Oracle Forms Developer error on Oracle9i Developer Suite

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Nathan Sokalski
    #1

    Oracle Forms Developer error on Oracle9i Developer Suite

    When I attempt to run a form created with Oracle9i Forms Builder I receive a
    dialog box asking for the following info:

    User Name:
    Password:
    Database:

    I obviously know my User Name and Password, and I assume that the value I
    use for Database is the value found in the tnsnames.ora file (in my case,
    ORCL). However, when I do this I receive the following error:

    ORA-12154: TNS:could not resolve service name

    I do not receive this error when logging into SQL*Plus or entering my
    username and password for Enterprise Manager Console, but those do not have
    a Database: field to fill in and have a different Oracle Home directory,
    which causes me to think that the problem is either the value I am entering
    in the Database: field or some setting that I do not know of. I am using
    Oracle9i Database Personal Edition and Oracle9i Developer Suite on Windows
    XP Professional SP2. If any more information is necessary, let me know what
    it is and how to find it (since I am new to database administration) . Any
    help would be greatly appreciated. Thanks.
    --
    Nathan Sokalski
    njsokalski@hotm ail.com
    有声小说网-无弹窗小说阅读网
    https://www.nathansokalski.com
    有声小说网为广大读者提供热门小说在线免费阅读，本站收集的网络文学小说情节跌宕起伏，有声小说网是值得书友们收藏的小说在线阅读网。




    Tags: None
    • prisilia
      #2
      Re: Oracle Forms Developer error on Oracle9i Developer Suite

      "Nathan Sokalski" <njsokalski@ver izon.netwrote in message news:<A_Cdd.948 $Nf7.513@trndny 02>...
      When I attempt to run a form created with Oracle9i Forms Builder I receive a
      dialog box asking for the following info:
      >
      User Name:
      Password:
      Database:
      >
      I obviously know my User Name and Password, and I assume that the value I
      use for Database is the value found in the tnsnames.ora file (in my case,
      ORCL). However, when I do this I receive the following error:
      >
      ORA-12154: TNS:could not resolve service name
      >
      I do not receive this error when logging into SQL*Plus or entering my
      username and password for Enterprise Manager Console, but those do not have
      a Database: field to fill in and have a different Oracle Home directory,
      which causes me to think that the problem is either the value I am entering
      in the Database: field or some setting that I do not know of. I am using
      Oracle9i Database Personal Edition and Oracle9i Developer Suite on Windows
      XP Professional SP2. If any more information is necessary, let me know what
      it is and how to find it (since I am new to database administration) . Any
      help would be greatly appreciated. Thanks.



      Hi,
      i would like to say, username and password which you assign for oracle
      database.
      while database is the service name you have created for accessing
      oracle database. refer to below, database = HP

      HP =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = OracleDbase)
      )
      )

      this ia the text in tnsnames.ora file , place the database name under
      the service name.

      i think that is useful enough. I'm using SQLPlus to access the oracle
      database.

      regards,
      prisilia

        Comment

        • Frans H.
          #3
          Re: Oracle Forms Developer error on Oracle9i Developer Suite

          "Nathan Sokalski" <njsokalski@ver izon.netwrote in message news:<A_Cdd.948 $Nf7.513@trndny 02>...
          When I attempt to run a form created with Oracle9i Forms Builder I receive a
          dialog box asking for the following info:
          >
          User Name:
          Password:
          Database:
          >
          I obviously know my User Name and Password, and I assume that the value I
          use for Database is the value found in the tnsnames.ora file (in my case,
          ORCL). However, when I do this I receive the following error:
          >
          ORA-12154: TNS:could not resolve service name
          >
          I do not receive this error when logging into SQL*Plus or entering my
          username and password for Enterprise Manager Console, but those do not have
          a Database: field to fill in and have a different Oracle Home directory,
          which causes me to think that the problem is either the value I am entering
          in the Database: field or some setting that I do not know of. I am using
          Oracle9i Database Personal Edition and Oracle9i Developer Suite on Windows
          XP Professional SP2. If any more information is necessary, let me know what
          it is and how to find it (since I am new to database administration) . Any
          help would be greatly appreciated. Thanks.
          Nathan,
          you might have more then 1 oracle home, one for your database, and 1
          for the developer tools. Find out if you have more than 1 tnsnames
          file, and if so, make them equal (or change the registry settings so
          that they point to the same file),

          hth
          Frans

            Comment

            • OracleGuy
              #4
              Re: Oracle Forms Developer error on Oracle9i Developer Suite

              fransh@hotmail. com (Frans H.) wrote in message news:<31abf0e5. 0410260202.1543 8bf2@posting.go ogle.com>...
              "Nathan Sokalski" <njsokalski@ver izon.netwrote in message news:<A_Cdd.948 $Nf7.513@trndny 02>...
              When I attempt to run a form created with Oracle9i Forms Builder I receive a
              dialog box asking for the following info:

              User Name:
              Password:
              Database:

              I obviously know my User Name and Password, and I assume that the value I
              use for Database is the value found in the tnsnames.ora file (in my case,
              ORCL). However, when I do this I receive the following error:

              ORA-12154: TNS:could not resolve service name

              I do not receive this error when logging into SQL*Plus or entering my
              username and password for Enterprise Manager Console, but those do not have
              a Database: field to fill in and have a different Oracle Home directory,
              which causes me to think that the problem is either the value I am entering
              in the Database: field or some setting that I do not know of. I am using
              Oracle9i Database Personal Edition and Oracle9i Developer Suite on Windows
              XP Professional SP2. If any more information is necessary, let me know what
              it is and how to find it (since I am new to database administration) . Any
              help would be greatly appreciated. Thanks.
              >
              Nathan,
              you might have more then 1 oracle home, one for your database, and 1
              for the developer tools. Find out if you have more than 1 tnsnames
              file, and if so, make them equal (or change the registry settings so
              that they point to the same file),
              >
              hth
              Frans

              Just as an FYI, when even you install a new Oracle product on top of
              the existing Oracle Products, Oracle makes the default Oracle Home to
              the Home of the newly Installed Products. To recognize the previous
              TNS Names.ora which you have build painstakingly, all you have to do
              is change the dafault home by using Oracle Home Selector by going to
              Start-->Programs-->Oracle Installation Products-->Oracle Home Selector

              Change it back the previously installed Oracle Home, and you would
              successfully connect to all your TNS Services without "ORA-12154:
              TNS:could not resolve service name" error.

              Hope this helps

                Comment

                Previous template Next
                Working...