Preclone

[ErmanArslansOracleBlog]

First of all, If your purpose is to use scan listener in EBS 12.2, then you should have the scan listener related configuration in the following files:

$TNS_ADMIN/tnsnames.ora
Context file: s_apps_jdbc_connect_descriptor and s_apps_jdbc_patch_connect_descriptor variables
$FND_SECURE/<dbname>.dbc
The port and WebLogic server data source <FMW_HOME>/user_projects/domains/EBS_domain_<dbname>/config/jdbc/EBSDataSource-<number>-jdbc.xml

1)
Your EBS database is configured correctly right? I mean remote_listener= SCAN LISTENER and local listener= Your LOCAL listeners.
Ensure the above.

2)
Do the "exact" steps documented in 4.7.1 and 4.7.2, and send me the Apps Tier tnsnames.ora and s_apps_jdbc_connect_descriptor and s_apps_jdbc_patch_connect_descriptor  (after ensuring step 1)

[ErmanArslansOracleBlog]

Note that, you may see scan ips generated (instead of scan hostnames). If you see something like this; this is normal.
But you should see the scan ip or scan names in your tnsnames.ora , if you want to use scan.

Reference: Autoconfig Generates Tnsnames.ora With Ip Address Entries Instead Of Single Client Access Name (SCAN) Name (Doc ID 2063325.1)

[ErmanArslansOracleBlog]

After doing the above, if you don't see scan ips or hostnames generated in apps tier tns, then I suggest you to follow "Appendix D: Enabling/Disabling SCAN Listener Support in Autoconfig" of "Using Oracle 12c Release 1 Real Application Clusters with Oracle E-Business Suite Release 12 (Doc ID 1490850.1)"

-->
Re-enabling SCAN
s_scan_name=<scan_name>, s_scan_port=<scan_port> and s_update_scan=TRUE
Modify the remote_listener to "<scan_name>:<scan_port>" using alter system set remote_listener='...' for all instances
Run AutoConfig on Database tiers to create SCAN aliases in the tnsnames.ora
Run AutoConfig on Applications Tier to create SCAN aliases in the tnsnames.ora

[latifa]

Hi Erman,

Yes my aim is to set the scan listener.

regarding the Doc ID.


1) SQL> show parameter listen

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string      prdc1pdb01-vip:1521
remote_listener                      string      prdc1pdb01-scan:1521

2)
Point 4.7.1 of DocID:

  2.  tnsnames.ora are different between run and fs and even I change them autoconfig will update them as previously:

tnsnames.ora_runfs
tnsnames.ora_patchfs

 3. I am able to connect only to :

DBOFINP1=
DBOFINP11=
DBOFINP11_FO=
DBOFINP12=
DBOFINP12_FO=
DBOFINP1_FO=
DBOFINP1_BALANCE=

4. and 5. --> Done

autoconf on patch fs terminated with errors.

adconfig.log

ErArs_Context_values.txt

[ErmanArslansOracleBlog]

First of all,

1)prdc1pdb01-scan is a weird name. Its prefix is your node vip name. It even has a node number.. However, it should a general one. It should in a different format (like exa-scan, ebs-scan etc...) Are you sure that it is your scan listener.
Did you check your scan listener using lsnrctl utility and see that your EBS services and instances are registered to them?

2)
there is no scan listener related TNS entries in your tnsnames.ora file (run fs)
This is not your aim. So there is something wrong.

3)
Your patch fs tns is also problematic.
As in your autoconfig, you have the following:
  APPS_JDBC_URL='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=prdc1pdb01-scan.dalkia.net)(PORT=1521))(ADDRESS=(PROTOCOL=tcp))(CONNECT_DATA=(SERVICE_NAME=DBOFINP1)))'
    Trying to connect using APPS_JDBC_URL
WARNING:     Exception occurred: java.sql.SQLRecoverableException: IO Error: NL Exception was generated
    Trying to get connection using SID based connect descriptor

4)At the end of the day, your jdbc urls should be based on your scan addresses not vips..


Please do the following:

1)Modify database tier context variable s_scan_name=<scan_name>,s_scan_port=<scan_port> and s_update_scan=TRUE
2)Modify the database init.ora parameter remote_listener to <scan_name>:<scan_port> using the SQL command: alter system set remote_listener='...'  for all instances. (THIS SEEMS ALREADY DONE BUT STILL CHECK)
3)Modify database tier context variable s_instRemotelistener to <service>_remote value
4)Run AutoConfig in the database tier, it creates SCAN aliases in tnsnames.ora
5)Run AutoConfig on middle tier, it creates SCAN aliases in tnsnames.ora

[latifa]

Hi Erman,

How are you ? I hope fine.

For my previous issues, I recloned all servers (DBTier and AppsTiers).
I works fine. Now I can see scan IPs in the tnsnames.ora.

I am adding apps nodes one by one. However, I have an other issue I will make another post for it I think.

Regards,
Latifa

[ErmanArslansOracleBlog]

Thanks Latifa. I m fine.  I hope all is well at your end.
Yes :)