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
0answers
34 views

Oracle Enterprise Manger not working correctly

I'm not familiar with oracle management. The problem is when I try to connect to the enterprise manager through the Web browser I get this error: Where to find the log file to see what's the ...
1
vote
0answers
23 views

Multiple handler entries in lsnrctl services output

This what I get for an lsnrctl services. LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-APR-2014 10:01:43 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to ...
1
vote
0answers
38 views

DTC Timeout when trying to update oracle table through link that contains a text index

Problem Given is a SQL Server connected to an ORACLE Instance as a Linked Server. It’s using the Oracle Client OLEDB Provider. When doing an update in a transaction on a table having a CTXSYS.CONTEXT ...
0
votes
0answers
27 views

Importing dump file contents to another DB with different schema using Oracle Data Pump

I asked this question in stackoverflow but no one was able to answer it so am trying my luck here if anyone knew what am talking about. Here is the link original question. What i wanted to do is to ...
2
votes
2answers
430 views

Why do shadow processes exist?

Oracle architecture has two types of process: server process or foreground process and background process, but: Some people use it to refer to foreground processes, others use it for background ...
0
votes
2answers
531 views

Oracle schema import is not importing all the tables present in the schema dump file

I have exported an existing oracle schema from another machine and then imported it in my local machine. Import was successful, but some tables which are present in the export dump file are not ...
0
votes
1answer
33 views

How to create an index used by a WHERE extractValue(…) LIKE '…'?

Setup Let's say you have a table with some XML data. For the sake of argument, say: CREATE TABLE t_xml (xml XMLTYPE NOT NULL); INSERT INTO t_xml VALUES ('<name>Alice</name>'); INSERT ...
0
votes
1answer
45 views

Oracle 10g: same query, different plans on copies of the same DB

I have a query joining a number of long tables (primary key in one table, indexed column in another) which results in different plans on different copies of the same database. The structure of copies ...
10
votes
7answers
72k views

How do I Create Tablespace in Oracle 11g?

I am not too savvy in Oracle, and I have been trying to create a TABLESPACE, which keep on giving me an error message of invalid file name. Below is the syntax that I have used: SQL> create ...
0
votes
0answers
21 views

how do we specify an oracle edition in a database link?

We are connecting using a DB link from one oracle database (a) to another (b), and b has oracle editions enabled. How do we specify an edition to be used when viewing the tables / views in database ...
0
votes
0answers
10 views

Materialized view refresh when the underlying view data has been changed

The desired materialized view should contain all the data from the system view: select * from v$object_usage Is it possible for such a materialized view to be refreshed every time the data in the ...
1
vote
2answers
331 views

Oracle's UTL_FILE when connected locally or through listener has different behaviour

We have a procedure which creates a CSV file with UTL_FILE. (env is Oracle 11.2.0.1 and RHEL 6.4) Until now, we were storing that CSV file into system oracle (the oracle owner) user home ...
0
votes
1answer
51 views

Oracle: Table or View does not exist in Tree

I have set up a Oracle 12c database for students. The goal is that each student has access only to his own scheme where he/she can create tables, views, indexes, etc. I set up the accounts using ...
2
votes
1answer
131 views

How oracle Oracle Database 10g used index?

