
The SRVCTL enable command enables the named object so that it can run under Oracle Restart for automatic startup, failover, or restart. Usage: srvctl disable diskgroup -diskgroup Usage: srvctl disable service -db -service “” The SRVCTL disable command disables the named object so that it is unavailable to run under Oracle Restart for automatic startup, failover, or restart. Usage: srvctl modify ons …]] įor detailed help on each command and object and its options use: ~]$ srvctl status asm -detailĪSM is enabled. The srvctl status command is used to display the running status information of components. ~]$ srvctl config service -db orcl 3 status command ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL: false 2.5 srvctl config service 2.4 srvctl config onsĭisplay Oracle notification service information. Spfile: +DATA/ORCL/PARAMETERFILE/spfile.267.1037831659ĭatabase instance: orcl 2.3 srvctl config listener ~]$ srvctl config database -db orcl -all Query Server automatically creates Oracle external tables corresponding to the tables in the Hive metastore database(s) so that they are ready for querying.
#Restarting oracle database install#
To install Query Server, you must specify Cloud SQL as an option in Big Data Service through the service console. Spfile: +DATA/ASM/ASMPARAMETERFILE/registry.253.1037659875ĪSM diskgroup discovery string: /dev/oracleasm/disks/* 2.2 srvctl config database A restart deletes regular tables containing user data. Show the Oracle restart configuration information of ASM instance. The srvctl config command can display the Oracle restart configuration information of a specific component or a group of components. Objects: database|service|asm|diskgroup|listener|home|ons 2 config command 1 srvctl command syntaxĬommands: enable|disable|start|stop|status|add|remove|modify|update|getenv|setenv|unsetenv|config|upgrade|downgrade This article mainly introduces the application of srvctl command in Oracle restart, including the config and status commands in detail, and lists the usage of other commands. Srvctl, service control utility, can be used to configure and manage Oracle restart and Oracle RAC.
