| Oracle® Database Client Installation Guide 11g Release 1 (11.1) for Linux Part Number B32003-04 |
|
|
View PDF |
| Oracle® Database Client Installation Guide 11g Release 1 (11.1) for Linux Part Number B32003-04 |
|
|
View PDF |
This chapter describes the different installation types of Oracle Database for Linux and issues to consider before you install Oracle Database:
The Oracle Database installation process consists of the following phases:
Read the release notes: Read Oracle Database Release Notes for Linux before you begin the installation. The release notes are available with the platform-specific documentation. The latest version of the release notes is available on Oracle Technology Network at:
http://www.oracle.com/technology/documentation
Review the licensing information: Although the installation media in your media pack contain many Oracle components, you are permitted to use only those components for which you have purchased licenses.
Oracle Support Services does not provide support for components for which licenses have not been purchased.
See Also:
Oracle Database Licensing InformationPlan the installation: This chapter describes the Oracle products that you can install and issues that you must consider before starting the installation.
You can also refer to Appendix D which covers frequently asked questions about installing Oracle Database components, such as how to install Oracle Database if the site uses Oracle applications or if you need multiple Oracle Database client connections.
Complete preinstallation tasks: Chapter 2 describes preinstallation tasks that you must complete before installing the product.
Install the software: Use the following sections to install Oracle Database:
Chapter 3 describes how to use Oracle Universal Installer to install Oracle Database and Automatic Storage Management.
Appendix A provides information on performing noninteractive (silent) installations, which you may want to use if you need to perform multiple installations of Oracle Database.
Appendix B describes globalization support information.
Appendix C provides troubleshooting advice in case you encounter problems with the installation.
Chapter 5 describes how to remove Oracle Database.
Complete postinstallation tasks: Chapter 4 describes recommended and required postinstallation tasks.
The following product is installed by default during a client installation for 11g release 1:
Oracle SQL Developer is a graphical version of SQL*Plus that gives database developers a convenient way to perform basic tasks. Following are the functions you can perform with Oracle SQL Developer:
Browse, create, edit, and delete (drop) database objects
Run SQL statements and scripts
Create, edit, compile and debug PL/SQL code
Create, edit and update data
Import data, export data and data definition language
View and create reports
View metadata and data of Microsoft Access, Microsoft SQL Server, and MySQL databases
This section contains information that you should consider before deciding how to install this product. It contains the following sections:
The platform-specific hardware and software requirements included in this installation guide were current at the time this guide was published. However, because new platforms and operating system software versions might be certified after this guide is published, review the certification matrix on the OracleMetaLink Web site for the most up-to-date list of certified hardware platforms and operating system versions. The OracleMetaLink Web site is available at the following URL:
https://metalink.oracle.com
You must register online before using OracleMetaLink. After logging in, click Certify from the top right-hand side of the screen. The Certifications page appears. Other options include Product Availability, Desupport Notices, and Alerts.
SQL Developer can be used to view metadata and data of several non-Oracle databases. The following table lists the third-party database certifications.
| Database | Releases | Notes |
|---|---|---|
| Microsoft Access | Access 97
Access 2000 Access 2003 |
For any Access release: no JDBC driver needed, but you must ensure read access to the system tables in the.mdb file. |
| Microsoft SQL Server | SQL Server 7
SQL Server 2000 SQL Server 2005 |
For any Microsoft SQL Server release: JDBC driver jtds-1.2.2.jar required. This is included in the jtds-1.2-dist.zip available from sourceforge.net. |
| MySQL | MySQL 3.x
MySQL 4.x MySQL 5.x |
For any MySQL release: JDBC driver required.
For MySQL 5.x: |
This product supports multiple Oracle homes. This means that you can install this release or earlier releases of the software more than once on the same system, in different Oracle home directories.
You must install this product 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 release 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, then the installation fails.
You can install this release more than once on the same system if each installation is installed in a separate Oracle home directory.
You can choose different installation methods to install Oracle Client, as follows:
When you use the interactive method to install Oracle Client, Oracle Universal Installer displays a series of screens that enable you to specify all of the required information to install the Oracle Client software.
By creating a response file and specifying this file when you start Oracle Universal Installer, you can automate some or all of the Oracle Database installation. These automated installation methods are useful if you need to perform multiple installations on similarly configured systems or if the system where you want to install the software does not have X Window system software installed.
When you use a response file, you can run Oracle Universal Installer in the following modes, depending on whether you specify all of the required information or not:
Silent Mode: Oracle Universal Installer runs in silent mode if you use a response file that specifies all required information. None of the Oracle Universal Installer screens are displayed.
Suppressed Mode: Oracle Universal Installer runs in suppressed mode if you do not specify all required information in the response file. Oracle Universal Installer displays only the screens that prompt for the information that you did not specify.
For more information about these modes and about how to complete an installation using response files, refer to Appendix A.
You can choose one of the following installation types when installing Oracle Client:
Instant Client: Enables you to install only the shared libraries required by Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), Pro*C, or Java database connectivity (JDBC) OCI applications. This installation type requires much less disk space than the other Oracle Client installation types.
See Also:
Oracle Call Interface Programmer's Guide or Oracle Database JDBC Developer's Guide and Reference for more information about Instant ClientIncluded in the Instant Client installation is Instant Client Light. You may want to use this version of Instant Client if the applications generate error messages in American English only. Instant Client Light is beneficial to application that use one of the supported character sets and can accept error messages in American English. The following are the supported character sets:
US7ASCII
WE8DEC
WE8ISO8859P1
WE8EBCDIC37C for EBCDIC platform only
WE8EBCDIC1047 for EBCDIC platform only
WE8MSWIN1252
UTF8
AL32UTF8
AL16UTF16
The advantage of using Instant Client Light is that it has a smaller footprint than the regular Instant Client. The shared libraries, which an application must load, are only 34 MB as opposed to the 110 MB that regular Instant Client uses. Therefore, the applications use less memory.
Administrator: Enables applications to connect to an Oracle Database instance on the local system or on a remote system. It also provides tools that enable you to administer Oracle Database.
Runtime: Enables applications to connect to an Oracle Database instance on the local system or on a remote system.
Custom: Enables you to select individual components from the list of Administrator and Runtime components.
Caution:
AL32UTF8 is the Oracle Database character set that is appropriate for XMLType data. It is equivalent to the IANA registered standard UTF-8 encoding, which supports all valid XML characters.Do not confuse Oracle Database database character set UTF8 (no hyphen) with database character set AL32UTF8 or with character encoding UTF-8. Database character set UTF8 has been superseded by AL32UTF8. Do not use UTF8 for XML data. UTF8 supports only Unicode version 3.0 and earlier; it does not support all valid XML characters. AL32UTF8 has no such limitation.
Using database character set UTF8 for XML data could potentially cause a fatal error or affect security negatively. If a character that is not supported by the database character set appears in an input-document element name, then a replacement character (usually "?") is substituted for it. This terminates parsing and raises an exception.
For information about upgrading a earlier release of Oracle Database to Oracle Database 11g release 1 (11.1), refer to Oracle Database Upgrade Guide. The following sections provide additional platform-specific upgrade information that you should review before upgrading an existing database:
Note:
The information in this section does not apply to an upgrade of a release 1 (9.0.1) or later release of Oracle Database.Before you upgrade an existing database that uses the AL24UTFFSS character set, you must upgrade the database character set to UTF8. Oracle recommends that you use the Character Set Scanner (csscan) utility for data analysis before attempting to upgrade the existing database character set.
The Character Set Scanner utility checks all character data in the database and tests for the effects of, and problems with, changing the character set encoding. Before running the Character Set Scanner utility, set the shared library path environment variable for the platform to include the $ORACLE_HOME/lib directory. The shared library path environment path that you need to set is LD_LIBRARY_PATH.
Note:
AL32UTF8 is the Oracle Database character set that is appropriate for XMLType data. It is equivalent to the IANA registered standard UTF-8 encoding, which supports all valid XML characters.Do not confuse Oracle Database database character set UTF8 (no hyphen) with database character set AL32UTF8 or with character encoding UTF-8. Database character set UTF8 has been superseded by AL32UTF8. Do not use UTF8 for XML data. UTF8 supports only Unicode version 3.0 and earlier; it does not support all valid XML characters. AL32UTF8 has no such limitation.
Using database character set UTF8 for XML data could potentially cause a fatal error or affect security negatively. If a character that is not supported by the database character set appears in an input-document element name, then a replacement character (usually "?") is substituted for it. This will terminate parsing and raise an exception.
See Also:
Oracle Database Globalization Support Guide for more information about Character Set Support
