Previous | Table of Contents | Next

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.

  1. For a new install, select Oracle Networking to quickly install all the components necessary for SQL*Net and TNS.
    Pick the correct underlying network protocol and the correct stack vendor and let Oracle install the rest. If the Installer finds any duplicate DLL files in the path, the Installer will ask you to rename them so they will not conflict with older versions. If you answer no, Installer will create a file listing the duplicates found.
  2. Once the installation is complete, you will be left at the two-panel Oracle Installer 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'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.

Installing 32-Bit SQL*Net

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

  1. Start the Oracle Installer. The install directory on the CD-ROM for the 32-bit version is called \WIN95 for Windows 95 and \WIN32 for Windows NT. Be sure to pick the correct directory. Change to this directory and run the program SETUP.EXE.
    To start Oracle Installer under Windows 95 and Windows NT 4.0, click Start, Run from the taskbar and type the following (substituting your CD-ROM drive letter for D): D:\WIN95\SETUP.EXE for Windows 95 and D:\WIN32\SETUP.EXE for Windows NT. Confirm the selection by clicking OK.
    To start Oracle Installer under Windows NT 3.51, click File, Run from Program Manager and type the following (again substituting your CD-ROM drive letter for D): D:\WIN32\ SETUP.EXE. Confirm by pressing OK.
    Select Oracle Installation Settings.
  2. Next you will be prompted for the language being used for the installation. After choosing a language and selecting OK, you will be presented with an Oracle Installation Settings dialog box.
  3. The selection of your Oracle home is important. Think about this before selecting the default. In this example you will be again be installing to the local hard drive. The default path for Oracle home is C:\ORAWIN95 for the 32-bit Windows 95 version and C:\ORANT for the 32-bit Windows NT version.
  4. The next screen is a wizard to automate installing products such as Oracle Networking, SQL*Plus, Documentation, and so on.

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.

  1. For a new install, select Oracle Networking to quickly install all the components necessary for SQL*Net and TNS. Pick the correct underlying network protocol and the correct stack vendor and let Oracle install the rest. For Windows 95 this will be under Winsock stacks. Pick the configuration for Microsoft Windows 95 if you're using the native TCP/IP stack. If the Installer finds any duplicate DLL files in the path, it will ask you to rename them so they will not conflict with older versions. If you answer no, Installer will create a file listing the duplicates found.
  2. Once the installation is complete, you will be left at the two-panel Oracle Installer 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.

Previous | Table of Contents | Next