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';
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: local_listener, ORA-12514, tnsping
