RE: !!Please Read - Oracle-L is moving!!
Title: Message I like the fine message provided when you right click on Extra line break in this message were removed. To restore, click here..that is No help topic is associated with this item oh great. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Toepke Sent: Friday, January 23, 2004 9:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Its easy todisable this feature: Navigate to the Tools-Options menu Click the Email Options Button Uncheck the Remove extra line breaks in plain text messages checkbox Click Okay about 30 times and your're done! Kevin -Original Message- From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat your default new mail format is.I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office'in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David Lord Senior DBA Iron Mountain (UK) Ltd Telephone: 029 2054 4000 Direct: 029 2054 4013 Fax: 029 2069 2464 Email: [EMAIL PROTECTED] -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24 To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! -Original Message- From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data. If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that any dissemination, misuse or copying or disclosure of this communication by a recipient who has received this message in error is strictly prohibited. If this message is received in error, please return this email to the sender and immediately highlight any error in transmittal. Thank you. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for the author's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications
RE: RAC on Win2K using RMAN to Create Standby
True, but you can use a UNC address \\machine_name\shared_dir to copy a backup file remotely. But you need to make sure that the user who fires off the copy command has write access on the shared destination directory. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Sent: Thursday, January 15, 2004 4:34 AM To: Multiple recipients of list ORACLE-L jwiegand wrote: Good Day. Has anyone succeeded in this and care to share? I've tried sharing out the directory containing the Oracle backup, tried setting the Oracle services to run under a Windows domain user, but continue to get failures. Hello, Oracle on Windows don't support network drives. You may copy backup file from one server to other manualny, and then create standby database from backup. regards, Marcin Przpiórowski Senior Oracle DBA www.oracledba.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Marcin_Przepi=F3rowski?= 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: QuijadaReina, Julio C 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).
RMAN options (was: Deleting database)
that dropping ALL schemas would equal removing entire database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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: Carel-Jan Engel 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: QuijadaReina, Julio C 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).
RE: Deleting database
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
RE: Deleting database
Carel-Jan, Thanks for your insight in the difference between export/import and copying databases. Two factors had me initially thinking of doing export/import: 1) The tables in production are not big and 2) tables are not subject to heavy changes. As it was pointed out before and although I am not in favor of analyzing stats in a regular basis, the need for analyzing statistics will be determined by the circumstances of one's environment. My test database is more like a test to my logical backups and to have an instance for me to study the tables of this application. Thanks Branimir, Ron, and Vaidya too for your ideas. Now I have a broader view of the various ways to delete a database. Regards, Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Carel-Jan Engel Sent: Tuesday, December 30, 2003 3:39 PM To: Multiple recipients of list ORACLE-L As far as I can understand your question you are copying your production environment to test. So, test should be a copy, and not an export/import logical represantation of prod. Otherwise your tables/indexes will be reorganized every time you create the new test database. This means re-analyzing statistics (see another HOT topic today), and ending up with a non-represntative version of your production database, at least from the SQL-tuning/optimizing point of view. So, I would suggest to take rman, or the old-fashioned well working alter tablespace begein/end backup scenario, and clone your production database. This will give you the physical copy. I've done this many times on unix flavours, never on M$ OS's I like to keep it that way ;-). I guess you might find some nice articles about this on metalink, searching with the keywords clone database. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 12:14 30-12-03 -0800, you wrote: That's right - you would have to drop all schema owners. In my opinion it is simpler and easier task to automate dropping of all owners followed by one full import compared to task of automating database deletions followed by database creations then doing full import in very last step. DOS environment offers weak (better word is miserable) error handling, so unless you resort to non M$ scripting languages to do this task for you I believe you'd be better off to stick with simpler of two approaches. Another reason to try avoiding tearing/re-creating databases lies in the fact that when you create new database on WinXYZ platform, newly created data files are always fragmented at file level (which may not be overly fact important for your test database but it is an ugly site to look at nevertheless). Branimir Branimir, Correct me if I am wrong, but if I used your approach of dropping schema owner then if I have 25 schemas on my test db, I would have to drop ALL of them? I would think that dropping ALL schemas would equal removing entire database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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: Carel-Jan Engel 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: QuijadaReina, Julio C 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).
Deleting database
Hi All, I have two databases of small size running on a Win2k Server. One is production and the second one test. I would like to delete the test database in an automated way (run a script say every weekend), then recreate it so that I have a fresh database to work with or to import prod data into. I have the scripts for database creation part done. But, I was wondering if there were any sample scripts for deleting a database without user interaction or at least know what steps I should follow. Has anybody done this on his or her environment? Your help will be appreciated! Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: QuijadaReina, Julio C 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).
Deleting database
Sorry, I forgot to mention I am using Oracle 9.2.0.1.0 -Original Message- Sent: Tuesday, December 30, 2003 11:47 AM To: '[EMAIL PROTECTED]' Hi All, I have two databases of small size running on a Win2k Server. One is production and the second one test. I would like to delete the test database in an automated way (run a script say every weekend), then recreate it so that I have a fresh database to work with or to import prod data into. I have the scripts for database creation part done. But, I was wondering if there were any sample scripts for deleting a database without user interaction or at least know what steps I should follow. Has anybody done this on his or her environment? Your help will be appreciated! Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: QuijadaReina, Julio C 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: Deleting database
Vaidya, Wouldn't I have to worry about any registry info for the test instance after physically deleting the OS db files? Would I be able to create test using the same instance name? Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Vaidya, ShreepadX M Sent: Tuesday, December 30, 2003 12:05 PM To: Multiple recipients of list ORACLE-L Hi, One way would be 1) From your test database get a list of all datafiles,redologs,controlfile locations. 2) Spool and store it in a file. 3) Shutdown the database and listeners 4) Use the file to create a script to physically remove the database related files using OS commands. Hope this helps shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vaidya, ShreepadX M 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: QuijadaReina, Julio C 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: Deleting database
Ron, I like this idea. Although, I am not really concerned about userid's or environmentals, truncating test tables and importing the new data in looks like it would be faster than deleting the entire test database and then recreating it. But how would I know what tables to truncate? Thanks Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Ron Rogers Sent: Tuesday, December 30, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Julio, If you need to keep the userid's and other environmentals, I would create a script that truncates the tables and then import the data to populate them with the new data. The export can be controlled with a par file and the import can be part of the truncate script. Ron [EMAIL PROTECTED] 12/30/2003 11:54:32 AM Hi All, I have two databases of small size running on a Win2k Server. One is production and the second one test. I would like to delete the test database in an automated way (run a script say every weekend), then recreate it so that I have a fresh database to work with or to import prod data into. I have the scripts for database creation part done. But, I was wondering if there were any sample scripts for deleting a database without user interaction or at least know what steps I should follow. Has anybody done this on his or her environment? Your help will be appreciated! Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: QuijadaReina, Julio C 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: Ron Rogers 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: QuijadaReina, Julio C 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: Deleting database
Branimir, Correct me if I am wrong, but if I used your approach of dropping schema owner then if I have 25 schemas on my test db, I would have to drop ALL of them? I would think that dropping ALL schemas would equal removing entire database. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Branimir Petrovic Sent: Tuesday, December 30, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Run oradim.exe from command line to see how to delete SID. Deleting Oracle service via oradim _will_ remove corresponding registry entries. But why bother removing database, wouldn't dropping schema owner with cascade option followed by full import do the trick? Branimir Wouldn't I have to worry about any registry info for the test instance after physically deleting the OS db files? Would I be able to create test using the same instance name? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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: QuijadaReina, Julio C 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 Installation
Seema, Why would you need vncserver to install Oracle? Are you trying to install Oracle on the Linux box from a remote location? Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Seema Singh Sent: Friday, December 26, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Hi, Can I install oracle8i on Linux without using vncserver? Like set up the display and run runInstaller. thanks -seema _ Take advantage of our limited-time introductory offer for dial-up Internet access. http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: QuijadaReina, Julio C 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: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: QuijadaReina, Julio C 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: no longer listening
Yong, Thanks for the making that correction. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Yong Huang Sent: Friday, December 19, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Hi, Julio, Windows doesn't have a nsswitch.conf equivalent. Windows hosts file is equivalent to UNIX /etc/hosts. Imagine Windows has a nswitch.conf like this: hosts: files dns But it's missing other lines such as protocoles, services... in this file. This topic is much less off-topic than some others. Thanks for reminding everybody. Yong Huang QuijadaReina, Julio C wrote: Mladen, The equivalent of nsswitch.conf on Win2K is the hosts file in winnt\system32\drivers\etc. You'd probably say: the /etc directory in M$ ...But, well this is way off the topic we are dealing with. Like Jared said, we need to focus ;) __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: QuijadaReina, Julio C 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: no longer listening
Mladen, The equivalent of nsswitch.conf on Win2K is the hosts file in winnt\system32\drivers\etc. You'd probably say: the /etc directory in M$ Windoze? Somewhat of a resemblance to the UNIX naming convention. You'd be surprise to find a services file just like the one found in /etc directory of the UNIX and UNIX-like OS'sBut, well this is way off the topic we are dealing with. Like Jared said, we need to focus ;) My name resolution is done by a DC, actually there are several of them. I should probably check to make sure everything is consistent across all DCs as far as computer name and address for my Oracle server host. I doubt there will be differences since they replicate the same domain info. I also checked the hosts file and it only has the localhost line in it. I'll try including a line for my server as it appears in my domain controllers, maybe that'll help. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Mladen Gogala Sent: Wednesday, December 17, 2003 4:45 PM To: Multiple recipients of list ORACLE-L So, how are your host names resolved? Any changes in DNS or WINS name servers? Did anybody reboot or alter PDC? On NT host names are resolved by asking PDC. If it cannot respond because of reboot, listener may shut down as well. You should try modifying yur local equivalent of nsswitch.conf. whatever the name is. On 12/17/2003 04:24:34 PM, QuijadaReina, Julio C wrote: Mladen, I did look at the listener.log file and did not see any changes as far as network configuration. The host where the database is running on does not have a fixed IP address though. It gets a lease from a DHCP. I checked the logs on the DHCP and the IP for my database host has not changed lately. Also, the HOST parameter in listener.ora has assigned to it the host's name and not its IP address. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Mladen Gogala Sent: Wednesday, December 17, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Somebody might have changed network configuration. Did you look into the listener.log ? On 12/17/2003 02:19:43 PM, QuijadaReina, Julio C wrote: Hi all, For the last couple of weeks, I have experienced listener down times. The listener will work fine for say a week, and then all the sudden it will no longer allow connections from remote machines. Clients use SQL*plus to connect. Interestingly enough, on the actual server I am able to login just fine. The following are the log lines as they appear in my listener.log. - No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machinename.domain)(PORT=1521) )) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=8080))(Presentation=HTTP)(Session=RAW)) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=2100))(Presentation=FTP)(Session=RAW)) - HTTP and FTP are not important, since we do not use any Oracle's HTTP or FTP. But the second line on the log is rather important since it is the listener's port (1521). The server is a Win2K with 128MB of RAM and a small test database for about 60 users of which 20 or so might connect simultaneously. Any ideas as to why this might be happening? Regards, Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: QuijadaReina, Julio C 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
RE: no longer listening
Jared, I don't yet have a service to monitor the service that moniters the service monitor. Is this a tongue twister of some sort? ;-) I totally understand where you are coming from. Windoze seems to always have difficulty bringing and keeping services up. I presented this as a reason (among many others) why we should not have had our server on a Windoze box, but the faculty member you teaches one of the Database Concepts course said wanted Window. I myself wouldve gone for Sun Solaris, but heyas in most of the universities and junior colleges in the country. Faculty has the last say on this type of matters (sadly) no matter what Tech Support Staff or better yet real world experience says. Regards, Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 7:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: no longer listening I've had similar problems, however, it isn't just limited to Oracle listeners. NT and Win2k are both problematic when it comes to reliably starting services at bootup. They both occasionally have a problem with a service dying for no apparent reason. I don't know why this is. To deal with it I wrote a script that runs as another service on a separate server, checks each day at 05:30 if particular services are running on a number of servers, restarts them if possible and pages me. There's another service, on yet another computer, that checks to make sure the service monitor service is running. I don't yet have a service to monitor the service that moniters the service monitor. Not an ideal solution ( that would be linux where things tend to be more reliable), but it works. Jared QuijadaReina, Julio C [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 11:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:no longer listening Hi all, For the last couple of weeks, I have experienced listener down times. The listener will work fine for say a week, and then all the sudden it will no longer allow connections from remote machines. Clients use SQL*plus to connect. Interestingly enough, on the actual server I am able to login just fine. The following are the log lines as they appear in my listener.log. - No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machinename.domain)(PORT=1521))) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=8080))(Presentation=HTTP)(Session=RAW)) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=2100))(Presentation=FTP)(Session=RAW)) - HTTP and FTP are not important, since we do not use any Oracle's HTTP or FTP. But the second line on the log is rather important since it is the listener's port (1521). The server is a Win2K with 128MB of RAM and a small test database for about 60 users of which 20 or so might connect simultaneously. Any ideas as to why this might be happening? Regards, Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College
no longer listening
Hi all, For the last couple of weeks, I have experienced listener down times. The listener will work fine for say a week, and then all the sudden it will no longer allow connections from remote machines. Clients use SQL*plus to connect. Interestingly enough, on the actual server I am able to login just fine. The following are the log lines as they appear in my listener.log. - No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machinename.domain)(PORT=1521))) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=8080))(Presentation=HTTP)(Session=RAW)) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=2100))(Presentation=FTP)(Session=RAW)) - HTTP and FTP are not important, since we do not use any Oracles HTTP or FTP. But the second line on the log is rather important since it is the listeners port (1521). The server is a Win2K with 128MB of RAM and a small test database for about 60 users of which 20 or so might connect simultaneously. Any ideas as to why this might be happening? Regards, Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College
RE: no longer listening
Thanks for replying Leroy, I am running Oracle 9i Enterprise Edition 9.2.0.1.0 for both the database and the listener. But I wonder if the issue is the standard port 1521, should I change to a non-standard port? Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of LeRoy Kemnitz Sent: Wednesday, December 17, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Subject: Re: no longer listening I had a lot of problems with the listeners going down for no reason. I was running 8.1.7.4 with 8.1.7 listeners at the time. I changed the ports to non-default ports and upgraded to 9. And haven't had a problem since. QuijadaReina, Julio C wrote: Hi all, For the last couple of weeks, I have experienced listener down times. The listener will work fine for say a week, and then all the sudden it will no longer allow connections from remote machines. Clients use SQL*plus to connect. Interestingly enough, on the actual server I am able to login just fine. The following are the log lines as they appear in my listener.log. - No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machinename.domain)(PORT=1521))) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=8080))(Presentation=HTTP)(Session=RAW)) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=2100))(Presentation=FTP)(Session=RAW)) - HTTP and FTP are not important, since we do not use any Oracles HTTP or FTP. But the second line on the log is rather important since it is the listeners port (1521). The server is a Win2K with 128MB of RAM and a small test database for about 60 users of which 20 or so might connect simultaneously. Any ideas as to why this might be happening? Regards, Julio Cesar Quijada-Reina Programmer Analyst Computer Services atAlfredState College
RE: no longer listening
Mladen, I did look at the listener.log file and did not see any changes as far as network configuration. The host where the database is running on does not have a fixed IP address though. It gets a lease from a DHCP. I checked the logs on the DHCP and the IP for my database host has not changed lately. Also, the HOST parameter in listener.ora has assigned to it the host's name and not its IP address. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Mladen Gogala Sent: Wednesday, December 17, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Somebody might have changed network configuration. Did you look into the listener.log ? On 12/17/2003 02:19:43 PM, QuijadaReina, Julio C wrote: Hi all, For the last couple of weeks, I have experienced listener down times. The listener will work fine for say a week, and then all the sudden it will no longer allow connections from remote machines. Clients use SQL*plus to connect. Interestingly enough, on the actual server I am able to login just fine. The following are the log lines as they appear in my listener.log. - No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machinename.domain)(PORT=1521) )) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=8080))(Presentation=HTTP)(Session=RAW)) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= machinename.domain)(PORT=2100))(Presentation=FTP)(Session=RAW)) - HTTP and FTP are not important, since we do not use any Oracle's HTTP or FTP. But the second line on the log is rather important since it is the listener's port (1521). The server is a Win2K with 128MB of RAM and a small test database for about 60 users of which 20 or so might connect simultaneously. Any ideas as to why this might be happening? Regards, Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: QuijadaReina, Julio C 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: Stop using SYS, SYSTEM?
I thought SYS and SYSTEM were NOT 'PUBLIC' accounts. It all depends on how many people you let login as SYS or SYSTEM, and that decision will be different for each individual DBA. But my question is: How can you give a portion of SYS/SYSTEM functionality to Jane DBA and Joe DBA if you DO NOT have SYS and SYSTEM to begin with? Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Cupp Michael E Contr Det 1 AFRL/WSI Sent: Friday, November 14, 2003 8:09 AM To: Multiple recipients of list ORACLE-L -Original Message- Sent: Thursday, November 13, 2003 10:49 PM To: Multiple recipients of list ORACLE-L SNIP Stopping someone from using a given set of accounts achieves preciously nothing in terms of security (or auditing) IF the functionality of those accounts is then replicated to other accounts. SNIP Not if someone (I.e. an 'operator') is only using a portion of the access (COMPLETE) that is given to sys and/or system. Fact is a DBA needs to be able to exp/imp (debatable, but let's ignore that). And manage rights. And manage space. And manage allocations, And monitor the system. And a myriad of other tasks immaterial to the point I'm trying to make. But a user account for Joe DBA and another user account for Jane DBA, etc, etc will provide accountability and tracability, vs a 'public' account does not. Just my $0.02 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cupp Michael E Contr Det 1 AFRL/WSI 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: QuijadaReina, Julio C 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: 9i on Redhat9 agent does not start...
Title: Message Anjan, Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm. try setting the following on the users .profile or on your users shell startup file: LD_LIBRARY_PATH = $ORACLE_HOME/lib LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib Maybe oracle is looking for 64 bit library files! Julio -Original Message- From: Anjan Thakuria [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Subject: 9i on Redhat9 agent does not start... Gurus, Would appreciate any help that I can get on this... I have 9.2.0.1 on redhat 9 ... However I cannot seen to start the agent on the server... agentctl start just bails out.. no messages... This what I see in the dbsnmp.nohup /db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared libraries: libvppdc.so: cannot open shared object file: No such file or directory Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127 Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003 libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit file.. Thanks in advance... Anjan
RE: Oracle Service on Win2k
Stefan, Have you tried using the NOMOUNT switch somewhere in your db instance startup? Julio -Original Message- From: Stefan Jahnke [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 7:29 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Service on Win2k Hi list On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service OracleServiceSID, most of the times, the database will also be mounted and opened ! Doesn't matter wether I start the service via gui or via net start OracleServiceSID or oradim -STARTUP -SID SID -USRPWD PWD -STARTTYPE srvc, the database will be opened right away. I definitely don't want that. That sh%%($t can sc%$/w up my instance. Does anybody encounter the same problems ? Couldn't find anything relevant on metaling, though. Help, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: QuijadaReina, Julio C 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 to Log on 2000 users
Hi gaurav and fellow DBAs, I ran into the same problem once on a Sun Solaris 5.9 box. The lines on your sqlnet.ora file have a great deal of impact on how authentication works. remote_os_authent=true will allow people remote users to connect to your instance using the credentials on the machine they are logged in. This means that OS credentials used are niether Oracle's nor the local OS's that your insance resides on. I don't know about you but I 'goose bumps' at the thought of allowing users to user THEIR OS authentication credentials. If you are comfortable with they way your authentication works, omit the following lines: If I were you, I would take the SQLNET.AUTHENTICATION_SERVICES = (none) out of my sqlnet.ora file and change your remote_os_authent = false on my ora init instance file. An excelent way to troubleshoot the sqlnet.ora file is to create a copy of it as a backup and try taking out a line at a time. Restart your ora instance every time you delete one of your lines in the file and test your login. Another pointer I think you are missing grant connect and grant resource on your grant statement. Take care, Julio -Original Message- Sent: Monday, June 02, 2003 7:55 AM To: Multiple recipients of list ORACLE-L Hello list , I tried the same thing but to log on an OS user I have to set remote_os_authent=true in parameter file and SQLNET.AUTHENTICATION_SERVICES = (none) in sqlnet.ora Why would I need to set remote_os_authent ? shouldn't it be left at its default value of 'false' ? otherwise wouldn't it be a security problem. But I cannot log in my os users till I set remote_os_authent=true Other details : Oracle 9.2.0.1.0 enterprise edition on win32 OS_AUTHENT_PREFIX='' create user administrator identified externally default tablespace users temporary tablespace temp quota unlimited on users ; grant create session, create table to administrator; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 30, 2003 19:54 Munish Bajaj, If you want your OS users to log into your database, you need to set the OS_AUTHENT_PREFIX parameter in the init ora file for your instance to a string of your like. Oracle's default is OPS$. If your OS user account is JOE. Oracle looks at this account as OPS$JOE. The account is tacked on the OS_AUTHENT_PREFIX. Then, you need to create the ORACLE user account that will correspond to your OS account and make it externally identified. As sys do the following: SQL create user OPS$JOE externally identified; Bear in mind that if you have and OS group called DBA, any member of that group will be able to connect as sysdba, so you need to be careful with the people you put in that group ;-- ) Regards, Julio -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: QuijadaReina, Julio C 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 to Log on 2000 users
Munish Bajaj, If you want your OS users to log into your database, you need to set the OS_AUTHENT_PREFIX parameter in the init ora file for your instance to a string of your like. Oracles default is OPS$. If your OS user account is JOE. Oracle looks at this account as OPS$JOE. The account is tacked on the OS_AUTHENT_PREFIX. Then, you need to create the ORACLE user account that will correspond to your OS account and make it externally identified. As sys do the following: SQL create user OPS$JOE externally identified; Bear in mind that if you have and OS group called DBA, any member of that group will be able to connect as sysdba, so you need to be careful with the people you put in that group ;-- ) Regards, Julio -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED]] Sent: Friday, May 30, 2003 2:05 AM To: Multiple recipients of list ORACLE-L Subject: Need to Log on 2000 users Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj
RE: Need to Log on 2000 users
Sorry Munish, I misinterpreted your question. But Jared's suggestion is a good one. You can use orastack to set parameters to maximize memory use for your test database. And too, 128Gb sounds like a pretty large number for 2000 users! Julio -Original Message- Sent: Friday, May 30, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Jeremiah, Where do you get 128Gb? For 2000 users that is ~65M per user, which seems like an excessive estimate. While I probably wouldn't want to run 2k users on a single Windows server, I think you could do it for test purposes. Use orastack to reduce the memory per thread to 500k, set small sort_area_size, etc. Don't see why not. Jared On Friday 30 May 2003 02:14, Jeremiah Wilton wrote: You mean 2000 concurrent sessions? Why do you need to use dedicated server? Normally, you would accomplish this with Shared Server. You will need 128Gb of memory for the PGAs alone. Or you can use swap, but get ready to wait. Even that will probably be so slow that the connections may time out, or background thread IPC will time out, bringing the instance down. This seems like a silly exercise. Whose idea is it? Good luck with all that -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Munish Bajaj wrote: Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj -- 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: QuijadaReina, Julio C 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).
