-
Building a transportable Oracle Sandbox environment for an Apple Silicon Laptop (MacBook with M1- or M2-processor)
Since Apple released their Apple Silicon Laptops based on the ARM processor architecture, it became difficult for Consultants with such a device to run their Oracle Sandbox environment, because the main Oracle products are running on the Intel architecture. Hence a virtual machine on an Apple Silicon MacBook cannot be used for e.g. an Oracle…
-
Installing Oracle 23c Free developer release on Proxmox
Oracle provides an OVA (Open Virtual Appliance) file to install the 23c Free Developer Release on Virtualbox. An OVA file contains metadata and file elements in the Open Virtual Format (OVF) to package and distribute one or more virtual machines. The OVA-file provided by Oracle can also be used to import the Oracle 23c Free…
-
Patching ODA to 19.18.: Error in sshd_config
I recently patched an Oracle Database Appliance (ODA) from 19.16. to 19.18. Detailed steps on how to patch to 19.18. are available here. During the update-server step I got the following error: So obviously something is wrong with sshd_config. If an error happens when running a job on the ODA with odacli then I check…
-
Oracle: Is it possible to setup a system that a client (specific IP address) can only connect to a specific DB-User?
Problem description In a recent consulting assignment I got the following task: A server with a specific IP address (Application server or Oracle Client) should be able to connect to a specific DB-user only. E.g. a single application server responsible for reports should be able to only connect to a specific read-only-user in the database.…
-
Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)
To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when using platforms låike Exadata Cloud at Customer. I recently had a case where both the Primary…
-
Latency test from Client to Oracle DB: Minimum number of rows fetched in sqlplus and sqlcl
-
Running Intel x86-64 VMs with an Oracle DB on Apple Silicon (ARM)
For testing purposes many IT-people traditionally use Virtual Machines (VMs) on their Laptops (often on Oracle Virtualbox). Since Apple moved to its own processor type (Apple Silicon, i.e. ARM architecture), it’s no longer possible to run VMs based on Intel x86-64 on Apple ARM (e.g. on Apple MacBook Pros with M1 or M2 processors). I.e.…
-
datapatch fails when running against an Oracle Container Database because of missing temp files in PDBs
When going to 19.15. a customer hit this error when running datapatch: Unsupported named object type for bind parameter at /u01/app/oracle/product/19.0.0.0/dbhome1915/sqlpatch/sqlpatch.pm line 5849, line 4452. After anlyzing the issue it turned out to be related to what has been documented in My Oracle Support NoteDatapatch Failed with Error:“ORA-25153: Temporary Tablespace is Empty“ (Doc ID 2285159.1)…
-
Why do we still have HEIGHT BALANCED Histograms and how to get rid of them?
A customer, who is on 19c with his Oracle databases asked me recently why he still has Height Balanced Histograms in his database? E.g. In 12.1. Oracle introduced Top Frequency and Hybrid Histograms, which should replace Height Balanced histograms. There are 2 main reasons why Height Balanced histograms may still be there: 1. Top Frequency…