Re: Username and Password - Newbie

You will get 3121 when you are running on a system without a database, usually a client.
In that case you will need to use the syntax username/password_at_service where <service> has been defined in tnsnames.ora. Right now, it looks like you just started 'somewhere' and there's little clue in your post what is going on at your side. Can you confirm you have a database running at all?

You need to have a database on (preferably) a server different from the system designer/2000 is installed on, whether that different server is NT or any Unix port is irrelevant.

Can you verify one way or another you have installed the Oracle Server software or Personal Oracle on any of the systems available to you?

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address


"Stéphane Desautels" <sdesautels_at_videotron.ca> wrote in message
news:DMzG7.1553$dJ3.135114_at_wagner.videotron.net...


> Ok Mark, I just tried logging in with sys/change_on_install and

> system/manager.  In both cases, I'm getting error ORA-03121 - No interface

> driver connected - function not performed (same as when I try other

> user/pass combinations).

>

> I don't understand what's going on.

>

>

>

> "Mark Styles" <news_at_lambic.co.uk> wrote in message

> news:icdlut0casvnkp4buft8ct5ka30ff8ftqb_at_4ax.com...

> > On Thu, 8 Nov 2001 11:27:04 -0500, "Stéphane Desautels"

> > <sdesautels_at_videotron.ca> wrote:

> > >If I understand correctly, I should run SQP PLUS and enter sys as

> username

> > >and change_on_install as password.  Then I guess I'll be prompted to

> change

> > >username and password immediately right?

> >

> > Nope. You'll then be logged in, it's up to you to change the password.

> >

> > >What do you mean "once the database has been installed"?  Isn't the

> database

> > >created automatically when I installed Developper 2000?

> >

> > No, Developer 2000 is a completely separate product from the Oracle

> > Server database engine. If you don't have access to a database,

> > Developer 2000 will not be much use to you.

> >

>

>