How to set stack for Oracle's user?


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Operating Systems Solaris How to set stack for Oracle's user?
# 1  
How to set stack for Oracle's user?

Hi all!

I've got a problem.
Primary: Sun Sparc V890, 64bit
Standby: HP-Proliant ML 350, 64bit

In the machine that I've got configured physical standby database, the alert_log_file point me one error:

Code:
Sat Feb 28 00:40:08 2009
ORA-00202: control file: '/u01/app/oracle/datafile/controlstd01.ctl'
ORA-27047: unable to read the header block of file
Additional information: 2

And I could not startup mount this standby database. After a time, I found this error caused by
Code:
$ ulimit -s
10240
$ ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        10240
coredump(blocks)     unlimited
nofiles(descriptors) 256
vmemory(kbytes)      unlimited
$ ulimit -Ha
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
coredump(blocks)     unlimited
nofiles(descriptors) 65536
vmemory(kbytes)      unlimited

But the stack was not the same in Primary database
Code:
$ ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        8192
coredump(blocks)     unlimited
nofiles(descriptors) 256
vmemory(kbytes)      unlimited
$ ulimit -Ha
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
coredump(blocks)     unlimited
nofiles(descriptors) 65536
vmemory(kbytes)      unlimited

One is 8192, the other is 10240 bytes.

I know that I can force the stack for standby in .profile - shell for Oracle. But I did not know how to set it?

May you guide me? Thank you very much!

And, when I define the block in both of server, I found that:
Primary:
Code:
$ df -g | grep "block size"
/                  (/dev/md/dsk/d10   ):         8192 block size          1024 f
rag size
/devices           (/devices          ):          512 block size           512 f
rag size
/system/contract   (ctfs              ):          512 block size           512 f
rag size
/proc              (proc              ):          512 block size           512 f
rag size
/etc/mnttab        (mnttab            ):          512 block size           512 f
rag size
/etc/svc/volatile  (swap              ):         8192 block size          8192 f
rag size
/system/object     (objfs             ):          512 block size           512 f
rag size
/platform/sun4u-us3/lib/libc_psr.so.1(/platform/sun4u-us3/lib/libc_psr/libc_psr_
hwcap2.so.1):     8192 block size          1024 frag size
/platform/sun4u-us3/lib/sparcv9/libc_psr.so.1(/platform/sun4u-us3/lib/sparcv9/li
bc_psr/libc_psr_hwcap2.so.1):     8192 block size          1024 frag size
/dev/fd            (fd                ):         1024 block size          1024 f
rag size
/tmp               (swap              ):         8192 block size          8192 f
rag size
/var/run           (swap              ):         8192 block size          8192 f
rag size
/vnporadataSYSTEM  (/dev/dsk/c4t600A0B8000482FB20000045247E9D08Ad0s0):     8192
block size          1024 frag size
/vnprctl           (/dev/dsk/c4t600A0B8000482FB20000044C47E9CED8d0s0):     8192
block size          1024 frag size
/u01               (/dev/md/dsk/d30   ):         8192 block size          1024 f
rag size
/u02               (/dev/md/dsk/d40   ):         8192 block size          1024 f
rag size
/vnporadataUSERS   (/dev/dsk/c4t600A0B8000482FB20000044F47E9CF52d0s0):     8192
block size          1024 frag size
$

In standby:
Code:
$ df -g | grep "block size"
/                  (/dev/dsk/c1t0d0s0 ):         8192 block size          1024 f
rag size
/devices           (/devices          ):          512 block size           512 f
rag size
/system/contract   (ctfs              ):          512 block size           512 f
rag size
/proc              (proc              ):          512 block size           512 f
rag size
/etc/mnttab        (mnttab            ):          512 block size           512 f
rag size
/etc/svc/volatile  (swap              ):         4096 block size          4096 f
rag size
/system/object     (objfs             ):          512 block size           512 f
rag size
/etc/dfs/sharetab  (sharefs           ):          512 block size           512 f
rag size
/lib/libc.so.1     (/usr/lib/libc/libc_hwcap1.so.1):     8192 block size
  1024 frag size
