Nuovo-Logo-ScriptDBA.com
  • Home
  • About
    • Our Story
    • Resume
  • How to
    • SQL Query In the SQL Query category, you will find numerous queries useful for administering the Oracle database. A SQL Structure Query Language query is a query to a database through SQL code, which is a standard language used to retrieve and manage information from relational databases. Oracle is an RDBMS Relational Database Management System or a DBMS Data Base Management System based on the relational model. This allows you to retrieve data from multiple tables by relating them to each other in order to have the result in a single output. A query consists of a code structure consisting of 2 phases: selection and origin. SELECT * FROM all_users; The third phase follows, which is the condition. We apply a filter to the queries to limit the rows to be recovered: SELECT * FROM all_users WHERE username = ‘ALEX’; This is a simple query that allows us to retrieve the information recorded in the all_users table relating to the ALEX user. On the Foundations of Oracle course, the SQL language in all its forms will be illustrated in detail.
      • Oracle sessions management
        • Oracle SID session query
        • Oracle User Sessions Query
        • Query Oracle sessions to date and time
        • Query to see the RMAN sessions
        • Query Oracle sessions processes transactions cursors
        • Query sessions holding LOCK
        • Query Oracle LOCK and number of LOCKED sessions
        • Query to Identify Sessions Blocked by Another Session
        • KILL Oracle USER sessions on RAC
        • KILL Oracle USER sessions
        • Query disconnect session Oracle
      • Oracle performance statement analysis
        • Query to extract the statement from SQL_ID
        • Query to extract statement from a subsequent SQL_ID EXPLAIN PLAN FOR the statement
      • ASM space management
        • Query to View ASM DiskGroup Spaces
        • ASM LUN CANDIDATE Query
        • Query to view the remaining time of REBALANCE
      • Tablespace management
        • Query size datafiles of a tablespace
        • Query to see the size of all Oracle TABLESPACE
        • Query to retrieve disk space allocated by DATAFILES but not used
        • Query to View TEMPFILE and TEMP TABLESPACE Sizes
        • Query to retrieve disk space allocated by DATAFILES but not used
      • Oracle object management
        • Oracle Objects Query
        • Query for INVALID Objects
        • Query for Compiling INVALID Objects
      • Oracle database Management of LOB objects
        • Oracle Table LOB Query
        • LOB Segment Oracle Query
      • Oracle INDEX management
        • Index Size Query
        • Partitioned Indexes Oracle Query
        • UNUSABLE Indexes Query in Oracle
        • UNUSABLE Partitioned Indexes Query in Oracle
        • Dynamic Query for Generating REBUILD INDEX Command
      • EXTENT management of an Oracle object
        • Query EXTENT Oracle number and size
        • Query EXTENT TABLE Oracle
        • Query Oracle objects with few EXTENTS
      • Users management
        • Query for Oracle User Password Status
        • Query for Oracle User Roles
        • Query for Oracle User Object Privileges
        • DDL for User Creation Roles and Privileges
        • Assignment of DEFAULT_TABLESPACE Quota
        • Query USER PRIVILEGES replicated
      • REDO LOG management
        • Query REDO LOG file name and status
        • Query REDO LOG Switch Count
      • DDL extract Oracle objects
        • DDL Objects in ORACLE
      • Oracle JOBS management
        • Query JOB Oracle status
        • Query JOB Running
        • DBMS_IJOB BROKEN
        • dbms_ijob remove JOB Oracle
        • DBMS_IJOB BROKEN FALSE
    • Comandi CRS
      • CRSCTL commands – CRS Oracle
        • CRS stop
        • CRS start
        • CRS STOP ALL: Complete shutdown of all CRS cluster resources
        • CRS START ALL: Complete startup of all CRS cluster resources
        • Disable CRS
        • Enable CRS
      • SRVCTL commands – CRS Oracle
        • srvctl stop database
        • srvctl start database
        • srvctl stop instance
        • srvctl start instance
        • srvctl stop listener
        • srvctl stop service
        • srvctl start service
        • srvctl relocate service
    • Tutorial Work in progres.
      • Linux Work in progres.
        • Basic Linux commands
      • Oracle Work in progres.
        • Oracle Multitenant Database Architecture
        • How to Extend an Oracle TABLESPACE
        • Export e import in data pump
      • SQL Server
  • English
    • Italian

Comandi CRS

In the “Comandi CRS” category, the commands required for managing Oracle CRS are presented, from registering listener and database resources to managing registered resources.

Oracle Clusterware is a software that allows servers to operate together as if they were a single server.

In an Oracle cluster, each server appears as a standalone server.

However, additional processes are present that enable communication between them, so that separate servers appear as if they were a single server.

Using Oracle Clusterware, it is possible to use the same high reliability mechanisms to make your Oracle database and custom applications available.

Oracle Clusterware includes several processes that facilitate cluster operations. The Cluster Ready Services (CRS) services, Cluster Synchronization Service (CSS), Event Management (EVM), and Oracle Clusterware communicate with other layers of cluster components in other instances in the same cluster database environment.

