DBA Blogs

#Exasol Fail-Safety explained

The Oracle Instructor - Thu, 2018-07-05 10:26

The building blocks of an Exasol cluster are commodity Intel servers like e.g. Dell PowerEdge R740 with 96 GB RAM,12 x 1.2 TB SAS Hot-plug hard-drives and 2 x 10Gb Ethernet Cards for the private network. That’s sufficient to deliver outstanding performance combined with high availability. The picture below shows a 4+1 cluster, one of our most popular configurations:

Exasol 4+1 Cluster

Exasol 4+1 Cluster: Shared Nothing Architecture

Each active node hosts one database instance that works on its part of the database (A,B,C,D) in an MPP way. The instances communicate over the private network. Optionally, the private network can be separated into one database network and one storage network. In this case, the instances communicate over the database network. Notice that the instances access their part of the database directly on their local hard drives, they do not need the private network respectively the storage network for that. The reserve node becomes relevant only if one of the active nodes fails. The local hard drives are being setup in RAID 1 pairs, so single disk failures can be tolerated without losing database availability. Not listed is the license node that is required to boot the cluster initially. After that, the license node is no longer required to keep the cluster running.

If data volumes with redundancy 2 are in use – which is the most common case – then each node holds a copy of the data operated on by a neighbor node:

 Redundancy 2

Exasol 4+1 Cluster: Redundancy 2

If a Master-Segment like A is modified, the Slave-Segment (A’) is synchronized accordingly over the private network respectively the storage network.

Availability comes with a price: The raw disk capacity is reduced by half because of the RAID 1 mirroring and again by half because of the redundancy 2, so you remain with approximately (Linux OS and database software also require a small amount of disk space) 1/4 of your raw disk capacity. But since we are running on commodity hardware – no storage servers, no SAN, no SSDs required etc. – this is actually a very competitive price.

Now what if one node fails?

 Node failure

Exasol 4+1 Cluster: Node failure

ExaClusterOS – Exasols Clusterware – will detect the node failure within seconds and shutdown all remaining database instances in order to preserve a consistent state of the database. Then it restarts them again on the still available 3 nodes and also on the Reserve node that now becomes an Active node too. The database itself becomes available again with the node n15 now immediately working with segment B’.

The downtime of the system caused by the node failure is below 30 seconds typically. The restart of the database triggers a threshold called Restore Delay which defaults to 10 Minutes. If within that time the failed node becomes available again, we will just re-synchronize the segments (A’ and B in the example) which can be done fast. The instance on n15 will then work with the segment B as a Master-Segment until the cluster is manually restarted. Then n15 becomes a reserve node again and n12 is active with an instance running there.

If the failed node doesn’t come back within Restore Delay:

 Restore Delay is over

Exasol 4+1 Cluster: Restore Delay is over

We will then create new segments on node n15: A’ is copied from n11 and B is copied from n13. This activity is time-consuming and puts a significant load on the private network, which is why configuring a dedicated storage network may be beneficial to avoid a drop in performance during that period. A new reserve node should now be added to the cluster, replacing the crashed n12.

Categories: DBA Blogs

ORA-01652 unable to extend temp

Tom Kyte - Thu, 2018-07-05 08:06
Hi Team, I went through some weird situation where I am not able to figure out the reason behind error ORA-01652 unable to extend temp. While executing a PL/SQL block at one point I am facing this issue. ORA-01652 unable to extend temp. Whi...
Categories: DBA Blogs

CentOS as the Operating System for Oracle 12.2 database server

Tom Kyte - Thu, 2018-07-05 08:06
Hello Experts, We are planning to install Oracle <b>12.2</b> database server on a Linux <b>CentOS 7.4</b>. <b>My first question</b> May I know whether this setting is supported by Oracle? I've already noted that this OS is not listed under t...
Categories: DBA Blogs

Exadata and direct path read

Tom Kyte - Thu, 2018-07-05 08:06
Hi Tom, In order for smart scan to be achieved , mainly two thing should happen : 1 - The optimizer should choose to full scan the table. 2 - Scanning the data should be done using direct path read. The first requirement is quit simple , bu...
Categories: DBA Blogs

Index Column Order – Impact On Index Branch Blocks Part II (The Weeping Song)

