Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Friday, February 13, 2009

Portal 3.0.9 first page appears on accessing /oa_servlets/AppsLogin

While logging on to a test instance, I saw this error:
Forbidden
You don't have permission to access /pls/$TWO_TASK_portal30/portal30.home on this server.

apache access_log shows

192.168.11.23 - - [13/Feb/2009:10:41:14 -0500] "GET /pls/$TWO_TASK_portal30/portal30.home HTTP/1.1" 403 245 0

access_log_pls shows


error_log_pls shows
[Fri Feb 13 10:40:56 2009] [error] mod_plsql: /pls/$TWO_TASK_portal30/portal30.home HTTP-403 ORA-1017 Proxy log On failed.
Please verify that you have specified correct connectivity information i.e. username, password & connect-string in the DAD
[Fri Feb 13 10:41:14 2009] [error] mod_plsql: /pls/$TWO_TASK_portal30/portal30.home HTTP-403 ORA-1017 Proxy log On failed.
Please verify that you have specified correct connectivity information i.e. username, password & connect-string in the DAD

I checked the wdbsvr.app file and found this in the portal30 DAD:

[DAD_apps11i_portal30]
connect_string  =  apps11i
password        =  secretseven
username        =  portal30
default_page    =  portal30.home
document_table  =  portal30.wwdoc_document
document_path   =  docs
document_proc   =  portal30.wwdoc_process.process_download
upload_as_long_raw =
upload_as_blob  = *
reuse           =  Yes
connmax         = 10
enablesso       = Yes
pathalias       = url
pathaliasproc   = portal30.wwpth_api_alias.process_download
cgi_env_list=SERVER_NAME=apps11i.justanexample.com,
REQUEST_PROTOCOL=http,SERVER_PORT=8002,HOST=apps11i.justanexample.com:8000

I checked in the db

SQL> conn portal30/secretseven
ERROR:
ORA-01017: invalid username/password; logon denied

Since this was a test instance, I decided to see what happens if we change the password of portal30 user to secretseven.

So I changed the password of portal30 to secretseven

conn / as sysdba
alter user portal30 identified by secretseven

Accessing the /oa_servlets/AppsLogin page took me to:

http://apps11i.justanexample.com:8000/servlet/page?_pageid=51&_dad=apps11i_portal30&_schema=PORTAL30

which showed the Oracle Portal 3.0.9 first page:

I tried accessing it through: 
http://apps11i.justanexample.com:8000/OA_HTML/AppsLocalLogin.jsp

That showed me the expected username and password page:


Will update as I learn more.

No comments: