Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...
7
votes
0answers
106 views
Generate XML using Oracle XML schema
I have some XML schema definitions that have been registered using DBMS_XMLSCHEMA. I have created tables using the XMLTypes generated. I can create XML using XMLQuery and if I understand correctly, ...
5
votes
0answers
40 views
Sudden increase in log_file_sync waits
I'm on Oracle 11gR2 with a 2 node RAC system. It's shared fiber storage to an EMC Clariion.
Last friday things went bad..fast. All of the sudden processes that normally ran fine for years became ...
5
votes
0answers
97 views
9i streams capture doesn't evaluate rules
I have a streams replication set up between two oracle 9.2.0.8 instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table ...
5
votes
0answers
162 views
SQL Server Linked server query problem (group by)
I have been using an old SQL Server 2000 installation for a long time that is linked to several Oracle servers, and it all works very well.
I am trying to migrate to SQL Server 2012 via SQL Server ...
4
votes
0answers
20 views
Tablespace on ephemeral storage
For performance reasons in some scenarios, e.g. Amazon EC2, you have access to a faster and cheaper storage device, which loses all its data on reboots, so it is called "ephemeral".
This question is ...
4
votes
0answers
162 views
asm diskgroup drop from another asm instance
I have created long time back one ASM RAC setup and I created one diskgroup with some name say xyz. I think that instance is gone but the diskgroup was not dropped exclusively using command
drop ...
3
votes
0answers
54 views
General tool to load dump files
I am a big fan of Postgres both for its price but also for its features.
I am going to have to need to upload into it both Oracle dump and SQL Server files.
I will try to ask and beg for plain .csv ...
3
votes
0answers
379 views
Mismatched Oracle drivers - need upgrade (10.2.0.1 to 10.2.0.5)
I was forwarded here by recommendation from Stack Overflow ......
We are running Oracle Enterprise software on various client and DB servers and we are experiencing a problem (outlined here) where ...
3
votes
0answers
1k views
Oracle Trace File Interpretation: enq: TX - index contention
Background
I've got an application which is doing a large number of concurrent inserts into an Oracle table. The Top Activity view is reporting a lot of index contention and I am attempting to reduce ...
2
votes
0answers
99 views
Oracle UPDATE single record with multiple WHERE conditions
I'm trying to UPDATE values in an Oracle database table (of salary information) that has no row IDs or a primary key. I'm writing these statements in LinqPad.
This syntax should work just fine in ...
2
votes
0answers
33 views
Enabling/disabling/changing Oracle auditing without a shutdown?
I have a large database that needs auditing on a very detailed level (every select, update, insert, and delete, along with the actual text of the statement) for about half the users. I know how to do ...
2
votes
0answers
76 views
Oracle: How to gather stats in a logical standby database?
I have a Primary and a (logical) Standby Database. The Schema 'APP' gets synced.
Now a User has performance issues running a query against some tables in this 'APP' schema of the Standby Database. On ...
2
votes
0answers
107 views
Create Oracle ASM Disks Without Installing Oracle
I have been asked to setup workstations (VMs) for an instructor's Oracle 11g R2 Workshop. I am finding the documentation that was downloaded from the Oracle Academy site extremely underwhelming. I am ...
2
votes
0answers
256 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 ...
2
votes
0answers
428 views
Access 2010 linked table - solve the “decimal field's precision” error
I have an Access 2003 database (running on Win 7 64-bit, Office is also 64-bit) that has many linked tables pointing to an Oracle 11g instance through 64-bit Oracle ODBC driver. Most of the tables ...
2
votes
0answers
207 views
Help with SELECT queries
I need help with some queries. I struggled do find out how to do it, but I think I finally caught on or at least got the results I was looking for in the database.
These are the tables (given by my ...
2
votes
0answers
392 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 ...
2
votes
0answers
261 views
Where can I find a syntax reference for Oracle SQL Developer's “Generate DB Doc” function?
Oracle SQL Developer (I'm using v3.2) has a feature called "DB Doc", which generates documentation for database objects. I mostly want to use it to generate documentation for my stored procedures, ...
2
votes
0answers
320 views
Why does Oracle hang on “ALTER TABLE ADD … NOT NULL”?
Using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0, the operations below have completely stumped me. The first locks up (table has DDL lock, finally killed query after 20+ minute wait). ...
2
votes
0answers
118 views
Oracle sqldeveloper Database Diff - not seeing indexes/sequences
I am using Oracle SQL Developer's database diff tool to compare schemas. (SQL developer version : 3.2.09) It works great on some environments, but in one, I can only see differences in tables - the ...
2
votes
0answers
2k views
Oracle 11g .DMP viewer
I have received a dump of a Oracle 11.2.0.2.0 db, which I'd like to export to some readable format like plain text, CSV, excel...
Is that possible in some sort of a simple way? I've found a few ...
2
votes
0answers
600 views
oracle crash - not starting
We have a
Windows Server 2008 R2 Enterprise x64
Oracle 10.2.0.3
Adempiere - ERP
We had a power breakdown at 03.00 AM.
At 07.30 AM we started the server
At 08.00 our colleagues observed that the ...
2
votes
0answers
187 views
Ports necessary for Oracle 11g Replication across a firewall?
We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
2
votes
0answers
207 views
SQL Developer Data Modeller and Data Dictionary question
I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please?
I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
2
votes
0answers
1k views
Encoding problems with sqlplus, Linux
I use sqlplus and all non-Latin characters appear as '?' when I run select queries. When I run insert or update queries with non-Latin characters I get question marks on a web page.
select * from ...
2
votes
0answers
121 views
How to Connect R to Oracle?
I need to connect R to oracle and I have been unsuccessful so far. I downloaded two packages: RODBC & RODM.
This is the statement that I've been using: DB <- ...
2
votes
0answers
771 views
SQL*Plus, @, and relative paths
Somehow, it seems that SQL*Plus (at least on Windows) is unable to locate a script with a relative path when called with @@ and when the path starts with a single or double dot.
For example, under ...
2
votes
0answers
179 views
Oracle faster overlap check
We've a table with two columns beginrange and endrange, which contain hex values.
To this table no overlapping ranges should be inputted.
We had implemented the check by having a composite functional
...
2
votes
0answers
131 views
What do I need to do to avoid ORA-32696 errors?
I have a SELECT query using several WITH blocks. Sometimes it runs successfully. Very often it fails with the error "Lookup Error - Oracle Database Error: ORA-32696: HTI: No free slot". I Googled the ...
2
votes
0answers
611 views
ORA-01017: invalid username/password; logon denied
I've come across the abnormal situation, and can't understand what happens.
I am connecting databases using PL/SQL Developer 8.0.4.1514(I've also tried v7,but same) . Sometimes(When I am trying to ...
2
votes
0answers
473 views
Oracle GoldenGate replication is stuck
I deployed Oracle GoldenGate to integrate many-to-one databases. After initial loading everything works fine. Until recently, some of the replicat seem to stuck and do not proceed to change ...
2
votes
0answers
247 views
Isssue with Database Links converting OEM Job to DBMS_Scheduler Job
We had an OEM job that would run a PL/SQL block using a particular database users credentials. The credentials are the same for two different databases, so there was no problem for the block to use a ...
1
vote
0answers
46 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
0answers
43 views
+50
How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2?
I am trying to setup DBMS_SCHEDULER in Oracle 11g to run a remote database job.
I have a remote Oracle 11g R2 database on unix and a local one on Windows.
I read that you can install the oracle ...
1
vote
0answers
26 views
Why Oracle Database trigger can became DISABLED
We have an application, using ddl database trigger on oracle database.
Trigger depends on package and several tables, package depends on user defined function.
It works on different customer sites ...
1
vote
0answers
38 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
84 views
Unable to recover database
How to resolve this issue, I am getting this error, when I'm trying to open my Oracle Database
ORA-16038: log 1 sequence# 59 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: ...
1
vote
0answers
106 views
How do I execute an Oracle SQL script without sqlplus hanging on me?
For an automated task I would very much like to run some SQL scripts and make sure that sqlplus does not hang under any circumstancees, i.e.:
If the script contains any named substitution variable ...
1
vote
0answers
160 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
42 views
Calling a function in remote database inside a stored procedure
There are 2 Oracle databases with pseudo names Remote and Local. I have a function in Remote called FUS.F_Return_10 which simply returns 10 for testing purposes, where FUS is a schema name. In Local I ...
1
vote
0answers
118 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
188 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
0answers
29 views
How can I count the total number of document indexed by my oracle.text index?
I know I can use ctx_query.count_hits to count the number of document matching a query,
and similarly, I can use
count(*) where CONTAINS(...)
But these are only options if I actually have a query. ...
1
vote
0answers
201 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
0answers
37 views
How open oracle DB Linux (After installation)
I have just installed Oracle 11gR2 on my Linux Mint Distro (xfce). All worked fine, and I was able to acces to
https://localhost:1158/em [Erreur 102 (net::ERR_CONNECTION_REFUSED) ]
I rebooted my ...
1
vote
0answers
196 views
Root cause for Invalid arguments in call (ORA-17068)
We are getting Invalid arguments in call when we try to establish the connection with Oracle DB occasionally ( One hour in a day).
I did some research about this in Internet, still i am not getting ...
1
vote
0answers
246 views
Migrating from Oracle to MySQL using WorkBench Migration Tool
I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows:
Database ...
1
vote
0answers
239 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
108 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
0answers
53 views
Oracle update query sequence of actions on DB side
I searched online but could not find particularly consolidated source of what happens when you execute an update query. I know that there are a few actions happening like create redo data and logs ...
