Oracle® Database

3.1 Pro*C/C++ Requirement

Pro*C/C++ is also supported with the Microsoft Visual C++ .NET 2002 7.0 and Microsoft Visual C++ .NET 2003 7.1 compilers.

4.1 Adding or Deleting an Instance Using Oracle Enterprise Manager Displays an Error

An error message is displayed if you add or delete an instance in the following scenarios:

• You add or delete an instance using Oracle Enterprise Manager from a new cluster on which you have never installed Oracle

• You start the process of adding or deleting an instance from a node other than the one where you initially started the process

The error message displayed is similar to the following error message:

Error -Error getting a return value: The inventory pointer location
/var/opt/oracle/oraInst.loc is either not readable or does not exist
Operation Failed. Refer logs at ...

Workaround: Complete one of the following procedures to address this issue:

• On each node of the cluster, run commands similar to the following:

  SYSTEM_DRIVE:> cd CRS_home\oui\bin
  SYSTEM_DRIVE:> attachhome -silent -local "CLUSTER_NODES={comma_separated_node_list_of_this_cluster}
  
  

• On each node of the cluster:

  1. Run a command similar to the following command:

     SYSTEM_DRIVE:> cd CRS_home\oui\bin
     
     

  2. Start Oracle Universal Installer by running the setup.exe command.

  3. On the Welcome page, click Next.

  4. Exit from Oracle Universal Installer.

  Note:

  This issue is not observed if you already have an Oracle installation, such as Oracle Database, Oracle Management Agent, and so on, on the node.

This issue is tracked with Oracle bug 6603930.

4.2 Configuring Automatic Storage Management Disk Groups

During Automatic Storage Management configuration, the Configure Automatic Storage Management dialog is displayed. The dialog prompts you to enter a new discovery path for discovering Automatic Storage Management disks by clicking Change Disk Discovery Path. On Windows Vista, you cannot use the asterisk (*) wild card character for the new discovery path. For example, using the C:\\.\ORCLDISK* path is not supported. You have to provide a comma separated list of disk paths, such as C:\\.\ORCLDISK0,C:\\.\ORCLDISK1,C:\\.\ORCLDISK2. Additionally, ensure that there are no embedded spaces in the discovery path.

On other Windows operating systems, the asterisk (*) wild card is supported and handled appropriately in Oracle Universal Installer, during Automatic Storage Management disk selection, and in passing the new discovery path to Oracle Database Configuration Assistant. However, due to a behavioral change in Windows Vista, the selection appears to succeed during Oracle Universal Installer disk selection, but Oracle Database Configuration Assistant fails and displays the Invalid command line argument message. This is because the Windows Vista command processor (cmd) expands the wild card character (*), even when present within a double quoted string in a command line argument. The new discovery path is passed to Oracle Database Configuration Assistant as a double quoted string and as a result it fails.

This issue is tracked with Oracle bug 6373662.

4.3 Error When Installing Oracle Database 11g Enterprise Edition on Windows Vista

When installing Oracle Database 11g Enterprise Edition on Windows Vista, if you fill in the Oracle home name and click Next, and then click Back because you want to change the Oracle home name, an error message is displayed. If you continue by clicking OK on the error dialog box, the installation will proceed but the prerequisite check will be skipped. This may lead to other errors.

Workaround: Exit the installation process and restart it instead of proceeding through the error dialog box.

This issue is tracked with Oracle bug 6449586.

4.4 Nmefwmi Crashes on Windows Vista

Nmefwmi crashes on Windows Vista with the following popup message:

nmefwmi.exe has crashed.

or displays a metric collection error on the Network Interfaces metric and Windows Events Log metric with the following message:

Command exited abnormally without any output.

Workaround: Disable the Network metric and Windows Event Log metric temporarily by following these steps:

Network Metric:

1. Navigate to Host home page.

2. Click Metric and Policy Settings.

3. On the Metric Thresholds tab, select All metrics from the View list.

4. In the Network Interface Combined Utilization row, click the link in the Collection Schedule column.

5. Click Disable.

6. Click Continue and then click OK.

   This will remove the metric collection error in 5 to 10 minutes.

Windows Events Log Metric:

1. Navigate to Host home page.

2. Click Metric and Policy Settings.

3. On the Metric Thresholds tab, select All metrics from the View list.

4. In the System row, click the link in the Collection Schedule column.

5. Click Disable.

6. Click Continue and then click OK.

   This will remove the metric collection error in 5 to 10 minutes.

This issue is tracked with Oracle bug 6596234.

4.5 Error When Removing Oracle Configuration Manager

