1 oracle universal installer(OUI)
?used to install,upgrade,or remove software components and create a database
?./runInstaller(unix)
?Non-interactive installation using response files
?./runInstaller -responsefile myrewpfile -silent(用指定的安裝文件)
2 OracleDatabase Configuration Assistant(DBCA)
? creaste a database ,configure database options ,delete a database,manage template
3 Database Administrator Users
? Sys is the owner of the database data dictionary
? System is the owner of additional internal tables and views used by oracle tools
4 Local DataBase Administrator
? create os user id
? create os group ora dba,ora fox dba
??????????? ora_oper,ora_fox_oper
? add os user id to ora_dba,group
? edit sqlnet file: slqnet.authentication_services=(nts)
? you can login in database
? conn / as sysdba
5 User Password File Authentication（由于數(shù)據(jù)庫(kù)還沒(méi)有啟動(dòng)，需要利用數(shù)據(jù)庫(kù)外面的如文件系統(tǒng)，或口令文件來(lái)管理具有特出權(quán)限的用戶）
? 1 create the password file using the password
? orapwd file='d:\oracle\ora90\database\pwd<sid>.ora' password=admin1 entries=10;
? conn sys/admin1 as sysdba
? 2 set remote_login_passwordfile to exclusice
?? 1 orapwd?
?? 2 edit inti parameter file remote_login_passwordfile to exclusive
?? 3 grant system to kang （最多只能授權(quán)orapwd 中 entries參數(shù)指定用戶用戶數(shù)，具有此特出權(quán)限）
???? revoke sysdba form kong
?? select * from V$pwfile_users(查看有多少用戶具有特出權(quán)限)
6 sql/plus
? sqlplus /nolog? sqlplusw /nolog
? set autocommmit on
? set linesize 1000
7 Oracle Enterprise Manager Architecture
? Oracle Management Server，repository ，agent ，oracle server
? oracle 獨(dú)立登陸，雖然能夠聯(lián)機(jī)oracle ，但是很多管理更能不能操作，如backup 等
8 oem console
?? central launching point for all applications
?? can be run in thin mode(web) or as a fat client
?? can bu launched either standalone or through oracle management server
?????????