我装上去之后sqlplus和developer都可以连接,但我今天两个突然都连不上了,我在网上找了些方法,加了个系统变量,现在sqlplus里能连上,但是sqldeveloper里还是连不上,这是什么原因啊,求教!另外我第一次用developer建的数据表在sqlplus里面查询不出来,今天又突然出来了,用的同一种方法,我无语了,哪位能告诉我原因,万分感谢!
解决方案 »
- plsqldeveloper与数据库连接关闭的问题
- 多表查询优化
- 安装Oracle 10G到Configuration Assistant时屏幕长时间没有变化
- 小问题送分来了!要的快来
- 遇到的数据库设计与开发方面棘手的问题
- 请教关于oracle8I中从noarchive到archive时出现的问题???????????//
- Oracle初级问题!请问如果建立一个自增的ID阿?还有自动获取时间字段怎么建啊?
- 哪位大侠有Linux下安装9i的经验?
- 求助各位大虾:删除重复数据 急!!!
- 高手帮我看看这个触发器该怎么写?
- 如何比较不同数据库服务器相同表的表结构?
- 【问】请教一个group by rollup的问题。
这个错误,这是为什么,哪位高手能告诉我解决的办法?
TNS:listener does not currently know of SID given in connect descriptor
Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a SID for an instance (usually a database instance) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.
Action:
- Wait a moment and try to connect a second time.
- Check which instances are currently known by the listener by executing: lsnrctl services <listener name>
- Check that the SID parameter in the connect descriptor specifies an instance known by the listener.
- Check for an event in the listener.log file.
解决方法:
1. 过一段时间再试重连
2. 看看lsnrctl服务是否正常
3. 看看listener.log里的提示
我个人建议,你设置一个环境变量ORACLE_SID为你要用的那个instance的SID.
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:orcl:thin:@127.0.0.1:1521:orcl
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.testoracle_jsp._jspService(testoracle_jsp.java:108)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.sql.SQLException: No suitable driver found for jdbc:orcl:thin:@127.0.0.1:1521:orcl
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.testoracle_jsp._jspService(testoracle_jsp.java:68)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)这是我用ie时出的错误
我的数据库好像只有一个sid啊,怎么设置,能不能说清楚点,本人新手,很多东西还不知道呢,谢谢
而且最先时我在developer里插入的数据在sqlplus里面读不出来,但第二天却突然出来了,哪位高手能告诉我为什么,我真的很想知道。