Skip to Content
avatar image
Former Member

Connect to database instance PRD Failed

Hi,

We had refreshed our SCM quality system last month with production data, since then we are facing problem in BR connect operations like CheckDB, Verif DB, cleanup logs and update stats . When we schedule these operation using DB13 then we get an error "Connect to database instance PRD failed", but when try to run this manually by clicking excute immediately button then these operations complete succesfully.

Can you please help on this ?

Our version details are as below.

SCM 5.0

Oracle Release 10.2.0.2.0

Thanks,

Chetan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 25, 2009 at 08:50 AM

    Problems with the OPS$ mechanism? Check SAPNotes 400241 and 50088...

    Also check the output of

    > R3trans -d

    use <sid>adm on os level...

    GreetZ, AH

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2009 at 09:19 AM

    Hi,

    As above you need to delete the SAPUSER table associated with the old SID then re-create as in the notes mentioned....

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2009 at 10:06 AM

    Thanks both, this has worked for time being, let me again monitor it tomorrow, thanks once again for your help

    Add comment
    10|10000 characters needed characters exceeded