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?

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 !