Re: oracle 10g installation - access not permitted?

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.

[Quoted] And please stop whining and complaining about things you don't like and/or willfully misinterpret.

--
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*