Pages

Sunday, September 2, 2012

Unable to Open Help Link in ORacle APEX



We need to give an access of the Oracle TEXT URL  datastore to the APEX_030200 user such .

create a role, assign it to the APEX_030200 database user and grant the required permission to the role.


SQL> SELECT par_value FROM ctxsys.ctx_parameters WHERE par_name = 'FILE_ACCESS_ROLE';

PAR_VALUE
--------------------------------------------------------------------------------

SQL> CREATE ROLE APEX_URL_DATASTORE_ROLE;

Role created.

SQL> GRANT APEX_URL_DATASTORE_ROLE to APEX_030200;

Grant succeeded.

SQL> EXEC ctxsys.ctx_adm.set_parameter('file_access_role', 'APEX_URL_DATASTORE_ROLE');

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

 If the role exists, then just grant this role to the APEX_030200 user. 

2 comments:

  1. Oracle Apex slowness is big issue for me. Thanks in advance for your solution. Following are details of the problem. I am using Oracle 11g R2, in Red Hat Linux. Dual processor with 32 GB RAM,600 GB HDD. I upgraded default apex to Apex 4.1.1. I set the SHARED_SERVERS=10. But Apex builder as well as application is very slow. Some times it become faster again page submit and loading became slow. Lastly I upgraded to Apex 4.2 but still facing same slowness. Please help me in this regards.

    ReplyDelete
  2. You need to check the shared pool memory size , Kindly! follow the apex admin guide . This will get resolve :)

    ReplyDelete