Re: changing default database

Well, that's what I tried. Except that the application (java) says that it can't find tables (when I connect via sqlplus using the @ directive, I can see that everything is there).
That's why I believe that that application is not build to use something else
than the most obvious place (i.e. default database). Also I can start messing around with port numbers (or even secondary IP adresses), but I don't know if that will lead be to the solution. Changing over to another default database looks to me as a solution with a higher success chance.

regards,
Koen Scholtus

"C. Ferguson" wrote:

> Hi,
> since you mention java client, I'm going to assume a jdbc connection.
> Check the connection string you are using. In that string you will most
> likely find the connect instance specified as orcl. Change that to one
> of the other instances you wish to connect to.
>
> hth,
> cindy
>
> Koen Scholtus wrote:
>
> > On my server (8.0.6) i'v 3 instances running, each holding
> > their own database.
> > As clients we use a java based client, that appears to be
> > connectable only to the default database.
> >
> > Is there a way to alter the default database instance (orcl) for
> > a non-default database (orc1, orc2)?
> >
> > Regards
> > Koen Scholtus
> > --
> > ===========================
> > spamprotection : remove 'nospam' and use 'info' instead
> > ===========================

--
===========================
spamprotection : remove 'nospam' and use 'info' instead
===========================