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: , ,

Monday, May 4, 2009

Listener service problem

Dynamic listener was not able to register a service for a database that had the local_listener parameter set to another server in the spfile. Resulting in a ORA-12505 when trying to log on remotely. Unsetting the parameter solved the problem.

Labels: , ,