Dear Friends
We configured Oracle on server and given the same name to DBA what i had given in my desktop as erp.
in the tnsnames.ora Configuration is done and created as erp1 and erp, erp is my local database oracle dba and erp1 is on server. I am able to ping the server with tnsping.
but i am unable to connect using sql or sqldeveloper.
Can you please suggest how to resolve .
ERP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = erp)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = erp)
)
)
ERP1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = erp)
)
)
Sanjay