Skip to Content
author's profile photo Former Member
Former Member

DB13 Jobs are Failing and Brconnect does not work

Hello Everyone,

We have a 4.6C system running on AIX with Oracle DB and we upgraded the DB from 9.2.0.7 to 10.2.0.2 and i noticed that brconnect is not working for sidadm but it works for orasid...I have checked permissions for brconnect in exe directory and they are set correctly...and i followed a SAP note where it tells to download the sapdba_role .. Note Num 134592.. but still no luck.. When i execute Brconnect it comes back with this following error

brconnect -c -u / -f check

BR0801I BRCONNECT 7.00 (34)

BR0805I Start of BRCONNECT processing: cdyooddr.chk 2008-08-12 08.03.23

BR0484I BRCONNECT log file: /oracle/PSO/sapcheck/cdyooddr.chk

BR0280I BRCONNECT time stamp: 2008-08-12 08.03.23

BR0301E SQL error -27140 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

BR0310E Connect to database instance PSO failed

BR0280I BRCONNECT time stamp: 2008-08-12 08.03.23

BR0301E SQL error -27140 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

BR0310E Connect to database instance PSO failed

BR0806I End of BRCONNECT processing: cdyooddr.chk 2008-08-12 08.03.23

BR0280I BRCONNECT time stamp: 2008-08-12 08.03.23

BR0804I BRCONNECT terminated with errors

Has anyone come across this error.

Regards,

Ershad Ahmed

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Aug 12, 2008 at 01:19 PM

    Please check if $ORACLE_HOME/bin/oracle has the correct permissions.

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 01:25 PM

    OSS Note 651351 ,583861

    It will help you.

    Thanks

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 01:31 PM

    Hello Markus...

    Thank you for the Solution now Brconnect is working fine..

    This was the solution

    I checked permissions in /oracle/SID/102_64/bin/oracle and had to change the permissons of oracle to

    -rwsr-s--x 1 orasid dba Jul 31 02:10 oracle

    Regards,

    Ershad Ahmed,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.