Thursday, November 22, 2007

Oracle OpenWorld 2007 Presentations Available for Download


For those who have missed OOW-2007 (like me), here is the chance to go through the presentations. Presentations are available on virtually all topics for download, but unfortunately, Tom Kyte's presentation is not downloadable.

Although there are many presentations available, I started reading Cary Millsap's "Why You Can't See Your Real Performance Problems" presentation.

Here is the link:

Moreover, the username and password to download the presentations are available at the top of the page for our convenience.

You may also like to visit

Happy reading !!!!

Sunday, November 18, 2007

ORA-12537 TNS: Connection Closed

Dear readers,

When I was trying to establish client connection to one of our databases running on Oracle 10g, I received “ORA-12537 TNS: Connection Closed” error.

Upon investigation, I came across “TCP.VALIDNODE_CHECKING” parameter in “sqlnet.ora” file. This was set to “YES”. I simply commented this parameter and every thing went fine. Clients were able to establish connection to the database.

By setting TCP.VALIDNODE_CHECKING to “YES”, you inform Oracle database to allow/deny connections to the listed nodes. You may list the invited nodes using TCP.INVITED_NODES parameter in sqlnet.ora file or, alternatively, you may use the TCP.EXCLUDED_NODES parameter to disallow database connections from the listed nodes.

Hope you find this information helpful!!!

Monday, November 12, 2007

Manually Install/De-Install Database Options in Oracle Database 10gR2


When a new database is created using DBCA, by default some of the common database options are installed like Oracle JVM and Oracle Text. But, when you manually create the database none of them get installed. You need to manually install them.

I thought of sharing Metalink Note Id’s for some of the Common Database Options which you can manually install/de-install once database has been created:

Oracle JVM
Note:276554.1 How to Reload the JVM in 10.1.0.X and 10.2.0.X

Oracle Text
Note:280713.1 Manual installation, deinstallation of Oracle Text 10gR1 and 10gR2

Oracle XML DB
Note:243554.1 How to Deinstall and Reinstall XML Database (XDB)

Oracle Multimedia
Installation, Upgrade and Downgrade information can be found in the following Manual: Oracle® interMedia
User's Guide 10g Release 2 (10.2) Appendix B Installing and Upgrading Oracle interMedia

Oracle OLAP
Note:296187.1 How To Manually Install Oracle OLAP into a 9i or 10g Database After the DB Has Been Created

Oracle Spatial
Note:270588.1 Steps for Manual Installation / Verification of Spatial 10g

Note:1070647.1 How to Deinstall Oracle Spatial keeping Oracle Locator

Oracle Ultra Search
Note:337992.1 How to Manually Install and Uninstall Ultra Search 10gR2 Server Components

Oracle Label Security
Note:171155.1 How to Install / Deinstall Oracle Label Security Oracle9i/10g

Sample Schemas
Note:340112.1 How To Install Sample Schemas in 10g?

Enterprise Manager Repository
Note:114763.1 How to Create Enterprise Manager 2.1 Repository Using EMCA

Oracle Application Express
Note:445205.1 How to download and install Application Express / HTMLDB

Oracle Warehouse Builder
Note:459961.1 How to Install Warehouse Builder Repository( on a RAC Database on Windows and UNIX

Oracle Database Vault
Note:445092.1 How to Install Database Vault Patches on top of

Oracle Database Extensions for .NET
Note:374820.1 How to Install the Oracle Database Extensions for .NET (ODE.NET)

Oracle Data Mining
Note:297551.1 How to remove the Data Mining Option from the database

Thanks Gerrit for Oracle Data Mining & Oracle Spatial MOS document id's.

Hope you find this document helpful :)