Re: sqldba ORA-01031: insufficient privileges

One other thing that can help is to find out the permissions of the executables (these are set duing the root install of Oracle Installation). Most oracle binaries are setuid to oracle. If this is not set then sqldba cannot read files when executing in the user context other than oracle(presuming the owner of the oracle installation is the unix user "oracle")

In <Pine.SUN.3.91.950725213257.17802A-100000_at_mocha.eng.umd.edu> Teresa Narvaez <teresa_at_Glue.umd.edu> writes:
>
>Hello, I am trying to get into sqldba using my unix login name. I
 sourced
>a script which sets up all the environment variables and when I try
>to connect internal I get the following error:
>
>SQL*DBA: Release 7.1.3.0.0 - Production on Wed Jul 26 11:34:47 1995
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>Oracle7 Server Release 7.1.3.0.0 - Production Release
>PL/SQL Release 2.1.3.0.0 - Production
>
>SQLDBA> connect internal e c o n n
>Password:
>ORA-01031: insufficient privileges
>SQLDBA>
>
>
> Howerver, when I login as user oracle and source the same
>script mentioned above to set all the environment varialbes, I can
>connect to internal just fine and i am not asked to give a password.
>when i created my account in oracle, i granted myself dba privalages
 and
>I am in the dba group.
>
>Thanks for any help,
>-Teresa
>
>
>
>
>
>
>q
>
>
>
>
Received on Thu Jul 27 1995 - 00:00:00 CEST