Category Archives: Configuration

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

Opatch Throws error : java.text.ParseException: Unparseable date: “2016.Aug.09 08:27:15 AEST

SYMPTOMS For 12.1.0.2 GI Home,  opatch  12.2.0.1.5 and later versions  throw below errors : $ opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.5 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/12.1.0.2/grid Central Inventory : /u01/app/oraInventory from … Continue reading

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

How to Switch the Logfile of All the Threads in RAC environment

A. Switch the logfile of current instance only. SQL> alter system switch logfile; System altered. B. Switch the logfile of all the threads in RAC environment. SQL> alter system archive log current; System altered. C. Switch the logfile of all the … Continue reading

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

ERROR: Unable to get logical block size for spfile ‘+DATA1/RACTEST/spfileRACTEST.ora’

Created 12.1.0.2 CDB/PDB database through DBCA, there are a lot of below errors in alert.log. Mon Oct 24 23:33:11 2016 ERROR: Unable to get logical block size for spfile ‘+DATA1/RACTEST/spfileRACTEST.ora’. Mon Oct 24 23:33:11 2016 ERROR: Unable to get logical … Continue reading

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

Change ASM User SYS ASMSNMP Password in 12c

To see where the password file is located : $ asmcmd ASMCMD> pwget –asm +OCR_VOTE/orapwASM ASMCMD> cd +OCR_VOTE ASMCMD> ls -l orapwASM Type Redund Striped Time Sys Name PASSWORD UNPROT COARSE AUG 08 17:00:00 N orapwASM => +OCR_VOTE/ASM/PASSWORD/pwdasm.256.919359249 ASMCMD> cd … Continue reading

Posted in 12c new features, Configuration, GI and RAC, User Privileges and Roles | Tagged , , , | Leave a comment

Add Another Control file into ASM

Playing around to add another control file into ‘+DATA2’ disk group. Check current control files SQL> select name from v$controlfile; NAME ——————————————————————————– +DATA2/ractest/controlfile/current.523.925063153 +FRA/ractest/controlfile/current.1395.925063153 SQL> show parameter control_file NAME TYPE VALUE ———————————— ———– —————————— control_file_record_keep_time integer 7 control_files string +DATA2/ractest/controlfile/current.523.925063153, … Continue reading

Posted in Configuration, RMAN Restore and Recovery | Tagged , , , | Leave a comment