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) ...

learn more… | top users | synonyms

1
vote
0answers
3k 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
830 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
653 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
648 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
63 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 ...
1
vote
0answers
7k 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 ...
1
vote
0answers
954 views

Oracle 10g - Sudden change in execution time for specific query

After the DBAs fiddled with some parameters in our Oracle 10g Production Environment, most queries became a little faster. But a single query (a quite complex one) became dramaticaly slower - it went ...
1
vote
0answers
65 views

Combine Oracle locator instance with Oracle spatial instance with db link

we plan to have two oracle databases, one with oracle spatial installed, the other one just has the locator option. Is it possible to create an oracle database link between the two databases in order ...
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
303 views

Oracle TOAD and Team Coding with TFS: Unable to get revisions from TFS

My company is currently exploring the option of using TOAD as a means to seamlessly allow developers to check-in/check-out code in TFS. This would be seeded by our packages, stored procedures, etc. ...
1
vote
0answers
151 views

Pass in dynamic value to Oracle job scheduler

How does one pass a dynamic value into the oracle job scheduler when the underlying command is a stored procedure? example procedure: create procedure foo (bar varchar2) ... Job creation in ...
1
vote
0answers
520 views

Restoring Oracle prod backup to test server with new database name

I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database ...
1
vote
0answers
528 views

How can one reliably update a LOB column with data from another LOB column in Oracle?

I have tried: UPDATE "SCHEMA".TABLE SET LOB_COLUMN = (SELECT LOB_COLUMN FROM "SCHEMA".TABLE) I have tried: CREATE OR REPLACE PROCEDURE COPY_LOB_DATA IS OLD_BLOB BLOB; NEW_BLOB BLOB; ...
1
vote
0answers
281 views

Oracle server session terminated by fatal error

I have an Oracle server running on Windows Server. When an INSERT statement runs I receive an Oracle Ora-00603 error. The insert statement just tries to insert a BLOB into a table. I searched the ...
1
vote
0answers
134 views

Use of hash functions in group by?

I'd use a listagg() to generate a list of components a certain customer has and compare it to another list generated the same way somewhere else to detect inconsistencies. The problem is that ...
1
vote
0answers
440 views

Which oracle (10g) template files (DBCA) can be be copied to different server for cloning?

I am trying to clone a schema from one Oracle 10g server to a different Oracle 10g server. I have created a database template (DBCA) from an existing database (structure and data). I have copied ...
1
vote
0answers
630 views

Connection to MS Access from Oracle over a DB Link

I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the ...
1
vote
0answers
2k views

ORA-00449: background process 'MMON' unexpectedly terminated with error 448

I got the follwing error while running a query from Java: The database returned the following error: [Oracle] #11 ORA-00449: background process 'MMON' unexpectedly terminated with error 448 [Oracle] ...
1
vote
0answers
646 views

How do I import a dump for a deleted tablespace?

I'm trying to import a database dump, however I am encountering this error: ORA-39083: Object type TABLE:"MYSCHEMA"."MINF" failed to create with error: ORA-00959: tablespace '_$deleted$5$0' does not ...
1
vote
0answers
139 views

XML parsing failed

I'm using a query on a oracle db which extracts values from clobs using the xmltype function and an xpath. Unfortunately the query fails and reports a 'XML Parsing failed'. I assume that one of the ...
1
vote
0answers
153 views

Problem with SDO_AGGR_CONCAT_LINES in Oracle

I have a line consisting of 3 segments A, B & C A touches B at just one point, likewise for B & C The SDO_AGGR_CONCAT_LINES function returns a MULTILINE object (GType = 2006) rather than a ...
1
vote
0answers
89 views

Dealing with Invisible Referencers

Using Oracle database, suppose I have a parent table parent defined in schema A, and a child table child defined in schema B. To achieve this, schema A granted references privilege on parent to schema ...
1
vote
0answers
523 views

FATAL ERROR IN TWO-TASK SERVER: error = 12571

oracle9i/windows2003,java application. oracle crash, alert log file contains sdh_ora_4636.trc which contains: *** 2012-05-05 13:53:32.000 *** SESSION ID:(100.50539) 2012-05-05 13:53:32.000 FATAL ...
1
vote
0answers
478 views

ORACLE SSL using Microsoft Certificate Store for PKI

I am trying to set up PKI SSL authentication between client and server using a Microsoft Certificate Store. Client: Windows 7 64 bit with Oracle client 11.2.0.3.0 Server: Windows 2008 R2 64 bit with ...
1
vote
0answers
56 views

Diskless Oracle and persistent filesystems

I'm putting together a diskless Oracle database SLES image. What will need to be kept stateful? For example, what filesystems need to persist? Right now, the easy ones I know of are /home, /perf ...
1
vote
0answers
58 views

sdo_tune.quality_degradation returning negative values

While running the sdo_tune.quality_degradation function on one of our Oracle databases most of the results were around 1 but a number had values like -556127.225. Does this mean that these indexes ...
1
vote
0answers
174 views

Can not open oracle 10g database when migrated from oracle sql developer 1.5x to 3.1x

I have migrated from Oracle sql developer tool 1.5x to 3.1x and imported my connection settings with database 10g. When I try to open a connectionstring in the developer tool I get this message: ...
1
vote
0answers
57 views

What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?

I have some profiling scripts which work in some environments, but not others; the odd thing is that it doesn't seem terribly consistent across versions, so I'm guessing there's some patch or feature ...
1
vote
0answers
599 views

