Sadan's Oracle dba Blog

 # xhost + # su - oracle export DISPLAY=:0.0 echo $DISPLAY export DISPLAY=IP address of the graphical terminal:0.0

 /sbin/mkfs.ext4 -L /ora01 /dev/sdi1 mkdir /ora01 create the partions  fdisk -l n p wq mount /dev/sdi1 /ora01 mount  vi /etc/fstab add below line  LABEL=/ora01            /ora01              ext4    defaults        1 2 on other node: /dev/sdi1

  Step-by-Step Example Let's assume: You want to log blocking sessions into a table. Later, you could extend this to automatically kill sessions. 🔹 1. Create the Logging Table sql Copy Edit BLOCKING_SESSIONS_LOG CREATE TABLE blocking_sessions_log (     log_time         TIMESTAMP,     blocker_sid      NUMBER,     blocker_serial#  NUMBER,     blocker_username VARCHAR2(30),     blocked_sid      NUMBER,     blocked_username VARCHAR2(30) ); SQL> set lines 200 pages 200; SQL> col OWNER for a20; SQL> col TABLE_NAME for a20; SQL> col TABLESPACE_NAME for a20; OWNER                TABLE_NAME                                         TABLESPACE_NAME -------------------- -------------------------------------------------- -...

  1:- Create a backup of spfile/initfile (it is always a good practice to create a backup before any change on the DB):  create pfile='/tmp/initorcl1.ora' from spfile;    2:- Create WALLET directory in both nodes:    /u01/app/oracle/product/19.3.0/dbhome_1    mkdir /u01/app/oracle/product/19c/dbhome_1/admin/orcl/WALLET  created on Ndoe01  mkdir /u01/app/oracle/product/19c/dbhome_1/admin/orcl/WALLET  created on Ndoe02    3:- Update sqlnet.ora with wallet location (in all nodes):      ENCRYPTION_WALLET_LOCATION=  (SOURCE=   (METHOD=FILE)    (METHOD_DATA=     (DIRECTORY=/u01/app/oracle/product/19c/dbhome_1/admin/orcl/WALLET)))  [oracle@ggrac01 admin]$ scp sqlnet.ora ggrac02:/u01/app/oracle/product/19.3.0/dbhome_1/network/admin sqlnet.ora                                        ...

 ACFS file system creation using Manual Method. Steps to create ACFS file system Step 1: List the disks using the below command. col name for a30; SELECT NAME, VALUE, GROUP_NUMBER FROM v$asm_attribute where name like '%com%'; Step 2: Create the oracleasm disk using the below command. #oracleasm create disk ACFS  /dev/mapper/DISK014_ARCH_4T1 Step 4: Verify the header status of the path is provisioned using the below query. col PATH for a50; select path, group_number group_#, disk_number disk_#, mount_status,header_status, state, total_mb, free_mb from v$asm_disk order by group_number; SQL> SELECT NAME,VALUE,GROUP_NUMBER FROM v$asm_attribute where name like '%com%'; CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK ‘/dev/oracleasm/disks/ARCH03’ NAME FRA_01 ATTRIBUTE compatible.asm’ = ‘12.2.0.1.0’, ‘compatible.rdbms’=’12.2.0.1.0’ ,‘compatible.advm’ = 12.2.0.1.0’; Step 7: Verify the diskgroup has been created using the below query. SQL> SELECT name, free_mb, total_mb, ((t...

 All steps will be carried out on one of the node (Prod1) and later we will clone to other nodes or machines: Install the system Linux prerequisites:  The package oracle-database-preinstall-19c contains all the prerequisites on Oracle Linux using the Oracle Unbreakable Enterprise Kernel (UEK). yum install -y oracle-database-preinstall-19c yum install -y oracleasm-support sysctl -p crosscheck >>> cat  /etc/sysctl.conf  Group Creation: – groupadd -g 5001 oinstall groupadd -g 5002 dba groupadd -g 5003 oper groupadd -g 5004 asmadmin groupadd -g 5005 asmdba groupadd -g 5006 asmoper User Creation: – useradd -u 5007 -g oinstall -G dba,oper,asmdba oracle useradd -u 5008 -g oinstall -G asmadmin,asmdba,asmoper,dba grid usermod -g oinstall -G dba,oper,asmdba oracle usermod -g oinstall -G asmadmin,asmdba,asmoper,dba grid passwd oracle passwd grid Add below entries in /etc/security/limits.conf file which will detine limits  oracle   soft   nofile...

 [root@Node1 ~]#  [root@Node1 ~]# cat /etc/resolv.conf  # Generated by NetworkManager search oracle.com nameserver 192.168.0.1 options timeout:1 options attempts:5 [root@Node1 ~]#  [root@Node1 ~]#  [root@Node1 ~]#  [root@Node1 ~]#  [root@Node1 ~]# cat /etc/named.conf // named.conf // // Provided by Red Hat bind package to configure the ISC BIND named(8) DNS // server as a caching only nameserver (as a localhost DNS resolver only). // // See /usr/share/doc/bind*/sample/ for example named configuration files. // // See the BIND Administrator’s Reference Manual (ARM) for details about the // configuration located in /usr/share/doc/bind-{version}/Bv9ARM.html options { listen-on port 53 { 127.0.0.1; 192.168.0.1; }; listen-on-v6 port 53 { ::1; }; directory "/var/named"; dump-file "/var/named/data/cache_dump.db"; statistics-file "/var/named/data/named_stats.txt"; memstatistics-file "/var/named/data/named_mem_stats.txt"; recursing-file "/var/named/d...