If you made a typo in your parameter name or set it in the wrong file, then try setting the parameter like I mentioned and see if that makes a difference. If neither of those fixes helps you, then I'd probably try doing some local SQLNET tracing by using the trace_*_client parameters in the sqlnet.ora file. See the Net Reference guide for the parameters. At a minimum, you'll need to have the trace_level_client set to some value -- I'd crank it all the way up to level 16 and then review the trace file.
One last thing to check -- make sure that your environment variables are set correctly. On Oracle9i, I believe that the ORACLE_SID environment variable should be used. In previous releases on Windows, the LOCAL environment variable was the one used by Oracle when connecting locally.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Dan Norris
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.