aws-samples / aws-samples/aws-database-migration-samples

Oracle errors when running install-onprem.sql

Open
#24 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
PLpgSQL
Stars
185
Forks
215
PR merge metrics
No merged PRs in 30d

Description

I am logged into an installation of Oracle Database XE as user 'oracle' (as sysdba) on an EC2 instance. When I run install-onprem,sql all seems well except I get a few errors but I'm not sure if these are show stoppers?

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
Error at line 1:
ORA-31541: Supplemenmtal logging is not enabled in CDB$ROOT

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY LKEY) COLUMNS
Error at line 1:
ORA-31541: Supplemenmtal logging is not enabled in CDB$ROOT
**- Is supplemental logging necessary?**

grant select on sys.DBMS_LOGMNR to dms_user
Error at line 1:
ORA-02225: only EXECUTE and DEBUG priviligese are valid for procedures
**- will this cause issues?**

drop table ticket_purchase_hist
Error at line 1:
ORA-00942: table or view does not exist
**- Is this just a cleanup incase this has already been installed or should this table be there and something went wrong further up?**

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.