- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Chatr command & Oracle
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 07:48 PM
тАО04-01-2007 07:48 PM
Chatr command & Oracle
I want to decrease virtual memory data page size. I was trying to do the same using CHATR. But facing problems with permissions. I tried it with Oracle user having full permissions.
oracle-/home/oracle$/usr/bin/chatr +pd D /oracle/product/9.2/bin/oracle
/oracle/product/9.2/bin/oracle:
current values:
64-bit ELF executable
shared library dynamic path search:
LD_LIBRARY_PATH enabled first
SHLIB_PATH enabled second
embedded path enabled third /oracle/product/9.2/rdbms/lib/:/oracle/product/9.2/lib/:/usr/lib/hpux64:/opt/langtools/lib/hpux64
shared library list:
libodm9.so
libskgxp9.so
libskgxn9.so
libjox9.so
librt.so.1
libnss_dns.so.1
libdl.so.1
libm.so.1
libpthread.so.1
libCsup.so.1
libunwind.so.1
libc.so.1
shared library binding:
deferred
global hash table disabled
global hash table size 1103
shared library mapped private disabled
shared library segment merging enabled
shared vtable support disabled
explicit unloading disabled
segments:
index type address flags size
7 text 4000000000000000 z---c- 16M
8 data 6000000000000000 ---m-- L (largest possible)
executable from stack: D (default)
kernel assisted branch prediction enabled
lazy swap allocation for dynamic segments disabled
nulptr references disabled
address space model: default
caliper dynamic instrumentation disabled
chatr(error): cannot open file for writing /oracle/product/9.2/bin/oracle
oracle-/home/oracle$ll -rt /oracle/product/9.2/bin/oracle
-rwsr-s--x 1 oracle dba 178518464 Apr 4 2006 /oracle/product/9.2/bin/oracle
oracle-/home/oracle$id
uid=106(oracle) gid=104(dba)
Please help.
Ankit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 09:06 PM
тАО04-01-2007 09:06 PM
Re: Chatr command & Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 09:37 PM
тАО04-01-2007 09:37 PM
Re: Chatr command & Oracle
oracle-/home/oracle$ll -rt /oracle/product/9.2/bin/oracle
-rwsr-s--x 1 oracle dba 178518464 Apr 4 2006 /oracle/product/9.2/bin/oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 10:31 PM
тАО04-01-2007 10:31 PM
Re: Chatr command & Oracle
Can you do a trace or tusc on the chatr. Might be some kind of permission or relinking issue.
Hope you have correctly set the env varilables.
Also do a ldd $ORACLE_HOME/bin/oracle
Regards,
Rasheed Tamton.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 10:58 PM
тАО04-01-2007 10:58 PM
Re: Chatr command & Oracle
(oracle)hpux1572:/etc>ldd $ORACLE_HOME/bin/oracle
libodm9.so => /oracle/product/9.2/lib//libodm9.so
libskgxp9.so => /oracle/product/9.2/lib//libskgxp9.so
libskgxn9.so => /oracle/product/9.2/lib//libskgxn9.so
libjox9.so => /oracle/product/9.2/lib//libjox9.so
librt.so.1 => /usr/lib/hpux64/librt.so.1
libnss_dns.so.1 => /usr/lib/hpux64/libnss_dns.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1
libm.so.1 => /usr/lib/hpux64/libm.so.1
libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1
libCsup.so.1 => /usr/lib/hpux64/libCsup.so.1
libunwind.so.1 => /usr/lib/hpux64/libunwind.so.1
libc.so.1 => /usr/lib/hpux64/libc.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1
libuca.so.1 => /usr/lib/hpux64/libuca.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1
But I did not get how to trace CHATR. Can you elaborate it please?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2007 03:10 PM
тАО04-02-2007 03:10 PM
Re: Chatr command & Oracle
(Ah, you did provide it the first time.) They look like it. But you can't chatr (change) an executable while it is running.
>But I did not get how to trace CHATR. Can you elaborate it please?
$ tusc -o tusc.out chatr +pd D /oracle/product/9.2/bin/oracle
Then provide tusc.out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2007 06:17 PM
тАО04-02-2007 06:17 PM
Re: Chatr command & Oracle
oracle-/home/oracle$tusc -o tusc.out chatr +pd D /oracle/product/9.2/bin/oracle
su: tusc: not found.
I tried through root user:
[root]/#find / -name tusc
[root]/#
Dennis, but as you have mentioned that this might be due to running state of Oracle executable. But before halting all DB operations at our development center, I just want to confirm whether the things I am doing are going to help my cause or not?
We are facing lots of memory allocation problems on our Unix box. One possible cause & remedy which I have found is:
Decrease the virtual memory data page size for the Oracle9i release 2 (9.2.0.1.0) executable as necessary. Alter the page size setting with the following command:
/usr/bin/chatr +pd newsize $ORACLE_HOME/bin/oracle
Currenly the size id L(Largest), I was trying to make it D(Default). Can I go ahead with this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2007 06:48 PM
тАО04-02-2007 06:48 PM
Re: Chatr command & Oracle
You can get this from anonymous ftp from:
ftp.cup.hp.com
~ftp/dist/networking/tools/
Then pick the right one:
-rw-r--r-- 1 root 628232 Sep 12 2005 tusc.7.8.ia64.shar
-rw-r--r-- 1 root 327213 Sep 12 2005 tusc.7.8.pa.shar
>I just want to confirm whether the things I am doing are going to help my cause or not?
I'm not sure about that.
>We are facing lots of memory allocation problems on our Unix box.
You could just by more memory. I assume you have enough swap space but there is a performance issue with it?
>Currenly the size id L(Largest), I was trying to make it D(Default). Can I go ahead with this?
Hopefully tusc should give you the correct error. I found you do have to add the -fp options so you get the right child chatr.
Here I'm using a copy of chatr on itself:
$ tusc -fp -o tusc.out ./chatr +q3p enable chatr
[13554] open("chatr", O_RDWR, 0666) ......... ERR#26 ETXTBSY
You could try. You could copy to oracle.new and chatr that. Then do:
$ ln oracle oracle.old
$ ln -f oracle.new oracle
I'm not sure if this is safe if you are using oracle and it tries to fork/exec and would get a new version?