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

郑全

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