on 06-19-2007 3:20 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.