April 13, 2025

Gospel

Revelation 20

11 Then I saw a great white throne and him who was seated on it. The earth and the heavens fled from his presence, and there was no place for them. 12 And I saw the dead, great and small, standing before the throne, and books were opened. Another book was opened, which is the book of life. The dead were judged according to what they had done as recorded in the books. 13 The sea gave up the dead that were in it, and death and Hades gave up the dead that were in them, and each person was judged according to what they had done. 14 Then death and Hades were thrown into the lake of fire. The lake of fire is the second death. 15 Anyone whose name was not found written in the book of life was thrown into the lake of fire.

March 28, 2025

19c DBcreate

How to create a 19c database using scripts

ref scripts in github

# make sure you are logged in as oracle
# make sure your db environment is set, ORACLE_HOME, ORACLE_SID and all that

# this is the main directory where all the scripts should live, copy them here
cd /u01/app/oracle/admin/orcl/scripts

# create directories
bash create_dirs.sh

# create the database
sqlplus / as sysdba <<EOD
create spfile from pfile='/u01/app/oracle/admin/orcl/scripts/init.ora';
startup nomount
@crdb1.sql <sys_password>
EOD

# run catalog
bash catalog.sh <sys_password>

# install text
bash text.sh <sys_password>

# install cluster views
bash cluster_views.sh <sys_password>

# lock accounts via sqlplus
sqlplus / as sysdba
@lock_accounts
@show_accounts

# run datapatch
cd $ORACLE_HOME/OPatch
./datapatch -verbose

# compile invalids
bash utlrp.sh <sys_password>

# check the registry and patches
sqlplus / as sysdba
@dba_registry
@sqlpatch

# create a PDB
sqlplus / as sysdba
create pluggable database pdb1 admin user pdbadmin identified by "<password>";
alter pluggable database pdb1 open;

March 27, 2025

19c Install

How to install Oracle Database 19c on your new OL9 VM

We assume you have a new OL9 VM setup with all the 19c prereqs, and a 100GB /u01 ref scripts in github

create the directory structures

sudo mkdir -p /u01/app/oracle/product/19.0.0.0
sudo mkdir -p /u01/app/oracle/stage/ru
sudo chown -R oracle:oinstall /u01

copy the zips to /u01

scp LINUX.X64_193000_db_home.zip oracle@ol9:/u01/app/oracle/stage
scp p37260974_190000_Linux-x86-64.zip oracle@ol9:/u01/app/oracle/stage
scp p6880880_122010_Linux-x86-64.zip oracle@ol9:/u01/app/oracle/stage

unzip them as oracle

unzip -q LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.0.0.0
unzip -q p37260974_190000_Linux-x86-64.zip -d ru/
rm -rf /u01/app/oracle/product/19.0.0.0/OPatch
unzip -q p6880880_122010_Linux-x86-64.zip -d /u01/app/oracle/product/19.0.0.0

run the installer

bash install_oracle.sh

run the root scripts

sudo /u01/app/oracle/product/19.0.0.0/root.sh
sudo /u01/app/oraInventory/orainstRoot.sh