Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

How do you Install Oracle Linux 7 (OL7)

-
This tutorial provides a pictorial guide for performing a basic installation of Oracle Linux 7 
Installation
  1. Boot from the DVD. Use the up arrow to pick the "Install Oracle Linux 7.0" option and hit the return key.
    Boot
  2. Select the appropriate language and select the "Set keyboard to default layout for selected language" option, then click the "Continue" button.
    Language
    Click the "I want to proceed." button on the pre-release software warning screen.
  3. You are presented with the "Installation Summary" screen. You must complete any marked items before you can continue with the installation. Depending on your requirements, you may also want to alter the default settings by clicking on the relevant links.
    Installation Summary
    Click the "Installation Destination" link.
  4. If you are happy to use automatic partitioning of the whole disk, click the "Done" button to return to the previous screen.
    Installation Destination
    If you want to modify the partitioning configuration, click the "Continue" button and work through the partitioning screens.
  5. It would be advisable to click on the "Software Selection" link and pick the following options if you want a GUI console.
    • Base Environment > Server with GUI
    • Add-Ons for Selected Environment > Compatibility Libraries
    • Add-Ons for Selected Environment > Development Tools
    Once you have completed your selections, click the "Done" button.
    Software Selection
  6. Once you have completed your alterations to the default configuration, click the "Begin Installation" button.
    Installation Summary
  7. Click the "Root Password" link.
    Configuration
  8. Enter the root password and click the "Done" button.
    Root Password
    Click the "User Creation" link.
  9. Enter the user details and select the "Make this user administrator" option, then click the "Done" button.
    Create User
  10. Wait for the installation to complete. When prompted, click the "Reboot" button.
    Configuration
  11. Click the "License Information" link. Check the "I accept the license agreement" checkbox and click the "Done" button. When you return to the previous screen, click the "Finish Configuration" button.
    Initial Setup
  12. Decide if you want to use Kdump and click the "Forward" button.
    Kdump
  13. Decide if you want to set up software updates and click the "Forward" button. If you chose not to register with ULN, you will need to confirm you decision also.
    Set Up Software Updates
  14. Click the "Forward" button.
    Finish Updates Setup
  15. On the sign-in screen, click on the user you want to log in as.
    Log In
  16. Enter the password and click the "Sign In" button.
    Sign In
  17. Accept the language by clicking the "Next" button.
    Welcome
  18. Accept the input sources by clicking the "Next" button.
    Input Sources
  19. Connect to existing data in the cloud, or just click the "Next" button.
    Online Accounts
  20. Click the "Start using Oracle Linux Server" button.
    Thank You
  21. You are now presented with the console screen.
    Console

Network Configuration

  • If you are using DHCP to configure your network settings, then ignore the following network configuration screens, otherwise click the network icon on the top bar and click the "Network Settings" link. You are then presented with the "Settings" screen. Highlight "Wired", flick the switch to "ON" and click the cog icon at the bottom-right.
    Network
  • Click the IPv4 option, select the "Manual" method and enter the appropriate IP address and subnet mask, default gateway and primary DNS, then click the "Apply" button.
    Network Devices - IPv4
  • Close the "Network" dialog.

Customizing Software

  • You can customize the installed packages using the "Software" dialog (Applications > System Tools Software).
    Software

SELinux

  • If the OS is to be used for an Oracle installation, it is easier if Secure Linux (SELinux) is disabled or switched to permissive. To do this edit the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
    SELINUX=permissive
    If SELinux is configured after installation, the server will need a reboot for the change to take effect.

Firewall

  • If the OS is to be used for an Oracle installation, it is easier if the firewall is disabled. This can be done by issuing the following commands from a terminal window as the "root" user.
    # systemctl stop firewalld
# systemctl disable firewalld
You can install and configure it later if you wish.

SSH


  • Make sure the SSH daemon is started using the following commands.
    # systemctl start sshd.service
# systemctl enable sshd.service

Comments

Post a Comment

Popular posts from this blog

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

