CheckDb failed after Oracle Upgrade 10.2.0.4 to 11.2.0.1 on Windows 2008 64

[baby_fabrice]

Hello,

I have finished the upgrade database.

I have try to execute a DBcheck by the DB02 transaction.

The job stop immediatly and here the log :

13.01.2011 14:40:58 Job started

13.01.2011 14:40:58 Step 001 started (program RSDBAJOB, variant &0000000000003, user ID *******)

13.01.2011 14:40:58 Exécution de la commande logique BRCONNECT Sur machine *******

13.01.2011 14:40:58 Paramètres : -u / -jid CHECK20110113144058 -c -f check

13.01.2011 14:40:59 BR0801I BRCONNECT 7.20 (10)

13.01.2011 14:40:59 BR0252E Function CreateFile() failed for 'D:oracleSLM112databasespfileSLM.ora' at location BrFileStatGet-2

13.01.2011 14:40:59 BR0253E errno 5: Access is denied.

13.01.2011 14:40:59 BR0273E Determination of file status for D:oracleSLM112databasespfileSLM.ora failed

13.01.2011 14:40:59

13.01.2011 14:40:59 BR0806I End of BRCONNECT processing: ceezrvck.log2011-01-13 14.40.58

13.01.2011 14:40:59 BR0280I BRCONNECT time stamp: 2011-01-13 14.40.59

13.01.2011 14:40:59 BR0804I BRCONNECT terminated with errors

13.01.2011 14:40:59 External program terminated with exit code 3

13.01.2011 14:40:59 BRCONNECT returned error status E

13.01.2011 14:40:59 Job finished

I have check on SDN and i found this thread witch is the same but on Oracle 10g.....Is there a similar Patch file for Oracle 11? Maybe there is something to do...in order to solve this case.

Thx in advance

Regards

[alexey_chinyaev]

This message was moderated.

[Former Member]

Adopt the OPS$ mechanism according to SAP Note 50088 (Windows) and 400241 (for Unix).

Regards,

Nick Loy

[baby_fabrice]

First Thanks all for your help.

My OS is window 2008 x86-64 bit.

Nick, i already have OPS$ user in database.

I don't understand why i have to adopt this mecanism ( he is already in used since i have installed the SAP product with Oracle 10g and i'm supose he is always witht the upgraded database 11g)...

[Former Member]

Check below error: looks like no permission to <SID>adm on folder D:\oracle\SLM\112\database\

>>13.01.2011 14:40:59 BR0252E Function CreateFile() failed for 'D:\oracle\SLM\112\database\spfileSLM.ora' at location BrFileStatGet-2

>>13.01.2011 14:40:59 BR0253E errno 5: Access is denied.

[baby_fabrice]

I have check the permission for me it 's ok

All the folder under oracle have full permission with the group "administrators" and SLMadm is in group administrators.

At one time i have think that it's coming because of the CAPS inside the file spfileSLM.ora ( at the start he was with full CAPS : SPFILESLM.ORA) but after i have change it (and restart the database and sap) the result is the same...

I have made a Full backup with BRtools by command line with succes.

Here is the result if 'im doing the checkDB by Brtools:

BR0801I BRCONNECT 7.20 (10)

BR0477I Oracle pfile D:\oracle\SLM\112\database\initSLM.ora created from spfile

D:\oracle\SLM\112\database\spfileSLM.ora

BR0805I Start of BRCONNECT processing: ceezslwt.chk 2011-01-13 17.50.03

BR0484I BRCONNECT log file: D:\oracle\SLM\sapcheck\ceezslwt.chk

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.11

BR0813I Schema owners found in database SLM:

APPQOSSYS, DBSNMP, DIP, OPS$ADB\SAPSERVICESLM, OPS$ADB\SAPSERVICESR3, OPS$ADB\SL

MADM, ORACLE_OCM, OUTLN, SAPSR3*, SAPSR3DB%,

SYS, SYSTEM

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.17

BR0814I Number of tables in schema of owner SAPSR3: 32309

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

BR0814I Number of tables in schema of owner SAPSR3DB: 356

BR0814I Number of tables/partitions in schema of owner SYS: 896/138

BR0814I Number of tables/partitions in schema of owner SYSTEM: 146/39

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.27

BR0815I Number of indexes in schema of owner SAPSR3: 42500

BR0815I Number of indexes in schema of owner SAPSR3DB: 509

BR0815I Number of indexes/partitions in schema of owner SYS: 957/145

BR0815I Number of indexes/partitions in schema of owner SYSTEM: 206/52

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.31

BR0816I Number of segments in schema of owner APPQOSSYS: 2

BR0816I Number of segments in schema of owner DBSNMP: 38

BR0816I Number of segments in schema of owner OPS$ADB\SLMADM: 1

BR0816I Number of segments in schema of owner OUTLN: 9

