Installing and Configuring Oracle 12c in RHEL/CentOS/Oracle Linux 6.5 – Part II. In this article we will cover installation and configuration of Oracle 12c in RHEL/CentOS/Oracle Linux 6.5, along with some Oracle post installation instructions. Installing Prerequisites for Oracle 12c in RHEL/CentOS/Oracle Linux 6.5 – Part I.
This post will cover basic installation and configuration of Oracle 11g Express Edition (XE) on CentOS. We will also take a quick look at configuring Application Express (APEX) for 11g XE. Basic installation is straight forward. If you just want to get up and running, you can just do steps 1 to 4 below (and 10 and 11 for Apex). The remaining steps (5 to 9) cover basic backup, recovery, and performance configuration.
The full system requirements are Your CentOS box should have swap equal to 2xRAM. On every CentOS installation I have done for XE, I just needed to update/install the packages for libaio, bc, and flex. root@ms3 Disk1# /etc/init.d/oracle-xe configure. Oracle Database 11g Express Edition Configuration.
————————————————-. This will configure on-boot properties of Oracle Database 11g 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. Ctrl-C will abort. Specify the HTTP port that will be used for Oracle Application Express 8080:.
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 11g Express Edition to be started on boot (y/n) y:y. Starting Oracle Net ListenerDone. Configuring databaseDone. Starting Oracle Database 11g Express Edition instanceDone. Installation completed successfully.
The installation created the directory /u01 under which Oracle XE is installed. Step 5: Move the Flash Recovery Area (Fast Recovery Area) To protect against disk failure, you should move the Flash Recovery Area to a separate disk. This is actually now called the Fast Recovery Area, but the existing documentation still refers to it as the Flash Recovery Area If a separate disk is not in your budget you should, at the very least, move the Flash Recovery Area to a partition other than the Oracle installation directory. By default, the Fast Recovery Area will be located under /u01/app/oracle/fastrecoveryarea.
Step 6: Add Redo Log Members to Groups You should have at least two Redo Log Groups and each group should have at least two members. Additionally, the members should be spread across disks (or at least directories) For whatever reason, only one member is created per group on install. You can view the redo log files using SQL SELECT. FROM V$LOGFILE; Since the default location for the two members is the Flash Recovery Area, the two existing members have been moved to our new FRA. You should now add an additional member for each group under /u01/app/oracle/oradata/XE. else. echo Backup of the database succeeded.
echo Log file is at $rmanbackupcurrent. mail -s ‘Oracle Backup Completed’ ‘[email protected]’.
Step 10: Oracle 11g XE and Application Express (APEX) Oracle 11g Express Edition comes with Application Express 4.0.2 already installed. If you elect to upgrade to the latest version (4.1 as of this writing), you can do so but will loose access to the XE GUI. Not a huge loss, but something to keep in mind. Although Apex is already installed, you will need to set the Internal Admin password.
![]()
To do so, run the apxchpwd.sql located under /u01/app/oracle/product/11.2.0/xe/apex: Note: pick something simple like Password123! As you will be prompted to change it on first log in anyways. SQL @/u01/app/oracle/product/11.2.0/xe/apex/apxchpwd.sql.
Enter a value below for the password for the Application Express ADMIN user. Enter a password for the ADMIN user. Session altered. changing password for ADMIN.
PL/SQL procedure successfully completed. Commit complete. SQL You can access the Application Express GUI at: Replace localhost above with your IP or domain as required. Workspace: Internal User Name: admin Password: (whatever you selected above).
Alternatively, you can access via or Again, replace localhost above with your IP or domain as required. Step 11: Oracle 11g XE: Configure EPG or Apex Listener Unless you have a license for Oracle HTTP Server (OHS), your options are the embedded PLSQL Gateway (EPG) or Apex Listener. The Application Express that comes installed with Oracle 11g XE is configured using the EPG. While the EPG is simpler than Apex Listener, it can be painfully slow as of Apex 3.2. Apex Listener, while quite fast, adds an extra layer of complexity. You will need to install an application server to run Apex Listener.
I have run Apex Listener on both Tomcat (unsupported) as well as Oracle GlassFish 3.x (supported) and was not impressed with either. A lot of people who know far more than I do about APEX (read: 99.9999% of the population) like the Apex Listener. Apex Listener and it’s installation guide can be found The Apex Listener installation guide is well done and simple to follow. If you need to install Oracle GlassFish or GlassFish CE (basic installation is the same), you can use my GlassFish 3.1 instructions If you want to be an outlaw and use Tomcat, you can use my Tomcat 6 installation guide or my Tomcat 7 installation guide.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |