1
操作系统:Redhat Linux 5
[oracle@mzl proc]$ cat /proc/version
Linux version 2.6.18-8.el5
(
[email protected]) (gcc version 4.1.1
20070105 (Red Hat 4.1.1-52)) #1 SMP Fri Jan 26 14:15:21 EST
2007
2
数据库版本:Oracle10g
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE
10.2.0.1.0
Production
TNS Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
3
数据库的名字:orcl
SQL> show parameter db_name;
4
数据库的所有数据文件所在位置
SQL> select file#,status,enabled,name from
v$datafile;
FILE# STATUS
ENABLED
NAME
---------- ------- ----------
------------------------------------------
1 SYSTEM READ WRITE
/u01/app/oracle/oradata/orcl/system01.dbf
2 ONLINE READ WRITE
/u01/app/oracle/oradata/orcl/undotbs01.dbf
3 ONLINE READ WRITE
/u01/app/oracle/oradata/orcl/sysaux01.dbf
4 ONLINE READ WRITE
/u01/app/oracle/oradata/orcl/users01.dbf
5 ONLINE READ WRITE
/u01/app/oracle/oradata/orcl/example01.dbf
5 控制文件的所在位置
SQL> select * from v$controlfile;
STATUS
NAME
IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------ --- ----------
--------------
/u01/app/oracle/oradata/orcl/control01.ctl
NO
16384
430
/u01/app/oracle/oradata/orcl/control02.ctl
NO
16384
430
/u01/app/oracle/oradata/orcl/control03.ctl
NO
16384
430
本回答被网友采纳