Oracle Error ORA-00604 and ORA-01219: Database Not Open - Solution and Explanation

The error message "ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only" indicates that the database or pluggable database is not open, and therefore, you cannot execute queries on fixed tables or views. \n\nTo resolve this issue, you need to ensure that the database or pluggable database is open before executing the GRANT statement. You can use the following steps:\n\n1. Connect to the Oracle database using a privileged user account.\n2. Open the database or pluggable database using the following command:\n\n SQL\n ALTER DATABASE OPEN;\n \n\n If you are working with a pluggable database, you can use the following command to open it:\n\n SQL\n ALTER PLUGGABLE DATABASE <pluggable_database_name> OPEN;\n \n\n Replace <pluggable_database_name> with the name of your pluggable database.\n\n3. Once the database or pluggable database is open, you can execute the GRANT statement again:\n\n SQL\n GRANT SELECT ON gv$asm_operation TO htdasm;\n \n\n This will grant the SELECT privilege on the gv$asm_operation view to the user htdasm. \n\nRemember to replace htdasm with the actual username you want to grant the privilege to. \n\nNote: The gv$asm_operation view is a fixed view that displays information about ongoing operations in the Oracle ASM instance. Make sure the user htdasm has the necessary privileges and roles to access and query this view.