Oracle error: TNS-12518: TNS:listener could not hand off client connection, TNS-12547: TNS:lost contact, TNS-12560: TNS:protocol adapter error

Existen muchas razones por las que podamos obtener los errores TNS-12518, TNS-12547 Y TNS-12560, acompañados por TNS:protocol adapter error, sin mbargo, la mayor parte del tiempo está relacionada con el parámetro PROCESSES.

Si revisas la bitácora del servicio ALERT y observas estos códigos en el archivo y el comportamiento que ves en esta publicación, es muy posible que esto se deba a que el valor del parámetro PROCESSES es muy bajo.

En el caso que se ilustra a continuación, el inconveniente se soluciona cambiando el valor del parámetro y como no es un un parámetro dinámico, se hace necesario reiniciar el contenedor de la base de datos.

login as: opc

Authenticating with public key "rsa-key-20200507"
Passphrase for key "rsa-key-20200507":
Last login: Fri Feb 10 09:44:57 2023 from 11.0.3.253
[opc@bd-uat-lab1 ~]$ sudo -s /bin/bash
[root@bd-uat-lab1 opc]# time

real 0m0.000s
user 0m0.000s
sys 0m0.000s

[root@bd-uat-lab1 opc]# top

top - 09:47:52 up 64 days, 17:49, 2 users, load average: 0.03, 0.02, 0.00
Tasks: 434 total, 1 running, 376 sleeping, 0 stopped, 0 zombie
%Cpu(s): 1.8 us, 2.0 sy, 0.0 ni, 96.2 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 65325268 total, 32453952 free, 2831292 used, 30040024 buff/cache
KiB Swap: 8388604 total, 8024572 free, 364032 used. 32361100 avail Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5402 root 20 0 110328 2312 1936 S 0.7 0.0 0:00.02 pidstat
5426 root 20 0 163836 4780 3828 S 0.7 0.0 0:00.02 top
16 root rt 0 0 0 0 S 0.3 0.0 0:28.37 migration/1
2098 root 20 0 117024 3408 2972 S 0.3 0.0 18:53.24 OSWatcher
2107 root 20 0 0 0 0 I 0.3 0.0 0:00.01 kworker/1:0-eve
....

[oracle@bd-uat-lab1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 10-FEB-2023 10:23:52

Copyright (c) 1991, 2021, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bd-uat-lab1)(PORT=1521)))

STATUS of the LISTENER
-----------------------
Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 02-FEB-2023 11:10:14
Uptime 7 days 23 hr. 13 min. 37 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF

Listener Parameter File /opt/app/oracle/product/19c/network/admin/listener.ora
Listener Log File /opt/app/oracle/diag/tnslsnr/bd-uat-lab1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bd-uat-lab1.subacne.correcaminos.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=bd-uat-lab1.subacne.correcaminos.com)(PORT=5500))(Security=(my_wallet_directory=/opt/app/oracle/admin/cdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "cdb" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "cdbXDB" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "efa4c0eb93f34e55e053638c18ac1b30" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "efa4c0eb93f54e55e053638c18ac1b30" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "efa4c0eb93f74e55e053638c18ac1b30" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "efa4c0eb93f94e55e053638c18ac1b30" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "lab01" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb2" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb3" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb4" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...
The command completed successfully

[oracle@bd-uat-lab1 ~]$ cd /opt/app/oracle/diag/tnslsnr/bd-uat-lab1/listener/alert

[oracle@bd-uat-lab1 alert]$ ls -la

total 126532
drwxr-xr-x. 2 oracle oinstall 29 Dec 7 16:02 .
drwxr-xr-x. 14 oracle oinstall 4096 Dec 7 16:02 ..
-rw-r-----. 1 oracle oinstall 62488913 Feb 10 10:23 log.xml


[oracle@bd-uat-lab1 trace]$ more listener.log
2022-12-07T16:02:26.677697-06:00
Create Relation ADR_CONTROL
Create Relation ADR_INVALIDATION
Create Relation INC_METER_IMPT_DEF
Create Relation INC_METER_PK_IMPTS

LISTENER for Linux: Version 19.0.0.0.0 - Production
Version 19.10.3.0.0

System parameter file is /opt/app/oracle/product/19c/network/admin/listener.ora

Log messages written to /opt/app/oracle/diag/tnslsnr/bd-uat-lab1/listener/alert/log.xml

Trace information written to /opt/app/oracle/diag/tnslsnr/bd-uat-lab1/listener/trace/ora_11581_139834235333120.trc

Trace level is currently 0


Started with pid=11581

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracledb-amarilla)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 2: No such file or directory

2022-12-07T16:03:08.994908-06:00

LISTENER for Linux: Version 19.0.0.0.0 - Production
Version 19.10.3.0.0

System parameter file is /opt/app/oracle/product/19c/network/admin/listener.ora
Log messages written to /opt/app/oracle/diag/tnslsnr/bd-uat-lab1/listener/alert/log.xml
Trace information written to /opt/app/oracle/diag/tnslsnr/bd-uat-lab1/listener/trace/ora_11733_140143136844288.trc

Trace level is currently 0

Started with pid=11733

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bd-uat-lab1.subacne.correcaminos.com)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listener completed notification to CRS on start




TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
07-DEC-2022 16:03:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=bd-uat-lab1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=31876710
4)) * status * 0
[oracle@bd-uat-lab1 trace]$ tail -f 200 listener.log|more
tail: cannot open ‘200’ for reading: No such file or directory
==> listener.log <==
10-FEB-2023 10:24:03 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=17
2.24.140.92)(PORT=40988)) * establish * lab01 * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
...


SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ---------------------------
2 PDB$SEED READ ONLY NO
9 lab01 READ WRITE NO
10 pdb2 READ WRITE NO
11 pdb4 READ WRITE NO
12 pdb3 READ WRITE NO
SQL> alter session set container=lab01;

Session altered.
SQL> show parameter process


NAME TYPE VALUE
------------------------------------ 
aq_tm_processes integer 1
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 40
log_archive_max_processes integer 4
processes integer 300
processor_group_name string

SQL> alter system set processes=1000 scope=spfile;

SQL> connect / as sysdba
Connected.
SQL> alter system set processes=1000 scope=spfile;

System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 5.1540E+10 bytes
Fixed Size 9150584 bytes
Variable Size 8321499136 bytes
Database Buffers 4.3084E+10 bytes
Redo Buffers 125063168 bytes
Database mounted.
Database opened.

SQL> show parameter process
NAME TYPE VALUE
------------------------------------
aq_tm_processes integer 1
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 4000
log_archive_max_processes integer 4
processes integer 1000
processor_group_name string

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.3.0.0
[oracle@bd-uat-lab1 trace]$ tail -f listener.log

10-FEB-2023 10:28:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10868)) * establish * pdb3 * 0

10-FEB-2023 10:28:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10878)) * establish * pdb3 * 0

10-FEB-2023 10:28:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10880)) * establish * pdb3 * 0

10-FEB-2023 10:28:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10888)) * establish * pdb3 * 0

2023-02-10T10:29:00.288141-06:00

10-FEB-2023 10:29:00 * service_update * cdb * 0

2023-02-10T10:29:01.920961-06:00

10-FEB-2023 10:29:01 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb4)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.125)(PORT=39256)) * establish * pdb4 * 0

10-FEB-2023 10:29:02 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb4)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.125)(PORT=39270)) * establish * pdb4 * 0

10-FEB-2023 10:29:02 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb4)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.125)(PORT=39284)) * establish * pdb4 * 0

10-FEB-2023 10:29:02 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10890)) * establish * pdb3 * 0

10-FEB-2023 10:29:02 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10892)) * establish * pdb3 * 0

10-FEB-2023 10:29:02 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10894)) * establish * pdb3 * 0

10-FEB-2023 10:29:02 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10908)) * establish * pdb3 * 0

10-FEB-2023 10:29:02 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10910)) * establish * pdb3 * 0

2023-02-10T10:29:03.003611-06:00

10-FEB-2023 10:29:03 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10914)) * establish * pdb3 * 0

10-FEB-2023 10:29:03 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10930)) * establish * pdb3 * 0

10-FEB-2023 10:29:03 * service_update * cdb * 0

^C

[oracle@bd-uat-lab1 trace]$ tail -f listener.log

10-FEB-2023 10:29:27 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49438)) * establish * pdb3 * 0

2023-02-10T10:29:27.727539-06:00

10-FEB-2023 10:29:27 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49454)) * establish * pdb3 * 0

10-FEB-2023 10:29:27 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49458)) * establish * pdb3 * 0

10-FEB-2023 10:29:28 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49466)) * establish * pdb3 * 0

2023-02-10T10:29:28.730557-06:00

10-FEB-2023 10:29:28 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49472)) * establish * pdb3 * 0

10-FEB-2023 10:29:28 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49476)) * establish * pdb3 * 0

10-FEB-2023 10:29:29 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49488)) * establish * pdb3 * 0

10-FEB-2023 10:29:29 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49494)) * establish * pdb3 * 0

10-FEB-2023 10:29:29 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49500)) * establish * pdb3 * 0

2023-02-10T10:29:30.316683-06:00

10-FEB-2023 10:29:30 * service_update * cdb * 0

2023-02-10T10:29:32.785169-06:00

10-FEB-2023 10:29:32 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=49508)) * establish * pdb3 * 0

10-FEB-2023 10:29:33 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=mende))(SERVICE_NAME=lab01)(CONNECTION_ID=emXS6XgIQDe8vRtnsZzZew==)) * (ADDRESS=(PROTOCOL=tcp)(HOST=11.0.3.253)(PORT=46724)) * establish * lab01 * 0

