Jim Day <jday_at_fslso.com> schreef in berichtnieuws
jd2cdvk2hb3dhgpd0e2g63s8pp2hrepq3o_at_4ax.com...
| Thanks to everyone for the suggestions.
|
| I guess I didn't explain well enough, but I was trying to "su -
| oracle" in the vendor supplied OS shutdown script but it kept asking
| for a password. Well after further investigation, the su is working as
| everyone suggested and the script is switched to the oracle user. But
| when this OS shutdown script gets to the part that I modified (execute
| my script to shutdown a database) I get
|
| Enter password:
| ERROR:
| ORA-01031: insufficient privileges
|
| So, it appears that the SQLPLUS is wanting a password. As I mentioned
| in my initial post, the script I use to shutdown this database (while
| logged in as oracle) is as follows (this is not the entire script, but
| just the sqlplus part):
|
"su - oracle shutdownscript" spawns a process that runs as oracle *and* runs
the login scripts (because of the "-") /etc/profile and .profile of oracle
account. Do you set an Oracle environment ($ORACLE_HOME, $ORACLE_SID,
include $ORACLE_HOME/bin in $PATH etc...) in .profile? If not there is no
proper environment or an environment without a db (ORACLE_SID not set) or a
wrong database (other value of ORACLE_SID).
You can also set the variables in the "shutdownscript".
Received on Thu May 29 2003 - 15:59:01 CDT
