Posts

How to resolve "TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact" | Karan Rajpoot

Image
         TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Error: - "TNS-12547: TNS: lost contact TNS-12560: TNS: protocol adapter error TNS-00517: Lost contact" Cause: - This error occurs when loopback entries have been missed in the /etc/hosts file. Solution: - To resolve this error you need to put the loopback entries in the /etc/hosts file. Example: -  [oracle@prod bin]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-APR-2019 22:08:16 Copyright (c) 1991, 2013, Oracle.  All rights reserved. Starting /u02/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u02/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /u02/app/oracle/diag/tnslsnr/prod/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod.radical.com)(PORT=1521))) C

How to resolve "Destination Host Unreachable" Issue in Linux | Karan Rajpoot

Image
                                                        Destination Host Unreachable in Linux Error: -  icmp_seq=2 Destination Host Unreachable Cause: - When you are trying to ping Linux machine from one node to another node then you may face issue "destination host unreachable", the reason behind this issue is the selection of network while creation of Linux machine. Solution: - To resolve this issue you need to select the proper network selection. Example: - In this case, there are two machine prod and dr, When I was tried to ping dr machine from prod then I faced below issue. I checked so many things like firewall, etc/hosts file entries and so on, but didn't get resolution then, at last, I checked my network configuration and found it was set as NAT. I have changed the Network from NAT to the host-only adapter and then tried again finally, that issue has been resolved. Before changing the network from NAT to Host-only adapter. [root@prod Desk

How to Install Linux on Oracle Virtual Box

Image
                          Below are the steps to Install Linux on Oracle Virtual Box Step 1) First you need to download the Oracle Virtual Box from the link . Step 2) Select New Option to choose the name, type, and version of the Operating system. Step 3) Select the Memory as per your requirement. Step 4) Choose the Hard disk options as Create a Virtual Hard disk Now. Step 5) Choose the Hard disk file type as VDI (Virtual Disk Image). Step 6) Select Storage on a physical hard disk as Dynamically allocated or  Fixed size as per your requirement. Step 7) Select the File Location and Size as per your requirement. Step 8) Now go to the Storage tab and select the ISO image file which needs to be installed. Step 9) Now Click on the Start tab  to initialize the installation. Step 10) Now click on the Install or Upgrade an existing system to proceed further in the installation. Step 11) Click on the Skip tab to skip the med

How To Configure Step By Step Oracle DGMGRL Utility | Karan Rajpoot

In my previous blog, We saw the configuration steps of the data guard setup . In this blog, we will see the configuration of DGMGRL Oracle utility. let's start the configuration. Step 1) First we should check the DB name, DB unique name, open_mode, database_role of both the servers. Primary Server: - SQL>  select name, db_unique_name,open_mode,database_role, flashback_on from v$database; NAME   DB_UNIQUE_NAME OPEN_MODE       DATABASE_ROLE    FLASHBACK_ON --------- ------------------------------ -------------------- ---------------- ------------------ PROD   prod READ WRITE       PRIMARY        YES Standby Server: - SQL> select name, db_unique_name,open_mode,database_role, flashback_on from v$database; NAME   DB_UNIQUE_NAME OPEN_MODE       DATABASE_ROLE    FLASHBACK_ON --------- ------------------------------ -------------------- ---------------- ------------------ PROD   dr MOUNTED       PHYSICAL STANDBY YES Step 2) Now test th

Oracle Physical Standby Dataguard in 11g | Karan Rajpoot

Required Parameters to configure the Dataguard setup:- DB_NAME= It should be the same on the primary and standby side. DB_UNIQUE_NAME= Must be different on the primary and dr side. LOG_ARCHIVE_CONFIG= This parameter includes db_unique_name which is the part of data guard configuration. LOG_ARCHIVE_DEST_n=   It defines the local and remote archive log file location. LOG_ARCHIVE_DEST_STATE_n=  It defines the state of archiving (enable or differ). REMOTE_LOGIN_PASSWORDFILE=  it should be in EXCLUSIVE mode. FAL_SERVER= Use for archive log gap resolution (required only in physical standby server). DB_FILE_NAME_CONVERT=  It is required when directory structure is needed to be in the different datafile. LOG_FILE_NAME_CONVERT=     It is required when directory structure is needed to be in the different logfile. STANDBY_FILE_MANAGEMENT=  It helps to create the file automatically on the standby server. In this demonstration, I am using the below

Oracle SQL Developer Installation in Linux | Karan Rajpoot

Image
                                      Steps to Install Oracle SQL Developer  Step 1) You need to download the SQL developer rpm and java development kit rpm of the version as per your requirement. Links to download rpm's: - Java development kit: -  https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html SQL developer: -  https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Step 2) Login to your Linux Machine and install both the rpm's. [root@dr sf_Oracle_DBA_Softwares]# rpm -ivh sqldeveloper-18.4.0-376.1900.noarch.rpm Preparing...                ########################################### [100%]    1:sqldeveloper           ########################################### [100%] [root@dr sf_Oracle_DBA_Softwares]#  [root@dr sf_Oracle_DBA_Softwares]# rpm -ivh jdk-8u201-linux-x64.rpm warning: jdk-8u201-linux-x64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Preparing.