how to start up oralce instance manually for oralce8.1.7 on HP-UX?

[xie kexian]

After successful installation, I use dbassist to create a database, and then I want to start up this database manually, how can I?
Thx.

[Alexander M. Ermes]

Hi there.
Logon as dba user ( mostly oracle ).
Set ORACLE_SID and ORACLE_HOME correctly.
set the environment correctly using oraenv for the different libraries.
start svrmgrl
login : connect / as sysdba

then enter : startup ( force )

To ring database down use :
shutdown ( immediate | abort )

Rgds
Alexander M. Ermes

[Michael Tully]

Hi,

You'll need to create a start/stop script. The below link has enough examples. You need to set variables in the script. To run it, just run as:

# /sbin/init.d/oracle start
# /sbin/init.d/oracle stop

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

HTH
Michael

[T G Manikandan · Accepted solution]

check this link

http://www.vi.unizh.ch/oracle8i_816/onlinedocu/doc/server.816/a76956/start.htm#5948


login as oracle user

check your ORACLE_SID

$ORACLE_SID=
$export ORACLE_SID
check whether you are starting up the right instance using
echo $ORACLE_SID

$svrmgrl
svrmgr>connect internal
connected
svrmgr>startup

Also you can

login as oracle
$svrmgrl
svrmgr>connectinternal

svrmgr>startup pfile=$ORACLE_HOME/dbs/init


ALso use shutdown or shutdown immediate to shutdown the database.
do not use shutdown abort.


Thanks

[Christian Gebhardt]

Hi

just remember:

The binary "svrmgrl" is no longer needed and not available in oracle version 9i.

So if you want to script start/stop-procedures and you plan to update to 9i in the next years then you have to use

sqlplus "/ as internal"
(don't forget the quotation)

This works also in 8.1.7

Christian

[Yogeeraj_1]

hi,

This is how it is recommended for the latest versions of Oracle.

Login as a user in the dba group, then execute the following:
============================================================
$ sqlplus /nolog

SQL*Plus: Release 9.0.1.3.0 - Production on Tue Sep 3 13:56:47 2002

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 571396368 bytes
Fixed Size 438544 bytes
Variable Size 419430400 bytes
Database Buffers 150994944 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.3.0 - 64bit Producti
on
With the Partitioning option
JServer Release 9.0.1.3.0 - Production
$ lsnrctl start

LSNRCTL for HPUX: Version 9.0.1.3.0 - Production on 03-SEP-2002 13:57:44

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Starting /d01/product/oracle/9.0.2/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 9.0.1.3.0 - Production
System parameter file is /d01/product/oracle/9.0.2/network/admin/listener.ora
Log messages written to /d01/product/oracle/9.0.2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver.db.mu)(PORT=1521))
)

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 9.0.1.3.0 - Production
Start Date 03-SEP-2002 13:57:44
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /d01/product/oracle/9.0.2/network/admin/listener.ora
Listener Log File /d01/product/oracle/9.0.2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver.db.mu)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "iasdb.myserver.db.mu" has 1 instance(s).
Instance "iasdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$
============================================================

hope this helps!
Best Regards
Yogeeraj