ORA-28575: RPC connection with external procedure cannot opened
Hi DBAs, Here is my situation, I'm running Oracle8174 on Solaris. We are using an external procedure called in my pl/sql. I'll give you my example: I will use the Oracle example DEBUG_EXTPROC I'm on the Unix server and I connect with SQLPLUS, without the listener SQL connect c$mdlimol2 Enter password: Connected. SQL execute debug_extproc.startup_extproc_agent; PL/SQL procedure successfully completed. SQL Everything goes fine But when I connect with the listener SQL connect [EMAIL PROTECTED] Enter password: Connected. SQL execute debug_extproc.startup_extproc_agent; ERROR at line 1: ORA-28575: unable to open RPC connection to external procedure agent ... So the problem could be the listener ... But if a try TNSPING extproc_connection_data, I got OK Here is the copy of my listener file SID_LIST_EXTPROCLISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /disk1/app/oracle/product/8.1.7) (PROGRAM = /disk1/app/oracle/product/8.1.7/bin/extproc) ) ) EXTPROCLISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) ) ) And tnsnames EXTPROC_CONNECTION_DATA.CAMRD.ASTRAZENECA.NET= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) (SRVR = DEDICATED) ) ) I'm not using MTS Thank you for you help Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Background parameter adjustment
Hi DBAs, 2-3 days ago, I decided to play with dynamic modification of SGA parameters on Oracle9.2 I reduced my Shared_pool_size and since then my CKPT background process is taking 50% of my CPUs. In my Statspack report, I see a big wait event called Background parameter adjustment Did that happen to you? Thank you Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Export bigger then 2G with Oracle7.3.4
Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Export bigger then 2G with Oracle7.3.4
The migration to an Oracle8i database is not possible, b'cause, the package using the database only support Oracle7. I will have problem if they decide to reuse this product. The coldbackup is the less demanding solution. Thanks -Original Message- Sent: January 9, 2004 9:39 AM To: Multiple recipients of list ORACLE-L You could migrate the database to 8i, or you could use sql to split the table into 2GB and do the export in pieces, or you could just shut the database down and do a cold backup of the database, retaining any media you need to reinstall Oracle 7. Make sure if you are in archivelog mode that you backup all logfiles. Allan -Original Message- [EMAIL PROTECTED] Sent: Friday, January 09, 2004 7:59 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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). application/ms-tnef
RE: Export bigger then 2G with Oracle7.3.4
Mark, Jolane It's on WindowsNT, but I will install client7 on a Unix machine and I will use the pipe. Thank you Luc -Original Message- Sent: January 9, 2004 10:01 AM To: Multiple recipients of list ORACLE-L You don't mention OS, but if it's a flavor of unix, you could probably do: mknod my_pipe p exp file=my_pipe all other export options split -b 2047m my_pipe exp.dmp This will generate multiple files, 2.047 MB per file. They will be named exp.dmpaa, exp.dmpab, exp.dmpac, etc,etc. To import, you'd simply do: cat exp.dmp?? my_pipe imp file=my_pipe all other import options Hope that helps, -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 8:59 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Because of some requirements from one of our vendor, we still have a database running Oracle7.3.4 on WindowsNT and since this package is no longer used, so we want to export the content of this database. The database is around 60G, one table is 55G. So a simple export on release 7 will crash when I will get 2G of dump file. The export utility for release 7 doesn't allow us to create multiple files, but the export utility for release 8 does. I know that they recommend to always use the lower version of export, but is there a way to use export 8i and create multiple files on a Oracle7.3.4 database? If not, what can I do? Thanks Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Bobak, Mark 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). application/ms-tnef
Move datafiles, but can't delete them
Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Move datafiles, but can't delete them
Tom, I didn't know that I absolutely have to bounce the database. Tx Luc -Original Message- Sent: November 25, 2003 8:36 AM To: '[EMAIL PROTECTED]' Cc: Demanche, Luc Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- 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: Move datafiles, but can't delete them
Bruce, Thank you, the problem is not when I dropped the tablespace but want I moved datafiles. I will bounce the database. Luc -Original Message- [mailto:[EMAIL PROTECTED] Sent: November 25, 2003 5:02 PM To: Multiple recipients of list ORACLE-L When dropping a tablespace, we've had better success deleting the files by the delete command from CMD rather than using Windows Explorer. Also, found that you need to wait a period of time before you can delete the file - eg try again in 30 secs 5 mins time. This is mentioned in a forum at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=279331.996. From the note below, you should exit your tool (eg SQLPLus) and then wait a bit. Also see note 222033.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=222033.1 which says: fact: Oracle Server - Enterprise Edition 8.1.5 fact: MS Windows NT symptom: Unable to delete datafile from OS after drop tablespace symptom: Cannot delete %s: There has been a sharing violation symptom: Error deleting OS file cause: Bug:480928 OPEN HANDLE TO OFFLINE DATAFILES Fixed in ver. 8.1.6 and higher. fix: After issuing a DROP TABLESPACE command the corresponding datafile is still locked on OS level and not possible to remove. Workaround: Disconnect from the session and exit the tool (Server Manager or SQL*Plus) you were running the DROP TABLESPACE command from. Then wait for some time (minutes) , and the datafile will be released by the OS and possible to delete. To find out who has files open, you can use process explorer from www.sysinternals.com or tlist from the resource kit. HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed. -Original Message- Sent: Wednesday, 26 November 2003 1:49 AM To: Multiple recipients of list ORACLE-L In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows. No, I'm not talking about Oracle. NetBackup for instance, on windows it is often impossible to read the logfiles for a backup in progress. If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. Jared On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote: Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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). application/ms-tnef
RE: Oracle and Firewall
Hi Seema, Take a look on this document #131524.1 on Metalink. You will have to add an entry in the registry to force the connection to only use the port 1521 USE_SHARED_SOCKET=TRUE Luc -Original Message- Sent: November 21, 2003 11:21 AM To: Multiple recipients of list ORACLE-L Hi, We are using Oracle817 on Windows with netscreen firewall.I have been noticing after some times applications start connecting form 1521 to 1034 and so.IS this normal ?I want port 1521 Only in use. How to fix this problem? thx -Seema _ Gift-shop online from the comfort of home at MSN Shopping! No crowds, free parking. http://shopping.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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). application/ms-tnef
Performance problem with Shareplex and Oracle
Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 00 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Performance problem with Shareplex and Oracle
Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting for Shareplex, we have server's resources available (CPU is 50% idle). How can we speed up Shareplex? Luc -Original Message- Sent: October 23, 2003 12:56 PM To: Multiple recipients of list ORACLE-L How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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). application/ms-tnef
RE: Performance problem with Shareplex and Oracle
Dan, The process taking 50% is an Oracle process and it is connected on Shareplex Oracle user. I have two different error messages: 1- System call error: sp_cop(dsm) Temporary error (h_errno = 2) gethostbyname (can't add entry for ora4) I got this error every 10 minutes, but I didn't find something about this error. 2- Operation on 'table_name' is took longer then expected. Make sure the proper index si being used If I check my Explain Plan, the Explain Plan says that he taking the proper index. How can he tell me that it took longer that expected? It's true that on some replicated tables, I have lot of indexs. But my v$session_event should not tell me the waits on indexs (db file scattered read)? Luc -Original Message- Sent: October 23, 2003 1:16 PM To: Demanche, Luc Luc, Which process is taking 50% of the CPU? Do you see any messages from SharePlex? Are there indexes on the target tables or maybe a few that may be slowing down replication (you'll see a message in the event_log on any table that posting is taking longer than expected). Has SharePlex been running for a while and this has just started happening? Just some things to start looking at. Dan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 8:29 AM Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 00 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- 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: Performance problem with Shareplex and Oracle
I probably found my problem. My replicated tables have a lot of indexs. I removed all of them, and step by step I will add indexs who will help my replication. Tx Luc -Original Message- Sent: October 23, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Since the results of triggers firing in the source will appear in the log files, then in general you do not want the same triggers firing in the target. Similarly since data integrity is usually enforced in the source db you can typically disable it in the target. I suppose something on this order could be the problem. Allan -Original Message- Sent: Thursday, October 23, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Now we don't use Shareplex, but I do know of others who do this is not the first time I hear of performance problems, but I may be able to shed some light on the problem. Since Shareplex reads the redo logs, if one statement on the source database affects more than one row (lets say 10 for arguments sake), then shareplex turns it into 10 distinct statements for the replicated database. Now imagine that your statement affected one row in one table, but due to triggers and constraints affected 1000's of other rown in other tables. DAMN, that could make for a REAL mess on the target system. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Shareplex is fast here. We replicate a 6 CPU db to a 4 CPU machine without excessive loads or problems. We run an average of 29 messages with about 1 GB in the queues. Our data is 0 minutes old. Outside of contacting Quest support I'm sure of how much help I can be. When I have seen SP claim as much CPU as you have stated, I have had to do a shutdown, which kills sp_cop and start it again. This has fixed the high cpu consumption. SP for us is usually around 18% of a single CPU. We are processing about 240MB per day of redo. Sorry not to be of more help. Allan -Original Message- [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting for Shareplex, we have server's resources available (CPU is 50% idle). How can we speed up Shareplex? Luc -Original Message- Sent: October 23, 2003 12:56 PM To: Multiple recipients of list ORACLE-L How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ This email
RAC vs Fail Safe
Title: Message Hi gurus, I'm in a process of evaluating a high availability strategy. What the difference between RAC and Fail Safe ? Luc
ORA-03237 with LOB and locally managed tablespace
Hi gurus, Could you explain that. Working with tablespace in locally managed, with uniform extends size, we want to create LOB but we must have the uniform extend size 3 times the db_block_size, right? Otherwise we got ORA-03237. With dictionnary managed tablespace we don't have this problem. Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Intermedia tag problem
Hi Gurus, We are working with Intermedia Text 8.1.6. We created a intermedia index on a search field. We also created 2 sections in this field. Table name : S01 Filed name : S01_search Sections name : SY,MAN Here is an example of data in this field: SYCyane/SYMANPhibro Energy */MAN This example works fine. But we have a problem when there is a character in the data. Intermedia thinks it's a new tag and tries to find a section but it cannot. Exemple: SYCyane 10 /SYMANPhibro Energy */MAN Question : 1- Should we do something with the in our data ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche 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: Intermedia tag problem
Thank you Peter and Jan. Luc --- Hitchman, Peter [EMAIL PROTECTED] wrote: Hi, You will have to change your input data and replace the with lt;. This is one of the standard 5 XML entity references. Really you need to make sure that you have no double quotes, single quotes, less than , greater than or ampersands in your data and if you do replace then with the appropriate entity reference: - amp; - quot; ' - apos; - lt; - gt; Regards Pete -Original Message- Sent: 28 March 2003 14:34 To: Multiple recipients of list ORACLE-L Hi Gurus, We are working with Intermedia Text 8.1.6. We created a intermedia index on a search field. We also created 2 sections in this field. Table name : S01 Filed name : S01_search Sections name : SY,MAN Here is an example of data in this field: SYCyane/SYMANPhibro Energy */MAN This example works fine. But we have a problem when there is a character in the data. Intermedia thinks it's a new tag and tries to find a section but it cannot. Exemple: SYCyane 10 /SYMANPhibro Energy */MAN Question : 1- Should we do something with the in our data ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche 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). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter 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). = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche 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: newbie sqlplus ?
Les, Check your PATH. Issue echo $PATH and your should have $ORACLE_HOME/bin Otherwise you should enter the full path. Luc --- Les Ayudo [EMAIL PROTECTED] wrote: I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued the command sqlplus and I rec'd a command not found error. Is there something I forgt to do before the install? Let me kow if u need more info. THanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo 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). = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche 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).
SqlServer - Oracle transfer issues
Hi gurus, I need to transfer a few tables from SqlServer to Oracle. I've installed Heteroegous Service between the SqlServer and our Oracle database according to the Metalink doc no : 109730.1 I began the transfer between those two databases with this kind of statement : create table TableA as select * from TableA@hsodbc; But now I have a problem with the tables on the SqlServer side that contain columns of the Text datatype. Oracle wants to handle it as a LONG datatype. I received this kind of errors : ORA-00997 : illegal use of LONG database What should I do ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche 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: cursor and no data found
Philippe, Youcould use PL/SQL exceptions. Example : for c in c1 loop begin select a into v1 from table1 where a 1 and b 2 and ... exception when no_data_found then null; end; end loop; Luc "NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>wrote: Hi List ! how can I can make a "continue" statement in my loop when a request return no data e.g : cursor c1 is . for c in c1 loop select a into v1 from table1 where a 1 and b 2 and ... /* if my "select into" return no data ? how can I tell him to goes on into the loop ? */ end loop TIA Philippe Luc Demanche[EMAIL PROTECTED]Do You Yahoo!? Yahoo! Autos - Get free new car price quotes
Restore on another machine with RMAN
Hi gurus, I'm in process of testing our backup strategies. We are using RMAN, but for our prod database we aren't using the recovery catalog. Our backup's files are on disk, so I transfered them on another machine. I recovered the controlfile, I mounted the database, but when RMAN tried to restore it looks for the original location where RMAN created the backup. How can indicate the new location of the backup's files ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche 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).
Restore with RMAN
Hi gurus, I'm in a process of testing our backup and recovery strategies. Question: For a restore of a noarchivelog database : Is't possible to restore other backups than the last one? What's happen if the last one is not good? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche 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).
RE: Restore with RMAN
I solved it, I used set until time, I thought we could use set until time only with database in archived log mode... Sorry. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Luc - I wondered about this issue, but since it wasn't going to be on the OCP BR exam, it obviously wasn't worth knowing (just a little dark OCP humor). My initial guess would be either: 1) RMAN would just know to go to the earlier backup if the first failed (I doubt that). 2) Manually go into the RMAN catalog and delete the reference to the bad backup so RMAN no longer knows it exists. I also believe there may be an RMAN command to accomplish this. 3) Hope someone else on this list knows the answer. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Hi gurus, I'm in a process of testing our backup and recovery strategies. Question: For a restore of a noarchivelog database : Is't possible to restore other backups than the last one? What's happen if the last one is not good? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche 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: DENNIS WILLIAMS 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). = Luc Demanche [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche 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).
PL/SQL return a ref cursor to Java client
Hi gurus, Oracle 816, java application. I had a discussion with my co-workers on where all the SQL statements should reside. In client code (java) or in stored procs called by the java client? It's an internet application, so basically they're only a 'select' statements. Some of us prefer to keep all the SQL statements in stored procs, but with this solution comes some technical issues. For Example : Returning resultsets from pl/sql stored procs to the java client. We have to create a pl/sql package, that returns a ref cursor, handles it as a object in java, etc ... it's more complicated than coding an SQL statement directly in the java client. Do you guys have a solution that may be less complicated for this example? If we are going to keep all the SQL statement in stored procs called by the java client, will we have others surprises? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche 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).