SCAN – SINGLE CLIENT ACCESS NAME

11g r2 grid infranın en onemli ozeliklerinden biride SCAN. bu ozellik sayesinde cluster node eklerken ve cikarirken her defasinda tnsnames.orayı modifiye etmek zorunda kalmiyoruz.

Artik cluster son derece kolay kurulabilen ve ozellikle cluster baglanan sunucu sayisi gunden gune artan bir yapida dusunuluyor. O yuzdende node eklemek problemli bir is olmaktan cikarılması gerekiyor. Grid plug and play kapsamıda bu yonde geliştirilmiş bir ozellik.
Clientlar clustera tekbir isimden EZconnect sekilde ulastıkları bir yonetem SCAN.Hatta bu yontem sayesinde hangi nodeda database calısıyor ondanda bagımsız haraket etmek mumkun oluyor.SCAN client baglantılarında hem yuk dagılımından hemde problem oldugu zaman dıger sunucudan calısma isini hallediyor.
Grid infrayı kurarken SCAN yapılandırıyoruz. Ister kendi DNS istersenizde Oracle yeni getirdigi GNS kullanabilirsiniz.
3 adres kullanmamız tavsiye ediliyor
system/oracle@yeni-scan:1521/orcl
DNS girilen kayıt

bu adresler public networktte ve aynı subnette olmalı.

yeni-scan.oracle.com A 192.168.1.190
A 192.168.1.191
A 192.168.1.192

eger GNS kullanırsanız is dahada kolay , kurulum sırasında 3 adresi otomatik olarak dhcpden alıyor.

Cluster konfigurasyonu sırasında SCAN VIP ve SCAn listener yaratılır.

Cluster’ın birden fazla node yaratıldıgını dusunursek SANVIP ve lıstener farklı farklı nodelarda start olacaktır.


srvctl config scan_listener

SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521

SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521


srvctl config scan

SCAN name: yeni-scan, Network: 1/192.168.1.0/255.255.255.0/

SCAN VIP name: scan1, IP: /yeni-scan.oracle.com/192.168.1.190

SCAN VIP name: scan2, IP: /yeni-scan.oracle.com/192.168.1.191

SCAN VIP name: scan3, IP: /yeni-scan.oracle.com/192.168.1.192


kurulum sırasında remote_listener parametresi yeni-scan.oracle.com:1521 olarak ayarlanır.


SCAn kullanmıs bir TNSNAMES.ora dosyası

orcl =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=yeni-scan.oracle.com)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl))
)

Eski yontemle scan kullanmamıs bir tnsnames.ora dosyası örnegi

orcl =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=yeni1-vip.oracle.com)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=yeni2-vip.oracle.com)(PORT=1521))
)
(CONNECT_DATA=(SERVICE_NAME=orcl)))
)
)




Advertisements

About oracledocuments

Zekeriya Beşiroğlu, It joined the Bilginc IT Academy in July 2000. In the meantime, the Oracle Education, Oracle Data Base Management System and Oracle Internet Technologies, Oracle development technologies such as the training of Oracle products is responsible for training as consultants. During this task, since 1 April 2008 with 293 Oracle training in total, in 2150 Oracle customers successfully submitted. Oracle 10g New York in November 2002 have received training and education in Turkey was the first time the consultants. 20 April 2008 on education in Turkey 11g is the first who was a consultant. Oracle Real Application Cluster Expert advisor is certified is the first . Http://zekeriyabesiroglu.blogspot.com and Http://www.oracleforum.info owner and manager of the site. Its own has more than one hundred articles. In addition, creation and improvement of training materials are also related to work. Oracle products are used, database management and reporting Academy eruditely It also is working on. From the date of 1 January 2009 will continue to work as the Technical Director
This entry was posted in SCAN - SINGLE CLIENT ACCESS NAME. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s