当前位置：文档之家 › 01_PowerCenter811 for aix64 (Oracle作为repository库)安装过程

01_PowerCenter811 for aix64 (Oracle作为repository库)安装过程

  • 格式：doc
  • 大小：1.68 MB
  • 文档页数：20

PowerCenter811 for aix64安装过程1.环境准备1)为Informatica建立一个系统用户infa/infa，并把pc用户放置到sybase、oracle组以确保infa用户可以执行sybase的程序。

2)为infa用户预留10G空间，系统tmp区预留1G空间3)配置infa用户环境变量，确保可连通中所有涉及的资料库、数据源和目标2.上传介质注意事项：请使用infa用户并请确保以二进制方式上传3.配置infa环境变量. /sybase/.profile. /home/oracle/.profileexport LANG=Cexport INFA_CODEPAGENAME="ms936"export INFA_HOME=/informatica/PowerCenter8.1.1export NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport PA TH=/usr/bin:/etc/:/usr/sbin:/usr/ucb:/usr/local/bin:$INFA_HOME/server/bin:$ORACLE_HOME/bin:/usr/bin/X11:/sbin/opt/VRTS/bin:/opt/VRTSob/bin:/opt/VRTSvcs/bin:/opt/VRTSvxfs/sbin:/usr/lib/vxvm/bin:.:$PA THexportLIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:/usr/lib:$INFA_HOME/server/ lib:.:$LIBPATHexport CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jre/1.1.8/lib:/usr/jdk_base:/usr/ jdk_base:/usr/jdk_base/lib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib export TERM=xterm4.安装记录$ pwd/tmp/AIX64/Disk1/InstData/VM$ lsinstall.bin$ ./install.bin -i consolePreparing to install...Extracting the JRE from the installer archive...Unpacking the JRE...Extracting the installation resources from the installer archive...Configuring the installer for this system's environment...Launching installer...Preparing CONSOLE Mode Installation...====================================================================== =========PowerCenter 8.1.1 (created with InstallAnywhere by Macrovision)-------------------------------------------------------------------------------====================================================================== =========Welcome-------Welcome to Informatica PowerCenter 8.1.1. You can use this wizard to installPowerCenter 8.1.1.Copyright 1999-2006 Informatica Corporation. All rights reserved.This wizard guides you through installation of Informatica PowerCenter 8.1.1.Enter to start the installation. You can enter 'Back' for previous screen and'Quit' to stop the installation and exit the wizard.This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374;6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending.Press <enter> to continue:====================================================================== =========Configure Environment Variables-------------------------------Required UNIX Environment VariablesYou must set the following environment variables to continue with theinstallation on UNIX machines:DISPLAY variable: Configure the DISPLAY variable to run the GUI-basedinstallation program using X Windows on Solaris, AIX, HP-UX, and Linux.Locale variables: Configure the LANG, LANG_C, LC_TYPE, and LC_ALL variables to generate appropriate code pages and create and connect to repositories andRepository Services.Database client variables: Set the variables required for database clients.Configure ORACLE_HOME for Oracle databases, DB2DIR and DB2INSTANCE for IBM DB2 databases, and SYBASE_ASE and SYBASE_OCS for Sybase ASE databases. Thevariables are required to create and connect to repositories and RepositoryServices.Library path variables: Configure PATH, LD_LIBRARY_PATH for Solaris and Linux, LIBPATH for AIX, and SHLIB_PATH for HP-UX.If any of the required variables are not configured, quit the installationprogram, configure the variables, and restart the installation program.Press <enter> to continue:If you are not sure that the environment is correctly configured, quit theinstallation and verify environment settings.For more information about configuring environment variables and testingdatabase connections, see the PowerCenter Installation and Configuration Guide.Important information complete. Press <enter> to continue:====================================================================== =========PowerCenter License Key-----------------------<Type 'back' for the previous panel or 'quit' to exit the installer.>License key fileSelect the license key file: (DEFAULT: /infa/license.key): /infomatica/lic.key.txt====================================================================== =========Installation Prerequisites--------------------------Please read before continuing:Installation PrerequisitesPowerCenter Repository Database: Oracle, DB2, SQL Server (Windows only), SybaseData Analyzer Repository Database: Oracle, DB2, SQL Server, SybaseMetadata Manager Repository Database: Oracle, DB2, SQL Server, SybaseDomain Configuration Database: Oracle, DB2, SQL Server, SybaseAt least three database user accounts are required to complete theinstallation.Disk Space RequirementsComplete PowerCenter Advanced Edition installation: 2.3 GBPowerCenter Services: 500 MBPowerCenter Data Analyzer: 800 MBPowerCenter Metadata Manager: 1.0 GBImportant information complete. Press <enter> to continue:====================================================================== =========Installation Set----------------<Type 'back' for the previous panel or 'quit' to exit the installer.>Complete: Includes the following components:--PowerCenter Services--PowerCenter Data Analyzer (dashboards, reports, and graphs)--PowerCenter Metadata ManagerCustom: Choose the PowerCenter components to install.->1- Complete2- CustomEnter the Option: <Default:1>: 2====================================================================== =========PowerCenter Advanced Edition Components---------------------------------------<Type 'back' for the previous panel or 'quit' to exit the installer.>PowerCenter Advanced Edition->1- PowerCenter Services->2- PowerCenter Data Analyzer->3- PowerCenter Metadata ManagerEnter an option (separate multiple values with commas):: <Default:1,2,3>: 1====================================================================== =========Choose Installation Type------------------------<Type 'back' for the previous panel or 'quit' to exit the installer.>->1- Install PowerCenter 8.1.1. (Use this option if you are installing PowerCenter Services for the first time.)2- Upgrade to PowerCenter 8.1.1. (Use this option if you are upgrading from PowerCenter version 8.1.0.)Enter an option:: <Default:1>: 1====================================================================== =========Installation Directory----------------------<Type 'back' for previous screen and 'quit' to exit installer>Choose the installation directory:Default Install Directory: /infa/Informatica/PowerCenter8.1.1Enter an absolute path, or press <enter> to accept the default:====================================================================== =========Pre-Installation Summary------------------------Review the following information before continuing. Enter 'Back' to go back andchange settings.Product Name:PowerCenter 8.1.1Install Directory:/informatica/PowerCenter8.1.1Selected ComponentsPowerCenter ServicesDisk Space RequirementsRequired Space :500 MBAvailable Space :1,307 MBPress <enter> to continue:====================================================================== =========Installing...-------------[==================|==================|==================|============== ====][------------------|------------------|------------------|------------------]====================================================================== =========Create or Join Domain---------------------<Type 'back' for the previous panel or 'quit' to exit the installer.>See Create or Join Domain in the PowerCenter Quick Start guide for help onselecting an option.Reminder: PowerCenter is licensed on a CPU basis. Consult your licensingagreement for details on your licensed configuration.->1- Create New Domain (If you are installing PowerCenter Services for the first time or you want to create a new domain.)2- Join Existing Domain (If you are installing PowerCenter on multiple machines and you have already created a domain on another machine.)Enter an option:: <Default:1>: 1====================================================================== =========Configure Domain Database-------------------------<Type 'back' for the previous panel or 'quit' to exit the installer.>PowerCenter Services ConfigurationEnter the user account information for the database to store PowerCenter domain configuration metadata. You can store the PowerCenter domain configurationmetadata and a PowerCenter repository in the same database user account. Youmust store configuration metadata for different domains in separate databaseuser accounts.->1- Oracle2- DB23- SQLServer4- SybaseDatabase type:: <Default:1>: 1Database URL: (DEFAULT: host_name:port_no): dl_s_15_vip:1521Database user ID:: infa_sg17Database user password:: neusoftDatabase service name: (DEFAULT: sid): bietl1====================================================================== =========Configure Domain----------------<Type 'back' for the previous panel or 'quit' to exit the installer.>PowerCenter Services ConfigurationEnter the information for the PowerCenter domain you want to create.Domain name: (DEFAULT: Domain_ dl_s_15_vip): Domain_sgDomain host name: (DEFAULT: wk05s):Node name: (DEFAULT: node01_ wk05s):Domain port no: (DEFAULT: 6001):Domain user name: (DEFAULT: admin):Domain password:: adminConfirm password:: adminCreate Repository Service (Y/N) (DEFAULT: Y): NConfigure minimum and maximum port numbers? (Y/N) (DEFAULT: N):====================================================================== =========PowerCenter 8.1.1 Installation Summary--------------------------------------Installation Status : SUCCESSInstallation Status : SUCCESSThe PowerCenter 8.1.1 installation completed successfully. The informationbelow summarizes the location and configuration of the installed products andcomponents and status of the services. Use the debug log file/infa/Informatica/PowerCenter8.1.1/Informatica_Installation_Server_Debug.logfor more information.Installation Date :------------------------Fri Aug 31 11:06:37 GMT+08:00 2007Product Name :------------------------PowerCenter 8.1.1Chosen Install Set :------------------------CustomChosen Components :------------------------PowerCenter ServicesPress <enter> to continue:Installation Directory :------------------------/informatica/PowerCenter8.1.1Configuration Properties----------------------------PowerCenter Services--------------------------------Administration Console URL: http://WK05S:6001/adminconsoleDomain Name : Domain_sgGateway Host Name : WK05SAdministrator User Name : adminNode Name : node01_WK05SNode Port Number : 6001Configuration StatusPress <enter> to continue:----------------------------PowerCenter Domain Creation : SuccessPowerCenter Ping Domain : SuccessRepository Service Creation : SuccessRepository Service Startup : SuccessPowerCenter Repository Creation : SuccessDI Service Creation : SuccessDI Service Startup : SuccessThe installation debug log file can be found at :/infa/Informatica/PowerCenter8.1.1/Informatica_Installation_Server_Debug.logImportant information complete. Press <enter> to continue:====================================================================== =========Installation Complete---------------------The PowerCenter 8.1.1 installation completed successfully. Press <enter> to continue (OK):5.建立服务User:adminPass:admin6.建立任务7.Sybase iq 装载Load 配置connect string 按照uid=user ID; pwd=password; eng=Sybase IQ database server name; links=tcpip (host=host name; port=port number如uid=DBA;pwd=SQL;eng=jysoft-qc1_asiqdemo;links=tcpip(host=jysoft-qc1;port=2638) Server Datafile Directory需要改成目标文件的位置把输出文件设为逗号分割，无引用符。

