Developer/2000 and Personal Oracle8
Date: Wed, 11 Nov 1998 07:22:22 -0800
Message-ID: <PYh22.6755$C5.4386955_at_WReNphoon1>
Hi,
Look at this document
(http://www.oracle.com/support/products/dev2k/nt95/html/dev2kOra803.html)
This will help you to configure
Good luck
Madhu Cherukuri
Developer/2000 is an Oracle7 based tool which uses a SQL*Net connection to communicate with the database. Oracle8 uses a new networking standard for communicating with it's databases called Net8. In order for an Oracle7 tool to be able to communicate to an Oracle8 database, you must install and configure SQL*Net.
When Developer/2000 version 2.0 is installed a version of SQL*Net is installed that is not compatible with Oracle8 version 8.0.3. The following steps will need to be completed in order to set up a connection from Developer/2000 2.x to an Oracle8 database.
1.Install Oracle8 version 8.0.3
2.Install Developer/2000 version 2.x
3.Re-install the Oracle Installer & SQL*Net 2.3.3.0.1
Re-install the Oracle installer from the Oracle8 distribution media
(i.e. downloaded files or CD).
REMOVE SQL*Net 2.3.4.0.0 and the SQL*Net Adapters 2.3.4.0.0
Install SQL*Net 2.3.3.0.1 and the SQL*Net TCP/IP Adapter 2.3.3.0.1
from the Oracle8 distribution media.
(A different version of SQL*Net may be installed on your system if you are not using version 2.0 of Developer/2000.
This is OK. The current version of SQL*Net and the SQL*Net TCP/IP Adapter will need to be removed. Then you will
be able to Install SQL*Net 2.3.3.0.1 and the SQL*Net TCP/IP Adapter 2.3.3.0.1 from the Oracle8 distribution media.)
Please Note: You will need to make sure you have the TCP/IP protocol adapter installed and configured with a valid IP
address for your operating system before continuing. If you are not connect to a network you can set your IP address to be
obtained automatically. If you do not know how to configure TCP/IP please check with your network administrator or
contact Microsoft for assistance.
4.Configure a SQL*Net ALIAS for your Oracle8 database
START -> PROGRAMS -> ORACLE FOR WINDOWS95(NT) -> SQL*Net EASY Configuration.
ADD a database ALIAS.
Name the database ALIAS anything you would like.
Select TCP/IP as your protocol adapter.
Enter 'localhost' for the TCP/IP host name if you are connecting to
a local database.
The database Instance will be the same as the database SID, which is
ORCL if you are using the default database
installed with Oracle8.
5.Start the listener.
Go to a DOS command prompt.
Type: lsnrctl80
At the lsnrct prompt type: start
6.Start up the database
START -> PROGRAMS -> Oracle8 for NT/95 -> Start Database
7.Start up Developer
START -> PROGRAMS -> Developer 2000 r2.x -> Forms Builder
8.Connecting to the database from Forms Builder
FILE -> CONNECT
Username -> system
Password -> manager
Connect String -> (enter in the database ALIAS name that you created
in step 4)
Here are some additional default username/password for Personal Oracle8.
User Name Password
SCOTT TIGER
SYSTEM MANAGER
SYS CHANGE_ON_INSTALL
INTERNAL ORACLE
DEMO DEMO
-----------------------------------------------------------------------------------------------------------------------------
-**** Posted from Supernews, Discussions Start Here(tm) ****- http://www.supernews.com/ - Host to the the World's Discussions & Usenet Received on Wed Nov 11 1998 - 16:22:22 CET