Oracle database installation and connectivity and introduction

Installation of Oracle Database

1. Login to Oracle website-Trial and download

2. Consent Agreement--->file1

3. Complete the configuration

4. Test Connection: Open Oracle Developer---> New connection, note user name sys, password is set in step three, role: System administrator, Global database name: The third step has been set

Physical storage structure

1. Physical files: Data files, control files, redo log files, archive files, initialization parameters files, trace files, password files, warning files, backup files

Mainly refers to: Data file (*.dbf) control file (*.ctl) Redo log file (*.log)

2. Operations on data files: Create data files, modify data files, change the availability of data files, change the name and location of data files, delete data files, query data files

3. Operations on Log files: Add redo log file groups, add redo log filegroup Members, change the name or location of redo log filegroup member files, delete redo log filegroup Members, delete redo log file group, redo log file group switchover, view redo log file information, archive redo log file

Oracle database installation and connectivity and introduction