Oracle® Database

2.5.1 Installing 11.2.0.4 Oracle Database (Single-Instance)

1. Download the Oracle Database 11.2.0.4 software binaries from the Oracle website or the Oracle Software Delivery Cloud portal (edelivery):

   https://www.oracle.com/in/database/technologies/oracle-database-software-downloads.html

   https://edelivery.oracle.com/

2. Unzip the 11.2.0.4 database binaries.

3. Install Oracle Database 11.2.0.4 (software only):

   https://docs.oracle.com/cd/E11882_01/install.112/e47689/inst_task.htm#LADBI1258

   Note:

   Ignore any linking errors during the installation.

4. Download and apply the DBPSU 11.2.0.4.220118 patch 33477185 from My Oracle Support:

   https://support.oracle.com

   Note:

   • Use OPatch utility version 11.2.0.3.33 or later to apply the DBPSU 11.2.0.4.220118 patch. Oracle recommends that you use the latest released OPatch version for 11g, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release.

   • Ignore the warnings when you apply the DBPSU 11.2.0.4.220118 patch.

5. Download and apply the one-off patch 33991024.

   Note:

   The one-off patch 33991024 will take care of the database linking errors and DBPSU 11.2.0.4.220118 patch warnings.

6. Relink the binaries:

   $ORACLE_HOME/bin/relink all 
   

7. Run Oracle Net Configuration Assistant to configure the listener.

   $ cd $ORACLE_HOME/bin
   $ ./netca
   

8. Start Oracle Database Configuration Assistant (Oracle DBCA) to create a database.

   $ cd $ORACLE_HOME/bin
   $ ./dbca
   

2.5.2 Installing 11.2.0.4 Oracle RAC

1. Download the Oracle Grid Infrastructure 19.3 software binaries from the Oracle website or the Oracle Software Delivery Cloud portal (edelivery):

   https://www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html

   https://edelivery.oracle.com/

2. Perform an Oracle Grid Infrastructure 19c release update 19.14 (19.14.0.0.0) installation:

   https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/installing-oracle-grid-infrastructure-for-a-standalone-server-with-a-new-database-installation.html#GUID-0B1CEE8C-C893-46AA-8A6A-7B5FAAEC72B3

3. Apply the 19.14 release updates (RUs) during the Oracle Grid Infrastructure installation process:

   $ 19.3_grid_home/gridSetup.sh -applyRU 19.14GIRU patch 33509923 location
   

4. Repeat steps 1 to 8 in Installing 11.2.0.4 Oracle Database (Single-Instance) to install 11.2.0.4 Oracle Database. Skip step 7 as you do not need to configure the listener.

2.5.3 Installing 11.2.0.4 Oracle Database Client

1. Download the Oracle Database 11.2.0.4 software binaries from the Oracle website or the Oracle Software Delivery Cloud portal (edelivery):

   https://www.oracle.com/in/database/technologies/oracle-database-software-downloads.html

   https://edelivery.oracle.com/

2. Unzip the 11.2.0.4 database client binaries.

3. Install Oracle Database Client 11g Release 2 (11.2.0.4):

   https://docs.oracle.com/cd/E11882_01/install.112/e24322/inst_task.htm#LACLI1323

4. During the client installation, if you see any linking errors, then perform the workaround suggested in Bug 34175633.

5. For 64-bit client installations, in the Perform Prerequisite Checks screen, for the compat-libstdc++-33-3.2.3 (x86_64) missing check, select Ignore All, and click Install to continue with the client installation.

6. For 32-bit client installations, in the Perform Prerequisite Checks screen, for the libaio, libaio-devel-, libstdc++, libgcc, libstdc++-devel, compat-libstdc++, and pdksh-5.2.14 missing checks, select Ignore All, and click Install to continue with the client installation.

2.5.4 Installing 11.2.0.4 Oracle Database Examples

1. Download the Oracle Database Examples 11.2.0.4 software binaries from the Oracle website or the Oracle Software Delivery Cloud portal (edelivery):

   https://www.oracle.com/in/database/technologies/oracle-database-software-downloads.html

   https://edelivery.oracle.com/

2. Unzip the 11.2.0.4 examples binaries.

3. Install Oracle Database Examples 11g Release 2 (11.2.0.4):

   https://docs.oracle.com/cd/E11882_01/install.112/e24501/toc.htm#BABBIBJF

4. In the Perform Prerequisite Checks screen, for the compat-libstdc++-33-3.2.3 (x86_64) missing check, select Ignore All, and click Install to continue with the examples installation.

2.5.5 Installing 11.2.0.4 Oracle Database Gateways

1. Download the Oracle Database Gateways 11.2.0.4 software binaries from the Oracle website or the Oracle Software Delivery Cloud portal (edelivery):

   https://www.oracle.com/in/database/technologies/oracle-database-software-downloads.html

   https://edelivery.oracle.com/

2. Unzip the 11.2.0.4 gateways binaries.

3. Install Oracle Database Gateways 11g Release 2 (11.2.0.4):

   https://docs.oracle.com/cd/E11882_01/gateways.112/e12013/newoverview.htm#OTGIS100

