 | | | Oracle List | | Hello
Does anybody have installed dataprotector agent for oracle?
we have a problem we installed dataprotector agent in the 2003 server
running oracle and Rman cannot see the library we are settinfull production (and with suse linux its actually part of the standard
release)
On 31/07/07 Kerber Andrew W. <Andrew.Kerber@(protected) > wrote
>
>
> I have been doing some personal experimentation usiMost likely from the rebuild. I would have to look at the explain plan
to be sure but most likely its trying to read the index that is being
rebuilt. It 's a known issue you might try to rebuild onall
i have 10.2.0.1 on HP-UX and DSS type application
sga 10g
pga 12g
real memory 32g
i found on AWR
session pga memory 1 847 738 288 64 196.78 485 991.13
session pga memory maI know this subject has been beaten to death pretty well already but I
just recalled a good resource that I don 't think has been mentioned yet
in this discussion - the Oracle Software Investment GuidI 've got to upgrade Oracle 9206 to 10g on LINUX. Has anybody run into
anything unusual when doing a similar upgrade on Linux?
Hi Bill my take which may resonate with you is to treat it like
Windows Firewall - either disable- or learn. Its there as a security
measure - you may not need it.
On 30/07/07 William Wagman <wjwaHas anyone found a way to use compression with data pump like so many of
us did with export/import?
While a "set " may compress nicely you still need "full size " to
uncompress and import.
Have we Check thread Oracle monitoring with visual eye candy at
http //www.freelists.org/archives/oracle-l/04-2007/threads.html
Gints Plivna
http //www.gplivna.eu
2007/7/30 Oliver aka v1k1ng0 <ofabelo@(protected)Adi
Where are you getting the SQL statements? What Oracle version?
Dennis Williams
<div >Adi </div >
<div > </div >
<div >Where are you getting the SQL statements? What Oracle version? </div >
<div >Hello
Does anybody have installed dataprotector agent for oracle?
we have a problem Rman cannot see the library we are setting the variable
sbt_library c \windows\system32\orasbt.dll and the
traceHi Listers
I am working with a 2-node RAC system and we are thinking about using Data Guard 's physical database feature for DR Do you know if we can use a single instance physical Standby dataPer Metalink note 443617.1 you may be missing an OS package such as
libXp. Double-check the required packages and install the required ones
that are missing.
Bob Stauffer
DBA
D&E CommunicaI 've a question for streams folks that have used data filtering during
capture. We are using a downstream configuration and the logs from the
source (living on a different host) are shipped and registGene
You need 'ALTER USER ' privilege to do this.
SQL > create user nondba identified by nondba
User created.
SQL > grant connect to nondba
Grant succeeded.
SQL > conn nondba/nondba
Connected.
SQyou may use dbms_metadata package to get ddl for indexes in question...
Prem Khanna J wrote
Friends
I want to drop/create all indexes of a schema. This is on 10.2.0.2/AIX5.3L .
Thought I don 't w Hello
someone has configured oracle snmp on aix succesfully? I have a problem when
I try run "./start_peer -a " like root it shows
master_peer.out --- > Error Incorrect arguments.
encap_peer.out -To the OP
You need to remember that the EVENT column in V$SESSION_WAIT records the
*last* instrumented wait - executing on CPU is NOT waiting. In other words
if a session performed a 'db file sequeHey man! It wasn 't meant to be like that. Go ahead and post it - I
promised to keep the BAAG dog locked. -)
On 7/27/07 Don Seiler <don@(protected) > wrote
> Yeah sorry about that. Ever since the forYou can consider placing 3rd voting disk to NFS if it 's available.
You can actually run cluster with two voting disks but reliability of
this solution is lower than with one. )
Regarding ASM mirroriI guess I should ask is there a reason you found to suggest you cant do
it
As this is part of core architecture for supporting some requirements
for Data Guard and streams I dont see why it woulAnant
What are you trying to determine? The users who have objects stored in that
tablespace?
select distinct owner from dba_tables where tablespace_name ' <TS_NAME > '
Also check for indexes and Is there a way you know of to take a literal like *1*8*1 and turn it
into the result of 1 times 8 times 1 (8)? I 'm trying to do this in a
connect by prior sql inside a stored procedure.
I 'm using thSo which one performs better?
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Wolfgang Breitling
Sent Thursday July 26 2007 6 2Hello all!
I am configuring a new AIX 5.3 machine for an oracle database 9.2.0.8
The file systems are JFS2 with the blocksize of 4K which matches our db
block size.
I would like to implement ConcHi
I am trying to configure cman with version 10 host server to enable connecting to a target 8i database. Is this OK? Has anyone tried it? What would be the value to be given for remote_listener9204 9205 9206 to be upgraded to 9208 or 8207 and 10201 need to be
patched and upgraded to 10203 or 10202 to apply CUPs....is that correct?any
comments?
9204 9205 9206 to be upgraded to 9208 or I checked our CENTOS 4.5 server /var/log/messages and
found almost every second have message in it. This
server just setup ORACLE 10GR2 RAC and OCFS2 file
system.
Can anyone tell me where is messaThe listener can be run from any home.
The separation between ASM and DB homes gives you more flexibility in
patch management.
I imagine that upgrading ASM to more current patchset than DB is
easierPeter
One thing to consider is upgrades. In the future you 'll have upgrades of
H/W O.S. Oracle and applications. Often it is difficult to properly test
upgrades when a server is shared.
Dennis |
|
|
