oracle 18c 安装报ora-12754问题的解决

2019独角兽企业重金招聘Python工程师标准>>>

目前oracle发布的18c,只能安装在云上,如果我们安装在自己机器上,使用dbca创建实例时,会报ora-12754的错误,有办法解决没有呢?
答案是肯定的,有两种办法,一是上oracle 云上拷贝libserver18.a文件来解决,二是,直接修改参数_exadata_feature_on=true,之后,也可以启动:

Instead of changing lib file one can get the database running as follows -
1. instead of creating database using dbca, use dbca to get the scripts.
2. there will be 3 init* files. Modify all of them just place _exadata_feature_on=true.
3. execute xxxx.sh script to run and build database.

后面应该很快应该就有本地的安装介质出来,我选择了后者来解决.

SQL> select banner from v$version;
BANNER

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

然后,开启防火墙,就可以访问了.

[root@desktop0 ~]# firewall-cmd --permanent --add-port=5501/tcp
success
[root@desktop0 ~]# firewall-cmd --permanent --add-port=1521/tcp
success
[root@desktop0 ~]# firewall-cmd --reload
success
[root@desktop0 ~]# firewall-cmd --list-all
public (active)
target: default
icmp-block-inversion: no
interfaces: ens33
sources:
services: ssh dhcpv6-client
ports: 5501/tcp 1521/tcp
protocols:
masquerade: no
forward-ports:
source-ports:
icmp-blocks:
rich rules:

以上测试在centos 7.4上通过.

转载于:https://my.oschina.net/u/3635497/blog/2247108