Sunday, June 19, 2022

Upgrading sn Migrating

 Study the Mike Dietricht’s blog, with a lot of videos, in particular Zero Downtime Migration tool (ZDM). :

https://mikedietrichde.com/

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)


https://catalog-education.oracle.com/pls/certview/sharebadge?id=B210042D42359D33CB260E79DAE54808650FA4901D32CA89E7D8EEC3940EC3FA


Oracle Cloud Platform Application Integration 2021 Specialist (1Z0-1042-21)


https://catalog-education.oracle.com/pls/certview/sharebadge?id=3F7FF037F3DBCFDE13DFB8E87735A396565AFC12F79E19B705F0EA58FEC274C2


————————————-

Oracle Cloud Infrastructure Security 2021 Associate (1Z0-1104-21)


https://catalog-education.oracle.com/pls/certview/sharebadge?id=FA5557BF6EFD2F7F15FBB5FAF2B4791D20CD9A381CC22F24799B5264A76F4BA5


Oracle Cloud Database Services 2021 Certified Specialist (1Z0-1093-21)


https://catalog-education.oracle.com/pls/certview/sharebadge?id=815B21E3AA29FB32D3E58748E12AC11010285923C28E3A328F8F1ED367B7E366


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.

https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/clusterware-administration-and-deployment-guide.pdf

DATAGUARD 19C

Official documentation, all you need to know about all the architectures and possibilities of Oracle 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

After executing CSSCAN some files are generated (.err, .out) informing about the columns that will not fit in the target charset(usually ALxUTFz)and, furthermore, in the host schema CSMIG (@csminst.sql) the same information is stored, so we can use it to generate the modifications needed:

[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);
....