Essa semana encontrei um erro durante a criação de um banco RAC no Oracle Database Appliance.
A mensagem de erro era:
“ERROR : /bin/su oracle -c “/opt/oracle/oak/onecmd/tmp/dbca-PRTCORP.sh” did not complete successfully. Exit code 1 #Step -1# “
e o log do DBCA mostrava a mensagem:
“Default Listener “LISTENER” is not configured in the Grid Infrastructure home.”
O erro na verdade foi meu 😦 .. já que eu alterei um pouco demais o ambiente.
Por que ? Configuração de algumas redes (VLANs) no ambiente.
Segundo o MOS 1198973.1, o DBCA procura pelo listener default LISTENER rodando na porta 1521 para completar a criação da base em ambientes com GridInfrastructure.
A correção foi simples: removi um listener e o criei novamente com o nome padrão LISTENER.
This week I got an error running DBCA to create a RAC DB on my Oracle Database Appliance.
The error message was:
“ERROR : /bin/su oracle -c “/opt/oracle/oak/onecmd/tmp/dbca-PRTCORP.sh” did not complete successfully. Exit code 1 #Step -1# “
and in DBCA log was reported:
“Default Listener “LISTENER” is not configured in the Grid Infrastructure home.”
It was actually my mistake 😦 .. because I end up changing the environment too much.
But why so many changes ? Well, I had to set up a few networks (VLANs) on this GI.
As stated by MOS 1198973.1, the dbca utility searches for a default listener named LISTENER and running on port 1521 in order to complete the database creation running on GridInfrastructure home.
To fix this issue I had to remove one listener and create a new one with the default listener name LISTENER.