Oracle Database XE installieren (AlmaLinux/CentOS): Unterschied zwischen den Versionen

K
Zeile 98: Zeile 98:
chown oracle: -R /opt/apex
chown oracle: -R /opt/apex
cd /opt/apex
cd /opt/apex
</syntaxhighlight>Die Installation wird in der SQL-Konsole gestartet:<syntaxhighlight lang="bash">
</syntaxhighlight>In den oracle Benutzer wechseln und die SQL-Konsole starten:<syntaxhighlight lang="bash">
su oracle
su oracle
sqlplus /nolog
sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
SQL> CONNECT SYS as SYSDBA
Enter password: SYSTEM_password
Enter password: SYSTEM_password
</syntaxhighlight>Apex in die Pluggable DB (XEPDB1) installieren:<syntaxhighlight lang="bash">
SQL> ALTER SESSION SET CONTAINER = XEPDB1;
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/
</syntaxhighlight>Administrator und APEX_PUBLIC_USER anlegen:<syntaxhighlight lang="bash">
</syntaxhighlight>Administrator und APEX_PUBLIC_USER anlegen:<syntaxhighlight lang="bash">
SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password;
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password;
SQL> ALTER SESSION SET CONTAINER = XEPDB1;
SQL> @apxchpwd.sql
SQL> @apxchpwd.sql
</syntaxhighlight>Konfiguration starten:<syntaxhighlight lang="bash">
</syntaxhighlight>Konfiguration starten:<syntaxhighlight lang="bash">