Skip to Content
0
Oct 31, 2012 at 11:50 AM

warning alerts for database administration ?

663 Views





Detail log:cejqydjo.chk



BR0801I BRCONNECT 7.00 (41)


BR0477I Oracle pfile /oracle/P01/102_64/dbs/initP01.ora created from spfile /oracle/P01/102_64/dbs/spfileP01.ora


BR0805I Start of BRCONNECT processing: cejqydjo.chk 2012-10-15 23.00.04


BR0484I BRCONNECT log file: /oracle/P01/sapcheck/cejqydjo.chk


BR0101I Parameters


Name Value


oracle_sid P01


oracle_home /oracle/P01/102_64


oracle_profile /oracle/P01/102_64/dbs/initP01.ora


sapdata_home /oracle/P01


sap_profile /oracle/P01/102_64/dbs/initP01.sap


system_info p01adm/orap01 MBEP01 AIX 3 5 00C585C44C00


oracle_info P01 10.2.0.2.0 8192 41789 253727210 MBEP01 UTF8 UTF8


sap_info 700 SAPSR3 0002LK0003P010011Z14682207530015Maintenance_ORA


make_info rs6000_64 OCI_102 Apr 8 2009


command_line brconnect -u / -jid CHECK20121012230000 -c -f check


alert_log /oracle/P01/saptrace/background/alert_P01.log


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.04


BR0813I Schema owners found in database P01:


DBSNMP, DIP, OPS$ORAP01, OPS$P01ADM, OPS$SAPSERVICEP01, OPS$SR3ADM, OUTLN, SAPSR3*, SAPSR3DB%, SYS,


SYSTEM, TSMSYS


BR0118I Tablespaces and data files


Tablespace Status File Status Id. Size MaxSize IncrSize BlkSize Device Type Link


PSAPSR3 ONLINE+ /oracle/P01/sapdata1/sr3_1/sr3.data1 ONLINE+ 4 2747277312 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata1/sr3_2/sr3.data2 ONLINE+ 5 2621448192 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata1/sr3_3/sr3.data3 ONLINE+ 6 2600476672 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata1/sr3_4/sr3.data4 ONLINE+ 7 2621448192 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata1/sr3_5/sr3.data5 ONLINE+ 8 2663391232 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata2/sr3_6/sr3.data6 ONLINE+ 9 2726305792 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata2/sr3_7/sr3.data7 ONLINE+ 10 2768248832 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata2/sr3_8/sr3.data8 ONLINE+ 11 2642419712 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata2/sr3_9/sr3.data9 ONLINE+ 12 2705334272 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata2/sr3_10/sr3.data10 ONLINE+ 13 2684362752 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata3/sr3_11/sr3.data11 ONLINE+ 14 2705334272 10485760000 20971520 8192 3407883 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata3/sr3_12/sr3.data12 ONLINE+ 15 2684362752 10485760000 20971520 8192 3407883 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata3/sr3_13/sr3.data13 ONLINE+ 16 2747277312 10485760000 20971520 8192 3407883 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata3/sr3_14/sr3.data14 ONLINE+ 17 2936020992 10485760000 20971520 8192 3407883 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata3/sr3_15/sr3.data15 ONLINE+ 18 2852134912 10485760000 20971520 8192 3407883 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata4/sr3_16/sr3.data16 ONLINE+ 19 2915049472 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata4/sr3_17/sr3.data17 ONLINE+ 20 2642419712 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata4/sr3_18/sr3.data18 ONLINE+ 21 2747277312 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata4/sr3_19/sr3.data19 ONLINE+ 22 2726305792 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3 ONLINE+ /oracle/P01/sapdata4/sr3_20/sr3.data20 ONLINE+ 23 2558533632 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata1/sr3700_1/sr3700.data1 ONLINE+ 24 2579505152 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata1/sr3700_2/sr3700.data2 ONLINE+ 25 2579505152 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata1/sr3700_3/sr3700.data3 ONLINE+ 26 3040878592 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata1/sr3700_4/sr3700.data4 ONLINE+ 27 2936020992 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata2/sr3700_5/sr3700.data5 ONLINE+ 28 3019907072 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata2/sr3700_6/sr3700.data6 ONLINE+ 29 3019907072 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata2/sr3700_7/sr3700.data7 ONLINE+ 30 2998935552 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata2/sr3700_8/sr3700.data8 ONLINE+ 31 2810191872 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata3/sr3700_9/sr3700.data9 ONLINE+ 32 2789220352 10485760000 20971520 8192 3407883 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata3/sr3700_10/sr3700.data10 ONLINE+ 33 2726305792 10485760000 20971520 8192 3407883 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata3/sr3700_11/sr3700.data11 ONLINE+ 34 2684362752 10485760000 20971520 8192 3407883 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata3/sr3700_12/sr3700.data12 ONLINE+ 35 2684362752 10485760000 20971520 8192 3407883 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata4/sr3700_13/sr3700.data13 ONLINE+ 36 2621448192 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata4/sr3700_14/sr3700.data14 ONLINE+ 37 2621448192 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata4/sr3700_15/sr3700.data15 ONLINE+ 38 2600476672 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3700 ONLINE+ /oracle/P01/sapdata4/sr3700_16/sr3700.data16 ONLINE+ 39 2579505152 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3DB ONLINE+ /oracle/P01/sapdata4/sr3db_1/sr3db.data1 ONLINE+ 41 2097160192 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3DB ONLINE+ /oracle/P01/sapdata4/sr3db_2/sr3db.data2 ONLINE+ 42 2097160192 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3DB ONLINE+ /oracle/P01/sapdata4/sr3db_3/sr3db.data3 ONLINE+ 43 1048584192 10485760000 20971520 8192 3407884 FILE NOLINK


