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