Oracle 9i installation under Open Unix 8

This article will introduce the installation process of Oracle Database 9i in Open Unix 8. If you have experience installing Oracle, you can use the quick installation manual. If you have never installed Oracle databases before, from this article, we will be familiar with the oracle installation process.

System Requirements:

The following system requirements apply to typical Oracle Installation and creation of simple databases.

Memory:

Installing Oralce 9i requires at least MB of memory

Exchange zone:

The size of the swap area is generally twice the size of the memory, at least MB

Optical Drive:

If you use a CD to install Oracle9i, you need a CDROM of more than 8 speeds on your computer. If you download the oracle9i package file, you do not need to use the CDROM.

Hard Disk Space:

The installation of the Oracle9i database requires at least GB of space.

Temporary hard disk space: the Oracle installer requires more than MB of temporary hard disk space during installation. We recommend that you use the/tmp folder as the zero-time folder. If the/tmp file does not have enough hard disk space, you can create a new folder as the temporary directory for installation, and then set the environment variables TEMP and TMPDIR to the corresponding location, for example:

Use bash

 
 

  
  
mkdir /home/temp   
  
  
TEMP=/home/temp ; export TEMP   
  
  
TMPDIR=/home/temp ; export TMPDIR  
 
 

Use csh

 
 

  
  
mkdir /home/temp   
  
  
setenv TEMP /home/temp   
  
  
setenv TMPDIR /home/temp  
 
 

Operating System:

Caldera Open Unix 8 (LKP software package must be installed)

JDK

If you want to install Oracle HTTP Server and also need to use blackdown JDK 1.3.1, please go to the following address to download the ftp://ftp.progsoc.uts.edu.au/pub/Linux/java/JDK-1.3.0/i386/rc1/j2sdk-1.3.0-RC1-linux-i386.tar.bz

Configure Kernel Parameters

Oracle9i uses Open UNIX 8 shared memory, swap zone and other resources for work. If your kernel parameter settings do not meet the requirements of oracle, problems may occur frequently when installing javasel9i or using it, therefore, it is particularly important and critical to configure system kernel parameters.

 
 

  
  
Shared Memory SHMMAX 0.5 * (physical memory in machine)   
  
  
SHMMIN 1   
  
  
SHMMNI 100   
  
  
SHMSEG 15   
  
  
Semaphores SEMMNI 10000   
  
  
SEMMSL 300   
  
  
SEMMNS 610   
  
  
SEMOPM 20   
  
  
Process limits SCORLIM 0x7FFFFFFF   
  
  
HCORLIM 0x7FFFFFFF   
  
  
SDATLIM 0x7FFFFFFF   
  
  
HDATLIM 0x7FFFFFFF   
  
  
SVMMLIM 0x7FFFFFFF   
  
  
HVMMLIM 0x7FFFFFFF   
  
  
SFSZLIM 0x7FFFFFFF   
  
  
HFSZLIM 0x7FFFFFFF   
  
  
HFNOLIM 2048   
  
  
SFNOLIM 128   
  
  
NPROC 12500   
  
  
Other NPBUF 100   
  
  
MAXUP 5000   
  
  
RECRVRETRIES 10000   
  
  
FLCKREC 2000  
 
 

Install Open Unix 8 Patch

1. Download Patchftp: // ftp.caldera.com/pub/openunix8/ou800pk2/ou800pk2.image

2. Log On with the root user and enter the following command:

$ Su-

Password:

# Cat ou800pk2. image | pkgadd-d-

3. restart the computer

# Shutdown-g0

Add User

Specific users rather than root users are required for Oracle Installation and Use. According to oracle standards, three special users and user groups need to be added, to facilitate the installation and use of oracle, you can install and use oracle to a specific user.

First, create an oracle user group. Set this user group to dba:

Log on to the system as a root user;

Run # groupadd dba command to add a dba user group;

Add oracle users:

Log on to the system as a root user;

Run useradd-g dba-s/usr/bin/ksh-d/home/oracle-m oracle.

After running, the system creates a user oracle belonging to the dba user group. The main directory is/home/oracle using ksh.

Set Oracle Password

Log on to the system as a root user;

Run passwd oracle and enter the password

This user will be installed and used as the specified user, so it should be properly saved!

Create a mount point)

The typical installation of oracle9i requires at least two installation points: one installation of the basic operating program requires at least MB of hard disk space; the other is to store the database, requiring at least MB of hard disk space. To simplify installation, we can install the running program and database under the same installation point.

Find a partition with sufficient space on your file system and create a folder under the partition. Assume that the folder is/home/oracle.

Prepare to run KDE

Create a/home/oracle/. xinitrc File

Add/linux/usr/bin/startkde>/dev/null 2> & 1

Configure system environment variables

