How do I collect VP Oracle data on an OpenVMS System?|
You can do this if you are licensed to do so and if the configuration file is set up properly.|
There are examples of this in Appendix B of the ViewPoint for OpenVMS Host User's Guide. In short, the VIEWPOINT.INI file in the VVP_ETC directory needs to be modified. Namely, the parameters to be added are as follows (in addition to optional parameters shown in Appendix B):
ORACLE: SERVICENAME 1 servicename
ORACLE: DATABASE 1 DB name
ORACLE: SID 1 sid
ORACLE: USERPATH 1 devicename:[path]
ORACLE: ORIGNODE 1 nodename
A separate Oracle collector can be added between an "if" and "endif" statement or can simply be combined into the original collector as a donor:
if $collector() = "your_oracle_collector_name" then
MODULELIST 1 ORACLE
if $collector() = "your_main_collector"
MODULELIST 1 VMS,ORACLE
Also, remember, from an Oracle-enabled account for the SID on which you want to collect data, you have to run the following SQL script:
To verify this, type the following from an Oracle-enabled account:
$ sqlplus vp/viewpoint
Also, check to make sure the sqlnet listener is running for the instance you are trying to connect to (via $show system).
If you get the following error messages in the log file then take the following actions:
%VPCOLLECT-E-BADORACLE, error in function "orlon" called by module DBSDATABASE
-DAC-I-MESSAGE, ORA-12203 TNS:unable to connect to destination
-DAC-I-TOKEN, username="VP" service="INSTANCE_NAME" sql=""
-DAC-I-DATETIMESTAMP, the error (rc=12203)occurred at DD-MM-YYYY:HH:MM:SS
Cause: Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.
Action: Verify that the service name you entered on the command line was correct. Ensure that the listener is running at the remote node and that the ADDRESS parameters specified in the TNSNAMES.ORA file are correct. Finally, check that all interchanges needed to make the connection are up and running.
The TNSNAMES.ORA file is in the [ORACLE.NETWORK.ADMIN] directory. The connection depends on a SQLNET connection to log into the ViewPoint Database using the alias "INSTANCE_NAME". It should have TNS in its process name ($show system).
After your configuration is set, restart the collector and recheck the log.
Cannot collect Oracle data via ViewPoint|
License information needs to be enabled for the collection of Oracle data. The ViewPoint initialization file needs to be configured peoperly.|