SAP*

[Former Member]

Hi friends,

WE have solman on oracle installed , but there is no SAP* user for client 000. How to create this SAP* user in client 000. There is no other users in client 000 and nothing is there .Please help me .

Thanks

mohan

[stefan_koehler · Accepted solution]

Hello Mohan,

how did you determine that there is now SAP* ?

The SAP* user is programmed in the system so you don't need to have a user master record.

If you login with SAP* and change the password you will get a user master record.. if you delete this entry you can relogin with the SAP standard password for SAP*.

For the default passwords - take a look here:

http://help.sap.com/saphelp_nw04/helpdata/en/52/671785439b11d1896f0000e8322d00/content.htm

Regards

Stefan

[Former Member · Accepted solution]

Hi,

To allow login with sap* with default password (PASS) you have to first set parameter login/no_automatic_user_sapstar=0 in your Default.pfl

(this will require to restart your system).

Regards,

Antoine

[Former Member · Accepted solution]

I am not able to enter in any of the sap default user name and password , it says it is not existing.What is the use of setting the default profile when there is no user.

Please help me how to create this SAP* in client 000

[stefan_koehler · Accepted solution]

Hi,

you haven't read my link that i posted above or?

Please do the following on databaselevel to be sure that no user master record exists:

> sqlplus <SCHEMAUSER>/<PASSWORD>

> select * from USR01 where bname = 'SAP*';

> select * from USR02 where bname = 'SAP*';

Regards

Stefan

[Former Member · Accepted solution]

I have done as you said but SQL says that there is no USR01 and USR02 table or view doesn't exists.

Please help me.

thanks.

[stefan_koehler · Accepted solution]

Hello,

>> I have done as you said but SQL says that there is no USR01 and USR02 table or view doesn't exists.

If you don't have these tables.. you have another really big problem. Did you login with your SAP Schema owner on oracle?

Regards

Stefan

[Former Member · Accepted solution]

Hi,

Please use syntax

select * from <SCHEMAID>.USR02 where bname = 'SAP*'

[stefan_koehler · Accepted solution]

Hi

>> select * from <SCHEMAID>.USR02 where bname = 'SAP*'

No need to if he uses the schema user as i said...

Regards

Stefan

[Former Member · Accepted solution]

i am logging with the schema owner andpassword that is system / manager.

It says there is no table or view exists.

[stefan_koehler · Accepted solution]

Hello,

>> i am logging with the schema owner andpassword that is system / manager.

No that is wrong. You have to login with your SAP schema user. It maybe SAPR3 or SAPSR3.

Regards

Stefan

[Former Member · Accepted solution]

Hi,

logon to system as <SID>adm then from command prompt:

sqlplus /nolog

connect /as sysdba

select * from <SCHEMAID>.USR02 where bname = 'SAP*'

[Former Member · Accepted solution]

Sorry friends, when i have executed the below statement,

select * from SAPPR3.USR02 where bname = 'SAP*';

It has given the result.

But i could see 066, 001 and 300. But i couldn't find 000 client.

Please help

[Former Member · Accepted solution]

So, Please check if client exist ::

select * from SAPPR3.T0000;

this will show you existing clients;

If it shouw client 0000 then check if any users exist on 000:

select * from SAPPR3.USR02 where MANDT='000';

regards,

Wojtek

[Former Member · Accepted solution]

In SQL is it possible to display page by page. Like we do in unix | more.

[Former Member · Accepted solution]

Restrict queries :

select MANDT from SAPPR3.T0000;

select BNAME from SAPPR3.USR02 where MANDT='000';

regards,

Wojtek

[stefan_koehler · Accepted solution]

Hello

>> select * from SAPPR3.USR02 where bname = 'SAP*';

>> But i could see 066, 001 and 300. But i couldn't find 000 client.

Ok that's right.

So please try to login with the SAP* user in client 000 with the MasterPassword (which you entered in the installation procedure) ... or with the default passwords, that were mentoined in the link that i wrote before.

Btw. what is the release of your system?

Regards

Stefan

[Former Member · Accepted solution]

Hello,

If SAP* user does not exist in client 000 and client 000 exist, then you can try to log on to this client as user SAP* with password pass

Regards,

Wojtek

[Former Member · Accepted solution]

Thanks a lot for your immediate reply.

I could see the client 000 and user sap* ,SAPCPIC and TMSADM but i am not able to login. When i try to login it says either user is locked or password is not correct.

thanks

Edited by: Rama Mohan on Jan 23, 2008 12:20 PM

[Former Member · Accepted solution]

Well,

If you see sap* user in client 000 and message states that it is locked than delete it:

DELETE from SAPPR3.USR02 where BNAME='SAP*' and MANDT='000';

After user deletion you will be able to logon as sap* with password pass

[Former Member · Accepted solution]

I have given the statemnt as told but it delted the user SAP*, now i tried to login but i am getting the same message

[Former Member · Accepted solution]

Hi,

Please set in instance profile file the following parameter (AFTER STOPING SAP SYSTEM):

login/no_automatic_user_sapstar = 0

Than start SAP system.

this will unlock automatic sap* creation and alow you to log on as this user with password pass..

Regards,

Wojtek

[Former Member · Accepted solution]

Thanks i could log into sap*. thanks a lot

[Former Member]

Hi,

Default passwords for SAP* are not valid for new SAP releases.

During Central Instance setup you are asked for setting SAP MasterPassword.

Please try to log on as user SAP* with this password.

Regards,

Wojtek