Database replication process stopped in server


 
Thread Tools Search this Thread
Operating Systems HP-UX Database replication process stopped in server
# 1  
Old 08-12-2016
Database replication process stopped in server

Hi,

A database (Oracle) replication process was executed by the DBA team in one server (serverX). However, this replication process gets terminated, and there are no errors in the replication log. But there is error in the OS log files (syslog.log) :

Code:
Aug  8 16:51:47 L28dre02 sshd[10388]: subsystem request for sftp 
Aug  8 17:11:15 L28dre02 vmunix:
Aug  8 17:11:15 L28dre02 vmunix: Pid 11582 was killed due to failure in 
writing the signal context- possible stack overflow.
Aug  8 18:45:31 L28dre02 sshd[17209]: Accepted keyboard-interactive/pam 
for oracle from 192.168.29.23 port 50190 ssh2

From the error "stack overflow", I found that the solution was to edit the value of the parameter 'PTHREAD_DEFAULT_STACK_SIZE'.
However, I am not sure how/where to locate the file in the server.

Another article I read says that change that parameter value in the file :
$SYBASE/RAX-15_5/bin/ra.sh

However, when I run echo $SYBASE in the server to look for the path, the error is :

Code:
L28dre02:/home/oracle:INTDB> echo $SYBASE
sh: SYBASE: Parameter not set.
L28dre02:/home/oracle:INTDB>

How do I locate this parameter and change the value?

***The replication application used is 'DBVisit'.
# 2  
Old 08-17-2016
Setup the profile of the user using ulimit -s to a higher value.
Possibly one suggested in your database vendor documentation.

If ulimit fails to set to <value>, you will have to adjust the maxssize kernel parameter, then use ulimit.

Be sure to read the manual pages of ulimit and maxssize parameter (this is what i like about hpux, man <kernel parameter> is goldenSmilie )

Please for future note specify your shell (shell of the user the database processes runs under) and exact hpux version.
Folks here can be more exact in helping you with that information upfront.

I have not used the variable mentioned here so i cannot comment on that, give it a shot with standard tools mentioned above.

Hope that helps
Regards
Peasant.
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Killing A Stopped Process

UNIX Tutorial Five % kill %jobnumber Does that not work on a stopped process? I've tried to kill a stopped process and it is not working. Or do you need a certain type of shell for this to work? I don't see anything about this in my man pages. (3 Replies)
Discussion started by: cokedude
3 Replies

2. UNIX for Dummies Questions & Answers

Process stopped: WCHAN pipe_w

Hi. Before throwing my question, thanks to everybody for paying attention. Sorry if my english isn't good enough, but it's not my mother tongue. That's my question: I have a java program that throws an external program with "Process p = Runtime.getRuntime.exec(***)". The communication between... (2 Replies)
Discussion started by: jlopezperez
2 Replies

3. UNIX for Advanced & Expert Users

to understand stopped process in top

Hi, top process is shows like this in solaris server oracle 8i running: load averages: 5.01, 3.35, 2.82 18:24:45 344 processes: 332 sleeping, 5 running, 2 stopped, 5 on cpu CPU states: 22.2% idle, 29.6% user, 14.7% kernel, 33.5% iowait, 0.0% swap... (3 Replies)
Discussion started by: prakash.gr
3 Replies

4. UNIX for Dummies Questions & Answers

how to find which process is stopped

One of my linux machines has a 'stopped' process which i need to find. How do i find the process that is iin 'stopped' mode. I am running red hat linux enterprise. Frank I have now answered this myself with the following command: ps -e j |grep Z (2 Replies)
Discussion started by: frankkahle
2 Replies

5. UNIX for Dummies Questions & Answers

top shows stopped process

When I run the top command, it shows 1 process as being Stopped. This is not a zombie, but simply a stopped process. Unfortunately, I can't figure out how to tell which process this is, nor why it is in a stopped state? Any way of finding this out? (7 Replies)
Discussion started by: IrishRogue
7 Replies
Login or Register to Ask a Question