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.
Содержание
- Sql error 17002 sqlstate 08006
- Решение проблемы с кодом “Отказ в соединении” означает 17 002 Проблема
- Рекомендуется
- Можете ли вы помочь мне с кодом поставщика 17002?
- JBossDeveloper
Sql error 17002 sqlstate 08006
The following errors can occur during both design time (in both the inbound and outbound directions) and runtime.
There can be multiple reasons for a time out occurring, such as connectivity issues between Oracle Integration and the connectivity agent or the connectivity agent being disabled. Ensure that the connectivity agent is up and running if you see this error. Check the status of the agent under Dashboards > Agents in Oracle Integration .
When using the adapter to connect to an Oracle E-Business Suite database instance and this error continuously occurs, review the SQL query plans and other SQL tuning aspects. The adapter relies on JDBC driver APIs to fetch metadata such as table details, stored procedure details, and so on. This involves execution of certain SQL queries by the JDBC driver involving SYS tables such as the ALL_TYPES table. Since Oracle E-Business Suite has a large data dictionary, these metadata queries requires tuning consideration to improve overall performance of the adapter.
This error can occur when database sessions are terminated by a network firewall or some other reason. The adapter automatically recovers during this state and new connections are created. However, a few requests using old connections may time out. Ensure that the firewall is not terminating idle connections.
Источник
Решение проблемы с кодом “Отказ в соединении” означает 17 002 Проблема
Table of Contents
Рекомендуется
Я пытаюсь подключиться к Oracle DB из Java, моего любимого приложения (установленного с очень удаленного компьютера). но я генерирую код ошибки SQL 17022. Пожалуйста, дайте мне знать, как сообщение может решить эту проблему.
Этот lsnrctl должен отображать статус каждого слушателя и легальную службу.Слушать. Имейте это в виду при запуске SQL * Plus в базе данных.Сервер, ему не просто нужен прослушиватель для подключениязапись для конкретной базы данных tnsnames.ora.
Они будут использовать статус выгодных предложений lsnrctl, чтобы убедиться,наушники всегда включены, и lsnrctl запускает ваши наушники.Если вы наверняка все еще находитесь в Windows, также проверьте, работает ли служба для посетителей шоу.
Вопрос: Пробовал ли я связываться с Oracle?SQL Developer и я вижу все беды.
Исключение OK: сетевая карта не ожидается полностьюУстановить соединение
Код продавца 17002
Действие: Запустите настоящий прослушиватель точно на исходном компьютере.Репозиторий.
Следующие простые ошибки, безусловно, могут возникнуть во время проектирования (с течением времени как во входящих, так и в исходящих направлениях) и во время работы.
Задержка может быть вызвана множеством причин, например, препятствиями для подключения между 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 имеет гигантский словарь данных, запросы метаданных должны решать рекламную и маркетинговую задачу, повышая общую производительность какого-либо адаптера.
Эта ошибка должна иметь место, когда сеансы базы данных прерываются любым огромный сетевой брандмауэр или какое-то другое объяснение, почему. Адаптер автоматически восстановится во время округа, и будут созданы новые соединения. Однако для отдельных запросов, использующих предыдущие соединения, может истечь время ожидания. Убедитесь, что эксперты говорят, что брандмауэр больше не прерывает непродуктивные соединения.
Если вы используете адаптер для подъема в определенное место базы данных Oracle E-Business Suite, в дополнение к постоянным ошибкам проверьте чьи-то планы SQL-запросов и другие аспекты оптимизации SQL. Адаптер использует JDBC в API-интерфейсах драйвера для получения метаданных, таких как табличная информация, сохраненные умеренные данные и т. д. Это требует, чтобы иногда выполнялся некоторый SQL путем поиска в драйвере JDBC, правильное оборудование SYS, такое как таблица ALL_TYPES . Поскольку в Oracle E-Business Suite есть один хороший словарь данных, запросы метаданных должны быть оптимизированы для улучшения общих результатов адаптера.
Источник
JBossDeveloper
I am getting following error regarding database connections-
08:05:21,828 WARN [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-0.0.0.0-80-19) SQL Error: 17002, SQLState: 08006
08:05:21,828 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-0.0.0.0-80-19) IO Error: Connection reset
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) org.hibernate.exception.JDBCConnectionException: could not execute query
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.doList(Loader.java:2223)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.list(Loader.java:2099)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.database.NewsFlashDAO.readAlertMessage(NewsFlashDAO.java:85)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.session.DCAGSessionFacade. (DCAGSessionFacade.java:96)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.session.DCAGSessionFacade.getSession(DCAGSessionFacade.java:126)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.action.BaseAction.getSession(BaseAction.java:46)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.action.FrontPageAction.execute(FrontPageAction.java:19)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at sun.reflect.GeneratedMethodAccessor481.invoke(Unknown Source)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at java.lang.reflect.Method.invoke(Method.java:606)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) Caused by: java.sql.SQLException: IO Error: Connection reset
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:874)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.doQuery(Loader.java:674)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.doList(Loader.java:2220)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) . 81 more
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) Caused by: java.net.SocketException: Connection reset
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at java.net.SocketInputStream.read(SocketInputStream.java:189)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at java.net.SocketInputStream.read(SocketInputStream.java:121)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.Packet.receive(Packet.java:282)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.DataPacket.receive(DataPacket.java:103)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) . 92 more
08:05:21,906 ERROR [org.hibernate.transaction.JDBCTransaction] (http-0.0.0.0-0.0.0.0-80-19) JDBC commit failed: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3640) [ojdbc5.jar:11.2.0.1.0]
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680) [ojdbc5.jar:11.2.0.1.0]
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139) [hibernate3.jar:3.2.4.sp1]
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115) [hibernate3.jar:3.2.4.sp1]
at com.snapon.daimlerportal.database.DCAGAbstractDAO.freeSession(DCAGAbstractDAO.java:26) [daimlerportal-ejb.jar:]
at com.snapon.daimlerportal.database.NewsFlashDAO.readAlertMessage(NewsFlashDAO.java:93) [daimlerportal-ejb.jar:]
at com.snapon.daimlerportal.session.DCAGSessionFacade. (DCAGSessionFacade.java:96) [classes:]
at com.snapon.daimlerportal.session.DCAGSessionFacade.getSession(DCAGSessionFacade.java:126) [classes:]
at com.snapon.daimlerportal.action.BaseAction.getSession(BaseAction.java:46) [classes:]
at com.snapon.daimlerportal.action.FrontPageAction.execute(FrontPageAction.java:19) [classes:]
at sun.reflect.GeneratedMethodAccessor481.invoke(Unknown Source) [:1.7.0_25]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450) [xwork-core-2.3.15.1.jar:2.3.15.1]
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289) [xwork-core-2.3.15.1.jar:2.3.15.1]
Can anybody tell which type of error is it occurs?
When I started my server application working fine for 5 days, then it starts showing above errors and when we do restart the JBOSS service it starts working fine.
Источник
Version:
springboot: 2.0.2.RELEASE
HikariCP: 3.4.0
ojdbc8: 12.2.0.1
Mybatis: 3.4.0
mybatis-spring: 1.3.0
Hikari Configuration:
Hikari - configuration:
: allowPoolSuspension.............false
: autoCommit......................true
: catalog.........................none
: connectionInitSql...............none
: connectionTestQuery............."SELECT 1 FROM DUAL"
: connectionTimeout...............600000
: dataSource......................none
: dataSourceClassName.............none
: dataSourceJNDI..................none
: dataSourceProperties............{password=<masked>, prepStmtCacheSqlLimit=2048, cachePrepStmts=true, prepStmtCacheSize=250}
: driverClassName................."oracle.jdbc.driver.OracleDriver"
: healthCheckProperties...........{}
: healthCheckRegistry.............none
: idleTimeout.....................600000
: initializationFailTimeout.......5000
: isolateInternalQueries..........false
: jdbcUrl.........................jdbc:oracle:thin:@
: leakDetectionThreshold..........0
: maxLifetime.....................1800000
: maximumPoolSize.................10
: metricRegistry..................none
: metricsTrackerFactory...........none
: minimumIdle.....................5
: readOnly........................false
: registerMbeans..................false
: scheduledExecutor...............none
: schema..........................none
: threadFactory...................internal
: transactionIsolation............default
: validationTimeout...............5000
This exception is thrown when try to do the lots of insert operations, hundreds of data among 10 tables around. Also this operation occurred in the application initialed and the transaction was controlled with Spring @Transactinal.
Stack trace:
Hikari Pool-Data_Visualization_Service - Thread starvation or clock leap detected (housekeeper delta=2m20s593ms).
2020-04-04 01:52:02.648 DEBUG 7202 --- [ice housekeeper] com.zaxxer.hikari.pool.HikariPool : Hikari Pool-Data_Visualization_Service - Before cleanup stats (total=6, active=1, idle=5, waiting=0)
2020-04-04 01:55:57.549 DEBUG 7202 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1585936306922 sessioncount 0
2020-04-04 01:55:57.550 DEBUG 7202 --- [ice housekeeper] com.zaxxer.hikari.pool.HikariPool : Hikari Pool-Data_Visualization_Service - After cleanup stats (total=6, active=1, idle=5, waiting=0)
2020-04-04 01:55:57.550 DEBUG 7202 --- [Engine[Tomcat]]] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 250628 expired sessions: 0
2020-04-04 01:56:29.397 WARN 7202 --- [ice housekeeper] com.zaxxer.hikari.pool.HikariPool : Hikari Pool-Data_Visualization_Service - Thread starvation or clock leap detected (housekeeper delta=4m42s474ms).
2020-04-04 01:56:29.397 DEBUG 7202 --- [ice housekeeper] com.zaxxer.hikari.pool.HikariPool : Hikari Pool-Data_Visualization_Service - Before cleanup stats (total=6, active=1, idle=5, waiting=0)
2020-04-04 01:56:29.399 DEBUG 7202 --- [ice housekeeper] com.zaxxer.hikari.pool.HikariPool : Hikari Pool-Data_Visualization_Service - After cleanup stats (total=6, active=1, idle=5, waiting=0)
2020-04-04 01:57:00.831 DEBUG 7202 --- [ice housekeeper] com.zaxxer.hikari.pool.HikariPool : Hikari Pool-Data_Visualization_Service - Before cleanup stats (total=6, active=1, idle=5, waiting=0)
2020-04-04 01:57:00.832 DEBUG 7202 --- [ice housekeeper] com.zaxxer.hikari.pool.HikariPool : Hikari Pool-Data_Visualization_Service - After cleanup stats (total=6, active=1, idle=5, waiting=0)
2020-04-04 01:57:00.835 WARN 7202 --- [ main] com.zaxxer.hikari.pool.ProxyConnection : Hikari Pool-Data_Visualization_Service - Connection oracle.jdbc.driver.T4CConnection@22d8f4ed marked as broken because of SQLSTATE(08006), ErrorCode(17002)
java.sql.SQLRecoverableException: IO Error: Operation timed out
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:932) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.4.0.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) [HikariCP-3.4.0.jar:na]
at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) [mybatis-3.4.0.jar:3.4.0]
at com.sun.proxy.$Proxy110.execute(Unknown Source) [na:na]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46) [mybatis-3.4.0.jar:3.4.0]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) [mybatis-3.4.0.jar:3.4.0]
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) [mybatis-3.4.0.jar:3.4.0]
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) [mybatis-3.4.0.jar:3.4.0]
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) [mybatis-3.4.0.jar:3.4.0]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198) [mybatis-3.4.0.jar:3.4.0]
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185) [mybatis-3.4.0.jar:3.4.0]
at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434) [mybatis-spring-1.3.0.jar:1.3.0]
at com.sun.proxy.$Proxy81.insert(Unknown Source) [na:na]
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:279) [mybatis-spring-1.3.0.jar:1.3.0]
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:56) [mybatis-3.4.0.jar:3.4.0]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53) [mybatis-3.4.0.jar:3.4.0]
at com.sun.proxy.$Proxy94.saveChartInfo(Unknown Source) [na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:365) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:308) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:135) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:422) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1698) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:579) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:501) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) [spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:760) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:869) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) ~[spring-boot-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395) ~[spring-boot-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) ~[spring-boot-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1255) ~[spring-boot-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1243) ~[spring-boot-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at RunApplication.main(RunApplication.java:13) ~[classes/:na]
Caused by: java.io.IOException: Operation timed out
at sun.nio.ch.FileDispatcherImpl.read0(Native Method) ~[na:1.8.0_121]
at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:39) ~[na:1.8.0_121]
at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223) ~[na:1.8.0_121]
at sun.nio.ch.IOUtil.read(IOUtil.java:197) ~[na:1.8.0_121]
at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380) ~[na:1.8.0_121]
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:144) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.net.ns.NIOHeader.readHeaderBuffer(NIOHeader.java:82) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:139) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:101) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:80) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(T4CMAREngineNIO.java:98) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:534) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:485) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
... 76 common frames omitted
2020-04-04 01:57:00.836 DEBUG 7202 --- [nnection closer] com.zaxxer.hikari.pool.PoolBase : Hikari Pool-Data_Visualization_Service - Closing connection oracle.jdbc.driver.T4CConnection@22d8f4ed: (connection is broken)
2020-04-04 01:57:00.838 DEBUG 7202 --- [ main] org.mybatis.spring.SqlSessionUtils : Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@673a5aa7]
2020-04-04 01:57:00.838 DEBUG 7202 --- [ main] o.s.jdbc.datasource.DataSourceUtils : Returning JDBC Connection to DataSource
I also tried with the maxpoolsize 20, but the issue are the same.
Рекомендуется
Ускорьте свой компьютер сегодня с помощью этой простой в использовании загрузки. г.
Я пытаюсь подключиться к 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
Как исправить отказ в доступе к кактусам?
I am getting following error regarding database connections-
08:05:21,828 WARN [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-0.0.0.0-80-19) SQL Error: 17002, SQLState: 08006
08:05:21,828 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-0.0.0.0-80-19) IO Error: Connection reset
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) org.hibernate.exception.JDBCConnectionException: could not execute query
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.doList(Loader.java:2223)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.list(Loader.java:2099)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.database.NewsFlashDAO.readAlertMessage(NewsFlashDAO.java:85)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.session.DCAGSessionFacade.<init>(DCAGSessionFacade.java:96)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.session.DCAGSessionFacade.getSession(DCAGSessionFacade.java:126)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.action.BaseAction.getSession(BaseAction.java:46)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.snapon.daimlerportal.action.FrontPageAction.execute(FrontPageAction.java:19)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at sun.reflect.GeneratedMethodAccessor481.invoke(Unknown Source)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at java.lang.reflect.Method.invoke(Method.java:606)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
08:05:21,891 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) Caused by: java.sql.SQLException: IO Error: Connection reset
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:874)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.doQuery(Loader.java:674)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at org.hibernate.loader.Loader.doList(Loader.java:2220)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) … 81 more
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) Caused by: java.net.SocketException: Connection reset
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at java.net.SocketInputStream.read(SocketInputStream.java:189)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at java.net.SocketInputStream.read(SocketInputStream.java:121)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.Packet.receive(Packet.java:282)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.DataPacket.receive(DataPacket.java:103)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
08:05:21,906 ERROR [stderr] (http-0.0.0.0-0.0.0.0-80-19) … 92 more
08:05:21,906 ERROR [org.hibernate.transaction.JDBCTransaction] (http-0.0.0.0-0.0.0.0-80-19) JDBC commit failed: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3640) [ojdbc5.jar:11.2.0.1.0]
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680) [ojdbc5.jar:11.2.0.1.0]
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:986)
at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:757)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139) [hibernate3.jar:3.2.4.sp1]
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115) [hibernate3.jar:3.2.4.sp1]
at com.snapon.daimlerportal.database.DCAGAbstractDAO.freeSession(DCAGAbstractDAO.java:26) [daimlerportal-ejb.jar:]
at com.snapon.daimlerportal.database.NewsFlashDAO.readAlertMessage(NewsFlashDAO.java:93) [daimlerportal-ejb.jar:]
at com.snapon.daimlerportal.session.DCAGSessionFacade.<init>(DCAGSessionFacade.java:96) [classes:]
at com.snapon.daimlerportal.session.DCAGSessionFacade.getSession(DCAGSessionFacade.java:126) [classes:]
at com.snapon.daimlerportal.action.BaseAction.getSession(BaseAction.java:46) [classes:]
at com.snapon.daimlerportal.action.FrontPageAction.execute(FrontPageAction.java:19) [classes:]
at sun.reflect.GeneratedMethodAccessor481.invoke(Unknown Source) [:1.7.0_25]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_25]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25]
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450) [xwork-core-2.3.15.1.jar:2.3.15.1]
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289) [xwork-core-2.3.15.1.jar:2.3.15.1]
a
Can anybody tell which type of error is it occurs?
When I started my server application working fine for 5 days, then it starts showing above errors and when we do restart the JBOSS service it starts working fine.
Is there any database configuration missing in my standalone.xml?
Please help me , Thanks in advance.
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- All versions
- Oracle DB
Issue
- What does
java.sql.SQLRecoverableException: Io exception: Connection resetfrom Oracle JDBC driver mean?
Caused by: java.sql.SQLRecoverableException: Io exception: Connection reset
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:521)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:791)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299)
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
- Connection reset problem. User is getting connection reset exceptions error on the server.
The Error Code is : SQL Error: 17002, SQLState: 08006
Resolution
- The error does not originate with JBoss and may require investigation by:
- Network administrators
- Back-end server administrators/database administrators (e.g. Oracle admins)
- Database connection validation/fault tolerance1 may allow JBoss to recover from the externally originating connection failure
- The JBoss Idle timeout period may need to be decreased so that connections timeout on JBoss more rapidly than on the database server.
Root Cause
- This is a generic issue where the connection has been closed or terminated by something outside of the JBoss process.
- This may be due to a firewall, switches on the network, protocol or other network errors, interruptions in network connectivity, etc.
- The database server may be terminating the connection
- The exception may relate to configuration (e.g. timeout period) of the Oracle database server
- The exception may be due to error conditions in the database server
- The exception may be due to a defect in the database server or driver
- A similar exception (with a potentially different cause/resolution) may also occur during login
-
Product(s)
- Red Hat JBoss Enterprise Application Platform
-
Component
- jbossas
-
Category
- Troubleshoot
-
Tags
- eap
- hibernate
- jboss_eap
- jca
- transactions
This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.
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.
I get the above error when connecting to a new schema.
Note that when my VPN is connected initially all the connections(C1,C2,C3…) work fine. I then start working on one connection(C1) and after say 2 hours if i try to connect to C2 I have this error.
I have to disconnect and reconnect to the VPN every time, which is very annoying when you have to do it at least 15-20 times in a day.
Any idea why I could have this issue?
asked Jul 3, 2015 at 7:16
It seems that your vpn closes the connection after some time.
Check if you can ping the database ip before trying connect to it.
If you can’t ping it the problem has nothing to do with java, sql, sqldeveloper, and javascript. It is a network problem that you can try to solve with your network administrator.
answered Jul 3, 2015 at 7:19
In my case, the entry from hosts file was the problem.
Un-commented the following line from hosts worked for me.
# 127.0.0.1 localhost
answered Jul 9, 2019 at 6:44
One reason could be the services OracleServiceORCL and OracleOra…Listener have been off, Check the service running on your computer and turn this two services on, then the problem might be solved.
To avoid this from happening again, try to change the property of the service to automatically run.
answered Feb 14, 2020 at 11:34
0
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
Most probably you have listener configured wrongly, the hostname you specify in connection string must be the same as in the listener.
First check the Firewall and network related issues.
Check if Oracle Listener service is available and running. If not you may use Oracle Net Configuration Assistant tool to add and register new listener.
If the above steps are ok then you need to configure Oracle Listener appropriately. You may use Oracle Net Manager tool or edit “%ORACLE_HOME%networkadminlistener.ora” file manually.
There are 2 options that need to be considered carefully:
Listening Locations associated with the Listener – Hostname(IP) and Port in Listening Location must exactly match the ones used in the connection string.
For example, if you use 192.168.74.139 as target hostname, then there must be Listening Location registered with the same IP address.
Also make sure the you use the same SID as indicated in Database Service associated with the Listener.
Fix Oracle “IO ERROR: The network adapter could not establish the connection” error
Most probably you have listener configured wrongly, the hostname you specify in connection string must be the same as in the listener.
First check the Firewall and network related issues.
Check if Oracle Listener service is available and running. If not you may use Oracle Net Configuration Assistant tool to add and register new listener.
If the above steps are ok then you need to configure Oracle Listener appropriately. You may use Oracle Net Manager tool or edit “%ORACLE_HOME%networkadminlistener.ora” file manually.
There are 2 options that need to be considered carefully:
Listening Locations associated with the Listener – Hostname(IP) and Port in Listening Location must exactly match the ones used in the connection string.
For example, if you use 192.168.74.139 as target hostname, then there must be Listening Location registered with the same IP address.
Also make sure the you use the same SID as indicated in Database Service associated with the Listener.
Fix Oracle “IO ERROR: The network adapter could not establish the connection” error
May 6, 2021
I got ” ORA-17002: io exception: the network adaptor could not establish the connection Vendor code 17002″ error in Oracle database.
ORA-17002: io exception: the network adaptor could not establish the connection Vendor code 17002
Details of error are as follows.
ORA-17002: io exception: the network adaptor could not establish the connection Vendor code 17002
io exception: the network adaptor could not establish the connection Vendor code 17002
This ORA-17002 error is related with the ORA-12541: TNS:no listener error.
This error is related with the listener of database server, if you got this error, then check your database listener as follows.
$ lsnrctl status listener
Listener should be always started.
You can stop and start the Listener as follows.
$ srvctl start listener $ srvctl stop listener
or
$ lsnrctl stop listener $ lsnrctl start listener
Edit the server side sqlnet.ora file and add this parameter:
SQLNET.INBOUND_CONNECT_TIMEOUT=240
There is no need to restart either the listener or the database after this change unless the database is running in shared server mode.
The next dedicated server process that gets spawned will pick up the new setting.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
1,490 views last month, 1 views today
Hey guys! Have you ever faced the TNS IO error saying “The network adapter could not establish the connection”? when you are trying to make a new connection in SQL Developer or logging on to the database using SQL*Plus editor. If yes then you are at the right place because here in this blog I am going to show you how you can solve this error.
So without further ado let’s proceed to solve this badass TNS error.
Step 1: Make sure your entries are correct
First of all to solve “The network adapter could not establish the connection” error, check whether you have entered the correct username and password as well as the correct Hostname and Port number. Though these are small things we cannot avoid them. After all “It’s the small things in a relationship that means the most.”
[bctt tweet=”How to solve “The network adapter could not establish the connection” error in just 2 steps” username=”RebellionRider”]
For the valid hostname and port number, you can check the Listener.ora if you have access to your server as the listener is a server process. In case you don’t have access to listener.ora file then you can check the tnsnames.ora file.
In case of Listener.ora file check for Host and Port entry in Listener tag for valid hostname and port number.
Listener.ora
And if you are using TNSnames.ora file for validating the hostname and port number then search for the entry which has the same name as your SID and then check for host and port number entry in that particular tag.
TNSnames.ora
Now try connecting. If this solves your problem then you can avoid the next step. But if “The network adapter could not establish the connection” error is still there, then don’t worry just follow the next step.
Step 2: Is your listener taking a rest?
If your problem is still there and you haven’t gotten rid of that nasty error then there is a possibility that your Listener is not running. To check whether Listener is up and running or not, simply open up your command prompt with Administrative privileges and Write
C:> lsnrctl status
This command will show you the status of your listener. If the output of this command looks like the one shown in the picture below then it clearly means your listener is not running thus next what you have to do is to start the listener.
To start the listener you just have to write
C:> lsnrctl start.
This will start your listener and most probably solve your problem.
Info Byte:
In case you are having problems in starting your listener then try starting “OracleOraDb11g_home1TNSListener” windows service. For that open your Run Command and write services.msc this will open your service panel. Here search for the same and right click to start it.
That’s all you have to do. This must solve the “The network adapter could not establish the connection” error. May the force be with you. Enjoy.
Also, click here to learn how to do initial configuration of Orcale Enterprise Manager to start working with it.
If you find this helpful then please do share it on your social network and help me reach out to more people. Also if you have other queries then reach out to me on my Facebook Page & Twitter. Thanks, guys & have a great day!
SQL Developer FAQ