Skip to main content

Oracle Database 19c Bugs and Workarounds



Analytic Workspace Manager Known Bugs

* BUG 28532773 - CUBE STORAGE ADVISOR FAILS TO RUN UNLESS USER CAN QUERY V$PARAMETER
Cube Storage Advisor fails with the following error: ORA-00942 table or view not found

Workaround: None


* BUG 28937717 - CALCULATIONS MISSING FROM' CREATE CALCULATION MEASURES'
Measures cannot be calculated in the Create Calculation Measure wizard.

Workaround: None


Issues Affecting Linux for Oracle Database 19c


BUG 26708302 - UNABLE TO DELETE "DEINSTALL" EMPTY FOLDER ON SHARED RAC HOME ON NAS

Deinstallation of Oracle Real Application Clusters (Oracle RAC) home on shared Network Attached Storage (NAS) fails to delete the directory $ORACLE_HOME/deinstall and returns the following error:
Failed to delete the directory $ORACLE_HOME/deinstall. Either user has no permission to delete or it is in use.

Workaround: Manually delete the $ORACLE_HOME/deinstall folder as either the Oracle RAC owner or as root.


Known Issues and Bugs for SUSE Linux Enterprise Server 15

BUG 29953021 - 19.4: INVOKE GRIDSETUP.SH AND RUNINSTALLER WITH -APPLYRU OPTION POINTING TO 19.4 RU ON SLES12 SP3 AND SLES15:

BUG 29916735 - SLES15_194GIRU:OSWATCHER.SH SPIN CPU AFTER PATCH

BUG 29836096 - SUSE15 SUPPORT FOR INSTANT CLIENT INSTALLS
libstdc++33 package missing error during Oracle Instant Client installation.
Errors  :  PRVF-7532 : Package "libstdc++33" is missing on node "den02zlf"

Workaround: In the Perform Prerequisite Checks screen, select Ignore All and proceed with the installation.
For non-interactive or silent installations, run the following command:
$./runInstaller -ignorePrereq


BUG 30131474 - LIBGFORTRAN PACKAGE VERSION ISSUE FOR GRID/DB ON 19.3+19.4GIRU+ONE-OFF 30083976 FOR SLES15

libgfortran package missing error during Oracle Database 19.4 installation on SUSE Linux Enterprise Server 15

Workaround: Ignore the warning and ensure that you install the libgfortran4-7.3.1+r258812-2.15.x86_64 package on the system.


Issues Affecting Oracle Solaris for Oracle Database 19c

BUG 21816875 - SOLARIS:CLIENT 32: REMOVE NETCA FILES AND CFG TOOL -- Fixed

PROBLEM:

For solaris ports , Client 32 bit shiphome directory is empty under published

labels 

[susiddav@adc2120751 ~]$  ls
/ade_autofs/ud44_db/RDBMS_MAIN_SOLARIS.SPARC32.rdd/150902/install/shiphome/
[susiddav@adc2120751 ~]$ ls
/ade_autofs/ud44_db/RDBMS_MAIN_SOLARIS.X32.rdd/150828/install/shiphome/
[susiddav@adc2120751 ~]$



BUG 21800407 - [DB12201-SOLSPARC] FONT BACKGROUND COLOR IS YELLOW IN OUI/DBCA/DBUA -- Closed, Not feasible to fix

Problem Description:
During install DB, font background color is yellow in OUI/DBCA/DBUA pages.
This issue is verified on both English and Japanese env.
No such issue for GI OUI and ASMCA.

Workaround:
Prior to installing Oracle Database, run the following command: export _JAVA_OPTIONS='-Dsun.java2d.xrender=false'


BUG 28650933 - PROBLEMS INSTALLING AND/OR UPGRADING OSB ON NEW SOLARIS 11.4 OS

Workaround: Upgrade the Oracle Solaris OS version to Oracle Solaris 11.4.6.4.0. and then install Oracle Secure Backup 12.2. Alternate workaround is to copy the file /usr/ib/64/libnls.so.1 from an Oracle Solaris 11.3 machine to the /usr/lib/64 path in the Oracle Solaris 11.4 machine where Oracle Secure Backup 12.2 needs to be installed.


