Author Topic: Unable to connect from Developer 10G Report and Form Builder to Oracle Database  (Read 14919 times)

Offline gozuhair

  • Newbie
  • *
  • Posts: 1
    • View Profile
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

Offline admin

  • Administrator
  • Sr. Member
  • *****
  • Posts: 296
    • View Profile
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.