How to Modifying Language and Time Zone Preferences in ERP R12

To change display and time zone preferences:

Incorrect time showing in Application.

       1. Sign in to the application.
       2. Click the Preferences option from the logged-in user name menu at the top of the dashboard.

      This displays the Preferences page.
      3. Select your preferred language from the Language list.

    4. Select the country and the related time zone from the Timezone list.

     5. Click Apply to save your changes.

How to check the lock status of any user account and change the Password policy in Linux

1. To check User lock status

[root@oracle ~]# chage -l mysql
Last password change                                    : Jul 26, 2018
Password expires                                        : never
Password inactive                                       : never
Account expires                                         : never
Minimum number of days between password change          : -1
Maximum number of days between password change          : -1
Number of days of warning before password expires       : -1

Find more details by using below command

[root@oracle ~]# passwd --help
Usage: passwd [OPTION...] <accountName>
  -k, --keep-tokens       keep non-expired authentication tokens
  -d, --delete            delete the password for the named account (root only)
  -l, --lock              lock the password for the named account (root only)
  -u, --unlock            unlock the password for the named account (root only)
  -e, --expire            expire the password for the named account (root only)
  -f, --force             force operation
  -x, --maximum=DAYS      maximum password lifetime (root only)
  -n, --minimum=DAYS      minimum password lifetime (root only)
  -w, --warning=DAYS      number of days warning users receives before password expiration (root only)
  -i, --inactive=DAYS     number of days after password expiration when an account becomes disabled (root only)
  -S, --status            report password status on the named account (root only)
  --stdin                 read new tokens from stdin (root only)

Help options:
  -?, --help              Show this help message
  --usage                 Display brief usage message

2. Change Password Policy using below command.

[root@oracle ~]# passwd mysql --minimum=0 --maximum=99999 --warning=7
Adjusting aging data for user mysql.
passwd: Success

[root@oracle ~]# chage -l mysql
Last password change                                    : Jul 26, 2018
Password expires                                        : never
Password inactive                                       : never
Account expires                                         : never
Minimum number of days between password change          : 0
Maximum number of days between password change          : 99999

Number of days of warning before password expires       : 7

RPM Install issue in CentOS/RHEL6

[root@oracle~]# yum install telnet
Loaded plugins: security
Setting up Install Process
No package telnet available.
Error: Nothing to do

[root@oracle yum.repos.d]# wget http://yum.oracle.com/public-yum-ol6.repo
--2018-02-08 06:56:28--  http://yum.oracle.com/public-yum-ol6.repo
Resolving yum.oracle.com... failed: Temporary failure in name resolution.
wget: unable to resolve host address “yum.oracle.com”

Ping  yum.oracle.com and add ip entry for yum.oracle.com in /etc/hosts file

[root@oracle yum.repos.d]# wget http://yum.oracle.com/public-yum-ol6.repo
--2018-02-08 06:57:48--  http://yum.oracle.com/public-yum-ol6.repo
Resolving yum.oracle.com... 23.205.118.252
Connecting to yum.oracle.com|23.205.118.252|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 9547 (9.3K) [text/plain]
Saving to: “public-yum-ol6.repo.1”

100%[=========================================================================================>] 9,547       --.-K/s   in 0s

2018-02-08 06:57:49 (63.4 MB/s) - “public-yum-ol6.repo.1” saved [9547/9547]


[root@oracle yum.repos.d]# yum install telnet
Loaded plugins: security
Setting up Install Process
Repository 'public_ol6_UEK_latest': Error parsing config: Error parsing "enabled = '$uek'": invalid boolean value
Repository 'public_ol6_UEKR3_latest': Error parsing config: Error parsing "enabled = '$uekr3'": invalid boolean value
Repository 'public_ol6_UEKR4': Error parsing config: Error parsing "enabled = '$uekr4'": invalid boolean value
Error: Cannot retrieve repository metadata (repomd.xml) for repository: epel. Please verify its path and try again

[root@oracle yum.repos.d]# uname -a
Linux dbfw08002793653d 4.1.12-103.9.4.el6uek.x86_64 #2 SMP Wed Nov 8 14:04:45 PST 2017 x86_64 x86_64 x86_64 GNU/Linux

Change enabled value in public-yum-ol6.repo file like below

[public_ol6_UEK_latest]
name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)
baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1
enabled=$uek

