Wednesday, January 18, 2017

How To Install Oracle XE Database 11g Release 2 on Cent OS Linux 7

Step 1) Download the Oracle Database Express Edition 11g Release 2


http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

Step 2) Copy the file oracle-xe-11.2.0-1.0.x86_64.rpm.zip to the remote machine using WinSCP




Step 3) Unzip the file  oracle-xe-11.2.0-1.0.x86_64.rpm.zip 




Step 4) Navigate to Disk1 directory




Step 5) Execute below command with root user for installation


     rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm


Step 6) Execute '/etc/init.d/oracle-xe configure' as the root user to configure the database





Step 7) Login to oracle user and Export ORACLE_HOME & ORACLE_SID


[oracle@test1 ~]$ cat /etc/oratab
XE:/u01/app/oracle/product/11.2.0/xe:N
[oracle@test1 ~]$
[oracle@test1 ~]$ ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
[oracle@test1 ~]$ export ORACLE_HOME
[oracle@test1 ~]$ export PATH=$ORACLE_HOME/bin:PATH
[oracle@test1 ~]$ export ORACLE_SID=XE
[oracle@test1 ~]$


Step 8) Check Listener Status


lsnrctl status



Conclusion: Listener is up and running
Note: If not running in that case run the command 'lsnrctl start'


Step 9) Check the database status




Conclusion: Database is up and running & it can accept read write requests
Note: If not running execute sql command 'SQL> startup'

No comments:

Post a Comment