Monthly Archives: November 2013

Primary and Standby out of sync issue.

Errors Observed – Thread 1 advanced to log sequence 42642 (LGWR switch) Current log# 7 seq# 42642 mem# 0: +REDO_DG01/rp27db1_ttc/onlinelog/group_7.288.823921543 Current log# 7 seq# 42642 mem# 1: +REDO_DG02/rp27db1_ttc/onlinelog/group_7.288.823921547 LNS: Standby redo logfile selected for thread 1 sequence 42642 for destination … Continue reading

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

Changing “NLS_CHARACTERSET” in Oracle

NLS_CHARACTERSET  change ======================== Spool charfix.log SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; COL VALUE NEW_VALUE CHARSET –SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER=’NLS_CHARACTERSET’; SELECT ‘AL32UTF8′ as value FROM … Continue reading

Posted in Oracle | Tagged , , | Leave a comment

Oracle DBA Interview Questions and Answers

Oracle DBA Interview Q & A There will be interview conducted for each project in TCS (both by the TCS project tech. leads and Client Side DBA Managers) which candidates will be selected based on their skill, Hereby I am … Continue reading

Posted in Oracle | Tagged | 63 Comments