DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, January 19, 2017

Permission access denied in APEX with companion

Log file detail :-

ORA-1017 ORA-01017: invalid username/password; logon denied\n


cd $ORACLE_HOME/Apache/modplsql/conf

$ vim dads.conf   

Alias /i/ "/u02/app/oracle/product/10.2.0/ias/Apache/Apache/images/"

AddType text/xml xbl
AddType text/x-component htc

<Location /pls/apex>
  SetHandler pls_handler
  Order deny,allow
  Allow from all
  AllowOverride                 None
  PlsqlDatabaseUsername         APEX_PUBLIC_USER
  PlsqlDatabasePassword         oracle
  PlsqlDatabaseConnectString    192.168.1.20:1521:apex
  PlsqlAuthenticationMode       Basic
  PlsqlDefaultPage              apex
  PlsqlDocumentTablename        wwv_flow_file_objects$
  PlsqlDocumentPath             docs
  PlsqlDocumentProcedure        wwv_flow_file_mgr.process_download
  PlsqlNLSLanguage              AMERICAN_AMERICA.AL32UTF8
</Location>

Change the password in dads.conf file and in database level

Solution:-

SQL >ALTER USER APEX_PUBLIC_USER  IDENTIFIED BY oracle;

No comments: