Re: standby database question - solved

can u please tell me how to monitor it . TIA Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: !! *Very* important Oracle-L message !!

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: !! *Very* important Oracle-L message !!

://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re: RMAN/NETBACKUP/ORACLE 8.1.6 Configuration Problems

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Backup strategy using RMAN

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: RMAN/NETBACKUP/ORACLE 8.1.6 Configuration Problems

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Kind of cool feature! DBMS_RANDOM

Hi Chris, Pl excuse me for writing directly. I looked up this package and there is no mention of the STRING option at all. Metalink search returned no hits. Could you please send me the location where you got the information from. Thanks in advance Anjan Christopher Spence wrote: In 8.1.6

Re: Kind of cool feature! DBMS_RANDOM

racle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anjan Thakuria Sent: Wednesday, September 05, 2001 5:26 PM To: Multiple recipients of list ORACLE-L Subject: Re: Ki

Re: [Fwd: Re: patch question]

from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Do fast full index scans do physical disk reads?

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: rman question

Yes, That is, you can do both, let RMAN do it for you or apply the logs after restoring them. anjan "Koivu, Lisa" wrote: OK, this may be dumb. I was under the impression that if you use rman to back up your database, you MUST use rman to restore and recover. Is this not true? Is it possible

Re: RMAN

Seema, there are examples in the manual. Anjan Seema Singh wrote: Hi Does any one have RMAN hotbackup script withour catalog? If yes can you please send me. Thanks seema _ Get your FREE download of MSN Explorer at

Re: LISTENER CONFIGURATION?

Seema, It is explained in the manual. Please read it. Anjan Seema Singh wrote: Hi How could configure multiple listener for diffrent database if we have single oracle home? Thanks -Seema _ Get your FREE download of MSN

Re: Connection question?

But were these not both BEQ one in Caps and the other in lower case (BEQ and beq) .. Anjan "Koivu, Lisa" wrote: Hi Harry, I admit ignorance. Networking was never my strong point. IN fact sometimes I wonder if I still have one. Thanks for your response. Lisa -Original Message- From:

Re: Standby Database - Log Shipping

Ron, There is an excellent paper on how to set it up step-by-step for managed recovery (logs applied automatically) on metalink. I like to follow these to start with and read the manual for details. They are 149286.1, 97010.1, 120855.1, 67488.1 etc. to start with. Also consieder dataguard I am

Re: Duplicate DB to different host using RMAN/Veritas Netbackup ...he

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Do not belive BUSH and your army goverment so much

://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

Re: 9i download

