Database - RAC/Scalability (MOSC)

MOSC Banner

oracle 12c RAC connectivity issue

edited Sep 15, 2015 10:05AM in Database - RAC/Scalability (MOSC) 7 commentsAnswered

Hi All,

Oracle 12.1.0.2.0

Linux 3.8.13-68.1.2.el6uek.x86_64

am unable to connect the database using service name. please suggest me.

[oracle@lxdb4104 ~]$ sqlplus test/test@LBP1CAT

SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 8 13:21:33 2015

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

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:

does any listener registration is required?

[oracle@lxdb4104 ~]$ ps -ef|grep tns

root        50     2  0 Aug31 ?        00:00:00 [netns]

oracle    5443  1415  0 13:17 pts/1    00:00:00 grep tns

grid     13577     1  0 11:35 ?        00:00:00 /opt/app/grid/12.1.0/gi_1/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit

grid     13599     1  0 11:35 ?        00:00:00 /opt/app/grid/12.1.0/gi_1/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit

grid     13657     1  0 11:35 ?        00:00:00 /opt/app/grid/12.1.0/gi_1/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit

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