Tuesday, November 13, 2012

[OS] Basic Cron Management

Cron is a job scheduler for *nix operating systems. It is time-based, i.e. can periodically run scripts at certain times. Its main purpose is to automate system maintenance.

The crontab file is the configuration file that specifies the commands that will be executed on a specific moment. Users can have their own crontab file or can use the system crontab file.

The base format of the crontab entry is the following:
minute hour day month day-of-week command-to-execute

[RDBMS] What is ORACLE_UNQNAME?

The ORACLE_UNQNAME is an environment variable that is set to the database’s unique name.

To find its value you must run the following query in the database instance using SQL*Plus (as SYSTEM user):
SELECT name, db_unique_name FROM v$database
 Problem solved!

[RDBMS] Enable Database 11g Console

To enable the Database Control in an Oracle Database 11g you should complete the following tasks:

1. Login as oracle in the server.
2. [Optional] Delete any previous installation. It will ask for Database SID, Listener Port Number, Oracle Home Location and SYS/SYSMAN/DBSNMP Password:

emca -deconfig dbcontrol db -repos drop

Wednesday, November 7, 2012

[RDBMS] Show all tables from a database

This may be a basic SQL query but is a quick note to myself and it could be useful for other people. To list all the tables on your Oracle database, first you need to have access to DBA_TABLES view. If you don't have those privileges ask your DBA to grant you SELECT ANY DICTIONARY privilege or SELECT_CATALOG_TABLE role.

Monday, November 5, 2012

[OS] Bonding Network Interfaces

NIC Bonding (or NIC Teaming) is a way to increase available bandwidth where two network interface cards appear to be the same physical device and share the same MAC address. The Linux kernel module bonding allows this functionality.

First of all, you need to know the hardware addresses for the network cards. Example: eth0, eth1, eth2.

Wednesday, October 17, 2012

[RDBMS] SQL Query to Verify Installed Features and Components on Database

Verify Database Features
The V$OPTION is a view that lists the database features available to use. A database feature is an area of functionality that actually extends the capability of the server.

Monday, October 15, 2012

[OEM12c] Agent Initialization Error "stty: standard input: Invalid argument"

If you are trying to add an host target to you Oracle Enterprise Manager 12c Release 2 and in the Initialization stage appears an error containing the message "stty: standard input: Invalid argument", then you will have to check for stty lines on the files .bashrc.

Tuesday, October 9, 2012

[OEM12c] Named Credentials Not Listing

If you are on a situation in which you (or your client) use too many credentials and they do not appear on your Patch Plan creation (or other procedure involving credentials), we recommend you to change the property oracle.sysman.emdrep.creds.region.maxcreds of your Enterprise Manager.

Sunday, September 23, 2012

If not in PRODUCTION, you are not having enough fun

After go trough every environment: DEV, TEST and PRE-PROD, we were "ready" for the outage on PROD to go from Oracle Database 10g R2 (10.2.0.3) to 11g R2 (11.2.0.3).
As you may know there are some steps that you can execute before the outage begins, so here we go...
For last PSU, CPU or Patch Sets you must mark as "favorite" the following Note in your MOS:

Quick Reference To Patch Numbers For Database PSU, CPU And Bundle Patches [ID 1454618.1]
 
The above was a quick "Place Commercial Here", so where were we? Sure.. the steps, there is another Note, to guide you step by step what you should do in your way to upgrade from any version to 11.2.0.3: Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]

Wednesday, September 5, 2012

So... you have a duplicate Context File... now what?


Trying to pre-validate an EBS System (12.0.6) to work with Oracle Enterprise Manger Cloud Control 12c, I was having some issue with my EBS.  


Context variable details: 
**********************************************************************
|EBS Hostname| Context Variable| Context Value | 
**********************************************************************
|apps01 | s_hostname | apps01 | 
----------------------------------------------------------------------
|apps01 | s_appsuser | apporia | 
----------------------------------------------------------------------
|apps01 | s_appsgroup | oaa | 
----------------------------------------------------------------------
|apps01 | s_port_pool | 20 | 
----------------------------------------------------------------------
|apps01 | s_config_home | /u01/oria/inst/apps/oria_apps01
----------------------------------------------------------------------
|apps01 | s_atName | dbs01 | 
----------------------------------------------------------------------
|dbs01 | s_hostname | dbs01 | 
----------------------------------------------------------------------
|dbs01 | s_appsuser | apporia | 
----------------------------------------------------------------------
|dbs01 | s_appsgroup | oaa | 
----------------------------------------------------------------------
|dbs01 | s_port_pool | 20 | 
----------------------------------------------------------------------
|dbs01 | s_config_home | /u01/oria/inst/apps/oria_dbs01 | 
----------------------------------------------------------------------
|dbs01 | s_atName | dbs01 | 
----------------------------------------------------------------------
|apps01 | s_hostname | apps01 | 
----------------------------------------------------------------------
|apps01 | s_appsuser | apporia | 
----------------------------------------------------------------------
|apps01 | s_appsgroup | oaa | 
----------------------------------------------------------------------
|apps01 | s_port_pool | 20 | 
----------------------------------------------------------------------
|apps01 | s_config_home | /u05/oria/inst/apps/oria_apps01|  (This is NOT right)
----------------------------------------------------------------------
|apps01 | s_atName | dbs01 | 
----------------------------------------------------------------------