<code xml>
<role rolename="manager-gui"/>
<user username="tomcat" password="geheim" roles="manager-gui"/>
... fen ob nicht ein alter APEX Stand exisiert
select username from dba_users;
#falls ja mit @apxremov aus dem O... nistrator privileges.
Enter the administrator username: sys
Enter the database password for SYS AS SYS... d in configuration: default
The setting named: db.username was set to: ORDS_PUBLIC_USER in configuration: de
nistrator privileges.
Enter the administrator username: sys
Enter the database password for SYS AS SYS... d in configuration: default
The setting named: db.username was set to: ORDS_PUBLIC_USER in configuration: de... SRV_GPIDB_MAIN Pool
db.username ORDS_PUBLIC_USER ... 2021-03-27 17:20:43
select username,default_tablespace, temporary_tablespace from dba
=> 1,
p_username => 'SYSTEM',
... -- ========================================
v_username varchar2(32);
v_sql varchar2(4000);
v... den aktuellen aPEX Owner aus der DB
select max(username)
into v_username
from dba_users
where regexp_like(username,'^APEX_[[:digit:]].*');
if v_k
GIT_HOME%\cmd\git.exe" commit -m "Commit done by %USERNAME% at %DATE% %TIME%"
"%GIT_HOME%\cmd\git.exe" push
... _HOME\cmd\git.exe" commit -m "Commit done by $env:UserName at $datum"
& "$ENV:GIT_HOME\cmd\git.exe" push
</... erwendt als User Home den Windows Pfad (C:\Users\<username>) und legt dort die .gitconfig an.
Globale Konf
aiter ******************/
select ss.sid
, ss.username
, ss.terminal
, ss.program
, sw.event...
/**** Suchen über die v$lock und die X$KGLLK mit Username der blockierenden Session ***/
SELECT * FROM X$KG
ler - Wizard Connection Dialog "ORA-01017:invalid username/password; logon denied" ===
{{ :prog:dot-net-i... User Wizard Deploy Oracle .Net ORA-01017:invalid username/password; logon denied }}
Hier MUSS zwingend der... dung mit dem falschen Passwort (ORA-01017:invalid username/password; logon denied) ist dann sehr missverstän
0.1
db.port=1521
db.servicename=GPI
db.sid=GPI
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
rest.ser... s schema. Installation may be required.
Enter the username with SYSDBA privileges to verify the installation... ST Data Services schema.
Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA
Item mit einem Namen, wie in unseren Fall "P73_DBUSERNAME", anlegen und auf den Typ "Hidden" setzen.
In di... iner Bindvariablen hinterlegen:
<code sql>
select username
, os_username
, userhost
, terminal
, to_char(extended_timestamp,'dd.mm.yyyy hh24:mi')... IV_USED
from v_page_73_auditlog_details
where username=:P73_DBUSERNAME
order by extended_timestamp des