[public_ol6_UEKR3_latest]
name=Unbreakable Enterprise Kernel Release 3 for Oracle Linux $releasever ($basearch)
baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/UEKR3/latest/$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1
enabled=$uekr3

[public_ol6_UEKR4]
name=Latest Unbreakable Enterprise Kernel Release 4 for Oracle Linux $releasever ($basearch)
baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/UEKR4/$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1
enabled=$uekr4

to

[public_ol6_UEK_latest]
name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)
baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1
enabled=0

[public_ol6_UEKR3_latest]
name=Unbreakable Enterprise Kernel Release 3 for Oracle Linux $releasever ($basearch)
baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/UEKR3/latest/$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1
enabled=0

[public_ol6_UEKR4]
name=Latest Unbreakable Enterprise Kernel Release 4 for Oracle Linux $releasever ($basearch)
baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/UEKR4/$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1
enabled=0

Now install rpm using Yum it should run without any issues.

[root@oracle yum.repos.d]# yum install telnet
Loaded plugins: security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package telnet.x86_64 1:0.17-48.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================
 Package                            Arch                               Version                                      Repository                                     Size
==========================================================================================
Installing:
 telnet                             x86_64                             1:0.17-48.el6                                public_ol6_latest                              57 k

Transaction Summary
==========================================================================================
Install       1 Package(s)

Total download size: 57 k
Installed size: 109 k
Is this ok [y/N]: y
Downloading Packages:
telnet-0.17-48.el6.x86_64.rpm                                                                                                                    |  57 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
** Found 12 pre-existing rpmdb problem(s), 'yum check' output follows:
glib2-2.28.8-9.el6.x86_64 has missing requires of libfam.so.0()(64bit)
glib2-2.28.8-9.el6.x86_64 has missing requires of shared-mime-info
1:grub-0.97-99.0.1.el6.x86_64 has missing requires of system-logos
httpd-2.2.15-60.0.1.el6_9.6.x86_64 has missing requires of system-logos >= ('0', '7.92.1', '1')
initscripts-9.03.58-1.0.1.el6_9.2.x86_64 has missing requires of oracle-logos
less-436-13.el6.x86_64 has missing requires of groff
plymouth-0.8.3-29.0.1.el6.x86_64 has missing requires of system-logos
python-dmidecode-3.10.15-1.el6.x86_64 has missing requires of libxml2-python
python-dmidecode-3.10.15-1.el6.x86_64 has missing requires of libxml2mod.so()(64bit)
python-gudev-147.1-4.el6_0.1.x86_64 has missing requires of pygobject2
selinux-policy-3.7.19-307.0.1.el6_9.2.noarch has missing requires of m4
yum-utils-1.1.30-40.0.1.el6.noarch has missing requires of libxml2-python
  Installing : 1:telnet-0.17-48.el6.x86_64                                                                                                                          1/1
  Verifying  : 1:telnet-0.17-48.el6.x86_64                                                                                                                          1/1

Installed:
  telnet.x86_64 1:0.17-48.el6

Complete!

How to Install wget on RHEL 6

How to Install wget on RHEL 6

[root@rhel6 ~]# yum install wget -y
Loaded plugins: rhnplugin
This system is not registered with RHN.
RHN support will be disabled.
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package wget.i686 0:1.12-1.4.el6 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================
 Package          Arch             Version                   Repository                        Size
============================================================================================
Installing:
 wget             i686             1.12-1.4.el6              DVD-RHEL6-Repository             481 k

Transaction Summary
============================================================================================
Install       1 Package(s)
Upgrade       0 Package(s)

Total download size: 481 k
Installed size: 1.8 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : wget-1.12-1.4.el6.i686                                                       1/1

Installed:
  wget.i686 0:1.12-1.4.el6

Complete!



[root@dbfw08002793653d yum.repos.d]# wget http://yum.oracle.com/public-yum-ol6.repo
--2018-02-08 06:57:48--  http://yum.oracle.com/public-yum-ol6.repo
Resolving yum.oracle.com... 23.205.118.252
Connecting to yum.oracle.com|23.205.118.252|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 9547 (9.3K) [text/plain]
Saving to: “public-yum-ol6.repo.1”

100%[==========================================================================================>] 9,547       --.-K/s   in 0s

