Archive for the ‘Uncategorized’ Category

COLLABORATE 20 Conference Converted to Digital Virtual Conferences   Leave a comment

This year’s  Oracle technology users groups COLLABORATE conference has been cancelled  due to the evolving COVID-19 situation. As a result, the conference has been converted to multiple Digital Virtual Conferences.

  • OATUG (Oracle Applications Technology Users Group) will hold OATUG Online Forum on April 20-May 1, 2020 with 200+ sessions online. Refer to OATUG  Form Online page here . For this online forum, I will present my topic “Replicating Oracle EBS Database with Snapshot for DEV/Test,” on  Tue, Apr 28, 2020 3:30 PM – 4:30 PM EDT.
  • Quest Oracle Community will hold several Quest Forum Digital Events:  Innovation Week on April 20-April 24, 2020 and Community Education Weeks on May 27-June 18. Check this link for details.
  •   The Innovation week will consists of  keynote speakers, Oracle roadmap updates, strategic insights and customer case studies . This link has more details.
  • Community Education Weeks continues a series of comprehensive virtual events for each Quest Community such as Database & Technology week on June 15-18, 2020.  I will be giving three presentations on the Database & Technology Week:
    • Leveraging Oracle Autonomous Data Warehouse for Machine Learning, June 15, 2020, 11:am-12:00pm.
    • Database Cloud: Architecture components, Deployment and Migration, June 15, 2020, 3:45:pm-4:45pm.
    • Achieving Extreme Scalability & Total Fault Isolation with Oracle Sharding 19c/20c, June 16, 2020, 11:am-12:00pm.


Posted April 19, 2020 by kyuoracleblog in Uncategorized

My Presentation Topic at Oracle OpenWorld 2019   Leave a comment

I will be speaking at Oracle OpenWorld 2019. Here are information of my session. Look forward to seeing and discussing this interesting topic with friends and colleagues in Oracle community.

Title: Achieving Massive Scalability and Total Fault Isolation with Oracle Sharding 19c.  Session Code: BUS1988

Session time and location: Tuesday, September 17, 04:15 PM – 05:00 PM | Moscone West – Room 3020A

Session abstract:

Oracle Sharding was introduced in Oracle Database 12cR2, and was further improved in Oracle database 18c and 19c for linear scalability and complete fault isolation for OLTP workloads. With Oracle Sharding, data is horizontally partitioned across discrete Oracle Databases (shards) that collectively form a single logical database. Come to this session to learn about the latest sharding improvements in Oracle Database 18c and 19c, sharding on Oracle Database Cloud, and leveraging sharding for your business. Hear about the experience of using Oracle Sharding in Dell IT’s global geo-distribution application, including what apps best fit to sharding, deployment of sharded databases with replication for massive scalability, and complete fault isolation. Lessons learned are also covered.

Session link at Oracle OpenWorld conference  catalog:

Posted August 23, 2019 by kyuoracleblog in Uncategorized

I will be speaking at Ohio Oracle Users Group Meeting   Leave a comment

I  will be invited as a guest speaker to present at the upcoming Ohio Oracle Users Groups meeting on March 24, 2017.

At the meeting I will be speaking at the following presentation sessions

10:00 – 11:00 A.M:   Oracle DBAs, let’s have a taste of Oracle Database Cloud Service
11:00 – 12:00 A.M:  Leveraging Oracle Database In-Memory to accelerate Business Analytic Applications
01:00 – 02:00 P.M:  Optimize Oracle Database Storage with Storage Tiering
02:00 – 03:00 P.M:   Oracle ASM Cluster File System for Private Cloud storage

For the details about the meeting , please refer to the Ohio Oracle Users Group link:


Posted March 21, 2017 by kyuoracleblog in Uncategorized

IOUG Oracle Database 12c R2 Expert Panel tomorrow December 6, 2016, 12:00pm – 1:00pm Central   Leave a comment

I will join three other Oracle ACE/ACE Directors Jim Czuprynski, Anuj Mohan, and  Rich Niemiec to present IOUG Oracle Database 12cR2 Expert Panel. We will share our experience of attending a week long  Oracle 12cR2 beta program on behalf of IOUG  in Oracle Lab at Oracle HQ. We  will also discuss some of the major Oracle database features introduced in Oracle 12cR2 such as those in Multitenant database, Database In-Memory, Oracle Sharding and many more. To attend this IOUG webinar, please get the registration information from this link:



Thanks IOUG for Accepting My Presentations for Collaborate 17   Leave a comment

Just received a great news from IOUG that three of my presentations were accepted for Collaborate 17.

. Session #724:  Oracle DBAs, It is time to have a first taste of Oracle Database Cloud Service

    Abstract: As an important part of Oracle Cloud offering, Oracle Database Cloud service provides an easy of use enterprise-proven highly available and scalable database service. Oracle database cloud service can be the first “going to Cloud” that you, an Oracle DBA may experience. This session helps you get the first taste of Oracle Database Cloud service. It will examine choices of of database cloud services and help you to determine which one would fit in your business requirement. It will also discuss the technical expects of each of cloud services. Through a few examples, the session will discuss the DBA tasks and how you would perform in the new database environment ranging from creating database cloud service to managing the databases.

. Session #487, Leveraging Oracle Database In-Memory to accelerate Business Analytic Applications

Abstract :By introducing In-Memory column store, Oracle Database In-Memory (DBIM) significantly improves the performance for analytic queries as well as mixed workloads.  Come to this session to learn Oracle Database In Memory under the hood:  the dual format memory architecture and configuration, how the data is populated into In-Memory column store and  it helps query performance. . This presentation also covers further enhancements of DBIM in Oracle Database 12cR2  : Join group, and In-memory expression, In Memory active Data Guard support etc.   Through some case studies of business analytics projects, this presentation covers the practices of leveraging DBIM to improve the query performance of business analytic applications and how to use  In Memory advisor to determine the objects that need to be loaded into In memory column storage . We also will present some analysis on the performance gains by using IM memory features and when and how these gains can be achieved.

. Session #437: Get ready to upgrade your Oracle databases to 12c: tools, methods and paths

Abstract: In this session we will share some of our experience on upgrading different versions of Oracle databases to the  latest Oracle 12c. Attend this session you will learn the upgrade tools and various upgrade paths that help you plan your upcoming database upgrades. This will include upgrade methods for multitenant databases.  Another focus area of this session is Oracle RAC database upgrade which includes Oracle Grid Infrastructure upgrade and Oracle RAC database upgrade. You will also learn how to use the rolling upgrade for Oracle Clusterware and ASM and Oracle RAC database to reduce the database downtime.
And it will be my great honor to join my fellow Oracle ACE Directors and Oracle ACEs  as a co-speaker for their sessions:
. Session #779: Oracle VM, OEM13c and Cloud Computing – Expert Panel by   Tariq Farooq and Charles Kim and Kai Yu
. Session #518: Oracle 12c R2 Expert Panel by Anuj Mohan, Jim Czuprynski, Kai Yu, Seth Miller
And at last , but certainly not least,  I am waiting for  IOUG Collaborate 17 conference committee to accept one of important sessions in Cloud area:  the  IOUG Cloud SIG session: Session #711 Cloud Experience-To the Cloud and Back -Hands on Workshop by Steve Lemme, Charles Kim, Try Logon, Erik Benner, Kai Yu, Seth Miller.
See you at Collaborate 17@Vegas , next April!


OOW2016 Part 2: What I presented and what I learned   Leave a comment

Working in Progress, will come up in 2-3 days

Posted October 4, 2016 by kyuoracleblog in Uncategorized

OOW2016 Part 1: Preconference Oracle ACED Product Briefing at Oracle HQ   Leave a comment

The annual Oracle technology event Oracle OpenWorld (OOW) was held on Sept 18-22 in San Francisco. As usual my trip to this conference really consists of two parts: Preconference Oracle ACE Director product briefing (my 7th product briefing )  on Sept 15-16  and OOW conference  (my 11th OOW) on Sept 18-22. I am writing these two blogs to share my experience of this 7 days conference.

The preconference Oracle ACE Director Product briefing was held at the Oracle Conference center of Oracle HQ at Redwood shores, California. The event agenda consisted of two full days of presentations by Oracle executives and product managers. The Product briefing started at 9:00am of Spet 18  with the executive presentation by Thomas Kurian , the president of Oracle product development. In his one hour presentation, Thomas Kurian gave a very broad summary of the Oracle’s IaaS/Cloud Vision, Strategy, Roadmap , which covered a good amount of new development that would be announced in the upcoming Oracle OpenWorld 2016 in a next few days. Thomas’ talk was followed by two IaaS presentations that covered Oracle latest IaaS Cloud service: 1) IaaS architecture by Mark Cavage , vice president of Engineering at Oracle ; 2) the engineering overview of IaaS implementation by Deepak Patil, Vice president, Development at Oracle. The new Oracle IaaS service has built in some high performance features such as high bandwidth (Tb/s) and low round-trip-time (< 1ms) between Oracle Cloud data centers . It uses Software Defined networks  (SDN) technologies which provides the flexibility of network in the same way as Hypervisor provides flexibility of compute. In the compute cloud service, the  IaaS offers the Bare metal based compute service, the Virtual machine based compute service as well as the Container based compute service.


