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
1answer
182 views

Where to create directory for importing over network link?

While using data pump import over network link in Oracle: impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT directory=TEST_DIR remap_schema=SCOTT:TEST Where are we creating ...
0
votes
1answer
366 views

Oracle Alert Log is 4GB

We have a developer db server with 11g on Windows Server 2003 R2. I just noticed that the alert_dev11g.log file in the F:\Oracle11g\diag\rdbms\dev11g\dev11g\trace folder is nearly 4GB large. I'd like ...
1
vote
1answer
3k views

Use LDAP to authenticate oracle database users

I have Oracle Database 11g set up in few locations in either pure Linux/OpenLDAP, Samba/OpenLDAP environment and a full-blown Windows/AD environment. The applications that will be using those ...
0
votes
1answer
538 views

oracle enterprise manager agent unreachable (windows)

Since yesterday, the oracle enterprise manager tool on my windows 7 machine is saying that the agent is unreachable. I didn't do anything unusual before this appeared, if I remember correctly I only ...
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 ...
2
votes
1answer
3k 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'. ...
1
vote
1answer
1k views

Large amount of cursors causing slow response and massive CPU usage - cursor: mutex s

We have a problem with our Oracle server. It was upgraded to 11g a couple of months ago and is running a third-party system. The system has been running for years (and has had several other issues), ...
1
vote
0answers
289 views

Oracle 11g R2 eats swap a lot

We have an oracle 11.2.0.1 server with 8 cores and 12gb ram. It's CentOS 5.6 and it has 12gb swap file. Oracle's memory target is 4gb and memory management is automatic. It has MegaSAS Raid controller ...
0
votes
1answer
401 views

ORA-00257 even when Oracle is in NOARCHIVELOG mode

One of my jUnit tests fails with the following exception: java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed. The Oracle error code refers to (for lack of ...
1
vote
2answers
763 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
144 views

'impdb' is not recognized as an internal or external command, operable program or batch file

I can see impdb.exe in E:\Oracle\product\11.2.0\dbhome_1\bin, and that folder is in the PATH. But when I open a CMD window and try to run impdb, I get the error in the title. I can verify the PATH is ...
1
vote
4answers
20k views

Oracle database is very slow - Where to start and how to find the cause?

Our Oracle database(11g) is very slow all of a sudden. I donno where to start the debugging process to find what actually is the problem? I tried generating table stats and looked for locks..but i ...
2
votes
1answer
248 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 ...
1
vote
2answers
139 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
132 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
0answers
396 views

Switched Oracle to use Shared Servers, now Java app throws SQLRecoverableExceptions

This issue might blur the line between Java and database problem, so I apologize if this is the wrong place for it. Not sure which side is to blame yet. I'm a Java developer temporarily playing DBA ...
1
vote
1answer
3k views

MS SQL 2008 - Setup Oracle Linked Server [SERVICE_NAME not given error]

I'm trying to setup a linked server on MS SQL 2008 R2 to an Oracle 11g server. I've got the Oracle client installed and sqlnet.ora, tnsnames.ora & listener.ora copied from the server and in place ...
-1
votes
1answer
148 views

RMAN connecting to wrong target

When I run rman target / @mydb nocatalog cmdfile=%commands% msglog=%logfile%, I see connected to target database: OTHERDB (DBID=3786352837, not open).
1
vote
1answer
370 views

Oracle Internet Directory implementation questions?

I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using various Oracle DB versions 9i up to v11, usually I send email for all of the users to manually copy and update the ...
1
vote
1answer
1k 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 ...
2
votes
2answers
5k 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
2answers
1k 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 ...
1
vote
1answer
1k views

Unable to access Oracle DB from SQL Server with ODAC?

I've downloaded and install the ODAC for connecting oracle DB into my SQL Server 2008 using http://download.oracle.com/otn/other/ole-oo4o/ODAC112021Xcopy_x64.zip The OleDB data provider for Oracle ...
2
votes
2answers
7k 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 ...
1
vote
3answers
912 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 ...
0
votes
1answer
97 views

Common use cases of RMAN restore/recovery

To test our Oracle backup & recovery process, I would like to simulate some common fail case scenarios. Any suggestions?
2
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). ...
0
votes
3answers
140 views

Quickly revert an Oracle Database to a known state

I would like to use Selenium to test a web application but in order to do that successfully the tests must be run against a database at a known state. The recording and running of the Selenium tests ...
1
vote
2answers
846 views

