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...

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 a...

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.FileServ...

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...

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

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 variab...