Installation of Oracle 12c database on Oracle Enterprise ...



Contents TOC \o "1-3" \h \z \u Installation of Oracle 12c database on Oracle Enterprise Linux – 6.7 PAGEREF _Toc505112630 \h 2Oracle 12c Database Software PAGEREF _Toc505112631 \h 2Other Software’s required PAGEREF _Toc505112632 \h 3Oracle VirtualBox Software PAGEREF _Toc505112633 \h 4Oracle Enterprise Linux 6.7 software PAGEREF _Toc505112634 \h 4Oracle VirtualBox Installation PAGEREF _Toc505112635 \h 6Virtual Machine Setup PAGEREF _Toc505112636 \h 10Guest Operating System Installation PAGEREF _Toc505112637 \h 17Prepare Steps PAGEREF _Toc505112638 \h 34Edit the “hosts” file of Linux1 . PAGEREF _Toc505112639 \h 35Disable Firewall PAGEREF _Toc505112640 \h 36Install oracle-rdbms-server-11gR2-preinstall using yum PAGEREF _Toc505112641 \h 37Create directories and grant permissions PAGEREF _Toc505112642 \h 40Manual Setup PAGEREF _Toc505112643 \h 41Additional Setup PAGEREF _Toc505112644 \h 44Backup using VM PAGEREF _Toc505112645 \h 45Oracle Installation PAGEREF _Toc505112646 \h 46Windows sharing to Linux PAGEREF _Toc505112647 \h 46Install Database PAGEREF _Toc505112648 \h 50Verify the installation PAGEREF _Toc505112649 \h 59Install Database – Non-Container-database (Advance) PAGEREF _Toc505112650 \h 59Install Database – Container Database(including Pluggable Database) PAGEREF _Toc505112651 \h 72Installation of Oracle 12c database on Oracle Enterprise Linux – 6.7Windows 8 Server32 GB RAM / 2 TB HDDHere is my setup, I have 32 GB Server with Windows 8 installed and with 2 TB HDD on which the installation was done. I have created 1 VMs using Oracle Virtual Machine. Linux 6.74/8 GB RAM/200 GBOracle 12c Database SoftwareOracle Database 12c Release 1 from OTN 12c client on Windows DesktopOther Software’s requiredvnc viewer free version on windows - (free software) Copy files from windows to linux and vice versa (this software we will use for ftp between windows and linux)Instructions - putty.exe only Putty is used to maintenance of you Oracle database - VirtualBox Software Users Users Enterprise Linux 6.7 softwareDownload OEL 6.7 using below link Oracle Linux Release 6 Update 7 Media Pack for x86 (64 bit), Click Continue.V77197-01.iso Note:, if you want to Install Linux on a new Server, you need to burn them using the image option available with your cd-writer software, if you are using Oracle VM u may not needRefer: VirtualBox InstallationInstall the VirtualBox-5.0.6-103037-Win.exe version on the Windows host machineorrpm -Uvh VirtualBox-5.0-5.0.2_102096_el5-1.x86_64.rpm on Linux boxVirtual Machine SetupStart - Oracle VM VirtualBox (on windows)Go to System Tools – Oracle VM VirtualBox (On linux)Start VirtualBox and click the "New" button on the toolbar. Click the "Next" button on the first page of the Virtual Machine Wizard.Enter the name "linux1", OS "Linux" and Version "Oracle (64 bit)", then click the "Next" button.The "linux1" VM will appear on the left hand pane. Scroll down the "Details" tab on the right and click on the "Network" link.Make sure "Adapter 1" is enabled, set to "Bridged Adapter" and "eth0", The virtual machine is now configured so we can start the guest operating system installation.Guest Operating System InstallationClick on General->Advanced and change shared clipboard to Bidirectional and Change Drag ‘n’ Drop to Bidirectional and click OkIn the storage section, select the OEL6.7 iso file Start the virtual machine by clicking the "Start" button on the toolbar. The resulting console window will contain the Oracle Linux boot screen.Scroll Down and click NEXTSelect basic Storage and click NextSelect Discard any DataClick NextGive password for rootSelect Replace Existing LinuxSelect Write Changes to diskSelect Database Server option and select Customize now and Click NextSelect Tiger VNCSelect options as below for Desktop and Click NextClick YesReboot the Guest MachineClick ForwardPrepare StepsFirst of all check whether we can connect to the internet or notping PING (74.125.130.103) 56(84) bytes of data.64 bytes from sb-in-f103. (74.125.130.103): icmp_seq=1 ttl=46 time=63.4 ms64 bytes from sb-in-f103. (74.125.130.103): icmp_seq=2 ttl=46 time=63.5 ms64 bytes from sb-in-f103. (74.125.130.103): icmp_seq=3 ttl=46 time=62.2 msEdit the “hosts” file of Linux1 .Follow the below steps on linux1vi /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost.localdomain localhost192.168.1.18 linux1. linux1Verifyping linux1PING linux1. (192.168.1.18) 56(84) bytes of data.64 bytes from linux1. (192.168.1.18): icmp_seq=1 ttl=64 time=0.044 ms64 bytes from linux1. (192.168.1.18): icmp_seq=2 ttl=64 time=0.047 ms64 bytes from linux1. (192.168.1.18): icmp_seq=3 ttl=64 time=0.022 msDisable FirewallNow we need to disable the firewall: Linux Main menu | System | Administration | Firewall. Click on “Disable” icon, then on “Apply”.Click on "Disable" icon, then on "Apply".Install oracle-rdbms-server-11gR2-preinstall using yumyum install oracle-rdbms-server-12cR1-preinstall -yIdentify the IP address and make it staticSave the settingsYou need to start the network using below commandService network restartCreate directories and grant permissionsmkdir -p /u01/app/oraclechown -R oracle:oinstall /u01/app/chmod -R 775 /u01/app/oraclechown oracle:oinstall /u01/app/oracleCreate an environment filesu - oraclecat > oracle.envORACLE_UNQNAME=cdb1; export ORACLE_UNQNAMEORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1; export ORACLE_HOMEORACLE_SID=cdb1; export ORACLE_SIDPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATHManual SetupIf you have not used the "oracle-rdbms-server-12cR1-preinstall" package to perform all prerequisites, you will need to manually perform the following setup tasks.Add or amend the following lines in the "/etc/sysctl.conf" file.fs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500Run the following command to change the current kernel parameters./sbin/sysctl -pAdd the following lines to the "/etc/security/limits.conf" file.oracle soft nofile 1024oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768Install the following packages if they are not already present.# From Public Yum or ULNyum install binutils -yyum install compat-libcap1 -yyum install compat-libstdc++-33 -yyum install compat-libstdc++-33.i686 -yyum install gcc -yyum install gcc-c++ -yyum install glibc -yyum install glibc.i686 -yyum install glibc-devel -yyum install glibc-devel.i686 -yyum install ksh -yyum install libgcc -yyum install libgcc.i686 -yyum install libstdc++ -yyum install libstdc++.i686 -yyum install libstdc++-devel -yyum install libstdc++-devel.i686 -yyum install libaio -yyum install libaio.i686 -yyum install libaio-devel -yyum install libaio-devel.i686 -yyum install libXext -yyum install libXext.i686 -yyum install libXtst -yyum install libXtst.i686 -yyum install libX11 -yyum install libX11.i686 -yyum install libXau -yyum install libXau.i686 -yyum install libxcb -yyum install libxcb.i686 -yyum install libXi -yyum install libXi.i686 -yyum install make -yyum install sysstat -yyum install unixODBC -yyum install unixODBC-devel -yCreate the new groups and users.groupadd -g 54321 oinstallgroupadd -g 54322 dbagroupadd -g 54323 oper#groupadd -g 54324 backupdba#groupadd -g 54325 dgdba#groupadd -g 54326 kmdba#groupadd -g 54327 asmdba#groupadd -g 54328 asmoper#groupadd -g 54329 asmadminuseradd -u 54321 -g oinstall -G dba,oper oracleAdditional SetupThe following steps must be performed, whether you did the manual or automatic setup.Set the password for the "oracle" user.passwd oracleAmend the "/etc/security/limits.d/90-nproc.conf" file as described below. See?MOS Note [ID 1487773.1]# Change this* soft nproc 1024# To this* - nproc 16384Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.SELINUX=permissiveOnce the change is complete, restart the server or run the following command.# setenforce PermissiveBackup using VMOracle InstallationWindows sharing to LinuxIn this topic we shall see how to share a windows folder and access it in Linux 1> Share a folder in WindowsWindows IP address 192.168.1.9 and USER is the user in the windows 7/8 Now login to Linux and access all the shared folder on Windowssmbclient -L 192.168.1.9 -U USERCreate a directory in linux and mount itmkdir -p /softwaremount -o username=USER //192.168.1.9/database /softwarerun vncserver on the Guest machineFrom windows machine using vncviewer Install DatabaseLet’s install the Oracle Database Run the environment file – oracle.env the installation [oracle@linux1 ~]$ . ./oracle.env[oracle@linux1 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 12.1.0.2.0 Production on Mon Jan 29 16:45:42 2018Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> select name from v$database;NAME---------CDB1Install Database – Container Database(including Pluggable Database) In Oracle Database 12c Release 1 the concept of multitenant environment has been introduced. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12 were non-CDBs. A CDB includes the following components:RootThe root, named?CDB$ROOT, stores Oracle-supplied metadata and common users. An example of metadata is the source code for Oracle-supplied PL/SQL packages. A common user is a database user known in every container. A CDB has exactly one root.SeedThe seed, named?PDB$SEED, is a template that you can use to create new PDBs. You cannot add objects to or modify objects in the seed. A CDB has exactly one seed.PDBsA PDB appears to users and applications as if it were a non-CDB. For example, a PDB can contain the data and code required to support a specific application. A PDB is fully backward compatible with Oracle Database releases before Oracle Database 12c.Each of these components is called a container. Therefore, the root is a container, the seed is a container, and each PDB is a container. Each container has a unique container ID and name within a CDB.References: ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download