Which command will we use to manage (stop, start…) RAC services in command-line mode?

Which command will we use to manage (stop, start…) RAC services in command-line mode?
by

1 Answer

Answer :

srvctl
by

Related questions

What command would you use to check the availability of the RAC system?

Description : What command would you use to check the availability of the RAC system?

Last Answer : crs_stat -t -v (-t -v are optional)

How many alert logs exist in a RAC environment?

Description : How many alert logs exist in a RAC environment?

Last Answer : One for each instance.

What is the difference between normal views and RAC views?

Description : What is the difference between normal views and RAC views?

Last Answer : RAC views has the prefix ‘G’. For example, GV$SESSION instead of V$SESSION

What RAC component is used for communication between instances?

Description : What RAC component is used for communication between instances?

Last Answer : Private Interconnect.

What was RAC previous name before it was called RAC?

Description : What was RAC previous name before it was called RAC?

Last Answer : OPS: Oracle Parallel Server

Can you have many database versions in the same RAC?

Description : Can you have many database versions in the same RAC?

Last Answer : Yes, but Clusterware version must be greater than the greater database version.

Name two specific RAC background processes

Description : Name two specific RAC background processes

Last Answer : RAC processes are: LMON, LMDx, LMSn, LKCx and DIAG.

What is the minimum number of instances you need to have in order to create a RAC?

Description : What is the minimum number of instances you need to have in order to create a RAC?

Last Answer : 1. You can create a RAC with just one server.

What is the recommended method to make backups of a RAC environment?

Description : What is the recommended method to make backups of a RAC environment?

Last Answer : RMAN to make backups of the database, dd to backup your voting disk and hard copies of the OCR file.

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

What command will you start to run the installation of Oracle software on Linux?

Description : What command will you start to run the installation of Oracle software on Linux?

Last Answer : runInstaller

What use of command line parameter cmd file?

Description : What use of command line parameter cmd file?

Last Answer : It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB ... locked users account ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the ... from SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks

What is the use of TABLES option in EXP command ?

Description : What is the use of TABLES option in EXP command ?

Last Answer : List of tables should be exported.ze)

What is the use of PARFILE option in EXP command ?

Description : What is the use of PARFILE option in EXP command ?

Last Answer : Name of the parameter file to be passed for export.

What command would you use to encrypt a PL/SQL application?

Description : What command would you use to encrypt a PL/SQL application?

Last Answer : WRAP

What command would you use to create a backup control file?

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

What is the use of CONSISTENT (Ver 7) option in EXP command ?

Description : What is the use of CONSISTENT (Ver 7) option in EXP command ?

Last Answer : A flag to indicate whether a read consistent version of all the exported objects should be maintained.

What is the use of CONSTRAINTS option in EXP command ?

Description : What is the use of CONSTRAINTS option in EXP command ?

Last Answer : A flag to indicate whether constraints on table need to be exported.

What is the use of SHOW option in IMP command ?

Description : What is the use of SHOW option in IMP command ?

Last Answer : A flag to indicate whether file content should be displayed or not.

What is the use of FULL option in EXP command ?

Description : What is the use of FULL option in EXP command ?

Last Answer : A flag to indicate whether full databse export should be performed.

What is the use of GRANT option in IMP command ?

Description : What is the use of GRANT option in IMP command ?

Last Answer : A flag to indicate whether grants on database objects will be imported

What is the use of GRANT option in EXP command?

Description : What is the use of GRANT option in EXP command?

Last Answer : A flag to indicate whether grants on databse objects will be exported or not. Value is 'Y' or 'N'.

What is the use of INDEXES option in IMP command ?

Description : What is the use of INDEXES option in IMP command ?

Last Answer : A flag to indicate whether import should import index on tables or not.

What is the use of INDEXES option in EXP command ?

Description : What is the use of INDEXES option in EXP command ?

Last Answer : A flag to indicate whether indexes on tables will be exported.

What is the use of ROWS option in IMP command ?

Description : What is the use of ROWS option in IMP command ?

Last Answer : A flag to indicate whether rows should be imported. If this is set to 'N' then only DDL for database objects will be executed.

