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