The second and terminal release of Oracle Corporations Oracle 11g database product. 11.2 was released for Linux on September 1st, 2009. New features added include RAC One Node, Improved data compression ratios (up to 20x), Edition Based Redefinition, Recursive Subquery Factoring, Instance Caging, ...

learn more… | top users | synonyms

6
votes
1answer
683 views

Package state not re-intialized on raise_application_error

When a package has state and the header is changed, the first call gets an error stack something like this: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of ...
0
votes
1answer
5k views

How to connect to a Database made by Oracle SQL Database?

So I am fairly new at this, so if you could keep that in mind in your answers, it would be much appreciated. I installed Oracle SQL Database on my Windows PC. It came in two zip files. I installed it ...
1
vote
2answers
1k views

Factoring out subselect (with clause) ends in ORA-00904

I am trying fo factor a repetitive subquery with with but getting ORA-00904 over and over again. This is my base query which works quite well: select tka.id, tka.name, txt.text as langname, ...
3
votes
1answer
3k views

Why ORA-00932: Inconsistent Types error?

Sorry for the meaningless title, but I couldn't think up a better one. I'm using Oracle 11g r2. The following query raise ORA-00932 error: SELECT BBB.FIELD1 FROM TABLE0 AAA JOIN (SELECT * FROM ...
1
vote
0answers
625 views

What is the nature of “LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2”?

I'm not sure when this started, but for the time being the primary database instances in a physical standby configuration logs this message on every redo log switch. ...
4
votes
1answer
2k views

Is there a way to export an Oracle database to a CREATE DATABASE command?

I have an existing Oracle 11 instance, I want to export the database (which was created via DBCA) to an equivalent "CREATE DATABASE" command, handling the character set, etc. I'd also like to get a ...
1
vote
2answers
3k views

Oracle RAC with single node Data Guard physical standby

Best practices for Oracle 11gR2 Data Guard implies that the primary and standby databases should have the same layout, eg. RAC to RAC. What special considerations would one need to take into account ...
1
vote
1answer
426 views

Change a partitioned global non-unique index that is the primary key to a non-partitioned unique index

One of the largest tables in our system has its primary key setup as a globally ranged partitioned (in huge, useless, multi-billion value ranges) non-unique index. Its values are just a sequence ...
4
votes
2answers
188 views

Is there a bug with PL/Scope in combination with associative arrays?

I believe I stumbled upon a bug with PL/Scope in combination with associative arrays, but perhaps I overlook something. I have the following package create or replace package tq84_pkg_c as ...
-1
votes
1answer
2k views

how to connect remotely to oracle database [closed]

I've installed oracle 11g express edition and sql developer. I don't know ho to connect to a database on remote server. Can anyone help please. Note that I didn't installed any other software like ...
0
votes
0answers
69 views

Strange symbols in Database

My web application is storing the currency as strange symbols. I have the same web application running in two different machines connecting to same database. One is working fine, accepts currency ...
2
votes
1answer
2k views

Changing a materialized view column's length after a change in the base table?

We changed the underlying table column size (length). So the materialized view which is built on that table throws an error now since the MV column still has the old size. This is an Oracle 11gR2 ...
1
vote
1answer
489 views

Deleting folders after Oracle upgrade

I upgraded from Oracle 10g to Oracle 11g in Windows Server 2003. New Oracle home : C:\app\oracle\product\11.2.0\db_1 Old Oracle 10g was installed on: C:\oracle\product\10.2.0\ Questions Is the ...
1
vote
0answers
6k views

Oracle XE TNS Listener fails to start

I freshly installed Oracle XE 11.2.0.2.0 and found out that the TNS Listener service fails to start. At first I tried to start the Windows service by hand. After the failure this is the entry in the ...
2
votes
1answer
9k views

Expanding system tablespace

I need to add new data file into the system tablespace because its running out of space. Are there any precautionary measures I should consider since this is a production environment?
5
votes
3answers
2k views

Partition pruning with multiple date columns

I have a large table in Oracle 11g database that holds historical data from several years, so I would like to partition it by year. The problem is that the table has multiple date columns and they are ...
5
votes
2answers
3k views

What would be the correct size of redo logs?

I installed and put in production a 11g database. I was adviced to size redo logs to 200MB each one. Now I see that my archived redo logs are each one 200 MB and all of them occupy a lot os disk ...
4
votes
2answers
1k views

How many control files should I have?

On the Oracle Database Appliance, the default deployment only gives you a single control file. I find this a little puzzling. The single control file causes a policy violation in the automatically ...
1
vote
0answers
261 views

How to find an text in entire Oracle database?

I have a Oracle database (11g2). But i don't know how to find a text in all of table on a database. Because there are so many tables, can't find down by one column, one table... it takes me a lot of ...
1
vote
1answer
758 views

oracle streams - how to get last successfully applied scn for crashed apply?

I have a downstream Streams replication set up between Oracle 9i (source) and Oracle 11g (destination). The process is still in developlment stage, so the whole setup is not stable yet. Sometimes my ...
3
votes
3answers
1k views

Increase Oracle buffer cache gets slower

So we're contemplating increasing our Oracle 11gR2 buffer cache. They said they tried it in the past and things appeared to get worse - so they undid the change. They, however, have no idea why ...
-1
votes
1answer
406 views

How to get how many rows are inserted in ORACLE?

How do I get how many rows are inserted after executing an INSERT statement? I'm using Oracle 11r2 with MyBatis in Java.
2
votes
0answers
2k views

Oracle high Paging Faults

What are the reasons that lead to terrible high Paging faults. The following is the topas information and background about the Environment. OS: AIX 6.1 Softwares: Oracle 11gR2 Paging Space:30720 ...
0
votes
2answers
1k views

How to merge Oracle data

There are two schemas in Oracle11g. For example db1 and db2. They have same structure of tables and different data to each other. Now I want to merge data on db1 with data on db2 with no ...
2
votes
1answer
5k views

Installing Oracle 11g XE on Ubuntu 12.04

I have spent the last 6 hours trying to install Oracle 11g on Ubuntu. Obviously, I'm not the only one who has struggled with this, as there is a lot of (often misleading) "documentation" online on how ...
0
votes
1answer
1k views

Force number precision in a view with Union

I am using Entity Framework and Oracle. Oracle's ODAC seems to have a known bug where data of type NUMBER is cast to Int64 by Entity Framework. I thought a view would assist me but CREATE OR REPLACE ...
2
votes
1answer
266 views

Oracle start database with incorrect password

I have a question regarding starting oracle database with in correct sys password. I have provided incorrect password for sys user and I am still able to start database and execute statements. So ...
3
votes
1answer
5k views

How to connect multiple users/schemas in Oracle 11g?

I'm almost new user to databases, so I think I'm doing something wrong. I have the database created. I created 3 users, 1 it's an Admin, 2 are just users. I created 2 roles, 1 for the Admin and 2 ...
1
vote
2answers
8k views

How high can I set undo retention on Oracle 11gR2

Is it viable to set a very high undo retention, as to allow flashback queries several weeks back in time? Naturally, enough space must be available in the undo tablespaces to contain the amount of ...
0
votes
2answers
1k views

RMAN Recovery In Oracle 11g : Backup Database To Tape

On issuing this command: RMAN> backup device type sbt tablespace <tablespace_name>; we are getting the following error: ORA-19554: error allocating device, device type: SBT_TAPE, device ...
3
votes
1answer
470 views

Wait time differences in Oracle

I'm trying to track the different wait time classes for current Oracle sessions but I must be misunderstanding something. When I compare the sum(time_waited)/1000 for a given session in ...
2
votes
1answer
913 views

Oracle: Long delay opening connections

I am getting a very long delay (about 2 minutes) opening initial connections on my 11g2 development server. Sometimes I get ORA-28547: connection to server failed, probable Oracle Net admin error and ...
2
votes
1answer
1k views

Recover database until cancel without prompt?

The statement: RECOVER DATABASE UNTIL CANCEL prompts once to select the archive log file. Is there a way to pre specify the value so as to be able to use it in a script without prompt? I have ...
1
vote
0answers
5k views

Could Oracle ORA-08103 'object no longer exists' error be caused by size of undo_retention parameter?

Had a once-a-day long running data warehousing procedure that I had written that was failing about 50% of the time. Logs were showing ORA-08103 'object no longer exists'. ORA-12012: error on auto ...
1
vote
0answers
2k views

ORA-01460 during Data Pump Import

While migrating data from Oracle 11.2.0.1 RAC to Oracle 11.2.0.3 RAC using Data Pump, the import failed with ORA-01460: ORA-39097: Data Pump job encountered unexpected error -12801 ORA-39065: ...
3
votes
2answers
220 views

Periodic Oracle restarts…intentionally

Taking on a new dba role for an Oracle 11gR2 2 node RAC, I've been told that about 9 times a year, in schedule with other software releases, we intentionally shutdown and restart the database. It ...
0
votes
2answers
1k views

Difference between chained and migrated rows

What is the difference between chained and migrated rows? Also what query should be used to display these rows? (I'm using Oracle 11gR2 database)
1
vote
2answers
4k views

Run Unix command using PL/SQL

Is it possible to run a Unix command using a query in Oracle? I want to run simple commands (like df -h) using a query. Is this at all possible or am I wasting my time? I don't want to use a ...
2
votes
2answers
820 views

Why does my query run faster after I force full table scan?

I have a MERGE statement that took forever to execute the select as the table it is running from (SUB_DATA) is rather big (read 1.4 Tb, 700 million rows). My SELECT looks like this. SELECT ...
1
vote
2answers
1k views

Why Oracle 11g installs in folder C:\app\<name_of_user>

Just curious, now Oracle 11g installs by default in folder C:\app\ Why? Before, Oracle was installed by default in folder C:\oracle... Why now is created "app" folder?
1
vote
1answer
194 views

Pitfalls of creating a foreign key constraint on a system table?

I have a number of tables which hold metadata about the tables and packages in the system. This is intended to be a resource for analysts and documentation so it is not used to create data. One of ...
0
votes
2answers
566 views

Row level restore with Oracle Recovery Manager (RMAN)

We're approaching the end of 2012 and I still find myself relying on database exports to maintain the ability to do row level restore operations. While this is a proven method, it sure would be nice ...
1
vote
1answer
9k views

Oracle 11gR2 archive log destinations

I want to add a second archive log destination to an Oracle 11gR2 RAC database with ASM, the idea is that I will then have some redundancy if the primary storage should fail. Archive log is already ...
2
votes
2answers
19k views

How to store single result in variable and reuse it in a query (Oracle)?

I have a query like SELECT id FROM xyz WHERE ...; which has a more or less complex WHERE clause and returns exactly one row with one column (ID). I need this ID for several later queries in a ...
2
votes
1answer
442 views

Upgrading from 10.2g to 11g by incrementals

I know it's possible to generate a full rman backup in a 10.2g database, move it to another server containing 11g, restore it there and finally do an upgrade. Since I have to do this to a large ...
1
vote
1answer
782 views

Can't create archived redo logs

Oracle 11.2.0.3 in Windows Server 2008 64 bits. I try to set up archive mode in a database: C:\Users\Admin>SET ORACLE_SID=BDSPROD C:\Users\Admin>SQLPLUS /nolog SQL*Plus: Release 11.2.0.3.0 ...
0
votes
1answer
2k views

Error when installing Oracle 11.2.0.3 in Windows Server 2008 R2 64 bits

I downloaded Oracle 11.2.0.3 installer: p10404530_112030_MSWIN-x86-64_1of7.zip p10404530_112030_MSWIN-x86-64_2of7.zip p10404530_112030_MSWIN-x86-64_3of7.zip p10404530_112030_MSWIN-x86-64_4of7.zip ...
1
vote
1answer
412 views

Oracle Enterprise Manager font problem, some text is displayed in Chinese and with squares

In Oracle Enterprise Manager 11g database control in the following section: Setup->Monitoring Templates->"Choose template name and click Edit button"->Policies tab Texts are displayed in ...
0
votes
2answers
10k views

Simple query with date type requires explicit conversion to_date of date

My question is, I have a table which contains a column called myDateColumn (for example) which is of the type date: I can confirm desc myTable contains this line: myDateColumn NOT NULL DATE ...
2
votes
2answers
564 views

Oracle symmetrical one-way replication for cheap HA: unfashionable or technically unfeasible?

We have two smallish unrelated databases on two big Oracle Enterprise servers. Instead of buying more licenses and servers for high-availability replicas, can we replicate database B to server A and ...