Oracle 12C 安装
DB:Oracle 12.2.0.1.0
OS: Red Hat Enterprise Linux Server release 7.5 (Maipo)
安装包下载,前期环境准备等可参考:
http://blog.itpub.net/29785807/viewspace-2673708/
一:上传安装包
二:创建目录
三:设置环境变量
四:安装 Oracle 软件
五:创建数据库
六 创建测试数据
一:上传安装包
--- linuxx64_12201_database.zip
[root@cjcos package]# pwd
/package
[root@cjcos package]# ll -rth
total 7.5G
drwxr-xr-x. 2 oracle oinstall 42 Jan 16 12:05 Oracle_1903_for_Linux
-rw-r--r-- 1 oracle oinstall 3.3G Jan 19 10:36 linuxx64_12201_database.zip
-rw-r--r-- 1 oracle oinstall 4.3G Jan 19 10:55 LINUX.X64_180000_db_home.zip
二:创建目录
[root@cjcos yum.repos.d]# mkdir -p /u01/app/oracle12
[root@cjcos yum.repos.d]# chown -R oracle:oinstall /u01/app/oracle12
[root@cjcos yum.repos.d]# chown -R oracle:oinstall /u01/app/oraInventory
[root@cjcos yum.repos.d]# chmod -R 775 /u01/app
[root@cjcos yum.repos.d]# su - oracle
[oracle@cjcos ~]$ mkdir -p /u01/app/oracle12/product/12.0.0/dbhome_1
[oracle@cjcos ~]$ cd /u01/app/oracle12/product/12.0.0/dbhome_1
三:设置环境变量
[oracle@cjcos ~]$ vi .bash_profile
export PATH
#export ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE=/u01/app/oracle12
#export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORACLE_HOME=$ORACLE_BASE/product/12.0.0/dbhome_1
#export ORACLE_SID=cjcdb
export ORACLE_SID=cjcdb01
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
[oracle@cjcos ~]$ source .bash_profile
四:安装 Oracle 软件
[oracle@cjcos package]$ unzip /package/linuxx64_12201_database.zip
[oracle@cjcos package]$ cd database/ [root@cjcos ~]# xhost +
access control disabled, clients can connect from any host
[oracle@cjcos dbhome_1]$ cd /package/database/
[oracle@cjcos database]$ ./runInstaller
[root@cjcos ~]# /u01/app/oracle12/product/12.0.0/dbhome_1/root.sh
五:创建数据库
[oracle@cjcos ~]$ lsnrctl start
[oracle@cjcos ~]$ dbca
六 创建测试数据
[oracle@cjcos admin]$ pwd
/u01/app/oracle12/product/12.0.0/dbhome_1/network/admin
[oracle@cjcos admin]$ vim tnsnames.ora
SQL> alter session set container=cjcpdb01;
SQL> create user cjc identified by cjc;
SQL> grant connect,resource,dba to cjc;
SQL> conn cjc/cjc@cjcpdb01
欢迎关注我的微信公众号"IT小Chen",共同学习,共同成长!!!