Sofbang Tech Team Tips Series: Configuring Database Cloud (DbaaS) with Java Cloud for Application Deployment

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.

Continue reading…