I was experimenting with sqlplus -prelim option, trying to “bypass” connect / as sysdba part from command sequence by launching sqlplus under System account (the same account Oracle service is running under). The problem was that I was working remotely within Remote Desktop session, so an old trick:


cmd> at 12:00 /interactive cmd.exe


didn’t work. You have to seat at console to see the command prompt interactively.

A quick search on net revealed a quick fix for the problem:


cmd> psexec -i -s cmd.exe


Resulting in command prompt that runs under System account:

PsExec v1.72 - Execute processes remotely
Copyright (C) 2001-2006 Mark Russinovich
Sysinternals - www.sysinternals.com

C:\WINDOWS\system32>


You can download the latest psexec version from:
http://live.sysinternals.com/