BRCONNECT returned error status E

[Former Member]

Below is my Developmwnt platform

Windows NT

Oracle 8.1.7

SAP R/3 4.6C

When I am trying to run Check DB..I am getting the following error.Please help me to resolve this.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000009, user name BASIS)

Execute logical command BRCONNECT On host alstdev

Parameters: -u / -c -f check

BR801I BRCONNECT 6.10 (76)

BR805I Start of BRCONNECT processing: cdxiuimv.chk 2008-02-26 18.50.45

BR280I Time stamp 2008-02-26 18.50.47

BR301E SQL error -12540 at location db_connect-2

ORA-12540: TNS:internal limit restriction exceeded

BR310E Connect to database instance ALD failed

BR280I Time stamp 2008-02-26 18.50.47

BR301E SQL error -12540 at location thr_db_connect-4

ORA-12540: TNS:internal limit restriction exceeded

BR310E Connect to database instance ALD failed

BR806I End of BRCONNECT processing: cdxiuimv.chk 2008-02-26 18.50.47

BR280I Time stamp 2008-02-26 18.50.47

BR804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Regds,

Mofizur

[Former Member]

Hi read this Note 513524 it is about your problem.

Regards. Award if helpful.

[stefan_koehler]

Hello Mofizur,

you have to check the listener.log for more information ... it should contain the regarding OS error.

Possible errors:

• No more memory

• Out of network ports (sockets)

• Process limit reached

......

Regards

Stefan

[Former Member]

Hello Satadal,

The error is due to Oracle the reasons could be:

1. Number of open connection that Oracle Net can process simultaneously

2. Number of memory buffers which can be used simultaneously

3.Number of processes a particular database instance is allowed

In case of 1 and 2 its a harware bottle neck

In case of the 3rd point the number of process that the OraTNSlistener can listen to can be increased in the Initsid.ora file (but since this is for SAP i would suggest init<DBSID>.ora file.

But either ways check the logs files sqlnet.log or listener.log

for details of the error.

In most cases waiting for the open connections to close and then trying BRCONNECT should do it.

Regards,

Prashant