Not able to connect as sysdba.

sakthikumar
sakthikumar used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
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.
Docteur_ZDatabase Engineer

Commented:
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)
Most Valuable Expert 2012
Distinguished Expert 2018
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial