ORA-27102: Out of memory

Issue:

Reported ORA-27102: out of memory when installed Oracle 11gR2

Solution:

1. Check RAM size

% prtconf | grep Mem Memory size: 6208 Megabytes

2. Check project info

% id -p uid=60005(oracle) gid=100(oinstall) projid=100(user.oracle)

% prctl -n project.max-shm-memory -i project 100

project: 100: default NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT

project.max-shm-memory privileged 1.34GB – deny

– system 16.0EB max deny

3. Add a new project to the projects file using command:

( logged in as root)
# projadd -U oracle -K “project.max-shm-memory=(priv,4G,deny)” user.oracle

4.  Check the new entry by :

#cat /etc/project

system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
user.oracle:100::oracle::project.max-shm-memory=(priv,4294967296,deny)

5. Modify the max sem ids using:

#projmod -s -K “project.max-sem-ids=(priv,256,deny)” user.oracle

6. Dont need to reboot, but these changes r persistent across boots.

7. Check the parameter as user oracle:

$ prctl -i project user.oracle

(all options/values will belisted out, confirm the required ones

8.  Now install oracle sw/change sga etc. etc. it will work.

Common issues

Common Installation Errors

1. Unable to convert from “UTF-8” to “646” for NLS!
Solution: Install SUNWuiu8 package.

2. Checking monitor: must be configured to display at least 256 colors >>> Could not execute auto check for display colors using command /usr/openwin/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<< Some requirement checks failed. You must fulfill these requirements before continuing with the installation,at which time they will be rechecked.
Solution(s):
1. Install SUNWxwplt package
2. Set DISPLAY variable
3. Execute xhost + on target (set in DISPLAY) computer

3. Exception in thread “main” java.lang.UnsatisfiedLinkError:
… libmawt.so: ld.so.1: java: fatal: libXm.so.4: open failed: No such file or directory
Solution: Install the SUNWmfrun package.

4. Can’t load ‘/usr/perl5/5.8.4/lib/i86pc-solaris-64int/auto/Sun/Solaris/Project/Project.so’ for module Sun::Solaris::Project: ld.so.1: perl: fatal: libpool.so.1: open failed: No such file or directory at /usr/perl5/5.8.4/lib/i86pc-solaris-64int/DynaLoader.pm line 230. at /usr/sbin/projadd line 19 Compilation failed in require at /usr/sbin/projadd line 19. BEGIN failed–compilation aborted at /usr/sbin/projadd line 19.
Solution: Install the SUNWpool SUNWpoolr packages.

5. UX: useradd: ERROR: Unable to create the home directory: No such file or directory.

• Create specified directory where home directory will be located. In example for /export/home/oracle home you need to execute “mkdir -p /export/home” directory.
• Or:

# userdel user1

# useradd -m user1
6. UX: useradd: ERROR: Unable to create the home directory: Operation not applicable.
If you have been specified /home/oracle (or any directory under /home) check /etc/auto_home for relevant entry (See the Pre-Instalation Tasks – Create oracle User Account).

7. # pkg install SUNWi1of SUNWxwfnt
Creating Planpkg: The following pattern(s) did not match any packages in the current catalog.
Try relaxing the pattern, refreshing and/or examining the catalogs:
SUNWi1of
SUNWxwfnt
Solution: None available. These two packages are not present in repository. Ignore errors during OUI prerequisites check (Oracle will be working fine).

8. [INS-13001] Environment does meet minimum requirements. Are you sure you want to continue?
Solution: If you are installing 11.2.0.1.0 version (this version doesn’t know Solaris 11) you can answer “Yes” or if you have access to My Oracle Support you can download 11.2.0.2.0 version (patch nr: 10098816) and install it directly.

xhost unable to open display ” “

Issue:

xhost unable to open display ” ”

xhost unable to open display “:0.0”

Resolved:

1. Directly log in on the GUI as oracle

2. $ echo $DISPLAY

:.0

3. $ xhost servername1

 

GUI blank issue

Issue:

System started, but no GUI to log in, only the blank screen.

Checked system log at /var/adm/messages:

Jan  3 12:32:56 solaris11 syslog[1087]: [ID 883141 daemon.crit] Frame 27: /usr/lib/gdm-simple-greeter’_start+0x7d [0x806a64d]

Resolved:

1. Remote log in via ssh

2. Enter command:

# svcadm restart gdm

3. Go back to the console, the GUI appear.