Solved

Not able to connect as sysdba.

Posted on 2011-09-05
3
1,458 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:sakthikumar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 17

Expert Comment

by:sweetfa2
ID: 36485641
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
 
LVL 7

Expert Comment

by:Docteur_Z
ID: 36487850
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
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 36488341
>>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

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle encryption 12 61
pivot rows to columns 1 46
Oracle Distributed Transaction Lock Error ORA-01591 8 69
Need SQL Query to Find Foreign-keys Without Indexed Columns 4 34
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question