When you run the deployPackages -d ORACLE_BASE\ORACLE_HOME\ccr\inventory\core.jar command to remove Oracle Configuration Manager, the following message is displayed:

The batch file cannot be found.

This message indicates that the Oracle Configuration Manager service has been removed. To complete the removal of Oracle Configuration Manager, run the following command

SYSTEM_DRIVE:> rmdir /s/q ORACLE_BASE\ORACLE_HOME\ccr

This issue is tracked with Oracle bug 5982610.

4.6 Incorrect Port Number Registered for the New Node

When you run the crssetup.add.bat batch file to add another node, incorrect port number is registered for the new node.

Workaround: Complete the following procedure to resolve this issue:

1. After running the crssetup.add.bat batch file, ignore the error messages similar to the following error message:

   Starting ONS application resource on (*) nodes1:CRS-0215: Could not start resource 'ora.*.ons'
   
   

2. Use the following command to stop the nodeapps service on all the newly added nodes:

   srvctl stop nodeapps -n node
   
   

3. Use the following command to delete the existing ONS port number registration:

   racgons remove_config node:4948
   
   

4. Use the following command to add an ONS port number:

   racgons add_config node:remote_port
   
   

5. Use the following command to start the nodeapps service on all the newly added nodes:

   srcvtl start nodeapps -n node
   
   

This issue is tracked with Oracle bug 6410914.

4.7 Multiple Oracle Home Support

Oracle Database supports multiple Oracle homes. This means that you can install this release or previous releases of the software more than once on the same system, in different Oracle home directories. This enables flexibility in deployment and maintenance of the database software. For example, it enables you to run different versions of the database simultaneously on the same system, or it enables you to upgrade specific database or Automatic Storage Management instances on a system without affecting other running databases.

You must install Oracle Database 11g into a new Oracle home directory. You cannot install products from one release of Oracle Database into an Oracle home directory of a different release. For example, you cannot install Oracle Database 11g Release 1 (11.1) software into an existing Oracle9i Oracle home directory. If you attempt to install this release into an Oracle home directory that contains software from an earlier Oracle release, the installation fails.

You can install this release more than once on the same system as long as each installation is installed in a separate Oracle home directory.

4.8 Oracle Text User_Filter Executable Directory Change

In Oracle Database 11g, the executables for USER_FILTER should exist in the ORACLE_BASE\ORACLE_HOME\ctx\bin directory. Therefore, after upgrading an earlier version of Oracle Database to Oracle Database 11g, you need to run the following SQL commands as the SYS, SYSTEM, or CTXSYS user to display the list of USER_FILTER executables:

SQL> select ixv_value
SQL> from ctxsys.ctx_index_values
SQL> where ixv_class = 'FILTER'
SQL> and ixv_object = 'USER_FILTER'
SQL> and ixv_attribute = 'COMMAND';

Copy the displayed executables from the ORACLE_BASE\ORACLE_HOME\bin directory to the ORACLE_BASE\ORACLE_HOME\ctx\bin directory.

This issue is tracked with Oracle bug 6269811.

4.9 Oracle Universal Installer Displays Single Instance Install Option on Oracle RAC

If Oracle Clusterware is installed on servers that have not had previous Oracle installations, and you start to install Oracle RAC on a cluster node other than the node on which you installed Oracle Clusterware, then Oracle Universal Installer displays a single-instance Oracle Database installation screen instead of an Oracle RAC installation screen.

This issue appears when you perform the following procedure, where node_1 is the node on which you install Oracle Clusterware, and node_n is another node in the cluster:

1. Install Oracle Clusterware from node_1.

2. After Oracle Clusterware install, start an Oracle RAC database install from node_n.

3. Oracle Universal Installer displays the Select a Product to Install screen. Select Oracle Database 11g, and click Next.

4. Oracle Universal Installer displays the Select Installation Method screen with Basic/Advanced Installation options. This is specific to single instance installation. For Oracle RAC installation, the Select Installation Type screen should have been displayed.

Workaround: Continue with the installation by selecting Advanced Installation and clicking Next. Oracle universal Installer displays the Select Installation Type screen. Proceed with the rest of the Oracle RAC installation, as usual.

This issue is tracked with Oracle bug 6527941.

4.10 Registry and Service for Oracle Database Enterprise Manager Database Control is not Created on Remote Node

When running Database Upgrade Assistant, registry and service for Oracle Database Enterprise Manager Database Control is not created on the remote node.

Workaround: You must close Service Control Manager window when installing Oracle Clusterware, Oracle Database, and running Database Upgrade Assistant.

This issue is tracked with Oracle bug 6499676.

4.11 Rolling Upgrade Displays an Error Message

