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.

Filter by
Sorted by
Tagged with
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 ...
nray's user avatar
  • 1,540
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 ...
Jason Baker's user avatar
  • 1,219
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 ...
user avatar
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 ...
Paul's user avatar
  • 714
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 ...
katriel's user avatar
  • 4,477
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
M.N's user avatar
  • 337
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 ...
Adam Towne's user avatar
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://...
Stuart Woodward's user avatar
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 ...
Jason Baker's user avatar
  • 1,219

1 2
3