0
votes
2answers
28 views

Installing scott schema for oracle 11g express

I want to install scott schema, a sample database in oracle. But in express edition, I can't find out it. Please help me install it on Oracle 11g express. I'm a newbie, pls help me
0
votes
1answer
29 views

TNS-12535: TNS:operation timeout

I have Windows Server 2008 R2 with Oracle Client 11.1.0.7.0 client installed. TNSPing to 100% available databases (accessible from other machines, i.e. I can do TNS ping to these databases from other ...
0
votes
0answers
24 views

Oracle edition-based redefinition

I have difficulty purging prior editions that clutter up my system: we deploy new code every 2 weeks, hence a new edition every time: ORA$BASE --> v37 --> v38, for example. I actualized all ...
0
votes
0answers
17 views

What is a CLRExtProc oracle instance?

An lsnrctl status output: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, ...
1
vote
1answer
33 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
1answer
45 views

Striping IO with datafiles on different physical mounts

I have a server with three directly attached disk controllers. Each of these can provide internal redundancy and IO-striping accross disks, but I'm wondering what is the best way to configure the ...
0
votes
0answers
19 views

are temporal relationships a good candidate for Oracle cubes?

We have a requirement in our database to represent various "temporal" relationships in our data. A simple example would be an event table where I want to know how many days prior to the event date ...
1
vote
2answers
70 views

Oracle becomes too slow after system crash

I am using Oracle 11.2 as a database for my application. For this purpose I should import my data (around 100m records) to this database. For this purpose I used SQL Developer. Unfortunately at the ...
0
votes
0answers
34 views

Oracle Enterprise Manger not working correctly

I'm not familiar with oracle management. The problem is when I try to connect to the enterprise manager through the Web browser I get this error: Where to find the log file to see what's the ...
1
vote
0answers
23 views

Multiple handler entries in lsnrctl services output

This what I get for an lsnrctl services. LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-APR-2014 10:01:43 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to ...
0
votes
0answers
21 views

how do we specify an oracle edition in a database link?

We are connecting using a DB link from one oracle database (a) to another (b), and b has oracle editions enabled. How do we specify an edition to be used when viewing the tables / views in database ...
1
vote
2answers
42 views

Oracle result cache behaviour

Oracle by default caching the query results and function results(Buffer cache). I have noticed this with AutoTrace utility, where the physical reads are huge on first execution, but from next ...
0
votes
2answers
30 views

Hide zero hours and minutes with NLS_DATE_FORMAT

I'm currently using date format: alter session set nls_date_format = 'DD.MM.YYYY HH24:MI'; The (cosmetic) problem is that this always displays time even if it's zero, for example: "27.03.2014 ...
1
vote
0answers
35 views

is there a DB client which supports oracle editions?

We are using a clever feature or oracle 11gr2 called edition-based redefinitions. This means each stored proc and view looks different depending on the edition you set in the session. There are ...
3
votes
1answer
62 views

connection issue / Oracle Express 11g in windows7 32bit

I have an issue with Oracle Express 11g in windows7 32bit. Everytime when I try to conncet to the database I get this error message. How can I fix it please!
0
votes
3answers
46 views

How to mirror the privileges of an user to another in Oracle Database? [duplicate]

I need to grant all the privileges of a user (say 'AAA') to another user (say 'BBB'). Is there such an Oracle command (11.2.0.3.0)?
2
votes
1answer
40 views

Does a DDL in Oracle affect other transactions?

I understand that DDL statements in Oracle have an implicit commit before and after the statement, which obviously affects the current transaction. However, does a DDL statement in any way affect ...
0
votes
1answer
44 views

Inserting data into a table with one value as clob and blob

My table has one clob column and one blob column. I need to insert data into it through insert statements. The length of data to be inserted is more than 4000 chars. When I do export of insert ...
0
votes
0answers
31 views

Oracle Merge performance

I've a question about the merge performance in oracle. I work in the business intelligence area of a big company and its quite common to have to move millions of records one side to other. The other ...
0
votes
0answers
31 views

What is meant by the RMAN Duplicate “noncurrent point in time”?

When doing a RMAN DUPLICATE from backup connected to the target, how current does the duplicate make the database when no until time is set? The closest thing I can find in the documentation is the ...
0
votes
1answer
42 views

Oracle 11g max login fail attempts workaround

My problem with database starts with situation where I cant really modify anything in database. My project specialist has limited time to help me. Here is the thing: My user in Oracle database has ...
0
votes
1answer
58 views

How to export oracle 11g database partially

I have a huge oracle test database whose size is more than 100 GB. I want to export only 1% of all the data and import it into my local database to have a local replica of that application. Is it ...
0
votes
1answer
93 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 ...
0
votes
1answer
51 views

Oracle case insensitive passwords seemingly ignoring SEC_CASE_SENSITIVE_LOGON

I'm trying to change the SYS password of an Oracle 11g database to be case-insensitive for legacy application reasons. My research suggests all I need to do is set the SEC_CASE_SENSITIVE_LOGON flag, ...
0
votes
0answers
46 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
335 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
1answer
66 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
101 views

ORA-30009: Not enough memory for CONNECT BY operation

I have a Linux VM (with CentOS 64 bit) where I installed Oracle Database 11g Express Edition. The database is running, I can use sqlplus and I can create tables and stuff. However, when I run a ...
1
vote
2answers
75 views

Bad bind variable in audit trail trigger in Oracle 11g R2

I have been trying to construct audit trail triggers and procedures in oracle and I am facing a problem with bind variables. Following is the code create or replace trigger trg_audit_trail for insert ...
0
votes
1answer
58 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
0answers
161 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 ...
1
vote
1answer
113 views

Check only prerequisites when running runInstaller in silent mode

I want to check just prerequisites and generate a log without installing Oracle database. When I run the following command: ./runInstaller -silentvalidate -responseFile ...
0
votes
0answers
99 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
56 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
96 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 ...
-2
votes
1answer
88 views

Stored procedure syntax error [closed]

I am writing a procedure, independently the queries run fine with no errors.. But, when I run it as a procedure I get errors. Given below is my procedure create or replace PROCEDURE xyz(inuserid ...
0
votes
1answer
31 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,
0
votes
0answers
55 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: ...
2
votes
2answers
136 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
390 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
1answer
73 views

Database is slow once in a while

I am executing a web service for 100 times. The average response time of this service is 1.5 seconds. But when I look at the response time of each execution individually, there are a few executions ...
1
vote
1answer
78 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.
0
votes
1answer
413 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 ...
0
votes
1answer
38 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, ...
0
votes
0answers
267 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 ...
1
vote
1answer
61 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
83 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
2answers
165 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 ...
14
votes
3answers
327 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, ...
0
votes
1answer
89 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 ...