ERROR => CONNECT failed with sql error '1017'

[Former Member]

Hi,

Hi; Our set up is: CI and DB: AIX & ECC 6.0& Oracle We are having one 32 bit win application server. Yesterday we have added another 64 bit win applciation server but at the time of starting the same it is giving error ERROR => CONNECT failed with sql error '1017'

[Former Member]

Check Note - 717677 first.

If ops$ user exists do this:

check the schema user that is locked, you can use the following commands:

sqlplus "/as sysdba"

select username,account_status from dba_users;

in case user is locked then unlock it using the command:

alter user <user_name> account unlock;

P.S. you can excute R3trans -d to get a more exact error.

[Former Member]

Hi,

Are other application server is working fine ? If yes,

Check enviroment variable "dbs_ora_schema = <DBSID>" for <sid>adm and ora<sid> user on Application Server.

Post trans.log after "R3trans -d" test on Application server.

Regards.

Rajesh Narkhede

[Former Member]

What happens when you perform an R3trans -d from this machine?

Kind regards,

Mark

[paul_power]

Hi,

For ORA-01017: invalid username/password; logon denied#.

Check the note 400241 - Problems with ops$ or sapr3 connect to

Oracle.

Regards,

Paul