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

learn more… | top users | synonyms

0
votes
2answers
51 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 ...
2
votes
2answers
2k 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
107 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
4k 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>> ...
1
vote
0answers
481 views

Oracle IMPDP job ORA-30036 unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

I'm using IMPDP with the "network_link" for perform export/import in a single-pass. It runs fine until I get this error. ORA-39171: Job is experiencing a resumable wait. ORA-30036: unable to ...
0
votes
0answers
35 views

oracle update statement is too slow

I have oracle database 11.2.0.4 on oracle linux 6.4 I have configure huge page on this OS . After 5 months of my projects , when i want to update any tables their have over 20,000,000 records , this ...
1
vote
1answer
55 views

understanding ORA-01792 maximum number of columns in a table or view is 1000

We've recently migrated a server from Oracle 11 to Oracle 12c and ran into a few annoying issues. One of them is that a few a reports give the following error: ORA-01792: maximum number of columns ...
0
votes
1answer
44 views

Regarding Analyze table then performance improve

I used function which contain 3 table like a,b,c and table a contain index like ind1 on two column. Now I call store procedure which contain code and also get data from above function. And I also ...
1
vote
1answer
219 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
1answer
27 views

Error ORA-12505 when trying to access a newly installed instance of oracle-11g express

I encounter problems installing a local instance of oracle express on my Windows 7 - SP1 computer. I did a basic installation, as administrator (run as 'administrator' on setup.exe). Then I tried to ...
2
votes
2answers
892 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 ...
3
votes
2answers
925 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
1answer
2k 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
2answers
429 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
24 views

ora-13506 An attempt was made to perform operation with an invalid Start/End Snapshot Pair During AWR Creattion

When I'm create AWR Report then following error occurred plz help. Cause: An attempt was made to perform operation with an invalid Start/End Snapshot Pair.
0
votes
0answers
34 views

Find Bottleneck of Store procedure in Oracle 11g

I written a store procedure which retrieve data from 6 to 7 table using join and used sys-refcursor. Now problem is data fatch approximate 700 to 750 rows at 18 seconds but in some case take more ...
0
votes
1answer
518 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
0answers
17 views

Is it possible to resize a blob image?

I've got a table with an image blob field in it, which stores jpg files. As those jpg files are shown in a web page, I would like to resize them in order to spend less bandwidth when my web page call ...
1
vote
1answer
66 views

What is the purpose of %ORACLE_HOME%/dbs directory in Windows Environment?

I see some files in there like an init.ora and opctrn11.h, but what is the purpose of this directory, if we use %ORACLE_HOME%/database to store the p/spfile instead?
1
vote
2answers
8k 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 ...
3
votes
1answer
752 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 ...
2
votes
3answers
407 views

Archive Logs filling up Flash Recovery Area (FRA) space

I got hired to fill a position of DBA that I wasn't quite ready to fill, and while the training is getting me there, I am running close to a potential issue. My oracle 11g database's Flash Recovery ...
1
vote
1answer
558 views

SQLDeveloper.exe itself is getting access denied

Installed Oracle 11g and the 11g client. Everytime I start SQLDeveloper it prompts for the java.exe and again which files to associate. It must be trying to save this in registry (or maybe disk). ...
1
vote
2answers
54 views

Serialize :new in trigger

I have a trigger that needs to create an Oracle Advanced queue message. The payload of that message should contain the new record that was created, that is accessible via :new. What I am looking for ...
1
vote
1answer
240 views

impdp syntax for schema that is not available on other database

My intention is to import the data of schema 'SCOTT'. I have exported it from db1 using expdp scott/tiger schemas=scott dumpfile=scottexp.dmp ...... Now When I try to import the same in database db2 ...
4
votes
2answers
698 views

Check if an index exists by comparing columns

We are currently using ALL_IND_COLUMNS to check if an index exists by its name or the columns it is using. The problem is that we can only check if the index exists with columns in a specific order. ...
1
vote
2answers
324 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
2answers
62 views