2018-02-08 06:57:49 (63.4 MB/s) - “public-yum-ol6.repo.1” saved [9547/9547]

How to clean YUM cache in CentOS / RHEL6

How to clean YUM cache in CentOS / RHEL

[root@oracle ]# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda2        24G   20G  3.7G  84% /
tmpfs           7.8G  152K  7.8G   1% /dev/shm
/dev/sda1       190M  124M   52M  71% /boot
/dev/sda4       4.7G   31M  4.4G   1% /tmp
/dev/sda5       873G  711G  118G  86% /u01

[root@oracle]cd /var/cache

[root@oracle cache]# du -sh *
4.0K    abrt-di
16K     cups
1.4M    fontconfig
4.0K    foomatic
12K     gdm
1.3M    hald
4.0K    ipmimonitoringsdrcache
4.0K    ipmiseld
4.0K    krb5rcache
92K     ldconfig
8.0K    libvirt
3.6M    man
4.0K    mod_proxy
4.0K    mod_ssl
116K    PackageKit
4.0K    powertop
12K     rpcbind
12K     tomcat6
6.8G    yum


[root@oracle]# yum clean all
Loaded plugins: refresh-packagekit, security, ulninfo
Cleaning repos: epel mysql-connectors-community mysql-tools-community mysql57-community public_ol6_UEKR4 public_ol6_addons public_ol6_latest
Cleaning up Everything

[root@oracle yum]# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda2        24G   13G   11G  55% /
tmpfs           7.8G  152K  7.8G   1% /dev/shm
/dev/sda1       190M  124M   52M  71% /boot
/dev/sda4       4.7G   31M  4.4G   1% /tmp
/dev/sda5       873G  711G  118G  86% /u01

How to resolve GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Issue:

Downloading Packages:
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle


Solution:

Run below one to get RPM-GPG-KEY-oracle file.

wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Now you should able to run yum without any issues.

Yum not installaing rpms in Cent OS

Issue:

[root@test u03]# yum install oracle-rdbms-server-12c*
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: mirror.fibergrid.in
 * centosplus: mirror.fibergrid.in
 * contrib: mirror.fibergrid.in
 * extras: mirror.fibergrid.in
 * updates: mirror.fibergrid.in
No package oracle-rdbms-server-12c* available.
Error: Nothing to do

[root@test etc]# cd yum.repos.d
[root@test yum.repos.d]# ls
CentOS-Base.repo  CentOS-Base.repo.rpmnew  CentOS-Debuginfo.repo  CentOS-fasttrack.repo  CentOS-Media.repo  CentOS-Vault.repo

Solution:

Run below one to get public-yum-ol6.repo file.

[root@test yum.repos.d]# wget http://public-yum.oracle.com/public-yum-ol6.repo
--2016-12-06 06:01:55--  http://public-yum.oracle.com/public-yum-ol6.repo
Resolving public-yum.oracle.com... , 
Connecting to public-yum.oracle.com||:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 7301 (7.1K) [text/plain]
Saving to: âpublic-yum-ol6.repoâ

100%[==============================================================================================================================>] 7,301       --.-K/s   in 0s

2016-12-06 06:01:59 (15.8 MB/s) - âpublic-yum-ol6.repoâ

Now yum install run successfully

yum install oracle-rdbms-server-12c*

====================================================================
 Package             Arch    Version      Repository    Size
====================================================================
Installing:
 oracle-rdbms-server-12cR1-preinstall                    
                    x86_64  1.0-14.el6    ol6_latest    17 k
Installing for dependencies:
 cloog-ppl      x86_64  0.15.7-1.2.el6   base           93 k
 compat-libcap1 x86_64  1.10-1           base           17 k
 compat-libstdc++-33                                     
                x86_64  3.2.3-69.el6     base           183 k
 cpp            x86_64  4.4.7-17.el6     base           3.7 M
 gcc            x86_64  4.4.7-17.el6     base           10 M
 gcc-c++        x86_64  4.4.7-17.el6     base           4.7 M
 ksh            x86_64  20120801-33.el6  base           761 k
 libaio-devel   x86_64  0.3.107-10.el6   base           13 k
 libstdc++-develx86_64  4.4.7-17.el6     base           1.6 M

Transaction Summary
====================================================================
Install      14 Package(s)

Total size: 54 M
Installed size: 164 M
Is this ok [y/N]: y