Tuesday, November 1, 2011

Informatica

1. startup
$INFA_HOME/tomcat/bin/infaservice.sh startup

2. shutdown
$INFA_HOME/tomcat/bin/infaservice.sh shutdwon

log file: $INFA_HOME/tomcat/logs/catalina.out


3. change database connection info

$INFA_HOME/server/infasetup.sh updateGatewayNode -da database_hostname:database_port -ds database_name

4. change database password
$INFA_HOME/server/infasetup.sh UpdateGatewayNode -databasepassword

./infasetup.sh UpdateGatewayNode -da [new database host]:[new database port] -du [new database user] -dp [new database password -dt [database type i.e. db2] -ds [new database name]


reference:
https://forums.oracle.com/forums/thread.jspa?threadID=2240006
https://community.informatica.com/thread/27876
http://www.tek-tips.com/viewthread.cfm?qid=1561513

2 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. 1. backup domain
    /u01/app/informatica/isp/bin/infasetup.sh backupDomain -da hostname:1521 -du informatica -dp password -dt Oracle -ds ORCL -bf "/home/informatics/backup/domain_orcl_bkp" -dn Domain_orcl

    2.backup repo
    /u01/app/informatica/server/bin/pmrep <<EOF
    connect -r "orcl_repository" -d "Domain_orcl" -n Administrator -x "password"
    backup -o "/home/informatics/backup/orcl_repository_bkp"
    exit
    EOF

    3. backup repo object
    listobjects -o FOLDER

    objectexport -f "test_283" -u /tmp/backup_folder

    ReplyDelete