检查oracle是否安好,查看oracle是否正常、表空间

===================================================================

查看oracle数据库是否启动：

一、LINUX:

1、用ps -ef|grep ora查看,是否有oracle的进程,,linux下还可以用ipcs查看

2、查看监听的方法

lsnrctl status

启动监听

lsnrctl start

===================================================================

二、windows:

进到数据库里面看数据库当前状态

select instance_name,status from v$instance;

如果status = open 就说明oracle服务正常。

查看监听，执行lsnrctl status，就可以看监听所对应的实例。

是否有scott用户，可以查看dba_users这个表的用户状态。

==================================================================

三、检查操作系统空间使用状态

Linux命令：df -h或df -g

window:查看磁盘管理器

==================================================================

四、表空间检查

1、select tablespace_name,sum(bytes)/1024/1024

as total_size

from

dba_data_files

group by

tablespace_name

2、select tablespace_name,sum(bytes)/1024/1024 as

total_size

from

dba_free_space

group by

tablespace_name

==================================================================

五、启动过程：

sqlplus

/nolog or (sqlplus sys/passwd as sysdba)

conn sys/password as sysdba

SQL> select status from v$instance

ORA-01034: ORACLE not available ------------shutdown

SQL> startup

nomount ------------started

SQL> alter database mount ------------mounted

SQL> alter database

open ------------open

==================================================================

6、检查表空间碎片

select tablespace_name,

sqrt(MAX(blocks)/sum(blocks))*(100/sqrt(sqrt(COUNT(blocks))))

as

"FSFI%"

from dba_free_space

group by tablespace_name

==================================================================