Cruplex

So, 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!

Published in e-DBA Blog