DMAP: App & Data Modernization for Oracle to AWS RDS & Aurora PostgreSQL

DMAP Application Usage Instructions

Step 1: Launch the AMI. Log in to AWS Management Console and navigate to EC2. Click Launch Instance and select this DMAP AMI. Choose instance type t3.xlarge or higher for optimal performance.

Step 2: Configure Security Group. Create or select a security group with inbound rules allowing SSH on port 22, DMAP Application UI on port 9091, DMAP Database UI on port 9090, Database Port 5433, and Python Service port 7002 from your IP address or as needed.

Step 3: Select or create a key pair, download the PEM file, review configuration and launch the instance. Wait for Running state and note the Public IP address.

Step 4: Connect to Instance. Open terminal and run chmod 400 followed by path to your PEM file. Connect via SSH using ssh -i followed by PEM file path and ec2-user@ followed by instance public IP.

Step 5: Start Docker Service. Run sudo systemctl enable docker then sudo systemctl start docker to enable and start Docker service.

Step 6: Launch Database Container. Run sudo docker run -d -it -p 5433:5432 -p 9090:8080 -p 7002:5002 -e UI_PORT=9090 -e SERVICE_PORT=7002 -e DB_PORT=5433 -e ONLINE=Y --name=dmap_db_prod ngdmapo/dmap_db_prod:latest

Step 7: Launch Application Container. Run sudo docker run -d -it -p 9091:8080 -p 5002:5000 --name=dmap_app_prod ngdmapo/dmap_app_prod:latest

Step 8: Verify containers are running using sudo docker ps. You should see both dmap_db_prod and dmap_app_prod containers with Up status.

Step 9: Access Application. Open browser and navigate to http:// followed by your instance public IP :9091/DMAP/#/login

Troubleshooting: If unable to access, check Security Group rules ensure port 9091 is open. Verify containers using sudo docker ps -a. Check logs using sudo docker logs dmap_app_prod or sudo docker logs dmap_db_prod. Restart containers if needed using sudo docker restart dmap_app_prod dmap_db_prod.

Port Configuration: Default ports are 5433 for database, 9090 for database UI, 7002 for Python service, 9091 for application UI, and 5002 for internal services. Ports can be customized but update security group accordingly.

License Validation: Set ONLINE=Y for online license validation requiring internet connectivity or ONLINE=N for offline validation using local license files.

Important: Database container must start before application container. All commands require sudo privileges. Ensure chosen ports are available and not used by other processes.