Showing posts with label 11g. Show all posts
Showing posts with label 11g. Show all posts

Tuesday, March 19, 2013

key points of ADR, Clustware log housekeep

Due to space pressure in my test servers. I learn follow key points for various log file housekeeping in the environment having RAC, data guard, ASM instances.

1. Change default ADR retention policy.

LONGP_POLICY (long term) defaults to 365 days and relates to things like Incidents and Health Monitor warnings.
SHORTP_POLICY (short term) defaults to 30 days and relates to things like trace and core dump files.

Here are commands I used to set the retention policy.

 show control;
 set control (SHORTP_POLICY =360);
 set control (LONGP_POLICY =720);
 show control;

Note that files that are purged based on LONGP_POLICY includes the following:
-files in the alert directory
-files in the incident/incdir_ directory and metadata(in the directories metadata,ir,lck)  in the incident schema
-files in the sweep directory
-files in the stage directory
-HM — files in the hm directory and metadata in the HM schema

And files that are purged based on SHORTP_POLICY are:
-files in the trace directory
-files in the cdump directory
-files in the trace/cdmp_ directories
-files in the incpkg directory and metadata in the IPS schema

2. MMON doesn't clean ADR log files immediately, even I restarted database and wait for one day (nothing happened).

As per metalink document 975448.1 the purge happens once in 7 days.

3. The location where you issue adrci command affects homes you will see in adrci command prompt.

e.g.
orarac1poc:DG:/u01/app/oracle> cd "/u01/app/grid"
orarac1poc:DG:/u01/app/grid> adrci

ADRCI: Release 11.2.0.2.0 - Production on Tue Mar 19 14:19:32 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/app/grid"
adrci> show homes
ADR Homes:
diag/asm/+asm/+ASM1
diag/tnslsnr/orarac1poc/listener_scan1
diag/tnslsnr/orarac1poc/listener
diag/asmtool/user_grid/host_2737638882_80

In my case, I need to change default retention policy for each homes of ASM,  clustware, database (single instance, RAC and data guard).

if you go to lower level, then only one home is shown.

[grid@orarac1poc listener_scan1]$ pwd
/u01/app/grid/diag/tnslsnr/orarac1poc/listener_scan1
[grid@orarac1poc listener_scan1]$ adrci

ADRCI: Release 11.2.0.2.0 - Production on Tue Mar 19 17:38:19 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/app/grid"
adrci> show homes
ADR Homes:
diag/tnslsnr/orarac1poc/listener_scan1

4. "Oracle Clusterware logs and RDBMS logs rotation policy [ID 1368695.1]" explains clustware logs and so on. Read it again and again.

Note that some logs are not managed automatically, especially for /rdbms/audit directory. I have hundreds of thousands of *.aud files there. Therefore I use cron job to purge it  . 

find ${GRID_HOME}/rdbms/audit \( -name '*.aud' \) -mtime +15 -exec rm {} \; -prune


5. Purge command of adrci.

I notice some scripts using purge but without any argument , this purges all diagnostic data in the current ADR home based on the default purging policies:
 
 
Updates on 25-Mar.

After one week of above changes,
1. I notice old XML files in alert and trace are purged as expected.
2. But not of XML files of Grid Infrastructure, e.g SCAN Listener's log, which requires manual housekeeping.

 
/u01/app/11.2.0/grid/log/diag/tnslsnr/orarac1poc/listener_scan1/alert
[grid@orarac1poc alert]$ ls -lt
total 489044
-rw-r----- 1 grid oinstall  6972932 Mar 19 14:46 log.xml
-rw-r----- 1 grid oinstall 10485778 Mar 16 13:13 log_47.xml
-rw-r----- 1 grid oinstall 10485817 Mar 11 22:36 log_46.xml
-rw-r----- 1 grid oinstall 10485801 Mar  7 08:00 log_45.xml
...
-rw-r----- 1 grid oinstall 10485946 Dec 22  2011 log_3.xml
-rw-r----- 1 grid oinstall 10486146 Dec 22  2011 log_2.xml
-rw-r----- 1 grid oinstall 10485989 Dec 22  2011 log_1.xml

As quick solution, I use "find" command to do the job.

#purge XML listener log
find /u01/app/grid/diag/tnslsnr/orarac1poc/listener/alert \( -name 'log*.xml' \) -mtime +15 -exec rm {} \; -prune

for me, I even like to turn listener DIAG_ADR off in sqlnet.ora.
DIAG_ADR_ENABLED = OFF

Updated on 11-Apr.

After monitoring for few weeks, I found the SHORTP/LONGP POLICY doesn't work with my 11.2.0.2 env to purge ASM alert and trace sub-directories.

References:
 
 

Purging trace and dump files with 11g ADRCI

ADRCI: ADR Command Interpreter

adrci does not remove trace files from operating system

ADR files auto housekeeping

Scripts: adrci purge script, housekeeping

Thread: Check/Clear Oracle Cluster log files 

 

 

Thursday, January 24, 2013

How to corrupt a specific block

Continue to play with Amazing ABMR .

Table LIQY.T1 is the only VERY FIRST table in tablepsace USERS, and I was wrong to use dba_extents to find the block address due to rush time in evening .

SYS@DG> select file_id, file_name from dba_data_files;

   FILE_ID
----------
FILE_NAME
-------------------------------------------------------------------------------------------------------------------                      -----------------
         1
/u01/oradata/DG/system01.dbf

         2
/u01/oradata/DG/sysaux01.dbf

         3
/u01/oradata/DG/undotbs01.dbf

         4
/u01/oradata/DG/users01.dbf

         5
/u01/oradata/DG/dg1_tbs01.dbf

SYS@DG> select owner, segment_name from dba_segments where tablespace_name='USERS';

OWNER                          SEGMENT_NAME
------------------------------ ---------------------------------------------------------------------------------
LIQY                           T1


SYS@DG> select file_id, block_id from dba_extents where SEGMENT_NAME='T1';

   FILE_ID   BLOCK_ID
---------- ----------
         4        128

And I followed below command in "Active data guard hands on lab.pdf"  .

"dd if=/u01/app/oradata/SFO/example01.dbf of=/u01/app/oradata/SFO/example01.dbf count=1 bs=8192 skip=141 seek=140 conv=notrunc"

I thought  the (seek value) = (skip value)  - 1 ,  and come out  my command.
 dd if=/u01/oradata/DG/users01.dbf of=/u01/oradata/DG/users01.dbf count=1 bs=8192 skip=130 seek=129 conv=notrunc


Today, I spend some to "man dd"  and  thanks to "

Fix physically corrupt data blocks using PLSQL - DBMS_REPAIR"

which tells me to query dba_segments .

SYS@DG> select segment_name , header_file , header_block
  2  from dba_segments
  3  where segment_name = 'T1'
  4  and   owner = 'LIQY';

SEGMENT_NAME                                                                      HEADER_FILE HEADER_BLOCK
--------------------------------------------------------------------------------- ----------- ------------
T1                                                                                          4          130

Thus, I realized that :

1. I forgot that two blocks are used as data file header. So the table's header block should be 128 +2 =130. The first block of table LIQY.T1 is 131.
2. The value passed to the command in "Active data guard hands on lab.pdf"  is incorrect, reason being :

       seek=BLOCKS
              skip BLOCKS obs-sized blocks at start of output

       skip=BLOCKS
              skip BLOCKS ibs-sized blocks at start of input

so , we should skip130 blocks in input file and seek for 131st block in output file as target block.

The correct command should be :

orarac1poc:DG:/u01/oradata/DG> dd if=/u01/oradata/DG/users01.dbf of=/u01/oradata/DG/users01.dbf count=1 bs=8192 skip=130 seek=131 conv=notrunc
1+0 records in
1+0 records out
8192 bytes (8.2 kB) copied, 8.6e-05 seconds, 95.3 MB/s

With the help of active data guard and ABMR , the corrupt block is repaired transparently to front-end.



SYS@DG> alter system flush buffer_cache;

System altered.

SYS@DG> set time on
16:59:48 SYS@DG>  select * from liqy.t1;

        F1
----------
         1

16:59:55 SYS@DG> select file_id, block_id from dba_extents where SEGMENT_NAME='T1';

   FILE_ID   BLOCK_ID
---------- ----------
         4        128


Here are the corresponding alert.log .

Thu Jan 24 16:59:42 2013
ALTER SYSTEM: Flushing buffer cache

Thu Jan 24 16:59:54 2013
Hex dump of (file 4, block 131) in trace file /u01/app/oracle/diag/rdbms/dg/DG/trace/DG_ora_10205.trc
Corrupt block relative dba: 0x01000083 (file 4, block 131)
Bad header found during multiblock buffer read
Data in bad block:
 type: 35 format: 2 rdba: 0x01000082
 last change scn: 0x0000.000f3818 seq: 0x1 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x38182301
 check value in block header: 0x442e
 computed block checksum: 0x0
