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.




Oracle LazyDBA home page