2013年7月26日
关于OEM
摘要： OEM查看OEM控制台状态dbserver-> emctl status dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.https://dbserver.localdomain:1158/em/console/aboutApplicationOracle Enterprise Manager 11g is not running. ------------- 阅读全文
posted @ 2013-07-26 16:29 ArcerZhang 阅读(230) 评论(0) 推荐(0) 编辑
oracle开机自启动、监听自启动设置
摘要： 1、root用户下修改/etc/oratab文件:将ora9idb:/u01/app/oracle/product/9.2.0/db_1:N改为ora9idb:/u01/app/oracle/product/9.2.0/db_1:Yora9idb:/u01/app/oracle/product/9.... 阅读全文
posted @ 2013-07-26 13:32 ArcerZhang 阅读(1225) 评论(0) 推荐(0) 编辑
Oracle9i安装
摘要： 参考文档:我的网盘->OracleInstall->文章一、安装前准备0、打补丁包p4198954_21_LINUX.zip实际上此包里的内容只是compat-oracle-rhel4-1.0-5.i386.rpm、compat-libcwait-2.1-1.i386.rpm两个rpm包，使用rpm -ivh安装上即可.除此之外还要搭上下面的补丁包rpm -q compat-dbcompat-gcc-32compat-gcc-32-c++compat-oracle-rhel4compat-libcwaitcompat-libgcc-296compat-libstdc++-296co 阅读全文
posted @ 2013-07-26 13:20 ArcerZhang 阅读(295) 评论(0) 推荐(0) 编辑
auditing
摘要： AuditingAuditing is the monitoring of selected user database actions,and is used to:Investigate suspicious database activityGather information about specific database activitiesAuditing can be performed by session or accessby session:用户登陆上来后，发出同类型的SQL语句，oracle只会记录一条.bu access:发出一条sql语句，Oracle就会记录一条. 阅读全文
posted @ 2013-07-26 10:54 ArcerZhang 阅读(215) 评论(0) 推荐(0) 编辑