I really do not like coming into an install that is 75% done. The problem with this is that generally NOTHING works and you tend to doubt everything that you do, but hey…
If you are installing or upgrading JDE on unix, you need to know how to quickly determine if you are locking out user accounts. It’s a common problem to have separate passwords between old and new systems (in the case of an upgrade) and get some typing wrong.
Remember to use the [DSPWD] in the jde.ini on the deployment server. JDE expects that the passwords are the same as the OWNERNAME and the password is in CAPITALS (well this is the case for 9.1.
you can use “SELECT USERNAME, ACCOUNT_STATUS from DBA_USERS’ to see the accounts and their status. You could also SPECIFY a value like ‘ACCOUNT_STATUS <> ‘OPEN’
I also had a strange situation that the PRODDTA user could not insert into the TESTDTAT tablespace (strange yes), I had to “GRANT UNLIMITED TABLESPACE to PRODDTA’.
No comments:
Post a Comment