Oracle 11g is the July 11th, 2007 release of Oracle’s primary database product. New features added in 11.0.1 include Virtual Columns, Automatic Memory Management and Interval Partitioning.

learn more… | top users | synonyms

0
votes
0answers
23 views

Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ) [duplicate]

I have already seen the questioned in the stack overflow that might relate to my problem but let me emphasize that none of them could resolve my issue. issue is: when I wanted to integrate OWASP ...
2
votes
3answers
10k views

Clone / Copy Oracle 10g & 11g

Hi I am absolute begginer in Oracle domain. I would like to learn way how to clone copy oracle database to som backup, use this backup on another server. Oracle is installed on Windows server 2003. ...
0
votes
2answers
2k views

Oracle alternative edition for Windows Server 2012

Does Oracle 11.2 support Windows Server 2012? Any alternative for Windows Server 2012 with respect to Oracle editions? I checked in internet but their forums, and this question says its not ...
1
vote
1answer
28 views

Locating a schema that owns a role

Let's say we've logged on under the A schema. I am able to execute the following statement grant select on wph_pden to LANDING_R; However, the LANDING_R object can not be located in the schema A. ...
-1
votes
1answer
571 views

the environment variables configuration for ORACLE EXPRESS 11g / windows7 32Bit

I can't connect in Oracle Express 11g (windows7 32-bit) and I think the problem comes from the environment variable ORACLE_SID & ORACLE_HOME , how can I get the database instance to do the right ...
0
votes
1answer
817 views

Error AWR Operation failed: CATPROC not valid when creating database with dbca

I have a fresh installation of Oracle 11g enterprise edition on CentOS 6, both 64 bits. I have installed Oracle and so far everything looks fine. I have already added an started a listener. The ...
2
votes
1answer
4k views

Oracle Wallet Setup ORA-12578

I am having trouble setting up the Oracle Wallet on a new box connecting to a new database. I have added the following lines to my SQLNET.ORA: SQLNET.WALLET_OVERRIDE = TRUE WALLET_LOCATION = ...
1
vote
1answer
73 views

Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?

A database application I'm working with uses Oracle scheduled jobs to perform certain tasks. The DBA insists that hard-coding the schema name in the procedures that organise these jobs improves ...
0
votes
0answers
44 views

Oracle AQ Message Replication

We are upgrading our infrastructure and for that we are migrating from Oracle 10g to 11g. We are using Oracle GoldenGate for data replication and it does not support replication of AQ messages as far ...
2
votes
2answers
779 views

Why do shadow processes exist?

Oracle architecture has two types of process: server process or foreground process and background process, but: Some people use it to refer to foreground processes, others use it for background ...
0
votes
1answer
26 views

Enterpise Manager 12c to Database 11g

Does Oracle Enterpise Manager 12c can be install with Oracle Database 11g? Because the Oracle Enterprise Manager 11g is no longer available.
2
votes
0answers
2k views

Oracle 11g displaying ORA-01034, ORA-27101, and Linux “error 2” messages.

When I try to connect to Oracle 11g using: sqlplus noah/noah@orcl I get these errors: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or ...
6
votes
3answers
4k views

Add Oracle Label Security to an existing Oracle installation

We are using Amazon EC2 to host some Oracle database instances while we are evaluating and prototyping some software. We are using the AMIs provided by Oracle - specifically, Oracle Database 11g ...
0
votes
1answer
46 views

Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB

As far as I know in Microsoft SQL Server it is possible to use CURSOR to "scan" database and get all tables/entries where specified string is mentioned. Can I do this in Oracle 11g DB? Any ...
0
votes
1answer
101 views

Oracle 11g accessing data in Oracle 7

I am working on a project that involves converting production data from an Oracle 7 DB to our system, which use Oracle 11g. In our other projects, we use DB link to access the other system DB, which ...
0
votes
1answer
282 views

What is the Difference between IN and Not IN performance wise?

I am new to database.I am having doubt that what is the difference between IN and NOT IN performance wise. When I am using IN, takes less time for the same query(Logically same query) when I use NOT ...
0
votes
1answer
44 views

Orace tablespace extension operation

