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

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

1 Answer

Answer :

crs_stat -t -v (-t -v are optional)
by

Related questions

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

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

Last Answer : srvctl

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.

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)

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.

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 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.

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.

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.

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 is a Check Box?

Description : What is a Check Box?

Last Answer : A Check Box is a two state control that indicates whether a certain condition or value is on or off, true or false. The display state of a check box is always either "checked" or "unchecked".

What are the triggers associated with a check box?

Description : What are the triggers associated with a check box?

Last Answer : Only When-checkbox-activated Trigger associated with a Check box.

How can you check the structure of a table from sqlplus?

Description : How can you check the structure of a table from sqlplus?

Last Answer : DESCRIBE or DESC

Which log would you check if a database has a problem?

Description : Which log would you check if a database has a problem?

Last Answer : Alert log

How can you check if the database is accepting connections?

Description : How can you check if the database is accepting connections?

Last Answer : lsnrctl status or lsnrctl services

What is the full form of 'RAC' ? -How To ?

Description : What is the full form of 'RAC' ? -How To ?

Last Answer : The full form of 'RAC' is Reservation Against Cancellation

RAC stands for A. Reservation Against Cancellation B. Reservation Against Collection C. Reservation against cancel D. None of These

Description : RAC stands for A. Reservation Against Cancellation B. Reservation Against Collection C. Reservation against cancel D. None of These

Last Answer : A [Reservation Against Cancellation]

Horse power of I.C. engines can be expressed as RAC rating, SAE rating, or DIN rating. To which countries these standards belong ?

Description : Horse power of I.C. engines can be expressed as RAC rating, SAE rating, or DIN rating. To which countries these standards belong ?

Last Answer : U.K., USA and Germany respectively.

. A permanent DRDO exhibition known as Darpan is established at (a) VRDE (b) INMAS (c) DRDE (d) RAC

Description : . A permanent DRDO exhibition known as Darpan is established at (a) VRDE (b) INMAS (c) DRDE (d) RAC

Last Answer : (d) RAC

Where online can I check for a business name availability that I am interested in?

Description : Where online can I check for a business name availability that I am interested in?

Last Answer : If you want to search a large database of businesses then this website is what you need, http://www.directincorporation.com. There you will able to find out if your name is taken or not.