Wednesday, August 24, 2011

Oracle Restart - Installation and... SILENT Mode

I interested to Install Grid Infrastructure for standalone server + Database and Create database by SILENT mode (Oracle Restart ) So, I just tested it.
A. Created Groups/Users and checked Preinstallation (don't write more, please check on Oracle Document)
[root@mytest ~]# groupadd -g 1000 oinstall
[root@mytest ~]# groupadd -g 1031 dba
[root@mytest ~]# groupadd -g 1020 asmadmin
[root@mytest ~]# groupadd -g 1021 asmdba
[root@mytest ~]# groupadd -g 1022 asmoper
[root@mytest ~]# groupadd -g 1032 oper
[root@mytest ~]# useradd -u 1100 -g oinstall -G asmadmin,asmdba grid
[root@mytest ~]# useradd -u 1101 -g oinstall -G dba,oper,asmdba oracle
[root@mytest ~]# passwd grid
Changing password for user grid.
New password:
BAD PASSWORD: it is too short
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.
[root@mytest ~]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.

[root@mytest ~]# mkdir -p mkdir -p /u01/app/oracle/11.2.0/grid
[root@mytest ~]# chown -R grid:oinstall /u01
[root@mytest ~]# mkdir -p /u01/app/oracle
[root@mytest ~]# chown oracle:oinstall /u01/app/oracle
[root@mytest ~]# chmod -R 775 /u01
[root@mytest ~]# su - grid

B. Installed Grid Infrastructure for standalone server (SILENT Mode) *** In /u01/SRC/grid PATH (Source)***
[grid@mytest grid]$ ./runInstaller -silent -ignoreSysPrereqs -ignorePrereq -responseFile /u01/SRC/grid/response/grid_install.rsp ORACLE_BASE="/u01/app/oracle" ORACLE_HOME="/u01/app/oracle/11.2.0/grid" oracle.install.option="HA_CONFIG" oracle.install.asm.OSDBA=asmdba oracle.install.asm.OSOPER=asmoper oracle.install.asm.OSASM=asmadmin INVENTORY_LOCATION="/u01/app/oraInventory" oracle.install.asm.diskGroup.name=DATA oracle.install.asm.diskGroup.redundancy=NORMAL oracle.install.asm.diskGroup.diskDiscoveryString="/dev/raw/raw*" oracle.install.asm.diskGroup.disks="/dev/raw/raw1,/dev/raw/raw2" oracle.install.asm.SYSASMPassword=password oracle.install.asm.monitorPassword=password
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 15170 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4098 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-08-23_06-04-15PM. Please wait ...You can find the log of this install session at: /u01/app/oraInventory/logs/installActions2011-08-23_06-04-15PM.log

As a root user, execute the following script(s):
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/oracle/11.2.0/grid/root.sh

As install user, execute the following script to complete the configuration.
1. /u01/app/oracle/11.2.0/grid/cfgtoollogs/configToolAllCommands

Note:
1. This script should be run in the same environment from where the installer has been run.
2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).

Successfully Setup Software.

C. Go to "root" user and executed the following script(s)
[root@mytest ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.

*** I tested in Oracle Linux 6.1. so, below "Adding daemon to inittab" message, it's wrong!!! Because Oracle Linux 6.* not support inittab file (It uses UpStart). I created "/etc/init/init-orahas.conf" file, before executed "root.sh" ***
[root@mytest ~]# cat /etc/init/init-orahas.conf
#start oracle
start on runlevel [35]
stop on runlevel [016]
respawn
exec /etc/init.d/init.ohasd run >/dev/null 2>&1 </dev/null
[root@mytest ~]# /u01/app/oracle/11.2.0/grid/root.sh
Check /u01/app/oracle/11.2.0/grid/install/root_mytest_2011-08-24_10-51-18.log for the output of root script

[root@mytest ~]# cat /u01/app/oracle/11.2.0/grid/install/root_mytest_2011-08-24_10-51-18.log
Running Oracle 11g root script...

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/oracle/11.2.0/grid
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/oracle/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node mytest successfully pinned.
Adding daemon to inittab
ACFS-9459: ADVM/ACFS is not supported on this OS version: 'error: file /etc/SuSE-release: No such file or directory'

mytest 2011/08/24 10:52:08 /u01/app/oracle/11.2.0/grid/cdata/mytest/backup_20110824_105208.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server

D. Executed configToolAllCommands script.
[grid@mytest grid]$ cat /u01/SRC/grid/cfgrsp.properties
oracle.assistants.asm|S_ASMPASSWORD=password
oracle.assistants.asm|S_ASMMONITORPASSWORD=password
[grid@mytest grid]$ /u01/app/oracle/11.2.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/u01/SRC/grid/cfgrsp.properties
Setting the invPtrLoc to /u01/app/oracle/11.2.0/grid/oraInst.loc

perform - mode is starting for action: configure

Aug 24, 2011 12:06:00 PM oracle.install.driver.oui.config.GenericInternalPlugIn invoke
INFO: Executing ASMCA
Aug 24, 2011 12:06:00 PM oracle.install.driver.oui.config.GenericInternalPlugIn invoke
INFO: Command /u01/app/oracle/11.2.0/grid/bin/asmca -silent -oui_internal -configureASM -diskString '/dev/raw/raw*' -diskGroupName DATA -diskList /dev/raw/raw1,/dev/raw/raw2 -redundancy NORMAL
Aug 24, 2011 12:06:00 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: ... GenericInternalPlugIn.handleProcess() entered.
Aug 24, 2011 12:06:00 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: ... GenericInternalPlugIn: getting configAssistantParmas.
Aug 24, 2011 12:06:00 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: ... GenericInternalPlugIn: checking secretArguments.
Aug 24, 2011 12:06:00 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: ... GenericInternalPlugIn: starting read loop.
Aug 24, 2011 12:06:06 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: Read: SYS_PASSWORD_PROMPT
Aug 24, 2011 12:06:06 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: Processing: SYS_PASSWORD_PROMPT for argument tag -sysAsmPassword
Aug 24, 2011 12:06:06 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: Read: ASMSNMP_PASSWORD_PROMPT
Aug 24, 2011 12:06:06 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: Processing: ASMSNMP_PASSWORD_PROMPT for argument tag -asmMonitorPassword
Aug 24, 2011 12:06:06 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: End of argument passing to stdin
Aug 24, 2011 12:06:07 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: Read:
Aug 24, 2011 12:06:07 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: Read: An ASM Instance with SID +ASM is already detected. ASM failed to start.
Check /u01/app/oracle/cfgtoollogs/asmca/asmca-110824PM120601.log for details.
Aug 24, 2011 12:06:07 PM oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
INFO: Read:
perform - mode finished for action: configure

You can see the log file: /u01/app/oracle/11.2.0/grid/cfgtoollogs/oui/configActions2011-08-24_12-05-51-PM.log

[grid@mytest grid]$ cat /u01/app/oracle/11.2.0/grid/cfgtoollogs/oui/configActions2011-08-24_12-05-51-PM.log
###################################################
The action configuration is performing
.
.
.
------------------------------------------------------
------------------------------------------------------
The plug-in Automatic Storage Management Configuration Assistant is running

The plug-in Automatic Storage Management Configuration Assistant has failed its perform method
------------------------------------------------------
The action configuration has failed its perform method
###################################################
*** had to create ASM by manual ***

E. Created (ASM) by Manual!!!

[grid@mytest grid]$ crsctl status res
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on mytest

NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on mytest

NAME=ora.ons
TYPE=ora.ons.type
TARGET=OFFLINE
STATE=OFFLINE

[grid@mytest grid]$ crsctl start res ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'mytest'
CRS-2672: Attempting to start 'ora.diskmon' on 'mytest'
CRS-2676: Start of 'ora.diskmon' on 'mytest' succeeded
CRS-2676: Start of 'ora.cssd' on 'mytest' succeeded
[grid@mytest grid]$ crsctl status res ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on mytest

[grid@mytest admin]$ srvctl add asm -l LISTENER -p /u01/app/oracle/11.2.0/grid/dbs/init+ASM.ora -d '/dev/raw/raw*'
[grid@mytest admin]$ srvctl start asm

F. Created ASM Disk Group
[grid@mytest admin] export ORACLE_SID=+ASM
[grid@mytest admin] export ORACLE_HOME=/u01/app/oracle/11.2.0/grid
[grid@mytest admin] sqlplus / as sysasm

SQL> create diskgroup DATA normal redundancy disk '/dev/raw/raw*' ATTRIBUTE 'compatible.asm' = '11.2.0.0.0';

Diskgroup created.

SQL> create pfile='/tmp/pfile' from memory;

File created.

G. Modified '/tmp/pfile' file and create spfile in ASM Disk Group

SQL> create spfile='+DATA' from pfile='/tmp/pfile';

File created.

SQL> shutdown
ASM instance shutdown
SQL> startup
ASM instance started

Total System Global Area 283930624 bytes
Fixed Size 2225792 bytes
Variable Size 256539008 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/asm/asmparameterfile/registry.253.760018979

However, don't miss!!!
[grid@mytest dbs]$ orapwd file=/u01/app/oracle/11.2.0/grid/dbs/orapw+ASM password=password

H. Installed Oracle Database (Software Only) *** su - oracle ***
[oracle@mytest database]$ ./runInstaller -silent -ignoreSysPrereqs -ignorePrereq -ignoreInternalDriverError -responseFile /u01/SRC/database/response/db_install.rsp ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/11.2.0/dbhome_1 ORACLE_HOME_NAME=OraDbHome1 oracle.install.option=INSTALL_DB_SWONLY oracle.install.db.InstallEdition=EE oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=oper DECLINE_SECURITY_UPDATES=true
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 14549 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4099 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-08-24_04-05-49PM. Please wait ...
[WARNING] [INS-30060] Check for group existence failed.
CAUSE: Unexpected error occurred while trying to check for group existence.
ACTION: Refer to the logs or contact Oracle Support Services. Note for advanced users: Launch the installer by passing the following flag ''-ignoreInternalDriverError''.
You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2011-08-24_04-05-49PM.log

As a root user, execute the following script(s):
1. /u01/app/oracle/11.2.0/dbhome_1/root.sh

Successfully Setup Software

I. Go to "root" user and executed the following script
[root@mytest SRC]# /u01/app/oracle/11.2.0/dbhome_1/root.sh
Check /u01/app/oracle/11.2.0/dbhome_1/install/root_mytest_2011-08-24_16-13-58.log for the output of root script

*** checked " /u01/app/oracle/11.2.0/dbhome_1/install/root_mytest_2011-08-24_16-13-58.log " and no error ***
- Created Database
[oracle@mytest ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName orcl -sid orcl -SysPassword password -SystemPassword password -emConfiguration NONE -redoLogFileSize 100 -recoveryAreaDestination DATA -storageType ASM -asmSysPassword password -diskGroupName DATA -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -totalMemory 800
Copying database files
1% complete
3% complete
10% complete
17% complete
24% complete
31% complete
35% complete
Creating and starting Oracle instance
37% complete
42% complete
47% complete
52% complete
53% complete
56% complete
58% complete
Registering database with Oracle Restart
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
86% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.

[oracle@mytest ~]$ cat /u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 10%
DBCA_PROGRESS : 17%
DBCA_PROGRESS : 24%
DBCA_PROGRESS : 31%
DBCA_PROGRESS : 35%
Creating and starting Oracle instance
DBCA_PROGRESS : 37%
DBCA_PROGRESS : 42%
DBCA_PROGRESS : 47%
DBCA_PROGRESS : 52%
DBCA_PROGRESS : 53%
DBCA_PROGRESS : 56%
DBCA_PROGRESS : 58%
Registering database with Oracle Restart
DBCA_PROGRESS : 64%
Completing Database Creation
DBCA_PROGRESS : 68%
DBCA_PROGRESS : 71%
DBCA_PROGRESS : 75%
DBCA_PROGRESS : 85%
PRCR-1079 : Failed to start resource ora.orcl.db
CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0/dbhome_1/srvm/admin/oratab.bak.mytest" failed: details at "(:CLSN00011:)" in "/u01/app/oracle/11.2.0/grid/log/mytest/agent/ohasd/oraagent_grid/oraagent_grid.log"
ORA-01031: insufficient privileges
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-01031: insufficient privileges


CRS-2674: Start of 'ora.orcl.db' on 'mytest' failed
ORA-01031: insufficient privileges
DBCA_PROGRESS : 86%
ORA-01034: ORACLE not available
DBCA_PROGRESS : 96%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/orcl.
Database Information:
Global Database Name:orcl
System Identifier(SID):orcl
Error:
PRCR-1079 : Failed to start resource ora.orcl.db
CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0/dbhome_1/srvm/admin/oratab.bak.mytest" failed: details at "(:CLSN00011:)" in "/u01/app/oracle/11.2.0/grid/log/mytest/agent/ohasd/oraagent_grid/oraagent_grid.log"
ORA-01031: insufficient privileges
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-01031: insufficient privileges

CRS-2674: Start of 'ora.orcl.db' on 'mytest' failed
ORA-01031: insufficient privileges
DBCA_PROGRESS : 86%
ORA-01034: ORACLE not available
J. Tested by SQL*Plus
[oracle@mytest dbs]$ export ORACLE_SID=orcl
[oracle@mytest dbs]$ export ORACLE_HOME=/u01/app/oracle/11.2.0/dbhome_1
[oracle@mytest dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Wed Aug 24 16:53:54 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 835104768 bytes
Fixed Size 2231088 bytes
Variable Size 490734800 bytes
Database Buffers 335544320 bytes
Redo Buffers 6594560 bytes
Database mounted.
Database opened.

*** OK ... this issue depended on Grid Infrastructure ***

K. Fixed issue... CRS-5010
just bug. checked PRCR-1079 ORA-01031 CRS-2674 SRVCTL Fails to Start Database in Oracle Restart Job Role Separation Environment [ID 985743.1]
TEST: ...
[oracle@mytest dbhome_1]$ /u01/app/oracle/11.2.0/dbhome_1/bin/osdbagrp
dba
*** Add "grid" user to "dba" group ***
[root@mytest dbhome_1]# groups grid
grid : oinstall asmadmin asmdba
[root@mytest dbhome_1]# usermod -G asmadmin,asmdba,dba grid
[root@mytest dbhome_1]# groups grid
grid : oinstall dba asmadmin asmdba
[root@mytest dbhome_1]# su - grid
[grid@mytest ~]$ srvctl start database -d orcl
[grid@mytest ~]$ srvctl status database -d orcl
Database is running.

L. Checked ... again
[grid@mytest ~]$ crsctl stat res
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on mytest

NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on mytest

NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE on mytest

NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on mytest

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=ONLINE
STATE=ONLINE on mytest

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on mytest

NAME=ora.ons
TYPE=ora.ons.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.orcl.db
TYPE=ora.database.type
TARGET=ONLINE
STATE=ONLINE on mytest
This was just my test... wishes it's useful for someone.

Related Posts:
Install Grid Infra - clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory
ETC...

10 comments:

Adhika said...

Hi Surachart,

I think the $GRID_HOME/srvm/admin/ folder needs a write permission for the group.

I can see here in my test machine, whenever I started the database using "crsctl start resource ora.", there will be a step where the grid user will copy the oratab file from /etc/oratab to that folder.

At least, by adding the group write permission, the "CRS-5010: Update of configuration file ..." will be gone from oraagent_grid.log.

Cheers,
Adhika

Surachart Opun said...

Thank you for your comment.
I think when we start by using "crsctl ... " Oracle will read resource information.






Rauf said...

Hi Sucharat,
I am trying to start my listener using srvctl and getting the following error,however I am able to start/stop databases using srvctl

$ srvctl start listener -l inppmp1_lsnr
PRCR-1079 : Failed to start resource ora.INPPMP1_LSNR.lsnr
CRS-5010: Update of configuration file "/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora" failed: details at "(:CLSN00014:)" in "/u01/app/11.2.0/grid/log/usolpldxin002/agent/ohasd/oraagent_grid/oraagent_grid.log"
CRS-2674: Start of 'ora.INPPMP1_LSNR.lsnr' on 'usolpldxin002' failed

any suggestions please!

Surachart Opun said...

Your error not help. I suggest you check in /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora file.

Make sure you configure and set ora.INPPMP1_LSNR.lsnr parameter properly.

and /u01/app/11.2.0/grid/log/usolpldxin002/agent/ohasd/oraagent_grid/oraagent_grid.log file.

Or try this
$ export SRVM_TRACE=TRUE
$ srvctl start listener -l inppmp1_lsnr

BTW, I think you should use.

srvctl start listener -n node_name


Please check more error before ask and post question.

Rauf said...

Hi Surachart,
Sorry for not mentioning that this is not RAC,its a stanalone env with grid home owned by grid user and rdbms home owned by oracle user,listener parameters are set correctly,here is the entry

inppmp1_lsnr =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = inppmp1))
(ADDRESS = (PROTOCOL = TCP)(Host = 10.40.165.28)(Port = 20008))
)
SID_LIST_inppmp1_lsnr =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = inppmp1)
)
)

