setelah sy ulang lagi mengkon-pigur
/etc/init.d/dbora
/etc/oratab
bash_profile
terus restart..si pinguin
masalah beres,..
referensi link :
http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnFedora4.php
thanks all,
regards
IKS
setelahinimaukemanakita?
On 5/12/06, Ferry <[EMAIL PROTECTED]> wrote:
> pak Ketut,
> 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
> 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.
