How to check hidden parameter in Oracle

Check hidden parameter in Oracle

Read More

Generate Custom Report From OEM Cloud Control

REPORTING module can be used in OEM cloud control to generate custom reports like database status report of all target databases. Repository database contains all the target details and metric information. So the best way is to run a query against the repository database. Here we have provided steps for generating database consolidation report ENTERPRISE […]

Read More

Agent Clone Failed Exit Code:1 in Oracle OEM

When we talk about cloud we face issues. In this article we are going have a look at issue during deploying agent in one of the target server for OEM 12c cloud control, got error like Agent Clone Failed Exit Code:1. Solution: Get the inventory location

Go to inventory location, check the permissions on the […]

Read More

Deinstall Management Agents

We pay lots of attention on installation. As we know both things play an important role either is it installation or uninstall. Now we are going to have look on steps which are used to uninstall Management Agents. Below are the steps for Deinstall/Decommission Management Agents in Oracle 12c cloud control. Shutdown the Agent: SETUP – > […]

Read More

Add Database As Target Oracle 12c Cloud Control

Today we are going to have look on some steps which are used to Add Database As Target Oracle OEM 12c Cloud Control. Once agents are deployed on the target host, you can add the database and listeners residing on the target host for monitoring by cloud control. If you haven’t deployed Agents yet, click here […]

Read More

Change Sysman Password For Oracle OEM 12c Cloud Control

Below post is about the steps which are used How To Change Sysman Password For Oracle 12c Cloud Control. 1. Update the password using emctl config syntax – ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <sys password> -new_pwd < new sysman password>  

2. Stop the OMS

3. Start the OMS

2. Status […]

Read More

Steps to Restart Agents In Oracle OEM 12c Cloud Control

Let’s have look on steps which use for To Restart Agents In Oracle 12c Cloud Control. Agents are deployed on the target servers which are being monitored from OEM 12c cloud control. Use below command to start the agent. Checking the agent status:

Starting the Agent

Check the status:

Thank you for giving your […]

Read More

11g Dynamic v$ Performance Views

In this post, we are gonna have look on some important views of Oracle Database. The follow v$ views are used by the new 11g result cache:

The Oracle 11g RAT suite includes database replay and the following v$ view provides details on usage and status for this key new 11g feature with Oracle. […]

Read More

Data Dictionary Architecture in Oracle Database

Till today date normally we all know about Oracle Database Architecture. As we take one step forward in Oracle world we get introduces new terms and technology in Oracle. In this post let’s have a look on data dictionary architecture. Which might be new for you but I am sure it will be more interesting as Oracle Database architecture. […]

Read More

MAX_STRING_SIZE Parameter In Oracle 12c

This parameter was introduced in Oracle 12c. MAX_STRING_SIZE controls the maximum size of string size in Oracle database. Either we can set it to STANDARD or.EXTENDED The default value is STANDARD MAX_STRING_SIZE = STANDARD means the maximum size of strings is 4000 bytes for VARCHAR2 and NVARCHAR2 MAX_STRING_SIZE = EXTENDED means maximum size can be upto 32767 byte . We can change the value of MAX_STRING_SIZE from STANDARD to EXTENDED. But not from EXTENDED to STANDARD. With MAX_STRING_SIZE set to STANDARD , […]

Read More