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

ORA-01019 under Win 8.1 / Server 2012 R2, ODBC Excel

We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1. We are having the same issue ...
1
vote
1answer
4k views

Oracle: FRM-41211 Error Message when starting a Report from Oracle Forms (64 Bit Windows Server)

After installing Oracle Forms and Reports 6.0 (Patch 18) on a Windows 2008 64 Bit server we get the following error when we try to start a report from Forms. "FRM-41211 integration error: ssl failure ...
3
votes
6answers
4k views

Oracle real time database mirroring

Does Oracle have any built-in features to support a master-slave mirroring mechanism ? I am looking to mirror/replicate the production server on to a read-only database. The read-only database would ...
2
votes
1answer
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
2
votes
1answer
2k 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 ...
0
votes
0answers
11 views

Restore an oracle dmp file [migrated]

I've been given an oracle DMP file that was created on a solaris system which I need to restore to a windows system. I've created the DB with the correct blocksize, but when I try and do the restore ...
3
votes
1answer
3k views

Oracle 10g for Windows does not start up on system boot

We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to ...
-3
votes
1answer
58 views

SSH - Connection refused [closed]

I have setup on a server VMware ESXi 5.5.0. I have add the operating system Oracle Linux 5 I'm trying to setup ssh for local computers that runs on Ubuntu. But I get the error Connection refused. I ...
1
vote
1answer
846 views

PHP oci8 dll not loading on windows 64 bit XP. What am I doing wrong?

on win 64, I installed apache, php etc. Everything works fine, except the oracle part. I can connect to oracle from sql developer which means my tnsnames.ora file is correct. When apache starts, there ...
0
votes
1answer
53 views

ERROR: Not enough space?

Now this is a very unspecific question. I'm trying to figure out what this message would mean. Here is the story behind it: I'm installing Oracle enterprise manager cloud control (12c r3) on Solaris ...
1
vote
2answers
739 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 ...
1
vote
1answer
977 views

What permissions do I need to run SQL*Loader?

What permissions does a database user need to be able to run oracle's sql loader? For instance, since sql loader will disable indexes and triggers, does it need ALTER permissions for those items? ...
0
votes
1answer
1k views

Cannot start Oracle XE 11gR2 Net Listener and Database on Ubuntu 13.04

I have been following the setup step on this article for installing Oracle XE 11g R2 on Ubuntu 13.04. The environment variables PATH, ORACLE_HOME, ORACLE_SID, NLS_LANG ORACLE_BASE have all been set up ...
1
vote
1answer
1k views

ora-12505 error while starting new connection

I got this error while starting new connection in Oracle 11g: Listern refused the connection with the follwoing error: ORA-12505,TNS: Listner does not currently know of SID given in connect ...
0
votes
0answers
18 views

Oracle 6.5: MySQL Daemon failed to start

I installed MySQL by following these instructions on my Oracle Linux Server release 6.5, specifically using the yum package installer command, yum install mysql mysql-server mysql-libs mysql-server ...
1
vote
1answer
1k 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. ...
0
votes
1answer
960 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
0answers
6 views

How can I prevent having inconsistent data under isolation level serializable in Oracle SQL? [migrated]

I have the following table: InStores +--------+---------+-----+ | ProdID | StoreID | qty | +--------+---------+-----+ | p1 | s1 | 25 | | p1 | s2 | 70 | +--------+---------+-----+ ...
1
vote
0answers
77 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 ...
2
votes
0answers
40 views

doing ODBC System DSN's from Active Directory

2008R2 Active Directory, workstations are Win7 Ent, Office/Excel 2013, Oracle 11.2. Excel fetches data from Oracle using System DSN's. Where can I put ODBC System DSN's in Active Directory? Do I ...
2
votes
0answers
231 views

Installing Oracle 32bit and 64bit client on the same machine

So I need to have both the 32bit and 64bit clients for Oracle 11g coexist on the same machine. I have installed both together before, but there are many issues where applications that need to use the ...
0
votes
0answers
325 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
0answers
7 views

Need help in installing Oracle RAC with EBS

I have an running Oracle 2 node RAC. I need to setup an single node Oracle EBS which need to use the RAC cluster for data. Is there any specific process I should follow. I heard that Oracle EBS ...
0
votes
0answers
205 views

Oracle 11gR2 Listener stop automatically

My problem is after I started Oracle Listener succesfully, it will stop automatically after a few seconds. cache1-> lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-MAY-2013 ...
0
votes
1answer
40 views

WLS: Oracle data source yields “ORA-01435: user does not exist”

So I am trying to setup a new data source in a Weblogic Server (12c), but I'm getting the same error over and over: java.sql.SQLException: ORA-01435: user does not exist This looks pretty ...
3
votes
3answers
290 views

Restore Oracle 9 backup on Oracle 11 server?

We have a client who is using Oracle 9i on their old server, and they want to switch to Oracle 11 on the new server. They want to backup the old database and restore it on the new server. Is this ...
1
vote
1answer
56 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 ...
-2
votes
2answers
36 views

Virtual machine access [closed]

My host OS is Windows 7 and guest - Oracle Linux. I've got an appliaction which is running using JBoss and ngnix on guest. How can I connect to this app throgh host OS?
0
votes
0answers
53 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
31 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
579 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
58 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 ...
1
vote
2answers
2k 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 ...
0
votes
1answer
32 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
46 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 ...
1
vote
1answer
54 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 ...
0
votes
0answers
37 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 ...
2
votes
2answers
13k views

Setup Oracle instant client on CentOS/RHEL Linux - for PHP and Perl

I'm trying to setup a CentOS 5.5/64 bit VM to access a remote Oracle database with PHP and Perl scripts. (I have no experience with Oracle, have only programmed and administrated some PostgreSQl and ...
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
636 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
113 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
1answer
24 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
0answers
229 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
47 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 ...
2
votes
2answers
2k views

Oracle: replacing tnsnames.ora with LDAP lookup?

How do I go about replacing client-side tnsnames.ora with an ldap query? I'm not interested in running Oracle LDAP, we have an existing LDAP infrastructure. I need: format of LDAP entry how client ...
1
vote
0answers
23 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
30 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 ...
1
vote
3answers
2k 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 ...
3
votes
2answers
906 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 ...
-2
votes
1answer
101 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?