Mir Sayeed Hassan – Oracle Blog

How to change the SYSMAN Password on OEM 12C/13C.

Check the current database status

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

INSTANCE_NAME STATUS VERSION
---------------- ------------ -----------------
oemdb OPEN 12.1.0.2.0

To change/reset the sysman password, you need to know the sys password of database.

Note:...
Read more..

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 user in Pluggable DB (PDB) (Oracle...

ERROR emCLI.CLIPageHandler render.672 – ORA-14400: inserted partition key does not map to any partition

This issue is occur while dropping the agent from OEM Server.

Login to OEM Server

[oracle@oemdb ~]$ cd /u01/oem13.4c/middleware/bin/

[oracle@oemdb bin]$ ./emcli login -username=SYSMAN
Enter password : ********

Login... 
Read more..			

OEM Fix For Agent Shows Availability Evaluation Error

This error occur in one of our database after adding and agent into it

Locate to the agent bin location and check the current status

[oracle@test-db ~]$ cd /home/oracle/OEM13.4/agent_inst/bin/

[oracle@test-db bin]$ ls
emctl emtgtctl forwarderProxy nmosudo.props

Check...
Read more..

How to Exclude Specific Tablespace from the RMAN Backup in Oracle 11gR2

Check the database details

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

INSTANCE_NAME VERSION OPEN_MODE
---------------- ----------------- -----------
testdb1 11.2.0.4.0 READ WRITE

Check the RMAN Configuration

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