解决ORA-12514 监听程序当前无法识别连接描述符中的服务 2008-11-13 12:49
连接数据库时出错如下:
ORA-12505, TNS:listener does not currently know of SID given in connect descript
or
The Connection descriptor used by the client was:
127.0.0.1:1521:orcl
用plsqldev连接是出现:
ORA-12514 监听程序当前无法识别连接描述符中的服务
在命令行输入:
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>CD\
C:\>sqlplus / as sysdba;
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 11月 13 09:57:23 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
已连接到空闲例程。
SQL> select * from v$instance;
select * from v$instance
*
第 1 行出现错误:
ORA-01034: ORACLE not available
解决方法:
将HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1 下的ORA_ORCL_AUTOSTART值设置为FALSE。
SQL> startup;
ORACLE 例程已经启动。
Total System Global Area 591396864 bytes
Fixed Size 1250308 bytes
Variable Size 222301180 bytes
Database Buffers 360710144 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
数据库已经打开。
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE
----------------- -------------- ------------ --- ---------- -------
LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
--------------- ---------- --- ----------------- ------------------ ---------
BLO
---
1 orcl
ED2F45BB788A4EB
10.2.0.1.0 13-11月-08 OPEN NO 1 STOPPED
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE
----------------- -------------- ------------ --- ---------- -------
LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
--------------- ---------- --- ----------------- ------------------ ---------
BLO
---
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
NO
SQL>
成功搞定了,希望对大家有所帮助。