oracle10G 的ORA-12505问题解决方法

oracle10G 的ORA-12505问题解决方法

 

在CMD下snrctl status  ，tnsping orcl 显示都正常。

在pl/SQL下用

select open_mode from v$database；

show parameter instance；

select INSTANCE_NAME from v$instance；

sqlplus sys/oracle@orcl

查询都显示正常，就是用pl/sql 登录时 填“数据库名” orcl  就无法登陆，报ora -12514

l最后有效的解决方法：

修改listener.ora文件

原listener.ora文件：

# listener.ora Network Configuration File: D:/oracle/product/10.1.0/Db_4/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = D:/oracle/product/10.1.0/Db_4)

      (PROGRAM = extproc)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

      )

      (ADDRESS_LIST =

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

      )

    )

  )

 

 

修改后的文件：

---------------------------------------------------------------------------------------

# listener.ora Network Configuration File: D:/oracle/product/10.1.0/Db_4/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = D:/oracle/product/10.1.0/Db_4)

      (PROGRAM = extproc)

 

    )

 

 (SID_DESC =

       (GLOBAL_DBNAME = orcl)

       (ORACLE_HOME =  D:/oracle/product/10.1.0/Db_4) 

       (SID_NAME = orcl)

      )

   )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

      )

      (ADDRESS_LIST =

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

      )

    )

  )

-----------------------------------------------------------------

如果错误还存在，也可以那试一下:
set oracle_sid=<sid_name>
sqlplus /nolog
connect sys/pwd as sysdba
start

原贴：http://www.blogjava.net/joan/archive/2008/10/28/237141.html