Reading datafile '/u01/oradata/DG/users01.dbf' for corruption at rdba: 0x01000083 (file 4, block 131)
Reread (file 4, block 131) found same corrupt data (no logical check)
Starting background process ABMR
Thu Jan 24 16:59:54 2013
ABMR started with pid=36, OS id=10244
Automatic block media recovery service is active.
Automatic block media recovery requested for (file# 4, block# 131)
Thu Jan 24 16:59:55 2013
Automatic block media recovery successful for (file# 4, block# 131)
Automatic block media recovery successful for (file# 4, block# 131)
WARNING: AutoBMR fixed mismatched on-disk block 1000082 with in-mem rdba 1000083.



Monday, June 04, 2012

DBUA complains database not in mounted state

"The Upgrade Assistant failes in bringing up the database XXX. Oracle Home /oracle/XXX/11202 obtained from file /etc/oratab was used to connect to the database. Either the database is not running from Oracle Home /oracle/XXX/11202 or the correct Initialization Parameter file (pfile) was not found" Then it asks me to locate the pfile.

My case is similar to http://scn.sap.com/thread/1938507

So cat the Welcome_.txt 

> cat  Welcome_TTTT.txt
The presence of this file indicates that the database is opened up with the new Oracle Home binaries.

/software/orattt/admin/cfgtoollogs/dbua/logs_bak> ls -lrt
total 188
-rw-r----- 1 orattt orattt    102 Oct 21  2010 Welcome_TTTT.txt
-rw-r----- 1 orattt orattt 140879 May 24 16:03 sqls.log
-rw-r----- 1 orattt orattt   2104 May 24 16:07 PreUpgradeResults.html
-rw-r----- 1 orattt orattt  20034 May 24 16:07 trace.log

That is the culprit.

After I rename the directory, everything goes smoothly.

Monday, October 24, 2011

db_block_checking overhead.

11g中的db_block_checking参数 | Oracle Clinic – 提供专业Oracle技术支持,性能调整及数据恢复服务

Furthermore, if there are few indexes, I believe more overhead needed.

I do have data loading performance issues in data warehouse, after enable  DB_ULTRA_SAFE = DATA_AND_INDEX


Friday, September 09, 2011

10g and 11g Statistics Tables Created by the DBMS_STATS Package

REM in 10g database

SYS> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for HPUX: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

EXEC DBMS_STATS.CREATE_STAT_TABLE(ownname=>'PERFSTAT',stattab => 'T1_STATTAB');

SQL> DESC DBO.T1_STATTAB
 Name                                          Null?    Type
 ----------------------------------------- -------- ----------------------------
 STATID                                             VARCHAR2(30)
 TYPE                                               CHAR(1)
 VERSION                                            NUMBER
 FLAGS                                              NUMBER
 C1                                                 VARCHAR2(30)
 C2                                                 VARCHAR2(30)
 C3                                                 VARCHAR2(30)
 C4                                                 VARCHAR2(30)
 C5                                                 VARCHAR2(30)
 N1                                                 NUMBER
 N2                                                 NUMBER
 N3                                                 NUMBER
 N4                                                 NUMBER
 N5                                                 NUMBER
 N6                                                 NUMBER
 N7                                                 NUMBER
 N8                                                 NUMBER
 N9                                                 NUMBER
 N10                                                NUMBER
 N11                                                NUMBER
 N12                                                NUMBER
 D1                                                 DATE
 R1                                                 RAW(32)
 R2                                                 RAW(32)
 CH1                                                VARCHAR2(1000)


REM in 11g

SYS> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for HPUX: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL> DESC PERFSTAT.T1_STATTAB
 Name                                    Null?    Type
 ----------------------------------------- -------- ----------------------------
 STATID                                             VARCHAR2(30)
 TYPE                                               CHAR(1)
 VERSION                                            NUMBER
 FLAGS                                              NUMBER
 C1                                                 VARCHAR2(30)
 C2                                                 VARCHAR2(30)
 C3                                                 VARCHAR2(30)
 C4                                                 VARCHAR2(30)
 C5                                                 VARCHAR2(30)
 N1                                                 NUMBER
 N2                                                 NUMBER
 N3                                                 NUMBER
 N4                                                 NUMBER
 N5                                                 NUMBER
 N6                                                 NUMBER
 N7                                                 NUMBER
 N8                                                 NUMBER
 N9                                                 NUMBER
 N10                                                NUMBER
 N11                                                NUMBER
 N12                                                NUMBER
 D1                                                 DATE
 R1                                                 RAW(32)
 R2                                                 RAW(32)
 CH1                                                VARCHAR2(1000)
 CL1                                                CLOB


IN Step 33 of manual upgrade checklist to 11gR2.

Upgrade Statistics Tables Created by the DBMS_STATS Package
If you created statistics tables using the DBMS_STATS.CREATE_STAT_TABLE procedure, then upgrade these tables by executing the
following procedure:

EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('PERFSTAT','T1_STATTAB');


Thursday, May 26, 2011

11gR2 AWR runs slowly due to unrealistic system statistics

After database upgraded from 10.2.0.2 to 11.2.0.2, found AWR runs slower than 10g, the more snapshots covered the longer it takes.

Struggled for days, finally notice below system statistics in read is nor realistic to seem.
SYSP> select * from aux_stats$;

SNAME                          PNAME                               PVAL1
------------------------------ ------------------------------ ----------
PVAL2
------------------------------------------------------------------------------------------------------------------------------------
SYSSTATS_INFO                  STATUS
COMPLETED

SYSSTATS_INFO                  DSTART
02-23-2011 09:05

SYSSTATS_INFO                  DSTOP
02-23-2011 09:31

SYSSTATS_INFO                  FLAGS                                   1


SYSSTATS_MAIN                  CPUSPEEDNW                     1400.84388


SYSSTATS_MAIN                  IOSEEKTIM                              10


SYSSTATS_MAIN                  IOTFRSPEED                           4096


SYSSTATS_MAIN                  SREADTIM                         28231.75


SYSSTATS_MAIN                  MREADTIM                        24989.114


SYSSTATS_MAIN                  CPUSPEED                             1170


SYSSTATS_MAIN                  MBRC                                    6


SYSSTATS_MAIN                  MAXTHR                           96043008


SYSSTATS_MAIN                  SLAVETHR                          3421184



13 rows selected.

actions:
1.) backup system statistics and delete it. Run AWR report promptly .

SYS@ODSP> select * from aux_stats$;

SNAME                          PNAME                               PVAL1
------------------------------ ------------------------------ ----------
PVAL2
------------------------------------------------------------------------------
SYSSTATS_INFO                  STATUS
COMPLETED
SYSSTATS_INFO                  DSTART
05-26-2011 14:39
SYSSTATS_INFO                  DSTOP
05-26-2011 14:39
SYSSTATS_INFO                  FLAGS                                   0

SYSSTATS_MAIN                  CPUSPEEDNW                           1151

SYSSTATS_MAIN                  IOSEEKTIM                              10

SYSSTATS_MAIN                  IOTFRSPEED                           4096

SYSSTATS_MAIN                  SREADTIM

SYSSTATS_MAIN                  MREADTIM

SYSSTATS_MAIN                  CPUSPEED

SYSSTATS_MAIN                  MBRC

SYSSTATS_MAIN                  MAXTHR

SYSSTATS_MAIN                  SLAVETHR


13 rows selected.
2.) Gather NOWORKLOAD system statistics. Run report okay.
select * from aux_stats$;

SNAME                          PNAME                               PVAL1
------------------------------ ------------------------------ ----------
PVAL2
------------------------------------------------------------------------------
SYSSTATS_INFO                  STATUS
COMPLETED
SYSSTATS_INFO                  DSTART
05-26-2011 14:46
SYSSTATS_INFO                  DSTOP
05-26-2011 14:46
SYSSTATS_INFO                  FLAGS                                   1

SYSSTATS_MAIN                  CPUSPEEDNW                           1152

SYSSTATS_MAIN                  IOSEEKTIM                               6

SYSSTATS_MAIN                  IOTFRSPEED                          34397

SYSSTATS_MAIN                  SREADTIM

SYSSTATS_MAIN                  MREADTIM

SYSSTATS_MAIN                  CPUSPEED

SYSSTATS_MAIN                  MBRC

SYSSTATS_MAIN                  MAXTHR

SYSSTATS_MAIN                  SLAVETHR


13 rows selected.

Finally from http://structureddata.org/2008/01/02/what-are-your-system-statistics/ , I realized it is a bug.   Bug 9842771  Wrong SREADTIM and MREADTIM statistics in AUX_STATS$

The workaround is to manually set SYSTEM statistics or NOWORKLOAD system statistics.

Lesson learned again : understand what exactly you are going to do in depth. BTW, since this is a known bug, I think the complete checklist of upgrade guide should be updated.

Here are more informations about system statistics.

1. When Oracle gathers system statistics, it analyzes system activity in a specified time period (workload statistics) or simulates a workload (noworkload statistics). The statistics are collected using the DBMS_STATS.GATHER_SYSTEM_STATS procedure. Oracle Corporation highly recommends that you gather system statistics.

gathering_mode
   

Mode values are:

NOWORKLOAD: Will capture characteristics of the I/O system. Gathering may take a few minutes and depends on the size of the database. During this period Oracle will estimate the average read seek time and transfer speed for the I/O system. This mode is suitable for the all workloads. Oracle recommends to run GATHER_SYSTEM_STATS ('noworkload') after creation of the database and tablespaces. To fine tune system statistics for the workload use 'START' and 'STOP' or 'INTERVAL' options. If you gather both 'NOWORKLOAD' and workload specific (statistics collected using 'INTERVAL' or 'START' and 'STOP' ), the workload statistics will be used by optimizer. Collected components: cpuspeednw, ioseektim, iotfrspeed.

INTERVAL: Captures system activity during a specified interval. This works in combination with the interval parameter. You should provide an interval value in minutes, after which system statistics are created or updated in the dictionary or stattab. You can use GATHER_SYSTEM_STATS (gathering_mode=>'STOP') to stop gathering earlier than scheduled. Collected components: maxthr, slavethr, cpuspeed, sreadtim, mreadtim, mbrc.

START | STOP: Captures system activity during specified start and stop times and refreshes the dictionary or stattab with statistics for the elapsed period. Interval value is ignored. Collected components: maxthr, slavethr, cpuspeed, sreadtim, mreadtim, mbrc.

 -- In this case, I use START|STOP  to sample my database for 30 minutes during normal workload .


3. specs and units
CPUSPEED     Workload CPU speed in millions of cycles/second
CPUSPEEDNW     Noworkload CPU speed in millions of cycles/second
IOSEEKTIM     Seek time + latency time + operating system overhead time in milliseconds
IOTFRSPEED     Rate of a single read request in bytes/millisecond
MAXTHR     Maximum throughput that the I/O subsystem can deliver in bytes/second
MBRC     Average multiblock read count sequentially in blocks
MREADTIM     Average time for a multi-block read request in milliseconds
SLAVETHR     Average parallel slave I/O throughput in bytes/second
SREADTIM     Average time for a single-block read request in milliseconds

Thursday, April 28, 2011

How much more memory is needed by 11gR2 DBConsole

When assessing database upgrade, we'll need to know actual overhead need for newer version, which may not be found from Oracle document, or accurate enough for our own environment.  e.g, in order to run 11gR2 database, my finding for development is 500Mb and production is 800Mb. The 300Mb (if I remember correctly) in oracle document may easily lead to ORA-4031.

Today did the experiment on four DBConsoles , comparing 10.2.0.2 and 11.2.0.2.
The following shows the figure of Total Memory (VM) and Residential Memory(User memory) using HP-UX 11i IA v3 glance utility,  when I shutdown 4 DBConsoles one by one.


shutdown
10g dbconsole
init 1 Console 2 Consoles 3 Consoles 4 Consoles Average
Total VM(Gb) 22.5 21.8 21.3 20.7 20 0.625
user memory
(Gb)
10.6 10.4 10.2 10 9.7 0.225







shutdown
11g dbconsole
init 1 Console 2 Consoles 3 Consoles 4 Consoles Average
Total VM(Gb) 27.8 26 24.2 22.5 20.6 1.8
user memory
(Gb)
16.4 15.9 15.3 14.8 14.3 0.525
 

From above tables, it is clear that 11.2.0.2 DBConsole is almost 3 times than that in 10.2.0.2 , both total memory and physical memory.

For those doing capacity planning, please don't take for granted and overlook harware requirement by different version.

Friday, December 10, 2010

Upgrade 1st Production database to 11.2.0.2

Finally, I made it , from 10.2.0.4 to 11.2.0.2 for data warehouse database.

Only one minor performance issue encountered, which is within control.

-- Provide workaround to application , before log TAR to metalink. 

Cheers!  One more to upgrade Jan.

Monday, October 25, 2010

changes/bugs may fail your 11g upgrade

For OLAP type databases or running  complicated batch jobs.
1. here are two bugs 8477973 and 4926618

8477973 Multiple open DB links / ORA-2020 / distributed deadlock possible 

Impact: hang your sql session

4926618 Excessive CPU on HASH UNIQUE when repeated

Good news, both of them are fixed in 11.2.0.2

Impact: x times slower your UPDATE statement.  Especially updating more than 1 million rows. The more rows more greater times.  In my case, 21 minutes becomes  8 hours .



2. new parameter db_ultra_safe:  DATA_AND_INDEX comes with significant overhead. For my INSERT case, it is 7x slower.


Spent weeks of effort to come to above findings.  Hope it help preventing from happening to you . Cheers!

Monday, June 28, 2010

sample code for load top AWR sql into sql plan baseline

--in this example we load top 30 sql inside AWR snapshot 710 to 714 , into sql tuning set , followed by loaded and create as sql plan baseline.

EXEC DBMS_SQLTUNE.DROP_SQLSET('tset1');
EXEC DBMS_SQLTUNE.CREATE_SQLSET('tset1');

DECLARE
 baseline_cursor DBMS_SQLTUNE.SQLSET_CURSOR;
 my_plans PLS_INTEGER;
BEGIN
 OPEN baseline_cursor FOR
    SELECT VALUE(p)
    FROM TABLE (DBMS_SQLTUNE.SELECT_WORKLOAD_REPOSITORY(
                  710,714,
                   NULL, NULL,
                   'elapsed_time',
                   NULL, NULL, NULL,
                   30)) p;

    DBMS_SQLTUNE.LOAD_SQLSET(
             sqlset_name     => 'tset1',
             populate_cursor => baseline_cursor);
    my_plans := DBMS_SPM.LOAD_PLANS_FROM_SQLSET( sqlset_name => 'tset1');
END;
/

Sunday, April 18, 2010

11g sqlplus doesn't hide password

Prior to 10g Oracle database, anyone can see the database account password using 'ps -ef |grep sqlplus ' , if  it is hard coded on same command line with sqlplus, e.g sqlplus  username/password@DBNAME

In 10g , Oracle "solved" this problem ,.

However, it comes back again in 11g. Searched metalink, no more document says password will be removed. :(

Too bad.  Lucky, we have alternative way.

> ps -ef |grep sqlplus
oravas11  4997  4748  0 13:41:31 pts/0     0:00 ied sqlplus perfstat/xxxxxxxx@VAS11GP
oravas11  4998  4997  0 13:41:31 ttyp1     0:00 sqlplus perfstat/xxxxxxxx@VAS11GP

Sunday, January 10, 2010

OUI abort during 11g Release 2 installation

SEVERE: [FATAL] An internal error occurred within cluster verification framework
Unable to get the current group.

The relevant platform is HPUX Itanium v3.

After revisit installation guide, installed required Unix patches and adjust kernel parameters. Problem solved.

Sunday, July 12, 2009

Error uploading configuration data to the repository

[ERROR MESSAGE]

Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocked mgmt_view account
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked mgmt_view account
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: OCP11G, oracleHome: /apps/oracle/product/11.2.0, and user: SYS
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Jul 11, 2009 9:33:40 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: Passed listener validation check.Listener is up and running.
Jul 11, 2009 9:33:40 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Jul 11, 2009 9:33:40 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
CONFIG: Error uploading configuration data to the repository
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:674)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:370)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /apps/oracle/cfgtoollogs/emca/OCP11G/emca_repos_config_.log for more details.
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error uploading configuration data to the repository
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error uploading configuration data to the repository
Refer to the log file at /apps/oracle/cfgtoollogs/emca/OCP11G/emca_2009_07_11_21_27_18.log for more details.
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:382)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)



[ROOT CAUSE]
try some solution from internet, related to password file, listener, ORACLE_HOSTNAME.

recalled recent there is block error & fixed duing Linux booting , which are related to 11.1.0.7 ORACLE_HOME.

[SOLUTION]
1. reinstall the oracle software
2. copy old PFILE, password file and listener.ora &tnsnames.ora
3.emca -deconfig dbcontrol db -repos drop
4. emca -config dbcontrol db -repos create
cheers, see the follow messages

INFO: >>>>>>>>>>> The Database Control URL is https://localhost:1158/em <<<<<<<<<<<
Jul 12, 2009 2:27:16 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /apps/oracle/product/11.1.0/localhost_OCP11G/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 12, 2009 2:27:16 PM
You have new mail in /var/spool/mail/oracle