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
14
votes
4
answers
198k
views
Oracle: how to find out storage space used by a table?
How to find out (if possible via Enterprise Manager), the total in Mb that a certain table is using?
- 259
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://...
- 1,343
8
votes
4
answers
39k
views
ORA-12705: Cannot access NLS data files or invalid environment specified
I am getting this error while trying to create a connection pool, on my Oracle database, Oracle 10gR2.
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot ...
- 337
8
votes
4
answers
140k
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 ...
- 714
8
votes
2
answers
7k
views
Oracle 10g for Windows does not start up on system boot
We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to ...
- 261
4
votes
3
answers
7k
views
How can I find my Oracle 10g server version?
I don't have physical access to my Oracle server but I can run some sql command from Toad. Is there a way I can find wich version the server is running, like 10.2.3.1. I know it's 10g but I'd like to ...
- 191
4
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.
- 141
4
votes
1
answer
1k
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,866
4
votes
2
answers
48k
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:...
- 644
3
votes
1
answer
3k
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.
- 375
3
votes
2
answers
8k
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
5k
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
2
votes
5
answers
5k
views
SMON process in infinite loop in Oracle database instance...help!
My team and I have Googled (and Binged!) our guts out trying to find an answer to this issue, so hopefully the Oracle gurus on SF will know the answer.
A week ago we had a power outage in the ...
- 243
2
votes
4
answers
6k
views
Oracle 10 g - Unable to free up space in tablespace
The tablespace in Oracle 10g is almost 100% used.
Size (MB) = 571,768.0
Used (MB) = 571,534.0
I just deleted (and committed) thousands of records in a table that belongs to a schema associated with ...
- 259
2
votes
4
answers
611
views
Oracle Logical Standby redo generation
Oracle 10.2.0.4 database with a logical standby on Win2K3. Recently a rather large delete operation was carried out on the production instance. I'm experiencing difficulty with the logical standby, in ...
- 2,098
2
votes
2
answers
348
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 "...
2
votes
1
answer
8k
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
2
votes
1
answer
247
views
How do you profile an Oracle database?
What I would like to do is capture all the selects executing against a production Oracle database with all the parameters used for a period of time.
I would then rerun all the captured statements ...
- 161
2
votes
2
answers
33k
views
Oracle throwing this error: could not open registry key SOFTWARE\Oracle\ocr
I have an oracle installation that runs fine 95% percent of the time. But for some reason every day at a random time early in the morning (between 4:00am and 9:00am) I get the following error:
[ ...
- 197
2
votes
3
answers
4k
views
How do you clone an oracle instance?
How do you clone an oracle instance? Basically, I want to end up copying it from d:\oracle\oldname to d:\oracle\newname.
I'm working with Oracle 10.2.
- 1,866
2
votes
3
answers
827
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 ...
- 1,219
2
votes
1
answer
2k
views
Oracle Account Not Responding
I have an Oracle instance which has user1, user2 and user3 accounts. Yesterday I was able to log in to all three accounts. Today, I can get in to user1 and user3, but user2 is completely 'frozen' in ...
- 505
2
votes
3
answers
376
views
2
votes
3
answers
458
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
2
votes
3
answers
205
views
Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment?
Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment? From an IT professional position, why would I not allow Oracle XE and MSSQL2005 to run on the same ...
- 141
2
votes
1
answer
1k
views
Oracle DB import error
I get the error below when importing a database - any ideas why? I do this type of import all the time and I've never seen this error.
Prior to doing the import we drop all objects in the schema. ...
- 141
2
votes
1
answer
1k
views
Documentation on the SQL execution plan page in Oracle Enterprise Manager (Oracle 10g)
In Oracle Enterprise Manager, in "Performance > Top Activity", you can click a SQL that is being executed and then go to the Plan tab to see SQL execution plan.
For the execution plan, the Enterprise ...
- 259
2
votes
1
answer
295
views
Non-intrusive stored-procedure auditing on Orace 10g
I'm working in a environment where there are a large variety of legacy client programs. I'm trying to get an idea of which programs use what stored procedures. Is there a way to audit access to a ...
2
votes
1
answer
1k
views
Oracle 10g on Snow Leopard?
I have found a couple of pages on how to get this configured on Leopard (link and link), and then apparently an upgrade to Snow Leopard does not seem to complicate matters much. However, I'm already ...
- 141
2
votes
2
answers
7k
views
Commvault Oracle RMAN Restore to new host
We use Commvault Simpana 8 and I have a situation where I have backups of an Oracle database on tape that were taken from Host A. Host A suffered a disk failure (lost its raid configuration) and the ...
- 151
2
votes
0
answers
116
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
2
votes
1
answer
642
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
2
votes
1
answer
588
views
Opening an oracle database crashes the service
I am experiencing a weird issue with Oracle where the service started fine after a crash. The database mount went fine as well. However, when I issue alter database open; command, the database does ...
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 ...
user10921
1
vote
2
answers
29k
views
How to find out the current SGA memory distribution?
How can I get the current SGA memory distribution on Oracle 10G?
Something like this:
AME SIZE_MB RES
-------------------------------- ---------- ---
Maximum SGA Size ...
- 113
1
vote
2
answers
6k
views
Oracle ARCxxxxx_xxxxxxxxxx.001 Files on Windows Server
I have a database server that supports a single application. Sadly much of the configuration of this box is strictly controlled by the vendor. So in the event we change things they may discontinue ...
- 2,845
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....
- 720
1
vote
4
answers
10k
views
Running Oracle 10g and 11g side-by-side
I recently tried installing Oracle 11g on a server already running 10g. Each would run independently with no problem, but 10g refused to run simultaneously with 11g. Can this be done? I don't need a ...
- 723
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 ...
- 1,540
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
- 337
1
vote
2
answers
789
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
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
1
vote
2
answers
189
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
1
vote
1
answer
531
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
3
answers
383
views
Easy way to wipe a set of Oracle schemas
How can you wipe a set of Oracle schemas?
By wipe I mean remove all data, tables, views, procedures, synonyms, etc, etc.
- 141
1
vote
2
answers
13k
views
Starting SQLPlus in linux
How do you start sqlplus in linux? I know this is a service in windows.
- 160
1
vote
5
answers
7k
views
Open source scripts for Oracle health check?
I want to put together some scripts to run an automated health check of Oracle 9i and 10g databases. Before I start from scratch, I was wondering if anyone know of any available open source scripts ...
- 4,396
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 ...
- 4,477
1
vote
1
answer
111
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,866
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