The spfile in 9i facilitates this, haven't got to 10g yet but I would
imagine it has being carried forward.

miles

-----Original Message-----
From: Sangster Simon
[mailto:oracledba-ezmlmshield-x80300534.[Email address protected]
Sent: 12 November 2004 10:48
To: LazyDBA Discussion
Subject: RE: startup after shutdown abort

No experience with the wonders of 10g (yet) but can you connect to an
instance that is shutdown via SQL*Plus?

Si

-----Original Message-----
From: Todd Pepling
[mailto:oracledba-ezmlmshield-x86845269.[Email address protected]
Sent: Thursday, November 11, 2004 9:53 PM
To: LazyDBA Discussion
Subject: Re: startup after shutdown abort


You may need a local copy of the init.ora. Haven't tried in a long time,
but I think
that's what I used to need to do.

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


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

Oracle LazyDBA home page