Oracle Database Foundation

Oracle Basic Knowledge

Key Features of Oracle

1. Support multi-user, event volume transaction processing

2. Superior performance in maintaining data security and integrity

3. Support Distributed data processing. The database distributed in different physical locations is connected with the communication network, and under the control of the distributed database management system, a logically unified database is formed to complete the data Processing task.

4. Portable, Oracle can be used on multiple operating system platforms, such as Windows, Linux, and SQL Server can only run on window platform

Unable to build libraries in Oracle can only build tables

Oracle Basic Concepts

It is a collection of data stored on disk that is logically present in tablespace form

Parse: A database can open n table space, a table space can contain n data Files . table spaces are logical concepts.

global database name

   Global database name is to ensure that your database system Each database name is unique

Global database name = database name + database domain name, such as the global database name of the Fujian node is:oradb.fj.jtyz

patterns and users can be seen as peering relationships. Switch from a mode to B mode.

start, close the database

oracleservice<sid>: Database service

Oracleoradb11g_home1tnslistener : Database monitoring Service

Oracledbconsole<sid>: Enterprise Manager service

access to enterprise management services through the following URLs in oracle11g

Https://localhost.localdomain:1158/em/console/logon/logon

oracle and the database do not have a containing relationship like DB2, an instance-----> corresponds to open a database. The next database in the RAC cluster can be connected by multiple instances.

In a single stand-alone Oracle system, you can create multiple instances and databases, but one instance always corresponds to only one database, which is associated with a configuration file.

In DB2, a DB2 system can have multiple instances, the database is contained under an instance, an instance can have multiple databases, but a database may belong to only one instance.

  global database name

   Global database name is to ensure that your database system Each database name is unique

Global database name = database name + database domain name, such as the global database name of the Fujian node is:oradb.fj.jtyz

the pattern and the user can be regarded as a reciprocal relationship. Switch from a mode to B mode.

Single-line function:

Oracle Database Foundation