Adobe Flash End-of-Life Impact on Oracle Enterprise Manager Cloud Control

Adobe Flash End-of-Life

Cause :

The Adobe Flash EOL is December 31, 2020.
Adobe has announced that the Flash player will be blocked from running after the EOL date.

 

Adobe Flash Plug-in End-of-Life and Enterprise Manager

Many database performance screens in Enterprise Manager were implemented using Adobe Flash technology in versions prior to Enterprise Manager 13.3.2.0.   These database performance pages include ‘Performance Home’, ‘Top Activity’, ‘ASH Analytics’, ‘Real-time SQL Monitoring’ among others.

These Flash pages were replaced with the Oracle JET UI in Enterprise Manager 13.3.2.0 (EM 13.3 PG), released in 2019, and were later enhanced in Enterprise Manager 13.4.

Adobe Flash is being de-supported by Adobe on December 31, 2020.   If you are running versions of Enterprise Manager 13.3.1 or older and use the database performance pages with Adobe Flash goto solution.

RAC GRID Root.sh ORA-27091 ORA-15081 unable to queue I/O

RAC GRID Root.sh ORA-27091 ORA-15081 unable to queue I/O

ERROR:

[root@node-01 install]# /u01/app/11.2.0/grid/root.sh
Running Oracle 11g root script...

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

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/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
OLR initialization - successful
Adding daemon to inittab
ACFS-9200: Supported
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-2672: Attempting to start 'ora.mdnsd' on 'node-01'
CRS-2676: Start of 'ora.mdnsd' on 'node-01' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node-01'
CRS-2676: Start of 'ora.gpnpd' on 'node-01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node-01'
CRS-2672: Attempting to start 'ora.gipcd' on 'node-01'
CRS-2676: Start of 'ora.cssdmonitor' on 'node-01' succeeded
CRS-2676: Start of 'ora.gipcd' on 'node-01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node-01'
CRS-2672: Attempting to start 'ora.diskmon' on 'node-01'
CRS-2676: Start of 'ora.diskmon' on 'node-01' succeeded
CRS-2676: Start of 'ora.cssd' on 'node-01' succeeded

ASM created and started successfully.

Disk Group OCR_VOTE created successfully.

Errors in file :
ORA-27091: unable to queue I/O
ORA-15081: failed to submit an I/O operation to a disk
ORA-06512: at line 4
PROT-1: Failed to initialize ocrconfig
PROC-26: Error while accessing the physical storage
ORA-27091: unable to queue I/O
ORA-15081: failed to submit an I/O operation to a disk
ORA-06512: at line 4

Failed to create Oracle Cluster Registry configuration, rc 255
Oracle Clusterware Repository configuration failed at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 6471.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
[root@node-01 install]#


Solution:

The ASM Lib configuration was done with oracle id,But the grid installation i am doing with grid user.

[root@node-02 11202stage]# /usr/sbin/oracleasm configure
ORACLEASM_ENABLED=true
ORACLEASM_UID=oracle
ORACLEASM_GID=dba
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"

[root@node-02 11202stage]#

Update the configuration of ASMlib

/usr/sbin/oracleasm configure -u grid 

[root@node-02 11202stage]# /usr/sbin/oracleasm configure
ORACLEASM_ENABLED=true
ORACLEASM_UID=grid
ORACLEASM_GID=asmadmin
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"

[root@node-02 11202stage]#

For fresh installation delete the Disk group at asmlib.

/usr/sbin/oracleasm deletedisk OCR_VOTE01
/usr/sbin/oracleasm deletedisk ASM_DATA01
/usr/sbin/oracleasm deletedisk ASM_FRA01

And Recreate

/usr/sbin/oracleasm createdisk OCR_VOTE01 /dev/sde1
/usr/sbin/oracleasm createdisk ASM_DATA01 /dev/sdf1

/usr/sbin/oracleasm createdisk ASM_FRA01 /dev/sdg1

/usr/sbin/oracleasm listdisks

/usr/sbin/oracleasm scandisks

Now rerun the root.sh

 

 

http://oracletechdba.blogspot.com/2014/09/rac-grid-rootsh-ora-27091-ora-15081.html

Failed to start the virtual machine file not found .vmdk

I'm using VMware Workstation Pro 15.5.1 with monolithic disk files (on a Win 10 host). I worked with snapshots, but always deleted them again because they're not needed anymore.

Unfortunately, it does not delete the Snapshot files from my disk, when I try to delete them by hand it says This file is required to power on this virtual machine. If this file was moved, specify the new location.

 *.vmdk file which works independently from the snapshot files.

 

Solution:

1. Shut down the virtual machine
2. Go to the option 'VM' > Snapshot Manager
3. Select each snapshot and delete them from left-to-right

How To Move Spfile From File System To ASM In RAC

Below are the steps for moving spfile from file system to ASM diskgroup in RAC.

database name – ORCL
instance_names – ORCL1,ORCL2
oracle DB nodes – dbhstorcl1, dbhstorcl2

1. Check current pfile location:

SQL> show parameter pfile

NAME TYPE VALUE

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

spfile string /oracle/app/oracle/product/dbs/temp_init.ora

2. Now required directory in ASM diskgroup(where pfile will be created)

export ORACLE_HOME=/crsapp/app/oracle/product/12.1.2.0/grid12c

export ORACLE_SID=+ASM1

export PATH=$ORACLE_HOME/bin:$PATH

asmcmd

ASMCMD>mkdir +DATA/PARAM

3. Create the spfile from pfile:

create spfile='+DATA/PARAM/spfileORCL.ora' from pfile='/oracle/app/oracle/product/dbs/temp_init.ora';

4. Update INIT FILE on each node (pointing to actual spfile path)

on node 1(dbhstorcl1)

cd $ORACLE_HOME/dbs

cat initORCL1.ora

SPFILE='+DATA/PARAM/spfileORCL.ora'

on node 2(dbhstorcl2)

cd $ORACLE_HOME/dbs

cat initORCL2.ora

SPFILE='+DATA/PARAM/spfileORCL.ora'

5. update database config

srvctl modify database -d racdb1 -p +DATA/PARAM/spfileORCL.ora

srvctl config database -d B2CPRE | grep Spfile

Spfile: +CRMDB01/paramfile/spfileB2CPRE.ora

6. Restart the database

srvctl stop database -d ORCL

srvctl start database -d ORCL

SQL> show parameter pfile

NAME TYPE VALUE

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

spfile string +DATA/PARAM/spfileORCL.ora

 

DBCA Does Not Display ASM Disk Groups In 12cR2

I was installing Oracle 12c R2 with ASM but somehow the DBCA did not list ASM diskgroups. After struggling for hours, I could find a solution, not sure if it is approved by Oracle but it works !!

 

Problem

 

I’ve installed Grid infrastructure with user grid, and I was trying to install oracle database 12cr2 with oracle user but during this installation I wasn’t able to see any of my ASM disk in the select disk group.

 

Solution

 

log in as root user

 

/dev/oracleasm/

ls -lrt to check the permission on oracleasm directory

chown -R grid:oinstall oracleasm

 

cd /dev/oracleasm/disks

 

Login as grid user

 

cd $ORACLE_HOME

cd bin

ls -ld to check the permision on oracle directory

chmod 6571 oracle

ls -ld oracle

 

Login as oracle user

 

cd $ORACLE_HOME

cd bin

ls -ld oracle to check the permision

 

However, oracle directory permision in both grid user and oracle user must have the same permission. Therefore, issue the following command;

 

chmod 6571 oracle

 

Go back to select disk group and refresh.