Category Archives: Configuration

Reconfigure OS Parameters After Linux Server Memory Upgrade

One of the Oracle database server ‘s memory is to be upgraded from 48GB to 72GB, so some parameters should be adjusted to take advantage of the newly added memory. 1)  Change ‘memlock’ parameter in /etc/security/limits.conf to 70G, which is … Continue reading

Posted in Configuration, Linux | Tagged , , , , , , , , | Leave a comment

How to Configure SHMMAX SHMMNI SHMALL ?

Every DBA is so familiar with those three kernel parameters in Linux — SHMMAX, SHMMNI and SHMALL. Most of the time, the default values are used by majority clients. But sometime, those three parameters need to be reconfigured to reflect the … Continue reading

Posted in Configuration, Linux | Tagged , , , , , , , , , , , , | Leave a comment

ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates

Below errors occurred while starting up a 12.2.0.1 Oracle database instance. SQL> startup ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates … Continue reading

Posted in Configuration, ORA- ERRORS | Tagged , , , , , , , , , , , , , , | Leave a comment

How to Copy ASM Password File From Primary to Standby in 12cR1

12.1.0.2 primary database password file is stored in ASM, so it needs to be manually copied onto standby database ASM for dataguard configuration. Otherwise the below errors will occur: *** 2017-09-06 14:34:29.216 OCISessionBegin failed. Error -1 .. Detailed OCI error … Continue reading

Posted in 12c new features, ASM, Configuration, DataGuard, GI and RAC | Tagged , , , , , , , | Leave a comment

How to Disable SELinux or Set SELinux to Permissive Mode

It is suggested to disable SELinux or set SELinux to permissive mode for Oracle GI/RAC. Otherwise you might get similar below errors: Disk “ASM_DISK1” does not exist or is not instantiated Writing disk header: done Instantiating disk: oracleasm-instantiate-disk: Unable to … Continue reading

Posted in ASM, Configuration, Linux, Security | Tagged , , , , , , , , , , , | Leave a comment

ORA-02065: illegal option for ALTER SYSTEM

In an old 10g database, when tried to change SGA_TARGET parameter in spfile, “ORA-02065: illegal option for ALTER SYSTEM” occurred. $ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 – Production on Tue Jun 13 15:56:37 2017 Copyright (c) 1982, 2010, … Continue reading

Posted in Configuration, GI and RAC, ORA- ERRORS | Tagged , | Leave a comment

Oracle Database Time Zone

1) dbtimezone only shows the database creation time TZ offset from OS environment. For AEST, it could be either of the below depending on OS environment variable: 00:00 +10:00 ( non DST ) +11:00 ( DST ) SQL> select dbtimezone … Continue reading

Posted in Configuration, Globalization | Tagged , , , , , , , , , , , , | Leave a comment

ORA-01105: mount is incompatible with mounts by other instances ORA-19808: recovery destination parameter mismatch

When tries to start up one instance of the RAC , got below errors. ….. …. ORA-01105: mount is incompatible with mounts by other instances ORA-19808: recovery destination parameter mismatch … Check flash recovery parameters on other node: SQL> show … Continue reading

Posted in Configuration, GI and RAC, ORA- ERRORS | Tagged , , , , , | Leave a comment

“ORA-12505, TNS:listener does not currently know of SID given in connect descriptor” from ORMB ouafDatabasePatch

SYMPTOMS When  installing Rollup Pack for Oracle Utilities Application Framework Version 4.3.0.1.0, ran ouafDatabasePatch.cmd command , and got the below errors: D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\FW-V4.3.0.1.0-Rollup\Database>set TOOLSBIN=D:\dbpatch_tools\bin D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\FW-V4.3.0.1.0-Rollup\Database>set JAVA_HOME=D:\java D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\FW-V4.3.0.1.0-Rollup\Database>ouafDatabasePatch.cmd “CMDLINE::: D:\java\bin\java.exe -cp D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\dbpatch_tools\lib\*;D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\dbpatch_tools\config com.oracle.ouaf.database.patch.OUAFPatch” Enter the target database type (O/M/D) [O]: O Enter the … Continue reading

Posted in Client, Configuration, ORA- ERRORS, ORMB | Tagged , , , , , , | 1 Comment

INS-20802 Oracle Net Configuration Assistant Failed When Install 12c 32bit Oracle Client on Windows Server 2012 R2

SYMPTOMS When installing Oracle 12.1.0.2 32bit client onto Windows Server 2012R2, the below error occurred. SOLUTION 1) Click “..\winnt_12102_client32.zip\client32\stage\ext\bin\vcredist_x86.exe” and install “Microsoft Visual C++ 20xx Redistributable Package (x86)”. Then click “Retry again” to complete the installation successfully. 2) Before installation, … Continue reading

Posted in Client, Configuration | Tagged , , , , , , , | 8 Comments