Maintaining large numbers of client tnsnames.ora files is a pain. Oracle Internet Directory is the recommended solution to this, but it is not an easy exercise to set up or migrate to. An easier alternative is to set TNS_ADMIN in all client PCs to use a single common tnsnames.ora file set TNS_ADMIN=\\network\share\path All the client PCs […]
Read More Replace all tnsnames.ora files with a single master file using TNS_ADMINProblem: 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 David Yahalom for flagging this – it doesn’t appear to be covered in metalink/my oracle […]
Read More Intermittent ORA-12545 with oracle RAC database(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 that java applications have had for a long time – largely equalising performance differences with […]
Read More Database Resident Connection PoolingMy 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 set, any ‘oracle’ account on any machine (even a client) can stop and change listeners […]
Read More Listener passwords: always for 9i, never for 10gThanks 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 copes with listener passwords is below. The location of the listener.ora file was /etc in […]
Read More 9i unix startup / shutdown with listener password