10-FEB-2023 10:29:33 * service_update * cdb * 0

10-FEB-2023 10:29:33 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16292)) * establish * pdb3 * 0

10-FEB-2023 10:29:33 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16298)) * establish * pdb3 * 0

10-FEB-2023 10:29:33 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16306)) * establish * pdb3 * 0

2023-02-10T10:29:33.886891-06:00

10-FEB-2023 10:29:33 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16318)) * establish * pdb3 * 0

10-FEB-2023 10:29:34 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16326)) * establish * pdb3 * 0

10-FEB-2023 10:29:34 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16330)) * establish * pdb3 * 0

10-FEB-2023 10:29:34 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16334)) * establish * pdb3 * 0

10-FEB-2023 10:29:34 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16346)) * establish * pdb3 * 0

2023-02-10T10:29:35.259048-06:00

10-FEB-2023 10:29:35 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16358)) * establish * pdb3 * 0

10-FEB-2023 10:29:35 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11972)) * establish * lab01 * 0

10-FEB-2023 10:29:35 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16366)) * establish * pdb3 * 0

10-FEB-2023 10:29:35 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11976)) * establish * lab01 * 0

10-FEB-2023 10:29:35 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11988)) * establish * lab01 * 0

10-FEB-2023 10:29:35 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11998)) * establish * lab01 * 0

10-FEB-2023 10:29:35 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=12002)) * establish * lab01 * 0

10-FEB-2023 10:29:36 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=12004)) * establish * lab01 * 0

10-FEB-2023 10:29:36 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16378)) * establish * pdb3 * 0

10-FEB-2023 10:29:36 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=12008)) * establish * lab01 * 0

10-FEB-2023 10:29:36 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=12010)) * establish * lab01 * 0

2023-02-10T10:29:36.282173-06:00

10-FEB-2023 10:29:36 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=12022)) * establish * lab01 * 0

10-FEB-2023 10:29:36 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16392)) * establish * pdb3 * 0

10-FEB-2023 10:29:36 * service_update * cdb * 0

10-FEB-2023 10:29:36 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=12026)) * establish * lab01 * 0

10-FEB-2023 10:29:36 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=12036)) * establish * lab01 * 0

10-FEB-2023 10:29:36 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=12044)) * establish * lab01 * 0

2023-02-10T10:29:37.534924-06:00

10-FEB-2023 10:29:37 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16402)) * establish * pdb3 * 0

10-FEB-2023 10:29:37 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16418)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16428)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16440)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16446)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16458)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16460)) * establish * pdb3 * 0

2023-02-10T10:29:38.548315-06:00

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16470)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16486)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16494)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16496)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16500)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16508)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16520)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16532)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16548)) * establish * pdb3 * 0

10-FEB-2023 10:29:38 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16556)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16572)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16586)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16590)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16594)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16606)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16616)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16620)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * service_update * cdb * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16636)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16648)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16660)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16662)) * establish * pdb3 * 0

2023-02-10T10:29:39.606802-06:00

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16678)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16682)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16694)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16696)) * establish * pdb3 * 0

10-FEB-2023 10:29:39 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16708)) * establish * pdb3 * 0

10-FEB-2023 10:29:40 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=31034)) * establish * lab01 * 0

2023-02-10T10:29:41.497290-06:00

10-FEB-2023 10:29:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=31042)) * establish * lab01 * 0

10-FEB-2023 10:29:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=31056)) * establish * lab01 * 0

10-FEB-2023 10:29:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=31066)) * establish * lab01 * 0

10-FEB-2023 10:29:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=31070)) * establish * lab01 * 0

10-FEB-2023 10:29:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=31076)) * establish * lab01 * 0

10-FEB-2023 10:29:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=31084)) * establish * lab01 * 0

10-FEB-2023 10:29:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=31098)) * establish * lab01 * 0

10-FEB-2023 10:29:41 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=31114)) * establish * lab01 * 0

10-FEB-2023 10:29:42 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16716)) * establish * pdb3 * 0

10-FEB-2023 10:29:42 * service_update * cdb * 0

2023-02-10T10:29:42.964331-06:00

10-FEB-2023 10:29:42 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16728)) * establish * pdb3 * 0

10-FEB-2023 10:29:43 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16734)) * establish * pdb3 * 0

10-FEB-2023 10:29:43 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=16738)) * establish * pdb3 * 0

10-FEB-2023 10:29:43 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19036)) * establish * pdb3 * 0

10-FEB-2023 10:29:43 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19042)) * establish * pdb3 * 0

10-FEB-2023 10:29:43 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19054)) * establish * pdb3 * 0

2023-02-10T10:29:45.331758-06:00

10-FEB-2023 10:29:45 * service_update * cdb * 0

2023-02-10T10:29:47.387054-06:00

10-FEB-2023 10:29:47 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19064)) * establish * pdb3 * 0

2023-02-10T10:29:48.893152-06:00

10-FEB-2023 10:29:48 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19070)) * establish * pdb3 * 0

10-FEB-2023 10:29:49 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19078)) * establish * pdb3 * 0

10-FEB-2023 10:29:49 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19094)) * establish * pdb3 * 0

10-FEB-2023 10:29:49 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19098)) * establish * pdb3 * 0

2023-02-10T10:29:49.983354-06:00

10-FEB-2023 10:29:49 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19100)) * establish * pdb3 * 0

10-FEB-2023 10:29:50 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=19114)) * establish * pdb3 * 0

2023-02-10T10:29:51.338229-06:00

10-FEB-2023 10:29:51 * service_update * cdb * 0

2023-02-10T10:29:53.478549-06:00

10-FEB-2023 10:29:53 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60558)) * establish * lab01 * 0

10-FEB-2023 10:29:54 * service_update * cdb * 0

2023-02-10T10:29:56.471017-06:00

10-FEB-2023 10:29:56 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10496)) * establish * pdb3 * 0

10-FEB-2023 10:29:56 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10504)) * establish * pdb3 * 0

10-FEB-2023 10:29:56 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10506)) * establish * pdb3 * 0

10-FEB-2023 10:29:56 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10518)) * establish * pdb3 * 0

10-FEB-2023 10:29:56 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10532)) * establish * pdb3 * 0

10-FEB-2023 10:29:56 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10542)) * establish * pdb3 * 0

2023-02-10T10:29:58.934207-06:00

10-FEB-2023 10:29:58 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10552)) * establish * pdb3 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10568)) * establish * pdb3 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10576)) * establish * pdb3 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10588)) * establish * pdb3 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10598)) * establish * pdb3 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60562)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60576)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=10602)) * establish * pdb3 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60592)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60604)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60608)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60616)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60618)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60630)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60642)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60658)) * establish * lab01 * 0

2023-02-10T10:29:59.937249-06:00

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60672)) * establish * lab01 * 0

10-FEB-2023 10:29:59 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60684)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60690)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60698)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60714)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=60728)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11008)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11022)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11034)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11044)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * service_update * cdb * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11052)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11058)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11066)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11072)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11074)) * establish * lab01 * 0

10-FEB-2023 10:30:00 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=11090)) * establish * lab01 * 0

2023-02-10T10:30:03.348688-06:00

10-FEB-2023 10:30:03 * service_update * cdb * 0

2023-02-10T10:30:05.895254-06:00

10-FEB-2023 10:30:05 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=65020)) * establish * pdb3 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb4)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.125)(PORT=15788)) * establish * pdb4 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=65028)) * establish * pdb3 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb4)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.125)(PORT=15804)) * establish * pdb4 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=65038)) * establish * pdb3 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb4)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.125)(PORT=15812)) * establish * pdb4 * 0

10-FEB-2023 10:30:06 * service_update * cdb * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=65048)) * establish * pdb3 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb4)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.125)(PORT=15818)) * establish * pdb4 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=65058)) * establish * pdb3 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=65074)) * establish * pdb3 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=65076)) * establish * pdb3 * 0

10-FEB-2023 10:30:06 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=65092)) * establish * pdb3 * 0

2023-02-10T10:30:09.354318-06:00

10-FEB-2023 10:30:09 * service_update * cdb * 0

2023-02-10T10:30:24.879209-06:00

10-FEB-2023 10:30:24 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=pdb3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.69)(PORT=38220)) * establish * pdb3 * 0

2023-02-10T10:31:30.426760-06:00

10-FEB-2023 10:31:30 * service_update * cdb * 0

2023-02-10T10:33:16.436924-06:00

10-FEB-2023 10:33:16 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=46920)) * establish * lab01 * 0

10-FEB-2023 10:33:16 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=46934)) * establish * lab01 * 0

10-FEB-2023 10:33:16 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=46942)) * establish * lab01 * 0

10-FEB-2023 10:33:16 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=46946)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=46956)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=46960)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=46966)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=46982)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=46988)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47002)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47006)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47016)) * establish * lab01 * 0

2023-02-10T10:33:17.457326-06:00

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47032)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47042)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47054)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47060)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47076)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47090)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47096)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47110)) * establish * lab01 * 0

10-FEB-2023 10:33:17 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47120)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47134)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47146)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47154)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47170)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47172)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47188)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47192)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47200)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47202)) * establish * lab01 * 0

2023-02-10T10:33:18.471798-06:00

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47206)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * service_update * cdb * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47216)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47224)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47226)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47238)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47240)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47248)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47254)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47268)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47280)) * establish * lab01 * 0

10-FEB-2023 10:33:18 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47290)) * establish * lab01 * 0

10-FEB-2023 10:33:19 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47304)) * establish * lab01 * 0

10-FEB-2023 10:33:19 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47312)) * establish * lab01 * 0

10-FEB-2023 10:33:19 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47328)) * establish * lab01 * 0

10-FEB-2023 10:33:19 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47330)) * establish * lab01 * 0

10-FEB-2023 10:33:19 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47338)) * establish * lab01 * 0

10-FEB-2023 10:33:19 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47346)) * establish * lab01 * 0

10-FEB-2023 10:33:19 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=lab01)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.24.140.92)(PORT=47348)) * establish * lab01 * 0

2023-02-10T10:33:21.522063-06:00

10-FEB-2023 10:33:21 * service_update * cdb * 0

2023-02-10T10:38:45.807322-06:00

10-FEB-2023 10:38:45 * service_update * cdb * 0

Instalando imágen con el manejador de contenedores PODMAN de Oracle Database 23c-Free for Developers.

[root@dbsystem01 opc]# podman run -d --name db23cfree container-registry.oracle.com/database/free:latest

bash: podman: command not found

[root@dbsystem01 opc]# yum install podman

Loaded plugins: langpacks, ulninfo

docker-ce-stable                                                  | 3.5 kB  00:00:00

ol7_MySQL80                                                       | 3.0 kB  00:00:00

ol7_MySQL80_connectors_community                                  | 2.9 kB  00:00:00

ol7_MySQL80_tools_community                                       | 2.9 kB  00:00:00

ol7_UEKR6                                                         | 3.0 kB  00:00:00

ol7_addons                                                        | 3.0 kB  00:00:00

ol7_ksplice                                                       | 3.0 kB  00:00:00

ol7_latest                                                        | 3.6 kB  00:00:00

ol7_oci_included                                                  | 2.9 kB  00:00:00

ol7_optional_latest                                               | 3.0 kB  00:00:00

ol7_software_collections                                          | 3.0 kB  00:00:00

(1/6): ol7_ksplice/primary_db                                     | 3.7 MB  00:00:00

(2/6): docker-ce-stable/7Server/x86_64/primary_db                 | 101 kB  00:00:00

(3/6): ol7_optional_latest/x86_64/updateinfo                      | 1.4 MB  00:00:00

(4/6): ol7_optional_latest/x86_64/primary_db                      | 5.9 MB  00:00:00

(5/6): ol7_latest/x86_64/updateinfo                               | 3.5 MB  00:00:00

(6/6): ol7_latest/x86_64/primary_db                               |  45 MB  00:00:00

Resolving Dependencies

--> Running transaction check

---> Package podman.x86_64 0:1.6.4-29.0.1.el7_9 will be installed

--> Processing Dependency: containers-common >= 0.1.29-3 for package: podman-1.6.4-29.0.1.el7_9.x86_64

--> Processing Dependency: containernetworking-plugins >= 0.8.1-1 for package: podman-1.6.4-29.0.1.el7_9.x86_64

--> Processing Dependency: nftables for package: podman-1.6.4-29.0.1.el7_9.x86_64

--> Processing Dependency: conmon for package: podman-1.6.4-29.0.1.el7_9.x86_64

--> Running transaction check

---> Package conmon.x86_64 3:2.0.26-2.el7 will be installed

---> Package containernetworking-plugins.x86_64 0:0.8.1-2.el7 will be installed

---> Package containers-common.x86_64 1:0.1.37-3.0.1.el7 will be installed

---> Package nftables.x86_64 1:0.8-14.el7 will be installed

--> Processing Dependency: libnftnl.so.7(LIBNFTNL_5)(64bit) for package: 1:nftables-0.8-14.el7.x86_64

--> Processing Dependency: libnftnl.so.7()(64bit) for package: 1:nftables-0.8-14.el7.x86_64

--> Running transaction check

---> Package libnftnl.x86_64 0:1.0.8-3.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================

 Package                          Arch       Version             Repository         Size

=========================================================================================

Installing:

 podman                           x86_64     1.6.4-29.0.1.el7_9  ol7_oci_included   13 M

Installing for dependencies:

 conmon                           x86_64     3:2.0.26-2.el7      ol7_oci_included   36 k

 containernetworking-plugins      x86_64     0.8.1-2.el7         ol7_addons         20 M

 containers-common                x86_64     1:0.1.37-3.0.1.el7  ol7_addons         21 k

 libnftnl                         x86_64     1.0.8-3.el7         ol7_latest         77 k

 nftables                         x86_64     1:0.8-14.el7        ol7_latest        185 k

Transaction Summary

=========================================================================================

Install  1 Package (+5 Dependent packages)

Total download size: 33 M

Installed size: 129 M

Is this ok [y/d/N]: y

Downloading packages:

(1/6): conmon-2.0.26-2.el7.x86_64.rpm                                    |  36 kB  00:00:00

(2/6): containers-common-0.1.37-3.0.1.el7.x86_64.rpm                     |  21 kB  00:00:00

