Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle11gR2 RAC&DataGuard rman duplicate

899973Aug 7 2013 — edited Aug 13 2013

RAC 環境の data guard でちょっと悩んでいます。

data guard というより、rman と tnsnames.ora の関係あたりです。

結果的に実行したいことは、rman での接続の後の duplicate だけです。

（プライマリ・データベースの複製）

rman での接続がそもそも正常でなく、何が原因か分からない状態です。

詳しい方いれば教えていただきたいと思います。

よろしくお願い致します。

▼

実行時の画面出力：

standby 側 db が open の時：

export ORACLE_SID=HPYMUSIC1

rman target / auxiliary sys/passw@west1_DGMGRL

[oracle@tokyo1 ~]$ export ORACLE_SID=HPYMUSIC1

[oracle@tokyo1 ~]$ rman target / auxiliary sys/passw@west1_DGMGRL

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 16:48:32 2013

ターゲット・データベース: EAST (データベースID=3804390391)に接続されました

補助データベース: WEST (DBID=3187536000)に接続されました

rman target sys/passw@west1_DGMGRL auxiliary /

[oracle@tokyo1 ~]$ rman target sys/passw@west1_DGMGRL auxiliary /

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 16:50:25 2013

ターゲット・データベース: WEST (データベースID=3187536000)に接続されました

補助データベース: EAST (DBID=3804390391)に接続されました

rman target / auxiliary sys/passw@west1

[oracle@tokyo1 ~]$ rman target / auxiliary sys/passw@west1

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 16:51:53 2013

ターゲット・データベース: EAST (データベースID=3804390391)に接続されました

補助データベース: WEST (DBID=3187536000)に接続されました

▼ 上記全てにおいて、以下の状態にして、その後、duplicate をしたいというだけなのですが。。

補助データベース: WEST (DBID=3187536000)に接続されました(マウントされていません)

↓

↓ それが、以下のようにできない。。

↓

○ standby db が offline であるとします。

[root@osaka1 ~]# /u01/app/11.2.0/grid/bin/crsctl status resource -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Cluster Resources

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

ora.west.db

1 OFFLINE OFFLINE

2 ONLINE OFFLINE

○ startup nomount します。

ps -ef|egrep -i ora_

export ORACLE_SID=HPYMUSIC1

sqlplus / as sysdba

startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/pfile_for_standby.txt'

[oracle@osaka1 ~]$ ps -ef|egrep -i ora_

oracle 4487 4303 0 17:24 pts/1 00:00:00 egrep -i ora_

[oracle@osaka1 ~]$ export ORACLE_SID=HPYMUSIC1

