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 Cloud Infrastructure Quick Tip – Use the Bastion Service with MobaXterm
Mobatek’s MobaXterm is my favorite terminal for the daily work. It supports a lot of protocols like SSH, RDP, VNC, integrates X11 and SFTP and many more. And, MobaXterm can be used to connect to your OCI compute instance by the Oracle Cloud Infrastructure Bastion Service and the Managed SSH Session feature. Prerequisites OCI Compute Instance running in a private subnet OCI Bastion plugin enabled on Compute Instance – be patient when you enable it for the first time and fulfill the requirements for the agent The VCN has a Service Gateway attached The Subnet allows network connection from the Bastion Service private endpoint IP address – See Allowing Network Access From the Bastion (oracle.com) Link: Oracle Cloud Infrastructure Documentation…
Read MoreOracle ZFSSA Storage Appliance – disabling SNMP service kills the Hybrid Comlumnar Compression functionality
In a customer project, we are running several ZS7-2 Oracle ZFS Storage Appliances ZFSSA in bundled with Private Cloud Appliances PCA. The ZFSSA is a very powerful storage solution with a lot of functionality like OISP (Oracle Intelligent Storage Protocol), or – when an ADVANCED COMPRESSION license is yours – Hybrid Columnar Compression HCC. But once in a day when I tried to create a Hybrid Columnar Compression enabled tablespace in a 19c pluggable database in our test system, I got this error: ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type SQL> CREATE BIGFILE TABLESPACE ts_data_hcc_01 2 DATAFILE SIZE 200m AUTOEXTEND ON NEXT 10m MAXSIZE 100G 3 LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT…
Read MoreOracle Database Appliance – let’s backup to the Oracle Cloud Infrastructure Object Storage
This blog post describes the setup for an Oracle Database Appliance ODA database backup by RMAN to the Oracle Cloud Infrastructure. Basically there are three destinations for backup and recovery possible: • Oracle Fast Recovery Area (FRA) disk – the Internal FRA • Network File System (NFS) location – external FRA • Oracle Cloud Infrastructure Object Storage – Oracle Object Storage When using backup to the Oracle Cloud Infrastructure Object Storage, the Oracle Database Backup Cloud Service module (opc_installer.jar) is configured in the background. A configuration can be created by the ODA browser interface or by command line tool odacli – what I prefer. When you have already worked with the Oracle Database Backup Service and the OPC module, the…
Read More