Check Scope for Oracle dba when got an old db

上一篇 / 下一篇  2005-08-18 00:00:00 / 个人分类:系统

When I got an new Oracle db, I will do following


1. Operation System passwd, Administrator/root/oracle

cat /etc/passwd

Check users in Winnt

2.df -k

3.echo $ORACLE_SID,$ORACLE_HOME,$ORACLE_BASE

cat $ORACLE_HOME/network/admin/tnsnames.ora,

cat $ORACLE_HOME/network/admin/listener.ora

4.cat $ORACLE_BASE/admin/$ORACLE_SID/pfile/init$SID.ora

5. cat $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$SID.log

6. ls -l $ORACLE_HOME/dbs

7 cat /etc/sysctl.conf

8. more /etc/proc/sys/shmmax

9.ps -ef|grep lsnr

10. ipcs -mb

11 svrmgrl

connect internal;

select * from v$logfile;

select tablespace_name from dba_tablespaces;

select tablespace_name,file_name from dba_data_files;

select * from dba_temp_files;

select tablespace_name,sum(bytes) from dba_free_space

group by tablespace_name;

select * from v$control_file;

select * from v$recover_file;

archive log list;

select * from v$database;

select * from v$parameter;

select * from v$instance;

select * from v$sess_wait;

select * from v$system_event;

IS it RAC


TAG:

引用 删除 Guest   /   2008-07-14 16:41:51
借鉴一下
引用 删除 Guest   /   2008-07-14 16:41:27
1
 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-09-08  
 123456
78910111213
14151617181920
21222324252627
282930    

数据统计

  • 访问量: 1452
  • 日志数: 276
  • 图片数: 1
  • 建立时间: 2007-12-16
  • 更新时间: 2008-08-26

RSS订阅

Open Toolbar