Posts by M Ranesh

Configuration of Bash_profile

Configuration of Bash_profile   TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export ORACLE_SID=clone export ORACLE_HOME=/u01/oracle/clone/12.1.0 export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib SSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL THREADS_FLAG=native; export THREADS_FLAG…

Read More

Oracle 12c-Step by Step Manual Data Guard Switchover

Oracle 12c-Step by Step Manual Data Guard Switchover Prepared by Ranesh Details Primary Side  Standby Side Server Name Primary Pysical Standby DB Name Warangal Mumbai IP Adresses 192.168.182.128 192.168.182.129 Step 1:- Check database role…

Read More

Roll Forward Physical Standby Database using RMAN incremental backup

Roll Forward Physical Standby Database using RMAN incremental backup   Current_scn from primary database and standby database.       PRIMARY [oracle@ranesh ~]$ cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 192.168.182.130…

Read More

Oracle 12c Physical Standby Database Creation using Rman

Oracle 12c Physical Standby Database Creation using Rman     Prerequisites for standby built for primary side. Ø  Configure network files for both side (Primary,standby). Ø  Parameter change in primary side. Ø  Copy the Password file from primary…

Read More

ROLLBACK—-Oracle Database Patch

ROLLBACK [oracle@ranesh 30886680]$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/app/oracle/product/12.2.0.1/db_1 Central Inventory : /u01/app/oraInventory    from           : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc OPatch version    : 12.2.0.1.19 OUI version       : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-02-18_15-43-47PM_1.log Verifying…

Read More

EBS–12.1.1 Installation.

EBS Installation 12.1.1   Step- Edit  Yum.repository  and keep ol6_latest and ol6_addon  ebabled=1 cd /etc/yum.repos.d yum install wget.x86_64 wget http://public-yum.oracle.com/public-yum-ol6.repo vi public-yum-ol6.repo ([ol6_latest] name=Oracle Linux $releasever Latest ($basearch) baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1 [ol6_addons] name=Oracle…

Read More

EBS UPGRADE –12.1.1 TO 12.1.3 —

[applmgr@ebs applmgr]$ sqlplus apps/apps—connect to applmgr and apps/apps SQL*Plus: Release 10.1.0.5.0 – Production on Tue Mar 31 22:35:56 2020 Copyright (c) 1982, 2005, Oracle.  All rights reserved. Connected to: Oracle Database…

Read More

Up-grading 12c to 19c

Steps For Upgrading Oracle Database To 19c Using DBUA Database  preinstall 19c 19c software install Pre-upgrade check Run the pre-upgrade fixup script Run utlrp.sql ( to compile invalid objects) Check database component status To enable restore , in case…

Read More

CLOUD EBS INSTALLTION

CLOUD EBS INSTALLTION   login as: opc Authenticating with public key “rsa-key-………” from agent Last login: Thu Jan  07:59:41 2020 from 103.57……129  [root@document ~]# df -h Filesystem Size Used Avail…

Read More

ORA-10458 ,ORA-01196,ORA-01110

FAILURE IN PRIMARY DATABASE:  ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: ‘/u01/app/oracle/oradata/prime/system01.dbf’ SQL> startup ORACLE instance…

Read More