Move PDB to Cloud 12.1 to 12.2
Carlos Magno – EzDBA
by Carlos Magno
2y ago
– Be sure that the BUG Fix (18633374) is applied on the Source Database: — The PSU 12.1.0.2.190416 or higher should be applied also on the source. *** On-Premises: 1.) Check Status of the Source Database: SQL> select * from gv$pdbs where con_id=13; INST_ID CON_ID DBID CON_UID GUID NAME OPEN_MODE RES OPEN_TIME CREATE_SCN TOTAL_SIZE BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID 1 13 168895093 168895093 8837DFB294B8214DE054020820D8D4F1 PDBTEST ..read more
Visit website
Table Compression
Carlos Magno – EzDBA
by Carlos Magno
2y ago
— Table Compression https://oracle-base.com/articles/11g/dbms_compression-11gr2 https://www.oracle.com/us/assets/lad-2015-ses16380-pedregal-2604876.pdf http://www.bestremotedba.com/2017/01/25/how-to-advance-compression-12c/ https://www.morganslibrary.org/reference/compression.html --- MOS Notes- Advanced Compression Master Note(Doc ID 1223705.1)– How to compress a table that is online(Doc ID 1353967.1)– Advanced Compression critical patches(Doc ID 1061366.1)– Redo Transport compression with Data Guard (Doc ID 729551.1)– How to see if rows are compressed in a table(Doc ID 1477918.1) --- Test ..read more
Visit website
EXADATA CELL – Commands
Carlos Magno – EzDBA
by Carlos Magno
2y ago
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-monitoring.html#GUID-56D5DEDC-6999-4BA5-A6B8-1816A8528405 select * from v$cell; -------------------------------------------------------------------------------------------------------------------------------------- select * from V$BACKUP_DATAFILE; -------------------------------------------------------------------------------------------------------------------------------------- SELECT name, value/1024/1024 MB FROM v$sysstat a WHERE a.name = 'physical read total bytes' OR a.name = 'physical w ..read more
Visit website
JSON Query
Carlos Magno – EzDBA
by Carlos Magno
2y ago
  --- Using OCI and Database JSON https://oracle-base.com/articles/12c/json-support-in-oracle-database-12cr1 https://stackoverflow.com/questions/44149124/load-a-json-file-from-filestsystem-to-oracle-database https://docs.oracle.com/database/121/SQLRF/functions092.htm#SQLRF56973 On this example i am going to show , based on the oci cli output, how to insert and query a JSON Data on database. The file is based on REGIONS list from Oracle Cloud. --- Including JSON into a table: Json File: based on OCI CLI - Regions C:\Users\candrade>oci iam region list --output table ..read more
Visit website
Oracle Autonomous Transaction Processing and Roadmap
Carlos Magno – EzDBA
by Carlos Magno
2y ago
Hi All, this is the roadmap that just came out from Oracle Open World 2018, have a look into the Roadmap and stay tunned…. ATP_Overview_and_Roadmap_2018 ..read more
Visit website
Convert Database from Standard Version to Enterprise Version. 12.2
Carlos Magno – EzDBA
by Carlos Magno
2y ago
Steps to convert the Standard Database to Enterprise Edition… in a real world… How to Convert Oracle Database 12c from Standard to Enterprise Edition ? (Doc ID 2046103.1) 1.) Take a FULL backup of the database, if possible OFFLINE; 2.) Install the new binary in the different ORACLE_HOME; 3.) Check the PATCHES, the new ORACLE_HOME should be at least on the same level of PATCHES. So , if needed apply the PSUs / One-OFFs … 4.) If you are using the GRID Infrastructure, the ORACLE_HOME must be changed with srvctl; 5.) create pfile from spfile in order to keep the current INIT of the database; 6.) S ..read more
Visit website
Applying Patch on Oracle DBSystem on Oracle Cloud
Carlos Magno – EzDBA
by Carlos Magno
2y ago
On the link below you will find the steps to apply patch over a DBSystem in Oracle Cloud. DBSystem is different comparing with just a Database in cloud. There you can find already runing the ASM Instance and CRS runing. Enjoy…. PatchDBSystem ..read more
Visit website
Applying Patch on Oracle Database in Oracle Cloud
Carlos Magno – EzDBA
by Carlos Magno
2y ago
On this post i will show how to apply patch on Oracle Database inside of Oracle Cloud. 1.) Choose your database 2.) Checks the Avalilables Patches… On this case we have 1… 3.) Before apply the patch you should execute the PreCheck option, in order to see if there is some issue… For the first time I faced this issue during the Pre-Check Precheck failed due to incorrect Cloud tooling version and latest Cloud tooling update not available . “No applicable dbaastools rpms found” (Doc ID 2400143.1) The Solution (If your DBAASTOOLS is older than 18.2.3.1.0): [opc@db02 ~]$ sudo su – [root@db02 ..read more
Visit website
Creating a Database and Connecting on Oracle Cloud
Carlos Magno – EzDBA
by Carlos Magno
2y ago
On this post i will show the steps in order to create an Oracle Database on Oracle Cloud and connect… 1.) Connect o Oracle Cloud, on this case a create a Trial Login, you will receive an amount to try create a lot of stuffs… it’s nice to know better the platform… It’s easy when you use the Guided Journey You choose the Integrate, Store and Analyze Data option… Here you can choose the best option… I choose the Custom in order to explore more the options… Here i am no setting up the backup strategy, in another post i will explore more about that… Check also here the Time Zone appropriate for ..read more
Visit website
Exadata X7-2 – Patch 18.1.5 – OVM
Carlos Magno – EzDBA
by Carlos Magno
2y ago
Quarterly Full Stack Download Patch For Oracle Exadata (Apr 2018 – 18.0.0.0)     Version Software Notes See Note 1270094.1 for additional fixes that address critical issues. 18.1.5.0.0 Patch 27503194 – Storage server and InfiniBand switch software (18.1.5.0.0.180506) Patch 27561908 – x86-64 Database server bare metal / domU ULN exadata_dbserver_18.1.5.0.0_x86_64_base OL6 channel ISO image (18.1.5.0.0.180506) Patch 27561909 – x86-64 Database server dom0 ULN exadata_dbserver_dom0_18.1.5.0.0_x86_64_base OVM3 channel ISO image (18.1.5.0.0.180506)  Recommended for al ..read more
Visit website

Follow Carlos Magno – EzDBA on FeedSpot

Continue with Google
Continue with Apple
OR