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

ManualsBrandsHP ManualsSoftwareHP-UX Containers (SRP)

# ps -fR MKTPRD

UID PID PPID C STIME TTY TIME COMMAND

ora_mkt 6708 1 6 10:52:25 ? 0:00 ora_vktm_MKTPRD

ora_mkt 6737 1 3 10:52:26 ? 0:00 ora_d000_MKTPRD

ora_mkt 6719 1 6 10:52:26 ? 0:00 ora_dia0_MKTPRD

ora_mkt 6727 1 2 10:52:26 ? 0:00 ora_ckpt_MKTPRD

ora_mkt 6699 1 0 10:52:25 ? 0:00

/var/hpsrp/MKTPRD/u01/app/product/11.1.0/db_1/bin/tnslsnr LISTENER -

inherit

ora_mkt 6750 1 2 10:52:34 ? 0:00 ora_fbda_MKTPRD

ora_mkt 6729 1 2 10:52:26 ? 0:00 ora_smon_MKTPRD

ora_mkt 6735 1 6 10:52:26 ? 0:00 ora_mmnl_MKTPRD

ora_mkt 6712 1 2 10:52:26 ? 0:00 ora_dbrm_MKTPRD

ora_mkt 6714 1 3 10:52:26 ? 0:00 ora_psp0_MKTPRD

ora_mkt 6739 1 2 10:52:26 ? 0:00 ora_s000_MKTPRD

ora_mkt 6733 1 4 10:52:26 ? 0:00 ora_mmon_MKTPRD

ora_mkt 6721 1 2 10:52:26 ? 0:00 ora_mman_MKTPRD

ora_mkt 6773 1 3 10:52:45 ? 0:00 ora_q001_MKTPRD

ora_mkt 6731 1 2 10:52:26 ? 0:00 ora_reco_MKTPRD

ora_mkt 6748 1 2 10:52:34 ? 0:00 ora_smco_MKTPRD

ora_mkt 6768 1 4 10:52:37 ? 0:00 ora_w000_MKTPRD

ora_mkt 6771 1 4 10:52:45 ? 0:00 ora_q000_MKTPRD

ora_mkt 6754 1 3 10:52:34 ? 0:00 ora_qmnc_MKTPRD

ora_mkt 6710 1 6 10:52:26 ? 0:00 ora_diag_MKTPRD

root 6793 1 0 10:52:46 ? 0:00 /opt/ssh/sbin/sshd -f

/var/hpsrp

/MKTPRD/opt/ssh/sshd_config

ora_mkt 6723 1 2 10:52:26 ? 0:00 ora_dbw0_MKTPRD

ora_mkt 6706 1 3 10:52:25 ? 0:00 ora_pmon_MKTPRD

ora_mkt 6725 1 3 10:52:26 ? 0:00 ora_lgwr_MKTPRD

9. Verify remote SQL access:

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

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

DEDICATED)(SERVICE_NAME = MKTPRD)))"

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Apr 13 10:42:36 2010

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit

Production

With the Partitioning, OLAP, Data Mining and Real Application Testing

options

SQL> select * from emp

2 where empno=7902;

EMPNO ENAME JOB MGR HIREDATE SAL

COMM

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

DEPTNO

----------

7902 FORD ANALYST 7566 03-DEC-81 3000