合集下载

AIX 安装 oracle 案例

AIX 安装 oracle 案例

AIX 安装 oracle 案例准备工作：磁盘空间# lsvg -l rootvg [查看磁盘使用状态、文件系统类型]rootvg:LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT hd5 boot 1 1 1 closed/syncd N/Ahd6 paging 16 16 1 open/syncd N/Ahd8 jfs2log 1 1 1 open/syncd N/Ahd4 jfs2 10 10 1 open/syncd /hd2 jfs2 76 76 1 open/syncd /usrhd9var jfs2 17 17 1 open/syncd /varhd3 jfs2 192 192 1 open/syncd /tmphd1 jfs2 160 160 1 open/syncd /homehd10opt jfs2 14 14 1 open/syncd /opthd11admin jfs2 4 4 1 open/syncd /adminlg_dumplv sysdump 64 64 1 open/syncd N/A livedump jfs2 8 8 1 open/syncd/var/adm/ras/livedump# df -g磁盘使用情况Filesystem GB blocks Free %Used Iused %Iused Mounted on/dev/hd4 0.31 0.09 71% 11415 27% //dev/hd2 2.38 0.04 99% 53694 74% /usr/dev/hd9var 0.53 0.10 82% 8762 23% /var/dev/hd3 6.00 5.99 1% 90 1% /tmp/dev/hd1 5.00 0.44 92% 1493 2% /home/dev/hd11admin 0.12 0.12 1% 5 1% /admin/proc - - - - - /proc/dev/hd10opt 0.44 0.14 69% 10633 23% /opt/dev/livedump 0.25 0.25 1% 4 1% /var/adm/ras/livedump# df -g /tmpFilesystem GB blocks Free %Used Iused %Iused Mounted on/dev/hd3 0.19 0.18 4% 71 1% /tmp如不够需要做以下调整/usr 4g/var 2g/tmp 4g/home 4g# chfs -a size=6G /tmp [扩展tmp目录大小为6G]交换页面# lsps -aPage Space Physical Volume Volume Group Size %Used Active Auto Type Chksum hd6 hdisk0 rootvg 512MB 3 yes yes lv 0chps -s number hd6安装前检查：# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstatbos.perf.proctools bos.adt.prof bos.cifs_fs.rteFileset Level State Description----------------------------------------------------------------------------Path: /usr/lib/objreposbos.adt.base 6.1.7.0 COMMITTED Base Application DevelopmentToolkitbos.adt.lib 6.1.2.0 COMMITTED Base Application DevelopmentLibrariesbos.adt.libm 6.1.4.0 COMMITTED Base Application DevelopmentMath Librarybos.adt.prof 6.1.4.0 COMMITTED Base Profiling Supportbos.perf.libperfstat 6.1.7.0 COMMITTED Performance Statistics LibraryInterfacebos.perf.perfstat 6.1.7.0 COMMITTED Performance StatisticsInterfacebos.perf.proctools 6.1.7.0 COMMITTED Proc Filesystem ToolsPath: /etc/objreposbos.adt.base 6.1.7.0 COMMITTED Base Application DevelopmentToolkitbos.perf.libperfstat 6.1.7.0 COMMITTED Performance Statistics LibraryInterfacebos.perf.perfstat 6.1.4.0 COMMITTED Performance StatisticsInterfacelslpp: 0504-132 Fileset bos.cifs_fs.rte not installed.安装文件集，挂载AIX系统安装盘smitty installp －－>* INPUT device / directory for software /dev/cd0＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝> bos.cifs_fs ALL | | + 6.1.4.0 Runtime for SMBFS | + | + 6.1.1.0 SMIT Interface for SMBFS打补丁path> bos.cifs_fs ALL | + | + 6.1.7.0 Runtime for SMBFS | +| + 6.1.6.0 SMIT Interface for SMBFS | +创建用户双节点# mkgroup dba# mkgroup oinstall# mkuser pgrp=oinstall groups=oinstall,dba oracle下面方法，无法编辑环境文件# mkuser pgrp=oinstall groups=oinstall,dba home='/home/oracle' shell='/usr/bin/ksh' oracle [创建oracle用户]创建安装路径# mkdir -p /oracledata/product/10.2.0/db_1# mkdir /oracledata/oradata# chown -R oracle:oinstall /oracledata修改oracle 用户属性设定用户文件大小，否则AIX默认文件大小1G 以内；chuser fsize=-1 oraclechuser stack=-1 oraclechuser rss=-1 oraclechuser core=-1 oraclechuser data=-1 oraclechuser nofiles=-1 oraclechuser fsize=-1 rootchuser stack=-1 rootchuser rss=-1 rootchuser core=-1 rootchuser data=-1 rootchuser nofiles=-1 oraclechdev -l sys0 -a maxuproc='16384'shutdown -r 配置完毕重启系统；更改用户环境变量（节点1和节点2）vi /home/oracle/.profileORACLE_BASE=/oracledata/oradataexport ORACLE_BASEORACLE_HOME=/oracledata/product/10.2.0/db_1export ORACLE_HOMEORACLE_SID=oradbexport ORACLE_SIDPATH=$ORACLE_HOME/bin:$PATHexport PATHoracle安装在一个节点即可。

