Database Networking (MOSC)

MOSC Banner

The listener supports no services

edited Jun 11, 2012 7:52PM in Database Networking (MOSC) 5 commentsAnswered
Hi, 

I have 2 node RAC database running on RAC-node-db1 and RAC-node-db2  and db is up and running without issues.
Again I have created another single instance database(AJCRC) on RAC-node-db2 which is giving error during remote connection.
I have attached respective log file here. Kindly help me to resolve this issue.


C:\Users\chowdhs>tnsping ajcrc

Used parameter files:
C:\product\11.2.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = RAC-node-db2.domain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = a
jcrc.domain)))
OK (10 msec)

C:\Users\chowdhs>sqlplus dbsharif/xxx@ajcrc

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