Oracle Corporations version 10 of its flagship RDBMS product.
2
votes
1answer
136 views
Database Link from Oracle 10g on Windows over to MySQL database
Didn't see any answers on this subject so hoping for a miracle! :-)
I've got an Oracle 10g database running on Windows Server 2003 and I'd like to create a database link to an external MySQL database ...
1
vote
1answer
59 views
Finding why an Oracle listener got automatically restarted
I got the following message in the <listnername>.log file. I want to find out the reason why it got automatically shutdown and restarted again with different PID.
03-MAR-2013 03:00:57 * ...
3
votes
0answers
270 views
Convert Oracle Query for Date to Mysql queries
Need to convert the following oracle queries to MYSQL queries.
1)
select to_char(to_date(?,'DD-MM-YY'))
from dual;
2)
select to_char(next_day(to_date(?,'DD-MM-YY'),'FRIDAY'))
from dual;
3)
...
3
votes
0answers
124 views
changing Virtual IP interface names on RAC nodes - how to reconfigure
We are adding an extra interface on our nodes and we are going to bond these so the VIP interface will change from eth5 to bond3.
Can someone point on documentation on what to do to reconfigure the ...
2
votes
0answers
39 views
Oracle 10g weird behaviour
We have a thick client application using an Oracle 10g database. We recently upgraded the application and in the process migrated the database tables from a latin to unicode character set.
After the ...
2
votes
0answers
131 views
What do I need to do to avoid ORA-32696 errors?
I have a SELECT query using several WITH blocks. Sometimes it runs successfully. Very often it fails with the error "Lookup Error - Oracle Database Error: ORA-32696: HTI: No free slot". I Googled the ...
2
votes
0answers
247 views
Isssue with Database Links converting OEM Job to DBMS_Scheduler Job
We had an OEM job that would run a PL/SQL block using a particular database users credentials. The credentials are the same for two different databases, so there was no problem for the block to use a ...
1
vote
0answers
29 views
How can I count the total number of document indexed by my oracle.text index?
I know I can use ctx_query.count_hits to count the number of document matching a query,
and similarly, I can use
count(*) where CONTAINS(...)
But these are only options if I actually have a query. ...
1
vote
0answers
73 views
Deleting folders after Oracle upgrade
I upgraded from Oracle 10g to Oracle 11g in Windows Server 2003.
New Oracle home : C:\app\oracle\product\11.2.0\db_1
Old Oracle 10g was installed on: C:\oracle\product\10.2.0\
Questions
Is the ...
1
vote
0answers
110 views
Oracle locked sessions with ASP.Net
I am connecting to an Oracle database in ASP.Net using SQLDataSource. My connection string is:
<add name="ConnectionString3"
connectionString="Data Source=sml; User ID=sml; Password=sml; ...
1
vote
0answers
162 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
206 views
v$logmnr_contents with username as unknown
I applied logminer to find who deleted a lot of rows in one table. View v$logmnr_contents give me details of that operation. Unfortunately, minimum supplemental logging was not active when archived ...
1
vote
0answers
186 views
Timeout on remote query over database link
We are trying to verify if a database link is up before inserting data into a remote database. We have no control over the remote database's behavior and status. We need to set a timeout on a query ...
1
vote
0answers
28 views
What might cause all objects in an Oracle database to suddenly have quoted identifiers?
I have an Oracle schema in which, at some point in the past ("the event"), all of the procedural code objects in the database have been re-created with quoted identifiers. All of the objects are ...
1
vote
0answers
100 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
361 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
270 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
230 views
Find fragmented space free below HWM Oracle
That High Watermark Value always eludes me when calculating free space in my tablespaces.
Will the following query consider fragmented free spaces of object below the HWM value for each TS?
select * ...
0
votes
0answers
55 views
TimesTen performance as compared to 10g
I am new here, so please be nice...
I have a question regarding TimesTen & Oracle. I have attempted an experiment with both pieces of software, and realize that the query speed on a table is ...
0
votes
0answers
175 views
12154 error when using PL/SQL Developer
I have installed a few versions of Oracle on my machine. I have tried 64 bit and 32 bit versions. I have installed 11G. I need Oracle 10G 32 bit.
Using the following guide I removed all versions of ...
0
votes
0answers
50 views
Oracle 10g Login Error
I have installed Oracle 10g on my pc. Now, when I try to login in with Scott/Tiger, system/manager or the Database username/password given while installing Oracle 10g, it gives me "ORA-12560 TNS ...
0
votes
0answers
134 views
Oracle 10gR2 Data Guard Switchover
I need some help! I have a scenario of oracle 10gR2 database replication using data guard. I have selected the data guard command line interface. After my initial setup I can ship and apply logs from ...
0
votes
0answers
448 views
How to detect when did ocurre ORA-00604?
Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged on twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of ...
0
votes
0answers
104 views
How to load XML data into an oracle db table ?
Is there a way to load the XML format data into an Oracle 11g DB table directly ?
I mean, Can we write a Stored Procedure to accomplish the same in a more efficient way with the best performance ?
...
0
votes
0answers
54 views
Upgrading from Oracle 10 to 11g, what to look for in SQL embedded in code?
We're planning to upgrade our enterprise database to 11g.
We have a number of web applications using it via Weblogic and Hibernate 3.6.5, and both of those support 11g.
There are a number of direct ...
0
votes
0answers
63 views
Oracle form 10 g “RUN” Error
I have built a form from the employees table and trying to run it.But nothing is showing except for some text in the web browser with address being my local documents location instead of
...
0
votes
0answers
237 views
Problem in exporting users from oracle database. (Oracle 10g express edition)
I am trying to export the user from database, but its showing
export done in we8mswin1252 character set and al16utf16 nchar character set
But if i am trying to export entire database then its ...
0
votes
0answers
318 views
RMAN Error ( 00601, 03004)
Please help on this RMAN error:
RMAN> backup database plus archivelog;
Starting backup at 08-MAY-12
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=297 devtype=DISK
...
0
votes
0answers
112 views
Merge two packages into one package in Oracle 10g
I want to combine two different packages into one single new package in Oracle 10g. Is there some way to accomplish this?