4. During the Oracle Database Gateways installation, if you get any linking errors, then perform the workaround suggested in Bug 33874848.

2.7.1 Bug 33830284

When you install Oracle Database on Oracle Linux 8.2, the Cluster Verification Utility (CVU) reports compat-libstdc++-33-3.2.3, and pdksh-5.2.14 missing errors.

Workaround:

In the Perform Prerequisites Checks screen, for the above errors, select Ignore All, and click Install to continue with the installation.

2.7.2 Bug 33880702

When you install Oracle Database on Oracle Linux 8, the Cluster Verification Utility (CVU) reports the following error:

Task resolv.conf Integrity, Single Client Access Name (SCAN)
   For all the above following error is shown:
   protocol error: filename does not match request :failed, Cause of problem
not available.

Workaround:

In the Perform Prerequisites Checks screen, for the above errors, select Ignore All, and click Install to continue with the installation.

2.7.3 Bug 33880682

When you perform an Oracle Grid Infrastructure 19c release update 19.14 installation, followed by an Oracle RAC 11.2.0.4 installation, CVU reports the following error:

CRS Integrity, Cluster Manager Integrity, Node Application Existence, Clock
Synchronization, Database Clusterware Version Compatibility
   For all the above following error is shown:
   PRVF-4037: CRS is not installed on any of the nodes.

Workaround:

In the Perform Prerequisites Checks screen, for the above errors, select Ignore All, and click Install to continue with the installation.

2.7.4 Bug 19375887

When you install Oracle Database 11g Release 2 (11.2.0.4) on Oracle Linux 7, the installer reports the following error:

Error in invoking target 'agent nmhs' of makefile
'/home/oracle/obase/11204/dbhome/sysman/lib/ins_emagent.mk'.
See
'/home/oracle/oraInventory/logs/installActions2014-08-06_11-18-42AM.log' for
details.

Workaround:

1. Backup and edit the $ORACLE_HOME/sysman/lib/ins_emagent.mk file.

2. In the ins_emagent.mk file, change $(MK_EMAGENT_NMECTL) to $(MK_EMAGENT_NMECTL) -lnnz11.

3. In the installer, click Retry to complete the installation.

2.7.5 Bug 33879735

When you install Oracle Database Client 32-bit on Oracle Linux 8 with the Red Hat Compatible Kernel, the Cluster Verification Utility reports libaio, libaio-devel-, libstdc++, libgcc, libstdc++-devel, compat-libstdc++, and pdksh-5.2.14 errors.

Workaround:

In the Perform Prerequisites Checks screen, for the above errors, select Ignore All and click Install to continue with the installation.

2.7.6 Bug 34178081

When you install Oracle Database Client 64-bit or Oracle Database Examples on Oracle Linux 8.2, the Cluster Verification Utility reports compat-libstdc++33-3.2.3 (x86_64) error.

Workaround:

In the Perform Prerequisites Checks screen, for the above error, select Ignore All, and click Install to continue with the installation.

2.7.7 Bug 34175633

When you install Oracle Database Client 32-bit or 64-bit on Oracle Linux 8.2, the installer reports linking errors related to libaio.so.

Workaround:

1. Backup and edit the $ORACLE_HOME/lib/sysliblist file.

2. Change -ldl -lm -lpthread -lnsl -lirc -lipgo -lsvml

   to

   -ldl -lm -lpthread -lnsl -lirc -lipgo -lsvml -laio

3. In the installer, click Retry to complete the installation.

2.7.8 Bug 33874848

When you install Oracle Database Gateway 11g Release 2 (11.2.0.4) on Oracle Linux 8.2, the installer reports linking errors related to dg4odbc and dg4adbs.

Perform one of the following workarounds:

Workaround 1

When you encounter the linking error related to libaio.so, perform the following steps:

1. Backup and edit the $ORACLE_HOME//lib/sysliblist file.

2. Change -ldl -lm -lpthread -lnsl -lirc -lipgo -lsvml

   to

   -ldl -lm -lpthread -lnsl -lirc -lipgo -lsvml -laio.

3. In the installer, click Retry to complete the installation.

Workaround 2

When you encounter the linking error related to libcrypt.so.1, perform the following steps:

1. Backup and edit the $ORACLE_HOME//lib/sysliblist file.

2. Change -ldl -lm -lpthread -lnsl -lirc -lipgo -lsvml

   to

   -ldl -lm -lpthread -lnsl -lirc -lipgo -lsvml -laio -lcrypt.

3. In the installer, click Retry to complete the installation.

2.7.9 Bug 34018977

When you perform an Oracle Grid Infrastructure 19c release update 19.15 installation, followed by an Oracle Database 11g Release 2 (11.2.0.4) installation, and then run the cluvfy comp software component verification command, the command reports an error similar to the following:

some files with an unexpected or mismatched permissions on Oracle Database 11.2.0.4 home

Workaround:

Ignore the error.

2.7.10 Disable Oracle ASMFD

Oracle Database 11g Release 2 (11.2.0.4) is incompatible with Oracle ASM Filter Driver (Oracle ASMFD).

To create an Oracle Database 11g Release 2 (11.2.0.4) using Oracle Automatic Storage Management (Oracle ASM) as your storage, disable Oracle ASM Filter Driver (Oracle ASMFD) on your Oracle ASM diskgroup.

