This blog contains different things for Oracle DBA, APPS DBA and Middleware technologies. All these things should be tested first on test environments before applying in the Prod environments, please follow the standard Change control to apply all the PreProd and Prod changes. Also to make this blog more useful, please give your comments and share your experience. Thanks
Search This Blog
Saturday, 9 July 2011
Oracle Application APEX admin user password reset by script
Introduction:
If you dont know the password for admin user of Oracle Application APEX, and if version of APEX is 3 or higer then the password of admin can be reset by a script.
CookBook:
There is script in the directory of apex softwae and the script name is apxchpwd.sql, this can be run with sys user on sqlplus and it will ask the new password for admin, just type the new password and use it.
Oracle Application APEX admin user
Introduction:
How to create a second amdin user for Oracle Application APEX.
CookBook:
1- unlock the account FLOWS_030000 and login with FLOWS_030000 to Database where APEX was installed.
2- run the following procedure
begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);
wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin2',
p_email_address => 'admin2@test.com',
p_web_password => 'admin2') ;
end;
/
3- test the new admin account from the url
http:/appserver.test.com:7778/pls/apex/apex_admin
it will ask the new admin username and password, in our case the username is "admin2" and password is "admin2", once logged in, the APEX will ask to change the old password.
4- in case you dont know the password for FLOWS_030000, you can change the password and once run the procedure in point 2, the FLOWS_030000 should be locked.
How to create a second amdin user for Oracle Application APEX.
CookBook:
1- unlock the account FLOWS_030000 and login with FLOWS_030000 to Database where APEX was installed.
2- run the following procedure
begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);
wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin2',
p_email_address => 'admin2@test.com',
p_web_password => 'admin2') ;
end;
/
3- test the new admin account from the url
http:/appserver.test.com:7778/pls/apex/apex_admin
it will ask the new admin username and password, in our case the username is "admin2" and password is "admin2", once logged in, the APEX will ask to change the old password.
4- in case you dont know the password for FLOWS_030000, you can change the password and once run the procedure in point 2, the FLOWS_030000 should be locked.
Friday, 1 July 2011
To find the sid and serial# of a Concurrent Request in Oracle Financials R 11i and R12
Objective:
Some times we need to kill a hang concurrent request, and to kill it, we need to find the sid and serial# of that concurrent request.
Cookbook:
Following SQL query can be run with APPS user on APPS Database , it will need to provide the concurrent request id, and then it will give the sid and serial# of that concurrent requests, more information can also be obtained from v$session and v$sqlarea views.
Following is the SQL query
----------
SELECT ses.sid,
ses.serial#
FROM v$session ses,
v$process pro
WHERE ses.paddr = pro.addr
AND pro.spid IN (SELECT oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id = &request_id);
---------
Subscribe to:
Posts (Atom)
Oracle 19c - patch 19.22 unavailability for Windows platform
Oracle 19c - patch 19.22 unavailability for Windows platform Having upgraded the Oracle 11g 11.2.0.4 database to Oracle 19c 19.3.0.0.0 whi...
-
Oracle 12c Installer error - [INS-10102] Installer initialization failed - no oraInstaller in java.library.path - make sure oraInst.lo...
-
Introduction: This post is related to describe the Report server issue with Oracle 9i AS R2. For this release of Application Server, the X S...
-
Introduction: In this article we will see, the impact of "Parallel" clause of rebuilding a partition index. We would also enable t...