1. konek ke DB dari server
2. cek instans
SELECT HOST_NAME, LOGINS, STATUS, DATABASE_STATUS, ACTIVE_STATE,
SHUTDOWN_PENDING FROM v$instance;
HOST_NAME LOGINS STATUS DATABASE_STATUS ACTIVE_ST SHU
---------- ---------- ------------ ----------------- --------- ---
myhost ALLOWED OPEN ACTIVE NORMAL NO
3. jika status tidak demikian, coba SHUTDOWN kemudian STARTUP lagi
4. untuk koneksi dari Client ke Server dgn TNSNAMES
cara termudah adalah: copy kan file TNSNAMES.ORA ke client
dan untuk SQLNET.ORA coba nonaktifkan yg ini
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
selamat mencoba,
ferry sends.
----- Original Message -----
From: "Ketut Natha" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, May 11, 2006 1:51 PM
Subject: Re: [indo-oracle] tanya: connect to 10G on Fedora4
pak ardian,
tnsping dari ora client 8.1.7
D:\ora81\bin>tnsping dev10g
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on
11-MAY-2006 13:19:38
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=10.8.9.159)(PORT=1521))
OK (10 msec)
D:\ora81\bin>
klo di server :
LSNRCTL> start LISTENERDEV10G
Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is
/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to
/oracle/product/10.2.0/db_1/network/log/listenerdev10g.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nathafedora)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENERDEV10G
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 11-MAY-2006 11:15:31
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File
/oracle/product/10.2.0/db_1/network/log/listenerdev10g.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nathafedora)(PORT=1521)))
Services Summary...
Service "DEV10G" has 1 instance(s).
Instance "DEV10G", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
kondisi listener spt diatas.
dari server saya dapat konect sebagaimana mestinya,..
kira2 masalhnya dimana ya?
thanks,
On 5/11/06, absantoso <[EMAIL PROTECTED]> wrote:
> pak ketut,
> coba di check apakah listener di fedora nya sudah di konfigurasi , dan
> konfigurasi tnsnames.ora di client nya , bisa di check dulu dengan
> c:\tnsping <connectstring> (enter)
> lalu apakah ada firewall yang aktfif dari fedora nya ,
>
> login dari server tanpa connect string, menggunakan IPC, dan tidak perlu
> connect string juga bisa connect..
>
> salaam,
> ardian
>
>
--
-----------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
--
-----------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
SPONSORED LINKS
| Membership database software | Database mortgage software | Pda database software |
| Database management software | Oracle database administration | Oracle database management |
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
