Monday, April 15, 2013

EBS LISTENER PORT INFORMATION STORED IN FND_TNS_LISTENER_PORTS

FND_TNS_LISTENER_PORTS table stores the listener information.
I didnt trace it , but in my opinion, apps tier autoconfig queries this table, and retrieves the listener port.
Especially s_apps_jdbc_connect_descriptor in CONTEXT_FILE is updated by autoconfig using FND_TNS_LISTENER_PORTS table .
s_apps_jdbc_connect_descriptor variable is not related with port pool defined in apps tier CONTEXT_FILE.
This explains s_apps_jdbc_connect_descriptor related issues like "this parameter is not updated even after apps tier autoconfig and etc..), and the solutions of this issues; run db tier autoconfig first.

Awarded TOP 60 Oracle Blog

About Me

Erman Arslan is currently working as “Applications and Database
Operations Manager” and “Leading Oracle Consultant” for one of the
biggest Oracle Partner Company in Turkey.

He is a “Principle Apps
Dba”, “Oracle-certified Linux” and Certified Exadata Admin” with lots
of field experience in several Oracle projects implemented in several
sectors.

He studied Computer Engineering and received an MBA in istanbul
Turkey. He is a blogger who has written about Oracle Technologies
(“Erman Arslan’ Oracle Blog”) since
2013.

Arslan is the author of the book "Practical Oracle E-Business Suite" (Apress 2016).

Arslan also answers the questions of his readers and provides
support for their problems in his Oracle forum. (“Erman Arslan’s Oracle
Forum").

In addition to the administration and implementation works,
Arslan has developed applications for helping the Oracle Dbas in routine
administration works such as backup and recovery, deployments and performance.

As part of the consultancy work, Arslan has done several Oracle environment healthchecks and general
recoverability assessments in critical customer environments.

Arslan has completed several EBS migrations, Core Database migrations and replatforming projects. He
also played part as the Apps DBA Lead in 6 EBS 12.2 projects, which have gone live in 2015 and in 2016.
As part of the Apps Dba, Core Dba and Engineered Systems support responsibilities, he has managed
more than 15 Critical Customer Production Environments (mostly EBS, but also including Exadata, Oracle
Database Appliance, SSO, OID, and Weblogic Application Servers as well).

Arslan also has worked as DB
SME in very critical assesment and migration projects which are done by EMC in Banking Sector.