ORA-02019 错误处理

港控/mmm° 2022-05-15 08:53 965阅读 0赞

ORA-02019 错误提示是未找到远程数据库的连接说明，通常发生在本地数据库无法连接到远程数据库。引发该问题的原因很多，比如网络连接，连接方式(tnsnames)，dblinkc的创建等等。而下面的描述的故障则比较奇特。

**一、错误现象**

**二、分析与解决**  
1.当前数据库版本

> SQL> select \* from v$version; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production PL/SQL Release 8.1.7.4.0 - Production CORE 8.1.7.2.1 Production TNS for 32-bit Windows: Version 8.1.7.4.0 - Production NLSRTL Version 3.4.1.0.0 - Production

2.当前已创建的database link

> SQL> select \* from dba\_db\_links; OWNER DB\_LINK USERNAME HOST CREATED ------------------------------ ---------- ---------- --------------- ----------- DIMS DSS.M85 VIEWPIC PIC 2007-11-8 1 SQL> select \* from v$dblink; -->当前没有正在使用的database link DB\_LINK OWNER\_ID LOGGED\_ON HETEROGENEOUS PROTOCOL OPEN\_CURSORS IN\_TRANSACTION UPDATE\_SENT COMMIT\_POINT\_STRENGTH ---------- ---------- --------- ------------- -------- ------------ -------------- ----------- ---------------------

3.下面的存储过程使用了分布式数据库

> SQL> select text from dba\_source where name='P\_PROCESS\_PIC\_VALID'; TEXT -------------------------------------------------------------------------------- PROCEDURE "P\_PROCESS\_PIC\_VALID" (processDate IN DATE --处理日期，如果不传入，就表示当天 ) AS recCount INT; pictureName NVARCHAR2(50); mntnOperMask VARCHAR2(10); --维护部操作人员账号前缀 oper NVARCHAR2(50); PicId NVARCHAR2(50); FilmId NVARCHAR2(50); v\_maxid number; --20100720 BEGIN -------------------------------------------------20100720 -- 已导入的数据最大的ID select max(id) into v\_maxid from T\_scanfilename\_m85; -- 导入新增的数据 execute immediate 'insert into T\_scanfilename\_m85 select \* from scanfilename@dss.m85 TEXT -------------------------------------------------------------------------------- where id>:COL\_1' using v\_maxid; commit; -------------------------------------------------20100720 mntnOperMask := 'gl'; --从图系统导入有效片数据 INSERT INTO t\_pic\_xdoc\_file(cph,cl,wldd,fx,wlrq,wlxm,lrsj,oper,picture\_name SELECT T1.cph,T1.cl,T1.wldd,T1.fx,T1.wlrq,T1.wlxm,T1.lrsj,T1.oper,T2.FILE /\*FROM xdoc\_file@DSS.M85 T1,scanfilename@DSS.M85 T2\*/ --20100720 FROM xdoc\_file@DSS.M85 T1,T\_scanfilename\_m85 T2 WHERE T1.XH=T2.XH and t2.id>15717858 and not exists (select picture\_name from t\_pic\_xdoc\_file where pict AND substr(T1.oper,1,2)= mntnOperMask and (t1.lrsj >=sysdate-3); -- 将图文系统过来的有效片数据，分析处理后保存到统计表中 --处理有效片 FOR c IN(SELECT xf.\*,ROWID FROM t\_pic\_xdoc\_file xf WHERE status=1) LOOP SQL> select table\_name,owner from dba\_tables where table\_name in ('SCANFILENAME','XDOC\_FILE'); TABLE\_NAME OWNER ------------------------------ ------------------------------ SCANFILENAME DIMS SQL> select \* from dims.scanfilename where rownum<5; ID FILENAME XH --------------------------------------- -------------------------------------------------- ------------ 8606178 V1\_00000020361002320070614095523017900004.jpg 8605441 V1\_00000002101002120070614095523011900023.jpg 8605445 V1\_00000002101002120070614095523011900025.jpg 8605449 V1\_00000002101002120070614095523011900027.jpg

4.尝试执行操作

> SQL> select \* from scanfilename@dss.m85; select \* from scanfilename@dss.m85 ORA-02019: 未找到远程数据库的连接说明 SQL> select \* from xdoc\_file@DSS.M85; select \* from xdoc\_file@DSS.M85 ORA-02019: 未找到远程数据库的连接说明 SQL> show user; User is "SYS" SQL> conn dims/dims\_12345@dmsdb Connected to Oracle8i Enterprise Edition Release 8.1.7.4.1 Connected as dims SQL> select \* from dba\_db\_links; OWNER DB\_LINK USERNAME HOST CREATED --------------- --------------- --------------- --------------- ----------- DIMS DSS.M85 VIEWPIC PIC 2007-11-8 1 SQL> select \* from user\_db\_links; DB\_LINK USERNAME PASSWORD HOST CREATED --------------- --------------- ------------------------------ --------------- ----------- DSS.M85 VIEWPIC VIEWPIC PIC 2007-11-8 1

5.切换帐户后使用分布式数据库，提示监听不可用

> SQL> select \* from xdoc\_file@DSS.M85 ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE\_NAME SQL> select \* from scanfilename@DSS.M85; select \* from scanfilename@DSS.M85 ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE\_NAME pic = (DESCRIPTION = (ADDRESS\_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 100.100.1.31)(PORT = 1521)) ) (CONNECT\_DATA = (SERVER = DEDICATED) (SERVICE\_NAME = DSS) ) )

