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

K
Zeile 56: Zeile 56:
Enter password: SYSTEM_password
Enter password: SYSTEM_password
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/
</syntaxhighlight>Administrator anlegen:<syntaxhighlight lang="bash">
</syntaxhighlight>Administrator und APEX_PUBLIC_USER anlegen:<syntaxhighlight lang="bash">
ALTER SESSION SET CONTAINER = XEPDB1;
SQL> ALTER SESSION SET CONTAINER = XEPDB1;
SQL> @apxchpwd.sql
SQL> @apxchpwd.sql
</syntaxhighlight>APEX_PUBLIC_USER einrichten:<syntaxhighlight lang="sql">
SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password;
 
</syntaxhighlight>Konfiguration starten:<syntaxhighlight lang="bash">
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password
SQL> @apex_rest_config.sql
</syntaxhighlight><syntaxhighlight lang="bash">
@apex_rest_config.sql
</syntaxhighlight>
</syntaxhighlight>