DBA Tips and Tricks

Look here for the latest in neat stuff!

1. TNS_ADMIN tricks

Using TNS_ADMIN is a must for servers that have multiple ORACLE_HOMES.

There are a few issues to making sure all database functions find the correct TNS_ADMIN location.

Database Links – Creat any links with a complete SQL*NET description.

 create public database link LINKNAME connect to USERNAME identified by “password” using ‘(description=(address=(protocol =TCP)
(host=hostname)(port=portno))(connect_data=(SERVICE_NAME=SERVICE_NAME)))’;

local_listener Startup Initialization Parameter – Same as above use the complete SQL*NET description.

local_listener                       string      (address=(protocol=tcp)(host=hostname)(port=portnumber))