6.使用tnsping测试

> C:\\>tnsping pic TNS Ping Utility for 32-bit Windows: Version 8.1.7.4.0 - Production on 26-7月 -2 011 15:32:35 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=100.100.1.31)(PORT=1521)) OK（20毫秒） C:\\>sqlplus viewpic/viewpic@pic -->sqlplus 不能登陆 SQL\*Plus: Release 8.1.7.0.0 - Production on 星期二 7月 26 15:33:15 2011 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR： ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE\_NAME

7.查看本地tnsnames.ora

> pic = (DESCRIPTION = (ADDRESS\_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 100.100.1.31)(PORT = 1521)) ) (CONNECT\_DATA = (SERVER = DEDICATED) (SID = DSS) -->(原来为service\_name,将其改为SID) ) ) C:\\>sqlplus viewpic/viewpic@pic -->再次使用sqlplus登陆正常 SQL\*Plus: Release 8.1.7.0.0 - Production on 星期三 7月 27 09:49:57 2011 (c) Copyright 2000 Oracle Corporation. All rights reserved. 连接到: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production With the Partitioning and Parallel Server options JServer Release 8.1.7.0.0 - 64bit Production SQL> select \* from v$version; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Developmen NLSRTL Version 3.4.1.0.0 - Production SQL> select \* from scanfilename@DSS.M85 where rownum < 5; ID FILENAME XH ---------- -------------------------------------------------- -------------------- 8606178 V1\_00000020361002320070614095523017900004.jpg 8605441 V1\_00000002101002120070614095523011900023.jpg 8605445 V1\_00000002101002120070614095523011900025.jpg

8.是什么原因造成了需要将service\_name改为SID，以前使用service\_name一直正常。由于DSS.M85在故障前前曾重  
未做任何更改。Oracle 8之后推荐使用service\_name，但实际上在Oracle 8使用service\_name也可以正常使用。

**三、更多参考**

有关性能优化请参考

[ Oracle 硬解析与软解析][Oracle]

[ 共享池的调整与优化(Shared pool Tuning)][_Shared pool Tuning]

[ Buffer cache 的调整与优化(一)][Buffer cache]

[ Oracle 表缓存(caching table)的使用][Oracle _caching table]

有关ORACLE体系结构请参考

[ Oracle 表空间与数据文件][Oracle 1]

[ Oracle 密码文件][Oracle 2]

[ Oracle 参数文件][Oracle 3]

[ Oracle 联机重做日志文件(ONLINE LOG FILE)][Oracle _ONLINE LOG FILE]

[ Oracle 控制文件(CONTROLFILE)][Oracle _CONTROLFILE]

[Oracle 归档日志][Oracle 4]

[ Oracle 回滚(ROLLBACK)和撤销(UNDO)][Oracle _ROLLBACK_UNDO]

[ Oracle 数据库实例启动关闭过程][Oracle 5]

[ Oracle 10g SGA 的自动化管理][Oracle 10g SGA]

