Hi all, I recently installed Oracle 9i database and Oracle forms6i in my system. I couldn't access database through forms.If i try to connect, "ORA 12203: TNS: unable to connect destination" error is occured.Can anybody resolve this problem?

vidhyalakshmi
Profile Answers by vidhyalakshmi Questions by vidhyalakshmi
Jul 27th, 2006
4
1928

Showing Answers 1 - 4 of 4 Answers

vijay

Sep 12th, 2007

First you create database and user in Oracle 9i
Mapping for all database using tnsnames.ora file and save it.
Create DSN and connect

babuda
Profile Answers by babuda Questions by babuda

Jul 13th, 2008

I am not sure abt this but I was successful when I did this 2 years ago
Open tnsnames.ora file
take a back up
change the service from dedicated to permanent. I am not sure which one is it

ORCL01 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = homecomputer)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL01)
    )
)

Please check before you proceed !