Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORACLE ERROR ORA-00205
dtiorleans wrote in message <01bd45c4$8ee327c0$68c9098e_at_internetpublic>...
>On a Dec-Server running on OSF V3,
>Thie error occurs when the oracle instance
>is scheluded by then cron service.
>Howewer, when i start the instance manually,
>there is no error !!!
Because when you start it manually the environment variables for Oracle (e.g. ORACLE_HOME, ORACLE_SID etc.) are set correctly, while a cron does not run the .profile of the userid and thus none of the Oracle environment variables are set.
The shell script should look something like this for a cron job:
-- #!/bin/sh # run .profile to setup envirorment . $HOME/.profile # startup database svrmgr23 << EOF connect internal; startup; exit; EOF -- regards, BillyReceived on Mon Mar 02 1998 - 00:00:00 CST