-
Method 1 You can check the mode of the server using "pg_controldata". [pgsql@test~]$ pg_controldata /usr/local/pgsql/data84/ Database cluster state: in archive recovery --> This is Standby Database Database cluster state: in production --> This is Production Database [Master] Method 2 You can use pg_is_in_recovery() which returns True if recovery is still in progress(so the server is running in standby mode or slave) postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- t (1 row) If Return    false   so the server is running in primary mode or master postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- f (1 row)
Read more

7 Steps to configure BDR replication in postgresql

-
Image
 The  BDR  (Bi-Directional Replication) project adds multi-master replication to PostgreSQL 9.4.  Postgres-BDR has a lower impact on the masters(s) than trigger-based replication solutions. There is no write-amplification, as it does not require triggers to write to queue tables in order to replicate writes.   Here We are using  postgres version 9.4.12 and bdr version 1.0.2. for configuring  multi master replication . Simply Following 7 steps you can configure the multi master replication in postgresql. To download the bdr in below link. .   https://github.com/2ndQuadrant/bdr/archive/bdr-pg/REL9_4_12-1.tar.gz $ tar -xzvf REL9_4_12-1.tar.gz $ wget https://github.com/2ndQuadrant/bdr/archive/bdr-plugin/1.0.2.tar.gz $ tar -xzvf 1.0.2.tar.gz 1. To install BDR. $ cd ~/bdr-bdr-pg-REL9_4_12-1 $ ./configure --prefix=/usr/lib/postgresql/9.4 --enable-debug --with-openssl $ make -j4 -s install-world $ cd ~/bdr-bdr-plugin-1.0.2 $ PATH=/usr/lib/postgresql/9.4/bin:"$PATH" ./c
Read more

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

-
In this post, I am sharing few important function for finding the size of database, table and index in PostgreSQL. Finding object size in postgresql database is very important and common. Is it very useful to know the exact size occupied by the object at the tablespace. The object size in the following scripts is in GB. The scripts have been formatted to work very easily with PUTTY SQL Editor. 1. Checking table size excluding table dependency: SELECT pg_size_pretty(pg_relation_size('mhrordhu_shk.mut_kharedi_audit')); pg_size_pretty ---------------- 238 MB (1 row) 2. Checking table size including table dependency: SELECT pg_size_pretty(pg_total_relation_size('mhrordhu_shk.mut_kharedi_audit')); pg_size_pretty ---------------- 268 MB (1 row) 3. Finding individual postgresql database size SELECT pg_size_pretty(pg_database_size('db_name')); 4. Finding individual table size for postgresql database -including dependency index: SELECT pg_size_pretty(pg_total_rel
Read more

Ora2PG - Oracle/MySQL to Postgres DB migration Version 20.0

-
Ora2Pg is a free tool used to  migrate  an  Oracle  or MySQL database to a  PostgreSQL  compatible schema. It connects your  Oracle  database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your  PostgreSQL  database. ora2pg version 20.0 software : ora2pg-20.0.tar ora2pg-20.0   https://github.com/darold/ora2pg/releases/tag/v20.0 Some Blogs about DB Migration : https://2ndquadrant.in/postgresmigration/oracle-to-postgresql-migration/ https://2ndquadrant.in/database-migration-from-oracle-to-postgres/ INSTALLATION All Perl modules can always be found at CPAN ( http://search.cpan.org/ ). Just type the full name of the module (ex: DBD::Oracle) into the search input box, it will brings you the page for download. Releases of Ora2Pg stay at SF.net ( https://sourceforge.net/projects/ora2pg/ ). Under Windows you should install Strawberry Perl ( http://strawberryperl.com/ ) and the OSes corresponding Oracle clients. I
Read more

PostgreSQL Introduction

-
PostgreSQL tutorial provides basic and advanced concepts of SQL. Our PostgreSQL tutorial is designed for beginners and professionals. PostgreSQL is an opens-source object-relational database management system (ORDBMS). Our PostgreSQL tutorial includes all topics of PostgreSQL language such as create database, create table, drop database, drop table, select database, select table, insert record, update record, delete record, triggers, functions, procedures, cursors etc. There are also given PostgreSQL interview questions and quizzes to help you better understand the PostgreSQL language. Prerequisite: Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language. you must have the basic knowledge of SQL Problem: We assure that you will not find any problem in this PostgreSQL tutorial. But if there is any mistake
Read more