topic Re: ORACLE START UP in Operating System - HP-UX

ORACLE START UP

Ayanda — Thu, 25 Jul 2002 09:37:11 GMT

How do I start Orace 7 from
HPUX ?

Re: ORACLE START UP

Stefan Farrelly — Thu, 25 Jul 2002 09:45:58 GMT

su - oracle
dbstart

If it doesnt start you may need to check the following environment variables are set;
ORACLE_HOME=
ORACLE_SID=

Re: ORACLE START UP

Pierce Byrne_1 — Thu, 25 Jul 2002 09:58:08 GMT

su - oracle
ORACLE_SID=YOURSID
export ORACLE_SID
svrmgrl
>connect internal;
>startup;
>exit;

This will start from the command line, you can script this to autostart if you wish.

Note - Oracle 7 is desupported.

Re: ORACLE START UP

Ian Lochray — Thu, 25 Jul 2002 10:10:31 GMT

If you use dbstart (which is not the method recommended by Oracle) you must have a "Y" entry for the appropriate SID in the oratab file.
Note also, that at later Oracle versions, svrmgrl is desupported. Oracle currently recommend using sqlplus as sysdba to start Oracle.

Re: ORACLE START UP

Yogeeraj_1 — Thu, 25 Jul 2002 12:28:33 GMT

hello,

this is how i do it!

1. in /sbin/init.d
file oracle
(see attachment)

2. Create links to look as below:
yd: /sbin>ll rc*/*oracle*
lrwxr-xr-x 1 root sys 19 Dec 16 2001 rc1.d/K100oracle -> /sbin/init.d/oracle
lrwxr-xr-x 1 root sys 19 Dec 16 2001 rc2.d/S900oracle -> /sbin/init.d/oracle

3. Config file
yd: /etc/rc.config.d>more oracle
#YD/CMT-16/12/2001
# ORACLE DATABASE configuration
#
# ORACLE_START_STOP : Set to 1 to start ORACLE DATABASE
#
ORACLE_START_STOP=1
yd: /etc/rc.config.d>

Hope this helps!

best regards
yogeeraj

Re: ORACLE START UP

Volker Borowski — Thu, 25 Jul 2002 14:54:14 GMT

Hi,
most of it said already!

Depending on the x in Version 7.x:

"svrmgrl" might not be available.
Use "sqldba" instead.

Hope this helps
Volker

Re: ORACLE START UP

R. Allan Hicks — Fri, 26 Jul 2002 11:03:38 GMT

As others have said...

dbstart is the recommended way to go.

If it doesn't work for after you've checked /etc/oratab, take a look at the dbstart script in $ORACLE_HOME/bin.

I found a bug in a version of 7.x where it didn't decode the server version correctly and attempted to start the instance like it was version 6 or something like that.

Sorry, it's been a long time since I've run 7.

Good Luck

Re: ORACLE START UP

harry d brown jr — Fri, 26 Jul 2002 11:18:42 GMT

This might help

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x96b70bce6f33d6118fff0090279cd0f9,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x316efd3f91d3d5118ff40090279cd0f9,00.html

or this
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x1e6f84534efbd5118ff40090279cd0f9,00.html

live free or die
harry