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!

Remote Access to ASM DB Instance

2745406Dec 5 2014 — edited Dec 8 2014

Hello together,

on an Oracle Linux 6 server with GI 12.1.0.2 I'm trying to connect to the ASM DB Instance remotely. I want to monitor all my ASM Disks over Nagios with a plugin called "check-oracle-health". But I didn't get the connection to the ASM instance.

My listener config is just simplest one:

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = server123)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

  )

Also lsnrctl shows me, that the DB is ready to connect:

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 05-DEC-2014 15:17:12

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

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

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date                05-DEC-2014 15:15:25

Uptime                    0 days 0 hr. 1 min. 46 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /usr/local/grid/12.1.0.2/network/admin/listener.ora

Listener Log File         /usr/local/oracle/diag/tnslsnr/server123/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server123)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

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

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

Service "db1" has 1 instance(s).

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

Service "db2" has 1 instance(s).

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

The command completed successfully

I've some other db's running on that server that are using the same listener, I prefer it to have a "global" listener (one for all).

but when I'm trying to connect remotely to the ASM instance I can't connect:

./sqlplus sys/passwdas sysdba@ASM

SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 5 15:38:43 2014

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

ERROR:

ORA-12162: TNS:net service name is incorrectly specified

./sqlplus sys/passwdas sysasm@ASM

SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 5 15:38:43 2014

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

ERROR:

ORA-12162: TNS:net service name is incorrectly specified

The tnsnames.ora at remote side has this entry:

ASM =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = server123)(PORT = 1521))

    (CONNECT_DATA =

      (SERVICE_NAME = +ASM)

      (UR=A)

    )

  )

I've read about to configure a SID_LIST_LISTENER on server side in the listener.ora file, but then I've the issue, that the listener just know about the ASM Instance and not about the other and that also didn't solve my connection problem.

Cann you help?

Thanks a lot and regards,

David

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2015
Added on Dec 5 2014
21 comments
8,140 views