-
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
-
check for two task parameter on the bad box and see its pointing to that database or somewhere else ?
There is something goofy goin on with your environment.
