易截截图软件、单文件、免安装、纯绿色、仅160KB

developer suite链接到oracle服务器

Developer Suite连接数据库的问题,劳驾高手指点!
电脑里面同时装了OraHome92和DevSuiteHome2,前者的sql*plus能访问,后者的则不行。输入scott/tiger登陆后者时,我输入了"主机字符串"号以后,报错: 
  ORA-12154: TNS:无法解析指定的连接标识符

******在网上找了很长时间都找不到合适的对策,其中有人建议:
  1.打开OC4J listner, 然后在dos命令中输入'lsnrctl start listener',报错如下:
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

启动tnslsnr:请稍候...

Service OracleOraHome92TNSListener already running.
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
  32-bit Windows Error: 1056: Unknown error
***********************************************************************  

2.国外网站上人家的建议  
ORA-12154: TNS:could not resolve the connect identifier specified 
Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached.

Action: - If you are using local naming (TNSNAMES.ORA file):

- Make sure that "TNSNAMES" is listed as one


相关问答:

oracle入门配置

oracle连接啥这么复杂啊.
oracle 10g
用ps/sql dev怎么也连不上.
用sqlplus可以登陆.net manager之前测试连接了成功的.现在搞得也连接不了.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

ssh oracle 连接


兄弟  图挂了。

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......

ado连接oracle的怪问题

以前程序好好的,能进行任何操作
但从昨天开始突然连接数据库失败,代码如下:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......

老问题:Oracle行转列(字符串拆分)

现有以下数据:
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
转换为:
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
要求使用SQL查询完成,由于条件限制,不能使用 ......

求一条oracle多表查询的sql,求高手们不吝赐教~

table1:
uID    uName
1      小李 
2      小张

table2:
pID  uID  type
1    1    H1
2    ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号