Today started with the plan of installing Oracle Business Intelligence Suite EE 12c on my work machine. After the joy of downloading the files, I realized that I had never installed Oracle Database 12c first. Duh.
Then I realized I never blogged about this install process before. Thankfully (thankfully?), I ran into a glitch that took me a bit to figure out. Hopefully if the error happens to anyone else, my post will help them get out of the pickle. Here’s the install/configure process. Note that I am installing a desktop version of the database on a Windows 10 machine.
1. Download the files from download.oracle.com
2. Once downloaded, extract both zipped files.
3. STOP!! I’m going to fill you in on a tip that might save you a bit of time and frustration.
The error I got in the installation process was at 54% where the error said that the “dr0ulib.sql.sbs” file was not found. After a few wrong actions to fix this error, what addressed the error and produced a successful installation was to go into the extracted folder named “winx64_12102_database_2of2”. Drill down to the folder named “Components”. Copy all folders in this folder.
Paste these folders into the same location in the “winx64_12102_database_1of2” folder structure. It should now look like this:
Once you do this, your installation should work fine.
4. In the “1of2” folder, click on “database”.
You should see the following folder items:
5. Run “setup” as an administrator. It will bring up the installer screen. If you have an email address already associated with My Oracle Support, you can enter it here to get details on patches and security updates, if you choose.
6. Choose your type of installation. I chose to “Create and configure a database”.
7. You can choose to use an existing Windows user account, create a new Windows user, or use a Windows built-in account.
8. Most of these items will be filled in for you. The only thing I changed was the Character Set to Unicode. I also gave the “orcl” database name a password and chose to create a Container Database.
9. The system will run through its prerequisite checks.
10. This screen will show you what the installer plans to install as well as the size requirements.
11. The system will go through the installation. This will take around 10 minutes.
12. The Database Configuration Assistant will show towards the end.
13. Your Enterprise Manager details will also show.
14. Finally, you will get a confirmation screen that everything was installed and completed.
15. To double check the installation, I went into SQL*Plus to verify the installation and create a user.
16. Next, I created the user in the container database.
17. I added the container database option to the tnsnames.ora file so we can use it in SQL Developer.
18. I added the new database to SQL Developer successfully, so I’m good to go!