GVKun编程网logo

IO错误：网络适配器无法与Oracle 11gR2建立连接。与SQL开发人员联系（网络适配器不支持连接数据库）

18

关于IO错误：网络适配器无法与Oracle11gR2建立连接。与SQL开发人员联系和网络适配器不支持连接数据库的问题就给大家分享到这里，感谢你花时间阅读本站内容，更多关于centos6.5下安装ora

关于IO错误：网络适配器无法与Oracle 11gR2建立连接。与SQL开发人员联系和网络适配器不支持连接数据库的问题就给大家分享到这里，感谢你花时间阅读本站内容，更多关于centos 6.5下安装oracle 11gR2与Oracle自动启动的配置、IO错误：网络适配器无法与Oracle 11gR2建立连接与SQL开发人员联系、java – 无法创建PoolableConnectionFactory(Io异常：网络适配器无法建立连接)、java实现的client，无法与服务器建立连接。等相关知识的信息别忘了在本站进行查找喔。

本文目录一览：

IO错误：网络适配器无法与Oracle 11gR2建立连接。与SQL开发人员联系（网络适配器不支持连接数据库）

IO错误：网络适配器无法与Oracle 11gR2建立连接。与SQL开发人员联系（网络适配器不支持连接数据库）

我按照以下步骤尝试在“ http://technologylair.net/2013/08/oracle-11g-installation-
linux/#comment-50 ”中提到的所有步骤，在RedHat6 linux实例上安装了Oracle
11g。使用sql开发器从远程计算机访问数据库。但总是以-“ IO Error: The Network Adapter could notestablish the connection”结尾。

我正在使用的参数是

Username: sys as sysdba Password: <oracle password> Hostname: IP address of the server on which Oracle SQL is installed. Port: 1521 SID: testdb

我还在位置“
/oracle/product/11.2.0/db_1/network/admin”处创建了listener.ora文件，因为以前没有该文件。谁的内容是-

SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = /u01/oracle/product/11.2.0/db_1)      (PROGRAM = extproc)    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_TESTDB))      (ADDRESS = (PROTOCOL = TCP)(HOST = 173.39.238.15)(PORT = 1521))    )  )DEFAULT_SERVICE_LISTENER = (TESTDB)

我也在dba.stackexchange上发布了这个问题。但我需要尽快解决此问题。需要帮助 因此也将其发布在这里。

你能告诉我我可能做错了什么吗？

谢谢。

编辑 “ lsnrctl状态”的输出

连接到（DESCRIPTION =（ADDRESS =（PROTOCOL = IPC）（KEY =
EXTPROC_FOR_TESTDB）））TNS-12541：TNS：无侦听器TNS-12560：TNS：协议适配器错误
TNS-00511：无侦听器Linux错误：2：无此类文件或目录连接到（DESCRIPTION =（地址=（PROTOCOL = TCP）（HOST
= 173.39.238.15）（PORT = 1521）））TNS-12541：TNS：无侦听器TNS-12560：TNS：协议适配器错误
TNS-00511 ：没有侦听器Linux错误：111：连接被拒绝

答案1

小编典典

看来您的监听器没有运行。在数据库服务器上，ps -ef | grep lsnr查看是否正在运行PID
tnslsnr。如果不是，则需要使用启动侦听器lsnrctl start。

centos 6.5下安装oracle 11gR2与Oracle自动启动的配置

centos 6.5下安装oracle 11gR2与Oracle自动启动的配置

注意：以下命令使用 root 用户操作

安装依赖包

主要思路为配置 oracle yum 仓库，直接使用 yum 命令来安装依赖包，避免手工逐个的安装依赖包。

配置 yum 仓库以下载 orcale 依赖包

注意：这里是CentOS 6.X 的 oracle 依赖仓库，其他版本不同的。

导入 GPG Keys

rush:bash;"> wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle --no-check-certificate

安装 oracle 依赖

rush:bash;"> yum install oracle-rdbms-server-11gR2-preinstall

设置 hostname

打开文件 /etc/sysconfig/network，并修改 HOSTNAME。

rush:bash;"> vi /etc/sysconfig/network NETWORKING=yes HOSTNAME=oracle.buzheng.org

打开 /etc/host， 添加服务器本机IP地址 指向到 HOSTNAME

rush:bash;"> vi /etc/hosts 192.168.1.15 oracle.buzheng.org oracle

oracle 用户设置

当安装好 oracle 依赖之后， oracle 用户已经创建好了，不需要手工创建 oracle 用户和相关的用户组。

修改 oracle 用户密码

rush:plain;"> [root@oracle ~]# passwd oracle 更改用户 oracle 的密码 。 新的 密码： 重新输入新的 密码： passwd： 所有的身份验证令牌已经成功更新。

修改系统限制

在文件 /etc/security/limits.d/90-nproc.conf 中添加如下的最后一行

rush:bash;"> [root@oracle ~]# vi /etc/security/limits.d/90-nproc.conf # Default limit for number of user's processes to prevent # accidental fork bombs. # See rhbz #432903 for reasoning. * soft nproc 1024 root soft nproc unlimited * - nproc 16384

修改 SELinux 为 permissive 模式

修改文件 /etc/selinux/config 如下所示

rush:bash;"> [root@oracle ~]# vi /etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing - SELinux security policy is enforced. # permissive - SELinux prints warnings instead of enforcing. # disabled - No SELinux policy is loaded. SELINUX=permissive # SELINUXTYPE= can take one of these two values: # targeted - Targeted processes are protected,# mls - Multi Level Security protection. SELINUXTYPE=targeted

重启机器

rush:bash;"> [root@oracle]# reboot

创建 oracle 安装目录，并授权

rush:bash;"> [root@oracle]# mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1 [root@oracle]# chown -R oracle:oinstall /u01 [root@oracle]# chmod -R 775 /u01

授权 oracle 用户能够访问 X Server

rush:bash;"> [root@oracle]# xhost + # 要在主机上运行，不能是远程 shell

注意：以下命令使用 oracle 用户操作

配置 oracle 安装环境变量

切换到 oracle 用户,编辑 .bash_profile 文件,如下所示,添加环境配置。

rush:bash;"> [root@oracle]# su oracle [oracle@oracle]# vi .bash_profile # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=oracle.buzheng.org; export ORACLE_HOSTNAME ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLAsspATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLAsspATH export PATH

下载 oracle 安装文件，解压缩后安装

下载 oracle

打开 oracle 下载页面，http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html,下载下面两个文件到 /home/oracle

rush:bash;"> linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip

解压缩文件并运行

rush:bash;"> unzip linux.x64_11gR2_database_1of2.zip unzip linux.x64_11gR2_database_2of2.zip cd database ./runInstaller

若为中文系统，安装界面会出现中文乱码，需要先将环境变为英文，在安装

rush:bash;"> export LANG=en_US ./runInstaller

没有截图,安装步骤大致包括以下几步:

  1. Create and configure a database
  2. Server Class
  3. Single instance database installation
  4. Advanced install
  5. Language: English
  6. Enterprise Edition
  7. database type: General Purpose / Transaction Processing
  8. Memory: Enable Automatic Memory Management
  9. Character sets: Use Unicode(AL32UTF8)

图性界面安装最后会提示以ROOT 执行下面两个脚本

rush:bash;"> [root@oracle ~]# /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /u01/app/oraInventory to oinstall. The execution of the script is complete. rush:bash;"> [root@oracle ~]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: copying dbhome to /usr/local/bin ... copying oraenv to /usr/local/bin ... copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. Finished product-specific root actions.

出现的问题

1,当环境变量中的 ORACLE_SID 与 安装时实际配置不一致时，会导致 startup 出错，出错信息如下：

rush:bash;"> ORA-01078: failure in processing system parameters LRM-00109: Could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initDB11G.ora'

2,如果远程客户端连接是报错：ora-12514 tns 监听程序当前无法识别连接描述符中请求的服务，则需要配置 listener.ora，添加如下节点：

rush:bash;"> SID_LIST_LISTENER = (SID_LIST= (SID_DESC = (SID_NAME = orcl) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) ) )

好了，到此已经安装完成，通过访问 web 管理界面可验证。下面步骤也很重要，请继续。

注意：以下命令使用 root 用户操作

配置防火墙规则，开放侦听端口

将 1521（你配置的 oracle 侦听端口） 端口添加到防火墙规则，以便远程用户能顺利的访问到 oracle 服务。

rush:bash;"> iptables -I INPUT 4 -m state --state NEW -p tcp --dport 1521 -j ACCEPT service iptables save service iptables reload

设置 oracle 自动启动

完成 oracle 安装后，我们可以通过命令启动停止数据库，但是当机器重启时并不能随机器启动，这也给我们带来了一些不便，下面记录了，如何将 oralce 加入服务中，并随机机器启动。

修改配置文件 /etc/oratab

修改 /etc/oratab 的最后一行的最后一个字符，将 N 修改为 Y。此举主要是为了使 oracle 的 dbstart 命令能在系统启动时能运行。如下所示：

rush:bash;"> [root@oracle ~]# vi /etc/oratab # # This file is used by ORACLE utilities. It is created by root.sh # and updated by the Database Configuration Assistant when creating # a database. # A colon,':',is used as the field terminator. A new line terminates # the entry. Lines beginning with a pound sign,'#',are comments. # # Entries are of the form: # $ORACLE_SID:$ORACLE_HOME:: # # The first and second fields are the system identifier and home # directory of the database respectively. The third filed indicates # to the dbstart utility that the database should,"Y",or should not,# "N",be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # # orcl:/u01/app/oracle/product/11.2.0/dbhome_1:Y

创建 /etc/init.d/oracle

在 /etc/init.d/下创建文件 oracle，此为 oracle 自启动脚本。内容如下：

rush:bash;"> #!/bin/sh # chkconfig: 345 61 61 # description: Oracle 11g R2 AutoRun Servimces # /etc/init.d/oracle # # Run-level Startup script for the Oracle Instance,Listener,and # Web Interface ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1" ORA_OWNR="oracle" # if the executables do not exist -- display error if [ ! -f "$ORACLE_HOME/bin/dbstart" ] then echo "Oracle startup: cannot start" exit 1 fi # parameter: start,stop,restart case "$1" in start) # Oracle listener and instance startup su $ORA_OWNR -s /bin/bash $ORACLE_HOME/bin/dbstart $ORACLE_HOME echo "Oracle Start Succesful!OK." ;; stop) # Oracle listener and instance shutdown su $ORA_OWNR -s /bin/bash $ORACLE_HOME/bin/dbshut $ORACLE_HOME echo "Oracle Stop Succesful!OK." ;; restart) $0 stop $0 start ;; *) echo $"Usage: `basename $0` {start|stop|restart}" exit 1 esac exit 0

赋予启动脚本执行权限并链接好：

rush:bash;"> # chmod 750 /etc/init.d/oracle # ln -s /etc/init.d/oracle /etc/rc1.d/K61oracle # ln -s /etc/init.d/oracle /etc/rc3.d/S61oracle

启动脚本设置好了之后，可以使用 service 命令来启动停止 oracle 了，这时候 oracle 已经是系统服务了。

rush:bash;"> service oracle start service oracle stop service oracle restart

设置 oracle 服务为自启动

rush:bash;"> # chkconfig --add oracle # chkconfig --level 345 oracle on

总结

好了，重启机器试试吧。以上就是这篇文章的全部内容了，希望本文的内容对大家学习或者工作能带来一定的帮助，如果有疑问大家可以留言交流。

IO错误：网络适配器无法与Oracle 11gR2建立连接与SQL开发人员联系

IO错误：网络适配器无法与Oracle 11gR2建立连接与SQL开发人员联系

我按照以下步骤尝试在“ http://technologylair.net/2013/08/oracle-11g-installation-
linux/#comment-50 ”中提到的所有步骤，在RedHat6 linux实例上安装了Oracle
11g。使用sql开发器从远程计算机访问数据库。但总是以-“ IO Error: The Network Adapter could not establish the connection”结尾。

我正在使用的参数是

Username: sys as sysdba 
Password: <oracle password> 
Hostname: IP address of the server on which Oracle SQL is installed. 
Port: 1521 
SID: testdb

我还在位置“
/oracle/product/11.2.0/db_1/network/admin”处创建了listener.ora文件，因为以前没有该文件。谁的内容是-

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/oracle/product/11.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_TESTDB))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 173.39.238.15)(PORT = 1521))
    )
  )

DEFAULT_SERVICE_LISTENER = (TESTDB)

我也在dba.stackexchange上发布了这个问题。但我需要尽快解决此问题。需要帮助 因此也将其发布在这里。

你能告诉我我可能做错了什么吗？

谢谢。

编辑 “ lsnrctl状态”的输出

连接到（DESCRIPTION =（ADDRESS =（PROTOCOL = IPC）（KEY =
EXTPROC_FOR_TESTDB）））TNS-12541：TNS：无侦听器TNS-12560：TNS：协议适配器错误
TNS-00511：无侦听器Linux错误：2：无此类文件或目录连接到（DESCRIPTION =（地址=（PROTOCOL = TCP）（HOST
= 173.39.238.15）（PORT = 1521）））TNS-12541：TNS：无侦听器TNS-12560：TNS：协议适配器错误
TNS-00511 ：没有侦听器Linux错误：111：连接被拒绝

