Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shmem problem installing Oracle 12 C on Ubuntu 18.04
Top Forums UNIX for Beginners Questions & Answers Shmem problem installing Oracle 12 C on Ubuntu 18.04 Post 303024420 by Marika on Monday 8th of October 2018 08:52:00 AM
Old 10-08-2018
Hi bakunin,

many thanks for your reply!

Ad. shmall & shmax

The first link you mention - yes, I tried it, and a few other combinations of shmall & shmax, still not quite sure what is correct. Tested values:

Calculated by script from here:

Code:
kernel.shmmax = 8367513600
kernel.shmall = 2042850

Calculated by hand as instructed here:

Code:
kernel.shmmax = 8367519744
kernel.shmall = 1634281

Tried also this:

Code:
kernel.shmmax = 17179869184
kernel.shmall = 4194304

Following your link:

Code:
kernel.shmall = 9272480

Tried Oracle:

Code:
kernel.shmmax = MemTotal 16342812 kB * 1024 = 16735039488 bytes
kernel.shmall = MemTotal 16342812 kB * 1024 * 0,4 / 4096 (page size) = 10214258 pages (???)

this didn't seem right, so I used this for shmall (assuming I wat to give 8GB):

Code:
kernel.shmall = 8 * 1024 * 1024 * 1024 ) / 4096 = 2097152 pages

Every source gives me another recommendation, none worked so far.

SGA_TARGET & SGA_MAX_SIZE

I was setting SGA target (to match swap of 8000508 kB), during installation process in DBCA , I can see in the logs that this was picked up:

Code:
--------------------------------------------------------------------------------
Initialization Parameters
--------------------------------------------------------------------------------

- audit_file_dest : {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump
- audit_trail : db
- compatible : 12.2.0
- control_files : ("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl")
- db_block_size : 8192 BYTES
- db_name : mgdb7
- diagnostic_dest : {ORACLE_BASE}
- dispatchers : (PROTOCOL=TCP) (SERVICE=mgdb7XDB)
- local_listener : LISTENER_MGDB7
- nls_language : POLISH
- nls_territory : POLAND
- open_cursors : 300
- pga_aggregate_target : 2 GB
- processes : 640
- remote_login_passwordfile : EXCLUSIVE
- sga_target : 7812 MB
- undo_tablespace : UNDOTBS1

As for SGA_MAX_SIZE, according to this page it's for 10g only. But this time I did try setting MEMORY_MAX_TARGET, which was 0 by default.

During this attempt:
=============

kernel.shmmax = 16735039488
kernel.shmall = 2097152

001.png
002.png
003.png
004.png

So I check memory:

Code:
oracle@hyperbook-N650DU:/oracle/product/12/db_1/bin$ ipcs --human

------ Message Queues --------
key        msqid      owner      perms      size         messages    

------ Shared Memory Segments --------
key        shmid      owner      perms      size       nattch     status      
0x00000000 262144     oracle     600          128M     2          dest         
0x00000000 360449     oracle     600          512K     2          dest         
0x00000000 1114114    oracle     600          8,4M     2                       
0x00000000 491523     oracle     600          512K     2          dest         
0x00000000 524292     oracle     600          512K     2          dest         
0x00000000 557061     oracle     600          512K     2          dest         
0x00000000 1081350    oracle     600         82,8K     2          dest         
0x00000000 1146887    oracle     600          7,6G     1                       
0x00000000 1179656    oracle     600          7,6M     1                       
0x391430c8 1212425    oracle     600           36K     1                       

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     
0x9d5ea68c 98304      oracle     600        161       
0x9d5ea68d 131073     oracle     600        161       
0x9d5ea68e 163842     oracle     600        161       
0x9d5ea68f 196611     oracle     600        161       
0x9d5ea690 229380     oracle     600        161

Code:
oracle@hyperbook-N650DU:/oracle/product/12/db_1/bin$ free --mega
              total        used        free      shared  buff/cache   available
Mem:          16342        1595       12378         750        2368       13690
Swap:          8000           0        8000

Code:
oracle@hyperbook-N650DU:/oracle/product/12/db_1/bin$ cat /proc/meminfo
MemTotal:       16342812 kB
MemFree:        12371256 kB
MemAvailable:   13683224 kB
Buffers:          125812 kB
Cached:          2148640 kB
SwapCached:            0 kB
Active:          1724356 kB
Inactive:        1865320 kB
Active(anon):    1316344 kB
Inactive(anon):   754572 kB
Active(file):     408012 kB
Inactive(file):  1110748 kB
Unevictable:          16 kB
Mlocked:              16 kB
SwapTotal:       8000508 kB
SwapFree:        8000508 kB
Dirty:               100 kB
Writeback:             0 kB
AnonPages:       1315248 kB
Mapped:           807964 kB
Shmem:            755696 kB
Slab:             224248 kB
SReclaimable:      99952 kB
SUnreclaim:       124296 kB
KernelStack:       11888 kB
PageTables:        45148 kB
NFS_Unstable:          0 kB
Bounce:                0 kB
WritebackTmp:          0 kB
CommitLimit:    16171912 kB
Committed_AS:   14328444 kB
VmallocTotal:   34359738367 kB
VmallocUsed:           0 kB
VmallocChunk:          0 kB
HardwareCorrupted:     0 kB
AnonHugePages:         0 kB
ShmemHugePages:        0 kB
ShmemPmdMapped:        0 kB
CmaTotal:              0 kB
CmaFree:               0 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB
DirectMap4k:      237476 kB
DirectMap2M:     4923392 kB
DirectMap1G:    11534336 kB

Logs not very helpful:

/oracle/cfgtoollogs/dbca/trace.log_2018-10-08_01-28-13-PM

/oracle/cfgtoollogs/dbca/mgdb7/trace.log_2018-10-08_01-28-13-PM

-----

Can you help interpret these results? Is Oracle getting the 8GB of memory or not?

Many thanks for any effort Smilie
 

9 More Discussions You Might Find Interesting

1. Ubuntu

installing hula on ubuntu

i trying to install hula onto my ubuntu but it seems to be not working. i follow through every instructions which i found from the net but is still not working. As i have already install allthe necessary dependency! Below are all the dependency i have install: debhelper (>= 4.0.0),... (0 Replies)
Discussion started by: thms_sum
0 Replies

2. Windows & DOS: Issues & Discussions

Installing Ubuntu in the same partition as Vista

Hi , I hav a laptop with Vista, i need to install Ubuntu along with vista on it. But the problem is tht i donot hav a hard drive partition. though i have abt 70 gb of free space. the only other partition is "recovery" one, so i cnt play with it how shld i perform the installation ?? (4 Replies)
Discussion started by: akshay61286
4 Replies

3. Ubuntu

Installation issue while installing ubuntu

Hi All As i m trying to install ubuntu on my virtual PC where h/w confg is as 5GB didk n 512 mb RAm. after selecting mode option, and after pressing F6 after that screen shows some msg. And not goes to next step. What is the problem n wht i shall do?? Please provide me solution (3 Replies)
Discussion started by: sunray
3 Replies

4. Ubuntu

Grub rescue problem after installing ubuntu 10.04 amd64 after i386

Hi all, I have Windows XP dual boot with Ubuntu 8.10 on my system. I brought in a portable HDD on which I installed Ubuntu 10.04 32-bit. The grub boot loader was installed along with this and to boot windows, I've had to plug in the HDD (with lucid install) everytime. It had been working fine.... (0 Replies)
Discussion started by: morningSunshine
0 Replies

5. Ubuntu

Installing Ubuntu

Hi all- I'm getting ready to install Ubuntu onto my Sony Vaio laptop and had a few questions for which I have not yet found the answer. 1)Should I partition my hdd myself (including a swap partition) in Windows or should I do this when installing Ubuntu? When I do partition, since I have over... (2 Replies)
Discussion started by: Gatsby
2 Replies

6. Ubuntu

Installing latest Ubuntu on my desktop

I wish to install the latest ubuntu on my desktop. How do I go about doing this ? Also how do I create the superuser or admin once the installation is done ? (3 Replies)
Discussion started by: sundaresh
3 Replies

7. Solaris

Problem Installing Oracle 8i

System Model and Spec Sun Enterprise 420R Processor Speed: 450 MHz (4 processors) Installed RAM: 4 GB Os: Solaris 8 Sparc I successfully installed standard oracle 8i setup on our database server specs above but after installation was competed and it went to creating database I got the... (2 Replies)
Discussion started by: Wpgn
2 Replies

8. Ubuntu

Downloading and installing (new to Ubuntu OS)

I've done a whole days work of researching how to install a program on ubuntu.. so first I downloaded python.. unpackaged it from .tar.xz now its just python-3.4.2 then I navigated to the dir in terminal.. then ran the ./configure make make test sudo make install commands which took like 10 minutes... (2 Replies)
Discussion started by: Marniwild
2 Replies

9. Shell Programming and Scripting

[Ubuntu / PERL ]Problem installing WWW::Mechanize mod

Hello everyone, I've got some problem intalling a perl module. The installation is well done as you can see below. gueg@ux31:~$ sudo apt-get install libwww-mechanize-perl Lecture des listes de paquets... Fait Construction de l'arbre des dépendances Lecture des informations d'état...... (4 Replies)
Discussion started by: tot94
4 Replies
All times are GMT -4. The time now is 08:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy