Re: Permission denied executing sqlplus on Windows
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 04 Jan 2004 15:12:38 -0800
Message-ID: <1073257871.536886_at_yasure>
>
>
>
>
> Daniel,
>
> 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
>
Date: Sun, 04 Jan 2004 15:12:38 -0800
Message-ID: <1073257871.536886_at_yasure>
Rick Denoire wrote:
> 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,
>
> 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
>
Got it.
Check the environment variables ORACLE_HOME and ORACLE_SID. One or both is not set for the user.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Mon Jan 05 2004 - 00:12:38 CET