2. oracle installation knowledge, oracle server, oracle cluster, oracle service Introduction, user unlocking

2. oracle installation knowledge, oracle server, oracle cluster, oracle service Introduction, user unlocking

1 oracle installation knowledge (oracle10g and oracle11g versions are different ):

A installation directory does not contain Chinese characters or spaces

B oracle10g supports winxp and does not support win7, 8, and vista. Oracle11g supports all versions.

2 Oralce server: composed of oracle instances and oracle databases

Oracle Database: a set of physical files on a disk

A When oracle_home is configured, you can use echo $ ORACLE_HOME to view the oracle installation directory.

B bin directory (stores the exe tool), Location: F: \ app \ to-to \ product \ 11.2.0 \ dbhome_1 \ BIN

C lib directory (oracle dependent lib), Location: F: \ app \ to-to \ product \ 11.2.0 \ dbhome_1 \ LIB

D oradate directory (control file, data file, Log File Location :): F: \ app \ to-to \ oradata

E sqldeveloper: F: \ app \ to-to \ product \ 11.2.0 \ dbhome_1 \ sqldeveloper

Oracle instance: the memory image of the abstract physical file, read to the memory

3 oracle Cluster

A cluster oracle database can map multiple instances.

Benefits:

A server Load balancer

B Migration failed

4. Oracle10g related services and users

The default password of A scott is tiger.

B OracleServiceORCL: oracle background process service

C OracleOraDb10g_home1TNSListener: listener server. Port: 1521

E OracleOraDb10g_home1iSQL * Plus: web-based sqlplus tool 5560 B/S architecture (11g removed)

F sqlplus Tool

5. If the user is not unlocked after the database is installed, You can manually unlock the account and set the password:

A. Log on as an administrator.

Password Authentication Method: sqlplussys/password as sysdba;

Host Authentication Method: sqlplus/assysdba (prerequisite: the operating system user is the database administrator)

B. Unlock

Alter user scottaccount unlock; (scott is the user name)

C. Change Password

Alter user scottidentified by pass123 (paas123 is the new password)