Creation Zone

Saturday, 8 September 2007

Memory fragmentation / Large Pages on Solaris x86

Posted on 00:40 by Unknown

First, the symptom.

On Solaris x86 systems that support large pages (any page size > 4K), the processes may get 2M pages when the system is up for few hours, but may not obtain even a single large page (2M) when the system is up for few days.

Now, the explanation.

Memory fragmentation is the main reason for the above mentioned behavior on Solaris x86 platform. On Solaris x86, once memory has been fragmented, it is very rare that a large page can be put back together. This is a limitation of Solaris on x86. It takes 512 base pages (4K in size) that are aligned and physically contiguous to form a common large page (2M on x86). If a kernel allocation occurs within this region, it is typically not possible to ever form this large page again as kernel pages cannot be relocated.

Solaris/SPARC has the kernel cage to help memory from being fragmented with kernel allocations. However as of now kernel cage isn't fully implemented in Solaris/x86. That is the main reason for the non availability of large (2M) pages on Solaris x86 when the system is up for longer durations. The good news is that Sun Microsystems is actively working on a solution to address this issue.

Acknowledgments:
Kit Chow
_______________
Technorati tags:

Solaris |

OpenSolaris |

Performance

Posted in | No comments

Wednesday, 5 September 2007

Linux: Steps for installing GRUB as the Boot Loader

Posted on 19:55 by Unknown

For some reason if the Master Boot Record (MBR) is overwritten or corrupted, here is a simple HOW-To to install GRUB (GRand Unified Boot loader) as the boot loader with Ubuntu being the host operating system.

Boot up Linux using Ubuntu Live CD

Run grub with system user privileges

% sudo grub
Password:

Probing devices to guess BIOS drives. This may take a long time.

Locate the grub files on the connected devices.
```
grub> find /boot/grub/stage1
 (hd0,0)
```
Even though the above example shows only one location, it is not uncommon for grub to find multiple locations when multiple operating systems are installed on a system. In that case, choose the one that corresponds to the partition where Linux is installed.
```
grub> root (hd0,0)
```

Finally install the grub boot loader on the primary HDD by running 'setup'.

grub> setup (hd0)
 Checking if "/boot/grub/stage1" exists... yes
 Checking if "/boot/grub/stage2" exists... yes
 Checking if "/boot/grub/e2fs_stage1_5" exists... yes
 Running "embed /boot/grub/e2fs_stage1_5 (hd0)"...  17 sectors are embedded.
succeeded
 Running "install /boot/grub/stage1 (hd0) (hd0)1+17 p (hd0,0)/boot/grub/stage2
/boot/grub/menu.lst"... succeeded
Done.

After restarting the system, GRUB menu should appear during the system startup.
__________________
Technorati tags:

Linux |

Ubuntu |

GRUB

Posted in | No comments

Friday, 24 August 2007

Sandhya Vandanam in Telugu Script

Posted on 01:32 by Unknown

Sandhya Vandanamu [File format: PDF. File size: 3.1 MB]

Courtesy/Publisher: Gollapudi Veera Swamy Son, Rajahmundry

Related:
Hanuman Chalisa {Telugu Script}

______________
Technorati Tags:
Telugu | Devotion

Posted in | No comments

Thursday, 23 August 2007

Cricket Flash Game

Posted on 21:32 by Unknown

The following is a little flash game for all those cricket buffs who like to hit 6s and 4s almost every ball.

Play the Game

Simply use the arrow keys of the keyboard or use the mouse buttons to hit the ball.

Courtesy: npower

_______________
Technorati Tag:

Cricket |

Flash Game

Posted in | No comments

Friday, 10 August 2007

Oracle 10gR2/Solaris x64: Must Have Patches for E-Business Suite 11.5.10

Posted on 22:04 by Unknown

If you have an Oracle E-Business Suite 11.5.10 database running on Oracle 10gR2 (10.2.0.2) / Solaris x86-64 platform, make sure you have the following two Oracle patches to avoid concurrency issues and intermittent Oracle shadow process crashes.

Oracle patches

1) 4770693 BUG: Intel Solaris: Unnecessary latch sleeps by default
2) 5666714 BUG: ORA-7445 ON DELETE

Symptoms

