How to Configure Oracle DAC for the first time?

After installing DAC software, click on start > Programs > Oracle DAC > Client.

The Dac software screen appears, click on configure to create a connection the the database.  Fill in the following details:

1) Give the connection name
2) Select the driver type (OCI(THIN))
3) Give the TNS Name of the Oracle Database
4) Create a connection file (.con extension ).
5) Test connection. Click on Save, then Finish.

After creating a connection by following the steps above, select the newly created connection and provide an Admin username, password and click next.  If DBA gives table space, go ahead and create tables that are required by the DAC software.

This process should setup everything that gets you started with oracle DAC.

Until Next Post... :)