Wednesday, July 25, 2018


Linux NFS ( Network File Sharing) Method

NFS Config in Red Hat Portal

1. Put an entry to following file, which are going to share

>vi /etc/exports

/media/usb  *(rw)

Entry - /arcive/   *(rw)     

Note: r- read w- write


2. Restart the Network File Sharing service.

>service nfs restart

Or

>service nfs stop
>service nfs start



3. Destination Computer

>mount 192.168.6.19:/archive  /t

Note: t - local machine folder

>unmount /t





Tuesday, July 24, 2018


How to Disable Firewall on RHEL 6

In this post, i will show how to disable Linux Iptables Firewall on Red Hat Enterprise Linux 6 (RHEL 6). A Linux firewall on RHEL 6 can be configured to filter every network packet that passes into or out of network. In some cases such as testing and development environment, you will need to disable the iptables firewall. To disable linux iptables firewall on RHEL6, you just to execute the following commands :
1. Before stop the iptables, save the firewall setting using the following command :
[root@rhel6 ~]# service iptables save
iptables: Saving firewall rules to /etc/sysconfig/iptables:[  OK  ]
2. Stop iptables using the following command :
[root@rhel6 ~]# service iptables stop
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                               [  OK  ]
3. To ensure that iptables will not started at boot time, pleas execute this chkconfig command :
[root@rhel6 ~]# chkconfig iptables off
4. If IPv6 firewall is enabled, please disable it using the following commands :
[root@rhel6 ~]# service ip6tables save
ip6tables: Saving firewall rules to /etc/sysconfig/ip6table[  OK  ]
[root@rhel6 ~]# service ip6tables stop
ip6tables: Flushing firewall rules:                        [  OK  ]
ip6tables: Setting chains to policy ACCEPT: filter         [  OK  ]
ip6tables: Unloading modules:                              [  OK  ]
[root@rhel6 ~]# chkconfig ip6tables off

Install Oracle Linux 6.9 OS Using Local or Remote Media

This procedure describes how to install the Oracle Linux 6.9 OS from local or remote media. The procedure assumes that you are booting the Oracle Linux installation media from one of the following sources:
  • Oracle Linux 6.9 DVD set
  • Oracle Linux 6.9 ISO DVD image (network repository)
If you are booting the installation media from a PXE environment, see Installing an Operating System Using PXE Network Boot for instructions.
  1. Access the host console.
    For instructions, see Selecting the Console Display.
  2. Ensure that the installation media is available to boot.
    For instructions, see Selecting the Boot Media Option.
  3. Reset or power on the server.

    Note -  The next event occurs very quickly; therefore, be ready to press F8 to display the BBS Popup. Watch carefully for messages as they appear on the screen for a brief time. You might want to enlarge the size of your screen to eliminate scroll bars.
  4. On the BIOS screen, press F8 to specify a temporary boot device for the Linux OS installation.
  5. On the Please Select Boot Device menu, select an option according to the Linux OS media installation method you elected to use, and press Enter.
    For example, to use the Oracle ILOM Remote System Console Plus application delivery, select [UEFI]USB:VIRTUAL:Remote Iso CDROM2.04.
  6. On the Booting Oracle Linux Server 6.9 boot screen, press Enter or allow the screen to time out.
  7. In the Disc Found dialog box, if this is the first time that you are doing an install from this media, consider selecting OK to test the media; otherwise, select Skip and press Enter.
  8. On the Oracle Linux 6 splash screen, scroll to the bottom, and click Next.
  9. Follow the on-screen prompts to complete the Oracle Linux installation up to the point where you create partitions.
    For instructions on completing the Oracle Linux 6.9 installation up to the point where you create partitions, refer to the Oracle Linux 6 installation documentation at https://docs.oracle.com/cd/E37670_01/.
  10. To create partitions, for each mount point, use the following file system type and size.
    Mount Point
    File System Type
    Size (MB)
    /boot/efi
    EFI System Partition
    200
    /
    ext4
    20000
    None
    swap
    16384
  11. Format the disk. To recover and reformat the disk without aborting the install, click the keyboard Back button on the install screen several times to return to the initial Oracle Linuxsplash screen and perform these steps:
    1. To start the recovery shell, type Ctrl+Alt+F2.
    2. To reformat the disk in GPT format or MBR format for this installation, enter the following shell commands:
      anaconda root@localhost /]# parted /dev/sdb
      GNU Parted 2.1
      Using /dev/sda
      Welcome to GNU Parted! Type ???help' to view a list of commands.
      (parted) p
      Model: HITACHI H101860SFSUN600G (scsi)
      Disk /dev/sda: 600GB
      Sector size (logical/physical): 512B/512B
      Partition Table: msdos (or gpt for Legacy BIOS Boot Mode)
      Number Start End Size Type File system Flags
      1 1049kB 21.5GB 21.5GB primary ext2
      (parted) mklabel
      New disk label type? gpt (or msdos for Legacy BIOS Boot Mode)
      Warning: The existing disk label on /dev/sda will be destroyed and all data will be
      lost.
      Do you want to continue?
      Yes/No? yes
      (parted) p
      Model: HITACHI H101860SFSUN600G (scsi)
      Disk /dev/sda: 600GB
      Sector size (logical/physical): 512B/512B
      Partition Table: gpt
      Number Start End Size File system Name Flags
      (parted) g
      Information: You may need to update /etc/fstab.
      anaconda root@localhost /]#
    3. Press Ctrl+Alt+F6 to return to the graphical installation screen and continue the installation from the point of creating a partition (go to Step 10).

    Note -  In most cases, the values that you entered for this installation were saved, so you do not have to reenter them.
  12. On the Install boot loader screen, select Install boot loader on /dev/sdb1, and click Next.
  13. On the Select Server screen, for the purposes of this sample installation, accept the Basic Server default option and click Next.
  14. After the installation completes, reboot the installation.
  15. Press F2 to access the BIOS Setup Utility so that you can set the server to boot from the operating system you just installed.
  16. Verify that the boot entry name you created (in this case, [Oracle Linux]) is listed as the first option in the UEFI Boot Option Priority field.
  17. Press F10 to exit the BIOS Setup Utility and reboot the installation.
  18. Press any key to display the GNU GRUB menu.
  19. Select Oracle Linux Server Red Hat Compatible Kernel (2.6.32-696.el6.x86_64) and press Enter.
  20. Log in to Linux and perform these steps:
    1. Configure the network connection.
    2. Verify that the Linux Internet connection is active.
  21. Confirm that the UEK entry appears in: /etc/yum.repos.d/public-yum-ol6.repo
  22. Update to Oracle Unbreakable Kernel Release 4 by running yum update kernel-uek or yum update.
  23. When the update is complete, reboot the server with the reboot command to start the server with the new Oracle Unbreakable Enterprise Kernel.

