0 Replies Latest reply: Dec 15, 2005 6:41 AM by 455923 RSS

    Oracle 10g/form6i connectivity problem

    455923
      Hi Oracle guru,
      I have installed oracle10g beta version(downloaded from otn) ,it is running fine.

      Also I have installed form6i on same machine. now while connecting form6i(form builder/report builder) with oracle10g , error is coming "ORA-12203 TNS :unable to connect to destination".

      For your information I have two oracle homes, one for oracle10g and one for form6i.
      Second thing, I have wireless card, I am unable to fix my IP.

      Tnsnames.ora entry as below:
      # C:\ORACLE\PRODUCT\10.2.0\DB_1\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
      # Generated by Oracle Net8 Assistant

      ORACLE10 =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = patil)(PORT = 1521))
      (CONNECT_DATA = (SID = oracle10))
      )
      --------------
      SQLNET.ora entry as below
      # C:\ORACLE\PRODUCT\10.2.0\DB_1\NETWORK\ADMIN\SQLNET.ORA Configuration File:C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
      # Generated by Oracle Net8 Assistant

      NAMES.PREFERRED_SERVERS =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = patil)(PORT = 1521))
      )

      SQLNET.AUTHENTICATION_SERVICES= (none)

      # 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.
      #NAMES.DIRECTORY_PATH= (TNSNAMES)

      SQLNET.EXPIRE_TIME = 0

      SQLNET.ENCRYPTION_SERVER = requested

      SQLNET.ENCRYPTION_CLIENT = requested
      ------------------------------------------------------------------
      Listener.ora entry as below
      # C:\ORACLE\PRODUCT\10.2.0\DB_1\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
      # Generated by Oracle Net8 Assistant

      LISTENER =
      (ADDRESS = (PROTOCOL = TCP)(HOST = patil)(PORT = 1521))


      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (GLOBAL_DBNAME = Oracle10)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = oracle10)
      )
      )

      TRACE_LEVEL_LISTENER = USER

      ------------------------

      One more thing which I would like to tell u I am able to connect oracle10 using
      oracle10 tns i.e sqlplus scott/tiger@oracle10 work perfectlly. tnsping also work
      from oracle10g home directory, but it does not work from form6i/bin directory.

      I hope u got my problem ,how to connect oracle10g with form6i.

      Would appriciate your help

      Thanking you
      Ashok Patil