There are two environment variables for Unix to connect an Oracle database.One of them is ORACLE_SID and the other one is TWO_TASK. ORACLE_SID is used for connecting a database which is installed to the same host. TWO_TASK is used for connecting an oracle database which is installed another host. I must thank to my fellow DBA […]
Articles Tagged: ORACLE 12C
How to check hidden parameter in Oracle
Check hidden parameter in Oracle set lines 200 col name for a50 col value for a40 select ksppinm name , ksppstvl value from x$ksppi a, x$ksppsv b where a.indx=b.indx and substr(ksppinm,1,1) = ‘_’;
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 […]
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 [oracle@bt-tstdev-1]/export/home/oracle/bsstdba# opatch lsinventory Oracle Interim Patch Installer version 12.1.0.1.0 Copyright […]
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 – > […]
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 […]
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> oracle@bttstdev64:…ta/app/oracle/oms12cr5/oms/bin$ ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd oracle1234 -new_pwd oracle1234 Oracle Enterprise Manager […]
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: oracle@test:…oracle/agent12c/agent_inst/bin$. /emctl status agent Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) […]
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: v$result_cache_statistics v$result_cache_memory v$result_cache_objects v$result_cache_dependency v$client_result_cache_stats The Oracle 11g RAT suite includes database replay and the following v$ view provides details on usage and status for this key new […]
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. […]