Oracle 19 support requires creation of OMN-User before initialization [OR-783]
|
With OMN 5.12 Oracle 19 is supported (cp. Note! For systems hosted by apollon these steps are automatically done by our internal DB installation routines. So these adaptions only need to be done for externally (on customer-side) hosted OMN systems! (Cp. Installation/Migration Steps For externally hosted OMN systems the following steps must be executed as SYSDBA-User (sys or system) in the database before the OMN initialization is started: -- default Tablespace für OMN-User erstellen create tablespace BASE_DATA datafile '<<datafile_path>>/base_data01.dbf' size 1G autoextend on next 100M; -- OMN Rolle erstellen CREATE ROLE OMN_ROLE NOT IDENTIFIED; GRANT ALTER SESSION TO OMN_ROLE; GRANT CREATE INDEXTYPE TO OMN_ROLE; GRANT CREATE PROCEDURE TO OMN_ROLE; GRANT CREATE SEQUENCE TO OMN_ROLE; GRANT CREATE SESSION TO OMN_ROLE; GRANT CREATE TABLE TO OMN_ROLE; GRANT CREATE TRIGGER TO OMN_ROLE; GRANT CREATE TYPE TO OMN_ROLE; GRANT CREATE VIEW TO OMN_ROLE; GRANT EXP_FULL_DATABASE TO OMN_ROLE; GRANT IMP_FULL_DATABASE TO OMN_ROLE; GRANT OMN_ROLE TO SYS WITH ADMIN OPTION; -- OMN user erstellen und die Rechte vergeben CREATE USER omn IDENTIFIED BY "<<omn_user_password>>" DEFAULT TABLESPACE BASE_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CONNECT TO omn; GRANT RESOURCE TO omn; GRANT OMN_ROLE TO OMN; ALTER USER omn DEFAULT ROLE ALL; GRANT UNLIMITED TABLESPACE TO omn; ALTER USER omn QUOTA UNLIMITED ON BASE_DATA; GRANT CREATE JOB TO OMN; Note: |