Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

01 introduction and installation of Oracle

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report