Category Archives: Configuration

TFA – Oracle Trace File Analyser Installation

Uninstall TFA 1) Check TFA_HOME. $ grep TFA_HOME= /etc/init.d/init.tfa TFA_HOME=/u01/app/12.2.0.1/grid/tfa/racnode1/tfa_home 2) Uninstall TFA as root user. [root@racnode1 bin]# ./tfactl -h Usage : /u01/app/12.2.0.1/grid/bin/tfactl <command> [options] commands:diagcollect|collection|analyze|ips|run|start|stop|enable|disable|status|print|access|purge|directory|host|receiver|set|toolstatus|uninstall|diagnosetfa For detailed help on each command use: /u01/app/12.2.0.1/grid/bin/tfactl <command> -help [root@racnode1 bin]# /u01/app/12.2.0.1/grid/bin/tfactl uninstall … Continue reading

Posted in 12c new features, Configuration | Tagged , | Leave a comment

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 , , , , , , , | 2 Comments

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