July 18, 2011 archive

ORA-12519 TNS: no appropriate service handler found

Every 10 minutes or so, I have Grid Control sending me an alert similar to the following: Failed to connect to database instance: ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach). The database was running just fine and should be up and running. Signing on to the database server and issuing “lsnrctl status” showed …

Continue reading

DBCA Create Database bad REMOTE_LISTENER

I recently upgraded Oracle Cluster Ready Services 11.1.0.7 to Oracle Grid Infrastructure 11.2.0.2 on a testbed. I then attempted to run the DBCA to create an Oracle 11.1.0.7 on top of the 11.2.0.2 Grid installation. After walking through the DBCA wizard,I would always receive messages similar to the following: ORA-00119: Invalid specification for system parameter …

Continue reading