ora-12203: TNS:unable to connect destination

[msunder]

Hi,

I installed oracle 9i and forms 6i on windows xp media center 2005 edition. When i tried to connect the database from forms i am getting the following error.

ora-12203: TNS:unable to connect destination.

Please help me to solve this problem.

Thanx in advance.
Sunder.

[siraj_ahmed]

check ur tnsnames.ora file.. there has to be an entry in it.

host_name:ip address of the pc or server ur connecting sid=oracle instance name

for eg
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = host_name)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = host_name)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = instance_name)
)
)

[Larry Cumber]

If this did not start then you have to do some verification


Is your service name is correct.

2. Verify that the name of the ‘host’ computer (defined as part of the TNS address) is valid and correct.

3.Ensure that the listener is up and running.

4check if the oracle services are running too.

Trouble shoot it this way and get back to us.

[Larry Cumber]

I would also advice you to check the sqlnet.log.
Are there any errors ? If so then what are these errors.
Can you connect via SQlplus ?
Also is the Oracles sid set ?