Database not able to startup showing an error in reading control file

On Windows Server 2008 R2, when I am trying to startup Oracle 11g database it shows an error: SQL> startup ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size ...
3
votes
1answer
261 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
2answers
163 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?
0
votes
0answers
15 views

Oem 11g download link

Is the only way to get the following softwares from OTN by making service request? If suppose I dont have an OTN Account then how can I get it? Download Oracle Enterprise Manager Grid Control 11g ...
5
votes
1answer
8k views

Cannot change service name for Oracle

I'm trying to change the service name of an Oracle 11.2.0.3 installation on a Windows 2003 server. During installation the service name was defined with the default domain, but we'd like to get rid ...
1
vote
0answers
39 views

Oracle Database Change Notifications only sent every 15 minutes, not immediately

I'm registering a listener for Oracle Database Change Notifications through JDBC (using the EclipseLink implementation of JPA, Oracle 11.2.0.3, Oracle JDBC thin driver 11.2.0.4). I'm getting ...
2
votes
2answers
40 views

In Oracle what is the difference between STDEV and STDEV_SAMP functions?

We have a query that should return NULL when doing standard deviations in groups that have only 1 row. The normal STDDEV function returns zero. However I found another function called STDDEV_SAMP ...
0
votes
3answers
120 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 ...
1
vote
1answer
668 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 ...
1
vote
1answer
60 views

Oracle automatically unmount

I have a weird issue in my Oracle database, after 10 - 15 minutes of not using it (Not performing any query, insert on SQL Developer tool) then it will say ORA-27101: shared memory realm does not ...
0
votes
1answer
766 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
3
votes
6answers
3k views

Why can't I drop this Oracle datafile - even though it seems empty?

This system is Oracle 11.2.0.3.0, using ASM. We had an issue where there seemed to be a corruption issue of some kind - every time a row tried to get inserted into the table, we'd get the following: ...
1
vote
2answers
682 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
0answers
16 views

CDC Service for Oracle by Attunity Stops with Status Code ABORTED

We use Oracle 11gR2 as our OLTP layer behind our ERP product and we want to capture changes on SQL server for DWH use. In a new VM i make a clean install of SQL Server 2014 with SP1 (DB Engine and ...
0
votes
0answers
28 views

ROUND function behaviour with dates

My question is about rounding the week. My understanding is when rounding y week oracle will round to same day of the week as the first day of the month. Does this mean if the first day of the month ...
1
vote
0answers
26 views

Diagnosing Oracle query problems by a non-DBA [closed]

I have a query (insert) run on Oracle 11gR2 (inside a stored procedure). It goes something like this: execute immediate 'truncate table global_temp_table'; insert into global_temp_table select /*+ ...
0
votes
2answers
55 views

Can Oracle databases start automatically when Windows machine is booted/rebooted?

In one of my client machines every time Windows starts we have to start the Oracle database manually. Is there a solution/ command to start the database automatically when the machine is ...
1
vote
1answer
2k views

startup mount issues with Oracle

I am trying to simply shutdown and restart an Oracle db instance on a Windows Server 2008 machine (Oracle 11.2.0). Logged in via sqlplus, I issue the command shutdown immediate;. I get the Database ...
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 ...
1
vote
1answer
289 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
votes
0answers
25 views

ORA-12546 on Windows 2012, Oracle 10g and 11g x64

I am trying to create a database with Database Configuration Assistant. At the very beginning, it stops with this error. Of course, I am logged in as an administrator account, and I have disabled ...
0
votes
1answer
235 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
0answers
29 views

Oracle - compressed subpartitions in uncompressed table

I am working with Oracle 11.2. I have table which on subpartition level has in DBA_Tab_subPartitions column COMPRESSION set to ENABLED for all subpartitions. But on partition level in ...