top navigation
Ritesh Mandal Dr.
   

ORACLE 10 g Express Edition [ Oracle XE ]

 
  << Back to Homepage <<                   Previous <<< OpenClinica page 1                         Next >>> OpenClinica page 3  
   
INSTALL Oracle XE  : Considering the past experiences with oracle installation XE is almost painless and install in just few minutes. You would need swap space more than 1 GB, /usr directory to be over 4GB and a package libaio to be installed.

[ritesh@clinresearch ~]$ cd /home/ritesh/Documents/
[ritesh@clinresearch Documents]$ su root
Password:
[root@clinresearch Documents]# ls
oracle-xe-univ-10.2.0.1-1.0.i386.rpm*
[root@clinresearch Documents]# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
error: Failed dependencies:
libaio >= 0.3.96 is needed by oracle-xe-univ-10.2.0.1-1.0.i386

libaio package is required to install oracle

Download libaio package and install.

[root@clinresearch Documents]# rpm -ivh libaio-0.3.96-3.i386.rpm
Preparing... ########################################### [100%]
1:libaio ########################################### [100%]


At least 1GB swap space is required for Oracle XE to install. I never had , so got this error.

 
[root@clinresearch Documents]# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
Preparing... ########################################### [100%]
This system does not meet the minimum requirements for swap space. Based on
the amount of physical memory available on the system, Oracle Database 10g
Express Edition requires 1024 MB of swap space. This system has 897 MB
of swap space. Configure more swap space on the system and retry the installation.
error: %pre(oracle-xe-univ-10.2.0.1-1.0.i386) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping oracle-xe-univ-10.2.0.1-1.0
[root@clinresearch Documents]#



Manipulated the Disc Partition to resize swap space.

[root@clinresearch Documents]# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
Preparing... ########################################### [100%]
1:oracle-xe-univ ########################################### [100%]
Executing Post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to
configure the database.
[root@clinresearch Documents]# /etc/init.d/oracle-xe configure


Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:8081 (If you have other services running in port 8080 like apache tomcat then change the port)

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8081/apex"
[root@clinresearch Documents]#



If you have reached this page for OpenClinica installation with Oracle XE, Click here for next set of instructions
.
 
How to uninstall Oracle XE  :

You need to be root to perform admin functions
[ritesh@clinresearch ~]$ su root
Password:

Check what oracle is installed (using grep)
[root@clinresearch ritesh]# rpm -qa | grep oracle
oracle-xe-univ-10.2.0.1-1.0

Remove rpm (with no dependency option)
[root@clinresearch ritesh]# rpm -e --nodeps oracle-xe-univ

Remove folders generated by oracle install (using force and recursive options)
[root@clinresearch ritesh]# rm -fR /usr/lib/oracle/xe
[root@clinresearch ritesh]# rm -fR /etc/oratab
[root@clinresearch ritesh]# rm -fR /etc/init.d/oracle-xe
[root@clinresearch ritesh]# rm -fR /etc/sysconfig/oracle-xe


Resources : www.oracle.com
 

  MY TUTORIALS FOR BEGINNERS :
Medical Coding | Web Designing | Oracle | MySQL | Linux | Java | ICH GCP | Clinical Data Management | Indian Clinical Trials | 21 CFR Part 11 | Web server | PHP | 443 & SSL | Web Hosting | GXP India | Apache | Other Databases | Image Editing | Software validation | Networking | Guitar | Disclaimer of use
 
© www.riteshmandal.com
Contact : ritesh@riteshmandal.com