startup force;
shutdown immediate;
startup;

hth

-------------------------------------------------------
Mir M. Mirhashimali
Oracle Systems Manager
Web Services, Rice University
(713) 348-6365
-------------------------------------------------------

----- Original Message -----
From: " (Frank Dodgers)"
<oracledba-ezmlmshield-x29943717.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, November 11, 2004 3:31 PM
Subject: Re: startup after shutdown abort


> "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
> >
>
>
> --------
> 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