Hello,
I am trying to setup Automation start database 23ai FREE after boot. The service is started but can't access into the sqlplus, the instance stated not start and can't run “startup” . Only startup after stop the db service.
I opened ticket with oracle support, 
SR 3-37844629071 and couldn't help. Even I tried to create the dbora. The services added and after boot, the services from /etc/init.d was removed and can't added any more. I found out the kernel parameters from the configure script had set way too high SHMMAX to a value larger than the total SGA_MAX_SIZE of all instances on my server, that's why the service run but can't start up the database. The support engineer escalated the ticket to the manageable team, and the manageable team is not resolving this 23ai issues.
Here is what it is:
service started after bood but can't access into the db instance and/or startup .
# su - oracle
Last login: Tue Aug 27 07:20:32 EDT 2024
$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Production on Tue Aug 27 07:26:04 2024
Version 23.4.0.24.05
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-27125: unable to create shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 5846
Additional information: -221734748
I created the dbora script and enable and created symbolic link. It existed and after boot, the symbolic link had removed.
# ls -ltr
total 0
lrwxrwxrwx. 1 root root 17 Jun 20 09:45 K20cfn-hup -> ../init.d/cfn-hup
lrwxrwxrwx. 1 root root 26 Aug 22 13:24 S80oracle-free-23ai -> ../init.d/oracle-free-23ai
lrwxrwxrwx. 1 root root 15 Aug 27 11:50 S99dbora -> ../init.d/dbora
# systemctl disable oracle-free-23ai
oracle-free-23ai.service is not a native service, redirecting to systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install disable oracle-free-23ai
# /usr/lib/systemd/systemd-sysv-install disable oracle-free-23ai
# reboot
login as: maintuser
Authenticating with public key "imported-openssh-key"
Last login: Tue Aug 27 12:04:47 2024 from 140.19.144.20
$ sudo -i
[root@ip-139-40-33-160 ~]# ps ef|grep pmon
oracle 3057 3030 0 12:06 pts/1 00:00:00 grep --color=auto pmon
check back the /etc/rc3.d and the config is no longer there for dbora
# ls -ltr /etc/rc3.d
lrwxrwxrwx. 1 root root 10 Jul 26 20:33 /etc/rc3.d -> rc.d/rc3.d
It's odd that I can't add it back
# ls -ltr /etc/rc3.d
lrwxrwxrwx. 1 root root 10 Jul 26 20:33 /etc/rc3.d -> rc.d/rc3.d
# ls -ltr /etc/init.d/dbora
-rwxr-xr-x. 1 root root 1679 Aug 27 11:49 /etc/init.d/dbora
# /sbin/chkconfig --add dbora
# ls -ltr /etc/rc3.d
lrwxrwxrwx. 1 root root 10 Jul 26 20:33 /etc/rc3.d -> rc.d/rc3.d
I just disable the service and let it run on dbora and still not working either
I did change the shmall and still can't add dbora anymore. the symbolic link is not added
# vi /etc/sysctl.conf
kernel.shmall = 15204352
kernel.shmmax = 39991547720
# /sbin/chkconfig --add dbora
# ls -ltr /etc/rc3.d
lrwxrwxrwx. 1 root root 10 Jul 26 20:33 /etc/rc3.d -> rc.d/rc3.d
why it added before and disappeared after reboot, now I can't add it any more even using the free startup from Oracle
# systemctl enable oracle-free-23ai oracle-free-23ai.service is not a native service, redirecting to systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable oracle-free-23ai
# /usr/lib/systemd/systemd-sysv-install enable oracle-free-23ai
# systemctl daemon-reload
# . /etc/init.d/oracle-free-23ai status
Status of the Oracle FREE 23ai service:
LISTENER status: STOPPED
FREE Database status: STOPPED
# ls -ltr /etc/rc3.d lrwxrwxrwx. 1 root root 10 Jul 26 20:33 /etc/rc3.d -> rc.d/rc3.d
the oratab had set to ‘Y’
now none of the oracle-free-23ai and/or dbora are running after reboot.
what I did wrong here?