Oralce资识点汇总

标签：Oralce 资识点 uc 汇总 exit crqssingle conn oracle dp

启服务

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

 

标签：Oralce,资识点,uc,汇总,exit,crqssingle,conn,oracle,dp
From： https://www.cnblogs.com/salixleaf/p/16862206.html