Error System Rename

[former_member209959]

Hi,

Our enviroment is Oracle 12, RedHat 7.3, Netweaver 7.5 Java. After installing the development system we want to create a new system by cloning it with vmware. After the clone, we change the Oracle and SAP mount point with the new SID as the oficial system rename guide says. We have also changed the hostname. Launching the SPM19, we get the next error in the stepLogMessages.xml file:

GetNetworkEnv.getContext start</message>
Info: getContext done</message>
Info: getListenerFilePath start</message>
oracle_home: /oracle/DEV/121</message>
getListenerFilePath, found ORACLE_HOME, but search for link: /oracle/DEV/121</message>
oracle_home: /oracle/TES/121</message>
getListenerFilePath, found ORACLE_HOME, but search for link: /oracle/TES/121</message>
oracle_home: /oracle/DEV/112_64</message>
getListenerFilePath oracle_home not exists: /oracle/DEV/112_64 ...continue.</message>
oracle_home: /oracle/TES/112_64</message>
getListenerFilePath oracle_home not exists: /oracle/TES/112_64 ...continue.</message>
oracle_home: /oracle/DEV/102_64</message>
getListenerFilePath oracle_home not exists: /oracle/DEV/102_64 ...continue.</message>
oracle_home: /oracle/TES/102_64</message>
getListenerFilePath oracle_home not exists: /oracle/TES/102_64 ...continue.</message>
ERROR: cannot find any network files under /oracle/DEV/121 /oracle/TES/121 /oracle/DEV/112_64

DEV is the original SID and TES the target SID

We tried to change the hostname in the listener, and tnsames, but it didn't work. In service.sap there are not notes with this error.

Does anybody have any idea?

Regards.

[former_member209959]

Hi, finally I could start the system rename. Under /oracle/TES I had 121 and a link 12102 --> 121. I had to change the mount point 121 to 12102 and to create a link to 121 to 12102.

But now I'm getting another error from SPM in phase "Prepare to register and rename Oracle Database":

Query returned more than one result. Select attribute oracleHome, statement: WHERE listenerWhich = 'SOURCE'.

Any ideas?

[Sathya-08]

We are getting same error what you got,

Query returned more than one result. Select attribute oracleHome, statement: WHERE listenerWhich = 'SOURCE'.

Have you solved it? Please share the information.

[Former Member]

Hi

I'm also getting the same error when doing rename, did you able to resolve this?

[former_member340335]

Hi, thank you very much, the trick renaming the mountpoint to /oracle/<SID>/12102 worked for me!

This issue was getting me crazy!

[former_member209959]

Hi Harish, this is my first time using this tool. I'm not sure but I supose it's trying to use differents ways for searching the link. Now the listener and tnsnames are under /oracle/TES/121/network/admin. We have changed the host of the machine, but in the network file the hostname is of the source machine. We tried several tests changing the hostname but the error persists.

We have set only one ORACLE_HOME variable.

Regards

[Former Member]

Hi,

Issue seems with environment variables, fix all the variables to avoid these conflicts.

getListenerFilePath, found ORACLE_HOME, but search for link: /oracle/DEV/121</message>
oracle_home: /oracle/TES/121</message>
getListenerFilePath, found ORACLE_HOME, but search for link: /oracle/TES/121</message>
oracle_home: /oracle/DEV/112_64</message>
getListenerFilePath oracle_home not exists: /oracle/DEV/112_64 ...continue.</message>
oracle_home: /oracle/TES/112_64</message>
getListenerFilePath oracle_home not exists: /oracle/TES/112_64 ...continue.</message>
oracle_home: /oracle/DEV/102_64</message>
getListenerFilePath oracle_home not exists: /oracle/DEV/102_64 ...continue.</message>
oracle_home: /oracle/TES/102_64</message>
getListenerFilePath oracle_home not exists: /oracle/TES/102_64 ...continue.</message>

Regards,

Harish Karra