Oracle
in [SQL]
|
ORA-27100 after altering the SGA_MAX_SIZE Hi all, After issuing the following command ALTER SYSTEM SET sga_max_size='2097152000'scope=SPFILE and restarting the server. Oracle does not seem to start up correctly. I then attempt E:\oracle\product\10.1.0>sqlplus /nolog SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 20 09:36:57 2005 Copyrigh... 21 Jul 2005 05:21
AIX server running out of paging space on 7/12 I put our test database on our production server, so we have two databases running on the server. This is only temporary. We had no problems all week until sometime Saturday night or early Sunday morning the machine ran out of paging space it seems. The machine was not responding to any command. I ended... 20 Jul 2005 03:34
install Partitioning option in Oracle 9.2.0.6? Hello all, When I import a dump-file I get the error: "IMP-00003: ORACLE error 439 encountered ORA-00439: feature not enabled: Partitioning" The Database does not have partitioning so I want to install this option. Is that possible? (and how) (I do have the license for this option) Thanks, Anneke T... 6 Jul 2005 13:06
Oracle 10 RAC to 10G RAC standby Hi Everyone, I have trying to setup a 10G RAC to 10G RAC physical standby dataguard configuration and then put it iunder grid control as you cannot create a physical standby RAC database in the Grid Control. I have looked at the Oracle manuals, all the dataguard and dataguard broker 10g manuals, the high av... 3 Jul 2005 11:12
Basic Question Oracle 10g manually startup sequence, Win XP SP 2 Hello I've installed Oracle10g without any problems and the database server is running. After shutting down Win XP and starting up the OS Oracle 10g and listener process is running. After shutting down the Oracle service and the listener service manually I wanted to start the Instance manually . this is ... 1 Jul 2005 18:55
library cache load lock - major problems Morning all (or afternoon - I'm behind another firewall and using Google !) Oracle enterprise : 8.1.7.3 (there's nothing I can do about this I'm afraid !) HP-UX 11.11 8 CPUs and load average is 0.5 over 45 days. Sessions hang on library cache load lock, all are executing the same sql statement which makes ... 1 Jul 2005 20:02
oracle 9i installation problem Hi, I am trying to install oracle 9i on windows xp professional. I downloaded the software in the form of 3 disks from oracle website. When i click on setup.exe, i am getting the following error: java virtual machine launcher Could not find main class. Program will exit. ... 28 Jun 2005 17:05
10053 Trace File anomolies Oracle 9.2.0.6 EE on Win2K Adv Server SP3 I have an SQL statement which runs in 2/3 seconds in one database and over 30 minutes in another environment. I have narrowed the problem down to the optimizer choosing 2 totally different plans between these 2 databases. It appears that the slow database is not sele... 30 Jun 2005 06:34
Lock Deleting Hi, my IDE has crashed while debugging a PL/SQL Procedure. After some fixes I want to replace the procedure now, but there is a lock on the provedure that prevent me from replacing ORA-04021: timeout occurred while waiting to lock object PRC_AUTOVAL How can I get rid of the lock? Thanks Patrick ... 27 Jun 2005 05:00 |