2.oracle installation knowledge, ORALCE Server, Oracle Cluster, Oracle service Introduction, user unlock related



1 installation Knowledge of Oracle (oracle10g and oracle11g version differences ) :

A the installation directory should not have Chinese and white space

B oracle10g support winxp does not support win7,8 and vista;oracle11g supports all versions

2 oralce Server: comprised of Oracle instances and Oracle databases

Oracle Database: A collection of physical files on disk

A When you configure the Oracle_home , you can pass Echo$oracle_home to view Oracle the installation directory

B bin directory (storing 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 Example: An abstract memory image of a physical file, read into memory

3 Oracle Cluster

Cluster Oracle a Oracle a database can map multiple instances.

Benefits:

A Load Balancing

B failed Migration

4 about the oracle10g Related services and user-related

A Scott Default user password is Tiger

B oracleserviceorcl:oracle Background Process Service

C oracleoradb10g_home1tnslistener: listening server , corresponding port number:1521

E oracleoradb10g_home1isql*plus:web version of sqlplus tool 5560 b/S architecture (11g removed )

F sqlplus Tools

5 If the user is not unlocked in the installation database, you can manually unlock the account and set the password by:

A log in as Administrator

Password Authentication method: Sqlplussys/password as SYSDBA;

Host authentication method: sqlplus/assysdba ( premise: The user of the operating system is the database administrator )

B Unlock

alter user scottaccount unlock; ( Scott is the user name )

C Change Password

Alter user scottidentified by pass123 ( paas123 here for new password )

2.oracle installation knowledge, ORALCE Server, Oracle Cluster, Oracle service Introduction, user unlock related