Category: Installation

Thoughts on Installing OPA 19D On Premise

Thoughts on Installing OPA 19D On Premise

I addressed these thoughts in another forum, but figured I might put them here too, but under a different angle. Recently I discovered, as you do, that the installer for the On Premise Server Components of Oracle Intelligent Advisor 19D (aka Oracle Policy Automation Server Components) had a bit of an issue. As you probably know, it comes with three options (there used to be a fourth I think, in the 2014 timeframe, when the In Memory Analysis Server thing was being introduced).

Installing 19D

You can see them in the top part of the screenshot above, and you can see my issue in the lower section. the installer just dumped me out without any warning, complaining that I hadn’t given the deployment a name. Well I had not had a chance to even think about it because the script crashed as soon as I hit Return. Now, the java magic behind this script has been reverted to “Update 1” rather than “Update 2” according to the excellent response I got from Oracle. But that is not the purpose of this post.

In spite of the error above, and the errors in the other two options which stopped me from doing anything at all  – the second option had the same problem:

And the third option couldn’t work without the database and randomize seed key being present. So I was stuck. This was just a test machine, so I was not under life or death pressure, but I didn’t want to give up as I had to do some work on 19D. So after checking everything was versioned correctly and installed (WebLogic 12c was already running and healthy, Java JDK and JRE installed and in the path, that sort of thing) we decided to do it manually.

The On Premise installation of Oracle Policy Automation can broadly be defined as three steps

  • Create the user and database
  • Populate the database with the tables
  • Populate the tables with the seed data (such as the user admin)

These can be done manually by a combination of the following :

  1. Reading and following the On Premise guide where it provides helpful examples of the creation of the OPA Hub database user. There is little more to do that make any changes to the password or username and just run it.
  2. Running the SQL Script in the /unzippedinstaller/opa/bin/sql folder that creates the database (“create_tables_oracle.sql”). Again, aside from making sure you are connected with the user you just created, just click and go.
  3. Running the SQL Script which injects the seed data (such as the admin user and the basic roles, configuration settings and so forth) which is in the private_cloud subdirectory and is called “seed_data_oracle.sql”.
  4. The final step is to reset the admin password for the future OPA Hub. This uses the admin command (the or admin.cmd is present in the unzipped folders in the same location as install.cmd) with the -resetpassword switch. The various options are detailed in the documentation, if you are using Oracle DB don’t forget to use both the dbconn as well as the dbtype and dbuser and dbpass options. If you get a message about admin not being a user, go into the authentication_pwd table (there should only be one record) and change the status flag from 1 to 0 or vice-versa. Commit the changes then run the admin script again with your new password request.
  5. You can now run the third option to create the web applications and manually install them on the WebLogic server using the Deployment option. Don’t forget to create a Data Source pointing to your database before you install (it is documented here). On a test server I always put it as the default datasource as well to save me time.

Now you should have an up and running OPA 19D :

19D Welcome Screen

There are of course a number of other things you might have to fiddle with or that you can leverage. In my case, there was already a 19D database instance installed some days previously using the original installer, so a clone might have been an easier option.

Now let’s just make something clear. Under no circumstances am I telling you to do this. I’m putting this here because I thought it was interesting and educational. But you must the installation tools and guide provided. I will not be held responsible for anything or anyone.

Installing Oracle Policy Automation Hub Self Study Platform Part Two

Installing Oracle Policy Automation Hub Self Study Platform Part Two

I am regularly asked by students how to set up and install an OPA Hub for self-study purposes. So this post series aims to give people a guide to follow. Obviously this sort of thing is perilous because there are so many permutations and languages and settings and so forth. So I thought I had better finish what I started in the previous post!

It should be obvious by now that I am not aiming for in depth discussion of the best way or the secure way – I am aiming to get an OPA Hub in a virtual machine as fast as possible running Windows on my Windows PC in Virtual Box. Like every other application that I work with…

Get WebLogic Up and Running

In the last episode you had just started the WebLogic Configuration Wizard. Here are the steps to get the configuration done quickly, in preparation for the next part. Create a new domain.

Weblogic Config 2


Weblogic Config 4

Choose the base server option then set up a login and password.

Weblogic Config 5

We want to configure the following options:
Weblogic Config 6

WebLogic Config 7

Give a password and username for the nodemanager, keeping the other values as default.

Weblogic 7

We don’t want any clusters, but we do want a machine. Create one and call it Machine.

Weblogic Config 8
Webligic Config 9

You should now find yourself at the end of the configuration wizard.
Weblogic Config 10

Dig up the StartWebLogic and StartNodeManager scripts from your install directory:

Weblogic StartWeblogic Script

Find and change the SecureListener to false. Save and close the file.

NodeManager Properties


Start Weblogic and start Nodemanager using the provided shortcuts.

Weblogic Starting

Access WebLogic using the URL that was given at the end of the configuration (/console). Login with your login and password.

Nodemanager plain

Go to Machines. Find the machine you created in the configuration wizard and drill down on it. Select Node Manager and set the Type to Plain. Click Save.
machine in weblogic

In the menu go to Servers, add a new Server called OPA or HUB (something short, one word). Make sure the port is 7002.

Associate the Server with your Machine. Drill down on the Machine and Add the Server you just created to the Machine.

Associate Server with Machine

Start ServerIn the Servers List, with the Control tab selected, click your Server and Start it.

Installing Oracle Policy Automation

Finally we are here. Download the latest version of the OPA Server components from Oracle TechNet. Unzip the files into a safe place and dig out the install command file. Run it.

OPA Install Start


OK, I’ll admit it. I got tired of doing all those screenshots. So here is the video version of the next steps.


Nearly There!

On to part three!


Logo by Southpaw Projects LLC