Re: oracle 10g installation - access not permitted?
Date: Mon, 04 Jun 2007 16:05:05 +0200
Message-ID: <pan.2007.06.04.14.05.03.648823_at_yahoo.com>
[Quoted] On Mon, 04 Jun 2007 06:41:17 -0700, sybrandb wrote:
> On Jun 4, 3:17 pm, "Charles T. Smith" <cts.priv..._at_yahoo.com> wrote:
>> On Mon, 04 Jun 2007 04:14:08 -0700, sybrandb wrote:
>> > On Jun 4, 11:36 am, "Charles T. Smith" <cts.priv..._at_yahoo.com> wrote:
>> >> On Sat, 02 Jun 2007 21:00:26 +0200, Frank van Bortel wrote:
>> >> > -----BEGIN PGP SIGNED MESSAGE-----
>> >> > Hash: SHA1
>>
>> >> > Charles T. Smith wrote:
>>
>> >> >> oh! Is that the explanation? I've installed the server, but in
>> >> >> order to have non-oinstall users use it, I need to also install
>> >> >> the client?
>>
>> >> >> Where is the client? I don't find it onwww.oracle.com-except
>> >> >> something for linux - but I'm running solaris.
>>
>> >> > There's the possibility to install "client only" from every server
>> >> > CD I've seen so far (which did not include Solaris...) It's still a
>> >> > bold 200MB or something like that.
>>
>> >> I still think there's something fishy here. I can use sqlplus from
>> >> the account where oracle is loaded, I just can't use it from other
>> >> accounts - without manually intervening. Considering the level of
>> >> professionalism that oracle apparently aspires to, I suspect this
>> >> would be a bug ... if it weren't an operator error.
>>
>> >> > And of course there's this;
>> >> >http://www.oracle.com/technology/software/tech/oci/instantclient/inde...
>>
>> >> No, that's even more of the same. I want to use what's already
>> >> there. When you first mentioned client install, I thought it might
>> >> just add a different configuration. But a whole new 20 meg. or
>> >> db-less install... no, I don't think that's it.
>>
>> >> > - --
>> >> > Regards,
>> >> > Frank van Bortel
>>
>> >> > Top-posting is one way to shut me up... -----BEGIN PGP
>> >> > SIGNATURE----- Version: GnuPG v1.4.1 (MingW32)
>>
>> >> > iD8DBQFGYb5KLw8L4IAs830RAnF2AJ0WA3mHge3vPrlC90iIiHCJiQYrTQCfTpca
>> >> > ve4oUR24Y8ircr+D7M2Ga2w=
>> >> > =+nyd
>> >> > -----END PGP SIGNATURE------ Hide quoted text -
>>
>> >> - Show quoted text -
>>
>> > Most likely you just either didn't read the installation instructions
>> > at all and/or didn't follow them up to the letter.
>>
>> Yes, that's most likely. The question is, which installation
>> instructions? As I switched back and forth between the 4 different ones
>> I downloaded from the webpage (two different ones each for normal and
>> quick installs) - trying to find the various instructions that best fit
>> my situation, it might very well be that I overlooked something.
>>
>> I was hoping somebody would be able to recognize quickly what it was...
>>
>> > ... Normal server
>> > installations don't need an extra client. PERIOD
>> >... On normal server
>> > installations anyone can connect to Oracle, provided a) the setuid bit
>> > of several executables has been set
>>
>> The setuid bit doesn't help if the directory in which sqlplus resides is
>> not accessible.
>>
>> > b) $ORACLE_HOME/bin is in your $PATH
>>
>> I can't even use an absolute pathname.
>>
>> > c) you have access to a tnsnames.ora
>>
>> yes.
>>
>> So, there's a bug in this assertion, at any rate ... ;)- Hide quoted
>> text -
>>
>> - Show quoted text -
> > No. > You just didn't follow the installation instructions, or you followed your > own interpretation of the installation instructions or you read secondary > documents written by people who have a screwed install. Just follow the > documentation to the letter, make sure everything is in the dba group > (oinstall is just plain wrong), and fix protections. > > And please stop whining and complaining about things you don't like and/or > willfully misinterpret.
[Quoted] [Quoted] :) Okay, I'll stop whining. Bo ho. And willfully misinterpreting, in order to needless consume network bandwidth. And even try to keep the provocations to a minumum - but the assertion - your assertion - has a bug in it:
>> >... On normal server
>> > installations anyone can connect to Oracle, provided a) the setuid bit
>> > of several executables has been set
>> > b) $ORACLE_HOME/bin is in your $PATH
>> > c) you have access to a tnsnames.ora
[Quoted] [Quoted] Oh, okay, you've got a caveat there with "normal server installations" - I could never prove that one, I guess. (and actually, I appreciate knowing that *anyone can connect to Oracle*, so your contribution wasn't worthless ... assuming it's a statement of fact and not a statement of faith).
[Quoted] In any case, if you don't have a clue, then you don't really have to answer. No sense getting hysterical. Somebody else might know. But thanks for the moral guidance, at any rate.
> -- > Sybrand Bakker > Senior Oracle DBA > > Fact: 99.9 percent of all questions on any Oracle forum have already been > asked and answered over and over again. This is because most posters think > they are the first to run into a problem and consequently don't search > Google. > They are wrong: they are not unique, they are with *too many*Received on Mon Jun 04 2007 - 16:05:05 CEST