How to install Instant Client - How to Configure Instant Client on Windows

Summary

To successfully install Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, you need to follow a few critical steps. Start by setting up environment variables and installing a loopback adapter with a static IP. Then, install an Oracle database (any version 10g, 11g, or 12c) followed by the Repository Creation Utility to set up repository tables. Finally, install and configure OBIEE 11g, and optionally, create users for practice labs and learn how to import/export Oracle database data. Initially, create a folder on the C drive for Instant Client, then download the 32-bit Instant Client software, unzip it into the newly created folder, and modify the Windows path variable. Conclude by adding a new TNS_ADMIN variable, ensuring OBIEE can run successfully on your machine.

Highlights

• Learn to set up environment variables for OBIEE 11g installation ⚙️
• Download and unzip the correct Instant Client files for success 🗂️
• Configure Windows path and TNS_ADMIN variables for seamless operation 💡

Key Takeaways

• Start by setting up environment variables for a smooth installation process 🚀
• Unzip the 32-bit Instant Client software into the created folder 📁
• Ensure OBIEE runs smoothly by correctly configuring your environment variables 🌟

Overview

Embarking on the OBIEE 11g installation journey requires you to first set up your environment variables correctly. Without this vital step, you may face hiccups along the way. The process begins with the creation of an essential folder on your C drive, setting the stage for everything else that follows.

The installation and configuration of the Instant Client play a crucial role in connecting different databases to Oracle applications. Regardless of your system's specifications, downloading and unzipping the 32-bit version are imperative steps in smoothing out the software integration process.

After preparing your directory and files, adjusting the Windows path and adding a new TNS_ADMIN variable ensure the system's settings are primed and ready to support Oracle Business Intelligence. This setup is key to the proper functioning of your OBIEE setup, demonstrating the power of meticulous configuration.

Chapters

• 00:00 - 01:00: Introduction and Installation Steps Overview The chapter 'Introduction and Installation Steps Overview' provides a detailed guide for successfully installing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g. It emphasizes following the steps in the specified order to ensure a proper installation. The installation process begins with setting up environment variables, followed by installing the loopback adapter with a static IP address.
• 01:00 - 04:30: Creating a Folder and Downloading Instant Client This chapter explains the process of installing the Oracle database. It specifies that the version of the database does not matter, whether it's 10g, 11g, or 12c. The chapter outlines step four of the process, which involves installing the Repository Creation Utility, connecting to the Oracle database, and creating repository tables to hold sample data for OBIEE 11g. The final step, step five, involves installing and configuring OBIEE 11g.
• 04:30 - 06:00: Unzipping and Setting Up the Instant Client The chapter discusses the process of setting up the Instant Client and includes a bonus step on post-installation procedures. The bonus step involves creating users who will be utilized in labs throughout the course. Additionally, the chapter covers how to import and export data from the Oracle database.
• 06:00 - 08:00: Modifying Windows Path Variable The chapter titled 'Modifying Windows Path Variable' guides the reader on setting up environment variables, particularly emphasizing the initial step of creating a folder on the C drive. This chapter likely includes detailed instructions on modifying the Windows Path Variable, essential for configuring the environment in practice and lab settings.
• 08:00 - 10:00: Creating and Configuring Environment Variables This chapter provides a step-by-step guide on creating and configuring environment variables on Windows. It instructs users to open Windows File Explorer, navigate to the C drive, create a new folder named 'instantclient', and prepare for subsequent configuration steps.
• 10:00 - 10:30: Closing Remarks The chapter provides final instructions on downloading and installing the instant client software necessary for running Oracle Business Intelligence (OBI) on a 64-bit machine. It emphasizes the requirement of a 32-bit instance client software, even on a 64-bit system, and explains its role in connecting various databases to applications within Oracle. The software is freely accessible from Oracle's platform.

How to install Instant Client - How to Configure Instant Client on Windows Transcription

• 00:00 - 00:30 for a successful installation of oracle business intelligence enterprise edition i recommend that you follow the steps listed on these slides in the order in which you install each component for a successful installation of obiee 11g the first step is to set up the environment variables followed by installing the loopback adapter with a static ip address then you will go ahead and install the
• 00:30 - 01:00 oracle database which version of the database does not really matter it could be a 10g 11g or 12c step 4 you will install the repository creation utility connect to oracle database and create some repository tables to hold most of the sample data that you'll be using in ob ieee 11g and the fifth step which is the final step in installation will be to install and configure your ob ieee 11g on your
• 01:00 - 01:30 machine i've also included a bonus step 6 for post installation steps in this step what you do is you create users which will be working with in your labs as we go along during this uh course then the next thing will be to also show you how to import and export data from the oracle database which you can also
• 01:30 - 02:00 use in the practice and labs that are provided in this lesson so step one setting up the environment variables now the first thing that you want to do is before you go ahead and start setting up your environment variables you want to create a folder on your c drive and i will show you how to do that you will right click
• 02:00 - 02:30 on your windows file explorer go to file explorer then go to your c drive on the c drive when you're here all you have to do is just go ahead and click new folder once the new folder option comes up just type instant client done then the next step that we want to do is
• 02:30 - 03:00 we want to download the instant client software it's a 2-bit even if your computer may be a 64-bit you need a 2-bit instant client software to be able to run your obi successfully on your machine an instant client software is basically used for connecting different databases to different applications within oracle database and it's freely available on the oracle software i will go ahead and
• 03:00 - 03:30 show you which versions of instant clients you can download to have a successful installation in this slide which i share with you i will include urls which you can either copy and paste or click on to access your direct location where you can download this particular software so we'll go ahead and copy the link then open
• 03:30 - 04:00 a google chrome window it's taking a few minutes once it opens then we'll paste that url in the browser and go ahead and press enter so when you get to this page you want to download two files assuming that you are using a database 12c it's recommended that you go for the version 12.1.0.2.0
• 04:00 - 04:30 and out of this list that has been provided here you want to download only the first one that says instant client basic and another one that says instant client package or dbc you will download these two options onto your computer and once you have successfully downloaded them you will go ahead and unzip them into the folder that we
• 04:30 - 05:00 created in a step earlier so since i'm using a database 11g the downloads that i'm interested in are these two so i'll go ahead and show you how to download you have to accept accept the oracle license agreement and you scroll down to the section where you want to do the download click on it so what you want to do is you want to
• 05:00 - 05:30 go ahead and enter your username which in this case for me it's uh my email address and then the password once the two instant client files have been downloaded onto your machine the first thing that you want to do is to unzip the first
• 05:30 - 06:00 instant client download into the instant client folder that you created earlier on and then the next step would be to unzip the second instant client file into the same folder that you created earlier after successful unzipping of those two files you should see something like this in your folder instant client underscore 12 underscore 11 and let's go to and then you have
• 06:00 - 06:30 a list of different uh libraries that were installed and which are necessary for connecting to the oracle database 11g after the successful download is completed the next thing that you want to do is to go ahead and modify the path variable on your windows machine and to do that you will go ahead and right click on your start menu
• 06:30 - 07:00 then choose system once the system window comes on you will go ahead and click on advanced system settings then you go ahead and click on environment variables when you are in the environment variables window down in the section that says system variables you want to scroll down and find the variable called path
• 07:00 - 07:30 then you will go ahead select that option and then click edit once you click edit you will paste copy and paste the path where the instant client is which in this case has already been done and you'll notice that this is the last item that's listed here c instant client instant client underscore 11 underscore 12. and how did i get to this path i will show you in a second
• 07:30 - 08:00 you go ahead and go back to your desktop go to your c drive once you go back to your instant client folder click in the browser copy and open the environment variables window again then okay once the edit environment variables
• 08:00 - 08:30 window opens the next step you want to perform is to click on new and then you can either type in the path or you can paste it we had previously tested it in a demonstration so the pest function actually brought in this last item here as can be seen after this step has been performed successfully just go ahead and click ok then the next step after you've included the instant client path to the path
• 08:30 - 09:00 variable the next step is to create a new tns admin variable now to create the tns admin variable what you do is you go ahead and click new then you type tns underscore admin and you paste the instant client path which you copied earlier and then you go ahead and click ok after clicking ok you will have
• 09:00 - 09:30 another variable called admin tns admin with the value of c instant client instant client underscore 11 underscore two this is how you create and configure the environment variables in order for your obi 11g to be able to successfully work and run on your machine after this function all you do is you close out these windows by clicking okay
• 09:30 - 10:00 and okay again and you bring it to this screen i look forward to showing you how to install the loopback adapter in the next section thank you for watching