Shmem problem installing Oracle 12 C on Ubuntu 18.04


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Shmem problem installing Oracle 12 C on Ubuntu 18.04
# 1  
Old 09-30-2018
Shmem problem installing Oracle 12 C on Ubuntu 18.04

Hi,

I'm a junior programmer. This is my first post here, please excuse me if that's not the correct place Smilie

For days now I've been trying to install Oracle DB 12c R2 on Ubuntu 18.04. I'm at my wits' end. The software itself installs fine and a Listener can be started but I can't start Oracle nor create a database. After several attempts:
  • The GUI installer (DBCA) freezes at 2% at "Copying database files.."
  • Under CLI I can start sqlplus / as sysdba but it freezes after STARTUP NOMOUNT; command (nothing happens, SQL prompt doesn't come back, the cursor just moves to next line and blinks forever).

I ran perf top -p on the process, after a few minutes I was left with:
Code:
100,00% [kernel] [k] shmem_write_end

Do you have any suggestions? What can I try / which logs should I check?

My settings:

.bashrc

Code:
# Oracle Settings
export TMP=tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=hyperbook-N650DU
export ORACLE_UNQNAME=mgdb5
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12/db_1
export ORACLE_SID=mgdb5
export PATH=usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

/etc/sysctl.conf

Code:
# for oracle 12C
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 2042851
kernel.shmmax = 8367517696
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

pfile

Code:
db_name='mgdb5'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/mgdb5/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=MGDB5XDB)'
open_cursors=300 
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'

oracle user has no sudo rights, bu full access to $ORACLE_BASE

Hardware: Clevo N650DU notebook, i7700, 16 GB RAM.

~~~~~~~~~~~~~~~~

Many thanks in advance to anyone who would help me.
# 2  
Old 09-30-2018
Did you check to make sure you had enough disk space?
# 3  
Old 09-30-2018
Yes, 80 GB partition, half empty:

Code:
Filesystem     1K-blocks     Used Available Use% Mounted on
/dev/nvme0n1p5  77145836 37436396  35747536  52% /
tmpfs            8171404   164648   8006756   3% /dev/shm

# 4  
Old 09-30-2018
Do you have equivalent of swap as your SGA size ?

If you are using DISM (which is default i think from 11 something) you will need to have swap space sized as your SGA to start the database.

Hope that helps
Regards
Peasant.
# 5  
Old 09-30-2018
Yes, DISM.

MemTotal: 16342812 kB
SwapTotal: 8000508 kB

During installation I tried various configurations, with respectively 60, 40 and 25% of RAM value for total memory, of these % 3/4 was SGA, 1/4 PGA. So for example at 60% (10 GB) it was 7,5GB SGA + 2,5GB PGA. At one point I tried to go < 1 GB total.

So you are saying I must up the SGA value to mach (or exceed) swap?
# 6  
Old 10-01-2018
Yes, if you are using DISM, your swap should match your SGA exactly.

But that should not effect the installer hanging, which is very hard to tell why.

If you run the installer from command line, when it's hanging, what does the output to console say?
Does it give any hints ?
How long does it hang ?
Oracle tends to compile and link, so that could take a while on laptop.

If the installer has not completed successfully, it is doubtful you will be able to start the database.

Regards
Peasant.

Last edited by Peasant; 10-01-2018 at 01:37 AM.. Reason: Additional info.
This User Gave Thanks to Peasant For This Post:
# 7  
Old 10-01-2018
Quote:
Originally Posted by Peasant

If the installer has not completed successfully, it is doubtful you will be able to start the database.
Yes, it makes no sense to try to start the database when the installation process hangs and does not complete.

It's best to focus on the getting the install to work, not trying to get a database working when there is a clear error in the installation.
This User Gave Thanks to Neo For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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

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

7. 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

8. 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

9. 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
Login or Register to Ask a Question