DBCA /LISTENER

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.

Author: reguchi

Oracle ACE, OCP 12c, OCE 12c MAA, OCE Exadata, RHCE, AWS CSAA, OCI CSAA. Technology geek, homebrewer, dad.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s