Dicas ORACLE DBA

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

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

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

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