Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connect as sysdba

Re: connect as sysdba

From: Ajay <ajay_at_bhudevi.com.au>
Date: Fri, 11 Jan 2002 11:33:47 +1000
Message-ID: <3c3e4207$0$31690$afc38c87@news.optusnet.com.au>


Terry,
What was the missing configuration setting.

"Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> wrote in message news:P6p%7.17693$O3.4585879_at_news1.telusplanet.net...
> Ignore this message. I had a configuration error. Using sqlplus I can
use
> the exact same method as server manager.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> "Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> wrote in message
> news:ZMk%7.20467$e4.3841539_at_news0.telusplanet.net...
> > I'm converting my svrmgrl scripts to use sqlplus.
> > using server manager I would code a batch file like:
> > set oracle_sid=ABCD
> > svrmgrl.exe
> >
> > after which I use 'connect / as sysdba'
> >
> > With sqlplus (using /nolog switch) this doesn't work. I have to use
> > 'connect /@ABCDSERVICE as sysdba'
> >
> > Does this mean that I can't get in if the listener is not running?
> >
> > Environment: W2K, Oracle 817 SE
> >
> > --
> > Terry Dykstra
> > Canadian Forest Oil Ltd.
> >
> >
>
>
Received on Thu Jan 10 2002 - 19:33:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US