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, ...
1
vote
1answer
73 views
Delete shared memory segments left over by an Oracle instance
We're using Oracle Enterprise 11rR2 running on Solaris.
How can I delete/remove allocated shared memory segments using ipcrm?
I'm getting this error:
ORA-01041: internal error. hostdef extension ...
1
vote
1answer
95 views
need to use PLSQL to insert distinct rows
I need to take some data from Table A, use some logic, and then insert one or more rows into Table B. I have a PLSQL block that brings in data from Table A with a cursor, performs all the logic ...
1
vote
1answer
69 views
Strange behaviour of a query with order by and rownum on Oracle's Exadata server
I am executing the following query on two different database servers:
SELECT start_date,
end_date,
resort_id
FROM employee_activity
WHERE employee_id = 27
AND start_date < ...
1
vote
2answers
108 views
Count events on “user based” sliding window
So, if I wanted to know how many events a certain user bought in certain timeframe windows. I will use 7 for the example, but the query should accept this number of days as a parameter, which will be ...
1
vote
1answer
103 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 ...
1
vote
2answers
138 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
1k views
How to make stored procedure with outputs OUT sys_refcursor, OUT varchar2, and OUT number, then use in c#.net app
What is the syntax for a stored procedure that outputs a refcursor, a varchar2, and a number?
I would like to output all three in the result, for the purpose of displaying count, and a message which ...
1
vote
1answer
373 views
Oracle backup with RMAN Options?
I'm trying to learn RMAN but getting confused everytime I read Oracle docs!
Can someone help me what are the differences and when to use the following?
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT
...
1
vote
1answer
765 views
Error calling stored procedure from trigger in Oracle Database 11g
I'm trying to create a trigger that calls some Java code whenever a table is inserted/updated. I'm aware of possible performance issues, I don't need advice that I should not do this; I just need to ...
1
vote
2answers
3k views
Installing Oracle 11g on Ubuntu 11.10
Does anyone know to how to install Oracle 11g on Ubuntu 11.10?
1
vote
1answer
5k views
Where all can the /*+ PARALLEL */ hint be used?
It works with SELECT and UPDATE statements.
Are there some more statements with which it works?
I was able to use it with create, but am not sure if the hint was actually considered.
SQL> create ...
1
vote
1answer
29 views
Rebuild an index while it is being referenced in Oracle
I have come across many articles on this site and on Tom Kyte's blog on the how, whys and whens of Re-building indexes. Note that this question is about whether I can rebuild when there are concurrent ...
1
vote
1answer
284 views
How to list all users that have grants over a package
I'm looking for some query to list all users that have grants over a package.
For example, user Schema_A has been granted to execute package: B.MyPackage.
I'm querying views or tables like: ...
1
vote
2answers
830 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
2answers
209 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 ...
1
vote
1answer
3k views
Oracle DBCA utility: “Listener is not up or database service is not registered with it”
I'm a software engineer with some experience on SQL Server but a newbie on Oracle.
I'm attempting to run dbca on a remote linux machine to reconfigure a database that was initially configured to idle ...
1
vote
1answer
4k views
How do I grant execute permission to an Oracle database user?
I'm trying to call a Java function from Oracle database that does the following:
Process p = Runtime.getRuntime().exec("...");
When I try to run it, I get the following error:
ORA-29532: Java call ...
1
vote
1answer
419 views
Rule of thumb: AUTOALLOCATE or UNIFORM size for tablespaces
Is there a rule of thumb for creating a tablespace with extent management AUTOALLOCATE or UNIFORM? If the latter applies, how to estimate a reasonable extent size?
Even more, what should apply for ...
1
vote
1answer
184 views
Error creating linked database to oracle
CREATE DATABASE LINK myLINK CONNECT TO username IDENTIFIED BY password USING 'PROD';
OPT=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.6.1.5)(PORT = 1521))
)
...
1
vote
1answer
354 views
Oracle 11gR2 - Limits on Materialised View replication between databases
We are about to deploy a 3rd party product running on Oracle 11gR2. The product allows very generic text searches. We'd like to mitigate the performance impact of the searches.
Our current design is ...
1
vote
1answer
47 views
where is oracle session timezone set?
I have a logging table
CREATE TABLE EMAIL_LOGGING
(
ID NUMBER(9) NOT NULL,
SEND_DATE TIMESTAMP(6) DEFAULT LOCALTIMESTAMP NOT NULL,
...
1
vote
1answer
127 views
grant execute on utl_file to user in Oracle 11g XE
sqlplus connect <sys>/<pwd>
grant execute on utl_file to <user>
connect <user>/<pwd>
DESC utl_file
then i get:
ORA-24372: invalid object for describe
How can I access ...
1
vote
1answer
163 views
Specify Server for DBMS_Scheduler Job in Policy Managed RAC
A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test is being run from. I know that with an Admin managed database this could be done by creating a service that ...
1
vote
1answer
56 views
Update field1.table1 based on compound join between table1 and table2 - Oracle
I want to run update statement on Oracle 11g, but it fails with the following error:
SQL Error: ORA-01427: single-row subquery returns more than one row
01427. 00000 - "single-row subquery ...
1
vote
1answer
1k 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 ...
1
vote
1answer
275 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 ...
1
vote
1answer
128 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 ...
1
vote
1answer
178 views
What are the things need to be considered while creating tablespace?
I am creating temporary/permanent tablespace on Oracle. As I am going to create an application that is transactional there will be traffic. I bumped into concept called tablespace in oracle. What kind ...
1
vote
1answer
141 views
Can I recover an overwritten incident trace file?
I was looking at incident trace file in oracle database but some how that file got overwritten. As of now I have ecrep_ora_26467_i49966.trm but trhe corresponding .trc file is lost. is it possible to ...
1
vote
1answer
2k views
ORA-39165 Schema was not found in export
I'm getting the following error on a data pump export:
ORA-39165: Schema OFDAT was not found.
First I verified that I had full export permission:
GRANT EXPORT FULL DATABASE TO OFDAT;
Then I ...
1
vote
1answer
353 views
Reverse engineer Oracle database in visio
Trying to reverse engineer tables added into a database but when i connect, I get strange Chinese symbols with a lot of apex stuff.
I dont see anywhere the tables that i added, what am i doing ...
1
vote
1answer
148 views
Oracle block usage
I am wondering about a weird deadlock and after checking all other components I am considering it to be a INITRANS problem in Oracle 11.2.
Now three questions arose:
Is there some way of analyzing ...
1
vote
2answers
6k views
Oracle11.2g post-installation problem on Oracle Linux kernel
[question copied from stackoverflow]
After installation of Oracle 11.2g in silent mode on the Oracle Linux kernel, I have the following error:
[u01/app/oracle/product/11/bin] $ sqlplus
sqlplus ...
1
vote
1answer
124 views
Oracle bitand inconsistent behaviour
I'm working on a legacy database using bitmaps for searching. I'm using the bitand function to find bitmaps that match a given bitmask but I'm getting the wrong results: the bitand between two numbers ...
1
vote
2answers
3k views
How to connect to a local server in Oracle SQL Developer like SQL*Plus with no TNSlistener?
How can I use SQL Developer to connect to a local Oracle 11g server? I didn't enable TNS Listener, but SQL*Plus works well.
@update1:
I copied all *.jars from ...
1
vote
1answer
447 views
Can a Wallet be used with SQL Developer? How?
I have a Wallet configured and working fine for SQLPlus. Is there a way to make it work with SQL Developer?
1
vote
0answers
24 views
rman 'delete archivelog all’ very slow
On our automated test system we use flashback all the time to reset our Oracle 11g database to a state before a testrun. We noticed some of the scripts involved started to become slower and slower. In ...
1
vote
1answer
43 views
Data Migration from Oracle to SQL Server [duplicate]
If you need to do a data migration from an Oracle database to SQL server, what approaches and technical solutions are the best practice?
Our database has about 100 million rows and a total of 52 ...
1
vote
0answers
69 views
Performance Hit when upgrading to Oracle 11gr2
I am experiencing the same symptoms as noted in this question which was closed and does not have a satisfactory answer.
Original Question
We've recently upgraded from Oracle 10gR2 (10.2.0.4 ) to ...
1
vote
1answer
126 views
NLS_TIMESTAMP_FORMAT changing automatically and randomlly
I am using Oracle 11gR2. My nls_timestamp_format is changing randomly from dd-mon-rr to yyyy/mm/dd.
Does anyone have any clue why this is happening?
1
vote
0answers
50 views
need the most efficient way to handle unique constraint errors
I am looking for the most efficient way to solve this situation:
We are an Oracle shop. I need to load data from one table to another. My source table, which contains 30 million rows, has a person ...
1
vote
0answers
321 views
impdp failing with ORA-01031: insufficient privileges
I'm trying to import a dmp file provided by our dba to my dev database. I've been able to export the contents to a SQLFILE and the contents look ok. I tried importing the schema and it kept on failing ...
1
vote
0answers
185 views
Registry error while trying to install Oracle 11g on Win 2008 R2
I am new to Oracle and trying to install Oracle database 11g Enterprise Edition on Windows 2008 Server R2 but getting this error all the time...
It gives me error when updating registry key ...
1
vote
0answers
306 views
Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant
this is my first time to install Oracle 11g R2 on Linux.
I made all instructions in Oracle documentation.
But in the installation process, the Net Configuration Manager is failed.
I continued the ...
1
vote
1answer
357 views
Alternative tools to export Oracle database to SQL Server?
I've got an Oracle database that I need to export (schema and data) to SQL Server.
I am trying the Microsoft SQL Server Migration Assistant for Oracle, but it is horribly slow, grossly inefficient ...
1
vote
0answers
247 views
Oracle 11g R2 - same query sometimes fast, sometimes slow
I have a simple update query on a table with about 100 rows in it:
UPDATE RESULTS_DATA
SET IMAGE_BLOB=:myBlob
WHERE MEASUREMENT_INDEX=:mIndex
AND BATCH_ID=:batchId
AND SYSTEM_ID=:sysId
...
1
vote
1answer
88 views
Unable to start Oracle Database Server : Get an error as I try to start it
I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop :
but as I click this icon I see this dialog box :
What is it ? How do I ...
1
vote
0answers
263 views
Oracle 11g release 2 32 bit client Installation
I have installed a 32 bit Oracle 11g Release 2 (11.2.0.3) client on my Solaris 64 bit machine. But I am getting:
Generic Status: Library Open failed, Library Name: libclntsh.so, Platform Status: ...
1
vote
0answers
128 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.
...
1
vote
1answer
80 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 ...