[oracle@osaka1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 水 8月 7 17:24:35 2013

アイドル・インスタンスに接続しました。

SQL>

SQL> startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/pfile_for_standby.txt'

ORACLEインスタンスが起動しました。

Total System Global Area 814227456 bytes

Fixed Size 2217752 bytes

Variable Size 612370664 bytes

Database Buffers 192937984 bytes

Redo Buffers 6701056 bytes

SQL>

● db open の時に成功していたコマンドラインが失敗してしまう。

[oracle@tokyo1 ~]$ export ORACLE_SID=HPYMUSIC1

[oracle@tokyo1 ~]$ rman target / auxiliary sys/passw@west1_DGMGRL

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 17:27:36 2013

ターゲット・データベース: EAST (データベースID=3804390391)に接続されました

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: 内部Recovery Managerパッケージの初期化に失敗しました。

RMAN-04006: 補助データベースのエラー: ORA-12514: TNS: リスナーは接続記述子でリクエストされたサービスを現在認識していません

[oracle@tokyo1 ~]$ rman target sys/passw@west1_DGMGRL auxiliary /

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 17:29:54 2013

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: 内部Recovery Managerパッケージの初期化に失敗しました。

RMAN-04005: ターゲット・データベースからのエラー:

ORA-12514: TNS: リスナーは接続記述子でリクエストされたサービスを現在認識していません

[oracle@tokyo1 ~]$ rman target / auxiliary sys/passw@west1

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 17:30:07 2013

ターゲット・データベース: EAST (データベースID=3804390391)に接続されました

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: 内部Recovery Managerパッケージの初期化に失敗しました。

RMAN-04006: 補助データベースのエラー: ORA-12514: TNS: リスナーは接続記述子でリクエストされたサービスを現在認識していません

● db open から stop し、starup nomount pfile したとします。

[root@osaka1 ~]# /u01/app/11.2.0/grid/bin/crsctl status resource -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Cluster Resources

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

ora.west.db

1 ONLINE ONLINE osaka1 Open

2 ONLINE OFFLINE

[oracle@osaka1 ~]$ srvctl stop database -d west

[root@osaka1 ~]# /u01/app/11.2.0/grid/bin/crsctl status resource -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Cluster Resources

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

ora.west.db

1 OFFLINE OFFLINE Instance Shutdown

2 ONLINE OFFLINE

ps -ef|egrep -i ora_

export ORACLE_SID=HPYMUSIC1

sqlplus / as sysdba

startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/pfile_for_standby.txt'

[oracle@osaka1 ~]$ id

uid=54321(oracle) gid=54321(oinstall) 所属グループ=54321(oinstall),1101(oper),1201(asmdba),54322(dba)

[oracle@osaka1 ~]$ ps -ef|egrep -i ora_

oracle 6137 4303 0 17:44 pts/1 00:00:00 egrep -i ora_

[oracle@osaka1 ~]$ export ORACLE_SID=HPYMUSIC1

[oracle@osaka1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 水 8月 7 17:45:40 2013

アイドル・インスタンスに接続しました。

SQL> startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/pfile_for_standby.txt'

ORACLEインスタンスが起動しました。

Total System Global Area 814227456 bytes

Fixed Size 2217752 bytes

Variable Size 612370664 bytes

Database Buffers 192937984 bytes

Redo Buffers 6701056 bytes

SQL>

↓

↓ ▼ 結果、エラーになってしまう。

↓

[oracle@tokyo1 ~]$ export ORACLE_SID=HPYMUSIC1

[oracle@tokyo1 ~]$ rman target / auxiliary sys/passw@west1_DGMGRL

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 17:47:21 2013

ターゲット・データベース: EAST (データベースID=3804390391)に接続されました

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: 内部Recovery Managerパッケージの初期化に失敗しました。

RMAN-04006: 補助データベースのエラー: ORA-12514: TNS: リスナーは接続記述子でリクエストされたサービスを現在認識していません

[oracle@tokyo1 ~]$ rman target sys/passw@west1_DGMGRL auxiliary /

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 17:47:33 2013

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: 内部Recovery Managerパッケージの初期化に失敗しました。

RMAN-04005: ターゲット・データベースからのエラー:

ORA-12514: TNS: リスナーは接続記述子でリクエストされたサービスを現在認識していません

[oracle@tokyo1 ~]$ rman target / auxiliary sys/passw@west1

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 17:47:42 2013

ターゲット・データベース: EAST (データベースID=3804390391)に接続されました

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: 内部Recovery Managerパッケージの初期化に失敗しました。

RMAN-04006: 補助データベースのエラー: ORA-12514: TNS: リスナーは接続記述子でリクエストされたサービスを現在認識していません

● db open から stop し、srvctl start database -d west -o nomount したとします。

[root@osaka1 ~]# /u01/app/11.2.0/grid/bin/crsctl status resource -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Cluster Resources

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

ora.west.db

1 ONLINE ONLINE osaka1 Open

2 ONLINE OFFLINE

srvctl stop database -d west

[oracle@osaka1 ~]$ srvctl stop database -d west

[root@osaka1 ~]# /u01/app/11.2.0/grid/bin/crsctl status resource -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Cluster Resources

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

ora.west.db

1 OFFLINE OFFLINE Instance Shutdown

2 ONLINE OFFLINE

ps -ef|egrep -i ora_

export ORACLE_SID=HPYMUSIC1

srvctl start database -d west -o nomount

[oracle@osaka1 ~]$ ps -ef|egrep -i ora_

oracle 7521 4303 0 18:03 pts/1 00:00:00 egrep -i ora_

[oracle@osaka1 ~]$ export ORACLE_SID=HPYMUSIC1

[oracle@osaka1 ~]$ srvctl start database -d west -o nomount

[root@osaka1 ~]# /u01/app/11.2.0/grid/bin/crsctl status resource -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Cluster Resources

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

ora.west.db

1 ONLINE INTERMEDIATE osaka1 Dismounted

2 ONLINE OFFLINE

↓

↓ ▼ 結果、変わらずエラーになってしまう。

↓

[oracle@osaka1 ~]$ export ORACLE_SID=HPYMUSIC1

[oracle@osaka1 ~]$ rman target / auxiliary sys/passw@west1_DGMGRL

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 18:05:35 2013

ターゲット・データベース: WESTに接続されました(マウントされていません)

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: 内部Recovery Managerパッケージの初期化に失敗しました。

RMAN-04006: 補助データベースのエラー: ORA-12528: TNS:リスナー: 該当するインスタンスはすべて、新規接続をブロックしています

[oracle@osaka1 ~]$ rman target sys/passw@west1_DGMGRL auxiliary /

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 18:06:21 2013

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: 内部Recovery Managerパッケージの初期化に失敗しました。

RMAN-04005: ターゲット・データベースからのエラー:

ORA-12528: TNS:リスナー: 該当するインスタンスはすべて、新規接続をブロックしています

[oracle@osaka1 ~]$ rman target / auxiliary sys/passw@west1

Recovery Manager: Release 11.2.0.1.0 - Production on 水 8月 7 18:06:31 2013

ターゲット・データベース: WESTに接続されました(マウントされていません)

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: 内部Recovery Managerパッケージの初期化に失敗しました。

RMAN-04006: 補助データベースのエラー: ORA-12528: TNS:リスナー: 該当するインスタンスはすべて、新規接続をブロックしています

▼

tnsnames.ora は以下の状態で、tnsping はどの host からも通る状態。

east1_DGMGRL =

(DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.141)(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = east)

)

east1 =

(DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.141)(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = east)

(INSTANCE_NAME = HPYMUSIC1)

)

east2 =

(DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.142)(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = east)

(INSTANCE_NAME = HPYMUSIC2)

)

east =

(DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.141)(PORT = 1521)

)

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.142)(PORT = 1521)

)

(LOAD_BALANCE = yes)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = east)

)

west1_DGMGRL =

(DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.143)(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = west)

)

west1=

(DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.143)(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = west)

(INSTANCE_NAME=HPYMUSIC1)

)

west2=

(DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.144)(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = west)

(INSTANCE_NAME=HPYMUSIC2)

)

west=

(DESCRIPTION =

(ADDRESS_LIST=

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.143)(PORT = 1521)

)

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.144)(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = west)

)

LISTENERS_east=

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.141)(PORT = 1521)

)

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.142)(PORT = 1521)

)

east2_DGMGRL =

(DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.142)(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = east)

)

west2_DGMGRL =

(DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.144)(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = west)

)

LISTENERS_west=

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.143)(PORT = 1521)

)

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.144)(PORT = 1521)

)

▼

hosts は以下のような状態

