I got the error “ORA-21561: OID generation failed” when I tried to connect in rman catalog. To solve this problem, you need to edit the /etc/hosts file and add the name of the machine (host). The text above I wrote in 2015 while I was using the database version 11g. Now in March 2020 I faced the same error and despite of the fact that the version in this new case be 12c and I was trying to clone a virtual marchine from another the solution was the same :…
Author: brunors
Managing and Creating a Permanent Tablespaces on Oracle Database 11GR2
Some importants notes from Oracle’s documentation: – “… you cannot rename or drop the SYSTEM tablespace or take it offline.” – “As for the SYSTEM tablespace, management of the SYSAUX tablespace requires a higher level of security and you cannot rename or drop it.” Locally Managed Tablespace : Define through the command EXTENT MANAGEMENT LOCAL where you can: – Choose two types of extent management: AUTOALLOCATE: (default) Database manage extents. CREATE TABLESPACE tech01 DATAFILE ‘/u01/app/oracle/oradata/DB/tech01.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ; UNIFORM: You define the size on command…
ORA-0131:Insufficient Priviledges Debugging requires Debug connect session system priviledges
To solve this error , you have just to run a grant to the username that you can debugging and try again. SQL> grant debug connect session to username; brunors
Getting Instantiating disk: failed while an attempt to create a disk on OEL 6.3
While an attempt to create a disk, I got the follow error: ” Instantiating disk: failed”. Then, I did the follow steps: vi /etc/selinux/config and change the value selinux=enforcing to disabled. Restart your Operating System. Type it getenforce on prompt to your terminal. Try create the disk again through the command oracleasm createdisk DISK1 /dev/sdb1 Follow the example after the reboot: brunors
ASM 11g Disk Groups Management
Some Views: V$ASM V$ASM_ATTRIBUTE V$ASM_DISK V$ASM_DISKGROUP V$ASM_DISK_STAT V$ASM_FILE V$ASM_OPERATION V$ASM_USER Redundancy level of the disk group: Normal Redundancy: 2-way mirroring by default for most file types and the maximum oracle asm file sizes for disk group is 5.8 TB High Redundancy:3-way mirroring for all files and the maximum oracle asm file sizes for disk group is 3.9 TB. External Redundancy: If you do not want mirroring by Oracle ASM, but for RAID disk and the maximum oracle asm file sizes for disk group is 16 TB. CREATING…
Drop Oracle Database 11g
Drop database by command line $ sqlplus “/as sysdba” SQL> select instance_name, status from v$instance; SQL> shutdown immediate; SQL> startup mount SQL> alter system enable restricted session; SQL> drop database; Drop database by DBCA $cd $ORACLE_HOME/bin $./dbca DBCA-> Click “Delete a Database” -> Select the database name -> Click “Finish” brunors
Install Oracle Grid 11.2.0.3 Infrastructure on Oracle Linux 6.3
Install Oracle Grid 11.2.0.3 Infrastructure it is an operation that you have to do the prerequisites in the section Installing and Upgrading from Oracle documetation before continue installing the Oracle Grid infrastructure. Then go to stage area to grid file and do the follow operation: unzip p10404530_112030_Linux-x86-64_3of7.zip In the grid directory, run the runInstaller and start the installation: In the “Download Software Update” section, select “Skip software update” option and click in “Next”. Click “Install and Configure Oracle Grid Infrasctruture for a Cluster”. Click “Advanced Installation” and “Next” . In…
MENU FOR ORACLE DATABASE ON IBM AIX
When you have several databases in the same server using also the same user, it is common human errors because wrong Oracle environmental variables configuration. Then below has a script that you can put in .profile file of the user own of Oracle Database files on IBM AIX: EDITOR=vi export EDITOR clear echo “Please choose the instance number” echo ” ” cont=0 awk -F: ‘ ! /^#|^$|^*/ {print $1,$2}’ /etc/oratab | while read par1 par2 do cont=`expr $cont + 1` inst[$cont]=$par1 orahome[$cont]=$par2 echo ” [ $cont ] ${inst[$cont]} ( ${orahome[$cont]}…
Configure Services using Policy Managed Method on Oracle RAC 11G
On the Oracle Real Application Clusters (Oracle RAC) 11G you can create services for clients use to connect to one or several instances using either Oracle Enterprise Manager or SRVCTL. Moreover, it is important you know the managed methods for configure the services and what are the activities that you can do in a service.The activities are show below: Delete a service Check the status of a service Start or stop a service for a database or an instance Map a service to a consumer group Enable or disable a…
Configure Services using Manual Managed Method on Oracle RAC 11G
On the Oracle Real Application Clusters (Oracle RAC) 11G you can create services for clients use to connect to one or several instances using either Oracle Enterprise Manager or SRVCTL. Moreover, it is important you know the managed methods for configure the services and what are the activities that you can do in a service.The activities are show bellow: Delete a service Check the status of a service Start or stop a service for a database or an instance Map a service to a consumer group Enable or disable a…