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

1. Introduction to Oracle

In 1977 Larry, an American, established a software development laboratory.

In 1980, the first commercial relational database (RDBMS) in the world was developed with cAccord.

In 1983, the company changed its name to Oracle Corporation (Oracle)

With more than 30 years of development, Oracle has become a leading information management software supplier and independent software development company in the world. Oracle technology involves almost every industry.

April 21, 2009, formerly SUN-> Oracle

Market share: [Oracle (54%)-> IBM-DB2 (21%--)-> MicrosoftMSSQL (14%)]

Oracle certification category:

* (1) Development technology certification: Java certification

Database development language SQL and PL/SQL authentication

(2) Database technology certification:

OCM Certification [Master]

OCP certification [expert]

OCA certification [entry]

(3) Middleware technology certification: OracleServer authentication, WEB server authentication,.

(4) Applied technology certification in professional fields:

ERP certification

CRM certification

HR certification

OA certification

TAX certification.

On July 12, 2007, Oracle launched Oracle11g in the United States, recommending at least the use of JDK6

It has more than 400 functions and has been tested for 15 million hours, and the development workload has reached 36000 person / month.

Early: Oracle8i,9i, [10i]-(I stands for internet)

Recently: Oracle11g- (g stands for grid), which uses multiple Oracle servers as a host, grid computing is generally regarded as the computing method of the future.

Now: oracle 12c (clound converged cloud computing server)

In window7/8, query the name of the port: netstat-a, or use other third-party tools to query the port number on the current computer

The main port of the oracle database is 1521, which is usually fixed, provided that the "OracleOraDb11g_home1TNSListener" service is started when the computer is started.

Quotation: oracle11g Enterprise / Standard / personal Edition-¥195000 +-

Quotation: oracle12c Enterprise / Standard / personal Edition-¥317900 +-

2. Oracle installation

Operating system: Windows 8.1Enterprise 64bit

Step 1:

Double-click setup.exe

Step 2:

Cancel "Security Update"

Step 3:

In the installation options, select create and configure Database

In the system class, select Desktop Class.

Step 4:

In a typical installation, select the Oracle base directory, select UTF8 in the character set, and set the administrative password (for example: root).

Step 5:

6. Test whether the installation is successful

Enter after running cmd

Sqlplus / as sysdba

If you can log in, the installation is successful.

If you encounter an ORA-01031: insufficient privileges error, as shown below

The possible reason is that the user who logged in to windows (administrator or the user who installed oracle) is not included in the ORA_DBA group.

Reference: http://blog.csdn.net/wyzxg/article/details/4301266

The workaround is to add the current user to the ora_dba group (no need to restart Windows) and try to log in again.

Schematic diagram of adding a user to a user group

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.