常见ORACLE错误，及解决方案(遇则即时更新)

1、当登陆时提示“ORA-03113:通信通道的文件结束”时：

 

     解决方案：

                    需在X:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\sqlnet.ora文件中，修改

                    SQLNET.AUTHENTICATION_SERVICES = (NTS)    将NTS改为NONE 重启即可。

 

 

 

 2、ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 ：

    解决方案：

 

                    修改listener.ora：

 

 

        SID_LIST_LISTENER =

          (SID_LIST =

              (SID_DESC =

              (SID_NAME = PLSExtProc)

              (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)

              (PROGRAM = extproc)

            )

           (SID_DESC =

            (GLOBAL_DBNAME = XE)

            (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)  

            (SID_NAME = XE)

            )

          )

        LISTENER =

          (DESCRIPTION_LIST =

            (DESCRIPTION =

              (ADDRESS = (PROTOCOL = TCP)(HOST = LightPC)(PORT = 1521))

            )

          )

 

 3、ORA-12560:TNS:protocol adapter error

 

       解决方案：

 

                       登陆时    SYS@LIGHT   AS    SYSDBA常见ORACLE错误，及解决方案