启服务
1. linux下启动oracle
su - oracle e
sqlplus /nolog
conn /as sysdba
startup
exit
lsnrctl start
exit
停服务
2. linux下关闭oracle
su - oracle
sqlplus /nolog
conn /as sysdba
shutdown immediate
exit
lsnrctl stop
exit
建库脚本
create tablespace dp_crqssingle_uc datafile '/opt/oracle/oradata/develop/dp_crqssingle_uc.dbf' size 10m autoextend on;
create user dp_crqssingle_uc identified by dp_crqssingle_uc default tablespace dp_crqssingle_uc;
grant connect to dp_crqssingle_uc;
grant dba to dp_crqssingle_uc;
grant unlimited tablespace to dp_crqssingle_uc;
oracle用户被锁
报错信息 ORA-28000: the account is locked
解决命令
（1）conn sys/sys as sysdba; //以DBA的身份登录
（2）alter user scott account unlock;// 然后解锁
（3）conn scott/tiger //弹出一个修改密码的对话框，修改一下密码就可以了
