This content has been marked as final. Show 13 replies
Please check your ORACLE_HOME variable, if it look like here:
try to remove the ending backslash
Next please try to setup TNS_ADMIN variable to location in which you have tnsnames.ora file
Krystian Zieja / mob
Hello the oracle_home = D:\oracle\product\10.2.0\db_1
without the ending backslash
And tns_admin = D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
But the same problem
Your problem is described in bug#4684738 on MetaLink
Unfortunately it has no resolution yet
thanks, thats the same problem
IF you have error like:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0
Unable to proceed
pleas check first that you have
LD_LIBRARY_PATH=/oracle_path/client/lib/ <-- WRONG !!!
Remember without slash ('/') at the end !!!!!!
Thanks for your answer, but it didn't solve the problem. I think its more a question of wrong/incorrect rights on files or directories.
When i assigned the administrator rights to a user, everything works fine.
I am running into the same problem on a Windows 2000 machine. Has the above mentioned bug been fixed? I do not have access to MetaLink, and thought I could get a quicker response from here than our DB team.
Tried it, maybe it help you (found it on https://www.administrator.de/Zugriff_auf_OracleDB_(10i)_per_sql_plus_von_WTS_2003_(Servicepack_2).html)
Thanks a lot, ziarkowski! This was very helpful
i've added users at "create global object" right but i don't know what i've to do to apply this new settings...
i see my settings under "local settings" but not under "valid settings"
i operate like local admin
what can i do?
I am facing this very same problem with Oracle on Windows Vista. The with which I have installed the Oracle Software and setup the database is the computer's admin and this the same user from which I am trying to run SQLPLUS... any thoughts on how to resolve this?
In control panel, search UAC and turn it off.
We had this issue on one of our 126.96.36.199 database running on IBM AIX whereby no oracle user was trying to access the database. We followed the metalink note 417067.1 to resolve it.
For those who don't have access to metalink, this is the solution from the note that worked for us:
To implement the solution, please execute the following steps:
1. Manually change the privileges for the $ORACLE_HOME/oracore/zoneinfo directory and files.
chmod o+r oracore
chmod o+r oracore/zoneinfo/timezone.dat
or just type from $ORACLE_HOME directory:
2. SQL*Plus should be working now.
See if that helps.