Re: Can't get logged into database

From: gazzag <gareth_at_jamms.org>
Date: 29 Dec 2005 05:26:54 -0800
Message-ID: <1135862814.214098.162470@g44g2000cwa.googlegroups.com>

>> 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".

Once you log in to SQL*Plus successfully as MANAGER, I'd change it's password to something other than the default with the following command:

alter user system identified by <new_password>;

HTH --g Received on Thu Dec 29 2005 - 07:26:54 CST