I have table “result”, DDL : CREATE TABLE result (id_graduate NUMBER NOT NULL, id_sml NUMBER NOT NULL, last_update DATE NOT ...
0
votes
1answer
26 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 ...
1
vote
2answers
41 views

Oracle result cache behaviour

Oracle by default caching the query results and function results(Buffer cache). I have noticed this with AutoTrace utility, where the physical reads are huge on first execution, but from next ...
0
votes
0answers
23 views

Hints about Datatypes

I'm currently writing some style guides for a new project where we want to use Oracle for the first time in a extensive manor. I already wrote down some naming conventions for tables, columns, pk, ... ...
0
votes
1answer
49 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
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
36 views

How to organize a development environment using Oracle XE 11g?

I started developing small applications using Oracle XE 10g/11g using APEX. They are intented to be run on desktop computers that acts as a server in small offices. Oracle XE is well suited for those ...
0
votes
0answers
42 views

what should be in tnsnames.ora and sqlnet.ora for a local database?

here is my tnsnames.ora file # Every line that begins with # is a comment line # # Create Oracle net service names, or aliases, for each database server # you need to connect to. # # ...
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
2answers
126 views

Unclear oracle problem with getting response of query

The problem is very unclear, I have an application server, that constructs queries and sends it to Oracle to get response. The Oracle database is installed on a high perfomance server: Linux ...
4
votes
1answer
1k views

How do you find home information for Oracle RAC on Unix?

Need help finding Oracle home path corresponding to a database instance in RAC environment. I am aware of few of the ways to achieve the same. Listing them below to avoid the same answers. ...
2
votes
2answers
311 views

FileWatcher Troubleshooting Options

I have setup a Credential/Procedure/Program/File Watcher/Job to monitor a folder for new files, but it is not working. I am trying to figure out what I can check to troubleshoot why this isn't ...
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" ...
2
votes
1answer
313 views

ORA-16000 when trying to perform select on read only Oracle database

My application's SQL encounters an ORA-16000 error when trying to access a read only Oracle database. ORA-16000: database open for read-only access ORA-06512: at "SYS.XMLTYPE", line 272 ORA-06512: ...
0
votes
1answer
73 views

Database is slow once in a while

I am executing a web service for 100 times. The average response time of this service is 1.5 seconds. But when I look at the response time of each execution individually, there are a few executions ...
0
votes
1answer
170 views

Create database link on Oracle Database with 2 Databases on different machines.

I have 2 oracle databases (db1 and db2) on different machines, lets suppose: db1 on 192.168.1.1 and db2 on 192.168.1.2 What I want to achieve is to create a link on db1 that will allow me to perform ...
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
1answer
37 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
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
193 views

Connecting to Oracle Database with ODBC/Python

We've recently installed a new piece of software that uses an Oracle Database to store the data. My goal is to connect to that database and pull the data from the back end to do analysis on. I'm ...
0
votes
2answers
646 views

Oracle: adding subpartitions to existing partitioned table

In Oracle 11g, is there a way to introduce subpartitions into an existing partitioned table? I cannot seem to find a combination of EXCHANGE and SPLIT partition that does the right thing. SPLIT will ...
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 ...
0
votes
1answer
43 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
2answers
798 views

ORA-12154: TNS:could not resolve the connect identifier specified

I've initially posted this question on serverfault.com, but because lack of answers decided to post it here... I'm trying to use bat file/CLI to run SQL script against certain Oracle database with ...
0
votes
1answer
55 views

Slowness after migration to RAC 11gr2

we are getting slowness after migrate from ORacle 10gr2 single db to Oracle 11204 oracle rac (standard ed) with asm, on oracle solaris 11. at this momento we have only one node. In the next days we ...
0
votes
1answer
109 views

Oracle error: UDI-00018: Data Pump client is incompatible with database version 11.01.00.06.00

I'm trying to use data pump to move the database to a different server with this command: impdp dbuser/dbpsw@dbserver directory=data_pump_dir network_link=sourceDB schemas=EMP But I got this error: ...
1
vote
2answers
2k views

Trouble setting up Nagios to monitor Oracle services

I've got an install of Nagios XI that doesn't seem to want to talk to any of my Oracle services here. I've pulled out the monitoring command and am running it manually, after setting ORACLE_HOME and ...
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 ?
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... ...
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 ...
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
51 views

12c Shell to Linux

I am replacing two Oracle 11g servers with 12c TL/DR - when shelling out to a run an O.S. file, the PATH environmental variable is not being set. On the old servers we use an external library to ...
0
votes
2answers
155 views

oracle sqlplus as sysdba startup error

Oracle 11g, PC: 32G,8 thread cpu. now three oracle instances has been running. but. sqlplus "/as sysdba" prompt connect to an empty instance. when I do startup command, come an error: ...
0
votes
1answer
15 views

Connection with SQL*Plus to Oracle

I've installed Oracle Database Express 10g on Ubuntu, but the following error occures when I try to connect to sql plus using the sysdba as username and it's password which I gave during installation ...
1
vote
1answer
282 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 ...