[01] Oracle Database introduction, 01oracle database Introduction
Oracle relational database: built on the relational model.
Oracle10g: g (grid) Grid technology. grid Computing connects a large number of computers through network sharing and integrates the redundant processing capabilities of each computer, produce huge data processing and computing capabilities.
1. Glossary:
Database (DB): a collection of physical files (data files, control files, online logs, etc.) or a logical structure (tablespace, segment, etc.) that corresponds to it is called a Database.
Database System (DBS)
Database Management System (DBMS)
Database Administrator (DBA)
Database Instance: The ORACLE memory structure and backend process are called Database instances.
Real Application Clusters RAC)
2. Oracle features:
Global and cross-platform support
Multi-user, high-performance service handling capability
Strong security control and Integrity Control
Support distributed databases and distributed processing
3. Database Installation notes:
Disable the firewall during installation. Otherwise, the installation may fail.
Once the character set is selected, it can only be reinstalled unless it is changed to the parent class of the character set.
When Oracle is enabled, tomcat port 8080 is used. Check the port number: tasklist | findstr "8080 ".
After the database is installed, the machine name is modified, and the Listener service cannot be started. Solution: Modify the HOST under C: \ oracle \ ora92 \ network \ admin \ listener. ora.
The oradata file directory stores database data files and log files. Apart from oracle files, you can change the location of other files.
4. Detach a database
(1) Stop all Oracle services
(2) run Oracle Universal Installer to uninstall Oracle
(3) modify the registry and delete Oracle information:
A) The Oracle SOFTWARE has a key value: HKEY_LOCAL_MACHINE \ SOFTWARE \ Oracle
B) Oracle service: HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services
C) Oracle Event Log: HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ App
(4) Delete the Oracle System Directory
(5) delete Oracle environment variables
(6) Delete the Oracle menu in the program menu item
(7) (after the system is restarted) Delete the Oracle working home directory
5. database users
Common users: Scott/tiger (frequently used)
Common administrator: System/system
Super administrator: Sys/sys
6. SQL Introduction
SQL: Structured Query Language, which was first used by IBM,
DDL statements (Data Definition Language, change table structure) Create, Alter, Drop, and Truncate
DML statements (data operation language, changing the data structure) Insert, Update, Delete, Merge
DCL Statement (Data Control Language, permission Control) Grant, Revoke
Transaction control statement Commit, Rollback, Savepoint