martes, 1 de septiembre de 2009

Oracle RAC Comands

VER ESTADO SERVICIOS DEL CLUSTER

$ crs_stat -t

Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE ct1b...ip01
ora....p01.gsd application ONLINE OFFLINE
ora....p01.ons application ONLINE OFFLINE
ora....p01.vip application ONLINE ONLINE ct1b...ip01
ora....02.lsnr application ONLINE ONLINE ct1b...ip02
ora....p02.gsd application ONLINE ONLINE ct1b...ip02
ora....p02.ons application ONLINE OFFLINE
ora....p02.vip application ONLINE ONLINE ct1b...ip02
ora.sirs.db application ONLINE ONLINE ct1b...ip02
ora....s1.inst application ONLINE ONLINE ct1b...ip01
ora....s2.inst application ONLINE ONLINE ct1b...ip02
ora...._srv.cs application OFFLINE OFFLINE
ora....rs1.srv application OFFLINE OFFLINE
ora....rs2.srv application OFFLINE OFFLINE

SUBIR SERVICIOS DEL NODEAPPS

$ srvctl start nodeapps -n ct1bosunsipip02
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE ct1b...ip01
ora....p01.gsd application ONLINE ONLINE ct1b...ip01
ora....p01.ons application ONLINE ONLINE ct1b...ip01
ora....p01.vip application ONLINE ONLINE ct1b...ip01
ora....02.lsnr application ONLINE ONLINE ct1b...ip02
ora....p02.gsd application ONLINE ONLINE ct1b...ip02
ora....p02.ons application ONLINE ONLINE ct1b...ip02
ora....p02.vip application ONLINE ONLINE ct1b...ip02
ora.sirs.db application ONLINE ONLINE ct1b...ip02
ora....s1.inst application ONLINE ONLINE ct1b...ip01
ora....s2.inst application ONLINE ONLINE ct1b...ip02
ora...._srv.cs application OFFLINE OFFLINE
ora....rs1.srv application OFFLINE OFFLINE
ora....rs2.srv application OFFLINE OFFLINE

SUBIR LISTENER CLUSTER

srvctl start listener -n ct1bosunsipep01

SUBIR TODOS LOS SERVICIOS

$ crs_start -all

bash-3.00$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE ct1b...ip01
ora....p01.gsd application ONLINE ONLINE ct1b...ip01
ora....p01.ons application ONLINE ONLINE ct1b...ip01
ora....p01.vip application ONLINE ONLINE ct1b...ip01
ora....02.lsnr application ONLINE ONLINE ct1b...ip02
ora....p02.gsd application ONLINE ONLINE ct1b...ip02
ora....p02.ons application ONLINE ONLINE ct1b...ip02
ora....p02.vip application ONLINE ONLINE ct1b...ip02
ora.sirs.db application ONLINE ONLINE ct1b...ip02
ora....s1.inst application ONLINE ONLINE ct1b...ip01
ora....s2.inst application ONLINE ONLINE ct1b...ip02
ora...._srv.cs application ONLINE ONLINE ct1b...ip02
ora....rs1.srv application ONLINE ONLINE ct1b...ip01
ora....rs2.srv application ONLINE ONLINE ct1b...ip02


# Start and stop cluster
srvctl start database -d db10g
srvctl stop database -d db10g

# Start and stop individual instance
srvctl start instance -d db10g -i db10g1
srvctl stop instance -d db10g -i db10g1

# Get status of whole database or specific instance
srvctl status database -d db10g
srvctl status instance -d db10g -i db10g1

# Get current database config
srvctl config database -d db10g

start_crs.sh
/app/oracle/crs/10.2.0.3/bin/crsctl start crs

stop_crs.sh
/app/oracle/crs/10.2.0.3/bin/crsctl stop crs

status_crs.sh
/app/oracle/crs/10.2.0.3/bin/crs_stat -t


- Dirección pública e interconnect.
$ORA_CRS_HOME/bin/oifcfg getif

- Para las direcciones virtuales
$ srvctl config nodeapps -n nombre_nodo -a

rac1-> srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is running on node: rac1
Listener is running on node: rac1
ONS daemon is running on node: rac1

rac1-> srvctl status nodeapps -n rac2
VIP is running on node: rac2
GSD is running on node: rac2
Listener is running on node: rac2
ONS daemon is running on node: rac2


rac1-> srvctl status asm -n rac1
ASM instance +ASM1 is running on node rac1.

rac1-> srvctl status asm -n rac2
ASM instance +ASM2 is running on node rac2.

rac1-> srvctl status database -d devdb
Instance devdb1 is running on node rac1
Instance devdb2 is running on node rac2

rac1-> srvctl status service -d devdb

Check ONS Daemon si esta corriendo

onsctl ping


ORACLE_HOME/bin/onsctl help

usage: ORACLE_HOME/bin/onsctl

start|stop|ping|reconfig|debug
start - Start opmn only.
stop - Stop ons daemon
ping - Test to see if ons daemon is running
debug - Display debug information for the ons
daemon
reconfig - Reload the ons configuration
help - Print a short syntax description
(this).

$ onsctl start
onsctl: ons started


lLSNRCTL> set help
The following operations are available after set
An asterisk (*) denotes a modifier or extended command:

password rawmode
displaymode trc_file
trc_directory trc_level
log_file log_directory
log_status current_listener
inbound_connect_timeout startup_waittime
save_config_on_stop dynamic_registration

LSNRCTL> show inbound_connect_timeout
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "inbound_connect_timeout" set to 60
The command completed successfully


srvctl status service -d sirspe Ver servicios

Verificar instalacion CRS

/app/oracle/crs/10.2.0.3/bin/ olsnodes -n

$ olsnodes -n
ct1bosunsipep01 0
ct1bosunsipep02 1


CHEQUEAR EL TIPO DE FAILOVER

select instance_name, host_name,
NULL AS failover_type,
NULL AS failover_method,
NULL AS failed_over
FROM v$instance
UNION
SELECT NULL, NULL, failover_type, failover_method, failed_over
FROM v$session
WHERE username = 'SYSTEM';

VER SERVICIO DEL CLUSTER EN CADA UNO DE LOS NODOS

srvctl status database -d sirspe

VER SERVICIOS DEL CLUSTER

crs_stat -t

SUBIR TODOS LOS SERVICIOS DEL CLUSTER

crs_start -all

BAJAR TODOS LOS SERVICIOS DEL CLUSTER

crs_stop -all


srvctl start nodeapps -n
srvctl start nodeapps -n
srvctl start asm -n
srvctl start asm -n
srvctl start database -d
srvctl start service -d -s

crs_stat -t

srvctl stop service -d -s
srvctl stop database -d
srvctl stop asm -n
srvctl stop asm -n
srvctl stop nodeapps -n
srvctl stop nodeapps -n


Shut down the Oracle Cluster Synchronization Services (CSS) daemon as the root user:

# /etc/init.d/init.cssd stop


Shut down all ASM instances on all nodes. To shut down an ASM instance, enter the following command where node is the name of the node where the ASM instance is running:

$ oracle_home/bin/srvctl stop asm -n node

Stop all node applications on all nodes. To stop node applications running on a node, enter the following command where node is the name of the node where the applications are running:

$ oracle_home/bin/srvctl stop nodeapps -n node