What is the use of ANALYSE ( Ver 7) option in EXP command ?

Description : What is the use of ANALYSE ( Ver 7) option in EXP command ?

Last Answer : A flag to indicate whether statistical information about the exported objects should be written to export dump file.

What is the use of IGNORE option in IMP command ?

Description : What is the use of IGNORE option in IMP command ?

Last Answer : A flag to indicate whether the import should ignore errors encounter when issuing CREATE commands.

What is the use of COMPRESS option in EXP command ?

Description : What is the use of COMPRESS option in EXP command ?

Last Answer : Flag to indicate whether export should compress fragmented segments into single extents.

What is the use of ROWS option in EXP command ?

Description : What is the use of ROWS option in EXP command ?

Last Answer : Flag to indicate whether export should compress fragmented segments into single extents.

What is the use of RECORD option in EXP command?

Description : What is the use of RECORD option in EXP command?

Last Answer : For Incremental exports, the flag indirects whether a record will be stores data dictionary tables recording the export.

What is the use of PARFILE option in EXP command ?

Description : What is the use of PARFILE option in EXP command ?

Last Answer : Name of the parameter file to be passed for export.

What is the use of RECORD LENGTH option in EXP command ?

Description : What is the use of RECORD LENGTH option in EXP command ?

Last Answer : Record length in bytes.

What is the use of FILE option in IMP command ?

Description : What is the use of FILE option in IMP command ?

Last Answer : The name of the file from which import should be performed.

What is the use of INCTYPE option in EXP command ?

Description : What is the use of INCTYPE option in EXP command ?

Last Answer : Type export should be performed COMPLETE,CUMULATIVE,INCREMENTAL. List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment toexpand into anotion Completes. e. will be written.

WWhat is the use of ANALYZE command ?

Description : WWhat is the use of ANALYZE command ?

Last Answer : To perform one of these function on an index,table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary. - To delete statistics about the ... the structure of the object. - To identify migrated and chained rows of the table or cluster.

What command will you use to navigate through ASM files?

Description : What command will you use to navigate through ASM files?

Last Answer : asmcmd

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Description : What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Last Answer : CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

Some Basics command of ORACLE 10g on Windows Operating System:

Description : Some Basics command of ORACLE 10g on Windows Operating System:

Last Answer : SQL> show parameter db_name SQL> show parameter instance_name SQL> show parameterdb_block_size (it will show the default block size which is 8KB)

How does one stop and start the OMS? (for DBA

Description : How does one stop and start the OMS? (for DBA

Last Answer : Use the following command sequence to stop and start the OMS (Oracle Management Server): oemctl start oms oemctl status oms sysman/oem_temp oemctl stop oms sysman/oem_temp Windows NT/2000 users can just ... of "oem_temp". NOTE: Use command oemctrl instead of oemctl for Oracle 8i and below.

What are the values that can be specified for OPTIMIZER MODE Parameter ?

Description : What are the values that can be specified for OPTIMIZER MODE Parameter ?

Last Answer : COST and RULE.

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Description : Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Last Answer : ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. ... having to write transactions to an archive log and thus increases the performance of the database slightly.

What is Restricted Mode of Instance Startup ?

Description : What is Restricted Mode of Instance Startup ?

Last Answer : An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Description : What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Last Answer : Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

What are savepoint mode and cursor mode properties ? level?

Description : What are savepoint mode and cursor mode properties ? level?

Last Answer : Specifies whether Oracle Forms should issue savepoints during a session. This property is included primarily for applications that will run against non-ORACLE data sources. For applications that will run ... use the default setting. Cursor mode - define cursur state across transaction Open/close.

what are key-mode and locking mode properties? level ?

Description : what are key-mode and locking mode properties? level ?

Last Answer : Key Mode : Specifies how oracle forms uniquely identifies rows in the database.This is property includes for application that will run against NON-ORACLE datasources . Key setting unique (default.) ... locks on rows that correspond to queried records in the form. a) immediate b) delayed

My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Description : My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Last Answer : If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the ... : ALTER DATABASE END BACKUP; The above commands need to be issued when the database is mounted.