Let's say I want to set up two systems, A.D and B.D
where D is the Internet domain.

Each system supports an Oracle server (9i or possibly
10g).

Also, I would like A to be B's oracle client.

Is this possible?

Let's say A has Oracle SID X and B has Oracle SID Y.

What do the tnsname.ora files look like (roughly)?

(I'm presuming the connect statement forms
would be obvious from the answers to the above.)

Lower priority:

Can a 10g client connect to a 9i server (without DB migration)?

Can a 9i server connect to a 10g client (without DB
migration)?

Thanks,

-z

"z" <z@y.x.invalid> wrote in
news:W3MBf.33944$dW3.7832 (AT) newssvr21 (DOT) news.prodigy.com:

GOOGLE is your friend, but only when you use it.

All the answers can also be found at:
http://tahiti.oracle.com if you are willing to RTFM

Ummm servers don't connect to clients exactly.

People or shell scripts or programs running on a machine that is also
used as a database server can connect to a different oracle database
somewhere else ( given an appropriate tnsnames or other connection
setup ).

10g client can connect to a 9i server .. Yes.

z wrote:
Rather than tying to explain your proposed solution to an unknown
problem ... it would be better to explain the business problem
you are trying to solve. My read of what you've written is that
you may be trying to reinvent the wheel.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

"hpuxrac" <johnbhurley (AT) sbcglobal (DOT) net> wrote

I meant, can a system configured as an oracle server
be used as a client. FYI, an oracle SE advised me
against trying it already. I just wanted a second opinion
because I did not perceive any technical reason
why it should not be supportable in theory if not
in practice.

Thanks very much (another q the oracle SEs
could not answer from the hip). This should
speed up my config testing.

"IANAL_VISTA" <IANAL_Vista (AT) hotmail (DOT) com> wrote

Dear Ms. IANAL,

I've already been through oracle SEs for most
of these questions. That is something I pay
for but the answers that I get are vague or delayed
and generally not useful. Those oracle SE guys
are paid to know or get the answers to these
kinds of questions every day so please
cut me some slack.

My requirements are being shifted on me from day to day, while my deadlines
remain the same.
So yes I could read the friendly manual, but
it would take time and even then it would not
lead to certainty. I'm looking for a consensus
and I am willing to acknowledge that I have
limitations and that there are things I do not know.

(Unlike some of us, Ms. IANAL?)

z wrote:
Oracle support is not what it used to be. Their principal motivation
appears to be to try to close tickets as quickly as they can.

While you need to get the environment variables defined corectly (
especially important on unix/linux systems ) and/or when more than 1
set of oracle software executables ( different releases for example )
have been installed, it's a no brainer to use "for client
functiionality" when needed those executables to connect to another
database.

Typical disclaimers, anytime you are going across the network ...
performance varies and you want to consider application design issues.


You are welcome.

Lots of GOMS ( grumpy old men syndrome ) active at times on this
newsgroup.

Caveat emptor.

z wrote:
Depends on what you mean by a client which you don't explain.
Certainly you can create a database link between databases
and have one interact with the other.

There is no penalty for providing a complete explanation.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

hpuxrac wrote:

Unfortunately you are correct.

Part of what happened when they offshored support was to compensate or
rate on the number of tickets closed. If you give people a metric based
on closed tickets don't be surprised when they consider that their prime
directive.

I would encourage Oracle employees lurking hereabouts to take this
message back to the corporation. This practice is doing damage to the
company, generating ill will, and not doing anything to save Oracle
money as all we do is open another TAR. It is not like we are going to
just go away with a downed production system.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

"z" <z@y.x.invalid> wrote in
newstOBf.3446$2O6.730 (AT) newssvr12 (DOT) news.prodigy.com:

I did cut you some slack.
I provided the URL to all of Oracle's documenation set;
which contains answers to all your questions.
With free advice, you get what you paid for it!

Which is of no concern to me; unless & until you, your boss or
corporation is willing to hire me.

The consensus is that you are unwilling to make any effort
to answer your own questions.

Rather than relying on the kindness (& correctness) of
strangers, you could simply test the various combinations
and determine for yourself which works & which does not.
In the process, you might actually learn something about Oracle.