Sunday, February 2, 2014

Infra installation on Linux Machine ..

Its THE THING for which I was obsessed from Dec 22nd Dec [Starting from Cisco Shut Down] finally accomplished. Below are the Highlights / Errors / Resolutions / Helps I encountered ..

Installation Pre-Requisites

Linux
Basic criteria is to have Linux Installed on your machine. Make sure that your Linux, Oracle and Informatica software everthing  has to be of same bit i.e. either 32 or 64.

I had downloaded Oracle Linux 6 very basic version which is freely available at oracle site. There are 5 different CDs having serial number 1 to 5 I downloaded.

When you start installing the Linux, installation wizard will prompt you for Firewall - make sure to choose Disable Firewall option.

Also, check all possible add-ons and development software at the time of installations.

Oracle
This is a most difficult part of Informatica Installation. I had earlier downloaded Oracle Express Edition 11g and even 12C, but it did not work.

After lots of research over a net, finally I took a decision to download 11g Standard Edition. Make sure that you will follow EXACT SAME steps mentioned in a link below for Oracle Installations.

http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-5.php

To get a IP Address of your linux machine fire a command -- ifconfig

When you complete the installation following the steps mentioned in a link above, you will be able to login into oracle. However catch here is, if you shut down your machine and try to login to oracle again, you will get an error.

Steps which I followed.
Change in Listener File
Make sure your listener file will have below entries

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME =/u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = orcl)
    )
   
  (SID_DESC=
  (GLOBAL_DBNAME = orcl)
  (ORACLE_HOME =/u01/app/oracle/product/11.2.0/db_1)
  (SID_NAME=orcl)
  )

)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.26.137)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle


Once you change the Listener.ora file, hit below commands to start your listener

