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

On Jun 27, 9:07 am, ddog <wgblack..._at_yahoo.com> wrote:
> On Jun 27, 7:13 am, EdStevens <quetico_..._at_yahoo.com> wrote:
>
>
>
> > On Jun 27, 6:53 am, ddog <wgblack..._at_yahoo.com> wrote:
>
> > > On Jun 26, 10:58 pm, Sinardy Xing <Oracle.RD..._at_gmail.com> wrote:
>
> > > > On Jun 27, 10:49 am, ddog <wgblack..._at_yahoo.com> 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!
>
> > > > 1. If you see question asking you whether you should lock the account
> > > > or not, then you have a instance already, you don't have to create
> > > > database.
> > > > 2. there is connection directly to the instance without have to go
> > > > through TNS or SQLNET simply
> > > > sqlplus / as sysdba
> > > > 3. you can just create a user then start work from it. try
> > > > following...
> > > > sqlplus / as sysdba
> > > > grant dba to ddog identified by ddog;
> > > > connect ddog/ddog
> > > > create table mytable as select * from dba_users;
> > > > drop table mytable;
>
> > > Thanks for the replies! I tried sqlplus username=sysdba
> > > What is the password for sysdba? I tried the password that I entered
> > > during the initial installation and it doesn't work.
>
> > > Thanks again....
>
> > Well, the syntax is NOT "sqlplus username=sysdba". It is as previous
> > posters already said ... "sqlplus / as sysdba"
> > If you are logged on to the server with an account that is a member of
> > the dba group (I believe on windows it is "ora_dba") this will connect
> > you with all power.
>
> I know that's not the syntax. This is ridiculous.

Sorry. It wasn't at all obvious from your post that you knew that. And we have seen posters here who insist on trying to use syntax they feel *should* be correct instead of what *is* correct.

>I think I'll have
> better luck with
> MS SQL Server. Of course Oracle doesn't have an uninstall
> program..........

I guess you didn't find the 'uninstall' button on the Oracle Universal Installer.

> it's a miracle anyone uses it.

Why? Because you actually have to learn something about it, instead of just popping in a CD and start clicking?
>
> Have Fun!
Received on Thu Jun 28 2007 - 07:47:56 CDT