Re: EBS login page not opening after db upgrade

Posted by karthikmca.bhc on Dec 01, 2022; 2:09pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-login-page-not-opening-after-db-upgrade-tp11287p11302.html

Hi,

I found the below entry in available in working instance but in problematic instance the apps node entry is missing. I guess if we make apps node entry available in our problematic instance then the login page may come. Please see below and advise.


From Login page working instance:
--------------------------------------------
appldev@tp2esapps:/u01/appldev $ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Dec 1 13:51:10 2022
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> col NAME format a30
SQL> select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID;

NAME SERVER_TYPE
------------------------------ ------------------------------
tp2esapps_PRODUPG_APPS APPS
tp2esdb_PRODUPG_DB DB

SQL>



From Login page not working instance:
------------------------------------------------
oracle@p2esdbprd:/u01/oracle $ sqlplus apps/apps

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 1 13:44:04 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Thu Dec 01 2022 13:39:59 +03:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> col NAME format a20
SQL> select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID;

NAME SERVER_TYPE
-------------------- ------------------------------
p2esdbprd_P2ESUPG_DB DB

SQL>

The application node entry is missing from the instance that we face login page issue.

Please advise.