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

2
votes
0answers
278 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
166 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 ...
2
votes
0answers
304 views

Dtrace Oracle show high fsflush on solaris 10

Solaris 10 - Oracle 11G in a zone Running mpstat , i've noticed that one CPU was at 100% used every 5 seconds for 5 seconds while all other CPU were fine, in used but nicely spread. 1 0 0 0 ...
2
votes
0answers
268 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 ...
2
votes
0answers
53 views

Equivalent of SQL Server trace for Oracle 10g?

I've got a bad code duplication problem where we cannot tell which versions of packages/procedures are being used. i.e. I have different packages with procedures of the same name and I need to be ...
1
vote
0answers
33 views

Oracle Linux hangs on Hyper-V

I am trying to install Oracle Linux 7.0 on Hyper-V. While I click through the GUI installer the system stops responding. The mouse cursor stays in the same place. It happened to me a few times, ...
1
vote
0answers
249 views

Powershell execute Queries using SQLPLUS

I have a RHEL server with Oracle 10G installed. I need to write a powershell script to query my database and get the output. I have imported Posh-SSH module and am able to connect to my RHEL server ...
1
vote
0answers
36 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
0answers
483 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 ...
1
vote
0answers
550 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 ...
1
vote
0answers
100 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
0answers
52 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 ...
1
vote
0answers
529 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
0answers
45 views

Export data from Oracle Lite 10gR1 odb file

I hope you can help me with this one. Years ago (2005) someone way before me set up a server with WinXP and a custom-written Java/Tomcat-whatever application for monitoring some sensors, the database ...
1
vote
0answers
594 views

SSD Performance under Oracle

I have serious performance issues with oracle running over ssd. I have two OCZ Vertex 3 MAX IOPS drives (firmware 2.15). It runs on a INTEL C600 SATA Chipset. Windows 2008 R2. So the issue is ...
1
vote
0answers
122 views

iPlanet Authentication provider

Good day. I have stepped into project that requires a server migration that would change the means of authentication for our CAC/PKI SSL enabled website. We are using iPlanet 7 and Oracle Directory ...
1
vote
0answers
472 views

Oracle Virtual Server OEL vm fails to start - kernel panic on cpu identify

I am in the process of following a guide to setup various oracle vm templates, so far I have installed OVS 2. 2 and got the OVM Manager working, imported the template for OEL5U5 and created a vm from ...
1
vote
0answers
526 views

PHP5 OCI8 FreeBSD

I'm running a FreeBSD server with Apache and PHP 5.3. I'm trying to get the Oracle DB extension (OCI8) running with PHP but I can't find a port or anything for it. Half of the Internet says it's no ...
1
vote
0answers
773 views

cx_Oracle - InterfaceError: Unable to acquire Oracle environment handle

I have installed Django on Ubuntu 12.04 behind NGINX with uWSGI. I use Postgresql as the main database for the application however I need to retrieve some data from an Oracle database. I have ...
1
vote
0answers
1k views

Oracle 11gR2 error while installing on RHEL6_x64

Whenever I attempt to install Oracle it gives me this error in the install wizard on the group configuration screen. I am using group oinstall and user oracle has also been created. INS-30060] Check ...
1
vote
0answers
604 views

Intermittent java.sql.SQLException: ORA-03120: two-taskconversion routine: integer overflow exception

I get the following error intermittently when my spring app starts up. I am using oracle with dbcp pooling as my datasource bean in spring. Caused by: org.apache.commons.dbcp.SQLNestedException: ...
1
vote
0answers
56 views

Oracle SGD 4.61.915 not closing Windows 2003 application sessions

I'm using a Windows 2003 Application Server and I have followed this article: http://download.oracle.com/docs/cd/E19351-01/821-1926/z40000df1311155.html#bbjiefec but still.. when i close a application ...
1
vote
0answers
241 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 ...
1
vote
0answers
59 views

Oracle Grid Control Notification for Data Guard failures

Does anyone know a way to configure a Grid Control notification rule for a failure of the SQL APPLY process on a logical standby database? I'd really like an email notification that the SQL APPLY ...
1
vote
0answers
481 views

