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
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.
Su
– oraar12
sqlplus
'/as
sysdba'
alter
user
apps
account
unlock;
Now
issue
solved
and
auto
config
successfully
running.................
No comments:
Post a Comment