oracle remort database connection error - TechRepublic
Question
April 19, 2008 at 04:05 AM
durga.pf

oracle remort database connection error

by durga.pf . Updated 18 years, 2 months ago

when i am connecting the oracle remort database ex- suppose now i am in mechine1 & here the dbname/sid is orcl and from this(orcl) database i want to connect another db name as “cesu” as scott/tiger@cesu from orcl database.

For this i was 1st go to the directory H:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN and open the ”tnsnames.ora” file and copy the network configuration file & peast bellow & chenge the remort database HOST name & SERVICE_NAME name.

After that when i try to connect the oracle of cesu database then it shows the following error message

SQL> conn scott/tiger@cesu
ERROR:
ORA-12170: TNS:Connect timeout occurred

This discussion is locked

All Comments