Skip to Content
0

Error System Rename

Mar 23, 2017 at 06:24 PM

359

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Mar 23, 2017 at 07:04 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 23, 2017 at 08:11 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 24, 2017 at 10:46 AM
0

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?

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

0
Former Member

Hi

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

0