Problem Error Ora-12516.

[cleber]

Dear, good afternoon !!

This weekend was testing some scripts on my machine (notebook). They are scripts like to see Bank Statistics, see Tablespace consumption, see the Datafiles with free space, see CPU consumption and among others. I was testing the scripts in SQL * Plus. At one point I thought of executing them (the scripts) in the PL / SQL installed on my machine only out of curiosity, but when performing a select any, it presented the following message:

Select all

Erro ORA-12516: TNS:LISTENER NÃO PÔDE LOCALIZAR O HANDLER DISPONÍVEL COM A PILHA DE PROTOCOLOS CORRESPONDENTES. 

And if I open another SQL * Plus window generates the same error, that is, I can only stick with 1 (one) SQL * Plus window, if I open another generates the same error.

Please, if someone knows what can be, please send me the solution.


Thanks in advance.


Valeu staff ...
Thanks for the attention.

[diegoleite]

Cleber,
How is your listener configured ?? by IP or host name ?? If it is by IP because it is a notebook you use DHCP and it may be losing due to dirent numbers of the installation moment. At the time of installation we can prevent us using the IP as the basis for installation and config.

How is the Default Listener port 1521?

local_listener = ??


I hope I have helped,