oracle
qq1105273619
这个作者很懒,什么都没留下…
展开
-
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
oralce千万不要再没删库前删表空间文件正确的删库方法drop user ECOE_YY_JSNTGZQ cascade;drop tablespace DB_1101_TEST_HBHDCA including contents and datafiles cascade constraint;drop tablespace DB_ECOE_YY_JSNTGZQ_O1_TMP including contents and datafiles cascade constraint;否则下次启动原创 2020-08-21 10:04:33 · 294 阅读 · 0 评论 -
oracle修改表空间路径
##下线表空间SQL>alter tablespace DB_1104_JSWXYX_O1 offline;##查看表空间文件路径SQL>select t1.name,t2.namefrom vtablespacet1,vtablespace t1,vtablespacet1,vdatafile t2where t1.ts# = t2.ts# AND t1.name=‘DB_1104_JSWXYX_O1’;下线表空间SQL> alter tablespace DB_1104_原创 2020-08-11 13:22:20 · 573 阅读 · 0 评论 -
oracle查看当前用户的连接并杀掉
SELECT * FROM v$session WHERE SCHEMANAME = ‘OA_1101_JSWXBHHD_O1_DBA’;#为SID,SERIAL#alter system kill session ‘35,15265’;alter system kill session ‘193,23237’;alter system kill session ‘196,12475’;...原创 2020-03-11 10:36:12 · 635 阅读 · 0 评论 -
ORA-01654: unable to extend index报错解决
查询实例表空间使用情况和剩余大小SELECT Upper(F.TABLESPACE_NAME) "表空间名", D.TOT_GROOTTE_MB "表空间大小(M)", D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)", To_char(Round(( D.TOT_GR...原创 2020-02-12 10:07:30 · 6494 阅读 · 0 评论 -
oracle创建只读用户
LNSY_DBA为数据库实例LNSY_DBA_READ为创建的只读用户–创建用户create user LNSY_DBA_READ identified by 123456;–授权grant connect to LNSY_DBA_READD;grant create synonym to LNSY_DBA_READ;grant create session to LNSY_D...原创 2020-02-12 09:26:01 · 135 阅读 · 0 评论 -
记一次oracle数据库迁移
--临时表空间CREATE TEMPORARY TABLESPACE XXX TEMPFILE '/home/oracle/data/oracle/oradata/orcl/XXX.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;--正式表空间CREATE TABLESPACE XX...原创 2020-01-03 09:48:03 · 175 阅读 · 0 评论 -
oracle用户过期被锁定
查询用户状态select username,account_status from dba_users;解锁用户alter user 用户名 account unlock;查看用户使用的密码策略,并将策略的有效期改为无限制SELECT username, profile FROM dba_users;SELECT * FROM dba_profiles WHERE profile LI...原创 2019-12-10 13:25:25 · 108 阅读 · 0 评论 -
记一次oralce处理Checkpoint not complete
select member from v$logfile;select group#,sequence#,bytes,members,status from v$log;##增加成员组alter database add logfile group 4 ('/home/oracle/data/oracle/oradata/orcl/redo04.log') size 100m reuse...原创 2019-11-04 13:04:23 · 105 阅读 · 0 评论 -
启动oracle数据库
开启监听lsnrctl start查看监听状态lsnrctl status以dba身份登录oraclesqlplus /nolog 进入sql控制台conn /as sysdbastartup原创 2019-08-02 09:23:57 · 128 阅读 · 0 评论