Node ID does not exist for the current application server id

-
While Running Oracle Applications on the web, the following error appears:

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

 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:

Stop application.
Run adgendbc.sh script to configure apps tier dbc file with the correct id from the database instance.
Start the application and retest.

Location of script:
11i: $COMMON_TOP/admin/install/$CONTEXT_NAME
R12: $INST_TOP/admin/install

 Below is the Example. 
[oraprod@apps oraAP]$ cd $INST_TOP

[oraprod@apps POLPROD_apps]$ pwd
/oraprod/oraAP/fs2/inst/apps/POLPROD_apps
[oraprod@apps POLPROD_apps]$ cd admin/install/
[oraprod@apps install]$ ./adgendbc.sh

 adgendbc.sh started at Wed Feb 19 10:21:03 EAT 2020
Enter the APPS username: apps

 Enter the APPS password:

 SQL*Plus: Release 10.1.0.5.0 - Production on Wed Feb 19 10:21:10 2020

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

 Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ APPS_DATABASE_ID ]
Application Id : 0
Profile Value  : POLPROD
Level Name: SITE
INFO           : Updated/created profile option value.
.

 PL/SQL procedure successfully completed.
Commit complete.

 Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
==============================
* * * * DBC PARAMETERS * * * *
==============================
fnd_jdbc_buffer_min=1
fnd_jdbc_buffer_max=5
fnd_jdbc_buffer_decay_interval=300
fnd_jdbc_buffer_decay_size=5
fnd_jdbc_usable_check=false
fnd_jdbc_context_check=true
fnd_jdbc_plsql_reset=false

====================================
* * * * NO CUSTOM PARAMETERS * * * *
====================================

Unique constraint error (00001) is OK if key already exists

 Creating the DBC file...
ADD executed successfully - /oraprod/oraAP/fs2/inst/apps/POLPROD_apps/appl/fnd/12.0.0/secure/POLPROD.dbc

 Updating Server Security Authentication
AUTHENTICATION SECURE executed successfully - /oraprod/oraAP/fs2/inst/apps/POLPROD_apps/appl/fnd/12.0.0/secure/POLPROD.dbc

 adgendbc.sh ended at Wed Feb 19 10:21:23 EAT 2020

 adgendbc.sh exiting with status 0
ERRORCODE = 0 ERRORCODE_END

[oraprod@apps install]$

 Once it get completed successfully start all the application services for EBS. 

Comments

Post a Comment

Popular posts from this blog

ORA-06512: at SYS.DBMS_METADATA_UTIL Error

-
 If you face an error like the following while performing “impdp” operations: Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01001: invalid cursor ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 3343 ORA-06512: at "SYS.KUPM$MCP", line 2636 ORA-39097: Data Pump job encountered unexpected error -1001 Solution: execute the following command: SQL> exec dbms_metadata_util.load_stylesheets; If the above query executes sucessfully then try the “impdp” command again. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 SQL> exec dbms_metadata_util.load_stylesheets; PL/SQL procedure successfully completed. SQL>
Read more

RC-00118: Error occurred during creation of database Raised by oracle.apps.ad.clone.ApplyDatabase

-
Error Occurred :– Trying to connect using SID as ServiceName.DomainName getConnectionUsingServiceName() –> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oratest.tipl.com)(PORT=1532))(CONNECT_DATA=(SERVICE_NAME=TIR12.ticfg.com))) Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection Connection could not be obtained; returning null RC-00118: Error occurred during creation of database StackTrace: java.lang.Exception: Control file creation failed at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:661) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304) at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.re...
Read more

The install cannot proceed as service OracleServiceXE is present on the system

-
If you are not able to remove oracle from the above workaround. Please follow below steps to remove OracleServiceXE. Solution:– Try to delete the service using the command prompt: Click Start, type ‘cmd’ in the search field, and when ‘cmd’ shows up in the list of options, right click it and select ‘Run as Administrator’. At the Command Prompt window, type “sc delete OracleServiceXE” without the quotes and press Enter. Type “Exit” and press Enter. Hope it helps. C:\> sc stop OracleServiceXE                      (to Stop service) C:\> sc delete OracleServiceXE                      (to remove)
Read more