Database Administration (MOSC)

MOSC Banner

How can I connect different instance in oracle RAC machine?

edited Sep 10, 2015 4:07AM in Database Administration (MOSC) 3 commentsAnswered ✓

Hi all. I usually connect ORCL instance database. I want to connect ASM instance in same user.

I can connect;  sqlplus sys / as sysdba

I want to connect sqlplus asmuser/password AS SYSASM@+ASM

this is my listener;

[oracle@orcl1 ~]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 09-SEP-2015 11:53:54

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                08-MAY-2015 08:11:12

Uptime                    124 days 3 hr. 42 min. 41 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/12.1.0.2/grid/network/admin/listener.ora

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center