Oracle9i Release Notes
Release 2 (9.2.0.4.0) for Linux x86 Part No. B13670-06 March 2005 These release notes accompany Oracle9i release 9.2.0.4. This release includes the 9.2.0.1 release and the patches for all previous 9.2.0.x patch sets. The latest patch
set version which is included in this release is 9.2.0.4, and patches the following
products only:
■ Java VM
■ JDBC
■ JPublisher
■ Networking
■ Online Application Processing (OLAP)
■ Oracle Core
■ Oracle Gateways
■ Oracle Intelligent Agent
■ Oracle interMedia
■ Oracle Internet Directory
■ Oracle Spatial
■ Oracle Text, formerly Oracle interMedia Text
■ Oracle UltraSearch
■ Oracle XDK
■ Oracle9i Database
■ Oracle9i Globalization
■ PL/SQL
■ Precompilers
■ SQLJ
■ SQL*Plus
■ XML Developer’s Kit
Copyright . 2001, 2005 Oracle. Oracle is a registered trade of Oracle Corporation and/or its affiliates. Other names may be trades of their respective owners.
All rights reserved.
This document contains the following sections: ■
Documentation Accessibility
■
Red Hat Enterprise Linux 4 Certification Update
■
Post-release Updates
■
System Requirements
■
Kernel Parameters
■
Software Requirements
■
Installation Issues
■
Product Issues
■
Other Known Issues
Documentation Accessibility Our goal is to make Oracle products, services, and supporting documentation
accessible, with good usability, to the disabled community. To that end, our
documentation includes features that make information available to users of
assistive technology. This documentation is available in HTML format, and
contains up to facilitate access by the disabled community. Standards will
continue to evolve over time, and Oracle is actively engaged with other
et-leading technology vendors to address technical obstacles so that our
documentation can be accessible to all of our customers. For additional
information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/
Accessibility of Code Examples in Documentation JAWS, a Windows screen reader, may
not always correctly read the code examples in this document. The conventions
for writing code require that closing braces should appear on an otherwise empty
line; however, JAWS may not always read a line of text that consists solely of a
bracket or brace. Red Hat Enterprise Linux 4 Certification Update Oracle9i release 2 (9.2.0.6) is certified on Red Hat Enterprise Linux 4. To install
release 9.2.0.6 on Red Hat Linux Enterprise Server 4: 1.
Review the issues in this section and complete the steps in the "Additional
Required Pre-installation Tasks" section on page 3.
2.
Review the other issues in these release notes.
3.
Follow the instructions in the Oracle9i Release 2 (9.2.) Installation Guide for
UNIX Systems to install Oracle9i release 9.2.0.4.
4.
Follow the instructions in the Oracle9i Patch Set Notes Release 2 (9.2.0.6) for
Linux x86 to install the release 9.2.0.6 patch set.
5.
Complete the steps in the "Additional Required Post-installation Tasks"
section on page -4.
2
The following sections contain addition information specific to installing Oracle9i
release 9.2.0.6 on Red Hat Linux Enterprise Server 4: ■
Additional Required Pre-installation Tasks
■
Additional Required Post-installation Tasks
■
Direct I/O Support
■
Pro*COBOL and Pro*FORTRAN Precompiler Support
■
GNU C++ Compiler Version 296 Not Available
■
Legato Single Server Version Not Supported
■
Using hugetlbfs on Red Hat Enterprise Linux AS 2.1 (Itanium), SUSE Linux
Enterprise Server 9, or Red Hat Enterprise Linux 4
■
Red Hat Enterprise Linux 4 Only: Using hugetlbfs
■
Issues with Oracle Cluster Manager
Additional Required Pre-installation Tasks Before installing Oracle9i release 2 (9.2.0.6) on Red Hat Enterprise Linux 4, you
must perform the following steps: Download and Install Required Packages
Release 2 (9.2.0.4.0) for Linux x86 Part No. B13670-06 March 2005 These release notes accompany Oracle9i release 9.2.0.4. This release includes the 9.2.0.1 release and the patches for all previous 9.2.0.x patch sets. The latest patch
set version which is included in this release is 9.2.0.4, and patches the following
products only:
■ Java VM
■ JDBC
■ JPublisher
■ Networking
■ Online Application Processing (OLAP)
■ Oracle Core
■ Oracle Gateways
■ Oracle Intelligent Agent
■ Oracle interMedia
■ Oracle Internet Directory
■ Oracle Spatial
■ Oracle Text, formerly Oracle interMedia Text
■ Oracle UltraSearch
■ Oracle XDK
■ Oracle9i Database
■ Oracle9i Globalization
■ PL/SQL
■ Precompilers
■ SQLJ
■ SQL*Plus
■ XML Developer’s Kit
Copyright . 2001, 2005 Oracle. Oracle is a registered trade of Oracle Corporation and/or its affiliates. Other names may be trades of their respective owners.
All rights reserved.
This document contains the following sections: ■
Documentation Accessibility
■
Red Hat Enterprise Linux 4 Certification Update
■
Post-release Updates
■
System Requirements
■
Kernel Parameters
■
Software Requirements
■
Installation Issues
■
Product Issues
■
Other Known Issues
Documentation Accessibility Our goal is to make Oracle products, services, and supporting documentation
accessible, with good usability, to the disabled community. To that end, our
documentation includes features that make information available to users of
assistive technology. This documentation is available in HTML format, and
contains up to facilitate access by the disabled community. Standards will
continue to evolve over time, and Oracle is actively engaged with other
et-leading technology vendors to address technical obstacles so that our
documentation can be accessible to all of our customers. For additional
information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/
Accessibility of Code Examples in Documentation JAWS, a Windows screen reader, may
not always correctly read the code examples in this document. The conventions
for writing code require that closing braces should appear on an otherwise empty
line; however, JAWS may not always read a line of text that consists solely of a
bracket or brace. Red Hat Enterprise Linux 4 Certification Update Oracle9i release 2 (9.2.0.6) is certified on Red Hat Enterprise Linux 4. To install
release 9.2.0.6 on Red Hat Linux Enterprise Server 4: 1.
Review the issues in this section and complete the steps in the "Additional
Required Pre-installation Tasks" section on page 3.
2.
Review the other issues in these release notes.
3.
Follow the instructions in the Oracle9i Release 2 (9.2.) Installation Guide for
UNIX Systems to install Oracle9i release 9.2.0.4.
4.
Follow the instructions in the Oracle9i Patch Set Notes Release 2 (9.2.0.6) for
Linux x86 to install the release 9.2.0.6 patch set.
5.
Complete the steps in the "Additional Required Post-installation Tasks"
section on page -4.
2
The following sections contain addition information specific to installing Oracle9i
release 9.2.0.6 on Red Hat Linux Enterprise Server 4: ■
Additional Required Pre-installation Tasks
■
Additional Required Post-installation Tasks
■
Direct I/O Support
■
Pro*COBOL and Pro*FORTRAN Precompiler Support
■
GNU C++ Compiler Version 296 Not Available
■
Legato Single Server Version Not Supported
■
Using hugetlbfs on Red Hat Enterprise Linux AS 2.1 (Itanium), SUSE Linux
Enterprise Server 9, or Red Hat Enterprise Linux 4
■
Red Hat Enterprise Linux 4 Only: Using hugetlbfs
■
Issues with Oracle Cluster Manager
Additional Required Pre-installation Tasks Before installing Oracle9i release 2 (9.2.0.6) on Red Hat Enterprise Linux 4, you
must perform the following steps: Download and Install Required Packages
解决方案 »
- 数据库中的表记录莫名其妙的被删除了
- 做oracle热备份
- Oracle有张表,大概2KW条记录,想做分区.该如何实现,实现难度大么?
- 新手求助
- 1、求助:在suse linux 10 下安装oracle 10g 方法
- 紧急!紧急!安装TCP/IP协议时,弹出数据库服务器锁定,装不了
- ORACLE服务不能启动的问题
- 这句 SQL 语句该怎么样写呢? 急 在线等待!
- 整数问题
- oracle数据Oracle Net Configuration Assistant配置问题
- 从oracle网站下的oracle10g的文档是在线文档,需要上网才能查,在哪里有离线文档下载?
- count(*)和count(1) 问题
9
compat-gcc-32-3.2.3-47.3
compat-gcc-32-c++-3.2.3-47.3
compat-oracle-rhel4-1.0-
3
compat-libcwait-2.0-
1
compat-libgcc-296-2.96-132.7.2
compat-libstdc++-296-2.96-132.7.2
compat-libstdc++-33-3.2.3-47.3
gcc-3.4.3-9.EL4
gcc-c++-3.4.3-9.EL4
gnome-libs-1.4.1.2.90-44
gnome-libs-devel-1.4.1.2.90-44
libaio-devel-0.3.102-
1
libaio-0.3.102-
1
make-3.80-
5
openmotif21-2.1.30-11
xorg-x11-deprecated-libs-devel-6.8.1-23.EL
xorg-x11-deprecated-libs-6.8.1-23.EL
The compat-oracle-rhel4-1.0-3and compat-libcwait-2.0-1
packages are available from OracleMetalink patch 4198954. To download patch
4198954: 1.
Click Patches on the side of the OracleMetalink page.
2.
Click Simple Search on the Select a Patch Search Area page.
3.
Select Patch Number(s) in the Search By field.
4.
Enter 4198954 in the Search By Patch Number(s) field.
3
5.
Select Linux x86 in the Platform or Language field, then click Go.
6.
On the patch download page, click Download.
Download and Unzip Patch 4188455 Before you install Oracle9i release 9.2.0.6, you must download and unzip patch
4188455 from OracleMetalink: http://metalink.oracle.com
To download and unzip patch 4188455: 1.
Click Patches on the side of the OracleMetalink page.
2.
Click Simple Search on the Select a Patch Search Area page.
3.
Select Patch Number(s) in the Search By field.
4.
Enter 4188455 in the Search By Patch Number(s) field.
5.
Select Linux x86 in the Platform or Language field, then click Go.
6.
On the patch download page, click Download.
The p4188455_10103_LINUX.zip file is downloaded to your system. This
file contains the oraparam.ini file. 7.
Unzip the p4188455_10103_LINUX.zip file.
8.
Optionally, copy the oraparam.inifile to a different directory on your
system, for example, /tmp.
You must specify the full path to the oraparam.ini file when you start the
Installer. Set the LD_ASSUME_KERNEL Environment Variable Before starting Oracle Universal Installer, set the value of the
LD_ASSUME_KERNEL environment variable to 2.4.19: ■
Bourne, Bash, or Korn shell:
$ LD_ASSUME_KERNEL=2.4.19; export LD_ASSUME_KERNEL
■
C shell:
$ setenv LD_ASSUME_KERNEL 2.4.19
See Also: For information about the LD_ASSUME_KERNEL
environment variable, see document 243979.1, available from the
OracleMetalink Web site: http://metalink.oracle.com
Additional Required Post-installation Tasks After you complete the required post-installation tasks listed in the Oracle9i Patch
Set Notes Release 2 (9.2.0.6) for Linux x86, you must complete the following tasks: 1.
Download the patches for bugs 2617419 and 4190568 from OracleMetalink:
http://metalink.oracle.com
4
a.
Log on to OracleMetalink.
b.
Click Patches on the side of the OracleMetalink page.
c.
Click Simple Search on the Select a Patch Search Area page.
d.
Select Patch Number(s) in the Search By field.
e.
Enter the bug numbers separated by a comma in the Search By Patch
Number(s) field.
f.
Select Linux x86 in the Platform or Language field, then click Go.
g.
Select patch number 2617419 for release 10.1.0.2.
h.
On the patch download page, click Download.
The p2617419_10102_GENERIC.zip file is downloaded to your
system. This file contains the opatch utility. i.
Click the Back button in the browser.
j.
Select patch number 4190568.
k.
On the patch download page, click Download.
The p4190568_9206_LINUX.zipfile is downloaded to your system.
2.
Change permission on the downloaded .zip files as follows:
$ chmod o+rwx filename.zip
3.
Switch user to the oracle user:
$ su- oracle
4.
Unzip the p2617419_10102_GENERIC.zip file.
5.
Copy the extracted OPatch directory to the Oracle home directory:
$ cp -a OPatch/ oracle_home_path/
6.
Set the ORACLE_HOME environment variable to the Oracle home where
you copied the OPatch directory:
■
Bourne, Bash, or Korn shell:
$ ORACLE_HOME=oracle_home_path; export ORACLE_HOME
■
C shell:
% setenv ORACLE_HOME oracle_home_path
7.
Add the $ORACLE_HOME/OPatch directory to the list of directories specified
in the PATH environment variable:
■
Bourne, Bash, or Korn shell:
$ PATH=$ORACLE_HOME/OPatch:$PATH ; export PATH
■
C shell:
% setenv PATH $ORACLE_HOME/OPatch:$PATH
8.
Unzip the p4190568_9206_LINUX.zip file.
5
9. Change directory to the directory where you unzipped the file, for example:
$ cd 4190568
10. Enter the following command to apply the patch:
$ opatch apply
$ opatch lsinventory
Direct I/O Support If you intend to use Direct I/O Support, you must download and apply patch
2448994, available on the OracleMetaLink Web site at: http://metalink.oracle.com
To download patch 2448994: 1. Click Patches on the side of the OracleMetalink page.
2. Click Simple Search on the Select a Patch Search Area page.
3. Select Patch Number(s) in the Search By field.
4. Enter 2448994 in the Search By Patch Number(s) field.
5. Select Linux x86 in the Platform or Language field, then click Go.
6. On the patch download page, download the patch for the 9.2.0.6 release.
Pro*COBOL and Pro*FORTRAN Precompiler Support The Pro*COBOL and Pro*FORTRAN precompilers are not supported on Red Hat
Enterprise Linux 4. GNU C++ Compiler Version 296 Not Available GNU C++ compiler (gcc) version 296 is not available on Red Hat Enterprise
Linux 4. For this reason, OCCI and XDK++ are not available. Legato Single Server Version Not Supported Legato Single Server Version (LSSV) is not Supported on Red Hat Enterprise
Linux 4. Using hugetlbfs on Red Hat Enterprise Linux AS 2.1 (Itanium), SUSE
Linux Enterprise Server 9, or Red Hat Enterprise Linux 4 The "Using hugetlbfs on Red Hat Enterprise Linux AS 2.1 (Itanium) or SUSE
Linux Enterprise Server 9" section in the Oracle Database 10g Release 10.1
Administrator’s Reference should read as follows: To enable Oracle Database to use large pages (sometimes called huge pages) on
Red Hat Enterprise Linux AS 2.1 (Itanium), SUSE Linux Enterprise Server 9, or
Red Hat Enterprise Linux 4, set the value of the vm.nr_hugepageskernel
parameter to specify the number of large pages that you want to reserve. You 6
must specify a sufficient number of large pages to hold the entire SGA for the
database instance. To determine the required parameter value, divide the SGA size for the instance
by the size of a large page, then round the result up to the nearest integer. To determine the default large page size, enter the following command: # grep Hugepagesize /proc/meminfo
For example, if /proc/meminfolists the large page size as 2 MB, and the total
SGA size for the instance is 1.6 GB, then set the value for the vm.nr_hugepages
kernel parameter to 820 (1.6 GB / 2 MB = 819.2). Red Hat Enterprise Linux 4 Only: Using hugetlbfs To use hugetlbfs on Red Hat Enterprise Linux 4, you must increase the default
maximum size of the per-process locked memory. To increase the per-process
memory, add the following lines to the /etc/security/limits.conf file,
where oracle is the user that administers the database: oracle soft memlock 3145728
oracle hard memlock 3145728
Issues with Oracle Cluster Manager Before applying the Oracle9i release 2 (9.2.0.6) patchset to an Oracle Cluster
Manager installation, review Oracle bug 4181942 and follow the instructions in
the workaround section. Bug 4181942 is available on the OracleMetalink Web site: http://metalink.oracle.com
To view bug 4181942: 1. Log on to OracleMetalink.
2. Click Bugs on the side of the OracleMetalink page.
3. Enter 4181942 in the Bug Number field, then click Search Bugs.
Post-release Updates Before installing this release in a production environment, review the
OracleMetaLink site. Oracle Support provides information about the status of
issues discovered after this release is posted on OracleMetaLink. The information
is available in document 189908.1, ALERT: Oracle9i Release 2 (9.2) Support Status
and Alerts. To locate the document on OracleMetaLink, enter the document
number in the search field, and click Search. OracleMetaLink is available at the following URL http://metalink.oracle.com/
this release in a production environment. 7
System Requirements The following are the system requirements for this release: ■
Operating system requirement
-SUSE Linux Enterprise Server (SLES) 8 and
9
-Red Hat Enterprise Linux AS/ES 2.1 and
3
■
Hard disk space requirements
The space requirements listed on the Available Products window apply to
installations that include a database. If you select the Software Only
configuration type, then you require 3 GB. Kernel Parameters The following information supplements the information on kernel parameters in
the Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems. ■
SHMSEG
This kernel parameter is no longer accessible to users on current kernel
distributions. It can be ignored. ■
SHMALL
Do not change the default value of this parameter. This replaces the
instruction in the Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX
Systems to change the value. ■
SHMMAX
Set this parameter to half the size of physical RAM available on your system.
This value cannot exceed 4294967295. ■
For large system global area (SGA) sizes greater than 1.8 GB, choose one of
the following:
-
Run the following command as the rootuser to mount the shared
memory file system each time you reboot your system. # mount -t shm shmfs -o nr_blocks=8g/dev/shm
-Use the Automounter to run the shared memory file system command
automatically as follows: Edit the /etc/fstab file as the rootuser to include the following line: shm /dev/shm shmfs nr_blocks=8g 0
0
Software Requirements The following sections list the software requirements for supported operating
systems: ■
Software Requirements for Red Hat Enterprise Linux 2.1
■
Software Requirements for Red Hat Enterprise Linux 3
■
Software Requirements for SUSE Linux Enterprise Server 8
■
Software Requirements for SUSE Linux Enterprise Server 9
8
Software Requirements for Red Hat Enterprise Linux 2.1 The following software is required for installation on Red Hat Enterprise Linux 2.1:
■
Linux kernel version: 2.4.9 errata 34 (e.34) or higher
■
Glibc version: glibc 2.2.4-32
■
Required operating system packages:
-make-3.79
-openmotif-2.1.30
-gcc-2.96-128
-gcc-c++-2.96-128
-libstdc++-2.96-128
Software Requirements for Red Hat Enterprise Linux 3 The following software is required for installation on Red Hat Enterprise Linux 3: ■
Linux kernel version: 2.4.21-15
■
Glibc version: glibc 2.3.2-95.20
■
Required operating system packages:
-gcc-3.2.3-34
-make-3.79.1
-openmotif21-2.1.30-8
-setarch-1.3-1
-compat-db-4.0.14-5
-compat-gcc-7.3-2.96.128
-compat-gcc-c++-7.3-2.96.128
-compat-libstdc++-7.3-2.96.128
-compat-libstdc++-devel-7.3-2.96.128
-gnome-libs-1.4.1.2.90-34.1
9
To ensure that the Oracle software uses the version 296 gccand g++
executables, enter the following commands:
% mv /usr/bin/gcc /usr/bin/gcc323
% mv /usr/bin/g++ /usr/bin/g++323
% ln -s /usr/bin/gcc296 /usr/bin/gcc
% ln -s /usr/bin/g++296 /usr/bin/g+
+
■
The hostname command should return the fully qualified host name as
follows:
% hostname
hostname.domainname
■
If any Java packages are installed on the system, unset the Java environment
variables. For example, unset JAVA_HOME.
■
The oracle account used to install Oracle9i release 9.2.0.4 should not have
the Oracle installation-related variables set by default. For example, do not
set ORACLE_HOME, PATH, LD_LIBRARY_PATH to include Oracle binaries
in .profile, .login, and /etc/profile.d.
■
If you are using the hugemem kernel, enter the following command:
$ setarch i386
You do not have to enter this command if you are using the uniprocessor,
smpand boot kernels. Software Requirements for SUSE Linux Enterprise Server 8 The following software is required for installation on SLES 8: ■
Linux kernel version: 2.4.21-138
■
Required operating system packages:
-gcc-3.2.2-38
-glibc-2.2.2-124
-make-3.79.1
-openmotif-2.2.2-124
Software Requirements for SUSE Linux Enterprise Server 9 The following software is required for installation on SLES 9: ■
Linux kernel version: 2.6.5-7.97
■
Required operating system packages:
-glibc-2.3.3
-gcc-3.3.3
-gcc-c++-3.3.3
-libaio-0.3.98
10
-libaio-devel-0.3.98
-make-3.80
-openmotif-libs-2.2.2-519.1
-orarun-1.8-109
Setting the Environment for SLES 9 In addition to the environment variables listed in the Oracle9i Installation Guide for
UNIX Systems, before starting the Installer set the following environment
variables: Note: You must set the LD_ASSUME_KERNEL and
LD_PRELOAD environment variables before you run the
Installer or any other Java-based Oracle utilities. ■
Set the LD_ASSUME_KERNEL environment variable:
-Bourne, Bash, or Korn shell:
$ LD_ASSUME_KERNEL=2.4.21 ; export LD_ASSUME_KERNEL
-
C shell: % setenv LD_ASSUME_KERNEL 2.4.21
-Bourne, Bash, or Korn shell:
$ LD_PRELOAD=/usr/lib/libInternalSymbols.so ; export LD_PRELOAD
-
C shell: % setenv LD_PRELOAD /usr/lib/libInternalSymbols.so
Note: The libInternalSymbols.so library is part of the
orarun package. Installation Issues This section provides information about the following topics: ■
Multiple CD-ROM Installation
■
runInstaller Script
■
Installing Databases With Database Configuration Assistant
■
Database Migration
■
Installing With Response Files
■
Unzip Utility for Downloading and Installing Oracle Patches
11
Multiple CD-ROM Installation During installation you will be prompted to insert additional CD-ROMs from the
set that make up Oracle9i release 2 (9.2.0.4.0). After inserting the requested disk,
change the path in the Disk Location text box to specify the CD-ROM mount
point directory, if necessary. runInstaller Script As it is necessary to insert and eject more than one CD-ROM during installation,
do not launch Oracle Universal Installer by running the runInstaller script
from a shell where the current working directory is the CD-ROM mount point.
Also do not launch the Oracle Universal Installer by clicking on the script in a
File Manager window. To launch the Oracle Universal Installer, use the full
CD-ROM path in the command syntax as follows: cdrom_mount_path/runInstaller
In the previous command, cdrom_mount_path corresponds to the directory where
the CD-ROM is mounted. Installing Databases With Database Configuration Assistant Review the following information before running Database Configuration
Assistant. If you use Database Configuration Assistant to create a database, you
must change the SYS and SYSTEM passwords at the end of the configuration
process. This is a new security procedure designed to protect access to your data. Database Migration If you are upgrading from an Oracle release 8.0.6 database to Oracle9i release 2 (9.2.0.4.0) and you have Oracle interMedia installed on your system, then you
cannot use Database Migration Assistant. You must migrate the database
manually. For information on manual database migration, refer to Oracle9i
Database Migration Release 2 (9.2).
To upgrade from Oracle8i release 8.0.6 to Oracle9i release 2 (9.2.0.4.0), use the
following procedure: 1.
Upgrade the Linux operating system kernel on your system to the values
indicated in the Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX
Systems.
2.
Start the Oracle 8.0.6 database.
3.
Run the Oracle Universal Installer as instructed in the Oracle9i Installation
Guide Release 2 (9.2.0.1.0) for UNIX Systems.
4.
Select the 8.0.6 database when prompted to select a database for upgrading.
Installing With Response Files For installation with a response file, the path to the response file must be the full
path on the system. The Oracle Universal Installer does not handle relative paths
properly. 12
Unzip Utility for Downloading and Installing Oracle Patches An unzip utility is provided with Oracle9i release 2 (9.2.0.4.0) for uncompressing
Oracle patches downloaded from OracleMetaLink. The utility is located in the
following directory: $ORACLE_HOME/bin/
Product Issues The following sections contain information about issues related to Oracle9i and
associated products: ■
Red Hat Host Name Alias
■
Using Large SGA Size
■
Enabling Large Pages on Red Hat Enterprise Linux 2.1 and SUSE Linux
Enterprise Server 8
■
Increasing SGA Address Space
■
SLES 9 Only: Oracle Messaging Gateway
■
OCCI on SLES 9
■
Database Upgrade for Oracle E-Business Suite
■
Oracle Streams
■
Oracle Data Guard
■
Oracle Text INSO Updates
■
Oracle Advanced Queuing
■
Event 10499
■
Oracle XDK
Outage
■
ALTER TABLE SET COLUMN UNUSED not Supported by Logical Standby
Databases
■
Creating Nested Tables on Logical Standby Databases
■
DDL Statements that Use Database Links
■
Logical Standby Databases on the Same Node as the Primary Database
■
Granting Privileges to SYS Returns Error ORA-01749
■
Refreshing Materialized Views on a Logical Standby Database
■
Initially Starting Logical Standby Fails with Error ORA-1652
■
Verify Warning is Incorrect
■
Using Multiple Domain Names in CONNECT Command
■
Manually Finding an Archive Group
■
DBMS_LOGSTDBY.INSTANTIATE_TABLE
■
SQL Apply Does Not Support Tables with Function-based or Descending
Indexes
13
Red Hat Host Name Alias On Red Hat Linux, the /etc/hostsfile defines the local host name to the
loopback entry by default. This setting causes Oracle Intelligent Agent to fail to
stop or restart. To correct this problem, enter the system IP address as the first
line in the /etc/hosts file using the following format: IP address hostname.domain hostname
For example: 123.456.789.012 db.acme.com db
Using Large SGA Size If you want to use a large SGA size, set the USE_INDIRECT_DATA_BUFFERS
parameter to TRUE. Enabling Large Pages on Red Hat Enterprise Linux 2.1 and SUSE Linux
Enterprise Server 8 Enabling large pages can improve scalability by reducing virtual memory
overhead in the kernel. However, memory resources in the large page pool
cannot be swapped, so you must be sure that your system has sufficient memory. Note: Using the bigpages parameter is supported only on Red
Hat Enterprise Linux 2.1 and SUSE Linux Enterprise Server 8. It
is not available or supported on Red Hat Enterprise Linux 3 or
SUSE Linux Enterprise Server 9. To use the large pages feature, you must determine the bigpages parameter
value. To determine this value, convert the size of the instance’s SGA to
megabytes, and round up by 4 MB. Use the following example as a guide: Note: You can determine the size of the SGA by using the
SHOW SGA command in SQL*Plus or by using the ipcs
command. If the SGA is 2.7 GB: 1.
Determine the bigpages value as follows:
bigpages = 2.7 * 1024 = 2764.8
2.
Round the value up by 4 to 2768.
3.
Depending on your boot loader, perform one of the following steps:
LILO:
a.
Add the bigpages option to the appropriate image section in the
/etc/lilo.conf file:
append = "bigpages=2768MB"
14
b.
Run /sbin/lilo.
c. Restart the system.
GRUB:
a.
Add the bigpages option to the kernel command in the
/etc/grub.conffile, for example:
kernel /vmlinuz-2.4.9 root=/dev/hda5 bigpages=2768MB
b.
Restart the system.
4.
To enable the large pages feature, set the value of the shm-use-bigpages
kernel parameter in the /etc/sysctl.conf file to either 1 or 2, depending
on whether you are using the extended buffer cache feature, and set the
USE_INDIRECT_DATA_BUFFERS initialization parameter to TRUE in the
parameter file:
■
If you are not using the extended buffer cache (VLM), set the value to 1:
kernel.shm-use-bigpages =
1
■
If you are using the extended buffer cache (VLM), set the value to 2 to
configure the bigpages memory pool to include the memory allocated in
/dev/shm:
kernel.shm-use-bigpages =
2
5.
Enter the following command to set the parameter values:
# sysctl -p /etc/sysctl.conf
6.
Start up Oracle Database.
Increasing SGA Address Space Depending on your distribution of Linux, use the instructions in one of the
following sections to increase the SGA address space: ■
Red Hat Enterprise Linux 2.1 and SUSE Linux Enterprise Server 8 and 9
■
Red Hat Enterprise Linux 3 and 4
Red Hat Enterprise Linux 2.1 and SUSE Linux Enterprise Server 8 and 9 To increase the SGA address space on Red Hat Enterprise Linux 2.1 and SUSE
Linux Enterprise Server 8 and 9: 1.
If necessary, log in as the oracle user.
2.
In the $ORACLE_HOME/rdbms/lib directory, enter the following
commands:
$ genksms -s 0x15000000 > ksms.
s
$ make -f ins_rdbms.mk ksms.
o
$ make -f ins_rdbms.mk ioracle