FREETEMPORARY on blob with no reference

In Oracle 11g, we are using XMLELEMENT to get records from tables. The problem seems to be, however, that we are calling SELECT XMLELEMENT(...).getClobVal() from DUAL; which is eating our temp ...
1
vote
0answers
780 views

What can cause [DataDirect][ODBC Oracle Wire Protocol driver]Connection refused.?

The Title speaks for itself. We have this error message on the client side of the application. The devs suspect a problem on the database. The alert log on the database shows no errors at all. The ...
1
vote
0answers
90 views

Question on Oracle database table compress option?

How come a compress enable table (name as ABC) when created (Oracle 11g R1), but after merging with a partitioned table's partition with data which is not compressed, then the table (ABC) auto ...
1
vote
0answers
485 views

Error starting up OC4J_EM: java.sql.SQLException: Logical handle no longer valid

I'm trying to launch the OPMN-managed process OC4J_EM, which is needed for Oracle's Enterprise Manager. When I run use the startall or startproc command, I get an error: failed to start a managed ...
1
vote
0answers
790 views

Which packages are required to install Oracle 11.2.0.3 on Solaris 11?

Where can I find information on which packages are required to install Oracle 11.2.0.3 on Solaris 11? The documentation only mentions Solaris 10. I tracked down the packages required for Solaris 10, ...
1
vote
0answers
2k views

Convert the Highvalue of user_partition in varchar2

I have a requirement where I would like to use the HIGH_VALUE field of user_partition table as a Varchar2 or TimeStamp value and I would like to get it used as a Function in SQL Query. Something like ...
0
votes
0answers
15 views

ORA-01033: ORACLE initialization or shutdown in progress

I'm facing the below error while trying to login to database. Oracle services were up and running but was not able to login. Error:ORA-01033: ORACLE initialization or shutdown in progress I tried to ...
0
votes
0answers
24 views

In USER_INDEXES but not in USER_IND_COLUMNS

I can't believe I don't know this but what type of index (Oracle) would have an entry in the USER_INDEXES view and not in the USER_IND_COLUMNS view? I see two system entries in USER_INDEXES. Here is ...
0
votes
0answers
12 views

Toad Error using Proxy Connection

I created a login for a user two days ago to an oracle database and altered another user so this new user could do a proxy connection as that user. Everything worked fine that day and the user was ...
0
votes
0answers
30 views

Oracle query optimization time

Is there any way to get how long it takes the optimizer to optimize a query in Oracle?
0
votes
0answers
11 views

RMAN multilple channels

When to use multiple channels in RMAN? Is it effective only when backup is performed to multiple physical disks or tapes? I've found only that every channel is different session opened by RMAN in ...
0
votes
0answers
22 views

hierarchical query

I have a Oracle table that has child and parent rows similar to the example below P_JID has the parent's JID, it can go as far as 4 levels JID P_JID NAME STATUS ...
0
votes
0answers
23 views

Sql*PLUS: Output each field as a new line

Right now the configuration I have is the following: set pagesize 0; SET NULL *NULL*; SPOOL output/output.txt I am outputing the results to a text file in order to run a function on the file to ...
0
votes
0answers
30 views

Monitoring active query step using only pure sql

I would like to monitor actively running query on Oracle. What I mean is to gather info about: Actually running step. (What is currently db engine doing in this query) Actual query plan used in ...
0
votes
0answers
20 views

missing components in sys.dbms_registry

i just noticed that in package specification of dbms_registry are missing many procedures and functions. there are only four components in spec 'loading', 'loaded', 'time_stamp' and ...
0
votes
0answers
13 views

Difference between @multitenant(SINGLE_TABLE) and @multitenant(VPD) in EclipseLink

Despite the fact I searched a lot in the internet and read many articles, I still be unable to get the difference between the Single_Table strategy and the VPD strategy of EclipseLink. At first I ...
0
votes
0answers
4 views

Configuring management interface on Oracle RAC Listener

i have a SCAN configuration ready & working, but require along with it that each node be separately reachable on a management interface for administrative connections. Listener would have to be ...
0
votes
0answers
34 views

Is this MERGE statement correct?

Question: Is this MERGE statement correct ? emphasis on the ON and AND .. are they rightly placed? MERGE INTO VR_ORDER_LINE USING (SELECT * FROM E14) ON ( VR_LINE.RETAIL_NUMBER = ...
0
votes
0answers
30 views

IO contention on raid5 happens?

I found all of the Oracle data files including redo, control, system, index and everything are in just one directory. And that directory is on Raid 5 disks. In this case do I need to do something ...
0
votes
0answers
37 views

Oracle 11g xe replication/cluster free license?

I am new to db clustering/replication and I want to set up a cluster/replication of a database backed by t2 nodes. I used docker and spun up a preconfigured oracle 11g xe database ...
0
votes
0answers
51 views

How to find out the maximum number of datafiles per tablespace in Oracle?

According to this Oracle document, the maximum number of database files per tablespace is "Operating system dependent; usually 1022". I know there are queries for some of the other limits mentioned ...
0
votes
0answers
17 views

Portable Method of Deploying Oracle Express on Windows (Ideally without Installer)

I'm looking for a portable way of deploying Oracle Express alongside a C# application on a continuous integration machine running CruiseControl. Ideally I would not have to use the installer - this ...