Mir Sayeed Hassan – Oracle Blog

How to perform the Manual Data Guard Switchover on Oracle 19c Database

To perform this data guard switchover operation., You need to planned according to the requirement.

In this case., your primary database role will be changed/converted as STANDBY DB., Standby database role will be changed/converted as PRIMARY DB & There is no loss of data in this method.

Consider...
Read more..

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..			

How to Install the Oracle Enterprise Manager Cloud Control (OEM) 13.5c on Oracle Linux

Check the OS

[oracle@oem13 ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.5 (Maipo)

Hostname:

[root@oem13 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
192.168.***.***... 
Read more..			

Install Oracle 19c Database Software only on Oracle Linux 7.5

Check the OS

[oracle@ora19c ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.5 (Maipo)

Hostname:

[root@ora19c ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
192.168.***.*** ora19c

[oracle@ora19c... 
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..

How to configure the memory target in Oracle Database

Consider you are running the database with sga & pga configuration., if you need to change it to memroy target, fallow the below process.

Check the status of database

SQL> select instance_name, version, open_mode from V$database, v$instance;

INSTANCE_NAME       VERSION         OPEN_MODE
----------------------------------------------
oemsw... 
Read more..