Re: Oracle 10g - username and password, Scott/Tiger LOCKED

On Tue, 26 Jun 2007 20:30:57 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>ddog wrote:
>> I've installed Oracle 10g on my Windows XP Pro PC. During the config.
>> process I was given the option to set locking on various accounts. I
>> left all of them as they were and now I can't get in to anything - I
>> have no username and password combo that I know of to log in with. Is
>> there a way around this or do I have to uninstall everything,
>> reinstall it and unlock all of the users and pray that one of them is
>> able to log in?
>>
>> I've looked in the TSNAMES.ora file hoping to find something useful
>> there but found nothing. I've a developer not a DBA and all I want to
>> do is create a database, add tables etc. and manipulate it through
>> JDBC.
>>
>> Hopefully I'm just missing something obvious.
>>
>> Any help is greatly appreciated!
>
>conn / as sysdba
>alter user scott account unlock identified by tiger;

        Sure is a lot easier to deal with schema owners in Oracle than it is in MySQL.

        If you just want to mess around with a database using Java, maybe HSQLDB would be easier. Received on Wed Jun 27 2007 - 19:44:00 CDT