Re: Can't connect to 8.1.7!?

Already tried all that, listener is up & running, as is database. Can connect locally to it no problem at all. But I get tns timing out trying it from elsewhere, and I cant ping the agent thru OEM, even though its running, (according to services, but not dbsnmp_status)

Right now I'm trying to track down the network admin to see what else he may have done when he gave the machine a static IP address, althoug I can't see why that would cause it to fail.

"Robert Malikian" <malikian_at_malikian.homechoice.co.uk> wrote in message news:3bf2f087_at_news1.homechoice.co.uk...
> Got a CMD prompt
> lsnrctl status
> if not okay then
> lsnrctl start
> set oracle_sid=Your_sid_name
> svrmgrl
> > connect internal
> select * from v$database;
> if up then check the client's tnsnames.ora otherwise
> startup pfile=d:\oracle\Your_sid_name\pfile\init.ora
> that should do it.
> Good luck
> Robert
> "Glen A Stromquist" <stromqgl_at_nospa_alpac.ca> wrote in message
> news:JOBI7.4278$c4.613819_at_news0.telusplanet.net...
> > I just installed an 8.1.7 DB on win2k, everything was working good,
could
> > connect via sqlplus from a remote machine, and had it set up in OEM on a
> > remote machine with a dbrun event. Now I cant connect at all, the
listener
> > is up & running, but I can't tnsping the machine. The services show the
> > agent is running, but when I type dbsnmp_status from LSNRCTL it says the
> db
> > subagent is not started, if I type dbsnmp_start it returns me to the
> LSNRCTL
> > prompt but nothing has happened. When I look under task manager it shows
> > dbsnmp.exe is a running process.
> >
> > I suspect perhaps that one of the network guys may have assigned a
static
> IP
> > address to the machine over the weekend, other than that nothing has
> changed
> > to my knowledge. The machine name remained the same, which is how I set
it
> > up with net8.
> >
> > When I try to get OEM to refresh the node, it fails.
> >
> > ideas?
> >
> >
>
>
Received on Wed Nov 14 2001 - 17:03:36 CST