Network type : Virtual Function I/O
miércoles, 31 de mayo de 2023
Instancia OCI: Error en Migración en Vivo ( Live Migration ) Incompatible
Network type : Virtual Function I/O
viernes, 19 de mayo de 2023
ORA-00918: column ambiguously defined consulta con ANSI SQL reportado por Mike Dietrich en caso de Peter Lehmann en Oracle Database 23c Free-Developers
******************************************************************# Oracle Database 23c Free for Developers Using username "opc". Authenticating with public key "rsa-key-20200507" Passphrase for key "rsa-key-20200507": Activate the web console with: systemctl enable --now cockpit.socket Last login: Tue May 2 03:48:27 2023 from 201.204.89.63 [opc@oracle-database-server-free-for-developers ~]$ sudo su - oracle Last login: Tue May 2 04:37:35 GMT 2023 on pts/0 [oracle@oracle-database-server-free-for-developers ~]$ sqlplus hr/oracle@pdb1 -bash: sqlplus: command not found [oracle@oracle-database-server-free-for-developers ~]$ . oraenv ORACLE_SID = [oracle] ? FREE The Oracle base has been set to /opt/oracle [oracle@oracle-database-server-free-for-developers ~]$ sqlplus hr/oracle@pdb1 SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Thu May 4 00:25:41 2023 Version 23.2.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Last Successful login time: Tue May 02 2023 04:39:57 +00:00 Connected to: Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release Version 23.2.0.0.0 SQL> drop table t1; Table dropped. SQL> drop table t2; Table dropped. SQL> create table t1 (id int); create table t2 (id int); insert into t1 values(1); insert into t1 values(2); insert into t2 values(1); insert into t2 values(2); commit; Table created. SQL> Table created. SQL> SQL> 1 row created. SQL> 1 row created. SQL> SQL> 1 row created. SQL> 1 row created. SQL> SQL> Commit complete. SQL> select * from t1; ID ---------- 1 2 SQL> select * from t2; ID ---------- 1 2 select a_t1.id from t1 a_t1 inner join t2 a_t2 on a_t1.id=a_t2.id inner join t2 a_t2 on a_t1.id=a_t2.id; ID ---------- 1 2 select a_t2.id from t1 a_t1 inner join t2 a_t2 on a_t1.id=a_t2.id inner join t2 a_t2 on a_t1.id=a_t2.id ; select a_t2.id from t1 a_t1 * ERROR at line 1: ORA-00918: column ambiguously defined SQL> show user USER is "HR"
SQL> connect sys/oracle@pdb1 as sysdba Connected.
SQL> exit
Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
[oracle@oracle-database-server-free-for-developers ~]$ cd $ORACLE_HOME
[oracle@oracle-database-server-free-for-developers dbhomeFree]$ cd OPatch
[oracle@oracle-database-server-free-for-developers OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/product/23c/dbhomeFree
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/23c/dbhomeFree/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.9.0
Log file location : /opt/oracle/product/23c/dbhomeFree/cfgtoollogs/opatch/opatch2023-05-04_03-36-20AM_1.log
Lsinventory Output file location : /opt/oracle/product/23c/dbhomeFree/cfgtoollogs/opatch/lsinv/lsinventory2023-05-04_03-36-20AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oracle-database-server-free-for-developers.vcnlandb.vcntestinglab.oraclevcn.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 23c 23.0.0.0.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@oracle-database-server-free-for-developers OPatch]$ sqlplus sys/oracle@pdb1 as sysdba
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Thu May 4 03:38:37 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> alter system set "_fix_control" = '29015273:ON' scope=both;
System altered.
SQL> connect / as sysdba
Connected.
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 FREEPDB1 READ WRITE NO SQL> alter pluggable database FREEPDB1 close; Pluggable database altered. SQL> alter pluggable database FREEPDB1 open; Pluggable database altered. SQL> show parameter fix_control NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _fix_control string 29015273:1 SQL> connect hr/oracle@pdb1 Connected.
SQL> select a_t2.id from t1 a_t1 inner join t2 a_t2 on a_t1.id=a_t2.id inner join t2 a_t2 on a_t1.id=a_t2.id; ID ---------- 1 2 SQL>
jueves, 18 de mayo de 2023
Oracle invita: 25 de Mayo Introducción a Plug-ins en Oracle APEX
¡Acompáñanos el 25 de Mayo para conocer como puedes extender las funcionalidades de APEX con plug-ins!
http://apex.oracle.com/go/apex-español #orclAPEX #LowCode #Oracle
miércoles, 17 de mayo de 2023
ORAMEX: Jueves 18 de Mayo 5:PM CDMX Data Integration Options en OC
Tomorrow (May 18th at 5PM Mexico Time) as part of the Thursday OCI Series, I am participating in this webinar to talk about the evolution of Data Integration in Oracle.
You can join us here:https://lnkd.in/g6mCWbW6
ORAMEX Arturo González Romero SPS
martes, 16 de mayo de 2023
The EMEA Community Tour 2023 will take place between 2rd of October and 19th of October.
The EMEA Community Tour 2023 will take place between 2rd of October and 19th of October.
This year, 10 countries / 8 Oracle User Groups within EMEA will collaborate to bring together novices and specialists from all over the world
Submit your abstract by 21st of May, 23:59 CEST.
The events are scheduled as follows:
October, 2nd – DOUG-day 2023 (Copenhagen / Denmark)
October, 3rd – OUGF (Helsinki / Finland)
October, 5th – nlOUG + OBUG (Utrecht / Netherlands)
October, 7th – KSAOUG (Riyadh / Saudi Arabia)
October, 9th – CASOUG ( Bishkek / Kyrgyzstan)
October, 10th – CASOUG ( Tashkent /Uzbekistan)
October, 12th – CASOUG ( Dushanbe / Tajikistan)
October, 14th – AzerOUG (Baku / Azerbaijan)
October, 17th – SPOUG (Madrid / Spain)
October, 19th – HrOUG23 (Rovinj / Croatia)
jueves, 11 de mayo de 2023
SPOUG te invita a las siguientes sesiones de su #SPOUGAcademy para la 3era semana de Mayo de este 2023
Las sesiones de #SPOUGAcademy de la semana que viene serán el martes 16 de mayo sobre #OracleAPEX con Mónica Godoy y el miércoles 17 de mayo sobre #Security con Ronald Francisco Vargas.
🎯 Oracle APEX: Nuevas Características para ser 20x más productivo
💼 Oracle APEX
📍 Virtual
📅 16 mayo
⌚ 17h CET Time
✍️ Registro Miembro SPOUG ➡ https://lnkd.in/dvej_3wB
✍️ Registro NO Miembro SPOUG ➡ https://lnkd.in/dp-Kays3
🎯 Oracle Database Ethical Hacking: Sus datos podrían estar en el lugar equivocado
💼 Security
📍 Virtual
📅 17 mayo
⌚ 17h CET Time
✍️ Registro Miembro SPOUG ➡ https://lnkd.in/d2z2434M
✍️ Registro NO Miembro SPOUG ➡ https://lnkd.in/dBqw3i9n
¡NO TE LAS PIERDAS!
#SPOUG #Comunidad #SPOUGAcademy
martes, 9 de mayo de 2023
#SPOUG Academy eventos del 08 al 11 de mayo de 2023
Las sesiones de #SPOUGAcademy de esta semana serán hoy lunes 8 de mayo sobre #OracleAPEX con Carsten Czarski & David Lapp, el miércoles 10 de mayo sobre #Security con Ron Ekins y el jueves 11 de mayo sobre #OracleAPEX con Steve Muench.
🎯 Oracle APEX to the next level with Spatial💼 Oracle APEX
📍 Virtual
📅 8 mayo
⌚ 17h CET Time
✍️ Registro Miembro SPOUG ➡ https://lnkd.in/djCCZQd5
✍️ Registro NO Miembro SPOUG ➡ https://lnkd.in/dqFbXyvn
✔ Guardians of the Data - Protecting Oracle Backups from Ransomware and Malicious Intent
💼 Security
📍 Virtual
📅 10 mayo
⌚ 17h CET Time
✍️ Registro Miembro SPOUG ➡ https://lnkd.in/dYmfUZ3R
✍️ Registro NO Miembro SPOUG ➡ https://lnkd.in/dzFA7MNz
✔ Understanding the Oracle APEX Application Development Lifecycle
💼 Oracle APEX
📍 Virtual
📅 11 mayo
⌚ 17h CET Time
✍️ Registro Miembro SPOUG ➡ https://lnkd.in/dtRpnM5A
✍️ Registro NO Miembro SPOUG ➡ https://lnkd.in/dzAVqths
¡NO TE LAS PIERDAS!
#SPOUG #Comunidad