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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to access a DB using Scan name

2712108Jul 14 2014 — edited Aug 5 2014

Hi all I have implemented an oracle RAC, but I'm having a issue with one db instance which i have queried in here

This is a another query, how can I access the data base using scan name from a remote computer, I have tried the following methods,

./sqlplus sys/passwordroot@scan.private.xxv.com:1521/rac

which gives following output,

SQL*Plus: Release 12.1.0.1.0 Production on Mon Jul 14 19:20:42 2014

ERROR:

ORA-12545: Connect failed because target host or object does not exist

The second attempt,

./sqlplus sys as sysdba/passwordroot@scan.private.xxv.com:1521/rac

which gives following,

SQL*Plus: Release 12.1.0.1.0 Production on Mon Jul 14 19:21:30 2014

Enter password:

ERROR:

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

So how can I do this correctly and is this because one of my instances is down? Your kind help would really help me, Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2014

Added on Jul 14 2014

#performance-availability, #rac-asm-clusterware-installation

11 comments

6,145 views