Hello,
we have created three instances one computing instance where we hosted our application and two database instances which are configured in a dataguard.
We can access our application by using the public ip of the compute node and we can get the login interface of our application. But the problem is once the user puts in the username and password it won't allow the user to log in. When we checked the application log we got the following error.
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Io exception: Oracle Error ORA-12650
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
... 61 more
Caused by: java.sql.SQLException: Io exception: Oracle Error ORA-12650
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:190)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:173)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:164)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
... 62 more
error has occured Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [17002]; Io exception: Oracle Error ORA-12650; nested exception is java.sql.SQLException: Io exception: Oracle Error ORA-12650 caused by java.sql.SQLException: Io exception: Oracle Error ORA-12650
-- The user name is (User Authentication Controller) = cso
Sep 07, 2016 4:05:12 AM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 17002, SQLState: null
Sep 07, 2016 4:05:12 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Io exception: Oracle Error ORA-12650
Sep 07, 2016 4:05:12 AM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 17002, SQLState: null
Sep 07, 2016 4:05:12 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Io exception: Oracle Error ORA-12650
error has occured Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [17002]; Io exception: Oracle Error ORA-12650; nested exception is java.sql.SQLException: Io exception: Oracle Error ORA-12650 caused by java.sql.SQLException: Io exception: Oracle Error ORA-12650
Sep 07, 2016 4:31:07 AM org.springframework.web.context.request.FacesRequestAttributes registerDestructionCallback
We have enabled all the access rules on the database compute instance so that the application can connect to the database but as you can see from the above we are not able to. So your help is greatly appreciated
Warmest Regards
Rediet