login issue

[Former Member]

hi again i cannot login into sap* or ddic and i have just installed sap.......so i cannot set the profile parameter as login/no_user_automatic_sapstar as 0.....plz guide me through this step by step......i am jus learning sap from basics level

[former_member188883]

Hi Abhijeet,

1 ) Login to server and open SAP instance profile located at /usr/sap/<SID>/SYS/profile

2) Add the parameter login/no_user_automatic_sapstar = 0 and save it.

3) Restart SAP

4) Connect to database using database admin user. In case of oracle login with ora<sid>

5) execute sql query as below to delete SAP* user from the database table.

    SQL> delete from <schema>.USR02 where bname='SAP*' and MANDT=000;

    Above SQL deletes SAP* user from client 000

6) Post this you can login to client 000 using SAP* with password as pass.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

i am getting an error as      incorrect syntax near >      

[Former Member]

Dear

1 ) Login to server and open SAP instance profile located at /usr/sap/<SID>/SYS/profile

2) Add the parameter login/no_user_automatic_sapstar = 0 and save it.

3) Restart SAP

4) Connect to database using database admin user. In case of oracle login with ora<sid>

5) execute sql query as below to delete SAP* user from the database table.

    SQL> delete from SAPSR3.USR02 where bname='SAP*' and MANDT=000;

   SQL>deelte from SAPSR3.USR02 where banem='DDIC' and MANDT=000;

    Above SQL deletes SAP* user from client 000

6) Post this you can login to client 000 using SAP* with password as pass.

if you not use to SQL query first write it in notepad then paste it it won't allow backspace and forward psace it count that as character so you get syntax error

Regards

[Former Member]

i am getting the same error......thanks

[Former Member]

Dear

are you able run sql>

is your database is up and listner is running

shutdown system restart the system

Run this command D:\sqlplus "/as sysdba"

SQL>

then type above command it will work it is an proven soluitons

Regards

[Former Member]

Abhijeet ,

Looks like  you are not connected to SQL command prompt .

1- First set the parameter

2-Restart system

3- Delete the SAP* from 000

4- Login with SAP* in 000 with password : PASS

Regards,

Arun