Oracle Database/ERP/Cloud/RAC/Misc Solutions

 In this blog, we will look at steps to install the Oracle 12cR2 Database silently on RHEL 7. 1. Create the response file under /tmp vi / tmp / 12 cR2_response . rsp Do not forget to replace ORACLE_HOSTNAME, ORACLE_HOME and ORACLE_BASE location in the below file oracle . install . responseFileVersion = / oracle / install / rspfmt_dbinstall_response_schema_v12 . 2.0 oracle . install . option = INSTALL_DB_SWONLY ORACLE_HOSTNAME = proddb UNIX_GROUP_NAME = oinstall INVENTORY_LOCATION = / u01 / app / oraInventory SELECTED_LANGUAGES = en ORACLE_HOME = / u01 / app / oracle / product / 12.2 .0 .1 ORACLE_BASE = / u01 / app / oracle oracle . install . db . InstallEdition = EE oracle . install . db . OSDBA_GROUP = dba oracle . install . db . OSOPER_GROUP = dba oracle . install . db . OSBACKUPDBA_GROUP = dba oracle . install . db . OSDGDBA_GROUP = dba oracle . install . db . OSKMDBA_GROUP = dba oracle . install . db . OSRACDBA_GROUP = dba SECURITY_UPDATES_VIA_MYORACLESUPPORT = false DECLI...

Issue Description  We faced one issue, while installing the GI 12.1.0.1.0 on Solaris 11.3  ASM failed to start. Check /u01/app/grid/cfgtoollogs/asmca/asmca-201202PM061908.log for details. 2020/12/02 18:19:17 CLSRSC-184: Configuration of ASM failed 2020/12/02 18:19:17 CLSRSC-258: Failed to configure and start ASM Died at /u01/app/12.1.0/grid_1/crs/install/crsinstall.pm line 1976. The command '/u01/app/12.1.0/grid_1/perl/bin/perl -I/u01/app/12.1.0/grid_1/perl/lib -I/u01/app/12.1.0/grid_1/crs/install /u01/app/12.1.0/grid_1/crs/install/rootcrs.pl ' execution failed This error is coming during root.sh execution on primary node. After checking the asmca logs, the error seen is as below: ========================== [main] [ 2020-12-02 17:00:49.575 AST ] [UsmcaLogger.logException:156] SEVERE:method oracle.sysman.assistants.usmca.backend.USMInstance:configureLocalASM [main] [ 2020-12-02 17:00:49.575 AST ] [UsmcaLogger.logException:157] ORA-27122: unable to protect memory [main] [ 2020-1...

Oracle 12c Grid and RAC Database Installation on Solaris 11.3 - set UDP and TCP kernel parameters /usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 9000 /usr/sbin/ndd -set /dev/tcp tcp_largest_anon_port 65500 /usr/sbin/ndd -set /dev/udp udp_smallest_anon_port 9000 /usr/sbin/ndd -set /dev/udp udp_largest_anon_port 65500 – add groups /usr/sbin/groupadd oinstall /usr/sbin/groupadd dba /usr/sbin/groupadd asmadmin /usr/sbin/groupadd asmdba /usr/sbin/groupadd asmoper – add users /usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper -d /export/home/grid -m grid /usr/sbin/useradd -g oinstall -G dba,asmdba -d /export/home/oracle12 -m oracle – change user passwords passwd oracle passwd grid – add project projadd group.oinstall projmod -sK "project.max-shm-memory=(privileged,50G,deny)" group.oinstall projmod -sK "process.max-sem-nsems=(priv,4096,deny)" group.oinstall projmod -sK "project.max-shm-ids=(priv,1024,deny)" group.oinstall projmod -sK "project.max-...

 How to Install XClock on Linux Enable snaps on Red Hat Enterprise Linux and install xclock-simosx Snaps are applications packaged with all their dependencies to run on all popular Linux distributions from a single build. They update automatically and roll back gracefully. Snaps are discoverable and installable from the  Snap Store , an app store with an audience of millions. Follow the below link for the detailed steps https://snapcraft.io/install/xclock-simosx/rhel