记一次Linux Centos 7+ 安装Oracle 19c过程(包含卸载)

背景：公司服务器搬家，从阿里云迁到医院机房服务器。系统 Linux Centos 7+

步骤：

1. 配置hosts  

先用ifconfig 查看一下本机内网ip。我的主机名是  localhost

echo "192.168.11.101 localhost localhost">> /etc/hosts

 

2.关闭防火墙

systemctl stop firewalld

systemctl disable firewalld

 

3.准备安装目录

mkdir /opt/oracle

 

4.准备预先安装的包(从oracle官网下载，大约2.5g)

oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm 

 

5.根据提示安装所需要的包：

yum -y install compat-libstdc++-33 ksh libaio-devel

 

6.修改密码:

passwd oracle

7.手工目录授权

chown -R oracle:oinstall /opt/oracle

chmod -R 775 /opt/oracle

 

8.下载安装oracle-database-servrer:

rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm

 

9.准备配置文件：

cp /etc/sysconfig/oracledb_ORCLCDB-19c.conf /etc/sysconfig/oracledb_orcl-19c.conf

vi /etc/sysconfig/oracledb_orcl-19c.conf

cp /etc/init.d/oracledb_ORCLCDB-19c /etc/init.d/oracledb_orcl-19c

vi /etc/init.d/oracledb_orcl-19c

//全局替换

:%s/ORCLCDB/orcl/g

:%s/ORCLPDB1/orcl/g

 

export ORACLE_VERSION=19c

export ORACLE_SID=orcl

export TEMPLATE_NAME=General_Purpose.dbc

export CHARSET=ZHS16GBK

export PDB_NAME=orcl

export LISTENER_NAME=LISTENER

export NUMBER_OF_PDBS=1

export CREATE_AS_CDB=false

:wq!

 

10.创建数据库：

 /etc/init.d/oracledb_orcl-19c configure

检查环境：

su - oracle

ps -ef|grep smon

echo $ORACLE_HOME

lsnrctl status

Ø 测试停止、启动

/etc/init.d/oracledb_orcl-19c

Usage: /etc/init.d/oracledb_orcl-19c {start|stop|restart|configure}

# /etc/init.d/oracledb_orcl-19c stop

# /etc/init.d/oracledb_orcl-19c start

 

11.环境变量配置：

su - oracle

echo "export LANG=en_US" >> ~/.bash_profile

echo "export ORACLE_BASE=/opt/oracle" >> ~/.bash_profile

echo "export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1" >> ~/.bash_profile

echo "export ORACLE_UNQNAME=orcl" >> ~/.bash_profile

echo "export ORACLE_SID=orcl" >> ~/.bash_profile

echo "NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG" >> 

~/.bash_profile

echo "export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/bin" >> ~/.bash_profile

source ~/.bash_profile

env |grep ORACLE

 

12. 常规启动/关闭

Oracle数据库关闭

sqlplus “/as sysdba”

shutdown immediate;

exit;

lsnrctl stop

Ø Oracleo数据库启动

sqlplus “/as sysdba”

startup;

exit;

lsnrctl start

 

 

13.Ø 日志路径

select * from v$diag_info;

Ø Oracle 表空间创建

create tablespace ceshispace datafile '/oracle/app/oracle/oradata/orcl/ceshispace01.dbf' size 10m;

Ø Oracle 用户创建

create user ceshi identified by ceshi01 default tablespace ceshispace;

grant dba to ceshi;

 

14.sqlplus / as sysdba;

conn ceshi/ceshi01;

create table ceshitable(id number(12) primary key, name varchar(20)) ;

Ø Oracle 数据插入

insert into ceshitable values(1,'ceshidata01'); 

insert into ceshitable values(2,'ceshidata02'); 

commit;

Ø Oracle 数据查询

select * from ceshitable;

 

 

15卸载数据库

su - oracle

$ cd $ORACLE_HOME/bin 

$ ./dbca

$ cd $ORACLE_HOME/bin 

$ ./netca

root:

# yum -y remove oracle-database-ee-19c