SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql developer code 17002 IO Adapter could not establish connection

Russell ClayMar 3 2017 — edited Apr 10 2017

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.

Linux 7

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

Docs: man:systemd-sysv-generator(8)

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

ps -ef

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

This post has been answered by unknown-7404 on Mar 9 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2017

Added on Mar 3 2017

#sql-developer

9 comments

10,415 views