2
votes
1answer
73 views

How to connect to Oracle 11g using “Navicat for Oracle”?

My Oracle 11g Enterprise Manager runs like this: I have taken the following screen-shot after my Oracle installation has been completed: I have the following Oracle-related services running: ...
1
vote
1answer
174 views

Possible reasons for slow BLOB updates in Oracle?

We have an application that transfers .bmp images as BLOBs to an Oracle table. One of the users of the app has complained that it is taking 2-3 seconds to transfer each image. Each image is ~1.2Mb. ...
3
votes
1answer
321 views

Network design considerations for Oracle Database Appliance

With the introduction of Oracle Engineered Systems the DBA is moved somewhat closer to infrastructure design decisions, and expected to at least have some opinions of the network design requirements ...
2
votes
0answers
193 views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
0
votes
0answers
84 views

Visio and Oracle Server/Network Layout

I'm attempting to use Visio 2010 and SharePoint for a somewhat unique scenario. After quite a bit of searching, I am in need of some assistance in pointing me in the right direction. I want to ...
1
vote
1answer
77 views

Change Oracle IP

If I change Oracle database server IP , what problem may exist and how to solve? modify hosts file modify tnsnames.ora file modify listener.ora file modify clients' tnsnames.ora files As I know ...
3
votes
2answers
950 views

How do I limit Oracle to use specific ports?

I've built a new Oracle 9iR2 instance on a Windows 2003 32-bit cluster. Of course, it's version 9i for reasons out of my control. Several application servers connect to this instance, and each opens ...