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

TOP 10 VENOMOUS SNAKES IN THE WORLD

            It’s important to point out here that there’s a difference between   venomous snakes   and   poisonous snakes . Venomous here implies that something is capable of injecting someone or something with Venom, while poisonous implies that it is capable of harming you by merely touching or eating it.    Now let see the rating from 10th to 1st place -  10. Rattle Snake         The Rattle Snake is a sub-family of the pit vipers, it has a very unique tail that makes it easy to be identified. At the end of it’s tail is located the rattle which makes so much noise when shaken, that’s where the name “rattle snake” comes from. Large number of it can be found in America particularly at the south, western part of United States and Mexico. One Striking feature of rattle snake that they possessed from the pit vipers families is that they have two organs that...
Post a Comment
Read more
Alexander Graham Bell, the teacher of the deaf and his deaf wife Alexander Graham Bell. Alexander Graham Bell  (3 March 1847 – 2 August 1922) was an eminent scientist, inventor and innovator who is widely credited with inventing the first practical telephone. Bell was deeply affected by his mother's gradual deafness, (she began to lose her hearing when he was 12) and learned a manual finger language so he could sit at her side and tap out silently the conversations swirling around the family parlour. He also developed a technique of speaking in clear, modulated tones directly into his mother's forehead wherein she would hear him with reasonable clarity. Bell's preoccupation with his mother's deafness led him to study Acoustics (study of all mechanical waves in gases, liquids, and solids including vibration, sound, ultrasound and infrasound). Alexander Graham Bell, his wife Mabel Gardiner Hubbard, and their daughters Elsie (left) an...
Post a Comment
Read more

ORA-30013: undo tablespace 'UNDOTBS1' is currently in use

ORA-30013 is the error reported when the specified Undo tablespace is in use. In other words, this implies there are some background processes still using the undo tablespace.   This error can be reported in both space management or transaction management.   Error ORA-30013 reported while dropping the Undo tablespace.   In this case, the Undo tablespace is used by other active transactions, leading to the error. In such cases, we have to wait until the transactions are committed or rolled back before dropping the Undo tablespace. This situation is similar to that of the ORA-1548 case. Error ORA-30013 reported while bringing up the database.   This happens for RAC databases while the undo tablespace mentioned for an instance is already in use. The solution will be to set separate Undo tablespace for all instances.   Since undo_tablespace is an instance local parameter, we have to ensure that the "Alter system set undo_tablespace" is being invo...
Post a Comment
Read more