Re: Firewall -- ORA-12535: TNS:operation timed out
Could someone share with me if you come across similar kind of configuration. --- Mladen Gogala [EMAIL PROTECTED] wrote: You obviously do need special configuration. You are welcome. On 2003.07.08 17:09, Bob Robert wrote: All, I am getting following error message when I try to connect though firewall (from DMZ to Network). ORA-12535: TNS:operation timed out Do I need to do special configuration (like cman) around firewall? Thanks In Advance, Bob __ 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: Bob Robert 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Bob Robert 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).
Firewall -- ORA-12535: TNS:operation timed out
All, I am getting following error message when I try to connect though firewall (from DMZ to Network). ORA-12535: TNS:operation timed out Do I need to do special configuration (like cman) around firewall? Thanks In Advance, Bob __ 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: Bob Robert 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 Help -- Multiple rows into single column
No. We are still with 8i. --- [EMAIL PROTECTED] wrote: Are you on 9i? If so, setup the sql_load.txt file as an external table, and you can then use SQL and/ora PL/SQL to load your table the way you would like. Don't think you can do what you're asking directly from sqlldr. Jared Bob Robert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/26/2003 01:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SQL*Loader Help -- Multiple rows into single column Gurus, I have a special scenario to load data into tables with SQL*Loader. My SQL Loader data is not fixed format. It changes from time to time. But there is a good pattern about the data. Data which starts with letter R should go to table1 and data which starts with letter Z should go to table2. Table1 data is always fixed format where as table2 is kind of tricky. I would like to load data which starts with letter Z into table2 as a single row. For Example: (see my data at the bottom) Tom is having 3 lines of data Bob and Sam is having 4 lines of data Joe is having 5 lines of data Right now as per my SQL Loader Control file (sql_load.ctl), all the data which starts with Z goes into different rows (Tom -- 3 rows, Bob and Sam -- 4 rows, Joe -- 5 rows). I would like to load four rows into table1 (it is fine) and four rows into table2 (I am getting 16 rows). I hope I explained properly. FYI Please take look at the following scripts. -- Create Tables Script Start (sql_load.sql) -- Sequence create sequence table1_seq increment by 1 start with 1; create sequence table2_seq increment by 1 start with 1; -- Tables create table table1 (serial_no number(5), name varchar2(10), amount number(4)) / create table table2 (shipment_no number(5), details varchar2(1000)) / -- Create Tables Script End (sql_load.sql) -- SQL Loader Control file Start (sql_load.ctl) options (rows=1, errors=1) load data infile 'c:\sql_load.txt' badfile 'c:\sql_load.bad' discardfile 'c:\sql_load.disc' replace -- load table1 into table table1 when (1:1) = 'R' (serial_no position(1:1) table1_seq.nextval, name position(2:6) char, amount position(6:10) char) -- load table2 into table table2 when (1:1) = 'Z' (shipment_no position(1:1) table2_seq.nextval, details position(2:81) char) -- SQL Loader Control file End (sql_load.ctl) -- SQL Loader Data File Start (sql_load.txt) RTom 400 ZName: Tom ZShip_To: New York ZBill_To: Trenton RBob 300 ZName: Bob ZShip_To: Chicago ZBill_To: Detroit ZNotes: Best Customer Award RSam 500 ZName: Sam ZShip_To: Troy ZBill_To: Dallas ZNotes: Average Customer Award RJoe 200 ZName: Joe ZShip_To: Erie ZBill_To: San Fransisco ZNotes: Best Customer Award ZSpecial Notes: Include Customer -- SQL Loader Data File End (sql_load.txt) Thanks, Bob __ 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: Bob Robert 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: Bob Robert 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 Help -- Multiple rows into single column
Gurus, I have a special scenario to load data into tables with SQL*Loader. My SQL Loader data is not fixed format. It changes from time to time. But there is a good pattern about the data. Data which starts with letter R should go to table1 and data which starts with letter Z should go to table2. Table1 data is always fixed format where as table2 is kind of tricky. I would like to load data which starts with letter Z into table2 as a single row. For Example: (see my data at the bottom) Tom is having 3 lines of data Bob and Sam is having 4 lines of data Joe is having 5 lines of data Right now as per my SQL Loader Control file (sql_load.ctl), all the data which starts with Z goes into different rows (Tom -- 3 rows, Bob and Sam -- 4 rows, Joe -- 5 rows). I would like to load four rows into table1 (it is fine) and four rows into table2 (I am getting 16 rows). I hope I explained properly. FYI Please take look at the following scripts. -- Create Tables Script Start (sql_load.sql) -- Sequence create sequence table1_seq increment by 1 start with 1; create sequence table2_seq increment by 1 start with 1; -- Tables create table table1 (serial_no number(5), name varchar2(10), amount number(4)) / create table table2 (shipment_no number(5), details varchar2(1000)) / -- Create Tables Script End (sql_load.sql) -- SQL Loader Control file Start (sql_load.ctl) options (rows=1, errors=1) load data infile 'c:\sql_load.txt' badfile 'c:\sql_load.bad' discardfile 'c:\sql_load.disc' replace -- load table1 into table table1 when (1:1) = 'R' (serial_no position(1:1) table1_seq.nextval, name position(2:6) char, amount position(6:10) char) -- load table2 into table table2 when (1:1) = 'Z' (shipment_no position(1:1) table2_seq.nextval, details position(2:81) char) -- SQL Loader Control file End (sql_load.ctl) -- SQL Loader Data File Start (sql_load.txt) RTom 400 ZName: Tom ZShip_To: New York ZBill_To: Trenton RBob 300 ZName: Bob ZShip_To: Chicago ZBill_To: Detroit ZNotes: Best Customer Award RSam 500 ZName: Sam ZShip_To: Troy ZBill_To: Dallas ZNotes: Average Customer Award RJoe 200 ZName: Joe ZShip_To: Erie ZBill_To: San Fransisco ZNotes: Best Customer Award ZSpecial Notes: Include Customer -- SQL Loader Data File End (sql_load.txt) Thanks, Bob __ 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: Bob Robert 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).
MS Access 97 to Oracle 8.1.7 Scheduler
Gurus, We would like to load data from MS Access 97 database to Oracle 8.1.7 database with MS scheduler? Is it feasible? It could be done in MS SQL server with the helps of DTS package. Please share your experience in this regard and let me know what could be the best method to automate loading data from MS Access 97 to Oracle 8.1.7. Thank, Bob __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert 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).
Event Triggers in 8i ?
All, I would like to insert v$license table info into different table before shutting down the database with the help of Event Triggers. SQLdesc v$license Column NameNull?Type -- SESSIONS_MAXNUMBER SESSIONS_WARNINGNUMBER SESSIONS_CURRENTNUMBER SESSIONS_HIGHWATER NUMBER USERS_MAX NUMBER I would like to add sysdate in addition to above columns into temporary table on daily basis. Did any one setup similar to this? Thanks, Bob __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert 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).
Event Triggers in 8i ?
All, I would like to insert v$license table info into different table before shutting down the database with the help of Event Triggers. SQLdesc v$license Column NameNull?Type -- SESSIONS_MAXNUMBER SESSIONS_WARNINGNUMBER SESSIONS_CURRENTNUMBER SESSIONS_HIGHWATER NUMBER USERS_MAX NUMBER I would like to add sysdate in addition to above columns into temporary table on daily basis. Did any one setup similar to this? Thanks, Bob __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert 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).
OAUGNet OAUGNet-DBA list servers from OAUG.COM
Hi, Is any one getting emails from OAUGNet OAUGNet-DBA list servers (WWW.OAUG.COM)? For some reason, I am not getting emails for the last one week. Thanks 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] 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).
Mailing lists for MS Windows NT/2000/XP Administration
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] 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).
Spool Oracle Tables into Excel Format
All, Is it possible to create Oracle reports into Excel format ? Is it possible to spool Oracle tables into Excel format? Thanks in Advance Bob __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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).
Identify unused indexes in 8i ?
All, Is there a way to identify unused indexes in Oracle 8i. I know that it is easy to check with 9i. I would appreciate if you could share your experience (or ideas) with me. Thanks, Bob __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Identify unused indexes in 8i ?
All, Is there a way to identify unused indexes in Oracle 8i. I know that it is easy to check with 9i. I would appreciate if you could share your experience (or ideas) with me. Thanks, Bob __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Identify unused indexes in 8i ?
Indexes were never used. They must have been created for temporary purpose. --- #34;Gogala, Mladen#34; lt;[EMAIL PROTECTED]gt; wrote: gt; What are #34;unused indexes#34;? gt; gt; gt; -Original Message- gt; gt; From: Bob Robert [mailto:[EMAIL PROTECTED]] gt; gt; Sent: Thursday, August 29, 2002 3:33 PM gt; gt; To: Multiple recipients of list ORACLE-L gt; gt; Subject: Identify unused indexes in 8i ? gt; gt; gt; gt; gt; gt; All, gt; gt; gt; gt; Is there a way to identify unused indexes in gt; Oracle gt; gt; 8i. I know that it is easy to check with 9i. I gt; would gt; gt; appreciate if you could share your experience (or gt; gt; ideas) with me. gt; gt; gt; gt; Thanks, gt; gt; Bob gt; gt; gt; gt; gt; gt; gt; gt; __ gt; gt; Do You Yahoo!? gt; gt; Yahoo! Finance - Get real-time stock quotes gt; gt; http://finance.yahoo.com gt; gt; -- gt; gt; Please see the official ORACLE-L FAQ: gt; http://www.orafaq.com gt; gt; -- gt; gt; Author: Bob Robert gt; gt; INET: [EMAIL PROTECTED] gt; gt; gt; gt; Fat City Network Services-- (858) 538-5051 gt; FAX: (858) 538-5051 gt; gt; San Diego, California-- Public Internet gt; access / Mailing Lists gt; gt; gt; gt; gt; To REMOVE yourself from this mailing list, send an gt; E-Mail message gt; gt; to: [EMAIL PROTECTED] (note EXACT spelling of gt; 'ListGuru') and in gt; gt; the message BODY, include a line containing: UNSUB gt; ORACLE-L gt; gt; (or the name of mailing list you want to be gt; removed from). You may gt; gt; also send the HELP command for other information gt; (like subscribing). gt; gt; gt; -- gt; Please see the official ORACLE-L FAQ: gt; http://www.orafaq.com gt; -- gt; Author: Gogala, Mladen gt; INET: [EMAIL PROTECTED] gt; gt; Fat City Network Services-- (858) 538-5051 FAX: gt; (858) 538-5051 gt; San Diego, California-- Public Internet gt; access / Mailing Lists gt; gt; To REMOVE yourself from this mailing list, send an gt; E-Mail message gt; to: [EMAIL PROTECTED] (note EXACT spelling of gt; 'ListGuru') and in gt; the message BODY, include a line containing: UNSUB gt; ORACLE-L gt; (or the name of mailing list you want to be removed gt; from). You may gt; also send the HELP command for other information gt; (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
init.ora processes ??
All, What is the impact of processes init.ora parameter other than restricting number of user sessions ? I know it needs more memory (like stack size + sort area size + etc. ) whenever it gets new connection. My question is: Is there any additional resource (does it take more memory? ) usage if I start database with 100 processes versus 200 processes as init.ora parameter (assuming that I have same number of sessions in both cases). Thanks for your help. Bob __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: init.ora processes ??
How about with Microsoft Windows NT ? --- Fink, Dan [EMAIL PROTECTED] wrote: For each process 'reserved' by oracle, there is a small amount of space allocated in the SGA and a semaphore is reserved at the O/S level (assuming UNIX). A lesser number of processes will allocate a slightly smaller amount of SGA and fewer semaphores. Until a session is started, no other memory is allocated. Dan Fink -Original Message- Sent: Friday, August 16, 2002 10:44 AM To: Multiple recipients of list ORACLE-L All, What is the impact of processes init.ora parameter other than restricting number of user sessions ? I know it needs more memory (like stack size + sort area size + etc. ) whenever it gets new connection. My question is: Is there any additional resource (does it take more memory? ) usage if I start database with 100 processes versus 200 processes as init.ora parameter (assuming that I have same number of sessions in both cases). Thanks for your help. Bob __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-12500 TNS:listener failed -- Intermittent
Gurus, Oracle Version: 8.0.4 (I know we are way behind) OS: Windows NT (Service Pack 6) Physical Memory: 1.5 GB Virtual Memory: 1.5 GB Once in every week, we get TNS-12500 TNS:listener failed to start a dedicated server process. When I check listener process, it was running. When I check number of sessions, it was always below number processes (setup by init.ora file). Whenever we get this error message, one out of fifteen sessions get successful connection. When we check system resources, we had enough free memory in the system.If we try to stop listener process and restart again, it works for a while (may be 30 Min.). We couldn't find any error messages both in alert log file as well as OS event log. Only solution, we had right now is to reboot the NT server in the middle of production time. Users are getting frustrated whenever we reboot the server. I think upgrading database to 8i or 9i would help our problem. But, we are not in a position to do so. I think there might be memory leakage which we could not see from the OS Task Manager. Did any one come across similar kind of problem. I would appreciate if you could share your experience with me. Thanks, Bob __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DOS Script for pop up question ?
Thanks for the Oracle list members who responded very promptly for my question. At the moment, I am very satisfied with pause command. I have one more question for the DOS Gurus. Is there a way to change the fond size from the DOS Script ? Thanks, Bob --- James J. Morrow [EMAIL PROTECTED] wrote: Bob Robert wrote: All, I have a DOS batch file. In between this script, I would like to add user interactive question. Ex: Do you want to Continue [Y/N]? Once they hit Y, it will continue rest of the batch file. Could someone able to help me out as per the above requirement? Thanks, Bob Well, the simplest answer would be to use the Pause command. This assumes, of course, that you don't really care what key they press... simply: echo Hit Control-C to abort or... pause Will return: Hit Control-C to abort or... Press any key to continue I'm pretty sure that the DOS batch language doesn't have any get keystroke functionality built-in. However, the CMD language might. A search on google for dos cmd batch get (http://www.google.com/search?sourceid=navclientq=dos+cmd+batch+get) yields this link: http://www.simtel.iif.hu/pub/msdos/batchutl/ Which has a whole slew of MS-DOS based utilities. I'm sure one of them would have a little *.exe that would read a line or a character from stdin. Additionally, you could consider Cygnus for Windows (aka Cygwin) available through redhat.com. Cygwin is a Windows tool that gives you Unix functionality. Including some of the popular unix shells for scripting (Bash, Tcsh). This product (free, as in beer) provides the same functionality as the (much more expensive) MKS Toolkit (available from MKS Software... http://www.mks.com). The MKS toolkit is required for Oracle Applications 11i on MS Windows NT/2000. http://freshmeat.net/projects/cygwin/?topic_id=45%2C74 or http://cygwin.com -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DOS Script for pop up question ?
All, I have a DOS batch file. In between this script, I would like to add user interactive question. Ex: Do you want to Continue [Y/N]? Once they hit Y, it will continue rest of the batch file. Could someone able to help me out as per the above requirement? Thanks, Bob __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Link to MS SQL Server ?
All, Thanks for everyone's help. I will research more in Metalink. Thanks, --- Boivin, Patrice J [EMAIL PROTECTED] wrote: I checked for that last week, I think something needs to be installed on the same machine as SQL Server for the Gateway to work. ? correct? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 19, 2002 7:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB Link to MS SQL Server ? through Oracle gateway you can connect to non oracle databases. -Original Message- Sent: Wednesday, June 19, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Gurus, Is there a way to connect from Oracle Database to MS SQL Server or vise versa ? Please share your information. Thanka __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Kernal Parameters for HP-UX 11.0 (Oracle 8.1.7)
All, What are the recommended Kernal Parameters (Semaphore and Shared memory) for HP-UX 11.0 (Oracle 8.1.7). I could not find any good document from metalink site. Also, I could not find any thing from Oracle 8.1.7 documentation CD. Thanks, Bob __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OracleService is down on regular basis
Jamdagni Danishment, Thanks for your help. I opened a ticket with Oracle and it got fixed. See the Oracle explanation ... This is bug 614799. Abstract: ORA-600[17034] WHEN CONSTRAINT IS VIOLATED Workaround is: set AUDIT_TRAIL=NONE or set AUDIT_TRAIL=FALSE Thanks, Bob --- Danisment Gazi Unal [EMAIL PROTECTED] wrote: Hi, can you paste ora-600 trace files to list ? Jamadagni, Rajendra wrote: Check the code in the trigger it seems that one of the variables is getting assigned a value that is longer than it can hold. The ora-2 error is user generated. Check on metalink you could be running into a bug, one of the posters got it resolved by pinning all the packages in SGA. Anyways, the mantra is 'If you see ora-600 error, first contact OWS and then the list.' HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! Name: ESPN_Disclaimer.txt ESPN_Disclaimer.txtType: Plain Text (text/plain) Encoding: 7bit -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OracleService is down on regular basis
OS: Windows NT Oracle Database: 8.0.4 One of our production database instance OracleService was down at least three times in a row. At this stage, we have to restart OracleService to bring up the database. I saw couple of error messages in alert log file. ORA-00600: internal error code, arguments: [17034], [82083000], [0], [], [], [], [], [] ORA-2: The inserted duplicated information was deleted ORA-06512: at PROD.REAL_TRIGGER, line 318 ORA-04088: error during execution of trigger 'PROD.REAL_TRIGGER' Based on above information, Is it possible to stop OracleService ? Please let me know about your opinion and suggestion. Thanks, Bob __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OracleService is down on regular basis
OS: Windows NT Oracle Database: 8.0.4 One of our production database instance OracleService was down at least three times in a row. At this stage, we have to restart OracleService to bring up the database. I saw couple of error messages in alert log file. ORA-00600: internal error code, arguments: [17034], [82083000], [0], [], [], [], [], [] ORA-2: The inserted duplicated information was deleted ORA-06512: at PROD.REAL_TRIGGER, line 318 ORA-04088: error during execution of trigger 'PROD.REAL_TRIGGER' Based on above information, Is it possible to stop OracleService ? Please let me know about your opinion and suggestion. Thanks, Bob __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Embarcadero DBArtisan Trial Version
All, Six months back I installed DBArtisan trial version. I didn't get a chance to play much with DBArtisan. Now I un-installed DBArtisan and reinstalled again on same desktop. It is prompting me to enter license key. Is there a way to get trial version without rebuilding my desktop. I think you got my point. Thanks, Bob __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
email list groups for Windows NT and 2000
Are there any good email list groups for Windows NT and 2000 servers ? Thanks in Advance, Bob Robert __ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
logon failure auditing
All, I would like to audit all the database users upon logon failure. I know that someone must have been implemented similar kind of auditing. Could you please share your information with me. At the same time I did create new profile and assign it to all the database users. This new profile will lock database users for about 15 Min. after three successful logon failures. Thanks, Bob __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
