oracle 10g 10.2版本
RT无法连接到数据库实例。下面列出了组件的状态。一下是问题图片,我害怕贴不出来就给了个连接
http://fmn031.xnimg.cn/fmn031/pic001/20081211/17/25/large_AXS6_11948k206097.jpg
解决方案 »
- 执行存储过程报错!!!急!!!
- oracle导入数据库的问题
- Unix下Oracle数据库如何创建WIN NT下的PI数据库的Database Link?
- oracle 参数utl_file_dir
- 为啥我用了create 命令却在数据库中看不到表
- 请问我用企业管理器登陆时,选择身份时选择:sysdba和normal有什么区别吗,用户名不都是system吗?
- 如何将MS SQL 2000中的表结构及记录导入到Oracle 10g 中
- 各位:卸载oracle,重新安装卸载,如何删除原来的数据库sid
- 谁有COM.ibm.db2.jdbc.app.DB2Drive驱动
- PowerBuilder 和plsql 用他们链接数据库有什么区别吗
- to_char中的第三个参数怎么把中文日期转换为英文
- oracle 9i&10g编程艺术配环境的问题?
查找
select * from v$instance;
看看實例名是什麼?
instance_name
orcl
[HttpRequestHandler-28730188] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://127.0.0.1:3938/emd/main)(ERROR = INTERNAL_ERROR)
2008-12-12 10:58:53,453 [HttpRequestHandler-28497887] ERROR conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
解决步骤:
1、以oracle用户登录,/opt/oracle/product/10.2.0/db_1/dbs目录下运行
fuser -u lkORCL
fuser -k lkORCL
fuser -u lkORCL
2、重新启动数据库和监听
3、重新启动EM就好了
如果还有问题,可以联系我,MSN:[email protected]
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)tnsnames.oraEXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)是不是sid这有问题。PLSExtProc这个东西我没设置过啊~怎么会有的?
这两个文件和我的是一样的 ,虽然你的是装在windows下的。
少了这一段:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
oracle用户/系统用户?
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = orcl)
(PRESENTATION = RO)
)
)
F:\oracle>cd product
F:\oracle\product>cd 10.2.0
F:\oracle\product\10.2.0>cd db_1
F:\oracle\product\10.2.0\db_1>cd dbs
F:\oracle\product\10.2.0\db_1\dbs>fuser -u lkorcl
'fuser' 不是内部或外部命令,也不是可运行的程序
或批处理文件。
F:\oracle\product\10.2.0\db_1\dbs>fuser -u lkorcl
'fuser' 不是内部或外部命令,也不是可运行的程序
或批处理文件。
F:\oracle\product\10.2.0\db_1\dbs>
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
tnsnames.ora ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = orcl)
(PRESENTATION = RO)
)
)
emoms.log
[HttpRequestHandler-28730188] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://127.0.0.1:3938/emd/main)(ERROR = INTERNAL_ERROR)
2008-12-12 10:58:53,453 [HttpRequestHandler-28497887] ERROR conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
试一下能否链接上你的数据库