Re: SQLPlus and DSL internet connection in local usage
Date: Sat, 13 Mar 2004 19:33:30 +0200
Message-ID: <40534564_1_at_news.dnainternet.net>
[Quoted] Hello again!
I have Windows XP Pro version.
Here are my *.ora files. I did not find anything amazing there
but after couple of installations the problem still exists :(
Could this be a listener problem?
br
Pete
# SQLNET.ORA Network Configuration File: e:\oracle\ora91\network\admin\sqlnet.ora # Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) # TNSNAMES.ORA Network Configuration File: e:\oracle\ora91\network\admin\tnsnames.ora # Generated by Oracle configuration tools. # mikko-0jdq3imz1 is my PC's Windows computername
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mikko-0jdq3imz1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
MIKKODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mikko-0jdq3imz1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mikkodb)
)
)
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1079192163.20784_at_yasure...
> Comments in-line.
>
> Pete wrote:
> > I have newest version of both Windows XP and Oracle 9i (Personal
Edition).
> > DSL internet connection should not have anything to do with
> > this problem. But it seems to be so that if you install Oracle in your
> > personal PC Oracle starts to look "something" from internet if you are
> > connected
> > into it.
> > For clearyfying this I'm not running Oracle in office now, I'm running
> > it at home to test some SQL scripts.
>
> I'll spell it out ... XP Home or XP Professional? I'm guessing Home and
> Home is not supported. It works most of the time but not always.
>> >
> >>Do yo have a DBA and if so why hasn't that person helped you?
> > Haven't hired a DBA for home ;)
>
> Except the on in the mirror. ;-)
>
> > I have another PC here home too running SQL Server. It's also connected
to
> > internet and I have no problem running it locally in my PC.
>
> Post a copy of your SQLNET.ORA an TNSNAMES.ORA that is likely where the
> problem is.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
> Received on Sat Mar 13 2004 - 18:33:30 CET