Switched Oracle to use Shared Servers, now Java app throws SQLRecoverableExceptions

This issue might blur the line between Java and database problem, so I apologize if this is the wrong place for it. Not sure which side is to blame yet. I'm a Java developer temporarily playing DBA ...
1
vote
0answers
336 views

SSIS on W2K8 R2, SQL Server 2008 SP2 and Oracle

I'm in the process of migrating an old SQL Server 2000 SP4 on Windows 2000 to a new SQL Server 2008 SP2 on Windows 2008. In the old server we have a DTS that does some simple tasks against an Oracle ...
1
vote
0answers
452 views

Oracle Instant Client DSN via unixODBC

I've got the Oracle Instant Client installed on a SuSE webserver and I'm attempting to connect to an Oracle Database with PHP via unixODBC. The connection seems to be working properly, after issuing ...
1
vote
0answers
3k views

IIS can't load Oracle.Web assembly (for ASP.NET membership provider)

I am trying to configure an IIS web site to use an Oracle database for ASP.NET membership, but I can't get it to work. IIS doesn't seem to be able to load the assembly containing the Oracle ...
1
vote
0answers
923 views

listener could not find available handler for requested type of server

I have ora-12520. I run Oracle 11g on Red Hat 4 64 bit. Actually I have RAC but one node is down and I work only with up one (connection string point directly to listener of running node). I run test ...
0
votes
0answers
13 views

Is using sqlplus in a server environment considered as a bad practice?

We have a web application (a COTS product) and we need to query the application DB periodically using an external scheduler for alert purposes. DB is Oracle, se we decided to schedule a job on the ...
0
votes
0answers
21 views

Weblogic silent installation fails

I am trying to install Weblogic 12.1.3 to my Ubuntu Server 15.04 running on Vmware. I followed every step mentioned here (for single instance and instead of using /u02 I used /u01 folder. The rest is ...
0
votes
0answers
124 views

Oracle 11.2 linked server from SQL Server: missing oraclient11.dll required for distributed transactions

I've set up a linked server to Oracle 11g R2 in my 32-bit SQL Server 2005 instance, using the Oracle-provided OraOLEDB.Oracle. When I try to query against the linked server from SSMS, I get OLE DB ...
0
votes
0answers
82 views

Oracle UTL_HTTP with SHA-256

I use Oracle Express Edition 11G (11.2.0.2.0). Sometimes we need to call a webservice using UTL_HTTP. If the webservice is using https we need to use Oracle Wallet where we download the server's SSL ...
0
votes
0answers
52 views

Oracle 6i reports engine crash on Windows server 2008r2

Background: We have Oracle 6i applications that used to run on Windows server 2003. We've migrated to 2008r2, and we managed to get these applications running almost perfectly (took a while and a lot ...
0
votes
0answers
11 views

Installing BI Publisher 10 and 11 on the same machine

I was using BIP 11g previously but need to generate reports for an older version of our application which had 10g. Wanted to know if it is possible to have both versions installed on configured in the ...
0
votes
0answers
61 views

Error with OraOLEDB.Oracle in PowerShell

I am a sysadmin who primarily handles Powershell scripting for our AD environment, and we periodically hit this error in both our test environment and in live. Exception calling "Open" with "0" ...
0
votes
0answers
18 views

What does Oracle Data Access Components Release number mean?

I need to document the Oracle Data Access Component installed on our system. The current version we have installed is 12.1.0.1.2. What does each number indicate ? I searched but could only find ...
0
votes
0answers
45 views

Extremely high TTFB when connecting to Oracle DB 11 via ODP.net

After mutiple days of searching Google, I still have the following issue: I have an internal website, which is hosted on Win2012 server, and uses ODP.NET to connect to an oracle db. The issue is ...
0
votes
0answers
229 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
0answers
76 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
0answers
85 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
0answers
58 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 ...
0
votes
0answers
81 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
19 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
0answers
23 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 ...
0
votes
0answers
118 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
0answers
101 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 ...
0
votes
0answers
212 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
132 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
83 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 ...