Oracle RAC对AIX版本的支持

Oracle RAC对AIX版本的支持

Oracle RAC对AIX版本的支持
Oracle RAC支持AIX平台的版本如下：
∙10gR2 64-bit
∙10g 64-bit
∙9.2 64-bit
操作系统信息
∙Oracle认证支持AIX 5L操作系统，硬件架构包括pSeries和iSeries服务器，对AIX 5L的硬件支持信息参考以下网址：
/servers/eserver/iseries/aix/
∙AIX 5L版本认证的具体版本包括AIX 5L版本5.1, 5.2和5.3。

Oracle 10g只在AIX 5L 5.2和5.3两个版本认证
∙Customers should review MetaLink Note 282036.1
∙运行64位的RAC需要64位硬件架构支持
∙支持AIX 5L32位和64位核心
RAC信息
Oracle RAC对AIX平台集群软件的支持或者限制如下：
1）存储
●使用SSA硬盘，节点数最多为8个
●如使用VSD，节点最多为128个
2）网络互连
●如使用SP交换机，需要PSSP的支持
●9i RAC和10g CRS不支持使用交叉线互连
3）共享存储软件
●如使用CLVM，最多支持16个节点
●使用Veritas存储软件，实施RAC，使用10gR1版本测试到4节点。

Oracle11gRAC for AIX安装步骤

