Installation and configuration of oracle11g and PL/SQL (single-machine learning simple version)

Setup procedures for the database

1. Do not check to accept security updates, do not provide e-mail, skip the warning.
2. Choose to install only the database software
3. Single-instance database installation
4. Default language
5. Database version Select Enterprise Edition
6. Oracle Base directory: Store all Oracle software products and profiles, Oracle home directory: Oracle Software Installation Location
7. Direct Next (automatic prerequisite check)
8. Direct Next Step (summary display)
9. Direct next (automatic installation)
10. Installation Complete

Creation of the database and configuration of the listener

Creation of a database

1. Start menu, All Programs->oracle-> configuration and porting Tools->database config Assistant
2. Next, create a database
3. Select General user or transaction processing
4. Global database name: Database name SID: Name of instance name
5. Uncheck Configure Enterprise Manager (memory consumption)
6. SYS: Database owner SYSTEM: database operator can use the same password
7. Direct Next (Default storage type and location)
8. Direct Next (Default recovery configuration)
9. Select the instance scenario (learning to use)
10. Direct next (default initialization parameter)
11. Direct next (Database storage)
12. Click Finish
13. Click OK (CREATE DATABASE profile)
14. Select Password management after creation (change Scott's password to Tiger HR's password is hr)
15. Open the SQL plus input user name and password to connect to the test database

Configuration of the Listener

1. Start menu, All Programs->oracle-> configuration and porting Tools->net config Assistant
2. Select Listener Configuration
3. Add to
4. Direct Next (default listener name)
5. Direct next (default TCP protocol)
6. Direct Next (default port number 1521)
7. Run->services.msc Orcale Service (Tnslistener enabled: Database allows external connections, SERVICEORCL enabled: instance service enabled, database can be used)

PL/SQL configuration

1. Anonymous login in PL/SQL->tool->preferences Configure the Oracle Home:oracle installation home directory and OCI library:oracle installation home directory \bin\oci.dll
2. Modify the Tnsnames.ora file under the Oracle installation home directory \network\admin to write the relevant information based on the instance, a simple example is as follows:

ORCL = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (host=localhost) (port=1521))) (Connect_data = (SERVER = DEDI cated) (service_name = ORCL))

Installation and configuration of oracle11g and PL/SQL (single-machine learning simple version)