If your existing diskgroup has Oracle ASMFD enabled, then create another diskgroup with Oracle ASMFD disabled.

See My Oracle Supporte note 2247658.1 for details:

https://support.oracle.com/rs?type=doc&id=2247658.1

5.1.1 Swap Space Error Message

If you encounter an Oracle Universal Installer error indicating inadequate swap space size, but your swap space meets the requirements listed in the Oracle Database Installation Guide, then you can ignore this error.

This issue is tracked with Oracle bug 7700929.

5.1.2 ODBC Support for SUSE Linux Enterprise Server 11 on Linux x86

You must install the following 32-bit ODBC RPMs on Linux x86 to use ODBC on SUSE 11:

unixODBC-32bit-2.2.12 (32-bit) or later
unixODBC-devel-32bit-2.2.12 (32-bit) or later

5.1.3 ODBC Support for SUSE Linux Enterprise Server 11 on Linux x86-64

You must install the following 32-bit ODBC RPMs on Linux x86-64 to use ODBC on SUSE 11:

unixODBC-2.2.12 or later
unixODBC-devel-2.2.12 or later
unixODBC-32bit-2.2.12 (32-bit) or later 

5.1.4 Back Up grub.conf Before Installing Oracle Grid Infrastructure for a Cluster on Oracle VM

During Oracle Grid Infrastructure installation for a cluster, when rootcrs.pl installs Oracle ACFS in an unprivileged domain running a Xen or Oracle VM kernel, the base Linux driver installation routines may overwrite grub.conf with an incorrect version. Contact Oracle Support if you see the following error message:

# xm create vm.cfg
Using config file "./vm.cfg".
Error: Boot loader didn't return any data!

Workaround:

To prevent this error, follow these steps to copy /boot/grub/grub.conf to a backup, and then restore it after the Oracle ACFS installation.

1. Check for Xen kernel in a domU:

   # uname -r
   

2. Copy grub.conf to backup:

   # cp -a /boot/grub/grub.conf /boot/grub/grub.conf.bak
   

3. Install Oracle ACFS using the root script:

   # rootcrs.pl
   

4. Restore original grub.conf:

   cp -a /boot/grub/grub.conf.bak /boot/grub/grub.conf
   

This issue is tracked with Oracle bug 9268593.

5.2.1 Connection Load Balancing Issue

A single Oracle Database Client can request only a specific Oracle Single Client Access Name (SCAN) listener to connect to a database using SCAN and easy connect method. As a result, load balancing by the DNS round-robin is not available.

Workaround:

Connect to a database using the following configuration, specifying LOAD_BALANCE=on, in the tnsnames.ora file:

ORCL =
  (DESCRIPTION =
    (LOAD_BALANCE=on)
    (ADDRESS = (PROTOCOL = TCP)(HOST = stscan1)(PORT = 1521))
    (CONNECT_DATA =
     (SERVER = DEDICATED)
      (SERVICE_NAME = srv.world)
     )
  )
    

This issue is tracked with Oracle bug 8256753.

5.2.2 Oracle Real Application Clusters Upgrade Error When Upgrading from Release 10.1.0.5 to 11.2

When upgrading from Oracle Database release 10.1.0.5 on Linux x86-64, the following errors may occur in the Database Upgrade Assistant:

ERROR at line 1:

• ORA-00604: error occurred at recursive SQL level 3

• ORA-00060: deadlock detected while waiting for resource

Workaround: Complete the following steps before upgrading to avoid the errors:

1. Before starting the release 11.2 upgrade, purge the dba_recyclebin through SQL*Plus using the following command:

   SQL> purge dba_recyclebin;
   

2. Disable the recycle bin using the following command:

   ALTER SYSTEM set "_recyclebin"=FALSE;
   

3. Perform the upgrade.

4. Enable recycle bin after the release 11.2 upgrade using the following command:

   ALTER SESSION SET recyclebin=ON;
   

This issue is tracked with Oracle bug 8475185.

5.2.3 Error When Installing Oracle Grid Infrastructure with the Grid Naming Service (GNS) and the OCR and Voting Disks Stored on Oracle ASM

When installing Oracle Grid Infrastructure for Oracle Database 11g Release 2 with GNS and the OCR and voting disks on Oracle ASM on Linux x86-64, root.sh may fail with error:

PROT-1: Failed to initialize ocrconfig

The failing command is ocrconfig -upgrade user group, and TNS-12560 can be found in sqlnet log file.

Workaround:

Check the /etc/group entry for the group being used by OCR, temporarily reduce the number of users listed for this group, and restart the installation.

This issue is tracked with Oracle bug 8979500.

5.2.4 Cluster Verification Utility Issue During Oracle Clusterware Upgrade

While upgrading Oracle Clusterware of a previous release to Oracle Grid Infrastructure 11g Release 2 (11.2.0.1.0), Cluster Verification Utility (CVU) may fail if the permission and ownership on the raw devices configured with Oracle Cluster Registry and Voting Disks are incorrect.

Workaround:

