Page 461
CAUTION |
If you have a previous installation of SQL*Net, Oracle recommends that you remove all the components first before installing an upgraded version. This is done by selecting Custom Installation and removing all com-ponents on the right side of the screen. I do not believe this is necessary, but you can never be too careful. |
The core SQL*Net files installed are shown on the right side of the Oracle Installer screen, while available applications are shown on the left. If you will be working with older versions of Oracle databases, you'll need to load the Required Support Files (RSFs) for those versions. The 7.3 RSFs will already be installed. If you might use Oracle 7.2, install those RSFs too. It is good to install SQL*Plus for support and testing reasons as well. If support for Oracle 7.1 or 7.0 is needed, you will need to get an older Oracle CD-ROM to find these older RSFs.
To install specific product components, double-click the desired product in the Products Available list and then select the specific component to install. Click Install to begin product installation.
TIP |
One update you should do immediately is to add a parameter to the ORACLE.INI file. Add the key USERNAME under the [Oracle] section. The value for this key should be the user's name. This value is used when a SQL*Net connection is made to the Oracle server. This value is displayed on the server for your connection. This will aid releasing connections to shutdown the database. |
TIP |
Two other changes to the ORACLE.INI file should be considered. The key CNTL_BREAK=ON in the [Oracle] section will allow a Ctrl+C keypress to stop a long query. Also, changing the value for NLS_LANG can improve the order data is sorted using the ORDER BY clause. PeopleSoft software running against Oracle requires that the US7ASCII character set be used. Use the following syntax in the ORACLE.INI file: NLS_LANG=AMERICAN_AMERICA.US7ASCII. |
This description assumes that you will be installing a local version of 32-bit SQL*Net on a local hard drive. If you are running Windows 95 or Windows NT, your PC will probably autorun the installer for the appropriate 32-bit version of SQL*Net for your operating system. If the Oracle Installer is autorun, skip to step 2: Select Oracle Installation Settings. Otherwise, start with step 1 below to install 32-bit SQL*Net:
Page 462
CAUTION |
If you have a previous installation of SQL*Net, Oracle recommends that you remove all the components first before installing an upgraded version. This is done by selecting Custom Installation and removing all components on the right side of the screen. |
The core SQL*Net files installed are shown on the right side of the Oracle Installer screen, while available applications are shown on the left. If you will be working with older versions of Oracle databases, you will need to load the Required Support Files (RSFs) for these versions. The 7.3 RSFs will already be installed. If you might use Oracle 7.2, install these RSFs too. It is good to install SQL*Plus for support and testing reasons as well. If support for Oracle 7.1 or 7.0 is needed, you will need to get an older Oracle CD-ROM to find these older RSFs.