Dicas ORACLE DBA

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

cd $OHS_DOMAIN/bin $ ./stopComponent.sh ohs1 Stopping System Component ohs1 ... Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Reading domain from /u01/oracle/domains/ohs_domain Please enter your password : password Connecting to Node Manager ... Successfully Connected to Node Manager. Killing server ohs1 ... Successfully killed server ohs1 Successfully disconnected from Node Manager. Exiting WebLogic Scripting Tool. Done $ OHS_HOME/oracle_common/common/bin $ wlst.sh readDomain('/u01/oracle/domains/ohs_domain') ohs_domain>cd('/SecurityConfiguration/ohs_domain') set('NodeManagerUsername','weblogic') set('NodeManagerPasswordEncrypted','password') updateDomain() closeDomain() exit() $ ./startComponent.sh ohs1  Starting system Component ohs1 ... Initializing WebLogic Scripting Tool (WLST) ... Welco

Execution: $OHS_HOME/oracle_common/common/bin/ ./wlst.sh restart_OHS.py Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Connecting to Node Manager ... Successfully Connected to Node Manager. Restarting server ohs1 ... Successfully restarted server ohs1 Exiting WebLogic Scripting Tool. Script: cat restart_OHS.py nmConnect('weblogic','password','localhost','5557','ohs_domain','/u01/oracle/domains/ohs_domain','ssl') nmSoftRestart(serverName='ohs1', serverType='OHS') exit() Enjoy!

[oracle@hostname bin]$ cd $OHS_HOME/oracle_common/common/bin [oracle@hostname bin]$ ./wlst.sh Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands wls:/offline> readDomain('/u01/oracle/domains/ohs_domain') wls:/offline/ohs_domain> cd('/Machines/localmachine/NodeManager/localmachine') If you have questions about the structure, you can query using the ls () command. wls:/offline/ohs_domain/Machine/localmachine/NodeManager/localmachine> set('ListenPort',5057) wls:/offline/ohs_domain/Machine/localmachine/NodeManager/localmachine> updateDomain() wls:/offline/ohs_domain/Machine/localmachine/NodeManager/localmachine> closeDomain() wls:/offline>exit() Exiting WebLogic Scripting Tool. Reference:  https://docs.oracle.com/middleware/1221/webtier/administer-ohs/getstart.htm#HSADM12040