(3/6): nftables-0.8-14.el7.x86_64.rpm                                    | 185 kB  00:00:00

(4/6): libnftnl-1.0.8-3.el7.x86_64.rpm                                   |  77 kB  00:00:00

(5/6): containernetworking-plugins-0.8.1-2.el7.x86_64.rpm                |  20 MB  00:00:19

(6/6): podman-1.6.4-29.0.1.el7_9.x86_64.rpm                              |  13 MB  00:00:19

------------------------------------------------------------------------------------------------

Total                                                           1.6 MB/s |  33 MB  00:00:20

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : 1:containers-common-0.1.37-3.0.1.el7.x86_64           1/6

  Installing : libnftnl-1.0.8-3.el7.x86_64                           2/6

  Installing : 1:nftables-0.8-14.el7.x86_64                          3/6

  Installing : 3:conmon-2.0.26-2.el7.x86_64                          4/6

  Installing : containernetworking-plugins-0.8.1-2.el7.x86_64        5/6

  Installing : podman-1.6.4-29.0.1.el7_9.x86_64                      6/6

  Verifying  : containernetworking-plugins-0.8.1-2.el7.x86_64        1/6

  Verifying  : podman-1.6.4-29.0.1.el7_9.x86_64                      2/6

  Verifying  : 1:nftables-0.8-14.el7.x86_64                          3/6

  Verifying  : 3:conmon-2.0.26-2.el7.x86_64                          4/6

  Verifying  : libnftnl-1.0.8-3.el7.x86_64                           5/6

  Verifying  : 1:containers-common-0.1.37-3.0.1.el7.x86_64           6/6

Installed:

  podman.x86_64 0:1.6.4-29.0.1.el7_9

Dependency Installed:

  conmon.x86_64 3:2.0.26-2.el7  containernetworking-plugins.x86_64 0:0.8.1-2.el7  

  containers-common.x86_64 1:0.1.37-3.0.1.el7  libnftnl.x86_64 0:1.0.8-3.el7

  nftables.x86_64 1:0.8-14.el7

Complete!

[root@dbsystem01 opc]# podman run -d --name db23cfree container-registry.oracle.com/database/free:latest

Trying to pull container-registry.oracle.com/database/free:latest...

Getting image source signatures

Copying blob 480f5079c729 done

Copying blob 4f739c567988 done

Copying blob def8df68f6e5 done

Copying blob 579d0ff24aa5 done

Copying config 7c64410c08 done

Writing manifest to image destination

Storing signatures

baffef0c8749948427c6a3090fcac02cf82491d30a1e6eeb592d54ac5c75e8be

[root@dbsystem01 opc]# docker logs db23cfree

Error response from daemon: No such container: db23cfree

[root@dbsystem01 opc]# podman exec db23cfree ./setPassword.sh Mexico$2023

The Oracle base remains unchanged with value /opt/oracle

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Tue Apr 4 22:18:46 2023

Version 23.2.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

Connected to:

Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release

Version 23.2.0.0.0

SQL>

User altered.

SQL>

User altered.

SQL>

Session altered.

SQL>

User altered.

SQL> Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release

Version 23.2.0.0.0

[root@dbsystem01 opc]# podman logs

login as: opc

Authenticating with public key "rsa-key-20200507"

Passphrase for key "rsa-key-20200507":

Last login: Tue Apr  4 21:58:14 2023 from 201.198.177.118

[opc@dbsystem01 ~]$ sudo -s /bin/bash

[root@dbsystem01 opc]#  podman logs db23cfree

Starting Oracle Net Listener.

Oracle Net Listener started.

Starting Oracle Database instance FREE.

Oracle Database instance FREE started.

The Oracle base remains unchanged with value /opt/oracle

#########################

DATABASE IS READY TO USE!

#########################

The following output is now a tail of the alert.log:

PDB$SEED(2):Opening pdb with Resource Manager plan: DEFAULT_PLAN

FREEPDB1(3):SUPLOG: Initialize PDB SUPLOG SGA, old value 0x0, new value 0x18

FREEPDB1(3):Autotune of undo retention is turned on.

FREEPDB1(3):Undo initialization recovery: Parallel FPTR failed: start:173647808 end:173647813 diff:5 ms (0.0 seconds)

FREEPDB1(3):[186] Successfully onlined Undo Tablespace 2.

FREEPDB1(3):SUPLOG: Set PDB SUPLOG SGA at PDB OPEN, old 0x18, new 0x0 (no suplog)

2023-04-04T22:16:06.264372+00:00

FREEPDB1(3):Opening pdb with Resource Manager plan: DEFAULT_PLAN

Completed: Pluggable database FREEPDB1 opened read write

Completed: ALTER DATABASE OPEN

2023-04-04T22:18:47.119156+00:00