These components are also the main communication links between Oracle databases, applications, and Oracle Clusterware high availability components.

Additionally, these background processes monitor and manage database operations.

Cluster Ready Services (CRS) is the main program for managing high availability operations in a cluster. Anything that the CRS process manages is known as a cluster resource, which can be a database, an instance, a service, a listener, a virtual IP address (VIP), an application process, and so on.

The CRS process manages cluster resources based on the resource configuration information stored in the OCR. This includes startup, shutdown, monitoring, and failover operations.

After installing Oracle RAC, the CRS process monitors the Oracle database instance, the listener, and so on and automatically restarts these components when an error occurs.

CRSCTL commands – CRS Oracle

CRS START ALL: Complete startup of all CRS cluster resources

CRS START ALL With the CRS START ALL article: Complete startup of all CRS cluster resources, we provide the command to initiate the opening of all online resources registered in the CRS, including the opening of databases, by executing the command from a node of an RAC. If the first Read more…

By Alessandro Caredda, 6 years24 May 2019 ago
CRSCTL commands – CRS Oracle

CRS STOP ALL: Complete shutdown of all CRS cluster resources

CRS STOP ALL With the CRS STOP ALL article: Complete shutdown of all CRS cluster resources, we provide the command to shut down all online resources registered in the CRS from a node of an RAC. As indicated in multiple articles, CRS is the Oracle cluster manager. Through CRS commands, Read more…

By Alessandro Caredda, 6 years24 May 2019 ago
SRVCTL commands - CRS Oracle

srvctl relocate service

SRVCTL RELOCATE SERVICE With the article “srvctl relocate service,” we provide the command to relocate an Oracle service registered in the cluster from one node to another in the RAC using CRS. It may happen that for some reason, such as hardware failure, maintenance activity, or updates, one of the Read more…

By Alessandro Caredda, 6 years18 March 2019 ago
SRVCTL commands - CRS Oracle

srvctl start service

With the article you are about to read: srvctl start service, we provide the command to start an Oracle service registered in the cluster through CRS. Before executing the start, let’s check the status of resources with the command: crsctl status res -t The command to execute srvctl start service Read more…

By Alessandro Caredda, 6 years18 March 2019 ago
SRVCTL commands - CRS Oracle

srvctl stop service

With the article “srvctl stop service,” we provide the command to stop an Oracle service registered in the cluster through CRS. Before executing the stop, check the status of resources with the command: crsctl status res -t The command to execute srvctl stop service is: srvctl stop service -d <database> Read more…

By Alessandro Caredda, 6 years17 March 2019 ago
CRSCTL commands – CRS Oracle

Enable CRS

In this post, we’ll discuss how to enable CRS, so welcome to the “Enable CRS” article, where we provide the command to enable CRS upon operating system reboot. To enable CRS, only one command is needed, but make sure to type it correctly. For this purpose, we suggest using the Read more…

By Alessandro Caredda, 6 years17 March 2019 ago
CRSCTL commands – CRS Oracle

Disable CRS

Disable CRS With the article “Disable CRS,” we provide the command to disable CRS upon operating system reboot to disable autostart. The command is just one, but we advise executing it with caution, as with any command on server platforms, of course. Disabling CRS disables CRS on the system and Read more…

By Alessandro Caredda, 6 years17 March 2019 ago
CRSCTL commands – CRS Oracle

CRS start

With the article CRS start, we provide the command to perform a complete start of the CRS along with all its related resources. In the event that the RAC node has undergone maintenance activities or a change in some hardware component, and the CRS has been previously shut down and Read more…

By Alessandro Caredda, 6 years17 March 2019 ago
CRSCTL commands – CRS Oracle

CRS stop

With the article CRS stop, we provide the command to perform a complete stop of the CRS. The command provided is very convenient, as it shuts down all resources present on the node where it is executed. Complete CRS shutdown is very convenient because there is no need to first Read more…

By Alessandro Caredda, 6 years17 March 2019 ago
SRVCTL commands - CRS Oracle

srvctl stop listener

srvctl stop su Oracle With the article “srvctl stop listener,” we provide the command to stop the Oracle listener on a node of an RAC through CRS. As indicated in the article srvctl start listener, the LISTENER is the process that allows network connections to the database. Specifically, it handles the Read more…

By Alessandro Caredda, 6 years17 March 2019 ago

Posts pagination

1 2 Next
Login
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Recent Posts
  • Query to view the remaining time of REBALANCE
  • Query to extract statement from a subsequent SQL_ID EXPLAIN PLAN FOR the statement
  • Query size datafiles of a tablespace
  • Query to retrieve disk space allocated by DATAFILES but not used
  • Query Oracle sessions processes transactions cursors
Recent Comments
    Categories

    • About
    • Contacts
    • Download ScriptDBA.com
    • Home
    • How to
    • Pivacy Policy
    • References
    Hestia | Developed by ThemeIsle
    Don't have an account yet? Register Now

    Multilingual WordPress with WPML