Oracle Database Self-study Tutorial - 1

Because I used chinese version, maybe there are several special words are not correct, but it should be no problem to understand.

Download and Installation

Download Source: www.oracle.com
Recommend Version: Oracle Database 11g Release 2
* c – cloud; g – grid; i – internet

Installation Steps:
a. unzip two downloaded files into the same file.
b. double click setup.exe file to run the installation program.
c. check the option of Single Instance Database.
d. check the option of Enterprise version.
e. following the next steps to complete installation.

Database Creation

Creation Steps:
a. click win into the menu view, and open Oracle Databse folder.
b. open Configuration and porting tools folder, and you will find the Database Configuration Assistant, click it.
c. check option of Creating Database.
d. check box of general purpose or event....
e. you need edit the global/universal database name and SID (the name of instance).
f. uncheck the box of Enterprise Manager Configuration, because it will spend too much resource during it is running.
g. passwords of SYS and SYSTEM, sys is the owner of database, system is the people who operate this database.
h. following steps, and do not forget check the box of example solution.
i. in the pop window, database configuration assistant, click the password management, unlock the scott and hr with new passwords.

Testing:
a. from the oracle database folder, you can find the SQL Plus tool in the folder named application development.
b. in the SQL Plus command tool, you should type the username and password, like scott and the correspond password.

Listener Configuration

Configuration Steps:
a. find the Net Configuration Assistant, click it.
b. choosing the Listener Configuration option, Add with next button.
c. Edit Listener name.
d. TCP protocol.
e. port number.

Testing:
a. win+R, type services.msc.
b. find the OracleOrlDb11g_home1TNSListener, if existing, then successful. This file is working for the listener which you created one minute ago.
c. the file OracleServiceORCL is working for the instance of database service.