Hi everybody,
I have an ORA-27125-Issue and google seems to offer only general solutions on the problem (i.e. wrong systemctl-settings).
I am currently upgrading our development databases from Oracle Database 11.2.0.4 on Oracle Linux 5.11 x64_86 to Oracle Database 12.1.0.2 on Oracle Lniux 7.1 x64_86
Everything is working out fine so far, except for one thing: the Database fails to start automaticly upon start of the operating system:
/opt/oracle/1210/bin/dbstart: Starting up database "TB053D0"
Tue Mar 31 13:15:10 CEST 2015
SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 31 13:15:12 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORA-27125: unable to create shared memory segment
Linux-x86_64 Error: 1: Operation not permitted
Additional information: 6067
Additional information: 2
SQL> Disconnected
I get the same issue when I enter "systemctl start dbora.service"
Here is my .service-File:
[Unit]
Description=Oracle Autostart Service
After=syslog.target network.target
[Service]
Type=simple
RemainAfterExit=yes
User=oracle
Group=oracle
ExecStart=/opt/oracle/1210/bin/dbstart /opt/oracle/1210
ExecStop=/opt/oracle/1210/bin/dbshut /opt/oracle/1210
[Install]
WantedBy=multi-user.target
However, when I execute "/opt/oracle/1210/bin/dbstart /opt/oracle/1210" as user oracle manually, everything works out fine:
1210/bin/dbstart: Starting up database "TB053D0"
Tue Mar 31 13:27:09 CEST 2015
SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 31 13:27:09 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 805306368 bytes
Fixed Size 2929552 bytes
Variable Size 222301296 bytes
Database Buffers 574619648 bytes
Redo Buffers 5455872 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Has anyone faced a similar issue?
The server has "only" 2 GiB of RAM and I am using 513 hugepages, however I do not think this might be an issue due to the fact, that the database starts just fine when started "normally" - I'm thinking maybe it's a systemd-Issue/-misconfiguration?
Here are my sysctl-parameters:
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.core_uses_pid = 1
kernel.msgmax = 65536
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 128
kernel.shmmax = 2096623616
kernel.shmall = 511871
kernel.shmmni = 4096
kernel.sysrq = 0
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.ip_forward = 0
net.ipv4.ip_local_port_range = 9000 65535
net.ipv4.tcp_syncookies = 1
net.ipv6.conf.all.disable_ipv6 = 1
vm.nr_hugepages = 513
I hope somebody can help. Thanks in advance!