Oracle Database 11g Release 2. Please also tag oracle for search purposes.

learn more… | top users | synonyms

1
vote
2answers
3k views

Strange behaviour of a query with order by and rownum on Oracle's Exadata server

I am executing the following query on two different database servers: SELECT start_date, end_date, resort_id FROM employee_activity WHERE employee_id = 27 AND start_date < ...
3
votes
1answer
52 views

loss of all redologs scenario

I'm having this question regarding a restore scenario in RMAN: A database is running in Archivelog mode. Full RMAN hot backups are taken, redologs are backed up with RMAN to tape. The application ...
0
votes
0answers
140 views

How to know imdp size?

I have a dump file using expdp with compression (oracle version >= 11g). Before running impdp I want to check if there is enough space on the machine but it seems as there is no parameter in the impdp ...
1
vote
4answers
95k views

How to determine if an Oracle table is locked or not?

We've been using BI software and a repository database that are installed on Oracle Enterprise 11gR2. Some of these batch reports will try to access a database table which may still be locked. How ...
2
votes
1answer
434 views

How can I list Oracle editions granted?

In using Oracle Edition Based redefinition, I am receiving the error: ORA-38802: edition does not exist when issuing the call: DBMS_SESSION.SET_EDITION_DEFERRED("my_edition") I know the edition ...
0
votes
1answer
25 views

About audits in Oracle 11g

I need to do the auditing in database, but different the normal process that administrator use, (active audit in first installation or alter ) I don't have time window for this. My scenario: tree ...
0
votes
2answers
440 views

11gR2 didn't ask me to set username or any password

I have installed Oracle 11gR2 (latest version 11.2.0.1.0) on my system. During the installation it didn't ask me to set username or any password. I'm unable to start sql plus because i don't have the ...
1
vote
0answers
135 views

Search a value from multiple column and multiple table [closed]

