1752773 Members
4851 Online
108789 Solutions
New Discussion юеВ

Re: ORACLE START UP

 
Ayanda
Occasional Contributor

ORACLE START UP

How do I start Orace 7 from
HPUX ?
If anyone is in Christ , he is a new creature the Old has gone , The new has come
7 REPLIES 7
Stefan Farrelly
Honored Contributor

Re: ORACLE START UP

su - oracle
dbstart

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

Im from Palmerston North, New Zealand, but somehow ended up in London...
Pierce Byrne_1
Frequent Advisor

Re: ORACLE START UP

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.
Ian Lochray
Respected Contributor

Re: ORACLE START UP

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.
Yogeeraj_1
Honored Contributor

Re: ORACLE START UP

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Volker Borowski
Honored Contributor

Re: ORACLE START UP

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
R. Allan Hicks
Trusted Contributor

Re: ORACLE START UP

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
"Only he who attempts the absurd is capable of achieving the impossible