where is your orant resite open this file
supose orant in c drive
C:ORANTNET80ADMINTNSNAMES.ORA
copy this Script and add it to the end of file TNSNAMES.ORA
note:
open this file by text file
---------------------------------------------------------
database_name.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = database_name.)
)
)
database_name change this by your database name
and change host by your server name or where your database resite by PC Name or IP address
for that computer
best Regards
Haytham Hamdon -Khartoum-Suadn
Last Wiki Answer Submitted: December 18, 2008 8:19 am by 091554214745 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.