ora-

Learnomate Technologies > ora-
ora-01722 invalid number in oracle
18
Jan

In this blog, We will try to understand how to resolve the ORA-01722 error. Problem Statement ora-01722 invalid number in oracle Solution First describe the table and check for data types by using desc command Check the type of data you are inserting and type of column An ORA-01722 error occurs when an attempt is […]

Posted in: Oracle DBA ,
Tags: ankushthavali , blognow , ora- , ora-01722 , ora-01722 invalid number in oracle ,
ora-03113 end-of-file on communication channel
18
Jan

This is common error which will occur on oracle database. ora-03113 end-of-file on communication channel Following are the reason to get the error Database goes down abruptly Server goes down and there is no communication with server Solutions Check the alert log file. reason can be anything and accordingly you need to act If you […]

Posted in: Oracle DBA ,
Tags: ankushthavali , blognow , ora- , ora-03113 , ora-03113 end-of-file on communication channel ,
ORA-19573: cannot obtain exclusive enqueue for datafile 1 RM
30
Jun

Received below error while doing the dataguard restoration on standby database. RMAN-03002: failure of restore command at 06/30/2019 13:23:19 ORA-19870: error while restoring backup piece /data/rman/CDB/CDB1_D_20190607_0au 3g8ip_s10_p1 ORA-19573: cannot obtain exclusive enqueue for datafile 1 Follow the below steps to solve this error message. Shutdown the database. RMAN> shutdown immediate;database closeddatabase dismountedOracle instance shut down […]

Posted in: Oracle DBA ,
Tags: cannot obtain exclusive enqueue for datafile 1 RM , ora- , ORA-19573 , ram- , restoration failed , RMAN ,