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.

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

Login as the mysql root user to create database:

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;

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

Existing lock /var/run/yum.pid: another copy is running as pid

Issue: Existing lock /var/run/yum.pid: another copy is running as pid

Caused : Yum Session was locked by other user or it was terminated.

[root@rac1 ~]# yum list | grep oracle-
This system is not registered with ULN.
ULN support will be disabled.
Existing lock /var/run/yum.pid: another copy is running as pid 3246.
Another app is currently holding the yum lock; waiting for it to exit...
  The other application is: yum-updatesd-he
    Memory :  26 M RSS (263 MB VSZ)
    Started: Fri Dec 26 19:53:45 2014 - 00:10 ago
    State  : Running, pid: 3246
Another app is currently holding the yum lock; waiting for it to exit...
  The other application is: yum-updatesd-he
    Memory :  26 M RSS (263 MB VSZ)
    Started: Fri Dec 26 19:53:45 2014 - 00:12 ago
    State  : Running, pid: 3246
Another app is currently holding the yum lock; waiting for it to exit...
  The other application is: yum-updatesd-he
    Memory :  26 M RSS (263 MB VSZ)
    Started: Fri Dec 26 19:53:45 2014 - 00:14 ago
    State  : Running, pid: 3246


Exiting on user cancel.

Fixed:
[root@rac1 ~]# ls -l /var/run/yum.pid 
-rw-r--r-- 1 root root 4 Dec 26 19:53 /var/run/yum.pid
[root@rac1 ~]# rm /var/run/yum.pid 
rm: remove regular file `/var/run/yum.pid'? y

Re-run:
[root@rac1 ~]# yum list | grep oracle-

How to install telnet to windows 7

Telnet Client is not installed by default on Windows 7. The procedures to install Telnet Client vary based on the operating system you are using.


Here are the steps to Install into the Windows 7 Operating system:

• Select 'Control Panel'

• Select 'Programs and Features'

• Select 'Turn Windows Features on or off'

• Wait for 2-4 minutes on this screen

• Select 'Telnet Client' and click on 'Ok' button

• Open Command Prompt and now you have telnet command. 

Cloning cheat list - EBS 11i / R12.1 / R12.2

Application Cloning

Post clone steps

1. Clean FND_NODES

SQL> select node_name, node_mode, support_cp, support_web, support_admin,support_forms from FND_NODES;

NODE_NAME       N S S S S

------------------------------ - - - - -

SGERP01       O Y Y Y Y

AUTHENTICATION       O N N N N

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

2. Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers

EBS R12.2 - Application Cloning

Issue 1:

############################################################

Started ApplyAppsTier at Sun Oct 26 13:38:45 SGT 2014

Version:

        ApplyAppsTier.java      :       120.11.12020000.6

#############################################################

Found the directory : /r122va/VIS3/fs1/FMW_Home

Exiting cloning as FMW Home already exists..

~                                                                                                          

Fix: Move this folder to some other name

Issue 2:

#########################################################

Started ApplyAppsTier at Sun Oct 26 13:40:13 SGT 2014

Version:

        ApplyAppsTier.java      :       120.11.12020000.6

#############################################################

Below Oracle Homes are already registered in the global inventory:

/r122va/VIS3/fs1/FMW_Home/Oracle_EBS-app1

/r122va/VIS3/fs1/FMW_Home/webtier

/r122va/VIS3/fs1/FMW_Home/oracle_common

/r122va/VIS3/fs1/FMW_Home/Oracle_OAMWebGate1

Exiting Cloning...

Ensure that the above Oracle Homes are unregistered from the global inventory "/r122vd/VIS3/oraInventory//ContentsXML/inventory.xml" and re-run adcfgclone.pl script

~                                                                                                           

~                                                                                                           

Fix :
move inventory.xml file so new file will be created

mv /r122vd/VIS3/oraInventory//ContentsXML/inventory.xml /r122vd/VIS3/oraInventory//ContentsXML/inventory.xml.jm1

Error 3:

END: Executed adupdlobs.pl

ERROR: AutoConfig completed with errors. Check logfile at /r122va/VIS3/fs1/inst/apps/VIS3_sar122vis1/admin/log/clone/ApplyAppsTier_10261341.log for details.

FMW JDK version in use: 1.7.0_25

/r122va/VIS3/fs1/FMW_Home/Oracle_EBS-app1/jdk is not a symbolic link, creating it...

Running ln -s /r122va/VIS3/fs1/EBSapps/comn/util/jdk64 /r122va/VIS3/fs1/FMW_Home/Oracle_EBS-app1/jdk

-- further errors

Updating s_tnsmode to 'generateTNS'

UpdateContext exited with status: 0

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates

Instantiating Tools tnsnames.ora

Tools tnsnames.ora instantiated

adgentns.pl exiting with status 2

ERRORCODE = 2 ERRORCODE_END

fix: run fnd_node clean and run autoconfig on application and databsae node

applmgr@sar122vis1 bin]$ . /r122va/VIS3/EBSapps.env run

  E-Business Suite Environment Information

  ----------------------------------------

  RUN File System           : /r122va/VIS3/fs1/EBSapps/appl

  PATCH File System         : /r122va/VIS3/fs2/EBSapps/appl

  Non-Editioned File System : /r122va/VIS3/fs_ne

  DB Host: sar122vis1.stone-apple.com  Service/SID: VIS3

  Sourcing the RUN File System ...

[applmgr@sar122vis1 bin]$ cd $ADMIN_SCRIPTS_HOME 

[applmgr@sar122vis1 scripts]$ ./adautocfg.sh 

Enter the APPS user password:

RPM required for RHEL 6 to run Oracle Database 11gR2

Install following Rpm from the Yum / Installation Media

yum install libSM.i686 libXp.i686 libXp.x86_64 libX11.i686 libXt.i686 libXrender.i686 compat-db43.i686 gcc.x86_64 gcc-c++.x86_64 glibc-devel.i686 libgcc.i686 \
libstdc++-devel.i686 libstdc++-devel.x86_64 libstdc++.i686 libXi.i686 libaio.i686 gdbm.i686 compat-libstdc++-296.i686 compat-libstdc++-33.i686 compat-libcap1.x86_64 \
compat-libstdc++-33.x86_64 elfutils-libelf-devel.x86_64 libaio-devel.x86_64 unixODBC.i686 unixODBC.x86_64 unixODBC-devel.i686 unixODBC-devel.x86_64 xorg-x11-utils.x86_64 \
ksh.x86_64

Download following package from the Oracle website and Install it.

wget https://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/openmotif21-2.1.30-11.EL6.i686.rpm

rpm -ivh openmotif21-2.1.30-11.EL6.i686.rpm 

wget https://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

rpm -ivh xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

How to connect to AWS EC2 Server

Step 1 : Connect to the Jumpin server

From mac Pc

Copy secure key to your mac and run the below command

ssh -i <secure key> <username>@<server IP Address>

from Jump-in server to the actual server

From Putty