Author Archives: james huang

CRS-2412: The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time

In crs alert.log, below message is shown every 30 minutes in 12.2.0.1 GI. [OCTSSD(9932)]CRS-2412: The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time ctss is running in observer mode, because NTP … Continue reading

Posted in GI and RAC | Tagged , , , , | Leave a comment

Use emcli Command To Get Target Detailed Information

1) emcli login: $ emcli login -username=’sysman’ Enter password : Login successful 2) To get all targets: $ emcli get_targets 3) To get all the RAC databases only: $ emcli get_targets -target=’rac_database’ 4) To list rac database TESTDB details: $emcli … Continue reading

Posted in OEM12c, OEM13c | Tagged , , , , | Leave a comment

How to Apply April 2018 RU Patches

Here is the GI environment to be patched: GI HOME: 12.2.0.1 DB HOMES: 12.2.0.1 12.1.0.2 11.2.0.4 Patches downloaded : GI HOME: 12.2.0.1 : Combo OJVM Update 12.2.0.1.180417 and GI Update 12.2.0.1.180417 Patch 27726454, or – 27468969/ 27674384 DATABASE APR 2018 … Continue reading

Posted in GI and RAC, Upgrading and Patching | Tagged , , , , , , , | Leave a comment

RAC Database Hanging with “gc buffer busy acquire” and “gc buffer busy request” Wait Events

There is a RAC database hanging for a short period of time with high “gc buffer busy acquire” and “gc buffer busy request” wait events by sql id =”4vs91dcv7u1p6″: insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, … Continue reading

Posted in GI and RAC, Performance Tunning | Tagged , , , , , , , | Leave a comment

How to Create SQL Plan Baseline from Cursor Cache

Here is an example of how to create SQL plan baseline on a  12.1 Oracle database. 1)Get all the details of the sql: SQL> select SQL_ID,HASH_VALUE,CHILD_NUMBER,PLAN_HASH_VALUE, EXECUTIONS,ELAPSED_TIME/EXECUTIONS/1000000 Sec_per_exec from v$sql where sql_id=’gjpdb42w841yt’ order by ELAPSED_TIME/EXECUTIONS/1000000; SQL_ID HASH_VALUE CHILD_NUMBER PLAN_HASH_VALUE EXECUTIONS … Continue reading

Posted in Performance Tunning, SQL Scripts For DBA | Tagged , , , , , , , , , , | Leave a comment

SQL Script to Format Library Cache Lock/pin wait event p3 value

http://www.anbob.com/archives/2725.html Thanks  author: anbob.com(weejar@gmail.com) CREATE OR REPLACE PROCEDURE lbc_p3(P3 number) is — purpose: format p3 value (maybe p3 value large than 100,000,000) — author: anbob.com(weejar@gmail.com) — date: 2016-5-1 — note: 11.2 tested v_hex varchar2(50); v_hexoid varchar2(50); v_oid number; v_namespace number; … Continue reading

Posted in SQL Scripts For DBA | Tagged , | Leave a comment

To Get Object Name and Type From File# and Block#

Given file id and block id, the object details can be queried by below SQL query:   SQL>select OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME from dba_extents where FILE_ID=1 and 68619 BETWEEN block_id AND ( block_id + blocks); OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME ——– ————— ————– —————————- … Continue reading

Posted in SQL Scripts For DBA | Tagged , , , , | Leave a comment

ORA-04021: timeout occurred while waiting to lock object

Application job failed with below trace file contents: *** 2018-06-16 11:03:17.044 *** SESSION ID:(2437.25769) 2018-06-16 11:03:17.044 *** CLIENT ID:() 2018-06-16 11:03:17.044 *** SERVICE NAME:(BATCH) 2018-06-16 11:03:17.044 *** MODULE NAME:(DBMS_SCHEDULER) 2018-06-16 11:03:17.044 *** ACTION NAME:(IMMEDIATE16_06_2018_10_10_01) 2018-06-16 11:03:17.044 ORA-12012: error on auto … Continue reading

Posted in AWR, dbms_scheduler, ORA- ERRORS | Tagged , , , , , | Leave a comment

ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 28: No space left on device

When try to start up an Oracle database, the below errors occur: ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 28: No space left on device Additional information: 3773 Additional information: 3221225472 CAUSE Kernel parameter kernel.shmall is not set properly. … Continue reading

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

How to Relink Oracle 12CR2 Grid Infrastrure ( GI ) Binary

1)Change ownership of some root owned files like extjobO and jssuO, etc, because the relink script will be run as “grid’ user to change the file permissions. Otherwise, the relink will fail from the below commands in scripts: … .. . chmod … Continue reading

Posted in GI and RAC | Tagged , , , , | Leave a comment