Oracle VSS Writer vs. RMAN

I am unable to find any literature to evaluate which solution to use when backing up my Oracle 11g DB. The attempt is to perform online backups by enabling ARCHIVELOG mode. Edit: I have gone through ...
1
vote
4answers
379 views

How to wipe the slate clean on an Oracle installation?

After a basic, successful installation of Oracle 11g, I ran dbca again to enable Enterprise Manager on my database. The operation hung at around 67% for half an hour or more, so I clicked Stop to ...
0
votes
2answers
4k views

Oracle 11g: Why doesn't “grant create session” allow user to log in?

I'm working on an Oracle 11g database, and simply need to create a user and log in with it. I successfully create the user, but after running the second line below, I still can't log in. Is there ...
2
votes
4answers
232 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 ...
1
vote
3answers
590 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 ...
2
votes
3answers
124 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 ...
0
votes
2answers
1k views

Can I upgrade Oracle 11g 11.2.0.1 to 11.2.0.2 and keep my database intact?

I'm new to oracle, but I'm looking to upgrade an existing oracle database 11.2.0.1 to 11.2.0.2. Can anyone tell me if this will require wiping my existing database or will it remain intact? Thanks in ...
0
votes
1answer
1k views

Orcale 11g client installs error on 64 bit win server 2008 OS

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 of this check is: Failed <<<< Problem: Oracle ...
0
votes
1answer
512 views

Unable to start Oracle Enterprise Manager

Had some passwords expire, and this knocked out my OEM (11g, SE). Cleared this up, so that SYSMAN is not locked or expired (nor is DBSNMP, SYS, SYSTEM, all of which may or may not affect OEM, ...
0
votes
2answers
1k views

Oracle11g-x64-ent install on SUSE Linux have many check errors

I have searched widely, but didn't find out much about these errors. What are they, and should I be concerned? Oracle11g-x64-ent 11.1.0.6.0, SUSE Linux Enterprise Server 10 SP2 (x86_64), the ...
1
vote
2answers
552 views

Running multiple Oracle Databases on the same machine

we have hr system for government that serves about 50 governmental organizations the company who created the system want to change the structure of the current system which is one database serving all ...
1
vote
2answers
269 views

Administrating oracle database 11g - new database, user and tables

i've installed oracle database 11g standard edition. I opened "Oracle Enterprise manager" and i want to made new (and empty) database, create 5 tables and a user with permission only do access this ...
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 ...
0
votes
2answers
865 views

High Disk IO spikes in HP Windows 2008 Server with SAN and Oracle 11g

I have a HP Proliant BL68C G5 server, running Windows Server 2008 R2 Standard edition server that is being used as an Oracle 11g data-server. The machine itself has 20gb of RAM, dual Xeon 2.4ghz ...
0
votes
5answers
1k views

What is the Best HW / OS Combination for Oracle 11g?

My company is in the midst of upgrading our database hardware / software to support Oracle 11g. We're considering the following hardware / OS combinations for the database server: Sun v890 (current ...
0
votes
1answer
157 views

equivelant tool in oracle 11g to the Oracle Enterprise manager (OEM) that came with oracle 9i?

Is there equivelant tool in oracle 11g to the Oracle Enterprise manager (OEM) that came with oracle 9i? pointers on where to download/install/access would be greatly appreciated.
5
votes
5answers
3k 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 ...
0
votes
1answer
46 views

Can I predict to have query performance problems against a two column xref table with 25 million records?

I'm prototyping a design. In the design, I am considering creating a thin xref table (two integer fields) that would contain approximately 25 million records. Is this a crazy idea or would I still ...
0
votes
1answer
193 views

Oracle Enterprise Manager license

I read somewhere that OEM comes along with Oracle Database, but does it require some management license and how the license is counted? is it per physical/LDOM server based or per control domain based ...
0
votes
2answers
250 views

How do I get Oracle 11g to install on Vista when it gives an error about the listener port?

I'm trying to do an install of Oracle 11g.R2 taking the defaults, but the installers keeps generating and error message when trying to setup the listener. If I have the installer just install the ...
1
vote
1answer
683 views

Problems with connecting to ASM instance

I have Oracle11 with RAC installed on RedHat 5. I have two servers with two instances one on each one. In each server I succeed connect to appropriate instance of database but not to instance of ASM. ...