Before you begin
Installing the Database
- Start Installer, e.g. C:\stage\database\setup.exe
- Click Next
- Check Advanced Installation
- Click Next
- Select Enterprise Edition
- Click Next
- Destination:
- Name: ora102db
- Path: C:\ora102db
- Click Next
- Check that the Product-Specific Prerequisite Checks pass, and click Next
- Select Create a database (already selected) and click Next
- Select General Purpose (already selected) and click Next
- Database Configuration Options:
- As Global Database Name, enter orcl.disney.com
- As Database Character Set, select "West European WE8ISO8859P1"
- If you want to have the
available, then check the Create database with sample schemas field
- Click Next
- Check the Use Database Control for Database Management field (already checked)
and click Next
- As Database File Location, enter C:\ora102db\oradata
- Click Next
- Click Next
- Select the "Use the same password for all the accounts" field
- Enter welcome1
as password and confirm it
- Click Next
- Click Install (T + 10 min)
- Finished (T + 25 min)
- 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
- Configure the Oracle processes so that they are not started Automatically
(see "Startup and Shutdown")
- Start Installer for Companion CD, e.g. C:\stage\companion\setup.exe
- Click Next
- Select Oracle Database 10g Products 10.2.0.1.0
- Click Next
- Select the Oracle Home in directory C:\ora102db as destination
- Click Next
- Check that the Product-Specific Prerequisite Checks pass, and click Next
- Click Install
- 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
- Start Database Configuration Assistant
(Start
> Programs
> Oracle - ora102db
> Configuration and Migration Tools)
- Click Next
- Select Configure Database Options
- Click Next
- Select ORCL (already selected) and click Next
- Check Oracle Ultra Search
- Click Next
- Check Use the Same Password for All Accounts (already checked)
- Enter welcome1
as password and confirm it
- Click Next
- Check Dedicated Server Mode (already checked) and click Finish
- Click OK
- When asked "Do you want to perform another operation?", click No
- Set the following environment variables:
set DB_DOMAIN=disney.com
set SID=ORCL
Startup and Shutdown
By default, the following services are started automatically:
- OracleDBConsoleorcl
- Oracleora102dbiSQL*Plus
- Oracleora102dbTNSListener
- OracleServiceORCL
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