How to set stack for Oracle's user?

Login or Register to Ask a Question and Join Our Community

How to set stack for Oracle's user?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Operating Systems Solaris How to set stack for Oracle's user?

03-01-2009

Registered User

53, 1

Join Date: Mar 2007

Last Activity: 5 December 2014, 4:30 AM EST

Posts: 53

Thanks Given: 1

Thanked 1 Time in 1 Post

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!

trantuananh24hg

View Public Profile for trantuananh24hg

Find all posts by trantuananh24hg

03-02-2009

Registered User

2,693, 19

Join Date: May 2008

Last Activity: 24 August 2014, 5:15 AM EDT

Location: SINGAPORE.. The "FINE" City

Posts: 2,693

Thanks Given: 1

Thanked 19 Times in 19 Posts

You're using Oracle 8i or 10g ?

incredible

View Public Profile for incredible

Find all posts by incredible

03-03-2009

Registered User

53, 1

Join Date: Mar 2007

Last Activity: 5 December 2014, 4:30 AM EST

Posts: 53

Thanks Given: 1

Thanked 1 Time in 1 Post

Thank you for your reply, incredible

I am using Oracle 10g - 10.2.0.1, Solaris 10.

trantuananh24hg

View Public Profile for trantuananh24hg

Find all posts by trantuananh24hg

03-03-2009

Registered User

2,693, 19

Join Date: May 2008

Last Activity: 24 August 2014, 5:15 AM EDT

Location: SINGAPORE.. The "FINE" City

Posts: 2,693

Thanks Given: 1

Thanked 19 Times in 19 Posts

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.

incredible

View Public Profile for incredible

Find all posts by incredible

03-03-2009

Registered User

53, 1

Join Date: Mar 2007

Last Activity: 5 December 2014, 4:30 AM EST

Posts: 53

Thanks Given: 1

Thanked 1 Time in 1 Post

Thank you for your reply!

If I set ulimit -s 8192 in .profile of Oracle, will the problem resolve?

trantuananh24hg

View Public Profile for trantuananh24hg

Find all posts by trantuananh24hg

03-03-2009

Registered User

2,693, 19

Join Date: May 2008

Last Activity: 24 August 2014, 5:15 AM EDT

Location: SINGAPORE.. The "FINE" City

Posts: 2,693

Thanks Given: 1

Thanked 19 Times in 19 Posts

I cant guarantee you on that. But definitely you need to try.

incredible

View Public Profile for incredible

Find all posts by incredible

Login or Register to Ask a Question

Previous Thread | Next Thread

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. 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...

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;...

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...

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...

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...

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...

8. Programming

User Frame & Stack

Can anybody tell me what a user frame & stack looks like on a sun, hp, powerpc system?

Login or Register to Ask a Question