Oracle Database Discussions

Please check your ORACLE_HOME variable, if it look like here:
C:\oracle\ora10\
try to remove the ending backslash
C:\oracle\ora10

Next please try to setup TNS_ADMIN variable to location in which you have tnsnames.ora file

Best Regards
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

Solution:
IF you have error like:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
or
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
ORACLE_HOME=/oracle_path/client

NOT
LD_LIBRARY_PATH=/oracle_path/client/lib/ <-- WRONG !!!
ORACLE_HOME=/oracle_path/client/
Remember without slash ('/') at the end !!!!!!
Chmielu

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.

Thanks.

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)

Best regards

Thanks a lot, ziarkowski! This was very helpful

excuse me,
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?

thanks!

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?

Grateful

In control panel, search UAC and turn it off.

Hi,
We had this issue on one of our 11.1.0.6 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.

$sqlplus usr/password@dbalias


See if that helps.

Pranilesh Chand