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

In the last few days, i had to load a content that, by its requirements, needs to attach files to the content. My first alternative would be Batch Loading, however for the bacth loder file it was not possible because it does not actually support the rendition service. With the next option, i tried to use the IdcCommand, but still had many problems, such as errors below: sample hda file: [oracle @ hostname bin] $ cat idctst.txt @Properties LocalData IdcService = EDIT_RENDITIONS dID = 37020 renditionKeys = addRendition0 addRendition0.name = test543 addRendition0.action = edit addRendition0.file = test.txt addRendition0.file: path = / u01 / oracle / domains / content_domain / ucm / cs / vault / ~ temp / test.txt @end << EOD >> Executing: [oracle @ hostname bin] $ ./IdcCommand -f idctst.txt -u sysadmin -l log.log -c server Error: Java HotSpot (TM) 64-Bit Server VM warning: Using the ParNew young collector with the Serial old collector is deprecated and w

Problem: New Chekin file: Make Annotations: Reopen File: Error Log: intradoc.common.ServiceException: !csErrorAccessingForDownload,OWCCDEV12C034609-page1.png         at intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequestImplementor.java:2259)         at intradoc.server.Service.buildServiceException(Service.java:2432)         at intradoc.server.Service.createServiceExceptionEx(Service.java:2426)         at intradoc.server.Service.createServiceException(Service.java:2421)         at intradoc.server.ServiceHttpImplementor.handleUploadException(ServiceHttpImplementor.java:2633)         at intradoc.server.ServiceHttpImplementor.sendStreamResponse(ServiceHttpImplementor.java:2559)         at intradoc.server.Service.doResponse(Service.java:2195)         at intradoc.server.FileService.doResponse(FileService.java:1605)         at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:836)         at intradoc.

Warning Message: [oracle@host bin]$ ./BatchLoader -console -q -n/u01/oracle/domains/content_domain/ucm/cs/bin/test.txt Java HotSpot(TM) 64-Bit Server VM warning: Using the ParNew young collector with the Serial old collector is deprecated and will likely be removed in a future release >system/6       09.06 15:39:05.045      main    Configuring tracing verbose: false; sections: system >system/6       09.06 15:39:05.045      main    Configuring tracing verbose: false; Services: Sep 06, 2017 3:39:10 PM oracle.security.jps.JpsStartup start INFO: Jps initializing. Sep 06, 2017 3:39:19 PM oracle.security.jps.JpsStartup start INFO: Jps started. Sep 06, 2017 3:39:19 PM oracle.security.audit.Auditor init WARNING: IAU:IAU-6012: Unable to determine the audit log directory. No log directory specified. Sep 06, 2017 3:39:19 PM oracle.security.jps.util.JpsUtil disableAudit INFO: JpsUtil: isAuditDisabled set to true Sep 06, 2017 3:39:19 PM oracle.security.jps.internal.audit.AuditS

Error: Executing IdcAnalyze: # cd $CONTENT_DOMAIN/ucm/cs/bin/ # ./IdcAnalyze -index Output: (internal)/3   09.06 11:38:38.584      main            !csWcGetDocInfoFailed  (internal)/3   09.06 11:38:38.584      main            at intradoc.common.DefaultTraceImplementor.appendStackTrace(DefaultTraceImplementor.java:348)  (internal)/3   09.06 11:38:38.584      main            at intradoc.common.DefaultTraceImplementor.traceDumpException(DefaultTraceImplementor.java:467) ...  Caused by: intradoc.data.DataException: !csNoServiceDefined,DOC_INFO_BY_NAME Solution: In Administration Console: Select Administration --> Admin Server --> Component Manager  In Advanced Component Manager  disable the WebCenterConfigure component if you aren't using it.

Error: Executing IdcAnalyze: # cd $CONTENT_DOMAIN/ucm/cs/bin/ # ./IdcAnalyze -index Output: localization/3 09.06 11:45:41.519      Thread-6        !apUnableToInstantiateClass2,idcnls.OracleCommonLocalizationHandler exception backtrace:  localization/3 09.06 11:45:41.519      Thread-6                at intradoc.common.DefaultTraceImplementor.appendStackTrace(DefaultTraceImplementor.java:348)  localization/3 09.06 11:45:41.519      Thread-6                at intradoc.common.DefaultTraceImplementor.dumpException(DefaultTraceImplementor.java:412)  ...  ... localization/3 09.06 11:45:41.519  Thread-6   Caused by: java.lang.ClassNotFoundException: oracle.i18n.text.OraCollator  localization/3 09.06 11:45:41.519      Thread-6                at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ... ... Solution: Edit CLASSPATH variable in intradoc.cfg locate in $CONTENT_DOMAIN/ucm/cs/bin and add library as bellow: CLASSPATH=$COMPUTEDCLASSPATH: /u01/oracle/Middlew

