Pular para o conteúdo principal

Webcenter Content - Increase Number of SDATA Sections when using OracleTextSearch

About SDATA

Oracle UCM uses the SDATA section feature in Oracle Text to index important text, date, and integer fields and define them as Optimized Fields. The SDATA section is a separate XML structure managed by the Oracle Text engine that allows the engine to respond rapidly to requests involving data and integer ranges. Content Server can have up to 32 Optimized Fields, which includes data, integer, standard Content Server fields like dInDate, dOutDate, and fields selected to be optimized. All Optimized Fields are SDATA fields, which by default include dDocName, dDocTitle, dDocType, and dSecurityGroup.

Source: https://docs.oracle.com/cd/E21043_01/doc.1111/e10792/c05_search001.htm



Configuration for Database:
  • For database version > 11.2.0.4 can already have more than 32 sections, does not need to be configured.
  • For database version is Oracle 11.2.0.3.0:
    • Apply the Oracle 11.2.0.4.0 Patch Set: See Note:1562139.1 "11.2.0.4 Patch Set - Availability and Known Issues" (preferred solution)
    • Apply the one-off patch:
      • For Linux x86-64: Patch:16520720 "MERGE REQUEST ON TOP OF 11.2.0.3.0 FOR BUGS 13922299 12960302 14364541 14367567"
  • For database version is Oracle 11.2.0.1 or 11.2.0.2
    • Apply the Oracle 11.2.0.4.0 Patch Set: See Note:1562139.1 "11.2.0.4 Patch Set - Availability and Known Issues"
      • If your database version is 11.1.0.X:
      • Upgrade the database to Oracle 11.2.0.4.0

Configuring in Webcenter Content:

Edit $CONTENT_DOMAIN/ucm/cs/config/config.cfg

 And add parameter MaxNumSdataSections

 Sample:

 MaxNumSdataSections=99

 In weblogic Administration Console, Restart UCM Managed Server.

 Reference: Oracle Support 1607548.1
Marcadores:

Comentários

Postar um comentário

Postagens mais visitadas deste blog

Recompile JSP EBS - R12.2

1. Backup $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/ $ mv _pages _pages_old 2. Stop services cd $ADMIN_SCCRIPTS_HOME ./adapcctl.sh stop ./admanagedsrvctl.sh stop oafm_server1 ./admanagedsrvctl.sh stop oacore_server1 3. Compile the jsps manually  cd $FND_TOP/patch/115/bin/ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p             4. Checking $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages $ ls -ltr  5. Start services cd $ADMIN_SCCRIPTS_HOME ./admanagedsrvctl.sh start oacore_server1 ./admanagedsrvctl.sh start oafm_server1 ./adapcctl.sh start 6. Clear your web browser cache
Postar um comentário
Leia mais

How to Disable WebLogic Server Diagnostic Framework (WLDF)

[weblogic@yourhost ]$ cd $MW_HOME/oracle_common/common/bin/ [weblogic@yourhost bin]$ ./wlst.sh Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands wls:/offline> connect('weblogic','password','t3://host_ip:port') Connecting to t3://xx.xx.xx.xx:7001 with userid weblogic ... Successfully connected to Admin Server "AdminServer" that belongs to domain "WeblogicDomain". Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. wls:/WeblogiDomain/serverConfig/> edit() Location changed to edit tree. This is a writable tree with DomainMBean as the root. To make changes you will need to start an edit session via startEdit(). For more help, use help('edit'). wls:/WeblogiDomain/edit/> startEdit() Starting an edit session ... Started edit session, be sure...
Postar um comentário
Leia mais

How to recreate oraInventory in ebs R12

Edit the oraInst.loc file: vi /etc/oraInst.loc Change the inventory_loc to a new location: inventory_loc=/prod/oraInventory_new Create the new directory: mkdir /prod/oraInventory_new Give permissions to the new directory: chmod -R 777 /prod/oraInventory_new -- Add the 10.1.3 Oracle Home to the new created oraInventory: cd $INST_TOP/ora/10.1.3 . ./APP .env Go to the $ORACLE_HOME: cd $ORACLE_HOME Edit the oraInst.loc and point it to the same location ad done in step 1: inventory_loc=/prod/oraInventory_new Add the 10.1.3 Oracle Home to the new oraInventory location: cd $ORACLE_HOME/appsutil/clone ./ouicli.pl Verify if the 10.1.3 is added to the new oraInventory directory: cd /prod/oraInventory_new/ContentsXML cat inventory.xml If it's not added, check the /prod/oraInventory_new/logs file. Verify the oraInventory has the information about the 10.1.3 Oracle Home: export PATH=$ORACLE_HOME/OPatch:$PATH opatch lsinventory -detail -- Add the 10.1.2 Oracle Home to the new created oraInvento...
Postar um comentário
Leia mais