e-DBA Blog (2)
Oracle Apex Listener on WebLogic Featured
Written by Lee IrvineSo, before you can use the Apex software you just installed onto your Oracle database, you need to be able to access it from a browser. This means you need a HTTP server or Application server to provide that capability. I shall be using the WebLogic 12.1. As mentioned in another thread, it is based on the Apex install 4.0.1 on Oracle 11.2.0.
Ensure you have a valid WebLogic domain and you can deploy applications onto it.
I configured 2 managed servers, but that is not necessary, as you can use the admin WebLogic server if you wish. So in the apex directory you should now have an apex.war and i.war file.
Both of these files new deploying to WebLogic. Therefore you want to go to the WebLogic console and select "deployments" in the navigation. Specify the location of your file and click next. Select the defaults for deploying and click next. Click Finish on review.
Next you need to click on "SecurityRealm", clicking on "myrealm" or equivalent if you have created your own realm. Create new users called adminlistener / managerlistener: Default Auth and password.
Then create new roles to attach these users under. Again under "SecurityRealm" select the tab "Roles and Policies",
In the table under deployments you will find Roles, click that…
Add the role Admin and use the default drop down value (unless you have added others) and click save.
Click the Admin role in the table and click "Add Conditions". Select a User predicate and add the adminlistener to the group. Click save.
Repeat for the Manager role adding the managerlistener user!
OK, so everything is done now… Apex should be installed…
The next step is to configure the DB access… go to the URL:
http://<host_installed_on>:<port>/apex/listenerConfigure and add the credentials to access the database where apex was installed.
Now try logging in… I had fun with that one…. the documentation is not very clear in this regard…either you are faced with a login screen which asks for a workspace for which you have no idea about, or you are not sure which username and password to use. The best option is to go to:
http://<host_installed_on>:<port>/apex/apex_admin
And enter the credentials you used to create the APEX in the database… remember when you set the password for that user ages ago running some install command… Once logged in, you are forced to change it (as I mentioned elsewhere)… and originally forgot to note down what I had done… oops… hopefully you haven't made the same mistake! The password you created earlier is associated with the Admin user BTW.
When you again log into the system, you can use the "internal" workspace to login as Admin, if you are not sure which workspace to log in to! The next step is to start creating a workspace, users and an application!
Welcome to e-DBA's new website. We have had the website re-designed, re-manufactured in order to help our customers find information about our services more easily, easier to get in touch with us and keep up to date with our products and services, latest news and other fun happenings at e-DBA.
We hope you like the new layout and we hope you can find what you are looking for. If not, you can use the new Live Chat feature which is available on the left hand side of everypage, making it easier to engage with us. We have even joined twitter, so please follow us and keep up to date with what's happening at e-DBA.
Throughout the website, you will find:
- Information on all of our products and services
- Social Media links - Twitter, Facebook etc
- Blog - This will be updated with techical information, latest news and everything else that happens at e-DBA
- Event information
- Technical information from the blog
- Blog updates from all members of the e-DBA team
We hope you like our new website, which we hope meets your requirements. If you have any questions or would like to see something on the website, please do not hesitate to ask. Your thoughts are always welcome 
At e-DBA, we work hard but also like to have fun. Please keep you eye out for information soon regarding a charity bike ride which some of our staff are taking part in from London to Paris. Good luck to all those involved. More information coming soon on that.
