In this post i will explain how you can setup WSO2 API Manager analytucs with oracle 11g using docker container. First you need to install docker on your machine. You can use same commands for any server to configure with oracle.
First run following command.
Now Lets log into oracle and create
Now we have successfully connected to created database. Now lets add master-datasource config to api manager instance and analytics instance as follows. When analytics node run it will create required tables automatically. If you have schema you can create tables by yourself as well.
Data source
First run following command.
docker run -d -p 49160:22 -p 49161:1521 -e ORACLE_ALLOW_REMOTE=true wnameless/oracle-xe-11g
docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
5399cedca43c wnameless/oracle-xe-11g "/bin/sh -c '/usr/sbi" 2 minutes ago Up 2 minutes 8080/tcp, 0.0.0.0:49160->22/tcp, 0.0.0.0:49161->1521/tcp grave_hugle
Now Lets log into oracle and create
>>ssh root@localhost -p 49160
>>admin as password.
su oracle
sqlplus / as sysdba
SQL> create user testamdb identified by testamdb account unlock;
SQL> grant create session, dba to testamdb;
SQL> commit;
SQL> connect testamdb;
Now we have successfully connected to created database. Now lets add master-datasource config to api manager instance and analytics instance as follows. When analytics node run it will create required tables automatically. If you have schema you can create tables by yourself as well.
Data source
<datasource><name>WSO2AM_STATS_DB</name><description>The datasource used for setting statistics to API Manager</description><jndiConfig><name>jdbc/WSO2AM_STATS_DB</name></jndiConfig><definition type="RDBMS"><configuration><url>jdbc:oracle:thin:@127.0.0.1:49161/xe</url><username>testamdb</username><password>testamdb</password> <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName><maxActive>50</maxActive><maxWait>60000</maxWait><testOnBorrow>true</testOnBorrow><validationQuery>SELECT 1</validationQuery><validationInterval>30000</validationInterval><defaultAutoCommit>false</defaultAutoCommit></configuration></definition></datasource>
No comments:
Post a Comment