| ORA - 12203 TNS Unable To Connect Destination [message #73886] |
Wed, 28 July 2004 23:57  |
vivek desai
Messages: 3
Registered: June 2004
|
Junior Member |
|
|
Dear All
>
> I have one problem. i have installed windows 2000 sever and oracle 8i
(8.1.7) on sever.
> from the sever i am able to connect to database.
> but from the client i am not able to connect to database. it gives me
error like 'ORA - 12203 TNS : Unable to Connect Destination'.on server
side listener seveive is up and running . i also get the reply in ping
command from the client side. tnsping command also reply ok. so i cant
understand the probelem.
> here i am sending you my listener.ora,tnsname.ora,sqlnet.ora file.
>
> # Listener.Ora file
> # LISTENER.ORA Network Configuration File:
C:oracle8iora81networkadminlistener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.135)(PORT =
1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:oracleora81)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = hrmsank)
> (ORACLE_HOME = D:oracleora81)
> (SID_NAME = hrmsank)
> )
> )
>
> #Tnsnames.ora file
> # TNSNAMES.ORA Network Configuration File:
C:oracle8iora81networkadmintnsnames.ora
> # Generated by Oracle configuration tools.
>
> ANKCADILA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.135)(PORT =
1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = hrmsank)
> )
> )
> #sqlnet.ora file
>
> # SQLNET.ORA Network Configuration File:
d:oracleora81networkadminsqlnet.ora
> # Generated by Oracle configuration tools.
>
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP)
>
>
> Pls Send me the solution of this.
> Waiting for your favourable reply.
>
>
> Best regards.
> Vivek Desai
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
