JohonMedison 2013-02-04
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.