This includes the preparation and configuration of the CentOS 7 machine for the Oracle 12c installation, the Oracle 12c installation and testing the database with the Oracle Database command line utility 'sqlplus' and the web-based Oracle Enterprise Manager. CentOS 7 64-bit. At least 1 GB RAM Memory. Root Privileges.
So i'm trying to install Oracle 11g62 64 bit Client on my WIN7 & i have created a response file & my response file looks like this################################################################################# Copyright(c) Oracle Corporation 1998,2008. All rights reserved. #### #### Specify values for the variables listed below to customize #### your installation. #### #### Each variable is associated with a comment. The comment #### can help to populate the variables with the appropriate #### values.
Oracle database is one of the most widely used relational database management systems ( RDBMS) in enterprise environments. Developed, maintained, and supported by Oracle Corporation, this RDBMS is often installed on top of a flavor of Enterprise Linux (RHEL, CentOS, or Scientific Linux).
This makes for a very robust operating system – database choice.In this article, we will explain how to install Oracle 12c Release 2 on a RHEL/ CentOS 7 GUI server.Attention: RHEL/CentOS 6 users can follow this guide toLet’s begin. Prerequisites:After installing Oracle 12c, the configuration will be performed through a graphical interface. That is the reason why we need a CentOS 7 server with the X Window System software group installed.Read Also:Additionally, please note that an Oracle account is required to download the ( 3.2 GB). Don’t worry about this, though, as you can create an account for free.Finally, make sure your server has at least 2 GB of RAM and 30 GB of available disk space. These hardware requirements are safe for a testing environment such as ours, but will need to increase if you consider using Oracle in production. Preparing for Oracle 12c Installation1.
To begin, make sure that all the packages currently installed on your RHEL/CentOS 7 system are updated to their latest versions. # yum update -y2. Next, installed all the required dependencies for the RDBMS, along with the zip and unzip packages.
# yum install -y binutils.x8664 compat-libcap1.x8664 gcc.x8664 gcc-c.x8664 glibc.i686 glibc.x8664 glibc-devel.i686 glibc-devel.x8664 ksh compat-libstdc-33 libaio.i686 libaio.x8664 libaio-devel.i686 libaio-devel.x8664 libgcc.i686 libgcc.x8664 libstdc.i686 libstdc.x8664 libstdc-devel.i686 libstdc-devel.x8664 libXi.i686 libXi.x8664 libXtst.i686 libXtst.x8664 make.x8664 sysstat.x8664 zip unzip3. Create the user account and groups for Oracle. # groupadd oinstall# groupadd dba# useradd -g oinstall -G dba oracleFinally, set a password for the newly created oracle account. # passwd oracle4.
Add the following kernel parameters to /etc/sysctl.conf file. Fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.iplocalportrange = 9000 65500net.core.rmemdefault = 262144net.core.rmemmax = 4194304net.core.wmemdefault = 262144net.core.wmemmax = 1048586and apply them: # sysctl -p# sysctl -a5. Set the limits for oracle in /etc/security/limits.conf file.
Oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655366. Create a directory named /stage and extract the zipped installation file. # unzip linuxx6412201database.zip -d /stage/Before proceeding, create other directories that will be used during the actual installation, and assign the necessary permissions.
# mkdir /u01# mkdir /u02# chown -R oracle:oinstall /u01# chown -R oracle:oinstall /u02# chmod -R 775 /u01# chmod -R 775 /u02# chmod g+s /u01# chmod g+s /u02We are now ready to run the installation script.7. Open a GUI session in the RHEL/CentOS 7 server and launch the installation script. /stage/database/runInstallerand follow the steps presented by the installer. Installing Oracle 12c on CentOS 78. Enter the email address associated with your Oracle account (optional). Execute Oracle 12c Configuration Scripts15. After that, you will need to return to the previous screen in the GUI session and click OK so that the installation can continue.When it is finished, you will be presented with the following message indicating the URL of the Oracle Enterprise Manager: 12c Finishing Touches16.
To allow connections from outside the server, you will need to open the following ports: 1521/TCP5500/TCP5520/TCP3938/TCPAs follows: # firewall-cmd -zone=public -add-port=1521/tcp -add-port=5500/tcp -add-port=5520/tcp -add-port=3938/tcp -permanent# firewall-cmd -reload17. Next, login as oracle using the password that was chosen previously and add the following lines to.bashprofilefile. TMPDIR=$TMP; export TMPDIRORACLEBASE=/u01/app/oracle; export ORACLEBASEORACLEHOME=$ORACLEBASE/product/12.2.0/dbhome1; export ORACLEHOMEORACLESID=tecmint; export ORACLESIDPATH=$ORACLEHOME/bin:$PATH; export PATHLDLIBRARYPATH=$ORACLEHOME/lib:/lib:/usr/lib:/usr/lib64; export LDLIBRARYPATHCLASSPATH=$ORACLEHOME/jlib:$ORACLEHOME/rdbms/jlib; export CLASSPATH18. Finally, replace localhost with 0.0.0.0 on. # vi $ORACLEHOME/network/admin/listener.ora. Set Oracle 12c Listener19. The last step consists in reloading.bashprofile to apply the new settings.
# source.bashprofile20. And then login to the database using the system account and the password chosen in Step 11 of the previous section. # sqlplusOptionally, let’s create a table inside the tecmint database where we will insert some sample records as follows. SQL CREATE TABLE NamesTBL(id NUMBER GENERATED AS IDENTITY,name VARCHAR2(20));Please note that IDENTITY columns were first introduced in Oracle 12c. SQL INSERT INTO NamesTBL (name) VALUES ('Gabriel');SQL INSERT INTO NamesTBL (name) VALUES ('Admin');SQL SELECT.
FROM NamesTBL. Create Table in Oracle 12c Database Enabling Oracle to Start on System Boot21. To enable the database service to start automatically on boot, add the following lines to /etc/systemd/system/oracle-rdbms.service file. # /etc/systemd/system/oracle-rdbms.service# Invoking Oracle scripts to start/shutdown Instances defined in /etc/oratab# and starts ListenerUnitDescription=Oracle Database(s) and ListenerRequires=network.targetServiceType=forkingRestart=noExecStart=/u01/app/oracle/product/12.2.0/dbhome1/bin/dbstart /u01/app/oracle/product/12.2.0/dbhome1ExecStop=/u01/app/oracle/product/12.2.0/dbhome1/bin/dbshut /u01/app/oracle/product/12.2.0/dbhome1User=oracleInstallWantedBy=multi-user.target22. Finally, we need to indicate that the tecmint database should be brought up during boot in /etc/oratab ( Y: Yes).