Oracle is an RDBMS product and Oracle 11g is a specific version. Questions tagged **oracle11g** are assumed to be specific to this version or features introduced in this version.

learn more… | top users | synonyms

2
votes
0answers
219 views

Installing Oracle 32bit and 64bit client on the same machine

So I need to have both the 32bit and 64bit clients for Oracle 11g coexist on the same machine. I have installed both together before, but there are many issues where applications that need to use the ...
0
votes
0answers
7 views

Need help in installing Oracle RAC with EBS

I have an running Oracle 2 node RAC. I need to setup an single node Oracle EBS which need to use the RAC cluster for data. Is there any specific process I should follow. I heard that Oracle EBS ...
0
votes
1answer
53 views

High iowait despite small amount of write/read

I'm not sure how to interpret this or the next steps, but why is IOWait so high when I have not written/read much from any devices? Background: I am a developer trying to find why the DB seems to be ...
0
votes
0answers
7 views

Is there a way to find out the necessary users, roles, and privileges an Oracle Dump file needs?

I've been tasked with importing this old Oracle dump file from beyond my time - as such, the person that did the exporting, and the server on which it originally resides on is long gone. My knowledge ...
0
votes
1answer
11 views

How do I restore Oracle's default user tables?

The Problem: I've been trying to restore this dump file, but unfortunately, whoever did the exporting did not make it clear on what users, privileges, and roles are required for the database. So I ...
0
votes
0answers
318 views

PL-SQL Developer not connecting to remote oracle database , error ORA-01034

![Oracle error in PL SQL Developer][1] I am facing issues while trying to connect my database through PL-SQL Developer. It throws error - ORA-01034 everytime. Please note the below. 1.I am using ...
1
vote
1answer
284 views

Unable to connect to an Oracle XE database from another PC, or a local program / webpage

I've installed an Oracle 11g XE on a Linux Fedora machine, successfully created a user, and imported a database into it. My ultimate goal here is to connect an existing PHP website (also residing on ...
0
votes
0answers
47 views

Can this RMAN setup give me a 7-day point-in-time recovery window and a stable size?

I have an RMAN setup on an Oracle 11g Windows 2003 R2 server, storing a steady stream of instrumentation values for various machinery. There are routines in place to automatically accumulate and ...
0
votes
0answers
42 views

Downgrading memory in CentOS VM Causes failure for Oracle11g startup

I have a CentOS 6.4 virtual machine with one vCPU and 2GB of RAM running on top of VMWare workstation 8, this VM Runs Oracle 11g. Whenever I downgrade The VM RAM to 1GB oracle refuses to start ...
0
votes
0answers
104 views

Oracle - The provider is not compatible with the version of Oracle client

Often whilst I'm working on local code on my local IIS install, I would get the following error: At which point I open up IIS, recycle the application pool, and restart the website, and then all is ...
0
votes
0answers
27 views

Oracle remote_os_authent works locally but not remotely

