Wednesday 29 May 2013



ORA-28000: THE ACCOUNT IS LOCKED

Issue :
---------

While executing adconfig.sh in db tier, it shows the above error message.

Trying to connect using SID...
getConnectionUsingSID()
-->
JDBC
URL: jdbc racle:thin oraapps.yantro.com:1616:ar12
Exception
occurred: java.sql.SQLException: ORA-28000: the account is locked

Trying
to connect using SID as ServiceName
getConnectionUsingServiceName()
-->
JDBC
URL: jdbc racle:thin (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraapps.yantro.com)(PORT=1616))(CONNECT_DATA=(SERVICE_NAME=ar12)))
Exception
occurred: java.sql.SQLException: ORA-28000: the account is locked

Trying
to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName()
-->
JDBC
URL: jdbc racle:thin (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraapps.yantro.com)(PORT=1616))(CONNECT_DATA=(SERVICE_NAME=ar12.yantro.com)))
Exception
occurred: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514,
TNS:listener does not currently know of service requested in connect descriptor

Connection
could not be obtained; returning null

-------------------ADX
Database Utility Finished---------------

Verifying
connection to the Database : Could not be stablished
No
Restore Profile file created.


Restore
Profile utility ran successfully

===========================================================================


adcvmlog.xml
renamed to /ar12/d02/oracle/R12I/db/tech_st/11.1.0/appsutil/log/ar12_oraapps/07131458/adcvmlog.xml.07131459


[AutoConfig
Error Report]
The
following report lists errors AutoConfig encountered during each
phase
of its execution. Errors are grouped by directory and phase.
The
report format is:
<filename>
<phase> <return code where appropriate>

[PROFILE
PHASE]
AutoConfig
could not successfully execute the following scripts:
Directory:
/ar12/d02/oracle/R12I/db/tech_st/11.1.0/appsutil/install/ar12_oraapps
afdbprf.sh
INSTE8_PRF 1

[APPLY
PHASE]
AutoConfig
could not successfully execute the following scripts:
Directory:
/ar12/d02/oracle/R12I/db/tech_st/11.1.0/appsutil/install/ar12_oraapps
adcrobj.sh
INSTE8_APPLY 1


AutoConfig
is exiting with status 2

AutoConfig
execution completed on Fri Jul 13 14:59:50 2012

Time
taken for AutoConfig execution to complete : 1 mins 7 secs

Solution :
-------------

I try to run afdbprf.sh file individually it shows ora -28000 error message.

Suoraar12
sqlplus '/as sysdba'
alter user apps account unlock;

Now issue solved and auto config successfully running.................

No comments:

Post a Comment