Shulou(Shulou.com)06/02 Report--

Oracle Installation 11g:

1. Download oracle package through official website www.oracle.com, there are 1 and 2 respectively, extract both, and then merge them together, for example:

2. Note before installation: turn off the virus firewall to ensure that the system is healthy and normal

3. Double-click setup.exe

When configuring the database name, there will be a sid content, which refers to ServerID, service ID, used for network connection. In general, it is recommended that the database name be exactly the same as the SID name.

In our oracle database will be provided by default Nuogan users, each user has different permissions, here will ask whether to define a password for each user separately, in order to facilitate the unified password "oracleadmin".

After installation, configure database user permissions

Super Admin: sys/change_on_install

General Manager: System/Manager

User: Scott/Tiger

Big Data Users: sh/sh

Set passwords for four users and unlock them. Then click OK and the installation is complete

Oracle Services:

Oracle must start system services during use

Because oracle will consume a lot of system memory, it is recommended to start Oracle database services manually. There are two services in the given service.

OracleOraDbllg_home1TNSListener listening service, client access to local use. In the process of program development, you need to connect to the database, or tools to connect to this database, if this service is not open, you cannot connect.

Oracle Server MLDN oracle database instance service. Multiple databases can be configured on the oracle platform at the same time. Use the "Database Configuration Assistant" tool to create more databases. After each database is established, it will serve as Oracle Server SID. If you want to use MLDN database for data speculation, then this service must be enabled.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.