Reference Architecture: Consolidating Oracle Databases with Secure Resource Partitions in a Serviceguard Cluster Whitepaper

ster/MKTPRD/srp_monitor_script

ora_mkt MKTPRD 12419 1 0 14:15:33 ? 0:00

ora_psp0_MKTPRD

ora_mkt MKTPRD 12458 1 0 14:15:43 ? 0:00

ora_qmnc_MKTPRD

ora_mkt MKTPRD 12431 1 0 14:15:33 ? 0:00

ora_ckpt_MKTPRD

ora_mkt MKTPRD 12415 1 0 14:15:33 ? 0:00

ora_diag_MKTPRD

ora_mkt MKTPRD 12423 1 0 14:15:33 ? 0:00

ora_dia0_MKTPRD

ora_mkt MKTPRD 12429 1 0 14:15:33 ? 0:00

ora_lgwr_MKTPRD

ora_mkt MKTPRD 12413 1 0 14:15:33 ? 0:00

ora_vktm_MKTPRD

6. Verify which system the package is running on and remote SQL connectivity:

# ssh mktprd hostname

Password:

atcuxvm7

# echo "select * from emp where empno=7902;" | sqlplus -S

scott/tiger@"(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =

mktprd.rose.hp.com)(PORT = 1521))(CONNECT_DATA = (SERVER =

DEDICATED)(SERVICE_NAME = MKTPRD)))"

EMPNO ENAME JOB MGR HIREDATE SAL

COMM

---------- ---------- --------- ---------- --------- ---------- ---------

DEPTNO

----------

7902 FORD ANALYST 7566 03-DEC-81 3000

7. Move the package to backup node and verify connectivity:

# cmhaltpkg -v MKTPRD

Halting package MKTPRD

Successfully halted package MKTPRD

One or more packages or package instances have been halted.

The failover packages have AUTO_RUN disabled and no new instance can

start automatically. To allow automatic start, enable AUTO_RUN via

cmmodpkg -e <package_name>

# cmrunpkg -v -n atcuxvm8 MKTPRD

Running package MKTPRD on node atcuxvm8

Successfully started package MKTPRD on node atcuxvm8

cmrunpkg: All specified packages are running

# ssh mktprd hostname

Password:

atcuxvm8

# echo "select * from emp where empno=7902;" | sqlplus -S

scott/tiger@"(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =