liunx下oracle的操作日志

来源：互联网发布：three.js物体平移编辑：程序博客网时间：2024/06/05 22:48

centOS64中操作启动过程（启动oracle服务、启动监听、启动GMIS后台服务）：
a、sqlplus sys/oracle as sysdba
b、startup启动oracle
c、进入oracle/app/oracle/product/11.2.0/dbhome_1/bin目录，运行$ lsnrctl start启动监听
d、执行app/kingdee/eas/admin下的admin.cmd，命令为./admin.sh启动服务

导入数据库
drop user sty cascade;

DROP TABLESPACE EAS_D_STY_STANDARD INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE temp_sty INCLUDING CONTENTS AND DATAFILES;

create directory expnc_dir as '/bak/ncdatabak';

create tablespace EAS_D_STY_STANDARD
logging datafile '/oracle/app/oracle/oradata/orcl/EAS_D_STY_STANDARD.dbf'
size 5g
autoextend on
next 100m maxsize UNLIMITED
extent management local;

create temporary tablespace temp_sty
tempfile '/oracle/app/oracle/oradata/orcl/temp_sty.dbf'
size 100m
autoextend on
next 32m maxsize UNLIMITED
extent management local;

create user sty identified by sty
default tablespace EAS_D_STY_STANDARD
temporary tablespace temp_sty;

grant dba,connect,resource to sty;
grant read,write on directory expnc_dir to sty;

--无法按8扩展段（在还原表空间‘XXXX’中）解决方法：
--ALTER TABLESPACE EAS_D_ZH_STANDARD ADD DATAFILE 'D:\app\Administrator\oradata\orcl\EAS_D_ZH_STANDARD1.dbf' SIZE 500M

impdp sty/sty directory=expnc_dir dumpfile=sty.dmp remap_schema=sty:sty remap_tablespace=EAS_D_STY_STANDARD:EAS_D_STY_STANDARD
--注意，此处可能因为没有作/ncdatabak的权限而失败，可以先查看是否有权限再进行授权，在root用户下执行
--具体命令：chmod -R 777 /bak/ncdatabak

导出数据库

expdp system/1qaz2wsx directory=expnc_dir dumpfile=sty.dmp schemas=sty;
--注意expnc_dir权限问题

0 0