Archive

Archive for the ‘Grid’ Category

11gR2 Target Database or Repository Producing Several TNS-12599

January 25, 2012 Leave a comment

***********************************************************************
NI cryptographic checksum mismatch error: 12599.

VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 14-JUL-2010 11:39:22
Tracing not turned on.
Tns error struct:
ns main err code: 12599

TNS-12599: TNS:cryptographic checksum mismatch
ns secondary err code: 2526
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Wed Jul 14 11:48:14 2010
***********************************************************************

Workaround:

on the target database side, set SQLNET.ENCRYPTION_TYPES_SERVER= (3DES168)  in sqlnet.ora

Patches for bug 9953045 and  bug 12360281 fix this problem.

– bug 9953045   is to fix the issue for repository connection made from OMS
– bug 12360281 is to fix target database connections made from OMS

Download patches from Oracle

p9953045_111010_Generic.zip

p12360281_111010_Generic.zip

Categories: Grid

Install Oracle Grid Control 11g on Linux 64 Bit

September 14, 2011 Leave a comment

Download the following patches from Oracle

Grid software

GridControl_11.1.0.1.0_Linux_x86-64_1of3.zip
GridControl_11.1.0.1.0_Linux_x86-64_2of3.zip
GridControl_11.1.0.1.0_Linux_x86-64_3of3.zip

Weblogic Software 

wls1032_generic.jar

 

Invoke the software like

<Java_home>/bin/java -d64 -jar wls1032_generic.jar

Once the install is done  , you need to apply patch WDJ7   p9438213   to the WLS home before installing grid control . refer to note 1072763.1 for instructions to apply online/offline patch to WLS

Additional notes not mentioned in the metalink note

If you run the script as follows

./bsu.sh -prod_dir=/u01/oracle/Middleware/wlserver_10.3 -patch_download_dir=/u01/oracle/Middleware/utils/bsu/cache_dir -patchlist=4D53,NIXN, ,XLXA -verbose -install -log=/tmp/error.log

and it  fails with errors –

Encountered unrecognized patch ID: 4D53

Encountered unrecognized patch ID: NIXN

Encountered unrecognized patch ID: XLXA

To fix this –

Rename the file patch-catalog_15563.xml as patch-catalog.xml in the cache_dir .

This completes the installation of web logic

Install Grid Control

Before you install grid control , make sure you have a database to install the grid control repository

Make sure the following parameters are set

sessions_cached_cursors  > = 200

log_buffer > =  10485760

processes > = 500

Grid  control also requires 200Mb  of undo tablespace

Also you will have to deconfigure dbconsole if its installed on the database

Single instance  

<Database_Oracle_Home>/bin/emca -deconfig dbcontrol db -repos drop -SYS_PWD <sys password> -SYSMAN_PWD <sysman_password>

RAC database

<Database_Oracle_Home>/bin/emca -deconfig dbcontrol db -repos drop  -cluster -SYS_PWD <sys password> -SYSMAN_PWD <sysman_password>

Go to the download location and invoke the ./runInstaller

For further instruction of Grid Install  refer to Oracle note  ID 1059516.1

Once you install has finished  you should be able to connect to the following URLS


Use the following URL to access:

1. Enterprise Manager Grid Control URL: <a href="https://hostname.xxx-group.com:7799/em">https://hostname.xxx-group.com:7799/em</a>

2. Admin Server URL: <a href="https://hostname.xxx-group.com:7101/console">https://hostname.xxx-group.com:7101/console</a>

The following details need to be provided during the additional OMS install:

1. Admin Server Hostname: hostname.xxx-group.com

2. Admin Server Port: 7101

Other issues you will encouter with GRID control as as follows

After installing Grid Control 11.1.0.1, you may see the target “/secFarm_GCDomain/GCDomain/EMGC_ADMINSERVER/FMW Welcome Page Application(11.1.0.0.0)” reported as DOWN:

Steps to fix this issue

Patch 9431704 fixes this issue and is available via Oracle My Support. make sure you download the correct version of the patch or it will fail to install, also download the latest version of OPATCH from oracle support

Check the version of the software by running opatch lsinventory

Stop all Oracle Management Server processes:

Unzip patch 9431704

Set ORACLE_HOME to Middleware oracle_common directory and apply patch:

Start OMS processes:

After  applying this one-off patch, FMW Welcome Page Application should no longer be reported as down:

Another issue  reported on Grid console is

Incident (BEA-101020 [HTTP]) detected in …/user_projects/domains/GCDomain/servers/EMGC_OMS1/adr/diag/ofm/GCDomain/EMGC_OMS1/alert/log.xml

To resolve the above issue to need to apply a couple of patches to the agent  see oracle note 1139600.1

Download patch 9882856  , part of the patch you need to shut the agent down ,if you encounter the following error

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

You need to set the following env variables

export ORACLE_HOME=/u01/app/oracle/agent11g/
export LD_LIBRARY_PATH=/u01/app/oracle/agent11g/lib

PATH=$ORACLE_HOME/bin:.:$PATH;export PATH

You will also need to add the follwing so that the WLS incidents that match this regx are filtered

Edit the AGENT_HOME/sysman/config/emd.properties  file and add the following

adrAlertLogAsErrorCodeExcludeRegex=.*BEA-(101020)\D.*

To manually clear the exisiting or old alert  you need to download and apply patch 9914120

another issue you may encounter is

EMD runCollection error:
host_storage::storage_reporting_data:snmhsutl.c:executable nmhs should have root suid enabled

Refer to oracle note ID 435793.1 , you probably forgot to run root.sh  from the agent home

specific to my environment after running root.sh i still had the above issue , the problem was that the /u01 mount where  the oracle software was installed was mounted with the nosuid .

useful documents from Oracle metalink

How to Download and Apply the Recommended WLS patch on WLS for 11g grid Control Installation or Upgrade [ ID 1072763.1]

How to Install Web Logic Server for Installing 11g grid Control [ ID 1063762.1]

NOTE:1059516.1 – Step by Step Installation of Enterprise Manager Grid Control 11.1.0.1
NOTE:1063112.1 – Grid Control 11g: Example for Installing WebLogic Server 10.3.2 on OEL 5.3 x86_64
NOTE:1063587.1 – Case Study – Installing Grid Control 11.1.0.1 – Installation of jdk1.6 0n Linux x86_64 Before Installing WebLogic Server 10.3.2
NOTE:1064495.1 – Grid Control 11g: How to Install 11.1.0.1.0 on OEL5.3 x86_64 with a 11.1.0.7.0 Repository Database
NOTE:1071392.1 – How to de-install Web Logic Server (WLS) 10.3 ?
NOTE:1072763.1 – How to Download and Apply the Recommended WLS patch WDJ7 on WLS for 11g Grid Control Installation or Upgrade

Categories: Grid

Oracle Grid control 11g installation procedure

November 9, 2010 Leave a comment
Categories: Grid

Thousands of core dumps in $OMS_HOME

September 27, 2010 Leave a comment

Useful blog from martin that helped me when Oracle Grid control would not start and just core dumped filling the filesystem

http://martincarstenbach.wordpress.com/2010/05/24/thousands-of-core-dumps-in-oms_home/

Categories: Grid

OMS Startup

September 13, 2010 Leave a comment

$ORA_GRID_HOME/opmn/bin/opmnctl startall
$ORA_GRID_HOME/opmn/bin/opmnctl stopall

Categories: Grid

drop and recreate EMDATABASEControl (emca) drop and recreate for RAC DB

September 11, 2010 Leave a comment

 use emca -help you can get the parameters used to de-configure and re-configure the emca for RAC
$emca -help

-deleteInst (db | asm) [-silent] [parameters]: de-configure EM for a specified RAC instance

-reconfig dbcontrol -cluster [-silent] [parameters]: reconfigures RAC Database Control deployment

A very useful document published by oracle metalink is a must read if you have problem with dbcontrol in a rac environment. I have spends hours and days trying to fix dbcontrol until i read this document

How to manage DB Control 11.1.0.x for RAC Database with emca [ID 578011.1]

Categories: Grid

Creating a view only user in Enterprise Manager grid control

June 7, 2010 Leave a comment

If you need to give database monitoring access to some grid control users.


SQL> connect / as sysdba

SQL> create user grid_view identified by xxx

default tablespace users temporary tablespace temp;

SQL> grant create session, oem_monitor to grid_view;

1. Logon to Grid Control as a super admin user (SYSMAN or equivalent)
2. Click on the links: Setup -> Administrators -> Click on Create
3. Remove the ‘PUBLIC ROLE’ that is listed by default
4. Under Create Administrator: System Privileges select ‘VIEW ANY TARGET’.
5. Under Create Administrator: Targets, choose all the targets this new admin should be able to view
6. Under Create Administrator: Target Privileges , BATCH ASSIGN Choose ‘View’
7. Click Apply.

Login as this new administrator user you created and set grid_view as the username for the database target in preferred credentials.

Reference: metalink note 377310.1

Categories: Grid