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

learn more… | top users | synonyms

1
vote
1answer
14 views

Map ASM files to physical Linux Devices

We are having problems with log file sync waits periodically. We have a 2 node RAC cluster using ASM. I'd like to monitor the physical device(s) containing the REDO log files using iostat, but I'm ...
0
votes
0answers
9 views

Is there a way to compare very short periods of activity in Oracle?

I am having a problem with an application that requires very low latency (less than 100 ms per txn.) Every once in a while we will see spikes where transactions take 20-30 SECONDS. We looked at the ...
0
votes
1answer
58 views

Is DBCA in Oracle for a single database or the entire system?

I ask this because I was going to create a simple phone list database for learning. But when I used dbca, I was asked did I want to install the sample databases, HR, etc. It also had the default ...
22
votes
9answers
21k views

How do you version your Oracle database changes?

I am interested to know what methods other people are using to keep track of changes made to the database including table definition changes, new objects, packages changes, etc. Do you use flat files ...
1
vote
1answer
743 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 ...
4
votes
1answer
411 views

sql error on script execution. try deleting repository before creating repository

I want to migrate my mysql databse to oracle. I have followed the migration demo from this url http://www.oracle.com/technetwork/database/migration/connect-step-mysql-1946352.html but I got this ...
1
vote
1answer
6k views

listener can not start

My listener in Oracle 11g R2 can not start . When I want to give the status of that, the error in below is shown: Connecting to <ADDRESS=<PROTOCOL=tcp><HODT=><PORT=1521>> TNS-...
1
vote
0answers
22 views

What might be the cause of regular periodic slow transactions on an OLTP system?

I have a two node Oracle RAC cluster with that runs an oltp application against it. I have both a production and a duplicate test environment with the same setup. Upon running stress tests on the ...
0
votes
0answers
26 views

Dropping database in RAC

I need a drop a database which is a 2 node RAC configuration and I will also be drooping the disk groups as well completely. What is the right way to drop the database + diskgroups? Will it be ok to ...
-1
votes
1answer
24 views

Select catalog role - Oracle

Does select_catalog_role if granted to a schema provide access only to dba tables and v$ views only and not to other schemas created for any application? The reason i'm asking this is I need to grant ...
1
vote
1answer
586 views

The service name is invalid while starting EM on oracle 11g on windows

I am trying to start EM on oracle 11g on Windows. When I performed emctl start dbconsole It shows The service name is invalid more help is available on net helpmsg 2185 and when I wrote net ...
0
votes
0answers
26 views

Oracle SQL subquery Optimization

Hi I have table called TABLE1 that is Indexed by date DT, and Item ITEM respectively. I need to write a query that will retrieve for me a list of items, for month end for given amount of months. So ...
0
votes
1answer
1k views

Import big CSV on Oracle

I have big CSV files and placed it on Linux (Amazon AMI). I have installed instant client on Amazon Linux AMI and I can connect to my Oracle database using SQL Plus. How can I import all the CSVs to ...
1
vote
1answer
374 views

How do I import data into oracle 11g r2 using a `.dmp` file and a `.par` file?

How do I import data into a new installation of oracle 11g r2 using a .dmp file and a .par file? Here is what I have done so far, on a Windows 8.1 devbox: 1.) Open command line as administrator 2.)...
0
votes
1answer
22 views

RMAN Control File Information

I have daily full backups going on for my Oracle 12c databases on linux. Daily retention on disk is 6 days. This is what happens: Full backup happens at location /orcl_bkup/backup_full After ...
0
votes
1answer
369 views

impdp schema name not found

I have Oracle Database 11.2.0.4 . I want to import a dump file to it with impdp . The Dump file is for a "Popualtion" schema . the schemas name is case sensitive. How can i import this file to ...
0
votes
1answer
115 views

Could we delete old database and grid version?

We upgraded rac system and I want to ask, could I delete old grid and database version? [oracle@orcl1 app]$ cd 11.2.0.3/ 12.1.0.2/ Middleware/ oraInventory/ 11.2.0.4/ grid/ ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
8 views

Insert into table which contains nested-table inside (Object in Oracle)