Heard one my SA collegue saying that someone has successfully used PC RAM and something else (don't remember) sucessfully. (Now THAT is economical workaround). Anjan Christopher Spence wrote: Very suitable, it is a great machine, just don't plan on getting any upgrades cheap. Memory and DVD are

Extent grab ...

Gurus, Is there any way to fond out the rate of extent grab by a segment from the data dictionary. Thanks in advance. Anjan begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A

Re: Extent grab ...

; the rate of growth. Any help/input will be greatly appreciated. Thanks in advance. Anjan Anjan Thakuria wrote: Gurus, Is there any way to fond out the rate of extent grab by a segment from the data dictionary. Thanks in advance. Anjan begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x

UWIN and Oracle...

Hi Gurus, Any body got any experience using UWIN on NT with oracle. I can't seem to do anything like starting sqlplus, svrmgrl or lsnrctl.. Any hints/suggestions will be most welcome. I am trying out the eval of ver2.9. Thanks Anjan begin:vcard n:Thakuria;Anjan tel;work:817-963-3291

UWIN and Oracle

Hi Gurus, Any body got any experience using UWIN on NT with oracle. I can't seem to do anything like starting sqlplus, svrmgrl or lsnrctl.. Any hints/suggestions will be most welcome. I am trying out the eval of ver2.9. Thanks Anjan begin:vcard n:Thakuria;Anjan tel;work:817-963-3291

Re: UWIN and Oracle

going to the correct directory (cd /C/orant/bin or whatever) and type ./sqlplus or ./svrmgrl . This is assuming version 8 or 8i as there is no svrmgrl in 9i. HTH. Ivan -Original Message- From: Anjan Thakuria [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:24 AM To: Multiple

Re: could anyone please call this number ?

://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re: OT Terrorist Acts

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: recovery of rman

ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: recovery of rman

) Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Tablespace (datafile reducing)

Chris, "Generally more smaller data files is better than fewer larger ones." Can you pl let me know if there is any paper or something throwing light on this. Thanks Anjan Gene Sais wrote: !! Please do not post Off Topic to this List !! Datafile sizing is also dependent on the size of your db. I

Re: RMAN catalog Recreation Problems/Questions ....

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services

Re: How to move a databse from Solaris to Llinux

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Oracle error after recovery

There is a utility in $ORACLE_HOME/bin/ named sysresv which will tell you about the instance. Even after having killed all the processes used by the instance if the shared memory segment is not cleared you might get that error. To find out which shared memory segment I am pasting a portion

inspdver... equivalent in 8i and above...

Listers, I am hoping someone knows the equivalent of inspdver in 8i and above. Can you please let me know. thanks Anjan

Re: Create user identified by externally

Thanks Bill, Will it be something like this /@connect string>.. An example will really help. Anjan. "Chen, Bill" wrote: yes. make sure 'remote_os_auth...' is set to true in your init.ora bounce the db to make this effective. bill -Original Message- From: Feng, Jun [mailto:[EMAIL

Re: Create user identified by externally

Thanks Bill, Will it be something like this /@connect string>.. An example will really help. Anjan. "Chen, Bill" wrote: yes. make sure 'remote_os_auth...' is set to true in your init.ora bounce the db to make this effective. bill -Original Message- From: Feng, Jun [mailto:[EMAIL

Re: Rachel - RE: 2nd DBA or ?

I am impressed by both of you guys. I drive a used 97 Altima Gogala, Mladen wrote: Where exactly are you coming from? Beware because me, my Ford F350 and my faithful pump-action shotgun always have the right of way, $75k car or not -Original Message- From: satar

Re: Oracle Recovery from Cold backup.

the "using backup controlfile" is what is known as a open ended SCN in the command "recover using backup controlfile until cancel;" for recovery and therefore recovers and applies archive logs generated after the timestamp at which it was created. Somethnig similar to a standby controlfile. So

select * from dual;

the other columns stand for .. I am sure a lot of you know.. thanks in advance.. Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Physical access to servers for maintenance

the other columns stand for .. I am sure a lot of you know the answer... thanks in advance.. Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: How to tune treewalk sql statement

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET

STATSPACK snap_id and time generated...

ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

How to query Standby database ...

Hi, We have a standby environment where due to application constraints we have to apply logs based on the application progress. However before I was made responsible the remote archiving was not enabled, and files were transferred through a script. Now to clear the archive dest I need to write a

RE: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed..)

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjan Thakuria INET: [EMAIL

RE: 9i on Redhat9 agent does not start...

to list lib32 directrory first. LIBPATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib Be careful this doesn't break something else. I had to change the LIBPATH just for the start and stop and then change it back right away. LeRoy Anjan Thakuria wrote: Gurus,Would appreciate any help

RE: 9i on Redhat9 agent does not start...

variables are useful for 8.1.7 installations and are not for 9i installations ) L. Anjan Thakuria wrote: LeRoy,Thanks for responding...One question though.. I didn't see a $ORACLE_HOME/lib32 dir under $ORACLE_HOME...don't what to do...Anjan -Original

RE: 9i on Redhat9 agent does not start...

= $ORACLE_HOME/lib LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib Maybe oracle is looking for 64 bit library files! Julio -Original Message-From: Anjan Thakuria [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 3:05 PMTo: Multiple recipients of list ORACLE

RE: 9i on Redhat9 agent does not start...

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjan Thakuria INET: [EMAIL

RE: Seven Deadly Sins in Oracle?

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Outsourcing's dirty secret

Title: Message Thank you Jared. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, November 03, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Outsourcing's dirty secretThis is not