1) If the top 5 database timed events look something similar to the following in AWR, it is very likely that the database is running into the bug 4770693 Intel Solaris: Unnecessary latch sleeps by default.

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
latch: cache buffers chains	94,301	169,403	1,796	86.1	Concurrency
CPU time		5,478		2.8
wait list latch free	247,466	4,756	19	2.4	Other
buffer busy waits	14,928	1,382	93	.7	Concurrency
db file sequential read	98,750	552	6	.3	User I/O

Apply Oracle server patch 4770693 to get rid of the concurrency issue(s). Note that the fix will be part of 10.2.0.3.

2) If the application becomes unstable and if you notice core dumps in cdump directory, have a look at the corresponding stack traces generated in udump directory. If the call stack looks similar to the following stack, apply Oracle server patch 5666714 to overcome this problem.

Alert log will have the following errors:


Errors in file /opt/oracle/admin/VIS/udump/vis_ora_1040.trc:
ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [2168] [] [] []
Fri Jun 15 01:30:38 2007
Errors in file /opt/oracle/admin/VIS/udump/vis_ora_1040.trc:
ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [9] [] [] []
ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [2168] [] [] []
Fri Jun 15 01:30:38 2007
Errors in file /opt/oracle/admin/VIS/udump/vis_ora_1040.trc:
ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [9] [] [] []
ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [9] [] [] []
ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [2168] [] [] [] 

% more vis_ora_1040.trc
...
...
*** 2007-06-15 01:30:38.403
*** SERVICE NAME:(VIS) 2007-06-15 01:30:38.402
*** SESSION ID:(1111.4) 2007-06-15 01:30:38.402
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x878
*** 2007-06-15 01:30:38.403
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [2168] [] [] []
Current SQL statement for this session:
INSERT /*+ IDX(0) */ INTO "INV"."MLOG$_MTL_SUPPLY" (dmltype$$,old_new$$,snaptime$$,change_vector$$,m_row$$) VALUES (:d,:o,to_
date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),:c,:m)
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
ksedst()+23          ?        0000000000000001     00177A9EC 000000000 0061D0A60
                                                   000000000
ksedmp()+636         ?        0000000000000001     001779481 000000000 00000000B
                                                   000000000
ssexhd()+729         ?        0000000000000001     000E753CE 000000000 0061D0B90
                                                   000000000
_sigsetjmp()+25      ?        0000000000000001     0FDDCB7E6 0FFFFFD7F 0061D0B50
                                                   000000000
call_user_handler()  ?        0000000000000001     0FDDC0BA2 0FFFFFD7F 0061D0EF0
+589                                               000000000
sigacthandler()+163  ?        0000000000000001     0FDDC0D88 0FFFFFD7F 000000002
                                                   000000000
kglsim_pin_simhp()+  ?        0000000000000001     0FFFFFFFF 0FFFFFFFF 00000000B
173                                                000000000
kxsGetRuntimeLock()  ?        0000000000000001     001EBF830 000000000 005E5D868
+683                                               000000000
kksfbc()+7361        ?        0000000000000001     001FB60A6 000000000 005E5D868
                                                   000000000
opiexe()+1691        ?        0000000000000001     0029045D0 000000000 0FFDF9250
                                                   0FFFFFD7F
opiall0()+1316       ?        0000000000000001     0028E9FB9 000000000 000000001
                                                   000000000
opikpr()+536         ?        0000000000000001     00290B2DD 000000000 0000000B7
                                                   000000000
opiodr()+1087        ?        0000000000000001     000E7BE1C 000000000 000000001
                                                   000000000
rpidrus()+217        ?        0000000000000001     000E8058E 000000000 0FFDFA6B8
                                                   0FFFFFD7F
skgmstack()+163      ?        0000000000000001     003F611D0 000000000 005E5D868
                                                   000000000
rpidru()+129         ?        0000000000000001     000E808A6 000000000 005E6FAD0
                                                   000000000
rpiswu2()+431        ?        0000000000000001     000E7FD8C 000000000 0FFDFB278
                                                   0FFFFFD7F
kprball()+1189       ?        0000000000000001     000E86E6A 000000000 0FFDFB278
                                                   0FFFFFD7F
kntxslt()+3150       ?        0000000000000001     0030601F3 000000000 005F7C538
                                                   000000000
kntxit()+998         ?        0000000000000001     003058EBB 000000000 005F7C538
                                                   000000000
0000000001E4866E     ?        0000000000000001     001E4864B 000000000 000000000
                                                   000000000
delrow()+9170        ?        0000000000000001     0032020B7 000000000 000000002
                                                   000000000
