Erro de Listener: ORA-12514 / ORA-12520 e soluções


ORA-12514: TNS:listener does not currently know of service

 


 
Cause:


 

 

The listener received a request to establish a connection to a
  database or other service. The connect descriptor received by the listener
  specified a service name for a service (usually a database service) that
  either has not yet dynamically registered with the listener or has not been
  statically configured for the listener. This may be a temporary condition
  such as after the listener has started, but before the database instance has
  registered with the listener.


 

 

Action:


 

 

- Wait a moment and try to connect a second
  time.


 

- Check which services are currently known
  by the listener by executing: lsnrctl services <listener name>


 

- Check that the SERVICE_NAME parameter in
  the connect descriptor of the net service name used specifies a service known
  by the listener.


 

- If an easy connect naming connect
  identifier was used, check that the service name specified is a service known
  by the listener.


 

- Check for an event in the listener.log
  file.


 


Para identificar o serviço que
esta sendo utilizado, execute o comando abaixo no servidor onde esta instalado
o Oracle:

lsnrctl status

Após ajustar o TNSNAMES, validar através do comando
abaixo em outra computador e o resultado tem que ocorrer com sucesso:

tnsping nome_do_listener



ORA-12520: TNS:listener could not find available handler

A solução foi verificar o nome do banco no SPFile e
referenciar o nome do banco configurado