Developers Heaven Forum

DataBase => Oracle => Topic started by: gozuhair on August 11, 2009, 10:36:26 AM

Title: Unable to connect from Developer 10G Report and Form Builder to Oracle Database
Post by: gozuhair on August 11, 2009, 10:36:26 AM

I have received the following message when i connect Developer 10G report builder with oracle database.

scott/tiger@z

REP-0501:Unable to connect to the specified database ORA-12154:TNS could not resolve service name.

I have written the following text in tnsnames.ora file.


# TNSNAMES.ORA Network Configuration File: E:\ora_10g\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

z =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zkhan-dfml)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = dba)
    )
  )

One more thing that i need to mention,I have also installed Oracle Report 6i and its connecting well.I have installed Oracle database in my own computer.

Regards

Title: Re: Unable to connect from Developer 10G Report and Form Builder to Oracle Database
Post by: admin on August 11, 2009, 08:57:19 PM

The error is "'cannot find service name". That means it couldn't find the entry in tns. May you have multiple tnsnames and are hitting the wrong one.
you may also replace SID with SERVICE_NAME.