SID given in connect descriptor could not be resolved! [oracle@server2 oracle]$ sqlplus /nolog SQL*Plus: Release 9.2.0.4.0 - Production on Fri Aug 12 11:24:17 2005 Copyright (c) 1982, 2002, oracle Corporation. All rights reserved. SQL>; connect / as sysdba SQL>; startup ora-01081: cannot start already-running oraCLE - shut it down first SQL>; exit Disconnected from oracle9i Enterprise Edition...
by yuandanyi - Oracle - 2005-08-12 13:41:40 阅读(755) 回复(2)
我是新装的oraCLE 刚装完能正常访问和操作 EM http://192.168.1.246:1158/em/ 但是第二天重新开机后就出现上面的错误 状态 失败 详细资料 ora-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) 机器名称是 : prata IP: 192.168.1.246 下面是 oracle服务启动的过程 Starting oracle: LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-OCT-200...
我的oracle 装在linux 上, 客户端装在windows XP 下, 我还在XP上装了toad, 可是toad能连上oracle, XP上的sqlplus却连不上, 报错: ora-12514:TNS:listener does not currently know of service requested in connect descriptor. 有可能是什么原因?
在 Solaris8 Sparc 上面安裝 oracle817. .profile 如下: umask 022 PATH=/export/home/oracle/817:/export/home/oracle/817/bin:/usr/bin:/usr/ucb:/etc: /usr/ccs/bin:/usr/openwin/bin:/usr/local/bin oraCLE_HOME=/export/home/oracle/817 oraCLE_BASE=/export/home/oracle LD_LIBRARY_PATH=$oraCLE_HOME/lib ora_NLS33=$oraCLE_HOME/ocommon/nls/admin/data NLS_LANG="TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5" oraCLE_SID=CB ...
在 Solaris8 Sparc 上面安裝 oracle817. .profile 如下: umask 022 PATH=/export/home/oracle/817:/export/home/oracle/817/bin:/usr/bin:/usr/ucb:/etc: /usr/ccs/bin:/usr/openwin/bin:/usr/local/bin oraCLE_HOME=/export/home/oracle/817 oraCLE_BASE=/export/home/oracle LD_LIBRARY_PATH=$oraCLE_HOME/lib ora_NLS33=$oraCLE_HOME/ocommon/nls/admin/data NLS_LANG="TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5" oraCLE_SID=CB ...
1. data guard中的ora-12514: TNS:listener does not currently know of service requested in connect descriptor 2.[code][oracle@node1 admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora # Generated by oracle configuration tools. LSNODE2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = node2...
我在创建数据库时,到创建数据文件的阶段就会报错: ora-03114:CANNOT connect TO oraCLE? 这是为什么?
ora-12203:TNS:unable to connect to destination 什么意思???????????
当我的网络客户端有大量的connect里, 有时候报Cannot assign requested address 的错误. 我的connect频率大概为2000/s . 有哪位知道可能是什么原因吗?
在程序中访问数据库,该程序和oracle数据库在同一台主机(服务器)上,但是,运行程序时,报错:ora-12154: TNS:could not resolve the connect identifier specified oracle数据库服务器端: # listener.ora Network Configuration File: /opt/app/oracle/product/10.2.0/db_1/network/admin/listener.ora # Generated by oracle configuration tools. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = loca...
环境redhat 5.0 安装了oracle 10g,安装完成后,sqlplus /nolog ,出现sql 〉,用conn sys/sys@orc 1 as sysdba ,则会出现ora-12154: TNS:could not resolve the connect identifier specified,请问是什么原因,应该如何解决,急!希望大家帮帮忙!