| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-01031
In the OEM Console, if you try to connect to a database, a
logon dialogue window appears. You have a choice of
connecting as 'Normal', 'Sysdba', or 'Sysoper'. You can
connect with the user internal as sysdba but NOT sys or system.
When you attempt this, you receive the error:
ORA-1031 insuffient privileges
Why? How do you set this to work?
Solution Description
Run svrmgr30 or svrmgrl (depending on version) and logon as internal and then issue the following:
grant sysdba to system;
(or any user that you want to have the sysdba role).
Then in OEM, for this user that you setup, you can have the connect as set to SYSDBA by doing the following:
The next time you attempt to connect from the OEM applications, the application will connect as the role you selected.
Note: Before the SYSDBA role can be granted to a user, the init.ora file must have the parameter "REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE". If you have to modify the init.ora to include this parameter, you will need to shutdown and restart your instance.
Explanation
By default the internal user has the sysdba privilege. The system and sys do not. Therefore, you need to grant the sysdba role to the user.
-----Original Message-----
From: John P Weatherman [mailto:asahoshi_at_infionline.net]
Sent: Monday, February 16, 2004 1:44 PM
To: oracle-l
Subject: ORA-01031
Hi all,
I have a 9.2.0.4 database on Solaris 2.9 that is being very unhappy with
remote connections as sysdba. The owner of the process (sqlplus for
testing, but IA also as I am ultimately trying to get things scheduled with
Enterprise Manager) is the oracle owner which is in the dba group. If I
"connect sys/<passwd> as sysdba" on the local machine, it works without any
problems. However, when I throw SQL*Net into the mix ("connect
sys/<passwd>@<sid> as sysdba") I am getting an ORA-1031. I have tried
recreating the passwd file and even "resetting" the sys password, just to
make sure the password file is "synchronized" with the actual password (per
a note on google).
Has anyone seen anything like this and have any suggestions?
TIA,
John P Weatherman
Oracle Database Administrator
Advance America
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |