ORA-01665: control file is not a standby control file Receive the below error after the configuration of standby database manually & started the recovery process on standby database. SQL> alter database recover managed standby database using current logfile disconnect from session; alter database recover managed standby database using current logfile disconnect from session * ERROR… Read More

ORA-14404: partitioned table contains partitions in a different tablespace Got the below error, While dropping a tablespace. SQL> drop tablespace TEST1_TBL including contents and datafiles; drop tablespace TEST1_TBL including contents and datafiles; *ERROR at line 1: ORA-14404: partitioned table contains partitions in a different tablespace Check any contains… Read more..

ORA-65162: The password of the common user has expired The above error is occur due to the user password was expired in your database Check the status of the user SQL> select username,account_status from dba_users where account_status like ‘%EXPIRED%’; USERNAME      ACCOUNT_STATUS —————————– SYSTEM              EXPIRED Check… Read more..

How to set the alternative archive destination in Oracle database In case of the archivelog destination space is filled/exausted., the database will be hang until the space release from server. Error log: 0RA-00257: Archiver error, connect internal only until freed ORA-16014: Log 1 sequence# 3981 not archived, no available destinations Solution: To… Read more..

Checking swap space: 0 MB available, 150 MB required. Failed or Configure the swap space Error log while installation. [oracle@miroradb database]$ ./runInstaller Starting Oracle Universal Installer… Checking Temp space: must be greater than 120 MB. Actual 36214 MB Passed Checking swap space: 0 MB available, 150 MB required. Failed <<<< Checking monitor: must… Read more..

TNS-00583: Valid node checking: unable to parse configuration parameters in Oracle 12c Check the status of database SQL> select status,instance_name,open_mode, version from V$database,v$instance; STATUS INSTANCE_NAME OPEN_MODE VERSION ———— —————- ——————– —————– OPEN oemdb READ WRITE 12.1.0.2.0 Start the listerner [oracle@oemdb… Read more..