Installing the Oracle9i Database

Testing the Oracle9i Database Installation

Exploring the Oracle9i Database Installation

The Oracle Universal Installer requires 400 MB of temporary space on your C: drive to run successfully. If you do not have at least 400 MB on the C: drive, then update the TEMP user variable in your environment variables and change it to a location with the required amount of space. In addition, make sure that the computer has sufficient system memory (the combination of RAM and virtual memory). If the page file size is too small, messages appear indicating that the computer is running low on virtual memory. Check your page file size to make sure that the initial size is 200 MB and the maximum size is 400 MB.

Insert your Oracle9i Datbase Release 2 Enterprise Edition CD-ROM into the CD-ROM drive. In the Autorun window that appears, choose Install/Deinstall Products. If you do not have your laptop set up for Autorun capability, run autorun.exe directly from the AUTORUN directory on your Oracle9i Database Release 2 Enterprise Edition CD-ROM. You will install Oracle9i in its own home directory. Click Next to accept the default Oracle_Home name and location.

In the Welcome window, click Next.

Install Oracle9i Database Release 2 in its own home directory. Make sure it says OraHome92 in the Name field, and that the path is d:\oracle\ora92. Then click Next.

Select Oracle9i Database 9.2.0.1.0. Click Next to accept the default.

Choose Enterprise Edition and then click Next.

Accept the General Purpose default database configuration and click Next.

Click Next.

Click Next.

In the Global Database Name field, enter orcl.world. In the SID field, accept the default, orcl, and then click Next.

11.

Accept the directory to D:\oracle\oradata and click Next.

Accept the default character set and click Next.

The Oracle Universal Installer displays a summary of the installation options. Make sure that you have the required disk space available and then click Install.

The Oracle Universal Installer begins installing Oracle9i Database Release 2 Enterprise Edition and related software. Note: This process takes at least one hour. The Oracle Universal Installer also creates installation logs as it progresses. You can view these while the installation is in progress. The log for this installation session is located at C:\Program Files\Oracle\Inventory\logs\installActions.log. If you install another product, the current log is copied to this file and renamed, so there is always a history of each successive installation.

After the initial software is copied to the disk, the Oracle Universal Installer also automatically configures the network for the Production database. This is done in the background. The success of the operation is reported in the Oracle Universal Installer Configuration Tools window. Once the network configuration has been completed, the Oracle Universal Installer starts the Oracle Database Configuration Assistant. This assistant installs and configures the initial database in the background as well.

Database creation takes about twenty minutes. The progress is shown in the Database Creation Progress window. When the database has been created, the Database NT service is created.

Enter a password for SYS and SYSTEM. Please remember the passwords you choose, they will be used throughout the OBE lessons. Click OK.

Note: The password screen will not allow the old default passwords SYS and SYSTEM of change_on_install and manager to be entered.

When the database has been completely created and all the configuration tools have completed their tasks, the End of Installation window appears. Click Exit and then Yes to exit the Universal Installer.

For more information about the Oracle9i installation process, please see the Oracle9i Installation Guide.

Click Yes.

After creating the database Oracle Enterprise Manager starts in stand alone mode.

Select Start > Programs > Oracle-OraHome92> Enterprise Manager Console.

In the Oracle Enterprise Manager Console login window, make sure that Launch standalone is selected and then click OK. Note: You can launch Enterprise Manager to immediately connect to the database for direct database administration. No configuring is necessary. From this Login window, you can also connect to the Oracle Management Server (OMS) however you need to create an OMS repository first which you will do in another module.

Expand Network then Databases, then click the plus sign to expand ORCL.WORLD.

To log in to the instance, enter system in the Username field and oracle in the Password field, then click OK.

Expand Instance and then select Configuration to see the state of the database. To view the initialization parameters, click the All Initialization Parameters button.

Click the db_name parameter and then click the Description button. A description of the parameter is displayed at the bottom of the window. Click Cancel to close the window.

Notice that you cannot start or stop the database unless you are connected as SYSDBA. Right-click the ORCL.WORLD database and select Connect.

Enter sys in the Username field and oracle in the Password field. Select SYSDBA from the Connect as drop-down list and then click OK.

Expand Instance and then select Configuration. Notice that you now can shut down the database. Select the Shutdown option button and click Apply.

