Oracle® Database

Upgrading an Oracle9i Database to Oracle Database 10g

If you upgrade an Oracle9i database to Oracle Database 10g release 1, Oracle Flashback features using a timestamp may fail. To work around this problem, enter the following SQL script from the Oracle Database 10g database:

SQL> DELETE FROM smon_scn_time WHERE orig_thread <> 0;
SQL> COMMIT;

This issue is tracked with Oracle bug 3994270.

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.

De-Installing Oracle RAC Software

After you de-install CRS, enter the following command to delete the CRS scripts from /etc system runlevel directories:

To de-install Oracle RAC software in Oracle homes and Oracle CRS homes as described in the Oracle Real Application Clusters Installation and Configuration Guide, you must run the Installer on the node from which you performed the installation.

After you de-install CRS, enter the following command to delete the CRS scripts:

$ $ rm -rf /etc/rc.d/rc*.d/*96init.crs

Oracle CRS Installation Errors Caused by stty Commands

During an Oracle CRS installation, the Installer uses SSH (if available) to run commands and copy files to the other nodes. During the installation, you might see errors similar to the following if a "dot" file on the system (for example, .bashrc or .cshrc) contains stty commands:

 stty: standard input: Invalid argument 
 stty: standard input: Invalid argument 

To avoid this problem, Oracle recommends that you modify these files to suppress all output on STDERR, as follows:

• Bourne, Bash, or Korn shell:

  if [ -t 0 ]; then
     stty intr ^C
  fi
  
  

• C shell:

  test -t 0
  if ($status == 0) then
     stty intr ^C
  endif
  

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
   

Oracle CRS and RAC Installation Log File Messages

The installation log files for CRS and RAC installations might contain messages similar to the following:

/bin/tar: .../rootdeletenode: Cannot stat: No such file or directory
/bin/tar: .../rootdelete: Cannot stat: No such file or directory
/bin/tar: .../rootdeinstall: Cannot stat: No such file or directory

These messages do not indicate installation problems and can be ignored.

Creating a RAC Database on a NAS File System

To create a RAC database on a NAS file system, you must run DBCA in interactive mode. To run DBCA in interactive mode:

• Choose one of the following options when installing the software:

  • Choose the Enterprise Edition installation type, then choose the Advanced database configuration option

  • Choose the Custom installation type

• Run DBCA from the command line, after installing the software:

  $ $ORACLE_HOME/bin/dbca
  
  

When using DBCA to create the database, you must specify the value directIO for the FILESYSTEMIO_OPTIONS parameter, as follows:

1. When DBCA displays the Initialization Parameters screen, click All Initialization Parameters.

2. Click Show Advanced Parameters.

3. Specify the value directIO for the FILESYSTEMIO_OPTIONS parameter, then click Close.

Using Shared CRS Home or Oracle Home Directories

For this release, Oracle supports shared CRS home and Oracle home directories on Linux only if they are located on a certified NAS device. This configuration is supported only if you also use the NAS device to store the Oracle database files.

Using Network Attached Storage for RAC Installations

On Linux, you can use an NFS file system on a certified NAS device for storing Oracle software or database files. The file system that you use must have the same mount point path on all cluster nodes. In addition, you must use the following mount options when mounting the NFS file systems:

• Use the noac option to disable attribute caching.

• Use the tcp option to specify the TCP protocol.

• Verify that the NFS file system and the correct mount options are specified in the /etc/fstab file on every node to ensure that the file system is mounted when each node boots.

For more information about using NAS devices and NFS file systems:

• See OracleMetalink for information about certified NAS devices

• Contact your NAS vendor for specific recommendations about using the device with Oracle Real Application Clusters

• See Appendix C in the Oracle Database Installation Guide for UNIX Systems for general guidelines about using NAS devices for Oracle Database installations

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 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;
   
   

Running Oracle9i RAC with Oracle RAC 10g

If you are running Oracle9i RAC on the same cluster nodes as Oracle RAC 10g, complete the following steps:

1. Create the following directory:

   $ mkdir -p /etc/ORCLcluster/oracm/lib
   
   

2. Change directory to this directory:

   $ cd /etc/ORCLcluster/oracm/lib
   
   

3. Copy the /oracle9i_home/lib/libcmdll.so file to the current directory:

   $ cp /oracle9i_home/lib/libcmdll.so .
   
   

4. Enter the following command:

   # ln -s ./libcmdll.so ./libskgxn2.so
   
   

5. On any cluster node, enter commands similar to the following to restart the node applications on all cluster nodes:

   $ORACLE_HOME/bin/svrctl stop nodeapps -n nodename
   $ORACLE_HOME/bin/svrctl start nodeapps -n nodename
   
   

   In this example, $ORACLE_HOME is the Oracle RAC 10g Oracle home and nodename is the name of the node. Repeat the commands for each node in the cluster.

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.

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.

Network Utilization Metrics Not Displayed

The Oracle Enterprise Manager Grid Control or Database Control should display the following network utilization metrics for each network interface:

• Network Interface Combined Utilization (%)

• Network Interface Read Utilization (%)

• Network Interface Write Utilization (%)

If these metrics are not displayed for a particular network interface, create the $ORACLE_HOME/sysman/config/network_speed file and enter the network interface name and speed in the file as follows. In this example, interface is the network interface name and speed is the speed of the interface in megabits per second (Mbps):

interface_name speed

For example, if the eth0 network interface does not display metrics, create the $ORACLE_HOME/sysman/config/network_speed file and enter the following, where 100 is the network speed in Mbps:

eth0 100

Building Pro*C Applications if PostgreSQL is Installed

If the postgresql-devel package is installed on the system, add the following directory to the beginning of the sys_include parameter in the $ORACLE_HOME/precomp/admin/pcscfg.cfg file before building Pro*C applications:

$ORACLE_HOME/precomp/public

If you do not make this change, you may encounter errors similar to the following when linking the applications:

/tmp/ccbXd7v6.o(.text+0xc0): In function `drop_tables': 
: undefined reference to `sqlca' 

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)));

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 

Creating a socketpair for javassl

If you use javassl in an Oracle application, the system might hang after you create a socketpair using the createSocket() method if:

• String is localhost in the constructor createSocket (String host, int port, InetAddress localAddress, int localPort)

• You use the constructor createSocket (InetAddress1, int, InetAddress2, int)

To work around this problem, use a fully qualified domain name, IP address, or 127.0.0.1 instead of localhost. This issue is tracked with Oracle bug 3939624.

Running Java Demonstrations

Before you run Java demonstrations, include the directory that contains the classes.jar file in the setting for the CLASSPATH environment variable (/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes).