SAP Database link - Urgent

[brhynold]

Does anyone out there know how to create a database link in a SAP database to another Oracle database. We are trying to go live with a new application at midnight tonight and the SAP administrator is on vacation and didn't leave instructions with his juniors on how to create this link.

Thanks

[mauric]

edit the tnsnames.ora on your $ORACLE_HOME/network/admin
and try it with command tnsping <connect_string>

after this you be able to create a database link from your schema with a comand:

SQL>create database link <name_of_database_link> connect to <user>
identified by <password> using '<connect_string>';

hope this helps

[mauric]

edit the tnsnames.ora on your $ORACLE_HOME/network/admin
and try it with command tnsping <connect_string>

after this you be able to create a database link from your schema with a comand:

SQL>CREATE DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string';


hope this helps