Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    bangalore
    Posts
    12

    Unanswered: Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB.

    Hi,

    In my previous post I had mentioned a few things incorrectly.

    Oracle version : 8.1.7.0.0
    OS : Win2000 PE.

    I searched in google.com and also in other Oracle forums as well
    as in your site also. I found a few useful hints which I tried and still the
    problem exists.

    When I try to connect to the DB from Oracle forms 6i with just the
    username and password I get the following error :

    ORA-12203 : TNS : unable to connect to destination.

    In one site it had mentioned that I provide the host string name as
    that mentioned in the TNSNAMES.ORA file. I did that and got the following error :

    ORA-12154 : TNS : Could not resolve service name.

    I gave the service name as "home" as mentioned in my Oracle 8.1.7.0.0 ,TNSNAMES.ORA file, in the host string field of the forms 6i
    connect dialog box. I got the following error :

    ORA-12514 : Message 12514 not found: product=RDBMS80:facility=ORA

    In an other site it had mentioned that I do the following:

    1) Uninstall all Oracle products.
    2) Install Oracle forms 6i first.
    3) Then install Oracle 8.1.7.0.0 database.

    I did the above steps as well, but still I am unable to connect to the DB
    from forms 6i.

    I would like to know what the format of "host string" is,in the username/
    password dialog box.

    Can anyone assist me with this issue with a detailed explanation.

    thanks in advance
    sharathkv.

  2. #2
    Join Date
    Dec 2003
    Location
    italy
    Posts
    4
    If you have Oracle Forms and Oracle 8.1.6 on same machine,
    there are two Home directory in your installation.

    You can use the Oracle Home Selector
    (Start->Oracle per Windows NT->Oracle Home Selector)
    and select the correct Home directory.

    In this way you can use OracleForms xor SqlPlus 8.1.7;


    Regards,
    Roberto

  3. #3
    Join Date
    Oct 2003
    Posts
    37

    Re: Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB.

    Hi

    Just to cover the bases - I'll ask a really obvious question.

    You have modified the tnsnames.ora file on the pc with reports 6i installed?

    Its usually in oracle_forms_home/net80/admin


    Regards

    Keith

  4. #4
    Join Date
    Dec 2003
    Location
    italy
    Posts
    4

    Re: Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB.

    Originally posted by kfitzsimmons
    Hi

    Just to cover the bases - I'll ask a really obvious question.

    You have modified the tnsnames.ora file on the pc with reports 6i installed?

    Its usually in oracle_forms_home/net80/admin


    Regards

    Keith
    ==================
    Yes,
    you can modify the tnsnames.ora in the path oracle_forms_home/net80/admin for the reports/form;

    or

    modify the tnsnames.ora in \oracle_home\ora81\network\admin
    if you choices to use the 8.1.7 client

    Regards,
    Roberto

  5. #5
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333
    Hi,

    Rebuild the SQL*PLUS executable manually, using the makefile sqlplus.mk.
    SATHISH .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •