Commands to start the servers
ORACLE Start --> docker compose -f docker/oracle-xe-compose.yml up -d Check logs --> docker logs -f oracle-xe
You should the message: "DATABASE IS READY TO USE!"
Oracle is now running at:
JDBC URL: jdbc:oracle:thin:@//localhost:1521/XEPDB1 User: appuser Password: secret
Test --> docker exec -it oracle-xe sqlplus appuser/secret@//localhost:1521/XEPDB1
ELASTIC SEARCH/KIBANA Start --> docker compose -f docker/elasticsearch-kibana-compose.yml up -d Test --> curl http://localhost:9200
You should see JSON like this: { "name" : "es-8", "cluster_name" : "docker-cluster", "tagline" : "You Know, for Search" }
Verify if both are running --> docker ps Output expected: oracle-xe es-8 kibana-8
Stop the containers:
docker compose -f docker/oracle-xe-compose.yml down docker compose -f docker/elasticsearch-kibana-compose.yml down
docker stop oracle-xe es-8 kibana-8
SPRINGBOOT Start --> export ORACLE_USER=appuser export ORACLE_PASSWORD=secret ./mvnw spring-boot:run
Command to call the service --> curl -X POST http://localhost:8080/ingest/full
ES Checks:
| Action | Command |
|---|---|
| list indices | curl http://localhost:9200/_cat/indices?v |
| count docs | curl http://localhost:9200/customers/_count?pretty |
| view docs | curl http://localhost:9200/customers/_search?pretty |
| view 1 doc | curl http://localhost:9200/customers/_doc/<email>?pretty |
| delete index | curl -X DELETE http://localhost:9200/customers |