I have script of creating here: create type Ingredients_type as object ( Ingredient_ID varchar2(20), Ingredient_Name varchar2(50), ICalori int, IPretein int); create type Food_type as object ( ...
0
votes
3answers
482 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
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 ...
3
votes
5answers
4k views

Oracle 11g installation stuck at installation

I'm trying to install oracle 11g on fedora by following this tutorial but it stuck after I click Next in step 8. The screen does not go away even after several hours. There's no log file in ...
0
votes
1answer
602 views

How to call an oracle stored procedure in sql developer tool

I have written an Oracle procedure like below: create or replace procedure Sp_emp(cv_results out sys_refcursor) is begin open cv_results for select * from employee; end; / ...
1
vote
1answer
427 views

how to prevent an oracle block corruption from duplicating a database with a few nologging tables

I got a few data corruptions in a test db when I performed a duplicate from a production db where a few tables have the nologging option. Oracle support suggested to turn on the force logging option ...
0
votes
1answer
2k views

ORA-01031: insufficient privileges

why do i get ORA-01031: insufficient privileges ? SQL> grant create view to rojib; Error : grant create view to rojib * ERROR at line 1: ORA-01031: insufficient privileges
1
vote
1answer
133 views

Listener protocol error - Oracle

Okay first things first, this is probably a common issue which gets resolved going through all those questions and googling it but still I face this issue: LSNRCTL> service Connecting to (ADDRESS=(...
2
votes
2answers
2k 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 ...
0
votes
1answer
32 views

Oracle - Scan listener and multiple databases

I have a two node RAC database server hosting 8 databases. I have 3 scan listeners running. 2 in node 1 and one in the 2nd node. All the 8 databases are running for different applications. Are these ...
0
votes
2answers
142 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?
1
vote
1answer
178 views

Gap resolution of Logical Standby Database via Archive Log Backups

Due to reasons outside the scope of this question, we had to flashback our Logical Standby Database (at the VM level) to the previous day. So, now i'm trying to resolve gaps in missing archivelogs ...
-3
votes
1answer
15 views

[oracle@linuxuser ~]$ dbca -bash: dbca: command not found

i'm installing 11G on Enterprise version linux. after executing ./runInstaller and setting bashprofile when i'm firing dbca on tightVNC am facing this problem of not finding command dbca. please help ...
-1
votes
2answers
40 views

Copy tables of a schema to a new schema using where 1=2

I am trying to spool the below SQL to copy schema objects to another, but its not working. select 'CREATE TABLE INTDTA.' ||table_name|| '(AS SELECT * FROM all_tables where owner ='ZRTDTA' and 1=2;)' ...
1
vote
2answers
152 views

Automate - recover database using backup controfile

I am trying to automate a periodic clone of a database from one environment into another changing the database name. I have done this many times manually by doing a begin/end backup on the source ...
0
votes
1answer
94 views

ORA-00905: missing keyword

I am trying to run the below Pl/SQL statements on my Oracle DB 11g on Linux box, but getting the error "missing keyword". Please let me know if I miss anything. BEGIN FOR X in (select * from ...
0
votes
1answer
158 views

List all privileges granted on tablespace

I'm moving all objects of a tablespace-A to new tablespace-B. Is there a way to list all privileges/quota granted for tablespace-A? Since tablespace-A can have default user or not and also other ...
0
votes
0answers
42 views

ASM Query on Diskgroups

Platform - RHEL. Database - 11.2.0.3. I have a diskgroup name TEST with AU as 1. I need to have the diskgroup with AU as 4 therefore I decided to drop the existing DG and recreate the new one with ...
0
votes
0answers
10 views

Oracle 11g manually delete database

Using Windows Server 2012 here: I have a problem with two database instances that the Database Configuration Assistant tool didn't cleanly create. Specifically, it error'ed out trying to parse an ...
0
votes
0answers
10 views

Unable to login to my Oracle database

I am trying to log into my oracle database but keep receiving several error messages both from sqlplus commandline and enterprise manager of which one of them is "ORACLE NOT AVAILABLE".... And when i ...
0
votes
2answers
483 views

Optimize large table design

First, I am a complete novice when it comes to databases, but have been given the task to speed up queries on a large set of data. (Hundreds of millions of records) The current implementation is a ...
1
vote
1answer
22 views

Migration query - Oracle

I have two physical servers, hosting 6 two node RAC databases running in 11.2.0.3 version (both grid and database). I'm told to have the grid software in 11.2.0.4 version and the databases in the ...
0
votes
0answers
33 views

Row Directory in Oracle Block, How does it work?

Sorry for I am just a newbie in the Oracle. I read Oracle Concepts book. And The part I can't understand about the Row Directory in the Oracle Block Overhead is This portion of the data block ...
2
votes
1answer
687 views

Altering the location of Oracle-Suggested Backup

On one database, the Oracle-Suggested Backup scheduled from Enterprise Manager always ends up in the recovery area, despite RMAN configuration showing that device type disk format points elsewhere. ...
0
votes
1answer
42 views

ASM Query - Oracle 11gR2

I have two node RAC servers hosting 4 databases running on 11.2.0.3 version in RHEL OS. The underlying LUNs assigned to the ASM is not currently multipathed, meaning the disk sequence would change ...
0
votes
1answer
3k views

Oracle Duplicate Database with no archived logs

I am trying to perform a duplicate operation from one server to another (testing disaster recovery) on oracle 11g. I am very much still learning about Oracle. The system is not in production, it is ...
1
vote
1answer
5k views

Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant

This is my first time installing Oracle 11g R2 on Linux. I followed all the instructions in the Oracle documentation, but in the installation process, the Net Configuration Manager is failed. I ...