Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 13, 2011 at 04:13 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • avatar image
    Former Member
    Jan 14, 2011 at 09:14 AM

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

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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)...

  • Aug 26, 2013 at 01:44 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded