Information Technology Reference
In-Depth Information
Table25-2 Troubleshooting NetRanger (continued)
Symptom
Possible Problem
Suggested Actions
The following
error message is
displayed when
you try to run
sqlplus:
“~~~/oracle/prod
uct/7.3.2/bin/sqlp
lus: cannot open.”
The shell finds sqlplus, but it
cannot be executed. This can
occur when your $PATH
includes references to the
wrong versions of the Oracle
binaries. For example, you
have mounted the wrong
Oracle directories from a file
server. Therefore, you are
trying to execute HPUX
binaries on a SPARC system.
Ensure that the
$ORACLE_HOME directory
contains the proper binaries for
the platform you are running.
Refer to “Installing an Oracle
RDBMS” in
RDBMS Reference
.
sqlplus, sqlldr, or
sapx fail with the
following SID
error message:
“ERROR:
ORA-01034:
ORACLE not
available”
“ORA-07200:
slsid: oracle_sid
not set”
The ORACLE_SID
environment variable, which
identifies which database
instance to use, was not set
properly before starting
sqlplus.
Set the ORACLE_SID
environment variable to the
name of your database instance.
You can find out your database
instance name by running
ps -ef
| grep ora
. The string after the
last underbar in the returned
text is the database instance
name.
sqlplus, sqlldr, or
sapx fails with the
following libc
error message:
“libc.so.xxx:
can't do
something”
$ORACLE_HOME/lib is not
part of the
LD_LIBRARY_PATH
environment variable.
Add ORACLE_HOME/lib to
the LD_LIBRARY_PATH
environment variable. If you are
running either the Bourne or the
Korn shell, ensure that your
$HOME/.profile contains the
following entries:
LD_LIBRARY_PATH=$LD_LIB
RARY_PATH:$ORACLE_HOME/
lib
export LD_LIBRARAY_PATH
sqlplus, sqlldr, or
sapx fail with the
following TNS
error message:
“ERROR:
ORA-12154:
TNS: could not
resolve service
name”
Oracle cannot understand the
name specified in your connect
string.
Ensure that the Oracle file
tnsnames.ora resides in its
proper location (usually
$ORACLE_HOME/admin/net
work) and that it is properly
formatted. Then use the tnsping
utility to test sqlnet connectivity
to your remote database.