An oracle 11g server is configured to use the remote os authentcation option for select few users. Everything works fine from the shell of the DB server (e.g. you type sqlplus / and login is ...
0
votes
2answers
78 views

cannot connect to oracle after server crash

Our test server (based on windows 2008) crashed because of a power loss during the weekend. After the restart, all services started successfully but Oracle 11.2 didn't. I tried to start all services ...
0
votes
0answers
20 views

Exporting database files from external drive

Our experimental server crashed, due to SMPS failure. Now we have to recover the data from the Oracle database residing in the hard drive. Connecting the hard drive as an external device to a system, ...
0
votes
1answer
218 views

SP2-0750: You may need to set ORACLE_HOME

I am getting following error message when i write sqlplus on command prompt SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Here are the path details Net ...
0
votes
0answers
14 views

Oracle 11g and Level information of log files

I would like change level of information to log files in oralce 11g Enterprise. I find this article http://docs.oracle.com/cd/E23943_01/core.1111/e10105/logs.htm#CHDEJBIF 12.4.3 Setting the Level of ...
1
vote
1answer
76 views

Oracle SQLConnect: 1033 via UnixODBC

Here is the full error: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[08004] SQLConnect: 1033 [unixODBC][Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in ...
1
vote
1answer
14 views

Retain SIDs and TNS when upgrading Oracle

I am researching the process to upgrade Oracle from 11.2.0.1 to 11.2.0.3. I am planning on using the DBUA utility. My question is, will the DBUA make the necessary changes to retain my SIDs and update ...
0
votes
1answer
1k 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 ...
0
votes
0answers
315 views

CentOS6 Oracle11g,I can not start em

I start the oracle with the command “dbstart” [oracle@myCentOS ~]$ dbstart Processing Database instance "orcl": log file /oracle/11g/startup.log and then start the listener [oracle@myCentOS ~]$ ...
1
vote
1answer
47 views

Dataguard needed for onsite virtualization?

In moving both an Oracle DB and it's corresponding dataguard box both to a Virtual Environment, (Same site, same VM Infrastructure) Does it make sense to keep the dataguard setup? The VM ...
1
vote
2answers
330 views

What kind of performance overhead with LVM on Fusion ioDrive2 as Oracle DB 11gR2's Flash Cache?

This is a bit wordy, so please bear with me. :) We have a RAC cluster of 3 Oracle 11gR2 servers and purchased FusionIO ioDrive2 PCIx cards for these servers to use as OracleDB's Flash Cache. These ...
0
votes
1answer
491 views

Resizing partitions/moving /u01 oracle directory

I've got a test server recently set up at work which has oracle installed under /u01 - but without realising it, I've set the root partition to be ~50GB, so have filled the partition very quickly once ...
3
votes
3answers
497 views

What to check during a periodic system health check

I have been tasked with preparing a list of checks to do as a part of a weekly system health check routine which my team is supposed to do. The problem is neither I nor any of my colleagues have ever ...
0
votes
1answer
146 views

Windows 2003 Near Freezing

Problem: Our server becomes very very slow (near freezing) if I copy a file from any directory on C: and D: to any other directory. In short It becomes very slow if I touch the hard disk. Currently I ...
0
votes
2answers
108 views

Oracle Golden gate version using shell scrip

I am trying to grep the Oracle golden gate from a remote machine, But along with version it is giving some error details also, How do I resolve it ? user@serverhost:/dbei > echo <golgengate ...
1
vote
1answer
1k views

Caused by: java.net.SocketException: Software caused connection abort: socket write error

I running JSP on Oracle 11g, Weblogic 10.3.4. I have 2 managed server and a oracle admin server installed. I am encountering an error where intermittently the log file of the 2 managed server and ...
0
votes
1answer
224 views

2 RAC node clusters with different RAID layouts?

I am comparing RAID 10 and RAID 5 configurations for Oracle database in order to determine the best choice in terms of performance for mixed workloads. Is it possible to have 2 RAC node clusters and ...
0
votes
2answers
2k views

Why can't I grant exec on dbms_lock.sleep() OR create a procedure using it (but I can run it fine on its own)

I am trying to write a small bit of PL/SQL that has a non-CPU burning sleep in it. The following works in sqldeveloper begin dbms_lock.sleep(5); end; BUT (as the same user), I can't do the ...
1
vote
2answers
729 views

Ulimit settings in Oracle 11g on Linux 5

Is there an issue with "Ulimit -Hn" being set too low (at 1024) when (Oracle recommend 65536)? This is for Oracle 64-bit 11g on Linux 5. It is one of the settings that appears to be woefully short ...
2
votes
2answers
199 views

Oracle (xe) 10 vs 11 . Have I lost the SQL tuning pages ? Am I going out of my mind?

Ok .. so perhaps the title needs calming down a bit. Basically I am after the XE 11g equivalent of the pages that you can see here, in which you can then navigate to stuff like "top 50 queries" and ...
1
vote
2answers
2k views

Is there a way to setup Oracle on Mac Lion without VM?

I really would like to avoid having to install virtual box just to use Oracle 11g. Is there a way to install it into Mac OSX?
-1
votes
1answer
1k views

Symantec Netbackup : Oracle restore fails “exited with status 13: file read failed”

I am restoring Oracle datafile size of 1200GB. Datafile is read from backup piece size of 4000GB(4TB). Note: As I monitored 4TB is processed totaly to read all blocks of my datafile. I had several ...
1
vote
0answers
279 views

Oracle Database 11g Express Edition - Built-in backup files-to-be-saved

Considering the built-in 'Backup Database' script (backup.bat) that comes with a new instalation of the Oracle Express 11g Edition, after finishing the script execution, what folders/files should be ...
0
votes
1answer
402 views

How to add linked Oracle server to SQL 2008 Express?

I have tried to download Oracle Client 11g both 32 & 64 packages to Windows 2008 R2 with SQL server 2008 Express. However, I still cannot see Oracle provider in SQL server by using sa log in. Not ...
1
vote
0answers
142 views

ORA-32696: HTI: No free slot

I am getting the following error in oracle alert log file. ORA-32696: HTI: No free slot "Cause: There is not enough memory. Action: Increase memory." I have goggled this error but couldn't find the ...
-5
votes
1answer
84 views

Oracle database [closed]

what's the reason for Enterprise Manager is not able to connect to the database instance. ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) error? How to solve it?
0
votes
1answer
479 views

Oracle redo log performance degradation when inserting

I have a oracle 11g database. I'm testing in for inserts. The database running in noarchive mode. I have 3 redo log configured, each 2gb. I'm trying to insert data into test table. At begin it goes ...
0
votes
1answer
572 views

Recommended RAM and disc space for Oracle 11g on Windows

I need to provide the recommended amount of RAM and disc space (divided in two partitions) so the customer can create an appropriate virtual machine to run Oracle. All I could find in the ...
0
votes
1answer
1k views

INS-40719 error when Install Oracle RAC?

I'm tying to (learn how to) install Oracle RAC 11g on CentOS 6 all went OK so far but I get INS-40719 Error message regarding SCAN Name I do not have DNS server and I'm not going to try to use it on ...
1
vote
0answers
172 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 ...
-5
votes
1answer
94 views

What is the stability level of Oracle 11g? Is it suitable for production? [closed]

We are using both Express edition and Commercial edition to power up a Distributed application. Is Oracle 11g a good candidate for this application since we need data synchronization? Or is Oracle 10G ...
0
votes
2answers
107 views

Configuring swapfile error

I installed oracle linux 6 on my desktop but I forgot to configure the swapfile, I want to install oracle 11gr2 on it and it requires 2gig or ram, if I type the following commands on the terminal I ...
0
votes
1answer
98 views

DB2 to Oracle Migration

I am migrating a very large and complex database from DB2 to Oracle 11g. Can someone suggest any tools / processes to do this very quickly. My database is about 500 GB and it cannot have downtime ...
1
vote
1answer
439 views

How to enable Oracle-Managed Files on Oracle Express for Windows XP

I'm trying to enable Oracle-Managed Files on Oracle Express for Windows XP. From everything I've read, I need to set db_create_file_dest to an existing directory in the file system. I've tried ...
3
votes
2answers
619 views

Force refresh of client's java cache.

I have an Oracle Application server that has been upgraded. It serves users a java file which they launch in their browser. After the upgrade user's browsers are still pulling the old java file from ...
1
vote
1answer
2k views

Setting ORACLE_HOME in Oracle RAC 11g

I've got two (2) nodes in an Oracle RAC 11g in Windows Server 2008. Oracle software is installed in C:\app. I realized that the ORACLE_HOME path has not been set.. In System Properties-> Advanced -> ...
0
votes
1answer
415 views

Can't connect to oracle remotelly

I've been trying to install oracle in my home for more than a month now, but I still having some issues. Currently I have the server installed and running on a dedicated Win2k8R2 virtual machine. The ...
1
vote
1answer
1k views

Unable to delete a folder? Read Only Attribute locked?

We have a Windows 2008 R2 with Oracle11g and I need to uninstall the server and to reinstall again. I was following this Oracle Uninstall guide here: ...
0
votes
2answers
2k views

Howto enable remote login for a Oracle db user?

Stupid question: I've successfully installed Oracle 11g on my Linux box. I can connect to it and retrieve the countries table via C#/mono just fine, with the below connectionstring, which uses the ...
1
vote
1answer
1k views

Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?

I've and Oracle (11 Enterprise) schema with a table CREATE TABLE USER.WSP_BUNDLE ( NODE_ID RAW(16) NOT NULL, BUNDLE_DATA BLOB NOT NULL ); CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...