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

Installation of Oracle Applications R12.1.1 on Linux and vmware

Disable Firewall on Oracle Linux 8

ntp service in Maintenance mode Solaris 10