oracle sql developer 连接数据库 测试失败 报错如图

图片说明

0

2个回答

解决了 ,Sid是数据库实例名 应该写成我自己默认的ORCL

1
u013929331
爱看夜的猫 SID是实例id,orcl才是实例名
2 年多之前 回复

服务都开了图片说明

0
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
Oracle SQL Developer安装及连接数据库
1.下载Oracle SQL Developer,下载地址:http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 解压压缩包运行sqldeveloper.exe即可 2.连接oracle数据库,连接名任意,用户名、口令例如:scott/tiger 如果以sys登录,角色要选成S
使用SQL DEVELOPER 连接数据库 报错ORA-12505 .
我在使用SQL DEVELOPER 建立连接时 报错ORA-12505,TNS:listener does not currently know of SID given [img=https://img-bbs.csdn.net/upload/201802/14/1518541292_423342.png][/img]in connect descriptorrn百度了下说是SID不匹配,但我的SID确实是midnrn如图rn[img=https://img-bbs.csdn.net/upload/201802/14/1518541337_159135.png][/img]rn求问大神如何解决?rn或者能否留下QQ深入交流下,可有偿
oracle sql developer 连接数据库的一些细节问题
之前用oracle sql developer 连接本地数据库 很多次会出现 ora-12504的错误 说什么不能识别服务名 Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERV...
MAC版ORACLE SQL DEVELOPER设置连接数据库
MAC版ORACLE SQL DEVELOPER连接配置
使用SQL developer 连接数据库
先说下我的环境,PC机下安装了一台Linux 虚拟机,虚拟机上装了oracle11g,这里我们确保数据库是正常的, 首先安装SQL developer,无需多说,傻瓜式安装。 启动监听 lsnrctl start 打开developer 点击+号添加, 这里需要自己的填的有 connection name  //连接用户名字,这个是本地的,随意填 u
Oracle Sql Developer 调试程序报错,大家帮帮忙!!
Connecting to the database LNTESTCRM.rnExecuting PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUErnExecuting PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '0.0.0.0', '3006' )rnORA-30683: 与调试程序连接失败rnORA-12541: TNS: 无监听程序rnORA-06512: 在 "SYS.DBMS_DEBUG_JDWP", line 68rnORA-06512: 在 line 1rnProcess exited.rnDisconnecting from the database LNTESTCRM.rn
使用oracle sql developer 导入dmp报错
我在Enter SQL statement里输入rnimp system/a123456@loacl file=C:\Users\Administrator\Desktop\xin\deptmo\ptdemo.dmp full=y ignore=y direct=yrn报错,说是00900 无效sql语句rnrn还有我的Connection name是 ptdemo rnusername是system 应该怎么写导入语句?????????我是菜鸟啊
oracle spring 连接数据库 报错
1.JDWP Unable to get JNI 1.2 environment 把eclipse重启 2.Io 异常: The Network Adapter could not establish the connection A ResourcePool could not acquire a resource from its primary factory or source. ...
Sql Server连接数据库失败
sql server连接数据库失败,我们可以从以下几个方面去分析问题: 1.数据库服务是否打开。 2.数据库连接配置是否正确。 3.账号密码是否正确。2,3点都可以本地登录验证一下。 4.项目是否导入了jdbc相关的jar包。 以上都排除过后,就需要分析其他的原因了。在此记一下我的一个经历。有次启动项目包数据库连接失败的错,但是我昨天才登录成功了,什么都没动过,今天突然就不行,把以上原因...
WebService连接数据库测试时报错
javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initialrn at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:662)rn at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:307)rn at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:344)rn at javax.naming.InitialContext.lookup(InitialContext.java:411)rn at cn.demo.util.BaseDao.getConnection(BaseDao.java:22)rn at cn.demo.util.BaseDao.getResultSet(BaseDao.java:34)rn at cn.demo.dao.impl.LoginDaoImpl.Login(LoginDaoImpl.java:21)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)rn at java.lang.reflect.Method.invoke(Method.java:606)rn at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:75)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)rn at java.lang.reflect.Method.invoke(Method.java:606)rn at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:279)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)rn at java.lang.reflect.Method.invoke(Method.java:606)rn at com.sun.xml.internal.ws.api.server.MethodUtil.invoke(MethodUtil.java:68)rn at com.sun.xml.internal.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:235)rn at com.sun.xml.internal.ws.server.InvokerTube$2.invoke(InvokerTube.java:135)rn at com.sun.xml.internal.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:246)rn at com.sun.xml.internal.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:85)rn at com.sun.xml.internal.ws.api.pipe.Fiber.__doRun(Fiber.java:626)rn at com.sun.xml.internal.ws.api.pipe.Fiber._doRun(Fiber.java:585)rn at com.sun.xml.internal.ws.api.pipe.Fiber.doRun(Fiber.java:570)rn at com.sun.xml.internal.ws.api.pipe.Fiber.runSync(Fiber.java:467)rn at com.sun.xml.internal.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:299)rn at com.sun.xml.internal.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:593)rn at com.sun.xml.internal.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)rn at com.sun.xml.internal.ws.transport.http.server.WSHttpHandler.handleExchange(WSHttpHandler.java:95)rn at com.sun.xml.internal.ws.transport.http.server.WSHttpHandler.handle(WSHttpHandler.java:80)rn at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:77)rn at sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83)rn at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:80)rn at sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:677)rn at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:77)rn at sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:649)rn at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)rn at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)rn at java.lang.Thread.run(Thread.java:745)rn九月 06, 2016 2:58:04 下午 com.sun.xml.internal.ws.server.sei.EndpointMethodHandler invokern严重: nullrnjava.lang.NullPointerExceptionrn at cn.demo.util.BaseDao.getResultSet(BaseDao.java:36)rn at cn.demo.dao.impl.LoginDaoImpl.Login(LoginDaoImpl.java:21)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)rn at java.lang.reflect.Method.invoke(Method.java:606)rn at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:75)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)rn at java.lang.reflect.Method.invoke(Method.java:606)rn at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:279)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)rn at java.lang.reflect.Method.invoke(Method.java:606)rn at com.sun.xml.internal.ws.api.server.MethodUtil.invoke(MethodUtil.java:68)rn at com.sun.xml.internal.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:235)rn at com.sun.xml.internal.ws.server.InvokerTube$2.invoke(InvokerTube.java:135)rn at com.sun.xml.internal.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:246)rn at com.sun.xml.internal.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:85)rn at com.sun.xml.internal.ws.api.pipe.Fiber.__doRun(Fiber.java:626)rn at com.sun.xml.internal.ws.api.pipe.Fiber._doRun(Fiber.java:585)rn at com.sun.xml.internal.ws.api.pipe.Fiber.doRun(Fiber.java:570)rn at com.sun.xml.internal.ws.api.pipe.Fiber.runSync(Fiber.java:467)rn at com.sun.xml.internal.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:299)rn at com.sun.xml.internal.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:593)rn at com.sun.xml.internal.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)rn at com.sun.xml.internal.ws.transport.http.server.WSHttpHandler.handleExchange(WSHttpHandler.java:95)rn at com.sun.xml.internal.ws.transport.http.server.WSHttpHandler.handle(WSHttpHandler.java:80)rn at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:77)rn at sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83)rn at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:80)rn at sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:677)rn at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:77)rn at sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:649)rn at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)rn at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)rn at java.lang.Thread.run(Thread.java:745)rnrn[code=java]import java.sql.Connection;rnimport java.sql.PreparedStatement;rnimport java.sql.ResultSet;rnimport java.sql.SQLException;rnrnimport javax.naming.Context;rnimport javax.naming.InitialContext;rnimport javax.naming.NamingException;rnimport javax.sql.DataSource;rnrnpublic class BaseDao rn protected Connection conn;rn private ResultSet rs;rnrn // 连接数据库rnrn protected Connection getConnection() rn try rn Context cxt = new InitialContext();rn DataSource ds = (DataSource) cxt.lookup("java:comp/env/jdbc/webservice");rn this.conn = ds.getConnection();rn catch (NamingException e) rn e.printStackTrace();rn catch (SQLException e) rn e.printStackTrace();rn rn return conn;rn rnrn // 获得结果集,执行select语句rn public ResultSet getResultSet(String sql, Object[] prames) rn this.getConnection();rn try rn PreparedStatement smt = conn.prepareStatement(sql);rn if (prames != null) rn for (int i = 0; i < prames.length; i++) rn smt.setObject((i + 1), prames[i]);rn rn rn this.rs = smt.executeQuery();rn catch (SQLException e) rn e.printStackTrace();rn rn return rs;rn rnrn // 执行insert,update,delete 语句rn public boolean getupload(String sql, Object[] prames) rn int num = 0;rn boolean flag = false;rn this.getConnection();rn try rn PreparedStatement smt = conn.prepareStatement(sql);rn if (prames != null) rn for (int i = 0; i < prames.length; i++) rn smt.setObject((i + 1), prames[i]);rn rn rn num = smt.executeUpdate();rn if (num == 1) rn flag = true;rn rn catch (SQLException e) rn e.printStackTrace();rn rn return flag;rnrn rnrn // 关闭资源rn public void close() rn try rn if (rs != null) rn rs.close();rn rn if (conn != null) rn conn.close();rn rn catch (SQLException e) rn e.printStackTrace();rn rn rnrnrn[/code]rn使用的是数据源连接,提示错误,实在是找不到解决方法,新手刚接触WebServicern用的是MyEclipse,自带的有WebService浏览器[img=https://img-bbs.csdn.net/upload/201609/06/1473150192_727035.jpg][/img]在这里测试的,服务端报的错就是上面
PL/SQL连接数据库报错
PL/SQL连接数据库报错:“fatal two-task communication protocol error”是什么意思啊?
PL/SQL Developer和Oracle Developer 2000和Oracle Developer 10g Suite
小弟是菜鸟,那位道上前辈给讲一下PL/SQL Developer 和 Oracle Developer 2000还有Oracle Developer 10g Suite的区别rn
Oracle SQL Developer 2.1
Oracle SQL Developer is a relatively new product included in the range of Oracle products. It was frst introduced to the world in September 2005, by its code name Project Raptor. Raptor is a name many still cling to, despite being replaced very quickly with the full product name, Oracle SQL Developer (and referred to in the rest of the book as SQL Developer). The frst production version was released in early 2006 and had many Oracle customers both skeptical and excited. SQL Developer is a Graphical User Interface (GUI) for browsing and working with databases. Primarily developed for the Oracle database, it also provides a GUI for a selection of popular non-Oracle databases. As technology has evolved, many developers are looking for modern tools to assist them in daily tasks. A clean, easy to navigate interface is essential and many tools are judged on looks, performance, and functionality. Initially billed as a light-weight, clean, easy to install GUI for the Oracle database, SQL Developer is gaining momentum in the market and broadening its scope in its offering. The skeptics mentioned are ever concerned that Oracle is not really interested in the product, backing up this concern with the fact that SQL Developer is free. Disappointing as it is that "free" is equated with "poor quality", the last couple of years have considerably stilled many of these dissenting voices and the market using SQL Developer continues to increase. Time will tell.
oracle sql developer数据迁移
mysql到oracle的数据迁移,详细描述
oracle sql developer 简明教程
oracle sql developer 简明教 oracle sql developer 简明教程 oracle sql developer 简明教程
Oracle SQL Developer 1.5.5.59.69-with-jdk6.part2
说明: 这是2010年1月12日从Oracle官方网站下载的最新版本,官网也就是从这一天开始才正式提供正确的下载路径,所以在此之前没有出现过这个2.1版。 注意: 除非内含jdk1.6.11,否则需要在系统中安装有jdk1.6.11或以上版本,否则无法正常运行。 ================================================================================================= 所有sqldeveloper的下载地址: Oracle SQL Developer 2.1.0.63.73 for 32bit-windows-with-jdk1.6.11下载地址: part1: http://download.csdn.net/source/1988257 part2: http://download.csdn.net/source/1988297 part3: http://download.csdn.net/source/1988320 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for 32bit-windows-no-jre下载地址: part1: http://download.csdn.net/source/1990426 part2: http://download.csdn.net/source/1990448 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for 64bit-windows-no-jre下载地址: part1: http://download.csdn.net/source/1990232 part2: http://download.csdn.net/source/1990238 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for linux-noarch下载地址: part1: http://download.csdn.net/source/1990256 part2: http://download.csdn.net/source/1990265 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for mac-osx-no-jre下载地址: part1: http://download.csdn.net/source/1990322 part2: http://download.csdn.net/source/1990328 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for other-platform-no-jre下载地址: part1: http://download.csdn.net/source/1990381 part2: http://download.csdn.net/source/1990408 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 1.5.5.59.69-with-jdk6下载地址: part1: http://download.csdn.net/source/1986539 part2: http://download.csdn.net/source/1986547 ================================================================================================= There is no in-place upgrade available. To install Oracle SQL Developer 2.1 download the file and unzip into an empty folder. Select the "Use folder names" checkbox when unzipping the file. You can migrate your settings from Oracle SQL Developer 1.2.1. or Oracle SQL Developer 1.5.x. See the Release Notes 2.1 for more details. JDK Support Oracle SQL Developer 2.1 is shipped with JDK1.6_11. However, you can connect to and use any JDK 1.6.11 or above. To use an existing JDK, download the zip files listed below "with JDK already installed." Use Check for Updates to install: Third-party database drivers for Sybase, SQL Server and MySQL. For more information on setting up the third-party drivers, see Migrations: Getting Started Version control systems, Concurrent Versions System (CVS), Serena Dimensions or Perforce.
Oracle Sql developer 乱码问题
环境:win 2003 + oracle9irnOracle Sql developer 版本:2.1.1.64rnrn连接第一数据库(正式)乱码:rnPARAMETER 乱码rnNLS_LANGUAGE AMERICANrnNLS_TERRITORY AMERICArnNLS_CURRENCY $rnNLS_ISO_CURRENCY AMERICArnNLS_NUMERIC_CHARACTERS .,rnNLS_CHARACTERSET WE8DECrnNLS_CALENDAR GREGORIANrnNLS_DATE_FORMAT DD-MON-RRrnNLS_DATE_LANGUAGE AMERICANrnNLS_SORT BINARYrnNLS_TIME_FORMAT HH.MI.SSXFF AMrnNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMrnNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRrnNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRrnNLS_DUAL_CURRENCY $rnNLS_COMP BINARYrnNLS_LENGTH_SEMANTICS BYTErnNLS_NCHAR_CONV_EXCP FALSErnNLS_NCHAR_CHARACTERSET UTF8rnNLS_RDBMS_VERSION 9.2.0.4.0rnrn连接别外一个数据库(测试)正常:rnPARAMETER 正常rnNLS_LANGUAGE AMERICANrnNLS_TERRITORY AMERICArnNLS_CURRENCY $rnNLS_ISO_CURRENCY AMERICArnNLS_NUMERIC_CHARACTERS .,rnNLS_CHARACTERSET ZHS16GBKrnNLS_CALENDAR GREGORIANrnNLS_DATE_FORMAT DD-MON-RRrnNLS_DATE_LANGUAGE AMERICANrnNLS_SORT BINARYrnNLS_TIME_FORMAT HH.MI.SSXFF AMrnNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMrnNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRrnNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRrnNLS_DUAL_CURRENCY $rnNLS_COMP BINARYrnNLS_LENGTH_SEMANTICS BYTErnNLS_NCHAR_CONV_EXCP FALSErnNLS_NCHAR_CHARACTERSET AL16UTF16rnNLS_RDBMS_VERSION 9.2.0.1.0rnrn请问怎么设置Oracle sql developer 才能正常显示第一数据库(正式)数据?
PL-SQL? Oracle SQL Developer ?
幾年前接觸到Oracle,當時帶我的前輩教我用 PL-SQL 記得他那時候跟我說這個工具是 Oracle 出的 ? 但是要收錢? rn心裡只有想可是我們不是有買DB為什麼還要收錢?rnrn最近去Oracle 官方網站抓 64Bit Client 發現有一個 Oracle SQL Developer 竟然還是「免安裝版 」rnrn抓下來用發現,有些地方比PL-SQL還好用耶@@ 相似度也很高rnrn重點rn1. 免安裝版rn2. 智能感知坐的很不錯,輸入 sel 會自動帶出 select * from 讓你選,超方便!rn3. Select * from xxxx ,這時候滑鼠點 * 竟然能幫忙列出,所有欄位名稱有點方便rn4. 支援64位元rnrn目前還沒研究寫SP跟觸發程序那一塊如何,整體感覺還不錯耶rnrnTOAD 就不提了,超難用自動排序又醜,還會出現一堆髒資料 (看資料結構會顯示 xxx Byte... 誰會要看結構是幾 Byte......佔版面)rnrn所以到底PL-SQL是不是 Oracle 公司出的為什麼遲遲沒支援64位元?rnrn目前還是繼續使用用了5年的PL-SQL 。rnrn不過我會繼續測試使用 Oracle SQL Developer 真的有幾個體驗讓我很驚訝rn
Oracle SQL Developer问题
连接的时候报错 rntns listener does not currently know of service requested in connect descriptorrnrnrn连接名orclrn用户名systemrn口令rnrn角色defaultrn连接类型basic rn主机名192.168.80.3rn服务名orclrnrnrn另:rn两主机能ping通rn服务器的oracle和listener都已经启动rn在SQL Developer的机器上命令行 tnsping orcl能通,时间200msrnoracle主机是redhat系统rn两机器的防火墙都已经关闭
Oracle Sql developer
oracle连接数据库用到的工具。
Oracle SQL Developer
Oracle SQL 客户端,是Java练习学习中方便的数据。
Oracle SQL Developer 问题
我用Oracle SQL Developer 这个oracle客户端工具连接数据rn但是用一段时间后, 查询分析器的回车功能就不好使了(不换行),这是rn怎么回事啊?
Oracle SQL Developer 使用说明
该文档是对Oracle开发的完全免费的SQL Developer软件的使用说明。
oracle sql developer 介绍
NULL 博文链接:https://sdtm1016.iteye.com/blog/752227
oracle sql developer 使用教程
oracle sql developer最全使用教程 虽然不是oracle 11g,但本质上一致,通用。
Oracle SQL Developer 1.5.5.59.69-with-jdk6.part1
说明: 这是2010年1月12日从Oracle官方网站下载的最新版本,官网也就是从这一天开始才正式提供正确的下载路径,所以在此之前没有出现过这个2.1版。 注意: 除非内含jdk1.6.11,否则需要在系统中安装有jdk1.6.11或以上版本,否则无法正常运行。 ================================================================================================= 所有sqldeveloper的下载地址: Oracle SQL Developer 2.1.0.63.73 for 32bit-windows-with-jdk1.6.11下载地址: part1: http://download.csdn.net/source/1988257 part2: http://download.csdn.net/source/1988297 part3: http://download.csdn.net/source/1988320 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for 32bit-windows-no-jre下载地址: part1: http://download.csdn.net/source/1990426 part2: http://download.csdn.net/source/1990448 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for 64bit-windows-no-jre下载地址: part1: http://download.csdn.net/source/1990232 part2: http://download.csdn.net/source/1990238 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for linux-noarch下载地址: part1: http://download.csdn.net/source/1990256 part2: http://download.csdn.net/source/1990265 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for mac-osx-no-jre下载地址: part1: http://download.csdn.net/source/1990322 part2: http://download.csdn.net/source/1990328 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 2.1.0.63.73 for other-platform-no-jre下载地址: part1: http://download.csdn.net/source/1990381 part2: http://download.csdn.net/source/1990408 ------------------------------------------------------------------------------------------------- Oracle SQL Developer 1.5.5.59.69-with-jdk6下载地址: part1: http://download.csdn.net/source/1986539 part2: http://download.csdn.net/source/1986547 ================================================================================================= There is no in-place upgrade available. To install Oracle SQL Developer 2.1 download the file and unzip into an empty folder. Select the "Use folder names" checkbox when unzipping the file. You can migrate your settings from Oracle SQL Developer 1.2.1. or Oracle SQL Developer 1.5.x. See the Release Notes 2.1 for more details. JDK Support Oracle SQL Developer 2.1 is shipped with JDK1.6_11. However, you can connect to and use any JDK 1.6.11 or above. To use an existing JDK, download the zip files listed below "with JDK already installed." Use Check for Updates to install: Third-party database drivers for Sybase, SQL Server and MySQL. For more information on setting up the third-party drivers, see Migrations: Getting Started Version control systems, Concurrent Versions System (CVS), Serena Dimensions or Perforce.
oracle sql developer 乱码问题
用 sql developer 连接 mysql ,向表中插入中文,查询时,出现乱码。n如果直接通过 cmd 连接 mysql ,通过命令插入数据,再在 sql developer 查询,就不是乱码。n另外,直接在 sql developer 里输入 : select '汉字'; 查出来的也是乱码。n求大神解答!
oracle sql developer
oracle sql developeroracle sql developeroracle sql developeroracle sql developer
oracle sql developer x64
oracle sql developer x64
oracle 连接 sql developer
我新建一个连接,测试时会出现这个问题rn状态: 失败 -测试失败: Listener refused the connection with the following error:rnORA-12505, TNS:listener does not currently know of SID given in connect descriptorrn
PLSQL Developer连接数据库报错ora-12514解决
PLSQL Developer连接数据库报错ora-12514解决就这个错误纠结了好几天了,现在已经完美解决。现在把具体解决思路及方法记录下来,希望能够帮助更多像我这样纠结的人,高手大神们跳过。不多说废话,开始。 -------------------*--------------------------------------- 准备工具:1、PLSQLDEVELOPER 2、instantc
使用Oracle SQL Developer连接数据库中遇到的一系列错误
Io 异常: The Network Adapter could not establish the conn Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 无法从套接字中获取更多信息
那位有oracle Developer和PL/SQL Developer???????
那位好人 有:oracle Developer的软件rn或者PL/SQL Developer的中文资料,教材。rn我的邮箱:wuxiaojun8102@126.comrn万分感谢!!rn这两个工具有什么区别,rn我把我所有的分都给了,小弟刚开始学习ORACLE,
PL/SQL Developer 和 Oracle Developer 2000
小弟是菜鸟,那位道上前辈给讲一下PL/SQL Developer 和 Oracle Developer 2000的区别
oracle用SQL Developer连接数据库出现的小问题篇章一
1.如果出现以下错误提示:The NetWork Adapter could not establish the connection  首先检查两个服务有没有开:一个是OracleOraDb11g_home1TNSListener(我用的是11g版本)                                           另外一个是OracleServiceJSXX(标红J
使用Oracle创建数据库,SQL developer连接数据库简要步骤
SQL Developer 不能用于创建Oracle数据库,只能用来连接已经创建的数据库,数据库的建立要通过Database Configuration Assistant(DBCA)来完成。     找到开始菜单中Oracle-OraDb11g_home1下的DBCA,打开,可依次点击“下一步”,直到第3步数据库标识,创建数据库名称和SID。(最好在创建过程中形成文档,截图自己的创建过程,包括
本地不安装oracle,用PL/SQL Developer连接数据库
如果本地用不到oracle数据库的话,其实不必安装oracle,配置pl/sql就能连接数据库1.没配置前登录不上去2.D盘要准备oracle绿色免安装客户端,network里面的tnsnames.ora文件要配好3.配置oracle主目录和oci库4.配置后重新打开pl/sql,登录成功...
不安装oracle客户端,plsql developer连接数据库
无需安装oracle客户端,plsql developer直接连接数据库,内含plsql developer安装包、汉化包,安装教程,一步到位
连接数据库 ms sql server 失败
class connectMSSQLSERVERrnrn public void connect()rn rnrnrn //Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();rn// connect to the databasern // sqlConn=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.2:1433;DatabaseName=pubs;SelectMethod=direct","dxxx","");rnrnrn String dburl = "jdbc:microsoft:sqlserver://192.168.1.2:1433;DatabaseName=hd_pub";rn String user = "sa";rn String password = "sa";rn tryrn rn Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");rn Connection c = DriverManager.getConnection(dburl,user, password);rnrn if(c.isClosed())rn rn System.out.println("error");rn return;rn rnrn c.setAutoCommit(false);rn Statement s = c.createStatement();rn ResultSet r = s.executeQuery("select cempno,cpdm from sys_parm");rnrn while(r.next())rn rn System.out.println(r.getString(1) + r.getString("cpdm"));rn rn s.close();rn c.close();rn rn catch(Exception e)rn rn e.printStackTrace();rn rn rnrnrn错误提示:rnjava.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriverrnrn at java.net.URLClassLoader$1.run(URLClassLoader.java:198)rnrn at java.security.AccessController.doPrivileged(Native Method)rnrn at java.net.URLClassLoader.findClass(URLClassLoader.java:186)rnrn at java.lang.ClassLoader.loadClass(ClassLoader.java:299)rnrn at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)rnrn at java.lang.ClassLoader.loadClass(ClassLoader.java:255)rnrn at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)rnrn at java.lang.Class.forName0(Native Method)rnrn at java.lang.Class.forName(Class.java:140)rnrn at aaa.connectMSSQLSERVER.connect(Frame1.java:133)rnrn at aaa.Frame1.jButton1_actionPerformed(Frame1.java:65)rnrn at aaa.Frame1_jButton1_actionAdapter.actionPerformed(Frame1.java:86)rnrn at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764)rnrn at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1817)rnrn at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419)rnrn at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257)rnrn at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)rnrn at java.awt.Component.processMouseEvent(Component.java:5134)rnrn at java.awt.Component.processEvent(Component.java:4931)rnrn at java.awt.Container.processEvent(Container.java:1566)rnrn at java.awt.Component.dispatchEventImpl(Component.java:3639)rnrn at java.awt.Container.dispatchEventImpl(Container.java:1623)rnrn at java.awt.Component.dispatchEvent(Component.java:3480)rnrn at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450)rnrn at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)rnrn at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)rnrn at java.awt.Container.dispatchEventImpl(Container.java:1609)rnrn at java.awt.Window.dispatchEventImpl(Window.java:1590)rnrn at java.awt.Component.dispatchEvent(Component.java:3480)rnrn at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)rnrn at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:197)rnrn at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)rnrn at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)rnrn at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)rnrn at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)rnrnrn1. 我使用 jdatastore explorer 可以连接成功,连接参数也是那样 copy 下来的rn实在想不出来那里还有错误, jsdv 的驱动安装了,三个文件也 copy 到了 jdk 下面的 lib 下面rnrn2. 我怎么知道一个 connection 对象的状态,是否连接,难道一定要执行一个 SQL 吗???rnrn
sql server 打开报错如图,怎么修改 ?
![图片说明](https://img-ask.csdn.net/upload/201602/03/1454489017_798322.png)
相关热词 c# 线程顺序 c#昨天当前时间 c# 多进程 锁 c#mysql图片存取 c# ocx 委托事件 c# 读取类的属性和值 c# out 使用限制 c#获取url的id c#怎么进行分页查询 c# update 集合