Hi All,
We use Splunk DB Connect 3.10.0 for Oracle connections. Weirdly one Connection stopped working (after a password reset ) It is giving an error "
ORA-28000: The account is locked. "
We have tried to remove the connection/identity and create one from scratch but to no avail. The Database guys are saying that the account associated with the identity is just fine and they are not getting any bad hits as well. that account worked fine when I tried it via SQL explorer on my laptop Below is log from splunk_app_db_connect_serverlog--
[dw-37 - POST /api/connections/status] ERROR c.s.d.s.a.s.d.impl.DatabaseMetadataServiceImpl - action=error_in_validating_connection connection=ConnectionConf{connectionType='oracle', defaultDatabase='xxxxxx', host='yyyyyyyyy', jdbcUrlFormat='jdbc:oracle:thin:@//<host>:<port>/<database>', jdbcUrlSSLFormat='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<host>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<database>)))', jdbcUseSSL=false, port=1521, serviceClass='com.splunk.dbx2.OracleJDBC', jdbcDriverClass='oracle.jdbc.OracleDriver', testQuery='null', isolationLevel='null', readonly=true, identityName='XYZ_PROD', identity=DotConfBase{title='XYZ_PROD', disabled=false}, useConnectionPool=false, fetchSize=100, maxConnLifetimeMillis=1800000, maxWaitMillis=30000, minIdle=null, maxTotalConn=8, idleTimeout=null, timezone=null, connectionProperties='{}'} java.sql.SQLException: ORA-28000: The account is locked.
Any help would be appreciated.
Thanks,
Neerav
... View more