Enable Non-Oracle User Run SQL*Plus
Let's see how we enable an user other than the owner of Oracle product to run SQL*Plus. Windows In Windows platform, once oracle database has… Read More »Enable Non-Oracle User Run SQL*Plus
Solaris
Installation Guide on Solaris for All Releases of Oracle Database
In this post, we collect installation guides on Solaris for all database releases. You may bookmark this page by pressing Ctrl + d. There're 2… Read More »Installation Guide on Solaris for All Releases of Oracle Database
Where is oraInst.loc Location
oraInst.loc oraInst.loc stores Oracle product inventory path and installation group. For different OS, the location of oraInst.loc could vary. Here is the list to show… Read More »Where is oraInst.loc Location
How to Resolve ORA-27125: unable to create shared memory segment
ORA-27125 We found error ORA-27125 when we create the second database by Database Configuration Assistant (DBCA). ORA-27125 means that oracle has been bound to the… Read More »How to Resolve ORA-27125: unable to create shared memory segment
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 on Solaris. Upload Patches Update Opatch utility Backup Oracle Home… 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 (19.3) as below. OS Configuration Installation Please note that, if you want your database server… 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
Check if Directory Exists by Shell Script
Test Command In some situations, we may need to detect the existence of a directory in shell or scripts. If so, there's a quick way… Read More »Check if Directory Exists by Shell Script