How to Enable Logging on the Oracle Server

This task describes how to enable logging on the Oracle server.

1. Verify that the trace diagnostics are enabled

   Perform the following steps:

   1. Log on to the Oracle application server with administrator privileges, and select the desired module in the Oracle application. The Responsibilities dialog box opens.

   2. Select System Administrator and click OK.

   3. In the Functions tab, select Profile > System and click Open. The System Profile Values dialog box opens.

   4. In the Display section, select Site and Profiles with No Values, enter %Diagnostics% in the Profiles field, and then click Find.

   5. If any diagnostics profiles are disabled (denoted by a "Yes" in the Site column), change the setting to "No".

   6. Save your settings.

2. Set the trace file size to unlimited

   For Oracle 9i:

   On the Oracle server, run the following command in the SQL editor:

   Alter system set max_dump_file_size=UNLIMITED scope=both;
   

   For Oracle 8i:

   1. On the Oracle server, run the following command in the SQL editor:

   Alter system set max_dump_file_size=2048000;
   

   2. Edit the init*.ora file on $ORACLE_HOME\admin\<sid>\pfile\init<sid>.ora. Find the line of the parameter, change its value, and then save the file.

   Note: Verify that you have enough disk space on the database server since these trace files can be very large.