[oracle@localhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-JAN-2014 04:22:10

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.26.137)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
[oracle@localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-JAN-2014 04:22:17

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.26.137)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                05-JAN-2014 04:22:21
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.26.137)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 2 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 05-JAN-2014 04:22:29

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.26.137)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (10 msec)
[oracle@localhost ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 5 04:22:36 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: hr
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name:
[oracle@localhost ~]$
[oracle@localhost ~]$
[oracle@localhost ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 5 04:22:52 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size            1023412216 bytes
Database Buffers          620756992 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$
                             

These steps you need to follow every time when you will shut down your machine.

Informatica Installation --

DO NOT install informatica from root user. Assuming you had followed earlier oracle installation steps mentioned in a site, so you will have oracle user created. Use same user for even Informatica installation.

After installation of Oracle I created infomatica folder in  a same directory structure of Oracle using root user and granted all access to oracle user as below

mkdir -p /u01/app/oracle/Informatica
chown -R oracle:oinstall /u01
chmod -R 775 /u01

You also need to grant permission as below to the actual installer folder..as when you hit .sh script it will create some folders by default before extracting jar file.

Follow below steps --
[oracle@gogate /]$ su -
Password:
[root@gogate ~]# chmod 777 /tmp/
CVU_11.2.0.1.0_oracle/ .gdm_socket            kde-root/              .oracle/               ssh-ruFzH29585/
.font-unix/            hsperfdata_oracle/     ksocket-oracle/        .pk11ipc1/             .X0-lock
gconfd-root/           .ICE-unix/             ksocket-root/          .rnd                   .X11-unix/
.gdm469QCX             kde-oracle/            logs/                  Softwares/
[root@gogate ~]# chmod 777 /tmp/
CVU_11.2.0.1.0_oracle/ .gdm_socket            kde-root/              .oracle/               ssh-ruFzH29585/
.font-unix/            hsperfdata_oracle/     ksocket-oracle/        .pk11ipc1/             .X0-lock
gconfd-root/           .ICE-unix/             ksocket-root/          .rnd                   .X11-unix/
.gdm469QCX             kde-oracle/            logs/                  Softwares/
[root@gogate ~]# chmod 777 /tmp/Softwares/
[root@gogate ~]# chown -R oracle:oinstall /tmp/Softwares
[root@gogate ~]# chmod -R 777 /tmp/Softwares
[root@gogate ~]# sqlplus

Logged in to Root user again and extracted the infra tar files and started actual installation from Oracle user at the path specified above.

If you face any errors at the time of installations or at the time of creating a repository, those all are generic error and solutions is available at google. Just have some patience and do not loose hopes.

Last 3 entries [marked in BOLD] I added after informatica installation. Remaining all entries are part of Oracle Installations.

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH


# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
#export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
export LANG=en_US.utf8
export LC_ALL=en_US.utf8
export INFA_CODEPAGENAME=UTF-8


When I tried to create a Repository from Administrator user, it did not work and gave some code page error. So, after googling it, I created a new Infrormatica user, assigned all kind of permissions and privileges to it. and again tried for Repository Creation and it got completed successfully.

I feel I am top of the moon today :)

Cheers ~~

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

Once you shutdown and restart your system ..
You always have to  restart Oracle and Infra Services as below

**********For Oracle
[oracle@localhost ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 9 05:48:28 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size             973080568 bytes
Database Buffers          671088640 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


**********For Infra
[oracle@localhost ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-MAR-2014 05:49:15

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
[oracle@localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-MAR-2014 05:49:27

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                09-MAR-2014 05:49:30
Uptime                    0 days 0 hr. 0 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 2 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$ su root
Password:
[root@localhost oracle]# find / -name tomcat
/u01/app/informatica/tomcat
/u01/app/informatica/services/shared/jars/pc/classes/com/informatica/tools/mm/tomcat
/u01/app/informatica/server/tomcat
/tmp/Software/source/tomcat
/tmp/Software/source/services/shared/jars/pc/classes/com/informatica/tools/mm/tomcat
/tmp/Software/source/server/tomcat
/home/oracle/Informatica/9.5.1/tomcat
/home/oracle/Informatica/9.5.1/services/shared/jars/pc/classes/com/informatica/tools/mm/tomcat
/home/oracle/Informatica/9.5.1/server/tomcat
/home/oracle/.local/share/Trash/files/tomcat
/home/oracle/.local/share/Trash/files/services/shared/jars/pc/classes/com/informatica/tools/mm/tomcat

[root@localhost oracle]# cd /u01/app/informatica/tomcat
[root@localhost tomcat]# ls
bin  conf  lib  logs  temp  webapps  work
[root@localhost tomcat]# cd bin/
[root@localhost bin]# ls
bootstrap.jar       commons-daemon.jar            digest.sh              ispLogs.log      setclasspath.sh  TestODBCConnection.sh  tool-wrapper.sh
catalina.sh         commons-daemon-native.tar.gz  infaservice.sh         ispLogs.log.lck  shutdown.sh      tomcat-juli.jar        version.sh
catalina-tasks.xml  configtest.sh                 isplogging.properties  log4j.xml        startup.sh       tomcat-native.tar.gz
[root@localhost bin]# ./infaservice.sh startup
Starting Informatica services on node 'node01_localhost.localdomain'
Using CURRENT_DIR:     /u01/app/informatica/tomcat/bin
Using INFA_HOME:       /u01/app/informatica
[root@localhost bin]#                                                                                    

To Verify the Installation

[oracle@localhost ~]$ cd /u01/app/informatica/isp/bin/
[oracle@localhost bin]$ ./infacmd.sh ping -dn Domain_localhost.localdomain
[INFACMD_10052] Domain [Domain_localhost.localdomain] Host:Port [localhost.localdomain:6005] was successfully pinged.
Command ran successfully.
[oracle@localhost bin]$ ./infacmd.sh ping -dn Domain_localhost.localdomain -sn ASA
[INFACMD_10052] Service [ASA] Domain [Domain_localhost.localdomain] Host:Port [localhost.localdomain:6014] was successfully pinged.
Command ran successfully.

5 comments:

  1. To connect client with server getting error..
    please chk the link -- https://community.oracle.com/message/4348396#4346396

    ReplyDelete
  2. Hi informatica guru. I am new to informatica, i have installed oracle 11g (32 bit) and informatica 9.1 hf 2 (32 bit) on OEL 5.2 (32 bit) system as per your videos and everything was successful and i have created repository and integration service and everything was fine at that time. But the next day when i restarted my administrator page of informatica i got the following error.

    Database driver event.. Error occurred loading library [libclntsh.so.10.1:cannot open shared object file: No such file or directory] Database driver event.. Error occured loading library[libpmora8.so]

    I googled it and tried a lot but everything in vein :( Please help me out.

    ReplyDelete
  3. I am really satisfied by your information. It's well-written, to the point, and relative to what I do. I like it very much for giving information on “Infra installation on Linux Machine” the Author explained Oracle installation in Linux based machines. It’s really helpful who are looking for Informatica. Now a day’s Informatica etl tool is market leader in data integration and data quality services. Informatica is successful ETL and EAI tool with significant industry coverage. I will share a link just look: https://goo.gl/whaLnK

    ReplyDelete

All about CSS

From book HTML & CSS - Design and Build Websites - Jon Duckett CSS works by associating rules with HTML elements. These rules govern how...