29 July 2013

sqlplus: error while loading shared libraries


Issue
sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied

Solution
1.
                [root@linux_pc ~]# cat /etc/selinux/config
                # This file controls the state of SELinux on the system.
                # SELINUX= can take one of these three values:
                #       enforcing - SELinux security policy is enforced.
                #       permissive - SELinux prints warnings instead of enforcing.
                #       disabled - SELinux is fully disabled.
                SELINUX=enforcing
                # SELINUXTYPE= type of policy in use. Possible values are:
                #       targeted - Only targeted network daemons are protected.
                #       strict - Full SELinux protection.
                SELINUXTYPE=targeted

                # SETLOCALDEFS= Check local definition changes
                SETLOCALDEFS=0
                [root@linux_pc ~]# cp /etc/selinux/config /etc/selinux/config.bak
                [root@linux_pc ~]# vi /etc/selinux/config
                [root@linux_pc ~]# cat /etc/selinux/config
                # This file controls the state of SELinux on the system.
                # SELINUX= can take one of these three values:
                #       enforcing - SELinux security policy is enforced.
                #       permissive - SELinux prints warnings instead of enforcing.
                #       disabled - SELinux is fully disabled.
                SELINUX=disabled
                # SELINUXTYPE= type of policy in use. Possible values are:
                #       targeted - Only targeted network daemons are protected.
                #       strict - Full SELinux protection.
                SELINUXTYPE=targeted

2.
                echo 0 >/selinux/enforce

25 July 2013

PRVF-0002 : Could not retrieve local nodename

Issue:

While Oracle 12c Installation on Linux (my case OEL6 update 4) you could get an error.

Solution 1:

1. check hostname:
cat /etc/sysconfig/network | grep HOSTNAME
HOSTNAME = test.localdomain

2. check hosts:
cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6


3. change /etc/hosts like:
127.0.0.1 test test.localdomain
::1 test test.localdomain


4. Run installer

Solution 2:

1. setup system variable like

$ ORACLE_HOSTNAME=test.localdomain
$ export ORACLE_HOSTNAME