[리눅스 서버]에서 오라클db서버로 직접 연결(통신)상태 확인하려면 어떻게 하나요?

Question

안녕하세요

홈페이지를 실서버로 이관하는데 db서버랑 통신이 안되는것 같은데 어떤 부분이 문제인지 잘 모르겠는데요

여기 서버 상황이 웹서버에서 db서버로 붙을때는 별도의 가상 ip로만 붙을수가 있습니다. 오라클 포트도 기본이 아니라 1541포트인데요

지금 문제가 db연결 문제인데 홈페이지 소스상 문제인지 서버 자체적으로 db서버로 통신이 안되는지를 확인하고 싶습니다.

1. 웹서버에 직접 붙은 상태에서 db서버 아이피로의 통신이 되는지 확인하는 방법

2. db서버에서 웹서버의 연결은 포트도 다 열려있고 아이피도 다 허용된 상태여서 문제가 없다고 하는데요

혹시 웹서버에서 db서버로 나갈때(1541포트)도 무슨 설정을 해줘야되는게 있나요?(서버 담당자 말로는 그런건 딱히 없고 받는 db서버쪽에서만 허용하면 된다고합니다).

아시는분 계시면 좀 알려주세요..

--------------혹시해서 에러 로그를 남깁니다------------------

log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
[2016- [ERROR] BaseExecutor:51 - Could not get a databaseId from dataSource
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (IO 예외 상황: The Network Adapter could not establish the connection)
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[commons-dbcp-1.4.jar:1.4]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_65]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_65]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_65]
	at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_65]
	at net.bull.javamelody.JdbcWrapper$3.invoke(JdbcWrapper.java:795) ~[javamelody-core-1.57.0.jar:1.57.0]
	at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:286) ~[javamelody-core-1.57.0.jar:1.57.0]
	at com.sun.proxy.$Proxy31.getConnection(Unknown Source) ~[?:?]
	at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:76) ~[mybatis-3.2.2.jar:3.2.2]
	at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:61) ~[mybatis-3.2.2.jar:3.2.2]
	at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:49) [mybatis-3.2.2.jar:3.2.2]
	at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:445) [mybatis-spring-1.2.0.jar:1.2.0]
	at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:336) [mybatis-spring-1.2.0.jar:1.2.0]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1613) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1550) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1457) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1198) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getTypeForFactoryBean(AbstractBeanFactory.java:1418) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getTypeForFactoryBean(AbstractAutowireCapableBeanFactory.java:788) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.isTypeMatch(AbstractBeanFactory.java:541) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doGetBeanNamesForType(DefaultListableBeanFactory.java:387) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:362) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.BeanFactoryUtils.beanNamesForTypeIncludingAncestors(BeanFactoryUtils.java:187) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1006) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:964) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:862) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:494) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:298) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1186) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:706) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:762) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4727) [catalina.jar:8.5.8]
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5189) [catalina.jar:8.5.8]
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:8.5.8]
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1404) [catalina.jar:8.5.8]
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1394) [catalina.jar:8.5.8]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_65]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_65]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_65]
	at java.lang.Thread.run(Thread.java:745) [?:1.8.0_65]
Caused by: java.sql.SQLException: IO 예외 상황: The Network Adapter could not establish the connection
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) ~[ojdbc14.jar:Oracle JDBC Driver version - "10.2.0.5.0"]
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) ~[ojdbc14.jar:Oracle JDBC Driver version - "10.2.0.5.0"]
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257) ~[ojdbc14.jar:Oracle JDBC Driver version - "10.2.0.5.0"]
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389) ~[ojdbc14.jar:Oracle JDBC Driver version - "10.2.0.5.0"]
	at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:454) ~[ojdbc14.jar:Oracle JDBC Driver version - "10.2.0.5.0"]
	at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165) ~[ojdbc14.jar:Oracle JDBC Driver version - "10.2.0.5.0"]
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) ~[ojdbc14.jar:Oracle JDBC Driver version - "10.2.0.5.0"]
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802) ~[ojdbc14.jar:Oracle JDBC Driver version - "10.2.0.5.0"]
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[commons-dbcp-1.4.jar:1.4]
	... 65 more

우띠 · Accepted Answer

ping을 제한한 경우는 연결이 되지 않습니다. 그래서 보통 telent을 바로 사용합니다.

telnet 사용시 커서가 깜빡이게 되면 연결이 성공된 경우고,

실패시 에러메시지가 표출됩니다.

내부접속만 되는경우 같으니 참고 사이트입니다.

http://kudolove.tistory.com/1280

우띠 · Answer

1. 웹서버에 직접 붙은 상태에서 db서버 아이피로의 통신이 되는지 확인하는 방법

- ping IP주소 (접속 가능한 IP 확인)

2. db서버에서 웹서버의 연결은 포트도 다 열려있고 아이피도 다 허용된 상태여서 문제가 없다고 하는데요

혹시 웹서버에서 db서버로 나갈때(1541포트)도 무슨 설정을 해줘야되는게 있나요?(서버 담당자 말로는 그런건 딱히 없고 받는 db서버쪽에서만 허용하면 된다고합니다).

- telnet IP주소 포트번호 (해당포트로 연결확인)

추가로 위 사항이 된다면 DB 접속 계정과 DB연결, 외부접속 권한 부분 확인하세요~

위드 · Answer

#우띠

ping을 날려봤는데 ping이 정상적으로 안날아가서(핑을 보내고 멈추는것같습니다) 검색을 해봤는데요

ping은 설정을 안해놓으면 그럴수도있다고해서 ping이 안간다고 무조건 연결설정이 안됐다고 볼수가 없다고하더라고요...

그러면

telnet IP주소 1541

이걸 웹서버에서 햇을때 어떤식으로 응답이 오면 정상 연결상태인건가요?

위드 · Answer

#우띠

혹시 db계정에 grant로 설정하는 권한값에도 문제가 될수 있나요?

위드 · Answer

#우띠

답변 감사합니다. 이따가 서버쪽에 붙어서 우선 telnet부터 해봐야겠네요...

바카디F · Answer

오라클 서비스 접근 여부는 주로

tnsping 으로 체크합니다. 오라클 클라이언트 설치시 이용가능합니다.

위드 · Answer

#바카디F

음 tnsping 사용법을 검색해보고 있는데요

이거는 오라클DB서버에서

root계정에서 su oracle 로 변경한 뒤에

tnsping 웹서버IP

라고 하면 되는건가요?

바카디F · Answer

반대입니다.

웹서버에서 DB로 접근 가능한지 알아보는것입니다.

물론 DB서버 자체에서도 서비스 확인율 위해 쓸 수도 있습니다 .

어디까지나 오라클 서비스를 확인하는것입니다.

위드 · Answer

아,,그러면 tnsping는 웹서버에 오라클이 설치되어있다는 조건하에 쓸 수 있는건가보네요.. 감사합니다

[리눅스 서버]에서 오라클db서버로 직접 연결(통신)상태 확인하려면 어떻게 하나요?

9개의 답변

Q&A 목록