JDBC连接oracle数据库配置正确但是连接报错Caused by: ORA-01017: invalid username/password

最新推荐文章于 2023-10-19 19:55:25 发布
原创 最新推荐文章于 2023-10-19 19:55:25 发布 · 1k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

在华为云部署应用服务时，使用外网IP配置数据库连接会导致ORA-01017错误，因内部网络无法直接访问外网。解决方法是更改数据库链接为内网IP。

JDBC连接oracle数据库配置正确但是连接报错Caused by: ORA-01017: invalid username/password; logon denied

问题描述：在华为云上部署应用服务，启动服务后，调用接口时报ORA-01017: invalid username/password错误（在本地启动服务调用接口一切正常）；

解决方案:

由于华为云的IP分为外网IP和内网IP，在应用服务配制数据库链接时我们配制成了外网IP，所以在本地启动服力调用接口一切正常，但部署到华为云后，在华为云内网中无法直接访问外网IP，故导致数据库连接出错，将数据库链接信息改为内网IP即可。

SkidRow_xp
关注
三、 oracle 数据库适配记录
空空说技术的博客
04-23 729
Oracle数据库名(DB_NAME)、实例名(INSTANCE_NAME)、服务名(SERVICE_NAME) 概念数据库名(DB_NAME)它代表的是数据库，也就是数据库包含的所有的物理文件的总称。实例名(INSTANCE_NAME)用于响应某个数据库操作的数据库管理系统的名称。实例名是由初始化参数文件的参数instance_name决定的。如果这个参数不被指定，那么实例的名字由该用户的环境变量ORACLE_SID决定。
JDBC连接oracle数据库配置正确但是连接报错Caused by: ORA-01017: invalid username/password; logon denied
天涯的浪子
02-28 4756
1.程序数据库配置如下 ##oracle database settings jdbc.type=oracle jdbc.driver=oracle.jdbc.driver.OracleDriver jdbc.url=jdbc:oracle:thin:@192.168.1.20:1521:orcl2 jdbc.username=satp password = satp 程序启动报错 20...
ORA-01017: invalid username/password; logon denied
热门推荐
喜欢原味奶茶的博客
05-26 1万+
Idea启动项目老是报这个错。网上很多解决方案，但是都解决不了我的这个问题， 先说说场景，只有场景相似或者相同才合适。 1、新建数据库用户，pl/sql能够登录用户 2、idea项目启动报错 invalid username/password; logon denied 3、检查jdbc配置文件，账号密码，url都是对的。 两种情况: 1、第一种情况：数据库是12c的，看看是否导入了ojdbc8的...
oracle连接中出现错误ORA-12541,ORA-12514,ORA-01017的解决方法
weixin_34199405的博客
07-05 812
1.出现如下错误：ORA-12541:TNS:no listener，如下图所示：   错误原因是我们没有开启Listener监听器服务，解决方法是在服务中开启这个服务，如下图所示。 2.出现如下错误：ORA-12514：TNS：监听程序当前无法识别链接描述符中请求的服务。如下图所示： 解决方法是需要打开服务OracleServiceORCL，如下图所示： 3.出现错误：OR...
jdbc链接oracle 11g时, 会报ora-01017的错误的解决方法
大道废
02-15 9510
在oracle的之前版本时, 你的用户名密码是大小写不敏感的, 但在11g中, 数据库默认密码的大小写是敏感的, 于是我们就知道了一个事实, 那就是jdbc在给oracle密码时, 会将其变成大写,真是一个奇怪的事情啊.你可能会说: 那好, 那我就把密码设置为大写的好了, 哈哈哈哈, 你完了, 要知道有些程序, 在链接oracle时, 会将密码变为小写, 这是不是很奇怪, 很晕菜呢?在oracle
oracle连接失败invalid username,JDBC连接失败，报 invalid username/password
weixin_39876145的博客
04-03 620
通过如下SQL创建一个用户/*创建用户并指定表空间 */create user FND_DATA identified by FND default tablespace FND_DATA;/*给用户授予权限 */grant connect,resource to FND_DATA;PL/SQL可以正常登录，但是使用JDBC进行连接就会报错：invalid username/passwordCla...
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
11-18
以下是一个Java连接Oracle数据库的示例代码： ```java import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class OracleJDBC { public static void main(String...
oracle+ora-各种常见java.sq
06-21
- `java.sql.SQLException: ORA-01017: invalid username/password; logon denied`: 输入的用户名或密码不正确。检查数据库凭证的准确性。 3. **网络问题** - `java.sql.SQLException: ORA-01034: ORACLE not ...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "A"."TMP_BATCH_NUMBER": invalid identifier 什么错误
最新发布
10-10
`Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "A"."TMP_BATCH_NUMBER": invalid identifier` 错误表明在执行 SQL 语句时，Oracle 数据库无法识别 `"A"."TMP_BATCH_NUMBER"` 这个标识符。这里的 `"A"` ...
现在这个报错是什么意思呢 2025-09-24 13:39:52,540 ERROR Application run failed org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:165) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:585) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:147) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:732) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:409) at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1300) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1289) at com.alibaba.nacos.Nacos.main(Nacos.java:48) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:142) at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:104) at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:481) at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:211) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:184) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:162) ... 16 common frames omitted Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'basicAuthenticationFilter' defined in class path resource [com/alibaba/nacos/prometheus/filter/PrometheusAuthFilter.class]: Unsatisfied dependency expressed through method 'basicAuthenticationFilter' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosAuthConfig' defined in URL [jar:file:/home/plm/nacos/target/nacos-server.jar!/BOOT-INF/lib/default-auth-plugin-2.4.0.jar!/com/alibaba/nacos/plugin/auth/impl/NacosAuthConfig.class]: Unsatisfied dependency expressed through constructor parameter 3; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosUserDetailsServiceImpl': Unsatisfied dependency expressed through field 'userPersistService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:794) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:532) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:214) at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:213) at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:204) at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addServletContextInitializerBeans(ServletContextInitializerBeans.java:98) at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:86) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:262) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:236) at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:53) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4904) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:794) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:248) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:433) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:921) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.startup.Tomcat.start(Tomcat.java:489) at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:123) ... 21 common frames omitted Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosAuthConfig' defined in URL [jar:file:/home/plm/nacos/target/nacos-server.jar!/BOOT-INF/lib/default-auth-plugin-2.4.0.jar!/com/alibaba/nacos/plugin/auth/impl/NacosAuthConfig.class]: Unsatisfied dependency expressed through constructor parameter 3; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosUserDetailsServiceImpl': Unsatisfied dependency expressed through field 'userPersistService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:794) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:220) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1372) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1222) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:401) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:781) ... 61 common frames omitted Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nacosUserDetailsServiceImpl': Unsatisfied dependency expressed through field 'userPersistService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:713) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:693) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:408) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:781) ... 84 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalUserPersistServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:710) ... 99 common frames omitted Caused by: java.lang.RuntimeException: java.lang.RuntimeException: [db-load-error]load jdbc.properties error at com.alibaba.nacos.persistence.datasource.DynamicDataSource.getDataSource(DynamicDataSource.java:60) at com.alibaba.nacos.plugin.auth.impl.persistence.ExternalUserPersistServiceImpl.init(ExternalUserPersistServiceImpl.java:55) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) ... 111 common frames omitted Caused by: java.lang.RuntimeException: [db-load-error]load jdbc.properties error at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.init(ExternalDataSourceServiceImpl.java:119) at com.alibaba.nacos.persistence.datasource.DynamicDataSource.getDataSource(DynamicDataSource.java:55) ... 119 common frames omitted Caused by: java.io.IOException: java.lang.RuntimeException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.reload(ExternalDataSourceServiceImpl.java:168) at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.init(ExternalDataSourceServiceImpl.java:116) ... 120 common frames omitted Caused by: java.lang.RuntimeException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied at com.alibaba.nacos.persistence.utils.ConnectionCheckUtil.checkDataSourceConnection(ConnectionCheckUtil.java:42) at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.lambda$reload$0(ExternalDataSourceServiceImpl.java:138) at com.alibaba.nacos.persistence.datasource.ExternalDataSourceProperties.build(ExternalDataSourceProperties.java:97) at com.alibaba.nacos.persistence.datasource.ExternalDataSourceServiceImpl.reload(ExternalDataSourceServiceImpl.java:136) ... 121 common frames omitted Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:702) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:603) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:598) at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1710) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:819) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1041) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:443) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:462) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTHWithO5Logon(T4CTTIoauthenticate.java:1628) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1375) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1322) at oracle.jdbc.driver.T4CConnection.authenticateWithPassword(T4CConnection.java:1500) at oracle.jdbc.driver.T4CConnection.authenticateUserForLogon(T4CConnection.java:1443) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:812) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1101) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:104) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:837) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:664) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) at com.alibaba.nacos.persistence.utils.ConnectionCheckUtil.checkDataSourceConnection(ConnectionCheckUtil.java:40) ... 124 common frames omitted
09-25
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied ``` 关键信息：**数据库用户名或密码不正确**，导致Nacos无法连接Oracle数据库。 ### 解决方案 #### 1. 检查数据库...
oracle用户无密码jdbc,Oracle JDBC：无效的用户名/密码（ora-01017）
weixin_28931735的博客
04-03 635
我与Oracle数据库服务器的jdbc连接有一个奇怪的问题。我们已经在tomcat服务器上运行了应用程序。这些应用程序使用一个oracle数据库。所有应用程序都使用相同的凭据。应用程序整天运行良好。晚上没有活动。早晨，当应用程序尝试将自身重新连接到数据库时，我们会收到一些(2或3)ORA-01017(无效的用户名/密码)错误。然后重新连接工作，应用程序将正常运行。这可以工作几天(大约5天)，然后可...
oracle用户无密码jdbc,JDBC连接ORACLE无法登陆java.sql.SQLException: ORA-01017: invalid username/password; logon d...
weixin_34303763的博客
04-03 653
当用jdbc连接Oracle数据库的时候private Connection getConnection() throws SQLException{OracleDataSource ods = new OracleDataSource();ods.setUser("biaoJM");ods.setPassword("123456");ods.setURL("jdbc:oracle:thin:@l...
Oracle 登录时错误: ORA-01017: invalid username/password; logon denied
weixin_34314962的博客
01-16 1050
2019独角兽企业重金招聘Python工程师标准>>> ...
JDBC连接Oracle数据库问题
tan605963296的专栏
09-19 1171
<br />   今天早上解决了一个jdbc连接oracle数据库问题，看到网上的人都对这个问题都觉得无从下手，这里我就说一下我是怎么解决的，给大家参考参考。希望能帮到大家；<br /> <br />       昨天，在做servlet连接oracle数据库的时候，在tomcat上调试搞得真郁闷，老是出现：<br />java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection<br />at or
oracle11g数据库登录01017,数据库 – 提供正确的用户名和密码,获取ORA-01017：无效的用户名/密码;登录被拒绝...
weixin_28923455的博客
04-03 702
我在tomcat的server.xml中配置了oracle数据库driverClassName="oracle.jdbc.OracleDriver"url="jdbc:oracle:thin:@databaseurl:1521:schema"username="username" password="password" maxActive="20" maxIdle="10"maxWait="-1"...
数据库工具连接数据库正常，但是JDBC连接数据库出现了一直提示用户名/密码错误
之哥博客
02-09 4139
记录一次坑，花了大半天的时间排查。。。。。。 线上数据库迁移，迁移完成后启动程序一直报数据库用户名密码错误，各种尝试都是报这个问题。 一番尝试，各种修改密码，重启服务都不行，最后查询资料后发现问题！！！！ 原因分析： 1.由于某种原因JDBC传入的密码确实和数据库保存的不一致，比如手动输入，编码格式等。 2.老版本连接12c以上的库，由于添加了sqlnet.ora的兼容性，所以密码需重置才可连接。 解决方式： 1.使用比对器比对密码找到争取密码，或者服务器重新设置密...
分析解决JDBC连接ORACLE12c报错ORA-01017或Oracle ORA-28040问题，亲测有效
weixin_46909071的博客
10-19 2449
2、如果ORACLE版本为12以上时，SQLNET.ALLOWED_LOGON_VERSION_SERVER默认为12或者12C这时的密码认证协议默认为独家模式（Exclusive Mode），在这种情况下生成的PASSWORD_VERSIONS字段为11G, 12C，可以通过查看表DBA_USERS中的PASSWORD_VERSIONS字段进行查看。登录被拒绝报错问题。1. 修改数据库端sqlnet.ora配置文件（解决客户端与服务器端版本不兼容报错Oracle ORA-28040问题）
oracle用户无密码jdbc,JDBC无法通过连接池打印本地oracle数据，在用户名密码正确的情况下仍然报ora-01017...
weixin_29251337的博客
04-03 512
JDBC无法通过连接池打印本地oracle数据，在用户名密码正确的情况下仍然报ora-01017开发环境是jdk 1.7，oracle 11g，使用原生jdbc连接本地数据库，不使用连接池能打印数据，但是使用连接池，在用户名密码绝对正确的情况下仍然报ora-01017贴上使用连接池连接oracle的代码，包括三个文件，ConnectionSource.java,EmpDAO.java,db.pro...
oracle连接失败invalid username,本人是oracle菜鸟，用jsp连接时出现ORA-01017: invalid username/password; logon denied异常...
weixin_35381903的博客
04-03 505
当前位置:我的异常网» Oracle管理»本人是oracle菜鸟，用jsp连接时出现ORA-01017: inva本人是oracle菜鸟，用jsp连接时出现ORA-01017: invalid username/password; logon denied异常www.myexceptions.net网友分享于：2013-09-28浏览：379次本人是oracle初学者，用jsp连接时出...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值