 | |
sqlplus & exp "hanging" on a particular table
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: sqlplus & exp "hanging" on a particular table -
10-14-2011
, 11:01 AM
|
On Oct 12, 10:26 am, Jeremy <jeremy0505 (AT) gmail (DOT) com> wrote: |
<snip>
Quote:
|
What about a DB link? Created from the DB10 database to connect to DB11 SQL> create database link db11 connect to .... identified by .... using '....'; OK lets try: SQL> create X_IC_BO_BRANDING as select * from X_IC_BO_BRANDING@db11; Table created. SQL> create PROBLEM_TABLE as select * from PROBLEM_TABLE@db11; [NOTHING!] ----- |
Quote:
|
-- jeremy Had this as our security guys implemented an Application Gateway (Juniper) between our Servers, dropping Connections. Do you have such boxes in place ? regards |
Do you have a solution....?
--
jeremy
#12
| |||
| |||
|
|
Had this as our security guys implemented an Application Gateway (Juniper) between our Servers, dropping Connections. Do you have such boxes in place ? regards BINGO! Do you have a solution....? |
--
http://mgogala.byethost5.com
#13
| ||||
| ||||
|
|
On Fri, 14 Oct 2011 17:01:47 +0100, Jeremy wrote: Had this as our security guys implemented an Application Gateway (Juniper) between our Servers, dropping Connections. Do you have such boxes in place ? regards BINGO! Do you have a solution....? You can try setting up Oracle Connection Manager and bypass the firewall. |
idea what this means - if you have a firewall how can you "bypass" it?
Say the network is like this:
+-------+
Quote:
|
db11g | +-------+ ----- |
-----
Quote:
| i n t e r n e t ---- |
----
Quote:
|
+-------+ db10g | +-------+ |
firewall-1 appears to be the issue
--
jeremy
#14
| |||
| |||
|
|
In article <pan.2011.10.14.16.21... (AT) gmail (DOT) com>, gogala.mla... (AT) gmail (DOT) com says... On Fri, 14 Oct 2011 17:01:47 +0100, Jeremy wrote: Had this as our security guys implemented an Application Gateway (Juniper) between our Servers, dropping Connections. Do you have such boxes in place ? regards BINGO! Do you have a solution....? You can try setting up Oracle Connection Manager and bypass the firewall. How would that help? By the way we are using Standard Edition. I have no idea what this means - if you have a firewall how can you "bypass" it? Say the network is like this: * +-------+ * | db11g | * +-------+ * * | * ----- * firewall-1 * ----- * * | * * | * * | * i n t e r n e t * * | * * | * ---- * firewall-2 * ---- * * | * +-------+ * | db10g | * +-------+ firewall-1 appears to be the issue -- jeremy |
issue not handled correctly by the app gateway, basically i
dont care about issues introduced by other teams , only have to
q.e.d. but could asked them tomorrow. Dont know about your org,
but if local works and remote not it indicate net issue.
Your net team should provide the solution.
regards
stefan
#15
| |||
| |||
|
|
How would that help? By the way we are using Standard Edition. I have no idea what this means - if you have a firewall how can you "bypass" it? |
a tunnel that would make it possible to control the database connections.
Here is the description:
http://download.oracle.com/docs/cd/B...28316/cman.htm
--
http://mgogala.byethost5.com
#16
| |||
| |||
|
|
In article <a45a1d61-3f0c-4ee4-b2a9-e65c9e714069 @p25g2000yqh.googlegroups.com>, stefan.kapi... (AT) googlemail (DOT) com says... On Oct 12, 10:26 am, Jeremy <jeremy0... (AT) gmail (DOT) com> wrote: snip What about a DB link? Created from the DB10 database to connect to DB11 SQL> create database link db11 connect to .... identified by .... using '....'; OK lets try: SQL> create X_IC_BO_BRANDING as select * from *X_IC_BO_BRANDING@db11; Table created. SQL> create PROBLEM_TABLE as select * from *PROBLEM_TABLE@db11; [NOTHING!] ----- snip -- jeremy Had this as our security guys implemented an Application Gateway (Juniper) between our Servers, dropping Connections. Do you have such boxes in place ? regards BINGO! Do you have a solution....? -- jeremy |
leaving port redirection etc. untouched.
regards
Stefan
#17
| |||
| |||
|
|
On Sat, 15 Oct 2011 12:10:59 +0100, Jeremy wrote: How would that help? By the way we are using Standard Edition. I have no idea what this means - if you have a firewall how can you "bypass" it? Paul, connection manager is a proxy server on the firewall itself or with a tunnel that would make it possible to control the database connections. Here is the description:http://download.oracle.com/docs/cd/B...28316/cman.htm --http://mgogala.byethost5.com |
nice tip. (just in case the next generation of Sec Team is arriving
thanks and regards
Stefan
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.