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




Oracle LazyDBA home page