oracle 管理学习笔记2--oracle 系统工具

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
         

posted on 2006-08-07 10:36 康文 阅读(188) 评论(0)  编辑  收藏 所属分类: 数据库


只有注册用户登录后才能发表评论。


网站导航:
 
<2006年8月>
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789

导航

统计

常用链接

留言簿(1)

随笔分类

随笔档案

文章档案

搜索

最新评论

阅读排行榜

评论排行榜