"tnsping xxxxx" works fine so listener is OK.

cannot connect directly to linux box for political reasons.

"shutdown abort" worked while connected as sysdba, why wouldn't a "startup" work? Is it a 10g thing?

Thanks very much any additional 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]


-------------- Original message from "Michael Porter " <oracledba-ezmlmshield-x30007569.[Email address protected] --------------


> 1) try again and record the errors OR
> 2) verify the listener is UP OR
> 3) try connecting locally instead of thru listener if you can
>
> M
>
> >>> " (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
>

Oracle LazyDBA home page