(Oracle President for product development Thomas Kurian in Oracle ACED product briefing )

One of interesting presentations was given by Navin R. Thadani, Products at Ravello Systems at Oracle. Navin introduced one of new products recently acquired by Oracle: Ravello. This product helps customers by lifting the applications running on VMware from customer on-premise data center to Oracle public Cloud simply without any change. Another presentation was about Oracle  Oracle  Database 12c Release 2 Cloud First release, which was later officially announced by Larry at Oracle OpenWorld 16.

In the afternoon, I also attended a special session about Oracle Linux and virtualization update (my favor subject), presented by my good friend Honglin Su, Sr. Direct  of Product Management for Oracle Linux and Virtualization. A lot of new features about Oracle UEK kernel, and Oracle VM were presented, such as support for Ksplice , OpenStack for Oracle Linux, Docker and Oracle Cloud container Registry, in UEK R4. QU2 . Here is the photo taken after the session:


(With Oracle Linux and Virtualization : Honglin Su (Right) and his colleague (Left) and myself (middle))

On the second day, there were more Oracle cloud related presentations which covered a variety of Oracle public cloud topics: DevOps at Oracle public cloud, Big data in Oracle cloud, Oracle Golden Gate in the cloud, Oracle PaaS cloud. Oracle Management cloud service. Etc.

In summary, from this Oracle product briefing, we can see that Oracle has put so much focus on Oracle Cloud in the past year. I was expecting to give more details about Oracle Cloud from the  rest of Oracle OpenWorld conference.

Oracle ACE director product briefing not only provides us a chance to get the exposure on the Oracle latest technology development, it was also a great network opportunities for us. This is the annual event where more 70 Oracle ACE Directors  got together to discuss many their favor technologies and establish the professional network and the friendship among us. The following photo is the picture of all Oracle ACED directors who attend this preconference product briefing event at  Oracle Conference center before Oracle OpenWorld 2016.



(Oracle ACE directors at Oracle conference center)

The networking opportunity event extended to Oracle ACE and Oracle associate ACE (for more details about Oracle ACE directors, Oracle ACE and Oracle ACE associate , refer to Oracle ACE program link : ).

The following is the photo of Oracle ACE directors, Oracle ACE and Oracle ACE associate taken at San Francisco Pier 39 where Oracle ACE program hosted the annual Oracle ACE dinner for all the Oracle ACED/ACE/ACE associates who attended Oracle OpenWorld 2016.




Posted October 4, 2016 by kyuoracleblog in Uncategorized

I will be presenting at Oracle OpenWorld 2016   Leave a comment


At the upcoming Oracle OpenWorld 2016, I will be co-presenting  two sessions:

  1. Discovering Oracle Cloud [UGF5475],  Tariq, Farooq, Kai Yu, Sunday, Sep 18, 3:30 p.m. – 4:15 p.m. | Moscone West – 2009                                                                                               

This vibrant session explores how your company could make the best use of all Oracle Cloud options available, including backup in the cloud, and what benefits it can bring to your organization. Discover how Oracle Cloud works, looks, and feels in only 45 minutes , the link to download the presentation of this session:  

    2. Leveraging Oracle Database 12c Release 2 Multitenant Features [CON3075], Thursday, Sep 22, 12:00 p.m. – 12:45 p.m. | Park Central – Metropolitan I

Oracle Database 12c Release 2 offers so many new multitenancy features that only a panel of Oracle ACEs can do them justice. In this session Oracle ACEs Jim Czuprynski, Andy Colvin, Kai Yu, Anuj Mohan, and Deiby Gomez provide their experiences with the latest multitenancy features in Oracle Database 12c Release 2. Hear about client implementations as well as extensive beta testing and see how any Oracle DBA can take immediate advantage of these new capabilities. All source code and practical examples will be available immediately after the presentation.
The link to download the presentation of this session:
Refer to Oracle Openworld session catalog: ( yu&search.event=oracleopenworld)

Proud of be a Part of Dell Technologies   Leave a comment


Posted September 7, 2016 by kyuoracleblog in Uncategorized

Troubleshooting case study : Oracle RAC database is open but not accessible through listener due to some old unused diskgroup being removed   Leave a comment

The Issue:

I would like to use this blog to show how a recent database issue was resolved. The issue started when the application was not able to connect the database . Here is the part of log from the Oracle OBIEE application:

