resize or extend /u01 on exadata

First find how much space available to extend

[root@xxx-bac02 ~]# vgdisplay -s
  "VGExaDb" 3.27 TiB  [185.00 GiB used / 3.09 TiB free]

Here we have 3.09TB free

First check the existing size of /u01

df -kh |grep u01

/dev/mapper/VGExaDb-LVDbOra1                  99G   27G   67G  29% /u01

Currently it is 100GB

I want to increase to 150GB

So here are the commands

lvresize -L +50G /dev/mapper/VGExaDb-LVDbOra1

resize2fs  /dev/mapper/VGExaDb-LVDbOra1

Now if you recheck the size again

df -kh |grep u01

/dev/mapper/VGExaDb-LVDbOra1                 148G   36G  105G  26% /u01

**********************************************

For XFS file system on new exadata machines

determine if it xfs or ext etc

[root@nasipedwdb-bac02 ~]# df -Th |grep /

Filesystem                                  Type      Size  Used Avail Use% Mounted on

/dev/mapper/VGExaDb-LVDbSys1                xfs        15G   12G  3.3G  79% /

lvresize -L +50G /dev/mapper/VGExaDb-LVDbSys1

xfs_growfs -d /

[root@nasipedwdb-bac02 ~]# df -kh

Filesystem                                   Size  Used Avail Use% Mounted on

/dev/mapper/VGExaDb-LVDbSys1                  65G   12G   54G  19% /

*********************************************

creating swapspace on exadata

[root@n dev]# swapon -s

Filename                                Type            Size    Used    Priority

/dev/dm-4                               partition       16777212        0       -2

Add 110gb swap file

dd if=/dev/zero of=/swapspace bs=1M count=112640

mkswap /swapspace

chmod 600 swapspace

swapon /swapspace

 swapon -s

Filename                                Type            Size    Used    Priority

/dev/dm-4                               partition       16777212        0       -2

/swapspace                              file    115343356       0       -3

[root@ /]# free -g

              total        used        free      shared  buff/cache   available

Mem:           1007         382         341          48         283         555

Swap:           125           0         125

Set persistent permissions across reboot in linux and UDEV rules for ASM disks

For asm disks owner should be oracle:dba

You need to setup udev rules or edit rc.local 

else after reboot permissions will change back to root

There are 2 methods to do it. Oracle recommends setting up UDEV

Here is alternative to udev

vi /etc/rc.local

#!/bin/bash

# THIS FILE IS ADDED FOR COMPATIBILITY PURPOSES

#

# It is highly advisable to create own systemd services or udev rules

# to run scripts during boot instead of using this file.

#

# In contrast to previous versions due to parallel execution during boot

# this script will NOT be run after all other services.

#

# Please note that you must run 'chmod +x /etc/rc.d/rc.local' to ensure

# that this script will be executed during boot.

touch /var/lock/subsys/local

chown oracle:dba /dev/mapper/mpatha

chown oracle:dba /dev/mapper/mpathb

chown oracle:dba /dev/mapper/mpathc

chmod 660 /dev/mapper/mpatha

chmod 660 /dev/mapper/mpathb

chmod 660 /dev/mapper/mpathc

After that check status of service. If its not enabled enable it

systemctl status rc-local.service

systemctl enable rc-local

systemctl start rc-local

2nd method using UDEV

#############preparing disks for ASM

/usr/lib/udev/scsi_id -g -u -d /dev/sdc

3624a93707784b3a3c17b437c00011074

/usr/lib/udev/scsi_id -g -u -d /dev/sdd

3624a93707784b3a3c17b437c0001106f

/usr/lib/udev/scsi_id -g -u -d /dev/sde

3624a93707784b3a3c17b437c00011071

vi /etc/scsi_id.config

options=-g

wq!

vi /etc/udev/rules.d/99-asmdevices.rules

KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="3624a93707784b3a3c17b437c00011074", SYMLINK+="asm-disk1", OWNER="oracle", GROUP="dba", MODE="0660"

KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="3624a93707784b3a3c17b437c0001106f", SYMLINK+="asm-disk2", OWNER="oracle", GROUP="dba", MODE="0660"

KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="3624a93707784b3a3c17b437c00011071", SYMLINK+="asm-disk3", OWNER="oracle", GROUP="dba", MODE="0660"

##############Load rules

/sbin/partprobe /dev/sdc1

/sbin/partprobe /dev/sdd1

/sbin/partprobe /dev/sde1

##################Test rules

udevadm test /block/sdc/sdc1

udevadm test /block/sdd/sdd1

udevadm test /block/sde/sde1

#################Restart UDEV Service

udevadm control --reload-rules

check permissions

cd /dev

ls -lHL /dev/tas*

chown -R oracle:dba asm-disk1

chown -R oracle:dba asm-disk2

