Infra & DevOps gist: 2015

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$

Tuesday, February 24, 2015

Create a MySQL Database - Part1

MySQL is a free and open source database management system. To create a database and set up tables for the same use the following sql commands.

CREATE DATABASE – create the database. To use this statement, you need the CREATE privilege for the database.
CREATE TABLE – create the table. You must have the CREATE privilege for the table.
INSERT – To add/insert data to table i.e. inserts new rows into an existing table.

mysql -u root -p

Create Database book

CREATE DATABASE books;

Select / Use Database for further operations

USE books;

Create a sample table in a database

CREATE TABLE authors (id INT, name VARCHAR(20), email VARCHAR(20));

Check the table definition

SHOW TABLES;

Insert record in author table

INSERT INTO authors (id,name,email) VALUES(1,"Jig","xuz@abc.com");

INSERT INTO authors (id,name,email) VALUES(2,"Mak","m@gmail.com");

INSERT INTO authors (id,name,email) VALUES(3,"Hari","Hari@yahoo.com");

Select records from that table.

SELECT * FROM authors;

Thursday, January 22, 2015

EBS Maintancemode ENABLE / DISABLE

Oracle EBS, Enable / Disable maintanance mode using sql script

sqlplus -s apps/apps @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
adpatch driver=u16545472.drv logfile=adpatch_u16545472.log
sqlplus -s apps/apps @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE