Register * You must register for access to some support pages  FAQ Search   Support Main Menu  Entry #245: How do I collect VP Oracle data on an OpenVMS System? Question How do I collect VP Oracle data on an OpenVMS System? Answer 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 . . . endif -OR- if $collector() = "your_main_collector" MODULELIST 1 VMS,ORACLE . . . endif 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: VVP_ETC:CREATE_VP_USER.SQL 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. Symptoms Cannot collect Oracle data via ViewPoint Cause License information needs to be enabled for the collection of Oracle data. The ViewPoint initialization file needs to be configured peoperly.