Discussions
Categories
- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 448K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 520 MySQL Community Space
- 467 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.2K SQL & PL/SQL
- 21K SQL Developer
- 293.3K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 266 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 230 Portuguese
ora-0103
We are in 12.1.0.2 on Linux. I see that one of our query timeout due to above error ora-0103 that says user cancels the current operations. I checked alert log and did not see any errors. I checked AWR reports and found "failed login delay" as the top 5 events. Can you please tell me what does it mean and what causes this error? I did not find any oracle docs that explained it. Please help.
Answers
-
1049595 wrote:We are in 12.1.0.2 on Linux. I see that one of our query timeout due to above error ora-0103 that says user cancels the current operations. I checked alert log and did not see any errors. I checked AWR reports and found "failed login delay" as the top 5 events. Can you please tell me what does it mean and what causes this error? I did not find any oracle docs that explained it. Please help.
Caused by the client sending a cancelation request (like ctrl + c in sqlplus). So why is the client cancelling it?
Failed login delay means exactly how it sounds, you have users trying to login but their attempts are having to be restricted (because the user has previously entered the wrong password) this is completely different observation. Presumably your logs for your application are showing you the ora-1017 error being hit?
-
1049595 wrote:We are in 12.1.0.2 on Linux. I see that one of our query timeout due to above error ora-0103 that says user cancels the current operations. I checked alert log and did not see any errors. I checked AWR reports and found "failed login delay" as the top 5 events. Can you please tell me what does it mean and what causes this error? I did not find any oracle docs that explained it. Please help.
too bad COPY & PASTE are broken for you
It appears that you have a problem accurately reporting reality.
I doubt that you got ORA-00103 error
[[email protected] ~]$ oerr ora 103
00103, 00000, "invalid network protocol; reserved for use by dispatchers"
// *Cause: The network specified in the SQL*Net connect string is reserved
// for use by the dispatchers.
// *Action: Specify other network protocols in the connection string.
please use COPY & PASTE in the future ALWAYS!
You have an IMPRESSIVE LOOOOONG list of unanswered threads. Why is that?