Connecting to external Databse

[Former Member]

Dear All,

I'm trying to connect my SAP server which is on Oracle 10g to an external database i.e. oralce 9i.

I have created the entry in DBCO and given changed the tnsnames.ora, but still i'm facing error as given below:

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 08.03.2010 14:59:26

Short text

SQL error in the database when accessing a table.

What can you do?

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

How to correct the error

Database error text........: "ORA-12514: TNS:listener does not currently know

of service requested in connect descriptor"

Internal call code.........: "[RSQL/178/YCST_SMS_ALERT ]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"YCSI_BREAKDOWN_MAINTENANCE" or "YCSI_BREAKDOWN_MAINTENANCE"

"POST_MSG"

Regards,

Raj

[lbreddemann]

> Database error text........: "ORA-12514: TNS:listener does not currently know

> of service requested in connect descriptor"

> Internal call code.........: "[RSQL/178/YCST_SMS_ALERT ]"

> Please check the entries in the system log (Transaction SM21).

The connection details in DBCO aren't correct!

Make sure the TNSLISTENER actually knows the database you want to connect to.

regards,

Lars

[Former Member]

In continuation with Lars input, below some more

1.ping the ip or hostname of the target server from the source whether two system are not having network problems.

2.you can tnsping <service name> from you oracle 10g from the respective ora<sid> user and find out whether service is getting ping or not

3.if you have specified hostname in the tnsnames, check whether the host name is specified in /etc/hosts file.

4. lsnrctl status from ora<sid>, if no listener service is running, lsnrctl start

cheers

[lbreddemann]

Sorry - but I've to correct some things here...

>

> In continuation with Lars input, below some more

>

> 1.ping the ip or hostname of the target server from the source whether two system are not having network problems.

The network does seem to be OK since the error message is the reply from the target TNSLISTENER.

> 2.you can tnsping <service name> from you oracle 10g from the respective ora<sid> user and find out whether service is getting ping or not

TNSPING is a utility that checks the name resolution - not the network connectivity or the availability of the database.

Also it's not included in the SAP delivery of the Oracle client - so it has to be used from the database server.

> 3.if you have specified hostname in the tnsnames, check whether the host name is specified in /etc/hosts file.

Again: it's not about the network connectivity here.

> 4. lsnrctl status from ora<sid>, if no listener service is running, lsnrctl start

There is a listener running - otherwise the error message would have been a different one.

regards,

Lars

[Former Member]

I'm able to ping the service name using tnsping.

Please leme know any changes need to be done in external DB.

Regards,

Raj

[lbreddemann]

>

> I'm able to ping the service name using tnsping.

Ok, now make sure that the TNSNAMES.ORA file you used for your test is the same the sap application server uses!

> Please leme know any changes need to be done in external DB.

The external DB should be left as it is.

Check the connection details used in DBCON!

Check the workprocess developer trace file.

regards,

Lars

[Former Member]

tnsnames.ora is same as my SAP application is using.

settings in DBCO is fine.

Regards,

Raj

[former_member204746]

what is your OS? where is located tnsnames.ora?

[Former Member]

OS is AIX 5.3

And there are 2 tnsnames.ora files exist one is in /oracle/<SID>/102/nework/admin and the other is /sapmnt/<SID>/profile/oralce

from netweaver this file exists in two locations.

I've made the changes in both locations.

Regards,

Raj

[former_member204746]

have you setup environment variable TNS_ADMIN ?

[Former Member]

yes I DO.

[former_member204746]

The path in TNS_ADMIN points to the tnsnames.ora file that will be used.

check TNS_ADMIN variable for user [sid]adm.