I am able to srart the listener using lsnrctl but not using srvctl,i tried $ export SRVM_TRACE=TRUE but did not work.

Thanks for your prompt respone.

Surachart Opun said...

First, this host is 'usolpldxin002', right?
and what did you see in /u01/app/11.2.0/grid/log/usolpldxin002/agent/ohasd/oraagent_grid/oraagent_grid.log ?

Sorry, I could not help more... I have had information much.

If I was you. 1. I will check about resource paramter by using "crsctl status ora.INPPMP1_LSNR.lsnr -p"

I will use strace to find out more...

I will check more about Oracle HOME I set and Oracle home in resource.

Good Luck

Surachart Opun said...

Rauf

Please check.
1
crsctl status resource ora.INPPMP1_LSNR.lsnr -p | grep -i oracle_home

2.
echo $ORACLE_HOME

because you are set the different ORACLE_HOME ... because you have grid home/oracle database home.

How to fix ... open SR with Oracle Support.

Or set ORACLE_HOME right before using srvctl


Rauf said...

Surachart,
Thanks a lot and I should say your a master of Oracle,your suggestion helped me ,I was facing this issue because I added the listener initially to the oracle database home using srvctl utility then as you said I added it to the grid home and started it using srvctl utility and it worked like charm...Thanks again for your valuable suggestions.....Rauf

Rauf said...

Hi Surachart,
Now that i have fixed my problem of starting listener using srvctl,I have one question about Oracle restart,metalink document 1454439.1 says oracle restart is intended only for non-RAC environment,please let me know what is the alternative for RAC and also oracle documentation says oracle restart will be desupported starting from Oracle 12c.

Thanks!!!
Rauf

Surachart Opun said...

Good to hear like that.

Oracle restart on 12c. It might be desupported in future releases.
I am not sure much about it. but Oracle Restart is currently restricted to manage single instance Oracle Databases and Oracle ASM instances only.