fatih-keles

CREATE TABLE DEMO_TABLE (
  T_ID    NUMBER GENERATED ALWAYS AS IDENTITY INCREMENT BY 1 START WITH 1, 
  T_DATA  VARCHAR2(200 BYTE)
);

insert into DEMO_TABLE (t_data) values ('test data 1');
insert into DEMO_TABLE (t_data) values ('test data 2');
insert into DEMO_TABLE (t_data) values ('test data 3');
commit;

fatih-keles

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

insert into DEMO_TABLE (t_data) values ('test data 99');
update DEMO_TABLE 
   set t_data = 'test data X'
 where t_id <= 3;
commit;

select * from flashback_transaction_query
where 1=1

fatih-keles

ml3doz8p2wlcqekw_tp_local = (
  description = (retry_count=20)(retry_delay=3)
  (address = (protocol=tcps) (port=10522) (host=localhost))
  (connect_data=(service_name=gf5f9ffc50769d0_ml3doz8p2wlcqekw_tp.adb.oraclecloud.com))
  (security=(ssl_server_dn_match=no))
)

fatih-keles

BEGIN
    apex_instance_admin.set_parameter(
        p_parameter => 'IMAGE_PREFIX', 
        p_value => 'https://static.oracle.com/cdn/apex/22.2.0/'
    );
    COMMIT;
END;

fatih-keles

BEGIN
    apex_instance_admin.set_parameter(
        p_parameter => 'IMAGE_PREFIX', 
        p_value => '/i/20.2.0.00.20/'
    );
    COMMIT;
END;

fatih-keles

yum update
yum install ksh 
yum install jdk-19
yum install ords

fatih-keles

sudo systemctl stop firewalld.service
sudo firewall-offline-cmd --zone=public --add-port 8080/tcp
sudo systemctl start firewalld.service

sudo systemctl stop firewalld.service
sudo firewall-offline-cmd --zone=public --add-port 8443/tcp
sudo systemctl start firewalld.service

fatih-keles

mkdir -p /u01/ords/config 
mkdir -p /u01/ords/log

fatih-keles

scp -i ~/.ssh/fkeles-nopass 
    -o ProxyCommand="ssh -i ~/.ssh/fkeles-nopass -W %h:%p -p 22 <redacted-bastion-session-id>@host.bastion.uk-london-1.oci.oraclecloud.com" 
    -P 22 
    /your/local/folder/Wallet_ML3DOZ8P2WLCQEKW.zip 
    opc@10.0.1.217:/your/remote/folder

fatih-keles

[root@ords-2 ~]# ords install adb --interactive --prompt-password --log-folder /u01/ords/log
2023-04-13T09:14:50Z INFO       ORDS has not detected the option '--config' and this will be set up to the default directory.

ORDS: Release 23.1 Production on Thu Apr 13 09:14:52 2023

Copyright (c) 2010, 2023, Oracle.

Configuration:
  /etc/ords/config/