Re: Installing Developer6i and Oracle8i on same laptop

at www.iselfschooling.com they have some great explenation for this.

Developer & Oracle Personal Edition on Windows (standalone) The following will need to be done to establish a connection from Developer to Oracle Personal Edition.

1. Install Oracle. Default Oracle_Home is as follows: (oracle/oraxx - xx is version number for example Oracle 8i xx=81 or 82 and for Oracle 9i xx=90, 91 or 92) If you do not have a Domain name or are unsure of - use default selections (REMEMBER: your SID for step 3)

2.Install Developer into a seperate Oracle_Home from the Oracle database. Default Oracle_Home: ORAWIN95. Change the Developer Home name to: (oradevxx - xx is version number) and the Developer Home location to: (oracle/devxx - xx is version number)

3.Create a Net8 service name using the Net8 Easy config utility (start -> programs -> Oracle ->network administration -> net8 easy config)

Enter the following information:

     Select "create"

Name the service name - any name can be used. (this name must be the same as SID name on the step 1.

Select TCP/IP as the protocol adapter

Enter your PC name as your host (as found in your TCP/IP

properties of the control panel or 127.0.0.1)

Select the second radio button to change your database instance to equal the SID created during your installation or leave the default as ORCL.

Bypass the test and remaining screens by clicking next.

4.Go to the following location (using Windows Explorer): (oracle/oraxx/network/admin/) (where Oracle/Oraxx is the location of your Oracle_Home) then copy the tnsnames.ora file to the following location: (oracle/oradevxx/net80/admin) (where oracle/oradevxx is the location of your Developer Oracle_Home)

5.Rename the sqlnet.ora file to sqlnet.old. These files can be found in the following locations:

a.oracle/oraxx/network/admin/
b.oracle/oradevxx/net80/admin

Some installations will not create the above files in both locations, rename only the files that are found. Now reboot.

6.Start your listener:
At the DOS prompt type: LSNRCTL START

NOTE: if you have an internet connection that uses TCP/IP as a protocol you may recieve a dial-up connection box when starting the listener. Press cancel to bypass this connection.

7.Start your database: (Start -> Oracle - OraHomexx -> Database Administration -> Start

Login to any developer's tools and make a connection using:

      username: scott
      password: tiger
      database: <enter the service name created in step #3>

Hope this helps!

Jerzy Zakrzewski wrote:

> Installing on Win2000
> Installed Oracle 8.1.7 in c:\myOra8i oracle home=myOra8i
> Installed Developer 6i in c:\ORANT oracle home DEFAULT_HOME
> According to Oracle Doc ID 74131.1 changed developer 6i tnsnames.ora to
> MYORA8I.world =
> (DESCRIPTION_LIST =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = jerzy-5ltx7an9h)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID=myOra8i)
> )
> )
>
> Rep60_JERZY-5LTX7AN9H,Rep60_JERZY-5LTX7AN9H.world=(ADDRESS=(PROTOCOL=tcp)(HO
> ST=JERZY-5LTX7AN9H)(PORT=1949))
> Can not connect from Developer Report/Forms
> Using proper user/password and service name "myOra8i"
> Getting message REP-0501 Unable to connect to specified database. ORA-12154:
> TNS could not resolve service name.
> Using same string can get to Oracle using SQL+
> What am I doing wrong ?
>
>
>
>
Received on Thu May 30 2002 - 17:29:42 CDT