CentOS6.5 Installation Simplified Oracle Database tutorial

Download the software package to the official website, first register an account number, download is a compressed package, extract the oracle-xe-11.2.0-1.0.x86_64.rpm. There are only 64-bit versions under Linux.

1, install the dependent package

Yum Install Libaio libaio-devel bc-y

2. Install Oracle Express Edition
Use root user action.

CD ~
wget http://download.oracle.com/otn/linux/oracle11g/xe/oracle-xe-11.2.0-1.0.x86_64.rpm.zip? Authparam=1409379226_d26581af452e67b3a2b04fe09ee28749-o Oracle-xe-11.2.0-1.0.x86_64.rpm.zip
Unzip Oracle-xe-11.2.0-1.0.x86_64.rpm.zip
CD Disk1
RPM-IVH oracle-xe-11.2.0-1.0.x86_64.rpm

The system will be detected when installed, the best memory 1g,swap requirements are twice times the memory.

[Root@server01 disk1]# RPM-IVH oracle-xe-11.2.0-1.0.x86_64.rpm
Preparing ... ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing post-install steps ...

You are must run '/etc/init.d/oracle-xe configure ' as the root user to configure the database.

3, the expansion of the TMPFS to 2G
Tmpfs less than 2G, the next execution of the settings command will error:

Database Configuration failed. Look into/u01/app/oracle/product/11.2.0/xe/config/log for details

1) Modify/etc/fstab file

Vim/etc/fstab

Will:

TMPFS/DEV/SHM TMPFS Defaults 0 0

To

Tmpfs/dev/shm Tmpfs defaults,size=2048m 0 0

2) Reload Tmpfs

Umount/dev/shm
Mount/dev/shm

3) Check

Df-h/DEV/SHM
FileSystem Size Used Avail use% mounted on
None 2.0G 243M 1.8G 12%/DEV/SHM

4, follow the prompts to set up

/etc/init.d/oracle-xe Configure

[Root@server01 disk1]#/etc/init.d/oracle-xe Configure

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This would configure on-boot properties of Oracle 11g Express
Edition. The following questions would determine whether the database should
Be starting upon system boot, the ports it would use, and the passwords that
'll is used for database accounts. Press to accept the defaults.
Ctrl-c would abort.

Specify the HTTP port that'll be used for Oracle application Express [8080]:8081

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

Specify a password to is used for database accounts. The same
Password'll is used for SYS and SYSTEM. Oracle recommends the use of
Different passwords for each database account. This can is done after
Initial configuration:
Confirm the password:

Do your want Oracle Database 11g Express Edition to is started on boot (y/n) [y]:y

Starting Oracle Net Listener ... Done
Configuring Database ... Done
Starting Oracle Database 11g Express Edition instance ... Done
Installation completed successfully.

The four entries are: port at HTTP access, listener port for database, SYS and system user's password, whether to boot up (no boot started, maybe some place to set up).

When the installation is complete, a user named Oracle, home directory/u01/app/oracle, is automatically established.
A DBA group is established and the Oracle user belongs to this group.
An instance of the database is automatically generated, called XE. /u01/app/oracle/product/11.2.0/xe/dbs/spfilexe.ora

HTTP Admin Address:

http://server ip:8081/

Log in with SYS or system user.

5. Set Oracle Environment variables

Vim/etc/profile

Join:

Export Oracle_base=/u01/app/oracle
Export Oracle_home=/u01/app/oracle/product/11.2.0/xe
Export path= $PATH: $ORACLE _home/bin
Export Oracle_sid=xe

After setting, log off the user to log in again, you can use Sqlplus.

6, into the Sqlplus console

Sqlplus/nolog

Sql> Connect as Sysdba
Enter User-name:sys
Enter Password:
Connected.
Sql>
You can do other things later.

Start command:
Startup
Close command:
Shutdown