connect as sysdba

From: Terry Dykstra <dontreply_tdykstra_at_cfol.ab.ca>
Date: Thu, 10 Jan 2002 18:08:57 GMT
Message-ID: <ZMk%7.20467$e4.3841539@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 - 12:08:57 CST