DevTech101

DevTech101

Month: December 2015

Testing HDFS Over WebHDFS By Using CURL

A quick update on hdfs put/get/etc… Simplest solution to upload/download/delete/etc… Use webhdfs. samples are below. ————— Simple Example in one step. Note: In this example, replace node name with any of the 6 nodes [n01-n06] curl -L -i -X PUT -T source_file_name.pdf “http://n03.domain.com:50075/webhdfs/v1/user/usera/dest_file_name.pdf?user.name=usera&op=CREATE&user.name=usera&namenoderpcaddress=bda-cluster1-ns&overwrite=false” # Example You have a source file: solaris_openstack.pdf user.name: usera file dest: …

Testing HDFS Over WebHDFS By Using CURL Read More »

How to recover from an Oracle DB archivelog full error

How to recover from an Oracle DB if the disk/file system for archive logs gets full Note: if DB is hung at shutdown i.e. shu immediate, then force a shutdown, like below SQL> shutdown abort; SQL> startup nomount; SQL> alter database mount SQL> exit Get size used for if needed SQL> col name format A50 …

How to recover from an Oracle DB archivelog full error Read More »

ASM migrate from one lun to anther lun

To add new disk array / lun sqlplus / as sysasm ALTER DISKGROUP DATA ADD DISK ‘/dev/rdsk/c1d1s0’ REBALANCE POWER 5; # Fastest ALTER DISKGROUP DATA ADD DISK ‘/dev/rdsk/c1d1s0’ REBALANCE POWER 11; To verify SQL> select path,name,header_status from v$asm_disk; To Check where the rebalnce is up to select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES …

ASM migrate from one lun to anther lun Read More »

Configuring BDA

How to add scoop2 Doc ID 1922701.1 If it fails use Doc ID 1966882.1 Note: Clear the directory before starting as old junk will make it fail. P.S. Make sure you are not removing other jar files. rm -r /var/lib/sqoop2/* Hive issues, make sure to set full rights to the hive tmp dir hadoop fs …

Configuring BDA Read More »

Enterprise Manager Deleting Targets Manually With CLI

Enterprise Manager deleting a target manually First stop the agent. ./emctl stop agent Oracle Enterprise Manager Cloud Control 13c Release 1 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. Stopping agent … stopped. emcli login -username=sysman emcli sync emcli delete_target -name=”em-host.domain.com:3872″ -type=”oracle_emd” -delete_monitored_targets Now Uninstall the agent export ORACLE_HOME=export ORACLE_HOME=/u01/app/agent/core/12.1.0.2.0 $ORACLE_HOME/oui/bin/runInstaller -deinstall -removeallfiles # …

Enterprise Manager Deleting Targets Manually With CLI Read More »

Oracle Enterprise Manager 13c with Oracle DB Configuration Modifications

How to increase Oracle Database log size alter database add logfile size 600m; alter database drop logfile group 1; select l.group# , l.bytes , l.status , l.archived , lf.member from v$logfile lf , v$log l where lf.group# = l.group#; alter system switch logfile; alter system checkpoint; alter database drop logfile group [ active log]; Change …

Oracle Enterprise Manager 13c with Oracle DB Configuration Modifications Read More »

Enterprise Manager Cloud Control 12c startup issues

At startup first log directory /u01/app/oracle/gc_inst-r5/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.log After that log directory /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log/ Note: By setting memory to low, like below OMS will hang and never complete startup emctl set property -name ‘JAVA_EM_MEM_ARGS’ -value ‘-Xms256m -Xmx1740m’ How to increase the memory on EM 12c https://community.oracle.com/community/support/support-blogs/enterprise-manager-support-blog/blog/2015/01/20/how-to-tune-the-jvm-heap-memory-arguments-for-12c-oms-and-agent

Testing DNS performance – perl script

Use the perl script below to check your DNS performance. Make sure to replace the search string and your DNS provider IP address. #!/usr/bin/perl @ns = @ARGV; push(@ns,’8.8.8.8′, ‘4.2.2.1’) unless @ns; $domain = “www.devtech101.com”; use Net::DNS; use Time::HiRes; # high resolution timing required use Time::Stopwatch; use Number::Format qw(:subs); use Statistics::Descriptive; tie my $time, ‘Time::Stopwatch’; # …

Testing DNS performance – perl script Read More »

Oracle ODSEE to OUD Directory Replication or Migration

Contents 1 How to install and configure Odsee to oud directory replication 1.1 First install an OUD directory 1.2 Migrate ODSEE to OUD schema and roles 1.2.1 Set ODSEE compatibly 1.2.2 Migrate schema and roles 1.3 Get a one time ODSEE full export from 1.4 Clean Import ODSEE Data in OUD – OUD has to …

Oracle ODSEE to OUD Directory Replication or Migration Read More »