JAWAB 1:
Error yg anda dapatkan bukan karena masalah PORT, tapi karena
masalah SERVICE yg didaftarkan di listenernya tidak match dengan yg
ada di tnsnames.ora
Bisa anda kirim isi listener.ora dan tnsnames.ora-nya (japri ke saya)
Utk check service
C:\> lsnrctl services
Lalu dibandingkan dgn
isi tnsnames.ora (pada section SERVICE_NAME) ... match atau tidak
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
JAWAB 2:
Setiap aplikasi berbasis TCP/IP selalu menggunakan port,
sebagai "pintu masuk" ke dalam sebuah aplikasi di server.
Spt,
- Web server menggunakan default port 80,
- Telnet Server menggunakan default port 23
Komputer client yg mengakses database dengan menggunakan TCP/IP sbg
protocolnya, juga menggunakan port, baik di sisi client atau di
server.
Di sisi database server utk menerima "new incomming connection"
dibutuhkan listener. Listener bisa menerima koneksi dengan berbagai
jenis protocol, spt : IPC, TCP/IP, SPX/IPX ...
Kalau mengggunakan TCP/IP (de-facto), biasanya port 1521 sbg default
port number-nya.
Untuk merubah port numbernya,
1a. Edit file listener.ora (di sisi database server)
Anda sekaligus bisa menambahkan port number yg baru, contoh:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = edjkr2p0)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = edjkr2p0)(PORT = 1234))
)
)
)
(Jangan lupa di save !!!)
1b. Restart listenernya
C:\> lsrnctl stop
C:\> lsrnctl start
atau
C:\> lsrnctl reload
2. Edit tnsnames.ora (di sisi client)
contoh:
DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = edjkr2p0)(PORT = 1234))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
3. Test dari client
C:\> tnsping DATA
C:\> sqlplus scott/[EMAIL PROTECTED]
Bowo
--- In [email protected], Junus Sinuraya
<[EMAIL PROTECTED]> wrote:
>
> I am very sorry, iam Newbies too,saya hendak Tanya Port yang
dioracle itu
> gunanya apa ya?
>
>
> Thanks
>
>
> -----Original Message-----
> From: [email protected] [mailto:indo-
[EMAIL PROTECTED] On
> Behalf Of Rony
> Sent: Wednesday, December 28, 2005 1:12 PM
> To: [email protected]
> Subject: [indo-oracle] Merubah port di Oracle8i
>
> Hey guys..
> saya punya masalah... (maklum newbies)
> Saya pake Oracle 8i dan OS Win2K Adv Server yang mana koneksi ke
client
> menggunakan port 1521
> Gimana caranya biar saya bisa mindah port-nya ke port lain... Saya
coba
> ganti di listener.ora dan tnsnames.ora gak bisa :-)
> Padahal ketika saya coba ping dengan tnsping bisa (saya coba
memakai port
> 412), tapi database tidak bisa diakses seperti hasil capture
saya ::
> ------------------------------------------------------------
> C:\>tnsping DATA
>
> TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 -
Production on
> 28-DEC-20
> 05 13:11:13
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=oracle)
(PORT=412))
> OK (40 msec)
>
> C:\>sqlplus scott/[EMAIL PROTECTED]
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Wed Dec 28 13:12:10
2005
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12514: TNS:listener could not resolve SERVICE_NAME given in
connect
> descriptor
>
> SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting
SQL*Plus
>
> C:\>
> --------------------------------------------------------------
> ato gimana caranya masing-masing database dialokasikan ke port
> sendiri-sendiri (saya punya 3 database)
> Dengan demikian keamanan database dapat lebih secure ..
>
> Segitu aja.. n mohon pencerahannya...
> Thanks
>
> Regards,
>
> Rony
>
>
>
>
>
>
>
>
>
> --
> -----------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
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income homes are not online. Make a difference this holiday season!
http://us.click.yahoo.com/5UeCyC/BWHMAA/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/
