sounds like an ipchains problem(if its linux) or a net8 problem. You could
have a rule set up on the standby box which prevents getting messages from
net8 but allows sending messages to net8. Try running a sql*plus client from
the same box that orion runs on, and see if you can connect to the oracle
box. If not, you know its a port problem or a net8 config problem, and not
an issue with orion.
also...do the normal things like, can you ping the standby oracle box.
we run orion against different boxes with oracle all of the time....no
problems.
regards,
the elephantwalker
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, May 03, 2001 2:35 PM
To: Orion-Interest
Subject: Database Connectivity Problems
Ok I am completely baffled by this. We are running orion 1.4.4 and I am
having severe problems connecting to my Oracle database. Actually modifying
the connection to my database.
I have 2 Oracle Databases running on different servers. One is our
production server and the other is a standby server. I attempted to test
orion on my staging server against the standby database and I get a Network
Adapter error. When I point it to the Oracle database that It first ran
against it works fine, change the IP address in the data-sources.xml file to
the standby it dies. (All I am changing is the last 2 numbers). If I change
the IP address to the fully qualified hostname of the production database it
dies with the same error. In the Oracle logs I can see the connections, but
Orion still gives a "The Network Adapter could not establish the
connection". If I try the same thing on the development boxes it works
perfectly fine, I change between the databases at will.
I have tried deleting the application-deployments directory, the persistence
directory, the entire application directory and redeploying from scratch,
searching through the complete directory tree for any reference to the OLD
DB or it's IP address. I have search bugzilla, and the mailling list
archives and still I am completely baffled. Does anyone have any ideas why
it would not allow me to change the database it is going against. (I swear
all I am changing is a 47 to an 88, the databases are identical otherwise.)
Thanks
Kep
