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

Remote desktop disabled for oracle user

Recently while installing Oracle 12C DB on Windows server 2008 R2. I created an user called Oracle through the Oracle DB installation setup. Now am unable to login remotely into the machine with this ...
1
vote
2answers
42 views

How to crash Oracle VM intentionally by loading system parameters

I am using Oracle VM. I want to perform a stress test on system parameters like CPU, RAM etc. Can anyone help me out with the ways in which I can load the parameters with high load like using all the ...
0
votes
1answer
35 views

Unable to connect to Oracle database from certain client machines

I have an application that connects to an Oracle database that works fine in development on any development machine I can find but falls over with the following error when being ran from a production ...
0
votes
0answers
22 views

Websphere 8.5 not instantiating jdbc connection in jndi

I am trying to create a basic connection to a remote oracle machine. I have the datasource configured in websphere console and when I test the connection, it comes back as tested good. But when I ...
0
votes
0answers
20 views

How to give Entity Framework access to Oracle DB inside DMZ?

We are having issues with our current ASP.Net WebAPI application that uses Entity Framework to access our Oracle DB whereby we must use a proxy to give access to our DB. This has caused all kinds of ...
1
vote
0answers
106 views

Unable to convert JKS keystore to Oracle Wallet using orapki

I have generated jks keystore using keytool and using the jks keystore I have csr. The same csr I have sent to Signing authority. The Signing authority have given the trusted ...
0
votes
0answers
31 views

Why is my TPS/TPM value so different between benchmark factory and HammerDB?

I am using both benchmark factory and HammerDB to generate load against an Oracle 12 database. In both cases I use the same DB on the same storage. In both cases I use a warehouse size of 100. When ...
0
votes
0answers
24 views

dynamic IP firewall configuration for public-yum.oracle.com and clam AV

I currently have Clam AV installed as the AV solution for an Oracle Linux environment. The firewall that I use allow filtering only through specific IPs and thus currently, I am not able to configure ...
0
votes
0answers
126 views

Upgrading to Java 7u65 breaks my Deployment Rule Set for Oracle applications

My company uses an older version of an Oracle application that requires Java 6u45. Naturally we want to be secure, so we use a Deployment Rule Set to specify 6u45 for that internal application and let ...
0
votes
0answers
31 views

Cannot connect to Solaris Server when Oracle GoldenGate process uses the port

I'm trying to test the Oracle goldengate to replicate data between two databases on the same server. So I installed two databases and two goldengate homes in the same machine. The goldengate ...
0
votes
0answers
25 views

Apache mod_authn_dba with Oracle on Windows

How can I configure Apache to authenticate against Oracle dbms? According to this link Oracle database is natively supported. No additional software required. Loading those modules: LoadModule ...
0
votes
1answer
116 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 ...
-3
votes
1answer
877 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 ...
0
votes
0answers
56 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 ...
0
votes
1answer
84 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 ...
2
votes
0answers
172 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
2k 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
13 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
1answer
203 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 ...
-2
votes
2answers
39 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
99 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
50 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
1k 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
102 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
1k 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
71 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
68 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
64 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 ...
9
votes
2answers
802 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
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
1answer
154 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
461 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
85 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
38 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
45 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
143 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?
2
votes
0answers
216 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
2k 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
81 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
324 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
67 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
47 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
175 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
150 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
72 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
3k 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
945 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
118 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 ...
1
vote
1answer
84 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
430 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 ...