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

Oracle GNS (Grid Naming Service) Breaks DNS

Am running a 2-node Oracle 12.1.0.2.0 ASM Flex Cluster using Oracle GNS which I believe uses zeroconf to create it's adhoc network. Before GNS starts, DNS works, i.e. nslookup, dig, ping, ssh all ...
2
votes
1answer
54 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
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 ...
0
votes
3answers
844 views

SQL Server Migration Assistant for Oracle

I've recently installed SSMA and after connecting to both the Oracle instance (which holds the database to be converted) and the SQL Server I've mapped the necessary schemas from Oracle to MSSQL. The ...
1
vote
2answers
2k views

Configure Perl DBI and DBD in Linux

I am new to Perl and I work in a Linux OEL 5x server. I am trying to configure the Perl DB modules for Oracle connectivity (DBD and DBI modules). Can anyone help me out in the installation procedure? ...
0
votes
0answers
15 views

client crash after installing libpam-ldap and nscd and getting users authenticated by ldapserver [closed]

I configured a client machine for authentication through LDAP server. Using this tutorial. I was able to authenticate an LDAP user from the server. But when I restarted the machine, it failed to ...
-2
votes
0answers
15 views

enable fanotify on oracle redhat linux kernel 2.6.39-400

As a newbie in linux environment, I am trying to install clamav daemon, which is clamd, on oracle redhat linux 6 kernel EUK 2.6.39-400. It needs to have fanotify enabled in the kernel. As I see there ...
0
votes
1answer
2k views

How can I turn of redo logging on a materialized view refresh?

10gR2 Database, in Data Guard configuration to both a physical and logical standby. I have a materialized view that does a complete refresh periodically of about 40K records from a remote database. ...
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 ...
1
vote
0answers
22 views

Axis DMsuite RESTful API

I'm looking at Axis DMsuite for masking Oracle databases. I was told by their staff that they exposed some simple REST endpoints for triggering masking jobs, but I have done a fair bit of searching ...
1
vote
1answer
6k 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 ...
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 ...
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 ...
-1
votes
0answers
14 views

using update query with subquery in Oracle sql [migrated]

I have an update query where I am trying to update a field but for more than one record, I am trying a join but it doesn't work. Below I get multiple values that come back from the select statement ...
1
vote
2answers
1k 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 ...
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

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

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 ...
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
2k 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 ...
2
votes
1answer
265 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 ...
0
votes
0answers
10 views

Oracle Enterprise Manager getting users from administered databases

it is possible to get via SQL all Users/Schemas from the Oracle Enterprise Manager? Besides the Users/Schemas of the Oracle Enterprise Manager I want to have all the administrated Users/Schemas from ...
2
votes
0answers
215 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 ...
4
votes
4answers
30k views

Oracle difference between SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name

Can someone explain to me what's the difference of SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name in Oracle ? Thanks Michael
1
vote
1answer
541 views

Internet Explorer 8 - TLS Fatal Error Close Notify - Oracle HTTP - Server Apache 2.2.22.0

I applied the POODLE fix for Apache via "SSLProtocol All -SSLv2 -SSLv3" in the ssl.conf file for our Apache server but am having issues with the CAC Client authentication via "SSLVerifyClient ...
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 ...
0
votes
0answers
45 views

E5-2667V3 or E5-2640V3 for HP BL460c Gen9 and Oracle Linux 6 + Oracle 12c

We are currently designing a new shared environment (2-4 nodes cluster) which will have: HP BL460c Gen9; OEL 6.6; Oracle 12c database on Oracle Grid infrastructure (with ASM). The plan is to have 8-10 ...
0
votes
2answers
41 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 ...
6
votes
4answers
82k views

How to restore/import an Oracle database from dmp file?

I've recently recieved the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now i need to restore the original database. Can anyone give me a step to step ...
1
vote
2answers
2k views

How to find out the current SGA memory distribution?

How can I get the current SGA memory distribution on Oracle 10G? Something like this: AME SIZE_MB RES -------------------------------- ---------- --- Maximum SGA Size ...
1
vote
3answers
241 views

Easy way to wipe a set of Oracle schemas

How can you wipe a set of Oracle schemas? By wipe I mean remove all data, tables, views, procedures, synonyms, etc, etc.
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
1answer
74 views

Installing Weblogic 12 on Windows 8 Server - http server won't start

Apologies in advance for the terrible formatting - I spent more time getting to this point than I did asking my question. I'm trying to install Weblogic 12 on Windows 8 Server. I've followed the ...
1
vote
0answers
225 views

Oracle ODBC: DB on Windows Server 2003 – Windows 7 Client Connection Problems

I have an Oracle DB on a Win 2k3 Server (64-Bit). I have to access the database from a Win7 (64-Bit) machine. I have downloaded Instant Client and the 64-Bit ODBC driver, and have apparently ...
4
votes
3answers
33k views

Oracle: how to find out storage space used by a table?

How to find out (if possible via Enterprise Manager), the total in Mb that a certain table is using?
1
vote
0answers
315 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
1answer
34 views

Dependency error installing Oracle Client SDK on Linux

Trying to install Oracle Client and the SDK on Red Hat Linux EL6: [~]: sudo rpm -ivh oracle-instantclient12.1-basiclite-12.1.0.2.0-1.x86_64.rpm Preparing... ...
3
votes
1answer
3k 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
3answers
2k 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 ...
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
62 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
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 ...
3
votes
2answers
145 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
43 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
102 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
92 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
1answer
920 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
200 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
69 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 ...