Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORACLE ERROR ORA-00205

Re: ORACLE ERROR ORA-00205

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/03/02
Message-ID: <6dg5u8$6v9$1@hermes.is.co.za>#1/1

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,
Billy
Received on Mon Mar 02 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US