Installing Oracle 10g On Linux 4.5

How to installing Oracle 10g

1. Open a terminal window. Login as the root user.

2. Create these operating system groups: oinstall, dba, and, oper.

/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/groupadd oper

3. Create the operating system user oracle:

/usr/sbin/useradd -g oinstall -G dba,oper -d /home/oracle oracle

4. Enter the following command to set the password of the oracle user:

/usr/sbin/passwd oracle

5. With an editor of your choosing edit /home/oracle/.bash_profile to include the following entries:

umask 022

PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
ORACLE_SID=orcl


PATH=$ORACLE_HOME/bin:$PATH
export PATH LD_LIBRARY_PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID

6. Create the directory for the software installation and assign ownership to oracle:oinstall.

mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app
chmod -R 775 /u01/app

7. Open the /etc/sysctl.conf file in any text editor and add lines similar to the following:

kernel.sem = 250 32000 100 128
kernel.shmmax = 2147483684
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.msgmnb = 360000
kernel.msgmni = 2878
kernel.msgmax = 8192
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

8. Issue this command to set the kernel parameters:
/sbin/sysctl -p

9. Required RPMs.

binutils-2.15.92.0.2-15
compat-db-4.1.25-9
control-center-2.8.0-12.rhel4.2
gcc-3.4.4-2
gcc-c++-3.4.4-2
glibc-2.3.4-2.13
libc-common-2.3.4-2.13
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.4-2
libstdc++-devel-3.4.4-2
make-3.80-5
pdksh-5.2.14-30.3
sysstat-5.0.5-11.rhel4

To check the installed RPMs, run this command:

rpm -qa binutils \
compat-db \
control-center \
gcc \
gcc-c++ \
glibc \
glibc-common \
gnome-libs \
libstdc++ \
libstdc++-devel \
make \
pdksh \
sysstat sort

10. Exit from root user.

11. Connect as oracle in a Xterm enabled window to begin the installation.
Mount the Oracle Database 10g DVD.
Execute the script //database/runInstaller from oracle's home directory, /home/oracle.
Download Oracle 10g(10.2.0.1) on Linux

Example:
/media/cdrecorder/database/runInstaller

12. Select Advanced Installation. Click Next.

13. Specify Inventory directory and credentials
Verify the Inventory Directory: /u01/app/oracle/oraInventory
Operating Group: oinstall
Click Next.

14. Select Installation Type
Select Enterprise Edition (1.24 GB)
Click Product Languages.

15. Language Selection
Click the double arrow ( >> ) to select all.
Click OK.
Click Next.

16. Specify Home Details
Verify the name for the installation:
OraDb10g_home1
Verify the path:
/u01/app/oracle/product/10.2.0/db_1
Click Next.

17. Product-Specific Prerequisite Checks
The installer will now verify the system meets all the minimum requirements for installing and configuring the chosen product. The checks should all succeeds. If so, click Next. If not consult the installation manual and verify all prerequisites have been met..

18. Select Configuration Option
Select Create a database.
Click Next.

19. Select Database Configuration
Select General Purpose.
Click Next.

20. Specify Database Configuration Options
Global Database Name: orcl.oracle.com
SID: orcl
Database Character Set: Unicode standard UTF-8 AL32UTF8
Check box next to Create database with sample schemas
Click Next.

21. Select Database Management Option
Select Use Database Control for Database Management.
Click Next.

22. Specify Database Storage Option
Select File System
Click Next.

23. Specify Backup and Recovery Options
Select Do not enable Automated Backups
Click Next.

24. Specify Database Schema Passwords
Select Use the same password for all accounts
Password: oracle
Click Next.

25. On the Summary Screen: Click Install.

26. Click OK, when the Database Configuration Assistant completes.

Execute Configuration Scripts
Open a terminal window and execute these steps:

su -
/u01/app/oracle/oraInventory/orainstRoot.sh
/u01/app/oracle/product/10.2.0/db_1/root.sh
exit


27. After executing the scripts, click OK.

28. At the End of Installation screen click Exit, then click Yes

Unlock accounts

1. Unlock and assign passwords to all locked schemas in the database. Open a text editor and create a text file named unlock.sh which contains (cut and paste):

sqlplus -S /nolog < connect / as sysdba
SET LINESIZE 132
SET PAGESIZE 0
SET TERMOUT OFF
SET NEWPAGE 0
SET SPACE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SPOOL x.sql
SELECT 'ALTER USER 'username' IDENTIFIED BY 'username' ACCOUNT UNLOCK;'
FROM dba_users
WHERE account_status LIKE '%LOCK%';
SPOOL OFF
@x.sql
!rm x.sql
exit
<
2. Change permissions on file unlock.sh to make it executable, then execute it.

chmod u+x unlock.sh
./unlock.sh