date:20020917


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?


regards,
Karthik 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

TSOUG meeting

2002-09-17 Thread April Wells


TriState Oracle User Group First Meeting
DateLocation
Thursday September 26, 2002  5:30 PM1200 Ross St  Amarillo Texas 79102

Tentative Schedule  
5:30Registration
5:45Welcome 
6:00Lester Wells, Oracle 9ias   
7:00Computer Associates 



Please email me if you are interested in attending.


April Wells
Oracle DBA 
Corporate Systems
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out.  _Anonymous



begin 666 InterScan_Disclaimer.txt
M0U-502 R,# R.B @26UA9VEN92!T:4@4]SVEB:6QI=EER$-D-OG!O
MF%T92!37-T96US($%N;G5A;!5V5RR!!W-O8VEA=EO;B!#;VYF97)E
M;F-E#0I7:5N.B!/8W1O8F5R(#(M-P@,C P,@T*5VAEF4Z($-AFEB92!2
M;WEA;4@4F5S;W)T( @3W)L86YD;RP@1DP@(%5300T*1F]R(UOF4@:6YF
M;W)M871I;VX@9V\@=\@=W=W+F-S961G92YC;VT-@T*#0H-E1H92!I;F9O
MFUA=EO;B!C;VYT86EN960@:6X@=AIR!E+6UA:6P@:7,@W1R:6-T;'D@
M8V]N9FED96YT:6%L(%N9!F;W(@=AE(EN=5N95D('5S92!O9B!T:4@
M861DF5SV5E(]N;'D[(ET(UA2!A;'-O()E(QE9V%L;'D@')I=FEL
M96=E9!A;F0O;W(@')I8V4@V5NVET:79E+B @3F]T:6-E(ES(AEF5B
M2!G:79E;B!T:%T(%N2!D:7-C;]S=7)E+!UV4@;W(@8V]P6EN9R!O
M9B!T:4@:6YF;W)M871I;VX@8GD@86YY;VYE(]T:5R('1H86X@=AE(EN
M=5N95D(')E8VEP:65N=!IR!PF]H:6)I=5D(%N9!M87D@8F4@:6QL
M96=A;X@($EF('EO=2!H879E(')E8V5I=F5D('1H:7,@;65SV%G92!I;B!E
MG)OBP@QE87-E(YO=EF2!T:4@V5N95R(EM;65D:6%T96QY()Y
M(')E='5R;B!E+6UA:6PN@I#;W)P;W)A=4@4WES=5MRP@26YC+B!H87,@
M=%K96X@979EGD@F5AV]N86)L92!PF5C875T:6]N('1O(5NW5R92!T
M:%T(%N2!A='1A8VAM96YT('1O('1H:7,@92UM86EL(AAR!B965N('-W
M97!T(9OB!V:7)UV5S+B @5V4@86-C97!T(YO(QI86)I;ET2!F;W(@
M86YY(1A;6%G92!S=7-T86EN960@87,@82!R97-U;'0@;V8@V]F='=AF4@
M=FER=7-ER!A;F0@861V:7-E('EO=2!C87)R2!O=70@6]UB!O=VX@=FER
M=7,@8VAE8VMS()E9F]R92!O5N:6YG(%N2!A='1A8VAM96YT+@T*#0H-
#@T*
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re:


It seems that you send long sql requests or receive large amounts of data
from the database.
These parameters increase the blocksize so sqlnet will send and receive
larger block,
minimizing the time the server waits for data or waits for the client to
request more data.

Check the documents for implementation parameters.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 1:23 AM


 Hi List,

 If anybody can explain to me what sort of change I have to do on y sql*net
 it would be a big help:
 I got the following recommendation from oraperf.com:

 Check SQL*Net Configuration for SDU and TDU settings  - Any Idea?




 Hamid Alavi
 Office 818 737-0526
 Cell818 416-5095






 === Confidentiality Statement ===
 The information contained in this message and any attachments is
 intended only for the use of the individual or entity to which it is
 addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
 and exempt from disclosure under applicable law.  If you have received
 this message in error, you are prohibited from copying, distributing, or
 using the information.  Please contact the sender immediately by return
 e-mail and delete the original message from your system.
 = End Confidentiality Statement =


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Hamid Alavi
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Moving data between tablespaces[Scanned]

2002-09-17 Thread Karthikeyan S


Amar / Thomas,

Thanks a lot for your help. 
As you said, ALTER TABLE {table_name} MOVE {tablespace}, solved the problem.  

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 5:10 PM
To: [EMAIL PROTECTED]
Cc: Karthikeyan S


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?


regards,
Karthik 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: Another Character Set Problem


To change the character set to another that is not recognized as a superset
use:
Alter database db-name character set INTERNAL_USE new_character_set

This parameter is active for oracle 8.1 and above.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 3:18 PM


 We are currently having a character set problem.  We have a
 third-party product that is used for on-line courses (Prometheus from
 Blackboard, Inc.).  The character set that the instance was created with
 was US7ASCII.  The vendor says it should be WE8ISO8859P1, but we need to
 support Chinese and Japanese characters.  I contacted Oracle support,
 and was told that the specified character set would not support those
 characters, but that I should use UTF8.  I altered the instance to use
 UTF8 and ran into a CLOB problem.  We installed patchset 4 (so we are
 now 8.1.7.4.0 on Sun Solaris 2.8) and that problem went away.  However,
 none of the CLOB data is rendered properly in the application and I
 don't have a tool that allows me to see it directly out of the database.

 I am tempted to try to change the character set to WE8ISO8859P1, as
 the vendor requested, with the hope that any deficiencies in that
 character set have been handled by their product.  At this point, can I
 change the instance from UTF8 to WE8ISO8859P1?  I do have a tar open on
 this issue and will be asking the same question there, but I'm hoping
 I'll get a response here faster (ok, I'm expecting that I will).

 Thank you.

 --
 Scott Canaan ([EMAIL PROTECTED])
 (585) 475-7886
 Life is like a sewer, what you get out of it depends on what you put
 into it. - Tom Lehrer.


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Scott Canaan
   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 list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: ORACLE-L Digest -- Volume 2002, Number 260

2002-09-17 Thread Edouard Dormidontov


Hi Rajesh.

Try to use large rollback segments in your transactions.

Best regards
ED

 Hi All,
I am running a pro*c program which has a cursor which fetches data f=
 rom
 a table which is constantly being updated by front-end, so I am getting=
 
 snapshot too old error. My requirement is not to adhere to the
 consistency of the data. I am fine if the data that my program is readi=
 ng
 is not consistent. How can I ask oracle to not to give me this snapsho=
 t
 too old error even when the data is consistent/inconsistent.
 
 Thanks a lot,
 Rajesh
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Pillai, Rajesh
   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 list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Edouard Dormidontov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Moving data between tablespaces[Scanned]

2002-09-17 Thread Karthikeyan S


Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I am getting the 
following error. 
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in unusable 
state
Is it because of moving the table to a different tablespace or is it something else? 
TIA

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?


regards,
Karthik 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based t


If you will search Metalink you will see that this bug is generic and not
specific to a certain system.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 16, 2002 7:58 PM


 Guys, the 2429929 apply for Sun Solaris platform also?

 thanks.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author:
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Oracle Installer not launching in NT

2002-09-17 Thread Kitty Luo


The OUI does not launch at all. I also tried what the note 131299.1
suggests, still not working.

After I download the copy of  symcjit.dll described by Mark
http://www.cool-tools.co.uk/products/downloads/symcjit.dll, I receive the
following error message: jvm.dll could not be found.

Any ideas are appreciated!

Kitty


-Original Message-
Dave
Sent: 17 September, 2002 7:38 AM
To: Multiple recipients of list ORACLE-L


Is the problem that the OUI does not launch or that it launches, does some
installing and then suddenly stops??

Dave

-Original Message-
Sent: Monday, September 16, 2002 9:58 PM
To: Multiple recipients of list ORACLE-L


I have s similar problem (Oracle Installer 8.1.6 / 8.1.7 not launching in
NT) but on a Pentium 3 with NT4 SP5, anyone has a workround?

Many thanks.

Kitty

-Original Message-
Heisler
Sent: 25 July, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L


If it's a Pentium 4, it's a known bug.  See MetaLink note 131299.1.  The
patch is 1507768.


Dennis



 [EMAIL PROTECTED] wrote:

 Hi List,

 I saw a similar post to this in the last 2 weeks, but deleted it
 (oops) as I am in a unix shop.  But I now have a client who is
 trying to install the oracle client on his nt box in order to demo our
 *product*.

 However, he can't get the installer to even launch.  He thinks its
 a Java VM conflict.

 Any ideas?  I need this rather quick so please also reply direct
 to me and in the meantime I will hit the internet.

 Thanks,

 Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis M. Heisler
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Kitty Luo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Kitty Luo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Moving data between tablespaces[Scanned]

2002-09-17 Thread Amar Kumar Padhi

Title: RE: Moving data between tablespaces[Scanned]





Please rebuild the indexes for the move tables.
Once a table is moved indexes, if any, on it become invalid.


rgds
amar
http://amzone.netfirms.com



-Original Message-
From: Karthikeyan S [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 6:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Moving data between tablespaces[Scanned]



Thomas / Amar,


I moved the tables from SYSTEM to the DATA tablespace. But now I am getting the following error. 
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in unusable state
Is it because of moving the table to a different tablespace or is it something else? 
TIA


regards,
Karthik 


-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L



Karthik,


Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.


It will do exactly what you want.


You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.


Hope this helps.


Tom Mercadante
Oracle Certified Professional



-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L



Hi All,


Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?



regards,
Karthik 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Moving data between tablespaces[Scanned]

2002-09-17 Thread Deshpande, Kirti


Indexes store the rowids. Right? 

When the table row moved to a different place, the internal 'rowid' for it
changed, making the rowid in indexes useless (or unusable).

Since the 'alter table move' command does not automatically rebuild the
indexes with new rowids, the DBA has to do it (at least up to Oracle9i Rel
2) !! 
 
- Kirti 

-Original Message-
Sent: Tuesday, September 17, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L


Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I am getting
the following error. 
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in
unusable state
Is it because of moving the table to a different tablespace or is it
something else? 
TIA

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?


regards,
Karthik 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Moving data between tablespaces[Scanned]


Karthik
   Lesson #2 on moving tablespaces. Afterward, you must perform 
ALTER INDEX REBUILD
   This corrects the problem you are experiencing.
 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, September 17, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L


Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I am getting
the following error. 
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in
unusable state
Is it because of moving the table to a different tablespace or is it
something else? 
TIA

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?


regards,
Karthik 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RMAN restore to another node


Hi all,

I am stuck on this restore for two days and Oracle
support seems to offering little help. 

I seem to be doing everything according to manuals and
metalink notes  but am not able to do the restore.

The case is I am restoring a database to another node.
I have successfully restore the control file but when
I tried to restore the database I get 
RMAN-06100: no channel to restore a backup or copy of
datafile 1 
for every datafile.

I am inserting the RMAN trace . I would appreciate if
someone can lead in the right direction.
Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All
rights reserved.

ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
System name:SunOS
Node name:  EdwDev
Release:5.8
Version:Generic_108528-15
Machine:sun4u

Starting with debugging turned off

connected to target database: DB01 (not mounted)
using target database controlfile instead of recovery
catalog

RMAN
executing command: SET DBID

RMAN 2 3 4
allocated channel: ci
channel ci: sid=10 devtype=DISK

Starting restore at 17-SEP-02

channel ci: restoring controlfile
channel ci: restore complete
replicating controlfile
input filename=/extracts1/DB01_temp/ctrl1.ctl
output filename=/extracts1/DB01_temp/ctrl2.ctl
output filename=/extracts1/DB01_temp/ctrl3.ctl
Finished restore at 17-SEP-02
released channel: ci

RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15
16
allocated channel: c1
channel c1: sid=10 devtype=DISK

allocated channel: c2
channel c2: sid=11 devtype=DISK

allocated channel: c3
channel c3: sid=12 devtype=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 17-SEP-02

released channel: c1
released channel: c2
released channel: c3
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK
FOLLOWS ===
RMAN-00571:
===
RMAN-03002: failure of restore command at 09/17/2002
08:27:16
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of
datafile 8
RMAN-06100: no channel to restore a backup or copy of
datafile 7
RMAN-06100: no channel to restore a backup or copy of
datafile 6
RMAN-06100: no channel to restore a backup or copy of
datafile 5
RMAN-06100: no channel to restore a backup or copy of
datafile 4
RMAN-06100: no channel to restore a backup or copy of
datafile 3
RMAN-06100: no channel to restore a backup or copy of
datafile 2
RMAN-06100: no channel to restore a backup or copy of
datafile 1





__
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Tracking Temp Segment Usage and Event 10046

2002-09-17 Thread Jamadagni, Rajendra

Title: Tracking Temp Segment Usage and Event 10046





I have a problem with a process and its temp segment usage.


Previously, in RBO (8161) we used to run 8 reports with slightly different parameters in parallel and it used to work fine with all other load on the system and the total TEMP space was 6GB

Since we migrated to CBO (all tables  indexes are analyzed using estimate), these processes fail with unable to extent temp segment error. Currently we have allocated 12GB to temp tablespace.

I also have performance issues so I am doing a 10046 trace at level 8 on this one. Is there a way to identify when this process used temp space, how much and when does it de-allocate?

Would this information be available in 10046 trace or is there something else that I could do to track that ...


Thanks in advance
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!




*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: Moving data between tablespaces

2002-09-17 Thread Juan Miranda



try this.

Is my reorganization script.

It don´t work if the table has LONG or LONG RAW.

You must change the value of owner and tablespace.
You can change the values of INITIAL, NEXT, etc.

set serveroutput on size 100
set feedback off
set echo off
set trimspool on
spool c:\move_tables.sql

DECLARE
var1number;
var2number;
var3number;
var4number;
var5number;
var6number;
var7number;

BEGIN
dbms_output.put_line('set feedback on');
dbms_output.put_line('set echo on');
dbms_output.put_line('spool c:\move_tables.log');
dbms_output.put_line('alter session set SORT_AREA_SIZE=2500;');
dbms_output.put_line('select to_char(sysdate, ''MM/DD/ HH24:MI:SS'')
from dual;');


FOR TB in (select owner, table_name, pct_free, pct_used, ini_trans,
max_trans, initial_extent,
decode(next_extent,null,initial_extent,next_extent) nexte, min_extents,
max_extents, pct_increase, freelists, freelist_groups, decode(logging,
'YES', ' logging ', ' nologging ') logg
   from dba_tables where owner = 'EPSILON' order by TABLE_NAME)
LOOP

  dbms_output.put_line(chr(0));

  dbms_output.put_line('alter TABLE '|| TB.owner ||'.'|| TB.table_name || '
move tablespace USERS ' || TB.logg
|| chr(10) || '  pctfree ' || TB.pct_free || ' pctused ' || 
TB.pct_used
|| ' initrans ' || TB.ini_trans || ' maxtrans '|| TB.max_trans
|| chr(10) || '  storage ( initial ' || TB.initial_extent || ' 
next
' || TB.nexte ||
' minextents ' || TB.min_extents || ' maxextents UNLIMITED ' ||
' pctincrease 0  freelists ' || TB.freelists || ' freelist 
groups '
|| TB.freelist_groups ||');');


  -- Espacio ocupado por la tabla

dbms_space.unused_space(upper(''||TB.owner||''),upper(''||TB.table_name||'')
,'TABLE',VAR1,VAR2,VAR3,VAR4,VAR5,VAR6,VAR7);
  dbms_output.put_line('-- %Libre:'|| round((VAR4*100)/VAR2) ||'
Total_KB:'|| VAR2/1024 || '  Libre_KB:'||VAR4/1024 ||'  -- Blk_Total:'||
VAR1 || '  Blk_Libres:'||VAR3);


  -- Indices de esa tabla
  FOR INDX in (select owner, index_name, pct_free, ini_trans, max_trans,
initial_extent, decode(next_extent,null,initial_extent,next_extent) nexte,
min_extents, max_extents, pct_increase, freelists, freelist_groups,
decode(logging, 'YES', ' logging ', ' nologging ') logg
from dba_indexes where table_owner=TB.owner and 
table_name=TB.table_name
order by index_name)
  LOOP
 dbms_output.put_line(' alter INDEX ' || INDX.owner ||'.'||
INDX.index_name || ' rebuild '|| INDX.logg
|| chr(10) || '  pctfree ' || INDX.pct_free ||  ' initrans ' ||
INDX.ini_trans || ' maxtrans '|| INDX.max_trans
|| chr(10) || '  storage ( initial ' || INDX.initial_extent || 
' next '
|| INDX.nexte ||
' minextents ' || INDX.min_extents || ' maxextents UNLIMITED ' 
||
' pctincrease 0  freelists ' || INDX.freelists || ' freelist 
groups
' || INDX.freelist_groups ||');');

  -- Espacio ocupado por el índice

dbms_space.unused_space(upper(''||INDX.owner||''),upper(''||INDX.index_name|
|''),'INDEX',VAR1,VAR2,VAR3,VAR4,VAR5,VAR6,VAR7);
  dbms_output.put_line('-- %Libre:'|| round((VAR4*100)/VAR2) ||'
Total_KB:'|| VAR2/1024 || '  Libre_KB:'||VAR4/1024 ||'  -- Blk_Total:'||
VAR1 || '  Blk_Libres:'||VAR3);

  END LOOP;

END LOOP;

dbms_output.put_line('select to_char(sysdate, ''MM/DD/ HH24:MI:SS'')
from dual;');
dbms_output.put_line('select * from dba_indexes where status''VALID'';');
dbms_output.put_line('spool off');

END;
/

spool off

spool c:\extensiones_mon_cache.log
column segment_name format a20
column owner format a10
prompt ** EXTENSIONES. Cambia INITIAL de los siguientes segmentos (pulsa
ENTER):
pause
select owner, segment_name, segment_type, tablespace_name,
sum(bytes),count(*) from dba_extents where owner 'SYS' group by
segment_name,owner,segment_type,tablespace_name having count(*)3 order by
count(*);

prompt *  MONITORING y CACHE (pulsa ENTER):
pause
select table_name, monitoring, cache from dba_tables where owner='EPSILON'
and (cache not like '%N%' or monitoring'NO');
spool off


---

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Karthikeyan S
Enviado el: martes, 17 de septiembre de 2002 16:04
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Moving data between tablespaces[Scanned]


Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I am getting
the following error.
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in
unusable state
Is it because of moving the table to a different tablespace or is it
something else?
TIA

regards,
Karthik

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To:

RE: Moving data between tablespaces[Scanned]

2002-09-17 Thread Khedr, Waleed


rebuild the index.

-Original Message-
Sent: Tuesday, September 17, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L


Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I am getting
the following error. 
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in
unusable state
Is it because of moving the table to a different tablespace or is it
something else? 
TIA

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?


regards,
Karthik 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Moving data between tablespaces[Scanned]

2002-09-17 Thread Robertson Lee - lerobe


You now need to rebuild the index

-Original Message-
Sent: 17 September 2002 15:04
To: Multiple recipients of list ORACLE-L


Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I am getting
the following error. 
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in
unusable state
Is it because of moving the table to a different tablespace or is it
something else? 
TIA

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?


regards,
Karthik 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).


*

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: RMAN restore to another node


Johnson
   From what I read of your trace file, the channels are being released,
presumably just before you need them. Do you have that explicitly coded in
your RMAN recovery script, or are they being released for another reason. My
immediate response is that maybe the problem lies in why those channels are
being released. Can you move your channel commands after the SET NEWNAME
commands?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, September 17, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I am stuck on this restore for two days and Oracle
support seems to offering little help. 

I seem to be doing everything according to manuals and
metalink notes  but am not able to do the restore.

The case is I am restoring a database to another node.
I have successfully restore the control file but when
I tried to restore the database I get 
RMAN-06100: no channel to restore a backup or copy of
datafile 1 
for every datafile.

I am inserting the RMAN trace . I would appreciate if
someone can lead in the right direction.
Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All
rights reserved.

ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
System name:SunOS
Node name:  EdwDev
Release:5.8
Version:Generic_108528-15
Machine:sun4u

Starting with debugging turned off

connected to target database: DB01 (not mounted)
using target database controlfile instead of recovery
catalog

RMAN
executing command: SET DBID

RMAN 2 3 4
allocated channel: ci
channel ci: sid=10 devtype=DISK

Starting restore at 17-SEP-02

channel ci: restoring controlfile
channel ci: restore complete
replicating controlfile
input filename=/extracts1/DB01_temp/ctrl1.ctl
output filename=/extracts1/DB01_temp/ctrl2.ctl
output filename=/extracts1/DB01_temp/ctrl3.ctl
Finished restore at 17-SEP-02
released channel: ci

RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15
16
allocated channel: c1
channel c1: sid=10 devtype=DISK

allocated channel: c2
channel c2: sid=11 devtype=DISK

allocated channel: c3
channel c3: sid=12 devtype=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 17-SEP-02

released channel: c1
released channel: c2
released channel: c3
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK
FOLLOWS ===
RMAN-00571:
===
RMAN-03002: failure of restore command at 09/17/2002
08:27:16
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of
datafile 8
RMAN-06100: no channel to restore a backup or copy of
datafile 7
RMAN-06100: no channel to restore a backup or copy of
datafile 6
RMAN-06100: no channel to restore a backup or copy of
datafile 5
RMAN-06100: no channel to restore a backup or copy of
datafile 4
RMAN-06100: no channel to restore a backup or copy of
datafile 3
RMAN-06100: no channel to restore a backup or copy of
datafile 2
RMAN-06100: no channel to restore a backup or copy of
datafile 1





__
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Tracking Temp Segment Usage and Event 10046

2002-09-17 Thread K Gopalakrishnan

Title: Tracking Temp Segment Usage and Event 10046

Raj:

You
will be able to identify the processes (along with the SQLs and number of
extents) using the 10046 level 8 trace.
If you
use the temp files you see the file# ( in the direct path read/write events) as
db_files+1 or MAXDBFILES+1
or
similar values. DOn't try to map the FILE# with the dictionary or X$KCFIO. THis
is the only catch.

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni,
RajendraSent: Tuesday, September 17, 2002 7:34 AMTo:
Multiple recipients of list ORACLE-LSubject: Tracking Temp Segment
Usage and Event 10046
I have a problem with a process and its temp
segment usage.
Previously, in RBO (8161) we used to run 8 reports
with slightly different parameters in parallel and it used to work fine with
all other load on the system and the total TEMP space was 6GB
Since we migrated to CBO (all tables indexes
are analyzed using estimate), these processes fail with unable to extent temp
segment error. Currently we have allocated 12GB to temp tablespace.
I also have performance issues so I am doing a
10046 trace at level 8 on this one. Is there a way to identify when this
process used temp space, how much and when does it de-allocate?
Would this information be available in 10046 trace
or is there something else that I could do to track that ...
Thanks in advance Raj __ Rajendra Jamadagni
MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and
doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!

RE: Moving data between tablespaces[Scanned]


Karthik,

It's because you moved the table.

Think about it - the index is nothing more than a list of ROWID's.  The
ROWID's in the index are pointing to the old location of the table.  Thus,
the index is invalid.

Run the second part of my suggestion - either move the index to a new
tablesspace, or rebuild the index and you should be all set.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L


Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I am getting
the following error. 
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in
unusable state
Is it because of moving the table to a different tablespace or is it
something else? 
TIA

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?


regards,
Karthik 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: RMAN restore to another node


Johnson - Did Oracle Support offer any theories on why the RMAN channels
were being spontaneously released? Is Oracle Support looking into this as a
possible bug, and you are just checking to see whether anyone else has
experienced this behavior?
 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, September 17, 2002 9:02 AM
To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Oracle support too pointed to that. I tested with
allocating 3 more channnels after 'set newname'. But
no change. They were released. and same error
followed.

--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Johnson
From what I read of your trace file, the channels
 are being released,
 presumably just before you need them. Do you have
 that explicitly coded in
 your RMAN recovery script, or are they being
 released for another reason. My
 immediate response is that maybe the problem lies in
 why those channels are
 being released. Can you move your channel commands
 after the SET NEWNAME
 commands?
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED] 
 
 
 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 9:23 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RMAN restore to another node
 
 
 Hi all,
 
 I am stuck on this restore for two days and Oracle
 support seems to offering little help. 
 
 I seem to be doing everything according to manuals
 and
 metalink notes  but am not able to do the restore.
 
 The case is I am restoring a database to another
 node.
 I have successfully restore the control file but
 when
 I tried to restore the database I get 
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 1 
 for every datafile.
 
 I am inserting the RMAN trace . I would appreciate
 if
 someone can lead in the right direction.
 Recovery Manager: Release 9.2.0.1.0 - Production
 
 Copyright (c) 1995, 2002, Oracle Corporation.  All
 rights reserved.
 
 ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
 System name:SunOS
 Node name:  EdwDev
 Release:5.8
 Version:Generic_108528-15
 Machine:sun4u
 
 Starting with debugging turned off
 
 connected to target database: DB01 (not mounted)
 using target database controlfile instead of
 recovery
 catalog
 
 RMAN
 executing command: SET DBID
 
 RMAN 2 3 4
 allocated channel: ci
 channel ci: sid=10 devtype=DISK
 
 Starting restore at 17-SEP-02
 
 channel ci: restoring controlfile
 channel ci: restore complete
 replicating controlfile
 input filename=/extracts1/DB01_temp/ctrl1.ctl
 output filename=/extracts1/DB01_temp/ctrl2.ctl
 output filename=/extracts1/DB01_temp/ctrl3.ctl
 Finished restore at 17-SEP-02
 released channel: ci
 
 RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
 15
 16
 allocated channel: c1
 channel c1: sid=10 devtype=DISK
 
 allocated channel: c2
 channel c2: sid=11 devtype=DISK
 
 allocated channel: c3
 channel c3: sid=12 devtype=DISK
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 Starting restore at 17-SEP-02
 
 released channel: c1
 released channel: c2
 released channel: c3
 RMAN-00571:

===
 RMAN-00569: === ERROR MESSAGE STACK
 FOLLOWS ===
 RMAN-00571:

===
 RMAN-03002: failure of restore command at 09/17/2002
 08:27:16
 RMAN-06026: some targets not found - aborting
 restore
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 8
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 7
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 6
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 5
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 4
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 3
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 2
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 1
 
 
 
 
 
 __
 Do you Yahoo!?
 Yahoo! News - Today's headlines
 http://news.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Johnson Poovathummoottil
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of

Re: Moving data between tablespaces[Scanned]

2002-09-17 Thread Alan Davey


Karthik,

You need to rebuild your indexes after moving your table as they are invalidated with 
the move.

HTH,
-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 9/17/2002 10:03 AM, Karthikeyan S [EMAIL PROTECTED] wrote:
Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I 
am getting the following error. 
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such 
index is in unusable state
Is it because of moving the table to a different tablespace or is 
it something else? 
TIA

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move 
indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 

Is there any way to move the records and the table to some other 
tablespace?


regards,
Karthik 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Alan Davey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: RMAN restore to another node


I tried that too. But did it not help. here is the
ouput.

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

allocated channel: c1
channel c1: sid=10 devtype=DISK

allocated channel: c2
channel c2: sid=11 devtype=DISK
allocated channel: c3
channel c3: sid=12 devtype=DISK

Starting restore at 17-SEP-02

released channel: c1
released channel: c2
released channel: c3
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK
FOLLOWS ===
RMAN-00571:
===
RMAN-03002: failure of restore command at 09/17/2002
10:29:13
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of
datafile 8
RMAN-06100: no channel to restore a backup or copy of
datafile 7
RMAN-06100: no channel to restore a backup or copy of
datafile 6
RMAN-06100: no channel to restore a backup or copy of
datafile 5
RMAN-06100: no channel to restore a backup or copy of
datafile 4
RMAN-06100: no channel to restore a backup or copy of
datafile 3
RMAN-06100: no channel to restore a backup or copy of
datafile 2
RMAN-06100: no channel to restore a backup or copy of
datafile 1


--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Johnson
Their explanation doesn't make sense to me. I
 have had RMAN fail to get
 the backup piece, and the error message is very
 clear.
Just in case the SET NEWNAME is somehow affecting
 the recovery, you might
 take them out just to see what happens. I would also
 have moved the ALLOCATE
 CHANNEL below the SET NEWNAME, rather than opening a
 new set of channels,
 but then I haven't used SET NEWNAME. I just had my
 Unix sys admin create
 mount points named the same as the mount points on
 the production system. 
Perhaps someone can post an RMAN recovery script
 that includes a SET
 NEWNAME, so you can compare. You might also post
 your recovery script, that
 might clarify something.
Also, this is Oracle 9.2, and most of my RMAN
 practice has been on Oracle
 8.1.6.
Another thought for a test is to backup the
 production control file
 separately and then place it where it is needed,
 rather than have RMAN
 recover it. I'm just wondering whether you are
 getting some side-effect from
 the successful control file recovery. 
  
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED] 
 
 
 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 9:16 AM
 To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
 Subject: RE: RMAN restore to another node
 
 
 They are alluding it to a possibilty that RMAN
 cannot
 find the backup piece and just before showing the
 error it realeasing channels and that releasing
 channels per se does not point to any problem.
 
 --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
  Johnson - Did Oracle Support offer any theories on
  why the RMAN channels
  were being spontaneously released? Is Oracle
 Support
  looking into this as a
  possible bug, and you are just checking to see
  whether anyone else has
  experienced this behavior?
   
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
  mailto:[EMAIL PROTECTED] 
  
  
  -Original Message-
  From: Johnson Poovathummoottil
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, September 17, 2002 9:02 AM
  To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
  Cc: '[EMAIL PROTECTED]'
  Subject: RE: RMAN restore to another node
  
  
  Oracle support too pointed to that. I tested with
  allocating 3 more channnels after 'set newname'.
 But
  no change. They were released. and same error
  followed.
  
  --- DENNIS WILLIAMS [EMAIL PROTECTED]
 wrote:
   Johnson
  From what I read of your trace file, the
  channels
   are being released,
   presumably just before you need them. Do you
 have
   that explicitly coded in
   your RMAN recovery script, or are they being
   released for another reason. My
   immediate response is that maybe the problem
 lies
  in
   why those channels are
   being released. Can you move your channel
 commands
   after the SET NEWNAME
   commands?
   
   Dennis Williams
   DBA
   Lifetouch, Inc.
   [EMAIL PROTECTED]
   mailto:[EMAIL PROTECTED] 
   
   
   -Original Message-
   From: Johnson Poovathummoottil
   [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, September 17, 2002 9:23 AM
   To: Multiple recipients of list ORACLE-L
   Subject: RMAN restore to another node
   
   
   Hi all,
   
   I am stuck on this restore for two days and
 Oracle
   support seems to offering little help. 
   
   I seem to be doing everything according to
 manuals
   and
   metalink notes  but am not able to do the
 restore.
   
   The case is I am restoring a database to another

Fw: Moving data between tablespaces

2002-09-17 Thread Natalia Lorena Laracca


Hi,
If you have Oracle 8i, you can do:
alter table OWNER.TABLE_NAME
move tablespace TABLESPACE_NAME;

and after you have to do:

Alter index OWNER.INDEX_NAME
rebuild tablespaces TABLESPACE_NAME;

Natalia Lorena Laracca


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 2:58 AM


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace.
Is there any way to move the records and the table to some other tablespace?

regards,
Karthik


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Natalia Lorena Laracca
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Moving data between tablespaces[Scanned]

2002-09-17 Thread Jack van Zanen


Hi


That's what alter table move does to your indexes. (that sucks, and bit
me in the behind the other day as well)

just rebuild your indexes and you'll be fine.


Jack


   

  Karthikeyan S  

  skarthik@globalsTo:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
  w-in.comcc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  RE: Moving data between 
tablespaces[Scanned]  
  [EMAIL PROTECTED] 

   

   

  17-09-2002 16:03 

  Please respond to

  ORACLE-L 

   

   




Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I am getting
the following error.
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is
in unusable state
Is it because of moving the table to a different tablespace or is it
something else?
TIA

regards,
Karthik

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace.
Is there any way to move the records and the table to some other
tablespace?


regards,
Karthik

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).



===
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the

RE: Oracle Installer not launching in NT

2002-09-17 Thread moyam


Try installing Java VM and retry. Download Java from www.java.sun.com.

I ever got such a problem on TRU64 Unix. I installed Java, also changed the
parameters used to mount CD ROM. This SHOULD NOT BE the case with NT.

-Original Message-
Sent: Tuesday, September 17, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L


The OUI does not launch at all. I also tried what the note 131299.1
suggests, still not working.

After I download the copy of  symcjit.dll described by Mark
http://www.cool-tools.co.uk/products/downloads/symcjit.dll, I receive the
following error message: jvm.dll could not be found.

Any ideas are appreciated!

Kitty


-Original Message-
Dave
Sent: 17 September, 2002 7:38 AM
To: Multiple recipients of list ORACLE-L


Is the problem that the OUI does not launch or that it launches, does some
installing and then suddenly stops??

Dave

-Original Message-
Sent: Monday, September 16, 2002 9:58 PM
To: Multiple recipients of list ORACLE-L


I have s similar problem (Oracle Installer 8.1.6 / 8.1.7 not launching in
NT) but on a Pentium 3 with NT4 SP5, anyone has a workround?

Many thanks.

Kitty

-Original Message-
Heisler
Sent: 25 July, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L


If it's a Pentium 4, it's a known bug.  See MetaLink note 131299.1.  The
patch is 1507768.


Dennis



 [EMAIL PROTECTED] wrote:

 Hi List,

 I saw a similar post to this in the last 2 weeks, but deleted it
 (oops) as I am in a unix shop.  But I now have a client who is
 trying to install the oracle client on his nt box in order to demo our
 *product*.

 However, he can't get the installer to even launch.  He thinks its
 a Java VM conflict.

 Any ideas?  I need this rather quick so please also reply direct
 to me and in the meantime I will hit the internet.

 Thanks,

 Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis M. Heisler
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Kitty Luo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Kitty Luo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you

RE: Tracking Temp Segment Usage and Event 10046

2002-09-17 Thread Jamadagni, Rajendra

Title: RE: Tracking Temp Segment Usage and Event 10046





Dennis,


I did, but the problem is this is a SQR report, and it ain't one sql. SQR reports are like giant cursor loops but un structured. There are about 100 different sql statements (not including the recursive ones). 

In RBO, eight such reports could run parallel and not affect anything and finish in approx 25 minutes. In CBO they crash in about 14 minutes into the report and out of eight only about 3/4 manage to finish.

Performance is my second priority, reducing its temp space usage is my first priority. The trace files is about 400MB+ in size.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 10:11 AM
To: '[EMAIL PROTECTED]'
Cc: Jamadagni, Rajendra
Subject: RE: Tracking Temp Segment Usage and Event 10046



Raj - I personally favor using the simpler diagnostics first. Why not run
your SQL through EXPLAIN PLAN and see which SQL is performing sorts? My
immediate guess is that under RBO an index was being used that isn't now.


Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 



-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Tracking Temp Segment Usage and Event 10046




I have a problem with a process and its temp segment usage. 


Previously, in RBO (8161) we used to run 8 reports with slightly different
parameters in parallel and it used to work fine with all other load on the
system and the total TEMP space was 6GB


Since we migrated to CBO (all tables  indexes are analyzed using estimate),
these processes fail with unable to extent temp segment error. Currently we
have allocated 12GB to temp tablespace.


I also have performance issues so I am doing a 10046 trace at level 8 on
this one. Is there a way to identify when this process used temp space, how
much and when does it de-allocate?


Would this information be available in 10046 trace or is there something
else that I could do to track that ... 


Thanks in advance 
Raj 
__ 
Rajendra Jamadagni MIS, ESPN Inc. 
Rajendra dot Jamadagni at ESPN dot com 
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.


QOTD: Any clod can have facts, but having an opinion is an art! 




This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Rule Vs Cost

2002-09-17 Thread Surendra . Tirumala


John,

Yes, it is surprising no one responded..
Thanks for your reply. I just downloaded your paper and going through it.
After I have posted this question, I tried to use CHOOSE mode with my query.
Generated stats on the tables of interest, and forced one of the biggest
tables to
go for Index scan and other for PQ. The tables I am talking about contan 4
mil and 400,000 rows. The best timing  I got is hour and half for my query.
I am performing an outer join, order by and Distinct in the query.

I will get back to the list if I have any specific concerns.

Thanks,
Surendra

-Original Message-
Sent: Friday, September 13, 2002 10:13 PM
To: Multiple recipients of list ORACLE-L


Surendra,
 
Saw no replies, so just pitching in. Moving over to the CBO does give you
flexibility and the option for a query to 'self-tune' itself depending on
the object statistics. (Dare I say 'self-tune' with all the notes flying
around :)  Anyway - what I meant was that _most_ queries would adjust their
execution path depending on these stats. The two inputs to this process is
the objects stats themselves as well as the algorithm that operates on these
stats. This 'algorithm' can further be influenced (for want of a better
term) using a number of init.ora parameters (documented and undocumented).
The art is to determine the right values, but there are a few values such as
OPTIMIZER_INDEX_CACHING and OPTIMIZER_INDEX_COST_ADJ and that you will not
go wrong with - Tim Gorman deals with these two in his excellent paper on
the CBO. Browse at Tim's site at 'http://www.evdbt.com' .
 
At the same time, moving to the CBO without understanding this complex beast
is like getting into a souped-up Porshe when you have just got your Trainee
driver permit.
There are a number of issues with this that even seasoned DBAs miss... I
tried to cover these issues in my paper - just follow the second link on
'http://www.geocites.com/john_sharmila/links.htm'.
 
One way of performing a gradual move to the CBO is by gathering stats and
then using an ON-LOGON trigger to switch the optimizer_goal to CHOOSE for
selected programs/sessions. A final hint: Use PQ with caution - overuse and
ill-planned implementation can be potentially deadly and overwhelme your
CPUs. IMHO PQ is to be used ony in certain cases and that too only from the
SQL using Hints, which will limit PQ only to that SQL.
 
John Kanagaraj 
Oracle Applications DBA 
DB Soft Inc 
Work : (408) 970 7002 

Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com http://www.klove.com/  

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, September 13, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L


Hello All,
 
I am observing that some of our production instances(8i) are running on Rule
Based Optimizer. I am dealing with the task of tuning a bunch of reports.
While I continue my adventures, can you guys please let me know if there is
any reason to continue with age old Rule based optimizer when we have so
many advantages with CBO? I am exploring the option of using PQ with couple
of reports but the RBO is forcing me to stop thinking about it. 
 
All your suggestion are very much appreciated.
 
Thanks in advance.
 
Surendra Tirumala
Oracle DBA
Cabinet for Workforce Development
Commonwealth of Kentucky

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: RMAN restore to another node


They are alluding it to a possibilty that RMAN cannot
find the backup piece and just before showing the
error it realeasing channels and that releasing
channels per se does not point to any problem.

--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Johnson - Did Oracle Support offer any theories on
 why the RMAN channels
 were being spontaneously released? Is Oracle Support
 looking into this as a
 possible bug, and you are just checking to see
 whether anyone else has
 experienced this behavior?
  
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED] 
 
 
 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 9:02 AM
 To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
 Cc: '[EMAIL PROTECTED]'
 Subject: RE: RMAN restore to another node
 
 
 Oracle support too pointed to that. I tested with
 allocating 3 more channnels after 'set newname'. But
 no change. They were released. and same error
 followed.
 
 --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
  Johnson
 From what I read of your trace file, the
 channels
  are being released,
  presumably just before you need them. Do you have
  that explicitly coded in
  your RMAN recovery script, or are they being
  released for another reason. My
  immediate response is that maybe the problem lies
 in
  why those channels are
  being released. Can you move your channel commands
  after the SET NEWNAME
  commands?
  
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
  mailto:[EMAIL PROTECTED] 
  
  
  -Original Message-
  From: Johnson Poovathummoottil
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, September 17, 2002 9:23 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN restore to another node
  
  
  Hi all,
  
  I am stuck on this restore for two days and Oracle
  support seems to offering little help. 
  
  I seem to be doing everything according to manuals
  and
  metalink notes  but am not able to do the restore.
  
  The case is I am restoring a database to another
  node.
  I have successfully restore the control file but
  when
  I tried to restore the database I get 
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 1 
  for every datafile.
  
  I am inserting the RMAN trace . I would appreciate
  if
  someone can lead in the right direction.
  Recovery Manager: Release 9.2.0.1.0 - Production
  
  Copyright (c) 1995, 2002, Oracle Corporation.  All
  rights reserved.
  
  ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
  System name:SunOS
  Node name:  EdwDev
  Release:5.8
  Version:Generic_108528-15
  Machine:sun4u
  
  Starting with debugging turned off
  
  connected to target database: DB01 (not mounted)
  using target database controlfile instead of
  recovery
  catalog
  
  RMAN
  executing command: SET DBID
  
  RMAN 2 3 4
  allocated channel: ci
  channel ci: sid=10 devtype=DISK
  
  Starting restore at 17-SEP-02
  
  channel ci: restoring controlfile
  channel ci: restore complete
  replicating controlfile
  input filename=/extracts1/DB01_temp/ctrl1.ctl
  output filename=/extracts1/DB01_temp/ctrl2.ctl
  output filename=/extracts1/DB01_temp/ctrl3.ctl
  Finished restore at 17-SEP-02
  released channel: ci
  
  RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
  15
  16
  allocated channel: c1
  channel c1: sid=10 devtype=DISK
  
  allocated channel: c2
  channel c2: sid=11 devtype=DISK
  
  allocated channel: c3
  channel c3: sid=12 devtype=DISK
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  Starting restore at 17-SEP-02
  
  released channel: c1
  released channel: c2
  released channel: c3
  RMAN-00571:
 

===
  RMAN-00569: === ERROR MESSAGE STACK
  FOLLOWS ===
  RMAN-00571:
 

===
  RMAN-03002: failure of restore command at
 09/17/2002
  08:27:16
  RMAN-06026: some targets not found - aborting
  restore
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 8
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 7
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 6
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 5
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 4
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 3
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 2
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 1
  
  
  
  
  
  __
  Do you Yahoo!?
  Yahoo! News - Today's headlines
  http://news.yahoo.com
  -- 
  Please see

How to get all the SQL statements executed by a user !!!!

2002-09-17 Thread Reddy, Madhusudana




Hello All,
How to get all the SQL 
statements executed by a user , when he logs back in next time  ( I do 
not wanted miss even single SQL statement)
Can somebody help me in this. 


Thanks,
Madhu





  
  
Upgrade 
  Outlook® - Add COLOR to 
  your Emails

  
Outlook® is a registered trademark of Microsoft 
  Corporation

Re: Moving data between tablespaces[Scanned]

2002-09-17 Thread Ora NT DBA


Hi Karthik,

When you moved the table it caused any indexes on this table to be 
marked as unusable.  This
is because the rows in the table now have different  rowid's.  You will 
need to rebuild the indexes
as well.  They don't have to be moved to a different tablespace but they 
will have to be rebuilt.

Hope this helps,
John

[EMAIL PROTECTED] wrote:

Thomas / Amar,

I moved the tables from SYSTEM to the DATA tablespace. But now I am getting the 
following error. 
ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in unusable 
state
Is it because of moving the table to a different tablespace or is it something else? 
TIA

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L


Karthik,

Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.

It will do exactly what you want.

You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Some of my tables are accidentally created in the SYSTEM tablespace. 
Is there any way to move the records and the table to some other tablespace?


regards,
Karthik 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Oracle Installer not launching in NT[Scanned]

2002-09-17 Thread Cornio, Georgette Ms USACFSC


This is NOT a bug with Pentium-III .

I have Ver 8.1.5 - 8.1.6 - 8.1.7 on NT  W2K PIIIs ,
 with NO Installer Problems.

They are all Dell or ComPAQ systems.

-Original Message-
Sent: Tuesday, September 17, 2002 01:33
To: Multiple recipients of list ORACLE-L


Hi,

It is an Oracle bug. There is a DLL called symcjit.dll. You have to rename
this DLL to something else  before running the installer. This bug occurs
when you are using Pentium-3 or above. 

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 8:28 AM
To: Multiple recipients of list ORACLE-L


I have s similar problem (Oracle Installer 8.1.6 / 8.1.7 not launching in
NT) but on a Pentium 3 with NT4 SP5, anyone has a workround?

Many thanks.

Kitty

-Original Message-
Heisler
Sent: 25 July, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L


If it's a Pentium 4, it's a known bug.  See MetaLink note 131299.1.  The
patch is 1507768.


Dennis



 [EMAIL PROTECTED] wrote:

 Hi List,

 I saw a similar post to this in the last 2 weeks, but deleted it
 (oops) as I am in a unix shop.  But I now have a client who is
 trying to install the oracle client on his nt box in order to demo our
 *product*.

 However, he can't get the installer to even launch.  He thinks its
 a Java VM conflict.

 Any ideas?  I need this rather quick so please also reply direct
 to me and in the meantime I will hit the internet.

 Thanks,

 Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis M. Heisler
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Kitty Luo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Cornio, Georgette Ms USACFSC
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Listener load balance

2002-09-17 Thread Ramon E. Estevez




Hi list,

Scenario Win2000 server, 8.1.7.

I added anetwork card to my DB Server. I want the 
listener to accept connections for the 2 IP address to make load balance. 
I just added a line to the listener file with a different port.

How can I assure that the port 1521 is listening for the net 
address 01 and the port 1526 in the address 02 ?


Is that correct ?

---

LISTENER = (DESCRIPTION_LIST = 
(DESCRIPTION = (ADDRESS_LIST 
= (ADDRESS = (PROTOCOL = IPC)(KEY 
= EXTPROC1)) 
) (ADDRESS_LIST 
= (ADDRESS = (PROTOCOL = TCP)(HOST 
= myserver)(PORT = 1521)) 
---Original (ADDRESS = 
(PROTOCOL = TCP)(HOST = myserver)(PORT = 1526)) --- 
Added ) 
) (DESCRIPTION = 
(PROTOCOL_STACK = (PRESENTATION = 
GIOP) (SESSION = 
RAW) ) 
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 2481)) 
) )

SID_LIST_LISTENER = (SID_LIST 
= (SID_DESC = (SID_NAME 
= PLSExtProc) (ORACLE_HOME = 
C:\Oracle\Ora8I) (PROGRAM = 
extproc) ) (SID_DESC 
= (GLOBAL_DBNAME = 
ORCL) (ORACLE_HOME = 
C:\Oracle\Ora8I) (SID_NAME = 
ORCL) ) )



TIA,


Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

Re: Another Character Set Problem

2002-09-17 Thread Hemant K Chitale



This command is NOT supported by Oracle and Oracle would not
guarantee that your data is not corrupted -- particularly if you have
not run the character-set-scanner to verify it.
Hemant

At 05:33 AM 17-09-02 -0800, you wrote:
To change the character set to another that is not recognized as a superset
use:
Alter database db-name character set INTERNAL_USE new_character_set

This parameter is active for oracle 8.1 and above.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 3:18 PM


  We are currently having a character set problem.  We have a
  third-party product that is used for on-line courses (Prometheus from
  Blackboard, Inc.).  The character set that the instance was created with
  was US7ASCII.  The vendor says it should be WE8ISO8859P1, but we need to
  support Chinese and Japanese characters.  I contacted Oracle support,
  and was told that the specified character set would not support those
  characters, but that I should use UTF8.  I altered the instance to use
  UTF8 and ran into a CLOB problem.  We installed patchset 4 (so we are
  now 8.1.7.4.0 on Sun Solaris 2.8) and that problem went away.  However,
  none of the CLOB data is rendered properly in the application and I
  don't have a tool that allows me to see it directly out of the database.
 
  I am tempted to try to change the character set to WE8ISO8859P1, as
  the vendor requested, with the hope that any deficiencies in that
  character set have been handled by their product.  At this point, can I
  change the instance from UTF8 to WE8ISO8859P1?  I do have a tar open on
  this issue and will be asking the same question there, but I'm hoping
  I'll get a response here faster (ok, I'm expecting that I will).
 
  Thank you.
 
  --
  Scott Canaan ([EMAIL PROTECTED])
  (585) 475-7886
  Life is like a sewer, what you get out of it depends on what you put
  into it. - Tom Lehrer.
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Scott Canaan
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 list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: SNP uses 60% of CPU on Windows2000 - please help

2002-09-17 Thread Thomas Day



I have had times on Win NT boxes when the CPU went to 100%.  My experience
is that this happens when the OS is thrashing the swapfile (writing it into
and out of memory on a  continuous basis).   If the disk I/O is also very
high then that may be what's happening.  However, 800M free out of 2G does
not look too bad.  If you don't have the high disk I/O then the SGA is
probably not the issue.  I don't want to push you in the wrong direction
either.

HTH



   

Inka  

Bezdziecka  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
IBezdziecka cc:   

@cupe.caSubject: RE: SNP uses 60% of CPU on 
Windows2000 - please help 
Sent by: root  

   

   

09/16/2002 

03:38 PM   

Please 

respond to 

ORACLE-L   

   

   





The server has 2GB, free at the moment 800MB. Do you think that SGA size
may have something to do with it?

-Original Message-
Sent: Monday, September 16, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L



How much physical RAM do you have and how much are you using?  Check the
Task Manager on the performance tab under MEM Usage to get that figure.




Inka
Bezdziecka  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
IBezdziecka cc:
@cupe.caSubject: SNP uses 60% of CPU
on Windows2000 - please help
Sent by: root


09/16/2002
01:13 PM
Please
respond to
ORACLE-L






Hello,
I run into a problem, which I cannot solve myself and would greatly
appreciate any help.

Oracle 8.1.7.0.0 utilises 99% of CPU on a Windows2000 server, which also
has to run MS IIS and a few applications.

There are 9 user connections (from MS IISv.5, using Oracle ODBC). There are
no waits, no locks, basic statistics values are very good.

I found the SNP process executing queued jobs using 60% of CPU. There are
no queued  jobs (current, broken or any other) in the neighbourhood, never
mind on that server.
The sql_text shows: BEGIN sys.dbms_ijob.remove(:job); END;

It seems, that the high usage is coincidental with creation of InterMedia
Text indices, which seems to be at least peculiar.

If anyone cares to push me in the right direction, I shall be eternally
grateful.

inka
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Inka Bezdziecka
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Thomas Day
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB

RE: RMAN restore to another node


Oracle support too pointed to that. I tested with
allocating 3 more channnels after 'set newname'. But
no change. They were released. and same error
followed.

--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Johnson
From what I read of your trace file, the channels
 are being released,
 presumably just before you need them. Do you have
 that explicitly coded in
 your RMAN recovery script, or are they being
 released for another reason. My
 immediate response is that maybe the problem lies in
 why those channels are
 being released. Can you move your channel commands
 after the SET NEWNAME
 commands?
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED] 
 
 
 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 9:23 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RMAN restore to another node
 
 
 Hi all,
 
 I am stuck on this restore for two days and Oracle
 support seems to offering little help. 
 
 I seem to be doing everything according to manuals
 and
 metalink notes  but am not able to do the restore.
 
 The case is I am restoring a database to another
 node.
 I have successfully restore the control file but
 when
 I tried to restore the database I get 
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 1 
 for every datafile.
 
 I am inserting the RMAN trace . I would appreciate
 if
 someone can lead in the right direction.
 Recovery Manager: Release 9.2.0.1.0 - Production
 
 Copyright (c) 1995, 2002, Oracle Corporation.  All
 rights reserved.
 
 ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
 System name:SunOS
 Node name:  EdwDev
 Release:5.8
 Version:Generic_108528-15
 Machine:sun4u
 
 Starting with debugging turned off
 
 connected to target database: DB01 (not mounted)
 using target database controlfile instead of
 recovery
 catalog
 
 RMAN
 executing command: SET DBID
 
 RMAN 2 3 4
 allocated channel: ci
 channel ci: sid=10 devtype=DISK
 
 Starting restore at 17-SEP-02
 
 channel ci: restoring controlfile
 channel ci: restore complete
 replicating controlfile
 input filename=/extracts1/DB01_temp/ctrl1.ctl
 output filename=/extracts1/DB01_temp/ctrl2.ctl
 output filename=/extracts1/DB01_temp/ctrl3.ctl
 Finished restore at 17-SEP-02
 released channel: ci
 
 RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
 15
 16
 allocated channel: c1
 channel c1: sid=10 devtype=DISK
 
 allocated channel: c2
 channel c2: sid=11 devtype=DISK
 
 allocated channel: c3
 channel c3: sid=12 devtype=DISK
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 Starting restore at 17-SEP-02
 
 released channel: c1
 released channel: c2
 released channel: c3
 RMAN-00571:

===
 RMAN-00569: === ERROR MESSAGE STACK
 FOLLOWS ===
 RMAN-00571:

===
 RMAN-03002: failure of restore command at 09/17/2002
 08:27:16
 RMAN-06026: some targets not found - aborting
 restore
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 8
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 7
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 6
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 5
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 4
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 3
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 2
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 1
 
 
 
 
 
 __
 Do you Yahoo!?
 Yahoo! News - Today's headlines
 http://news.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Johnson Poovathummoottil
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') 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).


__
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California

RE: RMAN restore to another node


I am restoring the whole database. 

regarding RMAN-06026   I think  RMAN is not able to
find where my backup piece is. For the controlfile I
could specify 'restore from' whereas that is not
allowed for database or datfiles.

--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
 My other question is, why are you getting this
 error:
 
  RMAN-06026: some targets not found - aborting
 restore
 
 
 Are you trying to restore all of the files, are just
 some of them?
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 10:20 AM
 To: Mercadante, Thomas F; '[EMAIL PROTECTED]'
 Cc: '[EMAIL PROTECTED]'
 Subject: RE: RMAN restore to another node
 
 
 my RMAN script is the following I have not released
 any channels explicitly.
 
 run
 {
 allocate channel c1 type disk;
 allocate channel c2 type disk;
 allocate channel c3 type disk;
 set newname for datafile 1 to 
 '/extracts1/DB01_temp/system_01a.dbf';
 set newname for datafile 2 to 
 '/extracts1/DB01_temp/rbslrg01.dbf';
 set newname for datafile 3 to 
 '/extracts1/DB01_temp/tools01.dbf';
 set newname for datafile 4 to 
 '/extracts1/DB01_temp/temp01.dbf';
 set newname for datafile 5 to 
 '/extracts1/DB01_temp/usersdata01.dbf';
 set newname for datafile 6 to 
 '/extracts1/DB01_temp/usersidx01.dbf';
 set newname for datafile 7 to 
 '/extracts1/DB01_temp/oem_repository.dbf';
 set newname for datafile 8 to 
 '/extracts1/DB01_temp/users01.dbf';
 restore database ;
 switch datafile all;
 }
 
 I tried allocating 3 additional channels just before
 'restore database;' but they too were released along
 with the original 3 and the same error followed.
 
 
 --- Mercadante, Thomas F
 [EMAIL PROTECTED]
 wrote:
  Joni,
  
  It looks like you are releasing the channels
 before
  you are finished with
  them.
  
  Can you add another ALLOCATE CHANNEL command
 before
  you attempt the RESTORE
  command?
  
  You did not provide the rman commands, so I am
 only
  guessing here - but that
  is what the error is telling you.  You do not have
  any channel's available
  for Rman to use.
  
  Good Luck.
  
  Tom Mercadante
  Oracle Certified Professional
  
  
  -Original Message-
  From: Johnson Poovathummoottil
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, September 17, 2002 10:23 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN restore to another node
  
  
  Hi all,
  
  I am stuck on this restore for two days and Oracle
  support seems to offering little help. 
  
  I seem to be doing everything according to manuals
  and
  metalink notes  but am not able to do the restore.
  
  The case is I am restoring a database to another
  node.
  I have successfully restore the control file but
  when
  I tried to restore the database I get 
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 1 
  for every datafile.
  
  I am inserting the RMAN trace . I would appreciate
  if
  someone can lead in the right direction.
  Recovery Manager: Release 9.2.0.1.0 - Production
  
  Copyright (c) 1995, 2002, Oracle Corporation.  All
  rights reserved.
  
  ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
  System name:SunOS
  Node name:  EdwDev
  Release:5.8
  Version:Generic_108528-15
  Machine:sun4u
  
  Starting with debugging turned off
  
  connected to target database: DB01 (not mounted)
  using target database controlfile instead of
  recovery
  catalog
  
  RMAN
  executing command: SET DBID
  
  RMAN 2 3 4
  allocated channel: ci
  channel ci: sid=10 devtype=DISK
  
  Starting restore at 17-SEP-02
  
  channel ci: restoring controlfile
  channel ci: restore complete
  replicating controlfile
  input filename=/extracts1/DB01_temp/ctrl1.ctl
  output filename=/extracts1/DB01_temp/ctrl2.ctl
  output filename=/extracts1/DB01_temp/ctrl3.ctl
  Finished restore at 17-SEP-02
  released channel: ci
  
  RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
  15
  16
  allocated channel: c1
  channel c1: sid=10 devtype=DISK
  
  allocated channel: c2
  channel c2: sid=11 devtype=DISK
  
  allocated channel: c3
  channel c3: sid=12 devtype=DISK
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  Starting restore at 17-SEP-02
  
  released channel: c1
  released channel: c2
  released channel: c3
  RMAN-00571:
 

===
  RMAN-00569: === ERROR MESSAGE STACK
  FOLLOWS ===
  RMAN-00571:
 

===
  RMAN-03002: failure of restore command at
 09/17/2002
  08:27:16
  RMAN-06026: some targets not found - aborting
  restore
  RMAN-06100: no channel to restore a backup or copy
  of

RE: RMAN restore to another node


My other question is, why are you getting this error:

 RMAN-06026: some targets not found - aborting restore


Are you trying to restore all of the files, are just some of them?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 10:20 AM
To: Mercadante, Thomas F; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


my RMAN script is the following I have not released
any channels explicitly.

run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
set newname for datafile 1 to 
'/extracts1/DB01_temp/system_01a.dbf';
set newname for datafile 2 to 
'/extracts1/DB01_temp/rbslrg01.dbf';
set newname for datafile 3 to 
'/extracts1/DB01_temp/tools01.dbf';
set newname for datafile 4 to 
'/extracts1/DB01_temp/temp01.dbf';
set newname for datafile 5 to 
'/extracts1/DB01_temp/usersdata01.dbf';
set newname for datafile 6 to 
'/extracts1/DB01_temp/usersidx01.dbf';
set newname for datafile 7 to 
'/extracts1/DB01_temp/oem_repository.dbf';
set newname for datafile 8 to 
'/extracts1/DB01_temp/users01.dbf';
restore database ;
switch datafile all;
}

I tried allocating 3 additional channels just before
'restore database;' but they too were released along
with the original 3 and the same error followed.


--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
 Joni,
 
 It looks like you are releasing the channels before
 you are finished with
 them.
 
 Can you add another ALLOCATE CHANNEL command before
 you attempt the RESTORE
 command?
 
 You did not provide the rman commands, so I am only
 guessing here - but that
 is what the error is telling you.  You do not have
 any channel's available
 for Rman to use.
 
 Good Luck.
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 10:23 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RMAN restore to another node
 
 
 Hi all,
 
 I am stuck on this restore for two days and Oracle
 support seems to offering little help. 
 
 I seem to be doing everything according to manuals
 and
 metalink notes  but am not able to do the restore.
 
 The case is I am restoring a database to another
 node.
 I have successfully restore the control file but
 when
 I tried to restore the database I get 
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 1 
 for every datafile.
 
 I am inserting the RMAN trace . I would appreciate
 if
 someone can lead in the right direction.
 Recovery Manager: Release 9.2.0.1.0 - Production
 
 Copyright (c) 1995, 2002, Oracle Corporation.  All
 rights reserved.
 
 ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
 System name:SunOS
 Node name:  EdwDev
 Release:5.8
 Version:Generic_108528-15
 Machine:sun4u
 
 Starting with debugging turned off
 
 connected to target database: DB01 (not mounted)
 using target database controlfile instead of
 recovery
 catalog
 
 RMAN
 executing command: SET DBID
 
 RMAN 2 3 4
 allocated channel: ci
 channel ci: sid=10 devtype=DISK
 
 Starting restore at 17-SEP-02
 
 channel ci: restoring controlfile
 channel ci: restore complete
 replicating controlfile
 input filename=/extracts1/DB01_temp/ctrl1.ctl
 output filename=/extracts1/DB01_temp/ctrl2.ctl
 output filename=/extracts1/DB01_temp/ctrl3.ctl
 Finished restore at 17-SEP-02
 released channel: ci
 
 RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
 15
 16
 allocated channel: c1
 channel c1: sid=10 devtype=DISK
 
 allocated channel: c2
 channel c2: sid=11 devtype=DISK
 
 allocated channel: c3
 channel c3: sid=12 devtype=DISK
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 Starting restore at 17-SEP-02
 
 released channel: c1
 released channel: c2
 released channel: c3
 RMAN-00571:

===
 RMAN-00569: === ERROR MESSAGE STACK
 FOLLOWS ===
 RMAN-00571:

===
 RMAN-03002: failure of restore command at 09/17/2002
 08:27:16
 RMAN-06026: some targets not found - aborting
 restore
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 8
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 7
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 6
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 5
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 4
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 3
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 2
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 1
 
 
 
 
 
 __
 Do you Yahoo!?
 Yahoo!

RE: RMAN restore to another node

2002-09-17 Thread Deborah Lorraine


Testing a duplicate of 9.2.0.1.0, I had that problem of channels releasing 
and then getting an error about no channel, and it turned out I needed a 
new MML library for 9i.

Now I have a problem that I can't restore the database unless I first 
delete all old datafiles.  This behavior is different than old versions, 
and in my opinion, a bug.

Have others encountered this issue?

Debi


At 07:13 AM 9/17/2002 -0800, you wrote:
Johnson - Did Oracle Support offer any theories on why the RMAN channels
were being spontaneously released? Is Oracle Support looking into this as a
possible bug, and you are just checking to see whether anyone else has
experienced this behavior?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, September 17, 2002 9:02 AM
To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Oracle support too pointed to that. I tested with
allocating 3 more channnels after 'set newname'. But
no change. They were released. and same error
followed.

--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
  Johnson
 From what I read of your trace file, the channels
  are being released,
  presumably just before you need them. Do you have
  that explicitly coded in
  your RMAN recovery script, or are they being
  released for another reason. My
  immediate response is that maybe the problem lies in
  why those channels are
  being released. Can you move your channel commands
  after the SET NEWNAME
  commands?
 
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
  mailto:[EMAIL PROTECTED]
 
 
  -Original Message-
  From: Johnson Poovathummoottil
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, September 17, 2002 9:23 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN restore to another node
 
 
  Hi all,
 
  I am stuck on this restore for two days and Oracle
  support seems to offering little help.
 
  I seem to be doing everything according to manuals
  and
  metalink notes  but am not able to do the restore.
 
  The case is I am restoring a database to another
  node.
  I have successfully restore the control file but
  when
  I tried to restore the database I get
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 1
  for every datafile.
 
  I am inserting the RMAN trace . I would appreciate
  if
  someone can lead in the right direction.
  Recovery Manager: Release 9.2.0.1.0 - Production
 
  Copyright (c) 1995, 2002, Oracle Corporation.  All
  rights reserved.
 
  ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
  System name:SunOS
  Node name:  EdwDev
  Release:5.8
  Version:Generic_108528-15
  Machine:sun4u
 
  Starting with debugging turned off
 
  connected to target database: DB01 (not mounted)
  using target database controlfile instead of
  recovery
  catalog
 
  RMAN
  executing command: SET DBID
 
  RMAN 2 3 4
  allocated channel: ci
  channel ci: sid=10 devtype=DISK
 
  Starting restore at 17-SEP-02
 
  channel ci: restoring controlfile
  channel ci: restore complete
  replicating controlfile
  input filename=/extracts1/DB01_temp/ctrl1.ctl
  output filename=/extracts1/DB01_temp/ctrl2.ctl
  output filename=/extracts1/DB01_temp/ctrl3.ctl
  Finished restore at 17-SEP-02
  released channel: ci
 
  RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
  15
  16
  allocated channel: c1
  channel c1: sid=10 devtype=DISK
 
  allocated channel: c2
  channel c2: sid=11 devtype=DISK
 
  allocated channel: c3
  channel c3: sid=12 devtype=DISK
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  Starting restore at 17-SEP-02
 
  released channel: c1
  released channel: c2
  released channel: c3
  RMAN-00571:
 
===
  RMAN-00569: === ERROR MESSAGE STACK
  FOLLOWS ===
  RMAN-00571:
 
===
  RMAN-03002: failure of restore command at 09/17/2002
  08:27:16
  RMAN-06026: some targets not found - aborting
  restore
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 8
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 7
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 6
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 5
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 4
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 3
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 2
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 1
 
 
 
 
 
  __
  Do you Yahoo!?
  Yahoo! News - Today's headlines
  http://news.yahoo.com
  --

RE: Oracle Installer not launching in NT[Scanned]

2002-09-17 Thread Bishop Lewis


No, I don't believe it is the bug either (just seen references to problems
with P4's). It's obviously something to do with Java - I have had problems
like this with dbassist when memory has been short.

If reinstalling Java does not do it for you try stopping all necessary
background processes and trying again... otherwise check memory and
pagefaile settings...

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]
 

-Original Message-
Sent: 17 September 2002 17:08
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

This is NOT a bug with Pentium-III .

I have Ver 8.1.5 - 8.1.6 - 8.1.7 on NT  W2K PIIIs ,
 with NO Installer Problems.

They are all Dell or ComPAQ systems.

-Original Message-
Sent: Tuesday, September 17, 2002 01:33
To: Multiple recipients of list ORACLE-L


Hi,

It is an Oracle bug. There is a DLL called symcjit.dll. You have to rename
this DLL to something else  before running the installer. This bug occurs
when you are using Pentium-3 or above. 

regards,
Karthik 

-Original Message-
Sent: Tuesday, September 17, 2002 8:28 AM
To: Multiple recipients of list ORACLE-L


I have s similar problem (Oracle Installer 8.1.6 / 8.1.7 not launching in
NT) but on a Pentium 3 with NT4 SP5, anyone has a workround?

Many thanks.

Kitty

-Original Message-
Heisler
Sent: 25 July, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L


If it's a Pentium 4, it's a known bug.  See MetaLink note 131299.1.  The
patch is 1507768.


Dennis



 [EMAIL PROTECTED] wrote:

 Hi List,

 I saw a similar post to this in the last 2 weeks, but deleted it
 (oops) as I am in a unix shop.  But I now have a client who is
 trying to install the oracle client on his nt box in order to demo our
 *product*.

 However, he can't get the installer to even launch.  He thinks its
 a Java VM conflict.

 Any ideas?  I need this rather quick so please also reply direct
 to me and in the meantime I will hit the internet.

 Thanks,

 Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis M. Heisler
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Kitty Luo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Karthikeyan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Cornio, Georgette Ms USACFSC
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).


The information, attachments and opinions contained in this message are those of its 
author only and

RE: RMAN restore to another node


Joni,

It looks like you are releasing the channels before you are finished with
them.

Can you add another ALLOCATE CHANNEL command before you attempt the RESTORE
command?

You did not provide the rman commands, so I am only guessing here - but that
is what the error is telling you.  You do not have any channel's available
for Rman to use.

Good Luck.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I am stuck on this restore for two days and Oracle
support seems to offering little help. 

I seem to be doing everything according to manuals and
metalink notes  but am not able to do the restore.

The case is I am restoring a database to another node.
I have successfully restore the control file but when
I tried to restore the database I get 
RMAN-06100: no channel to restore a backup or copy of
datafile 1 
for every datafile.

I am inserting the RMAN trace . I would appreciate if
someone can lead in the right direction.
Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All
rights reserved.

ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
System name:SunOS
Node name:  EdwDev
Release:5.8
Version:Generic_108528-15
Machine:sun4u

Starting with debugging turned off

connected to target database: DB01 (not mounted)
using target database controlfile instead of recovery
catalog

RMAN
executing command: SET DBID

RMAN 2 3 4
allocated channel: ci
channel ci: sid=10 devtype=DISK

Starting restore at 17-SEP-02

channel ci: restoring controlfile
channel ci: restore complete
replicating controlfile
input filename=/extracts1/DB01_temp/ctrl1.ctl
output filename=/extracts1/DB01_temp/ctrl2.ctl
output filename=/extracts1/DB01_temp/ctrl3.ctl
Finished restore at 17-SEP-02
released channel: ci

RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15
16
allocated channel: c1
channel c1: sid=10 devtype=DISK

allocated channel: c2
channel c2: sid=11 devtype=DISK

allocated channel: c3
channel c3: sid=12 devtype=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 17-SEP-02

released channel: c1
released channel: c2
released channel: c3
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK
FOLLOWS ===
RMAN-00571:
===
RMAN-03002: failure of restore command at 09/17/2002
08:27:16
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of
datafile 8
RMAN-06100: no channel to restore a backup or copy of
datafile 7
RMAN-06100: no channel to restore a backup or copy of
datafile 6
RMAN-06100: no channel to restore a backup or copy of
datafile 5
RMAN-06100: no channel to restore a backup or copy of
datafile 4
RMAN-06100: no channel to restore a backup or copy of
datafile 3
RMAN-06100: no channel to restore a backup or copy of
datafile 2
RMAN-06100: no channel to restore a backup or copy of
datafile 1





__
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

_spin_count Revealed

2002-09-17 Thread Fink, Dan




I have learned that 
my information was incorrect. A negative value for spin count is not to be used 
for reversing transactions. It is to be used for those systems in the southern 
hemisphere to insure that the disks spin counter-clockwise.

I sincerely 
apologize for this mistake and hope the list will forgive 
me.

Dan

RE: Tracking Temp Segment Usage and Event 10046


Raj - I personally favor using the simpler diagnostics first. Why not run
your SQL through EXPLAIN PLAN and see which SQL is performing sorts? My
immediate guess is that under RBO an index was being used that isn't now.
 
 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
 

-Original Message-
Sent: Tuesday, September 17, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L



I have a problem with a process and its temp segment usage. 

Previously, in RBO (8161) we used to run 8 reports with slightly different
parameters in parallel and it used to work fine with all other load on the
system and the total TEMP space was 6GB

Since we migrated to CBO (all tables  indexes are analyzed using estimate),
these processes fail with unable to extent temp segment error. Currently we
have allocated 12GB to temp tablespace.

I also have performance issues so I am doing a 10046 trace at level 8 on
this one. Is there a way to identify when this process used temp space, how
much and when does it de-allocate?

Would this information be available in 10046 trace or is there something
else that I could do to track that ... 

Thanks in advance 
Raj 
__ 
Rajendra Jamadagni  MIS, ESPN Inc. 
Rajendra dot Jamadagni at ESPN dot com 
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art! 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

How to create a directory alias on Suse Linux7.3 to insert an external PDF file into BFILE column.

2002-09-17 Thread Meomeo Nguyen

Hi,
I just wanted to create a directory alias on SuSe Linux7.3 in order to insert an external PDF file into BFILE column. Anyone please show me how to do so.
On Window:
CREATE or REPLACE DIRECTORY TEST as 'c:\images' ;
On Linux: I issues this below command
CREATE or REPLACE DIRECTORY TEST as '/Disk05/images' ;
When using DBMS_LOB.fileexiststs function to test the existence of the file, but the specified fiel does not exist, Fileexists return zero.
please note that I've already stored a specified file on /Disk05/images. 
Thanks in advance
LenkaDo you Yahoo!?
Yahoo! News - Today's headlines

Profile

2002-09-17 Thread Joe Frohne


Good Morning,

Is there much/any overhead associated with turning the resource_limit on
and enacting profiles to limit user resources?

Thanks,

Joe Frohne
UW-Milwaukee, DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Frohne
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: bug number 2429929

2002-09-17 Thread Jesse, Rich


The bug is generic.  And a quick create of a 9.2.0.1 DB on Winders for me
seems to support that.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Monday, September 16, 2002 7:44 PM
To: Multiple recipients of list ORACLE-L


Hi Guys ,
 
Do you guys have any update on bug number 2429929 , which is SID values in
v$session and v$session_event does not match  .  Do you see this bug on
solaris also , cuz metalink says this is on digital unix.
 
Thanks ,
Bp
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: RMAN restore to another node


my RMAN script is the following I have not released
any channels explicitly.

run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
set newname for datafile 1 to 
'/extracts1/DB01_temp/system_01a.dbf';
set newname for datafile 2 to 
'/extracts1/DB01_temp/rbslrg01.dbf';
set newname for datafile 3 to 
'/extracts1/DB01_temp/tools01.dbf';
set newname for datafile 4 to 
'/extracts1/DB01_temp/temp01.dbf';
set newname for datafile 5 to 
'/extracts1/DB01_temp/usersdata01.dbf';
set newname for datafile 6 to 
'/extracts1/DB01_temp/usersidx01.dbf';
set newname for datafile 7 to 
'/extracts1/DB01_temp/oem_repository.dbf';
set newname for datafile 8 to 
'/extracts1/DB01_temp/users01.dbf';
restore database ;
switch datafile all;
}

I tried allocating 3 additional channels just before
'restore database;' but they too were released along
with the original 3 and the same error followed.


--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
 Joni,
 
 It looks like you are releasing the channels before
 you are finished with
 them.
 
 Can you add another ALLOCATE CHANNEL command before
 you attempt the RESTORE
 command?
 
 You did not provide the rman commands, so I am only
 guessing here - but that
 is what the error is telling you.  You do not have
 any channel's available
 for Rman to use.
 
 Good Luck.
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 10:23 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RMAN restore to another node
 
 
 Hi all,
 
 I am stuck on this restore for two days and Oracle
 support seems to offering little help. 
 
 I seem to be doing everything according to manuals
 and
 metalink notes  but am not able to do the restore.
 
 The case is I am restoring a database to another
 node.
 I have successfully restore the control file but
 when
 I tried to restore the database I get 
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 1 
 for every datafile.
 
 I am inserting the RMAN trace . I would appreciate
 if
 someone can lead in the right direction.
 Recovery Manager: Release 9.2.0.1.0 - Production
 
 Copyright (c) 1995, 2002, Oracle Corporation.  All
 rights reserved.
 
 ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
 System name:SunOS
 Node name:  EdwDev
 Release:5.8
 Version:Generic_108528-15
 Machine:sun4u
 
 Starting with debugging turned off
 
 connected to target database: DB01 (not mounted)
 using target database controlfile instead of
 recovery
 catalog
 
 RMAN
 executing command: SET DBID
 
 RMAN 2 3 4
 allocated channel: ci
 channel ci: sid=10 devtype=DISK
 
 Starting restore at 17-SEP-02
 
 channel ci: restoring controlfile
 channel ci: restore complete
 replicating controlfile
 input filename=/extracts1/DB01_temp/ctrl1.ctl
 output filename=/extracts1/DB01_temp/ctrl2.ctl
 output filename=/extracts1/DB01_temp/ctrl3.ctl
 Finished restore at 17-SEP-02
 released channel: ci
 
 RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
 15
 16
 allocated channel: c1
 channel c1: sid=10 devtype=DISK
 
 allocated channel: c2
 channel c2: sid=11 devtype=DISK
 
 allocated channel: c3
 channel c3: sid=12 devtype=DISK
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 executing command: SET NEWNAME
 
 Starting restore at 17-SEP-02
 
 released channel: c1
 released channel: c2
 released channel: c3
 RMAN-00571:

===
 RMAN-00569: === ERROR MESSAGE STACK
 FOLLOWS ===
 RMAN-00571:

===
 RMAN-03002: failure of restore command at 09/17/2002
 08:27:16
 RMAN-06026: some targets not found - aborting
 restore
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 8
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 7
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 6
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 5
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 4
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 3
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 2
 RMAN-06100: no channel to restore a backup or copy
 of
 datafile 1
 
 
 
 
 
 __
 Do you Yahoo!?
 Yahoo! News - Today's headlines
 http://news.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Johnson Poovathummoottil
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

How to Call C Routine from PL/SQL

2002-09-17 Thread Suman S K


 Hi Everybody,


I want to call C Program routine from PL/SQL. What all things I need
to do.


Thanks
Suman



DISCLAIMER: Information contained and transmitted by this E-MAIL is
proprietary to Mascot Systems Limited and is intended for use only by the
individual or entity to which it is addressed, and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law. If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible for
delivering the information to the named recipient, you are notified that any
use, distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail  notify us
immediately at [EMAIL PROTECTED] Before opening attachments,
please scan for viruses. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suman S K
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

bug number 2429929

2002-09-17 Thread BigP





Hi 
Guys ,

Do 
you guys have any update on bug number 2429929 , which is "SID values in 
v$session and v$session_event does not match " . Do you see this bug on 
solaris also , cuz metalink says this is on digital unix.

Thanks 
,
Bp

RE: SNP uses 60% of CPU on Windows2000 - please help

2002-09-17 Thread Inka Bezdziecka


Thanks,
my problem is that I hardly know how to spell Windows. Performance monitor shows 
Paging file usage at zero. 

On Oracle side I altered system and set job_queue _process = 1.

when I run 
select vb.name NOME, vp.program PROCESSNAME, 
vp.spid THREADID, vs.sid SID, vs.program
from v$session vs, v$process vp, v$bgprocess vb 
where vb.paddr  '00' and 
vb.paddr = vp.addr and 
vp.addr = vs.paddr;

I got an output:
NOMEPROCESSNAME THREADIDSID PROGRAM
PMONORACLE.EXE  15801   ORACLE.EXE
DBW0ORACLE.EXE  14042   ORACLE.EXE
LGWRORACLE.EXE  15843   ORACLE.EXE
CKPTORACLE.EXE  15884   ORACLE.EXE
SMONORACLE.EXE  15925   ORACLE.EXE
RECOORACLE.EXE  15966   ORACLE.EXE
SNP0ORACLE.EXE  16007   
SNP2ORACLE.EXE  262435  dllhost.exe
SNP3ORACLE.EXE  25328   dllhost.exe
ARC0ORACLE.EXE  163611  ORACLE.EXE
SNP4ORACLE.EXE  178418  dllhost.exe
SNP5ORACLE.EXE  644 23  dllhost.exe

As far as I know, dllhost.exe is ASP execution engine. So the culprit may be on the 
application side, not Oracle.

Does that make any sense?

inka



-Original Message-
Sent: Tuesday, September 17, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L



I have had times on Win NT boxes when the CPU went to 100%.  My experience
is that this happens when the OS is thrashing the swapfile (writing it into
and out of memory on a  continuous basis).   If the disk I/O is also very
high then that may be what's happening.  However, 800M free out of 2G does
not look too bad.  If you don't have the high disk I/O then the SGA is
probably not the issue.  I don't want to push you in the wrong direction
either.

HTH



   

Inka  

Bezdziecka  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
IBezdziecka cc:   

@cupe.caSubject: RE: SNP uses 60% of CPU on 
Windows2000 - please help 
Sent by: root  

   

   

09/16/2002 

03:38 PM   

Please 

respond to 

ORACLE-L   

   

   





The server has 2GB, free at the moment 800MB. Do you think that SGA size
may have something to do with it?

-Original Message-
Sent: Monday, September 16, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L



How much physical RAM do you have and how much are you using?  Check the
Task Manager on the performance tab under MEM Usage to get that figure.




Inka
Bezdziecka  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
IBezdziecka cc:
@cupe.caSubject: SNP uses 60% of CPU
on Windows2000 - please help
Sent by: root


09/16/2002
01:13 PM
Please
respond to
ORACLE-L






Hello,
I run into a problem, which I cannot solve myself and would greatly
appreciate any help.

Oracle 8.1.7.0.0 utilises 99% of CPU on a Windows2000 server, which also
has to run MS IIS and a few applications.

There are 9 user connections (from MS IISv.5, using Oracle ODBC). There are
no waits, no locks, basic statistics values are very good.

I found the SNP process executing queued jobs using 60% of CPU. There are
no queued  jobs (current, broken or any other) in the neighbourhood, never
mind on that server.
The sql_text shows: BEGIN sys.dbms_ijob.remove(:job); END;

It seems, that the high

RE: How to get all the SQL statements executed by a user !!!!

2002-09-17 Thread Cary Millsap










alter session set sql_trace=true;



Make this the first statement the user
executes upon login. If you dont have control over the users
source code, you can put the alter session command into a trigger that fires
when he logs in.





Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Oct
13 San Francisco, Oct 1517 Dallas, Dec 911 Honolulu
- 2003 Hotsos Symposium on
Oracle System Performance, Feb 912 Dallas
- Next event: Miracle Database Forum, Sep
2022 Middlefart Denmark



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Reddy,
Madhusudana
Sent: Tuesday, September 17, 2002
10:53 AM
To: Multiple recipients of list
ORACLE-L
Subject: How to get all the SQL
statements executed by a user 





Hello All,





How to get all
the SQL statements executed by a user , when he logs back in next time
 ( I do not wanted miss even single SQL statement)





Can somebody
help me in this. 











Thanks,





Madhu
























 
  
  Upgrade
  Outlook - Add COLOR to your Emails
  
  
  
  
 
 
  
  Outlook
  is a registered trademark of Microsoft Corporation

migration to oracle 9i

2002-09-17 Thread BigP




Hi Guys ,
I know this question might have apperaed in this 
many times and I just neglected it cuzI was not interested in it. But now 
I am asking same question . We are runnning oracle bi ( 8.1.7) database , since 
recently it has been decided to move our iplanet LDAP server to oracle 9i LDAP 
we are considering migrating our database also to oracle 9i . Now my question 
is a) what version oracle 9i is most stable 9.1.0.2 . Are there any 
issues which we should be concerned about .I am sure many of you have done 
this migration .I would like to know your experience .

Thanks ,
Bp

RE: Listener load balance

2002-09-17 Thread Kevin Lange




Your 
HOSTNAME of 'myserver' would tell you which.

Since 
you have the same hostname on the listener, both ports would currently be using 
the same IP address.

Did 
you setup DNS so that the cards share a Hostname ?

  -Original Message-From: Ramon E. Estevez 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 17, 
  2002 9:43 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Listener load balance
  Hi list,
  
  Scenario Win2000 server, 8.1.7.
  
  I added anetwork card to my DB Server. I want 
  the listener to accept connections for the 2 IP address to make load 
  balance. I just added a line to the listener file with a different 
  port.
  
  How can I assure that the port 1521 is listening for the net 
  address 01 and the port 1526 in the address 02 ?
  
  
  Is that correct ?
  
  ---
  
  LISTENER = (DESCRIPTION_LIST 
  = (DESCRIPTION = 
  (ADDRESS_LIST = (ADDRESS = 
  (PROTOCOL = IPC)(KEY = EXTPROC1)) 
  ) (ADDRESS_LIST 
  = (ADDRESS = (PROTOCOL = 
  TCP)(HOST = myserver)(PORT = 1521)) 
  ---Original (ADDRESS = 
  (PROTOCOL = TCP)(HOST = myserver)(PORT = 1526)) --- 
  Added ) 
  ) (DESCRIPTION = 
  (PROTOCOL_STACK = (PRESENTATION 
  = GIOP) (SESSION = 
  RAW) ) 
  (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 
  2481)) ) )
  
  SID_LIST_LISTENER = (SID_LIST 
  = (SID_DESC = 
  (SID_NAME = PLSExtProc) (ORACLE_HOME = 
  C:\Oracle\Ora8I) (PROGRAM = 
  extproc) ) (SID_DESC 
  = (GLOBAL_DBNAME = 
  ORCL) (ORACLE_HOME = 
  C:\Oracle\Ora8I) (SID_NAME = 
  ORCL) ) )
  
  
  
  TIA,
  
  
  Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

