Database Security Products (MOSC)

MOSC Banner

Cannot Login without using the @database_name

edited Jul 22, 2014 4:05PM in Database Security Products (MOSC) 3 commentsAnswered

I have checked TNSPING, listener and SQL.net and all checkout AOK. The problem follows

c:\set ORACLE_SID=database_name

c:>sqlplus /nolog

SQLPLUS> connect sys as sysdba

enter password:

ORA-12560: TNS: Protocol adapter error

-------------------------------------------------------------------------------------------

I CAN ONLY CONNECT USING THE @database_name

SQLPLUS> connect sys@database_name as sysdba

enter password:

Connected

Any Ideas would be greatly appreciated.  I have been given this Oracle database after another DBA left.  The only differences from this database and the other oracle Instance follows

a) The %PATH%   has both the dbhome_1     and  client_1    in the path and it's installed as follows

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