To create a database link to MySQL, follow these steps: Prerequisites: Oracle Database: Ensure that Oracle Database is installed and running. MySQL Database: Have access to a MySQL database. Steps: Install MySQL ODBC Driver: Download and install the MySQL ODBC driver from the official MySQL website. After installation, configure the ODBC driver in the ODBC […]

Deploy ORDS to Tomcat install ORDS as standalone in your webserver and connect to your database server (if it is not in localhost you need to open listener port on database server and allow access to it remotely) Java -jar ords.war –config configdirectory install check if it works ok using: Java -jar ords.war –config configdirectory […]

to change ords_public_user password: Java -jar ords.war –config configdirectory config secret db.password If you user tomcat you need to update the application in tomcat. create the webapp for tomcat again: Java -jar ords.war –config configdirectory war appname.war Replace the old webapp file with the new one the tomcat/webapp directory. restart tomcat if nessecary.