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

learn more… | top users | synonyms

1
vote
3answers
105 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 ...
0
votes
2answers
786 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 - ...
0
votes
1answer
49 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
2answers
135 views

PowerShell script to access Oracle system views [closed]

I am using PowerShell script to access oracle 11g's system views as SELECT COUNT (*) AS COUNT FROM v$session but I keep getting "ORA-00942: table or view does not exist" I have created a user with ...
2
votes
2answers
615 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
652 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 ...
1
vote
1answer
42 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. ...
1
vote
2answers
702 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?
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
158 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
841 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
984 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 ...
0
votes
1answer
62 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 ...
1
vote
2answers
1k 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
56 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 ...
3
votes
1answer
358 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
34 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
1answer
1k 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
93 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
193 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
33 views

Reading audit records in Oracle

As a DBA, what is the best way to read the audit records on daily basis? Say, i'm the administrator and I would like to view the audit records made by the DBAs. I have enabled audit sys operatiosn to ...
0
votes
1answer
78 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
110 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?
0
votes
1answer
499 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 ...
2
votes
1answer
53 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
76 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
1answer
179 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
243 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
27 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
0answers
115 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 ...
1
vote
0answers
115 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 ...
1
vote
1answer
402 views

How to create DBA user from oracle APEX 11gR2 XE

Please anyone tell me how to create DBA user from ORACLE Application express(http://127.0.0.1:8080/apex/apex_admin)? I installed Oracle 11gR2 XE on windows 8.1 PC and I am able to login to Oracle ...
1
vote
1answer
93 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 ...
0
votes
0answers
11 views

Oracle OEM provisioning and patching

What is meant by Oracle provisioning and patching?, how can we do RAC cluster upgrades and patching using this in OEM ?
1
vote
1answer
40 views

how to avoid duplicate record with certain conditon

Heading ##I have a table with data like below +----+--------+-----------+----------------+ | id | name | testfield | status | +----+--------+-----------+----------------+ | 1 | raju | ...
2
votes
1answer
519 views

How to download Oracle Database 11g release 2 for Mac OS

I have been trying to download Oracle Database 11g release 2 for mac os but in the given link by oracle I can only see Linux x86 and Linux x86-64. Is this ok to use this Linux file for installing ...
1
vote
1answer
240 views

Oracle 11g Sync Standby Database

Currently, I synchronize the standby database from primary database by copying archive logs from primary server to the secondary server. I do this activity daily. I have heard that there are automated ...
0
votes
0answers
66 views

CALL Procedure(Function) = Trigger?

I have discovered some strange behavior in Oracle 11g, and I'm wondering if anyone has an explanation for it. The gist is that when I use a function that contains a commit/rollback/savepoint within a ...
1
vote
1answer
3k views

Oracle 11.2.0.3 to 11.2.0.4

I'm planning to upgrade 3 instances of Oracle (all same Oracle Home) from 11.2.0.3 to 11.2.0.4. I'm going through the installer and I get to the question about Upgrade or install just the database ...
0
votes
2answers
285 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
0answers
72 views

Whitespace Trimming on Before Trigger in PL/SQL [closed]

I'm looking to create a simple trigger that trims the whitespace on a piece of data prior to it writing to the table. I'm using PL/SQL with Oracle 11g. I am receiving the following error: ...
0
votes
1answer
128 views

Is possible do an online snapshot backup , without archive logs at Oracle Database?

Using Oracle Database Standard Edition 11r2 . I'm looking a way to backup the database with zero downtime , using a snapshot of datafiles (LVM snapshots) and without need backup de archive logs. ...
2
votes
2answers
279 views

sqlplus (Oracle XE) doesn't start on CentOS 7

I followed the steps of this document: https://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#XEINL121, but sqlplus doesn't start. Even if I used the command: "sqlplus /nolog". The other ...
0
votes
0answers
171 views

ORA-00933: SQL command not properly ended from function

I created a function but I keep getting the errors ORA-00933: SQL command not properly ended ORA-06512: at "FCUBSPROD.FN_GSS_UNPROCESSED_TXNS", line 110 ORA-06512: at line 11 when I try to run it. ...
0
votes
0answers
110 views

Oracle 11g installation on fedora 20 - stuck at step6 - Oracle-base.com installation procedure

I am trying to install Oracle Database 11g Release 2 (11.2.0.1) On Fedora 20 (F20)Oracle 11g in my laptop and I am following the steps provided in this Link But it is getting stuck after step 6. Can ...
1
vote
0answers
121 views

How to free temporary lob used in result set of SQL SELECT in Oracle

A goal is to aggregate rows into very large strings. I cannot use LISTAGG(XMLAGG,etc.) that support only up to 4000 bytes. I looked into using PIVOT XML option but we have a strict requirement on ...
4
votes
2answers
652 views

Cummulative Sum with Reset Value

Consider the following table: ID | GROUP_ID | ORDER_VAL | RESET_VAL | VAL ---+----------+-----------+-----------+----- 1 | 1 | 1 | (null) | 3 2 | 1 | 2 | (null) ...
2
votes
3answers
116 views

Calculating overlap between groups

I have a table with two columns of interest, item_id and bucket_id. There are a fixed number of values for bucket_id and I'm okay with listing them out if I need to. Each item_id can appear multiple ...
0
votes
1answer
29 views

Instant File Initialisation on Windows Oracle Server

I require to add additional datafiles to a SmallFile tablespace. The process took several minutes on my system for 1 datafile. Is it possible to allow Oracle the same capability as SQL Server using ...
1
vote
1answer
1k views

Oracle cannot connect to SQL developer as sys account

I am trying to connect to SQL developer as sys account. It is always giving the error invalid username/password. When I try to connect it through SQLPLUS, it gets connect with any wrong password ...