Friday, July 31, 2009

TNSping resolves but SQLplus gives ORA-12514

After creating a new DB on 11g, configuring it in listener.ora and entering it into LDAP, tnsping worked but I wasn't able to make a connection.

The problem was, that the DB didn't register with the listener automatically. Setting the local_listener parameter solved the problem

alter system set local_listener='host_listenername';

Labels: , ,