BUG 24355490 - AUTO-POPULATION OF ORACLE_HOME IN GRIDSETUP.SH IS INCONSISTENT -- Closed, Not feasible to fix

WORKAROUND:
Invoke gridSetup.sh using absolute path


Issues Affecting HP-UX Itanium for Oracle Database 19c

BUG 27367949 - UPGRADING 12201/11204 DB TO 18.1 FAILED

Oracle OLAP API UPGRADED 18.1.0.0.0 00:00:18
Upgrade Datapatch Error: prereq checks failed!

catupgrd_datapatch_normal.log returns:
ORA-20001: Latest xml inventory is not loaded into table Prereq check failed, exiting without installing any patches.

Workaround: Start DBUA as a user with the same group ID as that of the Oracle user that owns the Oracle Database 18c Oracle home.

For example, if the user asmadmin is the group owner of the Oracle home on your system, change the user primary group to the asmadmin group using newgrp:

bash-4.3$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 1133380232 Feb 14 00:36 bin/oracle
bash-4.3$ newgrp asmadmin
bash-4.3$ $ORACLE_HOME/bin/dbua


BUG 28340043 - 18.3 HPIA: JAVAVM COMPONENT IS INVALID AFTER DATABASE CREATION


BUG 29198896 - 19.3HPIA: FAILURE TO DUPLICATE A DB FROM ASM TO NON-ASM

ORA-01017: invalid username/password; logon denied

Workaround: If the source instance password file is on Oracle ASM, then define the clone instance password on Oracle ASM only, and when the source password file is on Non-ASM files system, then keep the clone instance password file on Non-ASM file system.



Issues Affecting the IBM AIX on POWER Systems Platform for Oracle Database 19c

BUG 29053538 - PLEASE ADD TO RELEASE NOTES THE REQUIREMENT TO INSTALL IBM XL FORTRAN RUNTIME

ORA-40238: invalid linear algebra shared library

Workaround: Install XL Fortran Runtime for AIX Fix Pack 10 (February 2018 PTF) for 15.1.
Download and install XL Fortran Runtime for AIX Fix Pack 10 (February 2018 PTF) for 15.1 from:
https://www-01.ibm.com/support/docview.wss?uid=swg24044611



BUG 29434250 - 19.3 AIX: UNHANDLED EXCEPTION IN DBUA WHILE PROVIDING EM CLOUD CONTROL CREDENTIALS

Workaround: Do not register with EMCC during install or upgrade. Instead, discover the host and add targets either using EMCC web console or Enterprise Manager Command Line Interface (EMCLI) commands after the install and upgrade is complete.



BUG 29052788 - 19.2.AIX:CDP DOESN'T HANDLE SCAN IP CHANGES GRACEFULLY

Workaround: If CDP is found to be offline when the SCAN VIP's IP changes, then use srvctl start cdp to restart it.



BUG 29178036 - 19.3 AIX: ONE NODE DB CREATION FAILS: STARTING THE SECOND INSTANCE IS NOT ALLOWED IN RAC ONE NODE

DBCA ORA-24544: Oracle RAC One Node instance is already running.
ERROR: Starting the second instance is not allowed in RAC One Node.

Workaround: IBM AIX on Power Systems 8 or later, and AIX 7.2 use hardware compression for Active Memory Expansion (AME) and therefore can support the use of 64k pages with AME. On AIX 7.1 or earlier, 64k pages are not supported when AME is enabled, and 4k pages are used instead. In certain scenarios when using 4k pages with the Oracle Database, certain operations may be slower, including startup and shutdown of the database. Use of AME with the Oracle RAC One Node Database software is not recommended unless using AIX 8 or later and AIX 7.2 or later with 64k pages enabled.


Issues Affecting Microsoft Windows for Oracle Database 19c

BUG 20918120 - WS2012_122_GMSA:GMSA USER COULD NOT BE RECOGNIZED BY OUI

Workaround: Use a gMSA name (including the domain name) that consists of less than 15 characters.



