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)

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

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


2 Responses to DBA Tips and Tricks

  1. Tammy Lambdin says:

    Thank you for this website. I have been thrown into a Banner DBA role and appreciate all the good info.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s