Oralce资识点汇总

启服务

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 //弹出一个修改密码的对话框，修改一下密码就可以了