Oracle® Database

Silent Installations that Use Automatic Storage Management

You cannot use the silent installation method to install Oracle Database 10g and create a database that uses Automatic Storage Management (ASM) for database storage during the same installation. This is because the root.sh script must run before the Database Configuration Assistant (DBCA) can start an ASM instance.

If you want to use the silent installation method to install Oracle Database 10g and create a database that uses ASM, follow these steps:

1. Use the enterprise.rsp response file to complete a software-only installation.

2. Run $ORACLE_HOME/root.sh after the installation completes.

3. Use the dbca.rsp response file to run DBCA in silent mode, using a command similar to the following:

   $ $ORACLE_HOME/bin/dbca -silent -responseFile /full_path/dbca.rsp
   

Upgrading a Database

If you choose the Custom installation path and have previous versions of Oracle databases installed, then the Oracle Universal Installer gives you the option of upgrading the existing databases. If you choose to upgrade an existing database, the Oracle Universal Installer displays another screen asking whether you want to create a starter database.If you choose to create a starter database, the DBCA upgrades the older version of the database to Oracle Database 10g release 1 (10.1), but does not create a starter database.

Upgrading from Oracle8i Release 8.1.7 to Oracle Database 10g

To upgrade Oracle8i release 8.1.7 to Oracle Database 10g:

1. Back up the Oracle8i installation and database.

2. If your hardware supports Solaris 9, upgrade the operating system to this version.

   If your hardware does not support Solaris 9, you cannot run Oracle Database 10g on this system. Instead, you must use the Export/Import utilities to migrate the database to a system that does support Solaris 9.

3. Install Oracle Database 10g, release 1 (10.1.0.3).

4. Use Database Upgrade Assistant to upgrade the database to Oracle Database 10g, release 1 (10.1.0.3).

extjob Executable Required Directory Permissions

To enable the extjob executable to locate required libraries, the /oracle_home/lib directory and all of its parent directories must have execute permissions for group and other.

Enabling Automated Backups

While installing Oracle Database, the Specify Backup and Recovery Options screen may appear truncated if your system does not have the required fonts installed. If your system has only fixed-width fonts, you may not be able to fully specify the required information in the Backup Job Credentials area of the screen. To work around this issue, do not select Enable Automated Backups on this screen. After the installation is complete, use the Oracle Enterprise Manager 10g Database Control to enable automated backups.

ASM Instance Clean Up Procedures for Node Deletion

To remove the ASM instances, the delete node procedure requires the following additional steps on UNIX-based systems:

1. If this is the Oracle home from which the per-node listener named LISTENER_nodename runs, then use NetCA to remove this listener and its CRS resources. If necessary, re-create this listener in another Oracle home.

2. If this is the Oracle home from which the ASM instance runs, then enter the following commands to remove the ASM configuration:

   $ srvctl stop asm -n node
   $ srvctl remove asm -n node
   
   

