Not able to connect as sysdba.

I am using sql developer in my machine, i tried to connect as sysdba by giving the following options

role : sysdba
connection type : tns
and appropriate network alias.

when i try this, i am getting Insufficient privileges error.

Also I tried using cmd prompt as : \ as sysdba;

but am getting the below error.
The procedure entry point longjmp could not be located in the dynamic link library orauts.dll

Please help me resolve this issue ASAP
sakthikumarAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>i am getting Insufficient privileges error

You need to confirm your OS user form the client has the necessary privs to connect remotely 'as sysdba'.

Check the docs and with your DBA to set this up.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dba006.htm#i1006740

>>Also I tried using cmd prompt as : \ as sysdba;

The correct is a forward slash:  / as sysdba

>>not be located in the dynamic link library orauts.dll

This appears to be related to the Oracle Instant Client.
0
 
sweetfa2Commented:
I suggest you reinstall oracle.  Either you have a corrupted file, or you installed a 32 bit installation on a 64 bit environment.  Either way a clean install is the best way to go here.
0
 
Docteur_ZCommented:
Do you have many ORACLE_HOME on your machine ?
If so you have to put your environment variables correctly (or use %ORACLE_HOME%\oui\HomeSelector\ohsel.exe which exists under SOME installation (9i) for windows)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.