This discussion is archived
1 Reply Latest reply: Dec 18, 2012 10:59 AM by rcc50886 RSS

Convert 11.1.0.7 EBS 12.1.3 single node to RAC with ASM on 11.2.0.3 cluster

user336741 Newbie
Currently Being Moderated
Hi
I am trying to convert a single node 11.1.0.7 database with EBS 12.1.3 version from single to 2-node RAC ASM on Oracle clusterware 11.2.0.3 on AIX 6.1 - 64 bit
I am following Oracle metalink document note id 466649.1 . My 11.2.0.3 clusterware is already setup correctly and working fine as per document E24614-03.
However I am currently stuck in section 3.3:Configure TNS listener (Doc id : 466649.1) . The netca is unable to start the listener and failing with error as below.
However when I start the same locally from lsnrctl command listener starts.

trace_OraDb11g_home1-1212159AM174.log
====================================

[AWT-EventQueue-0] [18:34:31:887] [RuntimeExec.runCommand:144] runCommand: process returns 123
[AWT-EventQueue-0] [18:34:31:887] [RuntimeExec.runCommand:161] RunTimeExec: output>
[AWT-EventQueue-0] [18:34:31:887] [RuntimeExec.runCommand:164] Attempting to start `ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr
` on member `jxn-ux-ebs1d1q`
[AWT-EventQueue-0] [18:34:31:887] [RuntimeExec.runCommand:164] Start of `ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr` on member
`jxn-ux-ebs1d1q` failed.
[AWT-EventQueue-0] [18:34:31:888] [RuntimeExec.runCommand:164] Attempting to stop `ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr`
on member `jxn-ux-ebs1d1q`
[AWT-EventQueue-0] [18:34:31:888] [RuntimeExec.runCommand:164] Stop of `ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr` on member
`jxn-ux-ebs1d1q` succeeded.
[AWT-EventQueue-0] [18:34:31:888] [RuntimeExec.runCommand:164] CRS-2632: There are no more servers to try to place resource 'ora.jxn-ux-e
bs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr' on that would satisfy its placement policy
[AWT-EventQueue-0] [18:34:31:888] [RuntimeExec.runCommand:170] RunTimeExec: error>
[AWT-EventQueue-0] [18:34:31:889] [RuntimeExec.runCommand:173] CRS-0223: Resource 'ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr'
has placement error.
[AWT-EventQueue-0] [18:34:31:889] [RuntimeExec.runCommand:173]
[AWT-EventQueue-0] [18:34:31:889] [RuntimeExec.runCommand:192] Returning from RunTimeExec.runCommand
[AWT-EventQueue-0] [18:34:31:890] [HAOperationImpl.runCommand:1221] signed exit value = 123
[AWT-EventQueue-0] [18:34:31:890] [HAOperationImpl.runCommand:1258] set status HA_RES_RELOCATE_ERR
[AWT-EventQueue-0] [18:34:31:891] [HAStartOperation.run:84] Returned from executing the HA Operation
[AWT-EventQueue-0] [18:34:31:891] [HAStartOperation.run:89] OUTPUT> Attempting to start `ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q
.lsnr` on member `jxn-ux-ebs1d1q`
[AWT-EventQueue-0] [18:34:31:891] [HAStartOperation.run:89] OUTPUT> Start of `ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr` on m
ember `jxn-ux-ebs1d1q` failed.
[AWT-EventQueue-0] [18:34:31:891] [HAStartOperation.run:89] OUTPUT> Attempting to stop `ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.
lsnr` on member `jxn-ux-ebs1d1q`
[AWT-EventQueue-0] [18:34:31:892] [HAStartOperation.run:89] OUTPUT> Stop of `ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr` on me
mber `jxn-ux-ebs1d1q` succeeded.
[AWT-EventQueue-0] [18:34:31:892] [HAStartOperation.run:89] OUTPUT> CRS-2632: There are no more servers to try to place resource 'ora.jxn
-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr' on that would satisfy its placement policy
[AWT-EventQueue-0] [18:34:31:893] [HAStartOperation.run:95] ERROR> CRS-0223: Resource 'ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.l
snr' has placement error.
[AWT-EventQueue-0] [18:34:31:893] [LocalCommand.execute:56] LocalCommand.execute: Returned from run method
[AWT-EventQueue-0] [18:34:31:893] [HAOperationResult.getOutputAll:114] outLine is [CRS-2632: There are no more servers to try to place re
source 'ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr' on that would satisfy its placement policy]
[AWT-EventQueue-0] [18:34:31:894] [HAOperationResult.getOutputAll:115] errLine is [CRS-0223: Resource 'ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_
JXN-UX-EBS1D1Q.lsnr' has placement error.]
[AWT-EventQueue-0] [18:36:39:994] [ca.ConfigureListenerOPS.getNodeNameIndex:-1] getNodeNameIndex: Matching LISTENER_EBSQA_JXN-UX-EBS1D1Q
[AWT-EventQueue-0] [18:36:39:994] [ca.ConfigureListenerOPS.getListenerRootName:-1] ListenerName is LISTENER_EBSQA

The crsctl has details as below:
=====================
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jxn-ux-ebs2d1q
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE jxn-ux-ebs1d1q
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE jxn-ux-ebs1d1q
ora.cvu
1 ONLINE ONLINE jxn-ux-ebs1d1q
ora.jxn-ux-ebs1d1q.LISTENER_EBSQA_JXN-UX-EBS1D1Q.lsnr
1 ONLINE OFFLINE
ora.jxn-ux-ebs1d1q.vip
1 ONLINE ONLINE jxn-ux-ebs1d1q
ora.jxn-ux-ebs2d1q.LISTENER_EBSQA_JXN-UX-EBS2D1Q.lsnr
1 ONLINE OFFLINE


Not sure how to fix this .

Regards
Ram

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points