Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to connect to ASM instance

nhidbaMay 2 2012 — edited May 2 2012
Hi 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
This post has been answered by kuljeet singh - on May 2 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2012
Added on May 2 2012
6 comments
2,025 views