It sounds like you need to start lsnrctl from the command line

Ensure the environment variable ORACLE_SID is set

lsnrctl start

sqlplus /nolog

connect / as sysdba

You should connect to an idle instance.

Good luck!

Gus
> >> >>> " (Frank Dodgers)"
> >> > 04:06PM >>>
> >> From windows SQL*Plus screen (not cmd) trying to connect to an 10 G
> >> instance on a linux box
> >>
> >> entered "shutdown abort" and the db shut down as expected
> >> entered "startup" and got a TNS error (sorry did not record which one)
> >> entered "connect /[Email Address Removed] as sysdba" and got a TNS error (sorry
> >> did not record which one)
> >> exited sql*plus gui and opened a cmd window on windows box
> >> entered "sqlplus /[Email Address Removed] as sysdba" and got a TNS error (sorry did
> >> not record which one)
> >>
> >> basically I cannot get reconnected to an idle instance as I was
> >> initially prior to the shutdown abort -- your help is appreciated.
> >>
> >> --
> >> Thank You,
> >> Frank Dodgers
> >> Oracle & DB2 Certified
> >> Evergreen Information Systems
> >> -303-674-0433 Home
> >> -303-810-6625 Cell
> >> frank.[Email address protected]
> >>
> >>
> >> --------
> >> website: http://www.LazyDBA.com
> >> Please don't reply to RTFM questions
> >> Oracle documentation is here: http://tahiti.oracle.com
> >> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> >> To subscribe: see http://www.lazydba.com
> >> By using this list you agree to these
> >> terms:http://www.lazydba.com/legal.html
> >>
> >>
> >>
> >> --------
> >> website: http://www.LazyDBA.com
> >> Please don't reply to RTFM questions
> >> Oracle documentation is here: http://tahiti.oracle.com
> >> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> >> To subscribe: see http://www.lazydba.com
> >> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> >>
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> >
>
>
> --
> Todd Pepling, Oracle DBA
> 420 Vineyard Dr.
> Gibsonia, PA 15044
> email: [Email address protected]
> home: 724-444-6403
> cell: 412-779-1597
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page