Home » RDBMS Server » Server Utilities » ORA - 12203 TNS Unable To Connect Destination
ORA - 12203 TNS Unable To Connect Destination [message #73886] Wed, 28 July 2004 23:57 Go to next message
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
Re: ORA - 12203 TNS Unable To Connect Destination [message #73887 is a reply to message #73886] Thu, 29 July 2004 01:12 Go to previous messageGo to next message
Tarun Biswas
Messages: 23
Registered: May 2004
Junior Member
you have to make an entry in client side tnsnames.ora file for the same database. i.e. SQL net easy configuration
if home c:orawin95
it is c:orawin95networkadmintnsnames.ora

tarun
icon9.gif  Re: ORA - 12203 TNS Unable To Connect Destination [message #178066 is a reply to message #73887] Mon, 19 June 2006 05:22 Go to previous messageGo to next message
mayank_parmar2000
Messages: 1
Registered: June 2006
Location: Ahmedabad
Junior Member

I get this error since I have installed forms 6i.
It had install sql plus 8(Oracle 8 for NT).
Both came in 1 cd.
But sql plus 8 never worked.
does it reqiure SP 2 for windows?

Then I install oracle 9i.
But I can't make connection from forms 6i to oracle 9i.

Any suggestions

Reply please.
Mayank
Ahmedabad, India.
Re: ORA - 12203 TNS Unable To Connect Destination [message #209765 is a reply to message #178066] Sun, 17 December 2006 16:48 Go to previous messageGo to next message
gsubba_reddy
Messages: 1
Registered: December 2006
Location: USA
Junior Member
Hi,

I am facing the same problem you have. I have Developer 6i and Oracle 9i installed in a single PC. And I am not able to connect to oracle from form 6i.

Solucation is appreciated

Thanks,
Subba
Re: ORA - 12203 TNS Unable To Connect Destination [message #209803 is a reply to message #209765] Sun, 17 December 2006 22:57 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
as suggested "tarun".
check your tnsnames.ora file for
"you have to make an entry in client side tnsnames.ora file for the same database".

because you have more than one tnsnames.ora file on client system.


regards
Taj
Previous Topic: How to Monitor Export
Next Topic: different character set
Goto Forum:
  


Current Time: Sun Dec 04 02:54:42 CST 2016

Total time taken to generate the page: 0.05397 seconds