- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: databases
Operating System - HP-UX
1748268
Members
3611
Online
108760
Solutions
Forums
Categories
Company
Local Language
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- 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
06-07-2004 10:41 PM
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2004 10:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2004 10:56 PM
06-07-2004 10:56 PM
Re: databases
hi,
Assuming the O.S. is unix
#
su â c oracle
Sun Microsystems Inc. SunOS 5.8 Generic February 2000
$
then type lsnrctl
LSNRCTL> start (To start the listener &
stop - To stop the listener)
then type svrmgrl
SVRMGR> connect internal
(After passing the statement you will get msg Connected)
Connected.
SVRMGR> startup (To startup the database &
shutdown immediate â To shutdown the database)
Regar
Assuming the O.S. is unix
#
su â c oracle
Sun Microsystems Inc. SunOS 5.8 Generic February 2000
$
then type lsnrctl
LSNRCTL> start (To start the listener &
stop - To stop the listener)
then type svrmgrl
SVRMGR> connect internal
(After passing the statement you will get msg Connected)
Connected.
SVRMGR> startup (To startup the database &
shutdown immediate â To shutdown the database)
Regar
I'll sleep when i am dead.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2004 11:01 PM
06-07-2004 11:01 PM
Re: databases
Our DBA does it this way:
# sqlplus /nologin
> connect internal;
> starup
If you have more than one database make sure you are connected to desired one by setting proper ENV variables.
Hope that helps.
Regards,
Imran where you on certification.. Are you comfortably while studing???? :))
# sqlplus /nologin
> connect internal;
> starup
If you have more than one database make sure you are connected to desired one by setting proper ENV variables.
Hope that helps.
Regards,
Imran where you on certification.. Are you comfortably while studing???? :))
You need to know a lot to actually know how little you know
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2004 11:20 PM
06-07-2004 11:20 PM
Re: databases
hi,
If you are considering automatic startup of your oracle database, you should consider the following:
Files of Interest:
==================
a. $ORACLE_HOME/bin/dbstart
Ensures a clean startup of database instance(s), even after system failure
b.$ORACLE_HOME/bin/dbshut
Ensures a clean shutdown for data base instances
c. /etc/oratab or /var/opt/oracle/oratab
Contains a field that specifies whether a particular database instance should be brought up/down at system startup/shutdown time. By specifying "Y" in this field, the "dbstart" and "dbshut" scripts bring this database instance up or down.
Relevant Files:
===============
a. /sbin/init.d/oracle
contains the main script for doing db startup and shutdown owned by root
b. /etc/rc.config.d/oracle
this file enables/disables automatic startup and shutdown of the databases owned by root
c. /sbin/rc1.d/K100oracle ->/sbin/init.d/oracle
this link tells the system when to execute the Oracle script with the 'stop' command in single user mode during system shutdown
d. /sbin/rc2.d/S990oracle ->/sbin/init.d/oracle
this link tells the system when to execute the Oracle script with the 'start' command in multi-user mode during system startup
Steps:
======
1. Create an executable script /sbin/init.d/oracle for the startup and shutdown of Oracle
Your script should attempt to start the database with the following command:
su - -c <$ORACLE_HOME>/bin/dbstart
Your script should attempt to shut the database with the following command:
su - -c <$ORACLE_HOME>/bin/dbshut
Make sure that the script is owned and executable only by the super user.
2. Create the file /etc/rc.config.d/oracle
This file should contain:
ORACLE_START=1
export ORACLE_START
3. Edit /etc/oratab
ORACLE_SID:ORACLE_HOME:Y|N
where Y or N indicates whether you want the dbstart and dbshut scripts to be run
4. Make /sbin/rc1.d/K100oracle a symbolic link to /sbin/init.d/oracle
5. Make /sbin/rc2.d/S990oracle a symbolic link to /sbin/init.d/oracle
hope this helps!
regards
Yogeeraj
If you are considering automatic startup of your oracle database, you should consider the following:
Files of Interest:
==================
a. $ORACLE_HOME/bin/dbstart
Ensures a clean startup of database instance(s), even after system failure
b.$ORACLE_HOME/bin/dbshut
Ensures a clean shutdown for data base instances
c. /etc/oratab or /var/opt/oracle/oratab
Contains a field that specifies whether a particular database instance should be brought up/down at system startup/shutdown time. By specifying "Y" in this field, the "dbstart" and "dbshut" scripts bring this database instance up or down.
Relevant Files:
===============
a. /sbin/init.d/oracle
contains the main script for doing db startup and shutdown owned by root
b. /etc/rc.config.d/oracle
this file enables/disables automatic startup and shutdown of the databases owned by root
c. /sbin/rc1.d/K100oracle ->/sbin/init.d/oracle
this link tells the system when to execute the Oracle script with the 'stop' command in single user mode during system shutdown
d. /sbin/rc2.d/S990oracle ->/sbin/init.d/oracle
this link tells the system when to execute the Oracle script with the 'start' command in multi-user mode during system startup
Steps:
======
1. Create an executable script /sbin/init.d/oracle for the startup and shutdown of Oracle
Your script should attempt to start the database with the following command:
su -
Your script should attempt to shut the database with the following command:
su -
Make sure that the script is owned and executable only by the super user.
2. Create the file /etc/rc.config.d/oracle
This file should contain:
ORACLE_START=1
export ORACLE_START
3. Edit /etc/oratab
ORACLE_SID:ORACLE_HOME:Y|N
where Y or N indicates whether you want the dbstart and dbshut scripts to be run
4. Make /sbin/rc1.d/K100oracle a symbolic link to /sbin/init.d/oracle
5. Make /sbin/rc2.d/S990oracle a symbolic link to /sbin/init.d/oracle
hope this helps!
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP