Re: connecting automatically as sys

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Sun, 25 Jul 2004 03:13:58 GMT
Message-ID: <WzFMc.88024$Rf.50118@edtnps84>

Gerry Sinkiewicz wrote:

>>
>> SQLPLUS "/ AS SYSDBA"
>>

>
> sqlplus /"as sysdba" (a small point).

On my systems (Windows 2000, United Linux 1.0 and Solaris 8) it does work the way I wrote it - adjusting for lowercase sqlplus executables as appropriate. It ALSO works your way on the UL1/SLES8 (I have not consciously tried it on the others).

Thinking for a millibleem .... the key point is to get the 'as sysdba' transmitted as part of the userid arg. As long as sqlplus parses on the ' as ' keyword we are OK, provided we pass the whole set of information (user, "slash" password "as sysdba") as a single arg.

Your method works but could run into an issue if Unix' IFS is set to '/' or potentially if you start using a password, as in

sqlplus sys/mypass"as sysdba"

Your experience on your OS appreciated. BTW - which OS is it?

/Hans Received on Sat Jul 24 2004 - 22:13:58 CDT