Could somebody clarify whether tablespace expansion procedure in Oracle 11g database requires any downtime or could impact availability of the database? My understanding that this can be done "on the ...
2
votes
2answers
757 views

Oracle 11.1.0 Autobackup going to wrong location

I am running Oracle 11.1.0 on Win Server 2008. My autobackups used to go to flash_recovery_area\myDB\autobackup\*yyyy_mm_dd*. Then I added a prefix to the file name in front of %F and they started ...
0
votes
2answers
2k views

oracle active sessions waiting for scheduler

Load on my 11g RAC looks like this: and I don't understand how to get insight into what this "scheduler" wait class is. It seems like "scheduler" that it refers to is the process that runs ...
0
votes
1answer
6k views

How to run procedure in Oracle SQL developer

Hello I have a table named CITY in oracle SQL developer, my problem is how to run the procedure -- start the script SET SERVEROUTPUT ON SET LINESIZE 400 SET TIMING ON CREATE OR REPLACE PACKAGE BODY ...
0
votes
0answers
28 views

Bad Header Format in Data files ---Repair Data files [duplicate]

I have 1 corrupted Data file in Oracle Oracle complains "Bad Header Format found" in Alert Log I can open the DB in Mount Mode Can U help how I can repair the Datafiles and recover Data Thanks
0
votes
1answer
254 views

Changes in Oracle Database implicit conversion rules for select statement

Due to hardware failure after a power outage we had to recreate the database for one of our 3rd party applications from an dumpfile (created via exp). The old hardware had Oracle 10G R2 running while ...
0
votes
1answer
807 views

ADD Column ON UPDATE TIMESTAMP

I want to alter a table to include modified and created columns. However, I am having trouble with adding the modified column. I get the following error: SQL Error: ORA-00907: missing right ...
7
votes
2answers
40k views

How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?

I have access to a ORACLE 11g server using the following listener.ora # listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora # Generated by ...
0
votes
1answer
493 views

extproc env variables oracle 11g

I have oracle 11g with extproc separately configured in listener.ora. Users report some environmental variables that should be exported are not set. From where does extproc gets it environment ...
1
vote
1answer
2k views

Registry error while trying to install Oracle 11g on Win 2008 R2

I am new to Oracle and trying to install Oracle database 11g Enterprise Edition on Windows 2008 Server R2 but getting this error all the time... It gives me error when updating registry key ...
0
votes
2answers
269 views

Why can't an owner create a view?

There is a user as HRS. I am creating a view in HRS as CREATE VIEW HRS.RNS..... I am getting ORA-01031: insufficient privileges Edit As i remember, i only execute following commands for ...
9
votes
1answer
2k views

Why am I NOT getting a mutating table error in trigger?

It's (or at least was) known that you cannot use DML statements on a mutating table inside a trigger. An excerpt from the Oracle documentation: A mutating table is a table that is being modified ...
1
vote
1answer
1k views

Indexing issues while partitioning with dbms_redefinition

