July 2011 archive

11.2.0.2 Upgrade with Standby on RAC

I have been working on upgrading an existing 11.1.0.7 database to 11.2.0.2. This database is on a RAC cluster on Oracle Enterprise Linux 5. After successfully upgrading Oracle Clusterware to Oracle Grid Infrastructure 11.2.0.2, I was looking towards upgrading the database next. The last piece you need to know is that this database is part …

Continue reading

ORA-4031 errors with Direct NFS

This is an old problem for me which I resolved quite a while ago, but I figured I’d finally write it up. When I started at my new company, the production database would crash about once a month with ORA-4031 memory errors. The current DBA figured the problem was lack of bind variables in application …

Continue reading

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

CRS 11.2.0

I am working on upgrading our existing Oracle Cluster Ready Services from 11.1.0.7 to 11gR2 (11.2.0.1). Things are not going as smoothly as I had hoped and I am learning a lot about the changes in 11gR2. This is not a minor upgrade as the version number differences would suggest. There have been lots of …

Continue reading