Installing and Creating an Oracle Database 19c on Linux 7

hi everyone in this tutorial we will demonstrate the procedure to create an oracle database 19c in linux 7 on a virtual machine it will be a cdb database without oracle restart services in high level the procedure goes through the following steps first we will change some settings of the virtual appliance used in this tutorial its host name is srv1 second we will make the machine ib address static third we will configure putty to connect to srv1 fourth we will set up the environment variables for the os account oracle fifth we will change the kernel parameter values to the values recommended by oracle then we will install packages that are required by oracle database software and they aren't installed in our system finally we will do the good stuff and install the oracle database software and the create assemble database let's get started if you want to implement this tutorial on a pc it should have 3 8 gigabyte in its memory this practically means the ram memory in the pc should be at least 12 gigabyte in addition to that the pc should have at least 30 gigabyte free disk space finally the pc should be connected to the internet because we will install some packages on the virtual machine using em utility the table in the screen shows the specifications of the database that we will create in this tutorial it is a 19c database version 19.3 it will be a cdb database with a single user pluggable database in it it will be running on an oracle linux release 7.8 to implement this tutorial we need to have the following software products oracle virtualbox oracle database 19c for linux 64-bit and booty this tutorial was implemented using oracle virtualbox virgin 6 specifically 6.0.22 for windows this is a well-known virtual solution where you can build virtual machines virtual machines created by the solution are also called virtual appliances this tutorial was implemented on an oracle virtualbox appliance with a fresh installation of oracle linux 7.8 you can download a pre-built machine from my website the tutorial document contains a link to the download page in my website just be careful to download the virtual machine with the correct linux release because there are virtual machines created with different linux releases alternatively you can create one from scratch the procedure to create a vm machine with oracle linux 7 is explained in many articles and internet just google it after having the oracle virtual appliance we need to download oracle database 19c for linux x86 64-bit installation compressed file the file can be downloaded from oracle site just search the internet for oracle database 19c installation files for linux or check out the download link in the tutorial document finally we need putty this is a popular utility among the professionals who work in linux systems it is a utility that provides a command line prompt to connect to linux systems from windows after we have the virtual appliance ready we need to set some of its settings we will configure a shared folder in the virtual machine and enable the bi-directional clipboard setting go to the settings of the machine click on the shared folder click on the plus button enter the folder path give it a name make it auto mountable and click on ok button and that's it it is as simple as that then go to the network settings make sure the network adapter type is bridged adapter and its name is the same name as the network card of your pc this makes your vm appliance appears in your network as a separate host and it will be assigned an ib address based on your network configuration it is not a bad idea to set a more meaningful name to the appliance and put in basic information about the appliance contents in its description at the moment the appliance gets its id address from the dhcp in real life scenario this shouldn't be a problem for the database operation because we would have a dns server which dedicates the ib addresses with the host names but in my case i am using the hosts file as a replacement to the dns server for this reason i should make the ib address of the appliance static to avoid the risk of taking a different ib address in the future and that's what i'm going to do right now first i will start the appliance then i will log into it as root open a terminal window and issue the ifconfig command from the output i can get the ib address assigned to the machine i will just take a copy of it then i will go to the applications system tools settings then i will go to the network settings then i go to ipv4 set it to manual and give it the same ip address then i will ping the ib address to make sure the changes were successful then i will edit the hosts file to add the ib address and the host name in it then i will ping the host name to make sure the changes are successful after configuring the network settings of the appliance we need to configure putty so that we can connect to the appliance from the windows pc open putty and enter the ip address of the appliance in the host name then go to the connection and change the seconds between keep alives to a value like 9. if you wish you can increase the font size of the text that appears in putty just go to appearance click on change button and increase the font size after that save the configuration as srv1 then open the session let's try logging as root here you go the connection was successful make sure the firewall in your pc allows communication with oracle virtualbox otherwise the connection fails all the steps that we have done so far were to get our environment ready for the oracle database installation in the following steps we will configure the os variables for the software owner account which is called oracle in the putty session make sure the current user is root then add oracle account to the box sf group the vbox sf group was created by virtualbooks guest additions it allows its members to access the shared folder in the hosting machine switch the current user to oracle and make a backup copy of its patch profile file open the file and add the code as demonstrated in step number 21 init the most important variables are the first three variables oracle base oracle sid and oracle home observe that oracle home is a subdirectory of the oracle bays although you can set any directory for oracle base and home it is highly recommended to follow oracle standard in naming oracle home directory as root run the code as demonstrated in step number 22 to create the groups and directories required by oracle software the next step is to make changes on the kernel parameter values of the system and make them at least the same as the values recommended by oracle create the file as shown in step number 24 and then add the code that follows to it observe that the file name starts with the number 97 it is named this way so that we make sure that this file will be the last file to execute by the system when it executes the files in the csctl.d directory change the current values of the kernel parameters although the tutorial document suggests to reboot the system actually if you run the command in step number 25 no need to reboot the system you can go ahead to the next step most of the packages required by oracle are installed in the system however a couple of packages are missing in this tutorial we will install those missing packages open putty and login to srv1 as root then run the code as demonstrated in step number 28 to uninstall the missing packages required by oracle software all what we have done so far was done as a preparation to reach to this point in this stage of the tutorial we will install oracle database 19c software in the appliance and create the sample database copy the oracle database software installation file to the staging folder in my environment i have the file copied already to the staging folder in the position change the current user to oracle then extract the installation file into the oracle database software home directory in the virtual virtualbox window of srv1 login as oracle i will look out first from the root session and then login as oracle then open a terminal window change the current directory to the oracle database home directory and run the installer script in the configuration option window select the option create and configure a single instance database select server class then click on next make sure the enterprise edition is selected then click on next the values of the oracle base and oracle software location are taken from the os variables oracle bays and oracle home just click on next button keep the default values click on next button make sure the general purpose database is selected and click on next button we need over here to set the global database name and i will change the name of the pluggable database to pdb1 i will change the memory size to nearly 5 gigabyte do not enable the automatic memory management i will keep the character sets unchanged then i will mark this checkbox to install the sample schemas in the database over here you can select the directory where the database data files will be created i'm not going to change it from the default settings just click on next button we don't have currently an em server just click on next button enable the recovery area click on next button set a password to the system schemas change the selected groups to or install mark the check box and provide the root password all the prerequisite checks should pass if you face any issue or error you need to resolve it before you proceed click on install button when the installation reaches to nearly 12 percent it will display a confirmation message just click on yes button if everything goes fine you should end with this message just click on the close button after the installation and database creation are finished verify the database is up and running by looking into it as sysdba let's check if a connection entry to aurad b is added to the t in is names.ora file the tnsnames.ora file was created and a connection descriptor was automatically added to it start the firefox browser and open the em express accept the warning displayed by the browser enter the sales username its password leave the container name blank then click on login button the em express is up and running you may consider creating and deploying a script that automatically starts up the database when the machine is rebooted and that's it for this tutorial in high level the procedure to install and create an oracle database 19c database without oracle restart goes through the following stages set up the environment variables for the oracle os account change the kernel parameter values to the recommended values install the missing packages required by oracle software and finally install oracle database software and create the database if you wish you can download the appliance created in this demonstration you will find the download link in the video description thanks guys for staying with me see you soon in another demonstration

Channel: Ahmed Baraka

Views: 44,079

Keywords:

Id: DFbOmxoWrQ8

Length: 25min 6sec (1506 seconds)

Published: Sat Jul 18 2020