connect external oracle 10g database

[Former Member]

Hi,

I try to connect my sapR/3 to an external oracle10g database xx

I follow all from the note 339092.

Form other threat i use se38 and test connection with ADBC_TEST_CONNECTION program.

The result:

ORA-12154 TNS:could not resolve the connect identifier specified

DBCO is configured:

DB Connection: DBXX

DBMS : ORA

User name : useryy

DB password : pasword useryy for DBXX

tnsname.ora

DBXX.WORLD =

(DESCRIPTION =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = servernumber )(PORT = 1527))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SID = DBXX)

)

)

ORACLE_HOME is

oracle/SAP/102_64

Can we need to include something else?

[Former Member]

Hi,

I try to connect my sapR/3 to an external oracle10g database xx

I follow all from the note 339092.

Form other threat i use se38 and test connection with ADBC_TEST_CONNECTION program.

The result:

ORA-12154 TNS:could not resolve the connect identifier specified

DBCO is configured:

DB Connection: DBXX

DBMS : ORA

User name : useryy

DB password : pasword useryy for DBXX

tnsname.ora

DBXX.WORLD =

(DESCRIPTION =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = servernumber )(PORT = 1527))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SID = DBXX)

)

)

ORACLE_HOME is

oracle/SAP/102_64

Can we need to include something else?

[Former Member]

Hi,

Check this url:

http://saptechno.blogspot.com/2008/07/how-to-connect-to-external-database.html

Read this:

Using transaction SE11, create a table (ZTABLE) with the same fields as the table in the external database, make sure that the type and lengths of the fields are identical.

Using transaction SE11, create a view (ZTABLE_VIEW, projection view) using BASIS table ZTABLE

Using SVRMGRL>

create dblink REMOTE_DB as connect to remote_user identified by password; (database link created)

drop table ZTABLE; (table dropped)

create synonym ZTABLE for ZTABLE@REMOTE_DB; (synonym created)

Using transaction SE16 , type in ZTABLE_VIEW and hit RETURN

Enter value in key fields and hit execute. (displays rows from the remote table)

http://saptechno.blogspot.com/2008/07/how-to-connect-to-external-database.html

[Former Member]

Thanks for the help, we found a problem into tnsnames we fixed and connection is running now.