Oracle
in [SQL]
|
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
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
ORA-1113 signalled during: alter database open I was hasty and I did a cold backup incorrectly, I believe. I shut the database down and backed up only the data files for one (out of 4 tablespaces). I started Oracle and proceeded to work on all 4 tablespaces. Today I needed to quickly roll back the tablespace I "backed up", so I stopped Oracle and pasted th... 17 Jun 2005 19:49
Error messages not displayed Hello all, I get the following errors when I run tnsping (and lsnrctl) #tnsping orcldb TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 13-JUN-2005 07:30:20 Copyright (c) 1997, 2003, Oracle. All rights reserved. Message 3511 not found; No message file for product=network, facility=TNST... 14 Jun 2005 10:16
ORA-00054 Question Howdy, We are trying to run some scripts to give us some detail and stats on our indexes. Whenever we run the script though, we get: ORA-00054: resource busy and acquire with NOWAIT specified Is there no way to tell Oracle to re-try or to wait n seconds before retrying?? Thanks, Arthur ... 17 Jun 2005 14:30
OracleStartORCL(STRTDB73.EXE) error at Windows XP / Windows 2003 When I Use Windows(xp/2003) service to start OracleStartORCL (Oracle Database Server 7.3.4.x service starter) I have recently "Oracle Service Controller Error"! ----------------------------------------------------------------------- szAppName : STRTDB73.EXE szAppVer : 7.0.0.0 szModName : unknown szModVer :... 11 Jun 2005 00:57
parallel and append hint in insert statement I have a statement as below: INSERT /*+ APPEND */ INTO emp SELECT /*+ PARALLEL (temp_emp, 4) */ FROM temp_emp As you can see, SELECT is set to perform in 4 processes. Will the insert also be executed by 4 parallel processes without the explicit PARALLEL hint in the insert clause, since the select is done in ... 22 Apr 2005 15:20
Resolved ORA-27302 error, but how to fix? Hi, I have Oracle 9i running on a Solaris 9 system. Yesterday, when trying to startup one of the database instances using OEM, I was getting an ORA-27302 error (along with some others). There was also an ORA-27301 error among them. I tried to diagnose the problem, checking disk space, etc., but that looked ... 25 Feb 2005 16:51
Installing Oracle client over existing database Hi, I have Oracle 9i server installed on a machine. For some reason, the Oracle client has gotten messed up. Can I reinstall the client on the same machine? Will it affect the existing database on that machine? Do i have to select the same oracle home or a new one? Thanks, Kirtan ... 24 Feb 2005 10:06
Oracle 10g Installation Hello Friends, Having a linux box running Red Hat Enterprise ES version 3 for AMD64/EMT64. Hardware is Dell PowerEdge 2850 with two Xeon 3GHz processors (supporting EMT64). Upon installing Linux x86-64, netca and dbca failed. As advised, I made sure that my IP is static (looking at the ifcgf-eth0 files BOOTPRO... 14 Feb 2005 19:18 |