Infrastructure & DevOps Guide [Oracle, AWS, Azure, Kubernaties]

Thursday, March 3, 2016

liboraInstaller.so which might have disabled stack guard

Encounter below error while applying patch on Oracle EBS 12.1.3 10.1.3 ($IAS_ORACLE_HOME)

System Command: /u01/EP1/apps/tech_st/10.1.2/jdk/jre/bin/java -Doracle.installer.invPtrLoc=/etc/oraInst.loc -Dopatch.retry=10 -Dopatch.delay=30 -classpath "/u01/EP1/apps/tech_st/10.1.2/oui/jlib/OraInstaller.jar:/u01/EP1/apps/tech_st/10.1.2/oui/jlib/srvm.jar:/u01/EP1/apps/tech_st/10.1.2/OPatch/jlib/opatch.jar:/u01/EP1/apps/tech_st/10.1.2/oui/jlib/xmlparserv2.jar:/u01/EP1/apps/tech_st/10.1.2/oui/jlib/share.jar" opatch/CheckConflict "/u01/EP1/apps/tech_st/10.1.2/oui" "/u01/EP1/apps/tech_st/10.1.2" opatch.pl 1.0.0.0.64 16271876 "16271876 " "/u01/patch/tls_patches/16271876/etc/config/actions" "/u01/patch/tls_patches/16271876/etc/config/inventory"
Result :

Java HotSpot(TM) 64-Bit Server VM warning: You have loaded library /u01/EP1/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.
java.lang.UnsatisfiedLinkError: /u01/EP1/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so: /u01/EP1/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so: wrong ELF class: ELFCLASS32 (Possible cause: architecture word width mismatch)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary1(ClassLoader.java:1968)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1893)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1854)
at java.lang.Runtime.load0(Runtime.java:795)
at java.lang.System.load(System.java:1062)
at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.loadNativeLib(OiipuUnixOps.java:372)

Solution:
To implement the solution please execute the following steps:
1. Replace the 64 bit java by the 32 bit version of java.
2. Re-test the issue.

Tuesday, February 23, 2016

Invalid command 'SLCipherSuite'

Unable to start Oracle EBS 12.1.3 after TLS Upgrade

Issue: found below issue in httpd.conf file

/u01/EP1/inst/apps/EP1_example/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
Syntax error on line 124 of /u01/EP1/inst/apps/EP1_example/ora/10.1.3/Apache/Apache/conf/ssl.conf:
Invalid command 'SLCipherSuite', perhaps mis-spelled or defined by a module not included in the server configuration

Solution:

edit template file and change the below value

$FND_TOP/admin/template/custom/ssl_conf_1013.tmp

#SLCipherSuite ECDHE:!NULL:!3DES:!RC4:+aRSA:AES128-SHA

SSLCipherSuite ALL:!ADH:!EXPORT56:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP

Friday, January 1, 2016

Cannot load mod_ssl.so into server

Oracle EBS, Unable to start OHS after TLS Implementation

Error from Logfile:

/u01/EP1/inst/apps/EP1_example/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
Syntax error on line 270 of /u01/EP1/inst/apps/EP1_example/ora/10.1.3/Apache/Apache/conf/httpd.conf:
Cannot load /u01/EP1/apps/tech_st/10.1.3/Apache/Apache/modules/mod_ssl.so into server: /u01/EP1/apps/tech_st/10.1.3/Apache/Apache/modules/mod_ssl.so: cannot open shared object file: No such file or directory

Finding:
Check issue and notice that one module was loaded incorrectly in httpd.conf file .

$INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf

Solution:
Edit httpd.conf file and implement this change.

$INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf

From:
LoadModule ssl_module modules/mod_ssl.so

to:
LoadModule ssl_module libexec/mod_ssl.so

Sunday, October 4, 2015

Oracle EBS URL redirect https to http

Issue: Oracle EBS redirect URL from http to https.

Below are changes which I made but it's still redirecting to it...
https://orapp01.example.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif to http://orapp01.example.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif https://orapp01.example.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif to http://orapp01.example.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif https://orapp01.example.com:8000 to http://orapp01.example.com:8000 https://orapp01.example.com:8000/OA_HTML/AppsLogin to http://orapp01.example.com:8000/OA_HTML/AppsLogin

Finally, after changing below it resource the issue.

from:
<sslterminator oa_var="s_enable_sslterminator/">
To:
<sslterminator oa_var="s_enable_sslterminator">#</sslterminator>

Saturday, May 23, 2015

Install and Configure VNC Server in RHEL 7 and OEL 7

We need to run below 2 commands to setup GUI in RHEL 7

