Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't get logged into database

Re: Can't get logged into database

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 28 Dec 2005 20:16:01 +0100
Message-ID: <dounl4$lkf$2@news1.zwoll1.ov.home.nl>


Si wrote:
> First of all I have to say that I completely new to Oracle so this is a
> "noob" question.
>
> I cannot get logged onto my newly created database. When I open SQL*Plus I
> am presented with a login box saying User Name, Password and Host String.
> When I created the database I selected a password, yet I don't know what
> value to put into the "User Name" field.
>
> I also cannot get logged into Enterprise Manager for this database.
>
> I haven't created any users. Where do I do this and how do I log into the
> database?
>
>

Platform?
Version?
Error code(s)?

set oracle_sid=<your_sid>
sqlplus / as sysdba
select username from dba_users;
alter user scott identified by tiger;

Just examples, of course! Alter to fit your environment!

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Dec 28 2005 - 13:16:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US