coba di check semua parameter ORACLE_SID di environtment windows , disamakan
dengan
yang ada di /etc/oratab di fedora nya, message nya mengindikasi kan bahwa
ORACLE_SID yang di cari dalam kondisi shutdown...
On 5/11/06, Ketut Natha <[EMAIL PROTECTED]> wrote:
>
> 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
>
>
>
> SPONSORED LINKS
> Membership database software<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=eDDh4hKVCztlkTEeYzirSg> Database
> mortgage software<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=hXxg74XuhXSzegVx-t1xkA> Pda
> database software<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=roR_Z1cY1-GOzqzt3GgyUw> Database
> management software<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=qVd58SCSnEG4iKPrZDnKTA> Oracle
> database administration<http://groups.yahoo.com/gads?t=ms&k=Oracle+database+administration&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=HnkpKGBwHtP2yh9OvVaS3Q> Oracle
> database management<http://groups.yahoo.com/gads?t=ms&k=Oracle+database+management&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=8YpXzkCJ2hlCDM-NY94dXQ>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "indo-oracle<http://groups.yahoo.com/group/indo-oracle>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]<[EMAIL PROTECTED]>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>
[Non-text portions of this message have been removed]
--
-----------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.