Richard Foote - Wed, 2018-07-04 21:25
In Part I, I discussed how the order of columns in an index makes no real difference to the effectiveness of the index if all columns are referenced via equality predicates. If the leading column has a high number of distinct columns, it might result in less necessary data within index branches as less data […]
Categories: DBA Blogs

regexp question

Tom Kyte - Wed, 2018-07-04 13:46
Hi, I am trying to highlight a search term in a result set feeding a web page. So far I can highlight the entire result, but not just the term match. The problem is in white space mismatches between the column data and the search term that is ente...
Categories: DBA Blogs

IMPLICIT CURSOR ATTRIBUTE SQL%NOTFOUND NOT WORKING

Tom Kyte - Wed, 2018-07-04 13:46
Hi Tom, I am using implicit cursor attributes SQL%NOTFOUND for the below PL/SQL block. But it raises NO_DATA_FOUND exception. It works fine for update and delete statement as they are not going to raise the NO_DATA_FOUND exception. ...
Categories: DBA Blogs

Partner Webcast – Oracle Modern Application Development for Enterprises

Today’s global marketplace dictates that every organization - from large to small and across all industries - can only remain relevant through successful digital initiatives. These initiatives...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Partner Webcast - Maximizing the value of Oracle Cloud Infrastructure (OCI)

Oracle Cloud Infrastructure is a set of cloud services that enable you to build and run a wide range of applications in a highly-available environment. With Oracle Cloud Infrastructure we’ve...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Announcement: New Europe Seminar in Brussels, Belgium 27-28 September 2018

Richard Foote - Tue, 2018-07-03 01:49
Due to popular demand, I’ll be running another of my acclaimed seminars in Europe later in the year, this time in Brussels, Belgium on 27-28 September 2018. This is a must attend seminar of benefit to not only DBAs, but also to Developers, Solution Architects and anyone else interested in designing, developing or maintaining high […]
Categories: DBA Blogs

Email Domain Extraction using sql query

Tom Kyte - Tue, 2018-07-03 01:06
if the part of email before domain matches for eg in : xyz@gmail.com xyzef@gmail.com if xyz and xyzef does not match ,then do not consider this records and if the scenario is like , if non domain part are equal like xyz@gmail.com xyz@g...
Categories: DBA Blogs

Make Index Invisible for a session

Tom Kyte - Tue, 2018-07-03 01:06
Hi With the advent of In-Memory capabilities in 12C is there a way to make the optimizer ignore indexes for particular table for a session. The reason being if we want to use Oracle 12C as HTAP (Hybrid Transactional Analytical Processing) we wou...
Categories: DBA Blogs

ORA-31011: XML parsing failed issue

