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

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?
LVL 2
AJKBOCAsked:
Who is Participating?
 
ppinonCommented:
See http://www.dbforums.com/oracle/783785-need-explicit-attach-before-authenticating-user.html

You check check your environment variables and sqlnet.ora.
0
 
AJKBOCAuthor Commented:
We added the SID of our dbase in the listener.ora.

Also commented out the authentication in sqlnet.ora file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.