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

How do I configure in IBM WebSphere 8.5.5 a data source using Oracle Wallet?

I have a server with a fresh installation of WebSphere Application Server 8.5.5 and I'm trying to configure a data source over a connection using JDBC and Oracle Wallet for SSL. The error message in ...
2
votes
0answers
346 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
665 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 ...
2
votes
0answers
213 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
386 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
298 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
54 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
12 views

How to delete alogs fom Oracle downstream target

I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query: SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG; ...
1
vote
0answers
69 views

tnsping and lsnrctl hung when about to exit – Oracle 12.1.0.2.0 on virtual Windows 7 VM on Mac

I am trying to run an Oracle installation on Windows 7 running in a virtual machine (Parallels or VMware) on a MacBook Pro (Retina, 15-inch, Mid 2015). When executing Oracle utilities like tnsping ...
1
vote
0answers
43 views

How to use java UDF on AWS Oracle RDS?

I am trying to use a java udf in AWS Oracle RDS. On a managed Oracle server I can do this by using something like the following: CALL dbms_java.loadjava('-user <username>/<password> ...
1
vote
0answers
62 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
588 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
39 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
784 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
646 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
131 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
59 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
2k views

Username/password for Oracle Linux 5.8 VirtualMachine

I have the Oracle Linux 5 ova (converted to VirtualBox). The documentation I have seen mentions using either root/oracle or oracle/oracle to login. However that is not working. Any ...
1
vote
0answers
50 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
673 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
134 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
536 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
620 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
1k 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
662 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
57 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
255 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
62 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
539 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
345 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
492 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
1k 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
23 views

Custom oracle linux 6.7 image on google cloud hangs at 'Booting from 0000:7c00'

I am trying to create a custom oracle linux 6 image on Google compute engine. I followed all the steps as described in the google instructional videos here ...
0
votes
0answers
29 views

Error while running sqlplus after installing Oracle Client 11g R2 on RHEL 7

I am facing issue while running ./sqlplus command after installing Oracle Client 11g R2 on RHEL 7 here's is the error: $ ./sqlplus ./sqlplus: symbol lookup error: ...
0
votes
0answers
9 views

Telling how big an oracle DB dump will be when imported

I have an oracle DB dump file that is 30GB and i would like to build a filesystem to support its size once imported - is there a tool/method i can use to tell how big it will be post import ? Thanks ...
0
votes
0answers
9 views

Weblogic server hangs when “Creating data source connection pool named”

I have just installed Weblogic version 10.3.6.0 and created a data source which connects to MSSQL on my localhost. I have tested my connection and verified that a successful connection can be made ...
0
votes
0answers
23 views

c3p0 commit is always called even if queries are not executed(data is coming from Ehcache)

I have a web service which makes readonly call(bunch of select queries) to get data from DB. But it makes call to the database for the first time only, after that, all entities involved are cached in ...
0
votes
0answers
17 views

export vmware disk share ovf for RAC

I have one oracle RAC, which is configured as share disk(rac-node-2 share the vmdk of rac-node-1). Right now, I want to export the ovf template of oracle RAC, I hope when I import the ovf template ...
0
votes
0answers
9 views

Oracle 9i - Data Guard - how to completely resync existing stanby?

Thank's to another SF user, I've managed to recover the control file needed to start a target data guard database in standby mode. So I have an active primary running in ALM keeping only the last 14 ...
0
votes
0answers
44 views

Oracle / Sun ILO reports : Certificate not within the validity period

Trying to use to Oracle ILO(M), when I launch the remote console, Java Web Start starts, but then gives this error : Error screen The more information screen looks like this : More information ...
0
votes
0answers
6 views

Maintain and version controll config- and SQL scripts

I'm looking for recomandations of handling variouse config scripts for a few databaseservers. The scrips fall into the following categories: OS Config scripts and files, such as crontab for multiple ...
0
votes
0answers
50 views

Does CyberArk work with Oracle Dataguard?

Does anyone have experience setting up CyberArk password rotation for oracle databases that use DataGuard. the problem Im running into is that the secondary database is not open, so i need a way to ...
0
votes
0answers
71 views

What is the difference between Oracle WebCenter Content and Oracle Portal?

I'm having a difficult time understanding the difference between these two technologies. What I have understood is: The business logic, and DB connections lies in the Oracle Portal (weblogic server) ...
0
votes
0answers
62 views

siginificance of /dev/oracleasm/iid/*

I am a backup admin and our DB team says these files are required in backups. backups usually cannot protect /dev/ and /proc. kind request for any Oracle DBA to help me here to know siginificance of ...
0
votes
0answers
30 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
145 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
411 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
473 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 ...