yum-config-manager --enable rhui-REGION-rhel-server-extras
yum repolist
yum groupinstall -y "Server with GUI"

yum install -y tigervnc-server xorg-x11-fonts-Type1

yum install -y xorg-x11-apps

Install xorg-x11-apps in Oracle Linux8

yum config-manager --enable ol8_codeready_builder

yum install -y xorg-x11-apps

Copy file and change user details

cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver_root@:2.service

cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver_oracle@:3.service

sed -i 's/<USER>/root/g' /etc/systemd/system/vncserver_root@:2.service

sed -i 's/<USER>/oracle/g' /etc/systemd/system/vncserver_oracle@:3.service

#Start the Services and set password

systemctl enable vncserver_root@:2.service

systemctl enable vncserver_oracle@:3.service

systemctl daemon-reload

echo -e "admin123\nadmin123" | vncpasswd root

echo -e "admin123\nadmin123" | vncpasswd oracle

su - grid

vncserver

Friday, April 24, 2015

Moving the MySQL Data Directory - Part2

To prepare for moving MySQL’s data directory, let’s verify the current location by starting an interactive MySQL session using the administrative credentials.

mysql -u root -p

select @@datadir;

mysql> select @@datadir;

+-----------------+

| @@datadir       |

+-----------------+

| /var/lib/mysql/ |

+-----------------+

1 row in set (0.00 sec)

This output confirms that MySQL is configured to use the default data directory.

2. Shutdown database and check status

[root@hccmoenas ~]# service mysqld stop
Stopping mysqld: [ OK ]
[root@hccmoenas ~]# service mysqld status
mysqld is stopped

3. Copy datafiles to a different location

[root@hccmoenas lib]# mv mysql mysql.bkp

[root@hccmoenas lib]# cp -Rp mysql.bkp /u01/mysql

[root@hccmoenas lib]# du -sh /u01/mysql

21M /u01/mysql

[root@hccmoenas lib]#

4. Pointing to the New Data Location

Edit file/etc/my.cnf and update value for datadir location

[root@hccmoenas lib]# grep datadir /etc/my.cnf
#datadir=/var/lib/mysql
datadir=/u01/mysql
[root@hccmoenas lib]#

5. Start MySQL Database services and check datafile location and tables if it can access.

[root@hccmoenas lib]# service mysqld start

Starting mysqld: [ OK ]

[root@hccmoenas lib]# mysql

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.1.73 Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select @@datadir;

+-------------+

| @@datadir |

+-------------+

| /u01/mysql/ |

+-------------+

1 row in set (0.00 sec)

mysql> USE books;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> SHOW TABLES;

+-----------------+

| Tables_in_books |

+-----------------+

| authors |

+-----------------+

1 row in set (0.01 sec)

mysql> SELECT * FROM authors;

+------+-------+---------------+

| id | name | email |

+------+-------+---------------+

| 1 | Vivek | xuz@abc.com |

| 2 | Priya | p@gmail.com |

| 3 | Tom | tom@yahoo.com |

+------+-------+---------------+

3 rows in set (0.00 sec)

mysql> exit

Bye

Wednesday, March 4, 2015

EBS WF Mailer Issues

SMTP Telnet Test:

bash-4.1$ mailx -vvv makwana.jignesh@gmail.com
Subject: Test mail
test
.
EOT
makwana.jignesh@gmail.com... Connecting to [127.0.0.1] via relay...
220 <smtp_server_name> ESMTP Sendmail 8.14.4/8.14.4; Thu, 30 Oct 2014 14:56:04 GMT
>>> EHLO <smtp_server_name>
250-<smtp_server_name> Hello localhost [127.0.0.1], pleased to meet you
250-ENHANCEDSTATUSCODES
250-PIPELINING
250-8BITMIME
250-SIZE
250-DSN
250-ETRN
250-AUTH GSSAPI
250-DELIVERBY
250 HELP
>>> MAIL From:<<smtp_user_name>@<smtp_server_name>> SIZE=235 AUTH=<smtp_user_name>@<smtp_server_name>
250 2.1.0 <<smtp_user_name>@<smtp_server_name>>... Sender ok
>>> RCPT To:<makwana.jignesh@gmail.com>
>>> DATA
250 2.1.5 <makwana.jignesh@gmail.com>... Recipient ok
354 Enter mail, end with "." on a line by itself
>>> .
250 2.0.0 s9UEu4Dk013833 Message accepted for delivery
makwana.jignesh@gmail.com... Sent (s9UEu4Dk013833 Message accepted for delivery)
Closing connection to [127.0.0.1]
>>> QUIT
221 2.0.0 <smtp_server_name> closing connection
bash-4.1$