java – 无法创建PoolableConnectionFactory(Io异常：网络适配器无法建立连接)

java – 无法创建PoolableConnectionFactory(Io异常：网络适配器无法建立连接)

嗨我有一个弹簧应用程序的上述例外,我试图连接到集群的Oracle数据库,但即使我尝试连接到单个实例仍然有相同的异常.

bean定义如下：

    lovER=ON)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=db)))" />

完整的堆栈跟踪是：

2012-02-13 13:18:45,084 1375 [main] INFO  org.hibernate.connection.ConnectionProviderFactory  - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
2012-02-13 13:18:45,207 1498 [main] WARN  org.hibernate.util.JDBCExceptionReporter  - sql Error: 0,sqlState: null
2012-02-13 13:18:45,207 1498 [main] ERROR org.hibernate.util.JDBCExceptionReporter  - Cannot create PoolableConnectionFactory (Io exception: The Network Adapter Could not establish the connection)
2012-02-13 13:18:45,209 1500 [main] WARN  org.hibernate.cfg.SettingsFactory  - Could not obtain connection Metadata
org.apache.commons.dbcp.sqlnestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter Could not establish the connection)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
    at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
    at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1216)
    at org.springframework.orm.hibernate3.LocalSessionfactorybean.newSessionFactory(LocalSessionfactorybean.java:860)
    at org.springframework.orm.hibernate3.LocalSessionfactorybean.buildSessionFactory(LocalSessionfactorybean.java:779)
    at org.springframework.orm.hibernate3.AbstractSessionfactorybean.afterPropertiesSet(AbstractSessionfactorybean.java:211)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.invokeInitMethods(AbstractAutowireCapablebeanfactory.java:1479)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.initializeBean(AbstractAutowireCapablebeanfactory.java:1417)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
    at org.springframework.beans.factory.support.Abstractbeanfactory$1.getobject(Abstractbeanfactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:292)
    at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:194)
    at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveReference(BeanDeFinitionValueResolver.java:322)
    at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveValueIfNecessary(BeanDeFinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.applyPropertyValues(AbstractAutowireCapablebeanfactory.java:1325)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.populateBean(AbstractAutowireCapablebeanfactory.java:1086)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
    at org.springframework.beans.factory.support.Abstractbeanfactory$1.getobject(Abstractbeanfactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:292)
    at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:194)
    at org.springframework.beans.factory.support.DefaultListablebeanfactory.findAutowireCandidates(DefaultListablebeanfactory.java:844)
    at org.springframework.beans.factory.support.DefaultListablebeanfactory.doResolveDependency(DefaultListablebeanfactory.java:786)
    at org.springframework.beans.factory.support.DefaultListablebeanfactory.resolveDependency(DefaultListablebeanfactory.java:703)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:547)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:84)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcesspropertyValues(AutowiredAnnotationBeanPostProcessor.java:282)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.populateBean(AbstractAutowireCapablebeanfactory.java:1074)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
    at org.springframework.beans.factory.support.Abstractbeanfactory$1.getobject(Abstractbeanfactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:292)
    at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:194)
    at org.springframework.beans.factory.support.DefaultListablebeanfactory.preInstantiateSingletons(DefaultListablebeanfactory.java:580)
    at org.springframework.context.support.AbstractApplicationContext.finishbeanfactoryInitialization(AbstractApplicationContext.java:900)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:455)
    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:442)
    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:458)
    at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:339)
    at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:306)
    at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:133)
    at javax.servlet.GenericServlet.init(GenericServlet.java:212)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
    at org.apache.catalina.core.StandardService.start(StandardService.java:519)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.sql.sqlException: Io exception: The Network Adapter Could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwsqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwsqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwsqlException(DatabaseError.java:255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.

将ip地址更改为DNS名称,我有一个不同的例外,堆栈跟踪如下：

2012-02-13 13:46:36,709 1685 [main] WARN  org.hibernate.util.JDBCExceptionReporter  - sql Error: 0,sqlState: null
2012-02-13 13:46:36,709 1685 [main] ERROR org.hibernate.util.JDBCExceptionReporter  - Error preloading the connection pool
2012-02-13 13:46:36,710 1686 [main] WARN  org.hibernate.cfg.SettingsFactory  - Could not obtain connection Metadata
org.apache.commons.dbcp.sqlnestedException: Error preloading the connection pool
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1398)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
    at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
    at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1216)
    at org.springframework.orm.hibernate3.LocalSessionfactorybean.newSessionFactory(LocalSessionfactorybean.java:860)
    at org.springframework.orm.hibernate3.LocalSessionfactorybean.buildSessionFactory(LocalSessionfactorybean.java:779)
    at org.springframework.orm.hibernate3.AbstractSessionfactorybean.afterPropertiesSet(AbstractSessionfactorybean.java:211)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.invokeInitMethods(AbstractAutowireCapablebeanfactory.java:1479)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.initializeBean(AbstractAutowireCapablebeanfactory.java:1417)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
    at org.springframework.beans.factory.support.Abstractbeanfactory$1.getobject(Abstractbeanfactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:292)
    at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:194)
    at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveReference(BeanDeFinitionValueResolver.java:322)
    at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveValueIfNecessary(BeanDeFinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.applyPropertyValues(AbstractAutowireCapablebeanfactory.java:1325)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.populateBean(AbstractAutowireCapablebeanfactory.java:1086)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
    at org.springframework.beans.factory.support.Abstractbeanfactory$1.getobject(Abstractbeanfactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:292)
    at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:194)
    at org.springframework.beans.factory.support.DefaultListablebeanfactory.findAutowireCandidates(DefaultListablebeanfactory.java:844)
    at org.springframework.beans.factory.support.DefaultListablebeanfactory.doResolveDependency(DefaultListablebeanfactory.java:786)
    at org.springframework.beans.factory.support.DefaultListablebeanfactory.resolveDependency(DefaultListablebeanfactory.java:703)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:547)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:84)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcesspropertyValues(AutowiredAnnotationBeanPostProcessor.java:282)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.populateBean(AbstractAutowireCapablebeanfactory.java:1074)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
    at org.springframework.beans.factory.support.Abstractbeanfactory$1.getobject(Abstractbeanfactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:292)
    at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:194)
    at org.springframework.beans.factory.support.DefaultListablebeanfactory.preInstantiateSingletons(DefaultListablebeanfactory.java:580)
    at org.springframework.context.support.AbstractApplicationContext.finishbeanfactoryInitialization(AbstractApplicationContext.java:900)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:455)
    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:442)
    at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:458)
    at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:339)
    at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:306)
    at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:133)
    at javax.servlet.GenericServlet.init(GenericServlet.java:212)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
    at org.apache.catalina.core.StandardService.start(StandardService.java:519)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.sql.sqlException: Io exception: The Network Adapter Could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwsqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwsqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwsqlException(DatabaseError.java:255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.dobject(GenericObjectPool.java:1059)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1395)
    ... 74 more
