Re: Preclone

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Preclone-tp2425p2550.html

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