3. If you are using a cluster file system for your ASM Oracle home, then run the following commands on the local node:

   $ rm -r $ORACLE_BASE/admin/+ASM
   $ rm -f $ORACLE_HOME/dbs/*ASM*
   
   

4. If you are not using a cluster file system for your ASM Oracle home, then run the rm commands listed in the previous step on each node on which the Oracle home exists.

5. Remove oratab entries beginning with +ASM.

Oracle CRS Installation on an Oracle9i RAC Cluster

If you install Oracle CRS on a system that also contains an Oracle9i Real Application Clusters (RAC) cluster, you must reboot all of the Oracle CRS nodes. You can reboot the nodes one at a time to avoid affecting any Oracle9i databases that may be in use.

Oracle assumes that when you install Oracle CRS 10g software, you will also install Oracle Real Application Clusters 10g. If there will be a significant delay before you perform phase two of the RAC installation to install Oracle Real Application Clusters 10g, then run the /crs_home/bin/gsdctl start command to start the GSD manually to service the 9.2 SRVCTL tool and assistants. Then before installing Oracle Real Application Clusters 10g, run the /crs_home/bin/gsdctl stop command to stop the GSD.

Oracle CRS Silent Installation

If you perform a silent installation of Oracle CRS on multiple nodes, on a system that does not have other Oracle installations, the Installer does not set up the Oracle Inventory correctly. In this case, after the installation is complete, follow these steps:

1. Run the orainstRoot.sh script on a local node.

2. Copy the oraInventory directory from the local node to each of the remote nodes.

3. Log in as the root user and run the following script on each remote node:

   oraInventory/orainstRoot.sh
   

Backing Up the Voting Disk after Installing RAC

After installing Oracle RAC 10g and after ensuring that the system is functioning properly, make a backup of the voting disk. In addition, make a backup of the voting disk contents after you complete any node additions or node deletions and after running any de-installation procedures.

Remote Undo Tablespaces Do Not Autoexetend in RAC Seed Databases

If you create a RAC database with two or more instances and you choose to create General Purpose, Transaction Processing, or Data Warehouse databases, and if you use a shared cluster file system or Automatic Storage Management (ASM) for database files, then the Database Configuration Assistant (DBCA) creates undo tablespace datafiles with an initial size of 25 MB and AUTOEXTEND ON for the local instance but AUTOEXTEND OFF for remote instances.

You can set AUTOEXTEND ON for undo tablespace datafiles for remote instances after creating a RAC database using DBCA as follows:

1. Connect to the database instance on the node from which you ran DBCA:

   $ sqlplus "/ AS SYSDBA"
   
   

2. Enter the following command to find the datafile names for UNDOTBS tablespaces for remote instances:

   SQL> SELECT file_name FROM SYS.DBA_DATA_FILES
        WHERE tablespace_name LIKE 'UNDOTBS%' AND AUTOEXTENSIBLE='NO';
   
   

3. Set AUTOEXTEND ON for the datafiles that you found in the previous step:

   SQL> ALTER DATABASE DATAFILE datafile_name AUTOEXTEND ON;
   
   

ORA-00600 Error for ASM

If you are using ASM for database file storage and the ASM instance terminates with an ORA-00600 error, you might see an error message similar to the following in the ASM instances alert log file:

ORA-00600: internal error code, arguments: [kfcDel67] 

A one off patch will be provided to fix this issue.

Net Configuration Assistant Help

In the Net Configuration Assistant (NetCA) help, the link to the Select Oracle Context help topic is broken. The text for this topic is as follows:

Directory Usage Configuration, Select Oracle Context

Oracle administrative content has been found in more than one location in the directory. Oracle administrative content is stored in an Oracle Context, a subtree in the directory that stores Oracle entries.

From the list, select or enter the location you want to use as the default Oracle Context location from which this computer will access Oracle entries, such as connect identifiers.

HTML DB

After you install HTML DB:

1. Change directory to the $ORACLE_HOME/Apache/Apache/bin directory.

2. Enter the following commands:

   $ ./apachectl stop$ ./apachectl start
   
   

If you do not perform these steps, you will receive the following error:

ForbiddenYou don't have permission to access /pls/htmldb/htmldb on this server.

Flashback Table or Flashback Analysis

If a user invokes the Flashback Table or Flashback Analysis operation, and that user has FLASHBACK ANY TABLE privileges but does not have specific flashback privileges on the objects that flashback is invoked on and does not have DBA privileges, then the following errors may occur:

ORA-02002: error while writing to audit trail 
ORA-00600: internal error code, arguments: [kzasps1], [4], [47], [],[],  

To fix this problem, as SYSDBA, grant the user FLASHBACK privilege on the objects that are referred to in the FLASHBACK TABLE statement and then invoke the flashback operation. For example:

SQL> GRANT FLASHBACK ON SCOTT.EMP_1 TO user1;

This issue is tracked through Oracle bug 3403666.

Oracle Internet Directory

This release includes the Oracle Internet Directory (OID) client tools, but it does not include OID server components. OID server components are included with Oracle Application Server 10g. If you require the OID server tools for Oracle Database components, then run them from an Oracle Application Server 10g installation.

The OID client tools include:

• LDAP command-line tools

• Oracle Internet Directory SDK

• Oracle Directory Manager

The OID server components include the following servers and tools for starting and stopping them:

• Directory server

• Directory replication server

• Directory integration server

Error When Viewing Period SQL Execution Plan in Korean

Viewing the execution plan of a Period SQL in Korean causes an internal server error. This problem is unique to Korean; it does not reproduce in Japanese or Chinese. The only workaround currently available is to run the product in a language other than Korean when you need to view this page.

Quick Tour Not Available in Oracle Change Management Pack

Quick Tour is not available in Oracle Change Management Pack. If you try to run it, then an error results.

Grid Features

Oracle Database New Features for Oracle Database 10g release 1 (10.1) lists two Grid features that are not available in the first release of Oracle Database 10g; Resonance and Transparent Session Migration. These features will be available in a future release.

Memory Leaks in Exception Handling of OCCI Applications

If you are developing a C++ application that uses Oracle C++ Call Interface (OCCI) and you encounter a memory leak in C++ exception handling, regenerate the libocci.so.10.1 shared library using the libCCexcept.so.1 and libldstab_ws.so shared libraries, as follows:

1. Set the value of the EXCEPTION_OBJ_LOC environment variable to specify the path of the libCCexcept.so.1 and libldstab_ws.so shared libraries. In the following examples, path is the path of the directory that contains the libCCexcept.so.1 and libldstab_ws.so libraries:

   • Bourne, Bash, or Korn shell:

     $ EXCEPTION_OBJ_LOC= path ;
     $ export EXCEPTION_OBJ_LOC
     
     

   • C shell:

     $ setenv EXCEPTION_OBJ_LOC path  
     
     

2. Enter the following command to regenerate the shared library:

   $ $ORACLE_HOME/bin/genoccish 
   

Installing Enterprise Security Manager

To install Enterprise Security Manager (ESM), install Oracle Client and choose the Administrator installation type.

Full-Text Searching with Oracle Text

For full-text searching with Oracle Text, you must create XML tables manually.

If you will need to use Oracle Text indexes for text-based ora:contains searches over a collection of XML elements, then do not use XML schema annotation storeVarrayAsTable="true". This annotation causes element collections to be persisted as rows in an Index Organized Table (IOT). Oracle Text does not support IOTs.

To be able to use Oracle Text to search the contents of element collections, set parameter genTables="false" during schema registration. Then create the necessary tables manually, without using the clause ORGANIZATION INDEX OVERFLOW. The tables will then be heap-organized instead of index-organized (IOT), as shown in the following example:

CREATE TABLE PurchaseOrder of XMLTYPE
  XMLSCHEMA http://localhost:8080/home/SCOTT/poSource/xsd/purchaseOrder.xsd
  ELEMENT "PurchaseOrder"
  VARRAY "XMLDATA"."ACTIONS"."ACTION"
    STORE AS TABLE ACTION_TABLE ((PRIMARY KEY 
       (NESTED_TABLE_ID, ARRAY_INDEX)))
  VARRAY "XMLDATA"."LINEITEMS"."LINEITEM"
     STORE AS TABLE LINEITEM_TABLE ((PRIMARY KEY 
       (NESTED_TABLE_ID, ARRAY_INDEX)));

Transport Layer Security

In this release, the AES_128 and AES_256 cipher suites do not work with Transport Layer Security (TLS). This issue is tracked through Oracle bug 3753967.

XDK Error Messages

XDK error messages are available at the XML Technology Center on the OTN Web site:

http://www.oracle.com/technology/tech/xml/doc/production10g/Javaerrormsgs.html