Pular para o conteúdo principal

Postagens

Find User and Groups in Specific Directory

Postagens recentes

Oracle Database 20c preview version available for virtual machine DB systems

Oracle Database 20c preview version available for virtual machine DB systemsServices: DatabaseRelease Date: Feb. 14, 2020 You can now provision a virtual machine DB system with Oracle 20c preview version software to do development and application testing. Preview version software is limited to virtual machine systems using the Fast Provisioning option (which uses Logical Volume Manager for storage management). For more information, see Oracle Database Preview Version Availability.


You must use Logical Volume Manage to show the 20c version option:



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!