CentOS 7.9 安装Oracle 13c并开启ipv6

下载相关安装包

preinstall rpm 包

下载链接：https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

rpm安装包

下载链接：https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

下载oracle-database-ee-19c-1.0-1.x86_64.rpm

安装

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

yum localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

安装完成显示

[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure
  Verifying  : oracle-database-ee-19c-1.0-1.x86_64                                                                                                                                                                                                                        1/1 

Installed:
  oracle-database-ee-19c.x86_64 0:1.0-1                                                                                                                                                                                                                                       

Complete!

按照提示使用root执行

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

配置完成,配置过程比较慢要耐心等待

Configuring Oracle Database ORCLCDB.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

使用NetCA配置 oracle监听服务

切换到oracle用户

将/opt/oracle/product/19c/dbhome_1/bin添加到PATH中
配置ORACLE_HOME为/opt/oracle/product/19c/dbhome_1
配置环境变量ORACLE_SID为ORCLCDB否则oracle用户不能免密登录

如没有正确配置lsnrctl start会报错

执行

netca -silent -responseFile /opt/oracle/product/19c/dbhome_1/assistants/netca/netca.rsp

配置ipv6监听

切换用户时使用su -

vim /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora

在配置中增加ipv6配置

不要使用fe80开头的ip地址,它是本地回环地址无法对外提供服务

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node010047)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 2001:251:e000:1:5054:ff:feea:f7bc)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

启动监听和查看监听状态

lsnrctl start
lsnrctl status

使用oracle用户登录

sqlplus / as sysdba

切换到pdb

show pdbs;
alter session set container orclpdb1;

之后就可以正常进行创建用户,创建表等操作了

jdbc连接地址

jdbc:oracle:thin:@//192.168.10.47:1521/orclpdb1
jdbc:oracle:thin:@//[2001:251:e000:1:5054:ff:feea:f7bc]:1522/orclpdb1

其他问题

[42000][1950] ORA-01950: 对表空间 'USERS' 无权限

ALTER USER testuser QUOTA UNLIMITED ON "USERS";

参考文章

1. 干货速看！CentOS7+Oracle 19c安装并开启IPv6监听，带你一文打尽。
2. Oracle 19c之RPM安装
 3. ORA-01950：表空间USERS中无权限的2种方法

Matrix42