Oracle Database 19c dbca: Error while executing ordlib.sql

Este é um Post atípico, pois ainda não tenho solução.
Então, se você chegou aqui esperando isso, me solidarizo com você, e assim que eu encontrar a solução atualizo aqui. 🙂

Em tempo, o mesmo erro ocorreu em modo não Silent – estou utilizando o modo Silent aqui para uma melhor exibição.
Todos os pré-requisitos foram executados, e o Linux é OEL 7, atualizado. Aliás, utilizei o mesmo passo a passo que utilizo para 18c.

Ao criar um banco via DBCA, recebo o erro abaixo:

[oracle@nerv04 ~]$ dbca -createDatabase -silent -responseFile /home/oracle/dbca.rsp
Enter SYS user password:

Enter SYSTEM user password:

Enter PDBADMIN User Password:

Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
100% complete
[FATAL] Error while executing "/u01/app/oracle/product/19.3.0.0/db_1/ord/im/admin/ordlib.sql". Refer to "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ordlib0.log" for more details. Error in Process: /u01/app/oracle/product/19.3.0.0/db_1/perl/bin/perl
31% complete
8% complete
0% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ORCL1.log" for further details.
[oracle@nerv04 ~]$

E o que tem no Log indicado? Nada.

[oracle@nerv04 ~]$ cat "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ordlib0.log"
[oracle@nerv04 ~]$

E no Alert Log? Nada que me ajude muito. Após abrir o PDB$SEED, ocorre um ABORT.

2019-05-01T14:12:42.219847-03:00
alter pluggable database pdb$seed close
PDB$SEED(2):JIT: pid 18896 requesting stop
PDB$SEED(2):Buffer Cache flush started: 2
PDB$SEED(2):Buffer Cache flush finished: 2
Pluggable database PDB$SEED closed
Completed: alter pluggable database pdb$seed close
alter pluggable database pdb$seed open
PDB$SEED(2):Autotune of undo retention is turned on.
PDB$SEED(2):Endian type of dictionary set to little
2019-05-01T14:12:43.212543-03:00
PDB$SEED(2):Undo initialization recovery: err:0 start: 2468349 end: 2468351 diff: 2 ms (0.0 seconds)
PDB$SEED(2):[18896] Successfully onlined Undo Tablespace 2.
PDB$SEED(2):Undo initialization online undo segments: err:0 start: 2468351 end: 2468367 diff: 16 ms (0.0 seconds)
PDB$SEED(2):Undo initialization finished serial:0 start:2468349 end:2468368 diff:19 ms (0.0 seconds)
PDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8
PDB$SEED(2):Accessing dba_registry_sqlpatch hit error: 942
Accessing dba_registry_sqlpatch hit error: 942
PDB$SEED(2):joxcsys_required_dirobj_exists: error 942 in pid 18896 cid 2
PDB$SEED(2):joxcsys_required_dirobj_exists: directory object does not exist, pid 18896 cid 2
PDB$SEED(2):joxcsys_ensure_directory_object: created directory object with path /u01/app/oracle/product/19.3.0.0/db_1/javavm/admin/, pid 18896 cid 2
Pluggable database PDB$SEED opened read write
Completed: alter pluggable database pdb$seed open
2019-05-01T14:12:48.691779-03:00
Shutting down ORACLE instance (abort) (OS id: 18923)
License high water mark = 2
USER (ospid: 18923): terminating the instance
2019-05-01T14:12:49.695654-03:00
Instance terminated by USER, pid = 18923
2019-05-01T14:12:49.938564-03:00
Instance shutdown complete (OS id: 18923)

Como o erro falava de ordlib, tentei então criar o banco com o Template Custom, ao invés do General utilizado anteriormente, e tirei todas as opções possíveis. Aproveitei para testar em outra máquina

Só mudou o erro, que agora ocorre no catalog.sql (!!!).