[root@tokyo1 etc]# more hosts

192.168.56.101 tokyo1.oracle11g.jp tokyo1

192.168.56.102 tokyo2.oracle11g.jp tokyo2

192.168.56.103 osaka1.oracle11g.jp osaka1

192.168.56.104 osaka2.oracle11g.jp osaka2

192.168.56.141 tokyo1-vip.oracle11g.jp tokyo1-vip

192.168.56.142 tokyo2-vip.oracle11g.jp tokyo2-vip

192.168.56.143 osaka1-vip.oracle11g.jp osaka1-vip

192.168.56.144 osaka2-vip.oracle11g.jp osaka2-vip

192.168.56.201 scan.oracle11g.jp scan

192.168.56.202 scan.oracle11g.jp scan

192.168.56.203 scan.oracle11g.jp scan

192.168.56.254 dns1.oracle11g.jp

▼

構成は以下のような状態

PRIMARY STANDBY【 dr 】

Clusterware 11g R2 Grid Infrastructure (11.2.0.1) 11g R2 Grid Infrastructure (11.2.0.1)

Cluster Nodes tokyo1, tokyo2 (2-node RAC) osaka1, osaka2 (2-node RAC)

Cluster Name grid-cluster dr-grid-cluster（都合 primary と同じ名称になっている）

SCAN scan.oracle11g.jp dr-scan.oracle11g.jp（都合 primary と同じ名称になっている）

SCAN listener Host/port SCAN VIPs (port 1521) SCAN VIPs (port 1521)

VIPs tokyo1-vip, tokyo2-vip osaka1-vip, osaka2-vip

DB_UNIQUE_NAME east west

DB_NAME HPYMUSIC HPYMUSIC

DB Instances HPYMUSIC1, HPYMUSIC2 HPYMUSIC1, HPYMUSIC2

DB LISTENER HPYMUSIC_LISTENER HPYMUSIC_LISTENER

DB Listener Host/port tokyo1-vip, tokyo2-vip (port 1521) osaka1-vip, osaka2-vip (port 1521)

DB STORAGE ASM ASM

File Management OMF ( Oracle Managed Files ) OMF ( Oracle Managed Files )

ASM diskgroup for DB files DATA DATA

ASM Diskgroup for FRA FRA

Recovery Files

ORACLE_HOME /u01/app/oracle/product/11.2.0/dbhome_1 /u01/app/oracle/product/11.2.0/dbhome_1

11g R2 RAC version 11.2.0.1 11.2.0.1

OS Oracle Enterprise Linux 6 (64 bit) Oracle Enterprise Linux 6 (64 bit)

ARCHIVELOGモード有効有効

FORCE LOGGINGモード有効有効

▼

listener.ora は以下の状態

（配置ディレクトリは２箇所:

/u01/app/11.2.0/grid/network/admin/listener.ora

/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora ）

gridユーザでリスナー再起動：

[grid@tokyo1 ~]$ srvctl stop listener

[grid@tokyo1 ~]$ srvctl start listener

[grid@osaka1 ~]$ srvctl stop listener

[grid@osaka1 ~]$ srvctl start listener

LISTENER_west1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.143)(PORT = 1521)

(IP = FIRST)

)

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.103)(PORT = 1521)

(IP = FIRST)

)

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)

)

SID_LIST_LISTENER_west1 =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME=west)

(SID_NAME = HPYMUSIC1)

(ORACLE_HOME = $ORACLE_HOME)

)

LISTENER_east1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.141)(PORT = 1521)

(IP = FIRST)

)

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521)

(IP = FIRST)

)

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)

)

SID_LIST_LISTENER_east1 =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME=east)

(SID_NAME = HPYMUSIC1)

(ORACLE_HOME = $ORACLE_HOME)

)

LISTENER_west2 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.144)(PORT = 1521)

(IP = FIRST)

)

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.104)(PORT = 1521)

(IP = FIRST)

)

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)

)

SID_LIST_LISTENER_west2 =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME=west)

(SID_NAME = HPYMUSIC2)

(ORACLE_HOME = $ORACLE_HOME)

)

LISTENER_east2 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.142)(PORT = 1521)

(IP = FIRST)

)

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.102)(PORT = 1521)

(IP = FIRST)

)

(ADDRESS_LIST =

(

ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)

)

SID_LIST_LISTENER_east2 =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME=east)

(SID_NAME = HPYMUSIC2)

(ORACLE_HOME = $ORACLE_HOME)

)

Primary Node1

SID_LIST_HPYMUSIC_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=HPYMUSIC1)(GLOBAL_DBNAME=east)(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)))

Primary Node2

SID_LIST_HPYMUSIC_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=HPYMUSIC2)(GLOBAL_DBNAME=east)(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)))

Standby Node1

SID_LIST_HPYMUSIC_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=HPYMUSIC1)(GLOBAL_DBNAME=west)(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)))

Standby Node2

SID_LIST_HPYMUSIC_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=HPYMUSIC2)(GLOBAL_DBNAME=west)(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)))

▼

リソースの状態

[root@tokyo1 app]# /u01/app/11.2.0/grid/bin/crsctl status resource -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Local Resources

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

ora.DATA.dg

ONLINE ONLINE tokyo1

ora.FRA.dg

ONLINE ONLINE tokyo1

ora.LISTENER.lsnr

ONLINE ONLINE tokyo1

ora.asm

ONLINE ONLINE tokyo1 Started

ora.eons

ONLINE ONLINE tokyo1

ora.gsd

OFFLINE OFFLINE tokyo1

ora.net1.network

ONLINE ONLINE tokyo1

ora.ons

ONLINE ONLINE tokyo1

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

