Skip to Content

ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154

Hi,</br>

</br>

Our QAS system is DRQ.</br>

Our PRD system is DRP.</br>

</br>

External non-sap oracle DB is MENP, MEBP, MEPP, MEDP.</br>

</br>

MENP, MEBP, MEPP is registed the past.</br>

MEDP is registered newly.</br>

</br>

DRQ and DRP is registered "tnsnames.ora" file and TA DBCO with same

information.</br>

</br>

In DRQ,</br>

"tnsping MENP" is OK and "ADBC_TEST_CONNECTION" program is OK.</br>

"tnsping MEBP" is OK and "ADBC_TEST_CONNECTION" program is OK.</br>

"tnsping MEPP" is OK and "ADBC_TEST_CONNECTION" program is OK.</br>

"tnsping MEDP" is OK and "ADBC_TEST_CONNECTION" program is OK.</br>

</br>

In DRP,</br>

"tnsping MENP" is OK and "ADBC_TEST_CONNECTION" program is OK.</br>

"tnsping MEBP" is OK and "ADBC_TEST_CONNECTION" program is OK.</br>

"tnsping MEPP" is OK and "ADBC_TEST_CONNECTION" program is OK.</br>

"tnsping MEDP" is OK and "ADBC_TEST_CONNECTION" program is ERROR.</br>

</br>

It's same "tnsnaems.ora" file information of DRQ and DRP.</br>

I'm check up again and again.</br>

</br>

Despite the same information, DRP appear ERROR.</br>

</br>

In DRQ and DRP,</br>

sqlnet.ora, listener.ora, tnsnames.ora file is all same.</br>

</br>

I draw a comparison between DRQ and DRP.</br>

I check up again and again.</br>

</br>

</br>

-


Trace Data dev_w3 of DRP----


</br>

B Wed Oct 7 10:12:31 2009</br>

B Connect to MEDP as m60user with MEDP</br>

C got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment</br>

C Client NLS settings:</br>

C Connecting as m60user/<pwd>@MEDP on connection 1 (nls_hdl 0) ...</br>

(dbsl 640 070208)</br>

C Nls CharacterSet NationalCharSet C</br>

EnvHp ErrHp ErrHpBatch</br>

C 0 UTF8 1</br>

0x6000000003c16650 0x6000000003c29108 0x6000000003c28b18</br>

C Attaching to DB Server MEDP</br>

(con_hdl=1,svchp=0x60000000052c0d80,srvhp=0x60000000064884b8)</br>

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154</br>

[dboci.c 4289]</br>

C *** ERROR => CONNECT failed with sql error '12154'</br>

[dbsloci.c 11410]</br>

B ***LOG BY2=> sql error 12154 performing CON [dbds#3 @</br>

1044] [dbds 1044 ]</br>

B ***LOG BY0=> ORA-12154: TNS:could not resolve service name [dbds#3 @</br>

1044] [dbds 1044 ]</br>

B ***LOG BY1=> sql error 12154 [dbacds#2 @ 1317] [dbacds 1317 ]</br>

-


</br>

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 07, 2009 at 05:24 AM

    Have a look at SAP note 443867 - its focus is exactly on the oracle connection error you mentioned.

    Something seems to be wrong with your tnsnames.ora or sqlnet.ora. Can you provide its content?

    Also please check that none of the lines used within those two files for the connection definition have a line feed. It might seem that the line is complete but actually oracle cannot use it due to the line feed.

    Add comment
    10|10000 characters needed characters exceeded