Re: Error auto starting ORACLE during sys boot (277 Views)
Reply
Frequent Advisor
Z.K.
Posts: 44
Registered: ‎09-10-2006
Message 1 of 8 (277 Views)

Error auto starting ORACLE during sys boot

Hello everybody.

We have an Alpha Ds25,operation system is OpenVMS8.2, Oracle9i installed.
I want the system start Oracle automatically while booting up. So I add something into SYSTARTUP_VMS.COM as follows.
"RUN SYS$SYSTEM:LOGINOUT.EXE /UIC=[account with DBA privilege] /PRIV=ALL -
/INPUT=ORACLE_START.COM -
/OUTPUT=ORACLE_START.LOG -
/ERR=..."

oracle_start.com (Tested)
"
$ @$1$dga1:[oracle]orauser SID
$sqlplus / as sysdba
set echo on
spool LOG_DIR:startup_SID.log
startup
exit
$ lsnrctl start
$ exit
"

But I found Oracle not started after rebooting the system, And found the message in the log file as follows:
"ORACLE environment setup NOT successful.
The ORACLE environment must first be established by the
Database Administrator. This can be done by executing
ORAUSER.COM from an account which has DBA privileges."

Anything I have done wrong?
What else should I do?
Please use plain text.
Honored Contributor
Hein van den Heuvel
Posts: 6,585
Registered: ‎05-19-2003
Message 2 of 8 (277 Views)

Re: Error auto starting ORACLE during sys boot

>> Anything I have done wrong?

Besides posting an OpenVMS question in the Tru64 forum? ;-)

>> ORACLE environment setup NOT successful.

It probably misses ORACLE_SID and such.
Instead of the oracle_start, try a command file whcih simply does SHOW LOG ORACL*, SHOW PROC/PRIV, SHOW PROC/QUO. See if you think if the result is good enough to start Oracle.

By using the RUN/UIC you create a DETACHED process which does NOT use the standard login process. It does NOT run LOGIN.COM
At the very least you need to add /AUTHORIZE to make it pick up the SYSUAF setting for the oracle user.

>> What else should I do?

Why not just submit a BATCH JOB to start Oracle from a known to be working Oracle username. So much easier to debug / check / manage.

Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting
Please use plain text.
Frequent Advisor
Z.K.
Posts: 44
Registered: ‎09-10-2006
Message 3 of 8 (277 Views)

Re: Error auto starting ORACLE during sys boot

>> Anything I have done wrong?
Besides posting an OpenVMS question in the Tru64 forum? ;-)

I found no "database" category in OpenVMS forum, so... ;-)

I'll try your suggestions.
Thanks in advance!
Please use plain text.
Frequent Advisor
Z.K.
Posts: 44
Registered: ‎09-10-2006
Message 4 of 8 (277 Views)

Re: Error auto starting ORACLE during sys boot

I changed the commands in systartup_vms.com to
"$ SUBMIT $1$DGA1:[ORACLE]oracle_start.com -
$ /USER=ORACLE9 /LOG=$1$DGA1:[ORACLE] /NAME=ORACLE_start /KEEP -
$ /NOPRINT /QUEUE=SYS$BATCH"
Still no use.

Please use plain text.
Frequent Advisor
Z.K.
Posts: 44
Registered: ‎09-10-2006
Message 5 of 8 (277 Views)

Re: Error auto starting ORACLE during sys boot

I couldn't even find a log file in the specified directory.
Please use plain text.
Honored Contributor
Hein van den Heuvel
Posts: 6,585
Registered: ‎05-19-2003
Message 6 of 8 (277 Views)

Re: Error auto starting ORACLE during sys boot

>> I found no "database" category in OpenVMS forum, so... ;-)


Right, we failed to get that.
But your question is much more OpenVMS dependent than Oracle dependent and really belongs there. If we don't resolve this now, then we can ask a moderaotr to move, or perhpas re-post with the details learned in this exchange.
It will get better exposure there

>> $ SUBMIT $1$DGA1:[ORACLE]oracle_start.com -
$ /USER=ORACLE9 /LOG=$1$DGA1:[ORACLE] /NAME=ORACLE_start /KEEP -
$ /NOPRINT /QUEUE=SYS$BATCH"

Do NOT specify the log dev/disk for first tries. Just let the defalt log be created in hte SYS$LOGIN for the usename specified.
It will have the name of the command file.

You do NOT normally specify /NAME

You do NOT need to specify SYS$BATCH

Do specify /NOPRINT, as you did. It implies /KEEP

Optionally add /NOTI to hear/see it run ?
(if a session with ORACLE9 is looged on)

>> I couldn't even find a log file in the specified directory.

That's critical. Resolve that first.
You may nee ACCOUN/FULL/SINCE=... to get detail ont the batch job failure
Can the Oracle9 user read the command file?

Hth,
Hein.


Please use plain text.
Frequent Advisor
Z.K.
Posts: 44
Registered: ‎09-10-2006
Message 7 of 8 (277 Views)

Re: Error auto starting ORACLE during sys boot

Hi Hein.
The command file "oracle_start.com" works(logged in as user Oracle9).
I'll check the batch queue job failure infomation next monday.

Thanks again, have a nice weekend!
Please use plain text.
Frequent Advisor
Z.K.
Posts: 44
Registered: ‎09-10-2006
Message 8 of 8 (277 Views)

Re: Error auto starting ORACLE during sys boot

Sorry Hein.
>>"$ SUBMIT $1$DGA1:[ORACLE]oracle_start.com -
$ /USER=ORACLE9 /LOG=$1$DGA1:[ORACLE] /NAME=ORACLE_start /KEEP -
$ /NOPRINT /QUEUE=SYS$BATCH"
I put extra "$" at the begining of each line,should be
"$ SUBMIT $1$DGA1:[ORACLE]oracle_start.com -
/USER=ORACLE9 /LOG=$1$DGA1:[ORACLE] /NAME=ORACLE_start /KEEP -
/NOPRINT /QUEUE=SYS$BATCH".
A careless mistake.
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation