Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Changes in the sqlnet.ora file

Hi,

We add had made the changes to the file sqlnet.ora file.I had one doubt as how to test whether it is fine or not.

TCP.VALIDNODE_CHECKING

and TCP.INVITED_NODES

After making the changes we had done lsnrctl reload.

Then i was able to login into the system so does that mean everything is fine or anyother checks are required.Thanks.

Former Member
replied

> We add had made the changes to the file sqlnet.ora file.I had one doubt as how to test whether it is fine or not.

>

> TCP.VALIDNODE_CHECKING

> and TCP.INVITED_NODES

> Then i was able to login into the system so does that mean everything is fine or anyother checks are required.Thanks.

Ok, let's leave aside that there is really good documentation for all the SQLNET-Parameters in the official Oracle documentation.

Instead, let's think about what you have right now and what it is that you want:

- you changed the parameter file

- you restarted the listener - no error message

- you sucessfully connected to the database

So you already reached the "no error message occurs"-state.

Now, you want some more confirmation that your change was indeed correct and sucessfull.

For that you obviously have to test, whether the valid node checking actually does it's job.

Therefore, you should at least try to connection from

a) one host that is actually invited

and

b) one host that is not invited.

(of course you could also try every invited node and a bunch of uninvited ones - just depends on your available time...)

regards,

Lars

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question