PSAPSR3USR ONLINE+ /oracle/P01/sapdata1/sr3usr_1/sr3usr.data1 ONLINE+ 40 20979712 10485760000 20971520 8192 3407881 FILE NOLINK


PSAPTEMP ONLINE# /oracle/P01/sapdata2/temp_1/temp.data1 ONLINE+ -1 2097160192 10485760000 20971520 8192 3407882 FILE NOLINK


PSAPUNDO ONLINE- /oracle/P01/sapdata3/undo_1/undo.data1 ONLINE+ 2 10485768192 10485760000 20971520 8192 3407883 FILE NOLINK


SYSAUX ONLINE+ /oracle/P01/sapdata1/sysaux_1/sysaux.data1 ONLINE+ 3 314580992 10485760000 20971520 8192 3407881 FILE NOLINK


SYSTEM ONLINE+ /oracle/P01/sapdata1/system_1/system.data1 SYSTEM+ 1 922755072 10485760000 20971520 8192 3407881 FILE NOLINK


BR0119I Redo log files


File Status Group Size Device Type Link


/oracle/P01/origlogA/log_g11m1.dbf INUSE 1 52429312 3407875 FILE NOLINK


/oracle/P01/mirrlogA/log_g11m2.dbf INUSE 1 52429312 3407877 FILE NOLINK


/oracle/P01/origlogB/log_g12m1.dbf INUSE 2 52429312 3407876 FILE NOLINK


/oracle/P01/mirrlogB/log_g12m2.dbf INUSE 2 52429312 3407878 FILE NOLINK


/oracle/P01/origlogA/log_g13m1.dbf INUSE 3 52429312 3407875 FILE NOLINK


/oracle/P01/mirrlogA/log_g13m2.dbf INUSE 3 52429312 3407877 FILE NOLINK


/oracle/P01/origlogB/log_g14m1.dbf INUSE 4 52429312 3407876 FILE NOLINK


/oracle/P01/mirrlogB/log_g14m2.dbf INUSE 4 52429312 3407878 FILE NOLINK


/oracle/P01/origlogA/log_g15m1.dbf INUSE 15 52429312 3407875 FILE NOLINK


/oracle/P01/mirrlogA/log_g15m2.dbf INUSE 15 52429312 3407877 FILE NOLINK


/oracle/P01/origlogB/log_g16m1.dbf INUSE 16 52429312 3407876 FILE NOLINK


/oracle/P01/mirrlogB/log_g16m2.dbf INUSE 16 52429312 3407878 FILE NOLINK


BR0120I Control files