Tom Kyte - Tue, 2018-07-03 01:06
While extracting data from xml parsing issue is coming. Issue is coming while extracting data for field_name 401K_LOAN_1 and 401K_LOAN_2. Please advise. <code>PROCEDURE SP1( SXML IN CLOB, p_status OUT VARCHAR2, p_message OUT VARCHAR...
Categories: DBA Blogs

XMLForest for more than one tables

Tom Kyte - Tue, 2018-07-03 01:06
hi all i'm trying to make an enquiry from 2 tables with XML function, but i have some problems: this is sql i'm using for this sample select from the 2 different tables i'm using <code>select deptno,dname from dept; select empno,ename,de...
Categories: DBA Blogs

Transpose Rows Into Column

Tom Kyte - Mon, 2018-07-02 06:46
Hi, My question is regarding transpose of rows into columns: <code>BANNER_CODE/DIV_CODE/LEG_MATNR/SAP_MATNR/MAKTX/LEG_MATKL/SAP_MATKL/LEG_WHERL/SAP_WHERL/ CS/1/10137/58351/BAKE KING CHOCOLATE RICE 160G/384/10203004/34/SG/1 GH/1/36762/212615/M...
Categories: DBA Blogs

acfs not supported in oracle linux 7 though oracle documents says its supported.

Tom Kyte - Sun, 2018-07-01 12:26
Hi tom, In a rac environment with grid infrastructure i am trying to configure acfs. But i am getting following error. ACFS-9459: ADVM/ACFS is not supported on this OS version: 'unknown' ACFS-9201: Not Supported Blogs says i need to appl...
Categories: DBA Blogs

Creating linguistic indexes for CANADIAN FRENCH

Tom Kyte - Sun, 2018-07-01 12:26
When creating a linguistic index, I am not able to specify CANADIAN FRENCH. Oracle reports that the NLS parameter string is invalid. I suspect that it's because there is a space in it, but the answer eludes me. Here is a short example of a script ...
Categories: DBA Blogs

ora_rowscn - is it always incremental,

Tom Kyte - Sun, 2018-07-01 12:26
Hello, I want to sqoop data out of my Oracle 11.2 database on a daily basis. However, I want to do only incremental extracts. Apparently, scn_to_timestamp doesn't always work due to ORA-08181: specified number is not a valid system change number...
Categories: DBA Blogs

How to get the operating system user OSUSER from Oracle

Tom Kyte - Sat, 2018-06-30 18:06
I believe there is a way to get the LAN user ID of a user from within an Oracle query. I thought the variable was called OSUSER or OS_USER. I've tried select os_user from dual, but that doesn't work. Yet I think I'm close. Can you lead me in the ...
Categories: DBA Blogs

Patching Grid Infrastructure (Oracle Restart) 12.2.0.1 on Linux

Pierre Forstmann Oracle Database blog - Sat, 2018-06-30 07:55

Oracle Corp. has released on OTN an interim patch for Grid Infrastructure 12.2.0.1 on Linux. This patch is a fix needed for Oracle RAC in docker. In this blog article I am not going to install Oracle in docker but I am only going to install this interim patch in following Oracle Restart configuration:

  • Oracle Linux 7.3
  • Oracle Grid Infrastructure (GI) 12.2.0.1
  • Oracle Database 12.2.0.1
  • Grid Infrastructure owner is the same as Oracle Database owner (oracle account).
  • I have used patch README.html instructions when possible.

    Step 1: check opatch version

    In GI environment I have run:

    $ $ORACLE_HOME/OPatch/opatch version
    OPatch Version: 12.2.0.1.6
    
    OPatch succeeded.
    

    Patch README says that OPatch 12.2.0.1.5 is needed: so this is OK.

    However patch README says also that emocmrsp is needed to create an OCM response file but there is no emocmrsp binary GI Home:

    $ ls -al $ORACLE_HOME/OPatch/ocm
    total 4
    drwxr-xr-x.  2 oracle oinstall   24 Jan 26  2017 .
    drwxr-xr-x. 12 oracle oinstall 4096 Jan 26  2017 ..
    -rw-r--r--.  1 oracle oinstall    0 Jun 15  2016 generic.zip
    $ find $ORACLE_HOME -name emocmrsp
    $
    
    Step 2: check GI Home inventory
    $ $ORACLE_HOME/OPatch/opatch lsinventory -oh $ORACLE_HOME
    Oracle Interim Patch Installer version 12.2.0.1.6
    Copyright (c) 2018, Oracle Corporation.  All rights reserved.
    
    Oracle Home       : /u01/gi12201
    Central Inventory : /u01/orainv
       from           : /u01/gi12201/oraInst.loc
    OPatch version    : 12.2.0.1.6
    OUI version       : 12.2.0.1.4
    Log file location : /u01/gi12201/cfgtoollogs/opatch/opatch2018-06-30_13-00-50PM_1.log
    
    Lsinventory Output file location : /u01/gi12201/cfgtoollogs/opatch/lsinv/lsinventory2018-06-30_13-00-50PM.txt
    
    --------------------------------------------------------------------------------
    Local Machine Information::
    Hostname: ol7ttsa0
    ARU platform id: 226
    ARU platform description:: Linux x86-64
    
    Installed Top-level Products (1): 
    
    Oracle Grid Infrastructure 12c                                       12.2.0.1.0
    There are 1 products installed in this Oracle Home.
    
    
    There are no Interim patches installed in this Oracle Home.
    
    
    --------------------------------------------------------------------------------
    
    OPatch succeeded.
    $ 
    
    Step 3: unzip patch

    I have unzipped patch zip file in /stage directory:

    $ unzip p27383741_122010_Linux-x86-64.zip 
    
    Step 4: check patch conflict

    I have sitchwed to user root (to avoid OPATCHAUTO-72046 error messages):

    # /u01/gi12201/OPatch/opatchauto apply /stage/27383741/27383741/ -analyze
    
    System initialization log file is /u01/gi12201/cfgtoollogs/opatchautodb/systemconfig2018-06-30_01-19-36PM.log.
    
    Session log file is /u01/gi12201/cfgtoollogs/opatchauto/opatchauto2018-06-30_01-19-41PM.log
    The id for this session is 76WA
    [init:init] Executing OPatchAutoBinaryAction action on home /u01/db12201
    
    Executing OPatch prereq operations to verify patch applicability on SIDB Home........
    
    [init:init] OPatchAutoBinaryAction action completed on home /u01/db12201 successfully
    [init:init] Executing SIDBPrereqAction action on home /u01/db12201
    
    Executing prereq operations before applying on SIDB Home........
    
    [init:init] SIDBPrereqAction action completed on home /u01/db12201 successfully
    [init:init] Executing OPatchAutoBinaryAction action on home /u01/gi12201
    
    Executing OPatch prereq operations to verify patch applicability on SIHA Home........
    
    [init:init] OPatchAutoBinaryAction action completed on home /u01/gi12201 successfully
    [init:init] Executing SIHAPrereqAction action on home /u01/gi12201
    
    Executing prereq operations before applying on SIHA Home........
    
    [init:init] SIHAPrereqAction action completed on home /u01/gi12201 successfully
    OPatchAuto successful.
    
    --------------------------------Summary--------------------------------
    
    Analysis for applying patches has completed successfully:
    
    Host:ol7ttsa0
    SIDB Home:/u01/db12201
    
    
    ==Following patches were SUCCESSFULLY analyzed to be applied:
    
    Patch: /stage/27383741/27383741/
    Log: /u01/db12201/cfgtoollogs/opatchauto/core/opatch/opatch2018-06-30_13-19-47PM_1.log
    
    
    Host:ol7ttsa0
    SIHA Home:/u01/gi12201
    
    
    ==Following patches were SUCCESSFULLY analyzed to be applied:
    
    Patch: /stage/27383741/27383741/
    Log: /u01/gi12201/cfgtoollogs/opatchauto/core/opatch/opatch2018-06-30_13-20-15PM_1.log
    
    
    #
    
    Step 5: apply the patch

    In the same root session I have just run (without any setting for ORACLE_HOME or GRID_HOME):

    # /u01/gi12201/OPatch/opatchauto apply /stage/27383741 
    
    System initialization log file is /u01/gi12201/cfgtoollogs/opatchautodb/systemconfig2018-06-30_01-23-52PM.log.
    
    Session log file is /u01/gi12201/cfgtoollogs/opatchauto/opatchauto2018-06-30_01-23-56PM.log
    The id for this session is 2GYB
    [init:init] Executing OPatchAutoBinaryAction action on home /u01/db12201
    
    Executing OPatch prereq operations to verify patch applicability on SIDB Home........
    
    [init:init] OPatchAutoBinaryAction action completed on home /u01/db12201 successfully
    [init:init] Executing SIDBPrereqAction action on home /u01/db12201
    
    Executing prereq operations before applying on SIDB Home........
    
    [init:init] SIDBPrereqAction action completed on home /u01/db12201 successfully
    [init:init] Executing OPatchAutoBinaryAction action on home /u01/gi12201
    
    Executing OPatch prereq operations to verify patch applicability on SIHA Home........
    
    [init:init] OPatchAutoBinaryAction action completed on home /u01/gi12201 successfully
    [init:init] Executing SIHAPrereqAction action on home /u01/gi12201
    
    Executing prereq operations before applying on SIHA Home........
    
    [init:init] SIHAPrereqAction action completed on home /u01/gi12201 successfully
    [shutdown:prepare-shutdown] Executing SIDBPrepareShutDownAction action on home /u01/db12201
    
    Preparing SIDB Home to bring down database service........
    
    [shutdown:prepare-shutdown] SIDBPrepareShutDownAction action completed on home /u01/db12201 successfully
    [shutdown:shutdown] Executing SIDBShutDownAction action on home /u01/db12201
    
    Stopping the database service on SIDB Home for patching........
    
    Following database is been stopped and will be restarted later during the session: db0
    
    [shutdown:shutdown] SIDBShutDownAction action completed on home /u01/db12201 successfully
    [shutdown:shutdown] Executing SIHAShutDownAction action on home /u01/gi12201
    
    Performing prepatch operations on SIHA Home........
    
    Prepatch operation log file location: /u01/base/crsdata/ol7ttsa0/crsconfig/hapatch_2018-06-30_01-25-18PM.log 
    
    [shutdown:shutdown] SIHAShutDownAction action completed on home /u01/gi12201 successfully
    [offline:binary-patching] Executing OPatchAutoBinaryAction action on home /u01/db12201
    
    Start applying binary patches on SIDB Home........
    
    [offline:binary-patching] OPatchAutoBinaryAction action completed on home /u01/db12201 successfully
    [offline:binary-patching] Executing OPatchAutoBinaryAction action on home /u01/gi12201
    
    Start applying binary patches on SIHA Home........
    
    [offline:binary-patching] OPatchAutoBinaryAction action completed on home /u01/gi12201 successfully
    [startup:startup] Executing SIHAStartupAction action on home /u01/gi12201
    
    Performing postpatch operations on SIHA Home........
    
    Postpatch operation log file location: /u01/base/crsdata/ol7ttsa0/crsconfig/hapatch_2018-06-30_01-27-55PM.log 
    
    [startup:startup] SIHAStartupAction action completed on home /u01/gi12201 successfully
    [startup:startup] Executing SIDBStartupAction action on home /u01/db12201
    
    Starting the database service on SIDB Home........
    
    [startup:startup] SIDBStartupAction action completed on home /u01/db12201 successfully
    [startup:finalize] Executing SIDBFinalizeStartAction action on home /u01/db12201
    
    No step execution required.........
    
    [startup:finalize] SIDBFinalizeStartAction action completed on home /u01/db12201 successfully
    [online:product-patching] Executing SIDBOnlineAction action on home /u01/db12201
    
    Trying to apply SQL patches on SIDB Home.
    
    [online:product-patching] SIDBOnlineAction action completed on home /u01/db12201 successfully
    [finalize:finalize] Executing OracleHomeLSInventoryGrepAction action on home /u01/gi12201
    
    Verifying patches applied on SIHA Home.
    
    [finalize:finalize] OracleHomeLSInventoryGrepAction action completed on home /u01/gi12201 successfully
    [finalize:finalize] Executing OracleHomeLSInventoryGrepAction action on home /u01/db12201
    
    Verifying patches applied on SIDB Home.
    
    [finalize:finalize] OracleHomeLSInventoryGrepAction action completed on home /u01/db12201 successfully
    OPatchAuto successful.
    
    --------------------------------Summary--------------------------------
    
    Patching is completed successfully. Please find the summary as follows:
    
    Host:ol7ttsa0
    SIDB Home:/u01/db12201
    Summary:
    
    ==Following patches were SUCCESSFULLY applied:
    
    Patch: /stage/27383741/27383741
    Log: /u01/db12201/cfgtoollogs/opatchauto/core/opatch/opatch2018-06-30_13-25-36PM_1.log
    
    
    Host:ol7ttsa0
    SIHA Home:/u01/gi12201
    Summary:
    
    ==Following patches were SUCCESSFULLY applied:
    
    Patch: /stage/27383741/27383741
    Log: /u01/gi12201/cfgtoollogs/opatchauto/core/opatch/opatch2018-06-30_13-26-15PM_1.log
    
    # 
    
    Step 6: check that patch has been applied

    I have checked that GI is up and running:

    $ . oraenv
    ORACLE_SID = [oracle] ? +ASM 
    The Oracle base has been set to /u01/base
    $ crsctl stat res -t
    --------------------------------------------------------------------------------
    Name           Target  State        Server                   State details       
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.DATA.dg
                   ONLINE  ONLINE       ol7ttsa0                 STABLE
    ora.LISTENER.lsnr
                   ONLINE  ONLINE       ol7ttsa0                 STABLE
    ora.RECO.dg
                   ONLINE  ONLINE       ol7ttsa0                 STABLE
    ora.asm
                   ONLINE  ONLINE       ol7ttsa0                 Started,STABLE
    ora.ons
                   OFFLINE OFFLINE      ol7ttsa0                 STABLE
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.cssd
          1        ONLINE  ONLINE       ol7ttsa0                 STABLE
    ora.db0.db
          1        ONLINE  ONLINE       ol7ttsa0                 Open,HOME=/u01/db122
                                                                 01,STABLE
    ora.diskmon
          1        OFFLINE OFFLINE                               STABLE
    ora.evmd
          1        ONLINE  ONLINE       ol7ttsa0                 STABLE
    --------------------------------------------------------------------------------
    $ 
    

    I have checked that patch has been applied to GI Home:

    $ $ORACLE_HOME/OPatch/opatch lsinventory -oh $ORACLE_HOME
    Oracle Interim Patch Installer version 12.2.0.1.6
    Copyright (c) 2018, Oracle Corporation.  All rights reserved.
    
    
    Oracle Home       : /u01/gi12201
    Central Inventory : /u01/orainv
       from           : /u01/gi12201/oraInst.loc
    OPatch version    : 12.2.0.1.6
    OUI version       : 12.2.0.1.4
    Log file location : /u01/gi12201/cfgtoollogs/opatch/opatch2018-06-30_13-30-35PM_1.log
    
    Lsinventory Output file location : /u01/gi12201/cfgtoollogs/opatch/lsinv/lsinventory2018-06-30_13-30-35PM.txt
    
    --------------------------------------------------------------------------------
    Local Machine Information::
    Hostname: ol7ttsa0
    ARU platform id: 226
    ARU platform description:: Linux x86-64
    
    Installed Top-level Products (1): 
    
    Oracle Grid Infrastructure 12c                                       12.2.0.1.0
    There are 1 products installed in this Oracle Home.
    
    
    Interim patches (1) :
    
    Patch  27383741     : applied on Sat Jun 30 13:27:43 CEST 2018
    Unique Patch ID:  21873823
    Patch description:  "OCW Interim patch for 27383741"
       Created on 18 Jan 2018, 17:32:26 hrs PST8PDT
       Bugs fixed:
         25970667, 27187009
    
    
    
    --------------------------------------------------------------------------------
    
    OPatch succeeded.
    $
    

    I have checked that patch has been applied to Database Home:

    $ . oraenv
    ORACLE_SID = [+ASM] ? DB0
    The Oracle base has been changed from /u01/base to /u01/oracle
    $ $ORACLE_HOME/OPatch/opatch lsinventory -oh $ORACLE_HOME
    Oracle Interim Patch Installer version 12.2.0.1.6
    Copyright (c) 2018, Oracle Corporation.  All rights reserved.
    
    
    Oracle Home       : /u01/db12201
    Central Inventory : /u01/orainv
       from           : /u01/db12201/oraInst.loc
    OPatch version    : 12.2.0.1.6
    OUI version       : 12.2.0.1.4
    Log file location : /u01/db12201/cfgtoollogs/opatch/opatch2018-06-30_13-30-54PM_1.log
    
    Lsinventory Output file location : /u01/db12201/cfgtoollogs/opatch/lsinv/lsinventory2018-06-30_13-30-54PM.txt
    
    --------------------------------------------------------------------------------
    Local Machine Information::
    Hostname: ol7ttsa0
    ARU platform id: 226
    ARU platform description:: Linux x86-64
    
    Installed Top-level Products (1): 
    
    Oracle Database 12c                                                  12.2.0.1.0
    There are 1 products installed in this Oracle Home.
    
    
    Interim patches (1) :
    
    Patch  27383741     : applied on Sat Jun 30 13:26:07 CEST 2018
    Unique Patch ID:  21873823
    Patch description:  "OCW Interim patch for 27383741"
       Created on 18 Jan 2018, 17:32:26 hrs PST8PDT
       Bugs fixed:
         25970667, 27187009
    
    
    
    --------------------------------------------------------------------------------
    
    OPatch succeeded.
    $ 
    

    I have checked if patch has been applied to database:

    OPS$ORACLE@DB0>set linesize 120
    OPS$ORACLE@DB0>column action_time format a15
    OPS$ORACLE@DB0>column action format a10
    OPS$ORACLE@DB0>column version format a12
    OPS$ORACLE@DB0>column description format a50
    OPS$ORACLE@DB0>column comp_name format a40
    OPS$ORACLE@DB0>select name, cdb from v$database;
    
    NAME	  CDB
    --------- ---
    DB0	  NO
    
    OPS$ORACLE@DB0>select to_char(action_time,'DD-MON-YYYY') as action_time_2, patch_id, patch_uid, action, version,  description
      2  from dba_registry_sqlpatch
      3  order by action_time;
    
    no rows selected
    
    OPS$ORACLE@DB0>
    

    This interim patch has not been applied to the database.

    I have also checked that patch is displayed in database instance alert log;

    ==========================================================
    Dumping current patch information
    ===========================================================
    Patch Id: 27383741
    Patch Description: OCW Interim patch for 27383741
    Patch Apply Time: 2018-06-30T13:26:07+02:00
    Bugs Fixed: 25970667,27187009
    ===========================================================
    

    I have also checked that patch is displayed in ASM instance alert log:

    ============================================================
    NOTE: PatchLevel of this instance 1812918032
    ============================================================
    Dumping list of patches:
    ============================================================
    27383741
    ============================================================
    

    I have also checked that GI has been stopped and restarted during patching in $ORACLE_BASE/diag/crs/ol7ttsa0/crs/trace/alert.log:

    2018-06-30 13:25:22.293 [OCSSD(3367)]CRS-1603: CSSD on node ol7ttsa0 has been shut down.
    2018-06-30 13:25:23.622 [OCSSD(3367)]CRS-1660: The CSS daemon shutdown has completed
    2018-06-30 13:25:23.622 [OCSSD(3367)]CRS-8504: Oracle Clusterware OCSSD process with operating system process ID 3367 is exiting
    2018-06-30 13:28:04.361 [CLSECHO(13356)]ACFS-9500: Location of Oracle Home is '/u01/gi12201' as determined from the internal configuration data
    2018-06-30 13:28:05.539 [CLSECHO(13702)]ACFS-9300: ADVM/ACFS distribution files found.
    2018-06-30 13:28:05.853 [CLSECHO(13726)]ACFS-9119: Driver oracleacfs.ko failed to unload.
    2018-06-30 13:28:05.930 [CLSECHO(13750)]ACFS-9427: Failed to unload ADVM/ACFS drivers. A system reboot is recommended.
    2018-06-30 13:28:06.089 [CLSCFG(13807)]CRS-1810: Node-specific configuration for node ol7ttsa0 in Oracle Local Registry was patched to patch level 1812918032.
    2018-06-30 13:28:10.327 [OHASD(13827)]CRS-8500: Oracle Clusterware OHASD process is starting with operating system process ID 13827
    2018-06-30 13:28:10.331 [OHASD(13827)]CRS-0714: Oracle Clusterware Release 12.2.0.1.0.
    2018-06-30 13:28:10.347 [OHASD(13827)]CRS-2112: The OLR service started on node ol7ttsa0.
    2018-06-30 13:28:10.364 [OHASD(13827)]CRS-1301: Oracle High Availability Service started on node ol7ttsa0.
    2018-06-30 13:28:10.634 [CSSDAGENT(13893)]CRS-8500: Oracle Clusterware CSSDAGENT process is starting with operating system process ID 13893
    2018-06-30 13:28:10.665 [ORAAGENT(13890)]CRS-8500: Oracle Clusterware ORAAGENT process is starting with operating system process ID 13890
    2018-06-30 13:28:10.780 [ORAROOTAGENT(13898)]CRS-8500: Oracle Clusterware ORAROOTAGENT process is starting with operating system process ID 13898
    2018-06-30 13:28:11.200 [ORAAGENT(13947)]CRS-8500: Oracle Clusterware ORAAGENT process is starting with operating system process ID 13947
    2018-06-30 13:28:11.360 [EVMD(13971)]CRS-8500: Oracle Clusterware EVMD process is starting with operating system process ID 13971
    2018-06-30 13:28:15.868 [CSSDAGENT(14098)]CRS-8500: Oracle Clusterware CSSDAGENT process is starting with operating system process ID 14098
    2018-06-30 13:28:15.911 [ORAROOTAGENT(14101)]CRS-8500: Oracle Clusterware ORAROOTAGENT process is starting with operating system process ID 14101
    2018-06-30 13:28:16.019 [OCSSD(14130)]CRS-8500: Oracle Clusterware OCSSD process is starting with operating system process ID 14130
    2018-06-30 13:28:17.031 [OCSSD(14130)]CRS-1713: CSSD daemon is started in hub mode
    2018-06-30 13:28:25.628 [OCSSD(14130)]CRS-1601: CSSD Reconfiguration complete. Active nodes are ol7ttsa0 .
    2018-06-30 13:28:29.146 [OCSSD(14130)]CRS-1720: Cluster Synchronization Services daemon (CSSD) is ready for operation.
    

    I have ignored ACFS-9119 and ACFS-9427 messages because I don’t use ACFS any more on this node.

    Patch 27383741 has been successfully installed in this Oracle Restart environment.

    Categories: DBA Blogs

    Pages

    Subscribe to Oracle FAQ aggregator - DBA Blogs