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
12 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
1answer
19 views

Oracle 9i - Data guard target DB - lost control files, can I recreate from primary database?

I'm dealing with a problem whereby a I have a database that is managed using data guard using Redo Apply, so redo logs are copied to the target database, applied and kept in sync ready for fail over. ...
1
vote
1answer
4k 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 ...
-1
votes
1answer
624 views

HP Proliant DL380 Gen9

I have HP proliant DL380 Gen9 I do the installation oracle linux 6.4 and installation does not detect the logical drive created. i have 300GB SAS- on raid 0 logical drive
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)?
2
votes
2answers
17k views

Oracle throwing this error: could not open registry key SOFTWARE\Oracle\ocr

I have an oracle installation that runs fine 95% percent of the time. But for some reason every day at a random time early in the morning (between 4:00am and 9:00am) I get the following error: [ ...
0
votes
2answers
3k 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 ...
1
vote
0answers
60 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> ...
3
votes
1answer
4k 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 ...
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
79 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
1answer
56 views

Simple Paged Results control on Sun-Directory-Server/11.1.1.5.1

I am confused. I am trying to run simple pager results against what I believe is Oracle 11g Directory Server. I know that an old version at some point did not support RFC 2696. Now, according to ...
2
votes
0answers
242 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 ...
0
votes
0answers
114 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) ...
2
votes
1answer
125 views

Are IOPS capped at 3000 for AWS Oracle RDS with General Purpose (SSD) (gp2)?

Documentation at http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html says This storage type can deliver single-digit millisecond latencies, with a base performance of 3 IOPS/GB ...
0
votes
2answers
891 views

How do I install Oracle Linux 6 with the UEK over the Internet?

Is it possible to use the Oracle Linux 6 UEK download and download the rest of the OS over the Internet? I have UEK running. I selected URL for the Installation Method. I tried various URLs for ...
1
vote
1answer
251 views

Connecting to Oracle DB hosted on Windows 8.1 Azure VM

I have a windows 8.1 vm created on azure, it has 14 GB of memory and 200 some GB storage. I have installed Oracle with a templated database onto it. Everything is fine with the installation and I can ...
0
votes
0answers
81 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 ...
1
vote
2answers
4k views

How do I set the ORACLE_HOME variable for the Local System account?

I've run into an issue with one of my systems where multiple Oracle versions are installed for the support of various applications, but I need to run a program as a Windows service using the Local ...
1
vote
1answer
94 views

Setup freeIPA to handle Oracle Database name resolution

I am trying to setup freeIPA to handle Oracle Database name resolution. I have followed this tutorial for OpenLDAP http://www.idevelopment.info/data/Oracle/DBA_tips/LDAP/LDAP_8.shtml The schema ...
0
votes
0answers
31 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
253 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 ...
-1
votes
1answer
114 views

Using xhost, display and startx - confused

I have a client A (192.168.1.1)(vncviewer) accessing Server B (192.168.2.1) (RHEL6) to run a installer. The installation pre-requisite is to set the xhost and DISPLAY properly. Q1) Please correct me ...
2
votes
6answers
34k views

TNS-12535: TNS:operation timed out — Oracle DB

I'm seeing a lot of queries from a .Net data access server I maintain timing out. It appears to be totally random with no relationship to data or data locks. For example, the following query timed ...
5
votes
3answers
8k views

When to relink Oracle?

Various sources on the internet suggest relinking of Oracle binaries is necessary after each OS upgrade and / or patch. I can understand relinking would be necessary when upgrading glibc. Some ...
1
vote
6answers
5k 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 ...
1
vote
1answer
89 views

Can I “flush and lock” an Oracle database to do a filesystem backup?

I'm using ZFS to take snapshots of running OpenVZ containers. For MySQL databases I can use flush tables with read lock to put them in a flushed & locked state. This will put the underlying files ...
0
votes
1answer
226 views

Weblogic Server state changed to FORCE_SHUTTING_DOWN

I have a problem in Weblogic. When you run the script startWebLogic.sh the weblogic does not start. Below is the log. oracle.security.jps.JpsRuntimeException: ...
0
votes
1answer
953 views

javax.naming.InvalidNameException using Oracle BPM and weblogic when accessing directory

