Datawarehouse Architect

To Stop BI services in Linux 1. opmnctl /home/obiee/bi11g/instance/instance1/bin/opmnctl ./opmnctl stopall 2. Stop Managed server /home/obiee/bi11g/user_projects/domains/bifoundation_domain/bin/stopManagedweblogic.sh Format should be in stopManagedweblogic.sh bi_server1 http://obiee.7stl.com:7001 3. Start Administration service. Home/obiee/bi11g/user_projects/domains/bifoundation_domain/bin/Stopweblogic.sh

1. dac_env.bat file check 3 lines set INFA_CMD_STYLE=8 set PATH=C:\Informatica\9.1.0\java\server\bin;%PATH% set INFA_DOMAINS_FILE=C:\Informatica\9.1.0\domains.infa 2. I need to copy this odbc6 file from oracle jdbc/lib to bifoundation/lib/ 3. serversetupprompt.bat 4. startserver.bat and startclient.bat go to client in windows machine 1. start client 2. configure 3. In setup give dac server ip 4. then dac server setup

To start informatica services in Linux

First start Oracle services export ORACLE_SID=orcl export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH sqlplus / as sysdba start up exit lsnrctl start Informatica path ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1:export ORACLE_HOME PATH=$PATH:/apps/informatica/9.0.1/tomcat/bin:/apps/informatica/9.0.1/server/bin:/$ORACLE_HOME/bin:/apps/informatica/9.0.1/tomcat/server/lib:$ORACLE_HOME/lib; export PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/apps/informatica/9.0.1/tomcat/server/bin:/usr/lib:/lib64:/lib INFA_CODEPAGENAME=UTF-8 export INFA_CODEPAGENAME ulimit -n 4096 Login in root user go to bin location and hit this export then start informatica service  (infaservice.sh startup)  path : informatica/9.0.1/server/tomcat/bin/ Give this export in this path informatica/9.0.1/server/tomcat/bin/ export LANG=en_US.UTF-8 export LC_ALL=en_US.UT...

Steps for installing Informatica 9.0.1 server and client 1.        Create user infa and infadm using sqlplus. 2.        Go to the informatica folder <Informatica 9.0.1/infa 9.0.1….> ( the location is that the software were you are copied the software) 3.        Go to the server folder to install the Informatica server and click install.   4.        The installation process will start 5.        Select the installation type and give next 6.        Verify the pre-requisites to start the installation 7.        Select the licence key and installation path to install the informatica ...