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

1
vote
2answers
3k views

Find Current open Cursors in Oracle

What is the query to find the no. of current open cursors in an Oracle Instance? Also, what is the accuracy/update frequency of this data? I am using Oracle 10gR2
0
votes
1answer
68 views

Creating javaroles in Oracle 11g XE

I have installed Oracle 11g Express Edition in my system.I want to create user who has got the role javauserpriv. After creating the user I ran the following command grant javauserpriv to dbuser(new ...
1
vote
1answer
118 views

Oracle EE 11.2g: how to generate fresh new redo logs

In the company I work for we are heavy users of VMware machines. Almost all our projects are developed inside a virtual environment up to the point where we have to deploy them into a production ...
3
votes
5answers
1k views

Should Oracle *online* redo logs be backed up?

Obviously archived redo logs are backed up as frequently as required, but does it make any sense to backup online redo logs? Is the online redo log an open and active file such that copying it in this ...
3
votes
1answer
804 views

Is there a way to easily run the same query in Toad against multiple Oracle database servers?

I have several servers hosting data for the same application, and I want to see the results of the same query from different servers.
0
votes
0answers
188 views

Installing PHP OCI8 extension on SLES 11 with PHP 5.6.3 Oracle Instantclient 12.1 and APACHE2

I attempting to install the OCI8 extension. The OCI8 extension version is oci-2.0.8. The configure script to install is "./configure --with-oci8=instantclient,/usr/lib/oracle/12.1/client64/lib". ...
0
votes
1answer
158 views

yum Cannot open: oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm. Skipping

I am following this article on installing the oracle client RPMs on a CentOs 6.x server using yum localinstall.for some reason yum cannot open the RPMs - and I am at a loss as to what the next step ...
1
vote
2answers
2k views

latest version of oracle developer including forms and reports

What is the latest version of Oracle Developer which includes Oracle Forms and Reports? I am taking a Database Administration class in college. The professor is installing Oracle Developer 6i but ...
0
votes
2answers
76 views

OBIEE Upgrade from 11.1.1.5 to 11.1.1.7

Need assistance upgrading OracleBIEE 11.1.1.5 to 11.1.1.7 using In-Place upgrade i.e. with patch set assistance. Would like to know the following : The Pre-Requisite work (like taking backup of ...
0
votes
0answers
67 views

Configuring Oracle Access Manager to use x509 authentication

Hello members of Serverfault, I am new to serverfault and my knowledge of Oracle Access Manager(OAM) and x509 authentication is minimal. I have attempted searching the rest of serverfault and have ...
0
votes
1answer
81 views

Is Oracle Smartscan really effective?

Oracle is marketing Exadata to our company, and they're focusing on Smartscan, which is, advertised 10x more effective than traditional solution. I don't really understand (and somewhat don't really ...
0
votes
0answers
61 views

cx_Oracle suddenly slow to connect

Have a test machine set up with oracle 11g installed: I'm trying to connect with python and cx_Oracle. Yesterday, my code worked perfectly: import cx_Oracle print "connecting..." with ...
0
votes
1answer
464 views

SQL / OracleDB: How to set the same value for all fields in a column?

Is it possible to set a value for all fields in a column, e.g.: ID Host URI 1 //cyrus /images 2 //cyrus /videos 3 //cyrus /text 4 //cyrus /misc 5 //cyrus /backup I want be able to ...
2
votes
1answer
1k views

Oracle Account Not Responding

I have an Oracle instance which has user1, user2 and user3 accounts. Yesterday I was able to log in to all three accounts. Today, I can get in to user1 and user3, but user2 is completely 'frozen' in ...
0
votes
0answers
48 views

Broken Pipe error being thrown when configuring OAM 11g for simple mode

I looking for some advice/help with OAM 11g which when configured for simple mode with a 10g Seagate throws an error on the oam server of broken pipe. The set up is oam server is on a Linux 64 bit ...
1
vote
2answers
79 views

Why does my Apache access log timestamp sometimes go backwards?

I noticed that in my Apache log (actually Oracle's branded HTTP Server, which is really Apache) the timestamp of the lines sometimes goes down, instead of up. Here is an example: 1.2.3.4 - - ...
0
votes
0answers
66 views

Oracle 12c post install addition of MTS component fails with 'Failed to Grant Priveleges on specified Oracle home type .'

Is there a workaround in the Oracle 12c Universal Installer for the following error? Failed to Grant Priveleges on specified Oracle home type . [sic] It occurs when I run the Universal Installer on ...
0
votes
0answers
18 views

change x4270 ilom snmp destination ip for many servers

We are changing our NMS and need to redirect all the ilom snmp traps to the new one (only IP is changed). We have about 52 servers which need this change. Is there some option to change these IPs in ...
0
votes
1answer
288 views

Oracle 11g MTS install fails with error: OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull

Is there a workaround in the Oracle 11g Universal Installer for the following error? OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull in component oracle ...
0
votes
1answer
36 views

Dump users and group membership to file

I'm trying to get an oracle 6.2 system (same as redhat 6.2) to find all the users on the system, then take the username of each user discovered and query group membership of each user individually, ...
0
votes
2answers
7k views

Oracle 11gR2: NLS_CHARACTERSET accidentally removed with an UPDATE-Query

I have a fresh installation of Oracle 11gr2_x64 on CentOS. After the installation I wanted to get productive and started to import my dumps. One of the dumps caused characterset error so I tried to ...
0
votes
2answers
2k views

How to get Sun X4100 Firmware updates from Oracle?

This document directs how to get there, but it is for the old Sun website. http://download.oracle.com/docs/cd/E19569-01/820-1188-12/core_ilom_firmware.html#50413605_67571 Download the flash image ...
2
votes
5answers
1k views

Why does this SQL run so much faster in a Oracle server with the same hardware/data than another Oracle server?

My application has a SQL that takes ~ 30 min to run in the Oracle server in production. It takes about the same in a test Oracle server. For some reason, in another Oracle server, it runs much ...
-2
votes
1answer
275 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
5answers
6k views

How to connect to oracle server in java?

I am trying to connect to my friends Oracle server. But while connection I am getting error please help..... JDBC code Class.forName(oracle.jdbc.driver.OracleDriver).newInstance(); ...
0
votes
0answers
92 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
80 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
3answers
888 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? ...
1
vote
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
15k 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
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 ...
2
votes
1answer
377 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
19 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
258 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
35k 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
1k 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
260 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
102 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
44 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
89k 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
3k 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
252 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
764 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
317 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
236 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
41k 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
525 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
103 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... ...
4
votes
1answer
7k 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 ...