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. 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 RequirementsYour 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. You must also have a network card or modem, and be able to connect to the Internet. (You will not be connected to the Internet when you are using Oracle, but you must have the hardware and software so that you can connect to the Internet.) Software RequirementsYour computer must have the Windows 95 or Windows 98 operating system, and must be configured to support TCP/IP networking operations. (If you can connect to the Internet, then your computer is configured to support TCP/IP networking operations.) What is Included in the Software Installation KitThe Software Installation Kit includes 3 CDs: the Oracle Developer CD, which can be installed on both Windows 95 and Windows 98 computers; the Oracle8 Personal Edition release 8.0.4 CD, which will be used to install the Personal Oracle database on Windows 95 computers; and, the Oracle8i Personal Edition release 8.1.5 CD, which will be used to install the Personal Oracle database on Windows 98 computers. You will also need to install the Oracle help files, which are included on the Oracle8 Personal Edition release 8.0.4 CD. Installing and Configuring the Oracle Products The Oracle Developer and Personal Oracle products must each be installed in a separate folder on your workstation, which is called the product's Oracle Home directory. This is because each product has a similar set of files that are used to configure the product and make it run correctly, and the product looks for its configuration files in its Oracle Home directory. Oracle Developer must be installed first, and Personal Oracle must be installed second. If you have previously installed any Oracle products on your computer, you need to remove them using the Oracle Installer, and delete all of the Oracle entries in the system registry. Otherwise, you might receive error messages during the installation process that will cause the installation to fail. Installing Oracle DeveloperThe Oracle Developer CD can be used with either the Windows 95 or Windows 98 installation. The first step in the installation process is to install the Oracle Developer client applications (Form Builder, Report Builder, Graphics Builder, Procedure Builder, and Query Builder), which are the client applications used to create queries and user applications. To install Oracle Developer: 1. 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. 2. Confirm that English is selected as the default language, and then click OK. The Oracle Installation Settings dialog box is displayed.3. Type the Company Name of your choice. 4. 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. TIP: If the drive letter where you have 600 MB of free disk space is different than C, type this drive letter instead. 5. When the Path Modifications dialog box is displayed, click Yes to enable the Installer program to add the location of the Oracle executable files to your system's path. HELP? An error message might display stating that you have an "UNBOUND VARIABLE ERROR", and the Oracle Installer will immediately exit. This is caused by an error in the PATH command in your autoexec.bat file – sometimes when programs automatically update autoexec.bat, they do not do it properly, and this causes problems for other programs that need to modify the file. Open autoexec.bat (which is located in the C:\ folder) in Notepad, and "clean up" the PATH command so it looks something like this: PATH=C:\;"C:\Program Files\Mts". There should be no extra PATH or %PATH% entries anywhere in the autoexec.bat file. Save autoexec.bat, reboot your computer, and start the installation process over. 6. When the Oracle Developer Options dialog box is displayed, confirm that the Typical option button is selected, and then click OK.7. When the System Support Files dialog box is displayed, click OK. The Installing dialog box is displayed. The installation process will take several minutes.8. When the Installation Successful dialog box is displayed, click OK.9. 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 DatabaseThe next step is to install and configure the Personal Oracle database. Windows 95 users will install the Personal Oracle 8.0.4 database, and Windows 98 users will install the Personal Oracle8i database. A separate CD is provided for each of these Personal Oracle databases, and the installation steps are slightly different for each database. Installing the Personal Oracle 8.0.4 Database on Windows 95 ComputersTo install the Personal Oracle 8.0.4 database: 1. Insert the Personal Oracle 8.0.4 (Windows 95) CD in your CD-ROM drive. The Oracle8 Personal Edition – Autorun window is displayed. HELP? If the program does not automatically start, start Windows Explorer, navigate to your CD-ROM drive and run setup.exe on the CD. 2. Click Begin Installation. The Oracle Installation Settings dialog box is displayed. Enter the Company Name of your choice.3. In the Oracle Home frame, type PERSONAL_ORACLE for the Name, and C:\ORA95PO for the Location. Make sure that English is selected as the default Language, and then click OK. The Select Installation Options dialog box is displayed. TIP: If the drive letter where you have 600 MB of free disk space is different than C, then type this drive letter instead. 4. Make sure that the Application Developer (Complete) option button is selected, and then click OK. The Starter Database Installation Options dialog box is displayed.5. Make sure that the Standard (40 M disk space) option button is selected, and then click OK. The Installing Oracle Documentation dialog box is displayed.6. Make sure that the CD-ROM option button is selected, and then click OK. The Installing dialog box is displayed. The installation process will take several minutes.7. When the Installation Completed dialog box is displayed, click No to decline viewing the Oracle Documentation. The Reboot Needed dialog box is displayed.8. Click OK, close all open windows, and then reboot your computer.9. After your computer is rebooted, proceed to the section titled “Configuring and Testing the Personal Oracle Database.” Installing the Personal Oracle 8i Database on Windows 98 ComputersTo install the Personal Oracle database (Windows 98): 1. Insert the Personal Oracle CD in your CD-ROM drive. The Oracle8i Personal Edition dialog box is displayed. HELP? If the program does not automatically start, start Windows Explorer, navigate to your CD-ROM drive and run setup.exe on the CD. 2. Click Install/Deinstall Products. The Oracle Universal Installer dialog box is displayed. Click Next. The File Locations dialog box is displayed. HELP? If the Next button is disabled, click Deinstall Products, and then click Close. The button should now be enabled. 3. 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. TIP: If the drive letter where you have 600 MB of free disk space is different than C, then type this drive letter instead. 4. When the Available Products page is displayed, click the Oracle8i Minimal Installation option button, and then click Next.5. If the Warning page is displayed stating that you do not have 96 MB of RAM, click Next. The software appears to run successfully with 64 MB of RAM.6. 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.7. 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.8. When the Summary page is displayed, click Install. The Install page is displayed. The installation process will take several minutes.9. When the End of Installation dialog box is displayed, click Exit.10. Close all open windows and dialog boxes, and then reboot your computer. 11. After your computer is rebooted, proceed to the section titled “Configuring and Testing the Personal Oracle Database.” Configuring and Testing the Personal Oracle DatabaseTo 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. In some applications, the connect string is called a host string or database. 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 IP address 127.0.0.1. 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: 1. 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. The sample name TcpExample looks like this: TcpExample.world = (DESCRIPTION= (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = Production1) (Port = 1521) ) ) (CONNECT_DATA = (SID = ORCL) ) ) The first line of the connect string entry (in this case, TcpExample) specifies the actual connect string text that the user will type to log on to the Oracle database. Now you will copy the example TCP connect string, and modify it. You will change the connect string text to PO8, and you will modify the Host entry to match your IP address, which is 127.0.0.1. The SID entry will not need to be modified, since it is already ORCL. To create the new connect string entry:1. Copy all of the TcpExample connect string text, as shown in the above example.2. Place the insertion point at the bottom of the file, and then paste the copied text.3. Modify the pasted entry as follows: po8.world = (DESCRIPTION= (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 127.0.0.1) (Port = 1521) ) ) (CONNECT_DATA = (SID = ORCL) ) ) 2. Save the file, and then exit Notepad. Starting the Oracle ListenerThe 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):1. 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):1. 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 DatabaseNext, you will start the Personal Oracle database. The commands for starting the database are slightly different for Windows 95 (Personal Oracle 8.0.4) and Windows 98 (Personal Oracle 8i). To start the Personal Oracle database (Windows 95 Personal Oracle 8.0.4 users):1. Click Start on the taskbar, point to Programs, point to Oracle8 Personal Edition – PERSONAL_ORACLE, and then click Start Database. The Oracle8 Startup dialog box is displayed. A series of progress messages are displayed. When the message "Oracle8 database started successfully" is displayed, click OK. Note that the Personal Oracle database icon is displayed in the bottom right corner of the taskbar. To start the Personal Oracle database (Windows 98 Personal Oracle 8i users): 1. 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 DatabaseNow 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, which is the connect string text that you specified in the tnsnames.ora file. To start SQL*Plus and connect to the Personal Oracle database: 1. Click Start on the taskbar, point to Programs, point to Oracle for Windows 95, and click SQL Plus 8.0. The Log On dialog box is displayed.2. Type system for the User Name, manager for the Password, and po8 for the Host String, and then click OK. The SQL> prompt is displayed.3. Close SQL*Plus. Next, you will check to confirm that the Form Builder, Report Builder, and Graphics Developer utilities can connect to the Personal Oracle database. (If these utitilties can connect to the database, then the other Developer utilities will be able to connect also.) First, you will start Form Builder, and then connect using the user name system, password manager, and connect string po8. To confirm that Form Builder can connect to the database:1. Click Start on the taskbar, point to Programs, point to Oracle Developer 6.0, and click Form Builder. The Welcome to the Form Builder dialog box is displayed.2. Click the Build a new form manually option button, and then click OK. The Object Navigator window is displayed.3. Click File on the menu bar, and then click Connect. The Connect dialog box is displayed.4. Type system for the User Name, manager for the Password, and po8 for the Database (recall that in some applications, the connect string is called the database) and then click connect. If no error message is displayed, then you have successfully connected to the database.5. Exit Form Builder. Now you will start Report Builder and Graphics Builder, and confirm that you can connect to the database. To start Report Builder and Graphics Builder and connect to the database:1. Click Start on the taskbar, point to Programs, point to Oracle Developer 6.0, and click Report Builder. The Welcome to Report Builder dialog box is displayed.2. Click the Build a new report manually option button, and then click OK.3. Click File on the menu bar, and then click Connect. The Connect dialog box is displayed.4. Type system for the User Name, manager for the Password, and po8 for the Database and click connect. If no error message is displayed, then you have successfully connected to the database.5. Exit Report Builder.6. Click Start on the taskbar, point to Programs, point to Oracle Developer 6.0, and click Graphics Builder. The Graphics Builder Object Navigator window is displayed.7. Click File on the menu bar, click Connect, and then confirm that you can log on to the database in Graphics Builder using the same User Name, Password, and Database as before. If no error message is displayed, then you have successfully connect to the database. Close Graphics Builder, and do not save your changes. Shutting Down the Personal Oracle DatabaseEven when you are not working in one of the Oracle client utilities, the Personal Oracle database and the Oracle Listener are still running on your computer and using memory and system resources. First, you will shut down the database. The process is slightly different depending on whether you are a Windows 95 (Personal Oracle 8.0.4) or Windows 98 (Personal Oracle 8i) user, so use the steps associated with your system configuration. To shut down the Personal Oracle database (Windows 95 Personal Oracle 8.0.4 users):1. Click Start on the taskbar, point to Programs, point to Oracle8 Personal Edition – PERSONAL_ORACLE, point to Database Administration, and click Stop Database. The Oracle8i Shutdown dialog box is displayed. When the "Oracle8i database is shutdown" message is displayed, click OK. Note that the database icon is no longer displayed in the lower right corner of your taskbar. To shut down the Personal Oracle database (Windows 98 Personal Oracle 8i users): 1. Click Start on the taskbar, point to Programs, point to Oracle – PERSONAL_ORACLE, point to Database Administration, and click Stop Database. The Oracle8i Shutdown dialog box is displayed. When the "Oracle8i database is shutdown" message is displayed, click OK. Note that the database icon is no longer displayed in the lower right corner of your taskbar. Shutting Down the Oracle ListenerNow you will shut down the Oracle Listener. Since this is a DOS-based program, you cannot shut it down by simply closing the program window, because this might damage some of your system files. You will shut down the Oracle Listener by pressing Ctrl + C on the keyboard. This process is about the same for both Windows 95 and Windows 98 users. 1. Click tnslsnr80 on the taskbar. (Windows 98 users will click tnslsnr on the taskbar.) The tnslsnr80 window is displayed. (Windows 98 users will see the tnslsnr window.)2. Press Ctrl + C. The tnslsnr window is closed, and the Listener process is now shut down. Using the Personal Oracle Database When you use the Personal Oracle database and the Oracle, you must always start the Oracle Listener first, and then start the Personal Oracle database. If the database is started before the Listener is started, then applications will not successfully connect to the database. Therefore, when you use the Oracle utilities on your computer on a daily basis, always perform the following operations in the order specified: 1. Ensure that the Personal Oracle database is not running. If it is running, shut it down. 2. Start the Oracle Listener. 3. Start the Personal Oracle database.4. Start the client utility (SQL*Plus, Form Builder, Report Builder, Graphics Builder, etc.) that you wish to use. Installing and Accessing the Oracle Help Files To access on-line help while you are working the tutorials and exercises, you will need to copy the ora.hlp file from the Personal Oracle 8.0.4 CD. You will create a folder named MSHELP in the Personal Oracle Home directory, and then copy the file into this folder. To install the Oracle help files:1. Start Windows Explorer, navigate to the C:\Ora95po folder, and create a subfolder named MSHELP. (Your drive letter might be different.)2. Place the Personal Oracle 8.0.4 CD in your CD-ROM drive, navigate to the Doc\Hlpdoc80 subfolder, and copy ora.hlp to the MSHELP folder in the C:\Ora95po.3. To run the on-line help search engine, double-click ora.hlp in Windows Explorer.
|
Articles 
