Hello,
Using SQL Plus to connect to a remote database (over which I am just a DB client), I am getting the connection error:
ORA-28547: connection to server failed, probable Oracle Net admin error
FACTS:
(1) I have recently downloaded the Oracle InstantClient 11_2:
instantclient-sqlplus-nt-11.2.0.2.0.zip
instantclient-basiclite-nt-11.2.0.2.0.zip
(2) sqlplus -version prints out:
SQL*Plus: Release 11.2.0.2.0 Production
(3) the target oracle database is online and accessible, using SQL Developer I am able to query the database
(4) I do not believe that my connection descriptor is wrong, in fact, I believe that the probability of the problem being in my connect descriptor is border-line impossible, for the following reasons:
(4.1) I obtained the connect descriptor using the TNSPING tool (I queried the OID-LDAP server, which resolved the OID name into a connection descriptor
(4.2) Afterwards, running the command:
"sqlplus USER/[email protected](DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=targetHost)(PORT=1521)))(CONNECT_DATA=(SID=targetSID)))"
I obtained the connection error "ORA-28547: connection to server failed, probable Oracle Net admin error"
(4.3) As to ensure that the targetSID is correct (which I know for a fact that it is), I have also tried running the command listed in 4.2 with a completely random dummy SID, as a result, I obtained the following comprehensible error:
"ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor"
Theferefore, I assume that in 4.2 the TNS listener recognized the SID that I was giving it, and, further more, the SID is servicing, since, after all, I am connected to this database using SQL Developer.
(4.4) Finally, I have also monitored the TNS protocol interactions during connection setup using Wireshark.
I've Retrieved the connect descriptor used by SQL Developer, which is of the form:
(DESCRIPTION=(CONNECT_DATA=(SID=targetSID)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=null)))(ADDRESS=(PROTOCOL=tcp)(HOST=targetHOST)(PORT=1521)))
Again, I have tried using this connect descriptor, but, once more, I have obtained the "ORA-28547: connection to server failed, probable Oracle Net admin error "
(5) I have run out of ideas.
What I can say is that when I try to connect via SQL Plus and fail, the TNS monitored interaction is as follows:
tns connection request,
tns connection accept,
tns marker attention.
From the v$parameter table i can infer the following relevant information:
compatible11.2.0.0.0
dispatchers(PROTOCOL=TCP) (SERVICE=XDB)
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=targetHOST)(PORT=1521))))
nls_languagePORTUGUESE
Note:
I even thought that during connection configuration SQLPLUS may be disconnecting from the server from incompatible NLS Language configurations, as I am using it in American, but when I put it in PORTUGUESE by defining the necessary windows global variable, the ORA 28547 continues to occur.
Does anyone have any ideas of what the problem might be?
Is it possible ot SQL Plus connect to ORACLE by means of the JDBC driver + JDBC url?
Thank you.
Edited by: sono99 on Jul 29, 2011 11:38 PM
Tagged: