I encountered same problem with ORACLE 11G express on Windows.
After a long time waiting I got the same error message.
My solution is to make sure the hostname in tnsnames.ora (usually it’s not «localhost») and the default hostname in sql developer(usually it’s «localhost») same. You can either do this by changing it in the tnsnames.ora, or filling up the same in the sql developer.
Oh, of course you need to reboot all the oracle services (just to be safe).
Hope it helps.
I came across the similar problem again on another machine, but this time above solution doesn’t work.
After some trying, I found restarting all the oracle related services can fix the problem. Originally when the installation is done, connection can be made. Somehow after several reboot of computer, there is problem.
I change all the oracle services with start time as auto. And once I could not connect, I restart them all over again (the core service should be restarted at last order), and works fine.
Some article says it might be due to the MTS problem. Microsoft’s problem. Maybe!
In this post we’re going to talk about Oracle SQL developer “SQL Error 17002 Sqlstate 08006” error on Windows. We’ll talk about the error code and how to fix it fast.
Why Does SQL Error 17002 Sqlstate 08006 Shows Up?
Most of the times it shows up because there is incorrect Misconfiguration or listener isn’t running. Before you’re able to connect with Oracle database, SQL developer must be configured correctly and listener has to be running. The listener handles databases connection, by default the SQL settings does not need listener for connecting to database and so it has to be configured.
SQL Error 17002 Sqlstate 08006
Another possible reason for this SQL error could be database sessions have been terminated by the network firewall or interrupted by another reason. In this case you have to make sure firewall isn’t stopping idle connections.
Connectivity problems between oracle integration and connectivity agent can be the cause of this error also, or when the connectivity agent is disabled. You have to make sure connectivity agent is running. You can check the status under your Dashboards and Agents in oracle integration.
How To Fix SQL Error 17002 Sqlstate 08006
The fixes to this SQL error code is mostly about fixing or configuring the listener. We’ll also share other fixes that will help.
Fix No.1: Ensure listener is running
This can be checked from Windows Service Manager or using Command Prompt. Follow these steps to check the status;
Checking listener status using Windows Service Manager:
- Press Windows + R to open Run Dialogue.
- Type msc in the dialogue box.
- In the list of services, TNS listener is listed, make sure it’s running, the status is shown beside each service. If it’s not running you just need to right-click and click Start.
Checking with command prompt:
Open command prompt, you can do that by typing cmd in windows search, right-click on it and select ‘Run As Administrator’.
- When the command prompt opens, you type this command: C:>lsnrctl status
- If it’s not running, error will be mentioned multiple times, and you need to start it.
- To start the listener service, you need to type this command: C:>lsnrctl start
lsnrctl status
Fix No.2: Making sure the listener has the right configurations
- Open Oracle SQL Developer.
- Right click on database name and select properties.
- A window will open and you need to take note of the Hostname and port values under the ‘details’ tab.
- The default port is 1521, but sometimes it can be 1522, it has to be changed.
- Now back to checking hostname, you should type C:>hostname.
- The hostname will immediately appear below this command and if you’re receiving the SQL error code 17002, in most cases it will be different from the hostname that appeared when you right-click on the database name in the previous step. Remember that I told you to take note of the Hostname, this difference occurs when the computer name is changed. In this situation, the hostname has to be corrected in the connection Window, and the port value also should be changed to 1521 if that’s not the value.
- The next step now is to open tnsnames.ora file and check to confirm that the hostname and port is correct. The full path is; %ORACLE_HOME%/network/admin/tnsnames.ora. if not you need to change the values appropriately.
- Open the Windows Service Manager and Restart OracleserviceXE by right clicking and then click restart.
- Now you should test the connection to see if things are ok. When you’re sure all values are correct, that’s the Port, Hostname, username and password, you should click the test button. If connection show successful it means the problem has been rectified.
- After that you can now click connect and can now browse and query your database.
This fix can be lengthy or seem complex to most users but that’s the way to go about it.
Fix No.3: Restart Oracle TNS listener
As we’ve mentioned in the first fix, you should check whether listener is running or not, so in this case even if it’s running you should restart it. You should follow the same procedure in the first fix. Restarting the listener has work for some, you should give it a try.
Conclusion
So far these are some of the best fixes to SQL Error 17002 Sqlstate 08006, the problem most of the time has to do with listener and you need to ensure that it’s pointing to the correct port and server. Once you can figure this out, you’ll definitely get rid of the problem. Do let us know in the comments if these fixes have solved the SQL error for you, if you also have more ideas to share please drop your comments below for our readers.
When I try to create a connection using SQL Developer 4.0.2 on MAC OS I got the following error message :
The Network Adapter could not establish the connection’ (ORA-17002) error.
asked Aug 29, 2014 at 21:31
Mohammad HammadMohammad Hammad
1051 gold badge2 silver badges8 bronze badges
3
ORA-17002 is a generic error code shown when the client cannot connect to the database. The actual fix can be found only if we have additional info.
You can start by troubleshooting the following.
1. Check if the database server can be pinged.
2. check if the port is accessible by running telnet.
3. check if there are any firewall rules blocking access to database.
answered Jan 10, 2018 at 19:57
run the below command in mac cli:
sudo scutil --set HostName localhost
answered Mar 26, 2020 at 23:07
When I try to create a connection using SQL Developer 4.0.2 on MAC OS I got the following error message :
The Network Adapter could not establish the connection’ (ORA-17002) error.
asked Aug 29, 2014 at 21:31
Mohammad HammadMohammad Hammad
1051 gold badge2 silver badges8 bronze badges
3
ORA-17002 is a generic error code shown when the client cannot connect to the database. The actual fix can be found only if we have additional info.
You can start by troubleshooting the following.
1. Check if the database server can be pinged.
2. check if the port is accessible by running telnet.
3. check if there are any firewall rules blocking access to database.
answered Jan 10, 2018 at 19:57
run the below command in mac cli:
sudo scutil --set HostName localhost
answered Mar 26, 2020 at 23:07
Содержание
- SQL Developer Cannot Connect To Database Fails With Vendor code 17002 (Doc ID 1324766.1)
- Applies to:
- Symptoms
- Changes
- Cause
- To view full details, sign in with your My Oracle Support account.
- Don’t have a My Oracle Support account? Click to get started!
- Christoph Jahn
- 30 thoughts on “ Oracle Error 17002 “Io Exception: The Network Adapter could not establish the connection” ”
- SQL Developer won’t connect to database — Vendor code 17002
- Answers
- Cannot Establish Connection (Error Code: 17002) Randomly With JDBC Thin Driver (Doc ID 357445.1)
- Applies to:
- Symptoms
- Changes
- Cause
- To view full details, sign in with your My Oracle Support account.
- Don’t have a My Oracle Support account? Click to get started!
- ORA-17002 error
- Comments
SQL Developer Cannot Connect To Database Fails With Vendor code 17002 (Doc ID 1324766.1)
Last updated on SEPTEMBER 20, 2022
Applies to:
Symptoms
In the process of rolling out banners for SEC_USER_UNAUTHORIZED_ACCESS_BANNER and SEC_USER_AUDIT_ACTION_BANNER.
Testing applications to see if there was any effect on connectivity, and noticed unable to connect to the database using SQL Developer (3.0.04). SQL Developer throws error:
Error
———
An error was encountered performing the requested operation:
IO Error: Got minus one from a read call
Vendor code 17002
Works
————
Using SQL Developer 2.1 connects without any errors
SQL Plus can connect to the database without any issues, as can TOAD
SQL Developer can connect to the database without issues if we remove the banner files.
Does Not Work
—————
Using SQL Developer 3.0 and banner files.
Changes
Upgraded from SQL Developer 2.1 to 3.0.
Cause
To view full details, sign in with your My Oracle Support account.
Don’t have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com. пїЅ Oracle | Contact and Chat | Support | Communities | Connect with us | 
| 
| 
| Legal Notices | Terms of Use
Источник
Christoph Jahn
If you search for the Oracle error “Io Exception: The Network Adapter could not establish the connection” (ORA-17002) you will find plenty of discussion on the web. It usually comes down to what the message says, that it is a network issue. But the error can also be caused by e.g. incompatible jar files. In my case, however, I was trying to access a 11g R2 instance from SQL Developer and during initial setup everything had worked. And local access, also with SQL Developer, worked absolutely fine.
Solution: Replace “simple” DB hostname with the fully qualified one. I am not sure why this changed the behavior. I can think of either a DNS setup issue (although my search list included the domain) or some kind of reverse lookup logic that is being applied. Anyway, I wanted to share this finding and also record it for my own future use.
30 thoughts on “ Oracle Error 17002 “Io Exception: The Network Adapter could not establish the connection” ”
Thanks for the tip, it worked for me too !!
Even, I changed localhost to my machine name, it worked, and it was still working when I reverted to localhost. There must be some strange network behaviour beneath.
thank you very much!
I tried a lot of complex solutions and this was the winner, now I can continue my work, thanks again
thank you very much …!
other solution :
you make sure that you have the right DNS on your IP Address this is happened if you have 2 network
It didn’t work for me.
Thank you very much, it helped me to solve the problem I had
Thank you so much for your helping me.
it worked fo me too ! merci beacoup !!
Awesome tip! worked for me too…it was a dns issue
Hey, what’s the difference between “simple DB hostname” and “fully qualified DB hostname”? some example pls because I’m not sure did I understand it right? 🙂
Simple name is e.g. “dbserver” whereas fully qualified one is “dbserver.mycomany.com”. Does that help?
Where can I find fully qualified name? I tried with select * from global_name, but I got same name as simple name….
The fully qualified hostname is part of the machine’s network setup and only indirectly part of Oracle
It worked like a charm. Thanks
Awesome tip. It worked for me..
I tried everything, it doesn’t work. Finally i tried by using connection type as local/Bequeath. Then it worked for me.
Other solution: In your application data-source change the connect string from
“jdbc:oracle:thin:@host:port:sid” (short connection string)
“jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS = (PROTOCOL = TCP)
(HOST = host)
(PORT = port)
)
(CONNECT_DATA=
(SERVICE_NAME=sid)
(SERVER=DEDICATED)
)
)” (full server string)
Super… Used the fully qualified hostname and it worked. Thanks.
Thanks worked for me 🙂
Hello All ,
I have tried all these techniques but still my facing same issue.
1- I have data source on my local websphere6.1 and when do test connection from web console server ,it was successful but when i tried to do the same it giving me error
” java.sql.SQLException: Io exception: The Network Adapter could not establish the connectionDSRA0010E: SQL State = null, Error Code = 17,002″
Note : I am connection to remote oracle db.
in my machine , i have only raid & web sphere installed.
Please any body help me.
Advance thank you
It c an be bacause of the wrong credentials of the service name. I changed my system credentials which i was using for the service, the moment i updated that it worked for me. Thanks.
@Lucas Silva: perfect, your my hero!
I got this error but the hostname is the fully one
I changed to localhost and it worked fine
Источник
SQL Developer won’t connect to database — Vendor code 17002
I have latest Oracle Sql Developer 3.2.1 installed, and I cannot connect to databases. I typed correct SID, port number, user and password and it won’t connect saying: «The Network Adapter could not establish the connection. Vendor code: 17002»
Do I need oracle client installed on my machine to connect to remote server using sql developer?
I am tunelling the connection using putty SSH to remote machine, and I put localhost as host in connection details in sql developer, but it works on another computer. I have also JDK 1.7.0_06 installed, and while starting sql developer I get warning that this product is supported with minimum version of 1.6.0_04 and less than 1.7. May this be problem?
Thanks in advance
Tom
Answers
Vendor code 17002 generally means a major network problem like invalid host or port number. Using ssh tunneling complicates the troubleshooting. It may be best to try to replicate the other machine setup as far as possible, including ssh setup, name resolution and sql developer configuration.
These are the normal troubleshooting steps.
Given a SQL Developer connection definition of DBSERVER, 1521, ORCL.
Can you ping DBSERVER?
Can you telnet to DBSERVER on port 1521 (telnet DBSERVER 1521). If you don’t have windows telnet you can use a putty telnet session.
I assume somewhere in your tunnelling setup you have something like locahost:1521 mapping to DBSERVER:1521. In that case you can replace localhost in the troubleshooting steps.
Источник
Cannot Establish Connection (Error Code: 17002) Randomly With JDBC Thin Driver (Doc ID 357445.1)
Last updated on FEBRUARY 10, 2022
Applies to:
Symptoms
When using the ORACLEВ JDBC thinВ driver В to access aВ database server instance, it В fails with the following Exception:
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
This happens whenВ looping on the following sequence :
- connect to the database server В (DriverManager.getConnection() В method)
- close JDBC connection
AfterВ executing N times (randomly) this sequence of code fails at connection time.
Changes
Cause
To view full details, sign in with your My Oracle Support account.
Don’t have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com. пїЅ Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use
Источник
ORA-17002 error
I am using Sun JDK for Linux and classes12.zip to connect to Oracle8i 8.1.5 EE Server running on Red Hat Linux 6.2.
It’s a multithreaded application which connects successfully to the database, works fine for some time but suddenly starts throwing ORA-17002.
I am struggling to sort out this error, the JDK version is. Can anyone help ?
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0_02)
Thanks in anticipation,
Hi, I get this too. Win2k to sun solaris 8 (8.1.7) Did anyone find a reason why this happens?
quote: Originally posted by koustubh kulkarni ([email protected]):
Hi,
I am using Sun JDK for Linux and classes12.zip to connect to Oracle8i 8.1.5 EE Server running on Red Hat Linux 6.2.
It’s a multithreaded application which connects successfully to the database, works fine for some time but suddenly starts throwing ORA-17002.
I am struggling to sort out this error, the JDK version is. Can anyone help ?
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0_02)
Thanks in anticipation,
Me too! Relates to ‘java.sql.SQLException: Io exception: End of
TNS data channel’ as the error code of the exception.
I’m on 8.1.7 talking to 8.1.7
I got the same problem, this is sporadic.
Here is what I found:
1) duplicate host name in the host file
2) Oracle thin driver version issues
3) JDBC port blocking, ie 1521
4) SID & service name issues
5) Oracle BLOB issues
6) result set exhaust, close it before re-crate one.
None of them can solve my problem. The error just come out from no-where, and goes away by itself. It is on my production server, so I am getting calls every hour.
I’m getting this error in a multi-threaded application that connects to 9i database. I am able to connect to connect with 25 clients, but several clients will received this message «Io Exception: invalid arguments in call». Each client when done, will make the same call:
cstmt = dbConnection.prepareCall( «» );
cstmt.setInt( 1, getSyncID() ); /* sync ID */
cstmt.execute();
Out of 25 clients, only one or two will experience this problem. The error stack is as follows:
java.sql.SQLException: Io exception: invalid arguments in call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.driver.OracleStatement.freeLine(OracleStatement.java:6480)
at oracle.jdbc.driver.OracleConnection.needLine(OracleConnection.java:2432)
at oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:577)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2806)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:685)
at com.tiscor.syncserver.ServerThread.sync_Logout(ServerThread.java:1149)
at com.tiscor.syncserver.ServerThread.run(ServerThread.java:348)
I’m getting the error when close connection.
Источник
I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get an IO Error: The Network Adapter could not establish the connection Vendor Code 17002 error.
- connecting using sqlplus from my machine:
sqlplus cd2/ @ec2-publicIp.myCloud.compute.amazonaws.com:1522/orcl
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 3 15:30:56 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
ERROR:
ORA-12541: TNS:no listener
- On the ec2 instance, Security Groups, a TCP 1522 port is open for my machine’s public IP
- telnet to the instance, port 1522 seems to indicate that the port is open:
telnet ec2-pubIp.compute.amazonaws.com 1522
Trying pubIp...
telnet: connect to address pubIp: Connection refused
telnet: Unable to connect to remote host
- Port 1522 is used consistently across all the configurations
- I verified that the ec2 hostname (
hostnamecommand) matches the service name output fromlsnrctl status. The output showslocalhostinstead ofip-localIp.myCloud.compute.internal.
$ hostname
ip-localIp.myCloud.compute.internal
$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 03-AUG-2020 15:20:44
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip-localIp.myCloud.compute.internal)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 03-AUG-2020 13:30:22
Uptime 0 days 1 hr. 50 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/centos/product/12.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/centos/diag/tnslsnr/ip-localIp/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
Services Summary...
Service "orcl.myCloud.compute.internal" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.myCloud.compute.internal" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
- The hostname and port also matches the default listener configured in
listener.ora:
cat /u01/app/centos/product/12.2.0/dbhome_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/centos/product/12.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip-localIp.myCloud.compute.internal)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
- Oracle parameters are as shown, again both host and port match:
SQL> show parameter listener_networks
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST =
ip-localIp.myCloud
.compute.internal)(PORT = 1522
))
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string
- I can connect from the ec2 instance:
sqlplus / as sysdba - I can connect from the ec2 instance as a schema/user cd2:
sqlplus cd2/ @orcl
SQL*Plus: Release 12.2.0.1.0 Production on Mon Aug 3 18:04:13 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter password:
Last Successful login time: Mon Aug 03 2020 18:03:52 +00:00
Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SP2-0310: unable to open file "orcl.sql"
SQL> select 1 from dual;
1
----------
1
SQL>
- SQL Developer connection matches both the port and ec2’s public domain name:
- This database server is our dev instance so no license was installed
- Updated
listener.oraby setting theHOSTvalue to0.0.0.0, restarted withlsnrctlbut the result was the same:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
/etc/hostscontent:
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ip-localIp.myCloud.compute.internal
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
- I also tested it with all inbound traffic and all ports opened for the ec2 instance
Рекомендуется
Ускорьте свой компьютер сегодня с помощью этой простой в использовании загрузки. г.
Я пытаюсь подключиться к Oracle DB из Java, моего любимого приложения (установленного с очень удаленного компьютера). но я генерирую код ошибки SQL 17022. Пожалуйста, дайте мне знать, как сообщение может решить эту проблему.
MSG: fix to jdbc: oracle: thin: @ (описание означает (address_list = (address = (protocol = tcp) (host равен dlocdb04) (port = 500000))) (address = (protocol is равно tcp )) (хост = dlocdb04) (порт равен 500000))) (connect_data = (service_name = os02rtdb01svc.world) (сервер соответствует выбранному))) с версией драйвера Oracle JDBC: 9.2.0.1.0 [совокупный выбор попыток = 0] USER_ID: неизвестно Уровень: УВЕДОМЛЕНИЕ Дата: 21.09.2015 10:51:45 563 Категория: com.retek.merch.utils.ConnectionPoolMSG: [Код ошибки SQL: 17002, Null] Статус: принадлежность к физической базе данных действительно недействительна. Перезапуск пула из-за ошибки точно здесь. USER_ID: НЕИЗВЕСТНОjava.sql.SQLException: Исключение Io: Соединение отклонено (DESCRIPTION = (ERR = 1153) (VSNNUM означает 0) (ERROR_STACK = (ERROR = (CODE означает 1153) (EMFI = 4) (ARGS = '(DESCRIPTION означает (ADDRESS = (ПРОТОКОЛ = TCP) (HOST подразумевает dlocdb0401) (PORT = 27320)) (CONNECT_DATA = (CID равно (PROGRAM =) (HOST = __ jdbc __) (USER =)) null))) ')) (ERROR = ( КОД равен 303) (EMFI = 1)))) доступно в oracle.jdbc.dbaccess.DBError.throwSqlException (DBError.java:134) в oracle.jdbc.dbaccess.DBError.throwSqlException (DBError.java:179) в oracle.jdbc.dbaccess.DBError.throwSqlException (DBError.java:333) Только oracle.jdbc.driver.OracleConnection. <инициализация> (OracleConnection.java:404) исключительно oracle.jdbc.driver.OracleDriver.getConnectionInstance (OracleDriver.java:468) вокруг oracle.jdbc.driver.OracleDriver.connect (OracleDriver.java:314) в java.sql.DriverManager.getConnection (DriverManager.java:512) в java.sql.DriverManager.getConnection (DriverManager.java:140) возможно, в oracle.jdbc.pool.OracleDataSource.getConnection (OracleDataSource.java:169) зайдя в oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection (OracleConnectionPoolDataSource.java:149). в то время как oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection (OracleConnectionPoolDataSource.java:95) перейдя к oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection (OracleConnectionPoolDataSource.java:63). в oracle.jdbc.pool.OracleConnectionCacheImpl.getNewPoolOrXAConnection (OracleConnectionCacheImpl.java:547) можно найти в oracle.jdbc.pool.OracleConnectionCacheImpl.getPooledConnection (OracleConnectionCacheImpl.java:404) в oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection (OracleConnectionCacheImpl.java:298) найдено в oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection (OracleConnectionCacheImpl.java:268) когда это был com.retek.merch.utils.ConnectionPool.get (ConnectionPool.java:346) на com.retek.merch.utils.TransactionManager.start (TransactionManager.java:59) на com.retek.reim.merch.utils.ReIMTransactionManager.start (ReIMTransactionManager.java:49) только на com.retek.reim.manager.LoginManager.login (LoginManager.java:72) на com.retek.reim.ui.login.LoginAction.perform (LoginAction.java:47) здесь в разделе org.apache.struts.action.ActionServlet.processActionPerform (ActionServlet.java:1786) автор: org.apache.struts.action.ActionServlet.process (ActionServlet.java:1585) с переходом на org.apache.struts.action.ActionServlet.doPost (ActionServlet.java:509). исходя из javax.servlet.http.HttpServlet.service (HttpServlet.java:638) рядом с javax.servlet.http.HttpServlet.service (HttpServlet.java:720) в org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:199) автор: org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:145) готово на org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:210) на org.apache.catalina.core.StandardPipeline $ StandardPipelineValveContext.invokeNext (StandardPipeline.java:596) в org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:433) на org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:955) на org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:139) найдено по адресу org.apache.catalina.core.StandardPipeline $ StandardPipelineValveContext.invokeNext (StandardPipeline.java:596) автор: org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:433) наличие org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:955) в org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2460) на org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:133) в org.apache.catalina.core.StandardPipeline $ StandardPipelineValveContext.invokeNext (StandardPipeline.java:596) в org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:119) с org.apache.catalina.core.StandardPipeline $ StandardPipelineValveContext.invokeNext (StandardPipeline.java:594) здесь, на org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:116) только org.apache.catalina.core.StandardPipeline $ StandardPipelineValveContext.invokeNext (StandardPipeline.java:594) когда он был org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:433) на org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:955) через org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:127) внутри org.apache.catalina.core.StandardPipeline $ StandardPipelineValveContext.invokeNext (StandardPipeline.java:596) внутри org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:433) на org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:955) в org.apache.coyote.tomcat4.CoyoteAdapter.service (CoyoteAdapter.java:157) в org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:873) родом из org.apache.coyote.http11.Http11BaseProtocol $ Http11ConnectionHandler.processConnection (Http11BaseProtocol.java:665) затем в org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket (PoolTcpEndpoint.java:528) после org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt (LeaderFollowerWorkerThread.java:81) в соответствии с org.apache.tomcat.util.threads.ThreadPool $ ControlRunnable.run (ThreadPool.java:689) после java.lang.Thread.run (Thread.java:534) Ответ: В вашем случае большинство "кодов поставщиков 17002"это точный дефект ORA-12541: его можно описать как очень вероятно, чтоВаша гарнитура имеет неправильное название подключаемого модуля или службы.Из документов TNS:
<цитата> ORA-12541: без наушников
Что означает код ошибки "Отказано в соединении ERR"?
Причина: прослушиватель репозитория местоположения был недоступен.начинать.
Действие: Запускаем наушники на машине где какой именно источникДепо находится.
Рекомендуется
Ваш компьютер работает медленно? У вас проблемы с запуском Windows? Не отчаивайтесь! ASR Pro - это решение для вас. Этот мощный и простой в использовании инструмент проведет диагностику и ремонт вашего ПК, повысит производительность системы, оптимизирует память и повысит безопасность процесса. Так что не ждите - скачайте ASR Pro сегодня!
1. Скачать ASR Pro
2. Следуйте инструкциям на экране, чтобы запустить сканирование.
3. Перезагрузите компьютер и подождите, пока он завершит сканирование, а затем снова следуйте инструкциям на экране, чтобы удалить все вирусы, обнаруженные при сканировании компьютера с кодом ASR Pro.
В основном SQL Developer не может найти слушателя. Сначала проверьтеtnsnames.ora и, к сожалению, убедитесь, что он указывает, что сервер будет исправлять иГавань. Если весь сервер форм находится на другом компьютере, проверьте разрешение TNS.с помощью tnsping из командной строки. Наконец, проверьте, могу ли я сказать, чтоСлушатель.
#Статус
Этот lsnrctl должен отображать статус каждого слушателя и легальную службу.Слушать. Имейте это в виду при запуске SQL * Plus в базе данных.Сервер, ему не просто нужен прослушиватель для подключениязапись для конкретной базы данных tnsnames.ora.
Они будут использовать статус выгодных предложений lsnrctl, чтобы убедиться,наушники всегда включены, и lsnrctl запускает ваши наушники.Если вы наверняка все еще находитесь в Windows, также проверьте, работает ли служба для посетителей шоу.
<время>
Вопрос: Пробовал ли я связываться с Oracle?SQL Developer и я вижу все беды.
Исключение OK: сетевая карта не ожидается полностьюУстановить соединение
Код продавца 17002
<р>Действие: Запустите настоящий прослушиватель точно на исходном компьютере.Репозиторий.
Следующие простые ошибки, безусловно, могут возникнуть во время проектирования (с течением времени как во входящих, так и в исходящих направлениях) и во время работы.
<ул>
Сообщение было получено не только через X секунд после интервала смещения
Задержка может быть вызвана множеством причин, например, препятствиями для подключения между Oracle Integration и Connectivity Brokerage или изменением производительности агента подключения. Если возникает эта ошибка, убедитесь, что соединение с агентом работает. Проверьте состояние конкретного агента в разделе Панели мониторинга> Агенты в Oracle Integration.
<дел>
Можете ли вы помочь мне с кодом поставщика 17002?
Примечание.
Если вы используете адаптер для подключения к экземпляру базы данных Oracle E-Business Suite, эта уникальная ошибка повторяется, проверьте планы Quandary SQL и другие настройки SQL. области работы. ... Адаптер использует JDBC в API-интерфейсах вредоносных драйверов для получения метаданных, таких как новости таблиц, информация о хранимых процедурах и т. д. Это включает выполнение SQL путем запроса драйвера JDBC, что означает таблицы SYS, такие как ALL_TYPES room table . Поскольку Oracle E-Business Suite имеет гигантский словарь данных, запросы метаданных должны решать рекламную и маркетинговую задачу, повышая общую производительность какого-либо адаптера.
SQLState: 08006 errorCode: 17002 Сообщение: Ошибка ввода-вывода: время ожидания соединения истекло
Эта ошибка должна иметь место, когда сеансы базы данных прерываются любым огромный сетевой брандмауэр или какое-то другое объяснение, почему. Адаптер автоматически восстановится во время округа, и будут созданы новые соединения. Однако для отдельных запросов, использующих предыдущие соединения, может истечь время ожидания. Убедитесь, что эксперты говорят, что брандмауэр больше не прерывает непродуктивные соединения.
Тайм-ауты также могут возникать из-за запросов дизайна. Избегайте определенных антимоделей. Например, не создавайте явно ту же таблицу, что и при создании хирургического вмешательства, если страница инициализации может запросить новую такую же таблицу.
Сообщение не получено после ожидания X секунд
Если вы используете адаптер для подъема в определенное место базы данных Oracle E-Business Suite, в дополнение к постоянным ошибкам проверьте чьи-то планы SQL-запросов и другие аспекты оптимизации SQL. Адаптер использует JDBC в API-интерфейсах драйвера для получения метаданных, таких как табличная информация, сохраненные умеренные данные и т. д. Это требует, чтобы иногда выполнялся некоторый SQL путем поиска в драйвере JDBC, правильное оборудование SYS, такое как таблица ALL_TYPES . Поскольку в Oracle E-Business Suite есть один хороший словарь данных, запросы метаданных должны быть оптимизированы для улучшения общих результатов адаптера.
Ускорьте свой компьютер сегодня с помощью этой простой в использовании загрузки. г.
Connection Refused Error Code 17 002
Anslutning Nekad Felkod 17 002
Verbindung Abgelehnt Fehlercode 17 002
Codice Errore Connessione Rifiutata 17 002
연결 거부 오류 코드 17 002
Polaczenie Odrzucone Kod Bledu 17 002
Connexion Refusee Code Erreur 17 002
Verbinding Geweigerd Foutcode 17 002
Codigo De Erro De Conexao Recusada 17 002
Codigo De Error De Conexion Rechazada 17 002
г.
Related posts:
Возникла проблема с кодом ошибки SMTP 501 5.1.3
Советы по устранению неполадок что означает Pid в диспетчере задач?
Как и легко исправить отказ в доступе к Backup Exec 11d Exchange
Как исправить отказ в доступе к кактусам?
SQL Developer Cannot Connect To Database Fails With Vendor code 17002 (Doc ID 1324766.1)
Last updated on SEPTEMBER 20, 2022
Applies to:
Symptoms
In the process of rolling out banners for SEC_USER_UNAUTHORIZED_ACCESS_BANNER and SEC_USER_AUDIT_ACTION_BANNER.
Testing applications to see if there was any effect on connectivity, and noticed unable to connect to the database using SQL Developer (3.0.04). SQL Developer throws error:
Error
———
An error was encountered performing the requested operation:
IO Error: Got minus one from a read call
Vendor code 17002
Works
————
Using SQL Developer 2.1 connects without any errors
SQL Plus can connect to the database without any issues, as can TOAD
SQL Developer can connect to the database without issues if we remove the banner files.
Does Not Work
—————
Using SQL Developer 3.0 and banner files.
Changes
Upgraded from SQL Developer 2.1 to 3.0.
Cause
To view full details, sign in with your My Oracle Support account.
Don’t have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com. пїЅ Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use
Источник
SQL Developer 4.1.1 Status : Failure -Test Failed Vendor Code 17002 (Doc ID 2038401.1)
Last updated on SEPTEMBER 20, 2022
Applies to:
Symptoms
When the global name of a database contains hyphens, if you define a connection with SERVICE_NAME instead of SID, it will cause the following error when testing the connection :
«Status : Failure -Test failed: IO Error: Invalid connection string format, a valid format is: «host:port:sid»
If you use SID instead of SERVICE NAME, the connection will succeed.
Changes
Cause
To view full details, sign in with your My Oracle Support account.
Don’t have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com. пїЅ Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use
Источник
sql developer code 17002 IO Adapter could not establish connection
I get an error when trying to establish a connection from SQL Developer — this has previously worked. Where do I check the TNSListener configuration — trying to find this in Oracle Docs now.
Oracle JDK 1.8.0.121
SQL Developer 4.1.5.21 Build Main 21.78
Oracle Express 11g
i am able to ping the hostname of the box.
systemctl status oracle-xe.service:
oracle-xe.service — SYSV: This is a program that is responsible for taking care of
Loaded: loaded (/etc/rc.d/init.d/oracle-xe; bad; vendor preset: disabled)
Active: active (exited) since Wed 2017-03-01 00:21:32 EST; 2 days ago
Process: 1789 ExecStart=/etc/rc.d/init.d/oracle-xe start (code=exited, status=0/SUCCESS)
Mar 01 00:21:21 oracleexpress oracle-xe[1789]: Starting Oracle Net Listener.
Mar 01 00:21:21 oracleexpress su[1817]: (to oracle) root on none
Mar 01 00:21:24 oracleexpress oracle-xe[1789]: Starting Oracle Database 11g Express Edition instance.
Mar 01 00:21:24 oracleexpress su[2384]: (to oracle) root on none
oracle 2349 1 0 Mar02 ? 00:00:02 /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr LISTENER -inherit
oracle 2706 1 0 Mar02 ? 00:00:04 xe_pmon_XE
oracle 2718 1 0 Mar02 ? 00:00:08 xe_psp0_XE
oracle 2731 1 0 Mar02 ? 00:00:10 xe_vktm_XE
oracle 2742 1 0 Mar02 ? 00:00:01 xe_gen0_XE
oracle 2749 1 0 Mar02 ? 00:00:01 xe_diag_XE
oracle 2760 1 0 Mar02 ? 00:00:00 xe_dbrm_XE
oracle 2770 1 0 Mar02 ? 00:00:08 xe_dia0_XE
oracle 2779 1 0 Mar02 ? 00:00:01 xe_mman_XE
oracle 2788 1 0 Mar02 ? 00:00:01 xe_dbw0_XE
oracle 2798 1 0 Mar02 ? 00:00:01 xe_lgwr_XE
oracle 2804 1 0 Mar02 ? 00:00:05 xe_ckpt_XE
oracle 2812 1 0 Mar02 ? 00:00:01 xe_smon_XE
oracle 2819 1 0 Mar02 ? 00:00:00 xe_reco_XE
oracle 2825 1 0 Mar02 ? 00:00:04 xe_mmon_XE
oracle 2835 1 0 Mar02 ? 00:00:03 xe_mmnl_XE
oracle 2845 1 0 Mar02 ? 00:00:00 xe_d000_XE
oracle 2853 1 0 Mar02 ? 00:00:00 xe_s000_XE
oracle 2862 1 0 Mar02 ? 00:00:00 xe_s001_XE
oracle 2871 1 0 Mar02 ? 00:00:00 xe_s002_XE
oracle 2878 1 0 Mar02 ? 00:00:00 xe_s003_XE
oracle 3182 1 0 Mar02 ? 00:01:38 xe_vkrm_XE
oracle 3184 1 0 Mar02 ? 00:00:00 xe_qmnc_XE
oracle 3217 1 0 Mar02 ? 00:00:04 xe_cjq0_XE
oracle 3228 1 0 Mar02 ? 00:00:00 xe_q001_XE
oracle 3264 1 0 Mar02 ? 00:00:01 xe_smco_XE
oracle 12222 1 0 Mar02 ? 00:00:00 xe_q000_XE
oracle 14184 1 0 00:39 ? 00:00:00 xe_w000_XE
Best Answer
No — it was NOT ‘an odd caching issue’. It was what I told you earlier
The results of ‘lsnrctl services’ do NOT show ANY DB registered with the listener. Either the DB wasn’t running or it hadn’t registered.
Answers
If you’re on Unix, the location should be $ORACLE_HOME/network/admin
That exception has NOTHING to do with the listener. Your attempt never leaves the client.
You are calling a number that doesn’t exist.
We can’t help you if you don’t SHOW US:
2. HOW you do it
3. WHAT results you get
You need to show us the type of connection you are trying to create and the parameters you use in the connection dialog to make it.
The hostname, port or SID/SERVICE_NAME you are using are wrong or you don’t have that host name in your hosts file.
1) Run Sql Develeoper
2) Double click icon on desktop
3) Network IO Error error code 17002
Connection Type: Basic
ns33: flags=4163 mtu 1500
inet 192.168.1.15 netmask 255.255.255.0 broadcast 192.168.1.255
inet6 fe80::7627:cbc6:cb6:19c2 prefixlen 64 scopeid 0x20
ether 00:0c:29:33:71:c7 txqueuelen 1000 (Ethernet)
RX packets 26096 bytes 20855024 (19.8 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 19479 bytes 5091086 (4.8 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
27.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
listener.ora Network Configuration File:
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
Oddly I have another connect which uses localhost, & I get an Error 12505 on that one — tns does not the SID —
Well — that’s your problem isn’t it? This is what I said
Your host name is ‘oracleexpress’ — I don’t see that in your ‘hosts’ file anywhere do you? If the host name isn’t in the file then the JDBC driver can’t find it to get the IP address of the DB server.
Well — local host is in the ‘hosts’ file but what you posted shows you are using 27.0.0.1 as the IP address when the local host address should be 127.0.0.1
If the ‘sid’ can’t be found then the database isn’t registered with the listener. Post the results of
‘lsnrctl services’ and it will show you EVERYTHING the listener knows about.
Most DBs these days register automatically when you start them. So if your sid ‘xe’ isn’t listed the database either isn’t open or the registration failed.
The TNSnames.ORA file is NOT used for basic connections.
Thanks for your reply — but it was my BAD very BAD.
When i pasted the /etc/hosts file — i made two mistakes — I missed the 1 from local host, and when I subsequently pasted the other data, the cursor was in the wrong place. Really sorry about that. for completeness I paste the full /etc/hosts below
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
LSNRCTL for Linux: Version 11.2.0.2.0 — Production on 05-MAR-2017 02:32:03
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Service «PLSExtProc» has 1 instance(s).
Instance «PLSExtProc», status UNKNOWN, has 1 handler(s) for this service.
Источник
unable to connect through sqldeveloper vendor error code 17002
I am using sqldeveloper on windows 7 . The sql developer version is given below
Java(TM) Platform 1.6.0_23
Oracle IDE 2.1.1.64.45
Versioning Support 2.1.1.64.45
I am getting this error while connecting to the db.
IO exception: The Network Adaptor couldnt establish the connection.
Vendor code: 17002
I am able to connect the db through the command prompt.
———————
Listener status
———————
C:UsersDev D>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 — Production on 19-DEC-2010 12:43:52
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 — Production
Start Date 19-DEC-2010 12:26:31
Uptime 0 days 0 hr. 17 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:oraclexeapporacleproduct10.2.0servernetworkadminlistener.ora
Listener Log File C:oraclexeapporacleproduct10.2.0servernetworkloglistener.log
Listening Endpoints Summary.
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DevD-PC)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary.
Service «CLRExtProc» has 1 instance(s).
Instance «CLRExtProc», status UNKNOWN, has 1 handler(s) for this service.
Service «PLSExtProc» has 1 instance(s).
Instance «PLSExtProc», status UNKNOWN, has 1 handler(s) for this service.
Service «XEXDB» has 1 instance(s).
Instance «xe», status READY, has 1 handler(s) for this service.
Service «XE_XPT» has 1 instance(s).
Instance «xe», status READY, has 1 handler(s) for this service.
Service «xe» has 1 instance(s).
Instance «xe», status READY, has 1 handler(s) for this service.
The command completed successfully
C:UsersDev D>tnsping xe
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 — Production on 19-DEC-2010 12:49:39
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:oraclexeapporacleproduct10.2.0servernetworkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DevD-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (14000 msec)
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DevD-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct10.2.0server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct10.2.0server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = DevD-PC)(PORT = 1521))
)
)
Could someone help me what am i missing here
Источник
SQL Developer 1.5.4.59.40 — IO Exception: Undefined Error VENDOR CODE 17002
Hi All.
I hope someone can help.
I have recently installed Oracle XE on my Vista Ultimate laptop and it is up and running with no apparent problems. I then connected to the HR schema on XE with no problems using SQL Developer 1.2.1.3213 (OLD Version). I noticed that SQL Developer 1.5.4.59.40 (NEW version) was available and downloaded it (the offering without JDK included) and renamed the «C:Program FilesSQLDeveloper» folder holding the older version to «C:Program FilesSQLDeveloper_Orig» and placed the new version of SQL Developer in the Prog Files directory to give «C:Program FilesSQLDeveloper».
I then ran SQLDeveloper.exe (NEW) and when requested gave the JDK path as «C:Program FilesJavaJDK_1.6.0_11binjava.exe» (‘Java -version’ gives 1.6.0_11-b03) and migrated over the settings from the previous version of SQLDeveloper (OLD).
The Application loads fine but when i attempt to connect to XE’s HR schema i get the following error:
«IO Exception: Undefined Error
VENDOR CODE 17002″
I have searched to try and find out what is going on but cannot find any solutions that work. The previous 17002 error solutions on this forumn have all failed.
These included changing the JDK.conf file to hold route to JDK directory and also creating a ‘bat’ file.
My system does not have the directory for the JDK in it’s PATH environment setting (either USER or SYSTEM) but does include a directory path under SYSTEM environment vars to another version fo JDK on my machine under «C:Program FilesSunJDK». I thought this may be causing a conflict but it is version 1.6.0.05_b13 and is also compatible-is it not? I also have Java JRE6 (1.6.0_12-b04) on my machine — this does not have a PATH variable and was not referenced when loading SQL Developer when loading the first time.
Can anyone help me resolve this, why can the previous version still connect OK to XE and not new version? is there something i am missing? Do i require the Java JDK Directory to be placed under a PATH environment SYSTEM variable?
Thanks in advance,
M
Edited by: user592047 on 16-Mar-2009 10:08
Answers
Taken from about SQL Developer:
Version:
————
CVS Version Internal to Oracle SQL Developer (client-only)
Java(TM) Platform 1.6.0_11
Oracle IDE 1.5.4.59.40
Versioning Support 1.5.4.59.40
Источник