Search This Blog

Thursday 25 April 2024

Oracle 19c - patch 19.22 unavailability for Windows platform

 Oracle 19c - patch 19.22 unavailability for Windows platform 


Having upgraded the Oracle 11g 11.2.0.4 database to Oracle 19c 19.3.0.0.0 while applying the latest patch 19.22 discovered that 19.22 patch is still not released for the Windows platform, raised a SR with Oracle support and they confirmed that 19.22 patch for Windows platform is yet to be released, and they have requested the internal development team to release the 19.22 patch for Windows platform, hope it helps for the shops which are trying to do the latest set of patches 19.22 for their databases on Windows platform. 

Oracle 11g 11.2.0.4 upgrade to Oracle 19c failing with error ora-01034 - glogin.sql

 Oracle 11g 11.2.0.4  upgrade to Oracle 19c 19.3.0.0.0  failing with error ORA-01034


Solution:

glogin.sql file is causing something that upgrade would fail with error ORA-01034, the simple solution is to rename the glogin.sql file and re-run the upgrade process and it will catch up from the point it failed, hope it helps.



Tuesday 20 September 2022

 Oracle Weblogic 12.2.1.3.0

60820: Select a domain which is a compatible with this environment.


stopComponent.sh and startComponent.sh gives the following errors

Welcome to WebLogic Server Administration Scripting Shell


Type help() for help on available commands


Reading domain from /<PATH>/user_projects/domains/IDMDomain

Error: runCmd() failed. Do dumpStack() to see details.

Error: Error reading domain:

60820: Unsupported Domain

60820: This domain is a managed domain. It has been scaled out from the original domain.

60820: Select a domain which is a compatible with this environment.


Exiting WebLogic Scripting Tool.


Solution: 
Oracle Doc 2380467.1

This condition is a result of Bug 25964279 (internal / not published in MOS).  Due to Bug 25964279, the startComponent.sh and stopComponent.sh scripts can only successfully complete from the first node in an OID 12c collocated cluster.

 

Execute the startComponent.sh and stopComponent.sh scripts only from the first server node in the collocated cluster.

Alternately an OID instance may be started from a WLST session with one of the following commands :

WLST connected to the AdminServer:
start('<COMPONENT_NAME>')

WLST connected to the target NodeManager:
nmStart(serverName='<COMPONENT_NAME>',serverType='OID')


Replace '<COMPONENT_NAME>' with the OID component name, e.g. 'oid1' or 'oid2'


 Oracle FMW 12.2.1.3.0 Error: Error reading domain: 60820: Unsupported Domain

60820: This domain is a managed domain. It has been scaled out from the original domain.


Starting system Component ohs01 ...


Initializing WebLogic Scripting Tool (WLST) ...


Welcome to WebLogic Server Administration Scripting Shell


Type help() for help on available commands


Reading domain from /u01/oracle/product/fmw/wl_home/user_projects/domains/wl_domain

Error: runCmd() failed. Do dumpStack() to see details.

Error: Error reading domain:

60820: Unsupported Domain

60820: This domain is a managed domain. It has been scaled out from the original domain.

60820: Select a domain which is a compatible with this environment.

Exiting WebLogic Scripting Tool.

Done


Cause:

Oracle Support Document: 2723339.1

The issue was happening because the pack command is being run using -managed=true option on a domain that's already created using unpack command, as following:

     a. Host 1 has a WebLogic domain with Admin and a managed server - Execute pack command with -managed=true option.

     b. Host 2 - Execute unpack command.

     c. Host 2 - Execute pack command with -managed=true option.

     d. Host 3 - Execute unpack command and it will fail with 60820: This domain is a managed domain. It has been scaled out from the original domain

 Solution:

Do not extend a domain which is already created using unpack after it's pack was run using -managed=true option.

In order to extend a domain pack should be executed on the host where the domain was created originally using the config wizard or unpack was executed on a host after it's pack was run using -managed=false option



Sunday 7 August 2022

ASM instance warning message in alert log file

“Warning: VKTM detected a time drift”


  Solution

Usually VKTM and VKRM issues come together, at least when you are using the resource manager. 

