How can I find the logonname of a ora-01017 logon denied?
Hello,
I'm a database admin of a oracle 11g. I have a application without any support and this application give me a ora-01017 (since the new server).
The logon on the oracle database is in background of this application.
Now I need the information which oracle logonname the application use to logon?
Have you any Idea how I can find the logonname of the logon that failed with ora-01017?
Thank you
Reiner
I'm a database admin of a oracle 11g. I have a application without any support and this application give me a ora-01017 (since the new server).
The logon on the oracle database is in background of this application.
Now I need the information which oracle logonname the application use to logon?
Have you any Idea how I can find the logonname of the logon that failed with ora-01017?
Thank you
Reiner
Check the listener.log file.
If that doesn't have it check the OS logs.
If neither of those have the info you'll likely need to turn on auditing to track it.
If that doesn't have it check the OS logs.
If neither of those have the info you'll likely need to turn on auditing to track it.
ASKER
Thank you, but I don't need the os user. I need the logonname of oracle which the application try to connect and fail with ora-01017
in the listener.log I see only the os user
in the listener.log I see only the os user
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
![Avatar of Alex [***Alex140181***]](https://filedb.experts-exchange.com/files/public/2022/11/13/8257e912-ee3c-4a93-9df0-fe9a8a1515cf.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to log this in an ongoing manner, you can create a trigger that will log it to a table. However, since it seems like this already happened, that isn't going to help you now.