SQLNET trace including oci and thin driver
1. Net Logging and Trace when it is oci driverhttp://docs.oracle.com/cd/A57673_01/DOC/net/doc/NWTR23/ch3trc.htmLoggingThe following parameters can be set to configure Oracle Net logging in sqlnet.ora: ParameterDescriptionLOG_D...
Nosql分类
参考:http://www.infoq.com/cn/news/2013/11/introducing-nosqlhttp://www.cnblogs.com/sunli/archive/2011/01/24/nosql_or_relation.html 列式存储面向列的DBMS是这样一种数据库管理系统,它将数据表存储为数据列而非行的形式。从物理上来说,表是列的集合,每一列从本质上来说都是只有一个字段的表。这...
How to audit failed logon attempts
How to audit failed logon attemptsOracle Audit -- failed connectionBackground:In some situation DBA team wants to audit failed logon attempts when "unlock account" requirement becomes frequently and user cannot figure out who from where is using incorrect password ...
Getting oracle agent installation from oem
1. access oem to get the url for softwareEnter [Setup]-->[Extensibility]-->[Self Update]Enter Type[Agent Software] and select the version and click [Action]-->[Export], get the command line like below"emcli export_update -id=99161547BBDF9C653CF7400EBE4B23C5 -omslocal -dir="...
Important directory for OBIEE 11g for system component and java component
obiee11g
Check database status in RAC
[grid@jptkydbrac011lnx ~]$ srvctl status database -d uhkcInstance uhkc1 is running on node jptkydbrac011lnxInstance uhkc2 is not running on node jptkydbrac012lnx[grid@jptkydbrac011lnx ~]$ srvctl config database -d uhkcDatabase unique name: uhkcDatabase name: uhkcOracle home: /apps/oracle/prod...
Manage startup/shutdown/status services in 11gR2 RAC
http://appsdbaworkshop.blogspot.jp/2011/11/manage-startupshutdownstatus-services.htmlAll these commands are demonstrated on a 4 node cluster running on OEL 5.6. How to check the status of CRS on specific node: [ora11g@racnode1 ~]$ crsctl check crsCRS-4638: Oracle High Availability Services i...