OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » ORA-12203 TNS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12203 TNS [message #66358]

Mon, 29 April 2002 18:24

turiddo
Messages: 1
Registered: April 2002

Junior Member

I can't connect a database in the Form Builder. It seems that I need to copy tnsnames.ora to form's home. but what does it look like, if it's a local machine? It's not connected to anywhere.

Apprentice

Report message to a moderator

Re: ORA-12203 TNS [message #66374 is a reply to message #66358]

Mon, 06 May 2002 10:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

for local machine you no need to give the hostring during the connect. just give the username and password

Report message to a moderator

Re: ORA-12203 TNS [message #66418 is a reply to message #66358]

Sun, 02 June 2002 10:48

kailee
Messages: 2
Registered: June 2002

Junior Member

I have the identical problem. I typed
username: scott
password: tiger
database:

I kept getting the error message:
ORA: 12203 TNS:unable to connect to destination.

Report message to a moderator

Re: ORA-12203 TNS [message #66420 is a reply to message #66358]

Mon, 03 June 2002 05:23

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

tnsnames is the file you need to edit.
if you have problems with it, use net*8 configuration assistent to configure the service name
you need to know the following informat.
hostname/ip number
dbname
port number (default is 1521).
else
send me the above informationtnsames file
i will create the tnsnames.ora entry

Report message to a moderator

Re: ORA-12203 TNS [message #66422 is a reply to message #66358]

Tue, 04 June 2002 09:12

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

hello!
i just created a serivice name for a databse&client in the same machine.
gave host=LOCALHOST.
it works fine for me.
so, u just find your dbname and use something like this!!

MAGVIVEK =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = magvivek)
    )
  )

magvivek=dbname
i jave created the servicename and dbname to be as magvivek.

Report message to a moderator

Re: ORA-12203 TNS [message #66424 is a reply to message #66358]

Wed, 05 June 2002 17:07

kailee
Messages: 2
Registered: June 2002

Junior Member

Hi Mahesh,

Thank you for all your help. I tried all your suggestions, including using the sample tnsnames file you so kindly provided without any luck. I kept getting th same messages that Oracle could not connect me to the database. I am beginning to wonder if there may be problems with the software I have on hand.

Report message to a moderator

Re: ORA-12203 TNS [message #66582 is a reply to message #66358]

Tue, 13 August 2002 14:33

Betty Rsoeburough
Messages: 1
Registered: August 2002

Junior Member

Please help. I'm getting that same ORA-12203 error message. I can't connect to the database. You have to tell me step by step what to do, I'm lost.

Report message to a moderator

Re: Error : ORA-12203 TNS [message #66600 is a reply to message #66358]

Sat, 24 August 2002 23:38

Prabhu
Messages: 26
Registered: October 2001

Junior Member

When I give Username:Scott, password: tiger - in Oracle Forms developer, the following error is thrown:

ORA-12203: TNS: Unable to connect to destination.

Kindly let me know how to rectify the error.

Report message to a moderator

Re: ORA-12203 TNS [message #66601 is a reply to message #66358]

Sun, 25 August 2002 00:07

Prabhu
Messages: 26
Registered: October 2001

Junior Member

When I give Username:Scott, password: tiger - in Oracle Forms developer, the following error is thrown:
ORA-12203: TNS: Unable to connect to destination.

Kindly let me know how to rectify the error.

Report message to a moderator

Re: ORA-12203 TNS [message #66649 is a reply to message #66358]

Wed, 02 October 2002 18:19

Anil
Messages: 80
Registered: September 2001

Member

if u get the reply, kindly forward me also

Report message to a moderator

Re: ORA-12203 TNS [message #66858 is a reply to message #66358]

Sun, 09 February 2003 12:49

sara
Messages: 36
Registered: February 2000

Member

I am getting in 2000 xp, the following message
"tns protocol adapter problem" after logged in as sysmgr
I am also getting this message "ora 12203 tns loc not available".

please kindly suggest some advise.

thanks,
sara.

Report message to a moderator

Re: ORA-12203 TNS [message #67341 is a reply to message #66601]

Tue, 18 May 2004 05:23

MOHAED ALI
Messages: 1
Registered: May 2004

Junior Member

When I give Username:Scott, password: tiger - in Oracle Forms developer, the following error is thrown:
ORA-12203: TNS: Unable to connect to destination.
Kindly let me know how to rectify the error.

Report message to a moderator

Re: ORA-12203 TNS [message #67361 is a reply to message #66358]

Wed, 02 June 2004 08:30

HOSSIN JAFARY FARAHANI
Messages: 1
Registered: June 2004

Junior Member

I CAN NOT CONNECT TO DATABASE FROM DEVELOPER 6i

Report message to a moderator

Re: ORA-12203 TNS [message #67552 is a reply to message #67361]

Tue, 05 October 2004 01:07

Mohamed Gaber
Messages: 1
Registered: October 2004

Junior Member

Dear
The following message :ORA-12203: TNS: UNBALE TO CONNECT TO DESTINATION
its declared when i try to log in the database.
Many thanks.

Report message to a moderator

Re: Error : ORA-12203 TNS [message #67591 is a reply to message #66600]

Wed, 03 November 2004 12:44

Satyabrata Dash
Messages: 1
Registered: November 2004

Junior Member

While i am trying to connect oracle database through CGI script using DBI module it is showing me error as
"Error while trying to retrieve text for error ORA-12203 (DBD: login failed)"

Report message to a moderator

Previous Topic:	TNS:could not resolve service name
Next Topic:	cannot connect to DB on another machine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 00:48:01 CDT 2024