Pessoal,

segue abaixo a descrição de um problema que tivemos ontem, um simples reinicio de serviço do listener e a solução, acaba que estava ‘na cara’.

Análise:
Como estava o status do listner ao iniciar a analise:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”W29yYWNsZUBURVNURTAxIGJpbl0kIC4vY3JzX3N0YXQgb3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yCk5BTUU9b3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yClRZUEU9YXBwbGljYXRpb24KVEFSR0VUPU9OTElORQpTVEFURT1PRkZMSU5F” hover_enabled=”0″]W29yYWNsZUBURVNURTAxIGJpbl0kIC4vY3JzX3N0YXQgb3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yCk5BTUU9b3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yClRZUEU9YXBwbGljYXRpb24KVEFSR0VUPU9OTElORQpTVEFURT1PRkZMSU5F[/et_pb_dmb_code_snippet]

Parar (crs_stop) o serviço para ficar todo OFFLINE:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”W29yYWNsZUBURVNURTAxIGJpbl0kIC4vY3JzX3N0b3Agb3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yCltvcmFjbGVAVEVTVEUwMSBiaW5dJCAuL2Nyc19zdGF0IG9yYS50ZXN0ZTAyLkxJU1RFTkVSX1RFU1RFMDIubHNucgpOQU1FPW9yYS50ZXN0ZTAyLkxJU1RFTkVSX1RFU1RFMDIubHNucgpUWVBFPWFwcGxpY2F0aW9uClRBUkdFVD1PRkZMSU5FClNUQVRFPU9GRkxJTkU=” hover_enabled=”0″]W29yYWNsZUBURVNURTAxIGJpbl0kIC4vY3JzX3N0b3Agb3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yCltvcmFjbGVAVEVTVEUwMSBiaW5dJCAuL2Nyc19zdGF0IG9yYS50ZXN0ZTAyLkxJU1RFTkVSX1RFU1RFMDIubHNucgpOQU1FPW9yYS50ZXN0ZTAyLkxJU1RFTkVSX1RFU1RFMDIubHNucgpUWVBFPWFwcGxpY2F0aW9uClRBUkdFVD1PRkZMSU5FClNUQVRFPU9GRkxJTkU=[/et_pb_dmb_code_snippet]

Problema:
Tentar iniciar (crs_start) o serviço parado, aconteceu os erros abaixo:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”W29yYWNsZUBURVNURTAxIGJpbl0kIC4vY3JzX3N0YXJ0IG9yYS50ZXN0ZTAyLkxJU1RFTkVSX1RFU1RFMDIubHNucgp0ZXN0ZTAxIDogQ1JTLTEwMTk6IFJlc291cmNlIG9yYS50ZXN0ZTAyLkxJU1RFTkVSX1RFU1RFMDIubHNuciAoYXBwbGljYXRpb24pIGNhbm5vdCBydW4gb24gdGVzdGUwMQp0ZXN0ZTAyIDogQ1JTLTEwMTg6IFJlc291cmNlIG9yYS50ZXN0ZTAyLnZpcCAoYXBwbGljYXRpb24pIGlzIGFscmVhZHkgcnVubmluZyBvbiB0ZXN0ZTAx” hover_enabled=”0″]W29yYWNsZUBURVNURTAxIGJpbl0kIC4vY3JzX3N0YXJ0IG9yYS50ZXN0ZTAyLkxJU1RFTkVSX1RFU1RFMDIubHNucgp0ZXN0ZTAxIDogQ1JTLTEwMTk6IFJlc291cmNlIG9yYS50ZXN0ZTAyLkxJU1RFTkVSX1RFU1RFMDIubHNuciAoYXBwbGljYXRpb24pIGNhbm5vdCBydW4gb24gdGVzdGUwMQp0ZXN0ZTAyIDogQ1JTLTEwMTg6IFJlc291cmNlIG9yYS50ZXN0ZTAyLnZpcCAoYXBwbGljYXRpb24pIGlzIGFscmVhZHkgcnVubmluZyBvbiB0ZXN0ZTAx[/et_pb_dmb_code_snippet]

Como o crs_stop funcionou, achei que funcionaria o crs_start também, mas não.
Depois de procurar um tempo no google e achei soluções do tipo: Parar TODOS os serviços (crs_stop -all) e iniciar tudo (crs_start -all). Não né? Indisponibilidade totalmente desnecessária!
Em um fórum vi alguém dando exemplo de inicializar com o srvctl e lembrei de utiliza-lo, esse utilitário é da administração do Cluster, com ele solucionei o problema.

