Installation of Oracle10g on LINUX
Table of Contents
1. Pre-installation Tasks for the ORACLE 10g Database.
2. Installing the ORACLE 10g Database.
3. Post-installation tasks for the ORACLE 10g Database.
4. Testing the installation.
Pre-installation Tasks for the ORACLE 10g Database. Before starting the oracle 10g installation ,several parameters must be checked.
To perform these checks login as the root user or switch user to root using the command su – root.
Checking Memory and Swap space.
For successful installation of Oracle 10g, the system is required to have atleast 512MB of RAM and 1 GB of Swap space.You can verify this using :--
grep MemTotal /proc/meminfo grep SwapTotal /proc/meminfo
Checking /tmp space.
The Oracle Universal Installer requires 400 MB of free space in the /tmp directory. The command to check this is as follows:--
df /tmp
Checking The Existence of following Softwares/RPM Packages.The following packages or later versions must be installed :---
· make-3.79.1· gcc-3.2.3-34· glibc-2.3.2-95.20· glibc-devel-2.3.2-95.20· compat-db-4.0.14-5· compat-gcc-7.3-2.96.128· compat-gcc-c++-7.3-2.96.128· compat-libstdc++-7.3-2.96.128· compat-libstdc++-devel-7.3-2.96.128· gnome-libs-1.4.1.2.90-34.1· openmotif21-2.1.30-8· setarch-1.3-1· libaio-0.3.96-3· libaio-devel-0.3.96-3
Check the existence of the above packages by issuing the following command:--
rpm -q make gcc glibc glibc-devel compat-db compat-gcccompat-gcc-c++ compat-libstdc++ gnome-libs openmotif setarch libaio libaio-devel
If any packages are not installed first install them using the command :--rpm -ivh
Note:---Oracle Database 10g while being installed detects the Linux Distribution via a file called redhatrelease.
Oracle Database 10g can be installed only on Redhat Enterprise Linux Advance Server 2.1 and 3.
TO install Oracle Database 10g on Fedora Core
A file called /etc/redhat-release needs to be edited to make Oracle Database 10g believe that itis running on an appropriate Linux Version. (Since it does not support Fedora Core.)
To accomplish this type in the following command at the prompt :--
cp /etc/redhat-release /etc/redhat-release.backup
Now type in the following command to change the current distribution's identity. cat >> /etc/redhat-release <<>Red Hat Enterprise Linux AS release 3 (Taroon)>EOF
Changing Kernel Parameters--
The file /etc/sysctl.conf contains all the basic system parameters and is read during the boot process.Open this file in any text editor and carefully type in the following lines:--
kernel.shmmax = 2147483648
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
These modifications will cause the system to change the kernel parameters after each boot so as to make the system compatible for running Oracle 10g.
Creating Oracle User accounts.su -root groupadd dba groupadd oinstall useradd -c “Oracle Software Owner” -g oinstall -G dba oracle passwd oracle
Creating Oracle Directoriesmkdir -p /u01/app/oracle chown -R oracle.oinstall /u01
Setting the Oracle Environment.
To set the oracle environment variables automatically each time the oracle user logs in issue the following commands:--
su oracle cat >> ~oracle/.bashrc <<>export ORACLE_BASE=/u01/app/oracle>export ORACLE_SID=SCT>EOF
The next step is to unset the ORACLE_HOME and TNS_ADMIN VariablesDo this as follows :--
su oracle unset ORACLE_HOME unset TNS_ADMIN
Once the variable are unset change the user back to the root by typing in the following command at the prompt :--
exit
Next the xhost needs to be executed .This is done to disable the access control mechanism of the system.
xhost +
Installing The Oracle Database 10gIn order to begin the installation issue the following commands in case of Fedora :--
su oracle /media/cdrecorder/runInstaller
After issuing these commands the Oracle Installation will begin.Thereafter go on following the instructions int installations.
During the installation when the dialog box telling the completion of Database Configuration Assistant appears click on that the Password Management button and unock the following accounts :--· SCOTT· PM· IX· SH· OE· HRThen go in following the instructions and complete the installation of Database.
Post installation tasks for the Oracle Database 10g
Type in the following command :--
kate /home/oracle/.bashrc
Append the following lines
export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/Db_1export PATH=$PATH:$ORACLE_HOME/bin
Save and exit the file.Testing the Installation.
Close any open Shell Windows.Open a new shell window.After logging in as oracle , type in the following commands:--
sqlplus
Enter the user name as scott and issue the query:--
select * from dept;
.................................to test the Installation.
If some table is displayed as output then CONGRATS !! Your installation was successful
1. Pre-installation Tasks for the ORACLE 10g Database.
2. Installing the ORACLE 10g Database.
3. Post-installation tasks for the ORACLE 10g Database.
4. Testing the installation.
Pre-installation Tasks for the ORACLE 10g Database. Before starting the oracle 10g installation ,several parameters must be checked.
To perform these checks login as the root user or switch user to root using the command su – root.
Checking Memory and Swap space.
For successful installation of Oracle 10g, the system is required to have atleast 512MB of RAM and 1 GB of Swap space.You can verify this using :--
Checking /tmp space.
The Oracle Universal Installer requires 400 MB of free space in the /tmp directory. The command to check this is as follows:--
Checking The Existence of following Softwares/RPM Packages.The following packages or later versions must be installed :---
· make-3.79.1· gcc-3.2.3-34· glibc-2.3.2-95.20· glibc-devel-2.3.2-95.20· compat-db-4.0.14-5· compat-gcc-7.3-2.96.128· compat-gcc-c++-7.3-2.96.128· compat-libstdc++-7.3-2.96.128· compat-libstdc++-devel-7.3-2.96.128· gnome-libs-1.4.1.2.90-34.1· openmotif21-2.1.30-8· setarch-1.3-1· libaio-0.3.96-3· libaio-devel-0.3.96-3
Check the existence of the above packages by issuing the following command:--
If any packages are not installed first install them using the command :--
Note:---Oracle Database 10g while being installed detects the Linux Distribution via a file called redhatrelease.
Oracle Database 10g can be installed only on Redhat Enterprise Linux Advance Server 2.1 and 3.
TO install Oracle Database 10g on Fedora Core
A file called /etc/redhat-release needs to be edited to make Oracle Database 10g believe that itis running on an appropriate Linux Version. (Since it does not support Fedora Core.)
To accomplish this type in the following command at the prompt :--
Now type in the following command to change the current distribution's identity.
Changing Kernel Parameters--
The file /etc/sysctl.conf contains all the basic system parameters and is read during the boot process.Open this file in any text editor and carefully type in the following lines:--
kernel.shmmax = 2147483648
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
These modifications will cause the system to change the kernel parameters after each boot so as to make the system compatible for running Oracle 10g.
Creating Oracle User accounts.
Creating Oracle Directories
Setting the Oracle Environment.
To set the oracle environment variables automatically each time the oracle user logs in issue the following commands:--
The next step is to unset the ORACLE_HOME and TNS_ADMIN VariablesDo this as follows :--
Once the variable are unset change the user back to the root by typing in the following command at the prompt :--
Next the xhost needs to be executed .This is done to disable the access control mechanism of the system.
Installing The Oracle Database 10gIn order to begin the installation issue the following commands in case of Fedora :--
After issuing these commands the Oracle Installation will begin.Thereafter go on following the instructions int installations.
During the installation when the dialog box telling the completion of Database Configuration Assistant appears click on that the Password Management button and unock the following accounts :--· SCOTT· PM· IX· SH· OE· HRThen go in following the instructions and complete the installation of Database.
Post installation tasks for the Oracle Database 10g
Type in the following command :--
Append the following lines
export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/Db_1export PATH=$PATH:$ORACLE_HOME/bin
Save and exit the file.Testing the Installation.
Close any open Shell Windows.Open a new shell window.After logging in as oracle , type in the following commands:--
Enter the user name as scott and issue the query:--
select * from dept;
.................................to test the Installation.
If some table is displayed as output then CONGRATS !! Your installation was successful
Comments
Post a Comment