Admin password change for Apex 3.2 in Oracle XE


 

apxchpwd.sql is used to change the password.

You will be prompted for

'Enter a password for the ADMIN user '


 

Enter it and your password is changed


 

See the apex admin password change script provided by Oracle

Rem Copyright (c) Oracle Corporation 1999 - 2007. All Rights Reserved.

Rem

Rem NAME

Rem apxchpwd.sql

Rem

Rem DESCRIPTION

Rem Used to set the password for the Application Express ADMIN user.

Rem

Rem NOTES

Rem Assumes the SYS user is connected.

Rem

Rem REQUIREMENTS

Rem - Oracle 9.2.0.3 or later

Rem

Rem

Rem MODIFIED (MM/DD/YYYY)

Rem jstraub 08/08/2007 - Created

Rem jstraub 09/04/2007 - Added HIDE to PASSWD accept (Bug 6370075)

Rem jkallman 09/09/2008 - Change FLOWS_030100 references to APEX_030200

Rem


 

set define '&'


 

set verify off


 

prompt Enter a value below for the password for the Application Express ADMIN user.

prompt

prompt


 

accept PASSWD CHAR prompt 'Enter a password for the ADMIN user [] ' HIDE


 

alter session set current_schema = APEX_030200;


 

prompt ...changing password for ADMIN


 

begin


 

wwv_flow_security.g_security_group_id := 10;

wwv_flow_security.g_user := 'ADMIN';

wwv_flow_security.g_import_in_progress := true;


 

for c1 in (select user_id

from wwv_flow_fnd_user

where security_group_id = wwv_flow_security.g_security_group_id

and user_name = wwv_flow_security.g_user) loop


 

wwv_flow_fnd_user_api.edit_fnd_user(

p_user_id => c1.user_id,

p_user_name => wwv_flow_security.g_user,

p_web_password => '&PASSWD',

p_new_password => '&PASSWD');

end loop;


 

wwv_flow_security.g_import_in_progress := false;


 

end;

/

commit;


 


 


 


 


 

Comments

Post a Comment

Popular posts from this blog

PRKH-1010 : Unable to communicate with CRS services

OS : AIX 5L Oracle 10g RAC Error message on one of the nodes PRKH - 1010 : Unable to communicate with CRS services I faced a typical issue.     The localconfig command has been used for a single instance RDBMS. There is absolutely no requirement to run localconfig on RAC system and it should never be used on RAC system as it will destroy the CRS configuration When the localconfig reset was run on only one system the following things happened. Ocr.loc was created at /etc/oracle/ora.loc. Cat /etc/oracle/ocr.loc is like : Ocrconfig_loc=<$ORACLE_HOME>/cdata/localhost/local.ocr Local_only=true   Cat /etc/inittab is like H1:35:respaw:/etc/init.d/init.evmd run >/dev/null 2>&1</dev/null H3:35:respawn:/etc/init.d/init.crsd run >/dev/null 2>&2 </dev/null H1:35:respawn:/etcc/init.d/init.dcssd run >/dev/null 2>&1 </dev/null<<< this one   As root Run the following scripts $ORA_CRS_HOME/install/rootdelete.sh $ORA_CRS_HOME/install/rootdeinstall
Read more

vi Commands

What is vi? The default editor that comes with the UNIX operating system is called vi (visual editor). The UNIX vi editor is a full screen editor and has two modes of operation: Command mode commands which cause action to be taken on the file, and Insert mode in which entered text is inserted into the file. In the command mode, every character typed is a command that does something to the text file being edited; a character typed in the command mode may even cause the vi editor to enter the insert mode. In the insert mode, every character typed is added to the text in the file; pressing the (Escape) key turns off the Insert mode. While there are a number of vi commands, just a handful of these is usually sufficient for beginning vi users. To assist such users, this Web page contains a sampling of basic vi commands. The most basic and useful commands are marked with an asterisk (* or star) in the tables below. With practice, these commands should become automatic. NO
Read more

Determining if an Oracle Software Owner User Exists

Determining if an Oracle Software Owner User Exists To determine whether an Oracle software owner user named oracle exists, enter the following command: # id oracle If the oracle user exists, then the output from this command is similar to the following: uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)
Read more