Re: how do I chg administrator pwd on oracle 11g 11.2.0.1.0 on Windows Professional 7?

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 11 Mar 2012 23:09:15 +0000 (UTC)
Message-ID: <pan.2012.03.11.23.09.15_at_gmail.com>

On Sun, 11 Mar 2012 15:28:34 -0700, Ken Quirici wrote:

> I don't have sql developer connecting to the database as SYS, but as
> another user I created when I
> downloaded Oracle 11 and installed it.
>
> However the question is moot because my PC is fried. Everytime I boot it
> up I get a message

Can you do me a favor: please execute the SQL below and post the result:

select sys_context('userenv','current_user') from dual;

This is how this should look:
[mgogala_at_medo ~]$ sqlplus scott/tiger_at_local

SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 11 19:04:17 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select sys_context('userenv','current_user') from dual;

SYS_CONTEXT('USERENV','CURRENT_USER')

---

SCOTT Elapsed: 00:00:00.00
SQL> Here, I am connecting from my laptop to the database on my desktop as user SCOTT. I can do the same thing with the SQL*Developer but result will be the same. In order to be help you out, I would need the username you are using to connect to the database.

-- 
http://mgogala.byethost5.com

Received on Sun Mar 11 2012 - 18:09:15 CDT