qerdlFetch()+640     ?        0000000000000001     0033545F5 000000000 0EF38B020
                                                   000000003
delexe()+909         ?        0000000000000001     0032034EA 000000000 005E6FC50
                                                   000000000
opiexe()+9267        ?        0000000000000001     002906368 000000000 000000001
                                                   000000000
opiodr()+1087        ?        0000000000000001     000E7BE1C 000000000 0FFDFCD10
                                                   0FFFFFD7F
ttcpip()+1168        ?        0000000000000001     003D031AD 000000000 0FFDFEDF4
                                                   0FFFFFD7F
opitsk()+1212        ?        0000000000000001     000E77C41 000000000 000E7BA00
                                                   000000000
opiino()+931         ?        0000000000000001     000E7B0D8 000000000 005E5B8F0
                                                   000000000
opiodr()+1087        ?        0000000000000001     000E7BE1C 000000000 000000000
                                                   000000000
opidrv()+748         ?        0000000000000001     000E76A11 000000000 0FFDFF6D8
                                                   0FFFFFD7F
sou2o()+86           ?        0000000000000001     000E73E6B 000000000 000000000
                                                   000000000
opimai_real()+127    ?        0000000000000001     000E3A7C4 000000000 000000000
                                                   000000000
main()+95            ?        0000000000000001     000E3A694 000000000 000000000
                                                   000000000
0000000000E3A4D7     ?        0000000000000001     000E3A4DC 000000000 000000000
                                                   000000000
 
--------------------- Binary Stack Dump ---------------------
 