We are getting this exception when we start our cluster (2 managed servers, 1 admin), we have deployed only the ears corresponding to the OBPM 10.3.1 SP1 in a weblogic 10.3. When the server cluster ...
0
votes
1answer
96 views

How do I prevent Oracle from writing to datafile when I start database?

I am creating a Docker image for Oracle database, and many different containers will be generated from the same image. When I start the Oracle instance, for some reason a few bytes are written to all ...
3
votes
8answers
14k views

Oracle 11gR2 exp does not export some tables

I have an Oracle 11g (11.2.0.1) Database running on Linux (x64). Within the database I have a schema and 33 tables for it (all in the same tablespace). When I log in via sqlplus I can list all the ...
0
votes
0answers
591 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
1answer
48 views

Oracle Database with autofs

We run our oracle databases (11 & 12) on NFS on Redhat 6. We do not use ASM. Is it acceptable to use autofs for all of the various oracle files? Thanks, Al
0
votes
3answers
2k views

How do I redirect Weblogic logging to database?

Is there a way to send or redirect Weblogic (or Fusion Middleware) logging output to a database, without having to write a custom application? All the documentation I've read seem to deal exclusively ...
0
votes
1answer
536 views

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history? For instance, I want to move from BPEL instances deployed to defined partition on Oracle SOA to ...
11
votes
2answers
17k views

Disable CPU cores in bios?

Is it possible to disable CPU (Intel) cores in BIOS, and if yes what HP/DELL (others?) 1U/2U servers would allow this? It is becoming difficult to find new server hardware with dual core CPUs, most ...
3
votes
1answer
79 views

Oracle SOA repository migration

Does anybody know whether it is possible to migrate Oracle SOA repository from a simple Oracle database to Oracle RAC?
0
votes
0answers
216 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 ...
2
votes
1answer
12k views

Cannot create Oracle ODBC source on 64bit Windows 7 [closed]

I have installed the 64-bit version of the Oracle ODBC driver (instantclient-odbc-windows.x64-12.1.0.1.0 from http://www.oracle.com/technetwork/topics/winx64soft-089540.html) on my 64 bit Windows 7 ...
6
votes
3answers
236 views

Oracle: 1 Large Server vs. 2 Smaller Servers?

We are in the planning stages of setting up our production Oracle 10gR2 environment. Our budget gives us the ability to buy 2 processor licenses of Oracle DB Standard Edition. We have minimal ...
2
votes
1answer
10k 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 ...
1
vote
1answer
842 views

Oracle 10.2.0.1 --> 10.2.0.4 patchset errors on Advanced Queuing tables

We're running Oracle on RHEL 5.4 64-bit. We recently did an upgrade from 10.2.0.1 to 10.2.0.4. Many errors were generated during the upgrade (sample listed below from trace.log) but during ...
0
votes
0answers
24 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 ...
3
votes
3answers
5k views

How can I find my Oracle 10g server version?

I don't have physical access to my Oracle server but I can run some sql command from Toad. Is there a way I can find wich version the server is running, like 10.2.3.1. I know it's 10g but I'd like to ...
4
votes
1answer
47k views

How to execute datapump commands as sysdba from remote machine

I would like to know the syntax to call datapump commands (expdp/impdp) logged as 'sys as sysdba' from a remote machine. I know that when logged on the machine which runs the database, I can use : ...
1
vote
1answer
719 views

How To Remove Non-Existent/Phantom Yum Repository?

TL;DR... I'm replacing public yum repos with an internal one and I can't figure out why two public ones continue to display in "yum repolist" when they don't appear in the normal config files. I've ...
2
votes
1answer
115 views

Migrating Oracle DB to another operating system from Red Hat Enterprise by using a disk image

I have a Red Hat Enterprise server disk image that Oracle DB is installed on it. My question is : Is it even possible to use this disk image in order to setup same DB on another Oracle supported ...
1
vote
1answer
1k views

Oracle: TRUNCATE sometimes takes ages

Usually, truncating a table takes 5-10 seconds. But when several people work on the same DB instance (but different tables), the operation can take more than an hour. How do I debug this?
1
vote
0answers
68 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, ...