Study the Mike Dietricht’s blog, with a lot of videos, in particular Zero Downtime Migration tool (ZDM). :
Sunday, June 19, 2022
Saturday, June 18, 2022
Itinerary to Data Scientist
This is the list of certifications I have followed on the path from DBA to data scientist:
Oracle Cloud Infrastructure 2021 Certified Architect Professional (1Z0-997-21)
Oracle Cloud Database Services 2021 Certified Specialist (1Z0-1093-21)
Oracle Cloud Database Migration and Integration Specialist (1Z0-1094–21)
Oracle Autonomous Database 2021 Specialist (1Z0-931-21)
Oracle Machine Learning using Autonomous Database 2021 Specialist (1Z0-1096-21)
Oracle Cloud Infrastructure Security 2021 Associate (1Z0-1104-21)
Oracle Cloud Platform Application Integration 2021 Specialist (1Z0-1042-21)
Oracle Cloud Infrastructure 2021 Certified Architect Associate (1Z0-1072-21) 1Z0-1042-21)
Oracle Cloud Infrastructure 2021 Certified Architect Professional (1Z0-997-21)
Oracle Cloud Database Services 2021 Certified Specialist (1Z0-1093-21)
Oracle Cloud Database Migration and Integration Specialist (1Z0-1094–21)
Oracle Autonomous Database 2021 Specialist (1Z0-931-21)
Oracle Machine Learning using Autonomous Database 2021 Specialist (1Z0-1096-21)
Oracle Cloud Infrastructure 2021 Certified Architect Associate (1Z0-1072-21)
Oracle Clourd Infrastructure 2021 Certified Architect Professional (1Z0-997-21)
Oracle Cloud Platform Application Integration 2021 Specialist (1Z0-1042-21)
————————————-
Oracle Cloud Infrastructure Security 2021 Associate (1Z0-1104-21)
Oracle Cloud Database Services 2021 Certified Specialist (1Z0-1093-21)
Oracle Cloud Database Migration and Integration Specialist (1Z0-1094–21) |
https://catalog-education.oracle.com/pls/certview/sharebadge?id=BF1401EFB019FFFB05BDFB6C9E269997CC73995D4A29A2C07C30925F5F21F9C9 |
Oracle Autonomous Database 2021 Specialist (1Z0-931-21) |
https://catalog-education.oracle.com/pls/certview/sharebadge?id=E531555B94E028BC9D21327CBD99BC0AE9393A521CCD6E82E516AA8F8A4DECFB |
Oracle Machine Learning using Autonomous Database 2021 Specialist (1Z0-1096-21) |
https://catalog-education.oracle.com/pls/certview/sharebadge?id=51995BB3D53949C1BBED2525FBDC5498E42AB63A76211AEC598D7DFA9769C380 |
Oracle Cloud Infrastructure 2021 Certified Architect Associate (1Z0-1072-21) |
https://catalog-education.oracle.com/pls/certview/sharebadge?id=A0B291E7CBA58AB58A3DDCC627ED321D88B16F38B19C01D56995387ACD85C361 |
How to create a Data Guard Broker Configuration in Oracle 19c
Here an article from my colleague Fernando:
https://rootfan.com/data-guard-broker-configuration-oracle-19c/#more-1677
And just another useful one, in a virtualized environment:
https://oracledbwr.com/step-by-step-guide-to-install-oracle-19c-rac-installation-using-virtualbox/
Oracle Clusterware 19C
Official documentation, all you need to know about all the architectures and possibilities of Oracle Clusterware 19C.
Here you will find Fleet Patching and Provisioning.
DATAGUARD 19C
Fleet Patching and Provisioning commands
Formerly “Rapid Home Provisioning (RHP)”, thats the reason for the command rhpctl.
This artefact consists of a server connected to an ACFS where clusterware and RDBMS binaries are stored for distribution and installation on client nodes.
The following is a summary of the main commands that will help us install and update the software
srvctl start rhpserver
srvctl add rhpserver -storage /// -diskgroup xxx
rhpctl import image… -imagetype -path
rhpctl add image -image abc -workingcopy abcwc
rhpctl add workingcopy -workingcopy WC1 -image iii -storagetype LOCAL -path /ora19
rhpctl upgrade gihome -sourcewc aa -destwc bb
rhpctl upgrade database
rhpctl zdtupgrade database…
rhpctl addpdb database…
rhpctl deletepdb database…
Bynaries:rhpctl add workingcopy -image db19 -path /u01…. -client xxx -oraclebase /u01.. - workingcopy w1
RDBMS:rhpctl add database -workingcopy w1 -dbname db - node a,b -dbtype RAC- datafiledestination xx_DG
rhpctl move database -sourcewc a -patchedwc a_psu
Thursday, May 12, 2011
CHANGING THE COLUMNS WIDTH USING CSSCAN
[CAT ]Després de passar el CSSCAN, com a subproducte, i a part dels fitxerets que es generen, queda la mateixa informació a l'esquema CSMIG (s'ha de crear abans de passar el CSSCAN [@csminst.sql]). Doncs aquesta info es pot utilitzar per generar les ordres d'ampliació de les columnes que no hi cabran al nou codi de caràcters.
cat prova.err|grep "Number of Exceptions"|grep -v ": 0"|wc –l
This select produces the instructions for the tables that can't fit in the actual column size:
set linesize 222
SELECT 'ALTER TABLE '||PROP||'.'||TAULA||' MODIFY '
||dba_tab_columns.COLUMN_NAME||' '||
dba_tab_columns.DATA_TYPE||'('||TAMANY||');' DDL
FROM
(select DISTINCT U.USERNAME PROP, O.OBJECT_NAME TAULA,
T.COLUMN_ID COL_ID, max(MAXSIZ) TAMANY
from CSM$COLUMNS C, dba_users U,
dba_objects O, dba_tab_columns T
where C.ERRCNT > 0 and
C.USR#=U.USER_ID and
C.OBJ#=O.OBJECT_ID and
C.COL#=T.COLUMN_ID
group by U.USERNAME, O.OBJECT_NAME, T.COLUMN_ID),
dba_tab_columns
WHERE PROP = dba_tab_columns.OWNER
AND TAULA = dba_tab_columns.TABLE_NAME
AND COL_ID = dba_tab_columns.COLUMN_ID
ORDER BY 1;
EXAMPLE OUTPUT:
ALTER TABLE DMBATCH.TAULA MODIFY NOM_PERSONA_TIT VARCHAR2(54);
....