by In my last post, I installed the Oracle 18c binaries on Oracle Linux 7. Now next step is to create the database. But you’ll be stuck with error “ORA-12754” when you trying to create database with exadata binaries.
|
1 2 3 |
[oracle@oracle18c bin]$ pwd /u01/app/oracle/product/18.0.0/db1/bin [oracle@oracle18c bin]$ ./dbca |
The library which is causing the problem is “libserver18”. It’s really hard to troubleshoot this library. So I thought to copy this library from Oracle cloud environment. I deployed the 18c database from my free trail cloud account. You need to wait at least 10-15 mins before the database service is ready for you.
Once database is ready, make an SSH connection which is explained here.
Now I replaced the library from my OPC environment to VM machine and relink the libraries again. Without relink, you’ll receive the same error.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
[opc@cloud18c ~]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_main-lv_root 25G 12G 13G 47% / tmpfs 3.7G 4.5M 3.7G 1% /dev/shm /dev/xvdb1 477M 70M 379M 16% /boot /dev/xvde1 59G 9.4G 47G 17% /u01 /dev/mapper/dataVolGroup-lvol0 25G 3.8G 20G 17% /u02 /dev/mapper/fraVolGroup-lvol0 6.8G 2.1G 4.4G 33% /u03 /dev/mapper/redoVolGroup-lvol0 26G 3.2G 22G 13% /u04 # Switch to root account [opc@cloud18c ~]$ sudo -s [root@cloud18c lib]# cd /u01/app/oracle/product/18.0.0/dbhome_1/lib [root@cloud18c lib]# ls -altr libserver18.a -rw-r--r-- 1 oracle oinstall 462876440 Mar 1 23:13 libserver18.a [root@cloud18c lib]# cp libserver18.a /tmp # Used WinScp to copy the file from OPC environment to VM shared folder [root@oracle18c sf_Share_VM]# cp libserver18.a /u01/app/oracle/product/18.0.0/db1/lib [root@oracle18c lib]# chown oracle:oinstall libserver18.a [oracle@oracle18c bin]$ relink all writing relink log to: /u01/app/oracle/product/18.0.0/db1/install/relink_2018-03-02_14-29-06PM.log |
Now kick off database creation from DBCA and you won’t get any “ORA-12754” error again.
Now test the database connection via sqlplus.
|
1 2 3 4 5 6 7 8 9 |
[oracle@oracle18c bin]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 Production on Fri Mar 2 15:42:02 2018 Version 18.1.0.0.0 Copyright (c) 1982, 2017, Oracle. All rights reserved. Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.1.0.0.0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO |
Have Fun!!!
Mandy
Mandy thanks for this. Is it possible for you to upload this library somewhere; for those of us who don’t have Oracle public cloud accounts
Hi Shadab, I don’t think so legally I can upload the library from Oracle cloud for public use. Best is to create an account, and you’ll get $300US (depends upon your region) credits for one month. I am so sorry, I could not able to help in this case…
Mandy!!!