最佳答案
我不得不去寻找与oracle上的版本兼容的ojdbc,安装了这个解决了我的问题,我的不好意思是一个ojdbc适用于所有人

java实现的client，无法与服务器建立连接。

java实现的client，无法与服务器建立连接。

server是node js.
java客户端如下：

WebSocketContainer container =
ContainerProvider.getWebSocketContainer();
String uri ="ws://127.0.0.1:8080";
System.out.println("Connecting to"+ uri);
try
{     session = container.connectToServer(MyClient.class, URI.create(uri));
}
catch
(DeploymentException e)
{      e.printStackTrace();
}
catch
(IOException e)
{     e.printStackTrace();

}用这个方法创建连接被拒。下面是用这个client发送请求后获取的网络包， 创建连接失败了。。。 

这个是用java实现的client发送的额网络包， 服务器没有应答

如果用js，则可以成功

var target=''ws://localhost:7777'';

var socket = io.connect(target);

成功的请求包如下



我得问题是：

1. java是否可以跟nodejs server建立websocket连接？

2. 如果可以， 那么怎么建立？3. 如果不可以，是否可以通过java中执行js代码完成这个功能（其实我也试过了，在执行require的时候就报错了。。。） 

我们今天的关于IO错误：网络适配器无法与Oracle 11gR2建立连接。与SQL开发人员联系和网络适配器不支持连接数据库的分享就到这里，谢谢您的阅读，如果想了解更多关于centos 6.5下安装oracle 11gR2与Oracle自动启动的配置、IO错误：网络适配器无法与Oracle 11gR2建立连接与SQL开发人员联系、java – 无法创建PoolableConnectionFactory(Io异常：网络适配器无法建立连接)、java实现的client，无法与服务器建立连接。的相关信息，可以在本站进行搜索。

本文标签：

上一篇SQL SELECT * FROM XXX WHERE数组中的columnName（sql where in 数组）

下一篇SQL Server中具有IGNORE NULLS的Last_value（在sql中null表示）

相关文章