how to connect 9i to 10g forms

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • farhanusm
    New Member
    • Aug 2008
    • 8

    how to connect 9i to 10g forms

    hi everyone
    i have installed oracle 9i enterprise addition database and alsi i have installed 10g form developer but i am not able to connect the two , plz help me how i can connect ..........
  • amitpatel66
    Recognized Expert Top Contributor
    • Mar 2007
    • 2358

    #2
    Please provide more information about the error that you are facing?

    Comment

    • samir pradhan
      New Member
      • Jul 2008
      • 7

      #3
      Hi. I have a suggestion for u.it may work.

      If u have already installed oracle9i and forms 10g remove both from ur system.
      after that first istall forms 10g ,then install oracle9i.
      during 9i installation specify or SID as "orcl".

      after complete installtion of both
      Replace the contents of listener.ora which is located at $ORACLE_HOME\ne twork\admin\lis tener.ora with the text below.



      # LISTENER.ORA Network Configuration File: e:\oracle\netwo rk\admin\listen er.ora
      # Generated by Oracle configuration tools.

      LISTENER =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      SID_LIST_LISTEN ER =
      (SID_DESC =
      (SID_NAME = orcl)
      )

      L1 =
      (ADDRESS =
      (PROTOCOL = TCP)
      (HOST = 127.0.0.1)
      (PORT = 1526)
      )

      SID_LIST_L1 =
      (SID_DESC =
      (SID_NAME = orcl)
      )







      Now replace the contents of tnsnames.ora file located at $DEV_HOME\netwo rk\admin with the text below.


      # tnsnames.ora Network Configuration File: G:\DevSuiteHome _1\network\admi n\tnsnames.ora
      # Generated by Oracle configuration tools.

      EXTPROC_CONNECT ION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.1)( PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = PLSExtProc)
      )
      )





      Go to Command prompt
      Execute LSNRCTL START L1


      after that start "oc4j" instance which u can find somewhere at
      start->all programs->developer->......

      now open forms, go to file menu, click on connect, provide username and password and connect.

      plz inform me whether u succeeded or not.

      Comment

      • farhanusm
        New Member
        • Aug 2008
        • 8

        #4
        i have tried this but it's not working , i have installed oracle and developer tool in same drive .....and also when i try this i got a tns protocol adapter error...
        Also tell me what should i write in coonect .....????as i have writen ocl in tht textbox ..

        Comment

        Working...