Host Rac Information
DBNAME=PRDDB
host01 information :
- hostname= HOST01
- oracle sid = PRDDB1
host02 information :
- hostname= HOST02
- oracle sid = PRDDB2
Check the Status of the PRDDB
There are several ways to check the status of the PRDDB. The srvctl utility shows the current configuration and status of the PRDDB database.
C:\>srvctl config database -d PRDDB
HOST01 PRDDB1 C:\oracle\product\10.2.0\db_1
HOST02 PRDDB2 C:\oracle\product\10.2.0\db_1
C:\>srvctl status database -d PRDDB
Instance PRDDB1 is running on node HOST01
Instance PRDDB2 is running on node HOST02
The V$ACTIVE_INSTANCES view can also display the current status of the instances.
C:\>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 20 16:58:37 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> SELECT * FROM v$active_instances;
INST_NUMBER INST_NAME
----------- ------------------------------------------------------------
1 HOST01:PRDDB1
2 HOST02:PRDDB2
SQL>
Finally, the GV$ allow you to display global information for the whole PRDDB.
-------------------------------------------------------------------------------------------------
Start/Stop All Instances with SRVCTL (All node)
Start/stop all the instances and their enabled services. I have included this step just for fun as a way to bring down all instances!
Start database
srvctl start nodeapps -n HOST01
srvctl start nodeapps -n HOST02
srvctl start asm -n HOST01
srvctl start asm -n HOST02
srvctl start database -d PRDDB
Stop database
srvctl stop database -d PRDDB
srvctl stop asm -n HOST01
srvctl stop asm -n HOST02
srvctl stop nodeapps -n HOST01
srvctl stop nodeapps -n HOST02
-------------------------------------------------------------------------------------------------
Starting the Oracle PRDDB 10g Environment (1 node)
The first step is to start the node applications (Virtual IP, GSD, TNS Listener, and ONS). When the node applications are successfully started, then bring up the ASM instance. Finally, bring up the Oracle instance (and related services) and the Enterprise Manager Database console.
Start Node PRDDB1:
srvctl start nodeapps -n HOST01
srvctl start asm -n HOST01
srvctl start instance -d PRDDB -i PRDDB1
Stopping the Oracle PRDDB 10g Environment (1 node)
The first step is to stop the Oracle instance. When the instance (and related services) is down, then bring down the ASM instance. Finally, shut down the node applications (Virtual IP, GSD, TNS Listener, and ONS).
Stop Node PRDDB1:
srvctl stop instance -d PRDDB -i PRDDB1
srvctl stop asm -n HOST01
srvctl stop nodeapps -n HOST01
-------------------------------------------------------------------------------------------------
Starting listener Oracle PRDDB 10g Environment (1 node)
If listener down or not start automatic.
Start Node PRDDB1:
lsnrctl start
-- or --
Right click mycom
--manage
--services and applicationàservices
--OracleOraDb10g_home1TNSListenerLISTENER_HOST01
--start
Stopping listener the Oracle PRDDB 10g Environment (1 node)
If want to stop listener.
Stop Node PRDDB1:
lsnrctl stop
-- or --
Right click mycom
--manageàservices and application
--services
--OracleOraDb10g_home1TNSListenerLISTENER_HOST01
--stop
-------------------------------------------------------------------------------------------------
Starting ASM Instance Oracle PRDDB 10g Environment (1 node)
If ASM instance down or not start automatic.
Start Node PRDDB1:
srvctl start asm -n HOST01
-- or --
Right click mycom
--manage
--services and application
--services
--OracleASMService+ASM1
--start
Stopping ASM Instance the Oracle PRDDB 10g Environment (1 node)
If want to stop ASM instance.
Stop Node PRDDB1:
srvctl stop asm -n HOST01
-- or --
Right click mycom
--manage
--services and application
--services
--OracleASMService+ASM1
--stop
-------------------------------------------------------------------------------------------------
Start/Stop Database control Oracle PRDDB 10g
Gui browser for control database
http://host01:1158/em
emctl start dbconsole
emctl stop dbconsole
-- or –
Right click mycom
--manage
--services and application
--services
--OracleDBConsoleHOST01
--start/stop
0 comments:
Post a Comment