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