Castle.eiu.edu



Oracle10g Download and Installation

12/19/2005

Peter Ping Liu

To all students:

It is super important to take detailed notes when you install any system and database software. There are a lot of details you may take it as granted but will never be able to remember them exactly if you do not write them down. The information will be very valuable for trouble shooting.

The following is my record.

Oracle 10g

Windows XP on Desk top PC in the office (EIU#148026)

Go to Oracle Technology Network, at otn., in order to download the software (Oracle 10g Enterprise Edition for Windows).

[pic]

Choose Oracle 10g for Windows

Accept Software License Agreement.

[pic]

Download the Complete Files

[pic]

Unzip the files, for example, to a folder under the same directory. You may unzip to any where you like.

[pic]

Browse to find setup.exe file.

[pic]

On the Basic Installation Screen: (Please note down all the details.)

Oracle Home Location: C:\oracle\product\10.2.0\db_1

Installation type: Enterprise Edition (13GB)

Create Starter Database (additional 720 MB)

Global Database Name: oracle (I did not use the default, orcl)

Database Password: pingliu (for SYS, SYSTEM, SYSMAN AND DBSNMP accounts)

You may use your own password. But, please write them down since we all forget some time.

On this version, you cannot use “change_on_install” or “manager” as passwords, as in previous version.

[pic]

[pic]

[pic]

Click “Yes” to ignore network setting problem since I am installing the software to a PC instead of a server.

[pic]

Ignore the warning for my computer system.

[pic]

After verifying the products, click “Install.”

[pic]

Click “Password Management.”

Uncheck the “SCOTT” and “HR” accounts. SCOTT will be used in some of the exercises for this class.

[pic]

Enterprise Manager Database Control URL - (oracle) :



Your database configuration files have been installed in C:\oracle\product\10.2.0 while other components selected for installation have been installed in C:\oracle\product\10.2.0\db_1. Be cautious not to accidentally delete these configuration files.

The iSQL*Plus URL is:



The iSQL*Plus DBA URL is:



[pic]

Click “Exit.”

[pic]

Click “Yes.”

It will automatically start default browser for Oracle Enterprise Manager (EM) database control.

[pic]

The Netscape browser in my computer does not support Oracle Enterprise Manager (EM). Close it and use Microsoft Internet Explorer.

[pic]

Login using:

User Name: sys

Password: pingliu (which I entered before installation of Oracle 10g.)

Connect As: SYSDBA

[pic]

Scroll down and click “I Agree.”

[pic]

The above shows the database (oracle) was online. In other words, the database installation was successful and the sample database was open.

[pic]

To see if the sample database is open, you may use SQL Plus to login as SCOTT/tiger.

[pic]

Password expired. Enter new password; pingliu.

After login as Scott, enter the following command:

SQL> select * from dept;

The result will be as follows:

DEPTNO DNAME LOC

---------- -------------- -------------

10 ACCOUNTING NEW YORK

20 RESEARCH DALLAS

30 SALES CHICAGO

40 OPERATIONS BOSTON

The above shows the database has been installed successfully.

[pic]

You may also test it using Command Prompt:

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 21 14:26:23 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect sys/pingliu as sysdba;

Connected.

SQL>

[pic]

The above also shows the database is online and login as sys/pingliu was successful.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download