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

9
votes
2answers
13k 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 ...
1
vote
1answer
813 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
17 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" ...
2
votes
1answer
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
0
votes
0answers
8 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
4k 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
22k 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 : ...
0
votes
1answer
34 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
10 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 ...
2
votes
1answer
99 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 ...
3
votes
1answer
3k 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 ...
1
vote
1answer
720 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
1answer
7k 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
0answers
16 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, ...
13
votes
3answers
1k views

Does my Oracle DBA need root access?

My Oracle DBA Colleague is requesting root access on our production servers. He is arguing that he need it to perform some operations like rebooting the server and some other tasks. I do not not ...
3
votes
1answer
4k views

Oracle 10g for Windows does not start up on system boot

We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to ...
1
vote
2answers
1k views

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message: Total System Global Area 534462464 bytes Fixed Size 2215064 bytes Variable ...
0
votes
1answer
68 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
1answer
19 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
1k views

Trying to install pdo_oci via PECL fails asking for PDO extension

I'm using Linux Mint 11 (based on Ubuntu 11.04) and I need to use PHP with Oracle through PDO, a requirement of the framework we will work with. I've installed various PDO extensions using the normal ...
0
votes
1answer
21 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: ...
0
votes
1answer
39 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. ...
1
vote
1answer
1k views

What permissions do I need to run SQL*Loader?

What permissions does a database user need to be able to run oracle's sql loader? For instance, since sql loader will disable indexes and triggers, does it need ALTER permissions for those items? ...
0
votes
1answer
2k views

Cannot start Oracle XE 11gR2 Net Listener and Database on Ubuntu 13.04

I have been following the setup step on this article for installing Oracle XE 11g R2 on Ubuntu 13.04. The environment variables PATH, ORACLE_HOME, ORACLE_SID, NLS_LANG ORACLE_BASE have all been set up ...
-3
votes
1answer
34 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 ...
1
vote
4answers
3k 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
votes
0answers
9 views

Portable Method of Deploying Oracle Express on Windows (Ideally without Installer) [migrated]

I'm looking for a portable way of deploying Oracle Express alongside a C# application on a continuous integration machine running CruiseControl. Ideally I would not have to use the installer - this ...
1
vote
1answer
862 views

How do I ensure that the SQL*Net keepalive is turned on?

I have a public facing application server that accesses an Oracle database that resides behind a firewall. Some of the processes that are executed through the application server can run for over an ...
1
vote
1answer
2k 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
vote
1answer
902 views

Can't start WebLogic admin console

I'm wondering how to fix this error. We had the wrong Java installed on my machine when I got it, so my boss installed JRocket to fix things. WebLogic has been having problems ever since. I cannot ...
0
votes
2answers
22 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 ...
15
votes
5answers
911 views

Is my new Oracle DBA talking sense

When we setup FC LUNs for our MSSQL boxes we rarely have to present them with more than about 8 distinct LUNs of various kinds (Quorum, MSDTC, TempDB, Data, Logs, Backup and a few others). We have a ...
1
vote
0answers
33 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 ...
2
votes
1answer
157 views

HPSA (HP Server Automation) [closed]

Using HP SA (HP Server Automation) version 9 for automation and its Oracle database consumes inordinately large amounts of CPU resources. Anyone have a similar experience?
1
vote
0answers
131 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
217 views

Configuring ASR and Oracle Clusterware

I have a four server cluster with Oracle Clusterware managing 4 MySQL instances on them. On failure Clusterware will move the MySQL instance to another server. I am on Proliant servers and also have ...
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
37 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
117 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
737 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
98 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
65 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
40 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
46 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
77 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
38 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
418 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
2k 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 ...