CAUSE ALTER TABLESPACE TB1 add datafile ‘+WHALE_DG1’ size 10g autoextend on next 500M * ERROR at line 1: ORA-00059: maximum number of DB_FILES exceeded We do not have to recreate the CONTROL FILE from 10g onwards to change/modify MAXLOGFILE, MAXLOGMEMBERS,MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES For MAXDATAFILES, follow the steps below:
It is small xml file located in $GRID_HOME/gpnp/<hostname>/profiles/peer under the name profile.xml. It is used to establish the correct global personality of a node. Each node maintains a local copy of the GPnP Profile and is maintanied by the GPnP Deamon (GPnPD) . So from the above dump we can see that GPnP profile contains … Read more
Oracle 19c Grid Infrastructure requires certain files and provides tools to access each Standalone Cluster . It should have a Grid Infrastructure Management Repository (GIMR) installed or be a part of a Domain Service Cluster having a GIMR. In Oracle 19c Grid Infrastructure, the GIMR is not required for a Standalone Cluster but recommended. If … Read more
Sometimes you may need to kill the RMAN session which is hanging and does not respond. There are several ways to terminate an RMAN command in the middle of execution: 1. The preferred method is to press CTRL+C (or the equivalent “attention” key combination for your system) in the RMAN interface. This will also terminates … Read more
During the Creation of database via DBCA , SPFILE is created in the file location that we specify. This location can be an ASM disk group, cluster file system file, or a shared raw device. If we manually create your database, it is recommended that you create an SPFILE from a PFILE. All instances in … Read more
1. Run this SQL script until it returns ‘CATPROC can be validated now’. For any objects that are reported by this script, they must be addressed in some manner and made valid to continue. To check CATALOG, simply change the two entries in the script. (i.e. replace CATPROC with CATALOG before running) 2. Then run … Read more
Prerequisite. Add below OS groups Add asmdba as secondary group to Oracle user Create Grid User Change the password for Oracle and Grid user Create the Directories for Oracle Database installation Create the Directories for Oracle Grid installation Step2. Configure Oracle ASM Load / initiate Oracle ASM init 0 Add 25 GB Hard Disk Add … Read more
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done that query to improve performance. It might give suggestion to create few indexes or accepting a SQL profile. Suppose the sql id is – 72nggna3640qk 1. Create Tuning Task 2. Execute Tuning task: 3. Tuning … Read more
Check the status of the cluster Check the status of the services on the cluster Stop crs on all nodes (only one node up in this example) Stop crs on specifc node Disable CRS from starting on reboot Enable CRS to start on reboot Start crs on specific node Check database status Stop an instance … Read more
