Search This Blog

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



Tuesday 21 June 2022

open a EM express port 5500 in Oracle Linux




[root@oracle12cdb1 ~]# firewall-cmd --permanent --add-port=5500/tcp

success

[root@oracle12cdb1 ~]# firewall-cmd --reload

success




 

Saturday 18 June 2022

orainstRoot.sh and root.sh scripts post CRS install



[root@oracle12cdb1 app]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.


Changing groupname of /u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@oracle12cdb1 app]# /u01/app/grid/12.2.0/grid_home/root.sh

Performing root user operation.


The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /u01/app/grid/12.2.0/grid_home


Enter the full pathname of the local bin directory: [/usr/local/bin]:

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...



Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /u01/app/grid/12.2.0/grid_home/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/oracle12cdb1/crsconfig/roothas_2022-06-19_00-38-46AM.log

2022/06/19 00:38:47 CLSRSC-363: User ignored prerequisites during installation

LOCAL ADD MODE

Creating OCR keys for user 'grid', privgrp 'oinstall'..

Operation successful.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.


how to change hostname in Oracle Linux 7.2



[root@localhost ~]# hostname

oracle12cdb1

[root@localhost ~]# hostnamectl

   Static hostname: oracle12cdb1

         Icon name: computer-vm

           Chassis: vm

        Machine ID: 8ced32e2f6ce7e4182560e468ff0fb52

           Boot ID: 07e076fe742343a68c9c022c10b0911b

    Virtualization: kvm

  Operating System: Oracle Linux Server 7.2

       CPE OS Name: cpe:/o:oracle:linux:7:2:server

            Kernel: Linux 3.8.13-98.7.1.el7uek.x86_64

      Architecture: x86-64

[root@localhost ~]# hostnamectl set-hostname oracle12cdb1.testlab.com

[root@localhost ~]# hostname

oracle12cdb1.testlab.com


 

 

Friday 17 June 2022

Grid infrastructure installer error error while loading shared libraries: libnsl.so.1


[grid@oracle12cdb1 grid_home]$ sh gridSetup.sh

/u01/app/grid/12.2.0/grid_home/perl/bin/perl: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory

 


[root@oracle12cdb1 u01]# yum install libnsl.x86_64

Last metadata expiration check: 2:39:16 ago on Fri 17 Jun 2022 05:46:12 PM NZST.

Dependencies resolved.

=====================================================================================================================

 Package                       Architecture       Version                        Repository                     Size

=====================================================================================================================

Installing:

 libnsl                        x86_64             2.28-189.1.0.1.el8             ol8_baseos_latest             103 k

Upgrading:

 glibc                         i686               2.28-189.1.0.1.el8             ol8_baseos_latest             2.0 M

 glibc                         x86_64             2.28-189.1.0.1.el8             ol8_baseos_latest             2.2 M

 glibc-common                  x86_64             2.28-189.1.0.1.el8             ol8_baseos_latest             1.3 M

 glibc-devel                   x86_64             2.28-189.1.0.1.el8             ol8_baseos_latest              80 k

 glibc-headers                 x86_64             2.28-189.1.0.1.el8             ol8_baseos_latest             485 k

 glibc-langpack-en             x86_64             2.28-189.1.0.1.el8             ol8_baseos_latest             835 k


Transaction Summary

=====================================================================================================================

Install  1 Package

Upgrade  6 Packages


Total download size: 6.9 M

Is this ok [y/N]: y

Downloading Packages:

(1/7): libnsl-2.28-189.1.0.1.el8.x86_64.rpm                                          257 kB/s | 103 kB     00:00

(2/7): glibc-2.28-189.1.0.1.el8.x86_64.rpm                                           1.7 MB/s | 2.2 MB     00:01

(3/7): glibc-common-2.28-189.1.0.1.el8.x86_64.rpm                                    1.4 MB/s | 1.3 MB     00:00

(4/7): glibc-devel-2.28-189.1.0.1.el8.x86_64.rpm                                     1.9 MB/s |  80 kB     00:00

