This content has been marked as final. Show 14 replies
Do as below:
export ORACLE_HOME=<path where the database is installed>or
export ORACLE_SID=<Database SID>
In the .bash_profile file, set:
ORACLE_HOME=<path where the database is installed>; export ORACLE_HOMEand then execute the .bash_profile file
$ . .bash_profile
The result are :
Standard sqlplus command use on Linux server that Oracle database is installed on.
Thanks for your interest.
Zack, it is possible that you are running the wrong sqlplus. Just because you are sitting in a directory does NOT mean that the sqlplus you run is the copy in that directory. That is why I have twice asked you to use the which command to be certain.
However, I don;t think that is the problem. You might want to check a few other utilities, such as lsnrctl and dbca and see if the entire installation is broken.
Can you try "unset NLS_LANG" and check ?
Refer these MOS documents:
ORA-12705 - Common Reasons and How to Resolve Them [ID 158654.1]
ORA-12705: invalid or unknown NLS parameter value specified [ID 1142225.1]
Please consider closing the thread if you feel that your question has been answered by providing appropriate points.
Yes, had tried to unset NLS_LANG, can sqlplus but when perform startup, encountered:
ORA-12709: error while loading create database character set.
Database NLS_LANG has always being set to Simplified Chinese_China.ZHS16gbk.
Unfortunately i currently do not have access to MOS.
Edited by: Zack.L on Nov 17, 2012 6:43 PM
To those that might have the same problems.
Problems are the result of missing Oracle's files.
Do not know why it happened.
Copy back contents from another installation with the exception of dbs & network directory to resolve the problems.
Fix is only temporary, will have to do a complete installation later.