Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g47g2000cwa.googlegroups.com!not-for-mail
From: fitzjarrell@cox.net
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle Enterprise Manager Console won't let me login as SYS, Win XP
Date: 9 Sep 2005 13:33:06 -0700
Organization: http://groups.google.com
Lines: 29
Message-ID: <1126297986.697116.189060@g47g2000cwa.googlegroups.com>
References: <1126289118.880533.25420@g43g2000cwa.googlegroups.com>
NNTP-Posting-Host: 68.95.47.225
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126297992 3875 127.0.0.1 (9 Sep 2005 20:33:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 9 Sep 2005 20:33:12 +0000 (UTC)
In-Reply-To: <1126289118.880533.25420@g43g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g47g2000cwa.googlegroups.com; posting-host=68.95.47.225;
   posting-account=B_KC8Q0AAADcSTVy4DZ59utFaLrVLOo4
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251207


barneytoe wrote:
> I want to stop my DB, but OEMC won't let me login, ora version 9.2.
>
> Am a newbie to managing my own DB.
>
> I'm trying to login as SYS and it refuses. I can switch over to my
> DBArtisan SQL tool and it lets me login fine with same user/pwd combo.
>
> SQLPLUS also doesn't let me login as SYS. Says invalid user/pwd.
>
> Maybe an ORACLE_SID env var prob? It's not currently set.
>
> thanks.
>
> chris

DBArtisan is using a tns alias, is it not?  Are you using the same
connect string with OEMC?  Likely not, and ORACLE_SID should then be
set (it should be set on the local DB server anyway).  Also, SYS as
SYSDBA is the only way, by default, you can use the SYS account, unless
you have O7_DIcTIONARY_AVAILABILITY set to TRUE (you shouldn't).

Please post the login sequence you're attempting to use, so we will
know exactly what you ARE doing and what you may be missing.


David Fitzjarrell