Questions tagged [oracle-11g-r2]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
379 views

ORA-02270: Error report: no matching unique or primary key for this column list

I have created two tables: CREATE TABLE team ( teamname VARCHAR2(30) NOT NULL, carndate DATE NOT NULL, teamnomembers NUMBER(2) NOT NULL, charname VARCHAR2(30), ...
2
votes
2answers
394 views

Deploy materialized view with database link using another user

Our database deployment process logs in as sys to deploy database objects. We ran into a problem when we wanted to deploy a private database link for another user (AU). Our solution was to: Create ...
0
votes
1answer
988 views

How to Migrate Oracle 11g R2 (Windows) database to Oracle 12c R2 (Linux) db

I have a requirement to migrate Oracle 11g R2 database (Windows platform) to Oracle 12c R2 database (Red Hat Linux platform). Is there any methods using RMAN to do it? Any help will be appreciated.
0
votes
1answer
325 views

ORA-27101 while trying to login after shutdown immediate

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 23 19:29:19 2018 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not ...
0
votes
1answer
436 views

Eclipse data source explorer not showing Inserted table records (Oracle)

After I installed Oracle database 11g, I went to Eclipse Database Development Perspective and successfully created a new database connection for Oracle. Then I created a new account call "testing" ...
0
votes
1answer
64 views

Copying Oracle datafiles to a system clone

We have an Oracle 11G R2 on Windows 2008 R2. One night, a windows update package caused our Oracle Instance to be down (no way to connect using sqlplus. we believe it's a network, NIC issue.). We ...
1
vote
1answer
1k views

ORA-04020: deadlock detected while trying to lock object - Oracle Package [closed]

I have an Oracle Package (Schema1) that is calling another Oracle Package (Schema2) over a DB link. There are no recent code changes. When I try to compile the package in (Schema1) it throws the ...
0
votes
2answers
76 views

Unable to remove a user in Oracle 11g

I have a streams replication related user in Oracle 11g. I see the user in dba_users table and was anle to login using the user but when I try to drop the user i get the error. SQL> drop user &...
0
votes
1answer
95 views

MOVING TO ORACLE 12c

I have an rman backup of 11.2.0.2. Also I have installed 12c on a separate server. Can I move my backup to 12c. if yes? Please guide me how to do it? Appreciate your comments and answer.
0
votes
1answer
523 views

Oracle 11g database archive log got increased suddenly in production server

My production db archivelog got increased suddenly one night. Around 200 MB of archivelog were generating in FRA within a minute. It got into normal condition after 15 hours from the start of this ...
1
vote
1answer
4k views

Very slow insert statement

Oracle 11.2.0.4 on OEL 6.5 Our app admin run some update script from app vendor, and this script has been running for several hours and no one know when it will end. Also database now generates lots ...
1
vote
1answer
19 views

How to effectively limit a selection size in a generic manner in Oracle?

Let's say, we have the a query to an Oracle database: SELECT * FROM FOO f WHERE f.bar > baz ORDER BY f.qux; And we are looking for a way to limit the selection size in a generic manner. The ...
0
votes
1answer
107 views

corrupted Oracle 11g database

At a client site with a development Oracle 11.2.0.3/linux DB power outage and crash - no archivelog mode - no backups - Don't know how this was even running select file#,substr(name,1,70) name, ...
0
votes
1answer
187 views

Oracle 11gR2 (11.2.0.4) RMAN cold backup | Media recovery

I'm planning to setup a test server with production data. The intended actions are, making a cold backup & restoring it in the Test server. The cold backup routine is run { shutdown immediate; ...
-1
votes
1answer
196 views

After insert trigger in oracle [closed]

I want to update the value of account table whenever a new transaction occur in transaction table. My schema is-- ACCOUNT TABLE create table accounts(acc_id number(10)primary key, ...
0
votes
1answer
670 views

How to enable Oracle Database In-Memory feature in Oracle 11g R2 to reduce report generation time?

Problem: Each report generation takes a few hours in Oracle 11g R2 and a few tens of reports has to be generated every day. Objective: To reduce report generation time Understood: a) "reports that ...
0
votes
1answer
147 views

How could we start Oracle database in Oracle Exadata which's celldisk has proactive failure?

I am trying to open exadata machine but it has error. That EXADATA  Oracle Sun Fire X4720 M3 SAS, Oracle 11gr2 RAC database installed. I was examining celldisks. When i gave command list griddisk I ...
0
votes
1answer
2k views

How can I prevent oracle to create minidumps?

For some reason, our application sometimes loses connections with the Databases, and then a LOT of minidumps are generated. How can I track the reason for these minidumps? how can I enable something ...
0
votes
1answer
479 views

ORA-31114: XDB configuration has been deleted or is corrupted

ORA-31114: XDB configuration has been deleted or is corrupted How to recreate the XDB configuration? Do I need to remove the existing component first? By the way I can't run UTLRP scritp for the ...
1
vote
0answers
123 views

Error creating aggregate materialized view

Trying to create an aggregate materialized view: CREATE MATERIALIZED VIEW MV_LLATTRDATA_MAX_VERSIONS NOLOGGING BUILD IMMEDIATE REFRESH FAST ON COMMIT ENABLE QUERY REWRITE AS ...
3
votes
2answers
5k views

Granting Privilege on SCHEMA

I have two SCHEMA in a database(ABC,XYZ) Now i want to create a user Test and grant select privilege only on SCHEMA (XYZ) I know how to grant Privilege to a user, but confused how to grant privilege ...
2
votes
1answer
3k views

Why create a Materialized View Log with Primary Key or RowID, etc?

I have a table with 600million rows. I want to create a materialized view that filters it down to 50 million records but also uses REFRESH FAST ON COMMIT. To use REFRESH FAST I need a MATERIALIZED ...
1
vote
1answer
3k views

Merge statement with two conditions in same CLAUSE alternative in Postgres

I was able to convert a Merge which has one condition in both MATCHED & UNMATCHED clauses using CTE. But not sure how to do (both DELETE & UPDATE), if I have two conditions in the same clause. ...
0
votes
2answers
871 views

Cloning the database to another server with raw data files

I'm trying to clone the database of server 1 to server 2 with raw data files. I'm using Linux 7 and Oracle 11g R2. I have the instance running with same SID in Server 2 but file structure is different....
2
votes
1answer
247 views

Oracle 11g: functions or procedures in C/C++

I want to create a function called by a trigger on oracle but in c or c++. Something like in PostgreSQL: Audit trigger in C. Or, in any case, is there support for this but in other languages like ...
1
vote
0answers
68 views

How to set processes parameter in oracle 11g Windows in accordance with RAM in the server

Could anyone explain me whether there is any limitation in setting processes parameter in Oracle 11gr2 and how to set sga_target according to this. Right now I have set the processes to 4000 and I ...
0
votes
1answer
1k views

What is the “SYS_C00054_14031410:34:03$” column in my regular Oracle table?

Tried to do partition exchange and it failed because of 2 extra SYS_* columns in the table: select NAME from SYS.COL$ WHERE obj# =41900658 and name like 'SYS_%'; SYS_C00054_14031410:34:03$ ...
1
vote
1answer
591 views

oracle-xe (11g) service not mounting the database

A few days ago I did a system upgrade to fedora 27 and since then the oracle service doesn't properly start the database, I mean after running: sudo service oracle-xe start the database still down. ...
0
votes
1answer
5k views

ps-ef|grep pmon (Instance Name Only)

When i issue a "ps -ef|grep pmon", I get the below output. oracle 230330 1 0 Jan08 ? 00:01:14 asm_pmon_+ASM1 oracle 244018 1 0 Jan08 ? 00:00:59 ora_pmon_vbsenopd ...
0
votes
1answer
67 views

Command Line Creation of a new 12g Oracle Database

I am new to creating an Oracle database using the command line. I am logged in as superuser; now I would like to create a new blank database, "mynewdatabase". $ . oraenv ORACLE_SID = [oracle] ? ...
0
votes
1answer
66 views

trying to get date to MM/DD/YYY

I have a coding using sqldeveloper under Oracle database using a student database, PowerSchool: PS_CUSTOMFIELDS.getStudentsCF(s.id,'CA_LastIEPDate') AnnDate This is a custom field, ca_lastIEPdate ...
1
vote
3answers
10k views

Materialized view became INVALID and USER_MVIEWS.COMPILE_STATE becomes 'NEEDS_COMPILE'

I have an application which is getting data from Oracle(11.2.0.4) Materialized view, there is expected behaviour about materialized view will go INVALID when any DML action happens on the associated ...
1
vote
1answer
337 views

Disabling SKIP_CORRUPT after using DBMS_REPAIR.SKIP_CORRUPT_BLOCKS

Recently I was involved in recovering data after several blocks in production DB got corrupted. Disclaimer: I'm by no means a competent DBA, but rather a PL/SQL developer with quite a bit (I guess) ...
0
votes
1answer
164 views

ORA-00932 - Error when I try to filter all_triggers

I'm trying to execute the next query: SELECT * FROM all_triggers t WHERE UPPER(trigger_name) like UPPER('%ABC%') AND UPPER(TRIGGER_BODY) LIKE '%DEF%'; But I get the following error: ORA-00932: ...
0
votes
1answer
28 views

Avoiding a possible table reference error

I'm working on a project that's due in 2 weeks and have hit a possibly serious roadblock. The app that I'm working on is some tuition reimbursement management system, whose use cases are dependent on ...
-1
votes
2answers
379 views

How should I ask the IT to enable publishing an apex application on Internet? [closed]

I made an application in apex, (I barely learning first steps), which I use for testing. I have both the database and apex installed on my work PC, and the company has his own Oracle database ...
0
votes
1answer
113 views

oracle practitionner only : UTL_ENCODE failing while sending pdf attached mail in 11g

After lots of trial and error,I was able to send an email with UTL_SMPT. I the code below, in a previous version, I used a raw file and T_BLOB for p_attach_file and it sent a 32 K unreadable PDF as ...
0
votes
1answer
15k views

Best way to get current year minus 5 years

I'm actually have the next query that I use to obtain the current year minus 5 years in january in this format 'YYYYMM'. select TO_CHAR(ADD_MONTHS(TRUNC(SYSDATE,'YEAR'),12*5*-1),'YYYYMM') from dual; ...
0
votes
1answer
184 views

Oracle second date range comparison ignored in where clause

I have the query below and am receiving an unexpected dataset returned back. I was wondering if you all might be able to explain what is going on for me? I am using Oracle 11g. I understand having ...
1
vote
1answer
782 views

How to Manage CPU Usage in Oracle Database 11g using Instance Caging?

I am doing a little test of the cpu utilization case, got to know that i can use Instance Caging for the same to improve my resource utilization. Can somebody let me know how to do this? i m using ...
1
vote
2answers
8k views

Oracle 11gR2 Installation on Oracle linux 7 - Prerequisite condition failed for OS kernel parameter “semmni”

while Installing oracle 11gr2 on oracle Linux 7. The prerequisite condition to test whether the OS kernel parameter "semmni" is failed with below error. Please find the screenshot of it. Below is ...
1
vote
0answers
62 views

Wildly different performance for CTE vs. duplicated table expression [duplicate]

I have a view written like create view v1 as with conn_query as (xxx) select stuff from conn_query where some_cond union select stuff from conn_query where some_other_cond But suddenly querying ...
1
vote
1answer
148 views

How does TIMESTAMP WITH LOCAL TIME ZONE behave when exporting data?

Consider the following table: CREATE TABLE MY_DATA ( MY_DATA_ID NUMBER(38,0) PRIMARY KEY, THE_DATA VARCHAR(10) NOT NULL, DATA_TIMESTAMP TIMESTAMP (6) WITH LOCAL TIME ZONE DEFAULT ...
0
votes
1answer
34 views

When do I need more than one Oracle Instance on the same server?

I have one application server separate from an Oracle server (one physical server). I have three instances on one Oracle Database Server (another physical server). I want to have three environments ...
0
votes
1answer
65 views

Oracle 11g database- performance enhancement and sql tuning methods [closed]

My production database(oracle 11g- windows platform) is growing(it's about 200 GB now) so that the risk of performance issue is also increasing. Please give me some tuning tips used to follow by a ...
1
vote
0answers
30 views

How to handle large sized oracle databases in a windows server

My Production database is having 188 GB size. The server handling the db is having C Drive with a space of 250 GB. My database is growing rapidly.I don't think this database is having much size ...
1
vote
1answer
813 views

Cannot connect to Oracle database server through SQL Developer but Test works OK

I am new to Oracle (from a SQL server and MySQL background) and have just installed Oracle 11g2 Express Edition. I have downloaded SQL developer which appears to be the Oracle world's equivalent to ...
3
votes
1answer
96 views

Alert on Table size

I need to create an alert on my application table when it reaches 98% of its threshold. I wrote an SP which checks the rows and logs the information into a log file which was monitored by alert system ...
0
votes
1answer
958 views

Oracle 11g Enterprise Manager Login Fail Internal Error has Occured

I have installed Oracle 11g on my Windows 10 machine. I followed all preinstallation requirements. When trying to log in to the Enterprise manager via this link: https://localhost:1158/em I get the ...
0
votes
0answers
381 views

Unable to connect Oracle 11g server remotely after recovering Database on a new host?

I have recovered my Oracle database using RMAN after following this tutorial http://www.isaca.org/Groups/Professional-English/oracle-database/GroupDocuments/CKE-...