Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

Checking swap space: 0 MB available, 150 MB required. Failed or Configure the swap space

Posted by Mir Sayeed Hassan on June 19th, 2021

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

Posted in ORA-Error | Comments Off on Checking swap space: 0 MB available, 150 MB required. Failed or Configure the swap space

TNS-00583: Valid node checking: unable to parse configuration parameters in Oracle 12c

Posted by Mir Sayeed Hassan on June 14th, 2021

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

Posted in ORA-Error | Comments Off on TNS-00583: Valid node checking: unable to parse configuration parameters in Oracle 12c

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

Posted by Mir Sayeed Hassan on April 11th, 2021

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

Posted in OEM (Oracle Enterprise Manager) | Comments Off on How to change the SYSMAN Password on OEM 12C/13C

ORA-65096: invalid common user or role name in Oracle 12c DB

Posted by Mir Sayeed Hassan on March 10th, 2021

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

Read more..

Posted in ORA-Error | Comments Off on ORA-65096: invalid common user or role name in Oracle 12c DB

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

Posted by Mir Sayeed Hassan on March 9th, 2021

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

Posted in OEM (Oracle Enterprise Manager) | Comments Off on ERROR emCLI.CLIPageHandler render.672 – ORA-14400: inserted partition key does not map to any partition

OEM Fix For Agent Shows Availability Evaluation Error

Posted by Mir Sayeed Hassan on March 9th, 2021

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

Posted in OEM (Oracle Enterprise Manager) | Comments Off on OEM Fix For Agent Shows Availability Evaluation Error