<div>
We added the SID of our dbase in the listener.ora.<br />
<br />
Also commented out the authentication in sqlnet.ora file.
</div>


We added the SID of our dbase in the listener.ora.

Also commented out the authentication in sqlnet.ora file.

<div>
<div class="content wysiwyg-content">
We are using oracle for an accounting software for the past 2 years. &nbsp;<br />
<br />
Suddently yesterday oracle stoped working. &nbsp;<br />
<br />
We restarted the machine, and the oracle services individually but without success.<br />
<br />
We are executing the below command to start oracle:<br />
<br />
set ORACLE_SID=ORCL<br />
E:\oracle\product\10.1.0\D<wbr />b_1\bin\or<wbr />adim.exe -startup -sid ORCL -usrpwd oracle<br />
<br />
we get the error &quot;ora-24327: need explicit attach before authenticating a user&quot;<br />
<br />
Can anyone help?
</div>
</div>


We are using oracle for an accounting software for the past 2 years.  

Suddently yesterday oracle stoped working.  

We restarted the machine, and the oracle services individually but without success.

We are executing the below command to start oracle:

set ORACLE_SID=ORCL
E:\oracle\product\10.1.0\Db_1\bin\oradim.exe -startup -sid ORCL -usrpwd oracle

we get the error "ora-24327: need explicit attach before authenticating a user"

Can anyone help?

Oracle gives error &quot;ora-24327: need explicit attach before authenticating a user&quot; and dows not work

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 gives error &quot;ora-24327: need explicit attach before authenticating a user&quot; and dows not work

Oracle gives error "ora-24327: need explicit attach before authenticating a user" and dows not work