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
0answers
3 views

How can I force a bushy tree join in Oracle SQL? [migrated]

As far as I know the default join is the deep left join. How can I force a bushy tree join on 4 tables?
0
votes
0answers
6 views

How to generate create table script without primary and foreign key in Oracle [migrated]

I have lots of schemas and tables. I want to generate create script of all of my tables. I am using below statement and it is working pretty well. SELECT ...
0
votes
0answers
33 views

How do I tell the actual IOPS used by Oracle? [migrated]

This is hopefully a simple question. We have a large DB deployment that we need to scale up over the next year. For scaling we have been relying on our vendor, but recent developments have caused us ...
0
votes
0answers
19 views

Oracle orion I/O bechmark fail

We use oracle orion as our i/o benchmark tool. And our test device is Fusion-io ioDrive Duo 640GB.The platform is Red Hat Enterprise Linux Server release 6.2 (Santiago). And the orion version is ...
0
votes
0answers
19 views

Oracle Content Server Losing HTTPS on adfAuthentication

This has been a nagging problem for a while now, in summary we have the following setup. Cisco ACE Load Balancer -> Oracle HTTP Sevrer -> WebLogic We are terminating the SSL on the load balancer, ...
1
vote
1answer
65 views

How to use Oracle Installation Prerequisites on Redhat Linux 6.5?

Today I get error below when install Oracle 11gR2 on Redhat Linux 6.5. I follow instruction in this link: http://public-yum.oracle.com/ After I call this command: # yum install ...
0
votes
1answer
31 views

Oracle Database suddenly fills storage device in about 20 minutes

My Oracle instance up on Amazon's RDS filled a 20GB storage in the space of about 20 minutes. I checked all the applications that use this DB and nothing looks out of the ordinary - I can't figure out ...
0
votes
0answers
43 views

PL-SQL Developer not connecting to remote oracle database , error ORA-01034

![Oracle error in PL SQL Developer][1] I am facing issues while trying to connect my database through PL-SQL Developer. It throws error - ORA-01034 everytime. Please note the below. 1.I am using ...
0
votes
1answer
14 views

SQL 2008 R2 replication with Oracle DB Server Issue

I am configuring replication between SQL 2008 R2 & Oracle DB server. Getting below error "ORA-01830: date format picture ends before converting entire input string (Source: MSSQL_REPL_ORACLE, ...
0
votes
2answers
31 views

Oracle database installation file limits

I'm reading a oracle guide for installing a Database on redhat 6, but i don't understand why oracle recommend to set the file-max system parameter and nofile in /etc/sysctl.conf ...
0
votes
0answers
18 views

Running two different application servers on the same Oracle RAC database

I would like to set up a basic high availability solution for one application server (Tomcat, JBoss). Is it possible to run to clone each application server and connect clone a to node1 and clone b to ...
0
votes
0answers
21 views

Java 6 updates on SLES 11 [duplicate]

Since mid 2013 there are no public updates for Java 6, but only paid support ones. Is this policy enforced for all JVM implementations? Does this include SLES 11 IBM JVM implementation too or IBM ...
9
votes
2answers
485 views

How do you get the latest update for Java 6?

An application my company is considering buying requires Java 6. I am concerned that this is quite out of date and am recommending against the application as a result. But it seems that Oracle do ...
0
votes
1answer
21 views

“Raw” Packages of Oracle JDK for Linux

Is there any public source of zipped JDKs for Linux (64bit) that can be downloaded and used more easily than the original installers or the PPA? Currently we create them ourselves manually, but that ...
0
votes
1answer
76 views

Tomcat - JDBC Data Access Exception

My company has a web application that allows users as part of their business process to upload large documents (10+ MBs) into the application. For fast connections it works great with the document ...
0
votes
0answers
91 views

ORACLE Forms app throws error: “Failed to open file: ifrun60_dump_” on terminal server

Scenario We have an ORACLE Forms client application deployed on multiple Windows clients and one Microsoft Terminal Services server. The application has scarce documentation and largely inefficient ...
0
votes
0answers
36 views

Can this RMAN setup give me a 7-day point-in-time recovery window and a stable size?

I have an RMAN setup on an Oracle 11g Windows 2003 R2 server, storing a steady stream of instrumentation values for various machinery. There are routines in place to automatically accumulate and ...
1
vote
0answers
19 views

