Database Software

Hi Experts,

I have installed Oracle RAC in the below environment.But unable to connect ASM instance using tns string

This is production DB and up and running.

RAC 2 nodes
Oracle RAC 11.2.0.1.0
ASM

Enterprise Linux Server release 5.5 (Carthage)
Processor Type x64
OS 64 bit

Getting below error while connecting with asm instance directly:

[oracle@ admin]$ sqlplus sys@asm as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Sun Aug 5 11:16:11 2012

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

Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name:

Listener entries on node 1

[oracle@ admin]$ cat listener.ora
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))                # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))                # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON                # line added by Agent

SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
         (SID_NAME = +ASM1)
         (GLOBAL_DBNAME=ASM)
         (ORACLE_HOME = /u01/app/11.2.0/grid)
      )
      (SID_DESC =
         (SID_NAME = PLSExtProc)
         (ORACLE_HOME = /u01/app/11.2.0/grid)
         (PROGRAM = extproc)
      )
   )
[oracle@ admin]$

$ lsnrctl services

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-AUG-2012 00:31:04

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 "ASM" has 1 instance(s).
  Instance "+ASM1", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
 

Tnsnames.ora entries are as below:

[oracle@ admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: 

/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

XXX =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxx-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = xxx)
    )
  )

ASM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxxdata-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (SID_NAME = +ASM1)
    )
  )

Any help ?

Regards,

Edited by: LazyDBA11g on Aug 11, 2012 9:58 PM

Edited by: LazyDBA11g on Aug 12, 2012 3:27 AM