The VTKM is the Virtual Keeper of Time Process. The VKTM acts as a time publisher for an Oracle instance.  VKTM publishes two sets of time: a wall clock time using a seconds interval and a higher resolution time (which is not wall clock time) for interval measurements.  

The VKTM process is a process that is available in ASM instances and RDBMS instances. So if you see issues with VKTM process, it usually pops up on both. VKTM usage is affected mainly by two hidden parameters _timer_precision and _disable_highres_ticks. So, tuning these parameters can bring down VKTM CPU consumption.

The VKRM process is the Virtual Scheduler for Resource Manager Process, and it serves as centralized scheduler for Resource Manager activity. As there is no resource manager on a ASM instance, you will see this process only on RDBMS instances.


For version 11.2.0.1, Apply patch for Bug 9843304.  This Bug is already fixed in 11.2.0.2

For 11.2.0.2 and 11.2.0.3, apply patch for Bug 11837095, This Bug is already fixed in 11.2.0.4

If patch is not available then please raise SR with Oracle Support.


Add the following even in spfile or pfile.

event="10795 trace name context forever, level 2"



Thursday 4 August 2022

Oracle Grid Infrastructure CRS status showing offline


Oracle GI CRS status is showing offline in Red Hat Linux, and because CRS is not up and running, it won't allow ASM instance to start.


check the status of the GI resource


login with "grid" os user and run the following command


[root@oracle12cdb1 bin]# ./crsctl status res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.CRS.dg

               OFFLINE  OFFLINE       oracle12cdb1             STABLE

ora.DATA.dg

               OFFLINE  OFFLINE       oracle12cdb1             STABLE

ora.FRS.dg

               OFFLINE  OFFLINE       oracle12cdb1             STABLE

ora.LISTENER.lsnr

               ONLINE  ONLINE       oracle12cdb1             STABLE

ora.LISTENER12C.lsnr

               ONLINE  ONLINE       oracle12cdb1             STABLE

ora.asm

               OFFKINE  OFFLINE       oracle12cdb1             STABLE

ora.ons

               OFFLINE OFFLINE      oracle12cdb1             STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       oracle12cdb1             STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       oracle12cdb1             STABLE

ora.ora12cr2global.db

      1        ONLINE  OFFLINE                               STABLE

--------------------------------------------------------------------------------


- To resolve the issue, do the following command, please take all the backups of GI , CRS 

run the following command

                  crsctl stop res ora.CRS.dg -init
                  
                    crsctl status res -t
                  
                    crsctl modify res ora.CRS.dg -attr ENABLED=0 -init
                   
                     crsctl status res -t
                   
                    crsctl modify res ora.CRS.dg -attr ENABLED=1 -init
                   
                    crsctl status res -t

                    crsctl start res ora.CRS.dg -init


[grid@oracle12cdb1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       oracle12cdb1             STABLE
ora.DATA.dg
               ONLINE  ONLINE       oracle12cdb1             STABLE
ora.FRS.dg
               ONLINE  ONLINE       oracle12cdb1             STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       oracle12cdb1             STABLE
ora.LISTENER12C.lsnr
               ONLINE  ONLINE       oracle12cdb1             STABLE
ora.asm
               ONLINE  ONLINE       oracle12cdb1             Started,STABLE
ora.ons
               OFFLINE OFFLINE      oracle12cdb1             STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       oracle12cdb1             STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       oracle12cdb1             STABLE
ora.ora12cr2global.db
      1        ONLINE  OFFLINE                               STABLE




Thursday 7 July 2022

Oracle Weblogic handson labs 


Following link is very useful to practice the Oracle Weblgoic basics, it will give you a lab where you can do hanson practice and learn and clear your concepts, enjoy :)




https://luna.oracle.com/lab/77b25364-204a-4ed0-9dc8-6e993fe1e659



Oracle 19c - patch 19.22 unavailability for Windows platform

 Oracle 19c - patch 19.22 unavailability for Windows platform  Having upgraded the Oracle 11g 11.2.0.4 database to Oracle 19c 19.3.0.0.0 whi...