Re: Permission denied executing sqlplus on Windows

[Quoted] Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>To diagnose problems it is best to not use Windows GUI.

>Go to a DOS prompt, navigate to the Oracle BIN directory and perform the
>following:
>
>1. lsnrctl status
>2. if not started lsnrctl start
>3. sqlplus /nolog
>4. conn / as sysdba
>5. select count(*) from tab$;
>6. if database not started shutdown followed by startup
>
>Record any error messages.
>
>The above assumes you are logged onto the machine as the same Windows
>account as the one that installed the Oracle software.
>
>Check in Control Panel, Users and Passwords, and make sure the Windows
>account you are using is a member of the ORA_DBA group.

Daniel,

[Quoted] Everything works fine. The problem is not whether the DB is up and running and if it is "healthy".

Logged in to Windows using a "normal" account, which is not in the ORA_DBA group, no tool (GUI or not GUI) can be used, it is not found or the permissions are missing. You got it now?

Regards
Rico Received on Sun Jan 04 2004 - 19:15:50 CET