unable to connect to ASM instance
nhidbaMay 2 2012 — edited May 2 2012Hi all,
Iam new to Oracle 11g..
We have installed 11.2.0.3 Grid infrastructure for standalone server. ASM was configured as part of it. After installation iam not able to connect to asm instance.
below is the error:
$ sqlplus grid as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 2 15:29:12 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
and listener configuration is:
$ srvctl config asm
ASM home: /ora11emc1/app/grid/product/11.2.0/grid
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.253.782222035
ASM diskgroup discovery string:
listener.ora file:
$ cat listener.ora
# listener.ora Network Configuration File: /ora11emc1/app/grid/product/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = baantestserver)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /ora11emc1/app/grid
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
Please suggest.
Thanks
sandy