Eastern Illinois University
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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- download and installation of oracle10g by naveed baqir
- web services in oracle database 10g and beyond
- oracle database 10g pl sql programming
- oracle database sql quick reference
- oracle database 10g on windows architecture for performance
- adjusting the oracle database 10g shared pool
- oracle database 10g performance overview
- how to install oracle database 10g release2 on widows xp
- useful web links chapter 10
- download and unzip the 10
Related searches
- eastern illinois online degree programs
- eastern illinois university online degrees
- eastern michigan university high school
- eastern illinois university degrees
- eastern illinois track schedule
- eastern illinois university majors
- eastern michigan university gpa requirement
- eastern michigan university grade scale
- eastern michigan university application
- eastern michigan university graduate apply
- eastern michigan university graduate program
- eastern michigan university graduate admissions