Useful shortcuts for vi editor

Monday, 7 September 2015

Reklam gelirleri hakkında

Kasa: 26.72 TL
Güncellenme tarihi: 21.09.2016

How to force kill spesific process or multiple processes in Command Window by using process name ?

Please make sure that you do not enter system process while killing some processes. 
  • Press Windows key + R
  • Enter cmd then click OK
  • Write tasklist and press Enter
  • Define process name (image name)
  • Write taskkill /IM [processname.exe] /F /T
    e.g. taskkill /IM onenote.exe /F /T
Info: 
/IM -> image name
/F -> force
/T -> tree kill

That's all.

Bye :)

Saturday, 5 September 2015

How to connect internet via USB cable in Android Devices?

To do that please follows the instructions;

Info: In this example, Android 4.2.2 version has been used.

Prerequisite: Plug your device into PC/Lap-Top via USB cable.

Open "Settings" -> Go to "More networks-> Go to "Tethering and portable hotspot" -> Activate "USB tethering"

After that, you should be able to see "Blue usb icon" in Notification bar

Tip: You may use this when mobile device connects to WiFi as well. 

Attention: Please be aware of your mobile data usage while "USB tethering" is open

Wednesday, 1 July 2015

How to point outlook archive file (.pst) in Outlook 2013?

To do that please follows the instructions;

Click "File" from top-left corner -> Click "Data Files" -> Click "Add" -> Select archive .pst file -> Click "OK" -> Check your mail box to see archive folder

Wednesday, 17 June 2015

How to update driver with .inf file?

To do that please follows the instructions;

Press Windows key + R -> Input "mmc devmgmt.msc-> Right click to "undefined device" in "Portable Devices" folder then select "Update Driver Software-> Click to "Browse my computer for driver software" -> Click to "Let me pick from a list of device on my computer-> Click to "Have Disk" -> Click to "Browse" -> Find .inf file then click "Open" -> Click "Next" and finish-up.

Monday, 8 June 2015

How to use adb (android debug bridge) cmd tool?

First, you need to connect your devices to PC with adb.

e.g.
CMD> adb devices
result; abcdabcdxxx device

- start adb from different port
e.g.
CMD> adb -P 1111 start-server

- Install .apk package
e.g.
CMD> adb install mytool.apk

- Get logs from android device e.g.
CMD> adb logcat -d > mydevicelogs.txt

- Start-Stop adb server
CMD> adb start-server
CMD> adb kill-server

- Remount devices
CMD> adb remount

- Reboot devices
CMD> adb reboot

Enter to shell (linux)
CMD> adb shell

Gain read-write access for /system path to get rid of "Read-only file system" error
CMD> adb shell
# mount -o rw,remount /system

- Revert to read-only access for /system path
CMD> adb shell
# mount -o ro,remount /system

- Define a new folder
CMD> adb shell mkdir /tmp/example

- Send a file into phone
CMD> adb push config.txt /tmp/example

- Get a file from phone
CMD> adb pull /tmp/example/config.txt

Friday, 5 June 2015

.tar examples for gzip

e.g.
tar -cvzf mytarfiles.tar myfile1 myfile2
- c, create a new file
- v, verbose (display) file to compress or uncompress
- z, use gzip to zip it
- f, create tar file with filename provided as the argument

e.g.
tar -cvzf mytarnewfiles.tar *.txt
- all text files will be tarred in current path (pwd)

e.g.
lz mytarnewfiles.tar
- lz, list files inside of tar

e.g.
tar -xvzf mytarnewfiles.tar
- x, extract files in the current path (pwd)

e.g.
tar -xvzf mytarnewfiles.tar -C myfiles/
- C, extract files into defined folder as new

Sunday, 31 May 2015

How to use "for update" clause in Oracle?

You are able to lock a table to prevent executing Data Manupulation Language-DML commands like INSERT, UPDATE, DELETE by others users:

e.g.
SQL> SELECT * FROM employees FOR UPDATE;
-- in this way, other users could not execute DML command that hangs up until user sends COMMIT or ROLLBACK to release the table lock. However, other users are able to execute SELECT still.

Wednesday, 27 May 2015

How to know total row number, word number and character number in Linux?

e.g.
$ wc myfile.txt
-> 5 13 56 myfile.txt 
5; total row number 
13; total word number
56; total character number

$ ls | wc -l
-> Total number of files in current directory

Monday, 25 May 2015

How to configure auto reply e-mail in Office 2013?

To do that please follow the instructions:

To define auto reply;

1. define a message template

Home -> New Email-> Manage Rules & Alerts -> Enter your message -> File -> Save As "Outlook Template .oft"

2. define a rule for auto reply

Home -> Rules -> Manage Rules & Alerts ->  New Rule -> Select "Start from a blank rule-Apply rules on messages I receive" -> select own preferences -> Activate "reply using a specific template" -> Click "a specific template" by saved .oft file -> Define a name to rule -> Finish

To turn off auto reply;

Home -> Rules -> Manage Rules & Alerts -> Go Email Rules tab -> inactivate to desired rule

Sunday, 24 May 2015

How to get instance name, database status and instance role in Oracle?

SQL> select instance_name, database_status, instance_role from v$instance; 

e..g.
INSTANCE_NAME    DATABASE_STATUS   INSTANCE_ROLE
---------------- ----------------- ------------------
xe               ACTIVE            PRIMARY_INSTANCE

Thursday, 23 April 2015

How to transfer database file in Windows?

To do that please follow the instructions;

Tablespace: ALPER_DATA

