目前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上通过.