You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2021/08/10 14:59:31 UTC
[GitHub] [dolphinscheduler] juha1995 opened a new issue #5970: Oracle DataSource Connection Failed
juha1995 opened a new issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970
**For better global communication, Please describe it in English. If you feel the description in English is not clear, then you can append description in Chinese(just for Mandarin(CN)), thx! **
**Describe the question**
A clear and concise description of what the question is.
All configuration is done, according to the document of Official Site. But still can't connect to my Oracle data source, version of Oracle is _11.2.0.4.0_
I've tried use different versions of ojdbc-jar, ojdbc6-11.2.0.4.jar, ojdbc8-21.1.0.0.jar and ojdbc8-12.2.0.1.jar, but none of them worked.
**Which version of DolphinScheduler:**
latest
**Additional context**
**Requirement or improvement**
- Please describe about your requirements or improvement suggestions.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] juha1995 commented on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
juha1995 commented on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-980515158
> Have you checked that `ojdbc8-19.9.0.0.jar` exists in `/opt/dolphinscheduler/lib` and restart the containers?
yes, all things done, but still not work
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] chengshiwen commented on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
chengshiwen commented on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-899947163
Have you checked that `ojdbc8-19.9.0.0.jar` exists in `/opt/dolphinscheduler/lib` and restart the containers?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] chengshiwen commented on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
chengshiwen commented on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-979044064
Close since no updates for long time
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] chengshiwen closed issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
chengshiwen closed issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] chengshiwen edited a comment on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
chengshiwen edited a comment on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-898812622
@juha1995 There are two solutions:
1. Refer to the *How to support Oracle datasource in Datasource manage* in https://dolphinscheduler.apache.org/en-us/docs/1.3.6/user_doc/docker-deployment.html
2. Temporarily, if you just want to connect to a oracle datasource using `ojdbc8-19.9.0.0.jar`, not only you need to execute `docker cp ojdbc8-19.9.0.0.jar /opt/dolphinscheduler/lib` into `api`, `master` and `worker` container, you also need to restart all containers by `docker-compose restart`.
```
docker cp ojdbc8-19.9.0.0.jar docker-swarm_dolphinscheduler-api_1:/opt/dolphinscheduler/lib
docker cp ojdbc8-19.9.0.0.jar docker-swarm_dolphinscheduler-master_1:/opt/dolphinscheduler/lib
docker cp ojdbc8-19.9.0.0.jar docker-swarm_dolphinscheduler-worker_1r:/opt/dolphinscheduler/lib
docker-compose restart
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] chengshiwen commented on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
chengshiwen commented on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-898812622
@juha1995 You can refer to the solution of #4871, or refer to the *How to support Oracle datasource in Datasource manage* in https://dolphinscheduler.apache.org/en-us/docs/1.3.6/user_doc/docker-deployment.html
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] Tandoy commented on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
Tandoy commented on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-896477169
After you put the different OJDBC jars in the lib folder of the Dolphin installation directory, did you restart the dolphin api-server and worker-server? If not, you can try it.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] juha1995 commented on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
juha1995 commented on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-896560892
> After you put the different OJDBC jars in the lib folder of the Dolphin installation directory, did you restart the dolphin api-server and worker-server? If not, you can try it.
I've restart servers, I've also try to restart dockers, but still not work.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] juha1995 commented on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
juha1995 commented on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-899525131
> @juha1995 There are two solutions:
>
> 1. Refer to the _How to support Oracle datasource in Datasource manage_ in https://dolphinscheduler.apache.org/en-us/docs/1.3.6/user_doc/docker-deployment.html
> 2. Temporarily, if you just want to connect to a oracle datasource using `ojdbc8-19.9.0.0.jar`, not only you need to execute `docker cp ojdbc8-19.9.0.0.jar /opt/dolphinscheduler/lib` into `api`, `master` and `worker` container, you also need to restart all containers by `docker-compose restart`.
>
> ```
> docker cp ojdbc8-19.9.0.0.jar docker-swarm_dolphinscheduler-api_1:/opt/dolphinscheduler/lib
> docker cp ojdbc8-19.9.0.0.jar docker-swarm_dolphinscheduler-master_1:/opt/dolphinscheduler/lib
> docker cp ojdbc8-19.9.0.0.jar docker-swarm_dolphinscheduler-worker_1r:/opt/dolphinscheduler/lib
> docker-compose restart
> ```
I've already did that, and I did that just now, not work...
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] chengshiwen edited a comment on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
chengshiwen edited a comment on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-898812622
@juha1995 There are two solutions:
1. Refer to the *How to support Oracle datasource in Datasource manage* in https://dolphinscheduler.apache.org/en-us/docs/1.3.6/user_doc/docker-deployment.html
2. Temporarily, if you just want to connect to a oracle datasource using `ojdbc8-19.9.0.0.jar`, not only you need to execute `docker cp ojdbc8-19.9.0.0.jar /opt/dolphinscheduler/lib` into `api`, `master` and `worker` container, you also need to restart all containers by `docker-compose restart`.
```
docker cp ojdbc8-19.9.0.0.jar docker-swarm_dolphinscheduler-api_1:/opt/dolphinscheduler/lib
docker cp ojdbc8-19.9.0.0.jar docker-swarm_dolphinscheduler-master_1:/opt/dolphinscheduler/lib
docker cp ojdbc8-19.9.0.0.jar docker-swarm_dolphinscheduler-worker_1:/opt/dolphinscheduler/lib
docker-compose restart
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #5970: Oracle DataSource Connection Failed
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #5970:
URL: https://github.com/apache/dolphinscheduler/issues/5970#issuecomment-896103130
Hi:
* Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
* In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
* If you haven't received a reply for a long time, you can subscribe to the developer's email，Mail subscription steps reference https://dolphinscheduler.apache.org/zh-cn/community/development/subscribe.html ,Then write the issue URL in the email content and send question to dev@dolphinscheduler.apache.org.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org