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