To enable Unified Auditing in Oracle Database 12 and 18 on Oracle Linux I did this:
export ORACLE_SID=ORCLCDB cd $ORACLE_HOME/bin ./sqlplus sys as sysdba SHUTDOWN IMMEDIATE EXIT ./lsnrctl stop cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk uniaud_on ioracle cd $ORACLE_HOME/bin ./lsnrctl start ./sqlplus sys as sysdba STARTUP(more…)
Clone the repository with the official Oracle docker images:
git clone https://github.com/oracle/docker-images
Install docker, download Oracle Database, put it to the directory docker-images/OracleDatabase/SingleInstance/dockerfiles/18.3.0 containing the Dockerfile and run the following commands to build and run Enterprise Edition:
cd docker-images/OracleDatabase/SingleInstance/dockerfiles/18.3.0 mv ~/Downloads/LINUX.X64_180000_db_home.zip . sudo docker build -t oracle/database:18.3.0 --build-arg DB_EDITION=EE . sudo docker run -d -it --rm --name oracle18 oracle/database:18.3.0 sudo docker logs oracle18 --tail 100 sudo docker logs oracle18 | grep -i password
and the following commands to build and run Standard Edition 2:
sudo docker build -t oracle/database-se:18.3.0 --build-arg DB_EDITION=SE2 . sudo docker run -d -it --rm --name oracle18se oracle/database-se:18.3.0 sudo docker logs oracle18se --tail 100
the first string of the docker output contains the generated password for SYS, SYSTEM and PDBADMIN.
(more…)In 2008 when I worked with some Oracle databases under Solaris and AIX, I spent some time to figure out how to make the database backup and restore and decided to use cold backup as the most straightforward method. As far as I remember, to backup the database I shutted down Oracle and then simply archive the database files using “zip” command. To restore the database I used the following shell script that extracts archived files and adjust some Oracle settings:
