RE: ORA-01031: insufficient privileges when trying to connect to instance using "/" as oracle owner account

RE: ORA-01031: insufficient privileges when trying to connect to instance using "/" as oracle owner account

 

  

Oracle 10g doesn't require the OPS$ORACLE user. At least, none of my
databases require it.

-----Original Message-----
From: Terance W. Ebert
[mailto:oracledba-ezmlmshield-x22325001.[Email address protected]
Sent: Thursday, January 31, 2008 1:37 PM
To: LazyDBA Discussion
Subject: RE: ORA-01031: insufficient privileges when trying to connect to
instance using "/" as oracle owner account

Have you created the ops$oracle database user?

-----Original Message-----
From: Stephen Price [mailto:oracledba-ezmlmshield-x80537072.[Email address
protected]
Sent: Thursday, January 31, 2008 11:22 AM
To: LazyDBA Discussion
Subject: ORA-01031: insufficient privileges when trying to connect to
instance using "/" as oracle owner account

I have been through everything I can think of and I still cannot understand
why this particular LINUX install will not allow the oracle user to connect
using command (sqlplus / as sysdba).

uid=500(oracle) gid=500(oinstall)
groups=500(oinstall),501(dba),502(oper)

Oracle owns almost everything and oinstall is the group owner on just about
everything.

Oracle = 10.2.0.3 64-bit

[[Email Address Removed] ~]$ find . -user root -exec ls -al {} \; lrwxrwxrwx 1 root
root 22 Jan 30 14:44 ../app/oracle/product/10.2.0/db_1/rdbms/filemap ->
/opt/ORCLfmap/prot1_64
-rw-r----- 1 root oinstall 1534 Dec 22 2005
../app/oracle/product/10.2.0/db_1/rdbms/admin/externaljob.ora
-rwsr-s--- 1 root oinstall 18143 Jan 28 16:50
../app/oracle/product/10.2.0/db_1/bin/nmb
-r-sr-s--- 1 root oinstall 14931 Dec 20 2006
../app/oracle/product/10.2.0/db_1/bin/oradism
-rwsr-x--- 1 root oinstall 58383 Jan 30 14:55
../app/oracle/product/10.2.0/db_1/bin/extjob
-rwsr-s--- 1 root oinstall 16375 Jan 28 16:50
../app/oracle/product/10.2.0/db_1/bin/nmo

Linux traindb 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:14 EST 2007 x86_64
x86_64 x86_64 GNU/Linux

SQLNET.AUTHENTICATION_SERVICES= (NTS) is the only line in my
$ORACLE_HOME/network/admin/sqlnet.ora file

I can connect using (sqlplus [Email Address Removed] as sysdba <mailto:[Email Address Removed] as
sysdba> ) just fine, so SQL*NET works...

OS is Red Hat Enterprise Linux Server release 5 (Tikanga)

Any other ideas???




Stephen Price
Oracle Database Administrator
Compusearch Software Systems, Inc.





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page