Refresh DB ORACLE_HOME

[big]

Hi,
On R12.2.4 DB 11.2.0.4 on AIX

I want to refresh ORACLE_HOME on DEV system from PROD. Is the following methode correct?

1- Backup CONTEXT_FILE of DEV.
2-Copy Production ORACLE_HOME onto DEV ORACLE_HOME.
3-Move DEV CONTEXT_FILE (which was backed up on 1) to DEV ORACLE_HOME/appsutil. And delete CONTEXT_FILE of PROD.
4-Run adcfgclon dbconfig using DEV CONTEXT_FILE.

Thanks for advice.

[ErmanArslansOracleBlog]

Seems correct.
Just one thing -> you may need to relink the oracle home on dev -- after copying..

[big]

Thank you.

Should database be stopped before running adcfgclon dbconfig?

Rgegards.

[ErmanArslansOracleBlog]

You are cloning/replacing the Oracle home, so ofcourse you will stop the target/clone database.

[big]

Hi,
Thank you.
I stopped DB.
Copied $ORACLE_HOME.

Relinked all.Run adcfgclone dbTiers, but

|      0% completed       Cannot connect to the database. Either the password provided is wrong or the database is down

ERROR while running Apply...
Mon Aug  2 14:50:34 2021
In log:
WARNING:     Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

conn is null
WARNING: RC-40201: Unable to connect to Database xxoa

Regards.

[ErmanArslansOracleBlog]

Start the database now.

[big]

Thanks.
I started database.

If listener is not running:
WARNING:     Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

conn is null
WARNING: RC-40201: Unable to connect to Database xxxxoa.

If listener is running:
Checking  Database Port on null:  Port Value = 12010
RC-50204: Error: - Database Port in use: Port Value = 12010
 Checking  DB ONS Local Port on null:  Port Value = 6300
   DB ONS Local Port available:  Port Value = 6300
 Checking  DB ONS Remote Port on null:  Port Value = 6400
   DB ONS Remote Port available:  Port Value = 6400
ERROR: Cannot proceed with ApplyDatabase - the paths/ports in the context file are not valid.
ERROR: RC-20403: The following port numbers are busy - please make sure the ports are available and try again.


Regards.

[ErmanArslansOracleBlog]

Big,

Your listener should be up as well..
adcfgclone will connect to the clone database using listener..
Your listener should be up, your db should be up, your env should be okay and that's it.

[big]

Hi,
Yes , you are true.
Thanks and regards.