Category Archives: SQL*Net

Intermittent ORA-12545 with oracle RAC database

Posted on 9 May 2011 by Andrew Fraser

Problem: Client suffers intermittent ORA-12545 “Connect failed because target host or object does not exist” trying to connect to oracle RAC database. Solution: Edit server side (not client side) listener.ora and tnsnames.ora files to have fully qualified hostnames. Thanks to … Continue reading →

Posted in RAC, SQL*Net | Leave a comment

Database Resident Connection Pooling

Posted on 23 April 2011 by Andrew Fraser

(Update: Firewalls can prevent DRCP functioning correctly – details at end of this post) Database Resident Connection Pooling is new with 11g, and should be used for PHP applications. It will allow them to use the same type of connection pooling … Continue reading →

Posted in RAC, SQL*Net | Leave a comment

Listener passwords: always for 9i, never for 10g

Posted on 24 May 2007 by Andrew Fraser

My rule of thumb: For 9i and below: always set a listener password (= change from default) For 10g and above: never set a listener password (= leave at default) And here’s why: 9i and below Without a listener password … Continue reading →

Posted in Security, SQL*Net | 6 Comments

9i unix startup / shutdown with listener password

Posted on 11 January 2007 by Andrew Fraser

Thanks to Laurent Schneider for tips on how to handle listener passwords in scripts. [Update 12-Jan-2007 - ammended script following Laurent's comment, and update 09-Feb-2007 - ammended script following Kevin's comment] A system startup/shutdown shell script I just used that … Continue reading →

Posted in Installs, Scripts, SQL*Net | 6 Comments