[ Oracle 实例和Oracle数据库(Oracle体系结构)][Oracle _Oracle_Oracle]

有关闪回特性请参考

[ Oracle 闪回特性(FLASHBACK DATABASE)][Oracle _FLASHBACK DATABASE]

[ Oracle 闪回特性(FLASHBACK DROP & RECYCLEBIN)][Oracle _FLASHBACK DROP _ RECYCLEBIN]

[ Oracle 闪回特性(Flashback Query、Flashback Table)][Oracle _Flashback Query_Flashback Table]

[ Oracle 闪回特性(Flashback Version、Flashback Transaction)][Oracle _Flashback Version_Flashback Transaction]

有关基于用户管理的备份和备份恢复的概念请参考

[ Oracle 冷备份][Oracle 6]

[ Oracle 热备份][Oracle 7]

[ Oracle 备份恢复概念][Oracle 8]

[ Oracle 实例恢复][Oracle 9]

[ Oracle 基于用户管理恢复的处理][Oracle 10](详细描述了介质恢复及其处理)

[ SYSTEM 表空间管理及备份恢复][SYSTEM]

[ SYSAUX表空间管理及恢复][SYSAUX]

有关RMAN的备份恢复与管理请参考

[ RMAN 概述及其体系结构][RMAN]

[ RMAN 配置、监控与管理][RMAN 1]

[ RMAN 备份详解][RMAN 2]

[ RMAN 还原与恢复][RMAN 3]

[ RMAN catalog 的创建和使用][RMAN catalog]

[ 基于catalog 创建RMAN存储脚本][_catalog _RMAN]

[基于catalog 的RMAN 备份与恢复][catalog _RMAN]

[使用RMAN迁移文件系统数据库到ASM][RMAN_ASM]

[ RMAN 备份路径困惑(使用plus archivelog时)][RMAN _plus archivelog]

有关ORACLE故障请参考

[ ORA-32004 的错误处理][ORA-32004]

[ ORA-01658 错误][ORA-01658]

[ CRS-0215 错误处理][CRS-0215]

[ ORA-00119，ORA-00132 错误处理][ORA-00119_ORA-00132]

[ 又一例SPFILE设置错误导致数据库无法启动][_SPFILE]

[ 对参数FAST\_START\_MTTR\_TARGET = 0 的误解及设定][_FAST_START_MTTR_TARGET _ 0]

[ SPFILE 错误导致数据库无法启动(ORA-01565)][SPFILE _ORA-01565]

有关ASM请参考

[ 创建ASM实例及ASM数据库][_ASM_ASM]

[ ASM 磁盘、目录的管理][ASM]

[ 使用 ASMCMD 工具管理ASM目录及文件][_ ASMCMD _ASM]

有关SQL/PLSQL请参考

[ SQLPlus 常用命令][SQLPlus]

[ 替代变量与SQL\*Plus环境设置][_SQL_Plus]

[ 使用Uniread实现SQLplus翻页功能][_Uniread_SQLplus]

[ SQL 基础*-->SELECT 查询*][SQL _--_SELECT]

[ SQL 基础*--> NEW\_VALUE 的使用*][SQL _--_ NEW_VALUE]

[ SQL 基础*--> 集合运算(UNION 与UNION ALL)*][SQL _--_ _UNION _UNION ALL]

[ SQL 基础*--> 常用函数*][SQL _--_]

[ SQL 基础*--> 视图(CREATE VIEW)*][SQL _--_ _CREATE VIEW]

[ SQL 基础*--> 创建和管理表*][SQL _--_ 1]

[ SQL 基础*--> 多表查询*][SQL _--_ 2]

[ SQL 基础*--> 过滤和排序*][SQL _--_ 3]

[ SQL 基础*--> 子查询*][SQL _--_ 4]

[ SQL 基础*--> 分组与分组函数*][SQL _--_ 5]

[ SQL 基础*--> 层次化查询(START BY ... CONNECT BY PRIOR)*][SQL _--_ _START BY ... CONNECT BY PRIOR]

[ SQL 基础*--> ROLLUP与CUBE运算符实现数据汇总*][SQL _--_ ROLLUP_CUBE]

[ PL/SQL *--> 游标*][PL_SQL _--_]