Many netizens failed to install oracle because the environment variables were not correctly configured. The configuration of the environment variables directly affects the later installation and configuration of oracle9i. Be careful when configuring the environment variables!

The following is an example for your reference.

 
 

  
  
ORACLE_HOME=/home/oracle/product/9.0.1; export ORACLE_HOME   
  
  
ORACLE_SID=oracle; export ORACLE_SID   
  
  
LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH   
  
  
NLS_LANG=american_america.ZHS16GBK; export NLS_LANG   
  
  
PATH=$PATH:$ORACLE_HOME/bin   
  
  
export PATH   
  
  
TMPDIR=/tmp;export TMPDIR   
  
  
umask 022  
 
 

Where:

ORACLE_HOME is the installation directory of system software;

ORACLE_SID is the SID of the database. You can set it here;

NLS_LANG is the character set of the database. To ensure that the database can output the input database, we need to set the character set to american_america.ZHS16GBK here, where american_america English character set and ZHS16GBK is the Chinese character set.

Log on to the system as an oracle user,

Log on to oracle again

Install Oralce9i

The installation of oracle9i supports almost all x-windows and remote virtual x-windows installation.

Run the startx command to go to x-windows.

After running, the kde interface will appear on your remote terminal several seconds later.

Open a console window and go to the directory where the oracle files are stored.

 
 

  
  
gunzip Linux9i_Disk1.cpio.gz   
  
  
cpio -idmv   
  
  
gunzip Linux9i_Disk2.cpio.gz   
  
  
cpio -idmv   
  
  
gunzip Linux9i_Disk3.cpio.gz   
  
  
cpio -idmv  
 
 

Command to decompress the three packages into three installation folders: Disk1, Disk2, and Disk3.

Go to the Disk1 directory

Cd Disk1

In the console window

./RunInstaller &

After running, an oui gui is displayed. The green window in the middle is the GUI for oracle installation.

Next we will perform the most basic installation of oracle9i. after entering the installation interface, click Next to go to the Next step:

Source refers to a file that contains Oracle product information. Generally, it automatically identifies the file. If it cannot be found, you can use the Browse button to manually specify the path.

Destination refers to the 9i installation path. Here we set $ ORACLE_HOME in the environment variable, if this column is blank, you need to re-check whether the values in the environment variables are set incorrectly. Confirm the correctness and click Next to proceed to the Next step:

Three installation options are available in this step:

Oracle9i Database 9.0.1.0.0: Install the Database server version, Administrative Tools, network services, and basic client software of oracle9i;

Oracle9i Client 9.0.1.0.0, enterprise Client software, network services, and development tools.

Oracle9i Mangement and Integration 9.0.1.0.0, install the Management Server, manage the network directory, integrated services, network services, and basic client software of Oracle.

Select the first option to install Oracle9i Database Service, and click "Install Next;

This step is to select the Oracle Installation type. There are three types to choose from: Enterprise Edition, Enterprise Edition, Standstard Edition, Peugeot Edition, and Custom installation. We select the Enterprise Edition installation, if you are familiar with Oracle products, you can choose Custom installation, select components for installation as needed, and then click Next to go to the Next step;

Here you can select a database template that is suitable for you. Generally, we select the first common database template. If you need to use a data warehouse, you can use a data warehouse template for installation. After confirmation, press Next to proceed to the Next step;

This step is to confirm the SID of Oracle9i and the Name of the Global Database. The SID value has been set in the environment variable, so it is automatically displayed here. The Global Database Name is Global Database Name) we can also specify the same value as SID. After confirmation, press Next to go to the Next step;

As we mentioned above, the character type of the database is critical in database supersteps. This step is to set the character set of the database. Previously we set NLS_LANG = american_america.ZHS16GBK, so we choose Simplifiled Chinese ZHS16GBK and press Next to go to the Next step;

Because we have selected the Enterprise version for installation, the system will install Oracle Web Server. JDK is required to install Oracle Web Server, we use the Browse button to specify the JDK directory so that the system can find the desired application during the installation process, and confirm to press Next to go to the Next step;

After all the options are selected, the system will provide an installation overview, which lists the components you have selected for installation. After confirming that everything you want to Install is in the list, Install the Install button, if you do not need to install other programs, press Exit to Exit the installation interface.

The installation speed of Oracle depends on the server performance. Generally, it takes 30 minutes to install it. A dialog box may pop up during the installation process. In the dialog box, some commands that need to be run by root must be executed, in this case, another console window is opened, su becomes root, and the commands in the prompt box are run. After the operation is complete, follow the instructions to continue the installation;

After the database is installed, the system runs the configuration tool to configure the network and database of the system. After the configuration is complete, the system automatically starts the database and enables the Oracle Web Server. After all the configurations are complete, click Next to complete the installation.

