Weblogic managed servers

[latifa]

Good morning Erman,

I didn't use that command: I run this one:

FNDCPASS apps/ebsapps  0 Y system/oracle SYSTEM APPLSYS apps

it doesn't work like I said in my post.

I restarted the application Tier and tried to connect to the application : error message for sysadmin. I tried to change it with FNDCPASS ... error message I post previously.

This morning I found a work around for the same error message: https://tobeimpact.blogspot.fr/2017/07/after-oracle-ebs-1224-cloning-we-get.html

I applied it so I could change sysadmin password and connect to the application.

However, why apps password is always 'invalid':

select fnd_web_sec.validate_login('apps','ebsapps') from dual ;

FND_WEB_SEC.VALIDATE_LOGIN('APPS','EBSAPPS')
--------------------------------------------------------------------------------
N


Regards,
Latifa

[latifa]

also I have:

conn apps/apps
ERROR:
ORA-01017: invalid username/password; logon denied

[ErmanArslansOracleBlog]

I know the command that you used.
I want to see the output of : I want to see the error. Please run the following ->

FNDCPASS apps/apps  0 Y system/oracle SYSTEM APPLSYS apps

also please do the throubleshooting in "How to Troubleshoot Login Issues After Changing APPS Password Using FNDCPASS Utility (Doc ID 809155.1)"  -- don't bother the name of this document, just follow the things documented there. (if you find them similar to your issue)

[ErmanArslansOracleBlog]

Bytheway, you can not use fnd_web_sec.validate_login for db users like apps.
so, the error you are getting for fnd_web_sec is normal :)

[latifa]

this nice to see :)  thank you :)

[latifa]

Here it is the output:

FNDCPASS apps/apps  0 Y system/oracle SYSTEM APPLSYS apps
APP-FND-01564: ORACLE error 1017 in AFPCOA

Cause: AFPCOA failed due to ORA-01017: invalid username/password; logon denied
.

The SQL statement being executed at the time of the error was:  and was executed from the file

Regards,

[ErmanArslansOracleBlog]

1)You see, this is a different error.
So , we need to focus on the previous error : "Error in password verification for APPS"

Follow this note -> FNDCPASS Troubleshooting Guide For Login and Changing Applications Passwords (Doc ID 1306938.1)

check every related thing documented there.

2)You can also try restoring the FND_ORACLE_USERID and FND_USER tables from the source instance. After restoring , retry your failing operation.

3)Also try using "AFPASSWD" utility.

[latifa]

Hi Erman,

I can't do these actions now because I gave back the environment to the customer in this afternoon but I'll keep these advises to apply in the comming cloning demands.

Thank you very much Erman for your help.

Regards,
Latifa

[ErmanArslansOracleBlog]

Okay Latifa.