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

[Former Member]

Hello All,

We have ECC 6 with

Database Oracle: 10.2.0.2.0

OS: HP-UX

We are facing problem while running Check and Update Optimizer Statistics in DB13. The Job Log says

Job started

Step 001 started (program RSDBAJOB, variant &0000000000003, user ID LARJHD01)

Execute logical command BRCONNECT On host madsappr

Parameters: -u / -jid STATS20090519130903 -c -f stats -t ALL

SXPG_COMMAND_EXECUTE(LONG)

COMMANDNAME = BRCONNECT

OPERATINGSYSTEM = ANYOS

TARGETSYSTEM = madsappr

DESTINATION =

BR0801I BRCONNECT 7.00 (24)

BR0805I Start of BRCONNECT processing: ceapnjyf.sta 2009-05-19 13.09.05

BR0484I BRCONNECT log file: /oracle/PRD/sapcheck/ceapnjyf.sta

BR0280I BRCONNECT time stamp: 2009-05-19 13.09.07

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 PRD failed

BR0280I BRCONNECT time stamp: 2009-05-19 13.09.07

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 PRD failed

BR0806I End of BRCONNECT processing: ceapnjyf.sta2009-05-19 13.09.07

BR0280I BRCONNECT time stamp: 2009-05-19 13.09.07

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Please throw some light on this error.

=Alex Daniel=

[Former Member · Accepted solution]

Hi,

Please check below links.

http://ora-exp.blogspot.com/2006/12/solution-of-ora-27140-attach-to.html

Thanks,

Sushil

[Former Member · Accepted solution]

Thanks Sushil It worked!!!

Gave you full points.

=Alex=