On a Single Instance Standalone Database, If you want to stop/start everything that runs on a ORACLE_HOME, you can run this: But why sometimes it does nothing? Well.. .this is where the magic of N or Y at the end of the line in /etc/oratab. Just change to Y and process will stop/start DB and... » read more
On this article we are going to do a silent install of Oracle Enterprise Manager Clod Control 24ai on a Oracle Linux 8 server.First we need an oracle DB where the repository will run. You can use a non-cdb, but since starting from 26ai, CBD/PDB is a must, we are going to use a 19c... » read more
From Oracle database 23ai/26ai, flashback logs can be stored outside the fast recovery area. This allows us to place flashback database logs on different storage, and means they are not competing for space with the rest of the contents of the fast recovery area. First we need a directory to place logs: Set destination and... » read more
We had someone complaining saying why v$flash_recovery_area_usage is empty when DB is in archive log mode? Should not list everything there? This has been replicated on 26ai, but it is valid on previous releases. Answer is simple, log_archive_dest_1 is not set properly, lets replicate on a test db…. Initially ok, right? well….. Since this is... » read more
On this activity we are going to create a DB in silent mode on a single server with ASM (GRID). That’s it! For a list of 26ai articles, go to HERE Post Views: 165
On this activity we are going to install the sample schemas on a 26ai DBFirst we need to download file from here: https://docs.oracle.com/en/database/oracle/oracle-database/26/comsc/installing-sample-schemas.html unzip and go to directory you want to install: Connect to the PDB and run the install (it will ask for HR password): That’s it! For a list of 26ai articles, go... » read more
On this activity we are going to install Oracle 26ai on premises (on a virtualbox server) Create direcories and unzip software We are going to use this response file: Run Install: ROOT SCRIPT: Check logs for errors and done! On every new install, I like to add en “dummy” entry on /etc/oratab for an easy... » read more
List of all the articles I created for Oracle 23ai/26ai. Post Views: 184
After a very, very long wait, finally onpremises has been released.As a starting point, we are on a Oracle Linux 8.10 (x86_64) server on kernel 5.15.0-316.196*, with at least 16G of swap. Lets install few bits and reboot: Make sure oinstall has assigned oracle in /etc/group file. This might not give you any issues on... » read more
On this activity we are going to rename the scan name on a Oracle 19c RAC environment.We don’t want to change the IP’s, just the name. ORIGINAL NAME: CLUSTER-ORA-SCAN2 TARGET NAME: CLUSTER-ORA2-SCAN First, you need to make sure new SCAN NAME is pingable from all RAC servers (to avoid name resolution issues) 1:- Check current... » read more