tag:blogger.com,1999:blog-34560741.post5316601386189748442..comments2023-11-02T12:22:23.089+03:00Comments on The Momen Blog: ORA-12537 TNS: Connection ClosedAsif Momenhttp://www.blogger.com/profile/08802175768050555784noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-34560741.post-79501270202673984542008-09-21T15:13:00.000+03:002008-09-21T15:13:00.000+03:00Thanks a lot this has helped me, as stated, I have...Thanks a lot this has helped me, as stated, I have commented the restriction in sqlnet.ora and restarted the listener and this worked.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-34560741.post-9232462281610918072008-02-11T14:25:00.000+03:002008-02-11T14:25:00.000+03:00Hi,I need to restrict access on all IPs except 2. ...Hi,<BR/><BR/>I need to restrict access on all IPs except 2. So I modified sqlnet.ora, as given below:<BR/><BR/>tcp.validnode_checking=yes<BR/>tcp.invited_nodes=(192.168.0.212,192.168<BR/>.15.18)<BR/><BR/>N then reloaded the listener.<BR/>This should work fine. But yet I'm able to login to database through any other IP.<BR/><BR/>--------------------------------<BR/>The other way I tried out was, a logon trigger on database. But that's not the secure way to do it. <BR/><BR/>So if you know, kindly reply me on the same!!! You can directly send an email on janishruti22@gmail.com<BR/><BR/>N thanks for ur reply!!! <BR/><BR/>--shrutiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-34560741.post-60145792167794691802008-02-11T13:00:00.000+03:002008-02-11T13:00:00.000+03:00Hi Shru,> Can u b more specifc 2 tis? Which area y...Hi Shru,<BR/><BR/>> Can u b more specifc 2 tis? <BR/>Which area you think needs more clarification?<BR/><BR/>Shru, can you please elaborate more on your issue? <BR/><BR/>What nodes are listed with INVITED_NODES parameter and from which node are you trying to connect ?<BR/><BR/>Following is a small test I performed by enabling the TCP.VALIDNODE_CHECKING parameter.<BR/><BR/>-- with TCP.INVITED_NODES=TESTPC<BR/>SQL> conn test/test@DB10G_TESTPC<BR/>Connected.<BR/><BR/>-- with TCP.EXCLUDED_NODES=TESTPCSQL> conn test/test@DB10G_TESTPC<BR/>ERROR:<BR/>ORA-12537: TNS:connection closed<BR/><BR/><BR/>Warning: You are no longer connected to ORACLE.<BR/>SQL> <BR/><BR/><BR/>RegardsAsif Momenhttps://www.blogger.com/profile/08802175768050555784noreply@blogger.comtag:blogger.com,1999:blog-34560741.post-81401420969928399722008-02-11T12:31:00.000+03:002008-02-11T12:31:00.000+03:00Hi,ORA-12537... I read ur post regd d same!! Can u...Hi,<BR/>ORA-12537... I read ur post regd d same!! Can u b more specifc 2 tis? <BR/>I'm currently facing d same error... <BR/>Yes, I've included validnode_checking and invited_nodes in sqlnet.ora.<BR/>But that should be working fine after reloading listener, but it isn't. <BR/>Following Metalink SR, but yet havent touched d solution... <BR/><BR/>--shrutiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-34560741.post-9652379306294277542007-11-18T12:32:00.000+03:002007-11-18T12:32:00.000+03:00Oi, achei seu blog pelo google está bem interessan...Oi, achei seu blog pelo google está bem interessante gostei desse post. Gostaria de falar sobre o <A HREF="http://www.provedorcrescenet.com" REL="nofollow">CresceNet</A>. O <A HREF="http://www.provedorcrescenet.com" REL="nofollow">CresceNet</A> é um provedor de <A HREF="http://www.provedorcrescenet.com" REL="nofollow">internet discada</A> que remunera seus usuários pelo tempo conectado. Exatamente isso que você leu, estão pagando para você conectar. O <A HREF="http://www.provedorcrescenet.com" REL="nofollow">provedor</A> paga 20 centavos por hora de <A HREF="http://www.provedorcrescenet.com" REL="nofollow">conexão discada</A> com ligação local para mais de 2100 cidades do Brasil. O CresceNet tem um <A HREF="http://www.provedorcrescenet.com" REL="nofollow">acelerador de conexão</A>, que deixa sua conexão até 10 vezes mais rápida. Quem utiliza <A HREF="http://www.provedorcrescenet.com" REL="nofollow">banda larga</A> pode lucrar também, basta se cadastrar no CresceNet e quando for dormir conectar por discada, é possível pagar a ADSL só com o <A HREF="http://www.provedorcrescenet.com" REL="nofollow">dinheiro</A> da discada. Nos horários de minuto único o gasto com telefone é mínimo e a remuneração do CresceNet generosa. Se você quiser linkar o <A HREF="http://www.provedorcrescenet.com" REL="nofollow">Cresce.Net</A>(www.provedorcrescenet.com) no seu blog eu ficaria agradecido, até mais e sucesso. If is possible add the CresceNet(www.provedorcrescenet.com) in your blogroll, I thank. Good bye friend.<A HREF="0402211608" REL="nofollow"></A>Anonymousnoreply@blogger.com