Check CVU's output in the installation log file and fix the permissions and ownership on the raw devices. Then, click Retry to run CVU again.

This issue is tracked with Oracle bug 8737732.

5.2.5 RPM Errors with Oracle VM

When Oracle Database is installed on a Linux environment configured with Oracle VM, Oracle Universal Installer may show package check failures, and the RPM command returns the following error:

# rpm
Floating point exception

Workaround:

Upgrade the RPM package to 4.4.2.3 or later.

This issue is tracked with Oracle bug 8626425.

5.2.6 C++ XDK Demos and Pro*C++ Static Demos Linking Error

The C++ XDK demos and Pro*C++ Static demos fail to link with the -lstdc++ library giving the following error on Linux x86-64 with SUSE Linux Enterprise Server 10, SUSE Linux Enterprise Server 11, and Red Hat Enterprise Linux 5:

/usr/lib64/gcc/x86_64-suse-linux/4.1.0/../../../..
/x86_64-suse-linux/bin/ld: cannot find -lstdc++_nonshared

Workaround:

Contact your operating system vendor.

This issue is tracked with Oracle bug 8396301.

5.2.7 Oracle RAC Installation Error on SUSE Linux Enterprise Server 11

The following error occurs while performing an Oracle RAC installation on SUSE Linux Enterprise Server 11:

Error securing Database Control, Database Control has not been brought up on nodes
remote_node(s). Please execute the following command(s) on nodes: remote_node(s).

1) Set the environment variable ORACLE_UNQNAME to Database unique name 
2) /u01/app/aime/product/11.2.0/racdb/bin/emctl config emkey -repos-sysman_pwd Password_for_SYSMAN_user -host node
-sid Database_unique_name
3) /u01/app/aime/product/11.2.0/racdb/bin/emctl secure dbconsole -sysman_pwd Password_for_SYSMAN_user -host node
-sid Database_unique_name 
4) /u01/app/aime/product/11.2.0/racdb/bin/emctl start dbconsole

To secure Em Key, run /u01/app/aime/product/11.2.0/racdb/bin/emctl configemkey -remove_from_repos -sysman_pwd
Password_for_SYSMAN_user

Workaround:

Follow the instructions shown in the error message.

This issue is tracked with Oracle bug 8680497.

5.2.8 Error When Installing Oracle RAC on Oracle Linux 5.0 Update 3

When installing an Oracle RAC on Oracle Linux 5 Update 3, the Perform Prerequisite Checks screen reports Node Connectivity failure.

Workaround:

Check Ignore All to ignore this error and proceed with the installation.

This issue is tracked with Oracle bug 8753154.

5.2.9 Oracle Grid Infrastructure for a Standalone Server Installation Error on SUSE Linux Enterprise Server 10

The root.sh script displays the following error when installing Oracle Grid Infrastructure for a standalone server on SUSE Linux Enterprise Server 10:

/bin/env: Command not found

Workaround:

Ignore this error and proceed with the installation.

This issue is tracked with Oracle bug 8732857.

5.2.10 Oracle Database Reupgrade Issue on Linux x86-64

When you reupgrade Oracle Database release 10.2 to release 11.2, after an initial upgrade to release 11.2 and a subsequent downgrade to release 10.2, the upgrade process hangs at 80% with Database Configuration Assistant. For manual upgrades, the hang may be seen in the spooled log while the c1101000.sql upgrade script is running.

This issue is tracked with Oracle bug 8742500.

5.3.1 Error While Loading Shared Library When SELinux is Enforcing on Oracle Linux 5.x and Red Hat Enterprise Linux 5.x

SQL*Plus and Oracle Call Interface (OCI) program calls fail with SELinux in the Enforcing mode on Oracle Linux 5.x and Red Hat Enterprise Linux 5.x.

Workaround: Shift SELinux to Permissive mode on the system.

This issue is tracked with Oracle bug 9817031.

5.3.2 Insufficient Memory Target Errors

On Linux systems, if the operating system /dev/shm mount size is too small for the Oracle system global area (SGA) and program global area (PGA), then you encounter the following error:

ORA-00845: MEMORY_TARGET not supported on this system. 

The cause of this error is an insufficient /dev/shm allocation. The total memory size of the SGA and PGA, which sets the initialization parameter MEMORY_TARGET or MEMORY_MAX_TARGET, cannot be greater than the shared memory file system (/dev/shm) on your operating system.

Background

Automatic Memory Management (AMM) has been updated in Oracle ASM 11g Release 2. It manages both the SGA and PGA together. It is managed by the Memory Manager Process (MMAN). In this release, note the following changes to AMM:

• It uses MEMORY_TARGET instead of SGA_TARGET

• It uses MEMORY_MAX_TARGET instead of SGA_MAX_SIZE (defaults to MEMORY_TARGET)

• It uses memory allocated by /dev/shm

If the value of max_target is set to a value greater than the allocation for the /dev/shm size, then you may encounter the error ORA-00845: MEMORY_TARGET not supported on this system.

$ df -k 
 
Filesystem 1K-blocks Used Available Use% Mounted on 
shmfs 6291456 832356 5459100 14% /dev/shm

Solution

Increase the /dev/shm mountpoint size.

For example:

