sapcontrol function GetProcessList gives no output

[Former Member]

Hi,

I'm facing a problem never seen before.

On a ERP 6.0 Installation on SLES 11/Oracle. It was installed by System Copy Option of the SWPM.

After finishing import and installation of the central instance the system worked correctly.

But now sapcontrol gives any output by calling its function GetProcess List. And SAP doesn't start anymore.

Does anybody know, what is the reason for that?

Output as follows:

#sapcontrol -nr 00 -function GetProcessList

     [Date Time]

     GetProcessList

     OK

     name, description, dispstatus, textstatus, starttime, elapsedtime, pid

#

Thank you in advance for your help and your ideas.

[former_member185239 · Accepted solution]

Hi Florian,

Try to run the command below command

sapcpe pf=<instance profile of DVEBMGS>

sapcpe pf=<instance profile of SCS> (if dual stack)

Start the system and also attached the dev_disp and dev_w0

Also let us know the kernel version

With Regards

Ashutosh Chaturvedi

[Former Member · Accepted solution]

Thank you for your answer.

The system has only an ABAP-Stack, so I tried the sapcpe command above.

Anyway, the system doesn't start. Although startsap returns "Instance on host <host> started" all work processes will be stopped immediately after start.

By the way I also don't understand why sapcpe was neccessary. I didn't changed the kernel since the system was working last time.

The following Kernel Version is used:

Release: 721, Unicode

Patchlevel 201

And there is one problem with dev_w0 and dev_disp: I don't know why, but the latest files are from yesterday. Shouldn't be there one file written at the latest try to start the system? I replaced real hostname by "hostname" and real SID by "SID" and attached the files to this post.

I also tried to cleanup the system by cleanipc as mentioned in note 1623979. Additionally I rebooted the server.

dev_disp.txt.zip

dev_w0.txt.zip

[former_member185239 · Accepted solution]

Hi Florian,

1. Kindly check the database is up or not

As it is giving the below error

ORA-03135: connection lost contact                                                                                           

2. Also check the listener of oracle.

With Regards

Ashutosh Chaturvedi

[former_member185239 · Accepted solution]

Hi Florian,

Also paste the content of sqlnet.ora from below location

$ORACLE_HOME/network/admin/sqlnet.ora

Also checked the alert_<DBSID>.log of oracle.

With Regards

Ashutosh Chaturvedi

[Former Member · Accepted solution]

Hi Ashutosh,

Oracle Database is up, Listener is working and also R3trans -x and R3trans -d are working with Returncode 0000.

This is the output of sqlnet.ora:

################

# Filename......: sqlnet.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //inst/inst_scripts/lmti_006_REL/tpls/ora/SQLNET.ORA#1 $

################

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

# 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

# 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

# 05.01.06 set to default

#TCP.NODELAY=YES

# 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

I attached the alert_SID.log to this post.

Thank you for your help.

alert_DBSID-log.txt.zip

[Reagan · Accepted solution]

This is the error what I see.

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 3135:
C     ORA-03135: connection lost contact                                                                                            
C  Server handle (con=0,svchp=6934448,srvhp=6936a10) detached
C  *** ERROR => CONNECT failed with SQL error '3135'
 [dbsloci.c    15581]
B  ***LOG BY2=> sql error 3135   performing CON [dbsh         1246]
B  ***LOG BY0=> ORA-03135: connection lost contact [dbsh         1246]
B  ***LOG BY2=> sql error 3135   performing CON [dblink       544]
B  ***LOG BY0=> ORA-03135: connection lost contact [dblink       544]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1521]

Start with this SAP note

1902517 - ORA-03135 general trouble shooting steps

Regards

RB

[former_member185239 · Accepted solution]

Hi Florian,

Try to stop the database and then start it again.

Then try to start the sap system.

If you face the same issue , then follow the sapnote provided by

With Regards

Ashutosh Chaturvedi

[Former Member · Accepted solution]

Check network with niping tool or increase timeout parameters. For explanation please read SAP KBA 1911531 - ORA-12170 or TNS-12535 during connecting to Oracle. You can also enable trace for Oracle Net to get more detailed information about issue. Read SAP Note 562403 - FAQ: Oracle Net. As example please read blog .

[Former Member · Accepted solution]

Thank you. I shut down oracle and all related services and rebooted the complete system. I don't know why, but now sap is working fine.

Also many thanks to all the other ideas.

Have a nice weekend @ all.

[former_member185239 · Accepted solution]

Thanks Florain,

I have been working continuous from last month

Wish you a very happy weekend.

With Regards

Ashutosh Chaturvedi