(5/7): glibc-2.28-189.1.0.1.el8.i686.rpm                                             1.4 MB/s | 2.0 MB     00:01

(6/7): glibc-langpack-en-2.28-189.1.0.1.el8.x86_64.rpm                               2.4 MB/s | 835 kB     00:00

(7/7): glibc-headers-2.28-189.1.0.1.el8.x86_64.rpm                                   1.2 MB/s | 485 kB     00:00

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

Total                                                                                4.0 MB/s | 6.9 MB     00:01

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

  Preparing        :                                                                                             1/1

  Upgrading        : glibc-common-2.28-189.1.0.1.el8.x86_64                                                     1/13

  Upgrading        : glibc-langpack-en-2.28-189.1.0.1.el8.x86_64                                                2/13

  Running scriptlet: glibc-2.28-189.1.0.1.el8.x86_64                                                            3/13

  Upgrading        : glibc-2.28-189.1.0.1.el8.x86_64                                                            3/13

  Running scriptlet: glibc-2.28-189.1.0.1.el8.x86_64                                                            3/13

  Running scriptlet: glibc-headers-2.28-189.1.0.1.el8.x86_64                                                    4/13

  Upgrading        : glibc-headers-2.28-189.1.0.1.el8.x86_64                                                    4/13

  Upgrading        : glibc-devel-2.28-189.1.0.1.el8.x86_64                                                      5/13

  Running scriptlet: glibc-devel-2.28-189.1.0.1.el8.x86_64                                                      5/13

  Installing       : libnsl-2.28-189.1.0.1.el8.x86_64                                                           6/13

  Running scriptlet: glibc-2.28-189.1.0.1.el8.i686                                                              7/13

  Upgrading        : glibc-2.28-189.1.0.1.el8.i686                                                              7/13

  Running scriptlet: glibc-2.28-189.1.0.1.el8.i686                                                              7/13

  Running scriptlet: glibc-devel-2.28-164.0.4.el8.x86_64                                                        8/13

  Cleanup          : glibc-devel-2.28-164.0.4.el8.x86_64                                                        8/13

  Cleanup          : glibc-2.28-164.0.4.el8.i686                                                                9/13

  Cleanup          : glibc-headers-2.28-164.0.4.el8.x86_64                                                     10/13

  Cleanup          : glibc-2.28-164.0.4.el8.x86_64                                                             11/13

  Cleanup          : glibc-langpack-en-2.28-164.0.4.el8.x86_64                                                 12/13

  Cleanup          : glibc-common-2.28-164.0.4.el8.x86_64                                                      13/13

  Running scriptlet: glibc-common-2.28-164.0.4.el8.x86_64                                                      13/13

  Running scriptlet: glibc-common-2.28-189.1.0.1.el8.x86_64                                                    13/13

  Verifying        : libnsl-2.28-189.1.0.1.el8.x86_64                                                           1/13

  Verifying        : glibc-2.28-189.1.0.1.el8.i686                                                              2/13

  Verifying        : glibc-2.28-164.0.4.el8.i686                                                                3/13

  Verifying        : glibc-2.28-189.1.0.1.el8.x86_64                                                            4/13

  Verifying        : glibc-2.28-164.0.4.el8.x86_64                                                              5/13

  Verifying        : glibc-common-2.28-189.1.0.1.el8.x86_64                                                     6/13

  Verifying        : glibc-common-2.28-164.0.4.el8.x86_64                                                       7/13

  Verifying        : glibc-devel-2.28-189.1.0.1.el8.x86_64                                                      8/13

  Verifying        : glibc-devel-2.28-164.0.4.el8.x86_64                                                        9/13

  Verifying        : glibc-headers-2.28-189.1.0.1.el8.x86_64                                                   10/13

  Verifying        : glibc-headers-2.28-164.0.4.el8.x86_64                                                     11/13

  Verifying        : glibc-langpack-en-2.28-189.1.0.1.el8.x86_64                                               12/13

  Verifying        : glibc-langpack-en-2.28-164.0.4.el8.x86_64                                                 13/13


Upgraded:

  glibc-2.28-189.1.0.1.el8.i686                           glibc-2.28-189.1.0.1.el8.x86_64

  glibc-common-2.28-189.1.0.1.el8.x86_64                  glibc-devel-2.28-189.1.0.1.el8.x86_64

  glibc-headers-2.28-189.1.0.1.el8.x86_64                 glibc-langpack-en-2.28-189.1.0.1.el8.x86_64

Installed:

  libnsl-2.28-189.1.0.1.el8.x86_64


Complete!

[root@oracle12cdb1 u01]#

[root@oracle12cdb1 u01]#

[root@oracle12cdb1 u01]# sudo su - grid

[grid@oracle12cdb1 ~]$ cd $ORACLE_HOME



[grid@oracle12cdb1 grid_home]$ sh gridSetup.sh

Launching Oracle Grid Infrastructure Setup Wizard...


oracleasm command


[root@oracle12cdb1 /]# oracleasm -V

oracleasm version 2.1.8


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

[root@oracle12cdb1 /]# oracleasm -h

Usage: oracleasm [--exec-path=<exec_path>] <command> [ <args> ]

       oracleasm --exec-path

       oracleasm -h

       oracleasm -V


The basic oracleasm commands are:

    configure        Configure the Oracle Linux ASMLib driver

    init             Load and initialize the ASMLib driver

    exit             Stop the ASMLib driver

    scandisks        Scan the system for Oracle ASMLib disks

    status           Display the status of the Oracle ASMLib driver

    listdisks        List known Oracle ASMLib disks

    querydisk        Determine if a disk belongs to Oracle ASMlib

    createdisk       Allocate a device for Oracle ASMLib use

    deletedisk       Return a device to the operating system

    renamedisk       Change the label of an Oracle ASMlib disk

    update-driver    Download the latest ASMLib driver

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

[root@oracle12cdb1 /]# oracleasm status

Checking if ASM is loaded: yes

Checking if /dev/oracleasm is mounted: yes


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

[root@oracle12cdb1 /]# oracleasm listdisks

CRS1

DATA1

FRA1

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

[root@oracle12cdb1 /]# oracle querydisk CRS1

bash: oracle: command not found...

[root@oracle12cdb1 /]# oracleasm querydisk CRS1

Disk "CRS1" is a valid ASM disk

[root@oracle12cdb1 /]# oracleasm querydisk CRS2

Disk "CRS2" does not exist or is not instantiated

[root@oracle12cdb1 /]# oracleasm querydisk DATA1

Disk "DATA1" is a valid ASM disk

[root@oracle12cdb1 /]# oracleasm querydisk FRA1

Disk "FRA1" is a valid ASM disk

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

[root@oracle12cdb1 /]# oracleasm listdisks
CRS1
DATA1
FRA1

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


[root@oracle12cdb1 /]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...



 

oracleasm createdisk command 


[root@oracle12cdb1 ~]# oracleasm createdisk CRS1 /dev/sdb1

Writing disk header: done

Instantiating disk: done

[root@oracle12cdb1 ~]# oracleasm createdisk DATA1 /dev/sdb2

Writing disk header: done

Instantiating disk: done

[root@oracle12cdb1 ~]# oracleasm createdisk FRA1 /dev/sdb3

Writing disk header: done

Instantiating disk: done

[root@oracle12cdb1 ~]# oracleasm listdisks

CRS1

DATA1

FRA1


 use of linux command fdisk to partition the raw device for ASM Disks


[root@oracle12cdb1 ~]# fdisk -l

Disk /dev/sda: 40.9 GiB, 43925766144 bytes, 85792512 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disklabel type: dos

Disk identifier: 0xb4face83


Device     Boot   Start      End  Sectors  Size Id Type

/dev/sda1  *       2048  2099199  2097152    1G 83 Linux

