Category Archives: Study

Oracle技术嘉年华闭幕

Oracle技术嘉年华胜利闭幕!
忙了一个多月的时间,尤其是会议之前的半个月连续工作无休,会议结束后,突然感觉神经无法放松了。
会议前半个月,每天50+邮件,其中一半为英文。
会议前一天,下午到会场,布置、安排、接待,忙碌到深夜,不进油盐。通宵未睡,回复各位嘉宾邮件、联系前台调换房间、准备会议当天文件,以防万一。
会议当天,6点制作出ACOUG 3D Timeline,7点进入会场确认各项事宜、9点正式开幕。全天未休未吃饭。晚上瘫倒。
第二天一切正常。
现在,每天10封邮件,睡不醒。
从始至终,了解到很多新的知识,各方面的经验也增加了不少。
流水账一般记录一下,我需要好好休息几天。

Linux命令——history查看用户操作记录及时间

默认情况下Linux里使用history命令,只显示序列和命令,不含执行时间和执行用户:

image

修改/etc/profile文件,在末尾添加:export HISTTIMEFORMAT=”%F %T `whoami` ”

[[email protected] ~]# history | tail
  515  2011-09-08 15:34:46 root exit
  516  2011-09-08 15:34:02 root history | grep passwd
  517  2011-09-08 15:34:47 root exit
  518  2011-09-08 15:34:52 root su - marshall
  519  2011-09-08 15:58:45 root exit
  520  2011-09-08 16:02:12 root cat /etc/pro
  521  2011-09-08 16:02:15 root cat /etc/profile
  522  2011-09-08 16:02:24 root history
  523  2011-09-08 16:02:40 root history tail
  524  2011-09-08 16:02:45 root history | tail

因为某用户密码被修改,才想到了修改history命令的显示输出。可结合last命令查看谁在何时做了啥操作。

参考:http://www.itdhz.com/post-74.html

Use orabf to crack Oracle user’s password

看到PUB上一个帖子,询问Oracle用户密码忘记如何找回,结果8楼一个哥直接上了个破解工具,遂学习之。

可使用orabf工具破解,工具介绍:

Orabf is an extremely fast offline brute force/dictionary attack tool that can be used when the particular username and hash are known for an Oracle account.  Obviously the speed of the brute force attack slows down the longer the amount of characters that it is trying to brute force with but for short username/hash combinations it can be over a million tries per second.

Command Syntax

C:\orabf-v0.7.5>orabf [hash]:[username] [options]
Options:

-c     [num] complexity: a number in [1..6] or a filename
– read words from stdin
[file] read words from file
1 numbers
2 alpha
3 alphanum
4 standard oracle (alpha)(alpha,num,_,#,$)… (default)
5 entire keyspace (‘ ‘..’~’)
6 custom (charset read from first line of file: charset.orabf)
-m [num] max pwd len: must be in the interval [1..14] (default: 14)
-n [num] min pwd len: must be in the interval [1..14] (default: 1)
-r resume: tries to resume a previous session

测试:

read more »

Oracle 10g新特性: Temporary Tablespaces Group

10G的新特性:临时表空间组
Grouping temporary tablespaces within a single group enables a user to consume temporary space from multiple tablespaces. (将临时表空间打包成组后,用户就能同时使用多个表空间作为临时表空间)

临时表空间组的内容:
. A temporary tablespace group contains at least one tablespace. There is no limit for a group to have a maximum number of tablespaces.(临时表空间组包含至少一个表空间,至多无上限)
. It shares the namespace of tablespaces, thus its name cannot be the same as that of any tablespace.(共享表空间的命名空间,也就是说,临时表空间组的名称不能与任何一个表空间名称相同)
. A temporary tablespace group name can appear where a tablespace name would appear when assigning a default temporary tablespace for the database or assigning a temporary tablespace for a user.(当为数据库指定临时表空间或为用户指定临时表空间时,可以使用临时表空间组的名称)
. It is not created explicitly. It gets created implicitly when the first temporary tablespace is assigned to it and it is dropped when the last temporary tablespace is removed from it.(临时表空间组无法显式的创建。当第一个临时表空间指定给它时则隐式创建,当最后一个临时表空间移除时则隐式的被删除)
. Any temporary tablespace can be
–> moved from a group to another (if the group does not exist, it gets created)
–> removed from a group
–> added to a group if standalone

read more »

导入中断导致AWR报告内容为空

导入AWR报告后,命令行迟迟不返回成功的提示,但是log中已经显示成功了,故手动中断命令行。生成AWR报告时可看到DBID,但是生成的报告为空:

 

SQL> @?/rdbms/admin/awrrpti 
输入 report_type 的值: 
Type Specified:  html 
Instances in this Workload Repository schema 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
  DB Id     Inst Num DB Name      Instance     Host 
------------ -------- ------------ ------------ ------------ 
  1656146280        1 ACSCNPRD     acscnprd     CNPEKS024 
* 1276130704        1 ORCL         orcl         MARSHALL-PC 
输入 dbid 的值:  1656146280 
Using 1656146280 for database Id 
输入 inst_num 的值:  1 
Using 1 for instance number 
输入 num_days 的值:  1 
Listing the last day's Completed Snapshots 
                                                     Snap 
Instance     DB Name        Snap Id    Snap Started    Level 
------------ ------------ --------- ------------------ ----- 
acscnprd     ACSCNPRD         39147 17 8月  2011 00:00     1 
                              39160 17 8月  2011 13:00     1 
                              39161 17 8月  2011 14:00     1 
                              39162 17 8月  2011 15:00     1 
                              39163 17 8月  2011 16:00     1 
                              39164 17 8月  2011 17:00     1 
                              39165 17 8月  2011 18:00     1 
                              39166 17 8月  2011 19:00     1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
输入 begin_snap 的值:  39165 
Begin Snapshot Id specified: 39165 
输入 end_snap 的值:  39166 
End   Snapshot Id specified: 39166 
Specify the Report Name 
~~~~~~~~~~~~~~~~~~~~~~~ 
The default report file name is awrrpt_1_39165_39166.html.  To use this name,press <return> to ontinue, otherwise enter an alternative. 
输入 report_name 的值: 
Using the report name awrrpt_1_39165_39166.html

 

 

read more »

普人特福的博客cnzz&51la for wordpress,cnzz for wordpress,51la for wordpress