[ PL/SQL *--> 异常处理(Exception)*][PL_SQL _--_ _Exception]

[ PL/SQL *--> 语言基础*][PL_SQL _--_ 1]

[ PL/SQL *--> 流程控制*][PL_SQL _--_ 2]

[ PL/SQL *--> PL/SQL记录*][PL_SQL _--_ PL_SQL]

[ PL/SQL *--> 包的创建与管理*][PL_SQL _--_ 3]

[ PL/SQL *--> 隐式游标(SQL%FOUND)*][PL_SQL _--_ _SQL_FOUND]

[ PL/SQL *--> 包重载、初始化*][PL_SQL _--_ 4]

[ PL/SQL *--> DBMS\_DDL包的使用*][PL_SQL _--_ DBMS_DDL]

[ PL/SQL *--> DML 触发器*][PL_SQL _--_ DML]

[ PL/SQL *--> INSTEAD OF 触发器*][PL_SQL _--_ INSTEAD OF]

[ PL/SQL *--> 存储过程*][PL_SQL _--_ 5]

[ PL/SQL *--> 函数*][PL_SQL _--_ 6]

[ PL/SQL *--> 动态SQL*][PL_SQL _--_ _SQL]

[ PL/SQL *--> 动态SQL的常见错误*][PL_SQL _--_ _SQL 1]

有关ORACLE其它特性

[ Oracle 常用目录结构(10g)][Oracle _10g]

[ 使用OEM,SQL\*Plus,iSQL\*Plus 管理Oracle实例][_OEM_SQL_Plus_iSQL_Plus _Oracle]

[ 日志记录模式(LOGGING 、FORCE LOGGING 、NOLOGGING)][_LOGGING _FORCE LOGGING _NOLOGGING]

[ 表段、索引段上的LOGGING与NOLOGGING][_LOGGING_NOLOGGING]

[ Oralce OMF 功能详解][Oralce OMF]

[ Oracle 用户、对象权限、系统权限 ][Oracle _]

[ Oracle 角色、配置文件][Oracle 11]

[ Oracle 分区表][Oracle 12]

[ Oracle 外部表][Oracle 13]

[ 使用外部表管理Oracle 告警日志(ALAERT\_$SID.LOG)][_Oracle _ALAERT_SID.LOG]

[ 簇表及簇表管理(Index clustered tables)][_Index clustered tables]

[ 数据泵 EXPDP 导出工具的使用][_ EXPDP]

[ 数据泵 IMPDP 导入工具的使用][_ IMPDP]

[ 导入导出 Oracle 分区表数据][_ Oracle]

[ SQL\*Loader使用方法][SQL_Loader]

[ 启用用户进程跟踪][Link 1]

[ 配置非默认端口的动态服务注册][Link 2]

[ 配置ORACLE 客户端连接到数据库][_ORACLE]

[ system sys，sysoper sysdba 的区别][system sys_sysoper sysdba]

[ ORACLE\_SID、DB\_NAME、INSTANCE\_NAME、DB\_DOMIAN、GLOBAL\_NAME][ORACLE_SID_DB_NAME_INSTANCE_NAME_DB_DOMIAN_GLOBAL_NAME]

[ Oracle 补丁全集 (Oracle 9i 10g 11g Path)][Oracle _ _Oracle 9i 10g 11g Path]

[ Oracle 10.2.0.1 升级到 10.2.0.4][Oracle 10.2.0.1 _ 10.2.0.4]

[ Oracle 彻底 kill session][Oracle _ kill session]