1 ONLINE OFFLINE

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE tokyo1

ora.LISTENER_SCAN3.lsnr

1 ONLINE OFFLINE

ora.east.db

1 ONLINE ONLINE tokyo1 Open

2 ONLINE OFFLINE

ora.oc4j

1 OFFLINE OFFLINE

ora.scan1.vip

1 ONLINE OFFLINE

ora.scan2.vip

1 ONLINE ONLINE tokyo1

ora.scan3.vip

1 ONLINE OFFLINE

ora.tokyo1.vip

1 ONLINE ONLINE tokyo1

ora.tokyo2.vip

1 ONLINE INTERMEDIATE tokyo1 FAILED OVER

[root@osaka1 app]# /u01/app/11.2.0/grid/bin/crsctl status resource -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Local Resources

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

ora.DATA.dg

ONLINE ONLINE osaka1

ora.FRA.dg

ONLINE ONLINE osaka1

ora.LISTENER.lsnr

ONLINE ONLINE osaka1

ora.asm

ONLINE ONLINE osaka1 Started

ora.eons

ONLINE ONLINE osaka1

ora.gsd

OFFLINE OFFLINE osaka1

ora.net1.network

ONLINE ONLINE osaka1

ora.ons

ONLINE ONLINE osaka1

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE osaka1

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE osaka1

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE osaka1

ora.oc4j

1 OFFLINE OFFLINE

ora.osaka1.vip

1 ONLINE ONLINE osaka1

ora.osaka2.vip

1 ONLINE INTERMEDIATE osaka1 FAILED OVER

ora.scan1.vip

1 ONLINE ONLINE osaka1

ora.scan2.vip

1 ONLINE ONLINE osaka1

ora.scan3.vip

1 ONLINE ONLINE osaka1

ora.west.db

1 ONLINE ONLINE osaka1 Open

2 ONLINE OFFLINE

[root@tokyo1 app]# /u01/app/11.2.0/grid/bin/crs_stat -t

名前型タ・. 状態ホスト

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

ora.DATA.dg ora....up.type ONLINE ONLINE tokyo1

ora.FRA.dg ora....up.type ONLINE ONLINE tokyo1

ora....ER.lsnr ora....er.type ONLINE ONLINE tokyo1

ora....N1.lsnr ora....er.type ONLINE OFFLINE

ora....N2.lsnr ora....er.type ONLINE ONLINE tokyo1

ora....N3.lsnr ora....er.type ONLINE OFFLINE

ora.asm ora.asm.type ONLINE ONLINE tokyo1

ora.east.db ora....se.type ONLINE ONLINE tokyo1

ora.eons ora.eons.type ONLINE ONLINE tokyo1

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE tokyo1

ora.oc4j ora.oc4j.type OFFLINE OFFLINE

ora.ons ora.ons.type ONLINE ONLINE tokyo1

ora.scan1.vip ora....ip.type ONLINE OFFLINE

ora.scan2.vip ora....ip.type ONLINE ONLINE tokyo1

ora.scan3.vip ora....ip.type ONLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE tokyo1

ora....O1.lsnr application ONLINE ONLINE tokyo1

ora.tokyo1.gsd application OFFLINE OFFLINE

ora.tokyo1.ons application ONLINE ONLINE tokyo1

ora.tokyo1.vip ora....t1.type ONLINE ONLINE tokyo1

ora....SM2.asm application ONLINE OFFLINE

ora....O2.lsnr application OFFLINE OFFLINE

ora.tokyo2.gsd application OFFLINE OFFLINE

ora.tokyo2.ons application ONLINE OFFLINE

ora.tokyo2.vip ora....t1.type ONLINE ONLINE tokyo1

[root@tokyo1 app]# ps -ef|egrep -i listener

grid 4111 1 0 15:22 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit

grid 6643 1 0 16:21 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit

root 6754 4658 0 16:24 pts/0 00:00:00 egrep -i listener

[root@osaka1 app]# /u01/app/11.2.0/grid/bin/crs_stat -t

名前型タ・. 状態ホスト

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

ora.DATA.dg ora....up.type ONLINE ONLINE osaka1

ora.FRA.dg ora....up.type ONLINE ONLINE osaka1

ora....ER.lsnr ora....er.type ONLINE ONLINE osaka1

ora....N1.lsnr ora....er.type ONLINE ONLINE osaka1

ora....N2.lsnr ora....er.type ONLINE ONLINE osaka1

ora....N3.lsnr ora....er.type ONLINE ONLINE osaka1

ora.asm ora.asm.type ONLINE ONLINE osaka1

ora.eons ora.eons.type ONLINE ONLINE osaka1

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE osaka1

ora.oc4j ora.oc4j.type OFFLINE OFFLINE

ora.ons ora.ons.type ONLINE ONLINE osaka1

ora....SM1.asm application ONLINE ONLINE osaka1

ora....A1.lsnr application ONLINE ONLINE osaka1

ora.osaka1.gsd application OFFLINE OFFLINE

ora.osaka1.ons application ONLINE ONLINE osaka1

ora.osaka1.vip ora....t1.type ONLINE ONLINE osaka1

ora....SM2.asm application ONLINE OFFLINE

ora....A2.lsnr application OFFLINE OFFLINE

ora.osaka2.gsd application OFFLINE OFFLINE

ora.osaka2.ons application ONLINE OFFLINE

ora.osaka2.vip ora....t1.type ONLINE ONLINE osaka1

ora.scan1.vip ora....ip.type ONLINE ONLINE osaka1

ora.scan2.vip ora....ip.type ONLINE ONLINE osaka1

ora.scan3.vip ora....ip.type ONLINE ONLINE osaka1

