Before you begin

Installing the Database

  1. Start Installer, e.g. C:\stage\database\setup.exe
  2. Click Next
  3. Check Advanced Installation
  4. Click Next
  5. Select Enterprise Edition
  6. Click Next
  7. Destination:
  8. Click Next
  9. Check that the Product-Specific Prerequisite Checks pass, and click Next
  10. Select Create a database (already selected) and click Next
  11. Select General Purpose (already selected) and click Next
  12. Database Configuration Options:
  13. Click Next
  14. Check the Use Database Control for Database Management field (already checked) and click Next
  15. As Database File Location, enter C:\ora102db\oradata
  16. Click Next
  17. Click Next
  18. Select the "Use the same password for all the accounts" field
  19. Enter welcome1 as password and confirm it
  20. Click Next
  21. Click Install (T + 10 min)
  22. Finished (T + 25 min)

  23. Installation Summary:
    Enterprise Manager Database Control URL - (orcl) :
        http://donald.disney.com:1158/em
    The iSQL*Plus URL is:
        http://donald.disney.com:5560/isqlplus
    The iSQL*Plus DBA URL is:
        http://donald.disney.com:5560/isqlplus/dba

  24. Configure the Oracle processes so that they are not started Automatically (see "Startup and Shutdown")

  25. Start Installer for Companion CD, e.g. C:\stage\companion\setup.exe
  26. Click Next

  27. Select Oracle Database 10g Products 10.2.0.1.0
  28. Click Next

  29. Select the Oracle Home in directory C:\ora102db as destination
  30. Click Next
  31. Check that the Product-Specific Prerequisite Checks pass, and click Next

  32. Click Install

  33. Installation Summary (C:\ora102db\install\readme.txt):
    The Ultra Search URL is:
        http://donald.disney.com:5620/ultrasearch
    The Ultra Search Administration Tool URL is:
        http://donald.disney.com:5620/ultrasearch/admin

  34. Start Database Configuration Assistant (Start > Programs > Oracle - ora102db > Configuration and Migration Tools)
  35. Click Next

  36. Select Configure Database Options
  37. Click Next

  38. Select ORCL (already selected) and click Next

  39. Check Oracle Ultra Search
  40. Click Next

  41. Check Use the Same Password for All Accounts (already checked)
  42. Enter welcome1 as password and confirm it
  43. Click Next

  44. Check Dedicated Server Mode (already checked) and click Finish
  45. Click OK
  46. When asked "Do you want to perform another operation?", click No

  47. Set the following environment variables:
    set DB_DOMAIN=disney.com
    set SID=ORCL
    

Startup and Shutdown

By default, the following services are started automatically: Dependencies among the services are created so that the services are started and stopped in the proper sequence. To have greater control over which services are started when you reboot your laptop, TC recommends the following:

Set the Startup Type to Manual for the database services and use the following command files to start and stop the database (click on their names to read and/or download them):

IMPORTANT: Always stop the database gracefully (i.e. execute "shutdown" from SQL*Plus when logged in as SYS) before shutting down or restarting Windows.

Applying Patches