OEM – Lots of Tech and a bit of Health

Generate tnsnames.ora from up to date OEM using sqlcl

OEM, Oracle, Oracle Database, sqlCL / By thg

No it is not required to use sqlcl for this. sqlplus or any other sql execution tool of your choice will work. C:\sqldeveloper-17.2.0.188.1159-x64\sqlcl-17.2.0.184.1230-no-jre\sqlcl\bin\sql.bat /nolog connect sysman/yourSysmanPW@your-oem-hostname:1521/emService spool newtns.ora set pagesize 0 set verify off set feedback off select distinct sid.PROPERTY_VALUE||’ = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ‘||machine.PROPERTY_VALUE||’)(PORT = ‘||port.PROPERTY_VALUE||’))) (CONNECT_DATA …

Generate tnsnames.ora from up to date OEM using sqlcl Read More »

How do I find Oracle support lifetime and what is not supported for all products and versions?

Leave a Comment / OEL (Linux), OEM, Oracle Data Guard, Oracle Database, Oracle EBS, Oracle Upgrade, RMAN / By thg

http://www.oracle.com/us/support/lifetime-support/index.html There are PDFs at the bottom of the page above providing information on an array products.

I forgot the URL to Oracle Enterprise Manager / OEM 13c – one way to find it – emctl status oms -details

Leave a Comment / Linux RHEL/CentOS/OEL, OEL (Linux), OEM / By thg

I forgot the URL to OEM – one way to find it – along with many the other related ports, homes, logs. It is under “Console URL:” below. export OMS_HOME=/u01/app/oracle/middleware $OMS_HOME/bin/emctl status oms -details Oracle Enterprise Manager Cloud Control 13c Release 2 Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root …

I forgot the URL to Oracle Enterprise Manager / OEM 13c – one way to find it – emctl status oms -details Read More »

oem agent can't communicate with oms

Leave a Comment / OEM, Oracle Database / By thg

I have a OEM 13c installation on my test network – and a few databases with 13c agents all running linux. After adding an agent succussfully, the IP changed on OMS (moved the VM that as hosting and the IP was DHCP based)- and I forgot to update one of the hosts files on one …

oem agent can't communicate with oms Read More »

Drop and recreate 11gR2 emctl dbconsole

Leave a Comment / OEM, Oracle, Oracle Database / By thg

— careful the drop “quieces” (temporarily halts transactions) and only warns you after you start the drop — DROP DBConsole $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop — CREATE DBConsole along with the repository $ORACLE_HOME/bin/emca -config dbcontrol db -repos create

Oracle 11gR2 OEM dbcontrol drop and recreate after database clone – OC4J_DBConsole not found

Leave a Comment / OEM, Oracle Database / By thg

Got this error after a 11gR2 database clone. oracle [prod] logs $ emctl status dbconsole OC4J Configuration issue. /u01/app/oracle/product/11.2.0.4/db_1/oc4j/j2ee/OC4J_DBConsole_hostname_prod not found. Just drop and recreate the repository and the configuration as follows – be aware this action will quiesce the database – and potentially impact operations emca -deconfig dbcontrol db -repos drop emca -config dbcontrol …

Oracle 11gR2 OEM dbcontrol drop and recreate after database clone – OC4J_DBConsole not found Read More »

oraInventory – what's this about?

Leave a Comment / OEL (Linux), OEM, Oracle, Oracle Database / By thg

Here are a few tidbits (not comprehensive – I’ll leave that to Oracle) about “oraInventory”. Generally, it’s directory structure containing XML files that point at installed Oracle Products. Where is “oraInventory”? On Linux & most UNIX dialects here is a pointer to the directory structure: /etc/oraInst.loc or /var/opt/oracle/oraInst.loc $ cat /etc/oraInst.loc inventory_loc=/u01/app/oraInventory inst_group=dba So lets …

oraInventory – what's this about? Read More »