FREEPDB1(3):TABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P451 (3200) VALUES LESS THAN (TIMESTAMP' 2023-04-05 00:00:00')

2023-04-04T22:21:48.140839+00:00

Resize operation completed for file# 201, fname /opt/oracle/oradata/FREE/temp01.dbf, old size 20480K, new size 86016K

2023-04-04T22:21:49.349843+00:00

Resize operation completed for file# 201, fname /opt/oracle/oradata/FREE/temp01.dbf, old size 86016K, new size 151552K

2023-04-04T22:21:50.547475+00:00

Resize operation completed for file# 201, fname /opt/oracle/oradata/FREE/temp01.dbf, old size 151552K, new size 217088K

2023-04-04T22:21:51.773856+00:00

Resize operation completed for file# 201, fname /opt/oracle/oradata/FREE/temp01.dbf, old size 217088K, new size 282624K

2023-04-04T22:21:52.938738+00:00

Resize operation completed for file# 201, fname /opt/oracle/oradata/FREE/temp01.dbf, old size 282624K, new size 348160K

[root@dbsystem01 opc]# podman exec -it db23cfree sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Tue Apr 4 22:25:42 2023

Version 23.2.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

Connected to:

Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release

Version 23.2.0.0.0

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 FREEPDB1                       READ WRITE NO

SQL> alter session set container=FREEPDB1;

Session altered.

SQL> exit

Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release

Version 23.2.0.0.0

[root@dbsystem01 opc]# podman images

REPOSITORY                                    TAG      IMAGE ID       CREATED      SIZE

container-registry.oracle.com/database/free   latest   7c64410c08d5   7 days ago   10.3 GB

[root@dbsystem01 opc]# podman ps -a

CONTAINER ID  IMAGE                                               COMMAND               CREATED         STATUS             PORTS  NAMES

baffef0c8749  container-registry.oracle.com/database/free:latest  /bin/sh -c exec $...  15 minutes ago  Up 15 minutes ago         db23cfree

[root@dbsystem01 opc]# podman exec -t db23cfree /bin/sh

sh-4.4$

Docker en Linux: yum install vi [Errno 13] Permission denied: '/var/lib/rpm/.dbenv.lock'

Jugando con docker para una imágen de Oracle Database 21c Express, cometí un error en la configuración de un parámetro y la instancia no reinicio al darle el startup.

En mi caso quería habilitar INMEMORY DATABASE y en al setear el parámetro se hizo falta un "0" en el tamaño, ya que el tamaño mínimo con el cuál se puede configurar el parámetro, es de 100MB.

Al crear el archivo de parámetros plano, me doy cuenta que no existe ningún editor de texto instalado en la imágen del docker.

bash-4.2$ ls -la

total 44
drwxr-xr-x. 1 oracle oinstall 57 Apr 7 23:42 .
drwxr-xr-x. 1 oracle oinstall 16 Sep 30 2022 ..
-rw-r--r--. 1 oracle oinstall 953 Apr 7 23:42 init.ora
-rw-r-----. 1 oracle oinstall 442 Sep 30 2022 listener.ora
-rw-r-----. 1 oracle oinstall 2048 Apr 4 22:05 orapwXE
-rw-r--r--. 1 oracle oinstall 775 Sep 30 2022 oratab
-rw-r-----. 1 oracle oinstall 2560 Apr 7 23:30 spfileXE.ora
-rw-r-----. 1 oracle oinstall 54 Sep 30 2022 sqlnet.ora
-rw-r-----. 1 oracle oinstall 678 Sep 30 2022 tnsnames.ora

bash-4.2$ vi init.ora
bash: vi: command not found
bash-4.2$ more init.ora
XE.__data_transfer_cache_size=0
XE.__db_cache_size=989855744
XE.__inmemory_ext_roarea=0
XE.__inmemory_ext_rwarea=0
XE.__java_pool_size=0
XE.__large_pool_size=16777216
XE.__oracle_base='/opt/oracle'#ORACLE_BASE set from environment
XE.__pga_aggregate_target=536870912
XE.__sga_target=1610612736
XE.__shared_io_pool_size=83886080
XE.__shared_pool_size=503316480
XE.__streams_pool_size=0
XE.__unified_pga_pool_size=0
*.audit_file_dest='/opt/oracle/admin/XE/adump'
*.audit_trail='db'
*.compatible='21.0.0'
*.control_files='/opt/oracle/oradata/XE/control01.ctl'
*.db_block_size=8192
*.db_name='XE'
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=XEXDB)'
*.enable_pluggable_database=true
*.inmemory_size=10485760
*.local_listener=''
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=512m
*.processes=320
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1536m
*.undo_tablespace='UNDOTBS1'

