control file creation failed

[Roshan]

Hello,

I am having an issue on post clone of database tier. Please find attached the logs. I do not know why it is failing to create control file. I did same clone on another vitual machine with same OS and it worked.

I tried from (Doc ID 603104.1) but still it does not work

postclone147.rar

[ErmanArslansOracleBlog]

oracle already reports the error. you have init.ora local listener parameter problem. It is set wrongly.
Read the docs and fix it.
Check your /etc/hosts  file, there can be a problem with your hostname (erppreprod01)

Fix this:

Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod01)(PORT=1523)))'
CREATE CONTROLFILE REUSE SET DATABASE "PREPRO01"

[Roshan]

Thanks. I managed to fix it. I removed the listener parameter (LOCAL_PROD) in initPROD.ora. I managed to startup nomount. The other issue was in the hosts file. When I was getting internet connection issue on the HyperV2012, the network admin accidentally changed the hostname in hosts file in root from erppreprod01 to erppreprod.

Thanks a lot!