Thursday, January 21, 2010

Default password in oracle

Username Password
applsys apps
ctxsys change_on_install
dbsnmp dbsnmp
outln outln
owa owa
perfstat perfstat
scott tiger
system change_on_install
system manager
sys change_on_install
sys manager

Previous post issue.

Please confirm that Workflow Deferred Agent Listener and Workflow Java Deferred Agent Listener are now up and running


Once Ready messages are almost 0 execute the concurrent request once again.

SQL> select decode(wfe.state,0,'0 = Ready',1,'1 = Delayed',2,'2 = Retained',3,'3 = Exception',to_char(substr(wfe.state,1,12))) State, count(*) COUNT from applsys.wf_deferred wfe group by wfe.state;

If still an issue please login as SYSADMIN and in System Administrator responsibility Define Users function --> Query an affected user --> End Date the user --> Save --> remove the end date --> save and retest

There are no active responsibilities available for this user

User not showing the Responsibility attached to it. giving the message "' There are no active responsibilities available for this user.""

Solution:

1. Submit the following conc. requests

'Sync responsibility role data into the WF table'.
"Synchronize WF LOCAL tables".
"Workflow Directory Services User/Role Validation" (with parameters 10000, yes, yes, yes).

2. Now, check if the same issue still persists

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...