1.052
Bearbeitungen
Oracle Database XE installieren (AlmaLinux/CentOS): Unterschied zwischen den Versionen
Oracle Database XE installieren (AlmaLinux/CentOS) (Quelltext anzeigen)
Version vom 13. August 2022, 19:05 Uhr
, vor 2 Jahren→Oracle Application Express (APEX) installieren
| Zeile 98: | Zeile 98: | ||
chown oracle: -R /opt/apex | chown oracle: -R /opt/apex | ||
cd /opt/apex | cd /opt/apex | ||
</syntaxhighlight> | </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> @apxchpwd.sql | SQL> @apxchpwd.sql | ||
</syntaxhighlight>Konfiguration starten:<syntaxhighlight lang="bash"> | </syntaxhighlight>Konfiguration starten:<syntaxhighlight lang="bash"> | ||