this was replaced in the previous email.
connect sys/password @ tnsname2.domainname.com as sysdba
-------------------------------------------------------
Mir M. Mirhashimali
Oracle Systems Manager
Web Services, Rice University
(713) 348-6365
-------------------------------------------------------
----- Original Message -----
From: "Mir M. Mirhashimali" <[Email address protected]
To: "LazyDBA Discussion" <[Email address protected] " (Frank Dodgers)"
<oracledba-ezmlmshield-x29943717.[Email address protected]
Sent: Thursday, November 11, 2004 5:15 PM
Subject: Re: startup after shutdown abort
> Frank,
>
> try this create 2 tnsnames entries like example
>
> tnsname1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.domainname.com)(PORT =
> 1521))
> )
> (CONNECT_DATA = (SERVICE_NAME = dbname.domainname.com))
> )
>
>
> and
>
> tnsname2.domainname.com =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.domainname.com)(PORT =
> 1521))
> )
> (CONNECT_DATA = (SERVICE_NAME = dbname.domainname.com))
> )
>
>
> then from sql*plus try this
>
> connect sys/[Email Address Removed] as sysdba
>
> connect sys/[Email address protected] as sysdba
>
> Hope this helps
>
> -------------------------------------------------------
> Mir M. Mirhashimali
> Oracle Systems Manager
> Web Services, Rice University
> (713) 348-6365
> -------------------------------------------------------
>
> ----- Original Message -----
> From: "Mir M. Mirhashimali" <[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected] " (Frank Dodgers)"
> <oracledba-ezmlmshield-x29943717.[Email address protected]
> Sent: Thursday, November 11, 2004 3:36 PM
> Subject: Re: startup after shutdown abort
>
>
> > 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