1) What is Netcool/Reporter?
The Netcool/Reporter is used to get the historical data for analysis and the real time information through a web based interface.
The Netcool/Reporter uses object server in one hand and database one the other to store the data of object server.
2) What are the different components of reporter?
• Netcool/Reporter server
• Netcool/Reporter clients
• Repository schema for the database
• Netcool/Reporter gateway (Optional)
• Data schema for the database
3) What are the supported platforms for reporter?
• Solaris 2.7, 2.8 and 2.9
• HP-UX 11.0 and 11i
• AIX 4.3 and 5L
• Windows NT 4.0 and 2000
4) What are the database engines which can be used for reporter?
• Oracle 8.0.x
• Oracle 8.1.6, 8.1.7
• Oracle 9i
• Sybase 11 and 12
• Microsoft SQL Server 7.0 and 2000
5) What are the supported browsers for reporter client?
• Internet explorer 5.5 and 6
• Netscape 6.2
6) What is the installation sequence for reporter?
- For Windows :-- first the apache web server should be installed.
Then the reporter installation can be started.
At the time of reporter installation, the option for installing jrun
can be selected.
- For Unix :-- just starting the reporter installation script will install the web-server ,jrun and the reporter server itself.
7) What are the configurations which are to be made before running reporter ?
- For windows :-- create database for reporter and repository database, configure system DSN, configure jrun server, start apache server, start jrun
- default server, start reporter server and then login to the reporter .
- For Unix :-- create database for reporter and repository database, run the repenv.sh script to set the environmental variables and start all the services from $REPORTERHOME/bin/startreporter
8) Where can I get the sql scripts for creating reporter database?
· For Windows :-- download the Reporter-gateway-sql-scripts-NT2K.zip, unzip it and then the scripts can be found inside Reporter-gateway-sql-scripts-NT2K\gateway-sql-scripts
· For Unix :-- download the reporter-gateway-sql-scripts.tar, extract it and then the scripts can be found inside the folder gateway-sql-scripts
9) Where can I get the sql scripts for creating repository database?
· For Windows :-- download the reporter-2_0-windows.zip, unzip it and then the scripts can be found inside \reporter-2_0-windows\windows\database
· For Unix :-- download the reporter-2_0-solaris.tar, extract it and then the scripts can be found inside the folder unix/database/
10) What is the location where reporter should be installed?
Document root of web server.
11) How the events are transferred from object server to the database?
Through the gateway
12) How the reporter gateway is installed?
Run the sol scripts for reporter database and that script creates the gateway which transfers the event from object server to reporter database.
13) For what purpose the reporter schema is used?
Reporter schema is used to store the event related information which is transferred from object server to the database through the gateways
14) For what purpose the repository schema is used?
Repository schema stores information about the Netcool/Reporter application and definition of the user defined reports.
15) How do I start the jrun management console? (For windows)
First start the jrun admin server, then start the jrun management console and login with userid admin, password admin.
16) What is the prerequisite of getting reporter logging screen?
Apache server should be started, jrun default server should be started, and reporter server should be started.
17) What smtp server name should be specified at the time of reporter installation?
Its better to provide the ip address of the smtp mail server which is available for the server on which reporter is running.
18) Can I drop reporter database and recreate it without uninstalling reporter?
Yes, that can be done but the entire object server related information which was stored in the reporter will be lost.
19) Can I drop repository database and recreate it without uninstalling reporter?
Yes, practically that can be done but it is not advisable because if some patches are already applied on the reporter version, then there might have been some modifications over the databse.When the database is recreated, then the modifications can not be performed because the patch is already applied on the reporter version.
20) What are the different types of tables in the reporter database?
4 Different types of tables for reporter database.
These are dynamic, audit, static, supporting.
21) What are the dynamic tables and how they are getting populated?
These tables are status, journal and details.
Populated directly from the corresponding tables in the object server
i.e. alerts.status, alerts,journal and alerts.details respectively.
So we should get all the data from alerts.status table of object server to the reporter_status table if the gateway is configured properly and started.
The journal table will be only populated for the events in which journal entries are added.
The details tables will be populated when we make the entry of details($*) at the end of the simnet.rules file.
22) What are the static tables and how they are getting populated?
These tables are names, groups, members, classes, conversions and severity.
Static tables are generated by the nco_update.sh script. They allow text to be included in the reports.
23) What are the audit tables and how they are getting populated?
These tables are severity, acknowledge, owneruid, ownergid.
Audits records are generated with the help of triggers when the associated fields are modified in the object server.
24) What are the supporting tables and how they are getting populated?
These tables are reference_date, time_periods.
These supporting tables are populated with the data at the time of creation of the database and used in parameterized reports.
25) I am not getting data in status table. What might be the possible reason?
Check the gateway log file for any possible errors in the gateway.
Check whether events are there in the object server.
If possible, clear all the events from the object server, start the gateway and then start the probe to populate the object server.
26) I am getting data in the status table but not getting any data in the
Audit tables. What might be the problem?
That means all the columns of status table is not getting populated.
Because the audit tables are getting populated by the triggers which act on some predefined columns of the status table. Check the gateway logfile for detailed error in the insert statement.
27) Is there any specific location where jrun should be installed?
No, there is no specific location for jrun but at the time of patch installation, it might ask for the jrun location.
28) Getting the error that reporter server is not able to connect to repository database. What might be the possible reason?
- For Unix :-- check the path is set and oracle/lib is included in the path. Also check the environmental variables.
- For Windows :-- go to programàadministrative toolsàODBC data source administrator and check for the system DSN entry tab. the proper DSN entry should be present there to connect to the repository database as well as reporter database (DSN names : rep_repository_two and reporter )
29) At the time of reporter installation I have put the name of the server and now I am not able to see reporter login screen.
Enter the entry of server name and corresponding ip address to the file of the client machine in the file
· For Windows :-- C:\WINDOWS\system32\drivers\etc\hosts
· For Unix :-- /etc/hosts
30) The reporter database is in different server and object server is in a different server, is it possible?
Yes.
31) The reporter database and the gateway are running in different servers, is it possible?
Yes.
32) The reporter database, the object server and the gateway are running in three different servers, is it possible?
Yes. For the above configuration, the database alias name should be specified at the gateway configuration file and the same entry should be there in the tnsnames.ora file of that server.
As a prerequisite, oracle client should be installed in the server where the gateway is running.
33) Where can we check the log file for apache server?
Inside apache/logs
34) Where can we check the log file for Jrun server?
Inside JRun/logs
35) Where can we check the log file for reporter server?
$REPORTERHOME\infospc\server\infolog
36) Where can we check the log files for gateways?
$OMNIHOME/logs
37) Which file contains the license information for reporter?
$REPORTER_HOME/infospc/server/licnese.conf
38) How to check the license information for the reporter server?
Run the license display tool $REPORTER_HOME/infospc/server/viewlicense
39) Where can I get all the entries which are made at the time of installation?
- For Unix :-- $REPORTERHOME/docs/FinalInstallInfo.txt
- For Windows :-- $REPORTERHOME/infospc/FinalInstallInfo.txt
40) What gateway should be use for windows server and mssql database?
We can use the nco_gate binary to start the gateway for windows server/mssql database.
41) What are the gateway configuration files and their location for the windows server and mssql database?
We can modify the gateway configuration file nco_gate.conf according to the database column names and put in the folder OMNIHOME\ini.
42) What gateway should be used for unix server and oracle database?
High performance oracle gateway should be used and the binary for the gateway is nco_g_oracle_9i_r2 which can be found in OMNIHOME/bin
43) What are the gateway configuration files and their location for the unix server and oracle database?
hp_oracle_gw.props, hp_oracle_gw.map, hp_oracle_gw.startup.cmd, hp_oracle_gw.thosts
in the folder $OMNIHOME/gates/hp_oracle_gw/
44) I am not able to get the server admin applet, what might be the reason?
Start the reporter admin server and then the server admin applet would be loaded fine.
45) What are the default users of reporter which gets created at the time of installation?
administrator, reporter and netcool are the default users and they are having the same password as the userid.
46) Why my L chart or Light Weight Chart Property Designer is not launched in Solaris8,9 and HPUX11i(head less exception)
There is a utility called Xvfb which emulates the X server that you need
to have running on the reporter host machine.
Generally It's in /usr/X11R6/bin or /usr/openwin/bin for Solaris
to start it ....#/usr/X11R6/bin/Xvfb :5.0 &
Need not set for for HPUX11i also.
Note : Need not set on AIX5L
you then need to edit the file $INFOHOME/server/infosrvorg
and change the line DISPLAY=hostname:0.0 to be DISPLAY=hostname:5.0
Then Graphic servlets should be fine
Note : GIF GENERATION
# X Server process is required for Gif Generation.
# X Server can be running on LOCAL machine or REMOTE machine.
# set DISPLAY to the machine where X Server runs on.
#
DISPLAY=172.22.23.172:0.0
export DISPLAY
47) In which directory all the reporter components created will be stored by the corresponding users?
/opt/reporter3.2/apache/htdocs/infospc/websqlbr/user
Or
$INFOHOME/websqlbr/user
48) How can I check whether my reporter FTP Server is running or not?
A) If you don’t type quit after you start the reporter, it means your ftp is running.
Though your ftp is running , Always Verify the Listener port is open or not
Using netstat –a | grep 2000 or what ever port you give.
B) To upload a file to your user directory using ftp in command line
# ftp 127.0.0.1 2000 will open your ftp session to upload any file into your ftp logged in user’s home directory
49) How to start reporter using script
Use
# cd $REPORTER/bin
#script reporter.out ./startreporter
Info : To Script the installation output.
User #script reporter.out ./setup.sh
50) what is difference between Pre-Process for Report and Post-Process for Report in the Report Designer.
If we set a stored Procedure as Pre-Process for Report , procedure is run before the reports get generated
If we set a stored Procedure as Post-Process for Report , procedure is run after reports get generated (Select table before delete). So, Previewing the report for the second time in this case gives the exact result of the report
51) Connect String for Sybase 12.5.x
While Installing Reporter2.0 GA or Reporter2.1 GA first time the connect string
Is :
e.g. : RABBIT.rep_repository_two
52) What connect string should I give after logging as Administrator to Reporter in case of Sybase.
In the User Administrator : For the Datasource
Give user reporter, pwd reporter and Connect string RABBIT.REPORTER
Otherwise, you will not be able to see reporter tables from Sybase REPORTER_STATUS
53) All Configuration parameter file for reporter2.0 is $INFOHOME/websqlbr/admin/spacesql.cfg
for Editing Mail server, AUDIT_LEVEL –user login, mail name etc…
54) Where can I set the debug level so that , more user login related logs are added to $INFOHOME/server/infolog/
$INFOHOME/configs/debuglog.xml
55) Why my oracle is not started and says that TNS-10256 message not found, problem with listener?
Possible reason is the corruption of mesg files which are located @
$ORACLE_HOME/rdbms/mesg
oraus.msg & oraus.msb
(sometimes the facility files too)
Eventhough the file size are the same like the working version it will not work
(usually after applying patch).
Just copy the executables from working version and it will work
Note: start the listener properly
56)how to run a report outside the reporter server i.e. using jsp tool at client side.
Run the report from the browser with the url:
http://
57) unable to recreate Table spaces.
Go to $ORACLE_HOME/dbs/
Delete table spaces and execute the sql script to recreate the table spaces.
Info : In $ORACLE_HOME/oradata/ - you have all log, dbf and control files.
58) How do I import expdat.dmp file to my oracle database à reporter database
Just “imp” in the $ORACLE_HOME/bin by putting the .dmp file in the same location. And follow the rest options.
59)
| Q) While starting oracle gateway some times it may stops immly.
|
60). I need a help with this error: ORA-12154: TNS: could not resolve service name.
Answer: The ORA-21254 is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases.
- Make sure that your listener is listening for the same service name that you are using.
- Your service name might have an alias, so check for global (world) entries and local entries. Check $ORACLE_HOME/network/admin/tnsnames.ora.
- Check your global_name setting with this SQL:
select * from global_name;
The query value should match your init.ora parms for db_name and db_domain, You can change the global_name with an alter database commend, as follows:
alter database rename global_name to xxx;
61). If in Sybase: server Space available in the log segment has fallen critically low in database 'master'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available. What should I do?
> dump tran master with no_log
> go
If that also don’t work and says that DUMP TRANSACTION for database 'master' could not truncate the log. Either extend the log using ALTER DATABASE ...
Then, do this:
1)>use master
go
select * from syslogshold
go
dbid reserved spid page xactid masterxactid name
xloid
------ ----------- ------ ----------- -------------- -------------- --------
----------------------- -----------
5 0 31 502763 0x000848f20002 0x000000000000
aip_db..temp_aip_orders 62
5 0 0 502763 0x000000000000 0x000000000000
$replication_truncation_point 0
2)> select "SPID"=spid from syslogshold where dbid = db_id("aip_db")
you will get the spid of the longest running process process .
To get the sqltext of the query :
dbcc traceon(3604)
go
dbcc sqltext(SPID) /*** that you have gotr from earlier query ***/
go
dbcc traceoff(3604)
go
you will get the text of the process , just check if you can affort to
kill that process as it might go for rollback.
3) to extend the master db transaction log by 4MB(2048 pages):
> alter database master
> go
4) Can't allocate space for object 'VI_FLDR_ITEM' in database 'master' because
'default' segment is full/has no free extents. If you ran out of space in
syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the
size of the segment.
62) I want to extend my master database in Sybase to 10MB more, how?
>alter database master on master=10
>go
Info: Staring Sybase 12.5.x :
Go to $SYBASE_ASE/install/RUN_
$SYBASE_ASE/install/RUN_
$SYBASE_ASE/install/RUN_
63) How to add a new column in Sybase12.5.3 e.g. to reporter.REPORTER_STATUS table:
>ALTER TABLE reporter.REPORTER_STATUS add TEST NUMERIC NULL
>go
64) How to set /change login and connect string for Reporter against Repository database.
$INFOHOME/util ./SetRepLogin
65)How to verify reporter’s connectivity with database.
$INFOHOME/bin/ ./ioraconn INFOHOME=”path” gives
SQL>connect repository_two/repository_two@
66) How does a Reporter connect to DB2 reporter or repository datasources.
In DB2 every database is created under the user db2inst1.
For repository database:
Username : db2inst1 pwd :
For Reporter database:
Username : db2inst1 pwd :
67) How do I import reporter’s vfgr_rep_tbls.dmp file to insert customer’s data and tables?
1) login as sqlplus reporter/reporter
2) Drop the reporter_status table; (drop table reporter_status)
3)DO
**************************************************************************************
bash-3.00$ imp
Import: Release 10.2.0.1.0 - Production on Tue Aug 21 07:42:57 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: reporter
Password:
Connected to: Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
Import file: expdat.dmp > vfgr_rep_tbls.dmp
Enter insert buffer size (minimum is 8192) 30720>
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
List contents of import file only (yes/no): no > no
Ignore create error due to object existence (yes/no): no > yes
Import grants (yes/no): yes > yes
Import table data (yes/no): yes >
Import entire export file (yes/no): no > yes
Imports all the tables and data from .dmp file .
**************************************************************************
68) What is the part name of the reporter2.0GA for Solaris available in Extreme leverage site.
C98VFEN
69) How Important is setting a LD_LIBRARY_PATH (LIBPATH and SHLIBPATH)
While setting oracle or any other database libraries locations, first set the path to $ORACLE_HOME/lib32 followed by $ORACLE_HOME/lib in line.
Because, reporter picks up the first library path set from LD_LIBRARY_PATH
70) How can I change the reporter configurations like mail id, httpd user and group, http ports .
$INFOHOME/websqlbr/admin/spacesql.cfg
$APACHEHOME/conf/httpd.conf ( for setting httpd user and group)
Info : While Configuring reporter on AIX 5L server, please make sure that you give existing user and group (of machine) for running httpd processes during the installation process in place of “nobody” and “nogroup”.
71) How can I view the pre-defined Sample reports (also called Canned reports) apart from the Form Based Reports?
Go to MyFolders link .
Select the Reporter 2.1 link in the My Folders section on the My Folders page.
3. The Reporter 2.1 folder is opened. This folder contains the following sub-folders:
• Sample Charts
• Sample Freeform Reports
• Sample Tabular Reports
• Supporting Files
Info: Canned reports generate pdf or html reports referring to the current date .
Info: Form Based Reports are just wrappers around the canned reports
72) How do I run a report job created from scheduler (normally as a netcool user) through command line when ever I wanted the same job to be run again ….?
Go to $INFOHOME/bin/ : Do >> ./runjob.sh
Info: To find the Job ID Go to $INFOHOME/websqlbr/user/netcool/job/
E.g: job3_1087.job , 1087 will be the job to run the job.
73) How can I update a column of a table:?
update reporter_status set LastOccurrence='23-AUG-07' where Summary like '%Invalid%';
74) I tried to login to MS-SQL server using sa and
| SetReplogin '' '' rep_repository_two |
‘’ ‘’ representing blank username and blank password with connect string rep_repository_two, which is the standard for WINNT authentication.
Info: Running infosrv_debug from the $INFOHOME/server folder will check whether reporter server is able to login to database successfully or not
No comments:
Post a Comment