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
3 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
5 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
15 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
9 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 ...
0
votes
0answers
9 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
1answer
38 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 ...
1
vote
1answer
18 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
0answers
24 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
votes
1answer
117 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
1
vote
1answer
52 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
17 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
45 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
44 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 ...
1
vote
1answer
40 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
47 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 ...
0
votes
0answers
272 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
188 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
123 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
28 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
0answers
86 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 ...
1
vote
1answer
830 views

ORA-12505, TNS:listener does not currently know of SID after changing port number

I am trying to change oracle tnslsnr port number from default to some other port. After I change port number for tnslsnr from 1521 to 2000 I start geting ORA-12505, TNS:listener does not currently ...
0
votes
0answers
13 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
76 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
22 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 ...
1
vote
1answer
294 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 ...
0
votes
0answers
64 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 ...
1
vote
0answers
43 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, ...
0
votes
1answer
373 views

Why am I getting a 'Memory fault(coredump)' when I start the oracle listener?

This server (AIX ver 6) recently went out due a prolonged power outage. When I try to start the oracle listener I get this $ lsnrctl start Memory fault(coredump)
0
votes
1answer
64 views

How to find database connection information for Oracle on VirtualBox?

I am attempting to run an Oracle database on a Mac OS X system. To do so, I have followed the following guide: ...
-3
votes
1answer
53 views

Why shared-disk architecture is beneficial for Oracle RAC? [closed]

Oracle RAC is using shared-disk architecture. I cant see why this can make the whole product highly scalable or available ? the shared storage can itself turn into a single point of failure. and if we ...
0
votes
1answer
60 views

Transfer enterprise data - tiny volumes - to AWS S3 for Heroku app

What would you suggest is the best option to get "enterprise" data from a client into AWS S3 so we can provide Heroku hosted SaaS? The data volumes are tiny, it's just daily spreadsheet/csv records. ...
0
votes
1answer
180 views

.NET 4.0 applications suddenly stop working with TNS error (IIS 7.5, Oracle 11.2.0 client)

I support an IIS 7.5 web server and I've been having a bit of trouble with my app pools. What I am seeing is every so often, the applications using connections to Oracle databases will stop working ...
0
votes
2answers
82 views

How do I set up Weblogic 12c on Windows to start the http server on boot?

Windows 2008 server, Weblogic 12c. I have a pretty simple setup using nodemanager. My problem is that our webhost likes to patch and reboot the server without telling us, and the HTTP server doesn't ...
1
vote
0answers
337 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 ...
0
votes
1answer
138 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 ...
0
votes
0answers
288 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
334 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 ...
0
votes
2answers
131 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
87 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
113 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
75 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
168 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
112 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
1answer
438 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
0answers
20 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
54 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, ...
-2
votes
1answer
372 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
0answers
24 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 ...
1
vote
0answers
37 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 ...
0
votes
0answers
136 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 ...