Oracle Database Foundation-Installation

I. Basic knowledge of the database

1. Concept

Database full Name database management system, referred to as DBMS, is a kind of technology to manage, store and share data in computer.

2. Classification

In the process of database development, according to the logical model can be divided into the following types:

3. Relational database

Ps:

1. Candidate keys, primary keys, foreign keys are defined by the user, in general, the definition of these keys will match the business, real data.

2.NF paradigm: In the relational model database, in order to exclude data redundancy, data integrity, exclusion of new or deleted data anomalies, usually introduce the concept of paradigm;

The normal form is called NF, Total has 6 kinds: 1nf\2nf\3nf\bcnf\4nf\5nf;

The implementation of the paradigm is achieved from the lowest to the highest order, to achieve a high-level paradigm, provided that the low-class paradigm has been achieved, generally speaking, only need to reach 3NF.

3. About 3NF: 3NF is usually achieved by splitting the table, can be combined with the E-r diagram to achieve the operation of the table, the steps: A. Identify all the independent entities in the current table; b. Determine the relationship between entities, decomposition attributes; c. build a table

4.NoSQL database: Not only SQL, non-relational database, is accompanied by internet applications, big data generated.

Second, Oracle server

1. Installation

Open the Oracle Software installation package, double-click on the Setup.exe installation, note the following points when installing and remember:

A. Administrator password (must be set)
B. Name of the database (global database name)
C.sid

Install to the interface, the name of the database (global database name) and SID are the same as their own settings, if you click OK, the installation is complete.

2. Detection

A. View services: oracleservice Instance Name (the instance name is the global database name) → Multiple databases can be installed under an Oracle server, and each database (instance) has its own service process.

Oracle .... Tnslistener: A listener that is used to provide remote access, the service must be started, or remote access cannot be achieved

Oracledbconsole Instance Name: Only used to provide OEM services, OEM refers to Oracle Enterprise Manager, is a b/s architecture based on the management side, in the enterprise, the service is generally disabled. OEM Address: OEM's address:

IP address of Oracle 10g:http://server: 1158/em
IP address of Oracle 11g:https://server: 1158/em

B. Order

Oracle comes with a login command called Sqlplus, Syntax format: Sqlplus username/password [@ NETWORK service name] [identity], access to the remote Oracle server, only need to use the @ Network service name.

Oracle default administrator has two: Sys/system, SYS is a super administrator, whenever you use SYS to log in to Oracle, you need to indicate the login as System administrator (as SYSDBA)

In general, on an Oracle server, you only need to enter the following command: Sqlplus/as SYSDBA

Third, Oracle client

Oracle is a client/server architecture (client/server) software, and if you want to access the Oracle database remotely, you will need to install the Oracle client locally, after the installation is complete, as set out below.

1. Server-side configuration (usually with DBA operation)

Open Netmanager, configure the Listener listener→ listening location: Using TCP/IP protocol; Host: Fill in the computer name of the Oracle server; port: default is 1521;
Database service: It is recommended to manually add a database that needs to provide remote access functionality;
menu, click File-Save network configuration;
Restart the monitoring service: generally only in the exception to do the operation, command Lsnrctl→stop→start;

2. Configuration of the client * * *

Open the Netmanager in the client:

A. Listening: Click Add Listener, then click Add Address, use the default value.
B. Service naming: • Network Service Name: Can fill in, suggest meaningful, in fact, is the alias of the connection configuration. Required in subsequent connections (command, graphical client).
• Hostname: Fill in the IP address of the machine that is connected to the Oracle server.

• Service Name: Because multiple instances of Oracle can be installed on a single Oracle server, one connection can only connect one instance. This is where you specify the instance name (the global database name
C. FILE-Save network configuration.

The final interface appears, indicating that the server has been successfully connected.

PS: A service naming corresponds to a connection configuration for a remote instance; In general, we will implement the connection configuration by manually modifying the file Tnsnames.ora under/network/admin in the home directory of the Oracle client.

Iv. PL/SQL Devoloper

In Oracle development, third-party tools are typically used to assist in writing Sql,pl/sql, which is currently the most commonly used. You can use it to connect to our Oracle server directly after installation. The interface is roughly as follows:

Five, Oracle Enterprise Manager (Oracle Enterprise managers, referred to as OEM)

Oracle9i earlier versions of Enterprise Manager are application based on the C/s architecture, OEMs need to be installed separately on the machine to be able to use, and from oracle10g onwards, OEM edge transfer to the web system, this remote management Oracle brings convenience. All work can be done in the OEM, such as creating tablespaces and data files, creating users, creating tables, and so on.

OEM's address:
IP address of Oracle 10g:http://server: 1158/em

IP address of Oracle 11g:https://server: 1158/em

Oracle Database Foundation-Installation