| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Check this
tnsping from the pc works.
in the listener log file the pc connections are logged a here is a copy of the entry -
31-MAY-00 11:31:10 *
(CONNECT_DATA=(SID=UNET)(CID=(PROGRAM=C:\ORAWIN95\BIN\PLUS80W.EXE)(HOST=SAJ1)(USER=sajidi)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=194.119.129.98)(PORT=1315)) * establish *
UNET * 0
But in the client (pc) sqlplus it says Oracle not available.
Saj
-- U-NET Ltd a VIA NET.WORKS Inc company Sajid Iqbal | Mail : sajid_at_u-net.net Database DBA/Developer | Ext : 4485 U-NET Ltd | ICQ : 43903417 Warrington, Cheshire, UK | On Wed, 31 May 2000, ODell, Charles wrote:Received on Wed May 31 2000 - 05:32:32 CDT
> By successful, you mean the local connections made on the Solaris
> machine are showing up. Do you see any attempts from the PC machine?
>
> Do you have tnsping?
>
>
>
> -----Original Message-----
> From: Sajid Iqbal [mailto:sajid_at_u-net.net]
> Sent: Wednesday, May 31, 2000 6:18 AM
> To: ODell, Charles
> Subject: RE: Check this
>
>
>
> Yes sorry.. the server is Solaris Oracle 8.0.4.
>
> The client is Win98 se . SQL*Plus: Release 8.0.5.0.0
>
> It appears as though the problem is on the server side.. as connection are
> logged as successfull (on the server) in the listener log file.
>
> Thanks
>
> Saj
>
> --
> U-NET Ltd a VIA NET.WORKS Inc company
> Sajid Iqbal | Mail : sajid_at_u-net.net
> Database DBA/Developer | Ext : 4485
> U-NET Ltd | ICQ : 43903417
> Warrington, Cheshire, UK |
>
>
> On Wed, 31 May 2000, ODell, Charles wrote:
>
> > I thought you said the PC was having trouble finding the Oracle
> > database.
> >
> > What version of SQLPlus are you using?
> >
> > -----Original Message-----
> > From: Sajid Iqbal [mailto:sajid_at_u-net.net]
> > Sent: Wednesday, May 31, 2000 5:03 AM
> > To: ODell, Charles
> > Subject: Re: Check this
> >
> >
> >
> > I'm on Solaris !
> >
> > --
> > U-NET Ltd a VIA NET.WORKS Inc company
> > Sajid Iqbal | Mail : sajid_at_u-net.net
> > Database DBA/Developer | Ext : 4485
> > U-NET Ltd | ICQ : 43903417
> > Warrington, Cheshire, UK |
> >
> >
> > On Tue, 30 May 2000, ODell, Charles wrote:
> >
> > > See if you have the file:
> > >
> > > c:\winnt (or windows)\system32\drivers\etc\hosts
> > >
> > > In there put the ip address of the machine you are trying to reach, like
> > so:
> > >
> > >
> > > 127.0.0.1 localhost #This will always be here
> > > ###.###.###.### hroc #hroc at Chantilly
> > >
> > > and then also in the same directory check your services:
> > >
> > > kpop 1109/tcp # Pop with Kerberos
> > > phone 1167/udp
> > > oracle 1521/tcp #Oracle SQL*Net version
> 2
> > > ingreslock 1524/tcp
> > > oracle 1525/tcp #Oracle SQL*Net version
> 1
> > > maze 1666/udp
> > > nfs 2049/udp # sun nfs
> > > knetd 2053/tcp # Kerberos
> de-multiplexor
 |
 |