# mount -t tmpfs shmfs -o size=7g /dev/shm

To make this change persistent across system restarts, add an entry in /etc/fstab similar to the following:

shmfs /dev/shm tmpfs size=7g 0

5.3.3 Help Files Translation Issue for Spanish and French

Oracle Universal Installer does not copy the translated help files to Oracle home directory when you select the Spanish or French language.

Workaround:

On the Select Product Languages page, select both the Latin American Spanish and Spanish to get the help files translated in Spanish; and select both the Canadian French and French for the translated help files in French.

This issue is tracked with Oracle bug 9147106.

5.3.4 Incorrect Reverse Ping Command from Oracle Management Service

Oracle Management Service provides incorrect reverse ping command with Oracle Enterprise Manager Database Control. The emoms.properties file shows:

emdrep.ping.pingCommand=/usr/sbin/ping6 hostname

Workaround:

Change the property in the emoms.properties file to:

emdrep.ping.pingCommand=/bin/ping -c 3 -w 30 hostname

This issue is tracked with Oracle bug 9211800.

6.1.1 Oracle Unbreakable Enterprise Kernel for Linux

Oracle offers two Linux x86-64 kernels for Oracle Linux 5 Update 5, or Red Hat Enterprise Linux 5 Update 5:

• The Unbreakable Enterprise Kernel optimized for running Oracle software and hardware

• The Red Hat compatible kernel for strict Red Hat compatibility

6.1.2 Multiple Private Interconnects and Oracle Linux

Due to a Reverse Path Filtering bug fix, Oracle RAC and Oracle Exadata systems running kernel 2.6.31 and later require specific settings for the rp_filter parameter. When using multiple NICs for a private interconnect, the interconnect packets may be blocked or discarded if the rp_filter parameter is not set.

Set the rp_filter value for the private interconnects to either 0 (no filtering) or 2 (loose filtering). Do not set the private interconnect NIC to 1 (strict filtering) as it may cause connection issues on the private interconnect. For example, where eth1 and eth2 are the private interconnect NICs, and eth0 is the public network NIC, set the rp_filter of the private address to 2 (loose filtering), the public address to 1 (strict filtering), using the following entries in /etc/sysctl.conf :

net.ipv4.conf.eth2.rp_filter = 2
net.ipv4.conf.eth1.rp_filter = 2
net.ipv4.conf.eth0.rp_filter = 1

Oracle Linux 5.6 (Enterprise Linux 5 Update 6) includes a fix using initscripts-8.45.33-1.0.4.el5.i386.rpm, which sets the kernel parameter net.ipv4.conf.default.rp_filter to 2 (relaxed mode). After you apply Unbreakable Linux Kernel on top of Oracle Linux 5.6, you may not need to make manual changes, because the rp_filter value of all the NICs is set to 2. If you require strict reverse path filtering on the public network, then set the public NIC rp_filter to 1.

https://support.oracle.com

6.2.1 JDBC Connection Timeout Errors

On some servers, applications can encounter JDBC connection timeouts, due to errors with JVM attempting to access /tmp and reading the /dev/random device. This error may have multiple causes relating to hardware or operating system issues.

Workaround:

Contact an Oracle Support Engineer for further information.

This issue is tracked with Oracle bug 6485149.

6.2.2 Oracle Universal Installer Hangs During Oracle Grid Infrastructure Installation on SUSE 10

Due to an issue with the SUSE Enterprise Linux 10 operating system, Oracle Universal Installer may experience intermittent hangs of five to six minutes during Oracle Grid Infrastructure for a Cluster installation.

Workaround:

None. Wait for the hang to resolve, and proceed with the installation.

This issue is tracked with bug 9949520.

6.2.3 Oracle9i Real Application Clusters Upgrade Issue

When using Database Upgrade Assistant to upgrade an Oracle9i Real Application Clusters database to Oracle Database 11g Release 2, the upgrade fails if the Oracle Grid Infrastructure home is non-shared and was configured using the Oracle Grid Infrastructure Configuration Wizard.

Workaround:

1. As a user with root privileges, use the following commands to copy the libcmdll.so and libwddapi.so files to the remote nodes:

   scp grid_user@node1:/etc/ORCLcluster/oracm/lib/libcmdll.so
    /etc/ORCLcluster/oracm/lib
   scp grid_user@node1:etc/ORCLcluster/oracm/lib/libwddapi.so
    /etc/ORCLcluster/oracm/lib
   

   Enter the grid_user password when prompted.

2. Use Database Upgrade Assistant to upgrade Oracle RAC.

This issue is tracked with Oracle bug 10029705.

6.2.4 Missing Events After an Oracle Clusterware Upgrade

If you upgrade Oracle Clusterware or Oracle Grid Infrastructure for a cluster to 11g Release 2 (11.2.0.2), using a rolling upgrade, then Oracle Clusterware may not publish fast application notification (FAN) events and Oracle Enterprise Manager cluster management events on the upgraded clusters.

Workaround:

Perform a rolling restart of the Oracle Clusterware software by running the crsctl stop crs and crsctl start crs commands on each cluster member node in sequence.

This issue is tracked with Oracle bug 10015238.

