Posts

Oracle Database 19c Installation on Linux

Download Oracle 19c Software from the Oracle Edelivery Install Operating system (oracle Linux 7) on the target Machine after installing we need to do some pre requiste for installing Oracle database 1. vi /etc/hosts IPadress full_machine_name machine_name 192.168.2.2 db_test.com db_test 2.Install the required RPM we will do it by enabling internet on the target machine so that all the rpm downloaded and install automaticaly yum install -y oracle-database-preinstall-19c yum update -y 3 vi /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 run the following commond to propogate the changes to kernel /sbin/sysc

step by step How to make Oracle Database DR site as PR Site and vice versa in Oracle

How to make oracle database DR site as PR Site and vice versa in Oracle step by step PR Site DR Site S.no alter system job_queue process=0; alter system job_queue process=0 scope =both SID='*'; 1 emctl stop dbconsole emctl stop dbconsole 2 select 'APPLIED', max(sequence#), thread# from v$archived_log where APPLIED='YES' group by thread#   union all                select 'ARCHIVED', max(sequence#),thread# from v$archived_log where archived='YES'group by thread# order by 2; 3 check the status of both pr and dr   select SWITCHOVER_STATUS from v$database; select SWITCHOVER_STATUS from v$database; 4 stop the instances only leave one instance which need to become DR                                                                                                            

Oracle critical error alert in EM

Image

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Dumps

Oracle DR Drill

Oracle DR Drill How to make DR site as PR Site and vice versa in Oracle

Oracle Rac Node Removal

STEP BY STEP ORACLE 11G R2 NODE REMOVAL Prepared by: Hayat Mohammad Khan (DBA) hayathk@hotmail.com   - +92-333-5193460 Maroof Ud Din (DBA) maroofuddinkhan@yahoo.com   Saturday, March 01, 2014 Disclaimar The steps performed in below documents are our own and do not necessarily reflect the views of Oracle Corporation. Steps may vary to actual activity, environment, platform, and database and grid version and patches. Assumptions DB Version Oracle 11.2.0.4 two nodes cluster OS Version IBM AIX 6.1 Cluster File System IBM GPFS 3.4 DB Nodes Names SETTDB1, SETTDB2 DB OS Names SETT1,SETT2 DB-Home /oracle/app/grid/product/11.2.0.3/dbhome_3 Grid-Home /oracle/app/11.2.0.3/grid_2/ Homes Sharing Status Not Shared Recommendations Others Node1 refered to remaining node, Node2 refered to deleting node Othe