========== FRAME [1] (ksedst()+23 -> 0000000000000001) ==========
Dump of memory from 0x00000000061D0910 to 0x00000000061D0920
0061D0910 061D0920 00000000 0177A9EC 00000000  [ .........w.....]
========== FRAME [2] (ksedmp()+636 -> 0000000000000001) ==========
Dump of memory from 0x00000000061D0920 to 0x00000000061D0A60
0061D0920 061D0A60 00000000 01779481 00000000  [`.........w.....]
0061D0930 0000000B 00000000 061D0EF0 00000000  [................]
0061D0940 05E5B96C 00000000 05E5C930 00000000  [l.......0.......]
0061D0950 05E5C930 00000000 FE0D2000 FFFFFD7F  [0........ ......]
0061D0960 061D0A40 00000000 00000000 00000000  [@...............]
0061D0970 00000000 00000000 00000000 00000000  [................]
...
...

After installing the Oracle database patches, check the installed patches by running opatch lsinventory on your database server.

% opatch lsinventory
Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation.  All rights reserved..


Oracle Home       : /oracle/product/10.1.0
Central Inventory : /export/home/oracle/oraInventory
   from           : /oracle/product/10.1.0/oraInst.loc
OPatch version    : 10.2.0.1.0
OUI version       : 10.2.0.1.0
OUI location      : /oracle/product/10.1.0/oui
Log file location : /oracle/product/10.1.0/cfgtoollogs/opatch/opatch-2007_Aug_10_21-56-03-PDT_Fri.log

Lsinventory Output file location : /oracle/product/10.1.0/cfgtoollogs/opatch/lsinv/lsinventory-2007_Aug_10_21-56-03-PDT_Fri.txt

--------------------------------------------------------------------------------
Installed Top-level Products (3): 

Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Products                                         10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 1                            10.2.0.2.0
There are 3 products installed in this Oracle Home.


Interim patches (2) :

Patch  4770693      : applied on Thu Aug 02 15:27:23 PDT 2007
   Created on 12 Jul 2006, 11:52:39 hrs US/Pacific
   Bugs fixed:
     4770693

Patch  5666714      : applied on Fri Jul 20 10:21:33 PDT 2007
   Created on 29 Nov 2006, 04:52:58 hrs US/Pacific
   Bugs fixed:
     5666714

--------------------------------------------------------------------------------

OPatch succeeded.

_______________
Technorati Tags:

Oracle |

Database |

E-Business Suite |

Oracle Applications |

Solaris

Posted in | No comments

Wednesday, 13 June 2007

Oracle 10gR2/Solaris x64: Fixing ORA-20000: Oracle Text errors

Posted on 22:17 by Unknown

First, some facts:

* Oracle Applications 11.5.10 (aka E-Business Suite 11i) database is now supported on Solaris 10 for x86-64 architecture.

* The database must be at least Oracle 10g Release 2 (10gR2)

* KOREAN_LEXER lexer type has been discontinued with the Oracle 10gR2 release.

Scenario:

Customer X is trying to migrate the Oracle Apps 11i database instance from Oracle 10gR1/Solaris SPARC to Oracle 10gR2/Solaris x64. During the data import process, creation of some of the text indexes fail with the following error message:

ORA-20000: Oracle Text error:
DRG-10502: index  does not exist
DRG-13201: KOREAN_LEXER is desupported

Ignoring the above error message may lead to some dysfunctional modules. For example, creating a new service request (SR) fail with errors like:

ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE in Package
   CS_ServiceRequest_PVT Procedure Create_ServiceRequest

The following query confirms that the issue is indeed with failed indexes.

% sqlplus / as sysdba

SQL> Select INDEX_NAME, TABLE_NAME, DOMIDX_STATUS, DOMIDX_OPSTATUS
2  from ALL_INDEXES where TABLE_NAME like 'CS%INCIDENTS%ALL%' and INDEX_TYPE='DOMAIN';

INDEX_NAME                          TABLE_NAME                     DOMIDX_STATUS     DOMIDX_OPSTATUS
----------------------------------- ------------------------------ ----------------- -----------------
SUMMARY_CTX_INDEX                   CS_INCIDENTS_ALL_TL            VALID             FAILED
CS_INCIDENTS_ALL_TL_N1              CS_INCIDENTS_ALL_TL            VALID             FAILED

Refer to Oracle Metalink Note 306854.1 Create Service Request: Ora-29861: Domain Index Is Marked Loading/Failed/Unusable for more.

Similarly searching for a Catalog item under Sales & Marketing module fails with error message similar to:

ORA-20000: Oracle Text error: DRG-10599: column is not indexed
java.sql.SQLException: ORA-20000: Oracle Text error: DRG-10599: column is not indexed at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at 
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at 
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589) at 
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972) at 
oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1231) at 
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2607) at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2950) at 
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656) at 
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:582) at
...
...

How to fix the above ORA-20000: Oracle Text errors?

Steps:

1. Execute the SQL script which was posted in Oracle Metalink Note 187905.1 bde_imt_index_status.sql - List all interMedia Text indexes by owner, to check the status of the Text indexes.

For your convenience, I'm reproducing the script here:

% cat textindexes.sql

ttitle - 
  center  'iMT Index Summary by Owner' skip 2 
set pagesize 67
set linesize 95
column idx_owner heading 'Owner' format a8
column idx_name heading 'Index|Name' format a24;
column idx_table heading 'Table|Indexed' format a22
column idx_text_name heading 'Column|Indexed' format a21
column idx_docid_count heading 'Number|Rows|Indexed' format 99999
column idx_status heading 'Index|Status' format a8

break on idx_owner

spool bde_imt_index_status.lst

select idx_owner,idx_name,idx_table,idx_text_name,idx_docid_count,idx_status
 from ctx_indexes
group by idx_owner,idx_name,idx_table,idx_text_name,idx_docid_count,idx_status
/

spool off;

Here's the sample output from a Oracle 10gR2/Solaris x64 system right after the data was imported with index errors:

% sqlplus ctxsys/ctxsys

SQL> @textindexes.sql

                                   iMT Index Summary by Owner                                  
                                                                                               
                                                                                Number         
         Index                    Table                  Column                   Rows Index   
Owner    Name                     Indexed                Indexed               Indexed Status  
-------- ------------------------ ---------------------- --------------------- ------- --------
PA       PA_PROJECT_CTX_SEARCH_C1 PA_PROJECT_CTX_SEARCH  CTX_DESCRIPTION           159 INDEXED 
HR       IRC_SEARCH_CRITERIA_CTX  IRC_SEARCH_CRITERIA    KEYWORDS                    0 INDEXED 
JTF      JTF_TASKS_TL_IM          JTF_TASKS_TL           TASK_NAME                4183 INDEXED 
         JTF_AMV_ITEMS_NAME_CTX   JTF_AMV_ITEMS_TL       ITEM_NAME                1394 INDEXED 
CS       CS_FORUM_MESSAGES_TL_N4  CS_FORUM_MESSAGES_TL   COMPOSITE_ASSOC_COL         0 POPULATE 
         CS_KB_SETS_TL_N3         CS_KB_SETS_TL          COMPOSITE_ASSOC_INDEX       0 POPULATE 
JTF      JTF_AMV_ITEMS_DESC_CTX   JTF_AMV_ITEMS_TL       DESCRIPTION              1394 INDEXED 
HR       PER_EMPDIR_PEOPLE_N1     PER_EMPDIR_PEOPLE      PERSON_KEY               3258 INDEXED 
CTXTEST  QUICK_TEXT               QUICK                  TEXT                        0 NO_INDEX
HR       PER_ADDRESSES_N4         PER_ADDRESSES          DERIVED_LOCALE              0 INDEXED 
CS       SUMMARY_CTX_INDEX        CS_INCIDENTS_ALL_TL    SUMMARY                     0 POPULATE 
JTF      JTF_AMV_ITEMS_URL_CTX    JTF_AMV_ITEMS_B        URL_STRING                  0 INDEXED 
         JTF_AMV_ITEMS_TEXT_CTX   JTF_AMV_ITEMS_TL       TEXT_STRING              1394 INDEXED 
ENI      ENI_DEN_HRCHY_PAR_IM1    ENI_DENORM_HRCHY_PAREN CONCAT_CAT_PARENTAGE      143 INDEXED 
                                  TS                                                           
                                                                                               
OKC      OKC_ARTICLES_CTX         OKC_ARTICLE_VERSIONS   ARTICLE_TEXT              919 INDEXED 
AR       HZ_CUST_ACCT_SITES_ALL_T HZ_CUST_ACCT_SITES_ALL ADDRESS_TEXT                0 INDEXED 
         1                                                                                     
                                                                                               
HR       IRC_DOCUMENTS_CTX        IRC_DOCUMENTS          BINARY_DOC                 13 INDEXED 
AR       HZ_STAGE_CONTACT_T1      HZ_STAGED_CONTACTS     CONCAT_COL             ###### INDEXED 
CS       CS_KB_SOLN_CAT_TL_N1     CS_KB_SOLN_CATEGORIES_ NAME                        0 POPULATE 
                                  TL                                                           
                                                                                               
HR       IRC_POSTING_CON_TL_CTX   IRC_POSTING_CONTENTS_T NAME                       40 INDEXED 
                                  L                                                            
                                                                                               
ICX      ICX_CAT_ITEMS_CTX_DESC   ICX_CAT_ITEMS_TLP      CTX_DESC               ###### INDEXED 
IBC      IBC_ATTRIBUTE_BUNDLES_CT IBC_ATTRIBUTE_BUNDLES  ATTRIBUTE_BUNDLE_DATA     224 INDEXED 
         X                                                                                     
                                                                                               
AMV      AMV_C_CHANNELS_NAME_CTX  AMV_C_CHANNELS_TL      CHANNEL_NAME               56 INDEXED 
ICX      ICX_QUES_CTX             ICX_QUESTIONS_TL       QUESTION                 1279 INDEXED 
APPS     IBE_CT_IMEDIA_SEARCH_IM  IBE_CT_IMEDIA_SEARCH   INDEXED_SEARCH              0 POPULATE
CTXSYS   DEFAULT_POLICY_ORACONTAI DR$POLICY_TAB          PLT_POLICY                  0 NO_INDEX
         NS                                                                                    
                                                                                               
SYSTEM   QUICK_TEXT               QUICK                  TEXT                        2 INDEXING
HR       HR_LOCATIONS_N1          HR_LOCATIONS_ALL       DERIVED_LOCALE              0 INDEXED 
         IRC_DOCUMENTS_CTX1       IRC_DOCUMENTS          CHARACTER_DOC              13 INDEXED 
AR       HZ_STAGE_PARTIES_T1      HZ_STAGED_PARTIES      CONCAT_COL             ###### INDEXED 
CS       CS_KB_ELEMENTS_TL_N2     CS_KB_ELEMENTS_TL      COMPOSITE_TEXT_INDEX        0 POPULATE 
OKR      OKR_IPS_TL_N1            OKR_IP_COMMON_TL       KEYWORD_TEXT                7 INDEXED 
OKC      OKC_TERMS_TEMPLATES_CTX  OKC_TERMS_TEMPLATES_AL TEMPLATE_NAME              70 INDEXED 
                                  L                                                            
                                                                                               
APPLSYS  FND_LOBS_CTX             FND_LOBS               FILE_DATA                   0  POPULATE 
AR       HZ_CLASS_CODE_DENORM_T1  HZ_CLASS_CODE_DENORM   CONCAT_CLASS_CODE_MEA    8154 INDEXED 
                                                         NING                                  
                                                                                               
AMV      AMV_C_CHANNELS_DESC_CTX  AMV_C_CHANNELS_TL      DESCRIPTION                56 INDEXED 
CS       CS_INCIDENTS_ALL_TL_N1   CS_INCIDENTS_ALL_TL    TEXT_INDEX                  0 POPULATE
AR       HZ_STAGE_PARTY_SITES_T1  HZ_STAGED_PARTY_SITES  CONCAT_COL             ###### INDEXED 
         HZ_STAGE_CPT_T1          HZ_STAGED_CONTACT_POIN CONCAT_COL             ###### INDEXED 
                                  TS                                                                                                                                                         

39 rows selected.

2. Note down the index names whose status is not 'INDEXED'.

From the output in step #1, the following are the offensive indexes.

APPLSYS.FND_LOBS_CTX
APPS.IBE_CT_IMEDIA_SEARCH_IM
CS.CS_FORUM_MESSAGES_TL_N4
CS.CS_INCIDENTS_ALL_TL_N1
CS.CS_KB_ELEMENTS_TL_N2
CS.CS_KB_SETS_TL_N3
CS.CS_KB_SOLN_CAT_TL_N1
CS.SUMMARY_CTX_INDEX

3. Depending on the indexes to be re-created, connect as CS or APPS user, drop all the indexes whose status is something other than 'INDEXED'.

Continuing with the example, drop the indexes shown in step #2 as follows:

% sqlplus apps/apps

SQL> drop index applsys.FND_LOBS_CTX;
Index dropped.

SQL> drop index IBE_CT_IMEDIA_SEARCH_IM;
Index dropped.

% sqlplus cs/cs

SQL> drop index CS_FORUM_MESSAGES_TL_N4;
Index dropped.

SQL>  drop index CS_INCIDENTS_ALL_TL_N1;
Index dropped.

SQL> drop index CS_KB_ELEMENTS_TL_N2;
Index dropped.

SQL>  drop index CS_KB_SETS_TL_N3;
Index dropped.

SQL> drop index CS_KB_SOLN_CAT_TL_N1;
Index dropped.

SQL> drop index SUMMARY_CTX_INDEX;
Index dropped.

4. Finally create the dropped indexes with the following syntax:

create index <index_name> on <table_name> (<column_name>) indextype is ctxsys.context;

Continuing with the example, create the indexes shown in step #2 as follows:

% sqlplus apps/apps

SQL> create index applsys.FND_LOBS_CTX on applsys.FND_LOBS (FILE_DATA)  
2  indextype is ctxsys.context;

Index created.

SQL> create index IBE_CT_IMEDIA_SEARCH_IM on IBE_CT_IMEDIA_SEARCH (INDEXED_SEARCH) 
2  indextype is ctxsys.context;

Index created.

% sqlplus cs/cs

SQL> create index CS_FORUM_MESSAGES_TL_N4 on CS_FORUM_MESSAGES_TL (COMPOSITE_ASSOC_COL) 
2  indextype is ctxsys.context;

Index created.

SQL> create index CS_INCIDENTS_ALL_TL_N1 on CS_INCIDENTS_ALL_TL (TEXT_INDEX) 
2  indextype is ctxsys.context;

Index created.

SQL> create index CS_KB_ELEMENTS_TL_N2 on CS_KB_ELEMENTS_TL (COMPOSITE_TEXT_INDEX) 
2  indextype is ctxsys.context;

Index created.

SQL> create index CS_KB_SETS_TL_N3 on CS_KB_SETS_TL (COMPOSITE_ASSOC_INDEX) 
2  indextype is ctxsys.context;

Index created.

SQL> create index CS_KB_SOLN_CAT_TL_N1 on CS_KB_SOLN_CATEGORIES_TL (NAME) 
2  indextype is ctxsys.context;

Index created.

SQL> create index SUMMARY_CTX_INDEX on CS_INCIDENTS_ALL_TL (SUMMARY) 
2  indextype is ctxsys.context;

Index created.

5. Repeat step #1 to check the status of text indexes.

                                   iMT Index Summary by Owner

                                                                                Number
         Index                    Table                  Column                   Rows Index
Owner    Name                     Indexed                Indexed               Indexed Status
-------- ------------------------ ---------------------- --------------------- ------- --------
PA       PA_PROJECT_CTX_SEARCH_C1 PA_PROJECT_CTX_SEARCH  CTX_DESCRIPTION           159 INDEXED
HR       IRC_SEARCH_CRITERIA_CTX  IRC_SEARCH_CRITERIA    KEYWORDS                    0 INDEXED
CS       CS_KB_SETS_TL_N3         CS_KB_SETS_TL          COMPOSITE_ASSOC_INDEX     397 INDEXED
         CS_FORUM_MESSAGES_TL_N4  CS_FORUM_MESSAGES_TL   COMPOSITE_ASSOC_COL        10 INDEXED
JTF      JTF_TASKS_TL_IM          JTF_TASKS_TL           TASK_NAME                4183 INDEXED
         JTF_AMV_ITEMS_NAME_CTX   JTF_AMV_ITEMS_TL       ITEM_NAME                1394 INDEXED
         JTF_AMV_ITEMS_DESC_CTX   JTF_AMV_ITEMS_TL       DESCRIPTION              1394 INDEXED
HR       PER_EMPDIR_PEOPLE_N1     PER_EMPDIR_PEOPLE      PERSON_KEY               3258 INDEXED
CTXTEST  QUICK_TEXT               QUICK                  TEXT                        0 NO_INDEX
HR       PER_ADDRESSES_N4         PER_ADDRESSES          DERIVED_LOCALE              0 INDEXED
CS       SUMMARY_CTX_INDEX        CS_INCIDENTS_ALL_TL    SUMMARY                  3947 INDEXED
JTF      JTF_AMV_ITEMS_URL_CTX    JTF_AMV_ITEMS_B        URL_STRING                  0 INDEXED
         JTF_AMV_ITEMS_TEXT_CTX   JTF_AMV_ITEMS_TL       TEXT_STRING              1394 INDEXED
ENI      ENI_DEN_HRCHY_PAR_IM1    ENI_DENORM_HRCHY_PAREN CONCAT_CAT_PARENTAGE      143 INDEXED
                                  TS

OKC      OKC_ARTICLES_CTX         OKC_ARTICLE_VERSIONS   ARTICLE_TEXT              919 INDEXED
AR       HZ_CUST_ACCT_SITES_ALL_T HZ_CUST_ACCT_SITES_ALL ADDRESS_TEXT                0 INDEXED
         1

HR       IRC_DOCUMENTS_CTX        IRC_DOCUMENTS          BINARY_DOC                 13 INDEXED
AR       HZ_STAGE_CONTACT_T1      HZ_STAGED_CONTACTS     CONCAT_COL             ###### INDEXED
HR       IRC_POSTING_CON_TL_CTX   IRC_POSTING_CONTENTS_T NAME                       40 INDEXED
                                  L

IBC      IBC_ATTRIBUTE_BUNDLES_CT IBC_ATTRIBUTE_BUNDLES  ATTRIBUTE_BUNDLE_DATA     224 INDEXED
         X

ICX      ICX_CAT_ITEMS_CTX_DESC   ICX_CAT_ITEMS_TLP      CTX_DESC               ###### INDEXED
CS       CS_KB_SOLN_CAT_TL_N1     CS_KB_SOLN_CATEGORIES_ NAME                       60 INDEXED
                                  TL

AMV      AMV_C_CHANNELS_NAME_CTX  AMV_C_CHANNELS_TL      CHANNEL_NAME               56 INDEXED
ICX      ICX_QUES_CTX             ICX_QUESTIONS_TL       QUESTION                 1279 INDEXED
CS       CS_KB_ELEMENTS_TL_N2     CS_KB_ELEMENTS_TL      COMPOSITE_TEXT_INDEX      367 INDEXED
APPS     IBE_CT_IMEDIA_SEARCH_IM  IBE_CT_IMEDIA_SEARCH   INDEXED_SEARCH         ###### INDEXED
CTXSYS   DEFAULT_POLICY_ORACONTAI DR$POLICY_TAB          PLT_POLICY                  0 NO_INDEX
         NS

SYSTEM   QUICK_TEXT               QUICK                  TEXT                        2 INDEXING
HR       HR_LOCATIONS_N1          HR_LOCATIONS_ALL       DERIVED_LOCALE              0 INDEXED
         IRC_DOCUMENTS_CTX1       IRC_DOCUMENTS          CHARACTER_DOC              13 INDEXED
AR       HZ_STAGE_PARTIES_T1      HZ_STAGED_PARTIES      CONCAT_COL             ###### INDEXED
OKR      OKR_IPS_TL_N1            OKR_IP_COMMON_TL       KEYWORD_TEXT                7 INDEXED
OKC      OKC_TERMS_TEMPLATES_CTX  OKC_TERMS_TEMPLATES_AL TEMPLATE_NAME              70 INDEXED
                                  L

APPLSYS  FND_LOBS_CTX             FND_LOBS               FILE_DATA               61608 INDEXED
CS       CS_INCIDENTS_ALL_TL_N1   CS_INCIDENTS_ALL_TL    TEXT_INDEX               3947 INDEXED
AR       HZ_CLASS_CODE_DENORM_T1  HZ_CLASS_CODE_DENORM   CONCAT_CLASS_CODE_MEA    8154 INDEXED
                                                         NING

AMV      AMV_C_CHANNELS_DESC_CTX  AMV_C_CHANNELS_TL      DESCRIPTION                56 INDEXED
AR       HZ_STAGE_PARTY_SITES_T1  HZ_STAGED_PARTY_SITES  CONCAT_COL             ###### INDEXED
         HZ_STAGE_CPT_T1          HZ_STAGED_CONTACT_POIN CONCAT_COL             ###### INDEXED
                                  TS

39 rows selected.

Read the Oracle Metalink Note 312640.1 Oracle Text: Re-installation of Applications 11i (11.5.10) Oracle Text Indexes, if the steps mentioned in the previous paragraphs didn't help fixing the Oracle Text errors.
__________________
Technorati Tags:

Oracle |

Database |

E-Business Suite |

Oracle Applications |

Solaris

Posted in | No comments

Sunday, 10 June 2007

Java Web Console on Sun Solaris

Posted on 11:07 by Unknown

Have you ever noticed a java process running under noaccess user id on your Solaris 10 and later systems? It looks something similar to:

# prstat -u noaccess
   PID USERNAME  SIZE   RSS STATE  PRI NICE      TIME  CPU PROCESS/NLWP       
  7905 noaccess  110M   91M run     59    0   0:00:46 0.3% java/25

It is the Java Web Console whose responsibility is to provide a common location for users to access web-based system management applications. The Java Web Console is a web page where you can find the Sun system management web-based applications that are installed and registered on your system. Any compliant J2EE^TM web application can register with the web console to make itself available to authenticated and authorized users. Registration is automatically a part of an application's installation process.

The Java Web Console provides the following:

A single point of entry for login and the launching of browser-based system management applications

The console provides a central location from which you can start browser-based management applications simply by clicking the application names. Note that Java Web Console and the Solaris Management Console are not compatible with each other.
Single sign-on through a secure https port
Dynamically organized and aggregated applications

Applications are installed and displayed on the console launch page under the category of management tasks that is most applicable.
A common look and feel
Standard, extensible authentication, authorization, and auditing mechanisms

The Java Web Console supports Pluggable Authentication Module (PAM), role-based access control (RBAC) roles, and Basic Security Module (BSM) auditing.

Check the 3. Working With the Sun Java Web Console (Tasks) section in Solaris 10 System Administration Guide: Basic Administration for the detailed steps to work with Java Web Console.

If you do not need the web console, it can be disabled by running the following command:

# svcadm -v disable webconsole
svc:/system/webconsole:console disabled.

To remove the web console software completely, run the following command:

Solaris 10 3/05, Solaris 10 1/06, Solaris 10 6/06:
# cd / ; /usr/lib/webconsole/setup -u

Solaris 10 11/06 and later releases:
# cd / ; /usr/share/webconsole/bin/setup -u

* Thanks to Prameet Chhabra for sharing the Java Web Console tip.
______________
Technorati tags:

Solaris |

OpenSolaris

Posted in | No comments

Creation Zone

Saturday, 8 September 2007

Memory fragmentation / Large Pages on Solaris x86

Wednesday, 5 September 2007

Linux: Steps for installing GRUB as the Boot Loader

Friday, 24 August 2007

Sandhya Vandanam in Telugu Script

Thursday, 23 August 2007

Cricket Flash Game

Friday, 10 August 2007

Oracle 10gR2/Solaris x64: Must Have Patches for E-Business Suite 11.5.10

Wednesday, 13 June 2007

Oracle 10gR2/Solaris x64: Fixing ORA-20000: Oracle Text errors

Sunday, 10 June 2007

Java Web Console on Sun Solaris

Popular Posts

Categories

Blog Archive

About Me