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.
110
questions
0
votes
0
answers
25
views
What determines FILE Permissions: Oracle or UNIX?
Oracle 10g
Consider an Oracle Directory 'FOOBIZ'.
Record for FOOBIZ In ALL_TAB_PRIVS is as follows:
Grantor Grantee Schema Table_Name Privlege Type
USER ADMIN SYS FOOBIZ EXECUTE ...
0
votes
1
answer
158
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
95
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
137
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 ...
0
votes
1
answer
115
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 ...
-1
votes
1
answer
361
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 ...
1
vote
0
answers
99
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
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 ...
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 ...
2
votes
2
answers
349
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 ...
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 ...
1
vote
2
answers
798
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
0
answers
780
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
2
answers
1k
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 ...