ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Check Scope for Oracle dba when got an old db

Check Scope for Oracle dba when got an old db

原创 Linux操作系统 作者:yanggq 时间:2019-02-26 17:24:04 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26706/viewspace-64565/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2002-10-29

  • 博文量
    78
  • 访问量
    50759