RE: Windohs - monthly at job
Attached is the GUI program to schedule jobs in Windows env. May be useful for you. (See attached file: WINAT.EXE) "Boivin, Patrice J" <[EMAIL PROTECTED] To mpo.gc.ca>Multiple recipients of list Sent by: ORACLE-L <[EMAIL PROTECTED]> [EMAIL PROTECTED] cc .com Subject RE: Windohs - monthly at job 07/09/2003 05:19 PM Please respond to [EMAIL PROTECTED] com Yes, for fun. Three years ago I found a freeware utility called crontab for Windows. Works well, I don't use AT anymore. Especially when one autumn morning after the time jumped back an hour, I noticed that two AT backup jobs had failed to start. That was on NT Server 4. Patrice. -Original Message- Sent: Tuesday, July 08, 2003 5:19 PM To: Multiple recipients of list ORACLE-L Just for fun right?!? Actually years ago I wrote a C++ program which took the current time and added fifteen minutes to it and submitted the at command. At the end of each batch file which I wanted to run every fifteen minutes I would add a line calling the C++ program passing the name of my program for the parameter ( atplus15 "c:\myJob.bat"). It's crude but has working for years now. I'm sure the Perl gurus here could probably whip something up similiar if they wanted to. --Jeff -Original Message- Sent: Tuesday, July 08, 2003 2:10 PM To: Multiple recipients of list ORACLE-L at 06:00 /every:M C:\myJob.bat at 06:15 /every:M C:\myJob.bat at 06:30 /every:M C:\myJob.bat at 06:45 /every:M C:\myJob.bat -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J 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: FTP command -without user interaction
Hi Bruce, Thanks for you response. Yes it is Windows environment. I did follow exactly what you have mentioned in your mail, but i have problem in login. Could you please let me where i'm going wrong? D:\Oracle>type ftp_script.txt open psrsndb2 oracle temp123 cd sami get 1.sql quit D:\Oracle>ftp -s:ftp_script.txt ftp> open psrsndb2 Connected to psrsndb2.i2.com. 220 psrsndb2 FTP server (SunOS 5.8) ready. User (psrsndb2.i2.com:(none)): 331 Password required for oracle . 530 Login incorrect. Login failed. ftp> ftp> cd sami 530 Please login with USER and PASS. ftp> get 1.sql 530 Please login with USER and PASS. 530 Please login with USER and PASS. ftp> quit 221 Goodbye. D:\Oracle>ftp psrsndb2 Connected to psrsndb2.i2.com. 220 psrsndb2 FTP server (SunOS 5.8) ready. User (psrsndb2.i2.com:(none)): oracle 331 Password required for oracle. Password: 230 User oracle logged in. ftp> cd sami 250 CWD command successful. ftp> get 1.sql 200 PORT command successful. 150 ASCII data connection for 1.sql (10.153.11.3,4723) (238 bytes). 226 ASCII Transfer complete. ftp: 245 bytes received in 0.00Seconds 245000.00Kbytes/sec. ftp> bye 221 Goodbye. D:\Oracle> "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED] To malco.riotinto.co Multiple recipients of list m.au> ORACLE-L <[EMAIL PROTECTED]> Sent by: cc [EMAIL PROTECTED] .com Subject RE: FTP command -without user interaction 07/04/2003 11:59 AM Please respond to [EMAIL PROTECTED] com What OS? Since you say "batch" file I will presume Windows. Use the "-s:filename" parameter and pass a scriptfile to the ftp command You can generate the scriptfile on the fly with echo commands and ">>" symbol redirection: eg: echo verbose off> %ftp_tfile% echo open %ftp_tgt_node%>> %ftp_tfile% echo %ftp_tgt_user%>> %ftp_tfile% echo %ftp_tgt_pwd%>> %ftp_tfile% echo type ascii>> %ftp_tfile% echo cd %3>> %ftp_tfile% echo put %1%2>> %ftp_tfile% echo bye>> %ftp_tfile% rem Do the actual ftp using this script file rem TYPE %ftp_tfile% ftp -s:%ftp_tfile% Example: C:\Temp>type ftpscript.ftp open mynode username secretpassword type ascii cd sys$login get login.com bye C:\Temp>ftp -s:ftpscript.ftp ftp> open mynode Connected to mynode. 220 mynode FTP Server (Version V4.1-12) Ready. User (mynode:(none)): 331 Username USERNAME requires a Password. 230 User logged in. ftp> ftp> type ascii 200 TYPE set to ASCII. ftp> cd sys$login 250 CWD command succesful. ftp> get login.com 200 PORT command successful. 150 Opening data connection for login.com (a.b.c.d,2828) 226 Transfer complete. ftp: 1570 bytes received in 0.20Seconds 7.85Kbytes/sec. ftp> bye 221 Goodbye. C:\Temp> HTH, Bruce Reardon -Original Message- Sent: Friday, 4 July 2003 4:09 PM Hi All, How to execute FTP command without interaction. Basically i want to supply hostname,username,passwors,filename thru batch script. For example ftp hostname userName passWord fileName Could someone help me to do the same? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
FTP command -without user interaction
Hi All, How to execute FTP command without interaction. Basically i want to supply hostname,username,passwors,filename thru batch script. For example ftp hostname userName passWord fileName Could someone help me to do the same? Thanks Sami -- 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).
Script to check filename continuously
Hi All Does anyone have script(DOS batch file or Unix Shell) to do the following stuff? loop if exist FILE_NAME begin do something; copy files to remote machine,etc... EXIT; end; end loop; Thanks Sami -- 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).
Multiple update
Hi All, Is it possible to update multiple tables in single SQL statement? Note:- we can accomplish this using view(key-preserved view). Is there any other way? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-01041: internal error. hostdef extension doesn't exist
Hi Murray I'm running Win 2000. 1)OracleService is running. 2)But why do i need listener? I'm not going to use connect string. Thanks Sami "Murray, Margaret" <[EMAIL PROTECTED] To eating.com> Multiple recipients of list Sent by: ORACLE-L <[EMAIL PROTECTED]> [EMAIL PROTECTED] cc .com Subject RE: ORA-01041: internal error. 06/25/2003 10:09 hostdef extension doesn't exist PM Please respond to [EMAIL PROTECTED] com Are you running on NT or Windows 2000? If so, make sure both the TNSListener service and the OracleService are running. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 10:05 AM > To: Multiple recipients of list ORACLE-L > Subject: ORA-01041: internal error. hostdef extension doesn't exist > > > > > > > Hi All, > > I have the following environment variable set > > ORACLE_HOME > ORACLE_SID > TNS_ADMIN > > init.ora file > = > REMOTE_LOGIN_PASSWORDFILE=NONE > > sqlnet.ora file > > SQLNET.AUTHENTICATION_SERVICES= (NTS) > > > I'm getting the following error. What could be wrong? > > SQL> connect / as sysdba > ERROR: > ORA-01041: internal error. hostdef extension doesn't exist > > Thanks > Sami > > -- > 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: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-01041: internal error. hostdef extension doesn't exist
Hi Reginald Thanks for your response. I would like to use OS authentication instead if password file authentication. Anyways i'll try setting the REMOTE_LOGIN_PASSWORDFILE = TRUE and let you know. Thanks Sami Reginald.W.Bailey @jpmorgan.com Sent by: To [EMAIL PROTECTED] Multiple recipients of list .com ORACLE-L <[EMAIL PROTECTED]> cc 06/25/2003 09:54 Subject PMRe: ORA-01041: internal error. hostdef extension doesn't exist Please respond to [EMAIL PROTECTED] com Saminathan: Try setting the REMOTE_LOGIN_PASSWORDFILE = TRUE. Before bouncing the database, create the password file with the orapasswd utility and assign a password. Then in the database, alter the SYS userid to use the same password as in the file. Then bounce the database. Then try "sqlplus / as sysdba". RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) Saminathan_Seeran [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED] Subject: ORA-01041: internal error. hostdef extension doesn't exist .com 06/25/2003 09:04 AM Please respond to ORACLE-L Hi All, I have the following environment variable set ORACLE_HOME ORACLE_SID TNS_ADMIN init.ora file = REMOTE_LOGIN_PASSWORDFILE=NONE sqlnet.ora file SQLNET.AUTHENTICATION_SERVICES= (NTS) I'm getting the following error. What could be wrong? SQL> connect / as sysdba ERROR: ORA-01041: internal error. hostdef extension doesn't exist Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
ORA-01041: internal error. hostdef extension doesn't exist
Hi All, I have the following environment variable set ORACLE_HOME ORACLE_SID TNS_ADMIN init.ora file = REMOTE_LOGIN_PASSWORDFILE=NONE sqlnet.ora file SQLNET.AUTHENTICATION_SERVICES= (NTS) I'm getting the following error. What could be wrong? SQL> connect / as sysdba ERROR: ORA-01041: internal error. hostdef extension doesn't exist Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9.2 RAC on Win2K?
Hi All, Could someone send me the document to setup 9i RAC on Win2k laptop? Thanks Sami K Gopalakrishnan <[EMAIL PROTECTED] om>To Sent by: Multiple recipients of list [EMAIL PROTECTED] ORACLE-L <[EMAIL PROTECTED]> .com cc Subject 06/25/2003 02:44 Re: Oracle 9.2 RAC on Win2K? PM Please respond to [EMAIL PROTECTED] com Branimir: Comments inlined .. --- Branimir Petrovic <[EMAIL PROTECTED]> wrote: > I need help with clearing up one conceptual issue: > My understanding is that with Oracle RAC one set of physical database > files "sitting" in the "middle" - shared storage are being accessed > by multiple Oracle instances running on multiple physical servers > (nodes). All instances "attacking" (sharing) the very same set of > data files at the same time. Right or wrong? Not necessarily. You can run RAC in a single machine also. I have few guys here who run RAC in their windoze laptops. But in general your understanding is very correct > Provided the answer on the above question happens to be "yes" - I'd > like to ask List Folks how feasible is to assemble and successfully > (smoothly?) run 0.5-1 TB database, use Oracle RAC and high > performance shared storage (say SAN) served ("pumped") by a number > of Windows 2K servers? > > The "number" of Win2K servers I have on mind is at least 4 "beefy" > (as beefy as it gets in Windows wrld) Win2K "boxes" each running > Win2K AS with lots of RAM and at least 4 CPUs, with perspective of > adding more later. Installing and Configuring RAC is as simple as you install Oracle databases. But the scalability is limited to just 4 nodes in Windows. I think this limitation is coming from Windows Clusters and NOT from Oracle. And also for Windows, you can use the OCFS (Oracle Cluster File System) and no need to create the RAW partitions. ( I think now a days all platforms have their own CFS (for Linux and windoze oracle gives the CFS) and no need to use RAW partitions for OPS/RAC). > It would be nice (for me) to know if new nodes can be added to the > cluster at any later time to improve performance (in order to deal > with increase in usage or to accomodate growth over period of time). The nice thing is , yes you can add new nodes dynamically (depends on the OS) and the number of nodes is limited by the OS. For example, in Windoze and Solaris you can only have max 4 nodes. HP-UX, AIX and Linux clusters supports up to 8 nodes. IBM-SP clusters supports upto 128 nodes and again, as I have said earlier all these limitations come from the respective OS/Hardware vendors. From Oracle side , there is no limit for the number of nodes in RAC clusters. > It would be very nice to know if number of nodes is or is not limited > (otherwise than by raw I/O capabilities of the shared storage). > Has anyone seen/run/stumbled over similar beast, if so - does it > "fly" or it "stinks"? I think the mandatory RAW partition requirement only comes with AIX (or does oracle support GPFS?) and you don't need to worry about RAW partition limitations. > Thanks (for any help, hints, links, etc.), > > Branimir > > P.S. > > I've looked at number of metalink articles and found none yet to > "scratch" this specific "itch" of mine. > > Oracle RAC on Win2K is for some bizarre reason REQUIREMENT. So I was not the only one in this earth who caught in that trap.. Nice to know somebody else also caught in that. We had implemeted RAC on W2k Advanced Server some time back .. TAF (Select failover) will not work in W2k and make sure TAF is not the MANDATORY requirement. Preconnect is an alternate if your customer agrees for that. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL P
OR Vs UNION
Hi All, Could someone explain to me which one is best in the following two queries w.r.t performance? Thanks Sami Query1) select distinct empployee_id from employees where department_id=10 or department_id=20 / Query2) === select employee_id from employees where department_id=10 union select employee_id from employees where department_id=20 / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Isolation Level to get Phantom Read
Thanks Ganesh. I'm getting most of the answers from only you. Thanks you so much. Let me read Tom's article. Regards Sami "Ganesh Raja" <[EMAIL PROTECTED] l.com> To Sent by: Multiple recipients of list [EMAIL PROTECTED] ORACLE-L <[EMAIL PROTECTED]> .com cc Subject 06/09/2003 08:44 RE: Isolation Level to get Phantom PMRead Please respond to [EMAIL PROTECTED] com Maybe you can read up this... http://tinyurl.com/du9v Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- [EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Hi All, How to achieve Repeatable Read isolation level in oracle? I mean the application should allow Phantom Read but NOT Dirty Read,Lost Update & Non-Repeatable Read Note:- If i choose SERIALIZABLE isolation level Phantom read is NOT allowed if i choose Read Committed isolation Non-Repeatable Read is allowed. Any clarification would be really appreciated Thanks Sami -- 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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Isolation Level to get Phantom Read
Hi All, How to achieve Repeatable Read isolation level in oracle? I mean the application should allow Phantom Read but NOT Dirty Read,Lost Update & Non-Repeatable Read Note:- If i choose SERIALIZABLE isolation level Phantom read is NOT allowed if i choose Read Committed isolation Non-Repeatable Read is allowed. Any clarification would be really appreciated Thanks Sami -- 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).