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

0
votes
1answer
108 views

DB2 to Oracle Migration

I am migrating a very large and complex database from DB2 to Oracle 11g. Can someone suggest any tools / processes to do this very quickly. My database is about 500 GB and it cannot have downtime ...
1
vote
1answer
693 views

How to enable Oracle-Managed Files on Oracle Express for Windows XP

I'm trying to enable Oracle-Managed Files on Oracle Express for Windows XP. From everything I've read, I need to set db_create_file_dest to an existing directory in the file system. I've tried ...
2
votes
2answers
644 views

How to keep filesystem layout identical in every RedHat Installation?

I want to keep the following layout same in every installation on the identical servers: dm-0 /dev/VolGroup00/LogVol00 dm-1 /dev/VolGroup00/LogVol01 dm-2 /dev/VolGroup00/LogVol02 dm-3 ...
-3
votes
1answer
83 views

Oracle 11g on a hard disk [closed]

Can I install Oracle 11g on a hard drive. Can I use this hard drive in another computer where 11 g is not installed and just play a bit with Oracle?
2
votes
1answer
2k views

Installation ORACLE 11g in an external hardrive

I am working on a project in which i have to deal with oracle 11g. My project manager wants me to install Oracle 11g in an external hard drive. I already installed it in the hard drive, though when ...
0
votes
3answers
130 views

where does Tomcat and application logic sit on 2-server system (database server or webserver)?

I have an application depending on BlazeDS and Oracle Application Express, which both require the use of Tomcat or equivalent. I have the following two Linux servers: (1) Oracle database 11G (2) ...
3
votes
2answers
12k views

oracle lsnrctl TNS-12545: Connect failed because target host or object does not exist

I am trying to connect to my oracle database. I can't get the listener started. Here is what I have tried. $ lsnrctl start LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 ...
1
vote
1answer
2k views

ORA-12514: Message 12514 not found with two Oracle clients

A user is getting the following error when attempting to connect to an Oracle database through an Oracle Forms app. I also get the same error when I try to connect from their computer using sqlplus. ...
1
vote
1answer
356 views

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only ...
0
votes
2answers
3k views

Howto enable remote login for a Oracle db user?

Stupid question: I've successfully installed Oracle 11g on my Linux box. I can connect to it and retrieve the countries table via C#/mono just fine, with the below connectionstring, which uses the ...
1
vote
1answer
2k views

Can't fix “ORA-00990: missing or invalid privilege” on a sequence

I'm getting "ORA-00990: missing or invalid privilege" on this kind of statement: GRANT USAGE ON SEQUENCE SOME_SEQUENCE TO SOME_USER; I've researched this all over the Internet and AFAICT, this ...
1
vote
1answer
2k views

Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?

I've and Oracle (11 Enterprise) schema with a table CREATE TABLE USER.WSP_BUNDLE ( NODE_ID RAW(16) NOT NULL, BUNDLE_DATA BLOB NOT NULL ); CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...
3
votes
2answers
16k 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
77 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
228 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
637 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
251 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
99 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
232 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
772 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
99 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
8k 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
289 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
261 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
897 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
410 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 ...
3
votes
1answer
67 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?
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
101 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
531 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
360 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
465 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
682 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
398 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
588 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
321 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
14k 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
155 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
92 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
5k 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
53 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
484 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 ...