2 Replies Latest reply: Feb 24, 2014 7:59 AM by 892776 RSS

    Hi experts

    892776

      I'm installed RAC on Linux 11g.

      Now i am configuring Goldengate on RAC on Linux but just one node.

       

      My problem is oracle user can not connect +ASM instance.

       

       

      [oracle@node1 ~]$ lsnrctl services

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-FEB-2014 16:52:45

      Copyright (c) 1991, 2009, Oracle.  All rights reserved.

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

      Services Summary...

      Service "+ASM" has 1 instance(s).

        Instance "+ASM1", status READY, has 1 handler(s) for this service...

          Handler(s):

            "DEDICATED" established:0 refused:0 state:ready

               LOCAL SERVER

      Service "racdb.yuko.mn" has 1 instance(s).

        Instance "racdb1", status READY, has 1 handler(s) for this service...

          Handler(s):

            "DEDICATED" established:0 refused:0 state:ready

               LOCAL SERVER

      Service "racdbXDB.yuko.mn" has 1 instance(s).

        Instance "racdb1", status READY, has 1 handler(s) for this service...

          Handler(s):

            "D000" established:0 refused:0 current:0 max:1022 state:ready

               DISPATCHER <machine: node1.yuko.mn, pid: 21439>

               (ADDRESS=(PROTOCOL=tcp)(HOST=node1.yuko.mn)(PORT=34506))

      The command completed successfully

       

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

      [oracle@node1 ~]$ sqlplus sys/1pass@+ASM as sysasm

      SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 23 16:43:24 2014

      Copyright (c) 1982, 2009, Oracle.  All rights reserved.

      ERROR:

      ORA-12154: TNS:could not resolve the connect identifier specified

       

      ####################################

      #  MY CONFGIURE FILES           oracle user   #

      ####################################

       

       

      [oracle@node1 ~]$ cat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

      # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

      # Generated by Oracle configuration tools.

       

       

      RACDB =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = node-cluster-scan)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = racdb.yuko.mn)

          )

        )

       

      [oracle@node1 ~]$ ll /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/

      total 16

      drwxr-xr-x 2 oracle oinstall 4096 Feb 19 17:27 samples/

      -rw-r--r-- 1 oracle oinstall  187 May  7  2007 shrept.lst

      -rw-r--r-- 1 oracle oinstall  520 Feb 23 14:18 tnsnames1402232PM1835.bak

      -rw-r----- 1 oracle oinstall  344 Feb 23 16:01 tnsnames.ora

       

      #################################

      #       GRID USER's configure files             #

      #################################

       

      [grid@node1 ~]$ ls -l /u01/app/11.2.0/grid/network/admin

      total 24

      -rw-r--r-- 1 grid oinstall  181 Feb 19 16:32 endpoints_listener.ora

      -rw-r--r-- 1 grid oinstall  350 Feb 23 15:01 listener.ora

      -rw-r--r-- 1 grid oinstall  184 Feb 19 16:24 listener.ora.bak.node1

      drwxr-xr-x 2 grid oinstall 4096 Feb 19 16:12 samples/

      -rw-r--r-- 1 grid oinstall  187 May  7  2007 shrept.lst

      -rw-r--r-- 1 grid oinstall  214 Feb 19 16:32 sqlnet.ora

       

      [grid@node1 admin]$ cat listener.ora

      LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent

      LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent

      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent

      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

       

      [grid@node1 admin]$ lsnrctl services

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-FEB-2014 17:00:51

      Copyright (c) 1991, 2009, Oracle.  All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

      Services Summary...

      Service "+ASM" has 1 instance(s).

        Instance "+ASM1", status READY, has 1 handler(s) for this service...

          Handler(s):

            "DEDICATED" established:0 refused:0 state:ready

               LOCAL SERVER

      Service "racdb.yuko.mn" has 1 instance(s).

        Instance "racdb1", status READY, has 1 handler(s) for this service...

          Handler(s):

            "DEDICATED" established:0 refused:0 state:ready

               LOCAL SERVER

      Service "racdbXDB.yuko.mn" has 1 instance(s).

        Instance "racdb1", status READY, has 1 handler(s) for this service...

          Handler(s):

            "D000" established:0 refused:0 current:0 max:1022 state:ready

               DISPATCHER <machine: node1.yuko.mn, pid: 21439>

               (ADDRESS=(PROTOCOL=tcp)(HOST=node1.yuko.mn)(PORT=34506))

      The command completed successfully

       

       

      !!! how to connect +ASM instance.

        • 1. Re: Hi experts
          Tom321

          Hi,

           

          as asm software owner grid export SID +ASM1 or +ASM2:

          export ORACLE_SID=+ASM1

          sqlplus / as sysasm

           

          ASM Instance is not resolved via tnsnames.ora in the default config and it doesn't accept remote connections (disabled by default, can be enabled if you wish) via the sqlnet stack (even if they are from the local node).

           

          Regards

          Thomas

          • 2. Re: Hi experts
            892776

            Tnx Thomas

             

            resolved my error.

             

            Solution:

             

            1. edited /u01/app/11.2.0/grid/network/admin/listener.ora file
            added this configuration on both nodes.

             

            SID_LIST_LISTENER =

              (SID_LIST =

                (SID_DESC =

                  (SID_NAME = PLSExtProc)

                  (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

                  (PROGRAM = extproc)

                )

                (SID_DESC =

                  (GLOBAL_DBNAME  = +ASM)

                  (SID_NAME       = +ASM1)

                  (ORACLE_HOME    = /u01/app/oracle/product/11.2.0/dbhome_1)

                )

              )

             

            2. edited /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
            added this configuration on both nodes.

             

              ASM1 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVICE_NAME = +ASM)

                )

              )

             

            ASM2 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVICE_NAME = +ASM)

                )

              )

             

            3.  restart LISTENER

            lsnrctl stop LISTENER

            lsnrctl start LISTENER