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
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 ...
2
votes
2answers
2k views

prevent ORA-28001?

Using Oracle 11g, is there a way to prevent my user's passwords from needing to be updated (ORA-28001)?
1
vote
2answers
41 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 ...
1
vote
1answer
208 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 ...
3
votes
2answers
144 views

Need simple graphical interface for Oracle IMP utility

the company receives several Oracle database dumps from clients for analysis. My programmers are not Oracle literate and find it difficult to restore the dumps using the IMP utility. They need a ...
0
votes
1answer
21 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 ...
3
votes
4answers
3k views

How to delete data and free up disk space in Oracle DBMS 9i

I would like to know how usually one would delete data from an Oracle 9i DBMS which actually frees up disc space. Past scenario, we have had cases where clearing up 1-2 million rows of data does not ...
0
votes
1answer
32 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 ...
1
vote
1answer
5k 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 ...
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 ...
3
votes
1answer
4k 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 ...
0
votes
0answers
20 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 ...
1
vote
2answers
925 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 ...
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 ...
1
vote
1answer
960 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
2k 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

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? ...
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
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 ...
0
votes
1answer
903 views

How can I install Oracle ASM on Ubuntu Linux?

I am trying to install Oracle ASM on Ubuntu but I couldn't find ubuntu packages for ASM. Is there any way to install Oracle ASM on Ubuntu?
1
vote
0answers
103 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
28 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 ...
2
votes
2answers
1k views

oracle admin accounts can be disabled?

Are there any undesirable effects if I disable all oracle admin accounts (sys, sysman..) and use new admin accounts? I'm afraid oracle itself might use such default admin accounts for processing? ...
2
votes
1answer
43 views

Multiple Oracle DB's on network

Im about to install a std edition of oracle 10g on my own machine for testing only. However we allready have an Oracle db on our network. Is it possible that I might cause any problems for the other ...
0
votes
0answers
23 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
122 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
30 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 ...
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. ...
2
votes
3answers
5k 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
0answers
22 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
113 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
6answers
5k 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 ...
-3
votes
1answer
845 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
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 ...
0
votes
0answers
55 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 ...
2
votes
0answers
213 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
169 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
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
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
0answers
307 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
197 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
341 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
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 ...
-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
97 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 ...
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 ...