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

5
votes
5answers
4k views

Setting up array of SSDs for Oracle Database, recommendations?

I am configuring a server for a small, but read I/O intensive database. It serves as a master index for public access to a larger Oracle RAC database. When looking at the requirements for I/O, it was ...
4
votes
5answers
4k views

Are there any disadvantages of using UTF8 in an oracle database?

We are installing ordering a configured oracle database and they are asking us what character encoding we would like to have. The application (in Java) is in English only but users are from different ...
3
votes
3answers
838 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 ...
3
votes
2answers
777 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 ...
3
votes
2answers
3k views

Oracle 11g R2 Install Guide

I have a need to install Oracle 11g R2 on Windows Server 2008 R2. I have downloaded the two files from Oracle (win64_11gR2_database) and the client (win64_11gR2_client). Does anyone have a guide or ...
3
votes
1answer
2k views

installing oracle 11g in ubuntu 10.10

i'm trying to install oracle 11g database in my ubuntu 10.10, following this tutorial http://oracleabc.com/b/archives/167 but, at the step 11, the system asks for oracle password! which password is ...
3
votes
2answers
2k views

When RAID 10 is SLOWER than RAID 1, why?

We have a new Dell 2950 with PERC 6/e and 14 external SAS 15K 73GB drives. An Oracle 11g database job takes 3 hours to run with the drives set as hardware RAID 10 (striped across 7 mirrored pairs). ...
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 ...
3
votes
3answers
19k views

How can I uninstall Oracle 11g from Windows?

When I try to uninstall Oracle 11g from Windows, I get the following error message: Checking swap space: 0 MB available, 500 MB required. How can I fix this to completely uninstall Oracle 11g?
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 ...
2
votes
4answers
243 views

Oracle performance problem

We are using an Oracle 11G machine that is very powerful; has redundant storage etc. It's a beast from what I have been told. We just got this DB for a tool that when I first came on as a coop had ...
2
votes
2answers
6k views

Installing oracle 11g on windows 7, why getting errors?

While installing Oracle 11g on windows 7, I get these errors: Checking operating system requirements ... Expected result: One of 5.0,5.1,5.2,6.0 Actual Result: 6.1 Check complete. The overall result ...
2
votes
3answers
127 views

Oracle Move from 9 to 11

I have an oracle 9 database. There is a requirement to move this to Oracle 11. What is the best way to achieve this. Is it enough to export the database on 9 and import it again on 11 or is there an ...
2
votes
2answers
231 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 ...
2
votes
1answer
260 views

Oracle IIg Windows 64 Install

Tryine to do local install of Oracle 11g 64 on Win 7, everything goes fine but when I try to launch enterprise manager at https://localhost:1158/em I get a security certificate error. Where in the ...
2
votes
1answer
645 views

Apache apachectl/httpd hangs

Oracle HTTP Server (OHS), RHEL 5.3, Dell hardware Oracle has a modified version of Apache2 for use with web-enabled components in its product suite. The apachectl start command just hangs, even ...
2
votes
1answer
926 views

Oracle: Can Weblogic 11G run PL/SQL code like App Server 10G?

This is probably a silly question, but I'm not an oracle admin so I'm not sure. Our client currently runs a website written in PL/SQL and HTML on a Oracle 10G system. As everything is moving in the ...
2
votes
2answers
2k views

prevent ORA-28001?

Using Oracle 11g, is there a way to prevent my user's passwords from needing to be updated (ORA-28001)?
2
votes
1answer
3k views

Oracle 11g silent install on Linux CentOS 5.2 x86-32 fails on database creation

After reading the Linux installation guide for Oracle 11g, taking particular note of the pre-installation requirements; I have been able to record a response file for a silent installation based off a ...
2
votes
1answer
97 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 ...
2
votes
1answer
4k views

Oracle Enterprise Manager showing Agent Unreachable, negative disk space?

I'm recently installed Oracle 11g on a Windows Server 2008 box and although the database appears to work just fine when I load up the Enterprise Manager in Firefox it tells me 'Agent Unreachable'. ...
2
votes
2answers
2k views

Disable RMAN backups in Oracle 11g

Recently I tinkered around with RMAN to see how it works, and somehow managed to get a regularly scheduled backup going. I don't really have the disk space or the need for RMAN to run, but I can't ...
2
votes
2answers
9k views

Initialization error while trying to connect to Oracle using SQLDeveloper

I've installed Oracle 11.2.0 and Allround Automations' SQLDeveloper on Windows 7 64-bit. When I run SQLDeveloper and and try to connect to Oracle, I get the below error: Initialization error Could ...
2
votes
2answers
5k views

Fixed expired accounts in Oracle 11g

I have an Oracle 11g server that's used for PHP development. Recently, I had a problem logging into the Enterprise Manager due to expired passwords. I've already changed settings so passwords no ...
2
votes
1answer
135 views

What is the correct way to back up an Oracle 11g database with 190GB of data

