<div>
If you found the record in the listener log, it should have the IP address that the connection came from in there.
</div>


<div>
the ip addrss are all comming from the same server that the database is on , it has a IIS on it so that may be comming from that as the application connects thru the IIS , &nbsp;I am looking at some enteries in the linstner.log and i see some that are from w3wp processes and some others from perl . this listerner mearly hands off the connection to the database and has no knowledge of weather or not the password is locked , so this log would never show any info about a locked account correct?<br />
<br />

</div>


<div>
Sorry, I think we were thinking something different when you said locked.<br />
<br />
Locked accounts can be found in DBA_USERS.<br />
<br />
If you have an invalid attempt lockout on the user through a profile, there is not way to tell who locked it out without using a database trigger to log the failed attempts. &nbsp;But using the tiered architecture you are, you would most likely only get the IIS server as the &quot;person&quot; locking the account.
</div>


<div>
what is the exacy synatax i AM ANEWB at oracle?
</div>


<div>
<div class="content wysiwyg-content">
I have may users who us system accounts on my ORACLE 10GR2 database , I can see what I think this the connection that &nbsp;is locking it in the listener.log &nbsp;it looks as it is a pearl script of sometype , this is all on windows , how can i find out what workstation this is comming from , can I find out what ip addreess the locking action is comming from ?
</div>
</div>


I have may users who us system accounts on my ORACLE 10GR2 database , I can see what I think this the connection that  is locking it in the listener.log  it looks as it is a pearl script of sometype , this is all on windows , how can i find out what workstation this is comming from , can I find out what ip addreess the locking action is comming from ?

how can I find out who is locking my ORACLE 10GR2 database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.