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

0
votes
1answer
58 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
1answer
50 views

Oracle RAC not starting up after reboot of system

I have a 2 node RAC (11gR2) machine that was running fine till i did a hard reboot of both the RAC nodes as i had to extend the disk space of the vms they were running on. I also deleted the archieve ...
0
votes
1answer
19 views

Enterpise Manager 12c to Database 11g

Does Oracle Enterpise Manager 12c can be install with Oracle Database 11g? Because the Oracle Enterprise Manager 11g is no longer available.
0
votes
1answer
30 views

HOW does ROWNUM work with this “optimization”

I'm trying to optimize a query in which I have some requirements where I need to be able to arbitrarily select a row ROWX from a query. Why is it that SELECT XML_DATA FROM (Select ROWNUM AS ...
-1
votes
1answer
32 views

Oracle Database XE 11.2 Question on how to get started [closed]

I have installed Oracle Database XE 11.2 on my laptop PC. As I am new to Oracle and to SQL in general, I am finding it difficult to get started. I have searched but couldn't find any "step-by-step" ...
0
votes
0answers
19 views

Want to replicate between two Golden Gate versions

Can golden gate replicate between two versions? Example: Extract site is 11.1.1.1 AND Replicat site is 11.2.1.1
1
vote
1answer
42 views

ORA-00942: table or view does not exist

I have application / service which connects to Oracle database (11g) which shows me "ORA-00942: table or view does not exist" in its log file without any indication of particular table/view with ...
0
votes
0answers
28 views

Not able to select the disk during Oracle 11g Installation [duplicate]

Hi All, During the installation, I am not able to select the available disks which are already stamped using ASM. Any idea what could be the reason? I have tried to select using keyboard space as ...
0
votes
1answer
44 views

Using environment variables in data pump query

I have been trying to use data pump (expdp and impdp) in order to retrieve some data from a database to import it into another. I am using the expdp using the table and the query parameters in order ...
0
votes
0answers
25 views

Oracle spatial database

I am trying to run a simple query mentioned on: http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_operat.htm#g996876 SELECT c.mkt_id, c.name FROM cola_markets c WHERE ...
1
vote
1answer
30 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
2answers
30 views

Hide zero hours and minutes with NLS_DATE_FORMAT

I'm currently using date format: alter session set nls_date_format = 'DD.MM.YYYY HH24:MI'; The (cosmetic) problem is that this always displays time even if it's zero, for example: "27.03.2014 ...
0
votes
1answer
38 views

Where does Oracle Enterprise Manager derive the “User Logon Time” metrics from?

Oracle's enterprise manager has a metric named "User Logon Time" and will show an alert if that exceeds a certain threshold. I would like to retrieve the numbers stored for this metrics directly ...
0
votes
2answers
61 views

SELECT first value from 3 tables that is not null

Having 3 tables with name(varcahr) value(varchar) pairs how do I select the value for a given name from one of the table with respect to the following conditions select value from tab_1 if it exists ...
0
votes
2answers
48 views

Is there any disadvantage to using Oracle's Easy Connect syntax?

Oracle allows a few different syntaxes for specifying where to find your database service. The one I've seen most commonly (in the few short years I've been developing software professionally) looks ...
1
vote
0answers
35 views

is there a DB client which supports oracle editions?

We are using a clever feature or oracle 11gr2 called edition-based redefinitions. This means each stored proc and view looks different depending on the edition you set in the session. There are ...
0
votes
2answers
37 views

Get values that match any of pattern

Given two tables values(value varchar(100)) and patterns(pattern varchar(100)) How to select all rows from values that match any of pattern found in pattern table's rows
0
votes
1answer
42 views

Stored Procedure result is not showing in Datagrid pane in Toad for Oracle

Hi I have created a procedure in Toad for Oracle 12. When I execute the procedure it does not show the dataset in datagrid pane. While procedure get executed successfully. What I am doing wrong. ...
0
votes
2answers
84 views

Is it possible to know how many times a user connected to an Oracle database?

Is it possible to know how many times a user connected to an Oracle database? If possible where we can find this information?
3
votes
0answers
48 views

Why would function based indices I’ve created lower the cost but now show up in the explain plan breakdown?

Sorry for the terrible column/table names but since this is for a work project I wanted to insure it was ok to ask. I was just hoping to at least learn why I'm not seeing my functional indices being ...
0
votes
0answers
43 views

Execution time is different between normal query and query inside a stored procedure

I have following simplified query WITH Report1 AS ( SELECT SUM(t.X), SUM(t.Y) FROM Table1 t WHERE t.Date1 > :dateStart and t.Date1 < :dateFinish ) SELECT * FROM Report1 This query ...
0
votes
0answers
38 views

Enterprise Manager goes pink, legend color for other

To whom it may respond to, While monitoring our databases, we have seen that one of EM screens has gone pink, the color stands for OTHER at the legend. We have checked alert log and trc files, ...
0
votes
1answer
52 views

“Invalid option” while creating a tablespace

Can someone tell me what is wrong with this syntax: CREATE TABLESPACE ACME_DATA DATAFILE '/oracle/d02/acme/ACME_DATA_01.dbf' SIZE 40M EXTENT MANAGEMENT LOCAL AUTOEXTEND ON NEXT 2M MAXSIZE 100M ...
3
votes
1answer
62 views

connection issue / Oracle Express 11g in windows7 32bit

I have an issue with Oracle Express 11g in windows7 32bit. Everytime when I try to conncet to the database I get this error message. How can I fix it please!
2
votes
0answers
59 views

How to distribute a given database between multiple DBMS on a LAN? [closed]

Given a Database D, i need to distribute it over different DBMS in a LAN. D will be split into tables, and each DBMS will store a given table. Here is a sketch of what i need to do : I also need to ...
1
vote
2answers
49 views

How can i fix the Oracle Enerprise Manager error - Agent is blocked?

I have installed OEM 12c and after restarting my oms the agents got the following error: Heartbeat Status : Agent is blocked Blocked Reason : Plugin mismatch found between agent and repository. I ...
1
vote
0answers
80 views

automating oracle database installation on windows

I'm trying to install oracle 12c database on windows using the silent install with a response file as: setup.exe -silent -responseFile file.res where I generate the response file using the gui and ...
1
vote
1answer
51 views

Oracle temporary table usage with XA

I'm confused about the compatibility of Oracle XA with global temporary tables. I've read several places on the internet and in the oracle documentation that say "Distributed transactions are not ...
0
votes
3answers
46 views

How to mirror the privileges of an user to another in Oracle Database? [duplicate]

I need to grant all the privileges of a user (say 'AAA') to another user (say 'BBB'). Is there such an Oracle command (11.2.0.3.0)?
1
vote
1answer
50 views

Create Standby database using SE

We are on 11.2.0.1.I have been trying to create a Manual Standby database using Standard Edition. Although at this point its more like an incomplete recovery. This is wat i did Create Standby ...
0
votes
0answers
51 views

Oracle apps DBA

ORACLE APPS R12: Could you help me any one on this issue: i am able to open all the forms except order management:sales order form(version: apps R12). Here you go below are error description and ...
0
votes
0answers
42 views

export query results to file

I am facing the following issue. I want to execute a query and export all the results in a file. My query is saved as in varchar2 type and i can execute immediate on it and give me all the results. ...
2
votes
3answers
80 views

Move Complete ORACLE from one system to another

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. Entire ORACLE HOME ( bin , control files, data files everything on oracle) is on 2nd ...
1
vote
1answer
34 views

Move Complete ORACLE from one system to another [duplicate]

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. [Oralce 11G Enterprise Edition] Entire ORACLE HOME ( bin , control files, data files ...
0
votes
3answers
39 views

How to use Oracle Installation Prerequisites on Redhat Linux 6.5?

Today I get error below when install Oracle 11gR2 on Redhat Linux 6.5. I follow instruction in this link: http://public-yum.oracle.com/ After I call this command: # yum install ...
0
votes
0answers
44 views

in Oracle, which tables/indexes in query are responsible for disk reads?

Looking at the V$SQL_MONITOR view, I noticed some long-running queries where all the time is on disk I/O. I can see the total number of disk reads for the query. But how would I get the next level ...
0
votes
1answer
21 views

Stored Procedure with ROW instead of a list of parameters

i have a table with 15 columns, and trying to create a stored procedure in PL SQL that will only insert a row in a table using the INSERT statement. i would like to know if it is possible to declare ...
0
votes
0answers
92 views

index usages on table with recursive relationship

we are working on a project that uses jpa and oracle. In this project we have a table with a recursive relation: Create table alarm ( id varchar2(200), ... alarmcode varchar2(50), parent_id ...
0
votes
0answers
24 views

Oracle Database Gateway for SQL Server - Output changes to multibyte view

I have a really strange problem querying a Microsoft SQL Server through a Oracle Database Gateway for SQL Server. Some query outputs look like this SELECT NAME, RawToHex(NAME1) FROM XY; Output: J ...
1
vote
2answers
69 views

Identify in details the consumption of memory from a specific session

We are using Oracle 11g standard, without any options (diag/tunning/perf). I can identify one session with the SQL bellow which having a high consumption (1.4 GB) of memory on the past hours... ...
4
votes
1answer
88 views

date formatting in Oracle

this query: select to_char(sysdate, 'Ddspth MONTH, Yyyysp') from dual will return: Eighteenth MARCH , Two Thousand Fourteen i am wondering if there are any additional formatting keywords that ...
2
votes
1answer
40 views

Does a DDL in Oracle affect other transactions?

I understand that DDL statements in Oracle have an implicit commit before and after the statement, which obviously affects the current transaction. However, does a DDL statement in any way affect ...
0
votes
4answers
34 views

Oracle How to find Debug Compiled Stored Procedures/Functions

How can I get list of stored procedures/Function which are compiled for debug? I do not see relevant column in following tables. DBA_PROCEDURES DBA_OBJECTS
0
votes
2answers
45 views

Help about Oracle licensing

I would like to know some details about oracle licensing. What is oracle processor licences? How does it differ from the other?We are planning for a dual processor server, do we need to purchase 2 ...
0
votes
3answers
45 views

What is the instance name of the box I'm logged into?

I'm at the linux prompt of a computer running Oracle 11. Without connecting to the database, how can I determine what is the instance name of the Oracle server running on this box?
0
votes
2answers
88 views

maximum number of interval partitions in Oracle 11g

Does anyone know the maximum number of interval partitions permitted in Oracle 11g? didnt find anything in Oracle documentation -perhaps missed something. Thanks in advance!
0
votes
1answer
38 views

Access and filter in oracle plan

I came to a execution plan where oracle choose to access the index but instead of using the columns as predicate it only filter by them. My question is what are the reasons that can cause that(all ...
0
votes
2answers
43 views

Where .dmp file is restored after import in oracle?

I am new to oracle and I have abc.dmp file at c:\abc.dmp location. I want to import this abc.dmp file. I am using the following command. c:\>imp system/mypassword file=c:\abc.dmp full=y I am ...
0
votes
1answer
44 views

Inserting data into a table with one value as clob and blob

My table has one clob column and one blob column. I need to insert data into it through insert statements. The length of data to be inserted is more than 4000 chars. When I do export of insert ...
2
votes
0answers
58 views

Historical SQL Monitoring

Is there a built-in Oracle feature that extends Real-Time SQL Monitoring to historical activity? I am specifically interested in getting wait events aggregated at the SQL operation level, not just ...