Logging into DAC for the First Time

When you log into DAC for the first time, you must first configure a connection to connect to the DAC Repository.

DAC stores this connection information for subsequent logins.

DAC Repository Database Authentication File

1.     When you configure a connection to the DAC Repository, the configuration process includes creating a new authentication file or selecting an existing authentication file.

2.     The authentication file authenticates the database in which the repository resides.

3.     If  you create a new authentication file, you will specify the table owner and password for the database.

4.     A user with the Administrator role must distribute the authentication file to any user  account that needs to access the specified DAC Repository.

To log into DAC for the first time

1. Start the DAC Client by navigating to the $ORACLE_HOME\bifoundation\dac

directory and double-clicking the startclient.bat file.

The Login ... dialog box appears.

2. Click Configure.

3. In the Configuring ... dialog box, select Create Connection, and then click Next.

4. Enter the appropriate connection information:

Field                                             Required Value

Name                             Enter a unique name for the connection to the DAC  Repository.

Connection type                  Select the type of database in which the DAC Repository will  be stored.

Connection String, or                           

Database name, or TNS

Name, or Instance

Select the database name or database account name of the

DAC Repository.

If you are using:

■ Oracle (OCI8), use the tnsnames entry.

■ Oracle (Thin), use the instance name.

■ SQL Server, use the database name.

■ DB2-UDB, use the connect string as defined in the DB2

configuration.

Database Host Enter the name of the machine where the DAC Repository will

reside.

Database Port Enter the port number on which the database listens. For

example, for an Oracle database the default port is 1521, or for

a SQL Server database the default port is 1433.

Optional URL Can be used to override the standard URL for this connection.

Optional Driver Can be used to override the standard driver for this

connection.

Authentication File Click in this field to do one of the following:

■ Select an existing authentication file:

Navigate to the appropriate location, select the

authentication file , and click OK.

■ Create a new authentication file:

Navigate to the folder where you want to save the

authentication file, and click OK.

Proceed to the next step for detailed instructions.

5. To select an existing authentication file, do the following:

a. Click in the Authentication File field of the Configuring... dialog box.

b. In the Authentication File dialog box, select Choose existing authentication

file.

c. Navigate to the appropriate folder, and select the authentication file. Click OK.

d. In the Configuring... dialog box, click Test Connection to confirm the

connection works.

e. Click Apply, and then click Finish.

Note: You must distribute this authentication file to all user accounts

that need to access this DAC Repository.

6. To create a new authentication file, do the following:

a. Click in the Authentication File field of the Configuring... dialog box.

b. In the Authentication File dialog box, select Create authentication file.

c. Navigate to the folder where you want to save the new authentication file, and

click OK.

d. In the Create Authentication File dialog box, enter a unique name for the

authentication file, and click OK.

e. Enter the Table Owner Name and Password for the database where the

repository will reside.

f. In the Configuring... dialog box, click Test Connection to confirm the

connection works.

g. Click Apply, and then click Finish.