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

01 introduction to Oracle and installation of 1.Oracle

Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle.

Oracle database system is a popular relational database management system in the world at present. The system has good portability, easy to use and strong function, and is suitable for all kinds of large, medium, small and microcomputer environments.

The database server optimally manages the database table and handles multiple clients' concurrent access to the same data. Comprehensively maintain data integrity and control security requirements such as database access

2.Oracle 11g installation 2.1 Oracle 11g download official download address: http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html Baidu network disk download address: link: https://pan.baidu.com/s/1mixeCKo password: a95s2.2 Oracle installation

Reference: Oracle 11g installation guide .doc

2.3 install PLSQL Developer

Reference: PLSQL Developer connects to a local Oracle 11g 64-bit database. Doc

Three connection identities of 3.Oracle, sysdba, that is, database administrator

Permissions include: opening the database server; shutting down the database server; backing up the database; restoring the database; log archiving; session restrictions; administrative functions; creating the database

Sysyoper is the database operator

Permissions include: open the database server; shut down the database server; back up the database; restore the database; log archiving; session restrictions

Normal is an ordinary user.

Permission can only query the data of certain data tables

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.