Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g - username and password, Scott/Tiger LOCKED

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

From: EdStevens <quetico_man_at_yahoo.com>
Date: Wed, 27 Jun 2007 05:13:40 -0700
Message-ID: <1182946420.331058.118370@n2g2000hse.googlegroups.com>


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. Received on Wed Jun 27 2007 - 07:13:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US