ora.west.db ora....se.type ONLINE ONLINE osaka1

[root@osaka1 app]# ps -ef|egrep -i listener

grid 4037 1 0 15:05 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit

grid 4072 1 0 15:06 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit

grid 4916 1 0 15:16 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit

grid 7253 1 0 16:22 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit

root 7317 6348 0 16:24 pts/0 00:00:00 egrep -i listener

▼

プロセスの起動状態：

[grid@tokyo1 ~]$ ps -ef|egrep -i ora_

oracle 4253 1 0 15:23 ? 00:00:01 ora_pmon_HPYMUSIC1

oracle 4255 1 0 15:23 ? 00:00:20 ora_vktm_HPYMUSIC1

oracle 4259 1 0 15:23 ? 00:00:02 ora_gen0_HPYMUSIC1

oracle 4261 1 0 15:23 ? 00:00:07 ora_diag_HPYMUSIC1

oracle 4263 1 0 15:23 ? 00:00:00 ora_dbrm_HPYMUSIC1

oracle 4265 1 0 15:23 ? 00:00:00 ora_ping_HPYMUSIC1

oracle 4267 1 0 15:23 ? 00:00:00 ora_psp0_HPYMUSIC1

oracle 4269 1 0 15:23 ? 00:00:00 ora_acms_HPYMUSIC1

oracle 4271 1 0 15:23 ? 00:00:39 ora_dia0_HPYMUSIC1

oracle 4273 1 0 15:23 ? 00:00:14 ora_lmon_HPYMUSIC1

oracle 4275 1 0 15:23 ? 00:00:13 ora_lmd0_HPYMUSIC1

oracle 4277 1 0 15:23 ? 00:00:27 ora_lms0_HPYMUSIC1

oracle 4281 1 0 15:23 ? 00:00:00 ora_rms0_HPYMUSIC1

oracle 4283 1 0 15:23 ? 00:00:00 ora_lmhb_HPYMUSIC1

oracle 4285 1 0 15:23 ? 00:00:00 ora_mman_HPYMUSIC1

oracle 4287 1 0 15:23 ? 00:00:00 ora_dbw0_HPYMUSIC1

oracle 4289 1 0 15:23 ? 00:00:01 ora_lgwr_HPYMUSIC1

oracle 4291 1 0 15:23 ? 00:00:03 ora_ckpt_HPYMUSIC1

oracle 4293 1 0 15:23 ? 00:00:01 ora_smon_HPYMUSIC1

oracle 4295 1 0 15:23 ? 00:00:00 ora_reco_HPYMUSIC1

oracle 4297 1 0 15:23 ? 00:00:00 ora_rbal_HPYMUSIC1

oracle 4299 1 0 15:23 ? 00:00:00 ora_asmb_HPYMUSIC1

oracle 4301 1 0 15:23 ? 00:00:02 ora_mmon_HPYMUSIC1

oracle 4303 1 0 15:23 ? 00:00:01 ora_mmnl_HPYMUSIC1

oracle 4305 1 0 15:23 ? 00:00:00 ora_d000_HPYMUSIC1

oracle 4309 1 0 15:23 ? 00:00:00 ora_s000_HPYMUSIC1

oracle 4314 1 0 15:23 ? 00:00:00 ora_mark_HPYMUSIC1

oracle 4316 1 0 15:23 ? 00:00:08 ora_lck0_HPYMUSIC1

oracle 4320 1 0 15:23 ? 00:00:00 ora_rsmn_HPYMUSIC1

oracle 4332 1 0 15:23 ? 00:00:00 ora_dmon_HPYMUSIC1

oracle 4424 1 0 15:24 ? 00:00:00 ora_insv_HPYMUSIC1

oracle 4436 1 0 15:24 ? 00:00:00 ora_arc0_HPYMUSIC1

oracle 4438 1 0 15:24 ? 00:00:00 ora_arc1_HPYMUSIC1

oracle 4440 1 0 15:24 ? 00:00:00 ora_arc2_HPYMUSIC1

oracle 4442 1 0 15:24 ? 00:00:00 ora_arc3_HPYMUSIC1

oracle 4444 1 0 15:24 ? 00:00:00 ora_arc4_HPYMUSIC1

oracle 4446 1 0 15:24 ? 00:00:00 ora_arc5_HPYMUSIC1

oracle 4448 1 0 15:24 ? 00:00:00 ora_arc6_HPYMUSIC1

oracle 4450 1 0 15:24 ? 00:00:00 ora_arc7_HPYMUSIC1

oracle 4480 1 0 15:25 ? 00:00:00 ora_gtx0_HPYMUSIC1

oracle 4483 1 0 15:25 ? 00:00:00 ora_rcbg_HPYMUSIC1

oracle 4489 1 0 15:25 ? 00:00:00 ora_qmnc_HPYMUSIC1

oracle 4547 1 0 15:26 ? 00:00:00 ora_q001_HPYMUSIC1

oracle 4657 1 0 15:26 ? 00:00:02 ora_cjq0_HPYMUSIC1

oracle 4887 1 0 15:29 ? 00:00:00 ora_q002_HPYMUSIC1

oracle 5019 1 0 15:32 ? 00:00:00 ora_smco_HPYMUSIC1

oracle 6678 1 0 16:22 ? 00:00:00 ora_w000_HPYMUSIC1

grid 6895 6206 0 16:29 pts/1 00:00:00 egrep -i ora_

[grid@osaka1 ~]$ ps -ef|egrep -i ora_

oracle 4476 1 0 15:10 ? 00:00:01 ora_pmon_HPYMUSIC1

oracle 4478 1 0 15:10 ? 00:00:25 ora_vktm_HPYMUSIC1

