Insufficient privileges Connect SYS / Oracle AS SYSDBA

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
rtot
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 5
Joined: Thu, 09 Aug 2007 5:27 pm
Location: São Paulo - sp

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
Trevisolli
Moderador
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

Brother, I do not know if I'm mistaken but ...
tried as follows?

Select all

 
  sqlplus /nolog; 
  connect / as sysdba; 
Another thing, is the machine where the bank is located?
rtot
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 5
Joined: Thu, 09 Aug 2007 5:27 pm
Location: São Paulo - sp

Thanks, for answering my question.

The command did not work, in case, I'm running on the machine where the database is installed, the bank is Oracle 10g
gilbertoca
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 372
Joined: Tue, 24 Jan 2006 3:33 pm
Location: Palmas - TO
Contact:

Select all

 
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:~>     
Give SYSDBA permission to the Oracle user.
But before that prepares the bank for this: http://www.oracleutilities.com/OSUtil/orapwd.html

Gilberto
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest