Technical Notes

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.

Monday 16 March 2015

GET, POST, PUT and DELETE HTTP Methods?

Purposes:
GET - to get the resource
PUT - to update
POST - to Insert
DELETE - to delete

Thursday 12 March 2015

SOAP vs REST

SOAP
- runs based on XML
- uses WSDL standard
- more reliable
- more easier to reach documents and guides

REST
- runs based on "resource URI concept"
- uses HTTP methods for requests
- result data type could be JSON, XML, TXT, HTML
- more faster

Tuesday 10 March 2015

How to run SVN cleanup and update commands in CMD?

e.g. cleanup:
CMD> TortoiseProc.exe /command:cleanup /path:"D:\AlperSVN" /cleanup /noui

e.g. update:
CMD> TortoiseProc.exe /command:update /path:"D:\AlperSVN"

Monday 9 March 2015

How to install node.js in Windows?

Firstly, please go to here (C:\ or D:\) then run the following commands.

CMD> npm install jshint -g

(-g means that user can reach it from all directories when it installed)

If you use proxy, you should run below commands to download jshint module.

CMD> npm config set proxy http://YOURNAME:YOUR_PASSWORD@PROXY_ADDRESS:PROXY_PORT
CMD> npm config set https-proxy http://YOURNAME:YOUR_PASSWORD@PROXY_ADDRESS:PROXY_PORT

To run it;

CMD> jshint abc.js
abc.js: line 11, col 14, Missing semicolon.
1 error

Note: "node_modules" directory is jshint's setup directory

Friday 6 March 2015

[ADVICE] Free SSH Client Alternatives

I strongly recommend to use MobaXterm Personal Edition tool instead of other expensive SSH tools.

The other good choice is ZOC SSH Client.

Friday 27 February 2015

What is X11?

X11 is a network protocol designed for Unix and similar operating systems to enable remote graphical access to applications.

The X Window System (X11, X, and sometimes informally X-Windows) is a windowing system for bitmap displays, common on UNIX-like computer operating systems.

Ref:
http://en.wikipedia.org/wiki/X_Window_System
http://toastytech.com/guis/remotex11.html

Tuesday 24 February 2015

How to learn PC mainboard informations from cmd?

CMD> wmic baseboard get product,Manufacturer,version,serialnumber

Thursday 19 February 2015

[ADVICE] Using both of semicolon and slash characters at the same time

Please note that if you use semicolon and slash at the same time in sql queries, there will be executed as twice on the system.

e.g.
insert into mytable values (007,'Alper');
/

-- result of sql
-- 1 row inserted
-- 1 row inserted

-- do not use "/" with ";" to prevent this case.

Please note that if you use begin-end pl-sql code block, there should be ";" at the end of pl-sql block.

e.g.
begin
insert into mytable values (007,'Alper');
end;

-- result of sql
-- 1 row inserted

-- ";" should be existed in here.

Tuesday 17 February 2015

How to always see authentication pop-up window in Firefox?

Open Firefox -> Enter "about:config" in url bar -> Search "network.automatic-ntlm-auth.allow-proxies" -> Change value to "false" -> Restart Firefox -> That's all.

How to define virtual drive on the system?

Only you need to run these commands in cmd.

e.g. subst v: "\\10.10.10.10\MyRemoteDirectory"

e.g. subst x: "D:\MyBackupDirectory"

to delete it;
subst v: /d

Friday 13 February 2015

How to install/uninstall/search installed rpm package in Linux?

install rpm package:
e.g.
# rpm -Uvh jdk-1.6.0_35-fcs.i586.rpm
or
# rpm -ivh jdk-1.6.0_35-fcs.i586.rpm
(-U, upgrade -i, install –v, verbose –h gist of verbose)

uninstall rpm package:
e.g.
# rpm -ev jdk-1.6.0_35-fcs.i586.rpm

search installed rpm packages:
e.g.
$ rpm -qa | grep jdk

list the dependency of rpm packages:
# rpm -qRp jdk-1.6.0_35-fcs.i586.rpm
(-q, query -R, List package depends)

verify installed rpm package:
e.g.
# rpm -Vp jdk-1.6.0_35-fcs.i586.rpm
(-V, verify -p package name)

check state of files inside of rpm package:
e.g.
# rpm - qsp jdk-1.6.0_35-fcs.i586.rpm
(-s, state (installed, replaced or normal)

verify all installed rpm packages:
# rpm -Va
(-a, all)