Pular para o conteúdo principal

Postagens

Docker Remove ALL Containers and Images

Postagens recentes

Oracle Data Modeler and SQL Developer: change user interface (GUI) language

Oracle Data Modeler and Oracle SQL Developer does not allow to change the user interface language in “Options” or somewhere else in the GUI. This applies to the versions:

Oracle SQL Developer Data Modeler - Version All and later (18.2.0 in my case)
Oracle SQL Developer - Version 3.2 and later

However, it’s possible switch to other language, changing datamodeler\ide\bin\ide.conf configuration file.

The following lines should be added to the file for support English:

AddVMOption -Duser.language=en
AddVMOption -Duser.country=US

Restart application!


SQL Developer and Data Modeler supports the following languages:

French(fr), German(de), Italian(it), Spanish(es), Brazilian Portuguese(pt BR), Japanese(ja), Korean(ko), Simplified Chinese(zh CN), Traditional Chinese(zh TW).


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 s…

OHS 12c noprompt password when stop/start component

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

Welcome to WebLogic Server Administration Scripting S…

Basic Script to Restart OHS instance

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!

Change Nodemanager Port from OHS Standalone installation using WLST

[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

Webcenter Content - Jython to Checkin Content with Attachments (CHECKIN_NEW_WITH_RENDITIONS)

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 will likely be removed in …