Hello,
sc3.2 on Solaris 10 x86 and trying to create HA oracle - 11g on 2 nodes,
On Node2 :
clresource create -g oracleha-rg -t SUNW.oracle_listener -p LISTENER_NAME=LISTENER_ORCL -p ME=/oracle-pool/oracle/app/oracle/product/11.2.0/dbhome_1 -p Resource_dependencies=oracledisk-res,oracle-lh-res oraclelistener-res
Error,
node1:global - ORACLE_HOME /oracle-pool/oracle/app/oracle/product/11.2.0/dbhome_1 does not exist
node1:global - This resource depends on a HAStoragePlus resouce that is not online on this node. Ignoring validation errors.
oraclelistener-res: resource group failed to start on chosen node; it may end up failing over
clrs status
oracledisk-res node2 Online Online
node1 Offline Offline
oracle-lh-res node2 Online Online - LogicalHostname online.
node1 Offline Offline
oracledb-res node2 Offline Offline
node1 Offline Offline
oraclelistener-res node2 Start failed Faulted
node1 Offline Offline
clrg status
oracleha-rg node2 No Online faulted
node1 No Offline
oracledb-res resource was create as below,
clresource create -g oracleha-rg -t SUNW.oracle_server -p Connect_string=monitor/monitor -p ORACLE_SID=orcl -p ORACLE_HOME=/oracle-pool/oracle/app/oracle/product/11.2.0/dbhome_1 -p Alert_log_file=/oracle-pool/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log -p resource_dependencies=oracledisk-res oracledb-res
If I do clrs enable oracledb-res{
then it goes online
Resource: oracledb-res node2 Online Online
Resource: oracledb-res node1 Offline Offline
clrs enable oraclelistener-res
resource group failed to start on chosen node; it may end up failing over to other node(s)
/var/adm/messages
Feb 18 17:51:45 node2 Cluster.RGM.global.rgmd: [ID 314356 daemon.notice] resource oraclelistener-res enabled.
Feb 18 17:51:45 node2 Cluster.RGM.global.rgmd: [ID 529407 daemon.notice] resource group oracleha-rg state on node node2 change to RG_PENDING_ONLINE
Feb 18 17:51:45 node2 Cluster.RGM.global.rgmd: [ID 443746 daemon.notice] resource oraclelistener-res state on node node2 change to R_STARTING
Feb 18 17:51:45 node2 Cluster.RGM.global.rgmd: [ID 784560 daemon.notice] resource oraclelistener-res status on node node2 change to R_FM_UNKNOWN
Feb 18 17:51:45 node2 Cluster.RGM.global.rgmd: [ID 922363 daemon.notice] resource oraclelistener-res status msg on node node2 change to <Starting>
Feb 18 17:51:45 node2 Cluster.RGM.global.rgmd: [ID 224900 daemon.notice] launching method <bin/oracle_listener_start> for resource <oraclelistener-res>, resource group <oracleha-rg>, node <node2>, timeout <300> seconds
Feb 18 17:51:45 node2 Cluster.RGM.global.rgmd: [ID 863274 daemon.notice] 40 fe_rpc_command: cmd_type(enum):<1>:cmd=</opt/SUNWscor/oracle_listener/bin/oracle_listener_start>:tag=<oracleha-rg.oraclelistener-res.0>: Calling security_clnt_connect(..., host=<node2>, sec_type {0:WEAK, 1:STRONG, 2:DES} =<1>, ...)
Feb 18 17:51:46 node2 Cluster.RGM.global.rgmd: [ID 922363 daemon.notice] resource oraclelistener-res status msg on node node2 change to <>
Feb 18 17:51:50 node2 SC[SUNWscor.oracle_listener.start]:oracleha-rg:oraclelistener-res: [ID 847065 daemon.error] Failed to start listener LISTENER_ORCL.
Feb 18 17:51:51 node2 Cluster.RGM.global.rgmd: [ID 784560 daemon.notice] resource oraclelistener-res status on node node2 change to R_FM_FAULTED
Feb 18 17:51:51 node2 Cluster.RGM.global.rgmd: [ID 938318 daemon.error] Method <bin/oracle_listener_start> failed on resource <oraclelistener-res> in resource group <oracleha-rg> [exit code <1>, time used: 1% of timeout <300 seconds>]
Feb 18 17:51:51 node2 Cluster.RGM.global.rgmd: [ID 443746 daemon.notice] resource oraclelistener-res state on node node2 change to R_START_FAILED
Feb 18 17:51:51 node2 Cluster.RGM.global.rgmd: [ID 529407 daemon.notice] resource group oracleha-rg state on node node2 change to RG_PENDING_ON_STARTED
Feb 18 17:51:51 node2 Cluster.RGM.global.rgmd: [ID 529407 daemon.notice] resource group oracleha-rg state on node node2 change to RG_ONLINE
ps -fu oracle
UID PID PPID C STIME TTY TIME CMD
oracle 2291 1 0 17:48:30 ? 0:01 ora_vktm_orcl
oracle 2779 1 0 17:49:18 ? 0:00 ora_q001_orcl
oracle 2300 1 0 17:48:31 ? 0:00 ora_dbrm_orcl
oracle 1921 1920 0 17:47:14 ? 0:01 /usr/lib/ssh/sshd
oracle 2289 1 0 17:48:30 ? 0:01 ora_pmon_orcl
oracle 2296 1 0 17:48:30 ? 0:00 ora_gen0_orcl
oracle 2302 1 0 17:48:31 ? 0:01 ora_psp0_orcl
oracle 2785 1 0 17:49:19 ? 0:01 ora_cjq0_orcl
oracle 3488 1 0 17:54:58 ? 0:00 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 3286 1 0 17:54:22 ? 0:00 ora_smco_orcl
oracle 1992 1921 0 17:47:17 pts/2 0:00 -bash
oracle 2298 1 0 17:48:31 ? 0:01 ora_diag_orcl
oracle 2304 1 0 17:48:31 ? 0:01 ora_dia0_orcl
oracle 2306 1 0 17:48:31 ? 0:02 ora_mman_orcl
oracle 2308 1 0 17:48:31 ? 0:01 ora_dbw0_orcl
oracle 2310 1 0 17:48:31 ? 0:01 ora_lgwr_orcl
oracle 2315 1 0 17:48:32 ? 0:02 ora_smon_orcl
oracle 2313 1 0 17:48:32 ? 0:01 ora_ckpt_orcl
oracle 2317 1 0 17:48:32 ? 0:00 ora_reco_orcl
oracle 2319 1 0 17:48:32 ? 0:02 ora_mmon_orcl
oracle 2321 1 0 17:48:32 ? 0:01 ora_mmnl_orcl
oracle 2323 1 0 17:48:32 ? 0:00 ora_d000_orcl
oracle 2325 1 0 17:48:33 ? 0:00 ora_s000_orcl
oracle 2742 1 0 17:49:06 ? 0:00 ora_qmnc_orcl
oracle 2768 1 0 17:49:16 ? 0:00 ora_q000_orcl
oracle 3288 1 0 17:54:25 ? 0:01 ora_w000_orcl
oracle 2922 2921 0 17:49:48 ? 0:00 /opt/SUNWscor/oracle_server/bin/oracle_server_monitor64_v10 -R oracledb-res -G
Could anyone please throw some light on what I am doing wrong?
Thank you