In this post of Tech Team Tips Series, I am going to show how to migrate existing ADF web application deployed on-premise WebLogic 12c to Oracle Java Cloud Service.
I will use an existing WebLogic 12c ADF sample web application for migration. Before deploying the application, it is essential to configure these important steps:
Create Schema in Database Cloud (DbaaS)
Configure Data source in JCS
I encountered few slips while configuring these pre-requisites at first time. The following is what I encountered and how you can avoid and/or troubleshoot these slips:
1. Schema Creation through SQL Developer:
a. The “ORA–65096” error:
SQL Error: ORA–65096: invalid common user or role name
The Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters.
b. The “ORA–6048” error:
SQL Error: ORA–65048: error encountered when processing the current DDL statement in pluggable database PDB1 ORA–01955: DEFAULT ROLE ‘CONNECT’ not granted to user 65048.00000 - “error encountered when processing the current DDL statement in pluggable database %s”
The Cause: An error was encountered when executing a statement in one of the pluggable databases.
2. JNDI Creation Error from JCS WebLogic console.
a. Connection test failed. Error ORA–01045.
Error ORA–01045: User C##TEST lacks CREATE SESSION privilege; logon denied oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)
b. Connection test failed. Error ORA–01017:
Error ORA–01017: invalid username/password; logon denied oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)
Don’t worry about these errors, just follow the steps below to configure your cloud environment properly for smooth running.