- Before You Install Oracle
To install the Oracle products on your personal computer, you must first install the client applications on the Oracle Developer CD.
FYI - These applications include SQL*Plus, which is the command-line SQL utility, as well as Form Builder, Report Builder, Graphics Builder, Procedure Builder, and Query Builder, which are used to create queries and user applications.
Then, you need to install the Personal Oracle database, which is the DBMS that stores and manages the data.
Finally, you need to configure your computer so the Oracle Developer client applications can connect to the Personal Oracle database.
- Hardware Requirements
Your computer should have at least 64 MB of main memory; 96 MB of main memory are recommended. It must have a Pentium 166 MHz processor, and at least 600 MB of free hard drive space.
- Software Requirements
Your computer must have the Windows 95 or Windows 98 operating system, and must be configured to support TCP/IP networking operations.
- To install Oracle Developer:
- Insert the Oracle Developer CD in the CD-ROM drive on your computer. The Oracle Installer program starts. This is the program that is used to install all Oracle products. The Language dialog box is displayed.
HELP? If the Oracle Installer does not start automatically, start Windows Explorer, navigate to your CD-ROM drive and double-click the setup.exe file.
- Confirm that English is selected as the default language, and then click OK. The Oracle Installation Settings dialog box is displayed.
- Type the Company Name of your choice
- The default Oracle Home directory is C:\ORAWIN95. Change the default Oracle Home directory to C:\ORA95DEV, and then click OK. This will be the Developer Home directory
- When the Oracle Developer Options dialog box is displayed, confirm that the Typical option button is selected, and then click OK.
- When the System Support Files dialog box is displayed, click OK. The Installing dialog box is displayed. The installation process will take several minutes.
- When the Installation Successful dialog box is displayed, click OK.
- When the Reboot Needed dialog box is displayed, click OK, close all of the open windows, and then reboot your computer.
- Installing the Personal Oracle 8i Database on Windows 98 Computers
- Insert the Personal Oracle CD in your CD-ROM drive. The Oracle8i Personal Edition dialog box is displayed.
- Click Install/Deinstall Products. The Oracle Universal Installer dialog box is displayed. Click Next. The File Locations dialog box is displayed
- Accept the default Source file entry. Change the Destination Name entry to PERSONAL_ORACLE and the Path entry to C:\ORA95PO, and then click Next. The Loading Product Information dialog box is displayed.
- When the Available Products page is displayed, click the Oracle8i Minimal Installation option button, and then click Next.
- When the Type of Starter Database? page is displayed, make sure that the Standard Starter Database (97 MB) option button is selected, and then click Next.
- When the Database Identification page is displayed, accept the default global database name, which is oracle, and then click Next. Note that the SID (system identifier) for your database is ORCL.
- When the Summary page is displayed, click Install. The Install page is displayed. The installation process will take several minutes.
- When the End of Installation dialog box is displayed, click Exit.
- Close all open windows and dialog boxes, and then reboot your computer.
- After your computer is rebooted, proceed to the section titled "Configuring and Testing the Personal Oracle Database."
- Configuring and Testing the Personal Oracle Database
To use the Personal Oracle database with client utilities like SQL*Plus or Oracle Developer, you must first start the Oracle Listener process, which is a program that listens for database requests from the client utility, and then routes the requests to the Personal Oracle database running on your computer. Then, you start the database. Finally, you start the client utility, and log on using a user name, password, and connect string.
- Creating a Connect String in tnsnames.ora (Windows 95 and Windows 98)
A connect string is a text string that is used by the Listener to route the data requests to the correct Oracle database. The connect string is associated with the database name, the database SID, and the IP address of the computer where the database is running. For your Personal Oracle database, the database name is oracle, and the SID is ORCL. When you are connecting to a personal database that is running on your local workstation, the IP address of the local workstation can be referenced using the keyword localhost. The association between the database and the connect string is created in a configuration file named tnsnames.ora. Every Oracle Home directory has a separate tnsnames.ora file. This is a text file that can be modified using a text editor like Windows Notepad.
Before you can connect to the database from a client utility, you must first create a connect string in the tnsnames.ora files in the Developer Home directory on your computer.
- To create a connect string in the tnsnames.ora file:
- Start Windows Explorer, and navigate to the C:\Ora95dev\Net80\Admin folder. (Your drive letter might be different). Open the Tnsnames.ora file in Notepad. This file contains several sample connect string entries for different network protocols.
- Copy my own TNSNAMES.ORA, which I have working successfully in my PC:
po8.world =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = localhost)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Note: When you connect to the database you should use po8.world as the connect string.
- Starting the Oracle Listener
The next step is to start the Oracle Listener. The Oracle Listener is a program stored in a file named tnslsnr.exe that is stored in the \BIN folder in the Personal Oracle Home directory. When you start the Listener, you will need to specify the port that the Listener will listen for database requests on as a command line parameter to the Listener program (port is associated with a memory location). The default port associated with Oracle database requests is port 1521.
The command to start the Listener is slightly different depending on if you are using Windows 95 (Personal Oracle 8.0.4) or Windows 98 (Oracle 8i). Now you will start the Oracle Listener. Be sure to use the specific command sequence that is associated with your operating system and personal database.
- To start the Oracle Listener (Windows 95 Oracle 8.0.4 users):
Click Start on the taskbar, click Run, type c:\ora95po\bin\tnslsnr80.exe port=1521, and then click OK (your drive letter might be different). The tnslsnr80 window is displayed, indicating that the Oracle Listener is running. Minimize the window.
- To start the Oracle Listener (Windows 98 Oracle 8i users):
Click Start on the taskbar, click Run, type c:\ora95po\bin\tnslsnr.exe port=1521, and then click OK (your drive letter might be different). The tnslsnr window is displayed, indicating that the Oracle Listener is running. Minimize the window.
- Starting the Personal Oracle Database
To start the Personal Oracle database (Windows 98 Personal Oracle 8i users):
Click Start on the taskbar, point to Programs, point to Oracle - PERSONAL_ORACLE, point to Database Administration, and then click Start Database. The Oracle8i Startup dialog box is displayed. A series of progress messages are displayed. When the message "Oracle8i database started successfully" is displayed, click OK. Note that the Personal Oracle database icon is displayed in the bottom right corner of the taskbar.
- Connecting from the Client Applications to the Personal Oracle Database
Now you will start SQL*Plus, and connect to the Personal Oracle database. (This process is the same for both Windows 95 and Windows 98 users.) When you first install an Oracle database, some default database administration accounts exist. You will log on to the database using the default account named system, which has the password manager. For the connect string, you will type po8.world, which is the connect string text that you specified in the tnsnames.ora file.
IMPORTANT NOTE
Just to be on the safe side, once you are logged in as a SYSTEM, create a new userid and grant enough access to it to get you up and running. Using SYSTEM userid can be very dangerous, if you accidentaly delete one of the data dictionary's tables or some system tables you may have to reinstall the whole thing and you will have to start from square one.
|
