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
1
vote
3
answers
4k
views
Oracle 10g: backup failed, log disk full - how do I recover the database?
Because of failed backups, the disk used for transaction logs appears to be full.
The database is not accepting connections, so I cannot run the (HP Data Protector) backup job manually.
The Oracle ...
0
votes
1
answer
108
views
Is there any way to configure Oracle without Java support?
I've got an Oracle installation that I'm using on my Windows XP workstation to run tests against. I'm not using Oracle's Java support; is there any way to disable it? Or is that a good idea?
My ...
1
vote
10
answers
5k
views
What is the best OS platform for Oracle 10g? [closed]
I want to know the best choices for OS to run Oracle 11g on my sand box.
Also, I would like to know good combination for Dev environments in 50-100 user environments.
Any other information about ...
8
votes
4
answers
142k
views
How to restore/import an Oracle database from dmp file?
I've recently received the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now I need to restore the original database.
Can anyone give me a step by step procedure ...
1
vote
1
answer
1k
views
Oracle RAC: Configure instance to depend on VIP
In previous version of Oracle RAC with Oracle clusterware, before 10.0.1 I believe, an instance was dependent on a VIP resource. Once a vip was failed or relocated, the Instance would be stopped.
In ...
1
vote
2
answers
5k
views
Find Current open Cursors in Oracle
What is the query to find the no. of current open cursors in an Oracle Instance?
Also, what is the accuracy/update frequency of this data?
I am using Oracle 10gR2
1
vote
2
answers
3k
views
"Create global objects" rights on a terminal server
Talking about this security setting: link text
We have been having problems with the oracle 10g client on our Citrix servers. Through google I figured out that granting users this security right ...
14
votes
6
answers
25k
views
How can I diff two Oracle 10g Schemas?
I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article (http://...
2
votes
3
answers
829
views
How can I install Oracle on my Windows XP machine which uses DHCP?
I'm installing a copy of Oracle on my development workstation because running tests against a remote database is terribly slow. However, it says something about me having to set the loopback adapter ...