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))

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s