Hello
I have a problem to connect as SYSDBA. I put
Connect SYS / Oracle SYSDBA
and the message says insufficient privileges.
If I try to connect with any other user without SYSDBA, it works.
Does anyone have any suggestions ??
Sincerely
Insufficient privileges Connect SYS / Oracle AS SYSDBA
-
- Moderador
- Posts: 2016
- Joined: Wed, 12 Jan 2005 3:25 pm
- Location: Araraquara - SP
Abraço,
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Brother, I do not know if I'm mistaken but ...
tried as follows?
Another thing, is the machine where the bank is located?
tried as follows?
sqlplus /nolog;
connect / as sysdba;
-
- Rank: DBA Sênior
- Posts: 372
- Joined: Tue, 24 Jan 2006 3:33 pm
- Location: Palmas - TO
- Contact:
oracle@oracleibm:~> oerr ORA 01031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary operating
// system privileges.
// When Trusted Oracle is configure in DBMS MAC, this error may occur
// if the user was granted the necessary privilege at a higher label
// than the current login.
// *Action: Ask the database administrator to perform the operation or grant
// the required privileges.
// For Trusted Oracle users getting this error although granted the
// the appropriate privilege at a higher label, ask the database
// administrator to regrant the privilege at the appropriate label.
oracle@oracleibm:~>
But before that prepares the bank for this: http://www.oracleutilities.com/OSUtil/orapwd.html
Gilberto
-
- Information
-
Who is online
Users browsing this forum: No registered users and 1 guest