Question: I have sporadic ORA-101017 errors
that are occurring intermittently. We are running PeopleSoft and
every so oftenwe see a burst of ORA-01017 errors in one of our
application server log files. The only explanation I can think of is
that there is some sort of connection limitation to the database
which causes these errors to spawn when the maximum number of
connections is reached.
My question is whether or not the
ORA-01017 error could be a bug?
Answer: First, see my general notes here on
Also see MOSC Note:360556.1 "How To Correct Intermittent
Connections to Wrong Service" - intermittent ORA-01017 errors . . .
The core issue with an ORA-01017
error is an invalid user ID and passwords combination, but other
than an incorrect password, there are user ID issues that may
contribute to the ORA-01017 error:
When you get an intermittent ORA-01017 error, logic tells us that
it must be:
- A shared resource issue preventing new
- A application or Oracle bug
- A TNS
"connection" issue. Try changing names.directory_path=(TNSNAMES)
- A communications issue
Start at MOSC and look for known
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.