File Size Device Type Link


/oracle/P01/origlogA/cntrl/cntrlP01.dbf 20824064 3407875 FILE NOLINK


/oracle/P01/origlogB/cntrl/cntrlP01.dbf 20824064 3407876 FILE NOLINK


/oracle/P01/sapdata1/cntrl/cntrlP01.dbf 20824064 3407881 FILE NOLINK


BR0982I Database disk volumes


Directory / Raw disk Device Total[KB] Free[KB] Used[%] MaxNeed[KB] MaxMiss[KB]


/oracle/P01/102_64 3407885 95420416 88532064 7.22 0 0


/oracle/P01 3407886 152043520 151753216 0.19 0 0


/oracle/P01/mirrlogA 3407877 4194304 4039716 3.69 0 0


/oracle/P01/mirrlogB 3407878 4194304 4039720 3.69 0 0


/oracle/P01/origlogA 3407875 4194304 4019364 4.17 0 0


/oracle/P01/origlogB 3407876 4194304 4019364 4.17 0 0


/oracle/P01/sapdata1 3407881 62914560 37836620 39.86 97832960 59996340


/oracle/P01/sapdata2 3407882 62914560 37138068 40.97 76634048 39495980


/oracle/P01/sapdata3 3407883 62914560 28435996 54.80 67932160 39496164


/oracle/P01/sapdata4 3407884 62914560 34334328 45.43 94310400 59976072


/oracle/P01/saparch 3407886 152043520 151753216 0.19 0 0


/oracle/P01/sapbackup 3407886 152043520 151753216 0.19 0 0


/oracle/P01/sapcheck 3407886 152043520 151753216 0.19 0 0


/oracle/P01/sapreorg 3407880 4194304 4193324 0.02 0 0


/oracle/P01/saptrace 3407886 152043520 151753216 0.19 0 0


/oracle/P01/oraarch 3407879 20971520 20269860 3.35 0 0


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.10


BR0814I Number of tables in schema of owner SAPSR3: 70104


BR0836I Number of info cube tables found for owner SAPSR3: 49


BR0814I Number of tables in schema of owner SAPSR3DB: 318


BR0814I Number of tables/partitions in schema of owner SYS: 621/189


BR0814I Number of tables/partitions in schema of owner SYSTEM: 134/27


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.19


BR0815I Number of indexes in schema of owner SAPSR3: 83844


BR0815I Number of indexes in schema of owner SAPSR3DB: 466


BR0815I Number of indexes/partitions in schema of owner SYS: 675/199


BR0815I Number of indexes/partitions in schema of owner SYSTEM: 175/32


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45


BR0816I Number of segments in schema of owner DBSNMP: 25


BR0816I Number of segments in schema of owner OPS$P01ADM: 1


BR0816I Number of segments in schema of owner OUTLN: 8


BR0816I Number of segments/LOBs in schema of owner SAPSR3: 158226/2139


BR0816I Number of segments/LOBs in schema of owner SAPSR3DB: 1012/114


BR0816I Number of segments/LOBs in schema of owner SYS: 1818/85


BR0816I Number of segments/LOBs in schema of owner SYSTEM: 353/22


BR0816I Number of segments in schema of owner TSMSYS: 4


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45


BR0961I Number of conditions found in DBCHECKORA: 118


BR0983I Tablespace fragmentation


Tablespace Files Tables Indexes Extents Total[KB] Used[%] Free[KB] FreeExt. MaxSize[KB] MaxAlloc[KB] Used[%] Free[KB] Largest[KB]


PSAPSR3 20 69791 83404 199079 53022720 99.97 18176 4 190730240+ 137707520+ 27.79+ 137725696+ 7741440+:7700480+:7680000+:7680000+:7659520+


PSAPSR3700 16 299 425 9856 43253760 99.93 29120 16 161935360+ 118681600+ 26.69+ 118710720+ 7720960+:7720960+:7720960+:7700480+:7680000+


PSAPSR3DB 3 318 466 1623 5120000 21.93 3997056 4 30720000+ 25600000+ 3.66+ 29597056+ 9216000+:8192000+:8192000+:1692608:1630144