Oracle11gRAC for AIX安装步骤

Oracle 11g RAC for AIX安装步骤目录一、安操作系统检查3二、安装装备工作42.1.创建Grid Infrastructure和oracle用户和组42.2.创建Grid 集群如阿健和Oracle Database目录52.3.检查硬件条件52.4.IP地址分配52.5.调整操作系统参数62.6.配置ntp服务（服务端、客户端）82.7.配置SSH92.8.配置 SSH LoginGraceTime 参数102.9.配置GI用户环境102.10.配置ORACLE环境变量112.11.准备ASM磁盘11三、Grid Infrastructure安装过程153.1.检查root 用户umask为022153.2.检查grid 用户umask为022153.3.检查oracle 用户umask为022153.4./etc/hosts准备153.5.检查ifconfig值153.6.清理socket文件153.7.开始安装GI16四、安装Oracle Database 11gR2(不建库)29五、安装最新的OPatch33六、Oracle GI & RDBMS 安装PSU3补丁(18706472)34七、调整GI资源35八、调整ASM参数35九、安装ONE-OFF补丁35十、创建数据库36十一、加载one-off 补丁SQL 语句41十二、调整数据库参数41十三、调整11g 默认 profile42十四、Oracle11g RAC常用命令4214.1.数据库集群源状态查看4214.2.Oracle11g GI 启停命令4314.3.维护注意点43一、安操作系统检查1.检查软件条件二、安装装备工作2.1.创建Grid Infrastructure和oracle用户和组创建/oracle目录，大小为80G[2个节点]mkgroup -'A' id='1000' adms='root' oinstallmkgroup -'A' id='1100' adms='root' asmadminmkgroup -'A' id='1200' adms='root' dbamkgroup -'A' id='1300' adms='root' asmdbamkgroup -'A' id='1301' adms='root' asmopermkgroup -'A' id='1302' adms='root' operuseradd -u '1100' -g 'oinstall' -G 'asmadmin,asmdba,asmoper' -m griduseradd -u '1101' -g 'oinstall' -G 'dba,asmdba,oper' -m oraclepasswd gridpasswd oracle说明:并需要使用该用户重新登录一次。

