Re: Can't get logged into database

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 29 Dec 2005 14:47:33 +0100
Message-ID: <dp0op7$i27$1@news2.zwoll1.ov.home.nl>

gazzag wrote:

>>>When I created the database I selected a password, yet I don't know what
>>>value to put into the "User Name" field.

>
>
> As others have said, the password you supplied during database creation
> was the SYS password. Unlike what others have said, I would not use
> this account for much other than starting and stopping the database or
> running Oracle-supplied packages.
>
> The user you should use for general database administration should be
> SYSTEM. The default password for the system user will be "manager".

Since 9i, the installer forces the use of either one password, in which case the SYS and SYSTEM password would be the same (and just as unknown), or different passwords. iirc, MANAGER for SYSTEM is banned (and checked for), just like CHANGE_ON_INSTALL for SYS.

Trying to log on from a privileged OS account (/ as sysdba) does not require any passwords, but does indeed give all power (drop database, anyone?) to the new oracle user. Can only agree with the statement SYS should only be used when necessary.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Thu Dec 29 2005 - 07:47:33 CST