PSAPSR3USR 1 14 15 29 20480 9.38 18560 1 10240000+ 10219520+ 0.02+ 10238080+ 10219520+:18560:0:0:0


PSAPTEMP 1 0 0 0 2048000 0.20 2043904 0 10240000+ 8192000+ 0.04+ 10235904+ 8192000+:0:0:0:0


PSAPUNDO 1 0 0 0 10240000 0.00 10239936 242 10240000 0 0.00 10239936 4063232:2566144:2113472:100352:74752


SYSAUX 1 252 282 2117 307200 88.00 36864 3 10240000+ 9932800+ 2.64+ 9969664+ 9932800+:35776:1024:64:0


SYSTEM 1 503 568 2839 901120 99.44 5056 1 10240000+ 9338880+ 8.75+ 9343936+ 9338880+:5056:0:0:0


Total: 44 71177 85160 215543 114913280 85.74 16388672 271 434585600 319672320 22.67 336060992 66424832:26238976:25707456:17173504:17044416


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45


BR0818I Number of tables found in DBDIFF for owner SAPSR3: 2


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45


BR0818I Number of tables found in DBSTATC for owner SAPSR3: 390


BR0962I Check conditions for database administration:


Pos. Act. Lev. Condition Object


Description


1 Y W ARCHIVER_STUCK


Out of space in archive directory - more than 90% space used


2 Y E CONTROL_FILE_MIRROR


Control file not mirrored


3 Y E CONTROL_FILE_MISSING


Control file missing on disk


4 Y W CRITICAL_FILE


File autoextend can cause file system overflow


5 Y W CRITICAL_SEGMENT


Segment can cause tablespace overflow - by allocating up to 2 next extent(s)


6 Y W CRITICAL_TABLESPACE


Tablespace files autoextend can cause file system overflow


7 Y E DATA_FILE_MISMATCH


Data file marked as missing in control file


8 Y E DATA_FILE_MISSING


Data file missing on disk


9 Y E FILE_OFFLINE


Database file offline


10 Y W FILE_SYSTEM_FULL


File system full - more than 99% space used


11 Y E HARMFUL_STATISTICS


Table or index has harmful optimizer statistics


12 Y E INVALID_FILE_TYPE


Invalid operating system file type


13 Y W IN_WRONG_TABLESPACE


Table or index in wrong tablespace


14 Y E MISSING_INDEX


Table has no index


15 Y E MISSING_STATISTICS


Table or index has no optimizer statistics


16 Y E NOARCHIVELOG_MODE


Database in NOARCHIVELOG mode


17 Y W PCTINCREASE_NOT_ZERO


PCTINCREASE value not equal zero


18 Y E REDOLOG_FILE_MIRROR


Redo log file not mirrored


19 Y E REDOLOG_FILE_MISSING


Redo log file missing on disk


20 Y W TABLESPACE_FULL


Tablespace full - more than 95% space used


21 Y W TABLESPACE_IN_BACKUP


Tablespace in backup mode


22 Y E TABLESPACE_OFFLINE


Tablespace offline


23 Y W TOO_MANY_EXTENTS


Segment has too many extents - more than 90% of MAXEXTENTS used


BR0963I Check conditions for database operations:


Pos. Act. Lev. Condition Description


1 Y W ARCHIVE_TOO_OLD Last successful archive log backup older than 10 days (or has not been run)


2 Y W BACKUP_TOO_OLD Last successful complete database backup older than 10 days (or has not been run)


3 Y W LAST_ARCHIVE_FAILED Last archive log backup failed


4 Y W LAST_BACKUP_FAILED Last complete database backup failed


5 Y W LAST_OPERATION_FAILED Last 'chk' operation failed


6 N W LAST_OPERATION_FAILED Last DBA operation failed


7 Y W LAST_STATS_FAILED Last update optimizer statistics failed


8 Y W OPERATION_TOO_OLD Last successful 'chk' operation older than 10 days (or has not been run)


9 N W OPERATION_TOO_OLD Last successful DBA operation older than 10 days (or has not been run)


10 Y W STATS_TOO_OLD Last successful update optimizer statistics older than 10 days (or has not been run)


BR0964I Check conditions for database messages:


Pos. Act. Lev. Message Description


1 Y W ORA-00060 Deadlock while waiting for resource


