Hello to all!
We have:
AVDF:
Oracle Audit Vault and Database Firewall 12.2.0.3.0
Target host:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
After successful deploying of agent.jar, registering Secured target, we added new Audit trail.
That Audit trail fail to start with error logged in av/log folder on remote server (target server):
[2016-11-15T15:50:37.319+01:00] [collfwk] [ERROR] [] [] [tid: 35] [ecid: 1909602938:37141:1479221437315:0,0] OAV-8012: Error creating AuditEventCollector instanceCollectionController : run : AuditException from process(). [[
Error creating AuditEventCollector instance
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.initialize(CollectionController.java:434)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.process(CollectionController.java:537)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.run(CollectionController.java:487)
at java.lang.Thread.run(Thread.java:745)
Caused by: Failed to connect to DB
at oracle.av.plugin.orcldb.agent.collector12c.Coll12cAuditDataSource.getVersion(Coll12cAuditDataSource.java:227)
at oracle.av.plugin.orcldb.agent.collector12c.Coll12cAuditCollectionFactory.createAuditCollection(Coll12cAuditCollectionFactory.java:85)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.initialize(CollectionController.java:403)
... 3 more
Caused by: Failed to connect to DB
at oracle.av.platform.common.dao.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:589)
at oracle.av.plugin.orcldb.agent.collector12c.Coll12cAuditDataSource.getVersion(Coll12cAuditDataSource.java:217)
... 5 more
Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Oracle Error ORA-12660
at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:479)
at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:154)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1127)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1031)
at oracle.av.platform.common.dao.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:555)
... 6 more
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Oracle Error ORA-12660
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:359)
at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:58)
at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:102)
at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:82)
at oracle.ucp.common.Database.createPooledConnection(Database.java:268)
at oracle.ucp.common.Cluster.create(Cluster.java:234)
at oracle.ucp.common.Core.growBorrowed(Core.java:634)
at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:230)
at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionAndValidate(UniversalConnectionPoolImpl.java:145)
at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:120)
at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:170)
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.borrowConnection(OracleJDBCConnectionPool.java:849)
at oracle.ucp.jdbc.oracle.OracleConnectionConnectionPool.borrowConnection(OracleConnectionConnectionPool.java:82)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1103)
... 8 more
Caused by: java.sql.SQLException: Oracle Error ORA-12660
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:317)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:241)
at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:96)
... 19 more
Caused by: oracle.net.ns.NetException: Oracle Error ORA-12660
at oracle.net.ano.Ano.negotiation(Unknown Source)
We have doublecheck user/password on target database and user privileges (oracle_user_setup.sql).
What we suspect is that problem lies in some of sqlnet.ora parameter.
Currently, we have default sqlnet.ora on AVDF:
# AVDF autogenerated file - do not modify.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /var/lib/oracle/dbfw/network/admin/avwallet)))
ENCRYPTION_WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /usr/local/dbfw/etc/wallets/dbfwdb_wallet)))
SQLNET.AUTHENTICATION_SERVICES = (BEQ, TCP, TCPS, NONE)
SQLNET.EXPIRE_TIME = 10
SQLNET.ENCRYPTION_TYPES_SERVER = (AES256,AES192,AES128)
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 11
SSL_CLIENT_AUTHENTICATION = TRUE
SSL_VERSION = 1.2 or 1.1 or 1.0
SSL_CIPHER_SUITES=(SSL_RSA_WITH_AES_128_CBC_SHA,SSL_RSA_WITH_AES_256_CBC_SHA)
Can you please advise?
Thanks in advance