PassWords
Oracle 10g Install Issues

I have set up a 10g database and don't seem to be able to limit the logins. Case and Point any one can login through PL/SQL Plus using any combination of login ID or Passwords. All security seems to be lost. Anyone got any ideas?



-question by ed the lost

Go back and do the instalation slowly and make sure you fill in al the spaces because you may have missed something out

Not sure I understant. system/manager can login, sys/sys can login, scott/tiger can login, this is the normal case.
or do you mean that you type any username and any password (like whoknows/nobody or jeopardy/nothing) and it works ?

Creating Admin Account
Oracle 10g Install Issues

I have installed the software using the 2 disk set that came with the book. I however am at no time prompted to set up an admin account so that I can enter SQL plus to start scripting to create databases and tables etc. All applications in the development suite require a login to begin so what do I use initially before setting up any accounts?

-question by Masterson

I'm not terribly familiar with Oracle, however:

Typically, Database systems have two methods for authentication. Usually when you set up a database you can connect via SQL Authentication (at least in the case of MS SSMS) which means that you have created a database with unique authentication rights. Usually this would be done when setting up a New Database....

As a side note, make sure you have created a database that you are trying to connect to.

The second method of authentication, and I believe Oracle supports this, no idea why it wouldn't, is Windows Authentication, which is usually automated, however you might need to provide this information, which would be the same as the account which you accessed the computer with.


If all of this sounds greek to you, You can always try Admin/Pass, Administrator/Password, etc typical default entries..

and then as a last resort you could call Oracle support and get your question answered there.

Best Regards,
The Doc.

I see thet your really are not familiar with Oracle passwords: none of these are standard nor popular Oracle passwords.
And, of course, remember that the oracle admin can at any moment change any Oracle password. No need to know the passwords, simply assign the new ones.

That is what i stated, Yes. That was also something I offered as a last option if nothing else worked. The User's question was in regards to the fact that he could not even access administrative options, so he can't change passwords, so, he can't assign new ones, so he does need to know them.

Now, while it seems like he just needs to familiarize himself with the program so that he can change these settings, as I've never heard of software that requires passwords to even use it locally (that weren't set by the user in a prompted screen). But based on his statement:



I assumed that he had read through the user manual for their possible default passwords (finding none) and was then turning to us for suggestions.
That's what I gave him, a suggestion, a tentative one at that.

On another note:

I'd think that you would find that a lot of software in general uses Admin/Pass (or variations) as default (not standard or popular) password settings, at least I have in my experiences.

Regards,
The Doc.

Edit:

As another option, you might try (directed at FeedBacker) to setup an account even without knowing the passwords, without seeing your screen its hard to tell, but the initial login might create the account you are trying to set up, anyway.

This post has been edited by Doc.h0llyw00d: Mar 24 2008, 06:32 PM

Answer to development suite problem
Oracle 10g Install Issues

Replying to FeedbackerReplying to Feedbacker

Marserson, in regards to your question (as below)
Creating Admin Account
Oracle 10g Install Issues

I have installed the software using the 2 disk set that came with the book. I however am at no time prompted to set up an admin account so that I can enter SQL plus to start scripting to create databases and tables etc. All applications in the development suite require a login to begin so what do I use initially before setting up any accounts?

-question by Masterson


I had the same problem (having installed the deveopment suite from the 2 disk set - and spent hours trying to work out what was going on)
Then I realised that the development suite doesn't actually contain the oracle database software (it only contains other tools to work with it), thats why you didn't at any stage get asked to configure the default DB.

WHat you need to do is install oracle database software also (if you go to the oracle site you can download oracle express for free), once this is installed you can then access the database through that software and if you configure the development suite (using the net configuration assistant) you will be able to access all those tools correctly)

I hope this helps

Regards

- The General

-reply by The General