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/
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
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.
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/
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/
#LD_LIBRARY_PATH=$ORACLE_HOME/
#export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$
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.
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/
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.
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/
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/
#LD_LIBRARY_PATH=$ORACLE_HOME/
#export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$
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.
Wonderful :)
ReplyDeleteTo connect client with server getting error..
ReplyDeleteplease chk the link -- https://community.oracle.com/message/4348396#4346396
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.
ReplyDeleteDatabase 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.
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
ReplyDeleteAppreciate you for sharing this information
ReplyDeletepower bi training
devops online training