Re: connecting Developer 6 to O8i

From: Martin Vonk <m.w.vonk_at_chello.nl>
Date: 2000/05/09
Message-ID: <8f7frt$a3f$1_at_tesla.a2000.nl>#1/1


Hi Greg,
I don't know...but this might solve your problem .? .I managed to install it (testing environment)
HTH
Martin



Installation Procedure

Follow this procedure to install Developer 6.0 and Oracle 8i on the same physical machine in separate ORACLE_HOMEs on NT:

  1. Install Developer 6.0 using the instructions on the Developer CD. Specify an appropriate drive and the ORANT directory as the destination. For example: D:\ORANT Note: You must install Developer in the Oracle home named DEFAULT_HOME.
  2. Install RDBMS 8.1.5 from the Oracle 8i CD. Specify the following information when prompted for the Oracle Home and Full path: Oracle Home ora8i Full Path d:\orant\ora8i Choose Typical Install Global Database Name ora8i.us.oracle.com (This is an example) SID ORA8I (This is an example) As the product installs, a summary is displayed that shows the products that are installed and the space requirements. When the installation is complete, the following information is displayed and the installer exits: Oracle Database Configuration Assistant Alert Database Creation Completed. Database Information Global Database Name ora8i.us.oracle.com SID ORA8I Sys password change_on_install System passwd manager
  3. A TNSNAMES entry needs to be created in the tnsnames.ora file for the new Oracle 8i installation. You can find the file in: d:\orant\net80\admin\tnsnames.ora A default entry will look like this: alias.world
    (DESCRIPTION
    (ADDRESS_LIST
    (ADDRESS
    (PROTOCOL = TCP)
    (Host = )
    (Port = )
    ) )
    (CONNECT_DATA = (SID = )
    ) ) For example, if you installed on a machine with a HOSTNAME of TEST, a SID named ORA8I, on TCP/IP with port 1521, and an alias of NEW, you would create the following entry: NEW.world
    (DESCRIPTION
    (ADDRESS_LIST
    (ADDRESS
    (PROTOCOL = TCP)
    (Host = TEST)
    (Port = 1521)
    ) )
    (CONNECT_DATA = (SID = ORA8I)
    ) )
  4. If you manually created the entry, save and close the tnsnames.ora file. You can now connect to the local database instance of 8i using the DBSTRING as NEW. For example, you can connect as scott/tiger_at_NEW.

Greg Silverman <gms_at_gms.email.umn.edu> schreef in berichtnieuws 39171829.6D08A282_at_gms.email.umn.edu...

[Quoted] > We are having problems connecting Developer 6 to our Oracel 8i database?
> I seem
> to recall that the Net7 driver is needed for this? Is this true and if
> so, where can I get a copy of this?
>
> TIA!
>
Received on Tue May 09 2000 - 00:00:00 CEST

Original text of this message