oracle 4482 1 0 15:10 ? 00:00:02 ora_gen0_HPYMUSIC1

oracle 4484 1 0 15:10 ? 00:00:09 ora_diag_HPYMUSIC1

oracle 4486 1 0 15:10 ? 00:00:00 ora_dbrm_HPYMUSIC1

oracle 4488 1 0 15:10 ? 00:00:00 ora_ping_HPYMUSIC1

oracle 4490 1 0 15:10 ? 00:00:00 ora_psp0_HPYMUSIC1

oracle 4492 1 0 15:10 ? 00:00:00 ora_acms_HPYMUSIC1

oracle 4494 1 1 15:10 ? 00:00:48 ora_dia0_HPYMUSIC1

oracle 4496 1 0 15:10 ? 00:00:17 ora_lmon_HPYMUSIC1

oracle 4498 1 0 15:10 ? 00:00:16 ora_lmd0_HPYMUSIC1

oracle 4501 1 0 15:10 ? 00:00:33 ora_lms0_HPYMUSIC1

oracle 4505 1 0 15:10 ? 00:00:00 ora_rms0_HPYMUSIC1

oracle 4507 1 0 15:10 ? 00:00:00 ora_lmhb_HPYMUSIC1

oracle 4509 1 0 15:10 ? 00:00:00 ora_mman_HPYMUSIC1

oracle 4511 1 0 15:10 ? 00:00:01 ora_dbw0_HPYMUSIC1

oracle 4513 1 0 15:10 ? 00:00:01 ora_lgwr_HPYMUSIC1

oracle 4515 1 0 15:10 ? 00:00:03 ora_ckpt_HPYMUSIC1

oracle 4517 1 0 15:10 ? 00:00:01 ora_smon_HPYMUSIC1

oracle 4519 1 0 15:10 ? 00:00:00 ora_reco_HPYMUSIC1

oracle 4521 1 0 15:10 ? 00:00:00 ora_rbal_HPYMUSIC1

oracle 4523 1 0 15:10 ? 00:00:00 ora_asmb_HPYMUSIC1

oracle 4525 1 0 15:10 ? 00:00:03 ora_mmon_HPYMUSIC1

oracle 4527 1 0 15:10 ? 00:00:01 ora_mmnl_HPYMUSIC1

oracle 4531 1 0 15:10 ? 00:00:00 ora_d000_HPYMUSIC1

oracle 4533 1 0 15:10 ? 00:00:00 ora_s000_HPYMUSIC1

oracle 4536 1 0 15:10 ? 00:00:00 ora_mark_HPYMUSIC1

oracle 4556 1 0 15:11 ? 00:00:12 ora_lck0_HPYMUSIC1

oracle 4558 1 0 15:11 ? 00:00:00 ora_rsmn_HPYMUSIC1

oracle 4562 1 0 15:11 ? 00:00:00 ora_dmon_HPYMUSIC1

oracle 4635 1 0 15:11 ? 00:00:00 ora_arc0_HPYMUSIC1

oracle 4637 1 0 15:11 ? 00:00:00 ora_insv_HPYMUSIC1

oracle 4639 1 0 15:11 ? 00:00:00 ora_arc1_HPYMUSIC1

oracle 4641 1 0 15:11 ? 00:00:00 ora_arc2_HPYMUSIC1

oracle 4643 1 0 15:11 ? 00:00:00 ora_arc3_HPYMUSIC1

oracle 4647 1 0 15:11 ? 00:00:00 ora_gtx0_HPYMUSIC1

oracle 4649 1 0 15:11 ? 00:00:00 ora_rcbg_HPYMUSIC1

oracle 4651 1 0 15:11 ? 00:00:00 ora_qmnc_HPYMUSIC1

oracle 4695 1 0 15:12 ? 00:00:00 ora_q001_HPYMUSIC1

oracle 4755 1 0 15:12 ? 00:00:03 ora_cjq0_HPYMUSIC1

oracle 4878 1 0 15:16 ? 00:00:00 ora_q002_HPYMUSIC1

oracle 4953 1 0 15:17 ? 00:00:00 ora_smco_HPYMUSIC1

oracle 7097 1 0 16:17 ? 00:00:00 ora_w000_HPYMUSIC1

oracle 7454 1 1 16:29 ? 00:00:00 ora_j000_HPYMUSIC1

oracle 7456 1 0 16:29 ? 00:00:00 ora_j001_HPYMUSIC1

grid 7458 6756 0 16:29 pts/1 00:00:00 egrep -i ora_

▼

gridユーザ関連プロセス:

[grid@tokyo1 ~]$ ps -ef |egrep -i grid

root 2650 1 3 15:20 ? 00:02:48 /u01/app/11.2.0/grid/bin/ohasd.bin reboot

grid 2791 1 0 15:20 ? 00:00:15 /u01/app/11.2.0/grid/bin/oraagent.bin

grid 2804 1 0 15:20 ? 00:00:00 /u01/app/11.2.0/grid/bin/gipcd.bin

grid 2809 1 0 15:20 ? 00:00:00 /u01/app/11.2.0/grid/bin/mdnsd.bin

grid 2823 1 0 15:20 ? 00:00:27 /u01/app/11.2.0/grid/bin/gpnpd.bin

root 2835 1 1 15:20 ? 00:01:02 /u01/app/11.2.0/grid/bin/cssdmonitor

root 2853 1 1 15:20 ? 00:01:02 /u01/app/11.2.0/grid/bin/cssdagent

grid 2883 1 5 15:20 ? 00:03:56 /u01/app/11.2.0/grid/bin/ocssd.bin

