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

learn more… | top users | synonyms

0
votes
1answer
126 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 ...
3
votes
1answer
343 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 ...
0
votes
0answers
17 views

Changing database parameters after removing a node from RAC oracle

Oracle 11.2.0.3 on SunOS 5.1 i have a client who is running a 2 node RAC environment but has shutdown the instance on one of the nodes. I was wondering whether after doing this they should change the ...
1
vote
1answer
100 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 ...
1
vote
1answer
200 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 ...
0
votes
3answers
274 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 ...
2
votes
2answers
1k 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
145 views

Backup an Oracle database to NAS

I have an Oracle database (11.2.0.4) on Oracle Linux 6.7. I want to backup this database with rman to a folder on a NAS (network attach storage). How can I do this?
0
votes
2answers
5k views

How to return a result set from oracle procedure ?

How can i return a result set from a stored procedure in oracle ? suppose i want to return a table from a simple select statement such as this : Select * from tblTest I tried this but this seems ...
0
votes
2answers
15 views

Oracle Exadata datafile distribution

I'm new to Oracle and are curies of how Oracle Exadata handles database files. Do you have to assign disk to a database file as you do with Microsoft or is this handled by Exadata?
1
vote
2answers
447 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 ...
0
votes
1answer
40 views

ORA-01122: database file 5 failed verification check

Oracle version: 11g r2 OS: win server 2008 SQL> alter database open; alter database open * ERROR at line 1: ORA-01122: database file 5 failed verification check ORA-01110: ...
0
votes
1answer
33 views

Purging audit records - Oracle

At the end of each financial year, audit team asks for audit records for samples dates in a year as per their methodology and ideally we are supposed to provide them. (Say, give them list of schemas ...
1
vote
1answer
353 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
24 views

Record of schema related changes - Oracle

Is it possible to get the all changes that is made to schema as in what privileges was first assigned to the schema on creation, creation date, if later modified with different privilege what was that ...
0
votes
1answer
18 views

Redo/Noredo in Oracle

I have an Oracle 11.2.0.3 about 700GB in size running in noarchivelog mode in a pretty slow storage setup. It barely gives IOPS and there is resource crunch in terms of hardware resources. The ...
0
votes
3answers
243 views

Replacing the results of a row

I'm working with Microsoft Reporting Services 2008. In our database, we have a small group of confidential students that need to be taken into account for several queries. If they are a confidential ...
1
vote
2answers
964 views

Specify NLS-Settings during Oracle installation under Windows

Is there an easy way to specify NLS parameters for the database during the installation? We want to install a new database (environment: Windows). For testing purpose we need NLS settings for ...
0
votes
1answer
160 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 ...
0
votes
1answer
423 views

Oracle DB Point In Time Recovery faulted

I'm testing a procedure via RMAN backup to retore/recover at recover-point, but it fails. Exactly I've executed the first time and it works: Backup: RMAN> backup database INCLUDE CURRENT ...
0
votes
1answer
5k 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>> ...
2
votes
1answer
34 views

Oracle Patch Level Differences (Oracle Enterprise Manager and DBA_REGISTRY_HISTORY)

There is a difference in the patch level that I am seeing on my Oracle database. On the Oracle Enterprise Manager, it shows that it is patched up to .7 but on DBA_REGISTRY_HISTORY it does not show any ...
3
votes
2answers
1k 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
2answers
698 views

RMAN 11g/12c Client compatibility

I'm having a Recovery catalog database 12c version. While I'm trying to register the target database (11g) with the catalog I get the following error: Recovery Manager: Release 12.1.0.2.0 - ...
1
vote
1answer
379 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
2answers
50 views

Does Oracle 11g support CREATE ASSERTION? [closed]

When I tried to write the following statement: CREATE ASSERTION ir_collaboration CHECK(NOT EXISTS( SELECT ngo, id_employee, COUNT(*) FROM collaboration GROUP BY ngo, id_employee HAVING ...
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
32 views

Dataguard parameter changed after DB bounce

I have a production environment of Oracle 11g R2 patchset 4 primary database configured with 2 standby machines. Primary database unique_name is DBIDI 1st standby database unique_name is DBIFI 2nd ...
3
votes
1answer
808 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
709 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 ...
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
0answers
54 views

Will I have to restore controlfile in RMAN level 1 backupset before recover database?

For example, I have a level 0 and level 1 RMAN backupset files like inr00_0413_* inr01_0413_1_* Is it necessary to do this when recover from RMAN level 1 backup: restore controlfile from ...
0
votes
1answer
223 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
2answers
65 views

How to convert decimal number to IP address?

I need a function or query to convert a decimal number to ann IP address. Presently my ip_address column looks like this: select ip_address from test_ip; ip_address 173015430 ...
0
votes
0answers
24 views

how to become oracle dba as i am not from it background [duplicate]

hope u r fine & well.i am graduate from 2003 & dont have any IT background ,want to become oracle dba please guide how to start & proceed further. thanks in advance. your advice will be ...
1
vote
1answer
59 views

Oracle Min - ORA-00937 not a single-group group function

I try to find companies whose fare has minimum fare of destination which more than one companies use that destination. My command; SQL> select tickets.bus_id bus, tickets.fare fare, ...
0
votes
1answer
828 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
2answers
9k views

Create Oracle DB LINK to a database with no DB_DOMAIN

I'm trying to create a database link between this two DBs. My local DB is 11.2.0.3. SQL> select * from global_name; GLOBAL_NAME ...
1
vote
2answers
388 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
241 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; / ...
0
votes
1answer
129 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 ...
0
votes
2answers
260 views

How do I determine the appropriate size for my tablespace when importing a .dmp file?

I have a 14g DMP file. How large should I size my tablespace to import it into an Oracle 11g database?
1
vote
1answer
86 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 ...
1
vote
1answer
33 views

Is there a way to find the partition or subpartition name where my ID belongs

I know if I need to select from any partition I need to provide partition name SELECT * FROM TABLE PARTITION(P1); What if I need to know which partition a particular value belongs using a sql query ...
0
votes
1answer
28 views

Updating data from subpartition when the subpartition name is unknown

Thanks to JSapkota who helped me pull the subpartition name as per below query select subobject_name from user_objects where data_object_id IN (select dbms_rowid.rowid_object(rowid) from TABLE ...
0
votes
0answers
37 views

How could I improve speed of fetch in Oracle?

I've got a table of taxi GPS trajectory records with approx 60 million rows, including date, time, ID, longitude, latitude, speed, bearing etc., which were imported from .csv files with setting each ...
0
votes
2answers
26 views

Comparing values from two tables in a nested where clause.

This is a rather specific question. I'm working to create row restrictions in Business Objects and the customer wants records to fall within a certain range from another table. The problem is, you can ...
0
votes
1answer
1k 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
0
votes
1answer
17 views

Error “In a grant or revoke statement, the user attempted to grant a tablespace quota above the upper limit.” when trying to increase user quota

I'm attempting to increase the space quota on a particular schema. I'm using the following query to do so: ALTER USER MY_SCHEMA QUOTA "100 M" ON "USERS"; This results in the following error: SQL ...
0
votes
1answer
135 views

SGA size not decreasing after reducing memory_target (Oracle 11.2.0.1)

I have an Oracle 11.2.0.1 database using dynamic memory allocation with parameter MEMORY_TARGET. When I decrease it with SCOPE=BOTH, the size of the SGA doesn't seem to decrease along with it. I have ...