ORA-27140: attach to post/wait facility failed

[Former Member]

Hi

We are facing following probelm on hp 11i /oracle 9i system

##ORA-27140: attach to post/wait facility failed

Details Log As Below

-

---

BR0002I BRARCHIVE 6.40 (15)

BR0006I Start of offline redo log processing: adqqukeg.sve 2005-08-20 11.59.10

BR0280I BRARCHIVE time stamp: 2005-08-20 11.59.10

BR0301W SQL error -27140 at location BrDbConnect-2

ORA-27140: attach to post/wait facility failed

BR0310W Connect to database instance UX1 failed

BR0280I BRARCHIVE time stamp: 2005-08-20 11.59.10

BR0301W SQL error -27140 at location BrDbConnect-2

ORA-27140: attach to post/wait facility failed

BR0310W Connect to database instance UX1 failed

BR0278W Command output of '/oracle/UX1/920_64/bin/sqlplus':

SQL*Plus: Release 9.2.0.6.0 - Production on Sat Aug 20 11:59:10 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> Connected to an idle instance.

SQL> ORA-01034: ORACLE not available

SQL> Disconnected

BR0280I BRARCHIVE time stamp: 2005-08-20 11.59.10

BR0279W Return code from '/oracle/UX1/920_64/bin/sqlplus': 0

BR0302W SQLPLUS call for database instance UX1 failed

BR0323W 'Archive log list' for database instance UX1 failed

BR0019W Volume size or disk capacity reached - not all offline redo log files will be saved

BR0280I BRARCHIVE time stamp: 2005-08-20 11.59.10

BR0008I Offline redo log processing for database instance: UX1

BR0009I BRARCHIVE action ID: adqqukeg

BR0010I BRARCHIVE function ID: sve

BR0048I Archive function: save

BR0011I 34 offline redo log files found for processing, total size 1160.301 MB

BR0112I Files will not be compressed

BR0130I Backup device type: tape

BR0102I Following backup device will be used: /dev/rmt/0mn

BR0103I Following backup volume will be used: UX1A01

BR0280I BRARCHIVE time stamp: 2005-08-20 11.59.10

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

If any one know this error

[Former Member]

Hi,

Th following is the solution for this error.

"BR0019W Volume size or disk capacity reached - not all offline redo log files will be saved".

First check and compare the size of your DB and tape volume size.

Then in the backup profile, edit the parameter as follows.

tape_size = <size of your DB in MB + 50,000 MB)

This should work.

Regards,

Sandeep

[Former Member]

we solved the problem by resetting the permissions on the oracle executable as described underneath in the first solution mentioned.

The error ora-27140 is due to the lack accessibility to oracle

executables.

1. Please make sure that all oracle executables has permission as per

the note mentioned below.

583861 UNIX: Errors due to Oracle executable

(chmod 6751 oracle) Owner ORA<SID>

2. If the problem is not solved with this, please download the latest

patch level of the BR*tools as per SAP note 12741.

" Check the owner, the group and the permissions for sapdba and the br*

tools as described in Note 113747.

(Up to 4.6D, the same settings were valid for sapdba as for brarchive

and brbackup, but this has changed with the transfer of the command lin options to brconnect.)

File libsbt.* is a dynamic backup library (DLL). By default, it is not

used. For more information about this library, see Note 142635. The

settings for this are:

-rwxr-xr-x <sid>adm sapsys ... libsbt.*"

[Former Member]

did you get a response to this? I am having the same issue on a server I copied to another server

[Former Member]

We've got the same with db13 jobs (user <sid>adm>). However with ora<sid> the same commands (for example brconnect -u / -c -f check) on the server ends without any error. R3trans -d works fine for user <sid>adm.

Only one instance in the landscape reacts as told. All other sid's are doing allright.