BUG 21325903 - SI DB (MSA ACCOUNT) DEINSTALL DOES NOT REMOVE C:\122DB_MSA\BASE\HOME\BIN\OCI.DLL

Failed to delete the file 'C:\122db_MSA\base\home\bin\oci.dll'. The file is in use.
Failed to delete the directory 'C:\122db_MSA\base\home\bin'. The directory is not empty.
Failed to delete the directory 'C:\122db_MSA\base\home'. The directory is not empty.
...
...
Successfully deleted Registry key
'HKEY_LOCAL_MACHINE\System\\CurrentControlSet\
\Services\\Oracle11' on the local node.
Failed to delete directory 'C:\122db_MSA\base' on the local node.
Oracle Universal Installer cleanup completed with errors.


Workaround: Manually remove the Oracle home.



BUG 29426320 - 19.3_WIN.X64:EXECUTE .NET PROCEDURE GOT ORA-28575 ERROR WITH VIRTUAL ACCOUNT.

ORA-28575: Unable to open RPC connection to external procedure agent
Error occurs when running external procedures or Oracle Database Extensions for .NET procedures with a virtual user account.

ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "SYS.DBMS_CLR", line 129
ORA-06512: at "SYS.DBMS_CLR", line 42
ORA-06512: at "SYS.DBMS_CLR", line 124
ORA-06512: at line 1


Workaround#1: Restart the Oracle listener service and the OracleClrAgent service using a non-virtual user account.
Workaround#2: Reinstall Oracle Database 19c and select a non-virtual user account.
Workaround#3: If you require a virtual user account, then set sqlnet.authentication_services to NONE in SQLNET.ORA.

Comments

Post a Comment

Popular posts from this blog

Trading and Mindset

                Especially in India, when we say about TRADING, the majority of people think about either risk or loss or both. The reason behind the risks are extremely untutored on charting techniques, ill-educated about the trading platform, witless goals on the outcome, cretinous decisions when trade, lack of knowledge about current affairs and market conditions and so on. General info on Trading. Trading means buying or selling goods, commodities, metals, oils, currencies, stock & futures, etc. In trading either you can be an individual trader and be a boss of your own (OR) you can learn the skills, develop your own strategies and join a company as a professional trader. Before entering into Trading Network, you need to set your mind with the below qualities: 1 - Being patient. 2 - Not being greedy. 3 - Self Educated (both fundamental and technical analysis). If you miss any of the above at any point ...
Post a Comment
Read more
Charles Darwin's illness Charles Robert Darwin  (12 February 1809 – 19 April 1882) was an English naturalist who realised and presented compelling evidence that all species of life have evolved over time from common ancestors, through the process he called natural selection and now forms the basis of modern evolutionary theory. Darwin’s scientific discovery remains the foundation of biology, as it provides a unifying logical explanation for the diversity of life. For much of his adult life Charles Darwin's illness repeatedly affected him with an uncommon combination of symptoms, leaving him severely debilitated for long periods of time, incapable of normal life and intellectual production, staying in bed most of the time for months. Charles Darwin wrote that "Constant attacks....makes life an intolerable bother and stops all work". He consulted with more than 20 doctors, but with the medical science of the time the cause remained undiagnosed. He tried all ...
Post a Comment
Read more

Cryonics Technology

Today, I am going to articulate an interesting topic. It is about Cryonics Technology. It is the first and foremost prominent technology that relates to AFTERLIFE! Does it sound weird? Cryonics is the low-temperature freezing, that would be -130 °C and storage of corpses!  Now, you might have a plethora of WH-Questions! Cryonics Technology comes into the picture only when the human being expires due to lung/liver/heart or any other organ failure or due to any diseases. This technology will keep the body and other organs as undamaged as possible by freezing them and circulating the blood throughout the vessels. So that, In future, If the dead person gets antidote or cure, then they will implement the fix and then the dead can come back to life AGAIN!  It is like " I am back " as Keanu Reeves says in the movie John Wick. Let's go a little deeper into this topic! This will be fascinating. James Bedford was an American Psychology professor whose body was first preserved aft...
Post a Comment
Read more