Oracle 体系结构

Oracle database server = 实例 instance  +  数据库 database

instance = 内存 + 后台进程 background  processes

database = datafiles  数据文件 + controlfiles 控制文件 + logfiles 日志文件

select name from v$datafile;

select name from v$controlfile;

select member from v$logfile;

开启图形管理界面：

lsnrctl status

lsnrctl start

emctl unsecure dbconsole

emctl start dbconsole

emctl stop dbconsole