22.11.2022 – Update with Inputs from Roy Swonger, thank you Roy Why do we have AUDSYS data in our Oracle Data Pump full export? In a customer project, I was asked why there is always data of schema owner AUDSYS included in an Oracle Data Pump full export. The AUDSYS schema contains Unified Audit Trail Records and therefore the data is included when the feature is enabled. The demo case is a 19.15 Container Database with a PDB. The demo schema HR is loaded and there is a Unified Auditing Policy which gathers information whenever data from the schema HR are selected. SQL> SELECT parameter, value FROM v$option WHERE parameter = ‘Unified Auditing’; PARAMETER VALUE ——————– ——————– Unified Auditing…
Read MoreCategory: Oracle RDBMS
AWS Custom Engine Versions for Amazon RDS Custom for Oracle – Sightseeing Tour Part 3/3 – Pricing and personal Thoughts
This is the third and last part of the blog post series about AWS Custom Engine Versions for Amazon RDS Custom for Oracle. The blog post series: Part 1: Gives you an overview about the setup Part 2: About connectivity and what you get from AWS Part 3: My personal opinion about this service and some words about pricing After testing and running AWS RDS Custom for Oracle for a while, it’s time to came to a summary and finish the blog post series. First, let’s do a small comparison with the shapes what we used against Oracle Cloud Infrastructure. In the OCI DBCS service, we have full access to the database server too and have a lot of possibilities…
Read MoreAWS Custom Engine Versions for Amazon RDS Custom for Oracle – Sightseeing Tour Part 2/3 – Connectivity and what you get
This is the second part of the blog post series about AWS Custom Engine Versions for Amazon RDS Custom for Oracle. In this part we take a look how we can connect to the Oracle database host and to the database itself by a tool like the Oracle SQL Developer. The blog post series: Part 1: Gives you an overview about the setup Part 2: About connectivity and what you get from AWS Part 3: My personal opinion about this service and some words about pricing Connect as Schema User The username and the password for the SQl*Plus connect are the ones you have added as Master username and Master password during CEV RDB instance creation process. The database endpoint…
Read MoreAWS Custom Engine Versions for Amazon RDS Custom for Oracle – Sightseeing Tour Part 1/3 – Setup
Some weeks ago I saw in an AWS public presentation a topic about a RDS service for Oracle databases where you can build your own environments and get full OS access. This was new for me how knows the normal AWS RDS offerings for Oracle databases, where no (or very limited) OS access is possible. And this meant for me as a child of Oracle Cloud Infrastructure: time to play! I spent a lot of time in the last three weeks to take a deep dive. It was, let’s say, a nice experiment. In this blog post I give you an overview what this service for Oracle on AWS is, how you will bring it up and running and what’s…
Read MoreOracle 11g – let’s move that old Stuff to the Oracle Cloud
This blog post describes the lift and shift of an on-prem Oracle 11g Enterprise Edition to Oracle Cloud Infrastructure by using Oracle RMAN paired with OCI Object Storage. Works for other versions > Oracle 11g / Enterprise Edition too (the tablespace encryption method may change). Architecture Q&A What’s the motivation of the lift and shift of a good old on-prem Oracle 11g database to Oracle Database Service? Hardware runs out of lifecycle Out scoping of an on-prem database which is only used for several times to compare old data Regulatory, for example we have the keep and access the data for 10 yrs Changing from on-prem licenses to the license included model Upgrade tests for 19c and convert to Multitenancy…
Read More