Oracle Identity Manager and Microsoft Read-Only Domain Controllers

Is Oracle Identity Management 11g (OID) compatible with Microsoft Active Directory Read-Only Domain Controllers? (RODC) My setup has OID importing users from AD RODC. Is this configuration ...
0
votes
1answer
18 views

Can you restore multiple Oracle databases with the same tablespace name?

I am in the process of setting up an Oracle instance for customer database restores. The vast majority of our customers use the same tablespace name for their databases, which leads to us needing a ...
-2
votes
1answer
75 views

Adding secondary groups and running processes

I made oracle member of a secondary group. Do I have to restart Oracle before it can write to directories owned by this secondary group?
0
votes
0answers
25 views

RSS feed/email list to be notified about java updates

I'm doing upgrades of JDK on our servers regularly. But because Oracle JDK installed via custom packages (not via package manager) I need way to be notified about updates. Are there way to be ...
3
votes
2answers
407 views

Install Oracle Linux 6.4 on HP ProLiant DL380e Gen8 server

installation does not detect the raid 1 logical drive created from ACU. the installation shows the two 2T disks, and after the installation is complete, I can not boot up to the system. I have been ...
1
vote
1answer
37 views

How can I plan a DR solution for an SAP Instance running on HP-UX

I'm supporting an environment that runs SAP on HP-UX. The HP Blade running the SAP Instance is connected to IBM Storage over FC connection. SAN Infrastructure is duplicated by redundant ...
1
vote
0answers
85 views

What would cause RMAN backups over NFS to kill SAN performance?

I've been trying to figure out this problem for several weeks now, we are using an Exadata that runs nightly RMAN jobs to backup the database to a NFS mount. When these jobs occur, the average latency ...
1
vote
2answers
55 views

OEL fresh install while keeping old LogVols

I've been asked to install OEL 5.x on a server and setup a disk with a few directories (there's only one disk in the server). So I have an OEL 5.x server wtih multiple log volumes in a volume group: ...
2
votes
0answers
26 views

Alternatives to oracle flashback database/table functionality

Does anyone know of an open source tool or similar that covers the same functionality as the Oracle EE built-in flashback database and flashback table features? I'm considering going from Oracle EE ...
0
votes
1answer
87 views

Oracle 11g TNSLSNR LAST_ACK connection flooding

We have Windows 2k3 EE SP2 with Oracle 11.2.0.1.0 DB installed. The DB is used by different applications (including web-apps and services). From time to time, we have some problems with the web ...
0
votes
0answers
54 views

ORACLE keep-alives with ENABLE=BROKEN with ezconnect

Could you please advise is there any way to use ENABLE=BROKEN option with ezconnect? Usualy this option provided in tnsnames, but in case of ezconnect, tnsnames will not be used and option will not be ...
0
votes
1answer
33 views

Websphere shutdown not releasing database locks

Sometimes when shutting down Websphere there are database locks not released. As a result, when WAS is restarted nobody can work because of these locks, that must be removed manually by the DBA. It's ...
2
votes
1answer
289 views

Cannot create Oracle ODBC source on 64bit Windows 7

