unable to connect as sysdba on command prompt

[Former Member]

Hello All,

I'm unable to connect as sysdba to oracle from SQL Plus. The details are as follows:

-

---

E:\oracle\<SID>\920>sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Thu Jul 5 17:43:02 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn /as sysdba

ERROR:

ORA-01031: insufficient privileges

SQL> conn / as sysoper

ERROR:

ORA-01031: insufficient privileges

-

---

Please do guide. Even the Backups scheduled fail & give the same error.

Thank you.

Regards,

Anil.

[Former Member · Accepted solution]

Hi,

Provide the full permissions.

chmod 777 UID.

And then try.

Regarding back up fail also,

Provide the full 777 permissions to user and for all files backup and dbs etc.

then run.

Note: Points always encourage me to reply !!

[Former Member · Accepted solution]

hi,

The Operating system is Microsoft Windows Server 2003, not Unix.

Thank you.

[Former Member · Accepted solution]

Hello Anil,

Check once your System Domain name if you had changed it then it might be the cause..

I had once the same issue.

Regards,

Jafer

[Former Member · Accepted solution]

Thank you Jafer,

There was a domain change in the Network and the earlier domain was also functional, now when I reverted to the old domain name it worked fine.

Thank you all.

[Former Member]

Hi

Stop Oracleservice<sid> through services.msc then restart the service again and try sqlplus through cmd prompt ...

Murali

IBM

[Former Member]

Anil,

Did you try what i said earlier? I had faced the same issue, in Win. This gott solved!

[Former Member]

Hi Anil,

Login to OS with user <SID>adm and then try <b>sqlplus "/as sysdba"</b>

If you are getting same problem refer <b>SAP Note 480266</b> - Problems with the SYSDBA/SYSOPER/INTERNAL connect.

Regards,

Suraj

[Former Member]

Hi,

Try logging in by <sid>adm for OS user.

and try same command.

Regards,

Manomeet

[Former Member]

Anil,

First check the priviledges of the id which u hav used to login to the server, it should have ORA_DBA and ORA_OPER authorizations.

If u use <sid>adm there should not be any issues.

Also, for backups failing make sure your OPS$ users have been set up properly.

Award points if useful!

[Former Member]

Hi Anil,

First check if your user id used for accessing database is locked by somebody.

Also take the database as offline before you start off with the backup.

Might be you do not have all the authorization rights for the access to database.

Please check and give me details of your database and OS.

Thank you.

Regards,

Manomeet