oracle 18c 安裝報ora

目前oracle發(fā)布的18c,只能安裝在云上,如果我們安裝在自己機(jī)器上,使用dbca創(chuàng)建實例時,會報ora-12754的錯誤,有辦法解決沒有呢?

答案是肯定的,有兩種辦法,一是上oracle 云上拷貝libserver18.a文件來解決,二是,直接修改參數(shù)_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.

后面應(yīng)該很快應(yīng)該就有本地的安裝介質(zhì)出來,我選擇了后者來解決.

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上通過.