All versions of Oracle. Also add a version-specific tag like oracle-11g-r2 if that context is important in the question.

learn more… | top users | synonyms

2
votes
2answers
57 views

UNION ALL w/ MINUS

Why does: select 1 FROM DUAL UNION ALL select 1 FROM DUAL MINUS SELECT 2 FROM DUAL return only a single 1 rather than 2 rows of 1 in Oracle?
1
vote
0answers
41 views

Check if 1/3 Queries Evaluates to True

My large (+100 line) query contains a WHERE filter similar to: select * from (<complex 100+ line query>) d WHERE ( (EXISTS (select 1 FROM TABLE1 t1 WHERE d.dummy = t1.x ...
1
vote
2answers
5k 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 ...
0
votes
0answers
32 views

Error PROT-23, ocr manual backup

Everyday I have a manual backup of ocr in a rac instance 11.2 and It works fine, but this night the backup failed with PROT-23 error. Now I try to execute it and allways fails. I execute with root ...
0
votes
1answer
940 views

Oracle 12C, cannot drop NOT NULL constraint on a DEFAULT ON NULL column

In windows7 I Install oracle 12 C Then I connect to database as sys user and create new user so: CREATE USER C##USER IDENTIFIED BY user_pass; GRANT ALL PRIVILEGES TO C##USER; Then I connect to ...
0
votes
1answer
246 views

Cannot startup Oracle due to ORA-15041

I'm troubleshooting an Oracle instance that won't startup due to ORA-15041. The trc file shows this error: Failed to create file '+FRA_DATA' (file not accessible?) ORA-19816: WARNING: Files may ...
1
vote
1answer
362 views

Not able to update MySQL table using Oracle: Unknown column in 'where clause' {42S22,NativeErr = 1054}

I have the following tables: MySQL table: jti_member_interact CREATE TABLE `jti_member_interact` ( `INT_MEMBER_ID` int(11) NOT NULL, `INT_ID` int(11) NOT NULL AUTO_INCREMENT, `INT_SOURCE` ...
3
votes
1answer
860 views

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 ...
11
votes
9answers
191k views

Connect to sql plus from command line using connection string

Let's say I have a Oracle database. I have a username = x, password = y, database = z. Also I know the port = a, SID = b, Hostname = c. So how do I need to connect correctly? I used many options like:...
2
votes
3answers
828 views

Oracle Compatible Parameter to set

Is there any difference in setting the Compatible Parameter to 11.2.0.0 vs 11.2.0.4 ? Are there any advantages / dis-advantages ?
0
votes
1answer
36 views

Oracle sql combine several rows of the same table into one row

I have a table where for each given ID, three rows are generated as shown. The first row is the header row: +-------+------+-------+------+-------+----+----+----+ | ID | GRP | ITDESC| DEN | NUM ...
1
vote
1answer
51 views

Fetching user info from many databases at one go

I have a requirement to fetch all the schema available in 100+ Oracle instances running in RHEL environment. All the schema information such as username, roles assigned and is to be dumped in one ...
-4
votes
0answers
39 views

Retrieving the data based on id from table contains 2 million rows [closed]

I have one table/collection contains 2 million rows/document (id(20 alphanumerical digits), name, ... etc). From that table I want to retrieve data based on the id within 1 sec Which database ...
0
votes
1answer
355 views

Why would DBMS_METADATA.GET_DDL Fail when i have the SELECT_CATALOG_ROLE Role?

I am trying to get the DDL using METADATA_DBMS.GET_DDL for an object in a database, and I get the following error: ORA-31603: object "MY_PACKAGE" of type PACKAGE not found in schema "S1" ORA-06512: ...
5
votes
1answer
6k views

how to use dual foreign key in oracle 10g

I have created two tables create table ref1(id varchar2(3) primary key); create table ref2(id varchar2(3) primary key); Now I want to create a third table with a single column as foreign key for ...
0
votes
0answers
21 views

Oracle Report 12.2.1.1.0 Configure Issue

I installed Oracle 12c and Oracle frm 12.2.1.1.0 on my laptop(w10/64bit) properly and Oracle form server and form are run properly. But unfortunatly the report builder doesnt work properly. Report ...
2
votes
2answers
2k views

12c Grid Agent installation issues - Shell path is incorrect or not defined

I am installing 12c Grid Control agent on my server via Enterprise manager. The targer server is a UNIX server with AIX OS on it. I add target host manually, enter authentication information, host ...
2
votes
2answers
1k views

Oracle Data Pump Import imports no records

When we do an Oracle Data Pump import of our database, it runs without significant errors. However, on one table Oracle reports that 0 records have been imported. Processing object type ...
0
votes
1answer
655 views

Oracle trigger error: table %s.%s is mutating, trigger/function may not see it

I am having some issues while trying to use triggers over tables where I need to get the reference of custom data type from a table. I can't seem to get it to work, here are the scripts I am using ...
1
vote
2answers
12k views

What is the difference between Schema and Database in Oracle?

In oracle, Datafile are system files where actual data is stored.The collection to datafile make Tablespace and atlast database is collection of tablespaces Correct me if I am wrong on the concepts ...
4
votes
2answers
630 views

Security for Oracle linked server from SQL Server

I'm trying to make the linked server from SQL Server 2005 to Oracle more secure by not having user/pass on "Be made using this security context:" fields so only a specific user can access the data ...
0
votes
2answers
4k views

Cannot create an instance of OLE DB provider “OraOLEDB.Oracle” for linked server

i am having a bit of a linked server problem . I created a sql server linked server and it's been working fine for last 2 years and suddenly not working . SQL Server Microsoft SQL Server 2005 - 9....
0
votes
0answers
30 views

MSSQL Oracle Liked Server Float Problem

I create a new linked server on MSSQL for Oracle but i have a big problem. I have a view in oracle db. When i call this view everyhting is normal. I mean float fields looks fine ( like 7.6). But when ...
2
votes
1answer
523 views

How to switch Quiescing to Normal Mode in Oracle?

I have two instance database Oracle, they are ORCL11 and ORCL10,.... I've configured them, it looks like correct. Then, I connect to replication user admin ORCL10 conn repadmin/repadmin@orcl10 And ...
0
votes
2answers
13k views

ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64

Im starting to be very very frustrated by this Oracle. So, I have installed Oracle XE 11.2 64 bit and ODAC121012_x64. I can start listener, I can do tnsping xe, but when I try to connect as via ...
0
votes
1answer
202 views

Restoring oracle database

I come from SQL Server and I need to restore a oracle .bkp file in my database. Im using RMAN and I have the .bkp file in: F:\Oracle Back Ups\Back.bkp´ The command that I use in RMAN is: RMAN> ...
1
vote
2answers
444 views

Notification email when deadlock is encountered in Oracle alert log

How to send a notification email when a deadlock is encountered in alert log on any node like the deadlocks encountered below? (an alert any time a deadlock is detected in alert log) Node 1: Mon Sep ...
0
votes
1answer
158 views

mac os - virtualbox - oracle connection error - invalid username/password; logon denied

I have followed the below step guide(URL) to setup Oracle on Mac OS. Everything is fine on the guest side. But, I am facing some issues in host level. I can connect database in Guest (Virtual box) ...
1
vote
1answer
835 views

Toad for Oracle 64-bit : 1603 - Fatal error during installation

I'm trying to install Toad for oracle client, my Toad version is 12.1 for 64 bit system, i have succeeded to install oracle client 12c for 64 bit system, but i have stumbled by a problem when ...
1
vote
1answer
5k views

netca failed during installation of Oracle 12c on Windows

I have installed Oracle 12c on Windows Server 2008 and during installation it shows the following warning: [INS-20802] oracle net configuration assistant failed When I click retry it continues ...
0
votes
0answers
28 views

Hyper-V as Oracle Client failling to connect at Host Oracle Server [closed]

I have a Windows 8 Server (as host) running Hyper-V with a Windows 2012 server (as VM) On Host I installed the Oracle 10g (server version) and the Client 11g at the VM. At VM when I try to connect ...
0
votes
3answers
481 views

lsnrctl is not working on Ubuntu 14.04

I have managed to install Oracle 11g on Ubuntu 14.04 through lots of pain. I managed to install it in the end but listener does not seem to be working and even responding any command. My /home/...
0
votes
1answer
21 views

cant access both phone numbers in my nested table type

Im using Oracle Developer and I have a customers table where each customer has 1 home-phone number beginning with 0131 and either 1 or 2 mobile numbers. I am trying to display the customers name and ...
0
votes
2answers
41 views

ASM Diskgroup Creation Issue

I have 6, two node RAC databases running in the two physical servers. While I try to create new diskgroup, I get the following error: ORA-15018: diskgroup cannot be created ORA-04031: unable to ...
-1
votes
0answers
33 views

How do I install Oracle12c and then connect through SQL Developer? [closed]

I am having trouble installing Oracle12c and then establishing a connection. I have downloaded both files from Oracle's website for windows x64. I have read through the Oracle documentation on their ...
4
votes
2answers
3k views

Loading XML documents to Oracle 11g DB with control file

I am using Oracle 11g XML database and trying to load XML documents to this DB with a control file and the sqlldr utility. All these XML files have an element that contains a date string with time ...
0
votes
1answer
1k views

Oracle Enterprise Manager Installation

First I install oracle 11g database with this configuration Step 2 of 9 I selected Create and configure a database Step 3 of 9 I selected Desktop Class Step 4 of 8 Global database name: Blitz ...
0
votes
1answer
36 views

Trigger to delete with cascade effects [closed]

Hi I am new to Oracle triggers. Your help will be much appreciated! I have the following 2 tables: Product: CREATE TABLE Product (prodId varchar(10) NOT NULL PRIMARY KEY, prodName varchar(30) ...
5
votes
2answers
1k views

Find out if two rows came from same transaction in Oracle

I am using Oracle 11.1 and would like to figure out if two rows in one table where inserted by the same transaction. Is there an easy sql statement to map a row to an transactions id? The table is an ...
2
votes
1answer
564 views

Database design for a table with both bulk insert and single row insert

I have to design a table where records will be inserted in two ways. Bulk insert from a batch process from a delimited text file between 2 - 3 million rows in a short burst. Later the same records ...
0
votes
1answer
393 views

Strange error in trace file for NSAn standby process

One of the Oracle databases I help manage is the primary in a standby configuration, with two standby databases. I started finding repeated entries in the alert log on the primary for a failure to ...
0
votes
1answer
39 views

Oracle multiple databases on same server [closed]

I want to be able to import multiple database dumps locally and be able to switch between them. What I would like to achieve: Import dumps (objects+data) from multiple databases to local database ...
0
votes
1answer
4k views

SQL Server - linked Oracle server: EXECUTE permission denied on 'xp_prop_oledb_provider'

Inside of our SQL Server, we have created a linked server to an Oracle server. We ave mapped several users to the Oracle server and specified the credentials. On the Linked Server 'Security' ...
0
votes
1answer
37 views

Deadlock resource when try to drop datafile

This morning I did a mistake, I made a datafile offline by using alter tablespace users drop datafile 'C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_USERS_6LD56LRR_.DBF'; The reason is I want to drop that ...
2
votes
1answer
2k views

ORA-12546: TNS:permission denied, on Windows through Task Scheduler

I am trying to export all objects of specific oracle user by executing a batch file through Windows Task Scheduler: exp.exe myuser/pass@dbname owner=myuser log=mylog.txt The Oracle 11.2.0.4 x64 and ...
0
votes
1answer
42 views

Oracle DB refresh on 11g using 10g Cold backup

I am a sql dba, I am having only a little knowledge on Oracle. looking for help regarding oracle db restore. I am having an Oracle 10g cold backup, i need to restore this on Oracle 11g setup, can you ...
3
votes
2answers
46 views

Why am I getting ORA-00937 error using only aggregate functions?

Here is a sample of what I'm trying to do: SELECT COUNT(T1.FIELD) + ( SELECT COUNT(T2.FIELD) FROM TABLE2 T2 ) FROM TABLE1 T1 I don't see a need for group by clause in ...
-1
votes
0answers
27 views

While Recover Database and Database Open getting error ORA:01190

After Recover database from all OLD DBF File and run script for Alter Database Open resetlogs; Getting error message: ORA-01190: control file or data file 1 is from before the last RESETLOGS ...
0
votes
1answer
36 views

Failure to parse data returned by server

i login oracle database 12c with sys user with sysdba privileges.But in user section when i want to show the properties of other users by double clicking it, it shows the following error- 'Failure to ...
-1
votes
1answer
44 views

How to add default constraint in Oracle while altering column [closed]

I'm new in Oracle and my requirement is to port SQL Server statement to Oracle. I want to alter a column with adding a new constraint with a default value. SQL Server Query for the same: ALTER ...