BR0816I Number of segments/LOBs in schema of owner SAPSR3: 79017/2104

BR0816I Number of segments/LOBs in schema of owner SAPSR3DB: 1135/135

BR0816I Number of segments/LOBs in schema of owner SYS: 2329/129

BR0816I Number of segments/LOBs in schema of owner SYSTEM: 390/19

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.31

BR0961I Number of conditions found in DBCHECKORA: 118

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.31

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

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.31

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

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.31

BR0807I Name of database instance: SLM

BR0808I BRCONNECT action ID: ceezslwt

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: ceezsaho.chk 2011-01-13 15.39.32

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.31

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

c

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.46

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.46

BR0969I Checking database administration...

BR0970W Database administration alert - level: WARNING, type: ARCHIVER_STUCK, ob

ject: D:\oracle\SLM\oraarch, value: 95.92% (> 90%)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, obj

ect: D:\ORACLE\SLM\SAPDATA4\SR3DB_3\SR3DB.DATA3, value: (max_extn) 9216000 KB (>

8562732 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, obj

ect: D:\ORACLE\SLM\SAPDATA4\SR3USR_1\SR3USR.DATA1, value: (max_extn) 10219520 KB

(> 8562732 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, obj

ect: D:\ORACLE\SLM\SAPDATA1\TEMP_1\TEMP.DATA1, value: (max_extn) 9226240 KB (> 8

562732 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, obj

ect: D:\ORACLE\SLM\SAPDATA1\SYSAUX_1\SYSAUX.DATA1, value: (max_extn) 9973760 KB

(> 8562732 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, obj

ect: D:\ORACLE\SLM\SAPDATA1\SYSTEM_1\SYSTEM.DATA1, value: (max_extn) 9635840 KB

(> 8562732 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPAC

E, object: PSAPSR3, value: (max_extn of 10 files on disk 3) 68546560 KB (> 85627

32 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPAC

E, object: PSAPSR3DB, value: (max_extn of 3 files on disk 3) 25600000 KB (> 8562

732 KB)

[baby_fabrice]

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.47

BR0972I Checking database operations...

BR0973W Database operation alert - level: WARNING, operation: Archive log backup

, condition: Operation too old or has not been run in clean-up period

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.47

BR0974I Checking database messages in d:\oracle\slm\saptrace\diag\rdbms\slm\slm\

trace\alert_slm.log ...

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.47

BR0977I Checking database profile...

BR0978W Database profile alert - level: ERROR, parameter: COMPATIBLE, value: 11.

2.0 (<> 10.2.0)

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 6

848512 (>< 4096,512 KB)

BR0978W Database profile alert - level: WARNING, parameter: MAX_DUMP_FILE_SIZE,

value: UNLIMITED (>< 100000,10000)

BR0978W Database profile alert - level: ERROR, parameter: REMOTE_OS_AUTHENT, val

ue: FALSE (<> TRUE)

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.47

BR0980I Number of changed database profile parameters: 0

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.47

BR0955I Number of signaled error/warning/exception alerts for database administr

ation: 0/8/0

BR0956I Number of signaled error/warning/exception alerts for database operation

s: 0/1/0

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

0/0/0

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

2/2/0

BR0806I End of BRCONNECT processing: ceezslwt.chk 2011-01-13 17.50.47

BR0280I BRCONNECT time stamp: 2011-01-13 17.50.47

BR0803I BRCONNECT completed successfully with warnings

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 1

BR0280I BRTOOLS time stamp: 2011-01-13 17.50.47

BR0668I Warnings or errors occurred - you can continue to ignore them or go back

to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2011-01-13 17.50.56

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2011-01-13 17.50.56

BR0656I Choice menu 12 - please make a selection

-

---

I don't see why by the DB02 the CheckDB failed....and not by brtools.

Edited by: BABY Fabrice on Jan 14, 2011 7:57 AM

[nirmal_konchada]

Hi,

What is your OS???

If its Unix flavour then kindly make sure that oraSID has rights to 'D:\oracle\SLM\112\database\spfileSLM.ora'

Regards,

Nirmal.K

[nirmal_konchada]

Hi,

This is a known problem with windows......

Check the following note

SAP note 1173159 - Solution

Note 1292339 - 10.2: DBUA changes file access authorizations during upgrade

Regards,

Nirmal.K

[baby_fabrice]

Thx nirmal konchada.

I know this SAP note but the patch attached to this note is for Oracle 10g and now i'm with ORacle 11...i don't think i can use it...

Edited by: BABY Fabrice on Jan 14, 2011 10:33 AM

Edited by: BABY Fabrice on Jan 14, 2011 10:33 AM

[Former Member]

Thanks Nirmal,

You are correct, your hint solved my issue, it is user permission problem on that particular file.

Our host is windows, we just added SAPServiceSID user to this file and our problem got solved.

Many thanks,

Mohan.