root 2887 1 0 15:20 ? 00:00:03 /u01/app/11.2.0/grid/bin/orarootagent.bin

grid 2900 1 0 15:20 ? 00:00:25 /u01/app/11.2.0/grid/bin/diskmon.bin -d -f

root 3487 1 0 15:20 ? 00:00:01 /u01/app/11.2.0/grid/bin/octssd.bin reboot

grid 3502 1 0 15:20 ? 00:00:42 /u01/app/11.2.0/grid/bin/evmd.bin

grid 3597 1 0 15:21 ? 00:00:00 asm_pmon_+ASM1

grid 3599 1 0 15:21 ? 00:00:21 asm_vktm_+ASM1

grid 3603 1 0 15:21 ? 00:00:00 asm_gen0_+ASM1

grid 3605 1 0 15:21 ? 00:00:07 asm_diag_+ASM1

grid 3607 1 0 15:21 ? 00:00:00 asm_ping_+ASM1

grid 3609 1 0 15:21 ? 00:00:00 asm_psp0_+ASM1

grid 3611 1 0 15:21 ? 00:00:40 asm_dia0_+ASM1

grid 3613 1 0 15:21 ? 00:00:16 asm_lmon_+ASM1

grid 3615 1 0 15:21 ? 00:00:11 asm_lmd0_+ASM1

grid 3621 1 0 15:21 ? 00:00:11 asm_lms0_+ASM1

grid 3625 1 0 15:21 ? 00:00:00 asm_lmhb_+ASM1

grid 3627 1 0 15:21 ? 00:00:00 asm_mman_+ASM1

grid 3629 1 0 15:21 ? 00:00:00 asm_dbw0_+ASM1

grid 3631 1 0 15:21 ? 00:00:00 asm_lgwr_+ASM1

grid 3633 1 0 15:21 ? 00:00:00 asm_ckpt_+ASM1

grid 3635 1 0 15:21 ? 00:00:00 asm_smon_+ASM1

grid 3637 1 0 15:21 ? 00:00:01 asm_rbal_+ASM1

grid 3639 1 0 15:21 ? 00:00:02 asm_gmon_+ASM1

grid 3641 1 0 15:21 ? 00:00:00 asm_mmon_+ASM1

grid 3643 1 0 15:21 ? 00:00:01 asm_mmnl_+ASM1

grid 3645 1 0 15:21 ? 00:00:19 /u01/app/11.2.0/grid/bin/oclskd.bin

grid 3649 1 0 15:21 ? 00:00:01 asm_lck0_+ASM1

root 3703 1 2 15:21 ? 00:01:55 /u01/app/11.2.0/grid/bin/crsd.bin reboot

grid 3733 1 0 15:21 ? 00:00:00 asm_asmb_+ASM1

grid 3735 1 0 15:21 ? 00:00:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

root 3756 1 0 15:21 ? 00:00:19 /u01/app/11.2.0/grid/bin/oclskd.bin

grid 3764 1 0 15:21 ? 00:00:00 oracle+ASM1_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

grid 3810 3502 0 15:21 ? 00:00:00 /u01/app/11.2.0/grid/bin/evmlogger.bin -o /u01/app/11.2.0/grid/evm/log/evmlogger.info -l /u01/app/11.2.0/grid/evm/log/evmlogger.log

grid 3854 1 0 15:21 ? 00:00:06 /u01/app/11.2.0/grid/bin/oraagent.bin

root 3860 1 0 15:21 ? 00:00:38 /u01/app/11.2.0/grid/bin/orarootagent.bin

grid 3984 1 0 15:22 ? 00:00:15 /u01/app/11.2.0/grid/jdk/jre//bin/java -Doracle.supercluster.cluster.server=eonsd -Djava.net.preferIPv4Stack=true -Djava.util.logging.config.file=/u01/app/11.2.0/grid/srvm/admin/logging.properties -classpath /u01/app/11.2.0/grid/jdk/jre//lib/rt.jar:/u01/app/11.2.0/grid/jlib/srvm.jar:/u01/app/11.2.0/grid/jlib/srvmhas.jar:/u01/app/11.2.0/grid/jlib/supercluster.jar:/u01/app/11.2.0/grid/jlib/supercluster-common.jar:/u01/app/11.2.0/grid/ons/lib/ons.jar oracle.supercluster.impl.cluster.EONSServerImpl

grid 4085 1 0 15:22 ? 00:00:00 /u01/app/11.2.0/grid/opmn/bin/ons -d

grid 4086 4085 0 15:22 ? 00:00:00 /u01/app/11.2.0/grid/opmn/bin/ons -d

grid 4111 1 0 15:22 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit

oracle 4131 1 0 15:22 ? 00:00:12 /u01/app/11.2.0/grid/bin/oraagent.bin

grid 4307 1 0 15:23 ? 00:00:00 oracle+ASM1_asmb_hpymusic1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 4311 1 0 15:23 ? 00:00:19 /u01/app/11.2.0/grid/bin/oclskd.bin

root 6205 4746 0 16:09 pts/1 00:00:00 su - grid

grid 6206 6205 0 16:09 pts/1 00:00:00 -bash

grid 6643 1 0 16:21 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit

grid 6947 6206 0 16:31 pts/1 00:00:00 ps -ef

grid 6948 6206 0 16:31 pts/1 00:00:00 egrep -i grid

[grid@osaka1 ~]$ ps -ef |egrep -i grid

root 2658 1 3 15:04 ? 00:03:21 /u01/app/11.2.0/grid/bin/ohasd.bin reboot

grid 2785 1 0 15:04 ? 00:00:19 /u01/app/11.2.0/grid/bin/oraagent.bin

