1 Reply Latest reply: Dec 18, 2012 12:59 PM 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
      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