maximo安装

1 虚拟机使用的是JDK1.4，而maximo最佳支持是1.6，管理员用户视图流程显示存在问题。

2 安装过程出现table not found错误，查看源码，发现是Oracle Text 组件未安装，因此第一步：安装oracle text 组件

   参考http://www.cnblogs.com/mybook/archive/2012/12/17/2822299.html

   首先第一步查看是否安装Oracle Text，使用命令

select username from dba_users where username='CTXSYS'

    首先登录数据库实例，然后执行以下命令

    逐行执行如下脚本

//未为全文检索创建表空间，使用的SYSAUX空间
@D:\program\oracle\product\11.2.0\dbhome_1\ctx\admin\catctx.sql oracle SYSAUX TEMP NOLOCKc

@D:\program\oracle\product\11.2.0\dbhome_1\ctx\admin\catctx.sql oracle SYSAUX TEMP NOLOCK

connect "CTXSYS"/"oracle"


@D:\program\oracle\product\11.2.0\dbhome_1\ctx\admin\defaults\dr0defin.sql "AMERICAN" 
//英文全文检索，可能存在问题

set pages 1000

col object_name format a40
col object_type format a20
col comp_name format a30
column library_name format a8
column file_spec format a60 wrap

  注意：该步骤可能会报错，执行如下操作：

  1） 给ctx用户赋dbms_lobs权限

  2） 由于对组件进行了改动，因此用sys登录后重新编译

  密码oracle可能安全级别过低，因此使用了高级别的密码，比如oracle123

3 创建表空间，用户，付给权限，执行如下命令

Create tablespace SCCDDATA datafile 'D:\program\oracle\oradata\maximo\SCCDDATA.DBF' size 1500M autoextend on;

Create user maximo identified by max123 default tablespace SCCDDATA temporary tablespace TEMP;

grant create job to maximo; 
grant create trigger to maximo; 
grant create session to maximo;
grant create sequence to maximo;
grant create synonym to maximo;
grant create table to maximo;
grant create view to maximo;
grant create procedure to maximo;
grant alter session to maximo;
grant execute on ctxsys.ctx_ddl to maximo; 
grant dba to maximo;
alter user maximo quota unlimited on SCCDDATA;

 注意：可能出现的错误

 数据库ERROR:ORA-12560: TNS: 协议适配器错误的解决方法: 指定数据库的sid

 set oracle_sid = maximo，或在系统变量里设定oracle_sid = maximo

备份及恢复数据库命令：

备份：

imp maximo/max123@maximo file=E:\ora2013-2-1.dmp full=Y

恢复：

exp maximo/max123@orabiz file=/tmp/20130204.dmp full=Y

 dump可能会失败，原因可能是游标值过小，尝试将游标值设大 

alter system set open_cursors=1500;

 可使用

D:\IBM\SMP\maximo\tools\maximo>maxinst.bat -sSCCDDATA -tSCCDDATA

命令恢复数据库， 发生错误，如下

DBPROBLEM_PMP: V710-0, Current release DB build: V7102-01, Last release DB build
: V710-59
Database update in progress, please wait..........
Current version :V710-0
Updating To     :V7102-01
java.sql.SQLException: ORA-01000: 超出打开游标的最大数
ORA-01000: 超出打开游标的最大数

 增大即可

4 安装weblogic

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

          WLS Zip Distribution for Oracle WebLogic Server 10.3.6.0

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

The WLS zip distribution is intended for development use. It is supported on 

Windows, Linux and Mac OS X systems. It contains the necessary artifacts to 

develop and test applications on WebLogic Server.  

An optional supplemental zip (wls1036_dev_supplemental.zip) is 

available as a separate download. The supplemental zip contains samples, 

evaluation database (Derby) and L10N console help files. 

The following instructions should help in quickly setting up WLS. Please refer 

to the general WLS documentation for detailed instructions.

QUICKSTART

----------

4.1. Extract the contents of the zip to a directory. This directory is now the 

   MW_HOME (eg: /home/myhome/mywls)

4.2. Setup JAVA_HOME and MW_HOME variables in the current shell

  Linux

    $ export JAVA_HOME=/home/myhome/myjavahome

    $ export MW_HOME=/home/myhome/mywls

  Mac

    $ export JAVA_HOME=

      /System/Library/Frameworks/JavaVM.framework/Versions/1.6/Home

    $ export MW_HOME=/home/myhome/mywls

  Windows

    > set JAVA_HOME=C:\home\myhome\myjavahome

    > set MW_HOME=C:\home\myhome\mywls

    This version of WLS requires JDK 1.6. For Mac use 1.6.0_20 latest update. 

    Ensure that you have the proper JDK version installed.

4.3. Run the installation configuration script in the MW_HOME directory

   (This step is required to be run only once. If you move the installation to 

    another location/machine, you need to rerun this step)

  Linux/Mac

    $ ./configure.sh 

  Windows

    > configure.cmd

  This step also sets the WLS environment for the current shell. So, the next

  step can be ommitted.

4.4. Setup WLS environment in the current shell. 

   Linux

    $ . $MW_HOME/wlserver/server/bin/setWLSEnv.sh 

   Mac

    $ export USER_MEM_ARGS="-Xmx1024m -XX:PermSize=256m"

    $ . $MW_HOME/wlserver/server/bin/setWLSEnv.sh 

   Windows

    > %MW_HOME%\wlserver\server\bin\setWLSEnv.cmd

4.5 以图形化界面创建domain

   > %MW_HOME%\wlserver\common\bin\config.cmd

4.6 将domain内setDomainEnv内，增大虚拟机内存

   -Xms512m -Xmx512m 

4.7 进入domain执行startWebLogic命令

4.8 安装maximo，顺序点击安装即可

4.9 浏览器进入'http://localhost:7001/console'，部署maximo

附：官方文档

~. Create a new WLS domain and start WLS.

   (It is recommended that you create the domains outside the MW_HOME)

   Linux

    $ mkdir /home/myhome/mydomain

    $ cd /home/myhome/mydomain

    $ $JAVA_HOME/bin/java -Xmx1024m -XX:MaxPermSize=128m weblogic.Server

   Mac

    $ mkdir /home/myhome/mydomain

    $ cd /home/myhome/mydomain

    $ $JAVA_HOME/bin/java -Xmx1024m -XX:MaxPermSize=256m weblogic.Server

   Windows

    $ mkdir C:\home\myhome\mydomain

    $ cd C:\home\myhome\mydomain

    $ %JAVA_HOME%\bin\java.exe -Xmx1024m -XX:MaxPermSize=128m weblogic.Server

   Once the domain is created, you can shutdown WLS and restart it with the 

   scripts provided in the newly created domain. 

   Note: You can also create the domain by invoking the GUI configuration

   wizard (Run MW_HOME/wlserver/common/bin/config.[sh|cmd])

6. If you already have an existing domain that you want to run with this 

   installation, edit the DOMAIN_HOME/bin/setDomainEnv.sh script and change the 

   WL_HOME to point to the new installation - ${MW_HOME}/wlserver/

   Note: If the existing domain has samples configured, the server will issue

   failures during startup as samples are not included in the zip distribution.

7. Start a browser and open up url - 'http://localhost:7001/console' to 

   administer the server.

8. If you need samples, evaluation database (Derby) or console help files for

   for non-english locales, you can download the supplemental zip and extract 

   it under MW_HOME. Follow instructions in README_SUPP.txt to properly setup

   samples.