6.2.5 Installing Predownloaded Software Updates

By default, software updates are downloaded to the /tmp directory. This directory is deleted at the end of an installation. If you do not download and install the software updates during the same installation session, then the software updates are not available.

Workaround:

Specify a new download location for the software updates on the Download Software Updates screen.

This issue is tracked with Oracle bug 9975999.

6.2.6 Square Boxes Appear When Installing on Korean Locale on Red Hat Enterprise Linux 5

When installing on a Korean locale (ko_KR.utf8 or ko_KR.euckr), the characters on the Oracle Universal Installer screens are shown as square boxes.

Workaround:

Create the following symbolic link:

# cd /usr/share/fonts
# ln -s korean ko

This issue is tracked with Oracle bug 9746773.

6.2.7 Required Oracle Grid Infrastructure Patch Set Updates

If you prepare to upgrade Oracle Grid Infrastructure release 11.2.0.1 on Linux x86 and Linux x86_64 by applying patch for bug 9413827, then the rootupgrade.sh script for Oracle Grid Infrastructure release 11.2.0.2 displays the following error:

The fixes for bug 9413827 and 9706490 are not present in the 11.2.0.1 crs home.
Apply the patches for these bugs in the 11.2.0.1 crs home and then run 
rootupgrade.sh

Workaround

Apply patch 9655006 to the 11.2.0.1 Grid home before upgrading to 11.2.0.2.

This issue is tracked with Oracle bug 10036834.

6.2.8 Oracle Database Vault Administrator Login Issues

While trying to log in to Oracle Database Vault Administrator, you may get the following error:

java.security.NoSuchProviderException: no such provider: SUN 

Workaround:

Use any one of the following workarounds to configure the Database Vault policy:

• Connect to the 11.2.0.2 Linux Database Vault enabled database using the 11.2.0.1 Oracle Database Vault Administrator from any platform.

• Use Database Vault administrative packages.

This issue is tracked with Oracle bug 10188865.

6.3.1 Oracle Notification Service Issue Associated With Physical Memory

The Oracle Notification Service server may occasionally fail on Linux x86-64 systems with 32 GB of physical memory. The Oracle Notification Service server is immediately restarted, and no action is required of an administrator.

This issue is tracked with Oracle bug 9203989.

6.3.2 SQL Developer Fails to Start on IBM: Linux on System Z

SQL Developer might fail to start and the following error message appears:

Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path
will be stored in ~/.sqldeveloper/jdk

Workaround:

Download the latest version of SQL Developer from the Oracle Technology Network (OTN) website and start SQL Developer pointing to the appropriate JRE:

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

This issue is tracked with Oracle bug 10339897.

6.3.3 Required Oracle Warehouse Builder Patches on IBM: Linux on System Z

If you plan to install Oracle Warehouse Builder, then after you install Oracle Database, but before you create the Oracle Warehouse Builder repository, you must complete the following procedure:

1. Download patch 12326108 from the My Oracle Support website.

2. Extract the contents to a directory, for example, /tmp/12326108.

3. Verify that the ORACLE_HOME environment variable is set to the 11.2.0.2 Database home.

4. Run the Opatch utility to proceed with the Oracle Warehouse Builder installation:

   cd /tmp/12326108
   opatch apply
   

5. Navigate to $ORACLE_HOME/owb/patches/bug12326108.

6. Run the script, fix_bug12326108.sh.

7. Edit the following files:

   OMBPlus.sh

   Add the following line at line 15, under the s390 entry:

   s390x) OPTS="-Xdisableexplicitgc";;
   

   Add the -d64 entry to the following line:

   $JAVAPATH/bin/java $JAVA64FLAG -Xms64M -Xmx768M...
   

   reposinst.sh

   Add the -d64 entry to the following line:

   $JAVAPATH/bin/java $JAVA64FLAG -Xms128m -Xmx1024m...
   

   run_service.sh.orig

   Add the -d64 entry to the following line:

   $JAVAPATH/bin/java $JAVA64FLAG -Xmx768M...
   

   setowbenv.sh

   Add $ORACLE_HOME/lib to the clsspath line:

   CLASSPATH_LAUNCHER="-classpath ../admin:../admin/launcher.jar:$ORACLE_HOME/lib:$CLASSPATH:...
   

8. After you have edited the files, you can install Oracle Warehouse Builder.

This issue is tracked with Oracle bugs 11772716 and 11934843.

7.2.1 Square Boxes Appear When Installing on Korean Locale on Red Hat Enterprise Linux 5

When installing on a Korean locale (ko_KR.utf8 or ko_KR.euckr), the characters on the Oracle Universal Installer screens are shown as square boxes.

Workaround:

Create the following symbolic link:

# cd /usr/share/fonts
# ln -s korean ko

This issue is tracked with Oracle bug 9746773.

7.2.2 JDBC Connection Timeout Errors

On some servers, applications can encounter JDBC connection timeouts, due to errors with JVM attempting to access /tmp and reading the /dev/random device. This error may have multiple causes relating to hardware or operating system issues.

Workaround:

Contact an Oracle Support Engineer for further information.

This issue is tracked with Oracle bug 6485149.

