The other day an esteemed reader of this humble blog asked me a question about installing Intelligent Advisor on Amazon Elastic Cloud. Of course I immediately sugested they try Oracle Cloud instead but the questions were valid and it soon struck me that this site has not, for a long time updated it’s installation posts and guides (notably the Create an OPA Self-Study Series). So I had a few minutes to spare while waiting for a train the other day and I sat down and recorded an example. To assist with the example, which is extremely edited to simply hightlight he key points, here are the things that I needed to install the entire stack for an Intelligent Advisor Install.
- I started with Windows 2012 R2 Server as the base image. Old, stable and easy to navigate
- I choose 100Gb for the disk size and Large for the image
- I downloaded WebLogic 188.8.131.52 Quick Installer
- I downloaded Oracle Database 12c database
- I downloaded JDK 8 261
- I downloaded the latest version of SQL Developer
- I downloaded the 20B release of Intelligent Advisor
The install routine is very well documented here online and you could pretty much follow that as-is. my own way of installing in this demonstration focuses at the end on the Data Source, which is often forgotten about during the install. Here are the stumblng blocks you might come across:
- Local Security Policy stopping IE from being launched so you cannot install Chrome.
- Local Server setup put IE in enhanced security mode which slows everything down.
- Microsoft Visual C++ Runtime Missing which stops SQL Developer running. (See the section entitled Note: the Windows EXE requires a MSVCR100.dll to run. Most computers will already have this file and in the Windows PATH. However, if the first copy of the file found by the EXE is a 32-bit copy of the DLL, then SQL Developer will fail to start. You can fix this by copying a 64-bit version of the DLL into the BIN directory or updating your OS PATH such that a 64 bit copy of the DLL is found first.).
- Creating the database user for the install with the correct permissions.
- Ensuring the Data Source in your WebLogic is targeting the database and can connect / the database name is correct and the data source is accessible from the WebLogic server you created
- Ensuring for this demonstration machine that Node Manager is not using a secure connection
As I state clearly in the beginning of this video, this is for demonstration purposes only, and it is entirely your responsibility to ensure that you have licenses, permission and authority to do any of this. Good luck with your Intelligent Advisor Install and do not hesitate to leave a comment if you run into issues.