ORA-65096: invalid common user or role name in Oracle 12c DB The above issue is occur in Oracle 12c DB while creation of new database in Container. Solution recommendation If you want to create a user in Container DB (Oracle 12c), you need to use the prefix as “C##” If you want to create a Read More

ERROR: cannot find RHNS CA file: /usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT The below error is occur in one of my server while install the rpm packages Install the RPM Package for telnet [root@testdb~]# yum install telnet* Loaded plugins: fastestmirror, langpacks, ulninfo ERROR: can not find RHNS CA file: /usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT Check… Read more..

ORA-00245 control file backup failed target is likely on a local file system Got the error while taking the backup of the controlfile. Connect to RMAN & Initiate the backup of controlfile [oracle@racdb1 ~]$ rman target / Recovery Manager: Release 11.2.0.3.0 – Production on Sat Feb 13 09:54:49 2021 Copyright (c) 1982, 2011, Oracle and/or… Read More

ORA-15046: ASM file name is not in single-file creation form We got an below error copying the file from the existing ASM location to the New ASM Disk as shown below ASMCMD> cd +FRA/RACDBN1/BACKUPSET/2020_12_16/ ASMCMD> ls nnndn0_FRIDAY_LEVEL_0_0.333.1059285491 Need to copy the above file to new asm disk ASMCMD>… Read more..

ORA-16826: apply service state is inconsistent with the DelayMins property on Oracle Database 11gr2(11.2.0.4) Check the status of database SQL> select instance_name,version,status,open_mode from V$instance, v$database; INSTANCE_NAME VERSION STATUS OPEN_MODE —————- —————–… Read more..

Error while deleting the oracleasm disks from Oracle Server Check the disk need to delete [root@pri-db ~]# cd /dev/oracleasm/disks/ [root@pri-db disks]# ls ORADATA Delete the oracleasm disk “ORADATA” [root@pri-db disks]# oracleasm deletedisk ORADATA Clearing disk header: failed Unable… Read more..