[Oracle]: http://blog.csdn.net/robinson_0612/archive/2011/02/19/6195483.aspx
[_Shared pool Tuning]: http://blog.csdn.net/robinson_0612/archive/2011/02/25/6208268.aspx
[Buffer cache]: http://blog.csdn.net/robinson_0612/archive/2011/02/25/6208594.aspx
[Oracle _caching table]: http://blog.csdn.net/robinson_0612/archive/2011/03/06/6226767.aspx
[Oracle 1]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611738.aspx
[Oracle 2]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611672.aspx
[Oracle 3]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559174.aspx
[Oracle _ONLINE LOG FILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/20/5749556.aspx
[Oracle _CONTROLFILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/15/5737527.aspx
[Oracle 4]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784713.aspx
[Oracle _ROLLBACK_UNDO]: http://blog.csdn.net/robinson_0612/archive/2010/07/13/5731158.aspx
[Oracle 5]: http://blog.csdn.net/robinson_0612/archive/2010/04/29/5542983.aspx
[Oracle 10g SGA]: http://blog.csdn.net/robinson_0612/archive/2010/04/27/5534832.aspx
[Oracle _Oracle_Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529239.aspx
[Oracle _FLASHBACK DATABASE]: http://blog.csdn.net/robinson_0612/archive/2010/12/27/6100429.aspx
[Oracle _FLASHBACK DROP _ RECYCLEBIN]: http://blog.csdn.net/robinson_0612/archive/2010/12/29/6105327.aspx
[Oracle _Flashback Query_Flashback Table]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112607.aspx
[Oracle _Flashback Version_Flashback Transaction]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112981.aspx
[Oracle 6]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791597.aspx
[Oracle 7]: http://blog.csdn.net/robinson_0612/archive/2010/08/16/5816012.aspx
[Oracle 8]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791585.aspx
[Oracle 9]: http://blog.csdn.net/robinson_0612/archive/2010/07/27/5768233.aspx
[Oracle 10]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041217.aspx
[SYSTEM]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041207.aspx
[SYSAUX]: http://blog.csdn.net/robinson_0612/archive/2010/08/13/5810732.aspx
[RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032525.aspx
[RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032597.aspx
[RMAN 2]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032739.aspx
[RMAN 3]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041247.aspx
[RMAN catalog]: http://blog.csdn.net/robinson_0612/archive/2010/11/29/6043649.aspx
[_catalog _RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073020.aspx
[catalog _RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073069.aspx
[RMAN_ASM]: http://blog.csdn.net/robinson_0612/archive/2011/05/30/6453954.aspx
[RMAN _plus archivelog]: http://blog.csdn.net/robinson_0612/archive/2011/05/12/6414338.aspx
[ORA-32004]: http://blog.csdn.net/robinson_0612/archive/2011/02/19/6195475.aspx
[ORA-01658]: http://blog.csdn.net/robinson_0612/archive/2011/03/14/6249202.aspx
[CRS-0215]: http://blog.csdn.net/robinson_0612/archive/2011/04/05/6303583.aspx
[ORA-00119_ORA-00132]: http://blog.csdn.net/robinson_0612/archive/2011/05/05/6396989.aspx
[_SPFILE]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784736.aspx
[_FAST_START_MTTR_TARGET _ 0]: http://blog.csdn.net/robinson_0612/archive/2010/08/02/5782516.aspx
[SPFILE _ORA-01565]: http://blog.csdn.net/robinson_0612/archive/2010/07/29/5774795.aspx
[_ASM_ASM]: http://blog.csdn.net/robinson_0612/archive/2010/12/16/6080659.aspx
[ASM]: http://blog.csdn.net/robinson_0612/archive/2011/01/13/6134071.aspx
[_ ASMCMD _ASM]: http://blog.csdn.net/robinson_0612/archive/2011/01/13/6134163.aspx
[SQLPlus]: http://blog.csdn.net/robinson_0612/archive/2010/04/06/5454382.aspx
[_SQL_Plus]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084376.aspx
[_Uniread_SQLplus]: http://blog.csdn.net/robinson_0612/archive/2010/03/30/5431655.aspx
[SQL _--_SELECT]: http://blog.csdn.net/robinson_0612/archive/2010/04/15/5487668.aspx
[SQL _--_ NEW_VALUE]: http://blog.csdn.net/robinson_0612/archive/2011/02/18/6192944.aspx
[SQL _--_ _UNION _UNION ALL]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611716.aspx
[SQL _--_]: http://blog.csdn.net/robinson_0612/archive/2010/04/16/5495170.aspx
[SQL _--_ _CREATE VIEW]: http://blog.csdn.net/robinson_0612/archive/2010/05/28/5630426.aspx
[SQL _--_ 1]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5689199.aspx
[SQL _--_ 2]: http://blog.csdn.net/robinson_0612/archive/2010/05/06/5563199.aspx
[SQL _--_ 3]: http://blog.csdn.net/robinson_0612/archive/2010/04/15/5487992.aspx
[SQL _--_ 4]: http://blog.csdn.net/robinson_0612/archive/2010/05/14/5592002.aspx
[SQL _--_ 5]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559110.aspx
[SQL _--_ _START BY ... CONNECT BY PRIOR]: http://blog.csdn.net/robinson_0612/archive/2010/05/22/5616877.aspx
[SQL _--_ ROLLUP_CUBE]: http://blog.csdn.net/robinson_0612/archive/2010/06/01/5640031.aspx
[PL_SQL _--_]: http://blog.csdn.net/robinson_0612/archive/2010/12/15/6078622.aspx
[PL_SQL _--_ _Exception]: http://blog.csdn.net/robinson_0612/archive/2010/12/16/6080119.aspx
[PL_SQL _--_ 1]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063399.aspx
[PL_SQL _--_ 2]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063422.aspx
[PL_SQL _--_ PL_SQL]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084390.aspx
[PL_SQL _--_ 3]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084475.aspx
[PL_SQL _--_ _SQL_FOUND]: http://blog.csdn.net/robinson_0612/archive/2010/12/22/6092066.aspx
[PL_SQL _--_ 4]: http://blog.csdn.net/robinson_0612/archive/2010/12/22/6092097.aspx
[PL_SQL _--_ DBMS_DDL]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098248.aspx
[PL_SQL _--_ DML]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098258.aspx
[PL_SQL _--_ INSTEAD OF]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098263.aspx
[PL_SQL _--_ 5]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063434.aspx
[PL_SQL _--_ 6]: http://blog.csdn.net/robinson_0612/archive/2010/12/11/6069531.aspx
[PL_SQL _--_ _SQL]: http://blog.csdn.net/robinson_0612/archive/2011/01/05/6118010.aspx
[PL_SQL _--_ _SQL 1]: http://blog.csdn.net/robinson_0612/archive/2011/01/05/6118049.aspx
[Oracle _10g]: http://blog.csdn.net/robinson_0612/archive/2010/05/29/5633093.aspx
[_OEM_SQL_Plus_iSQL_Plus _Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529260.aspx
[_LOGGING _FORCE LOGGING _NOLOGGING]: http://blog.csdn.net/robinson_0612/archive/2011/01/12/6130866.aspx
[_LOGGING_NOLOGGING]: http://blog.csdn.net/robinson_0612/archive/2011/01/12/6131176.aspx
[Oralce OMF]: http://blog.csdn.net/robinson_0612/archive/2010/04/12/5478323.aspx
[Oracle _]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5688875.aspx
[Oracle 11]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5688997.aspx
[Oracle 12]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925572.aspx
[Oracle 13]: http://blog.csdn.net/robinson_0612/archive/2010/12/15/6078481.aspx
[_Oracle _ALAERT_SID.LOG]: http://blog.csdn.net/robinson_0612/archive/2011/02/18/6192979.aspx
[_Index clustered tables]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925501.aspx
[_ EXPDP]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925592.aspx
[_ IMPDP]: http://blog.csdn.net/robinson_0612/archive/2010/10/08/5926276.aspx
[_ Oracle]: http://blog.csdn.net/robinson_0612/archive/2011/03/13/6246738.aspx
[SQL_Loader]: http://blog.csdn.net/robinson_0612/archive/2010/10/08/5926296.aspx
[Link 1]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925564.aspx
[Link 2]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925526.aspx
[_ORACLE]: http://blog.csdn.net/robinson_0612/archive/2010/09/30/5917103.aspx
[system sys_sysoper sysdba]: http://blog.csdn.net/robinson_0612/archive/2010/11/05/5989565.aspx
[ORACLE_SID_DB_NAME_INSTANCE_NAME_DB_DOMIAN_GLOBAL_NAME]: http://blog.csdn.net/robinson_0612/archive/2010/09/30/5917082.aspx
[Oracle _ _Oracle 9i 10g 11g Path]: http://blog.csdn.net/robinson_0612/archive/2011/04/06/6304124.aspx
[Oracle 10.2.0.1 _ 10.2.0.4]: http://blog.csdn.net/robinson_0612/archive/2011/05/05/6396783.aspx
[Oracle _ kill session]: http://blog.csdn.net/robinson_0612/archive/2011/05/23/6439019.aspx