Solução:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”W29yYWNsZUBURVNURTAxIGJpbl0kIHN1CltvcmFjbGVAVEVTVEUwMSBiaW5dJApbcm9vdEBURVNURTAxIH5dIyBzcnZjdGwKVXNhZ2U6IHNydmN0bCBbXQpjb21tYW5kOiBlbmFibGV8ZGlzYWJsZXxzdGFydHxzdG9wfHJlbG9jYXRlfHN0YXR1c3xhZGR8cmVtb3ZlfG1vZGlmeXxnZXRlbnZ8c2V0ZW52fHVuc2V0ZW52fGNvbmZpZwpvYmplY3RzOiBkYXRhYmFzZXxpbnN0YW5jZXxzZXJ2aWNlfG5vZGVhcHBzfGFzbXxsaXN0ZW5lcgpGb3IgZGV0YWlsZWQgaGVscCBvbiBlYWNoIGNvbW1hbmQgYW5kIG9iamVjdCBhbmQgaXRzIG9wdGlvbnMgdXNlOgpzcnZjdGwgLWgKW3Jvb3RAVEVTVEUwMSB+XSMgc3J2Y3RsIHN0YXJ0IGxpc3RlbmVyIC1oClVzYWdlOiBzcnZjdGwgc3RhcnQgbGlzdGVuZXIgLW4gWy1sIF0KLW4gTm9kZSBuYW1lCi1sIOKAnOKAnSBDb21tYSBzZXBhcmF0ZWQgbGlzdGVuZXIgbmFtZXMKLWggUHJpbnQgdXNhZ2UKCltyb290QFRFU1RFMDEgfl0jIHNydmN0bCBzdGFydCBsaXN0ZW5lciAtbiB0ZXN0ZTAyCltyb290QFRFU1RFMDEgfl0jIGV4aXQKW29yYWNsZUBURVNURTAxIGJpbl0kIC4vY3JzX3N0YXQgb3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yCk5BTUU9b3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yClRZUEU9YXBwbGljYXRpb24KVEFSR0VUPU9OTElORQpTVEFURT1PTkxJTkUgb24gdGVzdGUwMg==” hover_enabled=”0″]W29yYWNsZUBURVNURTAxIGJpbl0kIHN1CltvcmFjbGVAVEVTVEUwMSBiaW5dJApbcm9vdEBURVNURTAxIH5dIyBzcnZjdGwKVXNhZ2U6IHNydmN0bCBbXQpjb21tYW5kOiBlbmFibGV8ZGlzYWJsZXxzdGFydHxzdG9wfHJlbG9jYXRlfHN0YXR1c3xhZGR8cmVtb3ZlfG1vZGlmeXxnZXRlbnZ8c2V0ZW52fHVuc2V0ZW52fGNvbmZpZwpvYmplY3RzOiBkYXRhYmFzZXxpbnN0YW5jZXxzZXJ2aWNlfG5vZGVhcHBzfGFzbXxsaXN0ZW5lcgpGb3IgZGV0YWlsZWQgaGVscCBvbiBlYWNoIGNvbW1hbmQgYW5kIG9iamVjdCBhbmQgaXRzIG9wdGlvbnMgdXNlOgpzcnZjdGwgLWgKW3Jvb3RAVEVTVEUwMSB+XSMgc3J2Y3RsIHN0YXJ0IGxpc3RlbmVyIC1oClVzYWdlOiBzcnZjdGwgc3RhcnQgbGlzdGVuZXIgLW4gWy1sIF0KLW4gTm9kZSBuYW1lCi1sIOKAnOKAnSBDb21tYSBzZXBhcmF0ZWQgbGlzdGVuZXIgbmFtZXMKLWggUHJpbnQgdXNhZ2UKCltyb290QFRFU1RFMDEgfl0jIHNydmN0bCBzdGFydCBsaXN0ZW5lciAtbiB0ZXN0ZTAyCltyb290QFRFU1RFMDEgfl0jIGV4aXQKW29yYWNsZUBURVNURTAxIGJpbl0kIC4vY3JzX3N0YXQgb3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yCk5BTUU9b3JhLnRlc3RlMDIuTElTVEVORVJfVEVTVEUwMi5sc25yClRZUEU9YXBwbGljYXRpb24KVEFSR0VUPU9OTElORQpTVEFURT1PTkxJTkUgb24gdGVzdGUwMg==[/et_pb_dmb_code_snippet]

Após isso testei a conexão dos clients para ambos os listeners, ok, tudo funcionando.

Dica:
Mais informação do comando SRVCTL:

Um pouco mais sobre a família CRS:
Obs.: Lembrando que está em para ser removido em próximas versões.

Espero ter ajudado.

att,
capin