从ONT网上http://www.oracle.com/technology/software/products/workflow/index.html
download 一个安装包,解压后安装,在选择安装路径时提示:“这不是10g oracle_home ”的错误信息,机器已经安装了10G DB的,查资料,发现有人说可以从Oracle Database 10g Companion CD Release 2 中安装。于是又去ONT下载 http://download.oracle.com/otn/nt/oracle10g/10201/10201_companion_win32.zip
下载完后。需要安装
1. Installing Oracle Database 10g Products (Oracle Workflow server)
2. Installing Oracle Database 10g Companion Products(Oracle Workflow middle tier components, Oracle HTTP Server)
先安装1 workflow server,安装完成以后运行 workflow configuration assistant,在弹出的画面中输入相关参数后点‘提交’,弹出一个错误提示:“连接方法无效Local=[”,检查发现这是因为‘TNS连接描叙符’输入错误,正确内容如下:
运行完以后,再安装 Oracle Workflow middle tier components, Oracle HTTP Server,安装过程中需要输入相关信息如下:
安装完成后,会有一个Oracle HTTP Server URL 提示 : http://man-95ea6e1530d:7777。到此整个workflow安装完成。
在安装完成后,还有一些后续动作要处理,
Postinstallation Tasks for Oracle Workflow Server
Checking Initialization Parameter Values
Parameter | Required Value |
AQ_TM_PROCESSES | Greater than 1 |
JOB_QUEUE_PROCESSES | 10 or greater |
To check the values of these initialization parameters and change them if necessary:
1. Log in to the database as the SYS user:
c:\> sqlplus sys/SYS_password as sysdba
- To determine the current value for all initialization parameters, enter the following command:
SQL> SHOW PARAMETER parameter_name
- To alter the value of an initialization parameter, enter a command similar to the following:
SQL> ALTER SYSTEM SET parameter_name=value
- If the database is not using a server parameter file, edit the value specified for the parameter in the initialization parameter file (initsid.ora).
- 在Enterprise Manager中,为Workflow管理员用户如OWF_MGR添加“Execute Any Procedure”权限,添加“Create any job”。
或者使用SQLPLUS完成:
sqlplus “/as sysdba”
sql>grant execute any procedure to owf_mgr
sql>grant create any job to owf_mgr
Compiling Invalid Objects
Log into the Oracle database and run the utlrp.sql script. to compile any invalid objects in the SYS schema. For example:
c:\> sqlplus sys/SYS_password as sysdba
SQL> @C:\oracle\product\10.2.0\db_1\rdbms\admin\utlrp.sql
Logging into the Oracle Workflow Home Page,
To access the Oracle Workflow home page, connect as a valid Oracle Workflow user to the following URL: http://hostname:port/pls/wf/wfa_html.home
Logging into Oracle Workflow Manager
The Oracle Workflow server installation includes the Oracle Workflow Manager component of Oracle Enterprise Manager. This component provides administrative and management tools for Oracle Workflow. When you install Oracle Workflow into your Oracle Database home, Oracle Workflow Configuration Assistant configures Oracle Workflow Manager. It creates two Oracle Application Server Containers for Java 2 Enterprise Edition (OC4J) instances:
· OC4J_Workflow_Component_Container: Workflow Configuration Assistant deploys two applications within this instance. One application runs the agent listener service components and the other runs notification mailer service components.
· OC4J_Workflow_Management_Container: Workflow Configuration Assistant deploys one application within this instance to implement the Oracle Workflow Manager user interface.
Starting, Stopping, or Restarting the OC4J Instances
To start these instances, run the following scripts:
ORACLE_BASE\ORACLE_HOME\wf\admin\wfmgrstart.bat
ORACLE_BASE\ORACLE_HOME\wf\admin\wfsvcstart.bat
You can stop and restart the OC4J instances in which Oracle Workflow Manager is deployed. To stop the instances, run the following scripts:
ORACLE_BASE\ORACLE_HOME\wf\admin\wfmgrstop.bat
ORACLE_BASE\ORACLE_HOME\wf\admin\wfsvcstop.bat
在Run wfmgrstart.bat,wfsvcstart.bat 以后,帐号 OWF_mgr 会自动锁住,其状态为LOCKED(TIMED).像之前的帐号sysman一样,当解锁后不久他又会被自动锁上,在网上找到的解决方法如下:
Step :
1. Start all of the Oracle Service, except for the OC4J
If you have already started OC4J, then stop them
Unlocked the
2. Search in your Oracle Home : data-sources.xml
There should be two files,
one is in the ...\OC4J_Workflow_Component_Container\application-deployments\WFALSNRSVCAppthe other is in ...\OC4J_Workflow_Component_Container\application-deployments\WFMLRSVCApp
3. Make sure, you create back up of them.
4. Replace the following line
password="->pwForOwfMgr"
with
password="",
should be look like this
password="a"
5. Now start the OC4J using wfmgrstart.bat and wfsvcstart.bat
6. Next, login to the Oracle Workflow Manager
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14142626/viewspace-329629/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14142626/viewspace-329629/