2 Y E ORA-00255 Error archiving log file


3 Y E ORA-00257 Archiver error


4 Y E ORA-00270 Error creating archive log


5 Y E ORA-00272 Error writing archive log


6 Y E ORA-00376 Database file cannot be read


7 Y E ORA-00447 Fatal error in background process


8 Y E ORA-00470 LGWR process terminated with error


9 Y E ORA-00471 DBWR process terminated with error


10 Y E ORA-00472 PMON process terminated with error


11 Y E ORA-00473 ARCH process terminated with error


12 Y E ORA-00474 SMON process terminated with error


13 Y E ORA-00600 Oracle internal error


14 Y E ORA-00603 Oracle server session terminated by fatal error


15 Y E ORA-01113 Data file needs media recovery


16 Y E ORA-01114 I/O error writing database file


17 Y E ORA-01115 I/O error reading database file


18 Y E ORA-01122 File verification check failed


19 Y E ORA-01135 Database file is offline


20 Y W ORA-01149 Cannot shutdown - data file in backup mode


21 Y W ORA-01555 Snapshot too old


22 Y W ORA-01562 Failed to extend rollback segment


23 Y E ORA-01578 Database block corrupted


24 Y E ORA-01628 Max. extents reached for rollback segment


25 Y E ORA-01629 Max. extents reached saving undo for tablespace


26 Y E ORA-01630 Max. extents reached in temp segment in tablespace


27 Y E ORA-01631 Max. extents reached in table


28 Y E ORA-01632 Max. extents reached in index


29 Y E ORA-01650 Unable to extend rollback segment in tablespace


30 Y E ORA-01651 Unable to extend save undo segment for tablespace


31 Y E ORA-01652 Unable to extend temp segment in tablespace


32 Y E ORA-01653 Unable to extend table in tablespace


33 Y E ORA-01654 Unable to extend index in tablespace


34 Y E ORA-01655 Unable to extend cluster in tablespace


35 Y E ORA-01656 Max. extents reached in cluster


36 Y E ORA-01680 Unable to extend LOB segment in tablespace


37 Y E ORA-01681 Max. extents reached in LOB segment in tablespace


38 Y E ORA-01683 Unable to extend index partition


39 Y E ORA-01684 Max. extents reached in table partition


40 Y E ORA-01685 Max. extents reached in index partition


41 Y E ORA-01688 Unable to extend table partition


42 Y E ORA-01691 Unable to extend lob segment in tablespace


43 Y E ORA-01692 Unable to extend lob segment partition in tablespace


44 Y E ORA-01693 Max. extents reached in lob segment


45 Y E ORA-01694 Max. extents reached in lob segment partition


46 Y E ORA-03113 End-of-file on communication channel


47 Y E ORA-07445 Exception encountered: core dump


48 Y E ORA-16014 Destination not available for archiving log file


49 Y E ORA-16038 Log file cannot be archived


50 Y E ORA-19502 Write error on log file


51 Y E ORA-19504 Failed to create log file


52 Y E ORA-19510 Failed to set size of blocks for file


53 Y E ORA-27044 Unable to write the header block of file


54 Y E ORA-27063 Number of bytes read/written is incorrect


55 Y E ORA-27072 File I/O error


56 Y E ORA-30036 Unable to extend segment in undo tablespace


57 Y W Checkpoint not complete


58 Y E Corrupt block


BR0965I Check conditions for database profile:


Pos. Act. Lev. Parameter Condition Value Unit


1 Y E COMPATIBLE <> 10.2.0


2 Y W CONTROL_FILE_RECORD_KEEP_TIME < 30


3 Y E DB_BLOCK_SIZE <> 8192


4 Y W DB_FILES < 254


5 Y W DB_FILE_MULTIBLOCK_READ_COUNT


6 Y E FILESYSTEMIO_OPTIONS <> SETALL


7 Y W LOG_ARCHIVE_START


8 Y W LOG_BUFFER >< 14234,624 K


9 Y W LOG_CHECKPOINTS_TO_ALERT <> TRUE


10 Y W MAX_DUMP_FILE_SIZE >< 100000,10000


11 Y W OPEN_CURSORS >< 2000,800


