OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » oracle Apex query (oracle apex 3.1.2 oracle 10 g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle Apex query [message #612938]

Mon, 28 April 2014 02:47

spatava
Messages: 12
Registered: April 2012
Location: Pune india

Junior Member

Hi Dear,
I lost my apex password. also not aware of admin users password for apex.
I tried to connect apex with the password present in DADS.conf file. But its not connecting.
Could you please help to reset or extract the password?

Thanks,
Suchita Patava

Report message to a moderator

Re: oracle Apex query [message #612939 is a reply to message #612938]

Mon, 28 April 2014 02:49

John Watson
Messages: 8805
Registered: January 2010
Location: Global Village

Senior Member

Use the $ORACLE_HOME/apex/apxchpwd.sql script.

Report message to a moderator

Re: oracle Apex query [message #612963 is a reply to message #612939]

Mon, 28 April 2014 05:51

spatava
Messages: 12
Registered: April 2012
Location: Pune india

Junior Member

Thanks John for reply...
Could you please elaborate what needs to be done in detail..

Report message to a moderator

Re: oracle Apex query [message #612964 is a reply to message #612963]

Mon, 28 April 2014 05:57

Littlefoot
Messages: 21761
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Connect to SQL*Plus as SYS and run the APXCHPWD.SQL. You'll be prompted for a new Apex Admin password. Once you set it, connect as admin to Application Express and then reset password for any other user (developer, end user, whoever).

Report message to a moderator

Re: oracle Apex query [message #612966 is a reply to message #612964]

Mon, 28 April 2014 06:25

spatava
Messages: 12
Registered: April 2012
Location: Pune india

Junior Member

Many thanks John and Littlefoot.....

Report message to a moderator

Previous Topic:	Apex installation problem
Next Topic:	Creating APEX users/groups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 02:07:15 CDT 2023