Hi Guyz,
I have a connection problem with the Developer Suite and the Database. When I'm trying to connect I'm facing 'ORA-12203: TNS:unable to connect to destination' Error in the Server (I can connect with sqlplus). But the clients/users can connect to the application (Developer Suite to the Database).
Please find my related details,
Database - 9i R2 EE
Developer Suite - 6i R2
OS - Windows Server 2003 EE
Database ---
tnsnames
PROD =
>(DESCRIPTION =
>(ADDRESS_LIST =
>(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
>)
>(CONNECT_DATA =
>(SERVER = DEDICATED)
>(SERVICE_NAME = PROD)
>)
>)
sqlnet
SQLNET.AUTHENTICATION_SERVICES= (NTS)
#SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
#NAMES.DEFAULT_DOMAIN = domain.com
#NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)
Listener
LISTENER =
>(DESCRIPTION_LIST =
>(DESCRIPTION =
>(ADDRESS_LIST =
>(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
>)
)
>)
Developer Suite ----
tnsnames
PROD =
>(DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
>)
(CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME =PROD)
)
)
Thanks