12 Y W OPTIMIZER_FEATURES_ENABLE


13 Y W OPTIMIZER_INDEX_COST_ADJ <> 20


14 Y W OPTIMIZER_MODE


15 Y W PARALLEL_EXECUTION_MESSAGE_SIZE >< 16384,4096


16 Y W PARALLEL_THREADS_PER_CPU >< 2,1


17 Y E QUERY_REWRITE_ENABLED <> FALSE


18 Y E RECYCLEBIN <> OFF


19 Y E REMOTE_OS_AUTHENT <> TRUE


20 Y E REPLICATION_DEPENDENCY_TRACKING <> FALSE


21 Y W SHARED_POOL_SIZE < 400 M


22 Y W STAR_TRANSFORMATION_ENABLED <> TRUE


23 Y W STATISTICS_LEVEL


24 Y W TIMED_STATISTICS


25 Y W TRACE_ENABLED


26 Y E UNDO_MANAGEMENT <> AUTO


27 Y W UNDO_TABLESPACE <> PSAPUNDO


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45


BR0807I Name of database instance: P01


BR0808I BRCONNECT action ID: cejqydjo


BR0809I BRCONNECT function ID: chk


BR0810I BRCONNECT function: check


BR0951I Number of active/inactive check conditions for database administration: 23/0


BR0952I Number of active/inactive check conditions for database operations: 8/2


BR0953I Number of active/inactive check conditions for database messages: 58/0


BR0954I Number of active/inactive check conditions for database profile: 27/0


BR0960I Last successful BRCONNECT check run: cejqtfol.chk 2012-10-14 23.00.03


BR0126I Unattended mode active - no operator confirmation required


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45


BR0969I Checking database administration...


BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3407881) 38256640 KB (> 37836620 KB)


BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3407882) 37990400 KB (> 37138068 KB)


BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3407883) 37601280 KB (> 28435996 KB)


BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3407884) 37928960 KB (> 34334328 KB)


BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 4 files on disk 3407883) 30330880 KB (> 28435996 KB)


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.46


BR0972I Checking database operations...


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.46


BR0974I Checking database messages in /oracle/P01/saptrace/background/alert_P01.log ...


BR0976W Database message alert - level: WARNING, line: 5514984, time: 2012-10-15 00.05.47, message:


Checkpoint not complete


BR0976W Database message alert - level: WARNING, line: 5515002, time: 2012-10-15 00.05.57, message:


Checkpoint not complete


BR0976W Database message alert - level: WARNING, line: 5515020, time: 2012-10-15 00.06.16, message:


Checkpoint not complete


BR0976W Database message alert - level: WARNING, line: 5515038, time: 2012-10-15 00.06.32, message:


Checkpoint not complete


BR0976W Database message alert - level: WARNING, line: 5515056, time: 2012-10-15 00.06.47, message:


Checkpoint not complete


BR0976W Database message alert - level: WARNING, line: 5515074, time: 2012-10-15 00.07.03, message:


Checkpoint not complete


BR0976W Database message alert - level: WARNING, line: 5515092, time: 2012-10-15 00.07.18, message:


Checkpoint not complete


BR0976W Database message alert - level: WARNING, line: 5515110, time: 2012-10-15 00.07.33, message:


Checkpoint not complete


BR0976W Database message alert - level: WARNING, line: 5515128, time: 2012-10-15 00.07.48, message:


Checkpoint not complete


BR0976W Database message alert - level: WARNING, line: 5515146, time: 2012-10-15 00.08.03, message:


Checkpoint not complete


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.49


BR0977I Checking database profile...


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.49


BR0980I Number of changed database profile parameters: 0


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.50


BR0955I Number of signaled error/warning/exception alerts for database administration: 0/5/0


BR0956I Number of signaled error/warning/exception alerts for database operations: 0/0/0


BR0957I Number of signaled error/warning/exception alerts for database messages: 0/10/0


BR0958I Number of signaled error/warning/exception alerts for database profile: 0/0/0


BR0806I End of BRCONNECT processing: cejqydjo.chk 2012-10-15 23.00.50


BR0280I BRCONNECT time stamp: 2012-10-15 23.00.50


BR0803I BRCONNECT completed successfully with warnings


Regards,

Sanju M S