发布时间：2025-06-24 18:16:05  作者：北方职教升学中心  阅读量：137

配置安全

vi /etc/selinux/config

修改SELINUX=enforceing使其等于SELINUX=disabled

setenforce 0

7、下载依赖包

2、修改内核参数

vim /etc/sysctl.conf

fs.aio-max-nr=1048576fs.file-max =6815744kernel.shmmax=5033164800kernel.shmall=1228800kernel.shmmni =4096kernel.sem =25032000100128net.ipv4.ip_local_port_range =900065500net.core.rmem_default =262144net.core.rmem_max =4194304net.core.wmem_default =262144net.core.wmem_max=1048586#kernel.panic_on_oops =1vm.nr_hugepages =2500

生效

sysctl -p

6、创建目录并赋予权限

mkdir -p /u01/app/oracle/product/19.3.0chown -R oracle:oinstall /u01chmod -R 775 /u01su - oraclecd /opt/ls

4、配置Oracle环境变量

su - oracle vi ~/.bash_profile

exportPS1="[`whoami`@`hostname`:"'$PWD]$'exportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=/u01/app/oracle/product/19.3.0exportPATH=$PATH:$ORACLE_HOME/bin:/usr/local/binexportORACLE_HOSTNAME=p19cdbexportORACLE_SID=p19cdbexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/network/lib:/lib:/usr/libexportCLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlibexportNLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"

生效

. .bash_profile

三 安装Oracle数据库

1.解压到Oracle安装目录

cd/optunzip-qLINUX.X64_193000_db_home.zip -d$ORACLE_HOMEcd$ORACLE_HOME/install/responsecpdb_install.rsp db_install.rsp.bak

2.编辑响应文件

sed-i's/^oracle.install.option=/oracle.install.option=INSTALL_DB_SWONLY/g'db_install.rspsed-i's/^UNIX_GROUP_NAME=/UNIX_GROUP_NAME=oinstall/g'db_install.rspsed-i's#^INVENTORY_LOCATION=#INVENTORY_LOCATION=/u01/app/oraInventory#g'db_install.rspsed-i's#^ORACLE_HOME=#ORACLE_HOME=/u01/app/oracle/product/19.3.0#g'db_install.rspsed-i's#^ORACLE_BASE=#ORACLE_BASE=/u01/app/oracle#g'db_install.rspsed-i's/^oracle.install.db.InstallEdition=/oracle.install.db.InstallEdition=EE/g'db_install.rspsed-i's/^oracle.install.db.OSDBA_GROUP=/oracle.install.db.OSDBA_GROUP=dba/g'db_install.rspsed-i's/^oracle.install.db.OSOPER_GROUP=/oracle.install.db.OSOPER_GROUP=oper/g'db_install.rspsed-i's/^oracle.install.db.OSBACKUPDBA_GROUP=/oracle.install.db.OSBACKUPDBA_GROUP=backupdba/g'db_install.rspsed-i's/^oracle.install.db.OSDGDBA_GROUP=/oracle.install.db.OSDGDBA_GROUP=dgdba/g'db_install.rspsed-i's/^oracle.install.db.OSKMDBA_GROUP=/oracle.install.db.OSKMDBA_GROUP=kmdba/g'db_install.rspsed-i's/^oracle.install.db.OSRACDBA_GROUP=/oracle.install.db.OSRACDBA_GROUP=racdba/g'db_install.rspsed-i's/^oracle.install.db.rootconfig.executeRootScript=/oracle.install.db.rootconfig.executeRootScript=false/g'db_install.rsp

3.查看是否编辑成功

catdb_install.rsp |grep'oracle.install.option'catdb_install.rsp |grep'UNIX_GROUP_NAME'catdb_install.rsp |grep'INVENTORY_LOCATION'catdb_install.rsp |grep'ORACLE_HOME'catdb_install.rsp |grep'ORACLE_BASE'catdb_install.rsp |grep'oracle.install.db.InstallEdition'catdb_install.rsp |grep'oracle.install.db.OSDBA_GROUP'catdb_install.rsp |grep'oracle.install.db.OSOPER_GROUP'catdb_install.rsp |grep'oracle.install.db.OSBACKUPDBA_GROUP'catdb_install.rsp |grep'oracle.install.db.OSDGDBA_GROUP'catdb_install.rsp |grep'oracle.install.db.OSKMDBA_GROUP'catdb_install.rsp |grep'oracle.install.db.OSRACDBA_GROUP'catdb_install.rsp |grep'oracle.install.db.rootconfig.executeRootScript'

4.使用响应文件运行Oracle Universal Installer

cd$ORACLE_HOME./runInstaller -silent-responseFile/u01/app/oracle/product/19.3.0/install/response/db_install.rsp

切换root用户下执行以下命令

/u01/app/oraInventory/orainstRoot.sh/u01/app/oracle/product/19.3.0/root.sh

四 创建Oracle实例

1.配置监听

netca /silent /responseFile /u01/app/oracle/product/19.3.0/assistants/netca/netca.rsp

2.创建数据库

cd/u01/app/oracle/product/19.3.0/assistants/dbcacpdbca.rsp dbca.rsp.bak

sed-i's/^gdbName=/gdbName=p19cdb/g'dbca.rspsed-i's/^sid=/sid=p19cdb/g'dbca.rspsed-i's/^databaseConfigType=/databaseConfigType=SI/g'dbca.rspsed-i's/^templateName=/templateName=General_Purpose.dbc/g'dbca.rspsed-i's/^sysPassword=/sysPassword=123/g'dbca.rspsed-i's/^systemPassword=/systemPassword=123/g'dbca.rspsed-i's/^emConfiguration=/emConfiguration=DBEXPRESS/g'dbca.rspsed-i's/^dbsnmpPassword=/dbsnmpPassword=123/g'dbca.rspsed-i's#^datafileDestination=#datafileDestination=/u01/app/oracle/oradata#g'dbca.rspsed-i's/^characterSet=/characterSet=AL32UTF8/g'dbca.rspsed-i's/^totalMemory=/totalMemory=3100/g'dbca.rsp

执行安装

dbca -silent-createDatabase-responseFile/u01/app/oracle/product/19.3.0/assistants/dbca/dbca.rsp

这是密码的格式问题不用管

五 启动数据库

sqlplus / as sysdba

查看实例状态

selectinstance_name,status from v$instance;

查看数据库状态

selectname,open_mode from v$database;

创建表测试一下

create table cs (idnumber , name varchar2(10));insert into cs values (1,'a');insert into cs values (2,'b');commit;select* from cs;

结束

相关链接：
https://blog.csdn.net/qq_38768446/article/details/143578876?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522f3e2d97d4d0662b180937e1c34e2ad8f%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=f3e2d97d4d0662b180937e1c34e2ad8f&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allfirst_rank_ecpm_v1~times_rank-1-143578876-null-null.142^v101control&utm_term=oracle19c%E5%AE%89%E8%A3%85%E6%95%99%E7%A8%8B&spm=1018.2226.3001.4187