How Oracle Check User Default Role
User Default Role Making roles default to a user has some advantages, it automatically enables all privileges in the default roles when the user logs… Read More »How Oracle Check User Default Role
How to Resolve rtld: 0712-001 Symbol was referenced
Could not load program sqlplus After restoring the operating system of an Oracle database server from tape, we saw something wrong. [oracle@test oracle]$ sqlplus /… Read More »How to Resolve rtld: 0712-001 Symbol was referenced
How to Check DB Status by Script
To check if a databae is alive or not, we already have a way to do it. However, such script can't tell NOMOUNT, MOUNT or… Read More »How to Check DB Status by Script
How to Check if Oracle Database is Alive or Not
To make sure that an Oracle database is alive, we can use a piece of shell script to check it. [oracle@test ~]$ vi check_database_alive.sh #!/bin/bash… Read More »How to Check if Oracle Database is Alive or Not
How to Patch Oracle Database 19c on Solaris (DBRU 19.17)
Here are steps to apply Database Release Update (DBRU) 19.17 (p34419443) on Oracle database 19.3. Upload Patches Update Opatch utility Backup Oracle Home Apply Release… Read More »How to Patch Oracle Database 19c on Solaris (DBRU 19.17)
How to Install Oracle Database 19c on Solaris
There're 2 phases of the installation of Oracle database 19c. OS Configuration Installation OS Configuration Check Operating System Groups, Users and Resources Check Operating System… Read More »How to Install Oracle Database 19c on Solaris
How to Resolve PRVF-7573 : Sufficient swap size is not available on node
PRVF-7573 or PRVF-07573 Saw an error PRVF-7573 when Oracle Universal Installer (OUI) 19c perform a prerequisite check. PRVF-7573 : Sufficient swap size is not available… Read More »How to Resolve PRVF-7573 : Sufficient swap size is not available on node
How to Resolve PRVF-7566 : User "oracle" does not belong to group "oper" on node
PRVF-7566 or PRVF-07566 Saw an error PRVF-7566 when Oracle Universal Installer (OUI) 19c perform a prerequisite check. PRVF-7566 : User "oracle" does not belong to… Read More »How to Resolve PRVF-7566 : User "oracle" does not belong to group "oper" on node
How to Install oracle-database-preinstall-19c Group Package
oracle-database-preinstall-19c The fastest way to fulfill the package requirement for Oralce database 19c installation prerequisites on Solaris 11 is to install a group package called… Read More »How to Install oracle-database-preinstall-19c Group Package
How to Resolve PRCC-1017 : LISTENER was already stopped on Node
PRCC-1017 Saw error PRCC-1017 when we tried to stop a listener service at specific node. [grid@primary01 ~]$ srvctl stop listener -n primary01 PRCC-1017 : LISTENER… Read More »How to Resolve PRCC-1017 : LISTENER was already stopped on Node