2 Replies Latest reply: May 18, 2013 2:43 AM by 1007061 RSS

    ORACLE FORM BUILDER ERROR

    1007061
      Hi guys! I need your HELP.

      I'm having a hard time in connecting to ORACLE FORMS...
      I can't connect the scott/tiger/orcl....
      It shows an error:

      ORA-12154:+
      TNS:could not resolve the connect identifier specified+

      Here the content of my tnsnames.ora, sqlnet.ora and listener.ora:

      TNSNAMES.ORA

      *# tnsnames.ora Network Configuration File: C:\Users\jack\product\11.2.0\dbhome_1\network\admin\tnsnames.ora*
      *# Generated by Oracle configuration tools.*

      LISTENER_ORCL =
      *(DESCRIPTION =*
      *(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))*
      *(CONNECTDATA =*_
      *(SERVER = DEDICATED)*
      *(SERVICENAME = ORCL)*_
      *)*
      *)*


      ORACLR_CONNECTION_DATA =
      *(DESCRIPTION =*
      *(ADDRESS_LIST =*
      *(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))*
      *)*
      *(CONNECT_DATA =*
      *(SID = CLRExtProc)*
      *(PRESENTATION = RO)*
      *)*
      *)*

      ORCL =
      *(DESCRIPTION =*
      *(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))*
      *(CONNECT_DATA =*
      *(SERVER = DEDICATED)*
      *(SERVICE_NAME = orcl.168.2.100)*
      *)*
      *)*


      SQLNET.ORA:


      *# sqlnet.ora Network Configuration File: C:\Users\jack\product\11.2.0\dbhome_1\network\admin\sqlnet.ora*
      *# Generated by Oracle configuration tools.*

      *# This file is actually generated by netca. But if customers choose to*
      *# install "Software Only", this file wont exist and without the native*
      *# authentication, they will not be able to connect to the database on NT.*

      SQLNET.AUTHENTICATION_SERVICES= (NTS)

      NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


      LISTENER.ORA:


      *# listener.ora Network Configuration File: C:\Users\jack\product\11.2.0\dbhome_1\network\admin\listener.ora*
      *# Generated by Oracle configuration tools.*

      SID_LIST_LISTENER =
      *(SID_LIST =*
      *(SID_DESC =*
      *(SID_NAME = CLRExtProc)*
      *(ORACLE_HOME = C:\Users\jack\product\11.2.0\dbhome_1)*
      *(PROGRAM = extproc)*
      *(ENVS = "EXTPROC_DLLS=ONLY:C:\Users\jack\product\11.2.0\dbhome_1\bin\oraclr11.dll")*
      *)*
      *(GLOBALDBNAME = ORACLE10G)*_
      *(ORACLEHOME = C:\oracle\)*_
      *(SIDNAME = ORACLE10)*_
      *)*
      *)*

      LISTENER =
      *(DESCRIPTION_LIST =*
      *(DESCRIPTION =*
      *(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))*
      *(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))*
      *)*
      *)*

      ADR_BASE_LISTENER = C:\Users\jack




      -- I ADDED THESE UNDERLINED STATEMENTS

      TNSNAMES:
      *(CONNECTDATA =*_
      *(SERVER = DEDICATED)*
      *(SERVICENAME = ORCL)*_
      _ *)*_

      LISTENER:

      *)*
      *(GLOBALDBNAME = ORACLE10G)*_
      *(ORACLEHOME = C:\oracle\)*_
      *(SIDNAME = ORACLE10)*_
      *)*

      Edited by: Oracle Abecedarian 12 on May 17, 2013 6:17 PM

      Edited by: Oracle Abecedarian 12 on May 18, 2013 12:53 AM