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
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 ...
2
votes
1answer
6k views

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

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 ...
1
vote
1answer
37 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 ...
-1
votes
0answers
12 views

Old oracle client component on new windows server [on hold]

i have the problem, that one of our customers use a software, which bases on an oracle client component from 2000. The Software runs on a windows server 2003. This oracle drivers only work until ...
10
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 ...
6
votes
3answers
230 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 ...
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 ...
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 ...
2
votes
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 ...
0
votes
0answers
7 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
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
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 ...
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 ...
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? ...
1
vote
1answer
906 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
5answers
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
vote
1answer
933 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 ...
1
vote
1answer
816 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
37 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
11 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
23k 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
58 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
19 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
101 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
742 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
18 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 ...
0
votes
1answer
87 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
31 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
30 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
43 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. ...
-3
votes
1answer
35 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
2answers
30 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
35 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
164 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
163 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
218 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
51 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
764 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
148 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
114 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
50 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
58 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 ...