bash-4.2$ ls -la
total 44
drwxr-xr-x. 1 oracle oinstall 57 Apr 7 23:42 .
drwxr-xr-x. 1 oracle oinstall 16 Sep 30 2022 ..
-rw-r--r--. 1 oracle oinstall 953 Apr 7 23:42 init.ora
-rw-r-----. 1 oracle oinstall 442 Sep 30 2022 listener.ora
-rw-r-----. 1 oracle oinstall 2048 Apr 4 22:05 orapwXE
-rw-r--r--. 1 oracle oinstall 775 Sep 30 2022 oratab
-rw-r-----. 1 oracle oinstall 2560 Apr 7 23:30 spfileXE.ora
-rw-r-----. 1 oracle oinstall 54 Sep 30 2022 sqlnet.ora
-rw-r-----. 1 oracle oinstall 678 Sep 30 2022 tnsnames.ora

bash-4.2$ nano init.ora
bash: nano: command not found

bash-4.2$ edit init.ora
bash: edit: command not found

Intento instalar el editor "VI" y recibo un error a la hora ejecutar el YUM INSTALL

bash-4.2$ yum install vi
Loaded plugins: ovl
ovl: Error while doing RPMdb copy-up:
[Errno 13] Permission denied: '/var/lib/rpm/.dbenv.lock'
You need to be root to perform this command.
bash-4.2$ [Errno 13] Permission denied: '/var/lib/rpm/.dbenv.lock'
bash: [Errno: command not found

Lo que sucede es que para poder hacer la instalación es necesario a la hora de logearse en el docker incluir el párametro "-u=0".

[root@dbsystem01 opc]# docker exec -u=0 -it myoradb1 bash -c "bash"
bash-4.2# yum install vi
Loaded plugins: ovl
ol7_latest | 3.6 kB 00:00:00
(1/3): ol7_latest/x86_64/group_gz | 136 kB 00:00:00
(2/3): ol7_latest/x86_64/updateinfo | 3.5 MB 00:00:00
(3/3): ol7_latest/x86_64/primary_db | 45 MB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package vim-minimal.x86_64 2:7.4.629-8.0.1.el7_9 will be installed
--> Finished Dependency Resolution

Total download size: 443 k

Installed size: 914 k

Is this ok [y/d/N]: y

Downloading packages:

vim-minimal-7.4.629-8.0.1.el7_9.x86_64.rpm                                                                                                       | 443 kB  00:00:03

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : 2:vim-minimal-7.4.629-8.0.1.el7_9.x86_64                                                                                                             1/1

  Verifying  : 2:vim-minimal-7.4.629-8.0.1.el7_9.x86_64                                                                                                             1/1

Installed:

  vim-minimal.x86_64 2:7.4.629-8.0.1.el7_9

Complete!

bash-4.2#

Ahora si se logra instalar el editor y puedo cambiar mi archivo y volver a levantar la base de datos.

Máquina Vritual para VirtualBox con la versión gratuita de la base de datos Oracle 23c para desarrolladores y Oracle Apex 22.2- Por Clarisa Maman

¿Estas listo para aprender lo nuevo de la base de datos Oracle 23c? Te comparto mi último video donde explico cómo importar la nueva máquina virtual en VirtualBox con Oracle Database 23c y APEX 22.2 en su versión gratuita para desarrolladores!

En este tutorial te explico como importar la máquina virtual que nos provee Oracle en VirtualBox lista para usar y aprender de las nuevas características de la base de datos Oracle 23c. 

Esta MV tiene instalado los siguientes productos: 

• Oracle Linux 8.7
• Oracle Database 23.2 Free - Developer Release for Linux x86-64
• Oracle REST Data Services 23.1
• Oracle SQLcl 23.1
• Oracle APEX 22.2

Te dejo el link donde puedes descargar la maquina virtual: https://www.oracle.com/database/techn...

#oracleapex #kiu #oracle #software #desarrollo #oracleace #database #oracledatabase

AskTOM Office Hours Digest for Week of April 03

Oracle AskTOM Office Hours offers free, live Q&A sessions with Oracle experts. Here are the Office Hours coming up this week for which you are registered. You'll also find below any new Office Hours sessions we've recently added to the program. Enjoy!

Tuesday, April 04

16:00 UTC: Solution Deployment: Estimating home property values using Autonomous Database, Oracle Machine Learning, and Oracle APEX

How do you deploy a machine-learning solution in an application? In this session, learn how to use Oracle Autonomous Database with Oracle Machine Learning (OML) and Oracle APEX services for fast and easy development of machine learning (ML) models in Autonomous Database. See how to use Oracle APEX to visualize and operationalize ML model predictions. This solution deployment demonstration, based on Brooklyn property value data, details how to use OML with AutoML to train an ML model on 15 years of historical property transactions, and then use those models within Oracle APEX to estimate the market value of homes across Brooklyn, NY. The ML pipeline developed for this demo can be easily adapted for a wide variety of ML use cases that Oracle customers face today, such as forecasting needs, demand, expenses, etc, as well as what-if scenario modeling.