RedHatAS5 Oracle10g Database Installation notes

Oracle10g does not support RedHatAS5 by default, but it can also be installed. The following is a simple record of the installation process: install Linux and package GCC and other development classes to reduce installation

Oracle 10 Gb does not support RedHat AS5 by default, but it can also be installed. The following is a simple record of the installation process: install Linux and package GCC and other development classes to reduce installation

Oracle 10 Gb does not support RedHat AS5 by default, but it can also be installed. The following is a simple record of the installation process:

Install Linux and package GCC and other development classes to reduce the environment configuration during installation.

Configure Linux for Oracle

Create an ORACLE user:

/Usr/sbin/groupadd oinstall/usr/sbin/groupadd dba/usr/sbin/useradd-m-g oinstall-G dba oracle
Create directory: the default directory is the root directory, which is not recommended in the production environment.

Mkdir-p/u01/app/oracle mkdir-p/u02/oradata chown-R oracle: oinstall/u01/app/oracle/u02/oradata chmod-R 775/u01/app/oracle/u02/oradata
Set SHELL restrictions for Oracle users to improve security:

Vi/etc/security/limits. conf Add the following content:

Oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
Modify:

Vi/etc/pam. d/login Add the following content:

Session required/lib/security/pam_limits.so
Log on with an Oracle user, modify user variables, and set the Oracle installation directory and Database Name:

Vi. bash_profile ORACLE_BASE =/u01/app/oracle; export ORACLE_BASE ORACLE_SID = demo1; export ORACLE_SID
Create a directory in the Oracle logon status:

Mkdir 10g_db
Put the Oracle 10g installation package in this directory

Note: If the installation file is stored under ROOT, grant the permission of this directory to Oracle.

Chmod oracle-R 777 \ 10g_db
Run:

$./RunInstaller
Welcome
Click Next.
Specify the List Directory and Certificate
If you have been following the steps in this Guide, use the default value. Otherwise, edit the path of the List Directory to point to the correct directory.
The operating system group name should be oinstall.
If this is the first time Oracle is installed on this machine, you will receive a pop-up window prompting you to run the orainstRoot. sh script as a root user. Log on as a root user, change to the directory specified in the window, execute the script, and continue the operation.
Specify File Location
If you have been following the steps in this Guide, use the default value. Otherwise, make sure that the source path and target path are correct before proceeding.
Select the installation type
Accept the default Enterprise Edition.
Inspection of prerequisites related to specific products
If you have been following the steps in this Guide, all checks should pass smoothly. If one or more checks fail, rectify the problem before continuing.
Select Database Configuration
Accept the default values Create a starter database and General Purpose.
Specify Database Configuration Options
Enter the Global Database Name of the database. This name should contain ORACLE_SID and server domain name (for example, demo1.orademo.org, where demo1 is ORACLE_SID and orademo.org is a domain name ).
When you enter a global database name, the SID box is automatically filled.
Accept the default database character set.
Select Create database with sample schemas.
Select Database Management Options
Select Use Database Control for Database Management.
Specify database file storage options
Select File System and enter the path name used by the database File (/u02/oradata in this example ).
Backup and recovery options
Select Do not enable automatic backups.
Database mode password
Select Use the same password for all the accounts.
Select a password and enter it twice for confirmation.
Summary
Displays the summary of installed products.
Click Install.
Install

This screen goes through several phases of installing and linking Oracle software.

When the installation process ends, a window is displayed, showing the configuration information. Write down the Enterprise Manager URL and click OK to close the window.
A "Setup Privileges" window is displayed, prompting you to run the configuration script as the root user. Log on as a root user, switch to the directory indicated in this window, and then execute the root. sh script. This script prompts you to enter the location of the local bin directory. Press Enter to accept the default value. When the script is complete, return to the Setup Privileges window and click OK.

Start the database:

Start and Stop iSQL * Plus:

$ Isqlplusctl start $ isqlplusctl stop
Start and Stop listeners:

The Listener accepts client connection requests and creates a database connection after verifying the certificate. To use OEM or iSQL * Plus, you must first start the listener.

$ Lsnrctl start $ lsnrctl stop
Start and Stop a database:

The simplest way to start and stop a database is to start and stop it from the OEM console. To perform this operation from the command line, use SQL * Plus after logging on as an oracle user, as shown below:

Start:

$ Sqlplus SQL * Plus: Release 10.1.0.2.0-Production on Sun Jun 13 22:27:48 2004 Copyright (c) 1982,200 4, Oracle. all rights reserved. enter user-name:/as sysdba Connected to an idle instance. SQL> startup ORACLE instance started.