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.

Comments

Anonymous said…
Yes. That is the fix
Anonymous said…
yes. That is the fix.

Popular posts from this blog

Disable Firewall on Oracle Linux 8

Installation of Oracle Applications R12.1.1 on Linux and vmware

Enable Desktop on Oracle Solaris 11.4