If everything is normal, OUI will see The Installation Of Oracle9i Database Was successful. this indicates that your Oracle9i Database is properly installed. If you want to Install other content, press the Next Install button to Install other content. Otherwise, press Exit to Exit the installation.

Use Oracle 9i Database

After the installation is complete, the Oracle database will be automatically started. Next we will use the actual supersteps to describe how to start and close the Oracle 9i Database.

Log on to the database as an oracle user and open a console window;

Shut down the Oracle 9i Database

$ Sqlplus "/as sysdba" // log on to the database as a sysdba user

 
 

  
  
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jul 11 15:35:31 2001   
  
  
 
  
  
(c) Copyright 2001 Oracle Corporation. All rights reserved.   
  
  
Connected to:   
  
  
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production   
  
  
With the Partitioning option   
  
  
JServer Release 9.0.1.0.0 - Production  
 
 

Run the shudown command to close the database.

 
 

  
  
SQL> shutdown  
  
  
Database closed.  
  
  
Database dismounted.  
  
  
ORACLE instance shut down.  
  
  
SQL> 
 
 

Start Oracle 9i Database

 
 

  
  
[oracle@wing bin]$ sqlplus " / as sysdba"  
  
  
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jul 11 16:00:59 2001  
  
  
(c) Copyright 2001 Oracle Corporation. All rights reserved.  
  
  
Connected to an idle instance.  
  
  
SQL> startup  
  
  
ORACLE instance started.  
  
  
Total System Global Area 336356520 bytes  
  
  
Fixed Size 279720 bytes  
  
  
Variable Size 268435456 bytes  
  
  
Database Buffers 67108864 bytes  
  
  
Redo Buffers 532480 bytes  
  
  
Database mounted.  
  
  
Database opened.  
  
  
SQL> 
 
 

Start the Oracle 9i listener

Oracle listeners provide interfaces for client connection.

 
 

  
  
$ lsnrctl  
  
  
LSNRCTL for Linux: Version 9.0.1.0.0 - Production on 11-JUL-2001 16:12:17  
  
  
Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.  
  
  
Welcome to LSNRCTL, type "help" for information.  
  
  
LSNRCTL> start  
  
  
Starting /oracle/product/9.0.1/bin/tnslsnr: please wait...  
  
  
TNSLSNR for Linux: Version 9.0.1.0.0 - Production  
  
  
System parameter file is /oracle/product/9.0.1/network/admin/listener.ora  
  
  
Log messages written to /oracle/product/9.0.1/network/log/listener.log  
  
  
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))  
  
  
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OU8)(PORT=1521)))  
  
  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))  
  
  
STATUS of the LISTENER  
  
  
------------------------  
  
  
Alias LISTENER  
  
  
Version TNSLSNR for Linux: Version 9.0.1.0.0 - Production  
  
  
Start Date 11-JUL-2001 16:12:58  
  
  
Uptime 0 days 0 hr. 0 min. 0 sec  
  
  
Trace Level off  
  
  
Security OFF  
  
  
SNMP OFF  
  
  
Listener Parameter File /oracle/product/9.0.1/network/admin/listener.ora  
  
  
Listener Log File /oracle/product/9.0.1/network/log/listener.log  
  
  
Listening Endpoints Summary...  
  
  
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))  
  
  
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OU8)(PORT=1521)))  
  
  
Services Summary...  
  
  
Service "PLSExtProc" has 1 instance(s).  
  
  
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...  
  
  
Service "oracle" has 1 instance(s).  
  
  
Instance "oracle", status UNKNOWN, has 1 handler(s) for this service...  
  
  
The command completed successfully  
  
  
LSNRCTL> 
 
 

Disable the Oracle 9i listener

 
 

  
  
[oracle@wing bin]$ lsnrctl  
  
  
LSNRCTL for Linux: Version 9.0.1.0.0 - Production on 11-JUL-2001 16:12:17  
  
  
Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.  
  
  
Welcome to LSNRCTL, type "help" for information.  
  
  
LSNRCTL> stop  
  
  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))  
  
  
The command completed successfully  
  
  
LSNRCTL> 
 
 

Disable Oracle Web Server

 
 

  
  
cd $ORACLE_HOME/Apache/Apache/bin  
  
  
./stopJServ.sh  
  
  
/oracle/product/9.0.1/Apache/Apache/bin/apachectl stop: httpd stopped 
 
 

Start Oracle Web Server

 
 

  
  
cd $ORACLE_HOME/Apache/Apache/bin  
  
  
$ ./startJServ.sh  
  
  
/oracle/product/9.0.1/Apache/Apache/bin/apachectl start: httpd started 
 
 

After Oracle Web Server is started, the default port number is 7777.

Enter http://xxx.xx.xxx.xxx: 7777/in the client browser address bar/