7.2.3 Offline Services After Completing a Shared Home Upgrade

After upgrading a shared home Oracle Clusterware from an earlier release to Oracle Clusterware release 11.2.0.3, you may encounter offline service errors.

Workaround:

Use the command crsctl start res from the Grid_home/bin directory to start offline service resources. For example, if the service resource that is offline is ora.orcldb.srv2.orcldb4.srv, then enter the following command:

# cd /u01/app/grid/11203/bin
# ./crsctl start res ora.orcldb.srv2.orcldb4.srv

This issue is tracked with Oracle bug 12844130.

7.3.1 Java-Based Tools Issue on Oracle Linux 6 and Red Hat Enterprise Linux 6

Java-based tools such as Oracle Universal Installer, Oracle Database Configuration Assistant, and Oracle Enterprise Manager Configuration Assistant cannot display non-English multibyte character language messages on Oracle Linux 6 (32-bit and 64-bit) and Red Hat Enterprise Linux 6. For example, languages like Japanese, Chinese, Korean, and so on, are not displayed by the Java-based tools on Oracle Linux 6 (32-bit and 64-bit) and Red Hat Enterprise Linux 6.

Workaround:

Download patch 12991286 from the My Oracle Support website and follow the instructions in the README file.

This issue is tracked with Oracle bug 12991286.

7.3.2 Issues While Running Asynchronous I/O on Red Hat Enterprise Linux 5 Update 6

If you are using Red Hat Enterprise Linux 5 Update 6 or later with kernel version 2.6.18-238 or later, then the I/O to Oracle Cluster File System 2 may hang due to a Red Hat kernel bug. This issue does not occur with Oracle Linux kernels.

Workaround:

Contact Red Hat for a fix.

This issue is tracked with Oracle bug 12725273.

7.3.3 Required Oracle Warehouse Builder Patches on IBM: Linux on System Z

If you plan to install Oracle Warehouse Builder, then after you install Oracle Database, but before you create the Oracle Warehouse Builder repository, you must complete the following procedure:

1. Download patch 12973496 from the My Oracle Support website.

2. Extract the contents to a directory, for example, /tmp/12973496.

3. Verify that the ORACLE_HOME environment variable is set to the 11.2.0.2 Database home.

4. Run the Opatch utility to proceed with the Oracle Warehouse Builder installation:

   cd /tmp/12973496
   opatch apply
   

5. Navigate to $ORACLE_HOME/owb/patches/bug12973496.

6. Run the script, fix_bug12973496.sh.

7. After you have edited the files, you can install Oracle Warehouse Builder.

This issue is tracked with Oracle bugs 11772716.

7.3.4 Issues While Deleting Oracle RAC on Linux on System Z

While deleting Oracle RAC, you may see an unhandled exception error if Oracle ASM disk group is used for storage. However, the database is deleted.

Workaround:

For Oracle ASM Configuration Assistant (ASMCA)

Use the following command instead of using ASMCA to dismount the disk group on all the nodes:

srvctl stop diskgroup -g diskgroup

For Database Configuration Assistant (DBCA)

Stop the database before running the DBCA to delete the database:

srvctl stop database -d db_unique_name

This issue is tracked with Oracle bug 13371048.

8.2.1 Square Boxes Appear When Installing on Korean Locale on Red Hat Enterprise Linux 5

When installing on a Korean locale (ko_KR.utf8 or ko_KR.euckr), the characters on the Oracle Universal Installer screens are shown as square boxes.

Workaround:

Create the following symbolic link:

# cd /usr/share/fonts
# ln -s korean ko

This issue is tracked with Oracle bug 9746773.

8.2.2 Oracle Universal Installer Error When psmisc Package is Not Installed

When installing Oracle Database Client for 11g Release 2 (11.2.0.4), if the psmisc package is not installed, Oracle Universal Installer shows the following error message:

[INS-30071] An error occured while trying to determine the running processes or services

Workaround:

Install the psmisc package before the Oracle Database Client installation.

This issue is tracked with Oracle bug 19460475.

8.2.3 Oracle Grid Infrastructure Installation Issue

During the Oracle Grid Infrastructure installation, you must apply patch 18370031 before configuring the software that is installed. The timing of applying the patch is important and is described in detail in the Note 1951613.1 on My Oracle Support. This patch ensures that the clusterware stack is configured to use systemd for clusterware processes, as Oracle Linux 7 uses systemd for all services.

This issue is tracked with Oracle bug 18370031, which was logged for release 12.1.0.2, but the patch is for release 11.2.0.4.

8.2.4 Error During Oracle Database Installation on Oracle Linux 7

When installing Oracle Database 11g Release 2 (11.2.0.4) on Oracle Linux 7 and Red Hat Enterprise Linux 7, Oracle Universal Installer shows the following error message:

Error in invoking target 'agent nmhs' of makefile

When creating the database, the following error occurs:

Error securing Database Control

Workaround:

Apply patch 19692824 to the Database home. For additional information about how to apply the patch and when to apply the patch, refer to Note 1951613.1 on My Oracle Support (formerly OracleMetaLink) at

https://support.oracle.com

This issue is tracked with Oracle bug 19692824.