Oracle安装For Aix

Oracle安装For Aix

Oracle安装配置/etc/hosts10.192.51.110 Unicom_ora1 Unicom_BPM2 bpm2.hq.unicom.local10.192.51.111 Unicom_ora2 Unicom_BPM1 bpm1.hq.unicom.local将oracle介质上传到服务器上。

/software/oracle9i/A99331-01.zip/software/oracle9i/A99332-01.zip/software/oracle9i/A99333-01.zip/software/oracle9i/A99334-01.zip/software/oracle9i/Java131.rte.tar/software/tools/unzip.5.52.tar创建组smitty group创建用户smitty userUnicom_ora1：Unicom_ora2：安装Jre131：（/usr/java131）将Java131.rte.tar解压到/software/oracle9i/jre smitty install--> 安装并更新软件--> 从所有可用软件中安装和更新--> 软件的输入设备／目录：/software/oracle9i/jre--> 要安装的软件：ALL分配磁盘空间smitty jfs2Unicom_ora1mount /oracle1chown -R oracle1:dba /oracle1 Unicom_ora2mount /oracle2chown -R oracle2:dba /oracle2vi /home/oracle1/.profile增加：ORACLE_BASE=/oracle1/oracle; export ORACLE_BASEORACLE_HOME=/oracle1/oracle/product/9.2.0; export ORACLE_HOMEORACLE_SID=mssdb; export ORACLE_SIDORACLE_TERM=vt100; export ORACLE_TERMTNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN#NLS_LANG=american_america.zhs16cgb231280; export NLS_LANGORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib ;export LIBPATH#ORA_DB=$ORACLE_HOME/dbs;export ORA_DBCLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar:$ORACL E_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATHPATH=$ORACLE_HOME/bin:$PATH; export PATHvi /home/oracle2/.profile增加：ORACLE_BASE=/oracle2/oracle; export ORACLE_BASEORACLE_HOME=/oracle2/oracle/product/9.2.0; export ORACLE_HOMEORACLE_SID=mssdb2; export ORACLE_SIDORACLE_TERM=vt100; export ORACLE_TERMTNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN#NLS_LANG=american_america.zhs16cgb231280; export NLS_LANGORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib ;export LIBPATH#ORA_DB=$ORACLE_HOME/dbs;export ORA_DBCLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar:$ORACL E_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATHPATH=$ORACLE_HOME/bin:$PATH; export PATH安装：# /software/oracle9i/01/rootpre.sh 注：假若安装目录为/.../01# echo $DISPLAY10.192.139.242:0.0注：记住该处的输出# su - oracle1$ export DISPLAY=10.192.139.242:0.0注：本IP地址不是服务器的$ cd /software/oracle9i/01$ ./rootpre.shConfiguring Asynchronous I/O...Asynchronous I/O is already defined$ ./runInstaller......Has 'rootpre.sh' been run by root? [y/n] (n)y端口：1521、2100、8080!? /oracle1/oracle/product/9.2.0/Apache/Apache/bin/startJServ.sh !? /oracle2/oracle/product/9.2.0/bin/dbsnmpwd!? /oracle2/oracle/product/9.2.0/bin/dbsnmp。