Node id does not exist for the current application server id

Node ID does not exist for the current application server ID errors [ID 359998.1]

Symptoms

On entering Oracle Applications on the web, the following error appears:

Node ID  does not exist for the current application server id.


This error also occurs at the time of starting / stopping Apache.

adapcctl.sh start

adapcctl.sh stop


Cause:


There is a mismatch between server_id in the  fnd_nodes table and appl_server_id in the dbc file and
hence we are getting this  "node id does not exist" error.

Solution:
=========
Do a select on the server_id in the  fnd_nodes table:

Here is an example of what it could look like:

 server_id=EA99227ED75CFE4EE030149077C4515496138833635529486962342698410274

Do a search on APPL_SERVER_ID in the .dbc file:
It could show something like:

 APPL_SERVER_ID=EA99220924EF823FE030149077C450C096138833635529486962342698410274

Please  manually comment out the APPL_SERVER_ID in the .dbc file

Then re-run adgendbc.sh  and it will  seed the node and get a good  application id.

If the server_id is missing from the FND_NODES table, ie. if the above SQL does not return anything

To get the FND_NODES table populated with the correct server ID, you may have to use

Note 260887.1 ->Steps to Clean Nonexistent Nodes or IP Addresses from   FND_NODES




Issue 1*:

When trying to open Forms, all forms error out with the below message in Oacle application
R12.

Issue 2:
=====
When i am starting and stopping the apache server getting below error in oracle application 11i.

adapcctl.sh stop

adapcctl.sh version 115.55

Node id does not exist for the current application server id.
Apache Web Server Listener :httpd ( pid 4368 ) is running.
Stopping Apache Web Server Listener (dedicated HTTP) ...
Node id does not exist for the current application server id.
Node id does not exist for the current application server id.
Apache Web Server Listener (PLSQL) :httpd ( pid 4403 ) is running.
Stopping Apache Web Server Listener (dedicated PLSQL) ...
Node id does not exist for the current application server id.

adapcctl.sh: exiting with status 0

Solution:

=======

Run adgendbc.sh file to configure the apps tier dbc file with the correct id from the database instance.

Location :

11i  cd  $COMMON_TOP/admin/install/$CONTEXT_NAME

R12  cd $INST_TOP/admin/install

you can run adgendbc.sh file when the services are up and running.

Lets see how to run it.

================

[applmgr@apps scripts]$ cd $INST_TOP/admin/install
[applmgr@apps install]$ ls -tlrh adgendbc.sh
-rwx------  1 applmgr dba 16K Apr 28 12:40 adgendbc.sh
[applmgr@apps install]$ sh adgendbc.sh

adgendbc.sh started at Thu May  2 12:45:05 IST 2013


Enter the APPS username: apps

Enter the APPS password:

SQL*Plus: Release 10.1.0.5.0 - Production on Thu May 2 12:45:09 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

Unique constraint error (00001) is OK if key already exists
Application server ID already exists for this host - loading..
ADD executed successfully - /u02/inst/apps/PROD_apps/appl/fnd/12.0.0/secure/PROD.dbc

Trying to update information ...

Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/inst/apps/PROD_apps/appl/fnd/12.0.0/secure/PROD.dbc
Updating parameters:  fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5 fnd_jdbc_buffer_decay_interval=300
Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/inst/apps/PROD_apps/appl/fnd/12.0.0/secure/PROD.dbc
Updating parameters:  fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false fnd_jdbc_context_check=true
Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/inst/apps/PROD_apps/appl/fnd/12.0.0/secure/PROD.dbc
Updating parameters:  fnd_jdbc_plsql_reset=false
Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/inst/apps/PROD_apps/appl/fnd/12.0.0/secure/PROD.dbc

Updating Server Security Authentication
AUTHENTICATION SECURE executed successfully - /u02/inst/apps/PROD_apps/appl/fnd/12.0.0/secure/PROD.dbc
adgendbc.sh exiting with status 0
ERRORCODE = 0 ERRORCODE_END
[applmgr@apps install]$

Now launch forms you will not get the  error.

Note *: No need to bounce the application tier service (OR) web/forms services,just log out and login back.

Thanks for visiting my blog and happy learning !!!! To check older post click on the bottom of the page.