This content has been marked as final. Show 2 replies
I found out the issue. Actual DB user referred in doc was different than what was got created when I install APEX.
In example it was mentioned as "APEX_040100". Where as in my DB it was not present. My DB has "APEX_040000" and "APEX_040200".
I changed the script to have APEX_040000 and it worked.
Now again when I changed to script to APEX_040200, and ran, it is failing. Not sure, if we need to run for both users. Any pointers here?
Thanks in advance.
Having multiple APEX_0% users suggests your database has originally started with APEX 4.0 and has been upgraded as subsequent versions are released (4.1.x, 4.2.x).
These accounts should be removed, as per the installation guide.
Your current APEX owner would be APEX_040200, and you should be reading documentation pertinent to your APEX version.
blog: [url grassroots-oracle.com]grassroots-oracle.com
twitter: [url twitter.com/swesley_perth]@swesley_perth
-- please mark any useful posts as helpful or correct, in the end it helps us all