Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use large pages in AIX with oracle

438679Jan 13 2006 — edited Aug 10 2009
Hi,

i'm trying to convince oracle to use large pages on AIX 5.3 but haven't
suceeded so far.
i set v_pinshm=1, maxpin%=80, lgpg_regions=448 and lgpg_size=16777216
using 'vmo' and 'LOCK_SGA=true' in spfile. after rebooting and starting
the instance 'svmon' shows no no large pages in use:

# svmon
size inuse free pin virtual
memory 4046848 3711708 335140 2911845 1503108
pg space 524288 5551

work pers clnt lpage
pin 1076604 0 233 1835008
in use 1503010 0 373690 0

pgsize size free
lpage pool 16 MB 448 448

SGA size is 3G. why doesn't oracle use large pages? i already have
created a TAR but maybe an oracle-on-AIX expert can help me faster than
oracle support :)

regards,
-ap

Comments

Dude!

You should be able to open the vi utility by simply giving the absolute path:

# cd ~


# /bin/vi .bashrc

There isn't really much in .bashrc

# cat .bashrc

# .bashrc




# User specific aliases and functions




alias rm='rm -i'


alias cp='cp -i'


alias mv='mv -i'




# Source global definitions


if [ -f /etc/bashrc ]; then


    . /etc/bashrc


fi
1 person found this helpful
ReemaPuri

Actually  when i logged in with root user  then i am not able to use vi command

[reema@reema Desktop]$ vi /etc/oratab

[reema@reema Desktop]$ su

Password:

[root@reema Desktop]# vi /etc/oratab

bash: vi: command not found

[root@reema Desktop]#

But  with normal user i am able to use vi command

why ?

Dude!

When you type "vi", the command line interpreter attempts to locate the path to the executable by walking through the directories defined by the PATH environment variable. If your PATH does not contain the directory where the program resides, you will have to specify the correct path instead, e.g.: /bin/vi. The PATH environment variable and other things are defined in the login scripts, such as .bashrc, /etc/profile, etc. and read depending on your type of shell. Note the difference between "su" and "su -". The later will perform a login and reset the current environment. You obviously screwed up the root login environment.

[root@localhost ~]# ls -al


total 36


dr-xr-x---.  2 root root 4096 Jan  3 00:00 .


drwxr-xr-x. 17 root root 4096 Jan  3 00:00 ..


-rw-------.  1 root root  903 Jan  2 21:43 anaconda-ks.cfg


-rw-------.  1 root root  525 Jan  3 01:24 .bash_history


-rw-r--r--.  1 root root   18 Apr 30  2014 .bash_logout


-rw-r--r--.  1 root root  176 Apr 30  2014 .bash_profile


-rw-r--r--.  1 root root  176 Apr 30  2014 .bashrc


-rw-r--r--.  1 root root  100 Apr 30  2014 .cshrc


-rw-r--r--.  1 root root  129 Apr 30  2014 .tcshrc


[root@localhost ~]# cat .bash_profile


# .bash_profile




# Get the aliases and functions


if [ -f ~/.bashrc ]; then


    . ~/.bashrc


fi




# User specific environment and startup programs




PATH=$PATH:$HOME/bin




export PATH


[root@localhost ~]#
1 person found this helpful
ReemaPuri

Yes u r right but what i found is in .bash_profile

Screenshot.png

I am setting in .bash_rc

export ORACLE_HOME=/u01/app/oracle/

product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$/u01/app/oracle/product/11.2.0/dbhome_1
export PATH

Is it my Path clashing am i right

in .bash_profile and .bash_rc

Dude!
Answer

Pretty much everything there is wrong. What you probably want to set is the following:

export ORACLE_BASE=/u01/app/oracle


export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1


export PATH=$PATH:$ORACLE_HOME/bin

or better:

$ . oraenv

Enter your oracle SID and all your Oracle environment variables will be set.

Marked as Answer by ReemaPuri · Sep 27 2020
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 7 2009
Added on Jan 13 2006
#general-database-discussions
3 comments
7,361 views