I have to search a value from multiple column and multiple table and each table is linked by foreign key and private key (in parent table , there is only one parent table and rest is child table of ...
2
votes
1answer
150 views

SQL query to identify missing hinted indexes

We have a fairly large number of queries using index hints in our 11.2.0.4 database. I recently uncovered some performance issues and found that some of the indexes referenced by the query hints were ...
0
votes
1answer
48 views

Oracle DB: Can one db file be shared between table space

Can one db file be shared between table space? I am deleting temp table space as below, Get all the files in table space: SELECT FILE_NAME FROM DBA_TEMP_FILES WHERE TABLESPACE_NAME = ...
0
votes
0answers
32 views

Conditional select needed

I have something like: SELECT ((SELECT SUM(VAL_TOTALA_FEROASE+VAL_TOTALA_NEFEROASE+VAL_TOTALA_ALTELE1+VAL_TOTALA_ALTELE2+ ...
1
vote
3answers
89 views

Finding “islands” of holiday periods for employees

I'm looking for some tips to find a nice solution for my problem: Let's say I have a table, where days of vacation of employees are stored. e.g. CREATE TABLE test_dates ( id NUMBER ...
2
votes
2answers
87 views

Select Count of one table into another

I have one SQL statement as: SELECT ARTICLES.NEWS_ARTCL_ID, ARTICLES.NEWS_ARTCL_TTL_DES, ARTICLES.NEWS_ARTCL_CNTNT_T, ARTICLES.NEWS_ARTCL_PUB_DT, ARTICLES.NEWS_ARTCL_AUTH_NM, ...
3
votes
3answers
132 views

Putting the database in backup mode before making file system changes

We are planning to make a small change in the Linux file system. To be on the safe side, I thought I would take a SAN-level snapshot of all the drives beforehand. I was thinking I should put the ...
0
votes
1answer
281 views

Oracle 11g - drop maxvalue partition, keep data

I have some tables with data like this: CREATE TABLE "PARTTEST4" ("year" number(4,0) NOT NULL ENABLE) PARTITION BY RANGE ("year") (PARTITION "P_OLD" VALUES LESS THAN (2010), PARTITION ...
1
vote
1answer
330 views

What's the fastest way to migrate an Oracle database from Unix to Linux?

We have an Oracle database installed on AIX 7.1, and now we want to migrate our database instance to RedHat 6.2. The RedHat server has Oracle 11.2 installed already. What's the fastest way to ...
0
votes
2answers
18k views

How to solve “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor” error?

I am trying to create connection with the database for debugging ASP.Net website. Database is 11g Oracle DB... There is no problem when I connect using SQL Developer, however using Visual Studio I get ...
1
vote
2answers
378 views

How does one identify if Oracle Data Guard is enabled in Oracle database?

How does one identify if the Oracle Data Guard feature is enabled in Oracle database? If this can be determined by a query, what is the query for finding the same?
2
votes
1answer
164 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
1answer
41 views

Oracle Enterprise Manager - stats split by user (schema)

Is there any way to split all the stats by user (schema) when looking at the Performance tab in the Oracle 11g Enterprise Manager? or effectively some other tool to retrieve that information - e.g. ...
2
votes
2answers
309 views

What will happen if I drop SYSAUX tablespace from Oracle 11G

As there are two mandatory tablespaces in Oracle SYSTEM and SYSAUX. They have mention on docs 1 " You cannot drop the SYSTEM tablespace. You can drop the SYSAUX tablespace only if you have the SYSDBA ...
0
votes
1answer
43 views

Mirror copies of redo logs

I'm running an two node RAC database with ASM having two DGs one for data and one for redo. I have only one copy of redo and I have the need to have another copy of redo logs. 1. How to go ahead with ...
0
votes
1answer
384 views

What is “CSS operation: data query” wait event in an Oracle StatsPack report?

Has anyone seen the CSS operation: data query Oracle wait event and know what it means? There was a bug 8299200 in 11.2.0.1 which is fixed in 11.2.0.3. STATSPACK report for Database DB Id ...
0
votes
0answers
21 views

Need to Sync Oracle DB table data with mysql [duplicate]

I have a table with some data in oracle which i want to sync with mysql table once in a day, like a cron job. Is there any tool available which i can use as a cron job in Linux?. Thanks,
2
votes
1answer
133 views

Foreign Key Constraint over two tables

I am trying to put the following entity-model into practice: We have a list of Payments, each Payment belongs to a certain store and is of a certain payment type (e.g. 10€ maintenance cost in ...
2
votes
1answer
516 views

Can I exchange partition between two table with partition with same name?

I am trying to restore one partition from a backup table. Both tables have partitions with the same name. My goal is to grab the data from the backup table partition x and put it in original table ...
1
vote
2answers
512 views

ORACLE_HOME / ORACLE_SID variable - why do we need to export them ?

I am not sure if this is a bash / shell question or oracle question. I am on linux and oracle 11g. I have always export my ORACLE_HOME and ORACLE_SID variable and e.g. using invoking sqlplus is no ...
-2
votes
1answer
453 views

LOAD DATA statement not working in Oracle SQL Developer

When I run the statement: LOAD DATA LOCAL INFILE 'C:/path/date.txt' INTO TABLE dimdate FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (date_id, yyyymmdd, fulldate, weekofyear, month, quarter, ...
0
votes
1answer
51 views

RMAN archivelog backup in Oracle 11gR2

I use below command to do RMAN backups on rhel 5.9, but archivelog backups always ends up in $ORACLE_HOME/dbs Backup as compressed backupset database plus archivelog format '/path' How to use ...
2
votes
2answers
640 views

Dropping Global Temporary Tables

In Oracle when you try to drop a Global Temporary Table that is in use you get the following exception: ORA-14452: attempt to create, alter or drop an index on temporary table already in use This ...
1
vote
0answers
51 views

Oracle migration to SQL Server

I am working in a Oracle 11g database migration to SQL Server 2012, I did the migration using SSMA v5.3 and all works fine. However, I did re-write code in some objects like triggers and stored ...
0
votes
1answer
330 views

Two Oracle clients on the same server

Is it okay to have two oracle clients (both 11g and 12c) in the same db server? What are the potential issues I could face? The reason im doing this is to connect the app server where I'm deploying ...
0
votes
0answers
33 views

Oracle DB - DR corruption

One of my databases in my DR is fully corrupted ( I have checked running validate database using RMAN). Now to recover all the data files which are corrupted I need to copy the data files from my ...
0
votes
0answers
61 views

Export backup from a different location

I have two servers. One database server and another is an app server. I have client installed in my app server and I have the respective the tns in my app server to connect to the db server. Now can I ...
0
votes
1answer
106 views

Why is the result cache always disabled in Oracle 11g

I'm trying to enable the result cache in Oracle 11g. I have used Enterprise Manager to change the result_cache_max_size and result_cache_max_result values to '1M' and '100' respectively (maybe these ...
0
votes
1answer
63 views

pfile - client parameter file - starting an instance remotely

I do not understand how we can start an Oracle instance remotely using a pfile. If we ssh into the Oracle server and issue: startup pfile='/path/to/pfile';` the pfile is on the server side. How ...
0
votes
2answers
75 views

LOB indexes corruption in Oracle

Why is it not possible to rebuild corrupt LOB indexes? So if my LOB index is corrupted, how to recover it?
3
votes
2answers
24k views

Using Oracle client to connect to remote database

Although I can do a telnet to remote oracle port I am unable to connect. I have a following tnsname.ora connecting to oracle database using sql plus: remoteOracle = (DESCRIPTION = (ADDRESS_LIST ...
0
votes
1answer
101 views

RMAN catalog database

I'm about to create a RMAN catalog database for my setup, what are the general precautions or major pre-requisites as in DB parameters, compatibility,etc that I should take care while creating the ...
2
votes
1answer
51 views

Tkprof in critical environments [closed]

Why tkprof utility is not adviced to be used in production setups? What concerns does it have?
1
vote
0answers
41 views

Oracle in hyper-convergence system

How does Oracle perform in hyperconvergence systems such as nutanix, simplivity? Oracle doesn't certify the underlying storage which nutanix or simplivity offers (file level storage) but in reality ...
0
votes
2answers
367 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
123 views

How do I prevent an ORA-08102 error

I am getting an ORA error (08102 - Index Key Not Found) with several customers, and I have been unable to reproduce or explain it. They have all been on the same index on the same table. This error ...
1
vote
0answers
23 views

Oracle DataGuard [closed]

Maximum performance and Maximum Availability modes has only difference right? Former is async mode and the latter is sync mode wherein it waits for acknowledgement for up to a time and after that it ...
0
votes
3answers
128 views

Is using ASM a pre-requisite for RAC?

I am about to build our first RAC development environment, and as I'm new to RAC and have not used ASM I wanted to keep things as simple as possible. I was under the impression that ASM is a ...
1
vote
0answers
76 views

Does oracle workspace manager work with oracle xe 11g

According to this forum it can be using a patch but I need a support identifier to access patches. https://community.oracle.com/thread/340084?start=0&tstart=0 This describes how to install ...
0
votes
0answers
60 views

Cann't connect from another server to Oracle

I can connect locally like normal : sqlplus sys as sysdba I can also connect sqlplus sys/pass@hostname:1521/servicename as sysdba the service I get from when I do lsrnctl status but when I try ...
0
votes
1answer
3k views

User with dba privs can't login to APEX, but can from SQL*Plus

I'm using Oracle 11gR2 XE. A user with dba privileges can't log in to the APEX interface, but can from the command line with sqlplus. I just created user: CREATE ROLE administrators; GRANT dba TO ...
1
vote
1answer
71 views

Service privileges for Patch Download? (Oracle 11gR2)

I first asked this question on stackoverflow, but someone pointed out that this might be the appropriate site. Hope I am doing this right. To perform tests in advance of an upgrade from Oracle 11gR2 ...