Tagged Questions

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

0
votes
0answers
12 views

Oracle Wallet Add Trusted Intermediate CA?

I have a Oracle Wallet for use with a Oracle HTTP Server. I am trying to update my Trusted Certs in the wallet as they have changed for my client authentication for DOD CACs (Smart Cards). I have ...
2
votes
1answer
66 views

remote login failed on windows XP, but remote telnet successful on mac

I recently set up an Oracle DB, started the listener on port 1561, and enabled TCP access. I then opened that port to all incoming connections. When I get on my Mac - I can use telnet remoteserver ...
1
vote
0answers
36 views

WebLogic datasource timeout

We have WebLogic 10 with some services running on it. One of our datasources started throwing timeout exceptions. We set Configuration -> Connection Pool -> Test table Name to problem sql. ...
3
votes
1answer
3k 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
15 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
2answers
127 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
1answer
12 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
23 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
1k 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
1k 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
93 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
49 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
2answers
104 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
1answer
532 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 ...
1
vote
1answer
88 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
17 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
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 ...
0
votes
0answers
364 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
49 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
385 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
667 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
780 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
164 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
127 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
2answers
3k 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
247 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
3k 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
881 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
224 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
3k 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
2k 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
404 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
490 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
154 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
85 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
631 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
848 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 ...
2
votes
0answers
209 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
99 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
111 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
102 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
562 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
751 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
2answers
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
465 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
2k 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 ...
3
votes
2answers
13k views

How can I resolve Oracle 11g XE connection failure straight after installation?

I have just installed Oracle 11g XE on a Windows 7 VirtualBox VM, using all the default options. "Getting Started" fails When I click on Getting Started I get taken to ...