Database Administration (MOSC)

MOSC Banner

tnsping works fine but lsnrctl and sqlplus gives error from remote server

edited May 2, 2015 7:15AM in Database Administration (MOSC) 3 commentsAnswered

Hi,

When using tnsping from a remote server, i get a proper response, but lsnrctl and sqlplus gives error.

LSNRCTL gives:-

TNS-01189: The listener could not authenticate the user

and when trying to connect to the instance through sqlplus i get :-

ORA-12505: TNS:listener does not currently know of SID given in connect

descriptor

I am using :-

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE    11.2.0.3.0      Production

TNS for Solaris: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

ON Sparc(SunOs 11)

I tried to ssh from the source to target server and it works fine.

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