Questions tagged [oracle10g]
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.
109 questions
0 votes
1 answer
208 views
Dockerfile Works Locally But Fails on EB (Elastic Beanstalk) Deploy (PHP 7.3 with OCI8 extension)
Good day, fellow developers! I have been searching for 2 weeks now on how to install the OCI8 PHP extension on Elastic Beanstalk using .ebextensions but sadly I can't search for similar ones. Before I ...
0 votes
1 answer
120 views
Oracle 10g - Differences between iSQL*Plus and SQLDeveloper
When I run this script on ISQL*Plus everything works fine but then if I try to run this on SQLDeveloper Tiempo1 and Tiempo2 are null, any idea why is this happening? truncate table a; call ...
2 votes
0 answers
152 views
When I ssh to my oracle server, the CPU load reduces
I am facing strange issue on an Oracle server. The server is on high CPU load everyday for around 5hrs. This starts everyday at around 03:46 AM and continues for next 5 hrs. CPU load reduces ...
- 21
0 votes
1 answer
123 views
DataSet.Fill slower after upgrading to oracle 11g
We have migrated from an oracle 10g to an oracle 11g Database. The instance of Database 11g is totally new an installed on a VirtualMachine in a different HW. The new DB is on Windows Server 2013 ...
- 133
-1 votes
1 answer
376 views
How to connect to an Oracle 10g database on the host computer from Ubuntu installed in VMware? [closed]
I have Oracle 10g installed in my host system which is running on Windows 7. I have also installed Ubuntu in the same system using VMware. Now I have written some program in Ubuntu which needs to ...
- 109
1 vote
0 answers
110 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 ...
- 11
0 votes
1 answer
9k 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 ...
- 255
0 votes
2 answers
1k 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 ...
- 117
2 votes
2 answers
367 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
1 answer
2k 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 ...
- 13
0 votes
1 answer
1k 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 ...
- 11
1 vote
2 answers
828 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?
Harshil Shah
1 vote
0 answers
801 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 ...
- 183
0 votes
2 answers
2k 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 ...
- 11
2 votes
3 answers
481 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. ...
- 81
4 votes
2 answers
49k 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 08:19:58 ...
- 664
0 votes
1 answer
522 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 ...
- 101
0 votes
1 answer
280 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
0 answers
69 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. ...
- 133
2 votes
1 answer
707 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 ...
- 21
1 vote
1 answer
131 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 ...
- 1,906
1 vote
0 answers
75 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 ...
- 375
4 votes
1 answer
2k 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 ...
- 1,906
0 votes
1 answer
518 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 ...
- 133
0 votes
2 answers
4k 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 ...
- 103
1 vote
1 answer
1k 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 ...
- 455
0 votes
1 answer
174 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
1 answer
4k 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 ...
- 121
1 vote
2 answers
216 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, ...
- 143
0 votes
1 answer
681 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 ...
- 1
0 votes
1 answer
165 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 ...
- 103
3 votes
1 answer
2k views
How to prevent remote login for SYS
Is it possible to prevent the remote logins for the SYS user? Oracle 10g.
- 131
1 vote
1 answer
551 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 TNSNAMES....
- 1,335
3 votes
2 answers
9k 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 ...
- 168
3 votes
1 answer
6k 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?
- 133
-1 votes
1 answer
773 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: ...
- 143
1 vote
3 answers
2k 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: java....
- 760
0 votes
1 answer
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 ...
- 377
1 vote
1 answer
287 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 ...
- 1,335
0 votes
1 answer
328 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
- 377
2 votes
1 answer
9k 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.
- 143
0 votes
4 answers
1k 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 ...
- 143
1 vote
1 answer
655 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 ...
- 2,098
1 vote
1 answer
1k 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, ...
- 111
0 votes
2 answers
10k 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 ...
- 103
0 votes
1 answer
1k 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 PATH. ...
- 179
1 vote
1 answer
3k 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)
- 238
0 votes
2 answers
2k 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 ...
- 4,586
0 votes
3 answers
9k 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. ...
- 215
0 votes
1 answer
217 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 ...
- 131