/dev/sda2       2099200 85790719 83691520 39.9G 8e Linux LVM



Disk /dev/sdb: 30.4 GiB, 32651509760 bytes, 63772480 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes


[root@oracle12cdb1 ~]# fdisk /dev/sdb


Welcome to fdisk (util-linux 2.32.1).

Changes will remain in memory only, until you decide to write them.

Be careful before using the write command.


Device does not contain a recognized partition table.

Created a new DOS disklabel with disk identifier 0x01e28984.


Command (m for help): n

Partition type

   p   primary (0 primary, 0 extended, 4 free)

   e   extended (container for logical partitions)

Select (default p): o

Value out of range.

   p   primary (0 primary, 0 extended, 4 free)

   e   extended (container for logical partitions)

Select (default p): p

Partition number (1-4, default 1):

First sector (2048-63772479, default 2048):

Last sector, +sectors or +size{K,M,G,T,P} (2048-63772479, default 63772479): +10G


Created a new partition 1 of type 'Linux' and of size 10 GiB.


Command (m for help): n

Partition type

   p   primary (1 primary, 0 extended, 3 free)

   e   extended (container for logical partitions)

Select (default p): p

Partition number (2-4, default 2):

First sector (20973568-63772479, default 20973568):

Last sector, +sectors or +size{K,M,G,T,P} (20973568-63772479, default 63772479): +15G


Created a new partition 2 of type 'Linux' and of size 15 GiB.


Command (m for help): n

Partition type

   p   primary (2 primary, 0 extended, 2 free)

   e   extended (container for logical partitions)

Select (default p): p

Partition number (3,4, default 3):

First sector (52430848-63772479, default 52430848):

Last sector, +sectors or +size{K,M,G,T,P} (52430848-63772479, default 63772479):


Created a new partition 3 of type 'Linux' and of size 5.4 GiB.


Command (m for help): w

The partition table has been altered.

Calling ioctl() to re-read partition table.

Syncing disks.


[root@oracle12cdb1 ~]# fdisk -l

Disk /dev/sda: 40.9 GiB, 43925766144 bytes, 85792512 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disklabel type: dos

Disk identifier: 0xb4face83


Device     Boot   Start      End  Sectors  Size Id Type

/dev/sda1  *       2048  2099199  2097152    1G 83 Linux

/dev/sda2       2099200 85790719 83691520 39.9G 8e Linux LVM



Disk /dev/sdb: 30.4 GiB, 32651509760 bytes, 63772480 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disklabel type: dos

Disk identifier: 0x01e28984


Device     Boot    Start      End  Sectors  Size Id Type

/dev/sdb1           2048 20973567 20971520   10G 83 Linux

/dev/sdb2       20973568 52430847 31457280   15G 83 Linux

/dev/sdb3       52430848 63772479 11341632  5.4G 83 Linux







 oracleasmlib-2.0.17-1.el8.x86_64 download for Oracle Enterprise Linux 8


oracleasmlib-2.0.17-1.el8.x86_64 can be downloaded from the following url


https://www.oracle.com/linux/downloads/linux-asmlib-v8-downloads.html



oracleasm-support package install issue on Oracle Enterprise Linux 8


[root@oracle12cdb1 stage]# yum install oracleasm-support

Last metadata expiration check: 2:05:15 ago on Fri 17 Jun 2022 08:46:17 AM NZST.

Dependencies resolved.

===================================================================================================================================================================

 Package                                      Architecture                      Version                                Repository                             Size

===================================================================================================================================================================

Installing:

 oracleasm-support                            x86_64                            2.1.8-1.el5                            el5_latest                             88 k


Transaction Summary

===================================================================================================================================================================

Install  1 Package


Total size: 88 k

Installed size: 213 k

Is this ok [y/N]: y

Downloading Packages:

[SKIPPED] oracleasm-support-2.1.8-1.el5.x86_64.rpm: Already downloaded

Oracle Linux 8 Latest (x86_64)                                                                                                     3.0 MB/s | 3.1 kB     00:00

