we have tried to configure wso2 apimanager api details into oracle db .For that we have done below configuretion on deploument .toml file
[database.apim_db]
type = "oracle"
url= "jdbc:oracle:thin:@localhost:1521/orcljegan"
username="C##wso2_local"
password="finexta123"
driver = "oracle.jdbc.driver.OracleDriver"
validationQuery = "SELECT 1 FROM DUAL"
[database.shared_db]
type = "oracle"
url= "jdbc:oracle:thin:@localhost:1521/orcljegan"
username="C##wso2_local"
password="finexta123"
driver = "oracle.jdbc.driver.OracleDriver"
validationQuery = "SELECT 1 FROM DUAL"
and i have executed all the oracle base dbscripts given by wso2 product which is present in below loaction “wso2am-4.2.0dbscripts”
After restart Api manager is running successfully but from the developer portal we have tried to create Api in wso2 api manager .we have faced the view doesn’t exit issue in the console and api also not created. its failing to create api.
enter image description here
need to configure oracle db and store the api values into oracle database. how to achieve that please help me