5 Replies Latest reply: Dec 15, 2012 5:14 AM by 655280 RSS

    Database installation gets fail in RAC

    dbarohit
      Hello All,

      I'm configuring Oracle 11gR2 RAC2 node server over RHEL5.5 on Oracle VM box.

      I configured Clusterware but when I'm installing Oracle Database using DBCA utility it throws the following error as
      "ORA-00119: invalid specification for system parameter REMOTE_LISTENER
      ORA-00132: syntax error or unresolved network name 'rac-scan.xxx.com:1521"

      Few months back, I had configured 11gR2 RAC2 node server without having any error, but this time I wanted to configure the same on different machine then I'm getting the above mentioned error.

      Following are the cluster services for your references.

      [root@rac1 bin]# ./crsctl check cluster -all
      **************************************************************
      rac1:
      CRS-4537: Cluster Ready Services is online
      CRS-4529: Cluster Synchronization Services is online
      CRS-4533: Event Manager is online
      **************************************************************
      rac2:
      CRS-4537: Cluster Ready Services is online
      CRS-4529: Cluster Synchronization Services is online
      CRS-4533: Event Manager is online
      **************************************************************

      [root@rac1 bin]# ./crsctl stat res -t
      --------------------------------------------------------------------------------
      NAME TARGET STATE SERVER STATE_DETAILS
      --------------------------------------------------------------------------------
      Local Resources
      --------------------------------------------------------------------------------
      ora.DATA.dg
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      ora.LISTENER.lsnr
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      ora.asm
      ONLINE ONLINE rac1 Started
      ONLINE ONLINE rac2 Started
      ora.gsd
      OFFLINE OFFLINE rac1
      OFFLINE OFFLINE rac2
      ora.net1.network
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      ora.ons
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      ora.registry.acfs
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.LISTENER_SCAN1.lsnr
      1 ONLINE ONLINE rac1
      ora.cvu
      1 ONLINE ONLINE rac2
      ora.oc4j
      1 ONLINE ONLINE rac2
      ora.rac1.vip
      1 ONLINE ONLINE rac1
      ora.rac2.vip
      1 ONLINE ONLINE rac2
      ora.scan1.vip
      1 ONLINE ONLINE rac1


      [root@rac2 bin]# ./crsctl stat res -t -init
      --------------------------------------------------------------------------------
      NAME TARGET STATE SERVER STATE_DETAILS
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.asm
      1 ONLINE ONLINE rac2 Started
      ora.cluster_interconnect.haip
      1 ONLINE ONLINE rac2
      ora.crf
      1 ONLINE OFFLINE
      ora.crsd
      1 ONLINE ONLINE rac2
      ora.cssd
      1 ONLINE ONLINE rac2
      ora.cssdmonitor
      1 ONLINE ONLINE rac2
      ora.ctssd
      1 ONLINE ONLINE rac2 ACTIVE:0
      ora.diskmon
      1 OFFLINE OFFLINE
      ora.drivers.acfs
      1 ONLINE ONLINE rac2
      ora.evmd
      1 ONLINE ONLINE rac2
      ora.gipcd
      1 ONLINE ONLINE rac2
      ora.gpnpd
      1 ONLINE ONLINE rac2
      ora.mdnsd
      1 ONLINE ONLINE rac2
      [root@rac2 bin]# ./crsctl stat res -t
      --------------------------------------------------------------------------------
      NAME TARGET STATE SERVER STATE_DETAILS
      --------------------------------------------------------------------------------
      Local Resources
      --------------------------------------------------------------------------------
      ora.DATA.dg
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      ora.LISTENER.lsnr
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      ora.asm
      ONLINE ONLINE rac1 Started
      ONLINE ONLINE rac2 Started
      ora.gsd
      OFFLINE OFFLINE rac1
      OFFLINE OFFLINE rac2
      ora.net1.network
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      ora.ons
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      ora.registry.acfs
      ONLINE ONLINE rac1
      ONLINE ONLINE rac2
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.LISTENER_SCAN1.lsnr
      1 ONLINE ONLINE rac1
      ora.cvu
      1 ONLINE ONLINE rac2
      ora.oc4j
      1 ONLINE ONLINE rac2
      ora.rac1.vip
      1 ONLINE ONLINE rac1
      ora.rac2.vip
      1 ONLINE ONLINE rac2
      ora.scan1.vip
      1 ONLINE ONLINE rac1
      [root@rac2 bin]#


      Plz help me out of this.

      Thanks !!!
      rohit
      http://dbarohit.blogspot.in/