when I want to change wso2'DB to Oracle I got this error . what shall I do? here is my tables and my settings please help me. Thank you so much

CodePudding user response：

Did you follow the steps in [1] to setup Oracle as the database with APIM 3.2.0?

If you need to have the WSO2CARBON_DB also in Oracle, you need to create a separate database and execute the sql script in <API-M_HOME>/dbscripts/oracle.sql and then change the [database.local] configuration in deployment.toml according as mentioned in the Info section at the bottom of the above documentation

[1] - https://apim.docs.wso2.com/en/3.2.0/install-and-setup/setup/setting-up-databases/changing-default-databases/changing-to-oracle/#executing-db-scripts-to-create-tables-on-oracle-database

CodePudding user response：

The error is thrown when you dont configure the shared db properly. Run the oracle scripts under APIM_HOME/dbcripts/oracle.sql into a separate user schema and point it as follows.

[database.shared_db]
type = "oracle"
url = "jdbc:oracle:thin:@localhost:1521/orcl1"
username = "sharedadmin"
password = "sharedadmin"
driver = "oracle.jdbc.driver.OracleDriver"
validationQuery = "SELECT 1 FROM DUAL"

then run the script under APIM-HOME/dbscripts/apimgt/oracle.sql and point it as follows.

[database.apim_db]
type = "oracle"
url = "jdbc:oracle:thin:@localhost:1521/orcl2"
username = "apimadmin"
password = "apimadmin"
driver = "oracle.jdbc.driver.OracleDriver"
validationQuery = "SELECT 1 FROM DUAL"

It is not mandatory to configure local db to oracle if you do not have a special need. You can remove the [database.local] config to keep it in h2 itself.