The configuration values below, control the temporarily cached files keep in FileCache table. FsCacheThreshold Specifies the maximum cache size, in megabytes (default=100) Once the threshold is met, Content Server starts deleting files that are older than the minimum age, as specified by the FsMinimumFileCacheAge parameter FsMaximumFileCacheAge The age at which files are deleted, expressed in days. The default is 365 days FsMinimumFileCacheAge The minimum age at which cached files can be deleted This parameter is used in conjunction with the FsCacheThreshold parameter to determine when to delete cached files FsCleanUpCacheDuringIndexing This parameter activates vault cache cleaning, while FsCacheThreshold, FsMaximumFileCacheAge and FsMinimumFileCacheAge are controling its behaviour.  Expect, when this is enabled on a system that currently has a large number of files in the FileCache table, the first cycle will take a long time to complete. How to Configure

In Administration Console: Select Administration --> Admin Server --> General Configuration In the " Additional Configuration Variables"  pane add the following to the config.cfg: FoldersIndexParentFolderValues=true FldEnforceFolderFileNameUniqueness=true FldEnforceCaseInsensitiveNameUniqueness=true When: FoldersIndexParentFolderValues Allows you to search for content within folders including subfolders. FldEnforceFolderFileNameUniqueness Prevents folders from having a child folder with the same name as a child document. FldEnforceCaseInsensitiveNameUniqueness Makes name-uniqueness checks for folder and file names case-insensitive, and makes path resolution case-insensitive. Reference: Support Note 2075477.1

Solution: Edit configuration file intradoc.cfg in $CONTENT_DOMAIN/ucm/cs/bin/ Add the configurations lines bellow: JAVA_MAX_HEAP_SIZE=1024 JAVA_OPTIONS_GC=-XX:+UseParNewGC JAVA_OPTIONS_MaxNew=-XX:MaxNewSize=350m This setting was required to use the BatchLoader

Excellent document with tips and tricks in vi: vi tips and tricks: Ten cool commands sure to impress your friends

Error: An error occurred during indexing. Unable to index metadata only. This may indicate the collection is damaged. Indexing aborted. [ Details ] !csIndexerError!csIndexerMetaOnlyFailed intradoc.common.ServiceException: !csIndexerMetaOnlyFailed   at intradoc.indexer.IndexerBulkLoader.handleIndexerResults(IndexerBulkLoader.java:593)   at intradoc.indexer.IndexerBulkLoader.createBulkLoad(IndexerBulkLoader.java:373)   at intradoc.indexer.IndexerBulkLoader.doWork(IndexerBulkLoader.java:170)   at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)   at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)   at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)   at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:841) Solution: Change SecureFile database feature to BasicFile for log segments: Edit $CONTENT_DOMAIN/ucm/cs/config/config.cfg Add entry UseSecureFiles=false in the config.cfg under addtional variables Save File and restart Content

Edit configuration file config.cgf in $CONTENT_DOMAIN/ucm/cs/config/ Add the configuration entry MemoFieldSize=<required size> to the config.cfg file. Restart the WebCenter Content managed server. This will only apply to newly created fields. Reference: Oracle Support Note ID 1376478.1

Hello, I took some time off, but now I intend to re-feed my humble blog with some experience that I may have acquired during my work. In my first post, after this long time, i will explain very briefly how to configure the EmailMetadata Component in Webcenter Content. Steps: Enable EmailMetadata Component Create new required metadatas Configure Mapped Fields and Mapped Values Install Desktop Integration Suite (DIS) Let´s Go Enable EmailMetadata Component With Administrator User in Webcenter Content  Administration Console (http://host:port/cs): Administration -> Admin  Server -> Component Manager Click in advanced component manager. Enable components EmailMetadata and Desktop Integration Suite Restart UCM Managed server in Weblogic Administration Console 2. Create new required metadatas In Admin Applets -> Configuration Manager, create new required metadatas: xEmailTo xEmailFrom xEmailSubject xEmailCC xPublicationDate xRec