How To Install Oracle 11g On Windows Desktop

BACKGROUND & OVERVIEW

The following documentation provides instructions for building an Oracle database residing on a Windows Desktop (XP Version) operating system.

ASSUMPTIONS & PRE-REQUISITES

This document expects and assumes the following:

  • The instructions are carried out by a qualified DBA, fully conversant with Oracle and Windows.
  • Access to the internet is available.
  • Access to a user-id with Local Administration privileges is available.
  • The resultant database will be standalone, i.e. not part of a cluster or failover configuration.
  • All references to SID should be replaced with correct database name as derived using the database naming standard.
  • All $variable references assume the system-wide environment variables have been configured as prescribed.
  • There is only ONE database installed on the server.

STEP-BY-STEP GUIDE

  1. Log on to the Windows Desktop with a user-id that has the Local Admin privilege.
  2. Confirm there is at least 1 GB of RAM.
    • Start>Settings>Control Panel>System>General
  3. Confirm there is at least 10 GB of spare disk space available.
  4. mkdir C:\ORACLE11G
  5. mkdir C:\ORACLE11G\SOFTWARE
  6. Set system-wide ORACLE_HOSTNAME=<windows hostname>
    • Start>Settings>Control Panel>System>Advanced>Environment Variables>System Variables>New/Edit
  7. Download the latest oracle binaries from OTN. For example:
    • Enterprise Edition for Windows Operating System (32-bit)
    • win32_11gR2_database_1of2.zip : 1,587,619 KB
    • win32_11gR2_database_2of2.zip : 617,124 KB
  8. Unzip the downloaded files ensuring they extract to directory C:\ORACLE11G
  9. Start the installer by double-clicking C:\ORACLE11G\database\setup.exe and follow the instructions as demonstrated in the Example Install section below.
  10. Set up tnanames.ora file in C:\ORACLE11G\app\oracle\product\11.2.0\NETWORK\ADMIN directory - see Example tnsnames.ora below.
  11. Test connectivity to the database using the following command from the DOS prompt:
    • sqlplus system/<password>@<SID>
    • exit
  12. mkdir C:\ORACLE11G\app\oracle\DBA\SQL
  13. Copy all required DBA SQL scripts to C:\ORACLE11G\app\oracle\DBA\SQL
  14. Configure SQLPATH=C:\ORACLE11G\app\oracle\DBA\SQL as per the instructions found here.
  15. Configure login.sql and/or glogin.sql as per the instructions found here.

SECURITY COMPLIANCE

The following steps should be performed once the database has been built to ensure that the environment conforms to Oracle's Best Practices and also ensures that it doesn't fall foul of Internal Audit. Perform the commands from the DOS Prompt.

  1. Remove the GRANT EXECUTE TO PUBLIC privilege from potentially harmful packages.
    • sqlplus / as sysdba
    • revoke execute on utl_file from public;
    • revoke execute on dbms_random from public;
    • revoke execute on utl_http from public;
    • revoke execute on utl_smtp from public;
    • revoke execute on utl_tcp from public;
    • exit
  2. Ensure the following user-ids' passwords, where applicable, have been changed:
    • SYS
    • SYSTEM
    • DBSNMP
    • OUTLN
    • CTXSYS
    • PERFSTAT
  3. Adjust the database DEFAULT TABLESPACE settings so that the SYSTEM is not used inappropriately.
    • sqlplus / as sysdba
    • alter database default tablespace users;
    • alter user sys default tablespace system;
    • alter user system default tablespace system;
    • Correct any users that already have SYSTEM as their DEFAULT TABLESPACE:
      • select username, default_tablespace from dba_users where default_tablespace = 'SYSTEM';
      • alter user <user name> default tablespace <non-SYSTEM tablespace>;
    • exit
  4. Lock and expire potentially harmful built-in user-ids.
    • sqlplus / as sysdba
    • alter user outln password expire account lock;
    • alter user dbsnmp password expire account lock;
    • exit

FILE LISTINGS

tnsnames.ora

         <SID> =
           (DESCRIPTION =
             (ADDRESS = (PROTOCOL = tcp)(HOST = <windows hostname>)(PORT = 1521))
             (CONNECT_DATA =
               (SID = <SID>)
             )
           )

FILE SYSTEM


OracleWindowsLayout.jpg

EXAMPLE INSTALL


OracleWindowsInstall_01.jpg
  • Click Run.

OracleWindowsInstall_02.jpg
  • Leave EMail blank.
  • Un-check …Receive Security Updates… tick-box.
  • Click Next.

OracleWindowsInstall_03.jpg
  • If integration with Oracle Support is required, it can be configured later.
  • Click Yes.

OracleWindowsInstall_04.jpg
  • Select Create And Configure A Database.
  • Click Next.

OracleWindowsInstall_05.jpg
  • Select Desktop Class.
  • Click Next.

OracleWindowsInstall_06.jpg
  • Enter full path to Oracle Base - e.g. C:\ORACLE11G\app\oracle
  • Enter full path to Software Location - e.g. C:\ORACLE11G\app\oracle\product\11.2.0
  • Enter full path to Database File Location - e.g. C:\ORACLE11G\oradata
  • Select Database Edition - e.g. Enterprise Edition
  • Select Character Set - e.g. Unicode (AL32UTF8)
  • Enter Global Database Name
  • Enter Administritive Password - N.B. The installer will check for appropriate complexity of the password.
  • Enter Confirm Password
  • Click Next.

OracleWindowsInstall_07.jpg
  • Check the summary.
  • Click Finish.

OracleWindowsInstall_08.jpg
  • Depending upon the specification of the desktop wait for approx 30 mins…

OracleWindowsInstall_09.jpg
  • Depending upon the specification of the desktop wait for approx 30 mins…

OracleWindowsInstall_10.jpg
  • Database Console can be configured later.
  • Click OK.

OracleWindowsInstall_11.jpg
  • Note down any information required from the Database Configuration Assistant summary.
  • Click OK.

OracleWindowsInstall_12.jpg
  • Click Close.

TROUBLESHOOTING

© copyright 2001-2014 ABCdba.com | all rights reserved