Red Hat Training

A Red Hat training course is available for Red Hat Enterprise Linux

15.6. Allowing the Oracle User to Change the Mapped Base Address for Shared Libraries

As shown at Section 15.4, “Lowering the Mapped Base Address for Shared Libraries in Red Hat Enterprise Linux 2.1” only root can change the mapped_base for shared libraries. Using sudo we can give the "oracle" user the privilege to change the mapped base for shared libraries for the shell terminal session without providing full root access to the system.
The procedure is as follows:
Create a script called "/usr/local/bin/ChangeMappedBase" which changes the mapped_base for shared libraries for for its own shell:
# cat /usr/local/bin/ChangeMappedBase
#/bin/sh
echo 268435456 > /proc/$PPID/mapped_base
Make the script executable:
# chown root.root /usr/local/bin/ChangeMappedBase
# chmod 755 /usr/local/bin/ChangeMappedBase
Allow the oracle user to execute /usr/local/bin/ChangeMappedBase via sudo without password:
# echo "oracle   ALL=NOPASSWD: /usr/local/bin/ChangeMappedBase" >> \
	/etc/sudoers
Now the Oracle user can run /usr/local/bin/ChangeMappedBase to change the mapped_base for its own shell:
$ su - oracle
$ cat /proc/$$/mapped_base; echo
1073741824
$ sudo /usr/local/bin/ChangeMappedBase
$ cat /proc/$$/mapped_base; echo
268435456$
To change the mapping for shared libraries automatically during the Oracle log in process, execute:
# echo "sudo /usr/local/bin/ChangeMappedBase" >> ~/.bash_profile
Now log in as oracle:
$ ssh oracle@localhost
oracle@localhost's password:
Last login: Sun Jan  7 13:59:22 2003 from localhost
$ cat /proc/$$/mapped_base; echo
268435456$

Note

If the mapped base address for shared libraries for the Oracle processes was changed, then every Linux shell that spawns Oracle processes (for example, listener, sqlplus, etc.) must have the same mapped base address as well. If you execute sqlplus to connect to the local database, then you will get the following error message, seen in the screen below, if the mapped_base for this shell is not the same as for the running Oracle processes.
SQL> connect scott/tiger
ERROR:
ORA-01034: ORACLE not available
ORA-27102: out of memory
Linux Error: 12: Cannot allocate memory
Additional information: 1
Additional information: 491524
			
SQL>