Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: connect as sysdba
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...Received on Thu Jan 10 2002 - 17:05:19 CST
> 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.
>
>