EBS LOGIN PAGE ISSUE:
Step to troubleshoot:
step 1. Check firewall status and disabled it (Otherwise add Ports to allow in the firewall exception list).
steps 2. Check your ebs login port is open or not through telnet.
step 3. Check oacore logs file.
In my case step 3 works in oacore logs I have found the below issue:
Log File: /apps/R12.2/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD/servers/oacore_server1/logs/oacore_server1.log
Observation and Findings:
I have checked in DB the expired users list and found that APPLSYSPUB user is showing expired Status.
Note:- APPLSYSPUB/PUB - is the default public username and password that grants access to oracle E-business suite initial sign-on form. In EBS Application at the time of login, oracle application connect to public schema - APPLSYSPUB. It has the sufficient privilege to perform the authentication of FND user (Application users) which includes the PL/SQL packages to verify the username/password and the privilege to record the success or failure of a login attempt.
SQL> select username,account_status from dba_users where USERNAME='APPLSYSPUB';
USERNAME ACCOUNT_STATUS
-------------------- --------------------------------
APPLSYSPUB EXPIRED
Solution:
[applmgr]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYSPUB PUB
Now, Oracle E-business Suite Login page is working fine..!!
Consulting services provided by GenexDBS
ReplyDeleteBusiness advisory firms in India can not only help us detect and solve problems, but they can also protect us from threats and provide us with innovative ideas to improve the stability and profitability of our businesses. Database Security
In an IT context, Genexdbs' 24/7 support is referred to as 24/7 support. Among the many IT services this term covers are server monitoring, call center support, and database support. Maintenance of services that must run continuously is one example of this kind of support.
GenexDB's remote DBA service allows companies to outsource the administration of their database platforms. Remote services are provided by businesses from their location.
The remote DBA services include the monitoring and administration of the designated database server installation by independent third parties. In addition to monitoring database space and memory, DBAs handle error log alerts, perform backups, and check error logs.
There are a number of ways DBAs can carry out remote monitoring. Administrators can use individual connections for this purpose. Performance monitoring can be carried out remotely. A script can also be developed to collect system performance and health data, which is then sent to the database administrator for review.