- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: how to start up oralce instance manually for o...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2002 09:22 PM
тАО09-01-2002 09:22 PM
Thx.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2002 09:32 PM
тАО09-01-2002 09:32 PM
Re: how to start up oralce instance manually for oralce8.1.7 on HP-UX?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2002 09:37 PM
тАО09-01-2002 09:37 PM
Re: how to start up oralce instance manually for oralce8.1.7 on HP-UX?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2002 09:42 PM
тАО09-01-2002 09:42 PM
Solutionhttp://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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-02-2002 09:49 PM
тАО09-02-2002 09:49 PM
Re: how to start up oralce instance manually for oralce8.1.7 on HP-UX?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-03-2002 01:57 AM
тАО09-03-2002 01:57 AM
Re: how to start up oralce instance manually for oralce8.1.7 on HP-UX?
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