/dev/fd            (fd                ):         1024 block size          1024 f
rag size
/tmp               (swap              ):         4096 block size          4096 f
rag size
/var/run           (swap              ):         4096 block size          4096 f
rag size
/u01               (/dev/dsk/c1t0d0s3 ):         8192 block size          1024 f
rag size
/export/home       (/dev/dsk/c1t0d0s7 ):         8192 block size          1024 f
rag size
$

Same block size, but some thing was different, such as:
In primary
Code:
/etc/svc/volatile  (swap              ) :         8192 block size          8192 frag size 

/dev/fd            (fd                ) :         1024 block size          1024 frag size
/tmp               (swap              ) :         8192 block size          8192 frag size
/var/run           (swap              ) :         8192 block size          8192 frag size

In standby
Code:
/etc/svc/volatile  (swap              ) :         4096 block size        4096 frag size
/dev/fd            (fd                ) :         1024 block size          1024 frag size
/tmp               (swap              ) :         4096 block size          4096 frag size
/var/run           (swap              ) :         4096 block size          4096 frag size

May you clarify more about them? Do them - the difference parameter affect to asynchronous data which will be transferred from primary to standby database? If yes, what should I do?

Thank you very much!
# 2  
You're using Oracle 8i or 10g ?
# 3  
Thank you for your reply, incredible

I am using Oracle 10g - 10.2.0.1, Solaris 10.
# 4  
It's because you are doing cross platform transfer.You can't use Solaris files as is on HP machine. The Endian is different between Solaris and HP platform.
# 5  
Thank you for your reply!

If I set ulimit -s 8192 in .profile of Oracle, will the problem resolve?
# 6  
I cant guarantee you on that. But definitely you need to try. Smilie
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #1005
Difficulty: Easy
Regarding a circle, one full turn of the circle is equal to 2 radians.
True or False?

8 More Discussions You Might Find Interesting

1. Red Hat

Cannot set 'soft limits' for 'maximum stack size' for a standard user

Hi Guys, I'm trying to install Oracle Database on to Oracle Linux 7.6 but when the database install package checks the OS set-up, it keeps on failing on the soft limits for the stack. It's default value is 8192 but I'm trying to set it to 10240. This is what I added to... (2 Replies)
Discussion started by: ASGR
2 Replies

2. UNIX for Dummies Questions & Answers

View User Mode Call Stack of Hung Process

I have a multithreaded usermode program(actually a daemon) which is in hanged state. To debug it I tried attaching the process to gdb, but the gdb hangs. gstack also gets hanged. I peeped into the proc file system and saw the process to be in sleeping state. /proc/sysrq-trigger I guess... (1 Reply)
Discussion started by: rupeshkp728
1 Replies

3. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies

4. UNIX for Dummies Questions & Answers

Kernel Stack vs User Mode Stack

Hi, I am new to the linux kernel development area. I want to know what is the difference between kernel mode stack and user mode stack? Does each process has a user mode stack and a kernel mode stack?? Or Each process has a user mode stack and there is only one kernel mode stack that is shared by... (4 Replies)
Discussion started by: saurabhkoar
4 Replies

5. Programming

How to read max stack size -Xss that is set/default for a java program?

I need to know what is the maximum stack size i.e. -Xss my java program is running with. Is there a way to find that out from inside my java program code and outside of it. What i am looking for is to read whatever the current set max limit -Xss (stack sie) is for a particular JVM(not... (3 Replies)
Discussion started by: mohtashims
3 Replies

6. Solaris

How to set restricted user by rksh? Cannot use Perl module DBD::Oracle

Hi, all, I need to add a user to our system in order to let him use Oracle and Perl. We want him to remain in his home directory and have no access to our data and other users' files. I created a separate group for this user, and set his shell to rksh when I created his account, by which he... (2 Replies)
Discussion started by: alanlh
2 Replies

7. Shell Programming and Scripting

Help to set the oracle environment????

Hi, I am trying to set the environment for my oracle database. I have 5 database in an unix box. My idea is to create 5 files for each database with the following script on it. After logging into the unix box ...just by typing the database name....the enviornment for the database... (2 Replies)
Discussion started by: castlerock
2 Replies

8. Programming

User Frame & Stack

Can anybody tell me what a user frame & stack looks like on a sun, hp, powerpc system? (0 Replies)
Discussion started by: John Budnik
0 Replies

Featured Tech Videos