Hi,
I am trying to access a) SQL Developer Web and b) Just the enabled schema on my web browser. O
ORDS is installed onto my PDB, I can reach the landing page for ORDS. I just can’t seem to go any further.
Schema alias is green_admin, I get these errors when browsing to http://16.0.4.6:8080/ords/green_admin/
(Ignore potential typos, I hand wrote this from the logs as i can't copy and paste)
SEVERE <requestID> GET 16.0.4.6 /ords/green_admin/ 571 The database user for the connection pool named |default|lo|, is not able to proxy to schema named GREEN_ADMIN. This could be a configured restriction on the maximum number of database sessions or an authorisation failure.
DatabaseConnectionException [statusCode=571, logLevel=SEVERE, reasons=[The database user for the connection pool named |default|lo|, is not able to proxy to schema named GREEN_ADMIN. This could be a configured restriction on the maximum number of database sessions or an authorisation failure.]]
Caused by: oracle.dbtools.url.mapping.TargetNotAvailableException: The database user for the connection pool named |default|lo|, is not able to proxy to schema named GREEN_ADMIN. This could be a configured restriction on the maximum number of database sessions or an authorisation failure.
Caused by: oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: The database user for the connection pool named |default|lo|, is not able to proxy to schema named GREEN_ADMIN. This could be a configured restriction on the maximum number of database sessions or an authorisation failure.
Caused by: oracle.dbtools.common.ucp.ConnectionLabellingException: Error occurred when attempting to configure url: jdbc: oracle:thin:@//16.0.4.6:1521/F35PDB.ALIS with labels: {oracle.dbtools.jdbc.label.cleanup=RECYCLE, oracle.dbtools.jdbc.label.schema=GREEN_ADMIN}
Caused by: java.sql.SQLException: ORA-01017
Is there anything I need to enable I may have missed? Any permissions or proxies that need granting? I have this working just fine on a different PC but just can’t get it to work on this one.