GPG key at file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle (0xAD986DA3) is already installed

The GPG keys listed for the "Oracle Linux 8 Latest (x86_64)" repository are already installed but they are not correct for this package.

Check that the correct key URLs are configured for this repository.. Failing package is: oracleasm-support-2.1.8-1.el5.x86_64

 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

The downloaded packages were saved in cache until the next successful transaction.

You can remove cached packages by executing 'yum clean packages'.

Error: GPG check FAILED

[root@oracle12cdb1 stage]# find / -name oracleasm-support-2.1.8-1.el5.x86_64* -print

find: ‘/run/user/54321/gvfs’: Permission denied

/var/cache/PackageKit/8.5/metadata/el5_latest-8-x86_64/packages/oracleasm-support-2.1.8-1.el5.x86_64.rpm

/var/cache/dnf/el5_latest-20127a734157f70c/packages/oracleasm-support-2.1.8-1.el5.x86_64.rpm

[root@oracle12cdb1 stage]# cp /var/cache/dnf/el5_latest-20127a734157f70c/packages/oracleasm-support-2.1.8-1.el5.x86_64.rpm /stage/.

[root@oracle12cdb1 stage]# ls -ltrh

total 120K

-rw-r--r--. 1 oracle oinstall 27K Jun 17 10:25 oracleasmlib-2.0.17-1.el8.x86_64.rpm

-rw-r--r--. 1 root   root     89K Jun 17 10:52 oracleasm-support-2.1.8-1.el5.x86_64.rpm

[root@oracle12cdb1 stage]# rpm -ivh oracleasm-support-2.1.8-1.el5.x86_64.rpm

warning: oracleasm-support-2.1.8-1.el5.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 1e5e0159: NOKEY

Verifying...                          ################################# [100%]

Preparing...                          ################################# [100%]

Updating / installing...

   1:oracleasm-support-2.1.8-1.el5    ################################# [100%]

[root@oracle12cdb1 stage]# oracleasm configure -i

Configuring the Oracle ASM library driver.


This will configure the on-boot properties of the Oracle ASM library

driver.  The following questions will determine whether the driver is

loaded on boot and what permissions it will have.  The current values

will be shown in brackets ('[]').  Hitting <ENTER> without typing an

answer will keep that current value.  Ctrl-C will abort.


Default user to own the driver interface []: grid

Default group to own the driver interface []: dba

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration: done

[root@oracle12cdb1 stage]# oracleasm init

Creating /dev/oracleasm mount point: /dev/oracleasm

Loading module "oracleasm": oracleasm

Configuring "oracleasm" to use device physical block size

Mounting ASMlib driver filesystem: /dev/oracleasm

 

Saturday 30 April 2022

 Oracle 12c EM console not showing up on browser





Download the latest flashplayer rpm and install on database host server.

 Oracle Database Incarnation concept:

Its very common concept for Oracle DBAs. Incarnation is the new version of the database and it happens when database is opened with "reset logs" option after an in complete recovery.


The view V$DATABASE_INCARNATION can be checked for all the database versions / incarnations. 





Thursday 24 March 2022

openssl command hangs while generating .p12 file - Git Bash environment

openssl commands hangs while generating .p12 file - Git Bash environment 


 openssl command will remain hang if you are trying to generate the .p12 file from the SSL cert , the only option to come out of hung state is to use the Ctrl+C and it will not generate the .p12 file. 


The issue can be resolved to use the winpty before the openssl command and it will generate the .p12 file. 


$ openssl pkcs12 -export -in ssl_cert_file.crt -inkey ssl_crt_key_file.key -out ssl_cert_file.p12 -name "test command to generate the p12 file" 

Ctrl+C 


use the winpty command and it will work 


$ winpty openssl pkcs12 -export -in ssl_cert_file.crt -inkey ssl_crt_key_file.key -out ssl_cert_file.p12 -name "test command to generate the p12 file" 

