check DDIC password error in solman 7 installation

[Former Member]

Hi Gurus,

I'm facing a error in solman 7.0 installation with oracle 10g & windows 2003 server 64 bit server.

Phase 29 of 47, check DDIC password

"test logon to sap system AJ1 failed"

Soluton:Make sure that the system is started,DDIC user exists and password is correct.

I could n't able to login from front end with both users DDIC & SAP* with default password and Master password (gave in parameters phase)

getting "DB-S error"

Oracle services & Database,SAP services are up and running.

when i tried to see the tables to unlock the DDIC user

SQL> select * from AJ1.USR02 where bname ='DDIC'and mandt = '000';

here i got error like view or table doesn't exist

SQL> update AJ1.usr set uflag = 0 where bname = 'DDIC' and mandt = '000';

no scope to execute update command

Could some body pls.help to proceed further.

Thanks,

Satya

[former_member189725]

Just to correct the last ..one ... its the hosts file not the services file.

[former_member189725]

Hi

The problem can be resolved if an enrty of SAPTRANSHOST is maintained in the services file.

Actually during the installation , DDIC user logs in to the system with the default password ( not the master password) to execute the ABAP post installation reports and the installation tool finally changes the password of the DDIC to master password.

Now during the execution of the ABAP reports , the logs are wriiten in the transport directory under the tmp subdirectory . But as the SAPTRANSHOST entry is not maintained in the services file , hence the transport host and the transport directory cannot be determined , and in ST22 , you can see a SHORT DUMP "WRITE_FAILED".

Regards

Ratnajit

[Former Member]

Hello,

Before you answer, I reinstalled SOLMAN, and this time I did not have a problem

Thanks

JC

[Former Member]

I done system copy today and I received the same error. Kernel upgrade helped to solve this probleem.

Kind regards.

[Former Member]

Hello,

I have exactly the same problem.

I Install SOLMAN7 with Oracle 10.2 and Windows 2003 Server 64bit.

Have you found a solution?

Thanks

JC

[debasissahoo]

Hi Satya,

If you've not found the solution yet, please follow the thread.

hope it will help.

Debasis.

[Former Member]

Hi Guys,

Thanks for your valuable points,still am not able to proceed further.

Followed your guidelines and was able to login with SAP*/pass and

successfully changed the password for DDIC, after that i tried to login with

DDIC and new password still end up with same old error "DB-error"

I created new user test1 and able to save it but not able to login with user

test1, got DB-error.

I deleted the user DDIC and tried to create a new user with below options

option 1:copy from SAP* (got error SAP* doesn't exist)

option 2:created a new DDIC user and was not able to login again (DB-error)

Option 3:DDIC/Pass for client 000- got incorrect user/password error & for client 001 got DB-error

Could you pls.guide me to proceed further.

Thanks,

Satya

[former_member105207]

Hi Satya,

Sometimes when you create a new user and login it might prompt for password change.

Create the new DDIC user as a service user and try restarting the installation.

regards

chandru.

[debasissahoo]

Hi Satya,

I deleted the user DDIC and tried to create a new user with below options
option 1:copy from SAP* (got error SAP* doesn't exist)

thats because when you are logging with SAP/pass that SAP is built in the kernel. it doesn't have a user master.

option 2:created a new DDIC user and was not able to login again (DB-error)

did you reset the password of DDIC to default? 19920706

try it and then continue installation without trying to login manually.

Option 3:DDIC/Pass for client 000- got incorrect user/password error & for client 001 got DB-error

Paul mentioned above,

If you receive a 'DB ERROR' message at the bottom of the SAPGUI screen when you try logging in, update to the latest kernel patch level. This corrected the problem for us recently.

So if nothing works, then you might try this.

Regards,

Debasis.

[former_member204746]

use the latest kernel patch, it usually resolved DB-ERROR problems.

if it still does not work, please supply contents of file dev_w0

[Former Member]

The problem must be ddic a/c is lock?

You can login to sap through sap gui and with userid SAP* and unlock ddic a/c and start the installation.

[Former Member]

Or use default schema SAPSR3, have you tried to stop and start Oracle again?

[ps0907]

If you receive a 'DB ERROR' message at the bottom of the SAPGUI screen when you try logging in, update to the latest kernel patch level. This corrected the problem for us recently.

[former_member204746]

AJ1 is not a schema name, try with schema SAPAJ1 instead.