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(由于数据库还没有启动,需要利用数据库外面的如文件系统,或口令文件来管理具有特出权限的用户)
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 (最多只能授权orapwd 中 entries参数指定用户用户数,具有此特出权限)
revoke sysdba form kong
select * from V$pwfile_users(查看有多少用户具有特出权限)
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 独立登陆,虽然能够联机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