Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't get logged into database
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
![]() |
![]() |