由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Sql developer connection issue
相关主题
connect to an oracle server on anoter machine Error Code 01034?
【已解决】oracle db linkRe: [转载] JDBC用完了oracle的large pool (memor
Oracle-Client connect to Server Database problemoracle db connection through firewall
很弱的Oracle Client和SQL Developer的问题请教一个sqlplus的问题
ora-12560: TNS: Protocol adaptor errorHow to configure Listener in Oracle?
Oracle database link problem我的oracle 怎么了?
How to know which database I am connected?Oracle problems
newbie's question about oracle问一下oracle高手
相关话题的讨论汇总
话题: sql话题: connection话题: developer话题: instance话题: does
进入Database版参与讨论
1 (共1页)
YW
发帖数: 46
1
Really appreciate if someone can help me with my questions.
1. I have Oracle version 11.2.0.2.0 installed into linux server, There is
an instance running before I created second instance. I connected it using
SQL developer for development purpose. Everything was working properly until
recently. I found I can’t connect it with SQL developer anymore (the
other instance can connect without problem).
When I test the connection, it gave me error as below:
Status: Failure - Test failed:Listener refused the connection with the
following error:ORA12505, TNS:listener does not currently know of SID given
in correct descriptor
Any idea why, and how to check and resolve the above problem?
2. I tried to use sqlplus instead, but didn’t make it work. Does Oracle
version 11.2.0.2.0 support sqlplus? if it does, how to confiq it? Please
provide detailed info if possible.
Thanks in advance!!
B*****g
发帖数: 34098
2
https://forums.oracle.com/forums/thread.jspa?threadID=431363

is
using
until
given

【在 YW 的大作中提到】
: Really appreciate if someone can help me with my questions.
: 1. I have Oracle version 11.2.0.2.0 installed into linux server, There is
: an instance running before I created second instance. I connected it using
: SQL developer for development purpose. Everything was working properly until
: recently. I found I can’t connect it with SQL developer anymore (the
: other instance can connect without problem).
: When I test the connection, it gave me error as below:
: Status: Failure - Test failed:Listener refused the connection with the
: following error:ORA12505, TNS:listener does not currently know of SID given
: in correct descriptor

s**********o
发帖数: 14359
3
北京MM的回答总是言简意赅啊。

【在 B*****g 的大作中提到】
: https://forums.oracle.com/forums/thread.jspa?threadID=431363
:
: is
: using
: until
: given

1 (共1页)
进入Database版参与讨论
相关主题
问一下oracle高手ora-12560: TNS: Protocol adaptor error
如何在Unbuntu下启动oracleOracle database link problem
found a way to corrupt oracle on NTHow to know which database I am connected?
connection pool 面试题newbie's question about oracle
connect to an oracle server on anoter machine Error Code 01034?
【已解决】oracle db linkRe: [转载] JDBC用完了oracle的large pool (memor
Oracle-Client connect to Server Database problemoracle db connection through firewall
很弱的Oracle Client和SQL Developer的问题请教一个sqlplus的问题
相关话题的讨论汇总
话题: sql话题: connection话题: developer话题: instance话题: does