7 Replies Latest reply: Aug 10, 2011 9:36 PM by HuaMin Chen RSS

    Oracle Forms 10g & Oracle 10g DB Connection Problem

    869664
      Toady i have installed oracle forms 10g and oracle 10g db when i run my form it gives me this error how can i resolve it

      "ora-12154 tns could not resolve the connect identifier specified"


      Here are the values in forms 10g tns

      # tnsnames.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = PLSExtProc)
      )
      )
                IMS =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = IMS)
      )
      )


      and here the values of forms 10g SQLnet

      # sqlnet.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\sqlnet.ora
      # Generated by Oracle configuration tools.

      SQLNET.AUTHENTICATION_SERVICES= (NTS)

      NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)

      (description =
      # (address=(protocol=tcp)(host=localhost)(port=1383))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (connect_data=(rpc=on))
      )

      What changes should i make to overcome this problem.
        • 1. Re: Oracle Forms 10g & Oracle 10g DB Connection Problem
          HuaMin Chen
          you can try to put the actual IP of the machine in which the database resides instead of "localhost"
          • 2. Re: Oracle Forms 10g & Oracle 10g DB Connection Problem
            Paul M.
            "ora-12154 tns could not resolve the connect identifier specified"
            The problem is local to the Forms Home, probably in tnsnames.ora (seems that there are tabs in IMS entry name). Carefully check it.
            $ oerr ora 12154
            12154, 00000, "TNS:could not resolve the connect identifier specified"
            // *Cause:  A connection to a database or other service was requested using
            // a connect identifier, and the connect identifier specified could not
            // be resolved into a connect descriptor using one of the naming methods
            // configured. For example, if the type of connect identifier used was a
            // net service name then the net service name could not be found in a
            // naming method repository, or the repository could not be
            // located or reached.
            // *Action:
            //   - If you are using local naming (TNSNAMES.ORA file):
            //      - Make sure that "TNSNAMES" is listed as one of the values of the
            //        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
            //        (SQLNET.ORA)
            //      - Verify that a TNSNAMES.ORA file exists and is in the proper
            //        directory and is accessible.
            //      - Check that the net service name used as the connect identifier
            //        exists in the TNSNAMES.ORA file.
            //      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
            //        file.  Look for unmatched parentheses or stray characters. Errors
            //        in a TNSNAMES.ORA file may make it unusable.
            //   - If you are using directory naming:
            //      - Verify that "LDAP" is listed as one of the values of the
            //        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
            //        (SQLNET.ORA).
            //      - Verify that the LDAP directory server is up and that it is
            //        accessible.
            //      - Verify that the net service name or database name used as the
            //        connect identifier is configured in the directory.
            //      - Verify that the default context being used is correct by
            //        specifying a fully qualified net service name or a full LDAP DN
            //        as the connect identifier
            //   - If you are using easy connect naming:
            //      - Verify that "EZCONNECT" is listed as one of the values of the
            //        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
            //        (SQLNET.ORA).
            //      - Make sure the host, port and service name specified
            //        are correct.
            //      - Try enclosing the connect identifier in quote marks.
            //
            //   See the Oracle Net Services Administrators Guide or the Oracle
            //   operating system specific guide for more information on naming.
            $
            • 3. Re: Oracle Forms 10g & Oracle 10g DB Connection Problem
              869664
              Its Stand Alon machine which is not on network.
              • 4. Re: Oracle Forms 10g & Oracle 10g DB Connection Problem
                CraigB
                On a stand-alone (non-networked) computer, you need a network emulation. If you are using Windows, you can install the Microsoft Loopback Adapter (as noted in the Oracle Database Preinstallation Requirements see section *2.4.4 Installing Oracle Database on Non-Networked Computers*). If you are not using Windows - then you will need to find the equivalent for your OS.

                Also, as Paul M indicated, each Oracle product is installed into it's own Oracle Home. If you have configured the TNSNAMES on the RDBMS, but not configured it for the Developer Suite (Forms 10g) then you will need to perform this configuration. The easiest way to do this is to set an Environment Variable (TNS_ADMIN) that points to the TNSNAMES.ORA you have already configured with your RDBMS. If you are unsure of how to create an environment variable, check out this: how to create environment variables.

                Hope this helps,
                Craig B-)

                If someone's response is helpful or correct, please mark it accordingly.
                • 5. Re: Oracle Forms 10g & Oracle 10g DB Connection Problem
                  HuaMin Chen
                  Are you able to connect using Form or Sql plus?

                  Make sure the TNS is right within

                  ...\network\admin\tnsnames.ora

                  Have you started the DB?
                  • 6. Re: Oracle Forms 10g & Oracle 10g DB Connection Problem
                    869664
                    Issue has been resolved by adding TNS_ADMIN variable there was another problem i was using system/manager to connect my forms with db that was the real problem as i have created the a user and try to connect it was connected with db

                    any way thanks a lot for great help.
                    • 7. Re: Oracle Forms 10g & Oracle 10g DB Connection Problem
                      HuaMin Chen
                      It's not good to develop the form using system login. You can create other schema for the development