Re: RE: CASE under Oracle8i
Hi I was not knowin about CASE functionality so was just trying curiously following thing. Results are also below. SQL select case when mgr is null then ename end from emp; CASEWHENMG -- KING CASEWHENMG -- 14 rows selected. This gives me all 14 rows. Can I get outout as just 'KING' here using CASE? Also what are the other usage of CASE functionality? NG -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg 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: Windows NT and Virtual Memory
Title: RE: Windows NT and Virtual Memory Rajesh, I had the same problem when we migrated to Oracle817. The solution was to setup MTS. Our server runs about 450 sessions/connections at a time now, no problems. I have the server set up to mts_servers = 15 and an initial dispatchers = 10. This has been working fine for our system for approx 1yr now. Hope this helps Rgds Denham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 5:59 PM To: Multiple recipients of list ORACLE-L Subject: Windows NT and Virtual Memory Operating System: Windows NT 4.0 with SP 6a Oracle Version : 8.1.7 We recently migrated an Oracle database from one Windoze NT box to another. The NT administrators claim that the NT boxes are indentical in all respects, except that the old one had Service Pack 4. We have recreated the database on the new box with exactly indentical initialization paremeters, file sizes, extent sizes, et all. The database gleefully accepts all connections upto about 220 users (V$license, v$session). When the 221st user tries to logon, the TNS-12500: Unable to start a dedicated server process is thrown. After all the troubleshooting (Connect timeouts, Disable otracing, tracing client), we discovered that as soon as the Virtual memory comes approaches 1.7Gb, this problem starts happening. I read articles on Metalink which suggested that this is a limitation with Windows NT, and suggests some recommendation to delay this problem. So, we recommended the same to business. But now they wish to know why these errors never occured in the old NT server. And to further worsen matters, the old server has been cleaned up. So, I have no way of going back and Checking. Has anyone else on this list encountered the same problem? Possible workarounds, if any? Thanks Raj I was an Atheist, until I started working with NT. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
Data transfer between 2 databases
Hi, I have an Oracle Database on Intranet network that is used for internal program ( insert, update etc.). The other database will be at the Internet provider and our cgi will run on it. Because the users on the Internet should see the actual data and the users can make some inserts in the database - I need to transfer records in both way, from one database to the other and inverse. What makes my problem even worse - only the Internet provider's Oracle has fix IP address, the other that is on the internal network doesn' t. Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
undocumented initSID.ora parameter
What is the undocumented (unsupported) parameter which allows/forces Oracle to ignore the state of the redo logfiles open up anyways? TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: could not open the forms/reports on the web
Ravi, I've never encountered the problem you have, so I can't help you directly. However, have you checked the following : - Are the Webserver setting for FORMS60JAVA, DEV60CGI, DEV60HTML, DEV60TEMP and JInitiator filled in correctly ? - You haven't mentioned your browser version, but is JInitiator installed correctly on your local workstation ? - What's the URL you're using ? (perhaps post it to the list) ? Greetings, Frank Ravi R [EMAIL PROTECTED]@fatcity.com on 24-03-2002 20:38:18 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Hi all I could not open the forms/reports on the web. When I try to run on the web, it asks me to 'open from current location/save to the disk'. Again when I select ''open from current location' it is not opening. Any suggestion is appreciable. I am using Form6i/Report6i against oracle 817 database and web 2.2 Installed in the order oradb817,forms6i/rep6i,web 2.2 on Win2000 prof. Thanks Ravi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravi R 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 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: Oracle Monitoring !!!!!
Check out: http://www.geocities.com/tbcox23/dba_checklist15.doc HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Madhusudana Sent: 22 March 2002 20:59 To: Multiple recipients of list ORACLE-L Hello All, I am planning to have a checklist , which can have a list of things which I have to monitor on a schedule base. And I also wanted to prepare scripts which will look into database and mail me at least once in a day. So that I am going to have what's happening in the database. Its one kind of proactive monitoring . Anybody is having a check list like this , if so pl mail me . any suggestions are appreciated. Thanks in advance, Madhu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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: Mark Leith 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).
error testing jdbc connectin
Hi all I hope you can help me out with this. I am running JdbcCheckup connection that comes as part of jdbc samples on oracle 9.0.1 I am running win2k and I get the following error.Unfortunately I dont have access to metalink. Can anyone help me out . Oracle 9i is the downloadable one on technet. The program connects fine but as soon as it does the select it gives this error Exception in thread main java.sql.SQLException: ORA-00600: internal error code , arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav a:1681) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1870) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java: 538) at JdbcCheckup.main(JdbcCheckup.java:55) Regards Tich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ticha Murehwa 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).
Create info about table definition
Hallo, is there any way to create a table of the definition of table( list of field names and their datatypes, indexes etc) Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 - procedur
Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want the following to be logged in a status table. Procedure names Start_time of procedure End_time_of procedure Error_code(if anything goes wrong) Error_message Please give me example onhow to write the code and also tell me how to pick out the procedure_name, start_time of_procedure, end_time_ptocedure, error_code, error_message. Thanks in advance. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Create info about table definition
To start with, you could look at DBA_TAB_COLUMNS: select table_name, column_name, data_type from dba_tab_columns where owner = 'SCHEMA_OWNER'; or select table_name, column_name, data_type from dba_tab_columns where table_name = 'TABLE_NAME'; Create your table: CREATE TABLE TAB_COLUMNS ( TABLE_NAME VARCHAR2(30) NOT NULL , COLUMN_NAME VARCHAR2(30) NOT NULL , DATA_TYPE VARCHAR2(106) ); and simply: insert into TAB_COLUMNS (select table_name, column_name, data_type from dba_tab_columns where table_name = 'TABLE_NAME'); What do you actually want to do this for? SHAMELESS PLUG If this is to document, I have a far easier way of documenting the DDL, and dependencies for tables/objects within a schema, and yes it is with a tool, but it's a free tool, so I don't feel too shameful about plugging it! ;) Check out: http://www.cool-tools.co.uk/Products/dbatool.html Take an export with rows=n of your schema, feed it in to the tool, and generate yourself a nice set of html files that will show you the structure of the tables/objects, and all dependencies on that object. All you have to do then is load the html files to an intranet or something.. This also has an added benefit in that the whole process (apart from the actual export) is totally unobtrusive to the database. /SHAMELESS PLUG ;) HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- [EMAIL PROTECTED] Sent: 25 March 2002 10:53 To: Multiple recipients of list ORACLE-L Hallo, is there any way to create a table of the definition of table( list of field names and their datatypes, indexes etc) Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Mark Leith 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: Create info about table definition
Hello Roland All the info is in the DB, all_tab_col, all_indexes etc. Why do you need your own table instead of getting it direct from the views? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Mon, March 25, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Subject: Create info about table definition Hallo, is there any way to create a table of the definition of table( list of field names and their datatypes, indexes etc) Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: RE: CASE under Oracle8i
The case works on each record in the set. you have to use where to limit the set. select case when mgr is null then ename end from scott.emp where mgr is NULL Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Nandu Garg [SMTP:[EMAIL PROTECTED]] Sent: Mon, March 25, 2002 10:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: CASE under Oracle8i Hi I was not knowin about CASE functionality so was just trying curiously following thing. Results are also below. SQL select case when mgr is null then ename end from emp; CASEWHENMG -- KING CASEWHENMG -- 14 rows selected. This gives me all 14 rows. Can I get outout as just 'KING' here using CASE? Also what are the other usage of CASE functionality? NG -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Data transfer between 2 databases
I think that this situation called for master to master replication. In this situation updates to each DB are forward to the second DB. What connection do you have between the two computers? In our installation there is NO connection between internet and intranet. The dynamic TCP/IP address can be resolved using DNS and working with the computer NAME instead of TCP/IP address. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Csillag Zsolt [SMTP:[EMAIL PROTECTED]] Sent: Mon, March 25, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Subject: Data transfer between 2 databases Hi, I have an Oracle Database on Intranet network that is used for internal program ( insert, update etc.). The other database will be at the Internet provider and our cgi will run on it. Because the users on the Internet should see the actual data and the users can make some inserts in the database - I need to transfer records in both way, from one database to the other and inverse. What makes my problem even worse - only the Internet provider's Oracle has fix IP address, the other that is on the internal network doesn' t. Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: PL/SQL - procedur
Look at Exception in PL/SQL and how to use it. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/11_elems.htm#8355 And don't use 'date' type of variable to store start time and end time of your procedures. JP On Mon 25. March 2002 12:23, you wrote: Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want the following to be logged in a status table. Procedure names Start_time of procedure End_time_of procedure Error_code(if anything goes wrong) Error_message Please give me example onhow to write the code and also tell me how to pick out the procedure_name, start_time of_procedure, end_time_ptocedure, error_code, error_message. Thanks in advance. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: CPU usage for each oracle instance
Thanks Catherine,It might do the trick.I will create a script and give it a try. Thanks again. -Original Message- Sent: Saturday, March 23, 2002 3:48 AM To: Multiple recipients of list ORACLE-L Hi Anne, Maybe you can try /usr/ucb/ps -aux in Unix to find the CPU usage of the instance processes. For example : Thu Mar 21 15:45:00 SGT 2002 USER PID %CPU %MEM SZ RSS TT SSTART TIME COMMAND orahrms 7312 6.4 10.0421864406560 ?S 14:29:34 3:47 oracleTEST (LOCAL= Hope it helps. Regds, New Bee -Original Message- From: Anne Yu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 12:49 AM To: Multiple recipients of list ORACLE-L Subject:CPU usage for each oracle instance Hey list, In the system accounting report, I can get the total CPU usage for ORACLE. However, I have 7 instances on this box. How can I get the total CPU usage for each Oracle instance?Any ideas? Million thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu 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: CHAN Chor Ling Catherine (CSC) 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: Anne Yu 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: undocumented initSID.ora parameter
_ALLOW_RESETLOGS_CORRUPTION = TRUE use them as a last resort and only when you understand all the risks. Joan Charlie Mengler wrote: What is the undocumented (unsupported) parameter which allows/forces Oracle to ignore the state of the redo logfiles open up anyways? TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: Joan Hsieh 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: PL/SQL - procedur
Jan, Could you explain why you say not to use the DATE datatype? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 25, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Look at Exception in PL/SQL and how to use it. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/ a77069/11_elems.htm#8355 And don't use 'date' type of variable to store start time and end time of your procedures. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Create info about table definition
USER_TABLES USER_TAB_COLUMNS USER_INDEXES USER_IND_COLUMNS should get you started hth connor --- [EMAIL PROTECTED] wrote: Hallo, is there any way to create a table of the definition of table( list of field names and their datatypes, indexes etc) Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Deadlock issues in 8.1.7.2
CM, We are using ORACLE 8.1.7.3 on HP-UX 11.0 for a fairly large warehouse project ( 150 Gigs growing at the rate of 15 Gigs a month) and with all the bells and whistles like STAR_TRANSFORMATION and partitioning turned on. Apart from some memory leak issue we are not facing any major problems. HTH Cheers, RS --- [EMAIL PROTECTED] wrote: Is anyone having deadlocking issues with the 8.1.7.2 release of Oracle? If you are, how serious are these errors? What are the consequences of the deadlock error messages.How long does it actually take to clean up the deadlocks? Does one of the transactions roll back? Does it then reissue later? I've opened a TAR but support seems unable to answer these questions to my satisfaction and I can't find this particular problem documented on Metalink. Maybe I'm not searching on the right thing. The error number seems to have very little information associated with it. We are doing some advance testing of an upgrade from 8.0.4 to 8.1.7.2 of a data warehouse. We are using partitioning, the STAR_TRANSFORMATION set to true, otherwise, a fairly typical database. We are using version 2.6 of Sun Solaris, EMC disk, and Veritas volume manager. During testing of two data load scripts, we get recurring deadlock errors on the 8.1.7.2 test database. We can reproduce these errors every time we run these scripts togethe In our current 8.0.4 database, we run the two scripts together and it is not an option to run them sequentially, instead of concurrently, since we don't have a long enough window to run them concurrently. Thanks in advance for any help. Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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: I've got that sinking feeling...
M with out some insignificant info like version of oracle and platform all I can do is take a wild guess :) Check out the bug 1788876 on metalink which seems to be occuring in MTS env. If you don't have access to metalink email me off list and I will forward the doc to you. Cheers, RS --- Seefelt, Beth [EMAIL PROTECTED] wrote: Does anyone know what this error means ? No traces, nothing in the alert log. SP2-0642: SQL*Plus internal error state 2133, context 0:0:0 Unsafe to proceed TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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).
Stand-by (Oracle9i Data Guard) vs. Replication
Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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).
Function to round to the nearest 15
I'm trying to convert a minutes field to hours and fractional hours. I need the fractional hours portion rounded to the nearest quarter hour... any SQL (no PLSQL) suggestions would be helpful. 1=.25 48=.75 90=1.5 95=1.5 98=1.75 application/ms-tnef
At the 4000 limit for LOBs in SQL
Anyone seen behaviour like this before ?
rem
rem simple table
rem
SQL create table blah (i number, x clob);
Table created.
rem
rem Add a row that I construct (i=1), and then
rem insert a row from an existing table (which
rem also contains a clob)
rem
SQL declare
2r varchar2(32000) := rpad('*',2,'*');
3 begin
4insert into blah values (1,r);
5insert into blah select 2,email
6 from email_content where id = 418830;
7commit;
8 end;
9 /
PL/SQL procedure successfully completed.
rem
rem So lengthwise the two lobs are similar
rem
SQL select i, dbms_lob.getlength(x) from blah;
I DBMS_LOB.GETLENGTH(X)
-- -
1 2
2 19743
rem
rem And the first lob looks fine...
rem
SQL select dbms_lob.substr(x,3999,1)
2 from blah where i = 1;
DBMS_LOB.SUBSTR(X,3999,1)
---
***
***
...
rem
rem Whereas the second lob does not!
rem
SQL
SQL select dbms_lob.substr(x,3999,1)
2 from blah where i = 2;
select dbms_lob.substr(x,3999,1)
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character
string buffer too small
ORA-06512: at line 1
Ideas anyone ?
Cheers
Connor
=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
Some days you're the pigeon, some days you're the statue
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
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: undocumented initSID.ora parameter
Charlie , You like playing with fire don't you..;) Well.. IMHO I wouldn't do this unless this is a test DB. Having said that, this might be the info you are looking for... _allow_resetlogs_corruption allow resetlogs even if it will cause corruption Cheers, RS --- Charlie Mengler [EMAIL PROTECTED] wrote: What is the undocumented (unsupported) parameter which allows/forces Oracle to ignore the state of the redo logfiles open up anyways? TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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).
Difference - SCN
Hi Gurus, What's the difference between System Commit Number, and System Change Number? I know they are not the same. I am looking to read more about them and how they are incremented viz. Commits, updates to rows, checkpoints, et all.. Any Good books, sites And not Oracle Docs please... Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Remote DB Installation
Wouldn't a non-interactive install work much faster? No X traffic, although it may take a few tries to get the script right. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, March 22, 2002 10:28 PM To: Multiple recipients of list ORACLE-L First let me say, It *CAN* be done. Given the right set of circumstances. You will need: 1. Some way of displaying X-Windows 2. A telnet or ssh session into the box. In all likelyhood, there will be a firewall involved somewhere, so some form of TCP/IP tunnel (VPN) would probably be required. While you can run X over a wide-area network, it can be rather slow and painful. (And I'm betting the ping-times between the US and Central America probably aren't all that great). So, I'd strongly recommend that you use either VNC (freely available from ATT Labs) or PC/Anywhere to control a PC with X-Windows software (Exceed/Reflection) on it. (VNC and/or PC/Anywyere will make the slow line speed much more bearable). Oh, and obviously, you'll need the proverbial well-trained monkey to load the CD into the drive for you... KENNETH JANUSZ wrote: I have a possible opportunity to install an Oracle DB (8i or 9i) for a company located in Central America. I am located in the Minneapolis / St. Paul, MN area. What tools would I need to install this remotely from MN? The server would probably be Sun or HP unix. Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: I've got that sinking feeling...
From Metalink: symptom: SP2-0642: SQL*Plus internal error state 2133, context 0:0:0 cause: bug:1746523 which is a duplicate of bug:1358043 this is caused by the SQL statement contained in the redo having trailing NULL columns. These trailing NULL columns are not stored in the redo record. fix: Upgrade to Oracle 9.0.1 or apply the 8.1.7.2 patchset. Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: Seefelt, Beth [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 7:38 PM To: Multiple recipients of list ORACLE-L Subject: I've got that sinking feeling... Does anyone know what this error means ? No traces, nothing in the alert log. SP2-0642: SQL*Plus internal error state 2133, context 0:0:0 Unsafe to proceed TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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 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: Function to round to the nearest 15
floor(x/60) gives the hours mod(x,60) gives the minutes floor(mins/15) gives a number between 0 and 3 etc hth connor --- Thompson, Todd [EMAIL PROTECTED] wrote: I'm trying to convert a minutes field to hours and fractional hours. I need the fractional hours portion rounded to the nearest quarter hour... any SQL (no PLSQL) suggestions would be helpful. 1=.25 48=.75 90=1.5 95=1.5 98=1.75 ATTACHMENT part 2 application/ms-tnef = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: RE: PL/SQL - procedur
Could you explain why you say not to use the DATE datatype? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Because of the 1s precision limit. The obvious workaround is to have PL/SQL procedures which always take more than say 10mn to run. Stephane Faroult Oriole Corporation Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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).
FYI
Just want to pass this on in case you haven't read about this yet. http://www.theregister.co.uk/content/53/24559.html Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard 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).
6i webforms
At times response times via webforms is NOTICABLY slow. However thick client access into the DB does not reflect any appreciable slowdown. Therefore I don't think the slow response is directly due to the database. How can I better identify exactly where the delay is being introduced between the thin clent to the DB and back again? Please note that this delay is intermittent. For much of the time the response time via webforms is perfectly OK. TIA HAND! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lead, follow, or at least have the courtesy to get out of my way! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: Stand-by (Oracle9i Data Guard) vs. Replication
What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Automatic shutdown on NT does a shutdown abort
That is the way stopping the Oracle service on NT works. A 'STOP NET Oracle_Service_Name' is like issuing a 'SHUTDOWN ABORT' from svrmgrl. I do a 'SHUTDOWN IMMEDIATE' in svrmgrl but this has a tendancy to hang the backup job. It's a vicious cycle. Dave -Original Message- Sent: Monday, March 25, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Environment: Oracle 8.1.7 NT 4.0 sp 6 Registry parameters: ORA_sid_SHUTDOWN = TRUE ORA_sid_SHUTDOWN_TYPE=i ORA_sid_SHUTDOWN_TIMEOUT=30 When I stop the OracleServicesid, the database appears to do a shutdown abort. No entries are made in the alert log to indicate that a clean shutdown occurred. When I restart the service, the alert log contains messages like Beginning crash recovery of 1 threads. Any ideas what I have missed? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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: Farnsworth, Dave 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: PL/SQL - procedur
Because it stores only seconds and if your procedure's runtime is short ( 1 sec) you will get the same numbers. Other problem is: if you call same procedure in LOOP, you will get 1 - 2 - 5 ... 15 ... 500 records with same value in start and end time column. And (I think so) there's no way how to get the order of inserting of these records. JP On Mon 25. March 2002 16:03, you wrote: Jan, Could you explain why you say not to use the DATE datatype? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 25, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Look at Exception in PL/SQL and how to use it. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817 / a77069/11_elems.htm#8355 And don't use 'date' type of variable to store start time and end time of your procedures. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
Well, up until about a couple of years ago, that was very true from what I experienced... Now, perhaps it takes a bit more work, but there seems to be enough demand around for the time being. Perhaps number 10 should be rather: 10. If you need a change of location, you can get one easier than with other jobs. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
Besides is was supposed to be FUNNY! RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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).
Function With Variable inpit
Hi List,
Need your help, I am not a PL/SQL person.
I want to write a function which the number of input parameter is
diffrent(some sort of array), is anybody have any idea about this sort of
FUNCTIONS, here is the example:
TABLEA( usera varchar2(11),Weight number(3)) this table has 100 users and
some of them may be with weight=null so any time I send the name of user or
users to the function I want to get the weight for each user(s) and if the
users weight is nul return ZERO for that user,
Function rUSERSX('a','b','c') return 50,10,0 even if user C has null value
in TABLEA the number of input for this function can be diffrent any time
called.
Thanks allot for your help.
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
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: Automatic shutdown on NT does a shutdown abort
Yeah, it just follows the old Windoze paradigm of crash and hope to rebuild when I come back up. Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Subject: RE: Automatic shutdown on NT does a shutdown abort That is the way stopping the Oracle service on NT works. A 'STOP NET Oracle_Service_Name' is like issuing a 'SHUTDOWN ABORT' from svrmgrl. I do a 'SHUTDOWN IMMEDIATE' in svrmgrl but this has a tendancy to hang the backup job. It's a vicious cycle. Dave -Original Message- Sent: Monday, March 25, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Environment: Oracle 8.1.7 NT 4.0 sp 6 Registry parameters: ORA_sid_SHUTDOWN = TRUE ORA_sid_SHUTDOWN_TYPE=i ORA_sid_SHUTDOWN_TIMEOUT=30 When I stop the OracleServicesid, the database appears to do a shutdown abort. No entries are made in the alert log to indicate that a clean shutdown occurred. When I restart the service, the alert log contains messages like Beginning crash recovery of 1 threads. Any ideas what I have missed? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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: Farnsworth, Dave 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 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
Probably to have no job. But as DBA ... ??? :-) JP On Mon 25. March 2002 18:03, you wrote: 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: At the 4000 limit for LOBs in SQL
Version ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 25 March 2002 16:50 |Anyone seen behaviour like this before ? | |rem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
My last profession was health physics which is a branch of nuclear physics. Where I could locate to was very limited when compared to the locations I can go to being a DBA. Dave -Original Message- Sent: Monday, March 25, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Well, up until about a couple of years ago, that was very true from what I experienced... Now, perhaps it takes a bit more work, but there seems to be enough demand around for the time being. Perhaps number 10 should be rather: 10. If you need a change of location, you can get one easier than with other jobs. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Farnsworth, Dave 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
If you need a change of location, you can get one easier... OK, now I understand what you meant. I can testify to the relocation potential because I recently escaped the Silicon Valley rat race to come up here to God's country. Nevertheless, I still fantasize about rendering remote DBA support via a laptop with multi-band satellite connectivity from a log cabin while snowed in at 10,000 feet. (Or while lounging in a hammock on some Carribean Ilse.) While I support servers 1000's of miles away, employers like to see you and hear you tapping on the keyboard. Working and living ANYWHERE is not so much a technical problem as it is an organizational, human relations challenge. Sigh... Steve Orr Still in Bozeman, MONTANA!!! -Original Message- Sent: Monday, March 25, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Well, up until about a couple of years ago, that was very true from what I experienced... Now, perhaps it takes a bit more work, but there seems to be enough demand around for the time being. Perhaps number 10 should be rather: 10. If you need a change of location, you can get one easier than with other jobs. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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).
How to test BCV and backups
Hello, we are implementing EMC Time Finder with our Sun boxes. Now I wonder how I can test backup and recovery scenarios with BCV. Do you have any ideas or good documents concerning that. Thank you in advance, Sepi _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seppo Kaasalainen 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).
Sun Cluster v3.0
Hello all, could some of you point or copy me a document how to setup Oracle for fail over (on E10K) with Sun Cluster v3.0. I've heard it is slightly different than previous release. Thank you in advance, Sepi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seppo Kaasalainen 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
Ok... so I never made it to Australia Geeez... Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Probably to have no job. But as DBA ... ??? :-) JP On Mon 25. March 2002 18:03, you wrote: 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Freeman, Robert 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
Where were you an HP at Dave ? -Original Message- Sent: Monday, March 25, 2002 11:34 AM To: Multiple recipients of list ORACLE-L My last profession was health physics which is a branch of nuclear physics. Where I could locate to was very limited when compared to the locations I can go to being a DBA. Dave -Original Message- Sent: Monday, March 25, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Well, up until about a couple of years ago, that was very true from what I experienced... Now, perhaps it takes a bit more work, but there seems to be enough demand around for the time being. Perhaps number 10 should be rather: 10. If you need a change of location, you can get one easier than with other jobs. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Farnsworth, Dave 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: Kevin Lange 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: Stand-by (Oracle9i Data Guard) vs. Replication
Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Freeman, Robert 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:RE: RE: Production Oracle DBA Needed in Rochester, Minnes
1) My wife mows the lawn since I've a habit of running over flowers. 2) Do that every 3000 miles on both of our cars, along with rotate the tires, change the spark plugs as needed, replace fault mufflers, etc... Namely the general purpose home mechanic. 3) Every spring fall I move furniture like clock work. 4) Had 3 kids, all currently grown, wife sent me to see the doctor after the third. 5) I pay for my truck, she pays for her car. That's the way she wants it. 6) Forbidden in our house, restaurant food has too much fat!! 7) Yeah, like where? 8) HMM, Maybe. At least it pays the bills. 9) Yeah, yeah, I save their butt and get mine kicked in the morning. Some fun! 10) Well, true in my case. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 8:23 AM Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Friday, March 22, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hey, don't give Lisa bad vibes! My wife I raised three of the little curtail climbers. Get to marry one off this June. But really kids are great, especially the second time around when their NOT yours. :-) Dick Goulet AKA: Grandpa Reply Separator Author: John Kanagaraj [EMAIL PROTECTED] Date: 3/22/2002 1:05 PM Slightly OT, but here's to a virtual baby shower and all good wishes to you Lisa. (PS: Entirely agree with Ron, you ain't seen grey hairs yet!) John Kanagaraj -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 12:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Production Oracle DBA Needed in Rochester, Minnesota Lisa, You THINK you have a few grey hairs now... wait a few years after the Baby Oven finishes the glorious gift for you. Parental revenge..I hope your kids grow up to be just like you... ROR mª¿ªm -- 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 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: Freeman, Robert 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RMAN restores
Oracle 8.1.7.0.0 on Solaris 2.8 with NetBackup 3.4 We are trying to use the same RMAN scripts that worked for us in 8.0.5 and 8.1.6. We can do full - incrememtal 0 - backup and restore. We can also do an incremental 1 backup, but when we try to do the restore, it does not restore the archive logs. The lists does show the correct archive logs, so I'm reasonabley certain that the logs are getting backed up, but they do NOT restore. I am working with Oracle on this, but because it is just testing at this point, WWW is not in any hurry to get back to me. Does any one have any scripts they use for 8.1.7 that work for them? I'd like to do a comparison and see if there is something we are missing. TIA Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: [RE: Stand-by (Oracle9i Data Guard) vs. Replication]
One way to recover Standby machine is to share a drive from the remote machine, and copy (ftp) the log files to the shared drive every time a new log file was created. Yigal Freeman, Robert [EMAIL PROTECTED] wrote: Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Freeman, Robert 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: Yigal Ran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
Re:How to test BCV and backups
Sepi, You'll need an additional server, and the EMC manuals, to mount the BCV's onto. After that it's just a matter of having the Oracle software in place bingo you can test to your hearts content or else use it as a reporting DB. BTW, don't forget to pay the Oracle piper for the second server. Dick Goulet Reply Separator Author: Seppo Kaasalainen [EMAIL PROTECTED] Date: 3/25/2002 9:39 AM Hello, we are implementing EMC Time Finder with our Sun boxes. Now I wonder how I can test backup and recovery scenarios with BCV. Do you have any ideas or good documents concerning that. Thank you in advance, Sepi _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seppo Kaasalainen 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 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: [RE: Stand-by (Oracle9i Data Guard) vs. Replication]
One way to recover Standby machine is to share a drive from the remote machine, and copy (ftp) the log files to the shared drive every time a new log file was created. Yigal Freeman, Robert [EMAIL PROTECTED] wrote: Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Freeman, Robert 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: Yigal Ran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
RE: RE: Production Oracle DBA Needed in Rochester, Minnesota
Hines VA Medical Center, Chicago Martinez VA Medical Center, Martinez, CA Ohio Dept of Health, Radiological Section, Columbus University of Iowa, Iowa City University of Wisconsin, Madison I think I got all of them. Then I went back to school for computers. and never looked back. Dave -Original Message- Sent: Monday, March 25, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Where were you an HP at Dave ? -Original Message- Sent: Monday, March 25, 2002 11:34 AM To: Multiple recipients of list ORACLE-L My last profession was health physics which is a branch of nuclear physics. Where I could locate to was very limited when compared to the locations I can go to being a DBA. Dave -Original Message- Sent: Monday, March 25, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Well, up until about a couple of years ago, that was very true from what I experienced... Now, perhaps it takes a bit more work, but there seems to be enough demand around for the time being. Perhaps number 10 should be rather: 10. If you need a change of location, you can get one easier than with other jobs. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Farnsworth, Dave 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: Kevin Lange 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: Farnsworth, Dave 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).
Access for Oracle Book
Would anyone like to recommend a book for learning Access for someone coming from an Oracle background? I have limited knowledge of Access but am looking for a good book to learn more -- and no, I am not replacing Oracle, just supplementing it. I thought I had seen something about this in the FAQs but cannot seem to find it. TIA, Wayne [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: McGill, Wayne L 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:Function With Variable inpit
Hamid,
You've got me lost in more ways than one. I assume from your post that you
have a table with a client's name weight therein and what you want is two
functions, one of which will always return a number for the person's weight.
The second one I haven't the foggiest clue what your asking for.
Are the assumptions correct?
Dick Goulet
Reply Separator
Author: Hamid Alavi [EMAIL PROTECTED]
Date: 3/25/2002 9:18 AM
Hi List,
Need your help, I am not a PL/SQL person.
I want to write a function which the number of input parameter is
diffrent(some sort of array), is anybody have any idea about this sort of
FUNCTIONS, here is the example:
TABLEA( usera varchar2(11),Weight number(3)) this table has 100 users and
some of them may be with weight=null so any time I send the name of user or
users to the function I want to get the weight for each user(s) and if the
users weight is nul return ZERO for that user,
Function rUSERSX('a','b','c') return 50,10,0 even if user C has null value
in TABLEA the number of input for this function can be diffrent any time
called.
Thanks allot for your help.
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
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 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: How to test BCV and backups
Maybe this is a stupid question but doesn't EMC have doc's on that? Also, I ass|u|me you have a recover plan. Shouldn't that be your testing plan? Brian P. MacLean Oracle DBA, OCP8i Seppo Kaasalainen To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] skaasal@hotma cc: il.com Subject: How to test BCV and backups Sent by: [EMAIL PROTECTED] om 03/25/02 10:39 AM Please respond to ORACLE-L Hello, we are implementing EMC Time Finder with our Sun boxes. Now I wonder how I can test backup and recovery scenarios with BCV. Do you have any ideas or good documents concerning that. Thank you in advance, Sepi _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seppo Kaasalainen 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 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: Stand-by (Oracle9i Data Guard) vs. Replication
Sorry for interrupting... but our SLAs (requirements docs) do not have such loose language... Things like 'ASAP' and 'as little latency as possible' must be specified in absolute numbers (minutes, hours, days etc.) If it is not spelled out, it's a wide open game of mud slinging ;) - Kirti -Original Message- Sent: Monday, March 25, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Function With Variable input
Hmmm
create or replace function myfunc (in_userlist in varchar2)
return varchar2 is
-- in_userlist is a comma delimited list of user numbers
szRtnVar varchar2(1000) := null;
--
szSqlText varchar2(1000) := null;
vRefCur REF CURSOR;
begin
szSqltext := 'select nvl(weight, 0) from tablea where usera in (' ||
in_userlist || ')';
open vRefCur for szSqltext;
loop
fetch vRefCur into szTmp;
exit when vRefCur%notfound;
szRtnVar := szRtnVar || ',' || to_char(szTmp);
end loop;
if vRefCur%isopen then
close vRefCur;
end if;
return (ltrim(szRtnVar,','));
end myfunc;
/
or if you have 8i, 9i then try this ...
create or replace function myfunc (in_userlist in varchar2)
return varchar2 is
-- in_userlist is a comma delimited list of user numbers
szRtnVar varchar2(1000) := null;
--
itTmpTab dbms_utility.uncl_array; -- table type definition for
varchar2
szSqlText varchar2(1000) := null;
vRefCur REF_CURSOR;
nRows number := 0; -- holds number of rows
begin
szSqltext := 'select to_char(nvl(weight, 0)) from tablea where usera in ('
|| in_userlist || ')';
execute immediate szSqlText BULK COLLECT into itTmpTab;
dbms_utility.table_to_comma(itTmpTab, nRows, szRtnVar);
return (szRtnVar);
end myfunc;
/
Of course check for syntaxes etc. Both these examples assume that the in
parameter is of type a,b,c,d etc.
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!
*2
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: RMAN restores
Terry,
When you say that Rman does not restore the archive log files, what exactly
are you expecting?
Maybe Rman does not need to restore any archive logs, depending on what
point-in-time you are restoring to. It could just restore the db files, and
use the current redo logs to catch them up?
Below is a point-in-time restore script that I have used - the syntax has
not changed much since 816.
run {
allocate channel t1 type 'SBT_TAPE' parms 'BLKSIZE=2097152';
set until time to_date('2001-06-22:13:25:00','-mm-dd:hh24:mi:ss');
restore (database);
recover database;
release channel t1;
sql 'alter database open resetlogs';
}
reset database;
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, March 25, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.7.0.0 on Solaris 2.8 with NetBackup 3.4
We are trying to use the same RMAN scripts that worked for us in 8.0.5 and
8.1.6. We can do full - incrememtal 0 - backup and restore. We can also do
an incremental 1 backup, but when we try to do the restore, it does not
restore the archive logs. The lists does show the correct archive logs, so
I'm reasonabley certain that the logs are getting backed up, but they do NOT
restore. I am working with Oracle on this, but because it is just testing
at this point, WWW is not in any hurry to get back to me.
Does any one have any scripts they use for 8.1.7 that work for them? I'd
like to do a comparison and see if there is something we are missing.
TIA
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
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: Mercadante, Thomas F
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).
8.1.7.3.1. patch for NT
FYI, I noticed that two fies are in the patch, but not mentioned in readme.txt: Oranls8.dll Oranls8.sym We are now getting bizarre errors on our 8.1.7.3.1. database: For one Web appication: Ora-02088 distributed option cannot be found For another: Ora-01003 no statement parsed I opened a support call. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: RMAN restores
Here are the errors I am seeing.
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 27
scn 34
923
This lists all the logs EXCEPT the most recent. No logs are found in the
archive log directory and the database does not recover thru RMAN. I can
not recover the database manually, because the archive logs can not be
found. (The backup script removes the archive logs after they have been
(hopefully) backed up.
-Original Message-
Sent: Monday, March 25, 2002 12:36 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Terry,
When you say that Rman does not restore the archive log files, what exactly
are you expecting?
Maybe Rman does not need to restore any archive logs, depending on what
point-in-time you are restoring to. It could just restore the db files, and
use the current redo logs to catch them up?
Below is a point-in-time restore script that I have used - the syntax has
not changed much since 816.
run {
allocate channel t1 type 'SBT_TAPE' parms 'BLKSIZE=2097152';
set until time to_date('2001-06-22:13:25:00','-mm-dd:hh24:mi:ss');
restore (database);
recover database;
release channel t1;
sql 'alter database open resetlogs';
}
reset database;
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, March 25, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.7.0.0 on Solaris 2.8 with NetBackup 3.4
We are trying to use the same RMAN scripts that worked for us in 8.0.5 and
8.1.6. We can do full - incrememtal 0 - backup and restore. We can also do
an incremental 1 backup, but when we try to do the restore, it does not
restore the archive logs. The lists does show the correct archive logs, so
I'm reasonabley certain that the logs are getting backed up, but they do NOT
restore. I am working with Oracle on this, but because it is just testing
at this point, WWW is not in any hurry to get back to me.
Does any one have any scripts they use for 8.1.7 that work for them? I'd
like to do a comparison and see if there is something we are missing.
TIA
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
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: Ball, Terry
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: CASE under Oracle8i
I think the case expression is supported in PL/SQL in 9i. prior to 9i, the pl/sql and sqlplus engine are separated. CASE just supported in sqlplus engine not in pl/sql engine. Joan CHAN Chor Ling Catherine (CSC) wrote: Hi Jonathan, I am using Oracle8i Enterprise Edition Release 8.1.6.1.0 SQL SET SERVEROUTPUT ON SQL EDIT Wrote file afiedt.buf 1 DECLARE 2 dual_message VARCHAR2(20); 3 BEGIN 4 SELECT CASE 5 WHEN DUMMY='X' THEN 'Dual is OK' 6 ELSE 'Dual is messed up' 7 END INTO dual_message 8 FROM DUAL; 9 DBMS_OUTPUT.PUT_LINE(dual_message); 10* END; SQL / SELECT CASE * ERROR at line 4: ORA-06550: line 4, column 11: PLS-00103: Encountered the symbol CASE when expecting one of the following: ( * - + all mod null an identifier a double-quoted delimited-identifier a bind variable table avg count current distinct max min prior sql stddev sum unique variance execute the forall time timestamp interval date a string literal with character set specification a number a single-quoted SQL string Hope it helps. Regds, Catherine -Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject:CASE under Oracle8i If you run Oracle8i, and could conveniently test a couple of statements for me, I'd appreciate it. First, I believe the following should work under Oracle8i: SELECT CASE WHEN DUMMY='X' THEN 'Dual is OK' ELSE 'Dual is messed up' END FROM DUAL; I'm less certain about the following, which I vagualy recall hearing might not work under Oracle8i, but which does work under Oracle9i: DECLARE dual_message VARCHAR2(20); BEGIN SELECT CASE WHEN DUMMY='X' THEN 'Dual is OK' ELSE 'Dual is messed up' END INTO dual_message FROM DUAL; DBMS_OUTPUT.PUT_LINE(dual_message); END; Be sure to SET SERVEROUTPUT ON before executing the above. Otherwise you won't see the results. The point of all this is that I seem to recall hearing that, while SQL in 8i supported the CASE statement, that SQL within PL/SQL did not. I'm trying to verify the truth or falsity if that statement. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: CHAN Chor Ling Catherine (CSC) 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: Joan Hsieh 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
RE: Stand-by (Oracle9i Data Guard) vs. Replication
(from the mouth of a replication non-quru) I think you answered your own question. If no network and they want to be up, then synchronous replication is not an option. You're only option is asynchronous replication. One answer that I'm sure EMC would luv to sell you is networked raw disks in conjunction with Oracle Parallel Server (OPS/RAC). If cost is not a problem, then EMC has the solution. It's not their company slogan/mission statement, but it should be. In this scenario you may lose a node but you can trade the problems of asynchronous replication conflict detection and resolution (and maintaining multiple databases), for the OPS locks and false ping problems. If given a choice, I'd take the OPS problems. Brian P. MacLean Oracle DBA, OCP8i Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Stand-by (Oracle9i Data Guard) vs. Replication Sent by: [EMAIL PROTECTED] om 03/25/02 10:48 AM Please respond to ORACLE-L Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Access for Oracle Book
Access 97 Developer's Handbook by Litwin, Getz, and Gilbert. They also make an Access 2000 and 2002 book. Be careful as there is a Microsoft book by the same title and it's, well, written by Microsoft. 'enuf said. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: McGill Wayne China Lake CA Would anyone like to recommend a book for learning Access for someone coming from an Oracle background? I have limited knowledge of Access but am looking for a good book to learn more -- and no, I am not replacing Oracle, just supplementing it. I thought I had seen something about this in the FAQs but cannot seem to find it. TIA, Wayne [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI 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).
How much memory is consumed by cache tables?
How much memory is consumed by cache tables? For example, if you have a small amount of data in a lookup table that's locally managed with 128K uniform extents, does it consume 128K of memory even if the data is only in one 8k DB block? (If that's the case then it would be better to assign it to a keep buffer pool.) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: 8.1.7.3.1. patch for NT
Where did you get the patch from. I had a TAR inquireing about 8.1.7.3.2 for NT and as an aside the analyst mentioned that 3.1 was available but had been pulled with no new release date Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 [EMAIL PROTECTED] 3/25/02 1:45:52 PM FYI,I noticed that two fies are in the patch, but not mentioned in readme.txt:Oranls8.dllOranls8.symWe are now getting bizarre errors on our 8.1.7.3.1. database:For one Web appication:Ora-02088 distributed option cannot be foundFor another:Ora-01003 no statement parsedI opened a support call.Regards,Patrice BoivinSystems Analyst (Oracle Certified DBA)Systems Admin Operations | Admin. et Exploit. des systèmesTechnology Services | Services technologiquesInformatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPOE-Mail: [EMAIL PROTECTED]--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Boivin, Patrice J INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re:RE: Stand-by (Oracle9i Data Guard) vs. Replication
Robert, Given what you've said it would appear that your only choice is going to be symetric/advanced replication, multi-master. The conflict resolution rules may be a bear to set up with 5 sites though. Using a standby db would not be very effective since data updates are dependent on the archive log switch points and that does not address the different sites if your reason for failure is a network related one. Snapshots won't work either since they are read only. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 9:48 AM Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy AwardsR http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Freeman, Robert 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
RE: [RE: Stand-by (Oracle9i Data Guard) vs. Replication]
Unfortunately, there are synchronization issues with the use of the stand-by since one requirement is that EACH of the 4 sites must be able to run autonomously... in other words, if I take all 4 sites out of stand-by mode, they make changes at all 4 sites and then we have to resynch (after the network is back for example) how the heck do I do that. I thought about using separate schemas for local data, and transportable tablespaces, but there is some data that is shared by the entire network, and that is a problem. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 1:05 PM To: Multiple recipients of list ORACLE-L One way to recover Standby machine is to share a drive from the remote machine, and copy (ftp) the log files to the shared drive every time a new log file was created. Yigal Freeman, Robert [EMAIL PROTECTED] wrote: Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: At the 4000 limit for LOBs in SQL
It didn't reproduce on 9.0.1.2.
But then it was a simple test with just a couple
of rows in the email table.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 25 March 2002 16:50
|Anyone seen behaviour like this before ?
|
|rem
|rem simple table
|rem
|SQL create table blah (i number, x clob);
|
|Table created.
|
|rem
|rem Add a row that I construct (i=1), and then
|rem insert a row from an existing table (which
|rem also contains a clob)
|rem
|SQL declare
| 2r varchar2(32000) := rpad('*',2,'*');
| 3 begin
| 4insert into blah values (1,r);
| 5insert into blah select 2,email
| 6 from email_content where id = 418830;
| 7commit;
| 8 end;
| 9 /
|
|PL/SQL procedure successfully completed.
|
|rem
|rem So lengthwise the two lobs are similar
|rem
|SQL select i, dbms_lob.getlength(x) from blah;
|
| I DBMS_LOB.GETLENGTH(X)
|-- -
| 1 2
| 2 19743
|
|rem
|rem And the first lob looks fine...
|rem
|SQL select dbms_lob.substr(x,3999,1)
| 2 from blah where i = 1;
|
|DBMS_LOB.SUBSTR(X,3999,1)
|-
--
|*
**
|*
**
|...
|
|rem
|rem Whereas the second lob does not!
|rem
|SQL
|SQL select dbms_lob.substr(x,3999,1)
| 2 from blah where i = 2;
|select dbms_lob.substr(x,3999,1)
| *
|ERROR at line 1:
|ORA-06502: PL/SQL: numeric or value error: character
|string buffer too small
|ORA-06512: at line 1
|
|Ideas anyone ?
|
|Cheers
|Connor
|
|=
|Connor McDonald
|http://www.oracledba.co.uk (mirrored at
|http://www.oradba.freeserve.co.uk)
|
|Some days you're the pigeon, some days you're the statue
|
|__
|Do You Yahoo!?
|Everything you'll ever need on one web page
|from News and Sport to Email and Music Charts
|http://uk.my.yahoo.com
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: =?iso-8859-1?q?Connor=20McDonald?=
| 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: Jonathan Lewis
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: RE: Production Oracle DBA Needed in Rochester, Minnesota
Nevertheless, I still fantasize about rendering remote DBA support via a laptop with multi-band satellite connectivity from a log cabin while snowed in at 10,000 feet. (Or while lounging in a hammock on some Carribean Ilse.) Oh *drooling* if only. Although, while I lived in Seattle, I did do some work (like documentation) and ride the Bremerton Ferry from time to time on my laptop...almost as good. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:44 PM To: Multiple recipients of list ORACLE-L If you need a change of location, you can get one easier... OK, now I understand what you meant. I can testify to the relocation potential because I recently escaped the Silicon Valley rat race to come up here to God's country. Nevertheless, I still fantasize about rendering remote DBA support via a laptop with multi-band satellite connectivity from a log cabin while snowed in at 10,000 feet. (Or while lounging in a hammock on some Carribean Ilse.) While I support servers 1000's of miles away, employers like to see you and hear you tapping on the keyboard. Working and living ANYWHERE is not so much a technical problem as it is an organizational, human relations challenge. Sigh... Steve Orr Still in Bozeman, MONTANA!!! -Original Message- Sent: Monday, March 25, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Well, up until about a couple of years ago, that was very true from what I experienced... Now, perhaps it takes a bit more work, but there seems to be enough demand around for the time being. Perhaps number 10 should be rather: 10. If you need a change of location, you can get one easier than with other jobs. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Freeman, Robert 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: Stand-by (Oracle9i Data Guard) vs. Replication
Yea yea yea well we don't have quite that level of definition at this point, and I have yet to see absolute numbers come my way. Isn't my project, in fact this is an outside vendor and I'm coming in on the tail end of the projects design phase and being asked, do you agree with this design and I'm saying, now's a fine time to ask. I've asked for additional facts and figures, but pointing my little digits sometimes only get's them bitten off by the big machine that is. The requirements as defined thus far to me are: 1. No more than 5 minutes outage. 2. No data loss 3. each site has to be able to act autonomously. three different kinds of data 1. Network wide data (used by all sites) - critical, no data loss 2. Regional data (specific to a region, not used by other sites) - critical, no data loss 3. Easily recoverable non-critical data. Data loss is tolerable. That being said, they want to replicate between the four sites, and they want to use replication conflict resolution rules to deal with outages and resync of the databases. They claim it will work great, I'm thinking, yea right sounds like a bear to manage. I'd much rather do 9i data guard just off the hip, but as you point out, I do not have lots of info as yet, so we shall see what comes down the pike. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 1:23 PM To: Multiple recipients of list ORACLE-L Sorry for interrupting... but our SLAs (requirements docs) do not have such loose language... Things like 'ASAP' and 'as little latency as possible' must be specified in absolute numbers (minutes, hours, days etc.) If it is not spelled out, it's a wide open game of mud slinging ;) - Kirti -Original Message- Sent: Monday, March 25, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
SQL Navigator Java
Hello, List: Does any one know how to see Java (Class) source file (original Java code) from SQL Navigator 4? I did a user level export from the server (with valid Java source/classes) and then imported to my local machine. But after this, the local Java Classes are invalid and can't recompile/rebuild from SQL Navigator. Any idea? Thanks Steven __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Joshua 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: RE: Stand-by (Oracle9i Data Guard) vs. Replication
Thanks for your thoughts Dick! Actually, look into Data Guard in 9i and you will find that you are no longer constrained by archive log switches!! I'm really concerned with the conflict resolution issues with MM Replication. I've done something like this once before, with only 2 sites, but it's been so long that it's a hazy distant memory. As I recall, the conflict resolution was a bear. They are intending on doing the resolution based on a date column and just saying that the latest date winds... they have a method of keeping the date/time on the servers in sync as long as the network is up, but my concern is what happens when it goes down and that date/time sync no longer is working or what happens when the system goes down and they also replace the hardware and the date/time is not sync'd for several days until the network is back. But... then I ask myself how often that will happen too... ;-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 2:37 PM To: Freeman, Robert ; Multiple recipients of list ORACLE-L Robert, Given what you've said it would appear that your only choice is going to be symetric/advanced replication, multi-master. The conflict resolution rules may be a bear to set up with 5 sites though. Using a standby db would not be very effective since data updates are dependent on the archive log switch points and that does not address the different sites if your reason for failure is a network related one. Snapshots won't work either since they are read only. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 9:48 AM Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Yahoo! Movies - coverage of
RE: How to test BCV and backups
Title: RE: How to test BCV and backups Are you going to use RMAN or only OS utilities? Tony Aponte -Original Message- From: Seppo Kaasalainen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Subject: How to test BCV and backups Hello, we are implementing EMC Time Finder with our Sun boxes. Now I wonder how I can test backup and recovery scenarios with BCV. Do you have any ideas or good documents concerning that. Thank you in advance, Sepi _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seppo Kaasalainen 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: Stand-by (Oracle9i Data Guard) vs. Replication
RF, Looks like you are looking for something like quest software's shareplex. A cool tool, although, on the expensive side. It has the ability to replicate with least intrusion and perf impact. ( Or thats what they say...:) ) And noI am not working for quest software...! Cheers, RS --- Freeman, Robert [EMAIL PROTECTED] wrote: Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Freeman, Robert 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: Automatic shutdown on NT does a shutdown abort
Peter, 30 seconds seems a little short for shutting down the database. I allow 10 minutes for mine. In addition, the follow registry key needs to be modified to allow the 10 minute timeout. There's an Oracle note on this in MetaLink somewhere. Jared Registry Key: HKLM\SYSTEM\CurrentControlSet\Control WaitToKillServiceTimeout = value in milliseconds To avoid killing the service before the database is shutdown, this value needs to be equal to ORACLE_SID_SHUTDOWN_TIMEOUT * 1000. e.g. for an ORACLE_SID_SHUTDOWN_TIMEOUT value of 600, this would be set to 60. Schauss, Peter [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/25/02 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Automatic shutdown on NT does a shutdown abort Environment: Oracle 8.1.7 NT 4.0 sp 6 Registry parameters: ORA_sid_SHUTDOWN = TRUE ORA_sid_SHUTDOWN_TYPE=i ORA_sid_SHUTDOWN_TIMEOUT=30 When I stop the OracleServicesid, the database appears to do a shutdown abort. No entries are made in the alert log to indicate that a clean shutdown occurred. When I restart the service, the alert log contains messages like Beginning crash recovery of 1 threads. Any ideas what I have missed? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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 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:RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication
Robert, Either way, I do believe that you can't have a standby database in both managed recovery and read only access at the same time which could be your biggest problem. The application would have to understand that under normal circumstances it's getting data from database 'X' and during failures from database 'Y'. This kind of thing gets messy as well. Therefore your best bet is for local objects that are replicated from elsewhere since all sites can update all data your rather stuck. And as far as the network going down, yours in a similar comment that our network specialist made some 2 years ago, until a back hoe operator ripped out about 1/4 mile of fiber near our building. Took the local yokels 4 days to get it repaired. So don't say 'never' as it definitely can come back to bite you. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 2:52 PM Thanks for your thoughts Dick! Actually, look into Data Guard in 9i and you will find that you are no longer constrained by archive log switches!! I'm really concerned with the conflict resolution issues with MM Replication. I've done something like this once before, with only 2 sites, but it's been so long that it's a hazy distant memory. As I recall, the conflict resolution was a bear. They are intending on doing the resolution based on a date column and just saying that the latest date winds... they have a method of keeping the date/time on the servers in sync as long as the network is up, but my concern is what happens when it goes down and that date/time sync no longer is working or what happens when the system goes down and they also replace the hardware and the date/time is not sync'd for several days until the network is back. But... then I ask myself how often that will happen too... ;-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 2:37 PM To: Freeman, Robert ; Multiple recipients of list ORACLE-L Robert, Given what you've said it would appear that your only choice is going to be symetric/advanced replication, multi-master. The conflict resolution rules may be a bear to set up with 5 sites though. Using a standby db would not be very effective since data updates are dependent on the archive log switch points and that does not address the different sites if your reason for failure is a network related one. Snapshots won't work either since they are read only. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 9:48 AM Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman
RE: RE: Production Oracle DBA Needed in Rochester, Minnesota
This is probably the most accurate list of reasons for being a DBA that I have seen. Some amendments: 1. So I don't have to mow my own lawn. Mine has been taken over by moss, so their isn't much point in mowing it. This is the rainy Pacific Northwest ya know. 2. So I don't have to change my own oil. Depends on which car. I trust very few people with *my* car. I let someone else change the oil in the mini van. Being a DBA allows me to drive a car that I cannot trust anyone else with. :) Add'l 11. So I can have a couple hundred square feet for computers and books. 12. Satisfy my need to have intimate knowledge of technical subjects. I think this makes me a geek, but I don't care. Jared, getting somewhat off topic. :) Freeman, Robert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/25/02 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: Production Oracle DBA Needed in Rochester, Minnesota Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Friday, March 22, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hey, don't give Lisa bad vibes! My wife I raised three of the little curtail climbers. Get to marry one off this June. But really kids are great, especially the second time around when their NOT yours. :-) Dick Goulet AKA: Grandpa Reply Separator Author: John Kanagaraj [EMAIL PROTECTED] Date: 3/22/2002 1:05 PM Slightly OT, but here's to a virtual baby shower and all good wishes to you Lisa. (PS: Entirely agree with Ron, you ain't seen grey hairs yet!) John Kanagaraj -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 12:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Production Oracle DBA Needed in Rochester, Minnesota Lisa, You THINK you have a few grey hairs now... wait a few years after the Baby Oven finishes the glorious gift for you. Parental revenge..I hope your kids grow up to be just like you... ROR mª¿ªm -- 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 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: Freeman, Robert 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
RE: Automatic shutdown on NT does a shutdown abort
Dave, net stop oracle_service_name will shutdown the database properly if you set it up right. There are notes on MetaLink about this. Jared PS. Is Ashley Furniture affiliated with Life Style Furnishings in NC? Please reply off list if so. Thanks. Farnsworth, Dave [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/25/02 09:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Automatic shutdown on NT does a shutdown abort That is the way stopping the Oracle service on NT works. A 'STOP NET Oracle_Service_Name' is like issuing a 'SHUTDOWN ABORT' from svrmgrl. I do a 'SHUTDOWN IMMEDIATE' in svrmgrl but this has a tendancy to hang the backup job. It's a vicious cycle. Dave -Original Message- Sent: Monday, March 25, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Environment: Oracle 8.1.7 NT 4.0 sp 6 Registry parameters: ORA_sid_SHUTDOWN = TRUE ORA_sid_SHUTDOWN_TYPE=i ORA_sid_SHUTDOWN_TIMEOUT=30 When I stop the OracleServicesid, the database appears to do a shutdown abort. No entries are made in the alert log to indicate that a clean shutdown occurred. When I restart the service, the alert log contains messages like Beginning crash recovery of 1 threads. Any ideas what I have missed? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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: Farnsworth, Dave 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 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
Yeah, does anybody know what happened to the new Internet concept of location doesn't matter? I thought by now I could be sitting at home taking DBA assignments all over the country, if not over the world? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 25, 2002 11:44 AM To: Multiple recipients of list ORACLE-L If you need a change of location, you can get one easier... OK, now I understand what you meant. I can testify to the relocation potential because I recently escaped the Silicon Valley rat race to come up here to God's country. Nevertheless, I still fantasize about rendering remote DBA support via a laptop with multi-band satellite connectivity from a log cabin while snowed in at 10,000 feet. (Or while lounging in a hammock on some Carribean Ilse.) While I support servers 1000's of miles away, employers like to see you and hear you tapping on the keyboard. Working and living ANYWHERE is not so much a technical problem as it is an organizational, human relations challenge. Sigh... Steve Orr Still in Bozeman, MONTANA!!! -Original Message- Sent: Monday, March 25, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Well, up until about a couple of years ago, that was very true from what I experienced... Now, perhaps it takes a bit more work, but there seems to be enough demand around for the time being. Perhaps number 10 should be rather: 10. If you need a change of location, you can get one easier than with other jobs. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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).
Re: OS variables read into PL/SQL
Have PL/SQL call Java call /usr/bin/env and parse the results. See - http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840241 and http://asktom.oracle.com/pls/ask/f?p=4950:8:627705::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1514388734200,%7Bjava%7D%20and%20%7Bcommand%7D and http://asktom.oracle.com/pls/ask/f?p=4950:8:627705::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:3069633370832,%7Bjava%7D%20and%20%7Bcommand%7D Brian P. MacLean Oracle DBA, OCP8i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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:RE: Stand-by (Oracle9i Data Guard) vs. Replication
Robert, I think it is possible to use RAC where the corporate data is located on a SAN accessible to all and each region has their own storage that they have RAC'd with the rest of the organization. If one region dies each region continues to function. If the corporate office dies each region continues to function. It sounds complicated and requires fast inter-connectivity between each region and the SAN. Sound reasonable? ROR mª¿ªm [EMAIL PROTECTED] 03/25/02 02:38PM Robert, Given what you've said it would appear that your only choice is going to be symetric/advanced replication, multi-master. The conflict resolution rules may be a bear to set up with 5 sites though. Using a standby db would not be very effective since data updates are dependent on the archive log switch points and that does not address the different sites if your reason for failure is a network related one. Snapshots won't work either since they are read only. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 9:48 AM Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Automatic shutdown on NT does a shutdown abort
Found the links for setting up Oracle to autostart/shutdown on NT. Jared http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=136214.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=82122.996 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=70988.996 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/25/02 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Automatic shutdown on NT does a shutdown abort Peter, 30 seconds seems a little short for shutting down the database. I allow 10 minutes for mine. In addition, the follow registry key needs to be modified to allow the 10 minute timeout. There's an Oracle note on this in MetaLink somewhere. Jared Registry Key: HKLM\SYSTEM\CurrentControlSet\Control WaitToKillServiceTimeout = value in milliseconds To avoid killing the service before the database is shutdown, this value needs to be equal to ORACLE_SID_SHUTDOWN_TIMEOUT * 1000. e.g. for an ORACLE_SID_SHUTDOWN_TIMEOUT value of 600, this would be set to 60. Schauss, Peter [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/25/02 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Automatic shutdown on NT does a shutdown abort Environment: Oracle 8.1.7 NT 4.0 sp 6 Registry parameters: ORA_sid_SHUTDOWN = TRUE ORA_sid_SHUTDOWN_TYPE=i ORA_sid_SHUTDOWN_TIMEOUT=30 When I stop the OracleServicesid, the database appears to do a shutdown abort. No entries are made in the alert log to indicate that a clean shutdown occurred. When I restart the service, the alert log contains messages like Beginning crash recovery of 1 threads. Any ideas what I have missed? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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 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 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).
Fwd:Oracle Technology Symposium Coming Soon!
YO, Anyone on the list attending this one?? Dick Goulet Forward Header_ Author: Oracle Technology Symposium [EMAIL PROTECTED] Date: 3/20/2002 9:23 AM RICHARD, Join us for our premier event in the Northeast! The Oracle Technology Symposium (Oratechs) will take place on May 2-3 at the Stamford Marriott Hotel in Stamford, Connecticut. Choose from over 30+ technical presentations on topics such as 9iAS Portal and Web Toolkit, 9iAS Business Intelligence, 9iAS Developer and JDeveloper, 9iMigration/New Features, Database and Web Security, Database Administration, Tools/Languages (including Third-Party), Project Design/Methodology/Mgmt. and Implementation Experiences. Also, take some time to visit with vendors exhibiting their latest products and services and network with other Oracle professionals in a comfortable, affordable setting. Check out the presentation abstracts that have just been posted to our website at http://www.oratechs.org, then register on-line! The advance registration deadline is April 16, so register now and save $75.00. For more information or if you need us to fax you a registration form contact Lisa Lancella at [EMAIL PROTECTED] or call (910) 253-9696. Hope to see you all in Stamford! Oratechs Conference Committee E-Mail sent using the Free Trial Version of WorldMerge, the fastest and easiest way to send personalized e-mail messages. More information at http://www.coloradosoft.com/worldmrg 391660 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Automatic shutdown on NT does a shutdown abort
Thanks Jared!! -Original Message- Sent: Monday, March 25, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Found the links for setting up Oracle to autostart/shutdown on NT. Jared http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=136214.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=82122.996 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=70988.996 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/25/02 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Automatic shutdown on NT does a shutdown abort Peter, 30 seconds seems a little short for shutting down the database. I allow 10 minutes for mine. In addition, the follow registry key needs to be modified to allow the 10 minute timeout. There's an Oracle note on this in MetaLink somewhere. Jared Registry Key: HKLM\SYSTEM\CurrentControlSet\Control WaitToKillServiceTimeout = value in milliseconds To avoid killing the service before the database is shutdown, this value needs to be equal to ORACLE_SID_SHUTDOWN_TIMEOUT * 1000. e.g. for an ORACLE_SID_SHUTDOWN_TIMEOUT value of 600, this would be set to 60. Schauss, Peter [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/25/02 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Automatic shutdown on NT does a shutdown abort Environment: Oracle 8.1.7 NT 4.0 sp 6 Registry parameters: ORA_sid_SHUTDOWN = TRUE ORA_sid_SHUTDOWN_TYPE=i ORA_sid_SHUTDOWN_TIMEOUT=30 When I stop the OracleServicesid, the database appears to do a shutdown abort. No entries are made in the alert log to indicate that a clean shutdown occurred. When I restart the service, the alert log contains messages like Beginning crash recovery of 1 threads. Any ideas what I have missed? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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 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 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: Farnsworth, Dave 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: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication
Dick - In the Oracle Backup and Recovery Class I took recently, I recall the instructor saying that restriction had been lifted in Oracle9i. I can't find my note on this, so don't take it as gospel, but it might be worth looking into if that would make a difference in the decisions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 25, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Robert, Either way, I do believe that you can't have a standby database in both managed recovery and read only access at the same time which could be your biggest problem. The application would have to understand that under normal circumstances it's getting data from database 'X' and during failures from database 'Y'. This kind of thing gets messy as well. Therefore your best bet is for local objects that are replicated from elsewhere since all sites can update all data your rather stuck. And as far as the network going down, yours in a similar comment that our network specialist made some 2 years ago, until a back hoe operator ripped out about 1/4 mile of fiber near our building. Took the local yokels 4 days to get it repaired. So don't say 'never' as it definitely can come back to bite you. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 2:52 PM Thanks for your thoughts Dick! Actually, look into Data Guard in 9i and you will find that you are no longer constrained by archive log switches!! I'm really concerned with the conflict resolution issues with MM Replication. I've done something like this once before, with only 2 sites, but it's been so long that it's a hazy distant memory. As I recall, the conflict resolution was a bear. They are intending on doing the resolution based on a date column and just saying that the latest date winds... they have a method of keeping the date/time on the servers in sync as long as the network is up, but my concern is what happens when it goes down and that date/time sync no longer is working or what happens when the system goes down and they also replace the hardware and the date/time is not sync'd for several days until the network is back. But... then I ask myself how often that will happen too... ;-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 2:37 PM To: Freeman, Robert ; Multiple recipients of list ORACLE-L Robert, Given what you've said it would appear that your only choice is going to be symetric/advanced replication, multi-master. The conflict resolution rules may be a bear to set up with 5 sites though. Using a standby db would not be very effective since data updates are dependent on the archive log switch points and that does not address the different sites if your reason for failure is a network related one. Snapshots won't work either since they are read only. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 9:48 AM Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your
RE: RE: Production Oracle DBA Needed in Rochester, Minnesota
Ahhh...be careful what you ask for. If that were truly the case, then you might not be able to find a job, since you would be outbid from someone working else where. Obviously, skills are a critical factor, but explain that to the bean counters... Some of the developers here are becoming very angry because some of the work has been farmed-out overseas because of their lower rates. It is a very interesting situation that I am quietly observing. The world is indeed becoming smaller. I have carefully worded this email in the hopes that I do not offend some of the VERY talented/god-like DBAs we have on this list that come a variety of locations around this great planet. I hope that I have succeeded. -Original Message- Sent: Monday, March 25, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Yeah, does anybody know what happened to the new Internet concept of location doesn't matter? I thought by now I could be sitting at home taking DBA assignments all over the country, if not over the world? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 25, 2002 11:44 AM To: Multiple recipients of list ORACLE-L If you need a change of location, you can get one easier... OK, now I understand what you meant. I can testify to the relocation potential because I recently escaped the Silicon Valley rat race to come up here to God's country. Nevertheless, I still fantasize about rendering remote DBA support via a laptop with multi-band satellite connectivity from a log cabin while snowed in at 10,000 feet. (Or while lounging in a hammock on some Carribean Ilse.) While I support servers 1000's of miles away, employers like to see you and hear you tapping on the keyboard. Working and living ANYWHERE is not so much a technical problem as it is an organizational, human relations challenge. Sigh... Steve Orr Still in Bozeman, MONTANA!!! -Original Message- Sent: Monday, March 25, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Well, up until about a couple of years ago, that was very true from what I experienced... Now, perhaps it takes a bit more work, but there seems to be enough demand around for the time being. Perhaps number 10 should be rather: 10. If you need a change of location, you can get one easier than with other jobs. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
RE: Oracle Technology Symposium Coming Soon!
No, but I really hate websites that assume everyone wants cookies turned on. And when they're not, the webapp blows chunks, but makes no mention of a missing cookie. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 25, 2002 2:28 PM To: Multiple recipients of list ORACLE-L YO, Anyone on the list attending this one?? Dick Goulet Forward Header_ Author: Oracle Technology Symposium [EMAIL PROTECTED] Date: 3/20/2002 9:23 AM RICHARD, Join us for our premier event in the Northeast! The Oracle Technology Symposium (Oratechs) will take place on May 2-3 at the Stamford Marriott Hotel in Stamford, Connecticut. Choose from over 30+ technical presentations on topics such as 9iAS Portal and Web Toolkit, 9iAS Business Intelligence, 9iAS Developer and JDeveloper, 9iMigration/New Features, Database and Web Security, Database Administration, Tools/Languages (including Third-Party), Project Design/Methodology/Mgmt. and Implementation Experiences. Also, take some time to visit with vendors exhibiting their latest products and services and network with other Oracle professionals in a comfortable, affordable setting. Check out the presentation abstracts that have just been posted to our website at http://www.oratechs.org, then register on-line! The advance registration deadline is April 16, so register now and save $75.00. For more information or if you need us to fax you a registration form contact Lisa Lancella at [EMAIL PROTECTED] or call (910) 253-9696. Hope to see you all in Stamford! Oratechs Conference Committee E-Mail sent using the Free Trial Version of WorldMerge, the fastest and easiest way to send personalized e-mail messages. More information at http://www.coloradosoft.com/worldmrg 391660 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Jesse, Rich 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: Automatic shutdown on NT does a shutdown abort
Peter, You don't even get a line in your Alert log like the following, which is what I always get immediately after I issue a Shutdown Immediate? ALTER DATABASE CLOSE NORMAL Perhaps 30sec. isn't enough time for your DB to do a Shutdown Immediate before the Oracle Service is stopped, which is equivalent to a Shutdown Abort? Try increasing ORA_sid_SHUTDOWN_TIMEOUT and see what happens. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Peter Sent: Monday, March 25, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Environment: Oracle 8.1.7 NT 4.0 sp 6 Registry parameters: ORA_sid_SHUTDOWN = TRUE ORA_sid_SHUTDOWN_TYPE=i ORA_sid_SHUTDOWN_TIMEOUT=30 When I stop the OracleServicesid, the database appears to do a shutdown abort. No entries are made in the alert log to indicate that a clean shutdown occurred. When I restart the service, the alert log contains messages like Beginning crash recovery of 1 threads. Any ideas what I have missed? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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: RE: Production Oracle DBA Needed in Rochester, Minnesota
as one who is currently looking for work and who has spent time talking to others who are in the same position, trust me, the demand is not really there. the reworded number 10 is more accurate --- Freeman, Robert [EMAIL PROTECTED] wrote: Well, up until about a couple of years ago, that was very true from what I experienced... Now, perhaps it takes a bit more work, but there seems to be enough demand around for the time being. Perhaps number 10 should be rather: 10. If you need a change of location, you can get one easier than with other jobs. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 12:04 PM To: '[EMAIL PROTECTED]' Cc: Freeman, Robert 10. So I can live where I choose. Oh really? How do you manage that? -Original Message- Sent: Monday, March 25, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Hey, I got five scampers running around right now youngest is 9 and the oldest is *gasp* 16 10 Reasons I became a DBA 1. So I don't have to mow my own lawn 2. So I don't have to change my own oil. 3. So I don't have to move my own furniture. 4. So I can have 5 kids and a wife. 5. So I can afford two NICE cars (well, mostly nice until the kids get to them). 6. So I can eat out every day if I choose. 7. One word, big screen TV (ok, three words). 8. Because it's cool. 9. Because I like getting paged at 3 in the morning to save someone's butt and have them owe me BIG. 10. So I can live where I choose. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication
Log application services can run in foreground or background now, but I don't think the database can be open read-only at the same time while doing managed recovery, even in 9i. Really, there is no read-only requirement in the architecture I'm looking at. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 3:46 PM To: Multiple recipients of list ORACLE-L Dick - In the Oracle Backup and Recovery Class I took recently, I recall the instructor saying that restriction had been lifted in Oracle9i. I can't find my note on this, so don't take it as gospel, but it might be worth looking into if that would make a difference in the decisions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 25, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Robert, Either way, I do believe that you can't have a standby database in both managed recovery and read only access at the same time which could be your biggest problem. The application would have to understand that under normal circumstances it's getting data from database 'X' and during failures from database 'Y'. This kind of thing gets messy as well. Therefore your best bet is for local objects that are replicated from elsewhere since all sites can update all data your rather stuck. And as far as the network going down, yours in a similar comment that our network specialist made some 2 years ago, until a back hoe operator ripped out about 1/4 mile of fiber near our building. Took the local yokels 4 days to get it repaired. So don't say 'never' as it definitely can come back to bite you. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 2:52 PM Thanks for your thoughts Dick! Actually, look into Data Guard in 9i and you will find that you are no longer constrained by archive log switches!! I'm really concerned with the conflict resolution issues with MM Replication. I've done something like this once before, with only 2 sites, but it's been so long that it's a hazy distant memory. As I recall, the conflict resolution was a bear. They are intending on doing the resolution based on a date column and just saying that the latest date winds... they have a method of keeping the date/time on the servers in sync as long as the network is up, but my concern is what happens when it goes down and that date/time sync no longer is working or what happens when the system goes down and they also replace the hardware and the date/time is not sync'd for several days until the network is back. But... then I ask myself how often that will happen too... ;-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 2:37 PM To: Freeman, Robert ; Multiple recipients of list ORACLE-L Robert, Given what you've said it would appear that your only choice is going to be symetric/advanced replication, multi-master. The conflict resolution rules may be a bear to set up with 5 sites though. Using a standby db would not be very effective since data updates are dependent on the archive log switch points and that does not address the different sites if your reason for failure is a network related one. Snapshots won't work either since they are read only. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 9:48 AM Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we
RE: Automatic shutdown on NT does a shutdown abort
Jared, Thanks for the links. However, we should be wary since the document at the end of the first link states (near the bottom) 1000 microseconds make one second! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Monday, March 25, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Found the links for setting up Oracle to autostart/shutdown on NT. Jared http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=136214.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=82122.996 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=70988.996 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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:RE: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replicatio
Dennis, I was just at an Oracle Tech seminar not more than 3 weeks ago. And as I remember the restriction on managed recovery vs. read only was still there the reason for it makes sense. With the underlying database in a constant state of flux from managed recovery it's hard to get a read consistent view. Now it was a whole lot simpler in 9i to switch the database from managed recovery to read only and back. But at any rate that does not address Roberts problem since the replicated copies of the data could not be modified unless you activated the standby database. After that it would be a real pain to re-sync each of the other standby's and what do you do with conflict resolution? Someone posted that RAC might be the way to go, I think that could be very iffy at best. It would depend on the distance between sites and the communications capabilities of the network. I've not heard of anyone setting up RAC in that fashion and would not want to try it myself. Also someone suggested a Quest product. I believe that product does read log files, not sure if a 9i version is currently available. I do believe that Oracle must switch logs for that product to function and you'd need one copy between each database, what did you say 4 sites? That makes 8 copies of the program running at one time then I have no idea how you would set it up to handle conflicts. I do not believe it was created in that way. Now if your really into being creative you could come up with your own packages procedures and/or external programs to handle the workload for you. That would be work though. Dick Goulet Reply Separator Author: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 3/25/2002 12:45 PM Dick - In the Oracle Backup and Recovery Class I took recently, I recall the instructor saying that restriction had been lifted in Oracle9i. I can't find my note on this, so don't take it as gospel, but it might be worth looking into if that would make a difference in the decisions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 25, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Robert, Either way, I do believe that you can't have a standby database in both managed recovery and read only access at the same time which could be your biggest problem. The application would have to understand that under normal circumstances it's getting data from database 'X' and during failures from database 'Y'. This kind of thing gets messy as well. Therefore your best bet is for local objects that are replicated from elsewhere since all sites can update all data your rather stuck. And as far as the network going down, yours in a similar comment that our network specialist made some 2 years ago, until a back hoe operator ripped out about 1/4 mile of fiber near our building. Took the local yokels 4 days to get it repaired. So don't say 'never' as it definitely can come back to bite you. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 3/25/2002 2:52 PM Thanks for your thoughts Dick! Actually, look into Data Guard in 9i and you will find that you are no longer constrained by archive log switches!! I'm really concerned with the conflict resolution issues with MM Replication. I've done something like this once before, with only 2 sites, but it's been so long that it's a hazy distant memory. As I recall, the conflict resolution was a bear. They are intending on doing the resolution based on a date column and just saying that the latest date winds... they have a method of keeping the date/time on the servers in sync as long as the network is up, but my concern is what happens when it goes down and that date/time sync no longer is working or what happens when the system goes down and they also replace the hardware and the date/time is not sync'd for several days until the network is back. But... then I ask myself how often that will happen too... ;-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 2:37 PM To: Freeman, Robert ; Multiple recipients of list ORACLE-L Robert, Given what you've said it would appear that your only choice is going to be symetric/advanced replication, multi-master. The conflict resolution rules may be a bear to set up with 5 sites though. Using a standby db would not be very effective since data updates are dependent on the archive log switch points and that does not address the different sites if your reason for failure is a network related one. Snapshots won't work either since they are read only. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL
RE: [RE: Stand-by (Oracle9i Data Guard) vs. Replication]
there is a new white paper (Feb 2002) from Oracle HA Center for Expertise that speaks to making databases maximumly highly available. It suggests a combination of RAC and standby (dataguard) with 9i. My thoughts on your requirements are: first -- I agree with Kirti, you need VERY specific language and should have downtime etc quantified in measurable units. ASAP is not measurable, for some systems that might mean two minutes and for others it might mean days. Get NUMBERS second -- can you run these in separate databases with dblinks? I'd isolate the data based on how available and to whom it has to be available. so I'd consider the Oracle solution for the data that must be available to everyone, then separate servers and databases for the others. third -- understand that it doesn't matter how available your servers and databases are if the networks are also not redundant. Finally -- has anyone at all considered and allowed for downtime for maintenance/upgrades? Just a few thoughts off the top of my head. Rachel --- Freeman, Robert [EMAIL PROTECTED] wrote: Unfortunately, there are synchronization issues with the use of the stand-by since one requirement is that EACH of the 4 sites must be able to run autonomously... in other words, if I take all 4 sites out of stand-by mode, they make changes at all 4 sites and then we have to resynch (after the network is back for example) how the heck do I do that. I thought about using separate schemas for local data, and transportable tablespaces, but there is some data that is shared by the entire network, and that is a problem. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 1:05 PM To: Multiple recipients of list ORACLE-L One way to recover Standby machine is to share a drive from the remote machine, and copy (ftp) the log files to the shared drive every time a new log file was created. Yigal Freeman, Robert [EMAIL PROTECTED] wrote: Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy, but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however. These requirements smack of trouble to me. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 25, 2002 11:48 AM To: Multiple recipients of list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- Freeman, Robert [EMAIL PROTECTED] wrote: Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data: 1. Network Critical data (must be available for entire network) 2. Regional Critical data (only used for a given region. site = region). 3. Regional non-critical data (this is data that is easily recovered from other operational data stores). I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN). What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution. Thoughts? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
ORA-1652: unable to extend temp segment - BUT I have plenty of sp
We are periodically getting the; ORA-1652: unable to extend temp segment by 128 in tablespace TEMP errors. I could not identify the problem, so I set up a monitor script which would insert into a log table space usage records every 30 seconds, so I could see the space usage at the time of the failure. After we got another ORA-1652, I looked up the time and queried my log table, which showed hardly any usage in the TEMP tablespace. My question is; Why do I keep getting this error when I have plenty of free space in TEMP??? Why is it trying to extend a 128 extent when I have uniform extents (locally managed temporary tablespace and the extent sizes are 1M)? Here are my supporting settings; Temporary tablespace settings: create temporary tablespace TEMP tempfile '/RPT/oradata04/prddata/temp01.dbf' size 5000M REUSE extent management LOCAL UNIFORM size 1048576; Query at the time of the failure: select sysdate dtstamp, s.tablespace_name, d.tbspc_mb, s.total_blocks*8192/1024/1024 temp_tot_mb, s.used_blocks*8192/1024/1024 temp_used_mb, s.free_blocks*8192/1024/1024 temp_free_mb fromv$sort_segment s, (select tablespace_name,sum(bytes/1024/1024) tbspc_mb from dba_data_files group by tablespace_name union select tablespace_name,sum(bytes/1024/1024) tbspc_mb from dba_temp_files group by tablespace_name) d where s.tablespace_name=d.tablespace_name; Output: Tablespace Tablespace Allocated Allocated Allocated Name Total MB Total MB Used MB Free MB -- - - - TEMP 5,000 568 6 562 Users using temp space query; select s.sid || ',' || s.serial# sid, s.username, u.tablespace, a.sql_text, round(((u.blocks*p.value)/1024/1024),2) size_mb from v$sort_usage u, v$session s, v$sqlarea a, v$parameter p where s.saddr = u.session_addr and a.address (+) = s.sql_address and a.hash_value (+) = s.sql_hash_value and p.name = 'db_block_size' and s.username != 'SYSTEM' group by s.sid || ',' || s.serial#, s.username, a.sql_text, u.tablespace, round(((u.blocks*p.value)/1024/1024),2); Output: Temporary Mbytes Session ID User Name TS NameSQL Used -- -- -- --- 152,6214 APPS TEMP select parameter, value from nls_session_parameters 1.00 32,11293 APPS TEMP select parameter, value from nls_session_parameters 1.00 (a couple of others totalling 6MB) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: Automatic shutdown on NT does a shutdown abort
And I wonder if they know that Oracle time slices are in centiseconds? :) Jared Jack C. Applewhite [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/25/02 01:10 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Automatic shutdown on NT does a shutdown abort Jared, Thanks for the links. However, we should be wary since the document at the end of the first link states (near the bottom) 1000 microseconds make one second! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Monday, March 25, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Found the links for setting up Oracle to autostart/shutdown on NT. Jared http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=136214.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=82122.996 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=70988.996 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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 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: ORA-1652: unable to extend temp segment - BUT I have plenty
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=266638.999 The above link has some comments , but Oracle folks says ALTERING THE DATA FILE will be OK. May be you can have some more inputs ... Thanks, Madhu -Original Message- Sent: Monday, March 25, 2002 3:30 PM To: Multiple recipients of list ORACLE-L sp We are periodically getting the; ORA-1652: unable to extend temp segment by 128 in tablespace TEMP errors. I could not identify the problem, so I set up a monitor script which would insert into a log table space usage records every 30 seconds, so I could see the space usage at the time of the failure. After we got another ORA-1652, I looked up the time and queried my log table, which showed hardly any usage in the TEMP tablespace. My question is; Why do I keep getting this error when I have plenty of free space in TEMP??? Why is it trying to extend a 128 extent when I have uniform extents (locally managed temporary tablespace and the extent sizes are 1M)? Here are my supporting settings; Temporary tablespace settings: create temporary tablespace TEMP tempfile '/RPT/oradata04/prddata/temp01.dbf' size 5000M REUSE extent management LOCAL UNIFORM size 1048576; Query at the time of the failure: select sysdate dtstamp, s.tablespace_name, d.tbspc_mb, s.total_blocks*8192/1024/1024 temp_tot_mb, s.used_blocks*8192/1024/1024 temp_used_mb, s.free_blocks*8192/1024/1024 temp_free_mb fromv$sort_segment s, (select tablespace_name,sum(bytes/1024/1024) tbspc_mb from dba_data_files group by tablespace_name union select tablespace_name,sum(bytes/1024/1024) tbspc_mb from dba_temp_files group by tablespace_name) d where s.tablespace_name=d.tablespace_name; Output: Tablespace Tablespace Allocated Allocated Allocated Name Total MB Total MB Used MB Free MB -- - - - TEMP 5,000 568 6 562 Users using temp space query; select s.sid || ',' || s.serial# sid, s.username, u.tablespace, a.sql_text, round(((u.blocks*p.value)/1024/1024),2) size_mb from v$sort_usage u, v$session s, v$sqlarea a, v$parameter p where s.saddr = u.session_addr and a.address (+) = s.sql_address and a.hash_value (+) = s.sql_hash_value and p.name = 'db_block_size' and s.username != 'SYSTEM' group by s.sid || ',' || s.serial#, s.username, a.sql_text, u.tablespace, round(((u.blocks*p.value)/1024/1024),2); Output: Temporary Mbytes Session ID User Name TS NameSQL Used -- -- -- --- 152,6214 APPS TEMP select parameter, value from nls_session_parameters 1.00 32,11293 APPS TEMP select parameter, value from nls_session_parameters 1.00 (a couple of others totalling 6MB) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: Reddy, Madhusudana 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: ORA-1652: unable to extend temp segment - BUT I have plenty of sp
Glenn, Use following query to check usage of temp(temporary) tablespace and put into your log table: select user,segtype,extents from v$sort_usage Are you having any table/indexes with degree 1 (check dba_tables/dba_indexes) Some of your job using such tables in parallel because of degree 1 and resulting in segtype as hash instead of sort and in this case it uses a lot of temp tablespace execeeding its total limit. There is also a possiblity that there may be some cartisian product/joining which also consumes a lot of temp tablespace and 5G is nothing when it happens... Once that job is terminated the usage goes to Zero so you cannot track it. Besides user also don't complaint because of fear of running wrong code. If nobody complaints then don't bother... HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 25 Mar 2002 13:30:26 -0800 We are periodically getting the; ORA-1652: unable to extend temp segment by 128 in tablespace TEMP errors. I could not identify the problem, so I set up a monitor script which would insert into a log table space usage records every 30 seconds, so I could see the space usage at the time of the failure. After we got another ORA-1652, I looked up the time and queried my log table, which showed hardly any usage in the TEMP tablespace. My question is; Why do I keep getting this error when I have plenty of free space in TEMP??? Why is it trying to extend a 128 extent when I have uniform extents (locally managed temporary tablespace and the extent sizes are 1M)? Here are my supporting settings; Temporary tablespace settings: create temporary tablespace TEMP tempfile '/RPT/oradata04/prddata/temp01.dbf' size 5000M REUSE extent management LOCAL UNIFORM size 1048576; Query at the time of the failure: select sysdate dtstamp, s.tablespace_name, d.tbspc_mb, s.total_blocks*8192/1024/1024 temp_tot_mb, s.used_blocks*8192/1024/1024 temp_used_mb, s.free_blocks*8192/1024/1024 temp_free_mb fromv$sort_segment s, (select tablespace_name,sum(bytes/1024/1024) tbspc_mb from dba_data_files group by tablespace_name union select tablespace_name,sum(bytes/1024/1024) tbspc_mb from dba_temp_files group by tablespace_name) d where s.tablespace_name=d.tablespace_name; Output: Tablespace Tablespace Allocated Allocated Allocated Name Total MB Total MB Used MB Free MB -- - - - TEMP 5,000 568 6 562 Users using temp space query; select s.sid || ',' || s.serial# sid, s.username, u.tablespace, a.sql_text, round(((u.blocks*p.value)/1024/1024),2) size_mb from v$sort_usage u, v$session s, v$sqlarea a, v$parameter p where s.saddr = u.session_addr and a.address (+) = s.sql_address and a.hash_value (+) = s.sql_hash_value and p.name = 'db_block_size' and s.username != 'SYSTEM' group by s.sid || ',' || s.serial#, s.username, a.sql_text, u.tablespace, round(((u.blocks*p.value)/1024/1024),2); Output: Temporary Mbytes Session ID User Name TS NameSQL Used -- -- -- --- 152,6214 APPS TEMP select parameter, value from nls_session_parameters 1.00 32,11293 APPS TEMP select parameter, value from nls_session_parameters 1.00 (a couple of others totalling 6MB) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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]
Could not create Tcl interpreter ???
Hi, I'm using OEM 9.0.1 on Win2000, after I submitted a job, I got error Could not create Tcl interpreter. I read some metalink articles which don't help. Any solution? Much appreciated! Janet __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
