Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...
1
vote
0answers
167 views
Which oracle (10g) template files (DBCA) can be be copied to different server for cloning?
I am trying to clone a schema from one Oracle 10g server to a different Oracle 10g server.
I have created a database template (DBCA) from an existing database (structure and data).
I have copied ...
1
vote
0answers
164 views
Connection to MS Access from Oracle over a DB Link
I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the ...
1
vote
0answers
441 views
ORA-00449: background process 'MMON' unexpectedly terminated with error 448
I got the follwing error while running a query from Java:
The database returned the following error:
[Oracle] #11 ORA-00449: background process 'MMON' unexpectedly terminated with error 448
[Oracle] ...
1
vote
0answers
186 views
How do I import a dump for a deleted tablespace?
I'm trying to import a database dump, however I am encountering this error:
ORA-39083: Object type TABLE:"MYSCHEMA"."MINF" failed to create with error:
ORA-00959: tablespace '_$deleted$5$0' does not ...
1
vote
0answers
76 views
XML parsing failed
I'm using a query on a oracle db which extracts values from clobs using the xmltype function and an xpath. Unfortunately the query fails and reports a 'XML Parsing failed'. I assume that one of the ...
1
vote
0answers
55 views
Problem with SDO_AGGR_CONCAT_LINES in Oracle
I have a line consisting of 3 segments A, B & C
A touches B at just one point, likewise for B & C
The SDO_AGGR_CONCAT_LINES function returns a MULTILINE object (GType = 2006) rather than a ...
1
vote
0answers
84 views
Dealing with Invisible Referencers
Using Oracle database, suppose I have a parent table parent defined in schema A, and a child table child defined in schema B. To achieve this, schema A granted references privilege on parent to schema ...
1
vote
0answers
216 views
FATAL ERROR IN TWO-TASK SERVER: error = 12571
oracle9i/windows2003,java application.
oracle crash, alert log file contains sdh_ora_4636.trc which contains:
*** 2012-05-05 13:53:32.000
*** SESSION ID:(100.50539) 2012-05-05 13:53:32.000
FATAL ...
1
vote
0answers
189 views
ORACLE SSL using Microsoft Certificate Store for PKI
I am trying to set up PKI SSL authentication between client and server using a Microsoft Certificate Store.
Client: Windows 7 64 bit with Oracle client 11.2.0.3.0
Server: Windows 2008 R2 64 bit with ...
1
vote
0answers
53 views
Diskless Oracle and persistent filesystems
I'm putting together a diskless Oracle database SLES image.
What will need to be kept stateful?
For example, what filesystems need to persist? Right now, the easy ones I know of are /home, /perf ...
1
vote
0answers
33 views
sdo_tune.quality_degradation returning negative values
While running the sdo_tune.quality_degradation function on one of our Oracle databases most of the results were around 1 but a number had values like -556127.225.
Does this mean that these indexes ...
1
vote
0answers
101 views
Can not open oracle 10g database when migrated from oracle sql developer 1.5x to 3.1x
I have migrated from Oracle sql developer tool 1.5x to 3.1x and imported my connection settings with database 10g. When I try to open a connectionstring in the developer tool I get this message:
...
1
vote
0answers
218 views
Oracle Flashback Archive aka Total Recall in MySQL
What would you suggest as a replacement system to achieve the same functionality of Oracle Flashback Archive aka Total Recall in other DBMS, in general or specifically in MySQL or MariaDB?
...
1
vote
0answers
39 views
What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?
I have some profiling scripts which work in some environments, but not others; the odd thing is that it doesn't seem terribly consistent across versions, so I'm guessing there's some patch or feature ...
1
vote
0answers
254 views
FREETEMPORARY on blob with no reference
In Oracle 11g, we are using XMLELEMENT to get records from tables. The problem seems to be, however, that we are calling SELECT XMLELEMENT(...).getClobVal() from DUAL; which is eating our temp ...
1
vote
0answers
362 views
What can cause [DataDirect][ODBC Oracle Wire Protocol driver]Connection refused.?
The Title speaks for itself.
We have this error message on the client side of the application.
The devs suspect a problem on the database.
The alert log on the database shows no errors at all.
The ...
1
vote
0answers
84 views
Question on Oracle database table compress option?
How come a compress enable table (name as ABC) when created (Oracle 11g R1), but after merging with a partitioned table's partition with data which is not compressed, then the table (ABC) auto ...
1
vote
0answers
271 views
Error starting up OC4J_EM: java.sql.SQLException: Logical handle no longer valid
I'm trying to launch the OPMN-managed process OC4J_EM, which is needed for Oracle's Enterprise Manager. When I run use the startall or startproc command, I get an error:
failed to start a managed ...
1
vote
0answers
458 views
Which packages are required to install Oracle 11.2.0.3 on Solaris 11?
Where can I find information on which packages are required to install Oracle 11.2.0.3 on Solaris 11? The documentation only mentions Solaris 10. I tracked down the packages required for Solaris 10, ...
1
vote
0answers
936 views
Convert the Highvalue of user_partition in varchar2
I have a requirement where I would like to use the HIGH_VALUE field of user_partition table as a Varchar2 or TimeStamp value and I would like to get it used as a Function in SQL Query.
Something like ...
0
votes
0answers
13 views
Longest prefix search in Oracle
I have a list of phone number prefixes defined for large number of zones (in query defined by gvcode and cgi).
I need to efficiently find a longest prefix that matches given number PHONE_NR.
I use ...
0
votes
0answers
31 views
How do you take export dump files on Oracle 7.3 running on Windows NT 3.51?
How to take dump files on Oracle7.3 running on Windows NT 3.51?
Should you stand in the Orant/bin folder and run one of the programs there like>
exp73 SYSTEM@[hostname] FULL=Y LOG=EXPORT.LOG
Did ...
0
votes
0answers
19 views
where is oracle session timezone set?
I have a logging table
CREATE TABLE EMAIL_LOGGING
(
ID NUMBER(9) NOT NULL,
SEND_DATE TIMESTAMP(6) DEFAULT LOCALTIMESTAMP NOT NULL,
...
0
votes
0answers
19 views
Oracle Grid Control
How can I implement all the mentioned below points for monitoring in Oracle Grid Control?
Datasource Monitoring
JMS Monitoring
Composites (State (Stop/Retired/Undeployed)
Physical servers (Virtual ...
0
votes
0answers
55 views
PL/SQL extremely slow FETCH performance
I have a stored procedure that includes (among many other things) a dynamic query with a LOOP and a FETCH. The fetch has to potential retrieve a large amount of data as one column contains spatial ...
0
votes
0answers
44 views
What are the host credentials for Enterprise Manager 11g?
I am trying to use Database Replay in 11g Release 1 using Enterprise Manager. In the last step it asks for 'Host Credentials' to start the capture. But when I give the username and password for the ...
0
votes
0answers
51 views
How to clone a database from one environment to a database on another environment?
OS: RHEL
DB: Oracle 11g version 11.1.0.7.0
I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database ...
0
votes
0answers
32 views
Passing parameters to a procedure executed by DBMS_SCHEDULER
I have a scheduler program that runs a stored procedure that requires input parameters.
BEGIN
DBMS_SCHEDULER.DROP_PROGRAM
(program_name => 'MYSCHEMA.EXPORT_SCHEMA_STARTING');
END;
...
0
votes
0answers
24 views
Database Volume Statistics in Oracle - dba_hist_tbspc_space_usage
I am looking for generating a Database Volume Consumption Report in Oracle 11g based on a specific time period.
For e.g
1) Total Volume( Excluding Index Size) at 12 AM
2) Total Volume( ...
0
votes
0answers
45 views
DBA_SCHEDULER_Job is not giving any result
I have created one procedure that is supposed to trigger on 5th date of every month.for that i have used dba scheduler job.but its not triggering.
select job_name,status from dba_scheduler_jobs;
...
0
votes
0answers
30 views
Oracle to SQL Server DDL replication
We have this customer requirement to do DDL + DML transactional replication from Oracle to SQL Server 2012. The DML part is straightforward. There are multiple options to choose from including the SQL ...
0
votes
0answers
22 views
Oracle Downstream Log transfers
I am attempting to create a downstream capture process for two Oracle 11 databases running on Linux servers. The replication will be one-way and asynchronous using archive logs as the transfer ...
0
votes
0answers
55 views
How to count number of rows inside Oracle dump file?
I have a huge (38Gb after bzip2) Oracle EXP dump file. It contains one table.
Such big dumps usually end up with an error, but in fact contain the full table.
Earlier I was importing these tables ...
0
votes
0answers
36 views
Temporarly disable cache in oracle 11g
I want to disable the caching for my session in oracle 11g to see how long a query takes.
Is this possible or is there a better way for meassuring the time a query takes to run?
0
votes
0answers
58 views
Use cases for NoSQL databases: Time series
I need to set up a database that will record temporal series data (sensors). A friend of mine has recommended me to use a NoSQL database instead of using Oracle (for instance).
There're also some ...
0
votes
0answers
27 views
What value should oracle.install.db.config.starterdb.memoryLimit be set to in the Oracle response file for a silent installation?
What happens when oracle.install.db.config.starterdb.memoryLimit is not set in the Oracle response file for a silent installation?
I noticed that when recording the response file for a silent Oracle ...
0
votes
0answers
27 views
file extension of the file types cdump, incident, trace
I need to know the file extension of the file types cdump, incident, trace, alert.
Actually I want to create files of the above types manually using mkfile command.
There are no existing files of ...
0
votes
0answers
82 views
pl/sql developer show errors with arabic letter
I have pl/sql on my PC but when an error occurred while I write an incorrect sql query the oracle error message show with Arabic letter as below
ORA-00936:???? ????? ??????
I am using oracle-client ...
0
votes
0answers
30 views
Error PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
i've problem here. i wanna create a Stored procedure like below, but i encountered error PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records.
create or ...
0
votes
0answers
115 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 ...
0
votes
0answers
24 views
Refresh ORACLE OLAP cube
I am new at Oracle OLAP programming, and just wanted to know about Cube´s Data Update.
For example, right now I maintained and processed the cube for 2012 data; 2013 data is ready on the fact table ...
0
votes
0answers
49 views
How can we hide our procedures in Oracle?
How can we hide our procedures in Oracle? Is there any other way except Wrap utility?
0
votes
0answers
24 views
Multiple principals in a single kerberos keytab file?
I have a situation where I have multiple keytab files (different principal accounts) and my application is going to use these different service
principal accounts and connect to one or more Oracle ...
0
votes
0answers
32 views
Why can't OUI detect system packages when they are already installed?
I am installing Oracle 11g 32bit on Ubuntu Linux and the OUI shows following error message on Prerequisite Checks screen -
This is a prerequisite condition to test whether the package "make-3.80" is ...
0
votes
0answers
44 views
Oracle Alternative to EXISTS EXCEPT
I wonder if there is an equally elegant solution for Oracle for the problem posted and answered here:
Comparing Columns that can contain NULLS - is there a more elegant way?
I can't get this ...
0
votes
0answers
90 views
Oracle Connection Issue - TNS Protocol Adapter Error
I'm trying to connect to an Oracle database from a client machine and I'm getting an ORA-12560: TNS:protocol adapter error from a python script using pypyodbc as my ODBC library.
I have researched ...
0
votes
0answers
76 views
DBA group in Linux
When we need to install Oracle database in Linux then the user should be in dba group. What is this group and why the user should be in this group for installing Oracle database. What happens if the ...
0
votes
0answers
39 views
No network ACL, yet my user can successfully connect to external server
This one's had both me and our dba scratching our heads.
We have an Oracle 11.1.0.7.0 instance, DEV, with a user who can successfully connect to our ldap server, e.g.:
DECLARE
l_session ...
0
votes
0answers
39 views
Troubleshoot abnormal connections
We experienced extreme slowness of login on 6 Mar in 1 of our Oracle servers (Solaris 10) running Oracle DB. During that period of time, our firewall had detected and dropped many TCP connections ...
0
votes
0answers
21 views
import .dmp file created in OS W2K to Win 2003
I have .dmp file exported using oracle 8 and OS Windows 2000. Can it be imported in Oracle 8 and OS Windows 2003?
