The second and terminal release of Oracle Corporations Oracle 11g database product. 11.2 was released for Linux on September 1st, 2009. New features added include RAC One Node, Improved data compression ratios (up to 20x), Edition Based Redefinition, Recursive Subquery Factoring, Instance Caging, ...

learn more… | top users | synonyms

0
votes
0answers
115 views

ORA-01658 on index tablespace when trying to insert into empty table of new database

We are getting ORA-01658 (Error :ORA-01658: unable to create INITIAL extent for segment in tablespace MYDATA_LDATA_INDEX) in our application logs. This happens when application is trying to insert ...
0
votes
1answer
1k views

ORA-15081: failed to submit an I/O operation to a disk

I have a test environment for Oracle single instance on ASM 11.2.0.3. I have restored database from tape and during the recovery, the system crashed by some I/O error. I restarted the server, ...
0
votes
0answers
22 views

unable to allocate 4064 bytes of shared memory [duplicate]

i am facing this error ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","SELECT...","sga heap(1,0)","kglsim heap") i have tried flushing the shared pool. it still didn't ...
0
votes
2answers
7k views

“ORA-01017: invalid username/password” : Why is that?

What is the difference between the two : SQLPLUS / AS SYSDBA and SQLPLUS Enter user-name: SYSDBA Enter password: If I use the first command I get connected and see the prompt SQL> but upon ...
0
votes
0answers
76 views

Installing Oracle on Windows Server 2008 R2 Guested by VMware

I am trying to install Oracle Database 11g R2 on Windows Server 2008 R2 Guested by VMware Workstation 10. I tried this more that 5 times but every time I was encountered by Enterprise Configuration ...
3
votes
2answers
159 views

How to retrieve disk spaces by removing tables from tablespaces in Oracle 10g?

I'm using a Oracle 10g database. I have a big tablespace MYTBS made of a dozen data files (MYTBS_01, MYTBS_02, ...) of different sizes which have been added through the years. Now i have removed very ...
0
votes
1answer
214 views

Installing Oracle 11g on Windows SBS 2011 64 bit

In the Oracle web site, I found the following requirements: http://docs.oracle.com/cd/B28359_01/install.111/b32006/reqs.htm#CHDHGGFE Oracle Database for x64 Windows is supported on the following ...
0
votes
1answer
100 views

Why am I getting an error in execute immediate command in oracle 11g?

I was just testing an anonymous code which I wrote for audit trail It's just a sample for test. However I am getting this error: [Error] Execution (1: 1): ORA-00984: column not allowed here ...
1
vote
1answer
51 views

can I quickly create tables for each partition?

I have a table with two partitions and I would like to create two tables, one from each partition. Is there a quick way to do this (a la partition exchanges) instead of a create table as select ...
0
votes
1answer
165 views

converting varchar to number while passing to IN clause

I am really stuck here.. Given below is the miniature of what I am trying to achieve. set serveroutput on; declare rajesh varchar2(20); x number(10); begin select wm_concat(stocks_id) into rajesh ...
0
votes
1answer
69 views

What index(es) should I use for three columns join?

I have a table which has the following columns: CREATE TABLE example ( exid INT, extype INT, studentid INT, (more columns) ) The table will have hundreds of thousands rows, and each ...
0
votes
1answer
39 views

Initializing values to a custom data type

