Date - JUL 2009
Affected Product & Version - NVBU 8.2.1
Affected Module & Version – Oracle APM 6.0
OS Version - Linux
Application Information - N/A
Symptoms:
ORA-03114: not connected to ORACLE
Make sure you can log in to the database using sqlplus
First set up the environment properly.
. /usr/local/bin/oraenv
Note that the “.” with a space after it in front of the command is necessary. You may be prompted for the SID. It should be able to pull all the other information it needs out of the /etc/oratab file.
Then run sqlplus
sqlplus / as sysdba
If the instance isn’t started, or doesn’t exist, it will say “Connected to an idle instance.” You can issue the startup command and it should say “ORACLE instance started”, “ORA-01081: cannot start already-running…” or another error if the instance doesn’t exist.
Having verified the instance is started, double check the settings in the configuration with what is in /etc/oratab. These settings are case sensitive.
Note: When configuring the SID in the Oracle APM, the SID is usually needs to be in lower case characters.
