Mir Sayeed Hassan – Oracle Blog

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

How to create a RMAN Catalog & register in Oracle Database 12c(12.2.0.0)

Overview of recovery catalog

The recovery catalog contains metadata about RMAN operations for each registered target database. therefore when RMAN is connected to a recovery catalog, the RMAN obtains its metadata exclusively from the catalog db, to perform this operation you need to have a dedicated user...
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..