I am in the process of cloning a single ORACLE_HOME on a single server. I successfully cloned the ORACLE_HOME, and created a database instance extdev02 in the new home, copying it from extdev01 in the old home.
I am also upgrading ORDS to version 220.127.116.113.06.48.
When I set up the second home, I set up a new listener, LISTENER_EXTDEV02 on port 1523. I got ORDS configured in a separate directory from the original.
Back to the first Oracle home: I dropped in the new ords.war file into the original ORDS directory, ran . oraenv to point to instance extdev01 in old home, verified paths, and did
java -jar ords.war
Verify ORDS schema in Database Configuration apex with connection host: localhost port: 1521 service name: extdev01
Verify ORDS schema in Database Configuration extdev02 with connection host: localhost port: 1523 service name: extdev02
STDERR, first part:
Jan 31, 2018 5:10:19 PM oracle.dbtools.rt.config.setup.SchemaSetup getInstallOrUpgrade
WARNING: Failed to connect to user ORDS_PUBLIC_USER jdbc:oracle:thin:@//localhost:1521/extdev01
ORA-28000: the account is locked Jan 31, 2018 5:10:19 PM oracle.dbtools.rt.config.setup.SchemaSetup getInstallOrUpgrade
WARNING: Failed to connect to user ORDS_PUBLIC_USER jdbc:oracle:thin:@//localhost:1523/extdev02
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
I fixed the account lock, and I was able to restart ORDS for extdev01, but I am getting a
There is a problem with your environment because the Application Express files are not up-to-date!
message when accessing APEX application express, but not when accessing my APEX application.
What appears to be happening is if I start ORDS in the old ORDS home directory using the old ORACLE_HOME it is still looking at the configuration files in my new ORDS home directory!
When I set oraenv to old home, and try to run
java -jar ords.war setup --configOnly --database extdev01
it is creating/updating the ORDS config files in the new directory.