Download Oracal installation package
Enter https://www.oracle.com/index.html Select-->menu-->downloads and trials-->database-->oracle Database
Check the Accept License agreement.
Locate Oracle Database 12c Release 2, select the following file 1 (3.2 GB) See all download (if you don't have an account, just register for download).
Environment:
[email protected], allocating resources: Cpu:2, Memory: 4GB, hard disk space: 30GB
ORACLE12C Enterprise Edition 64-bit
Process Summary:
- Root Install Dependency Package:
Install binutils compat-libcap1 compat-libstdc++-compat-libstdc++-makesysstat UnixODBC unixodbc*.i686 Unixodbc-devel unixodbc-devel*.i686 libxp
To set up users and groups:
Groupadd oinstall groupadd dba groupadd Oper useradd-g oinstall-g dba,oper Oracle " 123456passwd--stdin Oracle #oracle用户的登录密码, follow-up login to use, remember.
To create the installation directory:
Mkdir-p/orcl/app/oracle/product/12.1. 0/db_1 chown-r oracle:oinstall/orcl/775/orcl/app
To modify the kernel parameter vi/etc/sysctl.conf, add:
FS.AIO-MAX-NR =1048576Fs.File-max =6815744Kernel.shmall =2097152 Kernel.shmmax = 1200000000 Kernel.shmmni = 4096 Kernel.sem = 250 32000 100 Span style= "COLOR: #800080" >128 Net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_ Default = 262144 Net.core.rmem_max = 4194304 Net.core.wmem_default = 262144 Net.core.wmem_max = 1048576
- One argument: the above Kernel.shmmax = 1200000000 may be problematic and can be changed to 4098955264. I have a warning when I install it, but when I choose to ignore it, the installation will work.
After the change, make it effective: sysctl-p
- Change file limit: vi/etc/security/limits.conf, add:
2047 16384 1024x76865536
As well as Vi/etc/pam.d/login, add:
Session Required Pam_limits.so
To modify Ulimit:vi/etc/profile, add:
"Oraclethen "/bin/kshthen16384 ulimit-else
Modify environment variables. VI ~oracle/.bash_profile, add:
oracle_base=/orcl/app/Oracle oracle_home= $ORACLE _base/product/12.1. 0/db_1 oracle_sid=orcl export oracle_base oracle_home oracle_sid
#如果已经存在PATH, simply follow the path followed by: $oracle_home . PATH= $ORACLE _home/bin: $PATH export PATH
Download and install the JDK RPM-IVH jdk-8u101-linux-x64.rpm. Java-version.
Restart reboot.
Because I installed the smallest installation, there is no graphical interface, so here to install the X Window graphical interface.
# yum check-update "X window System"
#yum Install gnome-classic-session gnome-terminal nautilus-open-terminal control-center liberation-mono-fonts
Restart reboot.
After logging into the system, execute init 5 to the graphical interface, open the terminal and execute the following command
# SU- oracle /orcl/app/Oracle $ unzip linuxamd64_12102_database_se2_1of2.zip $ unzip Linuxamd64_12102_database_se2_2of2.zip $ export LANG="en_us" / orcl/app/oracle/Database $.
A graphical interface appears and is installed according to your needs.
Start Oracle
#su- Oracle #切换到 Oracle users and switch to its environment $lsnrctl status #查看监听及数据库状态 $lsnrctl start #启动监听$startup #启动服务
Log in and create a namespace, user, table.
Sqlplus/ assysdba #以 DBA into Sqlplus creating tablespace create tablespace my_space datafile'/usr/local/yrm/oracle_data/my_space.dbf'size 50M autoextend on next 50m maxsize 2048m extent management local; creating temporary tablespace create temporary tablespace my_space_tem Ptempfile'/usr/local/yrm/oracle_data/my_space_temp.dbf'size 32mautoextend on next 32m maxsize 1024mextent management local; Creating user create Users C # #my_user_1 identified by123456 defaulttablespace my_spacetemporary tablespace my_space_temp; authorize Grant Connect,resource to C # #my_user_1; Grant DBA to C # #my_ user_1; Switch User conn my_user_1/123456 assysdba; CREATE table test_1 (nameChar( -), IDintinserting data insert into test_1 values ('Zhang San',1) insert into test_1 values ('John Doe',2);
Installation of Oracle 12c under minimal installation centos7.4