Enter Export Password: 
Verifying - Enter Export Password:

Sunday 6 March 2022

Oracle 12c install error - Oracle Net Configuration Assistant keep searching the listener ports - Checking for free port in range: 1521-1540 - Validating end-point: TCP:1521

Oracle 12c install error - Oracle Net Configuration Assistant keep searching the listener ports 

The installer will stuck on the Oracle Net Configuration Assistant and will never complete, it will keep searching the listener ports, starting from 1521, it will keep searching the next port 1522, then so on. 

Even the listener port 1521 is free and not being used, but Net Configuration Assistant keep putting the following messages in the directory "cfgtoollogs/netca"


[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.isHASConfigured:1648]  Is Oracle Restart configured: false

[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.isHASRunning:1677]  Is Oracle Restart running: false

[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.listenerExists:411]  Is listener "LISTENER" already exists: false

[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.typicalConfigure:272]  Checking for free port in range: 1521-1540

[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.validateEndPoint:1074]  Validating end-point: TCP:1521

oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.

        at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)

        at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)

        at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)

        at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)

        at oracle.net.ca.NetCA.main(NetCA.java:452)

[main] [ 2022-03-06 13:39:15.023 NZDT ] [ConfigureListener.typicalConfigure:283]  The information provided for this listener is currently in use by other software on this computer.

[main] [ 2022-03-06 13:39:15.023 NZDT ] [ConfigureListener.validateEndPoint:1074]  Validating end-point: TCP:1522

oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.

        at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)

        at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)

        at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)

        at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)

        at oracle.net.ca.NetCA.main(NetCA.java:452)

[main] [ 2022-03-06 13:41:30.083 NZDT ] [ConfigureListener.typicalConfigure:283]  The information provided for this listener is currently in use by other software on this computer.

[main] [ 2022-03-06 13:41:30.083 NZDT ] [ConfigureListener.validateEndPoint:1074]  Validating end-point: TCP:1523

oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.

        at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)

        at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)

        at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)

        at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)

        at oracle.net.ca.NetCA.main(NetCA.java:452)

[main] [ 2022-03-06 13:43:45.041 NZDT ] [ConfigureListener.typicalConfigure:283]  The information provided for this listener is currently in use by other software on this computer.

[main] [ 2022-03-06 13:43:45.041 NZDT ] [ConfigureListener.validateEndPoint:1074]  Validating end-point: TCP:1524

oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.

        at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)

        at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)

        at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)

        at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)

        at oracle.net.ca.NetCA.main(NetCA.java:452)

[main] [ 2022-03-06 13:46:00.082 NZDT ] [ConfigureListener.typicalConfigure:283]  The information provided for this listener is currently in use by other software on this computer.

[main] [ 2022-03-06 13:46:00.083 NZDT ] [ConfigureListener.validateEndPoint:1074]  Validating end-point: TCP:1525

oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.

        at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)

        at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)

        at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)

        at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)

        at oracle.net.ca.NetCA.main(NetCA.java:452)

[main] [ 2022-03-06 13:48:17.004 NZDT ] [ConfigureListener.typicalConfigure:283]  The information provided for this listener is currently in use by other software on this computer.

[main] [ 2022-03-06 13:48:17.005 NZDT ] [ConfigureListener.validateEndPoint:1074]  Validating end-point: TCP:1526

oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.

        at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)

        at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)

        at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)


Resolution:

- check the /etc/hosts file, it should contain the fully qualified name of the host machine with the IP.

- update the /etc/hosts with the correct hostname / ip and Oracle Net Configuration Assistant will pick the right hostname and will get the listener port for the configuration.


- to make sure check the installer screen , also log file can be checked under "cfgtoollogs/netca"


[main] [ 2022-03-06 13:59:35.198 NZDT ] [ConfigureListener.typicalConfigure:283]  The information provided for this listener is currently in use by other software on this computer.

[main] [ 2022-03-06 13:59:35.198 NZDT ] [ConfigureListener.validateEndPoint:1074]  Validating end-point: TCP:1531

