Saturday, April 6, 2013

DB Connection format for R12 OAF

The –dbconnection information can actually be in one of two formats:

Format 1: The long format

You can put the entire TNS Names entry. For example, your entry might read as

follows:

-dbconnection "(description = (address_list = (address =

(community = tcp.world)(protocol = tcp) (host

=es0006.oracle.com)(port = 1521))) (connect_data = (sid =

es0006)))“

Format 2: The short format (preferred)

You can put an entry similar to the following:

-dbconnection es0006.oracle.com:1521:es0006

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...