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
45 views

Blocking locks and performance

My main question is if high amounts of blocking locks degrade Oracle server performance. I understand that it can hurt users performance, but does it cause high load on Oracle itself?
1
vote
0answers
636 views

cx_Oracle - InterfaceError: Unable to acquire Oracle environment handle

I have installed Django on Ubuntu 12.04 behind NGINX with uWSGI. I use Postgresql as the main database for the application however I need to retrieve some data from an Oracle database. I have ...
0
votes
1answer
248 views

I compiled samba 3.6.4 on Solaris 9, and can't get smbd to run

I compiled the latest release of samba on a Solaris 5.9 system to address CVE-2012-1182, and I'm getting this result when I run smbd. fs17151# ./smbd -i smbd version 3.6.4 started. Copyright Andrew ...
-1
votes
2answers
183 views

display sql syntax in Oracle's sqlplus? [closed]

What is in Oracle's sqlplus equivalent of Linux's man or --help ? When I'm in sqlplus and type help index, I get some commands displayed, but there is no way to get specific sql syntax. For example ...
2
votes
2answers
3k views

unable to install sun jdk on ubuntu

I have Ubuntu 12.04 x64 and I'm trying to install sun jdk for opennms. sudo apt-get install sun-java6-jdk when i run above given command i get following msg: root@fido:~# sudo apt-get install ...
0
votes
2answers
171 views

Improving latency between developer machine and oracle db

It seems our developers are concerned with the latency they are getting between their dev machines at site a and the database which is at site b. Ofcourse the obvious thing is to have as little as ...
0
votes
2answers
700 views

Oracle 10g queries very slow and CPU usage very high after applying patch

So I recently updated an Oracle Database 10g from 10.2.0.3.0 to 10.2.0.4.0, as advised by Oracle Support, due to stability issues (a known issue under some systems where the instance would freeze ...
2
votes
3answers
3k views

How to have oracle database accessible remotely

I can connect to my oracle database using localhost:1521. However, connecting to the IP address does not work. I'm trying to do this because I am trying to connect to my database using another ...
1
vote
2answers
203 views

create a 'definition' file from Oracle

I have inherited an oracle database, and have no Oracle experience. I have been tasked with building a 'clone' of the database on a new server. I am searching around, but not finding the things I am ...
1
vote
2answers
4k views

Connect to Oracle Database that is hosted in a Virtual Machine from the host machine

Good day, I've just setup a Virtual Machine (using VirtualBox) of Oracle Linux with Oracle Database in it. After setting it up, I can verify that I can connect to it using sqlplus (sqlplus of the ...
0
votes
2answers
2k views

Setting up Oracle Database in Oracle Linux

Good day, I am trying to install Oracle Database in Oracle Linux. However, it is looking for some dependencies. Anybody knows where I can get them? Package: gcc-3.4.6 FAILED Package: ...
2
votes
1answer
224 views

Need to downgrade from an intel xeon 5675 [closed]

I'll skip my sob story and just say Oracle has weird licensing, and because of this I'm trying to see if I can avoid buying three new ESX host servers by downgrading from 12 cores (6 licensed ...
2
votes
1answer
867 views

Can I enable Kerberos authentication for Oracle 11g Database Standard edition?

I have an Oracle 11g Database Standard instance running on Windows Server 2008 R2 and I need to enable Kerberos authentication. I followed the documentation for activating Kerberos 5, but cannot get ...
0
votes
1answer
299 views

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history? For instance, I want to move from BPEL instances deployed to defined partition on Oracle SOA to ...
0
votes
1answer
1k views

INS-40719 error when Install Oracle RAC?

I'm tying to (learn how to) install Oracle RAC 11g on CentOS 6 all went OK so far but I get INS-40719 Error message regarding SCAN Name I do not have DNS server and I'm not going to try to use it on ...
5
votes
2answers
422 views

My table half-exists. Can't drop it

I have a table that is taking up quite a bit of space even though it has no rows. I also dropped it a while ago. When I try to drop it now, it says the table doesn't exist. It shows up in ...
1
vote
1answer
2k views

Reporting Services: Cannot connect to Oracle using Integrated Security

Context I have an Oracle 11g database instance and a SQL Server 2012 instance installed on 2 different servers in the same domain. The Oracle database is configured to accept connection with ...
1
vote
1answer
472 views

How does Oracle Database Standard Edition (One) benefit from running on a dual CPU server?

I am evaluating the impact of additional CPUs on Oracle database performance. I am looking to license Oracle Standard Edition One (SEO, being most cost effective) or Oracle Standard Edition (SE). As ...
2
votes
1answer
93 views

Migrating Oracle DB to another operating system from Red Hat Enterprise by using a disk image

I have a Red Hat Enterprise server disk image that Oracle DB is installed on it. My question is : Is it even possible to use this disk image in order to setup same DB on another Oracle supported ...
2
votes
1answer
3k views

logfile deleted on Oracle database how to re-create it?

For my database assignment we were looking into 'database corruption' and I was asked to delete the second redo log file which I have done with the command: rm log02a.rdo this was in the ...
2
votes
0answers
224 views

Oracle concurrent programming execution methods

I created a package and a stored procedure under it to test a concurrent program. When I run it as an Oracle report executable method it works fine. But when I change it to PL/SQL stored procedure ...
-5
votes
1answer
100 views

What is the stability level of Oracle 11g? Is it suitable for production? [closed]

We are using both Express edition and Commercial edition to power up a Distributed application. Is Oracle 11g a good candidate for this application since we need data synchronization? Or is Oracle 10G ...
1
vote
2answers
3k views

Running SQL*Plus with bash causes wrong encoding

I have a problem with running SQL*Plus in the bash. Here is my code #!/bin/bash #curl http://192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql > script.sql wget -O script.sql ...
2
votes
3answers
598 views

Sunfire v100 Reinstall Problems

I own two Sunfire v100 servers, and I use hyperterminal to connect to them. I am trying to re-install Solaris on one of them, so I put in the LOM cable and unplugged the harddrives. Here's the ...
3
votes
1answer
17k views

How to execute datapump commands as sysdba from remote machine

I would like to know the syntax to call datapump commands (expdp/impdp) logged as 'sys as sysdba' from a remote machine. I know that when logged on the machine which runs the database, I can use : ...
2
votes
3answers
310 views

Change local admin password. Impacts on Oracle and Citrix?

I need to change the local admin password on some Citrix and Oracle servers. These servers are in production. Then we will start using a secure password procedure, and change them every X month. ...
0
votes
2answers
113 views

Configuring swapfile error

I installed oracle linux 6 on my desktop but I forgot to configure the swapfile, I want to install oracle 11gr2 on it and it requires 2gig or ram, if I type the following commands on the terminal I ...
1
vote
2answers
392 views

Oracle only starts with autostart, doesn't when trying manually

I have installed oracle on my ubuntu system a few months ago and its been working pretty well. I have it setup to start on system boot and I run the following commands to stop/start the service sudo ...
0
votes
2answers
450 views

MS Project Server 2010 and Oracle Database Backend?

After searching far and wide across the internet for an answer I have come here in hope of help. I am aware that MS Project Server 2010 requires a SharePoint server, but does anyone know if it is ...
0
votes
1answer
103 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
600 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
605 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
82 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
1k 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
129 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) ...
2
votes
2answers
10k 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
274 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
1k 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
13k 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
69 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
211 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
4k 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
576 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
241 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
219 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
684 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 ...