Re: Windows non-administrative prompt can not start sql plus

Jeffrey,

The SysInternals utility ProcMon is excellent for logging OS calls made by a process.

Download it, launch it, pause capturing events, filter for the executable of interest (contains sqlplus.exe) enable capturing and fire up SQL plus. Pause capturing. Save the log file as .pml and as .csv. Search the resulting .csv file with your text processing shell of choice for errors.

ProcMon is likely going to require admin privs which is leading to the error condition. Deadlock detected.

Hth.

Paul

On Mon, Apr 15, 2019, 2:19 PM Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> wrote:

> On Windows 2012 server with an Oracle client installed accessing a remote
> database.
>
> From a non-adminstrator command prompt, sqlplus returns access is denied.
>
> From a administrator command prompt, sqlplus start.
>
> I know it is a permissions issue but what?
>
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
>

--
http://www.freelists.org/webpage/oracle-l