Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle10g** are assumed to be specific to this version or features introduced in this version.

learn more… | top users | synonyms

-2
votes
0answers
12 views

how to take backup from one platform to another in Oracle [closed]

I am new in oracle and trying to learn different task. I have installed Oracle 10g R2 in Linux platform. i want to take an Online backup through RMAN in Windows platform. What should i do for this ...
0
votes
0answers
250 views

ORACLE Forms app throws error: “Failed to open file: ifrun60_dump_” on terminal server

Scenario We have an ORACLE Forms client application deployed on multiple Windows clients and one Microsoft Terminal Services server. The application has scarce documentation and largely inefficient ...
0
votes
0answers
24 views

Export data from Oracle Lite 10gR1 odb file

I hope you can help me with this one. Years ago (2005) someone way before me set up a server with WinXP and a custom-written Java/Tomcat-whatever application for monitoring some sensors, the database ...
0
votes
1answer
1k views

Weblogic intensive CPU usage

I am using Weblogic 10.3.4 + Oracle DB both on Solaris machines (VM) Unfortunately last week our app hosted on Weblogic became very very slow not being able to serve new users coming (everything ...
0
votes
1answer
138 views

how to see queries to oracle database

the database in question is Oracle 10g Enterprise software the tools available are Toad, SQL Developer, and other built in oracle tools I have an application server within the network, alongside the ...
2
votes
2answers
202 views

Oracle (xe) 10 vs 11 . Have I lost the SQL tuning pages ? Am I going out of my mind?

Ok .. so perhaps the title needs calming down a bit. Basically I am after the XE 11g equivalent of the pages that you can see here, in which you can then navigate to stuff like "top 50 queries" and ...
1
vote
1answer
769 views

How to export database from Oracle 10g

I'd like to export database with all the triggers, indexes, grants and user accounts from Oracle 10g database. Problem is I only have SYSDBA access to the server, so I can't access the servers files ...
0
votes
1answer
170 views

Oracle error when logging into database

When I try to log into my db with a specific user I get this message. Below is from the alert log. I can login as system just fine. Anyone know how to figure out what is causing this? Thanks in ...
1
vote
2answers
334 views

How to change Port Number Of Http Server in either Oracle10g or tomcat?

I am looking to run Apache tomcat and oracle10g... both are on port 8080 how to change port of any of them?
1
vote
0answers
281 views

migrate 10g xe to 11g xe

The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
0
votes
1answer
619 views

Oracle 10g queries very slow and CPU usage very high after applying patch

So I recently updated an Oracle Database 10g from 10.2.0.3.0 to 10.2.0.4.0, as advised by Oracle Support, due to stability issues (a known issue under some systems where the instance would freeze ...
2
votes
3answers
276 views

Change local admin password. Impacts on Oracle and Citrix?

I need to change the local admin password on some Citrix and Oracle servers. These servers are in production. Then we will start using a secure password procedure, and change them every X month. ...
2
votes
2answers
8k views

oracle lsnrctl TNS-12545: Connect failed because target host or object does not exist

I am trying to connect to my oracle database. I can't get the listener started. Here is what I have tried. $ lsnrctl start LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 ...
0
votes
1answer
182 views

Where to create directory for importing over network link?

While using data pump import over network link in Oracle: impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT directory=TEST_DIR remap_schema=SCOTT:TEST Where are we creating ...
0
votes
1answer
108 views

oci.dll is not linked

I have an application developed in Delphi 5 accessing Oracle 10g and I´m getting the error OCI.DLL IS NOT LINKED when I try to save data in database. My ODAC version is 6.50 and I'm running the ...
1
vote
0answers
41 views

How to open a standby database (Oracle)

First, let me state that I am not a DBA nor am I a systems guy; I'm a software developer. At work, we recently built a new virtualized db server by cloning our disaster recovery (DR) database server. ...
2
votes
1answer
295 views

DBMS_ALERT slow to trigger on RAC

I asked a question earlier about whether DBMS_ALERT works on the RAC. The answer was yes, and I have set up a VMWare test environment and confirmed it. However, there seems to be a long delay ...
2
votes
1answer
86 views

How can I tell how my oracle databases configurations' differ?

I have two databases with the same data, running on the same physical server. They are performing differently (one is twice as fast as the other). I've compared the Initialization Parameters and ...
2
votes
0answers
46 views

Equivalent of SQL Server trace for Oracle 10g?

I've got a bad code duplication problem where we cannot tell which versions of packages/procedures are being used. i.e. I have different packages with procedures of the same name and I need to be ...
4
votes
1answer
110 views

Are there any performance differences between Oracle Entreprise and Oracle Standard editions?

Someone has asserted to me that the reason why one database is performing better than another (50-100%) is because one has Enterprise Edition and the other has Standard Edition. Given the same ...
0
votes
1answer
162 views

Group policy define new services with install them in main server

I have Active Directory with Windows Server 2003 64-bit. One of my users asked me if it is possible if he can start and stop Oracle and MYSQL services from start --> control panel --> services. From ...
1
vote
2answers
1k views

Oracle Data Pump - export from Enterprise Edition to Standard Edition

I am migrating from an Enterprise Edition of Oracle 10g to a Standard Edition of Oracle 10g and I was wondering if anyone has experience doing this. I've searched around and I can't really find a ...
0
votes
0answers
1k views

Oracle Express services not starting

today I tried to install Oracle Express 10g on Windows 7 64bit (and 11g also). Unfortunately I ran into some problems. First of all, I noticed that the home page is not being loaded. Then I checked ...
1
vote
1answer
175 views

how to find foreign keys constraints?

I have a table called abs with primary key absId, this is used as a foreign key in couple of tables which I don't know. Is there a way that I can find out how find the names of those tables in which ...
0
votes
1answer
104 views

ODSI + weblogic = JDBC problem

I'm currently developing a web service using ODSI through Oracle Workshop for WebLogic (ex AquaLogic). I created a datasource on weblogic using the driver "Oracle thin driver 10g", the test succeed on ...
1
vote
1answer
2k views

Connecting Oracle XE DB / Oracle Database 10g Express

I started with Oracle DB. On Windows Server 2003 I installed Oracle Database 10g Express Edition and then I also installed PL SQL Developer. I tried log on via PL SQL Developer to XE database. I use ...
1
vote
2answers
132 views

How to connect an Oracle server between two countries and maintain high speeds for read & write

Our company has two branches, one in Malaysia and the other one in India. The problems occur when we try to share one of our Oracle environments to our branch in India; the connection is very slow, ...
0
votes
1answer
369 views

Oracle 10g Failover Database - How to fail back?

I want to know how the failover database concept works after recovery. We have defined our application to connect to a backup database in case the production database fails. If this happens, then all ...
0
votes
1answer
130 views

Installing Oracle 10g on Panasas PAS12 (NAS)

We are using Panasas PAS12 (running in pNFS protocol) internally in our team, and are currently thinking of migrating our Oracle 10g in it. We have two sides among ourselves. On one hand, Oracle 10g ...
5
votes
1answer
211 views

How to prevent remote login for SYS

Is it possible to prevent the remote logins for the SYS user? Oracle 10g.
1
vote
1answer
370 views

Oracle Internet Directory implementation questions?

I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using various Oracle DB versions 9i up to v11, usually I send email for all of the users to manually copy and update the ...
3
votes
2answers
1k views

How to diagnose frequent “500 Internal Server Error” on Oracle Apex

I have an Oracle 10g XE database running on OEL 5 on an Amazon EC2 instance. On it I run a public website (actually, 2 web sites) written in Oracle Application Express 4.0.1. Most of the year, the ...
2
votes
1answer
2k views

what is causing oracle archive log files to be growing fast

in the last few days our Oracle DB has been generating a large amount of archive log files. How would I find out what DML activity has been causing such a spike in log file generation?
0
votes
1answer
540 views

problem in run oracle server please help

I used Oracle 11g, from few days ago I face below error: SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: ...
1
vote
3answers
796 views

no suitable image found when installing Oracle on Mac OSX

I'm installing Oracle Database 10g Release 2 (10.2.0.4) for MAC OS X on Intel x86-64 I have Mac OS X 10.6.7, running at Intel Mac. When I start installing, I am faced to the following error: ...
0
votes
1answer
1k views

import XML to Oracle 10g

What would be the fastest, easy, and quickest way to import an xml data to a database table in Oracle 10g database? What tool should I use (if possible free)? The XML will look like this: <?xml ...
1
vote
1answer
180 views

How to query Oracle from SQL Server?

I'm having difficulties in creating a connection from my SQL Server 2008 Enterprise SP2 x64 into the Oracle database 10g even though I have already install the Oracle Client 11g R2 ? I've followed ...
0
votes
1answer
125 views

oracle sql developer and sql server

What should I input the connection name there? I have a database called Stack Overflow... I tried the hostname as localhost and it didn't work
2
votes
1answer
3k views

how modify username in oracle

I create a username in oracle that has spelling mistake, I want to modify it now but I am not successful. would you please help me how I can modify my username in all_users table? I use oracle 9.
0
votes
4answers
810 views

Oracle 10g to SQL server 2008/ migration

We have a reasonably heavy Oracle 10G database (~ 120 GB space occupied). The database consists of tables, packages, materialized views, procedures etc. We are planning to decommission Oracle and ...
1
vote
1answer
368 views

Oracle 10gR2 RMAN: Channel allocation

Oracle 10gR2, Win2003. I know enough about RMAN to perform basic functions. I'm trying to learn more. We have an RMAN backup process that is used to duplicate a database nightly. The backup is ...
1
vote
1answer
622 views

GWT - Oracle JDBC Connection problems

I am having great difficulty making a connection to an Oracle Database OJDBC. I´m using Google Web Toolkit and i added a SQL Database to my project. The Database name is Agenda. I've searched a lot, ...
0
votes
2answers
4k views

Oracle 11g: Why doesn't “grant create session” allow user to log in?

I'm working on an Oracle 11g database, and simply need to create a user and log in with it. I successfully create the user, but after running the second line below, I still can't log in. Is there ...
0
votes
1answer
474 views

Problem with binding php 5 on Apache 2 on Windows 7 to Oracle 10

I'm tring to use oci_connect() function, but get error: PHP Fatal error: Call to undefined function oci_connect() in ... I unzipped Instant Client to "C:\instantclient_11_2" and updated system ...
1
vote
1answer
1k views

After applying archive log in oracle, what time is it now?

I have restored the database and applied the archive log. How can I tell the latest transaction timestamp I have recovered to? This is oracle 10g R2 standard (no flashback enable)
0
votes
2answers
837 views

Convert an Oracle 10g RAC database to single instance

In an attempt to reduce the complexity of a solution, I've been asked to convert a two node Oracle 10g RAC production database to single instance. The database is running on RHEL5 with ASM on SAN. I ...
0
votes
3answers
4k views

How to move Oracle database to another PC without restoring backup?

Take this scenario: Suppose the customer has no backup of Oracle 9i or 10g database. The customer wants to move the database from one PC to another. The other PC has a fresh installation of Oracle. ...
0
votes
1answer
150 views

Cannot install Oracle Application server

After succesfull installation of database 10g server, I cannot run install file for application server - it closed unexpectly. How can be problem investigated? Log file contains: Checking installer ...
2
votes
1answer
579 views

Is there a way to easily run the same query in Toad against multiple Oracle database servers?

I have several servers hosting data for the same application, and I want to see the results of the same query from different servers.
1
vote
0answers
102 views

Oracle 10g Release 1 on Windows Server 2003 R2

Is Oracle 10g R1 supported on Windows Server 2003 R2? And if it isn't is it known to run without issue?