Re: How to Call C Routine from PL/SQL

2002-09-17 Thread Tim Gorman


Read up in the standard PL/SQL Reference manual on external procedures.
It will explain everything very well...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 10:23 AM


 Hi Everybody,


 I want to call C Program routine from PL/SQL. What all things I need
 to do.


 Thanks
 Suman



 DISCLAIMER: Information contained and transmitted by this E-MAIL is
 proprietary to Mascot Systems Limited and is intended for use only by the
 individual or entity to which it is addressed, and may contain information
 that is privileged, confidential or exempt from disclosure under
applicable
 law. If this is a forwarded message, the content of this E-MAIL may not
have
 been sent with the authority of the Company. If you are not the intended
 recipient, an agent of the intended recipient or a person responsible for
 delivering the information to the named recipient, you are notified that
any
 use, distribution, transmission, printing, copying or dissemination of
this
 information in any way or in any manner is strictly prohibited. If you
have
 received this communication in error, please delete this mail  notify us
 immediately at [EMAIL PROTECTED] Before opening attachments,
 please scan for viruses.


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Suman S K
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: RMAN restore to another node


Johnson
   Their explanation doesn't make sense to me. I have had RMAN fail to get
the backup piece, and the error message is very clear.
   Just in case the SET NEWNAME is somehow affecting the recovery, you might