<Mar 29, 2016 11:48:58 AM CDT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool “raframework_datasource”: Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

The Troubleshooting steps

 1) Test the sqlnet and it didn’t show any error message:

[oracle@inmem2 admin]$ tnsping POCDB

TNS Ping Utility for Linux: Version – Production on 26-MAR-2016 20:22 :18

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = inmem-sc an)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pocdb.dbase.lab)))

OK (0 msec)

2) Test the database connectivity and showed the failed connection to the database:

[oracle@inmem2 admin]$ sqlplus biuser/<password>@pocdb

SQL*Plus: Release Production on Sat Mar 26 20:22:23 2016

Copyright (c) 1982, 2014, Oracle. All rights reserved.


ORA-12514: TNS:listener does not currently know of service requested in connect


3) check listener and it looks fine

[oracle@inmem1 ~]$ lsnrctl status

LSNRCTL for Linux: Version – Production on 26-MAR-2016 20:39:13

Services Summary…

Service “+ASM” has 1 instance(s).

Instance “+ASM1”, status READY, has 1 handler(s) for this service…

Service “pocdb.dbase.lab” has 1 instance(s).

Instance “pocdb1”, status READY, has 1 handler(s) for this service…

Service “pocdbXDB.dbase.lab” has 1 instance(s).

Instance “pocdb1”, status READY, has 1 handler(s) for this service…

The command completed successful

4) Check the database sysdba login:

Database is up:

[oracle@inmem1 ~]$ sqlplus

SQL*Plus: Release Production on Tue Mar 29 09:41:28 2016

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Enter user-name: / as sysdba

Connected to:

Oracle Database 12c Enterprise Edition Release – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing option

5) However check the database status from srvctl and found that the database was marked down on both nodes:

[oracle@inmem2 admin]$ srvctl status database -d pocdb

Instance pocdb1 is not running on node inmem1

Instance pocdb2 is not running on node inmem2

Tried to bring it up and failed as it failed to bring up resource ‘ora.DATA.dg’

[oracle@inmem1 ~]$ srvctl start database -d pocdb

PRCR-1079 : Failed to start resource ora.pocdb.db

CRS-2674: Start of ‘ora.DATA.dg’ on ‘inmem2’ failed

CRS-2632: There are no more servers to try to place resource ‘ora.pocdb.db’ on that would satisfy its placement policy

CRS-2674: Start of ‘ora.DATA.dg’ on ‘inmem1’ failed

6)  Check the CRS resource status and found that ora.DATA.dg and ora.pocdb.db were offline:

[grid@inmem1 ~]$ crs_stat











Check the dependencies of ora.pocdb.db

7) Check the resource dependency. It shows the database pocdb has dependency on ora.DATa.dg for this startup process.

[grid@inmem1 ~]$ crsctl status resource ora.pocdb.db -f




START_DEPENDENCIES=hard(ora.DATA.dg, ora.SAN_DATA2.dg) pullup(ora.DATA.dg, ora.SAN_DATA2.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns)

It shows the POCDB has dependency on DATA diskgroup, but DATA diskgroup is no longer available in ASM instance:

SQL> select NAME, STATE  from v$asm_diskgroup;









6 rows selected.

So we need to remove the this dependency


The key is to remove this dependency so that we can restart the database through srvctl and make sure that the status of the database resource ora.pocdb.db is shown as ONLINE

1) Reregister pocdb in as a CRS resource

Remove the database first:

[oracle@inmem1 ~]$  srvctl remove database -d pocdb

Remove the database pocdb? (y/[n]) y

Then add the database back:

[oracle@inmem1 ~]$ srvctl add database -d pocdb -o /u01/app/oracle/product/12.1.0/dbhome_1

[oracle@inmem1 ~]$  srvctl add  instance -d pocdb -i pocdb1 -n inmem1

[oracle@inmem1 ~]$ srvctl add  instance -d pocdb -i pocdb2 -n inmem

2) Check the dependency status:

[grid@inmem1 ~]$ crsctl status resource ora.pocdb.db -f





3) Startup the database :

[oracle@inmem1 ~]$ srvctl start database -d pocdb

Check the database status

[oracle@inmem1 ~]$ srvctl status database -d pocdb

Instance pocdb1 is running on node inmem1

Instance pocdb2 is running on node inmem2

Test the database connectivity

[oracle@inmem1 ~]$ sqlplus biuser/password@pocdb

SQL*Plus: Release Production on Tue Mar 29 11:51:39 2016

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

The Oracle BI application is no longer having connectivity issue.

Posted March 29, 2016 by kyuoracleblog in Uncategorized