Problem solve Get help with specific problems with your technologies, process and projects.

Unable to connect to database on Pentium 4 machines

I have been using Oracle 9i client for the past year to connect remotely to our database. I have been trying to install software on various machines on our school campus, and I am not able to make a connection to the database using SQL*Plus on any machine that is a Pentium 4. I made the change from symcjit.dll to symcjit.old and that cleaned up the installation problem I was having after installing the software and beginning the client configuration wizard.

I can ping the machine. I can tnsping the machine. I've installed the ODBC drivers. It seems to be a Pentium 4 issue, but I have found no docs on the Web except to change the file mentioned above.

I hate to be wordy, but to reiterate, I have a Pentium 3 and a Pentium 4 right next to each other (as well as around the campus). Only the Pentium 3s are connecting.

I'd sure appreciate any help.

When you say, "I am not able to make a connection to the database using SQL*Plus", that suggests that you have an error message reported. If you include the error message, that may help. The problem with the Pentium 4 chips is a problem with the installer, not with the software that is installed. So, I've not heard of anything that should keep an Oracle client on a Pentium 4 from working properly once you get it installed (which requires the workaround you hint at).

With an issue that seems to be related to just Pentium 4 systems, I'd first make sure that the OHnetworkadmin*.ora files are exactly the same on the Pentium 4 as they are on a working system (actually copy them, don't just look at them). If that doesn't help, then you may need to trace the client activity to see what's different between the two. That requires using the trace_level_client, trace_file_client, and trace_directory_client at a minimum. See the documentation on how to configure them properly for you (they go in sqlnet.ora). I'd trace a working and a non-working system and then compare the resulting trace files to see where things differ.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.