I have installed the 64-bit version of the Oracle ODBC driver (instantclient-odbc-windows.x64-12.1.0.1.0 from http://www.oracle.com/technetwork/topics/winx64soft-089540.html) on my 64 bit Windows 7 ...
13
votes
3answers
573 views

Does my Oracle DBA need root access?

My Oracle DBA Colleague is requesting root access on our production servers. He is arguing that he need it to perform some operations like rebooting the server and some other tasks. I do not not ...
2
votes
0answers
67 views

MICR check printing through Linux (EBS)

We are currently working to get a new MICR check printer (Troy Micr - HP Laserjet 600 M601) printing correctly with Oracle EBS. Our EBS installation runs on Oracle Enterprise Linux (Redhat Based). The ...
0
votes
0answers
36 views

Ganglia Oracle plugin?

Can't seem to find a good Oracle plugin for Ganglia. I was hoping someone could point me in the right direction? I'm not hugely familiar with Oracle so I'm assuming it exposes the various metrics via ...
0
votes
1answer
136 views

ORA-12154: TNS:could not resolve the connect identifier specified

I'm trying to use bat file/CLI to run SQL script against certain Oracle database with following syntax: sqlplus -L user_name/database_name@Password @d:\my_bat_file\sql_script.sql If I run this ...
0
votes
0answers
15 views

Oracle URM - how to automatically insert content into folio

What is the best way to automatically insert new content into a folio based on metadata on Oracle URM 11g? Can I do it using a Auto-Contribution workflow? Is it the best way to do it? What are the ...
0
votes
0answers
51 views

Username/password for Oracle Linux 5.8 VirtualMachine

I have the Oracle Linux 5 ova (converted to VirtualBox). The documentation I have seen mentions using either root/oracle or oracle/oracle to login. However that is not working. Any ...
0
votes
0answers
17 views

Export data from Oracle Lite 10gR1 odb file

I hope you can help me with this one. Years ago (2005) someone way before me set up a server with WinXP and a custom-written Java/Tomcat-whatever application for monitoring some sensors, the database ...
0
votes
0answers
19 views

Oracle remote_os_authent works locally but not remotely

An oracle 11g server is configured to use the remote os authentcation option for select few users. Everything works fine from the shell of the DB server (e.g. you type sqlplus / and login is ...
0
votes
1answer
129 views

How do I install Oracle Linux 6 with the UEK over the Internet?

Is it possible to use the Oracle Linux 6 UEK download and download the rest of the OS over the Internet? I have UEK running. I selected URL for the Installation Method. I tried various URLs for ...
0
votes
1answer
54 views

IBM System X M4 Series Servers Oracle Linux Support

Is Oracle Linux runnable/compatible with the M4 Series of the IBM System X Servers? In their compatibility website, most compatible machines listed are those from Dell and HP..there are IBM system ...
0
votes
1answer
170 views

Error installing Oracle-Java6

I'm attempting to install Oracle-Java6 on my VPS, running ubuntu-10.04 for the purpose of running Openmeetings. I installed the ppa webupd8team/java, updated and ran sudo apt-get install ...
0
votes
1answer
37 views

Oracle 10g backup issue

Introduction: I have to set up a backup concept for an old Oracle 10g installation. The server is old and poorly managed, but I have to ensure we have rock solid backups until the system will be taken ...
0
votes
2answers
532 views

Can Docker help me install Oracle 11g database on Ubuntu?

We are struggling with a common problem of trying to provide an Oracle 11g instance for our developers to test with. Our standard build agents are based on Ubuntu 12.04 but Oracle supports only RedHat ...
0
votes
1answer
57 views

Error while using oraenv

I'm using Oracle RAC in RH6, and when i try to use the 'oraenv' utility to set the variables with the user oracle, i get an error: [oracle@vhor12 ~]$ . oraenv /bin/.: Permission denied. Using it in ...
0
votes
0answers
31 views

Oracle Session Numbers Going Crazy - What is the best strategy to over come this issue?

We have a JVM web application which is running on Oracle Application Server and it uses commons-dbcp (http://commons.apache.org/proper/commons-dbcp/) and implicit connection pooling. Our db is Oracle. ...
0
votes
0answers
26 views

Weblogic AS 12c showing “Sealing Violetion: Unable to seal javax.xml.bind.annotation ”. How to resolve?

Weblogic AS 12c showing "Sealing Violation: Unable to seal javax.xml.bind.annotation " during install. How to resolve ? In the second step of the weblogic install screen (the step which get install ...
0
votes
1answer
58 views

SQLPlus for Oracle 11 not rolling back

I have a shell script which invokes an SQL file. However even with AUTOCOMMIT OFF and on SQLERROR EXIT ROLLBACK. Sqlplus fails to rollback. My sql file has 3 lines 3 are correct and 1 is incorrect. ...
0
votes
0answers
103 views

Connect Crystal Report XI to Oracle DB 10g Issue

I tried to connect crystal report to oracle DB but it is failed and the following is the message error that was appeared : Failed to load database information . Below is the environment details : ...
0
votes
1answer
83 views

Oracle Counters for Perfmon

How to install Oracle Counters for Windows Performance Monitor (and operfcfg.exe) on a separate machine (other than the machine where Oracle Database Server is installed) ? The Oracle database version ...
0
votes
1answer
146 views

SP2-0750: You may need to set ORACLE_HOME

I am getting following error message when i write sqlplus on command prompt SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Here are the path details Net ...