Oracle People:

I've got 5 oracle boxes and my scripts run great from crontab using:

sqlplus -s / << eof_1 >> $LogFile

before running the sql commands from the script. The script runs as oracle who is a member of the "dba" unix group who can just login direct using:

sqlplus /

HOWEVER ...
One box gives the following error after the oracle user(member of dba group) runs the:
sqlplus /

ERROR: ORA-01017: invalid username/password; logon denied.

This is very strange since all the boxes use the same unix oracle user: dba group system for logon. The initSID.ora is the same as the boxes that work !

bad box:
remote_os_authent = true
os_authent_prefix = ""

good box:
remote_os_authent = true
os_authent_prefix = ""

Both of these machines are oracle 7.3.


Thanx,
Roger