8.2.5 Locale Issue with SUSE Linux Enterprise Server 11 on IBM: Linux on System Z

When you run Java GUI applications, such as Oracle Universal Installer, Database Configuration Assistant, or Database Upgrade Assistant, with SUSE Linux Enterprise Server 11 on a Simplified Chinese, Traditional Chinese, Japanese, or a Korean locale, the characters show as square boxes.

Workaround:

Run the Java GUI applications on an English locale with SUSE Linux Enterprise Server 11.

This issue is tracked with Oracle bug 17075895.

8.2.6 Missing Package Error During Oracle Database Installation on Oracle Linux 7

During Oracle Database 11.2.0.4 installation on Oracle Linux 7, the Oracle Universal Installer reports a missing pdksh-5.2.14 package.

Workaround:

Ignore the missing pdksh-5.2.14 package error and proceed with the installation.

This issue is tracked with Oracle bug 19947777.

8.3.1 Java-Based Tools Issue on Oracle Linux 6 and Red Hat Enterprise Linux 6

Java-based tools such as Oracle Universal Installer, Oracle Database Configuration Assistant, and Oracle Enterprise Manager Configuration Assistant cannot display non-English multibyte character language messages on Oracle Linux 6 (32-bit and 64-bit) and Red Hat Enterprise Linux 6. For example, languages like Japanese, Chinese, Korean, and so on, are not displayed by the Java-based tools on Oracle Linux 6 (32-bit and 64-bit) and Red Hat Enterprise Linux 6.

Workaround:

Download patch 12991286 from the My Oracle Support website and follow the instructions in the README file.

This issue is tracked with Oracle bug 12991286.

8.3.2 Time Zone Issue with Oracle Linux 6

When Oracle Grid Infrastructure is installed on Oracle Linux 6, the logs may show incorrect time zone information if the system Timezone string contains a space. Check the /etc/sysconfig/clock file.

Workaround:

You must use the following workaround on the local node (the node on which Oracle Universal Installer is running) of a cluster before starting the Oracle Grid Infrastructure installation:

Modify the /etc/sysconfig/clock file to replace any space with an underscore (_) in the time zone name. For example, Los_Angeles instead of Los Angeles.

Oracle recommends that you apply this workaround on all the nodes of a cluster so that if Oracle Universal Installer is run at a later time from any other node, the time zone is correctly calculated.

8.3.3 Linux Kernel Issue

Due to a bug in Linux version 2.6.39, after a system failure or an offline Oracle ACFS, if the system dirty page ratio is not high enough to trigger a flush using the dirty_background_ratio tunable parameter, then unexpected loss of data or extraneous data may occur at the ends of Oracle ACFS files that cached data at the time of the system failure or the offline Oracle ACFS.

Workaround:

Refer to the Unbreakable Enterprise Kernel 2.6.39 Errata, kernel version 2.6.39-400.5, for more information regarding the fix.

This issue is tracked with Oracle bug 16981677.

8.3.4 Required Oracle Warehouse Builder Patches on IBM: Linux on System Z

If you plan to install Oracle Warehouse Builder, then after you install Oracle Database, but before you create the Oracle Warehouse Builder repository, you must complete the following procedure:

1. Download patch 17498179 from the My Oracle Support website.

2. Extract the contents to a directory, for example, /tmp/17498179.

3. Verify that the ORACLE_HOME environment variable is set to the 11.2.0.4 Database home.

4. Run the Opatch utility to proceed with the Oracle Warehouse Builder installation:

   cd /tmp/17498179
   opatch apply
   

5. Navigate to $ORACLE_HOME/owb/patches/bug17498179.

6. Run the script, fix_bug17498179.sh.

7. After you have edited the files, you can install Oracle Warehouse Builder.

This issue is tracked with Oracle bugs 11772716.

8.3.5 Oracle Universal Installer Issue on Oracle Linux 7 and Red Hat Enterprise Linux 7

On Oracle Linux 7 (64-bit) and Red Hat Enterprise Linux 7, certain tools such as Oracle Universal Installer, Oracle Database Configuration Assistant, and Oracle Enterprise Manager Configuration Assistant cannot display the non-English multibyte character language messages. For example, languages such as Japanese, Chinese, and Korean are not displayed by these tools on Oracle Linux 7 (64-bit) and Red Hat Enterprise Linux 7.

Workaround:

Run the following commands for the Japanese language:

mkdir /usr/share/fonts/japanese/TrueType
cd /usr/share/fonts/japanese/TrueType
ln -s /usr/share/fonts/wqy-zenhei/wqy-zenhei.ttc sazanami-gothic.ttf

Run the following commands for the Chinese language:

mkdir /usr/share/fonts/chinese/TrueType
cd /usr/share/fonts/chinese/TrueType
ln -s /usr/share/fonts/wqy-zenhei/wqy-zenhei.ttc uming.ttf

Run the following commands for the Korean language:

mkdir /usr/share/fonts/korean/TrueType
cd /usr/share/fonts/korean/TrueType
ln -s /usr/share/fonts/wqy-zenhei/wqy-zenhei.ttc gulim.ttf

Next, start Oracle Universal Installer.

This issue is tracked with Oracle bug 19381563.