cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Alert

Former Member
0 Kudos

Hi All,

Plz help me understand following alerts and how to rectify the alert messages.

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14505984 (>< 4096,512 KB)

BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE) 4/19/2007 4:56:27 PM ptandon

BR0978W Database profile alert - level: WARNING, parameter: DB_BLOCK_CHECKSUM, value: TRUE (<> FALSE)

BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value: 2152 (>< 16384,4096)

BR0978W Database profile alert - level: WARNING, parameter: STAR_TRANSFORMATION_ENABLED, value: FALSE (<> TRUE)

FILESYSTEMIO_OPTIONS, value: ASYNCH (<> SETALL) BR0978W Database profile alert - level: WARNING, parameter:

regards,

Vikram

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

I assume your Oracle version is 10g. see SAP Note 900522 for modifying incorrect or unjustified alerts. To verify if your parameter file is correct, you can follow Note 830576.

Best Regards,

JC Llanes.

Former Member
0 Kudos

Hi,

Thanx for responding....Can u please suggest how we can change the database parameters through sql plus or opening the file in notepad and editing directly.

regards,

Vikram

Former Member
0 Kudos

Hi,

There're 2 options: DB is starting with SPFILE (default in 10g installation), or DB is starting with PFILE (typical initSID.ora text file).

If you don't know how is starting your instance, connect to sqlplus and run: "<i>SHOW PARAMETER SPFILE</i>". If something appears under "VALUE" columm, the answer is YES.

To change SPFILE parameters, the command from sqlplus is like that example:

<i>ALTER SYSTEM SET COMPATIBLE='10.2.0' SCOPE=SPFILE;</i>

If your DB use PFILE, you can edit the initSID.ora file with any editor (vi under Unix/Linux, notepad in Windows).

To read more about SPFILE, look at <b>Note 601157 </b>(It's for Oracle 9i, but will teach the basis about it).

Best Regards,

JC Llanes.