Oracle is a relational DBMS (Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java.

learn more… | top users | synonyms

3
votes
2answers
14k views

How can I resolve Oracle 11g XE connection failure straight after installation?

I have just installed Oracle 11g XE on a Windows 7 VirtualBox VM, using all the default options. "Getting Started" fails When I click on Getting Started I get taken to ...
0
votes
1answer
74 views

Jmeter gets Apache lost db connection

I have a web app that makes to many ajax requests (update data with a grid). When I use JMeter to make a stress test with 20 threads and 10 loops, my web application canno't connect to the database ...
0
votes
1answer
222 views

Where to create directory for importing over network link?

While using data pump import over network link in Oracle: impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT directory=TEST_DIR remap_schema=SCOTT:TEST Where are we creating ...
1
vote
1answer
5k views

Use LDAP to authenticate oracle database users

I have Oracle Database 11g set up in few locations in either pure Linux/OpenLDAP, Samba/OpenLDAP environment and a full-blown Windows/AD environment. The applications that will be using those ...
0
votes
1answer
599 views

Recieving ORA-12560: TNS:protocol adapter error on classic ASP same connection in .net works

I have 2 different application installed on a windows 2008 one is .net the other is classic ASP. They would be connecting two different databases however to help trouble shoot the issue I have both ...
0
votes
1answer
245 views

Remote Desktop Services and Oracle 9i

I have an Oracle 9i forms application installed on clients. I am looking at moving this to RDS. Is this possible?
0
votes
1answer
96 views

oracle RAC server addition at DR site after DR occurs

DB: Oracle Server: Physical OS: Linux 5.5 The production site contains 3 server nodes and will be clustered using Oracle RAC, database replication will be done with the help of Oracle Data guard. ...
1
vote
1answer
223 views

How to generate test data from an sql query and a result set?

I am using an oracle database and want to generate test data from a live database, but I do not want to copy the whole database content. Given a database DB(S, D) consisting of the database schema S ...
0
votes
1answer
737 views

oracle enterprise manager agent unreachable (windows)

Since yesterday, the oracle enterprise manager tool on my windows 7 machine is saying that the agent is unreachable. I didn't do anything unusual before this appeared, if I remember correctly I only ...
0
votes
2answers
97 views

how many servers and in what configuration for web application by small company? [duplicate]

Possible Duplicate: Can you help me with my capacity planning? My question is from a startup company providing a web application for the first time. It consists of an Oracle database (11G), ...
1
vote
1answer
2k views

oracle - grant all privileges to schema

i've used mysql before and i'm now switching to oracle. I've already created a user in oracle. Now i want to give it "all privileges" for a schema. In mysql i can give all privileges (DML/DDL) for a ...
3
votes
3answers
7k views

How to install Oracle's exp / imp binaries

I was browsing the net to find a solution, but I had no luck. :( How can I install Oracle's imp / exp binaries to my CentOS box without installing an Oracle Server? I'm accessing an existing Oracle ...
0
votes
1answer
278 views

Installation of Oracle 10.2.0.4 in windows server 2003 [closed]

I have a problem in installingthe oracle database 10.2.0.4 in windows server 2003 environment, when I clicked the installer it always says "...\setup.exe isa valid, but is for a machine type other ...
-3
votes
1answer
258 views

install vncserver without yum on Oracle Linux

can anybody describe me how to install vncserver on Oracle Linux without yum? (yum does not work because it is a pre-built appliance - timeouts all the time)
2
votes
1answer
856 views

Sparc v440 unable 2 boot after recommended patch install

After installing the October 2011 recommended patch bundle on a Solaris 10 the host fails to boot. The output is {0} ok boot SC Alert: Host System has Reset screen not found. keyboard not found. ...
0
votes
1answer
1k views

Trying to install pdo_oci via PECL fails asking for PDO extension

I'm using Linux Mint 11 (based on Ubuntu 11.04) and I need to use PHP with Oracle through PDO, a requirement of the framework we will work with. I've installed various PDO extensions using the normal ...
0
votes
3answers
402 views

XP IIS no longer listen to port 80 or 443 after installing Oracle 9i HTTP Server

I have installed Oracle 9i HTTP Server together with the database. After restarting the PC, even though i restarted the IIS and stopped the Oracle HTTP Server. When I go to http://localhost/ The ...
2
votes
1answer
63 views

Oracle SOA repository migration

Does anybody know whether it is possible to migrate Oracle SOA repository from a simple Oracle database to Oracle RAC? Thanks
1
vote
0answers
1k views

Oracle 11gR2 error while installing on RHEL6_x64

Whenever I attempt to install Oracle it gives me this error in the install wizard on the group configuration screen. I am using group oinstall and user oracle has also been created. INS-30060] Check ...
1
vote
2answers
98 views

Is it possible that I can change Port Number in Oracle 10g for remote connections

I am creating a project in Oracle Is it possible that I can change Port Number in Oracle 10g for remote connections ?
0
votes
1answer
502 views

Setup VirtualBox to see Oracle on a Local guest

I have a Ubuntu machine and I have a Linux instance running in a Virtual-box on this machine. I need to connect to the oracle instance (through the oracle extension in php) . The extension is running. ...
0
votes
1answer
345 views

Does DBMS_ALERT work correctly on an oracle RAC cluster?

Can anyone confirm whether the oracle DBMS_ALERT package works correctly in a RAC envirnoment. That is, if I have a DBMS_ALERT.WAITONE() on all instances, then I do a DBMS_ALERT.SIGNAL(), will all ...
2
votes
2answers
440 views

Is there a way to dump an Oracle db as SQL statements, à la pg_dump?

I'm very new to Oracle. It looks like all the Oracle DBA use binary only dumps. This sometimes cause problems, and seems rather useless to me (performance gain is bound to be negligible), but what do ...
1
vote
2answers
1k views

Oracle import fails due to NLS_DATE_LANGUAGE setting

I have an Oracle 10 database server and a dump created on another Oracle 10 server. When using the imp command to import the dump to the database: imp 'sys/*** as sysdba' file=c:\[...]\strukt.dmp ...
1
vote
1answer
631 views

Oracle on Solaris 10 : 15min TCP Timeout

I have Oracle10g running on Solaris 10. The configuration of the OS is standard, and there is a packet filter firewall running on the server. When I run a long query using sqldeveloper, the server ...
0
votes
1answer
377 views

Oracle EM detect a disk full, but the system has plenty of free space

My enterprise manager instance on Oracle 10.2.0.4 throws the following alert on a regular basis: Name=db4 Type=Host Host=db4 Metric=Disk Utilization (%) Disk Device=sd1 Timestamp=Oct 4, 2011 2:15:50 ...
1
vote
0answers
580 views

Intermittent java.sql.SQLException: ORA-03120: two-taskconversion routine: integer overflow exception

I get the following error intermittently when my spring app starts up. I am using oracle with dbcp pooling as my datasource bean in spring. Caused by: org.apache.commons.dbcp.SQLNestedException: ...
2
votes
1answer
308 views

What are the best practice for monitoring Oracle's rollback segment?

Occasionally, we run out of rollback segment space causing the query/update to fail. What are the best practices that I can expect from an Oracle DBA to ensure that this is monitored pro-actively and ...
6
votes
4answers
3k views

Why “Begin Transaction” before “Insert Query” locks the entire table?

I wrote a stored procedure to insert a record. I added "Begin Transaction" just above the Insert Query and execute the query. I noticed that another application that was showing a web page with ...
2
votes
3answers
13k views

How do I make imp use right charachter set?

I am trying to import a dmp file from one database to another. The problem is that some special danish characters are not imported right because some character map conversion is done during import. ...
33
votes
7answers
2k views

Database server: Small quick RAM or large slow RAM?

We are currently designing our new database servers, and have come up with a trade off I'm not entirely sure of how to answer. These are our options: 48GB 1333MHz, or 96GB 1066MHz. My thinking is ...
1
vote
0answers
56 views

Oracle SGD 4.61.915 not closing Windows 2003 application sessions

I'm using a Windows 2003 Application Server and I have followed this article: http://download.oracle.com/docs/cd/E19351-01/821-1926/z40000df1311155.html#bbjiefec but still.. when i close a application ...
2
votes
1answer
153 views

Oracle Backup Strategy

I have recently inherited a smallish Oracle database running on a SPARC Solaris 10 Server. I have been asked to implement a sensible backup strategy. The database has about 3000 odd tables and is ...
2
votes
1answer
91 views

How can I tell how my oracle databases configurations' differ?

I have two databases with the same data, running on the same physical server. They are performing differently (one is twice as fast as the other). I've compared the Initialization Parameters and ...
2
votes
1answer
4k views

Oracle Enterprise Manager showing Agent Unreachable, negative disk space?

I'm recently installed Oracle 11g on a Windows Server 2008 box and although the database appears to work just fine when I load up the Enterprise Manager in Firefox it tells me 'Agent Unreachable'. ...
1
vote
1answer
1k views

Large amount of cursors causing slow response and massive CPU usage - cursor: mutex s

We have a problem with our Oracle server. It was upgraded to 11g a couple of months ago and is running a third-party system. The system has been running for years (and has had several other issues), ...
2
votes
0answers
51 views

Equivalent of SQL Server trace for Oracle 10g?

I've got a bad code duplication problem where we cannot tell which versions of packages/procedures are being used. i.e. I have different packages with procedures of the same name and I need to be ...
3
votes
1answer
447 views

Oracle DB on drbd or SAN replication with Oracle Data Guard

I'm looking to deploy an application based on Oracle DB, and I was assuming that it would be possible to easily do active/passive clustering (with RH Cluster or Heartbeat) and synchronous replication ...
0
votes
1answer
169 views

Oracle Unbreakable Enterprise Kernel compatible with CentOS?

I'm installing Oracle 11.2. Anyone know if Oracle Unbreakable Enterprise Kernel ... (1) is required to be installed for CentOS 5.5? (2) may optionally be installed on CentOS 5.5? I'm following the ...
0
votes
4answers
778 views

SQL server Vs MySql vs Oracle for a large government project [closed]

I am in charge of deciding which database to use for a big government project with: 100 Million records (estimated in one big table) Availability and data reliability is paramount. Performance not ...
4
votes
1answer
160 views

Are there any performance differences between Oracle Entreprise and Oracle Standard editions?

Someone has asserted to me that the reason why one database is performing better than another (50-100%) is because one has Enterprise Edition and the other has Standard Edition. Given the same ...
1
vote
1answer
228 views

Oracle has exactly 20 second delay

I have a development oracle server in the office that has worked for several months up until Friday, when each and every call started returning after a 20 second delay to my computer. The delays are ...
55
votes
7answers
5k views

What are the drawbacks of running a database inside a virtual machine? How do I overcome them? [closed]

Running anything inside a virtual machine will have some level of performance hit, but how much does it really impact the performance of a database system? I found this academic reference paper with ...
1
vote
2answers
110 views

Error 503 on SQL/Oracle prodécure execution

I'm facing a problem with the Apache/Tomcat/JDBC/Oracle communication configuration of an application. Here are all the informations I have at my disposal about the problem : A button on the ...
0
votes
1answer
288 views

Oracle 10g cannot start after cloning server with dd

I used dd to clone a x4100 server with Linux Red Hat. The hardware is identical for old and new servers. Then I changed IP address and host name. The newly restored server is up and running but Oracle ...
3
votes
2answers
358 views

Oracle RAC failover backup procedure

We have Oracle 11gR2 RAC database on two nodes. We also have a RMAN backup script that works fine, using a recovery catalog database which is located in a town 20km from the data center. The script ...
0
votes
1answer
255 views

oracle 10g tablespace table relation?

Im running "Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production" and trying to get familiar with it. I have created a tablespace und set it online. How do I make sure the next create ...
1
vote
4answers
994 views

CPU utilization is low but swapped out processes and blocked processes is high

We're facing intermittent periods of 100% CPU utilization. Server Configuration:HP DL580 G7 (4 Processor with 8 cores each; 128GB memory.) Operating System: Solaris 10_x86 update 9 Application: ...
0
votes
1answer
528 views

Oracle performance after rebuild TEMP

My application was running without any problems for almost one year. But recently someone executed a big select for a report, and the Oracle´s TEMP datafile has grown from 5GB to 30GB. The server then ...
1
vote
2answers
1k views

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message: Total System Global Area 534462464 bytes Fixed Size 2215064 bytes Variable ...