Click OK to accept the default choice and shut down immediately.

When the shutdown is complete, click Close.

Notice that the database is no longer available. Now start it again. Click the Open option button and then Apply.

Click OK.

When the database has been successfully started up, click Close.

Notice that the database has been started. Click the Memory tab.

In the Memory tabbed page, you can see how memory is currently allocated.

When you created your database, the sample schemas (or seeded) are loaded into your database, the HR user cannot log into the database until the password has been changed or that user is unlocked. This lock has been put into place for security purposes. You can unlock the user from Enterprise Manager by expanding Security, then Users, then selecting HR.

Select Unlock then Apply. Unlock the other Sample Schema Users: OE, PM, SH, and QS.

Select File > Exit to close the Enterprise Manager Console.

Unzip postinstall.zip into your working directory.

Open the SQL*Plus session you just created and execute the following commands:

connect sys/oracle@orcl as sysdba
@unlock_users

SET TERMOUT OFF
SET NEWPAGE 0
SET PAGESIZE 0
SET LINESIZE 132
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF

SPOOL unlockusers.sql

SELECT 'ALTER USER '|| username ||' identified by '|| username ||' 
  ACCOUNT UNLOCK;'
  FROM dba_users
  WHERE account_status LIKE '%LOCKED%';

SPOOL OFF

@unlockusers.sql

SET PAGESIZE 14
SET NEWPAGE 1
SET HEADING ON
SET FEEDBACK ON
SET ECHO ON
SET TERMOUT ON

Open Windows NT Explorer and click the drive where you installed the database (for example, D:). Select View > Refresh. Navigate to the D:\Oracle directory. Notice that there are three subdirectories: admin, Ora90, and oradata.

Navigate to the admin directory. The D:\Oracle\admin directory is an OFA-compliant directory that contains information about different database instances installed on this machine. So far it contains one directory, orcl, for the orcl.world instance that you just created.

Navigate back to D:\Oracle\Ora92. This is the Oracle9i software directory, also known as the Oracle9i ORACLE_HOME. All the software for the Oracle9i Enterprise Edition is installed under this directory tree.

Navigate to the D:\Oracle\Ora92\Network\admin directory. This is the directory that the networking files are stored in.

Open the listener.ora file generated during the Oracle Universal Installer installation of Oracle9i.

Notice that the listener has been set to listen for three different types of connections:

	External processes called from the server, using InterProcess Communication (IPC)
	Oracle Net connections from across the network, using TCP/IP, on port 1521

The listener has also been configured with two services:

	An external process server for external procedure calls
	A database service for the ORCL.WORLD instance

Your listener.ora file should look like the following:

# LISTENER.ORA Network Configuration File: 
  d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = smtaylor-lap)(PORT = 1521))
      )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = d:\oracle\ora90)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl.world)
      (ORACLE_HOME = d:\oracle\ora90)
      (SID_NAME = orcl)
    )
  )

Close the file when you are finished.

Open the tnsnames.ora file generated during the Oracle Universal Installer installation of Oracle9i. Change US.ORACLE.COM to WORLD. This is done for simplicity purposes. The examples used through out the series will use this domain name however you may use what ever you would like.

# TNSNAMES.ORA Network Configuration File: 
  d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
ORCL.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = smtaylor-lap)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl.world)
    )
  )
INST1_HTTP.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = smtaylor-lap)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

Save your work and close the file.

Open the SQLNET.ORA file generated during the Oracle Universal Installer installation of Oracle9i. Change the US.ORACLE.COM entry to WORLD. The DEFAULT_DOMAIN name must match the domain name in your TNSNAMES.ORA file.

# SQLNET.ORA Network Configuration File: 
  d:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = WORLD
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

Save your work and close the file.

Navigate to the D:\Oracle\Ora92\Database directory. This directory contains the password files and the default initialization files for each instance created on this machine.

Open the initorcl.ora file. Notice that it contains a reference to the "real" initialization file at D:\oracle\admin\orcl\pfile\initorcl.ora.

Navigate back to D:\oracle\oradata\orcl. This is the directory that contains the data files for each instance that you create on this machine. Explore the contents of this directory.

Select Start > Settings > Control Panel. Scroll down to the list of the services that were added as a result of your installation.

Now that you have installed Oracle9i, you should reboot the machine.