Unable to Login into SQLPLUS
395775May 30 2003 — edited Jun 9 2003I am running my Oracle Enterprise DB 9.2.0.1.0 on my Linux Red Hat 8.0 box.
The DB was installed successfully and I even can connect to the database I created via my Java program.
However, when I startup the SQLPLUS (via my "oracle" user account), I had tried logging in with IDs "sys", "system", "daniel" (ID I created using the Enterprise Manager Console). They all failed with message ORA-07217: Environment variables cannot be evaluated.
After checking the error message for its meaning, I found that the cause was that the GETENV returns a null pointer. Although, I know the meaning of the error message, I could not fix the problem. I had checked my environment variable. The include:
ORACLE_HOME=/home/oracle/OraHome1/
JAVA_HOME=/usr/java/j2sdk1.4.1_01/
PATH=$ORACLE_HOME/bin:$JAVA_HOME/bin:.
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip:$ORACLE_HOME/jdbc/lib/nls_charset12.zip:.
LD_LIBRARY_PATH=$ORACLE_HOME/lib/
My knowledge tells me that I had done it according to books.
Pls help. Thanks!