I have defined a custom data type which I need to use in my procedure. Give below is my data type. CREATE or REPLACE TYPE CUSTOM_DATATYPE AS object( chkinvpre VARCHAR2(100), orderid ...
0
votes
0answers
1k views

Oracle installation requires old rpm versions, what to do?

I am installing Oracle 11g R2 on OEL6. I run the following command, for to check only prerequisites ./runInstaller -silent -responseFile /0/grid/response/crs_install_mk.rsp -executePrereqs It ...
2
votes
0answers
31 views

Attaching Existing Oracle Home to fresh Windows Install

I have a client who recently was forced to reformat and reinstall Windows Server 2008 R2. Their ORACLE_HOME (Oracle 11g) and all of the data was located on a D: drive that was not reformatted. Can I ...
0
votes
0answers
43 views

storing multiple values in variable

oracle:11g Hi, I have a query wherein I need to store the result of a select sql query which can return multiple values(I am selecting only one column so the values will be from the same column). ...
0
votes
0answers
428 views

'oracle.jdbc.driver.OracleSQLException': ORA-01031: insufficient privileges. (SYS.DBMS_XMLSAVE)

I have this function (written here by someone), placed in the package ENVER.ENCODING_VERIFIER: FUNCTION loadxml_table (p_owner IN VARCHAR2, p_tablename IN VARCHAR2, p_format IN VARCHAR2, p_tmpClob IN ...
1
vote
1answer
107 views

ORA-12541 error while connecting to oracle express edition 11g

My oracle express edition was working some months earlier. I dont know what i changed in the system, now I could not connect to it. I tried logging in from sqlplus as sysdba and altered the accounts ...
0
votes
0answers
234 views

What problems can be caused by dropping a rollback segment manually?

Oracle version: 11.2.0.1 I have the following error: "Transaction recovery: lock conflict caught and ignored" I can't upgrade my database now. I had a RAC. Removed one node, but the undo tablesapce ...
0
votes
0answers
99 views

ORA-13901 Object UNDOTBS01 was not found. ORA-06512: at “SYS.DBMS_SERVER_ALERT”, line 7

Oracle version is : 11.2.0.1 I have created alerting on every error occurring in database, and in this alert log I've found the following errors ORA-13901: Object UNDOTBS01 was not found. ORA-06512: ...
0
votes
1answer
73 views

How to Convert a Table into XML Document

I have a table say SCOTT.DEPT and I want to convert it into an XML document. Is there anyway to accomplish this task? Kind Regards,
2
votes
2answers
273 views

ORA-12899 when creating varchar virtual column based on numeric column

I have a table with numeric column: create table test (a number(2,0)); Next I want to create a virtual column based on column a: alter table test add (b varchar2(3) as ('A:'||to_char(a))); This ...
1
vote
1answer
172 views

Field Level Auditing in Oracle 11g R2

I want to enable auditing on some column in a table. I have tested the SYS, Schema and Table level auditing. Guide me or refer me some document to enable auditing on column level.
1
vote
1answer
1k views

SHA-256 hashing in oracle 11g

How can i encrypt or hash a password inside a trigger using sha-256 so that i can store the hashed value in another table using that trigger? Also how can I decrypt it??
0
votes
2answers
565 views

schema analyzer tool

I am currently using TOAD to connect to the database. I have around 20 tables that I have been asked to analyze ( I am new to project ). I think the first place to start is to understand the relation ...
0
votes
1answer
298 views

Oracle SYS Auditing with Audit Trail to DB

I have an Oracle Database 11g R2 on Oracle Enterprise Linux. I have enabled SYS auditing as: SQL> ALTER SYSTEM SET audit_sys_operations=true SCOPE=spfile; SQL> ALTER SYSTEM SET audit_trail=OS ...
5
votes
3answers
698 views

Return a fully dynamic table from an Oracle function

I'd like to write a function with two IN parameters where the first one is a varchar and the second a list of varchars. Based on these I want to return a table with varying column amounts and names of ...
1
vote
0answers
94 views

Advice to set minimum preferable value for MEMORY_TARGET

I have a server having 90GB of RAM. I have set MEMORY_TARGET to 60GB, because OEM showed me the following graph: Which tells that, if you set the parameter to the value of 60GB, the performance ...
0
votes
1answer
2k views

Oracleasm deletedisk failed Unable to clear disk

I have dropped the disk from ASM diskgroup: > ALTER DISKGROUP DATA01 DROP DISK DISK1; Oracle did a rebalance operation and then dropped the disk. Now, I want to delete the disk from ASM library ...
3
votes
2answers
951 views

Oracle imp crashes without error

I have Oracle 10g XE database locally. I export schema with something like exp %USER%/%PASSWD%@XE statistics=NONE owner=%USER% file=dump.dmp Exp is 10.2.0.1.0 version - so is the DB. Than I take ...
0
votes
1answer
55 views

How do I resolve “ORA-23293: Cannot rename a column which is part of a join index?”

Disclaimer: I am a developer, not a DBA, but this question seems more appropriate for DBAs than for StackOverflow. Now to my question: We have a table in an Oracle Exadata schema that uses a numeric, ...
1
vote
1answer
78 views

How can I delete rows in an oracle table from xml input parameter?

> CREATE OR REPLACE PROCEDURE PRC_OPEN_PERIOD > ( InputXml in VARCHAR2,Tmode in varchar2,pOUT OUT number ) > IS > v_count NUMBER(38) := 1; > v_inner NUMBER(38) := ...
0
votes
0answers
1k views

ORA-03137: TTC protocol internal error

I have 11g 2-node RAC. My alert.log contains several ORA-03137 errors: Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_10679.trc (incident=149362): ORA-03137: TTC protocol ...
4
votes
3answers
4k views

Trouble killing sessions then immediately dropping users in Oracle 11g XE

I would like to be able to kill active sessions by a given user, and then drop that user, and do so within a single database call. Here is what I have so far: DECLARE cursor c is select * ...
1
vote
0answers
241 views

rman 'delete archivelog all’ very slow

On our automated test system we use flashback all the time to reset our Oracle 11g database to a state before a testrun. We noticed some of the scripts involved started to become slower and slower. In ...
-1
votes
1answer
2k views

How to determine if an Oracle table is locked or not?

We've been using BI software and a repository database that are installed on Oracle Enterprise 11gR2. Some of these batch reports will try to access a database table which may still be locked. How ...
0
votes
2answers
577 views

How can I change the connection descriptor used by Oracle Enterprise Manager?

I've recently changed the SERVICE_NAME of my 11g database and Enterprise Manager can no longer connect to it: 2014-01-08 10:36:06,047 [HTTPThreadGroup-3] ERROR eml.OMSHandshake ...
0
votes
0answers
156 views

ClassNotFoundException when trying to deconfig Oracle Enterprise Manager

The Enterprise Manager for my Oracle 11.2 installation doesn't work anymore as described in How can I change the connection descriptor used by Oracle Enterprise Manager? and I tried to re-configure it ...
0
votes
0answers
74 views

Oracle 11g Rel 2 installation on windows 2008 Server

I am SQLServer guy but due to some reason I need to create a VM of windows 2008 R2 standard server and want to install Oracle 11g R2 64bit. I have installed a loop back adapter and gave IP : ...
0
votes
0answers
159 views

Database creation fails with ORA-12560

I installed Oracle 11g R2 PS4 on SunOS 5.10 sparc machine. When i try to create a new database using the Database Creation Assistant tool (dbca) i get the popup message ORA-12560: TNS:protocol ...
-1
votes
1answer
51 views

Making data from one schema available to another schema

I need to make data that is currently in one schema available to a different user in the same Oracle database. Does this require that we replicate data from one schema to another? Or is there a ...
6
votes
2answers
8k views

Learning to Optimize SQL Queries and Understand Execution Plans - Resources?

I find myself writing more and more SQL queries at work (mostly Oracle 11g, but some SQL Server 2005-2008) and have started creating some pretty complex views for the rest of the analyst team. They ...
14
votes
3answers
443 views

Oracle is not using a unique index for a long key

I have a table with 250K rows in my test database. (There are a few hundred millions in production, we can observe the same issue there.) The table has an nvarchar2(50) string identifier, not null, ...
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
1answer
264 views

Why doesn't row data show up in SQL Developer?

I'm using Oracle database and I've created a test table "Table1" with a varchar column "column1". I ran the following loop to add some rows: BEGIN FOR i in 1..10 LOOP INSERT INTO TABLE1 ...
0
votes
1answer
140 views

Can oracle use more memory than memory_max_target?

My system has 34 GB RAM, however, I have set memory_max_target = 3GB, memory_target = 3 GB and I use AMM (Automatic Memory Management). Even though thats the case when I check the current usage of ...
1
vote
2answers
116 views

Audit table insert restriction

So I'm trying to create my own audit table for some user management analysis and stumbled across a little problem. I use this trigger CREATE OR REPLACE TRIGGER usr_t_audit_user_alnd AFTER LOGON ...
1
vote
3answers
479 views

How to prevent scheduler jobs from running at instance startup

I'm currently testing Oracle 11g restore procedures from RMAN backups. I can restore instances to another host, but problem I'm having is that as soon as I open the restored instance, scheduler jobs ...
2
votes
2answers
3k views

Dynamic Oracle Pivot_In_Clause

I'm kinda stuck. I want to do a user-role-relationship pivot table and my query so far looks like this: WITH PIVOT_DATA AS ( SELECT * FROM ( SELECT USERNAME, GRANTED_ROLE ...
0
votes
2answers
69 views

Best Data compression technique in Oracle

We are trying to create a Archival Strategy for Oracle Databases. Archiving old Records to Compressed Oracle tables has come out as a winner. We have noticed 55% byte saving for Tables with only Text ...
1
vote
0answers
47 views

Register XML schema using dbms_xmlschema in Oracle 11g

I have a xsd file located at C:\temp\test.xsd I need to register this schema to create a XMLType table for Object Relational XML Storage. How do I register the schema for relational storage? I do ...