I work in a system , where a 3rd party tool will monitor Oracle. It is throwing some alerts with ORA-12154.
But I was able to connect to database using SQLPLUS from win NT ( Database is running on UNIX ). I did check all the logs Viz.. alert.log, listener.log... I coundn't see any errors realetd to ORA-12154.
but the 3rd party tool is still throwing the error messages . And It is happening for all instances on the UNIX machine.
dont know , how these errors are coming, May be some expert can help me out.
The Entry for the database is not there in TNSNAMES.ORA ( On UNIX MACHINE ), but I am still be able to connect to that instance through Oracle client ( Since TNSNAMES.ORA of my local machine is having the entry ). Do we essentially require this entry of the database in TNSNAMES.ORA ????