SQL*PLUS buffer width and buffer length stored where ??
All, I have the issue with setting a basic format in sql plus In my login.sql I have set line size 1000 Say I have a have a table with 20 columns and I select * from table where rownum =2 What happens is I can't scroll the data... (The horizontal scroll is locked)) Unless I go into Optionsenvironment Screen buffer width 900 Screen buffer length 899 This works in my environment however Id like to roll out a default login.sql to users or have the ability to set the sessions for them. I've search online and there doesn't seem a way to set the buffer width from a config file, only through the gui. I'm sure someone here knows that, or has a complete login.sql file to have the ability to enable the horizontal scroll by default Thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*PLUS buffer width and buffer length stored where ??
Interesting finding here ORCL9 SQL Store set C:\oracle\ora92\dbs\login.sql Or if the file exists ORCL9 SQL Store set C:\oracle\ora92\dbs\login.sql append That generates a substantial config file, much more than a standard login I have to test if it actually keeps the buffer width and length. I don't see it in there, though. Bob -Original Message- Sent: Tuesday, November 04, 2003 11:34 AM To: Multiple recipients of list ORACLE-L All, I have the issue with setting a basic format in sql plus In my login.sql I have set line size 1000 Say I have a have a table with 20 columns and I select * from table where rownum =2 What happens is I can't scroll the data... (The horizontal scroll is locked)) Unless I go into Optionsenvironment Screen buffer width 900 Screen buffer length 899 This works in my environment however Id like to roll out a default login.sql to users or have the ability to set the sessions for them. I've search online and there doesn't seem a way to set the buffer width from a config file, only through the gui. I'm sure someone here knows that, or has a complete login.sql file to have the ability to enable the horizontal scroll by default Thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What happened to Howard Rogers ?
This still seems active http://www.geocities.com/lydian_third/ Howard Rodgers writes extremely clearly. bob -Original Message- Sent: Thursday, October 23, 2003 10:04 AM To: Multiple recipients of list ORACLE-L howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We all know alot of people who 'used to work for oracle'. biggest downside is the lydian third site is gone. Had all the copies of his essays on it. apparently oracle theratened to sue him over it. Supposedly in australia companies own you while you work theere and you need special permission to publish. From: sdf [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:24:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: What happened to Howard Rogers ? Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sdf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
question on comments -sanity check
All The powers that be have it in their minds that there is a place for comments on each column in a table. afaik.. comments are only associated with tables not columns Eg Select * from user_tab_comments; People here seem to think they can document their columns by comments. Maybe I'm just burnt out... or am I missing something? A sanity check please. Also, is there a relatively easy way to maintain comments? Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: question on comments -sanity check
Dammit! I see now select * from user_col_comments order by table_name; -Original Message- Sent: Wednesday, October 22, 2003 3:41 PM To: '[EMAIL PROTECTED]' All The powers that be have it in their minds that there is a place for comments on each column in a table. afaik.. comments are only associated with tables not columns Eg Select * from user_tab_comments; People here seem to think they can document their columns by comments. Maybe I'm just burnt out... or am I missing something? A sanity check please. Also, is there a relatively easy way to maintain comments? Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Can I concatenate several rows without a procedure?
select username||user_id||' freestyle!! '|| created as concat from all_users; Hello, I am trying to concatenate several records with simple sql. Is this possible? -- Thanks, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Tires, and Wheel Packages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jake Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Can I concatenate several rows without a procedure?
Humm, what purpose would that serve? How would that be useful? My perception is a row of data is independently referenced and if you concat n rows into one string... the data would no longer be referenced individually. No doubt someone on this list can give you a solution, but Im sure it would need to be in a procedure, looping thru and concating as it went... which was not your original criteria. -Original Message- Sent: Tuesday, October 21, 2003 2:44 PM To: Multiple recipients of list ORACLE-L The following query returns 33 records. SYS0 freestyle!! 12-MAY-02 SYSTEM5 freestyle!! 12-MAY-02 OUTLN11 freestyle!! 12-MAY-02 But, I would like to have all 33 records appended together to have one long record. SYS0 freestyle!! 12-MAY-02SYSTEM5 freestyle!! 12-MAY-02OUTLN11 freestyle!! 12-MAY-02 Thanks again, Jake On Tue, Oct 21, 2003 at 07:49:25AM -0800, Bob Metelsky wrote: select username||user_id||' freestyle!! '|| created as concat from all_users; Hello, I am trying to concatenate several records with simple sql. Is this possible? -- Thanks, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Tires, and Wheel Packages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jake Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Tires, and Wheel Packages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jake Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
passwords case sensitive
Is it possible to force a password case sensitive? Command? Thanks! TGIF bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: passwords case sensitive
@C:\oracle\ora92\rdbms\admin\utlpwdmg.sql Im not seeing anything in that script that refers to enforcing ProperCase ??? ?? bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 5:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: passwords case sensitive see $ORACLE_HOME/rdbms/admin/utlpwdmg.sql Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 01:54 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:passwords case sensitive Is it possible to force a password case sensitive? Command? Thanks! TGIF bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Opinions sought on possible TOAD replacement
TORA, OraC, sqlplus, vi, perl and a linux box to run it on, though the database servers are mostly Win2k. Software $0.00 OS $0.0 HW $12k A procedure return with no errors Priceless g FWIW for a nice sql editor golden is nice. Others on this list sold me on that bob Paul Vincent [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 08:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been recommended a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!. But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
RE: How to add ' (comma) at the begining and end of each line? Either Unix or Windows
A windows solution for /f %d in (C:\yourfile.txt) do echo ,%d,C:\yourfilewithcomma.txt bob Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Passed Net8 OCP Exam
Congrats Dennis! I know we have be at that for some time now Way to go! bob Scott - My questions were distributed exactly as yours, maybe even the same questions, but it's all a blur now. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 2:55 PM To: Multiple recipients of list ORACLE-L WooHoo! Congrats Dennis! So were the questions distributed the same as when I took it, or did they emphasize different areas? Just curious. -Scott Stefick -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, October 16, 2003 2:24 PM To: Multiple recipients of list ORACLE-L I just passed the Net8 Administration OCP exam. This was my last exam, so I suppose I am now an OCP for Oracle8i. Thanks to everyone for their helpful tips. Some people said (or implied) that this is a very easy exam. I would dispute that. I found it just like the other exams, in that if you have quite a bit of on-the-job experience in the area, then it is easy. If not, you'll have to study more. In my case, - I don't like networking, and hate to drop everything to configure or debug someone's tnsnames.ora file. - Never had an Oracle networking class. - Our site has only needed local naming, so that is pretty much all my networking experience. Found all the questions related to local naming pretty easy. Never used Oracle Names, Connection Manager, MTS, Advanced Security. With the trend toward application servers with their connection pooling feature, I don't foresee us using any of those Oracle tools. I may need to use LDAP in the future, but that wasn't covered in the Oracle8i Net8 exam My goal was just to study and practice enough to practice the exam, and I accomplished the goal. Not a very lofty goal, but sometimes you do what you gotta do. Thanks everyone for the helpful suggestions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
question about less than values in a range partition
Good morning all Im experimenting with partitioning a table and do not understand the concept of the less than value Say I have a end_date date field 01-JAN-00 01-JAN-01 01-JAN-02 and I create a range partition (PARTITION SO00Q1 VALUES LESS THAN (TO_DATE('01-JAN-2000', 'DD-MON-')), PARTITION SO01Q1 VALUES LESS THAN (TO_DATE('01-JAN-2001', 'DD-MON-')), PARTITION SO02Q1 VALUES LESS THAN (TO_DATE('01-JAN-2002', 'DD-MON-'))... My mind is thinking SO00Q1 will have the desired jan 2000 But SO01Q1 would have jan 2001 and since the first partition is less than 2000 It would include what is in partition 1 And partition 2 would have 1 and 0 Between would make more sence to me How does the less than N work? Thanks! bob Bob Metelsky Oracle Certified Professional Phone 203-245-5089 ext113 Office 203-245-5000 Continuum Performance Systems Inc http://www.cps92.com PGP Key http://cps92.com/cps109.gpg -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to keep statistics up to date for CBO
Thank you very much Tom. That gives me an excellent starting point. I'll begin to implement this in a devel environment and get a feel for it. Thanks again! bob -Original Message- Sent: Thursday, October 09, 2003 9:00 AM To: Multiple recipients of list ORACLE-L Bob, I do the following: First, alter all tables turning monitoring on: alter table {table name} monitoring; Monitoring says: Specify MONITORING if you want Oracle to collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. Then use the following. It recalculates stats for those tables that have been changed enough to warrant stats. The User_Tab_Modifications table will hold a record if 10% of the table was changed. I've been using this for a while now, and it seems to be working fine. As you can see, I have a database table that I insert a record into so I can see how much work is done. I'm happy with it. And I'm not gathering stats for tables that I don't need to. I run this job daily. Hope this helps. PROCEDURE WTWDBA.Wtw_Gather_Statistics IS /* Procedure Name : Wtw_Gather_Statistics Author : Tom Mercadante Mercadante Systems Design June 14, 2001 Purpose: This Package will use the System DBMS_STATS package to gather statistics for both tables and indexes. */ loc_table_name USER_TABLES.TABLE_NAME%TYPE; loc_index_name USER_INDEXES.INDEX_NAME%TYPE; tbl_count NUMBER := 0; indx_count NUMBER := 0; loc_start_time DATE; CURSOR c1 IS SELECT ut.table_name FROM USER_TABLES UT, USER_TAB_MODIFICATIONS UTM WHERE UT.TABLE_NAME = UTM.table_name; CURSOR c2 IS SELECT index_name FROM USER_INDEXES WHERE table_name = loc_table_name; BEGIN loc_start_time := SYSDATE; -- Gather statistics on tables OPEN c1; LOOP FETCH c1 INTO loc_table_name; EXIT WHEN c1%NOTFOUND; dbms_stats.gather_table_stats('WTWDBA',loc_table_name); tbl_count := tbl_count + 1; -- Gather statistics on indexes OPEN c2; LOOP FETCH c2 INTO loc_index_name; EXIT WHEN c2%NOTFOUND; dbms_stats.gather_index_stats('WTWDBA',loc_index_name); indx_count := indx_count + 1; END LOOP; CLOSE c2; END LOOP; CLOSE c1; -- insert a record into the job log INSERT INTO WTW_JOB_LOG(JOB_NAME, RUN_DATE, START_TIME, END_TIME, MSG_TXT) VALUES('Wtw_Gather_Statistics',SYSDATE,loc_start_time, SYSDATE,INITCAP('SCHEMA Stats Complete') || CHR(10) || tbl_count || INITCAP(' TABLES Analyzed ') || CHR(10) || indx_count || INITCAP(' INDEXES Analyzed')); COMMIT; END; Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 08, 2003 4:54 PM To: Multiple recipients of list ORACLE-L How does one keep CBO statistics for an applications base tables up to date? We are about to implement the CBO any must read documents. Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
RE: where can I find sample db creation script (9.2.0.1.0 installation)?
ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to keep statistics up to date for CBO
How does one keep CBO statistics for an applications base tables up to date? We are about to implement the CBO any must read documents. Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to copy recursive files in Windows? like UNIX cp -r
For stubborn files, or if an error occurs during the copy, this uses the /c switch FOR /d %a in (G:\some\location\*) do xcopy *.* /s /c H:\someother\location This essentially forces the xcopy through the source directory, sometimes useful for copying off of cds where the data can be temporarily unavailable due to windows interaction with the hardware bob -Original Message- Sent: Wednesday, October 08, 2003 3:15 PM To: Multiple recipients of list ORACLE-L xcopy -Original Message- Sent: Wednesday, October 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: where can I find sample db creation script (9.2.0.1.0 installation)?
%ORACLEHOME%\rdbms\admin\build.db is one of them check this script which calls several others bob -Original Message- Sent: Wednesday, October 08, 2003 5:39 PM To: Multiple recipients of list ORACLE-L installation)? Hi: I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time. I let the installation to create a sample db. Now I am trying to see where I can find the db creation script, so I can study it and use it to create db instance manually. I can only find a bounch of log files in $ORACLE_ADMIN/sid/create directory, such as cloneDBCreation.log lockAccount.log postDBCreation.log postScripts.log ultraSearchCfg.log So does anyone know where I can find the script? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Desupport of RBO[Scanned]
, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to send mail from windows command prompt?[Scanned]
Use blat http://www.interlog.com/~tcharron/blat.html using blat is as simple as copying the exe to the windows system folder install as blat -install yourmailserver [EMAIL PROTECTED] 5 25 then call as shown below here is an example of blat used in a script :: C:\monitor.cmd :: Internet connection manager by BMetelsky Friday-June-20-2003-10:12:53 AM @echo off set theip=299.69.89.999 set theapp=Internet Connection Monitor set [EMAIL PROTECTED] set badmessage=The %theip% is NOT AVAILABLE at %date% at %time% title %theapp% is pinging %theip% to verify it is up :: echo C:\connection.txt :begin ping -a %theip%| FIND TTL C:\connection.txt IF ERRORLEVEL 1 GOTO :email sleep 10 GOTO begin :email blat C:\connection.txt -subject Internet connection is down at %date% at %time% -to %dbamail% -i [EMAIL PROTECTED] -body %otherbadmessage% C:\connection.txt GOTO begin ## HTH ! Bob Hello All: I have setup some scripts that would export the db every day. Instead of looking through the logs manually every morning, is there a way to tail (windoze equivalent?) the file and send and email (mailx equivalent on windows?) I know this can be implemented in Perl, but I don't know perl so I am looking for help on Windoze...PLEASE! I really appreciate your help in this matter. Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paulo Gomes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book[Scanned]
A few years ago being an experienced DBA was a valuable commodity and we really enjoyed that. But the managers were very frustrated by having to search hard for a DBA, pay spiraling salary demands, etc. I think some managers look on these times as their revenge. What some DBAs see as pay cuts the managers see as a return to sanity. Can anyone relate to this scenario? # Well, they may have their revenge now, (I certainly see that every day where I am for the past year or so) although I'm confident the tides will turn and we techies will once again rise. What gets my gall is, so many managers think short term and would sell their own mother if it meant one more step up the ladder for then, while people like us pride ourselves on something solid like real skills, knowledge and experience that make the actual wheels turn. We can't cook the books like we have seen from our 'leadership'. That level of 'business skill' makes me sick. Now our field is a primary victim of their short sightedness and greed. Oh sure... we are overpaid... right. It's an easy target but invalid and no doubt time will prove that. Its funny, I attended the recent NYOUG (Rachael where were you???g) and Oracle was spouting about 10g being a one click install, everything self managing, self tuning..., self installing, I mean that's laughable!!! Sure it will seem/ sold as self managing... but how does one know what *IS* managed and what to to do in the event the wizard fails grin? It's just marketing for the times. As soon as this economy gets on its feet And it will get back, all this will be behind us and nothing but the lowest level work will be outsourced... The times they will be a changing TGIF!! Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle and nfs mounted devices.[Scanned]
I am not a guru (as any one here can attest... g but The last line tell you what the problem is O/S-Error: (OS 3) The system cannot find the path specified. Oracle cant find the path, you probably need to pass it something like \\server_name\d$\oracle\oradata\mmstest\test.dbf providing the oracle on d is shared out bob Hello Gurus: I have been asked to create datafiles (create tablespace) on disk drives that are mapped ( internal disk - attached to remote servers) When I tried creating tablespace...I get the following error message: ERROR at line 1: ORA-01119: error in creating database file 'd:\oracle\oradata\mmstest\test.dbf' ORA-27040: skgfrcre: create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) The system cannot find the path specified. My opinion is Oracle does not support this operation. However I do not fully understand the internals of it...Is oracle not able to obtain locks on the device? Please Help. Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hiding passwords
That's very interesting... Thank you. Do you know how that can be set in an env variable? Or how the hidden variable can be passed around? Eg C:\adsset var=file.txt:pwd Or C:\adsset var=morefile.txt:pwd Echo %var% C:\ads echo is on ??? Thanks Bob In Windows2000 you can encrypt a file... Not sure how well that would work though, since if you install your software as local administrator (not good practice) then anyone else who logs in as administrator would be able to see / run the file too... Here is a little known trick of NTFS file systems. It's called data streams. D:\del file.txt D:\echo Some stuff file.txt D:\echo and its password file.txt:pwd D:\dir Volume in drive D is OS Volume Serial Number is A4BA-68F3 Directory of D:\ 24/09/2003 11:19p 13 file.txt (note the file size!) D:\type file.txt Some stuff D:\type file.txt:pwd The filename, directory name, or volume label syntax is incorrect. D:\more file.txt:pwd and its password D:\ I'm sure there are some interesting uses to be explored here to hide Oracle passwords! ;) Note: the hidden data stream name can be ANY filename string and is subject to security. This was used initially in NTFS to support the Mac resource fork file format in file servers. It is still there and won't go away any time soon as IIS uses it. MS Knowledge base article 105763 discusses this in detail. You can also search google for some details. Use alternate data streams. Careful: this is used by some virus writers!!! Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: createing test sessions
How about for /L %i IN (1,1,250) do start /min sqlplus user/[EMAIL PROTECTED] @script.sql Id try it with less than 250 as it can kill the machine opening 250 windows! ;-) to run form a batch file you need to %%i the variable hth bob If on windows, type start /min sqlplus user/[EMAIL PROTECTED] @script.sql ..255 times on your windows command prompt. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 7:54 PM I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script. Help bittee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: createing test sessions
Our exchange hiccupped... How about for /L %i IN (1,1,250) do start /min sqlplus user/[EMAIL PROTECTED] @script.sql Id try it with less than 250 as it can kill the machine opening 250 windows! ;-) to run form a batch file you need to %%i the variable hth bob If on windows, type start /min sqlplus user/[EMAIL PROTECTED] @script.sql ..255 times on your windows command prompt. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 7:54 PM I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script. Help bittee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to generate unique file names on Windows.
This adds the time in fractions... ## uniquefile.bat## @echo off for /f tokens=2,3,4 delims=/ %%a in ('date /t') do set pre=%%a%%b%%c_ FOR /F TOKENS=5-8 DELIMS=:. %%F IN ('ECHO.^|TIME') DO ( SET Hour=%%F SET Mins=%%G SET Secs=%%H SET Mill=%%I) set filename=yourPREFIX_%pre: =_%%Hour: =_%%Mins: =_%%Secs: =_%%Mill:=_%.txt ## hth bob I am trying to write a script on windows that would export the db every night. Can someone tell me how to generate unique file names on windows... What I am looking for is the windows equivalent of echo `date +%m%d%y` Thanks in advance. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Google's architecture -- was Re: paging and google.com
Title: Message An brief overview of Googles architecture http://www.computer.org/micro/mi2003/m2022.pdf Google does use Oracle, but afaik only in-house for internal applications. The clustered search engine is entirely custom code and engine. 10,000 servers would be a pretty big RAC install. :) Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Google's architecture -- was Re: paging and google.com I'm confused. Does Tom Kyte actually say that Google uses Oracle or is he talking of google-like behaviour in Oracle queries ? Hemant At 07:24 AM 26-09-03 -0800, you wrote: http://tinyurl.com/ordz HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8i OCP Net8 Exam
Hello Dennis To the best of my recollection it was not included. Pretty much basic stuff on that test. For me that was the easiest, and made the most sense of the tests I've taken Bob Can anyone recall whether the Oracle Intelligent Agent figured on the Oracle8i OCP Network Administration exam? Couchman's practice exams have quite a few questions on Intelligent Agent, but when I check the official Test Content Checklist on Oracle's Education website, it isn't directly mentioned. Being the lazy slob I am, wouldn't want to study extra. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off Topic: PC Firewall Recommendation
I agree I have a SMC 8 port broadband router that has a web based firewall admin module. It's worked excellent for over 2 years and is fully configurable. I would look for any over the counter router that included a web based firewall. Probably around $75 SMC lynksys... -Original Message- Sent: Monday, September 29, 2003 6:00 PM To: Multiple recipients of list ORACLE-L I second this recommendation. CNET testing showed that ZoneAlarm (even the free version; there's also ZoneAlarm Pro) did a better job of blocking break-in and hack attempts than most of the commercial products. --- Grabowy, Chris [EMAIL PROTECTED] wrote: Try Zonealarm. It's free. I have a wireless router, which has a built in firewall. -Original Message- Sent: Monday, September 29, 2003 10:05 AM To: Multiple recipients of list ORACLE-L I have a Dell 8200 with XP Prof. SP1. I would like recommendations as to a good firewall for this machine. XP has a firewall but it is not the greatest. Thanks much, Ken Janusz, CPIM __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 10g: SQL Plus
Losing the pseudo-GUI version would be a a drag, because it's so easy to copy and paste text in it (not so easy in a Windows command prompt). Try right click - paste or click the upper left icon and choose paste To copy - choose mark then enter -its then in the clipboard Ive actually began to like sqlplus (opposed to sqlplusw). One good feature is you have your command history using the up arrow like regular shell bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: download metalink articles - save target as
The grueling method is... grab the header, copy paste it into notepad.exe. That strips the weird formatting out of it. Grab the body text, but not all the way down, try to guess where the body text frame ends and stop just before that. It may take a few tries to find exactly where. copy paste into Wordpad.exe. Hehehe.. amazing what we have to go through. An easier method I use it to view source - then chop out any erroneous html and save as mydoc.html Then you can view the html and copy out nicely... That's my workaround bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Onames and various connections scenarios
Title: Message Jared, Ive read the documentation http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/controlu.htm#442071 But I dont see where it says this is a method to get a tnsnames on the *clients* workstation, It works on theserver but creates a 0 byte file on the client workstation I have a 9i names server, 8.17 on the clientand win2k. Ialso dont see how set server fits in asnamesctlon the client reveals the name server correctly my 817 is patched to level 4 although the banner for namesctl does not show it EG C:\namesctl dump_tnsnames Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production on 03-SEP-2003 09:16:16 (c) Copyright 1997 Oracle Corporation. All rights reserved. Currently managing name server "NS_CPSDB2"Version banner is "Oracle Names for 32-bit Windows: Version 9.2.0.1.0 - Production" Are you sayingyou have the same setup and it works for you? Here is my sqlnet.ora NAMES.INITIAL_RETRY_TIMEOUT = 2NAMES.REQUEST_RETRIES = 1NAMES.DIRECTORY_PATH= (ONAMES,TNSNAMES, HOSTNAME) NAMES.PREFERRED_SERVERS = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = CPSDB2)(PORT = 1575)) (ADDRESS = (PROTOCOL = TCP)(HOST = CPS012)(PORT = 1575)) ) SQLNET.EXPIRE_TIME = 10SQLNET.AUTHENTICATION_SERVICES= (NTS) ### Of course I can have a logon script grap the file, but Iprefer this method as its much more elegant ... and indeed I saw it on the list last Friday. Sure it's supposed to work that way. It is a documented feature. Otherwise there would be little point in having a 'set server' command. Jared "Bob Metelsky" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/02/2003 03:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Onames and various connections scenarios This is a mesage that I sent on Friday, and to my knowledeg did not showup, (+ there were no responses) Im assuming if I can post... That I amin fact subscribed ;-)Hopefully this make itThanks!bob##Ok, so it was too good to be truethe suggestion to run namesctl dump_tnsnames on the client and expecting a fresh copy of tnsnames to be installed (onthe clients machine) is NOT supported.I searched on metalink, alot of people have the same problem " a 0 bytetnsnames file being created using namesctl"Alot of OLD bugs that were never fixed, so I submitted an iTAR, and therep tried his best to convince me that this is NOT how the namesctl isdesigned to work.Does anyone know with certinty that this could be the methood to get afresh tnsnames file on the client from the onames server in the eventyou do not want individual users to maintain their own tnsnames file?The workaround wast to have the logon server pull and distribute the tnsfrom the onames serverAnd the money we pay oracle!any ideasthanks!bobHello Jared I did not know that the client could call the "default" nameserver... from sqlnet.ora... pretty cool.However, there now seems to be some bugs (no..)It seems the namesctl ignores the arg to use a user defined path eg afile does *not* gets created in C:\tempBUT an *empty* tnsnames files does get created in the%oracle_home%\network\adminPROVIDING there is *not* an existing tnsnames there, if there is,namesctl simply creates a copy of the *existing* tnsnames with a .savextension!Ive tested this on my machine running 8.1.7.4 all our client/user pcshere are 8.17 0r 8.16Im running w2k pro on all our client machinesmaybe I discoverd a bug in Oracle! gthanks!bobexamplesnamesctl dump_tnsnames c:\temp\tnsnames.txt creates the above scenariothe outputC:\namesctl dump_tnsnames c:\temp\tnsnames.txtOracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Productionon 27-AUG-2003 11:31:39(c) Copyright 1997 Oracle Corporation. All rights reserved.Currently managing name server "NS_CPSDB2"Version banner is "Oracle Names for 32-bit Windows: Version 9.2.0.1.0 -Production"No need to do it quite the way you are attempting. c: namesctl dump_tnsnames c:\temp\tnsnames.txt worked fine for me. The default server is ns_ns1 Had I wanted to do this from another server, say ns2, I would have gone directly into namesctl, then issued the command 'set server ns_ns2' Jared "Bob Metelsky" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/26/2003 03:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L[EMAIL PROTECTED] cc: Subject:RE: Onames and various connections scenarios No doubt im in the wrong ball field here but this is what I haveWindows 2
RE: DBI in activestate perl
Title: Message do you know about ppm type ppm at the command line perl package manager http://aspn.activestate.com/ASPN/Downloads/ActivePerl/PPM/ http://perl.about.com/library/weekly/aa030500a.htm hth bob Does anybody know how and where to get DBI/DBD::Oracle for ActivePerl 5.8.0.806 ? Here is what is happenening to me: C:\tmpperl dbi.plCan't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at dbi.pl line 1.BEGIN failed--compilation aborted at dbi.pl line 1. Line 1 is, of course, "use DBI;". Does anybody have a solution? Do I get it if I buy the development kit? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: DBI in activestate perl
Title: Message sorry that shoud have been type atthe command prompt perl -MCPAN -e shell then one you walk through the setup you use ppm to install new packages -Original Message-From: Bob Metelsky Sent: Wednesday, September 03, 2003 11:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: DBI in activestate perl do you know about ppm type ppm at the command line perl package manager http://aspn.activestate.com/ASPN/Downloads/ActivePerl/PPM/ http://perl.about.com/library/weekly/aa030500a.htm hth bob Does anybody know how and where to get DBI/DBD::Oracle for ActivePerl 5.8.0.806 ? Here is what is happenening to me: C:\tmpperl dbi.plCan't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at dbi.pl line 1.BEGIN failed--compilation aborted at dbi.pl line 1. Line 1 is, of course, "use DBI;". Does anybody have a solution? Do I get it if I buy the development kit? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Some posts not showing up
I've noticed a few of my recent posts have not shown up. Is someone reading and discerning whether the post is suitable? I've newer seen this before but some of my posts make it and some do not. I don't see how my content would be objectionable Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Onames and various connections scenarios
This is a mesage that I sent on Friday, and to my knowledeg did not show up, (+ there were no responses) Im assuming if I can post... That I am in fact subscribed ;-) Hopefully this make it Thanks! bob ## Ok, so it was too good to be true the suggestion to run namesctl dump_tnsnames on the client and expecting a fresh copy of tnsnames to be installed (on the clients machine) is NOT supported. I searched on metalink, alot of people have the same problem a 0 byte tnsnames file being created using namesctl Alot of OLD bugs that were never fixed, so I submitted an iTAR, and the rep tried his best to convince me that this is NOT how the namesctl is designed to work. Does anyone know with certinty that this could be the methood to get a fresh tnsnames file on the client from the onames server in the event you do not want individual users to maintain their own tnsnames file? The workaround wast to have the logon server pull and distribute the tns from the onames server And the money we pay oracle! any ideas thanks! bob Hello Jared I did not know that the client could call the default name server... from sqlnet.ora... pretty cool. However, there now seems to be some bugs (no..) It seems the namesctl ignores the arg to use a user defined path eg a file does *not* gets created in C:\temp BUT an *empty* tnsnames files does get created in the %oracle_home%\network\admin PROVIDING there is *not* an existing tnsnames there, if there is, namesctl simply creates a copy of the *existing* tnsnames with a .sav extension ! Ive tested this on my machine running 8.1.7.4 all our client/user pcs here are 8.17 0r 8.16 Im running w2k pro on all our client machines maybe I discoverd a bug in Oracle! g thanks! bob examples namesctl dump_tnsnames c:\temp\tnsnames.txt creates the above scenario the output C:\namesctl dump_tnsnames c:\temp\tnsnames.txt Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production on 27-AUG-2003 11:31:39 (c) Copyright 1997 Oracle Corporation. All rights reserved. Currently managing name server NS_CPSDB2 Version banner is Oracle Names for 32-bit Windows: Version 9.2.0.1.0 - Production No need to do it quite the way you are attempting. c: namesctl dump_tnsnames c:\temp\tnsnames.txt worked fine for me. The default server is ns_ns1 Had I wanted to do this from another server, say ns2, I would have gone directly into namesctl, then issued the command 'set server ns_ns2' Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/26/2003 03:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Onames and various connections scenarios No doubt im in the wrong ball field here but this is what I have Windows 2k Server1 Ns1 on 8.1.7.4 Server2 Ns2 on 9.2.0.1.0 [server1] C:\ start \\server1\bin\namesctl dump_tnsnames C:\mytnsnames.txt It creates an empty file on my (remote) machine From the server C:\ namesctl dump_tnsnames C:\mytnsnames.txt it creats an empty C:\mytnsnames.txt [server2] C:\ start \\server2\bin\namesctl dump_tnsnames C:\mytnsnames.txt And it creates an empty file on my (remote) machine From the server itself it creats a full C:\mytnsnames.txt file with all the connect discriptors How is this supposed to be called? Thanks! Bob, I understand what you are saying (and your pain). My suggestion would be to use the 'namesctl dump_tnsnames' command to dump out the current Onames repository to the PC's $TNS_ADMIN dir via a login script or SMS. You might want o rename the current TNSNAMES.ORA file just prior to that as dump_tnsnames adds to the end of the current one and doesn't handle changes very well. Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent: Tuesday, August 26, 2003 6:44 AM To: Multiple recipients of list ORACLE-L Hello All Im back from the trenches to post a quick request for helpg Ive setup onames on 2 servers and standard applications, (our app and sqlplus) connect just fine, a problem situation manifests itself when: 1 users need to connect (add a database) to dba studio. They get a error to the effect cant resolve host name And the other 2. Users connect to remote databases (via vpn) that are in our onames but many of these vpn connections once made do not allow access to *our* network resources. So basically almost all
RE: Congratulations Arup (DBA of the Year)
alification. OK so when do we start?;-) kidding aside, this does sound like a good idea. an independent group of professionals. -- An independent array or redundant professionals ;-) Sorry I couldn't resist Have a good holiday all! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Onames and various connections scenarios
Title: Message Ok, so it was too good to be true the suggestion to run namesctl dump_tnsnames on the client and expecting a fresh copy of tnsnames to be installed (on the clients machine) is NOT supported. I searched on metalink, alot of people have the same problem " a 0 byte tnsnames file being created using namesctl" Alot of OLD bugs that were never fixed, so I submitted an iTAR, and the rep tried his best to convince me that this is NOT how the namesctl is designed to work. Does anyone know with certinty that this could be the methood to get a fresh tnsnames file on the client from the onames server in the event you do not want individual users to maintain their own tnsnames file? The workaround wast to have the logon server pull and distribute the tns from the onames server And the money we pay oracle! any ideas thanks! bob Hello Jared I did not know that the client could call the "default" name server... from sqlnet.ora... pretty cool. However, there now seems to be some bugs (no..) It seems the namesctl ignores the arg to use a user defined path ega file does *not* gets created in C:\temp BUT an *empty* tnsnames files does get created in the %oracle_home%\network\admin PROVIDING there is *not* an existing tnsnames there, if there is, namesctl simply creates a copy of the *existing* tnsnames with a .sav extension ! Ive tested this on my machine running 8.1.7.4 all our client/user pcs here are 8.17 0r 8.16 Im running w2k pro on all our client machines maybe I discoverd a bug in Oracle! g thanks! bob examples namesctl dump_tnsnames c:\temp\tnsnames.txt creates the above scenario the output C:\namesctl dump_tnsnames c:\temp\tnsnames.txt Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production on 27-AUG-2003 11:31:39 (c) Copyright 1997 Oracle Corporation. All rights reserved. Currently managing name server "NS_CPSDB2"Version banner is "Oracle Names for 32-bit Windows: Version 9.2.0.1.0 - Production" No need to do it quite the way you are attempting. c: namesctl dump_tnsnames c:\temp\tnsnames.txt worked fine for me. The default server is ns_ns1 Had I wanted to do this from another server, say ns2, I would have gone directly into namesctl, then issued the command 'set server ns_ns2' Jared "Bob Metelsky" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/26/2003 03:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Onames and various connections scenariosNo doubt im in the wrong ball field here but this is what I haveWindows 2kServer1 Ns1 on 8.1.7.4Server2 Ns2 on 9.2.0.1.0[server1]C:\ start \\server1\bin\namesctl dump_tnsnames C:\mytnsnames.txtIt creates an empty file on my (remote) machineFrom the server C:\ namesctl dump_tnsnames C:\mytnsnames.txt it creatsan empty C:\mytnsnames.txt[server2]C:\ start \\server2\bin\namesctl dump_tnsnames C:\mytnsnames.txtAnd it creates an empty file on my (remote) machineFrom the server itself it creats a full C:\mytnsnames.txt file with allthe connect discriptorsHow is this supposed to be called?Thanks! Bob, I understand what you are saying (and your pain). My suggestion would be to use the 'namesctl dump_tnsnames' command to dump out the current Onames repository to the PC's $TNS_ADMIN dir via a login script or SMS. You might want o rename the current TNSNAMES.ORA file just prior to that as dump_tnsnames adds to the end of the current one and doesn't handle changes very well. Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent: Tuesday, August 26, 2003 6:44 AM To: Multiple recipients of list ORACLE-L Hello All Im back from the trenches to post a quick request for helpg Ive setup onames on 2 servers and standard applications, (our app and sqlplus) connect just fine, a problem situation manifests itself when: 1 users need to connect (add a database) to dba studio. They get a error to the effect "cant resolve host name" And the other 2. Users connect to remote databases (via vpn) th
RE: Onames and various connections scenarios
Title: Message Hello Jared I did not know that the client could call the "default" name server... from sqlnet.ora... pretty cool. However, there now seems to be some bugs (no..) It seems the namesctl ignores the arg to use a user defined path ega file does *not* gets created in C:\temp BUT an *empty* tnsnames files does get created in the %oracle_home%\network\admin PROVIDING there is *not* an existing tnsnames there, if there is, namesctl simply creates a copy of the *existing* tnsnames with a .sav extension ! Ive tested this on my machine running 8.1.7.4 all our client/user pcs here are 8.17 0r 8.16 Im running w2k pro on all our client machines maybe I discoverd a bug in Oracle! g thanks! bob examples namesctl dump_tnsnames c:\temp\tnsnames.txt creates the above scenario the output C:\namesctl dump_tnsnames c:\temp\tnsnames.txt Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production on 27-AUG-2003 11:31:39 (c) Copyright 1997 Oracle Corporation. All rights reserved. Currently managing name server "NS_CPSDB2"Version banner is "Oracle Names for 32-bit Windows: Version 9.2.0.1.0 - Production" No need to do it quite the way you are attempting. c: namesctl dump_tnsnames c:\temp\tnsnames.txt worked fine for me. The default server is ns_ns1 Had I wanted to do this from another server, say ns2, I would have gone directly into namesctl, then issued the command 'set server ns_ns2' Jared "Bob Metelsky" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/26/2003 03:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Onames and various connections scenariosNo doubt im in the wrong ball field here but this is what I haveWindows 2kServer1 Ns1 on 8.1.7.4Server2 Ns2 on 9.2.0.1.0[server1]C:\ start \\server1\bin\namesctl dump_tnsnames C:\mytnsnames.txtIt creates an empty file on my (remote) machineFrom the server C:\ namesctl dump_tnsnames C:\mytnsnames.txt it creatsan empty C:\mytnsnames.txt[server2]C:\ start \\server2\bin\namesctl dump_tnsnames C:\mytnsnames.txtAnd it creates an empty file on my (remote) machineFrom the server itself it creats a full C:\mytnsnames.txt file with allthe connect discriptorsHow is this supposed to be called?Thanks! Bob, I understand what you are saying (and your pain). My suggestion would be to use the 'namesctl dump_tnsnames' command to dump out the current Onames repository to the PC's $TNS_ADMIN dir via a login script or SMS. You might want o rename the current TNSNAMES.ORA file just prior to that as dump_tnsnames adds to the end of the current one and doesn't handle changes very well. Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent: Tuesday, August 26, 2003 6:44 AM To: Multiple recipients of list ORACLE-L Hello All Im back from the trenches to post a quick request for helpg Ive setup onames on 2 servers and standard applications, (our app and sqlplus) connect just fine, a problem situation manifests itself when: 1 users need to connect (add a database) to dba studio. They get a error to the effect "cant resolve host name" And the other 2. Users connect to remote databases (via vpn) that are in our onames but many of these vpn connections once made do not allow access to *our* network resources. So basically almost all of oour users have one or more of these secenarios which means they will need to maintain a tnsnames file as well. I'm managing about 70+ connect discriptors And I was hoping onames could be a centralised answer Is this common? Or is there a workaround? Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
Onames and various connections scenarios
Hello All Im back from the trenches to post a quick request for helpg Ive setup onames on 2 servers and standard applications, (our app and sqlplus) connect just fine, a problem situation manifests itself when: 1 users need to connect (add a database) to dba studio. They get a error to the effect cant resolve host name And the other 2. Users connect to remote databases (via vpn) that are in our onames but many of these vpn connections once made do not allow access to *our* network resources. So basically almost all of oour users have one or more of these secenarios which means they will need to maintain a tnsnames file as well. I'm managing about 70+ connect discriptors And I was hoping onames could be a centralised answer Is this common? Or is there a workaround? Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Onames and various connections scenarios
No doubt im in the wrong ball field here but this is what I have Windows 2k Server1 Ns1 on 8.1.7.4 Server2 Ns2 on 9.2.0.1.0 [server1] C:\ start \\server1\bin\namesctl dump_tnsnames C:\mytnsnames.txt It creates an empty file on my (remote) machine From the server C:\ namesctl dump_tnsnames C:\mytnsnames.txt it creats an empty C:\mytnsnames.txt [server2] C:\ start \\server2\bin\namesctl dump_tnsnames C:\mytnsnames.txt And it creates an empty file on my (remote) machine From the server itself it creats a full C:\mytnsnames.txt file with all the connect discriptors How is this supposed to be called? Thanks! Bob, I understand what you are saying (and your pain). My suggestion would be to use the 'namesctl dump_tnsnames' command to dump out the current Onames repository to the PC's $TNS_ADMIN dir via a login script or SMS. You might want o rename the current TNSNAMES.ORA file just prior to that as dump_tnsnames adds to the end of the current one and doesn't handle changes very well. Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent: Tuesday, August 26, 2003 6:44 AM To: Multiple recipients of list ORACLE-L Hello All Im back from the trenches to post a quick request for helpg Ive setup onames on 2 servers and standard applications, (our app and sqlplus) connect just fine, a problem situation manifests itself when: 1 users need to connect (add a database) to dba studio. They get a error to the effect cant resolve host name And the other 2. Users connect to remote databases (via vpn) that are in our onames but many of these vpn connections once made do not allow access to *our* network resources. So basically almost all of oour users have one or more of these secenarios which means they will need to maintain a tnsnames file as well. I'm managing about 70+ connect discriptors And I was hoping onames could be a centralised answer Is this common? Or is there a workaround? Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Standby database ORA-16016
ORA-16016 archived log for thread string sequence# string unavailable Hello All I have a standby database oracle 8.1.7.4 on win2k running in managed recovery mode. NET8 have been transferring logs untill somehow the primary or standby server must have rebooted and I have now have sequence gaps. This doc seems to be everything you ever wanted to know about standby databses http://www.cs.rose-hulman.edu/docs/oracle-817/server.817/a76995/standbyc .htm#29765 But does not seem to address my problem. I would think... The primary database, would be sure to send *any* logs it has not sent. How can I be sure the primary sends all logs? Ive performed a log switch and the missing logs do not get sent. Does anyone have any suggestions to correct this? I would be very thankful. have a good weekend all! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Correct method of auto starting standby db
All, I have a question of how to auto start a standby database. IOW, it seems the logs are only applies if I issue the command Recover managed standby database; With thatcommand, the logs are applied, however, if I (or someone else) exits the cmd window the process stops So, how can I set this up to be automated? I need to keep the database in this state (I must be missing the obivious) Sqlplus /nolog Connect sys/*** as sysdba Startup mount; Alter databse mount standby database; Recover managed standby database; I used this doc as a base for my initSID.ora files and dosnt seem to mention the starting up on the db http://www.oracle-base.com/Articles/8i/StandbyDatabase.asp Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Imort Parameter File Question
# your comment goes here # another comment # Bla bla -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Correct method of auto starting standby db
Ok It looks like the disconnect is for 9i From metalink This recover command must be ended from a different session with recover managed standby database cancel. There is a timeout=n option to the recovery command which will cause recovery to end if a new archive log is not received in n minutes. For example, recover managed standby database timeout=10 will start the recovery command, but if there is a 10 minute wait between the arrival of any two archive logs, the command will end. You can execute the recover command in the background using the AT command with just a one time execution. For example if it's 8:00 AM use: at 8:05 sqlplus @file.sql. If you need further assistance with this, please post a new thread in the Microsoft Server Utilities forum. Oracle9i provides a 'disconnect' option when placing a database in managed recovery. This allows for managed recovery to run in the background. Looks like I have to schedule a job to run every hour with a time out of n min Thanks Bob All, I have a question of how to auto start a standby database. IOW, it seems the logs are only applies if I issue the command Recover managed standby database; With thatcommand, the logs are applied, however, if I (or someone else) exits the cmd window the process stops So, how can I set this up to be automated? I need to keep the database in this state (I must be missing the obivious) Sqlplus /nolog Connect sys/*** as sysdba Startup mount; Alter databse mount standby database; Recover managed standby database; I used this doc as a base for my initSID.ora files and dosnt seem to mention the starting up on the db http://www.oracle- base.com/Articles/8i/StandbyDatabase.asp Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Correct method of auto starting standby db
I *really* hope this isnt one of those dumb question (due to the limited responses) Or maybe Ive stumped our contestents today vb grin ;- Here is what I have based on Tanels suggestion --C:\oracle\ora817R3\bin\svrmgrl.exe command='@C:\oracle\admin\LOC\ADHOC\startstandby. [startstandby.sql] Sqlplus /nolog; Connect sys/[EMAIL PROTECTED] as sysdba; Startup nomount pfile=C:\oracle\admin\LOC\PFILE\initLOC.ora; Alter database mount standby database; Recover managed standby database disconnect; @ - Recover managed standby database disconnect; ORA-00274: illegal recovery option DISCONNECT http://www.ss64.com/ora/recover.html I will try to poke around on metalink Thanks! bob Hi! Try: recover managed standby database disconnect; This should spawn a separate process for recovering. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:54 PM All, I have a question of how to auto start a standby database. IOW, it seems the logs are only applies if I issue the command Recover managed standby database; With thatcommand, the logs are applied, however, if I (or someone else) exits the cmd window the process stops So, how can I set this up to be automated? I need to keep the database in this state (I must be missing the obivious) Sqlplus /nolog Connect sys/*** as sysdba Startup mount; Alter databse mount standby database; Recover managed standby database; I used this doc as a base for my initSID.ora files and dosnt seem to mention the starting up on the db http://www.oracle-base.com/Articles/8i/StandbyDatabase.asp Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone using onames on win2k server + 8.1.7 ?
I tried the whole process again this morning and got it to work, (after a couple of days playing with varios settings. Here is the summary of the tar. This was a clean install on w2k sp2 oracle 8.17 with patch/sets 1,2,3,4 applied Thanks to all who took the time to reply Bob ## ORACLE TAR SUMMARY 28-JUL-03 13:37:09 GMT New info : I fixed the problem. Basically I deleted the names.ora file and checkpoint files located in the names dir, then used net8 configuration tool to create a new names server using the machine name rather than ip address saved the configuration, then through the GUI restarted the service. I noticed the 3 checkpoint files were created.(as opposed to the chkpcfg.ora)not getting created on friday. Please see the basic config files below as well as the zip file I will upload. Summary, it seems that the config has to be done in a specific order and being consistent with the HOST= machine name oposed to one using machine name and the other using ip address. The machine has rebooted several times and the names server is working. Please find the attached zip files for the record. This problem seems solved although a little buggy. also be advised I applied patch sets 1,2,3,4 Thanks bob [names.ora] NAMES.SERVER_NAME = NS_CPS012 NAMES.ADDRESSES = (ADDRESS = (PROTOCOL = TCP)(HOST = cps012)(PORT = 1575)) [sqlnet.ora] SQLNET.EXPIRE_TIME = 10 SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (ONAMES,HOSTNAME) NAMES.REQUEST_RETRIES = 1 NAMES.INITIAL_RETRY_TIMEOUT = 2 NAMES.PREFERRED_SERVERS = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = cps012)(PORT = 1575)) ) [sample from ckpreg.ora] this was the file that was not getting populated with the connect descriptors, here we show 1 connection # Generation date: 28-JUL-2003 09:01:01 # Server version banner: Oracle Names for 32-bit Windows: Version 8.1.7.4.0 - Production # . = (DATA_LIST=(FLAGS=0x11) (DATA=(TYPE=ns.smd.)(NAME=NS_CPS012.) ) ) mydb. = (DATA_LIST=(FLAGS=0x1)(TTL=86400) (DATA=(TYPE=a.smd.)(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HO ST=hoat) (PORT=1526)))(CONNECT_DATA=(SID=TEST2))) ) ) [ckpcfg.ora] # Generation date: 28-JUL-2003 08:54:39 # Server version banner: Oracle Names for 32-bit Windows: Version 8.1.7.4.0 - Production # Region's ROS data store: # NAMES.SERVER_NAME = NS_CPS012 names.domains = (DOMAIN_LIST=(DOMAIN=(NAME=)(MIN_TTL=86400))) NAMES.ADDRESSES = (ADDRESS = (PROTOCOL = TCP)(HOST = cps012)(PORT = 1575)) Text continued in next action... 28-JUL-03 13:38:07 GMT Text continued from previous action... [ckpcch.ora] blank file # Generation date: 28-JUL-2003 08:54:39 # Server version banner: Oracle Names for 32-bit Windows: Version 8.1.7.4.0 - Production # -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: Anyone using onames on win2k server + 8.1.7 ? Our secondary ONAMES server used to be 8.1.7 on WinTuke, SP3 with the primary ONAMES being 8.0.5.0.1 under OpenVMS and the common repository Names DB 8.1.7. At the time, the secondary ONAMES server was my PC (one of those quick-and-dirty ideas that became production). I was also trying to get OEM 8.1.7 in the same ORACLE_HOME working properly with an intermittent lack of notification e-mail. I had decided to rebuild my Windohs install from scratch and upgrade to Oracle9iR2 as part of that. The secondary 9.2.0 ONAMES ran OK against the original 8.1.7 repository (minimum version required for ONAMES in 9i) and the original primary 8.0.5 ONAMES server without much of any issue until we migrated everything to Linux servers. Short story long, yes, we have had 8.1.7 ONAMES run OK on WinTuke. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Saturday, July 26, 2003 5:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone using onames on win2k server + 8.1.7 ? I used onames on 8.1.7 without a problem. It's the secondary server, but it always works. Jared On Friday 25 July 2003 12:54, Bob Metelsky wrote: All Ive gone round and round with a new install of 8.17 and getting names to work. Initially when a name server was greated and upi opend the NET8 config, it would crash Searching metalink provided the needed patches 1,2,3,4 Aplied all in sequence without errors Import large
Anyone using onames on win2k server + 8.1.7 ?
All Ive gone round and round with a new install of 8.17 and getting names to work. Initially when a name server was greated and upi opend the NET8 config, it would crash Searching metalink provided the needed patches 1,2,3,4 Aplied all in sequence without errors Import large tnsfile into names, save config and exit All the instances can be querried through the name server both locally (on the machine) and remotely However When the service restarts, or machine reboots all configuration is lost Searched metalnk and diddnt comeup with too much. I opned a TAR and was suggested to move to 9.x Well, Ive spent so much time on this and I need to maintain the 8.1.x version for this particullar server So, my question is anyone using onames on win2k server 8.1.7 My banner is as follows SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jul 25 13:37:17 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production With the Partitioning option JServer Release 8.1.7.4.1 - Production Input truncated to 14 characters [EMAIL PROTECTED] - Thanks and have a good weekend bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NNC-00425: meta-data violation -- need sanity check!
All Im setting up a name server on Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production On windows 2000 server Im doing eerything within the namesctl utility as typically I find the gui to be too buggy for my tastes. So I have the service running C:\ namesctl Currently managing name server NS_DB2 Version banner is Oracle Names for 32-bit Windows: Version 9.2.0.1.0 - Product ... My problem is the utility does not like the syntax of my large multi db version tnsnames file 60 dbs. So, I simplify the test and just use 1 entry running on the names server. Tnsnames.ora orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db2)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) When I do a load_tnsnames I get NAMESCTL load_tnsnames Name: orcl Response status: NNC-00425: meta-data violation No records loaded This is the default tnsnames! Ummm... sanity check please!! ;-) Here we have the error definitions whch arent really helpful http://storacle.princeton.edu:9001/oracle8-doc/server.805/a58312/net8nnc 1.htm So I turn to the water walkers on this list grin!! This has to be a bug. I was counting on pulling in the one 9.2 tns entry and then entering the other 60 by hand yecch!! Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Multiple addreses in tns
Is having multiple addresses valid for a tns entry? A client provided this to me and initailly looked invalid alias = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526)) ) (CONNECT_DATA = (SID = name)(SERVER = DEDICATED)) ) From initial testing, if the first server is not avaliable the entire connect fails. Personally Ive never seen this and from checking my reference, this does NOT seem to be valid Any input would be most welcome Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple addreses in tns
Thanks Rachael Getting some more feedback on this What this appears to be is a cluster configuration with a middle ware capability ( like Oracle FailSafe) to fail a database over from one node to its backup. This would be the reason each IP is configured with two ports. That sounds reasonable Although my docs souw mulitple ADDRESS_LIST = eg for parrallel or cluster server. However if I performd the simple test below, as is it- fails, if I place valid first, it connects. Which raised my concern of Oracle not going to the next address ?? locdb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = invalid)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = valid)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = locdb) ) ) it's valid. if there is no response on the first port, Oracle tries the next etc etc etc. It's a means of failover or allowing for continuity of connections while doing maintenance on a listener or server --- Bob Metelsky [EMAIL PROTECTED] wrote: Is having multiple addresses valid for a tns entry? A client provided this to me and initailly looked invalid alias = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526)) ) (CONNECT_DATA = (SID = name)(SERVER = DEDICATED)) ) From initial testing, if the first server is not avaliable the entire connect fails. Personally Ive never seen this and from checking my reference, this does NOT seem to be valid Any input would be most welcome Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple addreses in tns
I don't know, thats what Im trying to figgure out. Non the less the connection works, It looked weird to me (on the first impression) I suppose I could ask, I was just wondering if this was an easily identifiable entry Thanks bob Is he trying to do failover or load balancing? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Online tech books
Thanks Jonathan and Robert... Yes, Those book cases are wallmart specials I think the tall one was $25 and the small work modle was $15 or so. Hey, I even purchaced the work book case due to my distaste for justifying the cost of the purchace I figgured it was at least 100x easier to just buy my own bookcase for $15, then when I leave I can take it with me, to the next employer ... I can hear damagement now... hey Joe... This guy is serious.. He is bringing in his own bookcase Yes sad, but unfortunatly true. Just thinking about that... Im sure that's against some corporate policy ;-) In any event the book case(s) were cheaper than most books there. Lastly my favorite books are the Oracle SQL Plus by Jonathan I enjoyed how personally it was written as well as being clear and providing a lot of tips. Second favorite is the Oracle 8i DBA bible which I know some here dispute a chapter or two, nevertheless It's a very *direct* useful reference book One that is not as dry as most. Also like the 101 backup and recovery, very useful, with full example scenarios. Have a good 4th of July Holiday all! bob BM message) But, Ive taken some pictures of my collection.. Ive BM actually purchaced all the books you see! BM http://162.42.213.232/books/index.html Wow! Bob, I think you have me beat, and I'm no slouch when it comes to ordering books. Hey, you know what else, as I look very closely at your bookcases, I think you use the same cheap, partical-board-covered-with-paper, bendable-shelf brand that I usegrin. I better get on the stick and order more booksgrin. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: nt script
echo off @cls find ORA-124 C:\yourlog.txt NUL IF ERRORLEVEL 1 GOTO no IF NOT ERRORLEVEL 1 GOTO yes :no ECHO NOT FOUND goto end :yes ECHO String IS found pause goto end :end exit Hi listers, I am working on a nt script. I download FORFILE exe, it works fine. My intention is finding the ORA-03113 string in the log. If there is a match, then reboot the server, else do nothing. I don't have problem with the findstr part. However, the errorlevel always return 0, no matter it find the error or not. So the if statement is not working. Can somebody give me some light on NT syntax? On unix, it is so easy to script the condition. Please help, Thanks, Joan FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log -d+0 -cCMD /c type d:[EMAIL PROTECTED]|findstr ORA-03113 if errorlevel 1 goto run_proc echo 'there is a match' if errorlevel 0 goto end echo 'there is no match' :run_proc d:\start_proc.bat goto end :end -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: nt script
Don't run it line by line Save it to a file called myfind.bat Then call from a command prompt C:\ myfind.bat Or click the batch file, be sure to leave the pause so you can see an error if any. Once its working, you can then implemet blat as someone suggested Here is a version using variables ## [myfind.bat] :: Find example by BMetelsky on Friday-April-11-2003-9:22:53 AM :: This script searches thefile for a string and if it finds it, sends an email message to dbamail :: 0 =is found echo off set themess=A Database SERVICE on %computername% is NOT running on %date% at %time% set [EMAIL PROTECTED] set blatfile=D:\dbmon\blattext.txt set thefile=D:\dbmon\runit.log set subject=A DB SERVICE IS NOT RUNNING set [EMAIL PROTECTED] echo starting %blatfile% find ERROR: %thefile% NUL IF ERRORLEVEL 1 GOTO no IF NOT ERRORLEVEL 1 GOTO yes :no goto end :yes echo A db service is down on %computername%%blatfile% blat D:\dbmon\blattext.txt -subject %subject% -to %dbamail% -i %from% -body %themess% goto end :end @exit rem echo %errorlevel% ## Hi Bob, thanks for the reply. I added your code and tested still no good. I tested the case without a match. Still go to run. Joan D:\oracle\adminFORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log -d+0 -cCMD /c echo @FILE PSPRCSRV_PSNT_0630.log PSPRCSRV_PSNT_0701.log D:\oracle\adminecho on D:\oracle\adminFORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log -d+0 -cCMD /c type d:\pslog [EMAIL PROTECTED]|findstr ORA-03113 D:\oracle\admin\test.log D:\oracle\adminrem FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log -d+0 -cCMD /c type d:\p [EMAIL PROTECTED]|findstr ORA-03113 NUL D:\oracle\adminIF ERRORLEVEL 1 GOTO no D:\oracle\adminIF NOT ERRORLEVEL 1 GOTO RUN_PROC D:\oracle\adminrem d:\psfm\start_proc_sched.bat D:\oracle\adminecho run run D:\oracle\adminpause Press any key to continue . . . D:\oracle\admingoto end D:\oracle\adminecho finished finished D:\oracle\adminrem if errorlevel 1 @d:\psfm\start_proc_sched.bat Bob Metelsky wrote: echo off @cls find ORA-124 C:\yourlog.txt NUL IF ERRORLEVEL 1 GOTO no IF NOT ERRORLEVEL 1 GOTO yes :no ECHO NOT FOUND goto end :yes ECHO String IS found pause goto end :end exit Hi listers, I am working on a nt script. I download FORFILE exe, it works fine. My intention is finding the ORA-03113 string in the log. If there is a match, then reboot the server, else do nothing. I don't have problem with the findstr part. However, the errorlevel always return 0, no matter it find the error or not. So the if statement is not working. Can somebody give me some light on NT syntax? On unix, it is so easy to script the condition. Please help, Thanks, Joan FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log -d+0 -cCMD /c type d:[EMAIL PROTECTED]|findstr ORA-03113 if errorlevel 1 goto run_proc echo 'there is a match' if errorlevel 0 goto end echo 'there is no match' :run_proc d:\start_proc.bat goto end :end -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Online tech books
All.. I just returned frm vacation, but I wanted to respond to Jonathan Gennick regarding my collection of books.( I managed to delete that message) But, Ive taken some pictures of my collection.. Ive actually purchaced all the books you see! http://162.42.213.232/books/index.html I would just like all to know that my initial recommendation to view free books online was not an offer to circumvent actually purchacing the books. Personally I prefer to actually have a hard copy in my hand for a reference, on the other hand I though the online books may be handy and hopefully spur individuals to purchace books they otherwise may not be aware of, and possibly maybe for a struggling fellow who doesnt have a dime but has an interest to learn may pick up something worthwhile Ahhh back to work Best to all bob And, more than likely, highly illegal. I was assume the authors on list list will be contacting their respective publishers? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: Online tech books This was just passed on to me and I'd like to share it wit the list... http://www.palaydium.net/tech/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online tech books
No I have not read them all. Work seems to be getting in the way of my reading... Actually I use most of them on a as needed bases namely a reference. Keep in mind the original point wasnt whether I've read them all but merely my assertation that I purchace a lot of books (particullary Orielly...)! I would love nothing more than to read and apply the info in there... But as we all know life(my life) is comprised mainly of fires that need to be extinguished and I use the books as tools to help me accomplish that ;-) All the best (admitted technical book addict) bob Yes, Have you read all those books Have you really read all books you have in your bookcase??? JP On Monday 30 of June 2003 16:39, you wrote: All.. I just returned frm vacation, but I wanted to respond to Jonathan Gennick regarding my collection of books.( I managed to delete that message) But, Ive taken some pictures of my collection.. Ive actually purchaced all the books you see! http://162.42.213.232/books/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] Script to generate grant privilege on a table?
/[EMAIL PROTECTED]:\scripts\createinsert.sql drop user SOMEONE; create user SOMEONE identified by lgt5666 default tablespace tables temporary tablespace temp; grant connect to SOMEONE; */ spool D:\scripts\insertperm.sql select 'GRANT INSERT ON SCHEMA.'||'' || table_name ||' TO SOMEONE' ||';' from sys.all_tables where owner = 'SCHEMA'; select 'GRANT SELECT ON SCHEMA.'||'' || table_name ||' TO SOMEONE' ||';' from sys.all_tables where owner = 'SCHEMA'; select 'GRANT UPDATE ON SCHEMA.'||'' || table_name ||' TO SOMEONE' ||';' from sys.all_tables where owner = 'SCHEMA'; select 'GRANT DELETE ON SCHEMA.'||'' || table_name ||' TO SOMEONE' ||';' from sys.all_tables where owner = 'SCHEMA'; select 'GRANT EXECUTE ON SCHEMA.'||'' || object_name ||' TO SOMEONE' ||';' from all_objects where object_type = 'PACKAGE' and owner = 'SCHEMA' and object_name like 'SOMETHING%'; spool off; start D:\scripts\insertperm.sql -- exit ; Does anyone has script which can check grant privilege on a table and generate output for future usage? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Online tech books
This was just passed on to me and I'd like to share it wit the list... http://www.palaydium.net/tech/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL in the future?
As a suggestion I would simply download, read the doc and install. I had mysql installed and database built in about an hour. (not to oversimplify it) but the docs are very good and will have you running in no time. Your coming from an oracle background so architecturally/(instinctually), it should be a piece of cake Just go for it! http://www.mysql.com/ My 2cts bob What is the best source / books to learn mysql quickest possible without too much cost to an individual? I am asking this because in my recent job search I found couple of good companies are also using mysql. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Online tech books
Wednesday, June 18, 2003, 12:34:19 PM, Jesse wrote: JR And, more than likely, highly illegal. I was assume the authors on JR list list will be contacting their respective publishers? My thanks to Rachel for pointing this out to me, else I'd have missed it. It turns out that O'Reilly, at least, is already after these guys. Jesse is absolutely correct. Palaydium has no right to post all those books online. Best regards, My sincerest apologies My intention was definetly not to circumvent purchaces of books. Especially the authors on this list... I for one have purchaced 80% of the O'Reillys Oracles books and have here at my desk close to 2K$ of books that I personally purchaced. Again my humble apologies bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: recreating a create database file
NEXT 128K OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 32); CREATE ROLLBACK SEGMENT RS_01B TABLESPACE ROLLBACK_SEGS STORAGE( INITIAL 128K NEXT128K OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 32); CREATE ROLLBACK SEGMENT RS_02A TABLESPACE ROLLBACK_SEGS STORAGE( INITIAL 128K NEXT128K OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 32); CREATE ROLLBACK SEGMENT RS_02B TABLESPACE ROLLBACK_SEGS STORAGE( INITIAL 128K NEXT128K OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 32); CREATE ROLLBACK SEGMENT RS_03A TABLESPACE ROLLBACK_SEGS STORAGE( INITIAL 128K NEXT128K OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 32); CREATE ROLLBACK SEGMENT RS_03B TABLESPACE ROLLBACK_SEGS STORAGE( INITIAL 128K NEXT128K OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 32); CREATE ROLLBACK SEGMENT RS_04A TABLESPACE ROLLBACK_SEGS STORAGE( INITIAL 128K NEXT128K OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 32); CREATE ROLLBACK SEGMENT RS_04B TABLESPACE ROLLBACK_SEGS STORAGE( INITIAL 128K NEXT128K OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 32); CREATE ROLLBACK SEGMENT RS_LRG TABLESPACE ROLLBACK_SEGS STORAGE( INITIAL 10M NEXT10M OPTIMAL 20M MINEXTENTS 2 MAXEXTENTS 32); ALTER ROLLBACK SEGMENT RS_01A ONLINE; ALTER ROLLBACK SEGMENT RS_01B ONLINE; ALTER ROLLBACK SEGMENT RS_02A ONLINE; ALTER ROLLBACK SEGMENT RS_02B ONLINE; ALTER ROLLBACK SEGMENT RS_03A ONLINE; ALTER ROLLBACK SEGMENT RS_03B ONLINE; ALTER ROLLBACK SEGMENT RS_04A ONLINE; ALTER ROLLBACK SEGMENT RS_04B ONLINE; ALTER ROLLBACK SEGMENT RS_LRG ONLINE; spool off -- Create catalog area spool DB_DESTINATION\admin\INSTANCE\create\CreateDBCatalog.log set echo on alter user sys temporary tablespace TEMP; @ORACLE_HOME\rdbms\admin\catalog.sql; @ORACLE_HOME\rdbms\admin\catexp7.sql; @ORACLE_HOME\rdbms\admin\catblock.sql; @ORACLE_HOME\rdbms\admin\catproc.sql; @ORACLE_HOME\rdbms\admin\catoctk.sql; @ORACLE_HOME\rdbms\admin\owminst.plb; connect SYSTEM/PASSWORD @ORACLE_HOME\sqlplus\admin\pupbld.sql; spool off connect SYSTEM/PASSWORD set echo on spool DB_DESTINATION\admin\INSTANCE\create\sqlPlusHelp.log @ORACLE_HOME\sqlplus\admin\help\hlpbld.sql helpus.sql; spool off -- post db build spool DB_DESTINATION\admin\INSTANCE\create\postDBCreation.log connect SYS/PASSWORD as SYSDBA @ORACLE_HOME\rdbms\admin\utlrp.sql; shutdown ; startup mount pfile=DB_DESTINATION\admin\INSTANCE\pfile\initINSTANCE.ora; alter database archivelog; alter database open; alter system archive log start; shutdown ; connect SYS/PASSWORD as SYSDBA set echo on spool DB_DESTINATION\admin\INSTANCE\create\postDBCreation.log create spfile='ORACLE_HOME\database\spfileINSTANCE.ora' FROM pfile='DB_DESTINATION\admin\INSTANCE\pfile\initINSTANCE.ora'; spool off prompt If there arent any errors press a key to continue, this will take you to the batch job check the logs... pause Exit Hth bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT Googles cluster architecture
This is off topic as far as oracle goes, however we are all interested in storing and querying data. Here is a pdf on how Google is doing it. Apparently they are using 15000 comodity class pcs in cluster architecture. It dosnt look like they are using Oracle, but seems to be a file based system.(index.shards) Pretty interesting stuff. Have a good weekend all! http://www.computer.org/micro/mi2003/m2022.pdf Amenable to extensive parallelization, google's web search application lets different queries run on different processors and, by partitioning the overall index, also lets a single query use multiple processors. to handle this workload, google's architecture features clusters of more than 15,000 commodity-class pcs with fault-tolerant software. this architecture achieves superior performance at a fraction of the cost of a system built from fewer, but more expensive, high-end servers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Loader Concatenate date and time
All Im need to concatenate my log_date and log_time field (the 2 physical records into one logical record). I can find how to do it with a fixed length file but my case is a delimited file. Looking at the docs, it seems the continueif is used for delimited dtaa, I cant seem to get the syntax to work any ideas would be welcome ;-) thanks! Bob LOAD DATA INFILE 'F:\528log.txt' BADFILE 'F:\bad.txt' truncate INTO TABLE log FIELDS TERMINATED BY WHITESPACE OPTIONALLY enclosed by '' TRAILING( log_id INTEGER, log_date DATE 'DD-MON-', log_time char, vpn_type char, interface char, name char, type char, action char, service char, source char, destination char, protocol char, port char, service2 char, log_user char, message char) example source row data 283700 28May2003 16:28:12 fff eth-sfp1c0 fff Log Accept nbdatagram 10.54.4.1 10.54.255.255 udp 23 nbdatagram Example oracle row data 283700 05/28/2003 00:00:00 16:28:12fff eth-s4fp1c0 fff Log Accept nbdatagram 10.54.4.1 10.54.255.255 udp 23 nbdatagram -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Loader Concatenate date and time
Hi Jonathan Thanks for answering my question. I diddnt realise you could querry colums ahead of the current line. Ive applied functions (in a ctl file) to the current column, but diddnt realise I could || the next column My working ctl file Thanks again bob LOAD DATA INFILE 'F:\11NETSHARE\528fwlog.txt' BADFILE 'F:\11NETSHARE\mybad.txt' append INTO TABLE fw_log FIELDS TERMINATED BY WHITESPACE OPTIONALLY enclosed by '' TRAILING( id SEQUENCE(MAX,1), log_id char, log_date char TO_DATE(:log_date || ' ' || :log_time,'ddMon hh24:mi:ss'), log_time CHAR, vpn_type char, interface char, name char, type char, action char, service char, source char, destination char, protocol char, port char, service2 char, log_user char, message char, create_date sysdate) Hello Bob, My first thought is to try something like: ... log_date CHAR TO_DATE(:log_date || ' ' || :log_time,'ddMon hh:mi:ss', log_time FILLER char, ... I may not have the syntax just right, and I can't take time to test it until later this evening (shouldn't be reading ORACLE-L now anywaygrin), but I'm fairly certain this approach can be made to work. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Thursday, May 29, 2003, 11:54:44 AM, you wrote: BM All BM Im need to concatenate my log_date and log_time field (the BM 2 physical records into one logical record). I can find how to do BM it with a fixed length file but my case is a delimited file. Looking BM at the docs, it seems the continueif is used for delimited dtaa, I BM cant seem to get the syntax to work BM any ideas would be welcome ;-) BM thanks! BM Bob BM LOAD DATA BM INFILE 'F:\528log.txt' BM BADFILE 'F:\bad.txt' BM truncate BM INTO TABLE log BM FIELDS TERMINATED BY WHITESPACE OPTIONALLY enclosed by '' BM TRAILING( BM log_id INTEGER, BM log_date DATE 'DD-MON-', BM log_time char, BM vpn_type char, BM interface char, BM name char, BM type char, BM action char, BM service char, BM source char, BM destination char, BM protocol char, BM port char, BM service2 char, BM log_user char, BM message char) BM example source row data BM 283700 28May2003 16:28:12 fff eth-sfp1c0 fff Log BM Accept nbdatagram 10.54.4.1 10.54.255.255 udp 23 BM nbdatagram BM Example oracle row data BM 283700 05/28/2003 00:00:00 16:28:12fff eth-s4fp1c0 BM fff Log Accept nbdatagram 10.54.4.1 10.54.255.255 BM udp 23 nbdatagram BM -- BM Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help with a dynamic query
SELECT 'CREATE TABLE TMP_'||table_name||' TABLESPACE tables AS '||chr(10)|| 'SELECT * FROM '||table_name||';' from sys.all_tables where owner = 'yourowner'; Or add a @dblink bob This probably isnt that hard, but Im having a brain dead moment. My goal is to select data from a table in one schema and insert it into the same table in another schema. However, I am not 100% certain that the tables exist in both schemas or that the columns are the same. The columns can be different if I have all the data needed to columns in my target schema that are set to 'NOT NULL'. Im trying to write a little TABLE_CHECK function to check these. Im having problems with the SQL. Its going to be dynamic and we have a few thousand tables between all the schemas so the faster the better I apologize for the bad parsing. Im sending this from work over the web and it doesnt parse well so the code will be a bit messy FUNCTION tableCheck(p_tableNameIN VARCHAR2, p_sourceSchema IN VARCHAR2, p_targetSchema IN VARCHAR2) RETURN VARCHAR2 IS TYPE REF_TYPE IS REF CURSOR; cur_colName REF_TYPE; CURSUR cur_colName IS SELECT COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE TABLE_NAME = p_tableName; v_colName DBA_TAB_COLUMNS.COLUMN_NAME%TYPE; v_nullDBA_TAB_COLUMNS.NULLABLE%TYPE; v_owner DBA_TAB_COLUMNS.OWNER%TYPE; BEGIN OPEN cur_colName FOR ' SELECT COLUMN_NAME, OWNER, NULLABLE ' FROM DBA_TAB_COLUMNS t, DBA_TAB_COLUMNS t1'|| ' WHERE t.TABLE_NAME = :1 '|| ' AND t1.TABLE_NAME = t.TABLE_NAME ' AND t.OWNER = USING p_tableName, p_sourceSchema, p_targetSchema; LOOP FETCH cur_colname INTO v_colName, v_null; EXIT WHEN cur_colName%NOTFOUND; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is the sql stored for a stored procedure?
Thanks for all the replies... A summary {user|all|dba}_source LOCDB SQL desc dba_source; Name --- OWNER NAME TYPE LINE TEXT LOCDB SQL select distinct type from dba_source ; TYPE FUNCTION PACKAGE PACKAGE BODY PROCEDURE TYPE SELECT TEXT FROM DBA_SOURCE WHERE NAME = 'object_name' bob Im mucking about in the user_ views... Im seeing dba_objects type = 'procedure'; but need to find the sql Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
Title: Message Can you start the service via oradim? CMD oradim C:\oradim -STARTUP -SID -USRPWD -STARTTYPE srvc,inst -PFILE C:\your_path\ can you start the db via svrmgrl? CMDset oracle_sid=mysid svrmgrl connect internal/* startup pfile=. have you tried rebooting and logging on as the administrator? here are known bugs on w2k and autosatarting 136214.1 Oracle8i Startup, Shutdown Related Registry Entries on WindowsNT Windows2000 135375.1 Database Autostart Fails Even When OracleServiceSID is Started Automatic 1022458.6 AUTOSTART OF INSTANCE AT OS BOOT TIME IS NOT WORKING 62006.1 Troubleshooting Tips Database Not Autostarting the one that fixed my problem (thanks Jared) was Patch 1522966 This patch is very easy to apply and replaces the orannts8.dll see the read me for that patch hth bob Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: "Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator." I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
Title: Message Lisa Sorry, I misread your message, I had theimpression the db would notstart... not that the listener would not start. Is it possible you/someone installed oracle that was not an administrator, at the time of install. Sounds like a permissions problem. possible solution to uninstall/ clean the registry (remove all referenced to oracle in the registry with the exceptions of legacy apps) and reinstall as administrator have you tried running other services ? like lsnrctl? Im running Windows 2000 sp3, ver 8.1.7.2 here without any issue at all (other than the autostart patch problem I posted earlier patch 1522966) bob Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: "Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator." I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Where is the sql stored for a stored procedure?
Im mucking about in the user_ views... Im seeing dba_objects type = 'procedure'; but need to find the sql Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Schema specific grants
Good Morning All Im looking at trying to grant privilidges to a guest user (who does not own the tables) I know I can do it for individual tables Eg GRANT INSERT ANY SCHEMA_NAME.TABLE_NAME TO Guest; but I need to grant to an entrie schema Like GRANT INSERT ANY SCHEMA_NAME.* TO Guest; Anyone have the syntax for that? Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Schema specific grants
Thnaks for the response. I realised that immediately after I posted. This is what Ive done /*@D:\createinsert.sql drop user Guest; create user Guest identified by * default tablespace tables temporary tablespace temp; grant connect to Guest; */ set echo off set feedback off set pages 0 set heading off set lines 80 set verify off Spool D:\insertperm.sql select 'GRANT INSERT ON SCHEMA_NAME.'||'' || table_name ||' TO Guest' ||';' from sys.all_tables where owner = 'SCHEMA_NAME'; select 'GRANT SELECT ON SCHEMA_NAME.'||'' || table_name ||' TO Guest' ||';' from sys.all_tables where owner = 'SCHEMA_NAME'; select 'GRANT UPDATE ON SCHEMA_NAME.'||'' || table_name ||' TO Guest' ||';' from sys.all_tables where owner = 'SCHEMA_NAME'; select 'GRANT DELETE ON SCHEMA_NAME.'||'' || table_name ||' TO Guest' ||';' from sys.all_tables where owner = 'SCHEMA_NAME'; select 'GRANT EXECUTE ON SCHEMA_NAME.'||'' || object_name ||' TO Guest' ||';' from all_objects where object_type = 'PACKAGE' and owner = 'SCHEMA_NAME' and object_name like 'CPS%'; spool off; start D:\insertperm.sql -- exit ; I was hoping for a syntax parameter but this works as well Thanks Bob Bob, the best thing I can offer is the following: set lines 150 set pages 2000 set trimspool on select 'grant insert on ' || table_name || ' to Guest_Role;' from user_tables / Create the role named in the script (or change the role name to the actual Oracle username) and grant the role to the user. Run it from the schema where the tables exist. Spool the output to a .sql file and run the resulting file back thru sqlplus. You may also want to create either public or private synonyms for the user to make their life a little easier. I like Roles better than assigning stuff directly to the user - just easier to manage. good luck! Tom Mercadante Oracle Certified Professional -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Subject: Schema specific grants Good Morning All Im looking at trying to grant privilidges to a guest user (who does not own the tables) I know I can do it for individual tables Eg GRANT INSERT ANY SCHEMA_NAME.TABLE_NAME TO Guest; but I need to grant to an entrie schema Like GRANT INSERT ANY SCHEMA_NAME.* TO Guest; Anyone have the syntax for that? Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Looking for simple monitor script dbup.bat
Good morning everyone Win2k pro, oracle 8.17 Ive been investigating a simple monitor script which will email me if the database is not available. I need this to be as simple as possible (ideally a batch file) Ive come across this on orafaq http://www.orafaq.net/scripts/win/isdbup.txt But dosnt seem to work. If you pass an incorrect sid, or file parameters the script just hangs I have a modified version ## Rem dbup.bat @echo off set ORACLE_SID=locdb sqlplus internal/pw@%ORACLE_SID% @C:\conn.sql if {%ERRORLEVEL%} == {0} ( echo Database %ORACLE_SID% is available ) else ( echo Database %ORACLE_SID% is NOT available ) ## [conn.sql] set echo off feed off pages 0 -- whenever sqlerror exit sql.sqlcode WHENEVER SQLERROR EXIT 1 select * from global_name; exit ; ## Although this works (gets into the error level) AFTER you hit enter to walk throough the errors The script gets stuck on Errors Such as If the db is down ERROR: ORA-01034: ORACLE not available Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied Or if I pass and invalid sid, (I can live with only passing valid sids) but how can I get sql+ to exit out of the error if in fact the db is not up I think Ive tried all variations of SQLERROR http://lina.cli.di.unipi.it:8000/WG73-doc/sqlplus/sp33/ch646.html Any ideas for the gurus??? Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Examples of dbms_job.submit intervals and arguments
Yes, thanks that's helpful but Here is a job, Im trying to simply call some sql but apparently I cant pass sql as an argument. Or my string variables in the sql are double single quotes?? Im not sure if they should be double single quotes or just double quotes Should this work?? It submits fine but if I execute it I get the following LOCDB SQL execute dbms_job.run(71); BEGIN dbms_job.run(71); END; * ERROR at line 1: ORA-12011: execution of 1 jobs failed ORA-06512: at SYS.DBMS_IJOB, line 394 ORA-06512: at SYS.DBMS_JOB, line 267 ORA-06512: at line 1 # variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit (:jobno, 'UPDATE TIME SET STATUS = ''O'' WHERE STATUS = ''I'' ;', trunc(sysdate+1), 'trunc(SYSDATE+1)', TRUE, :instno); commit; end; Also, Im not sure how to create a simple stored procedure wich simply contains the above sql. Any help would be graciously accepted... Thanks Bob Bob, Try Tom Kyte's web site: http://asktop.oracle.com. Search for dbms_job. There are some good examples. - Kirti -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wed 1/29/2003 4:44 PM To: Multiple recipients of list ORACLE-L Cc: Subject: Examples of dbms_job.submit intervals and arguments All I need to get a better understanding of the arguments to dbms_job.submit particulay the interval although all parameters would not hurt. Ive searched online and at tahiti but I couldn't really find good examples of usage Can someone point me in the right direction? Or provide examples..? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Creating a simple stored procedure
How can I create this simple stored procedure Obiviously I don't have much experience but I would not think this being as difficult as it appears I want to run an update on a table (eventually from a job) I just need to get the sp working... Any examples Ive seen are much too complex for this simple task CREATE OR REPLACE PROCEDURE XYZ AS BEGIN UPDATE myTab SET STATUS = 'a' WHERE STATUS = 'b' ; END XYZ; This is telling me I need to declare myTab... Ive tried every iteration of declaring... But its not happening So, I present my delimma to my knowledgable friends @fatcity! {about to go insane} bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating a simple stored procedure
Bob, where does the table mytab exist? - probably not in the same account as where you are creating the sp. in this case, you need to do two things. change the sp to say: update {schema}.mytab where {schema} is where the table exists. secondly, from {schema} you need to : grant select, insert, update, delete on mytab to {user} where {user} is where the sp exists. good luck! Tom Mercadante Oracle Certified Professional Tom, thanks for the reply (and thanks to everyone else as well) The problem was that I was not prefexing the table_name with the owner. The table did exist in the account I was logged in under but I had to add the owner for the procedure to reconise it. I had the necessary permissions in place I was logged on as the owner of the owner of the tables... I should have known to prefix with the table_name (I actually thought I tried that) So this works: create or replace procedure closeActivity AS BEGIN UPDATE OWNER.TABLE_NAME SET STATUS='O' WHERE STATUS='I' ; commit; END; / Then set this in a job: variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'OWNER.closeActivity;', trunc(sysdate+1), 'trunc(SYSDATE+1)', TRUE, :instno); commit; end; / I was getting extremely frustrated . Thanks for the clairity bob -Original Message- Sent: Thursday, January 30, 2003 10:31 AM To: Multiple recipients of list ORACLE-L How can I create this simple stored procedure Obiviously I don't have much experience but I would not think this being as difficult as it appears I want to run an update on a table (eventually from a job) I just need to get the sp working... Any examples Ive seen are much too complex for this simple task CREATE OR REPLACE PROCEDURE XYZ AS BEGIN UPDATE myTab SET STATUS = 'a' WHERE STATUS = 'b' ; END XYZ; This is telling me I need to declare myTab... Ive tried every iteration of declaring... But its not happening So, I present my delimma to my knowledgable friends @fatcity! {about to go insane} bob -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Examples of dbms_job.submit intervals and arguments
All I need to get a better understanding of the arguments to dbms_job.submit particulay the interval although all parameters would not hurt. Ive searched online and at tahiti but I couldn't really find good examples of usage Can someone point me in the right direction? Or provide examples..? Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Statspack recomendations.
Don Burleson has a book called Oracle9i High-Performance Tuning with STATSPACK. Check out the link below. http://www.dba-oracle.com/books.htm Dave Unfortunatly the ordering feature dosnt work on that site. IE 6 or Mozilla 1.2.1 I was interested in Conducting the Oracle Job Interview bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dictionary location or initSID.ora and PWDsid.ora
Can I dynamicall find the location of initSID.ora Eg C:\admin\INSTANCE\PFILE\initSID.ora and the password dir E.g C:\Oracle\Ora81\DATABASE\*.ora Im setting up a cold backup script and would like to include these 2 dir Im poking around in the v$ tables but cant seem to find it Id like to avoid hardcoding the values Thanks!! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Statspack recomendations.
Go to bookpool.com. Best prices on tech books. I've ordered several books from them and have always been happy. Yes definetly... But this one Conducting the Oracle Job Interview Is not available at bookpool or amazon... (personally I like the buy used books from amazon) quite a few deals there Ive always been reasonably pleased with the service as well. Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Global names
The way I understood Gloal names is a global name will have a .someserver.com AFAIK... Global names is set/required IF you have your sqlnet.ora with a line for GLOBAL_NAMES =.someserver.com Then you can seperatly identify your instances from the different servers they are running on Sqlplus [EMAIL PROTECTED] or Sqlplus [EMAIL PROTECTED] In the tns entries below I just use an alias how eer this wont work with a dblink, then you need to set the parameter in initSID.ora [example of 2 of the same SIDs different servers] LOCDB1= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.54.100.231)(PORT = 1521)) ) (CONNECT_DATA = (SID = LOCDB)(SRVR=SHARED)) ) LOCDB2= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.54.100.232)(PORT = 1521)) ) (CONNECT_DATA = (SID = LOCDB)(SRVR=SHARED)) ) The problem is if your like me and would like to know what db your on (while in SQL+) You would add a setting to glogin -- set db prompt set termout off col x new_value y select rtrim(name,chr(0)) x from v$database; set sqlprompt 'y SQL ' set termout on The problem is you still see the SID not the alias or global name.someserver.com Its much easier for SOME dba's to use the same SID but As the first fellow pointed out it can have its drawbacks/devistating effects The global_name in initSID.ora, afaik is for creating dblinks with the same or different names For ease of use I prefer false, but none the less that is going away My 2cts bob It recently came to my attention that the DBA's where I work have adopted a convention where the global_name of a database is the same for the production, test, and development instance of that database (obviously, they've turned off global naming in the init.ora). They've also set up the Oracle has stated for some time that global_names=true will be required in future versions of Oracle, and recommend that that be done now. Which obviously won't work if you have databases with the same global name. I personally have global_names=false, though our databases all have different global names. Having databases with the same global name is rather confusing. I can't say I've really thought through the ramifications other than that. Our DBA argues that this configuration is strongly preferred by the majority of developers since they don't have to make any changes to their code when they move from development to QA and to test. Junior developers? If the changing the database name requires code changes, then the duhvelopers need some remedial education. my $0.02 Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Auto start failing AGAIN... shared realm does not exist....
You're the man Jared! The doc you referred me to 136214.1, referered to a patch 1522966 which basically has you Stop all services/instances Rename %Oracle_Home%\bin\orannts8.dll to orannts8.dll.bad Then copy over the new orannts8.dll that's provided in the patch Reboot All my instances are auto starting! Many thanks bob Also take a look at Doc # 136214.1 on MetaLink. Jared On Monday 20 January 2003 13:46, Bob Metelsky wrote: My scenario Fresh install of w2k server, sp 3 high end machine, twin 2G processers 4G ram ... Installed Oracle 8.17 release 3, Install went perfectly smooth built 9 databases connected and imported all data I could connect at will ... All was well The problem: when the machine reboots, the service and database does not start automatically.If I try to sqlplus user/pass@instance I get the Oracle not available, shared realm does not exist (in other words the dbs did not start) I can start manually using startdb.bat svrmgrl.exe command='@C:\db_startup\initdb8i.sql' initdb8i.sql connect internal/pass@db8i startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora exit The instance starts and all is well Ive deleted all the services using Oradim and rebooted, then recreated using rem D:\install\setODIM.bat set db=someinstance sleep 1 ORADIM -DELETE -SID %db% sleep 2 ORADIM -NEW -SID %db% -INTPWD passwd -STARTMODE auto -PFILE D:\OraHome1\admin\%db%\PFILE\init%db%.ora -TIMEOUT 90 sleep 2 ORADIM -SHUTDOWN -SID %db% -USRPWD passwd -SHUTTYPE srvc,inst -SHUTMODE i sleep 2 ORADIM -STARTUP -SID %db% -USRPWD passwd -STARTTYPE srvc,inst -PFILE D:\OraHome1\admin\%db%\PFILE\init%db%.ora echo off echo. echo Done creating oradim entries for %db% ! If I create one service, using the above batch file I can connect to the database, eg ORADIM -STARTUP -SID %db% -USRPWD passwd -STARTTYPE srvc,inst -PFILE D:\OraHome1\admin\%db%\PFILE\init%db%.ora but when the machine reboots and I try to connect I get the oracle not available here are my registry settings http://209.123.6.84/srvreg.jpg This is very frustrating as I had this problem on a server that had the OS upgraded and I could never get the autostart working correctly This is a new machine and I can reboot at will or make any changes (no one is using this server yet) so I really need to get this working. I am at a loss... any suggestions would be appreciated thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Auto start failing AGAIN... shared realm does not exist....
My scenario Fresh install of w2k server, sp 3 high end machine, twin 2G processers 4G ram ... Installed Oracle 8.17 release 3, Install went perfectly smooth built 9 databases connected and imported all data I could connect at will ... All was well The problem: when the machine reboots, the service and database does not start automatically.If I try to sqlplus user/pass@instance I get the Oracle not available, shared realm does not exist (in other words the dbs did not start) I can start manually using startdb.bat svrmgrl.exe command='@C:\db_startup\initdb8i.sql' initdb8i.sql connect internal/pass@db8i startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora exit The instance starts and all is well Ive deleted all the services using Oradim and rebooted, then recreated using rem D:\install\setODIM.bat set db=someinstance sleep 1 ORADIM -DELETE -SID %db% sleep 2 ORADIM -NEW -SID %db% -INTPWD passwd -STARTMODE auto -PFILE D:\OraHome1\admin\%db%\PFILE\init%db%.ora -TIMEOUT 90 sleep 2 ORADIM -SHUTDOWN -SID %db% -USRPWD passwd -SHUTTYPE srvc,inst -SHUTMODE i sleep 2 ORADIM -STARTUP -SID %db% -USRPWD passwd -STARTTYPE srvc,inst -PFILE D:\OraHome1\admin\%db%\PFILE\init%db%.ora echo off echo. echo Done creating oradim entries for %db% ! If I create one service, using the above batch file I can connect to the database, eg ORADIM -STARTUP -SID %db% -USRPWD passwd -STARTTYPE srvc,inst -PFILE D:\OraHome1\admin\%db%\PFILE\init%db%.ora but when the machine reboots and I try to connect I get the oracle not available here are my registry settings http://209.123.6.84/srvreg.jpg This is very frustrating as I had this problem on a server that had the OS upgraded and I could never get the autostart working correctly This is a new machine and I can reboot at will or make any changes (no one is using this server yet) so I really need to get this working. I am at a loss... any suggestions would be appreciated thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
XML functonality in Oracle XML Developer Kit
Good afternoon all Im interested in using xml to hide sql querries on web applications (and storing xml querries) in the db A cursorary search http://www.dbspecialists.com/presentations/xml_and_oracle.html Shows me that in fact XML can work well however Im interested in feedback from anyone who has installed or used the The XML Developer Kit and if so how it worked how much trouble was it to set up... In other words does it actually work and is it being used Any worthwhile docs/links would be appreciated Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT Recommended reading...
I recall that people were looking for UNIX/DBA admin books, I did a search and came across some interesting reading Have a look, This is a riot! http://carcino.gen.nz/images/index.php/54de433e/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cant install statspack !
Hello All I seem to be missing something very basic as no matter what I do I cant get statspack to install This is 8.16 on WIN2kpro I downloaded the newest version of stataspack and placed it into %oracle_home%\rdbms\admin C:\Oracle\Ora81\RDBMS\ADMINdir stats* 02/08/2000 07:36p 1,805 statsauto.sql 02/08/2000 07:36p 891 statscauto.sql 12/30/1999 02:13p 1,832 statscbps.sql 02/08/2000 07:36p 882 statscre.sql 02/08/2000 07:36p 28,088 statsctab.sql 02/08/2000 07:36p 27,879 statsctaba.sql 02/08/2000 07:36p 5,098 statscusr.sql 02/08/2000 07:36p 4,384 statscusra.sql 02/08/2000 07:36p 829 statsdrp.sql 02/08/2000 07:36p 3,344 statsdtab.sql 02/08/2000 07:36p 1,136 statsdusr.sql 02/08/2000 07:34p 28,516 statspack.doc 02/08/2000 07:36p 51,400 statspack.sql 02/08/2000 07:36p 48,205 statsrep.sql 01/19/2000 06:53p 52,610 statsrep80.sql 02/08/2000 07:36p 579 statsuexp.par 16 File(s)257,478 bytes I log onto the db sqlplusw internal/pw@instance SQL@%oracle_home%\rdbms\admin\statscre.sql the script seems to create the user.. but then blinks out. Apparently its soupposed to generate .lis files but there are no such files I tried to spool a log file but It only captures the first line... as the script blinks out if I try to SQL execute statspack.snap I get PLS-00201: identifier 'STATSPACK.SNAP' must be declared I try to prefix it with perfstat. or sys. but no joy what can I be doing wrong?? Ive tried to hack the scripts(so they would stay up) but there are so many variables that it dosnt seem practical Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cant install statspack !
HOT DAMM!! Ive taken everyones suggestions and did the following Edited all the stats* file to change whenever sqlerror exit; To whenever sqlerror continue; And connect perfstat/perfstat To connect perfstat/perfstat@instance I also ran the script from a cmd window rather than sqlplusw I believe I looked at this last summer, and did in fact comment out or alter the files so they would stay Up but its quite possible I was more determined this go around due to everyones feedback. I diddnt really think one should have to hack up the 16 scripts just so they would run grin Thanks for the suggestions! bob Creating Package STATSPACK... Package created. No errors. Creating Package Body STATSPACK... Package body created. No errors. NOTE: STATSPACK complete. Please check statspack.lis for any errors. LOCDB SQL execute statspack.snap PL/SQL procedure successfully completed. LOCDB SQL spool off; not spooling currently LOCDB SQL @@@ I had some problems with stats pack install today. There is: 'on error exit' in the scripts. Remove it so the script can continue. This may solved your problem. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 8:04 PM Hello All I seem to be missing something very basic as no matter what I do I cant get statspack to install This is 8.16 on WIN2kpro I downloaded the newest version of stataspack and placed it into %oracle_home%\rdbms\admin C:\Oracle\Ora81\RDBMS\ADMINdir stats* 02/08/2000 07:36p 1,805 statsauto.sql 02/08/2000 07:36p 891 statscauto.sql 12/30/1999 02:13p 1,832 statscbps.sql 02/08/2000 07:36p 882 statscre.sql 02/08/2000 07:36p 28,088 statsctab.sql 02/08/2000 07:36p 27,879 statsctaba.sql 02/08/2000 07:36p 5,098 statscusr.sql 02/08/2000 07:36p 4,384 statscusra.sql 02/08/2000 07:36p 829 statsdrp.sql 02/08/2000 07:36p 3,344 statsdtab.sql 02/08/2000 07:36p 1,136 statsdusr.sql 02/08/2000 07:34p 28,516 statspack.doc 02/08/2000 07:36p 51,400 statspack.sql 02/08/2000 07:36p 48,205 statsrep.sql 01/19/2000 06:53p 52,610 statsrep80.sql 02/08/2000 07:36p 579 statsuexp.par 16 File(s)257,478 bytes I log onto the db sqlplusw internal/pw@instance SQL@%oracle_home%\rdbms\admin\statscre.sql the script seems to create the user.. but then blinks out. Apparently its soupposed to generate .lis files but there are no such files I tried to spool a log file but It only captures the first line... as the script blinks out if I try to SQL execute statspack.snap I get PLS-00201: identifier 'STATSPACK.SNAP' must be declared I try to prefix it with perfstat. or sys. but no joy what can I be doing wrong?? Ive tried to hack the scripts(so they would stay up) but there are so many variables that it dosnt seem practical Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list
RE: email out of oracle
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PMON seems to not close sessions in a timely manner eg Max
connection string (using the Oracle OLEDB provider wich is current) Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=z;Persis t Security Info=True;User ID=me;Data Source=mydb Here is my traditional sql+ connection username/password@instance So, Im wondering what type of special connection string I'd need for mts (if that's the case) Listener entry (SID_DESC = (GLOBAL_DBNAME =mydb) (ORACLE_HOME = C:\Oracle\Ora81) (SID_NAME = mydb) ) This is on win2k server, Oracle 8.1.7 Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PMON seems to not close sessions in a timely manner eg Max
Does your app connect to the database using the listener or directly (BEQ) without specifying a connect string? It should connect using the listener and a connect string. Regards, Waleed Waleed Yes, it's a web application and uses a listener. The listener entry has not been modified. There was a vague reference in the MTS docs that eluded to using a special connection string. But I got the impression that you would use a special connection string *if* you wanted the abillity to chooose between direct connection or mts (shared). In my case Id simply like to have all connections to use MTS. Should I be using a special connection string or listener entry? If so where can I find some examples Here is my asp application connection string (using the Oracle OLEDB provider wich is current) Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=z;Persist Security Info=True;User ID=me;Data Source=mydb Here is my traditional sql+ connection username/password@instance So, Im wondering what type of special connection string I'd need for mts (if that's the case) Listener entry (SID_DESC = (GLOBAL_DBNAME =mydb) (ORACLE_HOME = C:\Oracle\Ora81) (SID_NAME = mydb) ) This is on win2k server, Oracle 8.1.7 Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PMON seems to not close sessions in a timely manner eg Max
Title: Message From: Bob Metelsky [mailto:[EMAIL PROTECTED]] I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I get the dreaded "ORA-nnn max processes (50) reached" 1. 50 max processes? Damn, dude, you're choking that thing to death. 2. That is one of the sorriest excuses for a data access methodology that exists. Tell them to start pooling their database connections or you'll turn your max processes down even further. Hummm I have to be more diplomatic than that .. ;-) They are usingthe Oracle 8.17 provider with a connection string like so Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=a;Persist Security Info=True;User ID=a;Data Source=mydb Jeremy, do you have any examples of using pooled connections with active server pages? I'd like to be able to at least point them in the right direction and also have the information myself many thanks Bob
RE: PMON seems to not close sessions in a timely manner eg Max
Waleed, thanks for the reply here is what I have I have 26 sessions and 34 process, only one of which (my sqlplus session) that seems to indicate shared The rest seem to be remanents of the stored procedure. At the point of running this test, it was only myself monitoring and the developer repeadatly running his app which never ran the processses 37 in about 15 min How else can I analyse this? Im wondering why only one session is in shared mode and the remainder are dedicated? And what mandates a shared connection over a dedicated? My sql+ which initiated the shared session was simply username/passwd@instance Thanks bob LOCALUSER@MYDB - select count(*) from v$session; COUNT(*) -- 26 LOCALUSER@MYDB - select count(*) from v$process; COUNT(*) -- 37 LOCALUSER@MYDB - select decode(username,'SECUSER','LOCALUSER',NULL,'IS_NULL', username), status, program, server from v$session; DECODE(US STATUS PROGRAM SERVER - - IS_NULL ACTIVE ORACLE.EXE DEDICATED IS_NULL ACTIVE ORACLE.EXE DEDICATED IS_NULL ACTIVE ORACLE.EXE DEDICATED IS_NULL ACTIVE ORACLE.EXE DEDICATED IS_NULL ACTIVE ORACLE.EXE DEDICATED IS_NULL ACTIVE ORACLE.EXE DEDICATED username INACTIVE dbsnmp.exe DEDICATED LOCALUSER INACTIVE sqlplusw.exe NONE LOCALUSER INACTIVE sqlplusw.exe NONE LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE NONE LOCALUSER ACTIVE sqlplusw.exe SHARED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED LOCALUSER INACTIVE DEDICATED 26 rows selected. Do you know if the connections (sessions) created for the web app are shared or dedicated? If it's dedicated, did you try to connect using sqlplus from that win2k server and other hosts? Trying to isolate the problem? Regards, Waleed -Original Message- Sent: Thursday, December 26, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Does your app connect to the database using the listener or directly (BEQ) without specifying a connect string? It should connect using the listener and a connect string. Regards, Waleed Waleed Yes, it's a web application and uses a listener. The listener entry has not been modified. There was a vague reference in the MTS docs that eluded to using a special connection string. But I got the impression that you would use a special connection string *if* you wanted the abillity to chooose between direct connection or mts (shared). In my case Id simply like to have all connections to use MTS. Should I be using a special connection string or listener entry? If so where can I find some examples Here is my asp application connection string (using the Oracle OLEDB provider wich is current) Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=z;Persis t Security Info=True;User ID=me;Data Source=mydb Here is my traditional sql+ connection username/password@instance So, Im wondering what type of special connection string I'd need for mts (if that's the case) Listener entry (SID_DESC = (GLOBAL_DBNAME =mydb) (ORACLE_HOME = C:\Oracle\Ora81) (SID_NAME = mydb) ) This is on win2k server, Oracle 8.1.7 Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PMON seems to not close sessions in a timely manner eg Max processes(50) reached
I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I get the dreaded ORA-nnn max processes (50) reached I can watch processes increse and decrese with v$session and v$process, they just dont seem to close quick enough. (however, they do eventually close) Any ideas what to look for. Ive searched Google and for parameters for PMON to no avail, hence I bring my delimma to the list I think I'd like to tell PMON how frequently to check for completed requests. thanks and happy holidays bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PMON seems to not close sessions in a timely manner eg Max
select pid from v$process p,v$bgprocess b where b.paddr = p.addr and name = 'PMON' then oradebug wakeup n. where n is the process id Let me know if it works for you. Yes, I can do that but it seems like a manual process.I need something automatic.. No? Jared: We can bump up the processes but are worried about scaling. This was not an issue with one user, 2 users knocking the heck out of the app get processes = 50, so I would guess if users went to 100+ there could be an issue. Currently I have processes =100 and we don't get the error. Im looking for a setting that I can assign to have the processes clean up earlier. Ive read a article on Metalink saying processes should not be set to More than v$license More than 200 And is os dependant ? Thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PMON seems to not close sessions in a timely manner eg Max
Well, I had placed the db is MTS mode and still hit the max processes(50) #MTS_DISPATCHERS=(protocol=tcp)(dispatchers=5)(pool=on)(tick=1) (connections=1000)(sessions=4000) #MTS_MAX_DISPATCHERS=32 #MTS_SERVERS=5 #MTS_MAX_SERVERS=64 #MTS_SERVICE=MYDB #MTS_LISTENER_ADDRESS = (ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=MYSERVER)) And was able to have only shared connections as opposed to direct connections EG shows server=shared select username, program, server from v$session where audsid=userenv('sessionid'); I think Ive read all the docs I can find on multi threaded server but did not see anything about creating a service or adding a dispatcher, Im of the understanding that placing the above in my init.ora file, that creates the dispatcher when I bounce the db? In this case as far as I see my MTS service is MYDB.. Eg my SID So, I must be missing something... I'd sincerely appreciate any suggestions ... Examples?? From all the docs I see this is all that's needed, obiviously not - Please advise Thanks bob Add a dispatcher, configure MTS, min server processes and add an Oracle service for this MTS. An then let this app connect to Oracle through the MTS service. Regards, Waleed -Original Message- Sent: Tuesday, December 24, 2002 8:54 AM To: Multiple recipients of list ORACLE-L processes(50) reached I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I get the dreaded ORA-nnn max processes (50) reached I can watch processes increse and decrese with v$session and v$process, they just dont seem to close quick enough. (however, they do eventually close) Any ideas what to look for. Ive searched Google and for parameters for PMON to no avail, hence I bring my delimma to the list I think I'd like to tell PMON how frequently to check for completed requests. thanks and happy holidays bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Mailing lists for MS Windows NT/2000/XP Administration
http://peach.ease.lsoft.com/archives/winnt-l.html Hello, I am looking for mailing lists for MS Windows NT/2000/XP Administration which is similar to ORACLE-L from fatcity.com. Thanks in advance. Bob __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Holidays!!
Where and when is this going to be? A url maybe?? Or is it a womans only convention ;-) bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Methods to get DDL
The original is SQL PL/SQL Annotated Archives Ahh yes... but the new version is/ seems to be Oracle9i Instant PL/SQL Scripts Book Description From the authorized Oracle Press comes a complete guide to developing PL/SQL solutions quickly and easily. Inside, you'll find ready-to-run code and expert techniques with in-depth explanations that will help you understand the behaviors created, and even extend usage through customization. I bought mine yesterday used for $15 I think that's a pretty good deal http://www.iewww.com/content/0072132183 bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Footprint of 9i
All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bizzare behaviour of set oracle_sid=mysid
Only in my office can this happen Im checking into connecting to the db under the internal account from a cmd prompt I set oracle_sid=mysid C: set oracle_sid=my_sid C: connect internal I see cmd issuing sqlplusw system/password@othersid So, I add a permanent env_variable called ORACLE_SID I set the value to a bogus name eg mysid go to cmd C:set ORACLE_SID=mysid then I set ORACLE_sid=LOCDB set ORACLE_sid=LOCDB then connect internal I see cmd doing sqlplusw system/password@othersid It fails because I dont have a tns entry for othersid Where the heck is cmd getting the values for othersid?? any ideas? thanks bob ## LOCDB SQL select version from v$instance; VERSION - 8.1.6.0.0 ## Below is my output of set C:\set ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\bmetelsky\Application Data CI_HOLOS_CLI=C:\Program Files\Seagate Software\Open Olap\ CLASSPATH=D:\Programs\;C:\gnupg;C:\Oracle\Ora81\orb\classes\yoj.jar;C:\O racle\Ora81\orb\classes\share.zi CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=CPS109 ComSpec=C:\WINNT\system32\cmd.exe HOMEDRIVE=e: HOMEPATH=\bob LOGONSERVER=\\A_LOGON NUMBER_OF_PROCESSORS=1 oracle_home=C:\Oracle\Ora81 ORACLE_SID=LOCDB OS=Windows_NT Os2LibPath=C:\WINNT\system32\os2\dll; Path=D:\Oracle\Ora81\bin;C:\vim\vim\vim60;D:\Perl\bin\;C:\Oracle\Ora81\b in;C:\Oracle\Ora81\bin\bin80;C:\ am Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\ Wbem;C:\Oracle\Ora81\orb\bin; ULTRAE~1 PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH PERLDB_OPTS=RemotePort=127.0.0.1:2000 PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 0 Stepping 10, GenuineIntel PROCESSOR_LEVEL=15 PROCESSOR_REVISION=000a ProgramFiles=C:\Program Files PROMPT=$P$G SystemDrive=C: SystemRoot=C:\WINNT TEMP=C:\ TMP=C:\ USERDNSDOMAIN=MYDOMAIN USERDOMAIN=MYDOMAIN USERNAME=bmetelsky USERPROFILE=C:\Documents and Settings\bmetelsky windir=C:\WINNT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).