can we connect developer 6i with oracle 10g

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hafizmzahid
    New Member
    • Jun 2007
    • 3

    can we connect developer 6i with oracle 10g

    hi
    i have install oracle 10 g on machince name rec and developer 6i on other machince name trn can some one told me that how i can establish a connection between developer 6i and oracle 10g
    ok
    thanks
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Hi
    hafizmzahid

    Welcome to TSDN

    Feel free to post more doubts/questions in the forum.

    But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.
    It will help Experts in the forum in solving/underestanding your problem in a better way.

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      I hope u know how to establish connection of Developer 6i with prior version of oracle.
      The process is same.
      In your case both the systems shopuld be in LAN and in the conection string passthe name of the database that u have created along with username and password. System /machine name not required.

      Comment

      • hafizmzahid
        New Member
        • Jun 2007
        • 3

        #4
        sir
        both systems are on line developer 6 configuration assistance is not working so i have to do it manuall so please help me. this developer can connect with oracel 8 locally or remotely but i want to connect develoer 6 with oracle 10g.
        thanks for time and considration

        Comment

        • maoonbila
          New Member
          • Jun 2007
          • 1

          #5
          Hi,

          There are some things you need to consider.

          1. both machines are on the network
          2. Listener should be configured and listening/running
          3. configure tns file on the machine having 10g Database
          (TNS file name be configured using Oracle Network Utility or manually)
          4. The the connectivity using the created TNS service on Database machine locally, if working then copy it to the machine with developer


          1. Both Machines communication check
          Machine A's Command Prompt
          to check the local machine TCP/IP Configuration

          C:\> ping machineA

          Now check the communication status of second machine to first machine
          C:\> ping machineB

          2. Listener on Database Machine

          Launch Command Prompt and invoke lsnrctl utility

          C:\> lsnrctl

          check the listener is running properly and on which port it is listening
          LSNRCTL> services

          if not running
          LSNRCTL> start

          3. As you have mentioned the Net services are not working on your Dev machine you can use the database's machine Oracle network services to create/configure TNS file on the database machine and then copy to the Dev machine's (Developer home\network\ad min folder)

          OR

          Manually
          the file located in Oracle Home\product\ne twork\admin\tns name.ora
          you can add these entries to a TNS file,decide the tns service string(the connect string you need to provide for connection i.e. HOST)( (like I am just using o on system) anyway

          o =
          (DESCRIPTION =
          (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = wks1)(PORT = 1521))
          )
          (CONNECT_DATA =
          (SID = MYDB)
          )
          )

          PROTOCOL is on which the Listener is configured
          HOST machine name where your database resides
          PORT on which port the listener is listening

          Normally above mentioned PROTOCOL and PORT are the default configurations of an Oracle database servers since version 7.3

          I hope it will help you out

          take care

          Comment

          • debasisdas
            Recognized Expert Expert
            • Dec 2006
            • 8119

            #6
            Do as suggested in the previous post.

            Here with this i have attached a sample file for your reference.

            U need to make changes to your TNSNAMES.ORA File accordingly.

            Hope your problem is solved from this.
            Attached Files

            Comment

            Working...