Re: oracle 10g installation - access not permitted?

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. Normal server installations don't need an extra client. PERIOD [Quoted] 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

Assuming this is a bug is just.. ahem.. plain ridiculous.

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