j2ee status info unavailablein solution manager

[Former Member]

HI ,

After restart my MMC console, my ABAP system is working fine but in MMC j2ee status info unavailable.

Earlier its working fine.services also working fine. J2ee process table also empty.

Unable to login Visual admin and Config tool also .

Please guide me and suggest me .

Regards,

Ajay

[former_member185239 · Accepted solution]

Hi Ajay ,

exit code 66 , It means that there is an issue with database.

Things to check

At database level :

1. sqlplus /nolog

     connect /as sysdba

     select * from dba_users;

It will show all the users at database such as SAPSR3 and SAPSR3DB.

Over here chech the status of the user SAPSR3DB.

a. whether SAPSR3DB user is expired/locked

IF LOCKED

   UNLOCK the user

   Alter user SAPSR3DB unlock account;

2. Now try to logon with the database user SAPSR3DB

    sqlplus /nolog

    connect SAPSR3DB/<passsword of SAPSR3DB>

if the status is connected. THEN

3. Logon to configtool

    If you get a message while error connecting with DB then click on OK.

   On clicking OK , you will able to see , secure storage on the leftside and click on it.

    Over here , maintain the correct password for SAPSR3DB and J2EE_ADMIN.

If you don't know the correct password of SAPSR3DB , then change the password from brtools.

Kindly let know the status

With Regards

Ashutosh

[Former Member · Accepted solution]

Thanks for your help.

My system is windows base.

User SAPSR3DB is already unlocked. But I don't know the SAPSR3DB password.

When i am log in configtool that time error message is there that "Error while connecting to DB"

When i am click on ok that time only secure data is left side and at right side below data is there:--

admin/host/SOL	solman
admin/password/SOL	**********
admin/port/SOL	50004
admin/user/SOL	J2EE_ADMIN
jdbc/pool/SOL/ClassName	oracle.jdbc.driver.OracleDriver
jdbc/pool/SOL/Password	**********
jdbc/pool/SOL/Url	jdbc:oracle:thin:@solman:1527:SOL
jdbc/pool/SOL/User	SAPSR3DB

Please how to change SAPSR3DB to J2EE_ADMIN password, please guide?

Regards,

Ajay

[Former Member · Accepted solution]

Hi,

      if you dont know the password of SAPSR3DB and J2ee_admin , then please do the following.

1. login to sqlplus "/as sysdba" ->  alter user SAPSR3DB identified by  <give the password here>;

for example, alter user SAPSR3DB identified by password;

2.Login to SAP 001 client, go to su01 -> enter j2ee_admin and click on password change button -> enter the password .

IF POSSIBLE MAKE SURE THAT THE PASSWORD OF J2EE_ADMIN AND SAPSR3DB PASSWORDS ARE SAME.

Update the password as below

admin/password/SOL

*********  =====> J2ee_admin password

jdbc/pool/SOL/Password

********** =====> SAPSR3DB password. Thanks and Regards, Vimal

[Former Member · Accepted solution]

Hi,

Yes as per your suggest,

1. I have reset the password of user SAPSR3DB.

2. And unlock & reset the J2EE_ADMIN password from 001 client.

I was kept both password is same and update the both password in configtool ---- secure store.

It's done successfully. For to take the change effect please restart the cluster. So i have closed the configtool window.

Now what to do next?

Regards,

Ajay

[Former Member · Accepted solution]

Done as per your post.

But till i am not log in visual administrator and configtools

Please help

Regards,

Ajay

[Former Member · Accepted solution]

You will not be able to login visual administrator now until the java is up

What error you are getting when trying to connect to config tool??

[Former Member · Accepted solution]

[Former Member · Accepted solution]

Hi,

  Can you please attach the configtool log ?

Thanks and Regards,

Vimal

[former_member185239 · Accepted solution]

Hi ajay,

Can you provide the status for this.

sqlplus /nolog

connect SAPSR3DB/password

With Regards

Ashutosh

[former_member185239 · Accepted solution]

Hi ajay,

Can you provide the status for this.

sqlplus /nolog

connect SAPSR3DB/password of sapsr3db user

With Regards

Ashutosh

[former_member185239 · Accepted solution]

Hi ajay,

Can you provide the status for this.

sqlplus /nolog

connect SAPSR3DB/password of sapsr3db user

With Regards

Ashutosh

[Former Member · Accepted solution]

Hi thanks for reply.

As per your suggestion, please find below image:-

Please help

Regards,

Ajay Asawa

[Former Member · Accepted solution]

Please come out of the sqlplus and try login again as sqlplus "/as sysdba" and try to unlock the user.

[Former Member · Accepted solution]

HI,

Please find the attach of config tool log:-

ChangeServicePropsTask has finished successfully. Service: com.sap.security.core.ume.service on server

Changes in Secure Store are performed successfully.

Changes in Secure Store are performed successfully.

Changes in Secure Store are performed successfully.

Regards,

Ajay

[Former Member · Accepted solution]

Yes, user SAPSR3DB is unlocked now. Thanks.

But i am not log in in config tool now?

[former_member185239 · Accepted solution]

Hi Ajay,

Change the password with brtools

brconnect -u system/<syst_pwd> -f chpass -o SAPSR3DB -p <provide the password which you want to keep>

https://help.sap.com/saphelp_nw70/helpdata/EN/8e/13e33a10d53e36e10000000a11402f/frameset.htm

Never change the password of SAPSR3 and SAPSR3DB from sqlplus , when you do the changes from sqlplus cmd it will maintain the password of this users in dba_users table.

SAP recommend to change the password for SAPSR3 and SAPSR3DB from brtools(oracle database).

With Regards

Ashutosh Chaturvedi

[Former Member · Accepted solution]

Hello,

I have already unlock and reset the password of SAPSR3DB. But i am not able to login in config tool. When i have open that time i have just seen the secure data tab in left side.

Please help

Regards,

Ajay

[Former Member · Accepted solution]

Hi,

Yes now i have open configtool successfully.

Now what I do in configtool for start the J2EE in MMC console?

Please help me

Regards,

Ajay

[Former Member · Accepted solution]

Hello,

I have open successfully config tool. Now my database in connected.

Now what i do in configtool please help

Regards,

Ajay

[Former Member · Accepted solution]

Hi,

Now try to stop the System and try to start it again and check whether it is coming up or not.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi,

Now it's working file. All process is running now. Thanks you very much. Please find the image:-

Now everything is work but when i am try to login in java admin by j2ee_admin that time there is one message- "SAP* is active, no other user logon"

How to deactive SAP* ?

Regards,

Ajay Asawa

[Former Member · Accepted solution]

Hi,

  Please follow the below steps.

- Navigate to /usr/sap/SID/J*/j2ee/configtool/

- run the executable configtool.sh

- Expand the nodes Global server config > Services > com.sap.security.core.ume.services

- On right hand panel set values for properties as below:

Property	Value	Comment
ume.superadmin.activated	False	This deactivates the SAP* user.

-Save the config tool

-restart AS Java

- SAP* is de-activated .

Please check and provide your feedback.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Vimal,

Thank you very much. As per your post message now i am able to login in J2EE_ADMIN user.

All is working fine now.

My main problem is resolved. Can I ask you one more query regarding solution manager please?

Regards,

Ajay

[Former Member · Accepted solution]

Yes please

[Former Member · Accepted solution]

Hi,

I am trying to login to the SMD  (http://solman:8000/smd) but facing following error.

"You do not have sufficient rights to start Solution Manager Diagnostics.

Please contact your administrator to check the permissions on your system"

I use j2ee_admin user with those roles:

SAP_J2EE_ADMIN

SAP_SMDIAG_SAPSUPPORT

SAP_SMDIAG_TEMPLATE

SAP_SMDIAG_WIZARD

SAP_SOLMANDIAG_E2E

SAP_SOLMANDIAG_SAPSUPPORT

and profile:

SAP_ALL

Then why I can't access to smd page?

Actually I want to be complete BASIS CONFIGURATION of my solution manager. For that i need to login in smd page by j2ee_admin user.

Please help

Regards,

Ajay

[Former Member · Accepted solution]

Try to execute using solman_admin and check whether it works.

[Former Member · Accepted solution]

Yes i have already login by SOLMAN_ADMIN (Client 100) and then run tcode solman_setup.

In that case only BASIS configuration need to log in in smd page.

Please help, if you need any details please suggest me

Regards,

Ajay

[Former Member · Accepted solution]

Sorry Ajay... I dont have that much knowledge in Solution Manager.

Please raise a message under solution manager forum and check whether any can help you.

You can also go through the below link that will help you.

http://wiki.sdn.sap.com/wiki/display/SMSETUP/Home

[Former Member · Accepted solution]

OK

Thank you for the help.  You pointed me in the right direction.

Regards,

Ajay Asawa

[Former Member]

Hi,

  Can you please attach the screenshot of MMC?

Secondly, please let us know whether you did any kernel upgrade or any other activities.

Thirdly, please attach dev_Jcontrol file which is available in the work directory.

Thanks and Regards,

Vimal

[Former Member]

Thanks for reply.

Please find the attachment of MMC:-

And there is no any kernel upgrade. I have done only open configtool.bat file and activate the super admin user for reset the J2EE_ADMIN password. But it's not working so i was restart the MMC console.

Please find the contain of dev_Jcontrol file:-

---------------------------------------------------

trc file: "D:\usr\sap\SOL\DVEBMGS00\work\dev_jcontrol", trc level: 1, release: "701"

---------------------------------------------------

node name   : jcontrol

pid         : 4408

system name : SOL

system nr.  : 00

started at  : Sat Feb 02 14:59:44 2013

arguments            :

            arg[00] : D:\usr\sap\SOL\DVEBMGS00\exe\jcontrol.EXE

            arg[01] : pf=D:\usr\sap\SOL\SYS\profile\SOL_DVEBMGS00_solman

            arg[02] : -DSAPSTART=1

            arg[03] : -DCONNECT_PORT=64995

            arg[04] : -DSAPSYSTEM=00

            arg[05] : -DSAPSYSTEMNAME=SOL

            arg[06] : -DSAPMYNAME=solman_SOL_00

            arg[07] : -DSAPPROFILE=D:\usr\sap\SOL\SYS\profile\SOL_DVEBMGS00_solman

            arg[08] : -DFRFC_FALLBACK=ON

            arg[09] : -DFRFC_FALLBACK_HOST=localhost

[Thr 3728] Sat Feb 02 14:59:44 2013

[Thr 3728] *** WARNING => INFO: Unknown property [instance.box.number=SOLDVEBMGS00solman] [jstartxx.c   841]

[Thr 3728] *** WARNING => INFO: Unknown property [instance.en.host=solman] [jstartxx.c   841]

[Thr 3728] *** WARNING => INFO: Unknown property [instance.en.port=3201] [jstartxx.c   841]

[Thr 3728] *** WARNING => INFO: Unknown property [instance.system.id=0] [jstartxx.c   841]

**********************************************************************

JStartupReadInstanceProperties: read instance properties [D:\usr\sap\SOL\DVEBMGS00\j2ee\cluster\instance.properties;D:\usr\sap\SOL\DVEBMGS00\SDM\program\config\sdm_jstartup.properties]

-> ms host    : solman

-> ms port    : 3901

-> OS libs    : D:\usr\sap\SOL\DVEBMGS00\j2ee\os_libs

-> Admin URL  :

-> run mode   : NORMAL

-> run action : NONE

-> enabled    : yes

**********************************************************************

**********************************************************************

Used property files

-> files [00] : D:\usr\sap\SOL\DVEBMGS00\j2ee\cluster\instance.properties

-> files [01] : D:\usr\sap\SOL\DVEBMGS00\SDM\program\config\sdm_jstartup.properties

**********************************************************************

**********************************************************************

Instance properties

-> ms host    : solman

-> ms port    : 3901

-> os libs    : D:\usr\sap\SOL\DVEBMGS00\j2ee\os_libs

-> admin URL  :

-> run mode   : NORMAL

-> run action : NONE

-> enabled    : yes

**********************************************************************

**********************************************************************

Bootstrap nodes

-> [00] bootstrap            : D:\usr\sap\SOL\DVEBMGS00\j2ee\cluster\instance.properties

-> [01] bootstrap_ID4464400  : D:\usr\sap\SOL\DVEBMGS00\j2ee\cluster\instance.properties

-> [02] bootstrap_ID4464450  : D:\usr\sap\SOL\DVEBMGS00\j2ee\cluster\instance.properties

**********************************************************************

**********************************************************************

Worker nodes

-> [00] ID4464400            : D:\usr\sap\SOL\DVEBMGS00\j2ee\cluster\instance.properties

-> [01] ID4464450            : D:\usr\sap\SOL\DVEBMGS00\j2ee\cluster\instance.properties

-> [02] sdm                  : D:\usr\sap\SOL\DVEBMGS00\SDM\program\config\sdm_jstartup.properties

**********************************************************************

[Thr 3728] JControlExecuteBootstrap: execute bootstrap process [bootstrap]

[Thr 4784] JControlDPMessageProxy: Thread 4784 started as handler thread for R/3 dispatcher messages.

[Thr 3728] [Node: bootstrap] java home is set by profile parameter

          Java Home: C:\j2sdk1.4.2_25-x64\

[Thr 3728] JStartupICheckFrameworkPackage: can't find framework package D:\usr\sap\SOL\DVEBMGS00\exe\jvmx.jar

**********************************************************************

JStartupIReadSection: read node properties [bootstrap]

-> node name          : bootstrap

-> node type          : bootstrap

-> node execute       : yes

-> java path          : C:\j2sdk1.4.2_25-x64\

-> java parameters    : -Djco.jarm=1

-> java vm version    : 1.4.2_25-rev-b02

-> java vm vendor     : Java HotSpot(TM) 64-Bit Server VM (Sun Microsystems Inc.)

-> java vm type       : server

-> java vm cpu        : amd64

-> heap size          : 256M

-> root path          : D:\usr\sap\SOL\DVEBMGS00\j2ee\cluster

-> class path         : .\bootstrap\launcher.jar

-> OS libs path       : D:\usr\sap\SOL\DVEBMGS00\j2ee\os_libs

-> main class         : com.sap.engine.offline.OfflineToolStart

-> framework class    : com.sap.bc.proj.jstartup.JStartupFramework

-> registr. class     : com.sap.bc.proj.jstartup.JStartupNatives

-> framework path     : D:\usr\sap\SOL\DVEBMGS00\exe\jstartup.jar;D:\usr\sap\SOL\DVEBMGS00\exe\jvmx.jar

-> parameters         : com.sap.engine.bootstrap.Bootstrap ./bootstrap ID0044644

-> debuggable         : yes

-> debug mode         : no

-> debug port         : 60000

-> shutdown timeout   : 120000

**********************************************************************

**********************************************************************

JControlStartJLaunch: program = D:\usr\sap\SOL\DVEBMGS00\exe\jlaunch.exe

-> arg[00] = D:\usr\sap\SOL\DVEBMGS00\exe\jlaunch.exe

-> arg[01] = pf=D:\usr\sap\SOL\SYS\profile\SOL_DVEBMGS00_solman

-> arg[02] = -DSAPINFO=SOL_00_bootstrap

-> arg[03] = -nodeId=-1

-> arg[04] = -file=D:\usr\sap\SOL\DVEBMGS00\j2ee\cluster\instance.properties

-> arg[05] = -syncSem=JSTARTUP_WAIT_ON_4408

-> arg[06] = -nodeName=bootstrap

-> arg[07] = -jvmOutFile=D:\usr\sap\SOL\DVEBMGS00\work\jvm_bootstrap.out

-> arg[08] = -stdOutFile=D:\usr\sap\SOL\DVEBMGS00\work\std_bootstrap.out

-> arg[09] = -locOutFile=D:\usr\sap\SOL\DVEBMGS00\work\dev_bootstrap

-> arg[10] = -mode=BOOTSTRAP

-> arg[11] = pf=D:\usr\sap\SOL\SYS\profile\SOL_DVEBMGS00_solman

-> arg[12] = -DSAPSTART=1

-> arg[13] = -DCONNECT_PORT=65000

-> arg[14] = -DSAPSYSTEM=00

-> arg[15] = -DSAPSYSTEMNAME=SOL

-> arg[16] = -DSAPMYNAME=solman_SOL_00

-> arg[17] = -DSAPPROFILE=D:\usr\sap\SOL\SYS\profile\SOL_DVEBMGS00_solman

-> arg[18] = -DFRFC_FALLBACK=ON

-> arg[19] = -DFRFC_FALLBACK_HOST=localhost

-> lib path = PATH=C:\j2sdk1.4.2_25-x64\\jre\bin\server;C:\j2sdk1.4.2_25-x64\\jre\bin;C:\j2sdk1.4.2_25-x64\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\WBEM;C:\j2sdk1.4.2_25-x64\bin;D:\usr\sap\SOL\SYS\exe\uc\NTAMD64

-> exe path = PATH=C:\j2sdk1.4.2_25-x64\\bin;D:\usr\sap\SOL\DVEBMGS00\j2ee\os_libs;C:\j2sdk1.4.2_25-x64\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\WBEM;C:\j2sdk1.4.2_25-x64\bin;D:\usr\sap\SOL\SYS\exe\uc\NTAMD64

**********************************************************************

[Thr 3728] Sat Feb 02 14:59:51 2013

[Thr 3728] *** ERROR => invalid return code of process [bootstrap] (exitcode = 66) [jstartxx.c   1642]

[Thr 3728] JControlExecuteBootstrap: error executing bootstrap node [bootstrap] (rc = 66)

[Thr 3728] JControlCloseProgram: started (exitcode = 66)

[Thr 3728] JControlCloseProgram: good bye... (exitcode = 66)

Please suggest

Regards,

Ajay

[Former Member]

Hi,

     Please  open config tool. If you are only seeing secure store. I would suggest you to check whether your JAVA SCHEMA ID is locked or password expired.

If you are using oracle 11G, your dba_users passwords will be expiring every 180 days. So in your case that might also be the issue.

So I would suggest you to reset the password of your JAVA schema ID as well as your ume id which would be j2ee_admin or sapjsf or administrator. Mostly administrator will be i think. and update the same in your config tool.

If you dont see only secure store option in config tool, please attach dev_server0 log as well as std_server0.out files for further analysis.

Please check and provide your feedback.

Thanks and Regards,

Vimal

[Former Member]

You can also completely stop the SAP System and restart the OS .

It will free up the caught and unused space. Then try to start the system .

Please try this also.

Thanks and Regards,

Vimal

[Former Member]

Thanks for your reply.

We are using oracle 10.2 then in this case it's will be expiring every 180 days. Please confirm.

As per your suggestion, I have tried to unlock the j2ee_admin user and reset the password for same user but it's showing message:-

YES, i have seen only secure store option in config tool and I was also tried to completely stop the SAP System and restart the OS but it's seems not work.

Please suggest next step to me.

Regards,

Ajay

[Former Member]

Please help and suggest me

Regards,

Ajay

[Former Member]

You can reset the password of j2ee_admin from your UME.

For example, if ABAP is the UME, you need to reset the password from SAP level . I mean SAP GUI level.

First execute select username,account_status from dba_users. if you see your Java schema ID is locked, then  You can try to unlock the  SAPSR3DB from DB level.

Example

alter user  SAPSR3DB account unlock.\

Please reset the password of J2EE_ADMIN from SAP level . I mean in SAPGUI level.

Please check and provide your feedback.

Thanks and Regards,

Vimal

[Former Member]

Hi,

Thanks for reply.

I have reset the J2EE_ADMIN password from SAP GUI level. It's done.

But i have tried to unlock the user SAPSR3DB from SQL command, it's showing below message with numeric two. I don't know what will do next?

Please guide and how to unlock J2EE_ADMIN user from SQL command?

Regards,

Ajay

[Former Member]

You need to end the statement by entering semicolon (  ;   )  ..

You have to enter alter  user SAPSR3DB account unlock;

Now in the second line type ;   and press the enter button.

[Former Member]

Hi,

As per your suggestion, i have done but below message showing:-

When I have open the configtool.bat, it's showing message:-

Regards,

Ajay

[Former Member]

Hi

Please check whehter your DB is up and running.

It seems that your DB is down now.

Thanks and Regards,

Vimal

[Former Member]

Hi,

My database is up and running, i have checked.

Regards,

Ajay

[Former Member]

Then now try to unlock the SAPSR3DB and check

[Former Member]

Yes it's done. Now user altered.

Thanks

Now what to do next?

Regards,

AJay

[Former Member]

   Please open the config tool and update the passwords you have changed there.

Save & close the config tool -> restart the DB.

Now please try to open the config tool and check whether you are able to see other options apart from Secure store.

[Former Member]

Thanks but when i open the configtool that time error message is there:--

If Click OK the below screen occurred.

admin/host/SOL	solman
admin/password/SOL	**********
admin/port/SOL	50004
admin/user/SOL	J2EE_ADMIN
jdbc/pool/SOL/ClassName	oracle.jdbc.driver.OracleDriver
jdbc/pool/SOL/Password	**********
jdbc/pool/SOL/Url	jdbc:oracle:thin:@solman:1527:SOL
jdbc/pool/SOL/User	SAPSR3DB

Regards,

Ajay

[Former Member]

Hi,

Please check whether ABAP is up and running.

Secondly change whether listener is running or not.

Please login as sidadm -> go to start -> Run -> cmd -> lsnrctl status

Please check whether listener is running or not.

If not running, please start by lsnrctl start

Thanks and Regards,

Vimal

[Former Member]

hi,

my system is windows so how to check lsnrctl status or start/stop?

Regards,

Ajay

[Former Member]

Hi,

Are you able to see your ABAP running?? I mean whether you are able to login to SAPGUI now.

  login to windows with your soladm and its password.

Then click on start -> Run-> cmd

You will get the command prompt.

Type lsnrctl status.. If in the bottom of the ouput, if you see  Running, then your listener is running.

If , you get any message like TNS Connection refused, then your listener is not running.

Then go to start -> Run -> cmd -> lsnrctl start.

And try to start the System.

Thanks and Regards,

Vimal

[Former Member]

Hi,

Yes my ABAP is running, i am able to log in in SAP GUI.

But as per your suggestion, when i was try to start lsnrctl from command prompt, i got below message:-

In unix or aix , we can easily log in thru putty or run any command but in windows how to enable all command like in unix or aix?

Regards,

Ajay

[Former Member]

If ABAP is running, the listener will also be running. So no problem.

Please complete the suggestions described below.

Hi,

      if you dont know the password of SAPSR3DB and J2ee_admin , then please do the following.

1. login to sqlplus "/as sysdba" ->  alter user SAPSR3DB identified by  <give the password here>;

for example, alter user SAPSR3DB identified by password;

2.Login to SAP 001 client, go to su01 -> enter j2ee_admin and click on password change button -> enter the password .

IF POSSIBLE MAKE SURE THAT THE PASSWORD OF J2EE_ADMIN AND SAPSR3DB PASSWORDS ARE SAME.

Update the password as below

admin/password/SOL

*********  =====> J2ee_admin password

jdbc/pool/SOL/Password

********** =====> SAPSR3DB password.

Thanks and Regards,

Vimal