I get an error while doing the redefinition. Following are the steps which I have taken so far: Step 1. Start redefinition DBMS_REDEFINITION.CAN_REDEF_TABLE(v_name, 'T_FDC_TOOLCONTEXT', ...
1
vote
1answer
1k views

Why can't I log in to SYSTEM without AS SYSDBA

When loging in to sqlplus as SYSTEM, why does the login fail with an invalid username/password error if I do not include "AS SYSDBA" C:\Windows\System32>sqlplus /nolog SQL*Plus: Release ...
2
votes
1answer
4k views

Rename interval partitioning system generated partition names

I have an existing table which I partitioned (interval partitioning on a daily basis) using dbms_redefnition. PARTITION BY RANGE ("TIME_ID") INTERVAL (NUMTODSINTERVAL(1,'DAY')) (PARTITION "p1_1" ...
0
votes
0answers
70 views

what privileges are required to run 'GRANT USE ON EDITION'?

We've just started using oracle edition-based redefinition, which is a great feature. One DB user can run the following command without problems, and another will get ORA-01031: grant use on edition ...
1
vote
1answer
57 views

Open a Oracle 7.3.x database in Oracle 11

Is there any way to open or convert an old Oracle 7.x database into Oracle 11g? Thanks in advance!
0
votes
0answers
274 views

Alternatives for UPDATE statement Oracle 11g

I'm currently using Oracle 11g and let's say I have a table with the following columns (more or less) Table1 ID varchar(64) Status int(1) Transaction_date date tons of other columns And this ...
0
votes
2answers
1k views

ORA-1033: ORACLE initialization or shutdown in progress

I am stuck with a little Oracle problem. My PC was shut down improperly after my graphics card freaked out, which caused Oracle 11g Express to not properly close down. This means that I get the above ...
1
vote
3answers
3k views

Unable to mount oracle instance

I am trying to shutdown the system, then I want to mount it. I have tried this: SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ...
2
votes
2answers
6k views

Oracle 11g: LRM-00109 followed by ORA-01078 when using PFILE created by SPFILE

I know this is long, but please bear with me - I think the background info may be important. OS: Windows Server 2008 R2 64-bit DB: Oracle 11g 64-bit Enterprise Edition Yesterday evening we had to ...
0
votes
1answer
2k views

Oracle 11g Enterprise downgrade to Standard One

I'm checking possibilty of downgrade Oracle 11g from Enterpise Edition to Standard One edition. I've cross-checked edition comparison with select name from dba_feature_usage_statistics where ...
0
votes
1answer
1k views

How to see profile assigned to a user

Let's say i have created a user as 'TEST_USER', and then i assigned a profile to it. Now how can i see for TEST_USER which profile has been assigned? I want some query that will check what profile a ...
-1
votes
2answers
3k views

How do I determine the licensing cost of Oracle Standard Edition for HyperV instances? [closed]

I'm confused by Oracle's licensing for their Standard Edition. My understanding is that licensing for the Standard Edition is determined by the number or physical processors (actual chips, not cores) ...
11
votes
5answers
23k views

Best way to delete very large recordset in Oracle

I manage an application which has a very large (nearly 1TB of data with more than 500 million rows in one table) Oracle database back end. The database doesn't really do anything (no SProcs, no ...
0
votes
0answers
668 views

How to concatenate multi row sql output

Version Information: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production HP Server Automation v9.14 I am creating a report of all my HP-SA managed servers. The report includes data from ...
1
vote
1answer
319 views

USER_ID field in alert logs (also in V$DIAG_ALERT_EXT view)

Does anyone know what triggers the USER_ID field in the log.xml to be populated? The value also exists in the V$DIAG_ALERT_EXT view. I've found by observing the logs that if a temp tablespace fills ...
-1
votes
1answer
383 views

Importing only one user data from a Dump file

I am using oracle 11gr1 SingleByte Database, I am trying to import a Dump file. but strangely the dump file contains multiple user objects(i.e, Import(IMPDP) is not done properly). example: . . ...
1
vote
2answers
145 views

Using max for each sub group does not seem to work.

I have a table that looks like this in Oracle 11g: +----------------------------------------------------------+ | ACCT_NBR | MAIL_TY | ORGA | PERS | RUN_DATE | ...
-1
votes
1answer
79 views

Problems working with decode function when there is more then one expression

I am using Oracle 11g. I have these two tables: Table acct: acctnbr || Name || Mailing address 000001 || Slater || 000002 || Baker || Alt 000003 || Parke || Table addruse: ...
2
votes
1answer
1k views

Replicate or Call java encryption function in Oracle pl/sql

I am trying to replicate encryption/decryption method present in java in Oracle DB, so that data encrypted in java can be decrypted through Oracle Function. Below is java code: package com.encr; ...
1
vote
1answer
67 views

Query for View with unique entries from Database with repeated entries

I have a table with columns of Hotel names, city name and country name (of the respective hotels). I need to create a view of unique entries which will contain city name and country name columns. Any ...
3
votes
2answers
9k views

How to execute this procedure in PL/SQL?

I have this table in the below format: Persnbr | Userfieldcd | Value 01 | Port | Funds 01 | Vip1 | Systems 02 | Port | Bank 02 | Vip1 | Authority This is how I want ...
2
votes
2answers
163 views

how to make a particular field into seperate columns?

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production. I have this table in the below format: No | User | Value 01 | Port | Funds 01 | Vip1 | Systems 02 | Port | Bank ...