[main] [ 2022-03-06 14:00:50.125 NZDT ] [ConfigureListener.isPortFree:1155]  Checking if port 1531 is free on local machine...

[main] [ 2022-03-06 14:00:50.126 NZDT ] [ConfigureListener.isPortFree:1170]  InetAddress.getByName(127.0.0.1): /127.0.0.1

[main] [ 2022-03-06 14:00:50.126 NZDT ] [ConfigureListener.isPortFree:1172]  Local host IP address: oracle12cdb.testlab.com/192.168.1.100

[main] [ 2022-03-06 14:00:50.127 NZDT ] [ConfigureListener.isPortFree:1174]  Local host name: oracle12cdb.testlab.com

[main] [ 2022-03-06 14:00:50.127 NZDT ] [ConfigureListener.isPortFree:1207]  IP Address: oracle12cdb.testlab.com/192.168.1.100, Is IPv6 Address: false

[main] [ 2022-03-06 14:00:50.127 NZDT ] [ConfigureListener.isPortFree:1210]  IP Address: oracle12cdb.testlab.com/192.168.1.100, Is Link-Local Address: false

[main] [ 2022-03-06 14:00:50.127 NZDT ] [ConfigureListener.isPortFree:1235]  Creating ServerSocket on Port:1531, IP Address: oracle12cdb.testlab.com/192.168.1.100

[main] [ 2022-03-06 14:00:50.130 NZDT ] [ConfigureListener.isPortFree:1238]  Created ServerSocket successfully.

[main] [ 2022-03-06 14:00:50.130 NZDT ] [ConfigureListener.isPortFree:1250]  Creating ServerSocket on Port:1531, Local IP Address: /127.0.0.1

[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.isPortFree:1254]  Created ServerSocket successfully.

[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.isPortFree:1260]  Creating ServerSocket on Port:1531

[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.isPortFree:1263]  Created ServerSocket successfully.

[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.isPortFree:1283]  Returning is Port 1531 free: true

[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.validateEndPoint:1129]  Validation...Complete for TCP/TCPS.

[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.typicalConfigure:289]  Using port: 1531

[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1155]  Checking if port 1531 is free on local machine...

[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1170]  InetAddress.getByName(127.0.0.1): /127.0.0.1

[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1172]  Local host IP address: oracle12cdb.testlab.com/192.168.1.100

[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1174]  Local host name: oracle12cdb.testlab.com

[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1207]  IP Address: oracle12cdb.testlab.com/192.168.1.100, Is IPv6 Address: false

[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1210]  IP Address: oracle12cdb.testlab.com/192.168.1.100, Is Link-Local Address: false

[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1235]  Creating ServerSocket on Port:1531, IP Address: oracle12cdb.testlab.com/192.168.1.100

[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1238]  Created ServerSocket successfully.

[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1250]  Creating ServerSocket on Port:1531, Local IP Address: /127.0.0.1

[main] [ 2022-03-06 14:00:50.137 NZDT ] [ConfigureListener.isPortFree:1254]  Created ServerSocket successfully.

[main] [ 2022-03-06 14:00:50.137 NZDT ] [ConfigureListener.isPortFree:1260]  Creating ServerSocket on Port:1531

[main] [ 2022-03-06 14:00:50.137 NZDT ] [ConfigureListener.isPortFree:1263]  Created ServerSocket successfully.

[main] [ 2022-03-06 14:00:50.137 NZDT ] [ConfigureListener.isPortFree:1283]  Returning is Port 1531 free: true





Oracle 12c Installer error -- no oraInstaller in java.library.path

 Oracle 12c Installer error - 

[INS-10102] Installer initialization failed
- no oraInstaller in java.library.path


- make sure oraInst.loc file has the valid location of oraInventory path and oracle os user has the permissions to read the oraInst.loc file and read / write on oraInventory.


- install the following package  libnsl.so.1 with root user
#dnf install libnsl




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...