Here I will cover the shrink of ASM diskgroup in Exadata environment running VM’s. The process here is the opposite of what I wrote in the previous post, but have a tricky part that demands attention to avoid errors. The same points that you checked for extending are valid now: number the cells, disks per cell, ASM mirroring, and the VM that you want to change continue to be important, but we have more now. Besides that, the post shows how to verify if you have something in the ASM internal extent map that can block the shrink and “fix” this.
Recently, in March, I made the reimage from an X5-2 HA ODA and saw a strange behavior during the diskgroup creation and couldn’t reproduce (because involve reimaging again). Basically, the FLASH diskgroup was not created.
But in last May I reimaged another ODA using the same patch/imageversion (188.8.131.52 – Patch 27604623) and was possible to verify again. In both cases, I created the appliance using the CLI “odacli create-appliance” using JSON file because the network uses VLAN (what it is impossible to create using the web interface), and both appliances are identical (X5-2 HA with SSD for RECO and FLASH).
To reimage, I followed the steps in the docs for this version and used the ISO to do the baremetal procedure. If you look in the docs about the options for storage (check here) you can see that there is no single reference to use FLASH diskgroup (or that you need to do that). Checking in the readme/reference JSON files that exist in the folder “/opt/oracle/dcs/sample” under file “sample-oda-ha-json-readme.txt”:
As you know, for ODA, you have two options for storage: ACFS or ASM. If you choose ACFS, you can create all versions for databases, from 11g to 18c (until this moment). But if you choose ASM, the 11g will not be compatible.
So, ASM or ACFS? If you choose ACFS, the diskgroup where ACFS runs will be sliced and you have one mount point for each database. If you have, as an example, one system with more than 30 databases, can be complicated to manage all the ACFS mount points. So, ASM it simple and easier solution to sustain. Besides the fact that it is more homogeneous with other database environments (Exadata, RAC’s …etc).
If you choose ASM you can’t use 11g versions or avoid the ACFS mount points for all databases, but you can do a little simple approach to use 11g databases and still use ASM for others. Took one example where just 3 or 4 databases will run over 11g version and all others 30 databases in the environment will be in 12/18. To achieve that, the option, in this case, is using a “manual” ACFS mount point, I will explain.
More than 160 eProseed employees have made the trip from across Europe, the Middle East and beyond the Atlantic to attend the first edition of eProseed World, a two-day event held in Luxembourg on February 8 and 9, aimed at promoting exchanges and triggering debates between all the active forces of the company, featuring keynotes, breakout sessions, live demos and, just as importantly, team building games and true moments of fun and conviviality.
Lonneke Dikmans, Simon Haslam and Marco Gralike will represent eProseed at UKOUG Technology Conference & Exhibition UKOUG TECH18, a major annual event for the Oracle user community and reunites top Oracle customers and professionals across UK and Ireland. The event will take place between 2 to 5 December 2018 at Kings Dock in Liverpool UK.
At the Central Bank FinTech and RegTech Global Summit 2018 held in Singapore on September 6 and 7, 2018, Geoffroy de Lamalle, CEO of eProseed RTC discussed about the major challenges of risk-based supervision and explained how data architecture and Artificial Intelligence represent the future of regulatory reporting, helping Central Bank and Supervisory Authorities to accelerate and increase the supervisory cycles.
In an increasingly regulated economy, finding and capitalizing on the common denominator between news laws, directives, standards, or best practices is crucial. Using a megamodel is the best way to build, maintain and evolve an efficient cross-regulation platform, avoid the multiplication of data silos and prevent systemic risks from occurring, according to Fabien Henriet, Global CTO at eProseed RTC.
Enterprises in the 21st Century face a dramatic change in the expectations of their customers. These expectations, for new services, products, heightened privacy, and advanced interactions are driving organizations to change both quickly and radically. Responding to this intense demand requires a change to the technology organizations use to deliver an evolved offering to a more discerning and demanding consumer.
Continuing its international expansion, eProseed announces the opening of its second entity in Portugal. From the Lisbon office, eProseed will deliver its full range of services to customers throughout Europe and beyond.