[oracle@nerv01 ~]$ dbca -createDatabase -silent -responseFile /home/oracle/dbca.rsp
Enter SYS user password:

Enter SYSTEM user password:

Enter PDBADMIN User Password:

Prepare for db operation
4% complete
Creating and starting Oracle instance
5% complete
7% complete
Creating database files
8% complete
11% complete
Creating data dictionary views
12% complete
22% complete
100% complete
[FATAL] Error while executing "/u01/app/oracle/product/19.3.0.0/db_1/rdbms/admin/catalog.sql". Refer to "/u01/app/oracle/cfgtoollogs/dbca/ORCL/catalog0.log" for more details. Error in Process: /u01/app/oracle/product/19.3.0.0/db_1/perl/bin/perl
11% complete
7% complete
4% complete
0% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ORCL3.log" for further details.
[oracle@nerv01 ~]$

E o que tem no Log?

[oracle@nerv01 ~]$ cat "/u01/app/oracle/cfgtoollogs/dbca/ORCL/catalog0.log"
[oracle@nerv01 ~]$

No Alert Log, novamente, nada que me ajude muito.

Completed: alter pluggable database PDB$SEED OPEN RESTRICTED
PDB$SEED(2):alter pluggable database PDB$SEED set time_zone='+00:00'
PDB$SEED(2):Completed: alter pluggable database PDB$SEED set time_zone='+00:00'
PDB$SEED(2):TABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P221 (59) VALUES LESS THAN (TIMESTAMP' 2019-06-01 00:00:00')
alter pluggable database PDB$SEED CLOSE IMMEDIATE
PDB$SEED(2):JIT: pid 17189 requesting stop
PDB$SEED(2):Buffer Cache flush started: 2
2019-05-01T14:00:32.887480-03:00
Thread 1 advanced to log sequence 2 (LGWR switch)
  Current log# 2 seq# 2 mem# 0: /u01/app/oracle/oradata/ORCL/redo02.log
2019-05-01T14:01:40.543017-03:00
PDB$SEED(2):Buffer Cache flush finished: 2
2019-05-01T14:01:41.550186-03:00
Pluggable database PDB$SEED closed
Completed: alter pluggable database PDB$SEED CLOSE IMMEDIATE
alter pluggable database PDB$SEED OPEN restricted
PDB$SEED(2):Autotune of undo retention is turned on.
PDB$SEED(2):Endian type of dictionary set to little
PDB$SEED(2):Undo initialization recovery: err:0 start: 1807627 end: 1807629 diff: 2 ms (0.0 seconds)
PDB$SEED(2):[17189] Successfully onlined Undo Tablespace 2.
PDB$SEED(2):Undo initialization online undo segments: err:0 start: 1807629 end: 1807677 diff: 48 ms (0.0 seconds)
2019-05-01T14:01:42.541278-03:00
PDB$SEED(2):Undo initialization finished serial:0 start:1807627 end:1807680 diff:53 ms (0.1 seconds)
PDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8
PDB$SEED(2):Opening pdb with no Resource Manager plan active
PDB$SEED(2):joxcsys_required_dirobj_exists: directory object exists with required path /u01/app/oracle/product/19.3.0.0/db_1/javavm/admin/, pid 17189 cid 2
Pluggable database PDB$SEED opened read write
Completed: alter pluggable database PDB$SEED OPEN restricted
2019-05-01T14:01:48.473941-03:00
Shutting down ORACLE instance (abort) (OS id: 17561)
License high water mark = 2
USER (ospid: 17561): terminating the instance
2019-05-01T14:01:49.494608-03:00
Instance terminated by USER, pid = 17561
2019-05-01T14:01:49.738146-03:00
Instance shutdown complete (OS id: 17561)

UPDATE (05/05/2019): Refiz as duas máquinas, em um procedimento mais enxuto (instalei menos coisas do que instalo normalmente) e funcionou. Não consegui isolar qual era o problema. 🙁

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.