Wednesday, July 11, 2018


Make Oracle password never expire

Solution for making a password never expire:

SQL> connect sys/secret_password as sysdba;

SQL> alter user sysman account unlock ;

-- SQL> alter user DBUSER identified by newpa$$word;


Next, change the profile limit to unlimited.


SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;


SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;

Check the password expiry date

 
SQL> select username, account_status, EXPIRY_DATE from dba_users where username='PRAMUDITHA';


 
USERNAME                       ACCOUNT_STATUS               EXPIRY_DATE
------------------------------ ---------------------------- -------
BACMONIT                       OPEN                         UNLIMITED







Tuesday, July 10, 2018



E-Business Suite Applications Manager Rapidclone Script Adcfgclone Fails with Error 'RC-50014: Fatal: Execution of AutoConfig was failed Raised by oracle.apps.ad.clone.ApplyDBTechStack' And AC-00423 With File adcrdb.sh Missing (Doc ID 549872.1)

APPLIES TO:

Oracle Applications Manager - Version 11.5.10.2 to 12.0.6 [Release 11.5.10 to 12]
Information in this document applies to any platform.

SYMPTOMS

While running the command 'adcfgclone.pl dbTier' on the target E-Business Suite instance, the following error may occur:

AC-00423: Template file: <DB ORACLE_HOME>/appsutil/template/adcrdb.sh missing from file system.
Raised by oracle.apps.ad.autoconfig.InstantiateFile

[INSTANTIATE PHASE]
AutoConfig could not successfully instantiate the following files:
Directory: <DB ORACLE_HOME>/appsutil/install/XXX_YYYY
adcrdb.sh INSTE8

AutoConfig is exiting with status 1
RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDBTechStack

CAUSE

The template adcrdb.sh is missing from the target "<DB $ORACLE_HOME>/appsutil/template"

SOLUTION

To implement the solution test the following steps in a development instance and then migrate accordingly:

1. copy the missing 'adcrdb.sh' template from the Source to the Target Instance:
Source Location :
<DB $ORACLE_HOME>/appsutil/template
Target Location :
<DB $ORACLE_HOME>/appsutil/template
2. Change ownership and permission of adcrdb.sh file to match with the other templates, which resides in the template directory.
3. Rerun the command 'adcfgclone dbTier' on the target instance and confirm the RC-50014 error no longer occurs.

Tuesday, July 3, 2018


Installing the Unbreakable Enterprise Kernel

If the installed system is configured to use the Red Hat Compatible Kernel and the Unbreakable Enterprise Kernel (UEK) is not installed, you can use yum to install the kernel-uek package:
# yum install kernel-uek
Installing kernel-uek also installs the kernel-uek-firmware package on which it depends, and configures the UEK as the default kernel in /etc/grub.conf. Reboot the system to use this kernel.

  RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...