linux下oracle常用命令

--登陆oracle
sqlplus / as sysdba
sqlplus sys/founder@zon100db as sysdba

--查看oracle版本
select version from v$instance;


--启动数据库
startup


--停止数据库
shutdown immediate


--检查Oracle DB监听器是否正常
lsnrctl status


--启动监听器
lsnrctl start


--启动emctl http://localhost.localdomain:1158/em
emctl start dbconsole


--oracle安装路径
echo $ORACLE_HOME


--默认SID
echo $ORACLE_SID


--当前实例名
select name from v$database;

SELECT host_name, instance_name, version FROM v$instance;

--导出

exp epaysch/epaysch@EPAYDB file=/home/oracle/epaydb0807.dmp owner=epaysch

--导入

imp EPAYSCH/EPAYSCH@ZF file=/u01/20140716.dmp ignore=y full=y;

-- 创建表空间

create tablespace ZON100DB datafile '/u01/db/zbzf/data/ZON100DB.dbf'

size 200m autoextend on extent management local segment space management auto;

-- 查看表空间

select name from v$datafile;

--  创建用户

create user EPAYSCH identified by EPAYSCH default tablespace ZON100DB;

-- 授权

grant dba to epaysch;

-- 删除用户

drop user EPAYSCH cascade;