We have just installed Oracle Workflow Server on 11gR2 Database using below steps:
1. Go to $ORACLE_HOME\owb\wf\install
2. run below script:
Linux: $ ./wfinstall.csh
Windows: wfinstall.bat
3. insert values as below on the form displayed with the above command:
Install Option : Server Only
Workflow Account : owf_mgr
Workflow Password : Specify a password for owf_mgr
SYS Password : Enter SYS password for the database on which we are installing Oracle Workflow.
TNS Connect Descriptor : Descriotion of TNS of Target Database
[ (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME/IP)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MYDB)))]
LDAP Parameters : [If needed]
Mailer Parameters : [If needed]
Tablespace : Default tablespace for worlflow server
4. Submit to start
5. After Successful installation a completion message will be displayed
Thanks to below links:
http://download.oracle.com/docs/cd/B28359_01/owb.111/b31280/install_opts05.htm#i1008852
http://forums.oracle.com/forums/thread.jspa?threadID=663891
Solutions provided here, may or may not be from trusted sources. Please check in test environment before implement these in production.
Thursday, July 14, 2011
Saturday, July 2, 2011
User Trace
In order to trace all the actions by a specific user we can user below log on trigger:
CREATE OR REPLACE TRIGGER myuser_logon_trace
AFTER LOGON ON MYUSER.SCHEMA
BEGIN
execute immediate 'alter session set tracefile_identifier="MYUSER"';
DBMS_SESSION.SET_SQL_TRACE(TRUE);
END;
/
Now, we can find the output of the trace at "user_dump_dest" with "MYUSER" in the name.
CREATE OR REPLACE TRIGGER myuser_logon_trace
AFTER LOGON ON MYUSER.SCHEMA
BEGIN
execute immediate 'alter session set tracefile_identifier="MYUSER"';
DBMS_SESSION.SET_SQL_TRACE(TRUE);
END;
/
Now, we can find the output of the trace at "user_dump_dest" with "MYUSER" in the name.
Subscribe to:
Posts (Atom)