1. setelah diubah port di listener.ora, service
listenernya di restart.
LSNRCTL> START listener
2. agar setiap database punya port sendiri( kalo ada 3
database)
buat 3 listener dengan nama dan port yang berbeda.
Gunakan tools Oracle Net Manager
misal : db01 --> listener1 --> port 1525
db02 --> listener2 --> port 1526
db03 --> listener3 --> port 1527
sehingga kalo di cek di file listener.ora seperti ini:
#++++++++++++++++++++++++++++++++++
# INI DAFTAR NAMA LISTENERNYA
# DAN NOMOR PORT YG BISA DILAYANI
#++++++++++++++++++++++++++++++++++
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
db_server)(PORT = 1521))
)
)
LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db_server)(PORT
= 1525))
)
LISTENER2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db_server)(PORT
= 1526))
)
LISTENER3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db_server)(PORT
= 1527))
)
#+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
# INI DAFTAR NAMA SID YG DILAYANI OLEH SETIAP LISTENER
#+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = db01)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = db01)
)
)
SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = db02)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = db02)
)
)
SID_LIST_LISTENER3=
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = db03)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = db03)
)
)
Setiap listener nanti harus di startup, pertama kali
gunakan
tool LSNRCTL,
LSNRCTL> START LISTENER1
LSNRCTL> START LISTENER2
LSNRCTL> START LISTENER3
setelah ketiga perintah diatas, baru ketiga service
listener akan muncul di Windows Services.
Kemudian baru buat service_name di client. untuk
koneksi ketiga database berarti harus ada 3 nama
service name.
gunakan tools Oracle Net Manager
atau bisa langsung edit file tnsnames.ora-nya menjadi
seperti ini:
#+++++++++++++++++++++++++
# koneksi ke database DB01
#+++++++++++++++++++++++++
DB01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db_server)(PORT
= 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db01)
)
)
#+++++++++++++++++++++++++
# koneksi ke database DB02
#+++++++++++++++++++++++++
DB02 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db_server)(PORT
= 1526))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db01)
)
)
#+++++++++++++++++++++++++
# koneksi ke database DB03
#+++++++++++++++++++++++++
DB03 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db_server)(PORT
= 1527))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db01)
)
)
Semoga Membantu.
Mohon koreksi kalo ada kesalahan..
Bambang Sutejo
__________________________________
Yahoo! for Good - Make a difference this year.
http://brand.yahoo.com/cybergivingweek2005/
------------------------ Yahoo! Groups Sponsor --------------------~-->
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/.QUssC/izNLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
