Using Oracle 9.2 on windows 2000 (sp4)

Just installed what looks like a very good product Panda Platinum Internet
Security 2005. When I now try any of my db tools such as Toad I get
"TNSLSNR.exe has generated errors and will be closed by windows etc...."
Toad opens up using the connection but the TNS Listener service is stopped!

Has anyone any ideas as to why this would so this? - if I unistall the
product it works fine again! - nothing on Panda's site regarding trouble
with Oracle - maybe I'm the only person in the entire world running Panda,
Oracle on win 2000?

Tried CONNECT_TIMEOUT_LISTENER=10 at the end of my LISTENER.ORA file but no
difference -

LISTENER.ORA athough as it works without Panda it's probably pointless!

# LISTENER.ORA Network Configuration File:
i:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = p2600)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = i:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dev)
(ORACLE_HOME = i:\oracle\ora92)
(SID_NAME = dev)
)
)

Completely stumped! & preying I don't have to go back to Norton Security

many thanks!

harry

"harry" <spammemothers@yahoo.co.uk> wrote in message news:<v72ld.12826$up1.12738@text.news.blueyonder.c o.uk>...
> Using Oracle 9.2 on windows 2000 (sp4)
>
> Just installed what looks like a very good product Panda Platinum Internet
> Security 2005. When I now try any of my db tools such as Toad I get
> "TNSLSNR.exe has generated errors and will be closed by windows etc...."
> Toad opens up using the connection but the TNS Listener service is stopped!
>
> Has anyone any ideas as to why this would so this? - if I unistall the
> product it works fine again! - nothing on Panda's site regarding trouble
> with Oracle - maybe I'm the only person in the entire world running Panda,
> Oracle on win 2000?
>
> Tried CONNECT_TIMEOUT_LISTENER=10 at the end of my LISTENER.ORA file but no
> difference -
>
> LISTENER.ORA athough as it works without Panda it's probably pointless!
>
> # LISTENER.ORA Network Configuration File:
> i:\oracle\ora92\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = p2600)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = i:\oracle\ora92)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = dev)
> (ORACLE_HOME = i:\oracle\ora92)
> (SID_NAME = dev)
> )
> )
>
> Completely stumped! & preying I don't have to go back to Norton Security
>
> many thanks!
>
> harry

3 things:

1. don't run an external procedure listener unless you have to.
2. run the listener on the loopback interface, if you are only going
to connect to it from the local machine. in the firewall (AV) software
- allow all traffic on the loopback interface
3. connect via bequeath and avoid the listener entirely.

if you want to connect to the listener via tcp, you're going to have
to muck about in the security software settings. your best bet then
might be to use a dedicated port via shared server / dispatcher.

hth.

-bdbafh

harry wrote:

> Using Oracle 9.2 on windows 2000 (sp4)
>
> Just installed what looks like a very good product Panda Platinum Internet
> Security 2005. When I now try any of my db tools such as Toad I get
> "TNSLSNR.exe has generated errors and will be closed by windows etc...."
> Toad opens up using the connection but the TNS Listener service is
> stopped!
>
> Has anyone any ideas as to why this would so this? - if I unistall the
> product it works fine again!
>
> [snip]
>
> harry

My take on this sort of thing is that Oracle has no business being installed
on PCs which are clearly domestic in nature. It deserves dedicated, clean
machines -and preferably ones not exposed to the Internet, and hence viral
dangers.

Which in a domestic setting means: get VMware, and build virtual,
self-contained machines that won't get upset by what you are forced to do
with firewalls and antivirus software to keep XP safe and usable. That also
gives you the opportunity to learn Oracle on a robust, effectively
virus-free, O/S such a Linux.

Details at www.dizwell.com, of course.

Regards
HJR

"harry" <spammemothers@yahoo.co.uk> wrote in message news:<v72ld.12826$up1.12738@text.news.blueyonder.c o.uk>...



> with Oracle - maybe I'm the only person in the entire world running Panda,
> Oracle on win 2000?

You probably are. Get Zonealarm for a firewall and be done with it.
It's also free. As for viruses (virii?), do NOT open any
unsolicited attachements, use a mail tool that stops scripting upfront
(Thunderbird is a good one), do not load pirated software or "warez"
or other stupidity like that, and you'll be more than adequately
protected. As for spyware, download AdAware (once again: free) and
clean up your system. Use a proper browser (Firefox), not that
Microsoft security sieve. Bingo: no more problems.

Wanna break these rules and give yourself a warm feeling
you're safe if you spend money in unnecessary products?
No worries, your choice. But stop running Oracle in such a system.


>
> Completely stumped! & preying I don't have to go back to Norton Security

Don't. All those "security products" are nothing more nothing less
than expensive substitutes for what you can do yourself.