Posted by
Roshan on
Oct 12, 2023; 4:57am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/autostart-grid-tp12103.html
Grid 19c
Oracle 19c
Hello Erman,
we have 1 standalone database, which we would like to enable autostart.
As shown below, autostart is already enabled. Kindly advise why DB does not start upon reboot.
[grid@T24R18DBDEV ~]$ srvctl config database -d t24mudr
Database unique name: t24mudr
Database name: t24mu
Oracle home: /oracle/app/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/T24MUDR/PARAMETERFILE/spfilet24mudr.ora
Password file: +DATAC1/T24MUDR/PASSWORD/pwdt24mudr.1706.1120214245
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,DATAC1,RECOC1,FRAC1,OSASHARE,INTERFACE,T24SPOOLDG
Services:
OSDBA group: oinstall
OSOPER group: oinstall
Database instance: t24mudr
Also, we would like to enable volume automatically upon reboot.
asmcmd volenable -G INTERFACE INTERFACE01
asmcmd volenable -G OSASHARE OSASHARE01
asmcmd volenable -G T24SPOOLDG T24SPOOLVOL
asmcmd volenable -G FRAC1 BACKUP
I checked below doc for aumounting ACFS filesystem:
https://docs.oracle.com/en/database/oracle/oracle-database/19/ostmg/steps-manage-acfs.html#GUID-4C98CF06-8CCC-45F1-9316-C40FB3EFF268
/bin/mount -t acfs /dev/asm/osashare01-2 /interface
/bin/mount -t acfs /dev/asm/interface01-433 /osashare
/bin/mount -t acfs /dev/asm/t24spoolvol-112 /t24spool
/bin/mount -t acfs /dev/asm/backup-424 /backup
srvctl add filesystem -device /dev/asm/interface01-433 /osashare -path /osashare
-user oracle -mtowner sysowner -mtgroup sysgrp -mtperm 755
srvctl add filesystem -device /dev/asm/osashare01-2 /interface -path /interface
Thanks,
Roshan