Database file: data_01.dbf
DB file path: C:\Databasefiles
New database file name: data_new_01.dbf
New DB file path: D:\Databasefiles

Type these commands and press enter;

Example of offline transfer (database runs as non-archivelog mode)

Tablespace goes offline;
  • sqlplus / as sysdba 
  • alter tablespace ALPER_DATA offline;
  • exit
  • move C:\Databasefiles\data_01.dbf D:\Databasefiles\data_new_01.dbf
Datafile location info updates in database;
  • sqlplus / as sysdba
  • alter tablespace ALPER_DATA rename datafile 'C:\Databasefiles\data_01.dbf' to 'D:\Databasefiles\data_new_01.dbf';
  • alter tablespace ALPER_DATA online;
  • exit
Example of online transfer (database runs as archivelog mode)

Datafile goes offline;
  • sqlplus / as sysdba
  • alter database datafile 'C:\tablespaces\alper_01.dbf' offline;
  • exit
  • move C:\Databasefiles\data_01.dbf D:\Databasefiles\data_new_01.dbf
Datafile location info updates in database;
  • sqlplus / as sysdba
  • alter tablespace ALPER_DATA rename datafile 'C:\Databasefiles\data_01.dbf' to 'D:\Databasefiles\data_new_01.dbf';
  • recover datafile 'D:\Databasefiles\data_new_01.dbf'
  • alter database datafile 'D:\Databasefiles\data_new_01.dbf' online;
  • exit
Bye :)

Wednesday, 22 April 2015

Alexa Rank

Global rank: 5,696,926

How to make a schedule for disk cleanup automatically?

Please follow the steps;

1st step: 
Define a disk cleanup profile.
e.g. 
cleanmgr /sagerset:1

2nd step:
Run task scheduler
taskschd.msc

3rd step:
Define a task schedule as designed profile by importing "cleanmgr /sagerun:1" to Actions
e.g.
task generates first-day of each month at 01:00 pm

Saturday, 18 April 2015

RamDisk nedir ve nasıl kullanılır?

Nedir?
RAMDisk, eski tip mekanik hard-disk-lerin okuma ve yazma hızlarının düşüklüğünden bir nebze kurtulmak için kullanabileceğiniz faydalı bir yazılımdır. :) Kısacası; bu yazılım ile bilgisayarınız, fiziksel disk yerine (hard-disk) hali hazırdaki RAM-lerinizi (sanal) disk olarak kullanır.

Kullanımı
Basitçe, tanımladığınz sanal partisyon dizinine çok sık kullandığınız bir programı kurduktan sonra bilgisayarınızda belirgin bir hız artışı sağlanabilir.

Örnek
Google Chrome'da kullanımı;
Web Tarayıcısının, diske kullandığı dizini, yeni tanımladığınız sanal diske ayarlamanız ve aşağıdaki örneğe bakarak yeni bir kısayol tanımlamanız yeterlidir.
"C:\Program Files\Google\Chrome\Application\chrome.exe" --user-data-dir="G:\chrome_userdata"

-- G:\chrome_userdata; sanal disk dizini

Dataram RamDisk yazılımına burada erişebilirsiniz: http://memory.dataram.com/products-and-services/software/ramdisk

Kaynak: http://www.enpedi.com/2012/09/ramdisk-nedirkimler-kullanmal-nasl.html

HTML sayfalardaki Türkçe karakter gösterme sorunu ve çözümü

Merhaba,

HTML sayfalar, web-tarayıcıları tarafından çözümlenirken bazen Türçe karakterler sayfa yapısını bozabiliyor. Bunun çözümü oldukça basit;
html kaynak kodunuzun <head> etiketi içine, aşağıda gösterilen satırı eklemeniz yeterli;

<html>

<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8"/>
</head>
</html>

veya
<meta http-equiv="Content-Type" content="text/html;charset=iso-8859-9"/>

İşte bu kadar kolay! :)

İngilizce Çalışma - Seri 1

How come - nasıl olur da...
How on earth - nasıl olur da...
why on earth - ne demeye...

Örnek cümleler:
How come did you come to here?
How on earth didn't we buy this car?
Why did you ask this question?
Why on the earth did she break the relationship?

Sunday, 12 April 2015

How to find a listening port in Linux?

There are two simple ways for finding the listening port.
  • lsof | grep 8080
  • netstat -an | grep 8080

Friday, 10 April 2015

How to do inside search in Google?

Simply, you only need to add "site" in your query.

e.g. 

your query -> site:ozsoyler.blogspot.com Hello World!

Just all! 


Bye.

Thursday, 26 March 2015

Türkçemizi koruyalım - 2

Yanlış Olan - Doğru Olan
Herkez - Herkes
Birgün - Bir gün
Yanlız - Yalnız
Hoşgeldin - Hoş geldin
Klavuz - Kılavuz
Sağol - Sağ ol
Deyil - Değil
Özgeçmiş - Öz geçmiş
Poaça - Poğaça
Pekçok - Pek çok

Aktif - Etkin
Fonksiyon - İşlev
Anons - Duyuru
Sempatik - Sevimli
İzolasyon - Yalıtım
Detay - Ayrıntı
Asistan - Yardımcı
Dizayn - Tasarım
Orijinal - Özgün
İmaj - Görünüm

Avantaj - Üstünlük
Arşiv - Belgelik
Full - Tam
Ekstra - Fazladan
Limit - Sınır
Depresyon - Bunalım
Röportaj - Söyleşi
Profil - Görünüş
Kriter - Ölçüt
Favori - Gözde 

Bilgi: İspir Ziya Ortaokulu foto albümünden alıntıdır.