Error 17536 when connecting to an ORACLE Database

[w.kaelber]

 Posted by:  Werner Kälber 

Hi everyone,

we have a problem connecting a gupta application to an ORACLE Database. The
error is 17536 which is not found in error.sql file. We are using version
1.5 ptf6 and Oracle Version 8.1.7.3.

Connection with sqlplus is working, connection with sqltalk is ok, too. If
we try to connect with a wrong user name or password, the database returns
the correct error message "invalid username or password".

Can anyone help?

Thanks,
Werner

[Jim McNamara]

 Posted by:  Jim McNamara 

Oracle has different error messages. Some time a go someone posted a
version of error.sql that included them. I think Mahesh, but I'm not sure.

[pturnberg]

IF this occurs when a user attempts to log into Visual on Oracle,

select * from dba_users order by username;

the STATUS of the user account should be OPEN

If it is not (It could read LOCKED or EXPIRED & LOCKED)

ALTER USER <username> ACCOUNT UNLOCK;
commit;

Re-run and assure the account is now open

The user should now be able to log in