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

learn more… | top users | synonyms

0
votes
0answers
13 views

Need to retain 30 days of database dump(.dmp ) files on disk before deleting the oldest one [on hold]

Need the best way to retain 30 days of database dump(.dmp ) files on disk before deleting the oldest one. Scope: Each day we will do an export to dir1. so one .dmp file will live in this dir1 ...
1
vote
1answer
20 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
14 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 ...
1
vote
0answers
27 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
27 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
25 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 ...
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
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
9 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
2answers
42 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 ...
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 ...
-3
votes
1answer
16 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;)' ...
0
votes
0answers
44 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
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
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
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 ...
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 ...
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 ...
-1
votes
1answer
46 views

Golden Gate Privilege Missing for using Encryption

dblogin userid ogg_user, password AADAAAAAAAAAAAIAKAQIJAGAMFUFKFBGQHXBJIWGECTEIAZHJFYALFFIBGHGJBPFBCPBKEPCRCRHAESJ, AES128, encryptkey securekey1 ERROR: Unable to connect to database using user ...
1
vote
1answer
62 views

How do I get multiple rows output in one line?

The data is like Jane has items pen pencil eraser. If I write the statement 'select * from item' the output is: Jane pen Jane pencil Jane eraser Jack box Jack wiper I want the output to be like: ...
2
votes
1answer
21 views

How to debug an hanging impdp importation

I am currently trying to import a database dump in Oracle XE 11gR2 On windows 7. I have the following command. impdp 'APPLICATION/APPLICATION@XE' dumpfile=APPLICATION.dmp REMAP_TABLESPACE=...
0
votes
0answers
46 views

Oracle 11g Auditing and Collecting the SQL Text with AUDIT_TRAIL=OS

I'm certainly no Oracle DBA, so please forgive any ignorance on my part. I've done a fair bit of research, but I'm a bit stuck with something at the moment. Hopefully someone can help. I'm currently ...
1
vote
1answer
68 views

How can I fix these broken synonyms?

When I run the following query: SELECT S.OWNER AS SYN_OWNER, S.SYNONYM_NAME AS SYN_NAME, S.TABLE_OWNER AS OBJ_OWNER, S.TABLE_NAME AS OBJ_NAME, CASE WHEN O.OWNER IS NULL THEN '...
3
votes
1answer
75 views

Drop 15 days records in monthly partition

I have created a monthly partition on my table like below: PARTITION BY RANGE (PARTITION_KEY) INTERVAL(NUMTOYMINTERVAL(1, 'MONTH')) ( PARTITION MayPartition VALUES LESS THAN (TO_DATE('...
1
vote
1answer
29 views

Statement specific auditing - Oracle

I have enabled default auditing in one of my database. Oracle 11g. Audit_trail is set to DB, other than that for a particular schema 'test' I have set: audit all on test by access With the above ...
0
votes
0answers
9 views

How do I assign the result from ST_GeomFromText() to a variable and consume the variable?

This SQL works as is: select field1, field2 from schema1.featureClass1 t1 where sde.st_intersects(t1.shape, sde.ST_GeomFromText('point(99.0 22.0)', 1111)) = 1; Now I need to perform some ...
1
vote
1answer
25 views

Ranking based off conditional field

I am looking to select only 1 row based off the IMMS_ID field. Which row I select is based off this if statement (excuse the syntax) if (status group based off IMMS_ID) status='DI' select the DI row ...
0
votes
0answers
41 views

jdbc Datasource error BEA-001131 Closed Connection

I have Installed weblogic 10.3.5. On database side I have RAC environment with Two instance. I have created GRIDLINK DataSource with XA DRIVERS. NAME: test JNDI: jdbc/testDS NOTE: I ...
0
votes
1answer
20 views

Oracle Database Remote Connection

I've been searching online for a solution to my problem without any luck. I'm trying to connect to a remote server (~ 700 km of distance), but since I'm new in this Database administration world I'm ...
0
votes
1answer
94 views

ORA-02049 Timeout: Distributed Transaction Waiting for Lock Solution needed

We are cleaning up the last year's transactions from our primary database. We use public database link to delete the records a day by day from another database. Each days records are around 30-40k, ...
2
votes
1answer
33 views

SQLPLUS Default Column Widths

For almost all my databases, when I run a SELECT statement, the length of the column displayed is sized to the width of the data being queried. However, I have two databases (Dev and Prod for the ...
0
votes
0answers
36 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 ...
0
votes
2answers
22 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?
0
votes
1answer
179 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
57 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 ...
0
votes
1answer
29 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
23 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 ...
2
votes
1answer
63 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 ...
0
votes
2answers
84 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 COUNT(*...
1
vote
1answer
48 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 ...
1
vote
0answers
63 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
0answers
25 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 ...
2
votes
1answer
100 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, route....
0
votes
1answer
97 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 ...
1
vote
1answer
181 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 ...
0
votes
1answer
59 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 ...
1
vote
1answer
60 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
0answers
97 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 ...