Oracle 11.2.0.3 ORA-12012 ORA-29280 ORA-06512 错误 解决方法
11.2.0.3 ORA-12012 ORA-29280 ORA-06512
脚本:定时生成awr报告
脚本 定时 生成 awr crontab
How to Relink Oracle Database Software
How to Relink Oracle Database Software
oracle网络配置:三个配置文件
oracle网络配置 sqlnet tnsnames listener ora
简单记录下logmnr
oracle logmnr
UNDO使用率高,且unexpire过高
UNDO使用率高 且unexpire过高
oracle profiles
oracle profiles
Oracle Listener设置密码示例说明
Oracle Listener 设置密码 示例说明
Oracle DBA的基本任务
Oracle DBA的基本任务
某数据库的节点4因网络问题,主机关闭
某数据库的节点4因网络问题,主机关闭。
Configuring non-raw Multipath Devices for Oracle Clusterware 11g
Configuring non-raw Multipath Devices for Oracle Clusterware 11g (11.1.0, 11.2.0) on RHEL6/OL6 (Doc ID 1538626.1)
数据库打完11.1.0.7.12补丁后数据库启动失败
数据库打完11.1.0.7.12补丁后数据库启动失败,需要打上相应的补丁。
数据库启动在mount状态,无任何报错
数据库启动在mount状态,无任何报错
ORA-1652: unable to extend temp segment by xxx in tablespace XXXXX
ORA-1652: unable to extend temp segment by xxx in tablespace XXXXX
How To Know If An Object (Table / Procedure / View /…) Is Currently Being
How To Know If An Object (Table / Procedure / View /…) Is Currently Being Applies to:Oracle Server – Enterprise Edition – Version: 10.2.0.5 and later [Release: 10.2 a...
hanganalyze分析会话阻塞
hanganalyze分析会话阻塞 参考文档:USING AND READING HANGANALYZE或者[ID 215858.1]1、模拟阻塞会话数据库版本:SQL> select * from v$version;BANNER----------------------------------------...
ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU613$
ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU613$ Error: ORA 1628 Text: max # of extents <num> reached for rollback s...
表PK失效,表中已有重复记录
表PK失效,表中已有重复记录 同事发现部分表PK失效,处理过程如下:查到FM_MIB_OBJ_12215763592失效:SQL> select OWNER,CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,STATUS from dba_constraints whe...
10g dblink报错:ORA-01017、ORA-02063
10g dblink报错:ORA-01017、ORA-02063 源DB:10.2.0.3目标DB:11.2.0.3 一、创建database link: ggs_test = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = *...
Oracle10g startup报ORA-27102
Oracle10g startup报ORA-27102 DB版本:10.2.0.4OS版本:Linux-X86_64 数据库启动报错: SQL> startup nomount ORA-27102: out of memory Linux-x86_64 Error: 28: No space left ...