take them out just to see what happens. I would also have moved the ALLOCATE
CHANNEL below the SET NEWNAME, rather than opening a new set of channels,
but then I haven't used SET NEWNAME. I just had my Unix sys admin create
mount points named the same as the mount points on the production system. 
   Perhaps someone can post an RMAN recovery script that includes a SET
NEWNAME, so you can compare. You might also post your recovery script, that
might clarify something.
   Also, this is Oracle 9.2, and most of my RMAN practice has been on Oracle
8.1.6.
   Another thought for a test is to backup the production control file
separately and then place it where it is needed, rather than have RMAN
recover it. I'm just wondering whether you are getting some side-effect from
the successful control file recovery. 
 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, September 17, 2002 9:16 AM
To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'


They are alluding it to a possibilty that RMAN cannot
find the backup piece and just before showing the
error it realeasing channels and that releasing
channels per se does not point to any problem.

--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Johnson - Did Oracle Support offer any theories on
 why the RMAN channels
 were being spontaneously released? Is Oracle Support
 looking into this as a
 possible bug, and you are just checking to see
 whether anyone else has
 experienced this behavior?
  
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED] 
 
 
 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 9:02 AM
 To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
 Cc: '[EMAIL PROTECTED]'
 Subject: RE: RMAN restore to another node
 
 
 Oracle support too pointed to that. I tested with
 allocating 3 more channnels after 'set newname'. But
 no change. They were released. and same error
 followed.
 
 --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
  Johnson
 From what I read of your trace file, the
 channels
  are being released,
  presumably just before you need them. Do you have
  that explicitly coded in
  your RMAN recovery script, or are they being
  released for another reason. My
  immediate response is that maybe the problem lies
 in
  why those channels are
  being released. Can you move your channel commands
  after the SET NEWNAME
  commands?
  
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
  mailto:[EMAIL PROTECTED] 
  
  
  -Original Message-
  From: Johnson Poovathummoottil
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, September 17, 2002 9:23 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN restore to another node
  
  
  Hi all,
  
  I am stuck on this restore for two days and Oracle
  support seems to offering little help. 
  
  I seem to be doing everything according to manuals
  and
  metalink notes  but am not able to do the restore.
  
  The case is I am restoring a database to another
  node.
  I have successfully restore the control file but
  when
  I tried to restore the database I get 
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 1 
  for every datafile.
  
  I am inserting the RMAN trace . I would appreciate
  if
  someone can lead in the right direction.
  Recovery Manager: Release 9.2.0.1.0 - Production
  
  Copyright (c) 1995, 2002, Oracle Corporation.  All
  rights reserved.
  
  ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
  System name:SunOS
  Node name:  EdwDev
  Release:5.8
  Version:Generic_108528-15
  Machine:sun4u
  
  Starting with debugging turned off
  
  connected to target database: DB01 (not mounted)
  using target database controlfile instead of
  recovery
  catalog
  
  RMAN
  executing command: SET DBID
  
  RMAN 2 3 4
  allocated channel: ci
  channel ci: sid=10 devtype=DISK
  
  Starting restore at 17-SEP-02
  
  channel ci: restoring controlfile
  channel ci: restore complete
  replicating controlfile
  input filename=/extracts1/DB01_temp/ctrl1.ctl
  output filename=/extracts1/DB01_temp/ctrl2.ctl
  output filename=/extracts1/DB01_temp/ctrl3.ctl
  Finished restore at 17-SEP-02
  released channel: ci
  
  RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
  15
  16
  allocated channel: c1
  channel c1: sid=10 devtype=DISK
  
  allocated channel: c2
  channel c2: sid=11 devtype=DISK
  
  allocated channel: c3
  channel c3: sid=12 devtype=DISK
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME

RE: RMAN restore to another node

2002-09-17 Thread Mike Killough


You are allocating an auxilliary channel?

connect catalog rman/manager@rcat
connect target system/manager@db1
connect auxiliary system/manager as sysdba

run {
set until time '17-SEP-2002 08:30:39';
allocate auxiliary channel disk1 type disk;

set newname for datafile 1 to '/ot2_01/oradata/db1/system01.dbf';
set newname for datafile 2 to '/ot2_01/oradata/db1/undotbs01.dbf';
set newname for datafile 3 to '/ot2_01/oradata/db1/drsys01.dbf';
...
set newname for datafile 70 to '/ot2_01/oradata/db1/users01.dbf';
duplicate target database to db2
logfile '/ot2_01/oradata/db2/redo01.log' size 100M,
'/ot2_01/oradata/db2/redo02.log' size 100M,
'/ot2_01/oradata/db2/redo03.log' size 100M;
}





From: Johnson Poovathummoottil [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RMAN restore to another node
Date: Tue, 17 Sep 2002 07:43:28 -0800

I tried that too. But did it not help. here is the
ouput.

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

allocated channel: c1
channel c1: sid=10 devtype=DISK

allocated channel: c2
channel c2: sid=11 devtype=DISK
allocated channel: c3
channel c3: sid=12 devtype=DISK

Starting restore at 17-SEP-02

released channel: c1
released channel: c2
released channel: c3
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK
FOLLOWS ===
RMAN-00571:
===
RMAN-03002: failure of restore command at 09/17/2002
10:29:13
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of
datafile 8
RMAN-06100: no channel to restore a backup or copy of
datafile 7
RMAN-06100: no channel to restore a backup or copy of
datafile 6
RMAN-06100: no channel to restore a backup or copy of
datafile 5
RMAN-06100: no channel to restore a backup or copy of
datafile 4
RMAN-06100: no channel to restore a backup or copy of
datafile 3
RMAN-06100: no channel to restore a backup or copy of
datafile 2
RMAN-06100: no channel to restore a backup or copy of
datafile 1


--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
  Johnson
 Their explanation doesn't make sense to me. I
  have had RMAN fail to get
  the backup piece, and the error message is very
  clear.
 Just in case the SET NEWNAME is somehow affecting
  the recovery, you might
  take them out just to see what happens. I would also
  have moved the ALLOCATE
  CHANNEL below the SET NEWNAME, rather than opening a
  new set of channels,
  but then I haven't used SET NEWNAME. I just had my
  Unix sys admin create
  mount points named the same as the mount points on
  the production system.
 Perhaps someone can post an RMAN recovery script
  that includes a SET
  NEWNAME, so you can compare. You might also post
  your recovery script, that
  might clarify something.
 Also, this is Oracle 9.2, and most of my RMAN
  practice has been on Oracle
  8.1.6.
 Another thought for a test is to backup the
  production control file
  separately and then place it where it is needed,
  rather than have RMAN
  recover it. I'm just wondering whether you are
  getting some side-effect from
  the successful control file recovery.
   
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
  mailto:[EMAIL PROTECTED]
 
 
  -Original Message-
  From: Johnson Poovathummoottil
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, September 17, 2002 9:16 AM
  To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
  Subject: RE: RMAN restore to another node
 
 
  They are alluding it to a possibilty that RMAN
  cannot
  find the backup piece and just before showing the
  error it realeasing channels and that releasing
  channels per se does not point to any problem.
 
  --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
   Johnson - Did Oracle Support offer any theories on
   why the RMAN channels
   were being spontaneously released? Is Oracle
  Support
   looking into this as a
   possible bug, and you are just checking to see
   whether anyone else has
   experienced this behavior?
    
   Dennis Williams
   DBA
   Lifetouch, Inc.
   [EMAIL PROTECTED]
   mailto:[EMAIL PROTECTED]
  
  
   -Original Message-
   From: Johnson Poovathummoottil
   [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, September 17, 2002 9:02 AM
   To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
   Cc: '[EMAIL PROTECTED]'
   Subject: RE: RMAN restore to another node
  
  
   Oracle support too pointed to that. I tested with
   allocating 3 more channnels after 'set newname'.
  But
   no change. They were released. and same error
   followed.
  
   --- DENNIS WILLIAMS [EMAIL PROTECTED]
  wrote:
Johnson
   From what I read of your trace file, the
   channels
are being

Re: Shutdown and startup processes


Hello Willie

We are using startup trigger that calls a Java function that sends an
MQSeries message to the mainframe.
Maybe you could use a Java function that will close and open the scheduler.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 8:13 PM


 Gurus,

 I need to implement a process to startup/shutdown a PeopleSoft Unix batch
 scheduler job whenever the Oracle instance is shutdown or started back up.
 Does anyone know of a way to tie this process to an Oracle Instance to get
 invoked at shutdown/startup time?


 Willie Townsend
 Alverno Information Services
 Supervisor (Database Administration)
 317-532-7800 X'6265'
 eMail:  [EMAIL PROTECTED]


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Townsend Willie
   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 list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: bug number 2429929

2002-09-17 Thread Jamadagni, Rajendra

Title: RE: bug number 2429929





This will be fixed in 9203, I learned this AM, dev rejected our request for exception patch.


Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: bug number 2429929



The bug is generic. And a quick create of a 9.2.0.1 DB on Winders for me
seems to support that.


Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA




*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: RMAN restore to another node


OK.  I'll ask.   

Where is the backup piece?  Is it in a same named directory as in the other
machine?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 12:48 PM
To: Multiple recipients of list ORACLE-L


I am restoring the whole database. 

regarding RMAN-06026   I think  RMAN is not able to
find where my backup piece is. For the controlfile I
could specify 'restore from' whereas that is not
allowed for database or datfiles.

--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
 My other question is, why are you getting this
 error:
 
  RMAN-06026: some targets not found - aborting
 restore
 
 
 Are you trying to restore all of the files, are just
 some of them?
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 10:20 AM
 To: Mercadante, Thomas F; '[EMAIL PROTECTED]'
 Cc: '[EMAIL PROTECTED]'
 Subject: RE: RMAN restore to another node
 
 
 my RMAN script is the following I have not released
 any channels explicitly.
 
 run
 {
 allocate channel c1 type disk;
 allocate channel c2 type disk;
 allocate channel c3 type disk;
 set newname for datafile 1 to 
 '/extracts1/DB01_temp/system_01a.dbf';
 set newname for datafile 2 to 
 '/extracts1/DB01_temp/rbslrg01.dbf';
 set newname for datafile 3 to 
 '/extracts1/DB01_temp/tools01.dbf';
 set newname for datafile 4 to 
 '/extracts1/DB01_temp/temp01.dbf';
 set newname for datafile 5 to 
 '/extracts1/DB01_temp/usersdata01.dbf';
 set newname for datafile 6 to 
 '/extracts1/DB01_temp/usersidx01.dbf';
 set newname for datafile 7 to 
 '/extracts1/DB01_temp/oem_repository.dbf';
 set newname for datafile 8 to 
 '/extracts1/DB01_temp/users01.dbf';
 restore database ;
 switch datafile all;
 }
 
 I tried allocating 3 additional channels just before
 'restore database;' but they too were released along
 with the original 3 and the same error followed.
 
 
 --- Mercadante, Thomas F
 [EMAIL PROTECTED]
 wrote:
  Joni,
  
  It looks like you are releasing the channels
 before
  you are finished with
  them.
  
  Can you add another ALLOCATE CHANNEL command
 before
  you attempt the RESTORE
  command?
  
  You did not provide the rman commands, so I am
 only
  guessing here - but that
  is what the error is telling you.  You do not have
  any channel's available
  for Rman to use.
  
  Good Luck.
  
  Tom Mercadante
  Oracle Certified Professional
  
  
  -Original Message-
  From: Johnson Poovathummoottil
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, September 17, 2002 10:23 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN restore to another node
  
  
  Hi all,
  
  I am stuck on this restore for two days and Oracle
  support seems to offering little help. 
  
  I seem to be doing everything according to manuals
  and
  metalink notes  but am not able to do the restore.
  
  The case is I am restoring a database to another
  node.
  I have successfully restore the control file but
  when
  I tried to restore the database I get 
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 1 
  for every datafile.
  
  I am inserting the RMAN trace . I would appreciate
  if
  someone can lead in the right direction.
  Recovery Manager: Release 9.2.0.1.0 - Production
  
  Copyright (c) 1995, 2002, Oracle Corporation.  All
  rights reserved.
  
  ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
  System name:SunOS
  Node name:  EdwDev
  Release:5.8
  Version:Generic_108528-15
  Machine:sun4u
  
  Starting with debugging turned off
  
  connected to target database: DB01 (not mounted)
  using target database controlfile instead of
  recovery
  catalog
  
  RMAN
  executing command: SET DBID
  
  RMAN 2 3 4
  allocated channel: ci
  channel ci: sid=10 devtype=DISK
  
  Starting restore at 17-SEP-02
  
  channel ci: restoring controlfile
  channel ci: restore complete
  replicating controlfile
  input filename=/extracts1/DB01_temp/ctrl1.ctl
  output filename=/extracts1/DB01_temp/ctrl2.ctl
  output filename=/extracts1/DB01_temp/ctrl3.ctl
  Finished restore at 17-SEP-02
  released channel: ci
  
  RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
  15
  16
  allocated channel: c1
  channel c1: sid=10 devtype=DISK
  
  allocated channel: c2
  channel c2: sid=11 devtype=DISK
  
  allocated channel: c3
  channel c3: sid=12 devtype=DISK
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  executing command: SET NEWNAME
  
  Starting restore at 17-SEP-02
  
  released channel: c1
  released channel: c2
  released channel: c3
  RMAN-00571:
 

===
  RMAN-00569: === ERROR MESSAGE STACK
  FOLLOWS

Unable to down Oracle 9.2 for Linux or Tru64

2002-09-17 Thread Browett, Darren


Can anybody else, would like to know if this is a problem with
download.oracle.com
or my site.

Thanks

Darren


--
Darren Browett P.EngThis
message was transmitted
Data Administrator  using
100% recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Browett, Darren
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: How to Call C Routine from PL/SQL

2002-09-17 Thread Wong, Bing


H...   

My shop used it once and caused memory shortage because the external process
frequently did not terminate.  Application team removed the logic.

Bing Wong
Open Systems Database Administrator
x25721

This e-mail may contain material that is confidential. Any review, reliance
or distribution by others or forwarding without express permission is
strictly prohibited. If you are not the intended recipient, please contact
the sender and delete all copies received.



-Original Message-
Sent: Tuesday, September 17, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L


Read up in the standard PL/SQL Reference manual on external procedures.
It will explain everything very well...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 10:23 AM


 Hi Everybody,


 I want to call C Program routine from PL/SQL. What all things I need
 to do.


 Thanks
 Suman



 DISCLAIMER: Information contained and transmitted by this E-MAIL is
 proprietary to Mascot Systems Limited and is intended for use only by the
 individual or entity to which it is addressed, and may contain information
 that is privileged, confidential or exempt from disclosure under
applicable
 law. If this is a forwarded message, the content of this E-MAIL may not
have
 been sent with the authority of the Company. If you are not the intended
 recipient, an agent of the intended recipient or a person responsible for
 delivering the information to the named recipient, you are notified that
any
 use, distribution, transmission, printing, copying or dissemination of
this
 information in any way or in any manner is strictly prohibited. If you
have
 received this communication in error, please delete this mail  notify us
 immediately at [EMAIL PROTECTED] Before opening attachments,
 please scan for viruses.


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Suman S K
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: SYSDBA privilege with ORAPWD utility


Sorry for the late post.
I did some research some time ago and found that when connecting as sysdba
you are working under user SYS no matter what user you used to logon.
So, connect system as sysdba and you are sys. problem solved.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 13, 2002 10:28 AM


 Hey ,

 Im able to connect as SYSDBA from all other users (for e.g. WIP, SYSTEM)
 except SYS.  Can anyone pls advise on this.

 Thanks, Chetan

  --
  From: Yechiel Adar[SMTP:[EMAIL PROTECTED]]
  Reply To: [EMAIL PROTECTED]
  Sent: Thursday, September 12, 2002 6:53 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: SYSDBA privilege with ORAPWD utility
 
  Hello Chetan
 
  I think that you need to have administrator permission on the NT domain
to
  be able to logon as sysdba.
 
  Yechiel Adar
  Mehish
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, September 11, 2002 2:38 PM
 
 
   Hi List ,
  
   I have Oracle 8.1.5 server on Win 2K machine.
  
   When I try to connect as SYSDBA using SYS account from a remote
machine
  it
   says ORA-01017: invalid username/password; logon denied. Then I
  created
  a
   password file using ORAPWD utility and granted SYS and WIP (a newly
  created
   schema) the SYSDBA privilege. I also ensured that
  REMOTE_LOGIN_PASSWORDFILE
   is set to TRUE, but still I can not connect as SYSDBA.
  
   Following are the steps which I took.
  
   Step 1.  Created a password file as followed :
  
   D:\Oracle\Ora815\BINcd ..\dbs
   D:\Oracle\Ora815\DBSorapwd file=orapwsb815 password=oracle8i
   entries=30
  
   Step 2.  Grant SYS user the SYSDBA privilege by the following method
  
   D:\Oracle\Ora815\DBSsvrmgrl
  
   Oracle Server Manager Release 3.1.5.0.0 - Production
  
   (c) Copyright 1997, Oracle Corporation.  All Rights Reserved.
  
   Oracle8i Release 8.1.5.0.0 - Production
   With the Java option
   PL/SQL Release 8.1.5.0.0 - Production
  
   SVRMGR connect internal
   Password:
   Connected.
   SVRMGR grant SYSDBA to SYS;
   Statement processed.
  
   SVRMGR select * from v$pwfile_users ;
   USERNAME   SYSDB SYSOP
   -- - -
   INTERNAL   TRUE  TRUE
   SYSTRUE  TRUE
   2 rows selected.
  
   Pls help me if possible.
  
   Thanks in advance.
  
   Chetan
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Chindarkar,Chetan
 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 list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
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 list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Chindarkar,Chetan
   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 list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the

backup controlfile to trace

2002-09-17 Thread Ray Stell



8.1.7

For scripting purposes, what is the logic for finding the trc file from
alter database backup controlfile to trace cmd?  This seems really
stupid not being able to direct the output.
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: How to get all the SQL statements executed by a user !!!!

2002-09-17 Thread MCUK









  Hi Cary,
  
  I have hi-jacked this reply to one of our list members. May I please 
  ask of you to explain what happens next ?
  
  I understand (I think ) that you mean to capture all of some 
  ones activity during a logged in session by setting sql_trace=true, 
  but I don't know what to query or where to look to find the 
  results.
  
  Thanks in advance if you choose to reply.
  
  best regards,
  
  Ron.
  
  ---Original Message---
  
  
  From: [EMAIL PROTECTED]
  Date: Tuesday, 
  September 17, 2002 17:47:28
  To: [EMAIL PROTECTED]
  Subject: RE: How to get 
  all the SQL statements executed by a user 
  
  
  alter session set 
  sql_trace=true;
  
  Make this the 
  first statement the user executes upon login. If you dont have control 
  over the users source code, you can put the alter session command into a 
  trigger that fires when he logs in.
  
  
  Cary 
  MillsapHotsos 
  Enterprises, Ltd.http://www.hotsos.comUpcoming 
  events:- Hotsos 
  Clinic, Oct 13 San Francisco, Oct 1517 Dallas, Dec 911 
  Honolulu- 2003 Hotsos 
  Symposium on Oracle® System Performance, Feb 912 
  Dallas- Next event: Miracle Database 
  Forum, Sep 2022 Middlefart Denmark
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Reddy, 
  MadhusudanaSent: 
  Tuesday, September 17, 2002 10:53 AMTo: Multiple recipients of list 
  ORACLE-LSubject: How to 
  get all the SQL statements executed by a user 
  
  
  Hello 
  All,
  
  How to 
  get all the SQL statements executed by a user , when he logs back in 
  next time  ( I do not wanted miss even single SQL 
  statement)
  
  Can 
  somebody help me in this. 
  
  
  
  Thanks,
  
  Madhu
  
   
  
  
  
  
  
  


  
Upgrade 
Outlook® - Add COLOR 
to your 
Emails
  


  
Outlook® 
is a registered trademark of Microsoft 
  Corporation
  
  





	
	
	
	
	
	
	




 IncrediMail - Email has finally evolved - 
Click 
Here

RE: SNP uses 60% of CPU on Windows2000 - please help

2002-09-17 Thread Thomas Day



Go to your Task Manager again and pick the processes tab.  Click on 'CPU'
to sort the processes by CPU usage or 'CPU Time to get who has run up the
most CPU usage since you last booted the system.  All of your Oracle treads
run in one process, ORACLE.EXE.  The dllhost.exe should be there as a
separate process.  Though from what you show in your query I could be
wrong.



   

Inka  

Bezdziecka  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
IBezdziecka cc:   

@cupe.caSubject: RE: SNP uses 60% of CPU on 
Windows2000 - please help 
Sent by: root  

   

   

09/17/2002 

01:28 PM   

Please 

respond to 

ORACLE-L   

   

   





Thanks,
my problem is that I hardly know how to spell Windows. Performance monitor
shows Paging file usage at zero.

On Oracle side I altered system and set job_queue _process = 1.

when I run
select vb.name NOME, vp.program PROCESSNAME,
vp.spid THREADID, vs.sid SID, vs.program
from v$session vs, v$process vp, v$bgprocess vb
where vb.paddr  '00' and
vb.paddr = vp.addr and
vp.addr = vs.paddr;

I got an output:
NOME PROCESSNAMETHREADID  SID  PROGRAM
PMON ORACLE.EXE 1580 1ORACLE.EXE
DBW0 ORACLE.EXE 1404 2ORACLE.EXE
LGWR ORACLE.EXE 1584 3ORACLE.EXE
CKPT ORACLE.EXE 1588 4ORACLE.EXE
SMON ORACLE.EXE 1592 5ORACLE.EXE
RECO ORACLE.EXE 1596 6ORACLE.EXE
SNP0 ORACLE.EXE 1600 7
SNP2 ORACLE.EXE 2624 35   dllhost.exe
SNP3 ORACLE.EXE 2532 8dllhost.exe
ARC0 ORACLE.EXE 1636 11   ORACLE.EXE
SNP4 ORACLE.EXE 1784 18   dllhost.exe
SNP5 ORACLE.EXE 644  23   dllhost.exe

As far as I know, dllhost.exe is ASP execution engine. So the culprit may
be on the application side, not Oracle.

Does that make any sense?

inka



-Original Message-
Sent: Tuesday, September 17, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L



I have had times on Win NT boxes when the CPU went to 100%.  My experience
is that this happens when the OS is thrashing the swapfile (writing it into
and out of memory on a  continuous basis).   If the disk I/O is also very
high then that may be what's happening.  However, 800M free out of 2G does
not look too bad.  If you don't have the high disk I/O then the SGA is
probably not the issue.  I don't want to push you in the wrong direction
either.

HTH




Inka
Bezdziecka  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
IBezdziecka cc:
@cupe.caSubject: RE: SNP uses 60% of
CPU on Windows2000 - please help
Sent by: root


09/16/2002
03:38 PM
Please
respond to
ORACLE-L






The server has 2GB, free at the moment 800MB. Do you think that SGA size
may have something to do with it?

-Original Message-
Sent: Monday, September 16, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L



How much physical RAM do you have and how much are you using?  Check the
Task Manager on the performance tab under MEM Usage to get that figure.




Inka
Bezdziecka  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
IBezdziecka cc:
@cupe.caSubject: SNP uses 60% of CPU
on Windows2000 - please help
Sent by: root


09/16/2002
01:13 PM

Re: RMAN restore to another node

2002-09-17 Thread Ruth Gramolini


Do you have your backup restored to the box you are trying to restore from?
I
Have you build a database to hold the restored data?
If so, are all of the tablespaces and datafiles the same name on the box you
are restoring to?
We need more information to help you further.

Regards,
Ruth


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 11:18 AM


They are alluding it to a possibilty that RMAN cannot
find the backup piece and just before showing the
error it realeasing channels and that releasing
channels per se does not point to any problem.

--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Johnson - Did Oracle Support offer any theories on
 why the RMAN channels
 were being spontaneously released? Is Oracle Support
 looking into this as a
 possible bug, and you are just checking to see
 whether anyone else has
 experienced this behavior?

 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]


 -Original Message-
 From: Johnson Poovathummoottil
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 17, 2002 9:02 AM
 To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
 Cc: '[EMAIL PROTECTED]'
 Subject: RE: RMAN restore to another node


 Oracle support too pointed to that. I tested with
 allocating 3 more channnels after 'set newname'. But
 no change. They were released. and same error
 followed.

 --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
  Johnson
 From what I read of your trace file, the
 channels
  are being released,
  presumably just before you need them. Do you have
  that explicitly coded in
  your RMAN recovery script, or are they being
  released for another reason. My
  immediate response is that maybe the problem lies
 in
  why those channels are
  being released. Can you move your channel commands
  after the SET NEWNAME
  commands?
 
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
  mailto:[EMAIL PROTECTED]
 
 
  -Original Message-
  From: Johnson Poovathummoottil
  [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, September 17, 2002 9:23 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN restore to another node
 
 
  Hi all,
 
  I am stuck on this restore for two days and Oracle
  support seems to offering little help.
 
  I seem to be doing everything according to manuals
  and
  metalink notes  but am not able to do the restore.
 
  The case is I am restoring a database to another
  node.
  I have successfully restore the control file but
  when
  I tried to restore the database I get
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 1
  for every datafile.
 
  I am inserting the RMAN trace . I would appreciate
  if
  someone can lead in the right direction.
  Recovery Manager: Release 9.2.0.1.0 - Production
 
  Copyright (c) 1995, 2002, Oracle Corporation.  All
  rights reserved.
 
  ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
  System name:SunOS
  Node name:  EdwDev
  Release:5.8
  Version:Generic_108528-15
  Machine:sun4u
 
  Starting with debugging turned off
 
  connected to target database: DB01 (not mounted)
  using target database controlfile instead of
  recovery
  catalog
 
  RMAN
  executing command: SET DBID
 
  RMAN 2 3 4
  allocated channel: ci
  channel ci: sid=10 devtype=DISK
 
  Starting restore at 17-SEP-02
 
  channel ci: restoring controlfile
  channel ci: restore complete
  replicating controlfile
  input filename=/extracts1/DB01_temp/ctrl1.ctl
  output filename=/extracts1/DB01_temp/ctrl2.ctl
  output filename=/extracts1/DB01_temp/ctrl3.ctl
  Finished restore at 17-SEP-02
  released channel: ci
 
  RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14
  15
  16
  allocated channel: c1
  channel c1: sid=10 devtype=DISK
 
  allocated channel: c2
  channel c2: sid=11 devtype=DISK
 
  allocated channel: c3
  channel c3: sid=12 devtype=DISK
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  executing command: SET NEWNAME
 
  Starting restore at 17-SEP-02
 
  released channel: c1
  released channel: c2
  released channel: c3
  RMAN-00571:
 

===
  RMAN-00569: === ERROR MESSAGE STACK
  FOLLOWS ===
  RMAN-00571:
 

===
  RMAN-03002: failure of restore command at
 09/17/2002
  08:27:16
  RMAN-06026: some targets not found - aborting
  restore
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 8
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 7
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 6
  RMAN-06100: no channel to restore a backup or copy
  of
  datafile 5
  RMAN-06100: no channel to restore a backup or copy
  of

RE: backup controlfile to trace

2002-09-17 Thread Markham, Richard

Title: RE: backup controlfile to trace





a non-full proof method that I use is


T_FILE=$(ls -1rt /$ORACLE_HOME/admin/udump | tail -1)


this will assign $T_FILE to the newest file existing in UDUMP.



-Original Message-
From: Ray Stell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject: backup controlfile to trace




8.1.7


For scripting purposes, what is the logic for finding the trc file from
alter database backup controlfile to trace cmd? This seems really
stupid not being able to direct the output.
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Permanent Position Available-Oracle Clinical Systems Analyst/NJ

2002-09-17 Thread Bill Christison


Interested candidates, reply to: [EMAIL PROTECTED]
*
Position Title:
Oracle Clinical Systems Analyst/Permanent position

The Clinical Systems Analyst is responsible for a broad range of
systems-related  activities within the Clinical Research
Department.  These include, but are not limited to the
following:

Duties and Responsibilities:

·Designs, tests, and implements the clinical database and
clinical data screens
·Designs, tests, and implements standardized Clintrial meta data
objects
·Develops, tests, and documents programs to ensure the accuracy
and consistency of data
·Creates analysis databases using SAS and documents according to
SOPs
·Validates system upgrades
·Programs statistical tables and listings using SAS or other
software tools

Education and Experience:

·BS in Computer Science or related disciplines.  MS is a plus.
·At least 3 years experience in the clinical data management
environement
·Demonstrated working knowledge of PL/SQL and SAS
·Experience with relational databases, especially ORACLE
·Technical documentation experience and exposure to validation
processes and procedures
·Flexible and proactive approach to work.  Able to work both
independently and and collaboratively in a team environment
·Good interpersonal and communication skills.

Location/Salary:

Central New Jersey/$70K-$75K




=
Bill Christison
Knowlton Group, LLC
845-258-5129
www.knowltongroup.com

__
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Christison
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: backup controlfile to trace

2002-09-17 Thread Kevin Lange


The way we do it is not 100% but it seems close enough.  We run the backup
command and then do a descending order listing by date from the trace
directory.   The first file is the one containing the trace.

If anyone has a beter idea, I am all ears.

Kevin

-Original Message-
Sent: Tuesday, September 17, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L



8.1.7

For scripting purposes, what is the logic for finding the trc file from
alter database backup controlfile to trace cmd?  This seems really
stupid not being able to direct the output.
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: 9ir2 install on linux(removal)

2002-09-17 Thread Joe Testa


beats me but its one of those things that happens during the first time 
you run root.sh.

joe


Peter Barnett wrote:

Did it, it worked.  Now, why the heck do they put it
in /etc?


--- JOE TESTA [EMAIL PROTECTED] wrote:

try removing the /etc/oraInst.loc and the
oraInventory file(the location of it is in the .loc
file).

Joe



=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Replication script