When doing a rolling upgrade of Oracle Clusterware from earlier version to Oracle Database 11g, the Oracle Universal Installer prerequisite checks displays an error message when checking the status of Oracle Synchronization Service. This is an expected error message.

The message indicates that you must shutdown services on all the nodes. However, you only need to shutdown the services on the node(s) on which you are performing upgrade.

This issue is tracked with Oracle bug 6152450.

4.12 Storing Oracle Net Names And/Or Enabling Authenticated Binds Fail Using Active Directory on Windows Vista

Oracle Enterprise Manager, Oracle Net Configuration Assistant, and Oracle Net Manager cannot be used on a Windows Vista computer to configure Oracle Net Naming with Active Directory. Use another version of Microsoft Windows to configure Oracle Net naming with Active Directory at this time.

Active Directory Authenticated Name Lookup does not work from Oracle database clients running on Windows Vista. In a typical Oracle installation, no client-side configuration change is required. However, if Active Directory is configured to disallow anonymous binds for Oracle Net name lookup, Net name lookups from Windows Vista clients fail.

This issue is tracked with Oracle bug 6249895.

4.13 The Prerequisite Checker Deployment Procedure Reports Incorrect Results

When you run the Prerequisite Checker Deployment procedure from Oracle Enterprise Manager Database Console, the procedure displays that the Check Active Files and Executables check has failed. However, on Windows Vista, the procedure reports that the check has passed.

Workaround: Ignore the result of this check and consider it as failed.

This issues is tracked with Oracle bug 6215909.

4.14 Upgrading Oracle Clusterware from Oracle Database 10g (10.x)

When you upgrade Oracle Clusterware from an Oracle Database 10g release (10.x), the OPMD service is not created.

Workaround: After completing the upgrade process, run the following command from the CRS_home\bin directory on each node:

opmd -install

This issue is tracked with Oracle bug 6416092.

4.15 Warning Message is Displayed When ORACLE_HOME Refers to a Non-Existent Directory

When the ORACLE_HOME environment variable refers to a directory that does not exist, Oracle Universal Installer displays a warning message about a non-empty home directory when you click Next on the Install Location screen.

This is a benign message that you can ignore and continue with the install. This message is displayed when you have Oracle Database 11g Clusterware installed on the machine.

This issue is tracked with Oracle bug 6160525.

4.16 Installation, Configuration, and Upgrade Issues on Windows 32-Bit

The following are the Windows 32-bit specific issues that affect Oracle Database installation, configuration, and upgrade:

• Install Error: The Application Fails to Install Because the MSVCRTD.dll File is Missing

• The runcluvfy.bat File Fails to Run From the Root of the DVD Media

• The srvctl Utility and Oracle Database Upgrade Assistant Fail to Start or Stop Oracle9i RAC Databases

Install Error: The application fails to install because the MSVCRTD.dll file is missing. Re-installing the application may fix this problem.

The network path was not found.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.

PRKP-1006 : Failed to shut down cluster database database_name
     ORA-01031: insufficient privileges
     ORA-01005: null password given; logon denied
     ORA-01031: insufficient privileges
     ORA-01005: null password given; logon denied

CRS_home\bin\olsnodes

4.17 Installation, Configuration, and Upgrade Issues on Windows x64

The following are the Windows x64 specific issues that affect Oracle Database installation, configuration, and upgrade:

• Error When Adding Node to Oracle RAC

• ODBC Driver Setup Dialog Box Does not Work as Desired

• Oracle Configuration Manager May Fail

• The oradim.exe Application May Fail on Windows Vista When Deleting Non-Existing Oracle Services

Error while copying directory C:\app\oracle\product\11.1.0\db_1 with exclude file 
ist'C:\DOCUME~1\oracle\LOCALS~1\Temp\1\OraInstall2007-04-01_08-00-09PM\installExcludeFile.lst' to nodes 'nodes_being_added'.
[PRKC-1073 : Failed to transfer directory "C:\app\oracle\product\11.1.0\db_1" to any of the given nodes "nodes_being_added". 
Error on node nodes_being_added:Access denied]
Refer to 'C:\Program Files\Oracle\Inventory\logs\addNodeActions2007-04-01_08-00-09PM.log'
for details. You may fix the errors on the required remote nodes. 
Refer to the install guide for error recovery. Click 'Yes' if you want 
to proceed. Click 'No' to exit the install. Do you want to continue?

5.1 Database Resident Connection Pooling

When using Database Resident Connection Pooling on Windows, disable Windows native authentication for the clients that connect to pooled servers. Ensure that sqlnet.authentication_services parameter does not have NTS set for these clients. Pooled servers do not support NTS authentication, so there is no loss in functionality for these clients.

