search

gvenzl / oci-oracle-xe

Build scripts for Oracle Database XE container/docker images
Apache License 2.0
270 stars 76 forks source link

error occured on initiaion of 11-slim-faststart type #203

Closed kaiei-chou closed 1 year ago

kaiei-chou commented 1 year ago

i can start the database and use it with no problem currently. but every time error output can be confirmed like below.

2023-04-19T07:15:47.765538000Z #########################
2023-04-19T07:15:47.765573000Z DATABASE IS READY TO USE!
2023-04-19T07:15:47.765601000Z #########################
2023-04-19T07:15:47.767810000Z 
2023-04-19T07:15:47.768159000Z ##################################################################
2023-04-19T07:15:47.768211000Z CONTAINER: The following output is now from the alert_XE.log file:
2023-04-19T07:15:47.768244000Z ##################################################################
2023-04-19T07:15:47.783278000Z     DATAFILE '/u01/app/oracle/oradata/XE/MYDB.dbf'
2023-04-19T07:15:47.783537000Z     AUTOEXTEND ON NEXT 1G
2023-04-19T07:15:47.783579000Z     MAXSIZE UNLIMITED
2023-04-19T07:15:47.783609000Z Wed Apr 19 16:15:37 2023
2023-04-19T07:15:47.783638000Z Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_j001_117.trc:
2023-04-19T07:15:47.783665000Z ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
2023-04-19T07:15:47.783724000Z ORA-06550: line 1, column 807:
2023-04-19T07:15:47.783760000Z PLS-00201: identifier 'DBSNMP.BSLN_INTERNAL' must be declared
2023-04-19T07:15:47.783913000Z ORA-06550: line 1, column 807:
2023-04-19T07:15:47.783948000Z PL/SQL: Statement ignored
gvenzl commented 1 year ago

Hi @kaiei-chou,

You can happily ignore that error.

This is just an output written in the database's alert log (CONTAINER: The following output is now from the alert_XE.log file). Oracle 11g XE (and later versions) do not include all Oracle Database functionality and thus some errors may be seen.

I highly recommend using the latest image (Oracle 21c XE) or even migrating to github.com/gvenzl/oci-oracle-free

kaiei-chou commented 1 year ago

thanks. feel relieved to hear that I can ignore it