Re: control file creation failed

Posted by ErmanArslansOracleBlog on Mar 06, 2016; 7:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/control-file-creation-failed-tp668p669.html

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"