chown -R oracle:dba asm-disk3

chmod 660 asm-disk1

chmod 660 asm-disk2

chmod 660 asm-disk3

ls -lHL /dev/asm*

set password not to expire linux

To check current password expire date

# chage -l tibero
Last password change                                    : Jul 03, 2019
Password expires                                        : Oct 02, 2019
Password inactive                                       : never
Account expires                                         : never
Minimum number of days between password change          : 0
Maximum number of days between password change          : 91
Number of days of warning before password expires       : 7

To change

# passwd -x -1 tibero

Adjusting aging data for user tibero.

passwd: Success

Verify change again

# chage -l tibero

Last password change                                    : Jul 03, 2019

Password expires                                        : never

Password inactive                                       : never

Account expires                                         : never

Minimum number of days between password change          : 0

Maximum number of days between password change          : -1

Number of days of warning before password expires       : 7

Oracle database and EMC network MML error

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 04/18/2019 11:00:14
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2



You need to link below

$ cd $ORACLE_HOME/lib

$ ln -s /usr/lib/libnsrora.so libobk.so

Network ACL error after 12c database upgrade

begin
    dbms_network_acl_admin.append_host_ace (
    host=>'*',
    lower_port => 1,
    upper_port => 65535,
         ace=> sys.xs$ace_type( privilege_list=>sys.XS$NAME_LIST('JDWP') ,
                                principal_name=>'HMA_TM_PROD',
                                principal_type=>sys.XS_ACL.PTYPE_DB));
end;
/


BEGIN
  DBMS_NETWORK_ACL_ADMIN.append_host_ace (
    host       => '*',
    lower_port => 1,
    upper_port => 65535,
    ace        => xs$ace_type(privilege_list => xs$name_list('connect'),
                              principal_name => 'HMA_TM_PROD',
                              principal_type => xs_acl.ptype_db));
END;
/

*************************************
send test email from database

Create proc

CREATE OR REPLACE PROCEDURE send_mail (p_to        IN VARCHAR2,
                                       p_from      IN VARCHAR2,
                                       p_message   IN VARCHAR2,
                                       p_smtp_host IN VARCHAR2,
                                       p_smtp_port IN NUMBER DEFAULT 25)
AS
  l_mail_conn   UTL_SMTP.connection;
BEGIN
  l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);
  UTL_SMTP.helo(l_mail_conn, p_smtp_host);
  UTL_SMTP.mail(l_mail_conn, p_from);
  UTL_SMTP.rcpt(l_mail_conn, p_to);
  UTL_SMTP.data(l_mail_conn, p_message || UTL_TCP.crlf || UTL_TCP.crlf);
  UTL_SMTP.quit(l_mail_conn);
END;
/

Add privs


BEGIN
  DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'send_mailx.xml',
    description  => 'Purpose of the acl is to send mail',
    principal    => 'sravan',
    is_grant     => TRUE,
    privilege    => 'connect',
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);

   DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'send_mailx.xml',
    host        => '*',
    lower_port  => 1,
    upper_port  => 9999);

  COMMIT;
END;
/


Send
BEGIN
  send_mail(p_to        => 'xxx10563@xxx.local',
            p_from      => 'xxx-dba-alerts@xxx.local',
            p_message   => 'This is a test message.',
            p_smtp_host => '10.120.xx.xx');
END;
/

OEM 12c Unable To Complete Network Operation Against My Oracle Support

cd /opt/app/oracle/gc_inst/user_projects/domains/GCDomain/bin/


cp setDomainEnv.sh setDomainEnv.sh.old

Stop the OMS and web tier:

emctl stop oms



vi setDomainEnv.sh


Find

JAVA_OPTIONS="${JAVA_OPTIONS} ${JAVA_PROPERTIES} -Dwlw.iterativeDev=${iterativeDevFlag} -Dwlw.testConsole=${testConsoleFlag} -Dwlw.logErrorsToConsole=${logErrorsToConsoleFlag}"

Change to:

JAVA_OPTIONS="${JAVA_OPTIONS} ${JAVA_PROPERTIES} -Dwlw.iterativeDev=${iterativeDevFlag} -Dwlw.testConsole=${testConsoleFlag} -Dwlw.logErrorsToConsole=${logErrorsToConsoleFlag} -Dcom.sun.net.ssl.enableECC=false"

Restart the OMS and web tier.:

emctl start oms


rollback for



Fix MOS oracle unable to connect on hisipoem


/opt/app/oracle/gc_inst/user_projects/domains/GCDomain/bin/


cp setDomainEnv.sh.old setDomainEnv.sh

sql profile syntax for force match

execute dbms_sqltune.accept_sql_profile(task_name =>'H43369.4496173495', task_owner => 'xxxx',replace => TRUE, force_match => TRUE);