Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Monday, 10 January 2011

adadmin system account locked

Hi,

In oracle apps 11i environment when i am trying to run any adutlities, its not connecting to system user when prompted. Though normal connection from 8.0.6 home is working fine and tnsping too.

Error message during adadmin:

AD Administration error:
The following ORACLE error:

ORA-01017: invalid username/password; logon denied



Is this the correct database [Yes] ?

AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:

...Unable to connect.

AD Administration error:
The following ORACLE error:

ORA-01017: invalid username/password; logon denied


occurred while executing the SQL statement:

CONNECT SYSTEM/*****

AD Administration error:
Unable to connect to 'SYSTEM'; password may be invalid.

AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:



cause/recent changes:

Recently updgraded database to 11.2.0.1, the parameter sec_case_sensitive_logon was set to true.

This paramter should be false.

Solution:

Check the parameter sec_case_sensitive_logon and set it to false.

Happy reading :)

Thanks.

2 comments:

Anonymous said...

Yes. That is the fix

Anonymous said...

yes. That is the fix.