Right now we are doing the following: Generating a DMP file to a windows server, this takes about 14hrs Copy the DMP file to tape, this takes about 10 hrs Archive it..... In total this takes about ...
2
votes
3answers
268 views

Move Data on Oracle 11g

I am doing migration to move data from Ms SQL Server 2000 to Oracle 11g on HP Server machine. I don't know why it is very slow when I load data from file xxx.dat into table in oracle 11g. Do anyone ...
2
votes
1answer
135 views

Restore and Recovery scenario

I want to restore and recover my oracle database to the current state. For example, I have a full backup on Sunday and I have all archive logs from Sunday to Wednesday. If I restore and recover from ...
2
votes
0answers
28 views

mod_ssl client certificates on a reverse proxy

I am trying to add client certificate authentication on a reverse proxy that proxies an oracle application. Before adding, and if i remove the subsequent code, the oracle application is able to start ...
2
votes
0answers
222 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 ...
2
votes
1answer
640 views

When Installing Oracle Client 11.1.0.7 can I use a common directory for Oracle Base?

I am trying to install Oracle Client 11.1.0.7 on a Windows Server 2008 64-bit. To some this might not be rocket science but I can't understand what the options under the install screen "Specify Home ...
2
votes
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 ...
1
vote
10answers
5k views

What is the best OS platform for Oracle 10g?

I want to know the best choices for OS to run Oracle 11g on my sand box. Also, I would like to know good combination for Dev environments in 50-100 user environments. Any other information about ...
1
vote
3answers
15k views

Granting Read-Only access to an existing Oracle Schema

we've got an Oracle 11g Schema that our application uses to select, insert and update, but we've had a request from one of our customers to provide read-only access to the same base tables and views ...
1
vote
2answers
1k views

Oracle DBV File Parameter

For our 10g Oracle database I had a script that would periodically create batch files to run DBVerify on all our datafiles. This way if I needed to check for corruption I would just have to run the ...
1
vote
3answers
15k views

Cannot log into Oracle Enterprise Manager 11g: ORA-28001

I can no longer log into Oracle Enterprise Manager 11g. I get this error message: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) I could log into the server using SQL*Plus. I ...
1
vote
4answers
6k views

Running Oracle 10g and 11g side-by-side

I recently tried installing Oracle 11g on a server already running 10g. Each would run independently with no problem, but 10g refused to run simultaneously with 11g. Can this be done? I don't need a ...
1
vote
2answers
914 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 ...
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
vote
2answers
3k 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 -> ...
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 ...
1
vote
1answer
2k views

oracle - grant all privileges to schema

i've used mysql before and i'm now switching to oracle. I've already created a user in oracle. Now i want to give it "all privileges" for a schema. In mysql i can give all privileges (DML/DDL) for a ...
1
vote
2answers
141 views

sql-server 2008 vs oracle 11g certification

I a have been working at my job for around a year doing database and development work and we currently use sql server 2005, which you think would make my decision easy to pursue a certification in sql ...
1
vote
2answers
142 views

How to connect an Oracle server between two countries and maintain high speeds for read & write

Our company has two branches, one in Malaysia and the other one in India. The problems occur when we try to share one of our Oracle environments to our branch in India; the connection is very slow, ...
1
vote
3answers
1k views

ORA-1034 Oracle Not Found

I have recently installed oracle 11g on Windows 7 Home Premium Operating System. I logged in as administrator into windows. I am trying to create a database using DBCA wizard. I started the wizard as ...
1
vote
3answers
754 views

How do I find the query parameters for a prepared statement in an oracle .trc file?

I have an oracle query generating a 3137 error, and the trace file contains the query. For example: select x from y where z = :1 I think it would help to isolate the problem if I could determine ...
1
vote
2answers
23k views

Can't start managed server in Oracle Weblogic 10.3.2

I installed Oracle SOA Suite 11g. I start the NodeManager successfully. I start the AdminServer successfully. When I go to start the soa serve (soa_server1) I get this output: NMProcess: <Mar ...
1
vote
2answers
23k views

Create user in Oracle 11g with same priviledges as in Oracle 10g XE

I'm a PHP developer (not a DBA) and I've been working with Oracle 10g XE for a while. I'm used to XE's simplified user management: Go to Administration/ Users/ Create user Assign user name and ...
1
vote
2answers
1k views

How to fix corrupt indexes blocks in SYSAUX tablespace

we had power failure that left corruption in data files. It was recovered from RMAN backup including logs and all is OK, the DB is working.. except that I noticed this: RMAN> BACKUP VALIDATE CHECK ...
1
vote
1answer
1k views

Rolling Upgrade of Oracle 11g from 32 bit to 64 bit?

I have an Oracle 11.1.0.7 database running on windows 32 bit. I would like to upgrade to 64 bit (same version of oracle) and would like to use a standby database for a rolling upgrade. Is this ...
1
vote
3answers
4k views

Oracle 11g server rename issue

So we set up an Oracle server out of production (11g on Server 2008 x64) and our plan was to just rename the server's hostname to move it into production. Well, the database itself is functioning but ...