grid 2798 1 0 15:04 ? 00:00:00 /u01/app/11.2.0/grid/bin/gipcd.bin

grid 2803 1 0 15:04 ? 00:00:00 /u01/app/11.2.0/grid/bin/mdnsd.bin

grid 2818 1 0 15:04 ? 00:00:32 /u01/app/11.2.0/grid/bin/gpnpd.bin

root 2831 1 1 15:04 ? 00:01:16 /u01/app/11.2.0/grid/bin/cssdmonitor

root 2848 1 1 15:04 ? 00:01:16 /u01/app/11.2.0/grid/bin/cssdagent

grid 2879 1 5 15:04 ? 00:04:48 /u01/app/11.2.0/grid/bin/ocssd.bin

root 2882 1 0 15:04 ? 00:00:04 /u01/app/11.2.0/grid/bin/orarootagent.bin

grid 2896 1 0 15:04 ? 00:00:31 /u01/app/11.2.0/grid/bin/diskmon.bin -d -f

root 3493 1 0 15:05 ? 00:00:01 /u01/app/11.2.0/grid/bin/octssd.bin reboot

grid 3508 1 1 15:05 ? 00:00:52 /u01/app/11.2.0/grid/bin/evmd.bin

grid 3595 1 0 15:05 ? 00:00:01 asm_pmon_+ASM1

grid 3597 1 0 15:05 ? 00:00:26 asm_vktm_+ASM1

grid 3601 1 0 15:05 ? 00:00:00 asm_gen0_+ASM1

grid 3603 1 0 15:05 ? 00:00:09 asm_diag_+ASM1

grid 3605 1 0 15:05 ? 00:00:00 asm_ping_+ASM1

grid 3607 1 0 15:05 ? 00:00:00 asm_psp0_+ASM1

grid 3609 1 0 15:05 ? 00:00:49 asm_dia0_+ASM1

grid 3611 1 0 15:05 ? 00:00:20 asm_lmon_+ASM1

grid 3613 1 0 15:05 ? 00:00:14 asm_lmd0_+ASM1

grid 3618 1 0 15:05 ? 00:00:13 asm_lms0_+ASM1

grid 3622 1 0 15:05 ? 00:00:00 asm_lmhb_+ASM1

grid 3624 1 0 15:05 ? 00:00:00 asm_mman_+ASM1

grid 3626 1 0 15:05 ? 00:00:00 asm_dbw0_+ASM1

grid 3628 1 0 15:05 ? 00:00:00 asm_lgwr_+ASM1

grid 3630 1 0 15:05 ? 00:00:00 asm_ckpt_+ASM1

grid 3632 1 0 15:05 ? 00:00:00 asm_smon_+ASM1

grid 3634 1 0 15:05 ? 00:00:01 asm_rbal_+ASM1

grid 3636 1 0 15:05 ? 00:00:03 asm_gmon_+ASM1

grid 3638 1 0 15:05 ? 00:00:00 asm_mmon_+ASM1

grid 3640 1 0 15:05 ? 00:00:01 asm_mmnl_+ASM1

grid 3642 1 0 15:05 ? 00:00:23 /u01/app/11.2.0/grid/bin/oclskd.bin

grid 3647 1 0 15:05 ? 00:00:01 asm_lck0_+ASM1

root 3695 1 2 15:05 ? 00:02:19 /u01/app/11.2.0/grid/bin/crsd.bin reboot

grid 3721 1 0 15:05 ? 00:00:00 asm_asmb_+ASM1

grid 3723 1 0 15:05 ? 00:00:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

root 3745 1 0 15:05 ? 00:00:23 /u01/app/11.2.0/grid/bin/oclskd.bin

grid 3754 1 0 15:05 ? 00:00:00 oracle+ASM1_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

grid 3800 3508 0 15:05 ? 00:00:00 /u01/app/11.2.0/grid/bin/evmlogger.bin -o /u01/app/11.2.0/grid/evm/log/evmlogger.info -l /u01/app/11.2.0/grid/evm/log/evmlogger.log

root 3845 1 1 15:05 ? 00:01:05 /u01/app/11.2.0/grid/bin/orarootagent.bin

grid 3851 1 0 15:05 ? 00:00:10 /u01/app/11.2.0/grid/bin/oraagent.bin

grid 3943 1 0 15:05 ? 00:00:00 /u01/app/11.2.0/grid/opmn/bin/ons -d

grid 3944 3943 0 15:05 ? 00:00:01 /u01/app/11.2.0/grid/opmn/bin/ons -d

grid 4003 1 0 15:05 ? 00:00:17 /u01/app/11.2.0/grid/jdk/jre//bin/java -Doracle.supercluster.cluster.server=eonsd -Djava.net.preferIPv4Stack=true -Djava.util.logging.config.file=/u01/app/11.2.0/grid/srvm/admin/logging.properties -classpath /u01/app/11.2.0/grid/jdk/jre//lib/rt.jar:/u01/app/11.2.0/grid/jlib/srvm.jar:/u01/app/11.2.0/grid/jlib/srvmhas.jar:/u01/app/11.2.0/grid/jlib/supercluster.jar:/u01/app/11.2.0/grid/jlib/supercluster-common.jar:/u01/app/11.2.0/grid/ons/lib/ons.jar oracle.supercluster.impl.cluster.EONSServerImpl

grid 4037 1 0 15:05 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit

grid 4072 1 0 15:06 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit

oracle 4355 1 0 15:10 ? 00:00:41 /u01/app/11.2.0/grid/bin/oraagent.bin

grid 452

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2013

Added on Aug 7 2013

#データベース, #データベース一般

1 comment

2,144 views