This issue is tracked with Oracle bug 6183123.

5.2 Exporting an Encrypted Table Fails

If you export an encrypted table, an error message is displayed.

This issue is tracked with Oracle bug 6324760.

5.3 Importing an Encrypted Table Fails

If you import an encrypted table, an error message is displayed.

This issue is tracked with Oracle bug 6326362.

5.4 Oracle Database Gateway for Websphere MQ

The deployment script file pgmobj.sql located in the Gateway_Home\admin\deploy directory contains incorrect database link and library names. These incorrect names result in the malfunctioning of the gateway. You can detect this issue if the ORA-28509 error message is displayed and no gateway trace files are generated.

Workaround: To resolve this issue, make the following changes to the pgmobj.sql script:

1. Replace all the database link names pg4mqdepdblink with dg4mqdepdblink.

2. Replace all the library names libpg4mq with libdg4mq.

Save the pgmobj.sql script and follow the instruction available in the gateway manual to run the script. To run the script, use SYS user as SYSDBA in SQL*Plus on the Oracle database that needs access to the gateway.

This issues is tracked with Oracle bug 6448585.

5.5 Oracle VSS Writer Service is not Available After Upgrade

When you upgrade Oracle9i or Oracle Database 10g to Oracle Database 11g on Windows Server 2003, Oracle VSS Writer Service is not available in the upgraded database. If you want to make a backup of an Oracle database using Windows VSS infrastructure, then you must start Oracle VSS Writer Service.

Workaround: Use the following command to create Oracle VSS Writer Service:

SYSTEM_DRIVE:> oravssw ORACLE_SID /i

When you run this command, Oracle VSS Writer Service is created under Local System account. Using the Services icon in the Control panel, you must change the service to be run as a user account that has SYSDBA privilege using operating system authentication. This means that the user should be a member of ORA_DBA group.

This issue is tracked with Oracle bug 6496376.

5.6 Permission Denied When Oracle Database Configuration Assistant is Run on Non-Shared Oracle Home

If you run Oracle Database Configuration Assistant to install Automatic Storage Management with shared Oracle base and non-shared Oracle home, an error message stating permission denied is displayed.

Workaround: This is a benign message. Click OK to continue and complete the installation process. The Automatic Storage Management is created successfully.

This issue is tracked with Oracle bug 6327383.

5.7 Reactivate the OC4JADMIN User for Oracle Ultra Search

The OC4JADMIN user is deactivated during the Oracle Database 11g installation process. After the installation is complete, you must modify the ORACLE_BASE\ORACLE_HOME\oc4j\j2ee\OC4J_SEARCH\config\system-jazn-data.xml file. Replace the following content of the file:

<user deactivated="true">
<name>oc4jadmin</name>
<display-name>OC4J Administrator</display-name>
<description>OC4J Administrator</description>

with:

<user>
<name>oc4jadmin</name>
<display-name>OC4J Administrator</display-name>
<description>OC4J Administrator</description>

Use the following commands to restart the Oracle Ultra Search middle tier in the Oracle Database:

System_Drive:>ORACLE_BASE\ORACLE_HOME\bin\searchctl stop
System_Drive:>ORACLE_BASE\ORACLE_HOME\bin\searchctl start

5.8 Other Known Issues on Windows 32-Bit

The following is the Windows 32-bit specific known issue related to Oracle Database 11g and associated products:

• Compilation Error in Five XDKCPP Demonstration Files

#include <iostream>
using namespace std;

5.9 Other Known Issues on Windows x64

The following are the Windows x64 specific known issue related to Oracle Database 11g and associated products:

• Limitations with ODP.Net

• Support Only for Microsoft .Net Framework 2.0

• The sqldveloper.exe Application is not Supported

6.1 Scheduler Agent Installation on Windows

The "Installing and Configuring the Scheduler Agent" section of Chapter 28, "Administering Oracle Scheduler" in Oracle Database Administrator's Guide states that you need to use the schagent -installagentservice command to install the OracleSchedulerExecutionAgent service before starting the Scheduler agent. However, the service is installed and started automatically during the installation process. Therefore, no additional step is required.

This issue is tracked with Oracle bug 6431812.

6.2 The ocopy.exe Utility is not Installed in CRS_Home

In Oracle Clusterware Installation Guide for Microsoft Windows, you are instructed to make a backup of the contents of the voting disk by using the ocopy.exe utility after the Oracle Clusterware installation is complete. However, the ocopy.exe utility is not installed in the CRS_home. You should either use the ocopy.exe utility available in the database ORACLE_HOME, or use another utility to make the backup.

This issue is tracked with Oracle bug 6336685.