Backup script giving error when run by cron
Hi gurus, Our database is running on Dynix in a Sequent machine. I tried to put the startup/shutdown script we use in crontab and schedule it. I call a script shut.sh which in turn will call the shutdown.sh script. But it gives me an error saying svrmgrl- not found. I've given here those scripts.. What am I missing?? This shut.sh is called by the cron shut.sh /data23/tbms/.profile /data21/app/oracle/admin/TBMS/dba/shutdown.sh >/data21/app/oracle/admin/TBMS/db a/shut.log 2>/data21/app/oracle/admin/TBMS/dba/shut.err - shutdown.sh --- ORACLE_SID=TBMS export ORACLE_SID INITIAL_STATUS=`ps -ef|grep "ora_[a-z]*_TBMS"|wc -l` echo $INITIAL_STATUS if [ $INITIAL_STATUS != 0 ]; then svrmgrl
Re: connecting to sqlplus within a shell script
Them's fightin' words pardner! You'd have to prove it, and I think that's a tough row to hoe. Jared :) On Wednesday 18 July 2001 12:23, Ray Stell wrote: -- OraTcl is much better ;-> === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- > On Wed, Jul 18, 2001 at 10:37:48AM -0800, [EMAIL PROTECTED] wrote: > > > For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! > > > > Gather all ye faithful down by the river, and ye shall > > be baptized into the kingdom of Perl and DBI, and never > > more shall ye want or toil in vain! > > > > Jared ( part time perl evangelist :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
No Subject
SET ORACLE-L DIGEST -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: New Listener Question
List, please correct me if I'm wrong, but I understand that you can define local listeners for the dynamic registration process to register with using the init.ora parameter LOCAL_LISTENER. This parameter identifies "local" listeners for the instance via a tnsnames.ora style format. It can contain multiple listener address to register with. For example: LOCAL_LISTENER = "(ADDRESS_LIST = (ADDRESS=(PROTOCOL=TCP)(HOST=db01.acme.com)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=db02.acme.com)(PORT=1521))(ADDRESS=(PROTOCOL=TC P)(HOST=db03.acme.com)(PORT=1521)))" Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 3:44 PM > Alex, you are correct. And that's how it worked in 8.1.6. > But due to some unknown 'feature' one has to explicitly set th > service_names and instance_name in the init .ora file as a workaround to be > able to use auto-register feature in 8.1.7. Again, only if using the default > listener name with default listener port#.. I have not yet tested this > stuff in 9.0.1 but will do in the very near future. > > Regards, > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 1:52 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: RE: New Listener Question > > > > instance_name has default value ORACLE_SID and service_name has default > > value db_name.db_domain - so you do not need to define these parameters > > for > > dynamic service registration. > > > > Alex Hillman > > > > -Original Message- > > Sent: Wednesday, July 18, 2001 2:25 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > Actually, it's called dynamic service registration and you need > > both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter > > defined in the init.ora. Then, when the instance starts up, it > > will register the services it supports with the listener(s). > > > > Jon Walthour > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour 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: Another programming standard falls
For a good read check out Steve Gibson's article on XP, "Why Windows XP will be the DOS Tool of Choice". http://grc.com/dos/winxp.htm - Ethan - http://ww.geocities.com/epost1 -Original Message- Sent: Wednesday, July 18, 2001 5:50 PM To: Multiple recipients of list ORACLE-L Plus the default security setting for their browser will now be HIGH instead of MEDIUM, which will disallow running Java applets, even if you do install a Java Virtual Machine. > > Microsoft dropping Java code from Windows XP > > In the wake of a January legal settlement with Java owner Sun > Microsystems, > Microsoft plans to ship its Windows XP operating system > without the code needed > to run Java applications. > > http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62358_NLTAM%2C00.html > -- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Training - CBT/Online
Exam Cram Guides (All 5) + Oracle8i Complete Reference +O8i Administrator's Guide + Oracle 8.1.6 on RedHat Linux 6.2 == EQUALS Cheap & Complete resource materials for training DBA's Also, check out www.databasedomain.com !! best, - jeremy -- 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).
Questions about Oracle World Wide Support
Dear DBA gurus, Could I ask you about the following questions: What are the benifits of having a support contract?what are the issues withnot having a support contract or what the risks do I have to take without the Support?What is it covering? I mean, Does it cover issues involved in our application systems? Your views and advice are vital for me. Thanks Chuan
RE: Another programming standard falls
Plus the default security setting for their browser will now be HIGH instead of MEDIUM, which will disallow running Java applets, even if you do install a Java Virtual Machine. > > Microsoft dropping Java code from Windows XP > > In the wake of a January legal settlement with Java owner Sun > Microsystems, > Microsoft plans to ship its Windows XP operating system > without the code needed > to run Java applications. > > http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62358_NLTAM%2C00.html > -- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Command History in SQL*PLUS
Yosi Greenfield wrote: > > Bill, > > I'm on NT and the up and down arrows work peachy! That's > one of the few things I don't miss about Unix. I didn't think > there was anything additional running on my pc to allow the > arrows to work, but they do for me. Hmm... > > Unless you're referring to the windows client. (I just thought > of this right before clicking 'send.') I use the DOS client in > a cmd window just for this reason. The Windows client doesn't > use the arrow keys, the DOS version does. > > Is that what you meant? yup, sorry i wasn't more specific. -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Command History in SQL*PLUS
Try CPAN. There's some free wrappers out there: "MyOracle" emulates MySQL but it's a bit clunky and has bad error handling on exit. "fsql" is written in C and is fast but has very limited login capability. It does not mimic MySQL's show tables command. "YASQL" (Yet another SQL) is also a Perl wrapper but it's not bad. Show tables works and the up arrow is OK. Has good login capability for SQL*Net but it echos passwords to the screen. The best approach is to just get over MySQL addiction and learn to love SQL*Plus with all it's shortcomings. :-) Steve Orr -Original Message- Sent: Wednesday, July 18, 2001 2:07 PM To: Multiple recipients of list ORACLE-L On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set -o vi' in a KSH) Check out a script #10 at http://www.orafaq.com/faqscrpt.htm#UNIX. It is wrapper for sqlplus and svrmgrl to do similar things. On NT, I guess use your arrow keys... (Not sure of that, though).. HTH, Regards. - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Rama Malladi [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 2:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Command History in SQL*PLUS > > Sometime ago there was a post on how to get the last commands executed > in SQL*Plus. It is very similar to doing escape from the UNIX command > line > > Do you know how to scroll down the last 10-20 commands executed in > SQL*Plus ? I am not talking about "/" which would get the last command. > > Rama > > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Apps customization help working with consultants
The attribute1 - 10 columns are standard Oracle Applications infrastructure. They are used to hold context sensitive information about the record. I also would worry about the use of serrogate keys (sequences) as a primary key. This is standard fare in most ER designs. What I would be concerned about is there lack of trying to keep you involved in the project as it is you who will have to support it in the future. Be kind, understanding, but very demanding about this one put. BTW, what shop is doing the implementation? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] "I'm too sexy for my code." - Awk Sed Fred KathyD@belkin .com To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Oracle Apps customization help working with consultants com 07/18/01 04:01 PM Please respond to ORACLE-L First some background We are running on Unix 8.1.6 with 11i Apps. I know very little about Oracle Apps and I am the first DBA hired in house who has walked into several projects mid streams that consultants are working on and they continue to exclude me from design meeting and I get little or no information about the project. A consulting group is customizing 11i Apps. Part of this involves an EDI application that will take in files load them into staging tables that then will be loaded into the appropriate 11i App table. There are various Oracle and Crystal Reports that will be extracting information from these tables as well. Why use both... go figure... they are using Crystal for some reports and Oracle Reports for others. Just like some of the screens are being done in Forms and some done in ASP. These custom EDI app tables have 10 attribute columns defined as varchar2(100) in the middle of the table. These are extra columns to that may be used in the future for what ever reason. I have asked these be removed and real column names and data types be added as needed. They refuse saying they will have to redesign the forms they have created to use with these tables. Isn't is reasonable that the Forms should also reflect real column names not Attribute 1...10? Isn't it better to add columns to tables as I need them with an appropriate name and data type? At the very least I asked that they put these columns at the end of the table. They have agreed to this. They are also using a lot of sequences for Primary Keys instead of using columns from the table that would make an intelligent primary key and would be unique. They also have many columns as NUMBER that could be defined as NUMBER(3) or NUMBER(4). Is there any pros or cons to using NUMBER without defining a data length? That is besides the obvious that NUMBER you don't have to worry about losing precision data precision. Also they use a lot of char(1) in defining what they think will only be one character fields. I was under the impression that it was better to use varchar2(1)? Any comments... This is probably a trivial issue but I would like to know people's opinions. I am just a bit brain dead from arguing with them anyway about using a consistence naming convention, including me on the database design, etc. Even with renaming a column I get "We are on a tight schedule and this would put us behind". Or this is how Oracle Apps works. My point is that Oracle Apps as a generic product and this EDI application shouldn't be made generic but specific to our company needs. That is not putting in this Attribute fields into all the
Re: Command History in SQL*PLUS
Bill, I'm on NT and the up and down arrows work peachy! That's one of the few things I don't miss about Unix. I didn't think there was anything additional running on my pc to allow the arrows to work, but they do for me. Hmm... Unless you're referring to the windows client. (I just thought of this right before clicking 'send.') I use the DOS client in a cmd window just for this reason. The Windows client doesn't use the arrow keys, the DOS version does. Is that what you meant? Yosi "Thater, William" wrote: > "Deshpande, Kirti" wrote: > > > On NT, I guess use your arrow keys... (Not sure of that, though).. > > nope, at least not with the 8.1.7 client. > > -- > Bill "Shrek" Thater Certifiable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > If a program is useful, it must be changed. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > 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). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield 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: Command History in SQL*PLUS
Under NT with sqlplus.exe you can use the arrow keys (that is the character version of sqlplus). I do not know how to do this with sqlplusw.exe - if anyone does it would be VERY appreciated. Regards, Bruce Reardon -Original Message- Sent: Thursday, 19 July 2001 6:26 "Deshpande, Kirti" wrote: > On NT, I guess use your arrow keys... (Not sure of that, though).. nope, at least not with the 8.1.7 client. -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).
Dump V$ to Excel and Upload to Web for Analysis...or not.
MS haters please ignore this I wrote a little app in Access 97 that will allow you to dump any table to Excel via ODBC. It also generates an index page in HTML format so you can FTP all the files to a web server for others to see. I think this will be useful for people that ask questions like "my database is slow please help". They can put a bunch of V$ and DBA table info in oneplace so we can actually get an idea of where the problem might be, of course we could just ignore them too but that wouldn't be nice. I'm sure there are many other applications for this. Enjoy. Thanks, Ethan http://www.geocities.com/epost1/excel_dump.htm -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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).
Oracle listener security patch -
Just installed p1859778_8162_Solaris patch for listener security problems. Before I installed it - everything was hunky-dory. Afterwards the listener wouldn't start any 'services'. Haven't tried metallink yet. Anybody had this problem? (Using 8.1.6.2 on Sun Solaris) TIA - john f. lewis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Apps customization help working with consultants
First some background We are running on Unix 8.1.6 with 11i Apps. I know very little about Oracle Apps and I am the first DBA hired in house who has walked into several projects mid streams that consultants are working on and they continue to exclude me from design meeting and I get little or no information about the project. A consulting group is customizing 11i Apps. Part of this involves an EDI application that will take in files load them into staging tables that then will be loaded into the appropriate 11i App table. There are various Oracle and Crystal Reports that will be extracting information from these tables as well. Why use both... go figure... they are using Crystal for some reports and Oracle Reports for others. Just like some of the screens are being done in Forms and some done in ASP. These custom EDI app tables have 10 attribute columns defined as varchar2(100) in the middle of the table. These are extra columns to that may be used in the future for what ever reason. I have asked these be removed and real column names and data types be added as needed. They refuse saying they will have to redesign the forms they have created to use with these tables. Isn't is reasonable that the Forms should also reflect real column names not Attribute 1...10? Isn't it better to add columns to tables as I need them with an appropriate name and data type? At the very least I asked that they put these columns at the end of the table. They have agreed to this. They are also using a lot of sequences for Primary Keys instead of using columns from the table that would make an intelligent primary key and would be unique. They also have many columns as NUMBER that could be defined as NUMBER(3) or NUMBER(4). Is there any pros or cons to using NUMBER without defining a data length? That is besides the obvious that NUMBER you don't have to worry about losing precision data precision. Also they use a lot of char(1) in defining what they think will only be one character fields. I was under the impression that it was better to use varchar2(1)? Any comments... This is probably a trivial issue but I would like to know people's opinions. I am just a bit brain dead from arguing with them anyway about using a consistence naming convention, including me on the database design, etc. Even with renaming a column I get "We are on a tight schedule and this would put us behind". Or this is how Oracle Apps works. My point is that Oracle Apps as a generic product and this EDI application shouldn't be made generic but specific to our company needs. That is not putting in this Attribute fields into all the EDI tables, using intelligent keys not sequence numbers, defining the data length of the NUMBER Fields. I am really worried about performance since I will have to maintain this in January after they are long gone. Any help or suggestions would be appreciated. Any good books to get me quickly up to speed on how to tune Oracle Apps? Thanks very much. Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret 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).
sort segments
Are there any circumstances when temporary tablespace can contain more than 1 sort segment? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle high availability
I would check out the Veritas suite of products. We have several 24x7 high availability OLTP databases and are using Veritas Database Edition HA (High Availability), which includes several Veritas products bundled together that are well integrated with Oracle to provide continuous services and database failover and restoral in the event of hardware or software failure. You may also want to look into Oracle Parallel Server (8i, 8 and 7), or 9i Real Application Clusters if you're deploying with 9i. Defry - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 8:25 PM > I'm new to the list and was recently assigned working on Oracle high > availability for NT and HP-UX > platforms. We have Oracle 8 currently running in production but my research > should show all options > including 9i. Any research, urls, white papers, recommendations or > implementations are greatly > appreciated. > > Jessie > > -- > 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: Mustafa 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: OEM help ???
You don't want to remove the entire Oracle home from the registry UNLESS you are willing to remove all remnants of Oracle, files and registry entries for 8.1.5 and anything else you may have installed and then reinstall the components you need. OEM 816 (release 2.1?) will work with other versions of databases for administrative purposes, but you must have an 8.1.6 database for the OEM repository. Defry - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 3:15 PM > Andrea > > Remove the oracle home from the registry > regedit or reg32 > > > HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE > > --- Andrea Oracle <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I installed OEM816 on NT40, database server is 815 > > on > > Sun 5.6. The OEM doesn't run since OMS NT service > > cannot be started for some reason. I tried to > > deinstalled OEM using installer, the deinstalling > > only > > runs for 2% and jumpped out. So I manually removed > > all the OEM files, and tried to install again. Now > > the installer told me that "you cannot install this > > since it's already in oem home directory." and the > > Installed Products still shows all the OEM products, > > even though I already got rid off the whole oem > > home. > > > > Are there anything log in the registry or some other > > places that I should clean out? And does OEM816 > > works > > well with 815 database?? Thanks. > > > > Andrea > > > > > > __ > > Do You Yahoo!? > > Get personalized email addresses from Yahoo! Mail > > http://personal.mail.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Andrea Oracle > > 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!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: k johnson > 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: Mustafa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to run agent ???
Hi, Thank you for all those answering my question. I got OEM installed and it seems to work fine. I run lsnrctl dbsnmp_start on one box, it got started; but on some other box, I got "Tcl_RegisterChannel: duplicate channel names", and when I do lsnrctl dbsnmp_status, it shows The db subagent is not started. What does that error mean, and how to debug it? OS: Sun 5.6, database 815, OEM 204. Thanks. Andrea --- Andrea Oracle <[EMAIL PROTECTED]> wrote: > Hi all, > > I installed OEM816 on NT40, database server is 815 > on > Sun 5.6. The OEM doesn't run since OMS NT service > cannot be started for some reason. I tried to > deinstalled OEM using installer, the deinstalling > only > runs for 2% and jumpped out. So I manually removed > all the OEM files, and tried to install again. Now > the installer told me that "you cannot install this > since it's already in oem home directory." and the > Installed Products still shows all the OEM products, > even though I already got rid off the whole oem > home. > > Are there anything log in the registry or some other > places that I should clean out? And does OEM816 > works > well with 815 database?? Thanks. > > Andrea > > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ > __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
OT: Quest Software Product Query
Hi All. We just had some folks here from Quest software showing us their 'Live Reorg' product. Does anybody out there use...or not...this product? If you have experience or recommendations or horror stories I'd like to hear them. Please e-mail me privately ; this traffic doesn't need to clog up the list. My address is [EMAIL PROTECTED] Thanks, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Command History in SQL*PLUS
There is a SQL command history, actually, there is more then one. SQL command history can be found in v$sql,v$sqlarea and v$sqltext. > -Original Message- > From: Thater, William [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 4:26 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Command History in SQL*PLUS > > > "Deshpande, Kirti" wrote: > > > On NT, I guess use your arrow keys... (Not sure of that, though).. > > nope, at least not with the 8.1.7 client. > > > -- > Bill "Shrek" Thater Certifiable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > If a program is useful, it must be changed. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > 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: Gogala, Mladen 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: connecting to sqlplus within a shell script
I have an stty erase ^H in my login.sql file which may be causing the problem... h thanks for all of your responses Reed -Original Message- Sent: Wednesday, July 18, 2001 1:08 PM To: Multiple recipients of list ORACLE-L Everytime I have seen this message it was because there was a . $HOME/.profile to ensure that the environment was correct and because the script was run from a cron. By the way, there was stty erase ^H in .profile. . $HOME/.profile 2>/dev/null fudged the problem. HTH, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- Steve Sapovits wrote: > > SQL*Plus is probably performing terminal specific ioctl settings; > e.g., setting it in something other than line mode so it can update > the screen more efficiently, etc. > > For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! > > > Steve Sapovits > Global Sports Interactive > Work Email: [EMAIL PROTECTED] > Home Email: [EMAIL PROTECTED] > Work Phone: 610-491-7087 > Cell: 610-574-7706 > Pager: 877-239-4003 > > > -Original Message- > > From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 1:41 PM > > To: Multiple recipients of list ORACLE-L > > Subject: connecting to sqlplus within a shell script > > > > I use a lot of shell scripts (korn mainly) which use connections to > > sqlplus > > and always seem to get this error message when the script logs into > > sqlplus: > > stty: standard input: Inappropriate ioctl for device > > > > Here is my connection procedure within the script: sqlplus -s > > sitemon/sitemon << END > > > > To my knowledge it does not appear to cause any problems with my shell > > script or output but would really like to know why I am getting it and if > > there is any recommendations for fixing the problem. > > > > OS: Red Hat Linux 6.2 > > ORACLE: 8.1.7 standard edition > > shell: korn > > > > Any help would be appreciated > > > > thanks > > > > Reed > > > > -- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Kempf, Reed 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: Command History in SQL*PLUS
"Deshpande, Kirti" wrote: > On NT, I guess use your arrow keys... (Not sure of that, though).. nope, at least not with the 8.1.7 client. -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Command History in SQL*PLUS
On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set -o vi' in a KSH) Check out a script #10 at http://www.orafaq.com/faqscrpt.htm#UNIX. It is wrapper for sqlplus and svrmgrl to do similar things. On NT, I guess use your arrow keys... (Not sure of that, though).. HTH, Regards. - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Rama Malladi [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 2:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Command History in SQL*PLUS > > Sometime ago there was a post on how to get the last commands executed > in SQL*Plus. It is very similar to doing escape from the UNIX command > line > > Do you know how to scroll down the last 10-20 commands executed in > SQL*Plus ? I am not talking about "/" which would get the last command. > > Rama > > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: New Listener Question
Alex, you are correct. And that's how it worked in 8.1.6. But due to some unknown 'feature' one has to explicitly set the service_names and instance_name in the init .ora file as a workaround to be able to use auto-register feature in 8.1.7. Again, only if using the default listener name with default listener port#.. I have not yet tested this stuff in 9.0.1 but will do in the very near future. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 1:52 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: New Listener Question > > instance_name has default value ORACLE_SID and service_name has default > value db_name.db_domain - so you do not need to define these parameters > for > dynamic service registration. > > Alex Hillman > > -Original Message- > Sent: Wednesday, July 18, 2001 2:25 PM > To: Multiple recipients of list ORACLE-L > > > > > Actually, it's called dynamic service registration and you need > both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter > defined in the init.ora. Then, when the instance starts up, it > will register the services it supports with the listener(s). > > Jon Walthour > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New Listener Question
According to the doc, the default value for service_names is db_name.db_domain. Shouldn't the default value be sufficient? (I haven't actually tried it yet). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth 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).
Command History in SQL*PLUS
Sometime ago there was a post on how to get the last commands executed in SQL*Plus. It is very similar to doing escape from the UNIX command line Do you know how to scroll down the last 10-20 commands executed in SQL*Plus ? I am not talking about "/" which would get the last command. Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi 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).
MTS on Linux
Dears First I would like to thank you all for replies about tracing - it helped me very much Now I have a different problem - I have Linux (suse 7.0) with oracle 8.1.7EE and with 2 IP addresses and I want to have MTS server running. The server allways connects to the listener as a dedicated server and not as dispatcher (lsnrctl services). I have opened TAR but they are not able to help me (TAR opened since 18.6). I have tried a lot of things in init.ora and listener.ora files but it didnt help. Is there somebody who has the same configuration and whith MTS running? If yes, would you be so kind and send me your configuration files (or part with MTS config), please? Thank you in advance Ivo this is my MTS part of init.ora file #mts_max_dispatchers=10 #mts_max_servers=10 #mts_servers=3 #mts_listener_address="(ADDRESS=(PROTOCOL=TCP)(HOST=10.17.150.5)(PORT=1521)) " #large_pool_size = 1000 #MTS_DISPATCHERS="(ADDRESS=(PARTIAL=TRUE)(PROTOCOL=TCP)\ #(HOST=10.17.150.5)(PORT=12345))(DISPATCHERS=2)" mts_servers=3 mts_dispatchers="(PRO=TCP)(DISP=3)(LIS=awms)" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo 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: connecting to sqlplus within a shell script
You could add logic to .profile to execute stty only if the session is
attached to a terminal.
# set env based on terminal or non-terminal
if [ -t 0 ]
then
# if executing from terminal process
stty istrip
stty erase "^h" kill "^u" intr "^c"
PATH=${PATH}:/${HOME}/tools/bin ; export PATH
. ${HOME}/bin/sid # set Oracle env
THISHOST=`uname -n` ; export THISHOST
PS1='${THISHOST}-${LOGNAME}:${ORACLE_SID}:${PWD}> '
SQLPATH=${HOME}/tools/sql ; export SQLPATH
EDITOR=vi ; export EDITOR
PATH=${PATH}:${ORACLE_HOME}/bin:/usr/local/bin:/usr/local/ssh/bin ;
export PATH
else
# if executing from non-terminal process, eg., cron
ORACLE_HOME=/opt/app/oracle/product/8.1.7 ; export ORACLE_HOME
PATH=${PATH}:${ORACLE_HOME}/bin ; export PATH
fi
Erik Williams wrote:
>
> Are you doing an su before running SQL plus? I have run into problems in my
> .profile script when su-ing before running SQLPlus in a script. In my case,
> I was trying to run STTY to change my erase key in the .profile. Just a
> thought.
>
> Erik
>
> > -Original Message-
> > From: Steve Sapovits [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 18, 2001 1:52 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: connecting to sqlplus within a shell script
> >
> >
> > SQL*Plus is probably performing terminal specific ioctl settings;
> > e.g., setting it in something other than line mode so it can update
> > the screen more efficiently, etc.
> >
> > For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks!
> >
> >
> > Steve Sapovits
> > Global Sports Interactive
> > Work Email: [EMAIL PROTECTED]
> > Home Email: [EMAIL PROTECTED]
> > Work Phone: 610-491-7087
> > Cell: 610-574-7706
> > Pager: 877-239-4003
> >
> > > -Original Message-
> > > From: Kempf, Reed [SMTP:[EMAIL PROTECTED]]
> > > Sent: Wednesday, July 18, 2001 1:41 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject:connecting to sqlplus within a shell script
> > >
> > > I use a lot of shell scripts (korn mainly) which use connections to
> > > sqlplus
> > > and always seem to get this error message when the script logs into
> > > sqlplus:
> > > stty: standard input: Inappropriate ioctl for device
> > >
> > > Here is my connection procedure within the script: sqlplus -s
> > > sitemon/sitemon << END
> > >
> > > To my knowledge it does not appear to cause any problems with my shell
> > > script or output but would really like to know why I am getting it and
> > if
> > > there is any recommendations for fixing the problem.
> > >
> > > OS: Red Hat Linux 6.2
> > > ORACLE: 8.1.7 standard edition
> > > shell: korn
> > >
> > > Any help would be appreciated
> > >
> > > thanks
> > >
> > > Reed
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Kempf, Reed
> > > 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: Steve Sapovits
> > 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: Erik Williams
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
A
Re: connecting to sqlplus within a shell script
On Wed, Jul 18, 2001 at 10:37:48AM -0800, [EMAIL PROTECTED] wrote: > > > For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! > > Gather all ye faithful down by the river, and ye shall > be baptized into the kingdom of Perl and DBI, and never > more shall ye want or toil in vain! > > Jared ( part time perl evangelist :) -- OraTcl is much better ;-> === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
Another programming standard falls
Microsoft dropping Java code from Windows XP In the wake of a January legal settlement with Java owner Sun Microsystems, Microsoft plans to ship its Windows XP operating system without the code needed to run Java applications. http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62358_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OEM help ???
Andrea Remove the oracle home from the registry regedit or reg32 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE --- Andrea Oracle <[EMAIL PROTECTED]> wrote: > Hi all, > > I installed OEM816 on NT40, database server is 815 > on > Sun 5.6. The OEM doesn't run since OMS NT service > cannot be started for some reason. I tried to > deinstalled OEM using installer, the deinstalling > only > runs for 2% and jumpped out. So I manually removed > all the OEM files, and tried to install again. Now > the installer told me that "you cannot install this > since it's already in oem home directory." and the > Installed Products still shows all the OEM products, > even though I already got rid off the whole oem > home. > > Are there anything log in the registry or some other > places that I should clean out? And does OEM816 > works > well with 815 database?? Thanks. > > Andrea > > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Andrea Oracle > 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!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k johnson 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: connecting to sqlplus within a shell script
Everytime I have seen this message it was because there was a . $HOME/.profile to ensure that the environment was correct and because the script was run from a cron. By the way, there was stty erase ^H in .profile. . $HOME/.profile 2>/dev/null fudged the problem. HTH, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- Steve Sapovits wrote: > > SQL*Plus is probably performing terminal specific ioctl settings; > e.g., setting it in something other than line mode so it can update > the screen more efficiently, etc. > > For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! > > > Steve Sapovits > Global Sports Interactive > Work Email: [EMAIL PROTECTED] > Home Email: [EMAIL PROTECTED] > Work Phone: 610-491-7087 > Cell: 610-574-7706 > Pager: 877-239-4003 > > > -Original Message- > > From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 1:41 PM > > To: Multiple recipients of list ORACLE-L > > Subject: connecting to sqlplus within a shell script > > > > I use a lot of shell scripts (korn mainly) which use connections to > > sqlplus > > and always seem to get this error message when the script logs into > > sqlplus: > > stty: standard input: Inappropriate ioctl for device > > > > Here is my connection procedure within the script: sqlplus -s > > sitemon/sitemon << END > > > > To my knowledge it does not appear to cause any problems with my shell > > script or output but would really like to know why I am getting it and if > > there is any recommendations for fixing the problem. > > > > OS: Red Hat Linux 6.2 > > ORACLE: 8.1.7 standard edition > > shell: korn > > > > Any help would be appreciated > > > > thanks > > > > Reed > > > > -- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
OEM nmi.log file growing
We have shutdown one of our databases for extended maintenance. The nmi.log is growing about 1k per minute with the following messages. Short of removing the database from the listener, which I do not really want to do since the database will eventually be brought back up, how can I stop the messages. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
* Oracle Financials DBA Needed in Houston..
Major Houston company needs a Sr. Level Oracle Financials DBA to join its' I.T. staff. Requirements: -Must have 3+ yrs Oracle Financials DBA experience. -Looking for someone who has at least 18 months Fin. Apps. installations experience -U.S. citizenship or permanent residency. This company offers: -Competitive Salary with full benefits -Company will pay relocation NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: OraStaff, Inc. Ph: 1-800-549-8502-Please do not call if you need sponsorship Email: [EMAIL PROTECTED] Please use job code: One/Fin DBA/Houston/Pottle/Sanders Note: This is only one of the many opportunities that we have available across the U.S. for candidates with Oracle skills who are U.S. citizens or permanent residents. So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking. We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for you. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: OT: Certifications
"Post, Ethan" wrote: > > Well I have to say the IBM WebSphere Cert and Sun Java Programmer Cert are > infinitely easier than the Oracle OCP. I have received them both in the > mail recently and never taken any of the tests! This is strange, I think > someone has stolen my identity and is doing a better job at living my life > than me! > > - Ethan > Some are born gurus, some achieve certification, and some have certification thrust upon them :). -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: New Listener Question
instance_name has default value ORACLE_SID and service_name has default value db_name.db_domain - so you do not need to define these parameters for dynamic service registration. Alex Hillman -Original Message- Sent: Wednesday, July 18, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Actually, it's called dynamic service registration and you need both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter defined in the init.ora. Then, when the instance starts up, it will register the services it supports with the listener(s). Jon Walthour >--- Original Message --- >From: Glenn Travis <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/18/01 12:21:24 PM > >I disagree. Mine only registers itself if I have the "service_names" entry >in the init.ora file. Comment this line out and see what happens... > >-Original Message- >Smith >Sent: Tuesday, July 17, 2001 1:31 PM >To: Multiple recipients of list ORACLE-L > > >In Oracle 8i a database will self register with the default listener >even if you do not have it defined. There are parameters that you >can put in your init.ora to prevent this. > >-Original Message- >Sent: Tuesday, July 17, 2001 9:35 AM >To: Multiple recipients of list ORACLE-L > > >First Off, I would like to thank everyone who replied yesterday, your >answers were most helpful! > >Today, I am facing a new puzzle. I am currently running 3 databases on a >server, but only two of them are listed in the listener.ora (bdw and rcvr). >If I do a 'lsnrctl status' it shows a listener for all three databases (bdw >rcvr and webprod). How is this possible? I have included my current >listener.ora and output from 'lsnrctl status' ... Also, people who access >these databases go through VIRTUAL ip's, i.e. the box itself has IP address >xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod ip is >xxx.xxx.xxx.30 >The reason for the virt ip's is for the fail over we have in place, so >people do not have to reconfigure their machines when we move the databases >around. > >So by all rights I do not see how anyone can connect, but they are?!?!?!? >WTH??? > >Thanks again guys ... > ># LISTENER.ORA Configuration >File:/apps/oracle/product/816/network/admin/listener.ora ># Generated by Oracle configuration tools. > >LISTENER = > (DESCRIPTION_LIST = >(DESCRIPTION = > (ADDRESS_LIST = >(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > ) > (ADDRESS_LIST = >(ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521)) > ) >) >(DESCRIPTION = > (PROTOCOL_STACK = >(PRESENTATION = GIOP) >(SESSION = RAW) > ) > (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481)) >) > ) > >SID_LIST_LISTENER = > (SID_LIST = >(SID_DESC = > (SID_NAME = PLSExtProc) > (ORACLE_HOME = /apps/oracle/product/816) > (PROGRAM = extproc) >) >(SID_DESC = > (GLOBAL_DBNAME = bdw) > (ORACLE_HOME = /apps/oracle/product/816) > (SID_NAME = bdw) >) >(SID_DESC = > (GLOBAL_DBNAME = rcvr) > (ORACLE_HOME = /apps/oracle/product/816) > (SID_NAME = rcvr) >) > ) > >oracle@bdw1 SID: bdw /apps/oracle/product/816/network/admin > lsnrctl status > >LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001 09:24:30 > >(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. > >Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) >STATUS of the LISTENER > >Alias LISTENER >Version TNSLSNR for Solaris: Version 8.1.6.0.0 - >Production >Start Date10-JUL-2001 15:14:01 >Uptime6 days 18 hr. 10 min. 30 sec >Trace Level off >Security OFF >SNMP OFF >Listener Parameter File >/apps/oracle/product/816/network/admin/listener.ora >Listener Log File /apps/oracle/product/816/network/log/listener.log >Services Summary... > PLSExtProchas 1 service handler(s) > WEBPROD has 2 service handler(s) > bdw has 1 service handler(s) > bdw has 1 service handler(s) > rcvr has 1 service handler(s) >The command completed successfully > >-- >Edward W. Carr >UNIX Systems Administrator >Qwest Communications >Broadband Services Inc. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Kimberly Smith > 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
Re: connecting to sqlplus within a shell script
[EMAIL PROTECTED] wrote: > > > For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! > > Gather all ye faithful down by the river, and ye shall > be baptized into the kingdom of Perl and DBI, and never > more shall ye want or toil in vain! > > Jared ( part time perl evangelist :) can you preach to my SAs to install it and let me have access to it? they tell me perl is an SA tool and i don't need it.:-( -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: OEM help ???
Hi Andrea, Look for the oraInventory file. The installer reads this file for information on installed products. Find the file then delete the OEM entries. There are probably some registry entries that need to be removed so search the registry for references to OEM. HTH, -Rocky --- Andrea Oracle <[EMAIL PROTECTED]> wrote: > Hi all, > > I installed OEM816 on NT40, database server is 815 on > Sun 5.6. The OEM doesn't run since OMS NT service > cannot be started for some reason. I tried to > deinstalled OEM using installer, the deinstalling only > runs for 2% and jumpped out. So I manually removed > all the OEM files, and tried to install again. Now > the installer told me that "you cannot install this > since it's already in oem home directory." and the > Installed Products still shows all the OEM products, > even though I already got rid off the whole oem home. > > Are there anything log in the registry or some other > places that I should clean out? And does OEM816 works > well with 815 database?? Thanks. > > Andrea > > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrea Oracle > 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!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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: connecting to sqlplus within a shell script
> For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Gather all ye faithful down by the river, and ye shall be baptized into the kingdom of Perl and DBI, and never more shall ye want or toil in vain! Jared ( part time perl evangelist :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: connecting to sqlplus within a shell script
If you code the stty command like the following - [ -t 1 ] && stty erase It works both interactively & via cron jobs. HTH & YMMV! Erik Williams wrote: > > Are you doing an su before running SQL plus? I have run into problems in my > .profile script when su-ing before running SQLPlus in a script. In my case, > I was trying to run STTY to change my erase key in the .profile. Just a > thought. > > Erik > > > -Original Message- > > From: Steve Sapovits [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 1:52 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: connecting to sqlplus within a shell script > > > > > > SQL*Plus is probably performing terminal specific ioctl settings; > > e.g., setting it in something other than line mode so it can update > > the screen more efficiently, etc. > > > > For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! > > > > > > Steve Sapovits > > Global Sports Interactive > > Work Email: [EMAIL PROTECTED] > > Home Email: [EMAIL PROTECTED] > > Work Phone: 610-491-7087 > > Cell: 610-574-7706 > > Pager: 877-239-4003 > > > > > -Original Message- > > > From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] > > > Sent: Wednesday, July 18, 2001 1:41 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject:connecting to sqlplus within a shell script > > > > > > I use a lot of shell scripts (korn mainly) which use connections to > > > sqlplus > > > and always seem to get this error message when the script logs into > > > sqlplus: > > > stty: standard input: Inappropriate ioctl for device > > > > > > Here is my connection procedure within the script: sqlplus -s > > > sitemon/sitemon << END > > > > > > To my knowledge it does not appear to cause any problems with my shell > > > script or output but would really like to know why I am getting it and > > if > > > there is any recommendations for fixing the problem. > > > > > > OS: Red Hat Linux 6.2 > > > ORACLE: 8.1.7 standard edition > > > shell: korn > > > > > > Any help would be appreciated > > > > > > thanks > > > > > > Reed > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Kempf, Reed > > > 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: Steve Sapovits > > 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: Erik Williams > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Certifications
Now that's disconcerting! Chuck Speaks Database Administrator Lithonia Lighting 770-861-3450 http://www.lithonia.com -Original Message- Sent: Wednesday, July 18, 2001 1:32 PM To: Multiple recipients of list ORACLE-L Well I have to say the IBM WebSphere Cert and Sun Java Programmer Cert are infinitely easier than the Oracle OCP. I have received them both in the mail recently and never taken any of the tests! This is strange, I think someone has stolen my identity and is doing a better job at living my life than me! - Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Speaks, Chuck W. 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: New Listener Question
You are right, sir! I stand corrected. and thanks! -Original Message- Wilton Sent: Wednesday, July 18, 2001 1:48 PM To: Multiple recipients of list ORACLE-L On Wed, 18 Jul 2001, Glenn Travis wrote: > I disagree. Mine only registers itself if I have the "service_names" entry > in the init.ora file. Comment this line out and see what happens... Actually, the parameter that controls instance registration with listeners for dedicated server is LOCAL_LISTENER. The default value for this parameter is "(ADDRESS = (PROTOCOL=TCP)(HOST=)(PORT=1521))." That means that even if you don't set LOCAL_LISTENER, any instance will try to register with any listener running on port 1521 on the localhost. SERVICE_NAMES allows you to specify multiple differently named databases as a single 'service' for clients, but does not change which listeners the instance registers with. This information can be found in TFM, at the following URLs: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76961/ch176.htm http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/network.817 /a76933/concepts.htm#1036732 >From the "Net8 Administrator's Guide, Release 8.1.6:" "By default, PMON registers with the local listener on server at the default local address of TCP/IP, port 1521." -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > > -Original Message- > Smith > > In Oracle 8i a database will self register with the default listener > even if you do not have it defined. There are parameters that you > can put in your init.ora to prevent this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Procedure Builder - Seeing variables
Eriovaldo, Check on the object navigator and expand the node with the 'Stack' and you should see your variables there. Also, from the menu you can select 'View'>>'Navigator Pane' and this will show the object navigator in the center of the PL/SQL Interpreter. Regards, Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: New Listener Question
Actually, it's called dynamic service registration and you need both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter defined in the init.ora. Then, when the instance starts up, it will register the services it supports with the listener(s). Jon Walthour >--- Original Message --- >From: Glenn Travis <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/18/01 12:21:24 PM > >I disagree. Mine only registers itself if I have the "service_names" entry >in the init.ora file. Comment this line out and see what happens... > >-Original Message- >Smith >Sent: Tuesday, July 17, 2001 1:31 PM >To: Multiple recipients of list ORACLE-L > > >In Oracle 8i a database will self register with the default listener >even if you do not have it defined. There are parameters that you >can put in your init.ora to prevent this. > >-Original Message- >Sent: Tuesday, July 17, 2001 9:35 AM >To: Multiple recipients of list ORACLE-L > > >First Off, I would like to thank everyone who replied yesterday, your >answers were most helpful! > >Today, I am facing a new puzzle. I am currently running 3 databases on a >server, but only two of them are listed in the listener.ora (bdw and rcvr). >If I do a 'lsnrctl status' it shows a listener for all three databases (bdw >rcvr and webprod). How is this possible? I have included my current >listener.ora and output from 'lsnrctl status' ... Also, people who access >these databases go through VIRTUAL ip's, i.e. the box itself has IP address >xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod ip is >xxx.xxx.xxx.30 >The reason for the virt ip's is for the fail over we have in place, so >people do not have to reconfigure their machines when we move the databases >around. > >So by all rights I do not see how anyone can connect, but they are?!?!?!? >WTH??? > >Thanks again guys ... > ># LISTENER.ORA Configuration >File:/apps/oracle/product/816/network/admin/listener.ora ># Generated by Oracle configuration tools. > >LISTENER = > (DESCRIPTION_LIST = >(DESCRIPTION = > (ADDRESS_LIST = >(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > ) > (ADDRESS_LIST = >(ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521)) > ) >) >(DESCRIPTION = > (PROTOCOL_STACK = >(PRESENTATION = GIOP) >(SESSION = RAW) > ) > (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481)) >) > ) > >SID_LIST_LISTENER = > (SID_LIST = >(SID_DESC = > (SID_NAME = PLSExtProc) > (ORACLE_HOME = /apps/oracle/product/816) > (PROGRAM = extproc) >) >(SID_DESC = > (GLOBAL_DBNAME = bdw) > (ORACLE_HOME = /apps/oracle/product/816) > (SID_NAME = bdw) >) >(SID_DESC = > (GLOBAL_DBNAME = rcvr) > (ORACLE_HOME = /apps/oracle/product/816) > (SID_NAME = rcvr) >) > ) > >oracle@bdw1 SID: bdw /apps/oracle/product/816/network/admin > lsnrctl status > >LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001 09:24:30 > >(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. > >Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) >STATUS of the LISTENER > >Alias LISTENER >Version TNSLSNR for Solaris: Version 8.1.6.0.0 - >Production >Start Date10-JUL-2001 15:14:01 >Uptime6 days 18 hr. 10 min. 30 sec >Trace Level off >Security OFF >SNMP OFF >Listener Parameter File >/apps/oracle/product/816/network/admin/listener.ora >Listener Log File /apps/oracle/product/816/network/log/listener.log >Services Summary... > PLSExtProchas 1 service handler(s) > WEBPROD has 2 service handler(s) > bdw has 1 service handler(s) > bdw has 1 service handler(s) > rcvr has 1 service handler(s) >The command completed successfully > >-- >Edward W. Carr >UNIX Systems Administrator >Qwest Communications >Broadband Services Inc. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Kimberly Smith > 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: Glenn Travis > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego,
OEM help ???
Hi all, I installed OEM816 on NT40, database server is 815 on Sun 5.6. The OEM doesn't run since OMS NT service cannot be started for some reason. I tried to deinstalled OEM using installer, the deinstalling only runs for 2% and jumpped out. So I manually removed all the OEM files, and tried to install again. Now the installer told me that "you cannot install this since it's already in oem home directory." and the Installed Products still shows all the OEM products, even though I already got rid off the whole oem home. Are there anything log in the registry or some other places that I should clean out? And does OEM816 works well with 815 database?? Thanks. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: connecting to sqlplus within a shell script
Are you doing an su before running SQL plus? I have run into problems in my .profile script when su-ing before running SQLPlus in a script. In my case, I was trying to run STTY to change my erase key in the .profile. Just a thought. Erik > -Original Message- > From: Steve Sapovits [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 1:52 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: connecting to sqlplus within a shell script > > > SQL*Plus is probably performing terminal specific ioctl settings; > e.g., setting it in something other than line mode so it can update > the screen more efficiently, etc. > > For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! > > > Steve Sapovits > Global Sports Interactive > Work Email: [EMAIL PROTECTED] > Home Email: [EMAIL PROTECTED] > Work Phone: 610-491-7087 > Cell: 610-574-7706 > Pager: 877-239-4003 > > > -Original Message- > > From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 1:41 PM > > To: Multiple recipients of list ORACLE-L > > Subject:connecting to sqlplus within a shell script > > > > I use a lot of shell scripts (korn mainly) which use connections to > > sqlplus > > and always seem to get this error message when the script logs into > > sqlplus: > > stty: standard input: Inappropriate ioctl for device > > > > Here is my connection procedure within the script: sqlplus -s > > sitemon/sitemon << END > > > > To my knowledge it does not appear to cause any problems with my shell > > script or output but would really like to know why I am getting it and > if > > there is any recommendations for fixing the problem. > > > > OS: Red Hat Linux 6.2 > > ORACLE: 8.1.7 standard edition > > shell: korn > > > > Any help would be appreciated > > > > thanks > > > > Reed > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kempf, Reed > > 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: Steve Sapovits > 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: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: security problem with 8i
My old job had never changed any of the default passwords. And the reason why standard passwords are kept is because it is 'easy to remember'. Go figure... -Original Message- Sent: Wednesday, July 18, 2001 1:48 PM To: Multiple recipients of list ORACLE-L Not at all. Just last week I had a vendor who came in to install a package. They were very upset because SYS didn't have the "standard" password and their install script wouldn't work. I questioned their use of the SYS schema for the installation but powers wiser than me had me change the SYS password to the "standard" value and leave the room. Hey, it's a job. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Re[2]: security problem with 8i
In my book, it was a job. Reply Separator Author: [EMAIL PROTECTED] Date: 7/18/2001 9:48 AM Not at all. Just last week I had a vendor who came in to install a package. They were very upset because SYS didn't have the "standard" password and their install script wouldn't work. I questioned their use of the SYS schema for the installation but powers wiser than me had me change the SYS password to the "standard" value and leave the room. Hey, it's a job. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: connecting to sqlplus within a shell script
SQL*Plus is probably performing terminal specific ioctl settings; e.g., setting it in something other than line mode so it can update the screen more efficiently, etc. For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 > -Original Message- > From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 1:41 PM > To: Multiple recipients of list ORACLE-L > Subject: connecting to sqlplus within a shell script > > I use a lot of shell scripts (korn mainly) which use connections to > sqlplus > and always seem to get this error message when the script logs into > sqlplus: > stty: standard input: Inappropriate ioctl for device > > Here is my connection procedure within the script: sqlplus -s > sitemon/sitemon << END > > To my knowledge it does not appear to cause any problems with my shell > script or output but would really like to know why I am getting it and if > there is any recommendations for fixing the problem. > > OS: Red Hat Linux 6.2 > ORACLE: 8.1.7 standard edition > shell: korn > > Any help would be appreciated > > thanks > > Reed > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kempf, Reed > 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: Steve Sapovits 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: New Listener Question
On Wed, 18 Jul 2001, Glenn Travis wrote: > I disagree. Mine only registers itself if I have the "service_names" entry > in the init.ora file. Comment this line out and see what happens... Actually, the parameter that controls instance registration with listeners for dedicated server is LOCAL_LISTENER. The default value for this parameter is "(ADDRESS = (PROTOCOL=TCP)(HOST=)(PORT=1521))." That means that even if you don't set LOCAL_LISTENER, any instance will try to register with any listener running on port 1521 on the localhost. SERVICE_NAMES allows you to specify multiple differently named databases as a single 'service' for clients, but does not change which listeners the instance registers with. This information can be found in TFM, at the following URLs: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch176.htm http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/network.817/a76933/concepts.htm#1036732 >From the "Net8 Administrator's Guide, Release 8.1.6:" "By default, PMON registers with the local listener on server at the default local address of TCP/IP, port 1521." -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > > -Original Message- > Smith > > In Oracle 8i a database will self register with the default listener > even if you do not have it defined. There are parameters that you > can put in your init.ora to prevent this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: I still can't install Oracle on Linux - help
The Java that comes with Oracle is broke. Sorry. Here's how you can make it work, at least it did for me using SuSE 7.1 and Oracle 8.1.7. Get the 1.1.8 Java from www.blackdown.org Here's where my ORACLE_HOME/JRE points: lrwxrwxrwx1 oracle dba34 Apr 18 17:52 /u02/app/oracle/product/8.1.7/JRE -> /u02/app/oracle/product/jre /1.1.8/ So in my case, I would go to /u02/app/oracle/product/jre and perform the following: rename your oracle 1.1.8 directory to 1.1.8.oracle install blackdown to 1.1.8.blackdown create a virtual link from blackdown to 1.1.8 ln -s 1.1.8.blackdown 1.1.8 now your $ORACLE_HOME/JRE points to /u02/app/oracle/product/jre /1.1.8.blackdown/ Here's what my directory looks like: 9:44-sherlock:ts01:jkstill-6 > l total 28 drwxr-xr-x5 oracle dba 4096 May 26 11:32 ./ drwxrwxr-x6 oracle dba 4096 Apr 18 23:29 ../ lrwxrwxrwx1 oracle dba15 May 26 11:32 1.1.8 -> 1.1.8.blackdown/ drwxr-xr-x4 oracle dba 4096 Apr 18 17:52 1.1.8.blackdown/ drwxr-xr-x4 oracle dba 4096 Apr 18 17:51 1.1.8.oracle/ drwxr-xr-x6 oracle dba 4096 Apr 18 17:51 3.0.02/ -rw-r--r--1 oracle dba 7142 May 14 00:27 javacore16556.txt You will also need the patch for SuSE 7.1. It's available at http://technet.oracle.com/software/products/oracle8i/software_index.htm You need to click on the 8.1.7 for Linux link, go through the license page. You will find the patch on the download page. Jared Csillag Zsolt rware.hu>cc: Sent by: Subject: I still can't install Oracle on Linux - help [EMAIL PROTECTED] om 07/18/01 09:30 AM Please respond to ORACLE-L Hi, I have the following environment: Suse 7.1, Oracle 8.1.6, 256 Mb Ram, KDE, Java runtime (I hope I installed it correctly). When I run the Installer from Kde, it makes nothing, but if I run from terminal window I get a very long list ended by an OK. I'm going to paste below the whole message, I hope somebody will help : oracle@linux:~ > cd /cdrecorder oracle@linux:/cdrecorder > ./runInstaller oracle@linux:/cdrecorder > Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre. Please wait... SIGSEGV received at bfffd994 in /cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/linux/native_threads/libjava.so. Processing terminated Wed Jul 18 17:06:53 2001 jre full version "JDK 1.1.8 IBM build l118-2429 (JIT enabled: jitc)" Operating Environment - Host: linux. OS Level: 2.2.18.#1 Mon Feb 5 17:56:44 GMT 2001 glibc Version : 2.2 No. of Procs: 1 Memory Info: total:used:free: shared: buffers: cached: Mem: 268017664 239714304 283033600 126836736 39231488 Swap: 1151098880 115109888 MemTotal:261736 kB MemFree: 27640 kB MemShared:0 kB Buffers: 123864 kB Cached: 38312 kB BigTotal: 0 kB BigFree: 0 kB SwapTotal: 112412 kB SwapFree:112412 kB User Limits (in bytes except for NOFILE and NPROC) - RLIMIT_FSIZE: infinity RLIMIT_DATA : infinity RLIMIT_STACK: 2093056 RLIMIT_CORE : 0 RLIMIT_NOFILE : 1024 RLIMIT_NPROC: 1024 Application Environment --- Signal Handlers - SIGQUIT : ignored SIGILL : sysThreadIDump (libjava.so)
Re: security problem with 8i
Rachel Carmichael wrote: > > nah, I LIKED this boss :) never had one of those.;-) -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: resize in 7.3.4 urgent
Yep. That's the one. First book on my Oracle bookshelf.
"Rachel
Carmichael" To: Multiple recipients of list ORACLE-L
mail.com>cc:
Sent by: Subject: RE: resize in 7.3.4 urgent
root@fatcity.
com
07/18/2001
12:17 PM
Please
respond to
ORACLE-L
DBA Handbook is by Kevin Loney. as is Oracle8 DBA Handbook and Oracle8i DBA
Handbook (this last with Marlene Theriault as co-author). and the
to-be-published (no, I don't have a date, they have just started working on
it!) Oracle9i DBA Handbook
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: resize in 7.3.4 urgent
>Date: Wed, 18 Jul 2001 07:01:36 -0800
>
>If you want to see a more visual representation of what's in a tablespace
>(including free space) use the mapper.sql from the old DBA Handbook (don't
>have it right here in front of me so I don't know the author's name).
This
>is for Oracle 7.3.4.
>
>--
>rem
>rem file: mapper.sql
>rem parameters: the tablespace name being mapped
>rem
>rem Sample invocation:
>rem @mapper SYSTEM
>rem
>rem This script generates a mapping of the space usage
>rem (free space vs used) in a tablespace. It graphically
>rem shows segment and free space fragmentation.
>rem
>set pagesize 66 linesize 132 verify off
>ttitle 'Map of Tablespace ' &&1 right datevar skip 1
>column substr(file_id,1,4) heading "File|Id"
>column bytes format 999,999,999,999
>column today noprint new_value datevar
>
>SELECT
>to_char(sysdate, 'MM/DD/YY') today,
>'free space' owner, /*"owner" of free space*/
>' ' object, /*blank object name*/
>substr(file_id,1,4), /*file ID for the extent header*/
>block_id, /*block ID for the extent header*/
>blocks, /*lengthof the extent in blocks*/
>bytes /*length of the extent in bytes*/
>FROM sys.dba_free_space
>WHERE tablespace_name = upper('&&1')
>UNION
>SELECT
>to_char(sysdate, 'MM/DD/YY') today,
>substr(owner,1,10), /*owner name (first 20 chars)*/
>substr(segment_name,1,27), /*segment name (first 26 chars)*/
>substr(file_id,1,4), /*file ID for extent header*/
>block_id, /*block ID for block header*/
>blocks, /*length of the extent in blocks*/
>bytes /*length of the extent in bytes*/
>FROM sys.dba_extents
>WHERE tablespace_name = upper('&&1')
>ORDER BY 4,5
>
>/
>undefine 1
>
--
>
>--
>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).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTEC
OT: Certifications
Well I have to say the IBM WebSphere Cert and Sun Java Programmer Cert are infinitely easier than the Oracle OCP. I have received them both in the mail recently and never taken any of the tests! This is strange, I think someone has stolen my identity and is doing a better job at living my life than me! - Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: security problem with 8i
Not at all. Just last week I had a vendor who came in to install a package. They were very upset because SYS didn't have the "standard" password and their install script wouldn't work. I questioned their use of the SYS schema for the installation but powers wiser than me had me change the SYS password to the "standard" value and leave the room. Hey, it's a job. -- 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).
connecting to sqlplus within a shell script
I use a lot of shell scripts (korn mainly) which use connections to sqlplus and always seem to get this error message when the script logs into sqlplus: stty: standard input: Inappropriate ioctl for device Here is my connection procedure within the script: sqlplus -s sitemon/sitemon << END To my knowledge it does not appear to cause any problems with my shell script or output but would really like to know why I am getting it and if there is any recommendations for fixing the problem. OS: Red Hat Linux 6.2 ORACLE: 8.1.7 standard edition shell: korn Any help would be appreciated thanks Reed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: security problem with 8i
nah, I LIKED this boss :) >From: "Thater, William" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: security problem with 8i >Date: Wed, 18 Jul 2001 09:02:52 -0800 > >Rachel Carmichael wrote: > > > and log in as system/manager > > > > I do what they ask me to, then take my old boss aside and explain >(gently) > > that he has a security hole in his "highly secured" system that I could > > drive a truck through. > >you, my dear goddess, are way to kind.;-) > > >-- >Bill "Shrek" Thater Certifiable ORACLE DBA >Telergy, Inc.[EMAIL PROTECTED] >~~ >You gotta program like you don't need the money, >You gotta compile like you'll never get hurt, >You gotta run like there's nobody watching, >It's gotta come from the heart if you want it to work. >~~ >If a program is useful, it must be changed. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Thater, William > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: security problem with 8i
"Farnsworth, Dave" wrote: > > This is the way my current employers shop was. After I started here as a > SQL Server DBA I was told they want me to become the Oracle DBA for a new > third party app they were getting. They already had two other apps using > Oracle. These other apps were up and running for a couple of years. Within > the first couple of months of learning Oracle I was able to access the other > Oracle databases with the standard SYS and SYSTEM logins. These were > systems that at the time, I did not have access to. Well the next day, I > told damagement and now I have three Oracle systems. :) > > Dave some days it doesn't pay to open your mouth.;-) -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
Procedure Builder - Seeing variables
Hi all, Does anyone know what can I do for to see the variables in Procedure Builder. I know to start the procedure and i don´t get to see the variables in debbug option. Where must I click for it ? Regards Eriovaldo [EMAIL PROTECTED] Brazil _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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[2]: security problem with 8i
Brian, Humm, let me guess, SYSTEM right??? Some old concepts die so hard. Oracle 5 and earlier did not understand the idea of tablespaces, but had partitions with the system partition being the original and prime one. Now one could create other partitions, but that was 'risky' at best whereas Oracle provided a canned way to add a datafile to the system partition!!! Dick Goulet Reply Separator Author: "Brian McGraw" <[EMAIL PROTECTED]> Date: 7/18/2001 8:56 AM Ah, War stories... Reminds me (somewhat) of a company that I consulted, that had been suddently abandoned by its DBA in November, 1999 - anyone remember the Y2K panic?? They couldn't explan the CPU slowdown and lack of IO throughput. So I went on site, and their DBA with 5 years of experience had exactly 3 tablespaces in the system: TEMP, RBS, and SYSTEM. System was > 2GB and was composed of about 25 datafiles. Anyone care to guess where all of the db objects lived??? It was a production system, BTW. It's nice to feel like a miracle-worker sometimes. : ) Brian Rachel Carmichael wrote: > I would doubt he's joking. I've had simular experiences > > transferred to another department within the same company. Get a call from > my old boss "our dba is out sick, we HAVE to have this done today, this is a > highly secured system you have to help and make the changes from this pc" > > I go there, cannot log into the database with the username and password he > gives me. We call the dba (who was really sick), apologize and ask for the > username and password -- same as what I had. Still does not work. I stop, > think and say "let me try something" > > and log in as system/manager > > I do what they ask me to, then take my old boss aside and explain (gently) > that he has a security hole in his "highly secured" system that I could > drive a truck through. > > >From: paquette stephane <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: Re[2]: security problem with 8i > >Date: Wed, 18 Jul 2001 07:25:48 -0800 > > > >Are you joking ? > > > > --- [EMAIL PROTECTED] a écrit : > Although there > >has been so much publicity of > > > security "holes" in Oracle, in > > > particular the listener, the one hole that really > > > causes me concern is the > > > default passwords for sys and system and/or using > > > the username as a password. > > > Over the past 2 years I've been to a few sites, like > > > 4, at a friends request > > > and/or on an interview where the manager said "show > > > me" and each time I've been > > > able to log onto the DB with any of the following: > > > > > > sys/change_on_install > > > sys/sys > > > system/system > > > system/manager > > > > > > Now come on, this was an old V6 thing that we were > > > suppose to do, and we're > > > still not!! > > > > > > Dick Goulet > > > > > > Reply > > > Separator > > > Author: Ray Stell <[EMAIL PROTECTED]> > > > Date: 7/18/2001 5:15 AM > > > > > > On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon > > > Walthour wrote: > > > > Listers: > > > > > > > > My client has asked me to look into this issue and > > > determine if they should > > > > be concerned about it or not. Since they don't > > > have any db's directly > > > > accessible from the Internet and since their LAN > > > is very secure anyway, I'm > > > > inclined to not apply any patches based on the > > > premise that if it isn't a > > > > necessary patch, don't apply it in fear of > > > breaking something else. What do > > > > you think? > > > > -- > > > > > > two words, disgruntled employee > > > > >=== > > > Ray Stell [EMAIL PROTECTED] (540) 231-4109 > > > KE4TJC28^D > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Ray Stell > > > 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 > > > > >
Snapshot shows as INVALID in DBA_OBJECTs
Hi All, The subject says it all, 8.1.7 on Solaris 2.8 The snapshot is accessable and correct. Anyone know a (supported) way to clean up the data dictionary? TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: security problem with 8i
Oh yeah! I've got one even better! When I joined a previous company, their *Web-accessible* application's administration username/password was admin/admin! Their production Oracle DB - accessed via the admin/admin "protected" app - had system/manager and mps/mps (mps stands for Main Production Schema), plus all the usual default schemas like ctxsys/ctxsys... Needless to say, I closed those holes pretty quickly! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Carmichael Sent: Wednesday, July 18, 2001 11:13 AM To: Multiple recipients of list ORACLE-L I would doubt he's joking. I've had simular experiences transferred to another department within the same company. Get a call from my old boss "our dba is out sick, we HAVE to have this done today, this is a highly secured system you have to help and make the changes from this pc" I go there, cannot log into the database with the username and password he gives me. We call the dba (who was really sick), apologize and ask for the username and password -- same as what I had. Still does not work. I stop, think and say "let me try something" and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his "highly secured" system that I could drive a truck through. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SORT_SEGMENT_REQUEST Timeouts 100%
I logged a tar last night and have not gotten much help, here is the problem: AIX 4.3 Oracle 8.1.7 * Any operation requiring use of a temp segment takes forever to complete. Also attempting to drop TEMP tablespace is taking forever to complete. V$LOCK shows very long times on a TT and IS lock. The tablespace being dropped is only 500 MB and offline. V$SESSION_EVENT shows a constant enqueue wait. V$SYSTEM_EVENT has shown in past 100% timeouts on sort_segment_request event. This looks very much like bug# 1131535 but it says that it is fixed in 8.1.7? * Furthur analysis showed that the sort segment never got used then all of a sudden last night it started working and I have not been able to figure out why. I dropped the TEMP tablespace (eventually) and recreated a new LMT temporary tablespace and the trouble still occurred. Not occuring now so having problems diagnosing it. I did an event 10046 level 8 and the trace file was pretty useless to me, I could not make heads or tails of it. It showed a call to DBMS_APPLICATION_INFO which I assume is normal and it did not show the SQL I was running. Would this imply perhaps a problem with lib cache latch since it wasn't even in the trace file...? Any thoughts would be greatly appreciated. Thanks, Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: security problem with 8i
This is the way my current employers shop was. After I started here as a SQL Server DBA I was told they want me to become the Oracle DBA for a new third party app they were getting. They already had two other apps using Oracle. These other apps were up and running for a couple of years. Within the first couple of months of learning Oracle I was able to access the other Oracle databases with the standard SYS and SYSTEM logins. These were systems that at the time, I did not have access to. Well the next day, I told damagement and now I have three Oracle systems. :) Dave -Original Message- Sent: Wednesday, July 18, 2001 11:13 AM To: Multiple recipients of list ORACLE-L I would doubt he's joking. I've had simular experiences transferred to another department within the same company. Get a call from my old boss "our dba is out sick, we HAVE to have this done today, this is a highly secured system you have to help and make the changes from this pc" I go there, cannot log into the database with the username and password he gives me. We call the dba (who was really sick), apologize and ask for the username and password -- same as what I had. Still does not work. I stop, think and say "let me try something" and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his "highly secured" system that I could drive a truck through. >From: paquette stephane <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Re[2]: security problem with 8i >Date: Wed, 18 Jul 2001 07:25:48 -0800 > >Are you joking ? > > --- [EMAIL PROTECTED] a écrit : > Although there >has been so much publicity of > > security "holes" in Oracle, in > > particular the listener, the one hole that really > > causes me concern is the > > default passwords for sys and system and/or using > > the username as a password. > > Over the past 2 years I've been to a few sites, like > > 4, at a friends request > > and/or on an interview where the manager said "show > > me" and each time I've been > > able to log onto the DB with any of the following: > > > > sys/change_on_install > > sys/sys > > system/system > > system/manager > > > > Now come on, this was an old V6 thing that we were > > suppose to do, and we're > > still not!! > > > > Dick Goulet > > > > Reply > > Separator > > Author: Ray Stell <[EMAIL PROTECTED]> > > Date: 7/18/2001 5:15 AM > > > > On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon > > Walthour wrote: > > > Listers: > > > > > > My client has asked me to look into this issue and > > determine if they should > > > be concerned about it or not. Since they don't > > have any db's directly > > > accessible from the Internet and since their LAN > > is very secure anyway, I'm > > > inclined to not apply any patches based on the > > premise that if it isn't a > > > necessary patch, don't apply it in fear of > > breaking something else. What do > > > you think? > > > -- > > > > two words, disgruntled employee > > >=== > > Ray Stell [EMAIL PROTECTED] (540) 231-4109 > > KE4TJC28^D > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Ray Stell > > 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). > >= >Stéphane Paquette >DBA Oracle, consultant entrepôt de données >Oracle DBA, datawarehouse consultant >[EMAIL PROTECTED] > >___ >Do You Yahoo!? -- Vos albums photos en ligne, >Yahoo! Phot
Re: security problem with 8i
Rachel Carmichael wrote: > and log in as system/manager > > I do what they ask me to, then take my old boss aside and explain (gently) > that he has a security hole in his "highly secured" system that I could > drive a truck through. you, my dear goddess, are way to kind.;-) -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: security problem with 8i
Ah, War stories... Reminds me (somewhat) of a company that I consulted, that had been suddently abandoned by its DBA in November, 1999 - anyone remember the Y2K panic?? They couldn't explan the CPU slowdown and lack of IO throughput. So I went on site, and their DBA with 5 years of experience had exactly 3 tablespaces in the system: TEMP, RBS, and SYSTEM. System was > 2GB and was composed of about 25 datafiles. Anyone care to guess where all of the db objects lived??? It was a production system, BTW. It's nice to feel like a miracle-worker sometimes. : ) Brian Rachel Carmichael wrote: > I would doubt he's joking. I've had simular experiences > > transferred to another department within the same company. Get a call from > my old boss "our dba is out sick, we HAVE to have this done today, this is a > highly secured system you have to help and make the changes from this pc" > > I go there, cannot log into the database with the username and password he > gives me. We call the dba (who was really sick), apologize and ask for the > username and password -- same as what I had. Still does not work. I stop, > think and say "let me try something" > > and log in as system/manager > > I do what they ask me to, then take my old boss aside and explain (gently) > that he has a security hole in his "highly secured" system that I could > drive a truck through. > > >From: paquette stephane <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: Re[2]: security problem with 8i > >Date: Wed, 18 Jul 2001 07:25:48 -0800 > > > >Are you joking ? > > > > --- [EMAIL PROTECTED] a écrit : > Although there > >has been so much publicity of > > > security "holes" in Oracle, in > > > particular the listener, the one hole that really > > > causes me concern is the > > > default passwords for sys and system and/or using > > > the username as a password. > > > Over the past 2 years I've been to a few sites, like > > > 4, at a friends request > > > and/or on an interview where the manager said "show > > > me" and each time I've been > > > able to log onto the DB with any of the following: > > > > > > sys/change_on_install > > > sys/sys > > > system/system > > > system/manager > > > > > > Now come on, this was an old V6 thing that we were > > > suppose to do, and we're > > > still not!! > > > > > > Dick Goulet > > > > > > Reply > > > Separator > > > Author: Ray Stell <[EMAIL PROTECTED]> > > > Date: 7/18/2001 5:15 AM > > > > > > On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon > > > Walthour wrote: > > > > Listers: > > > > > > > > My client has asked me to look into this issue and > > > determine if they should > > > > be concerned about it or not. Since they don't > > > have any db's directly > > > > accessible from the Internet and since their LAN > > > is very secure anyway, I'm > > > > inclined to not apply any patches based on the > > > premise that if it isn't a > > > > necessary patch, don't apply it in fear of > > > breaking something else. What do > > > > you think? > > > > -- > > > > > > two words, disgruntled employee > > > > >=== > > > Ray Stell [EMAIL PROTECTED] (540) 231-4109 > > > KE4TJC28^D > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Ray Stell > > > 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). > > > >= > >Stéphane Paquette > >DBA Oracle, consultant entrepôt de données > >Oracle DBA, datawarehouse co
RE: 9i RAC's
Early publicity for RACs specifically said that it was an OPS upgrade and made great play of cache fusion which was already available in 8.1.7. I agree with the previous point that OPS was often thrown at applications that were badly suited and so customers perceived it as a poor technology. RAC seeks to improve over OPS by giving it the capability to scale any application, whether or not it's specifically designed to run in a parallel environment. Whether they've succeeded yet is still to be discovered. Regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: Re[2]: security problem with 8i
JS, I think DG did this and mail got crossed. HTH, RM -Original Message- Sent: Wednesday, July 18, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Ross, You can get into all of my databases that way, including the enterprise SAP database. Wonderful huh? Changing passwords around is on my todo list, but it's often not as simple as just changing it. There may be other ramifications, like it's a FailSafe database for instance. Or a 3rd party duhveloper installed the software and set everyone up to run as SYSTEM. Brilliant. Jared On Wednesday 18 July 2001 08:20, Mohan, Ross wrote: > > Although there has been so much publicity of security "holes" in > Oracle, in > particular the listener, the one hole that really causes me concern is the > default passwords for sys and system and/or using the username as a > password. > Over the past 2 years I've been to a few sites, like 4, at a friends > request and/or on an interview where the manager said "show me" and each > time I've been > able to log onto the DB with any of the following: > > sys/change_on_install > sys/sys > system/system > system/manager > > Now come on, this was an old V6 thing that we were suppose to do, and we're > still not!! > > Dick Goulet > > Reply Separator > Author: Ray Stell <[EMAIL PROTECTED]> > Date: 7/18/2001 5:15 AM > > On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: > > Listers: > > > > My client has asked me to look into this issue and determine if they > > should > > > be concerned about it or not. Since they don't have any db's directly > > accessible from the Internet and since their LAN is very secure anyway, > > I'm > > > inclined to not apply any patches based on the premise that if it isn't a > > necessary patch, don't apply it in fear of breaking something else. What > > do > > > you think? > > -- > > two words, disgruntled employee > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Mohan, Ross 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).
I still can't install Oracle on Linux - help
Hi, I have the following environment: Suse 7.1, Oracle 8.1.6, 256 Mb Ram, KDE, Java runtime (I hope I installed it correctly). When I run the Installer from Kde, it makes nothing, but if I run from terminal window I get a very long list ended by an OK. I'm going to paste below the whole message, I hope somebody will help : oracle@linux:~ > cd /cdrecorder oracle@linux:/cdrecorder > ./runInstaller oracle@linux:/cdrecorder > Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre. Please wait... SIGSEGV received at bfffd994 in /cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/linux/native_threads/libjava.so. Processing terminated Wed Jul 18 17:06:53 2001 jre full version "JDK 1.1.8 IBM build l118-2429 (JIT enabled: jitc)" Operating Environment - Host : linux. OS Level : 2.2.18.#1 Mon Feb 5 17:56:44 GMT 2001 glibc Version : 2.2 No. of Procs : 1 Memory Info: total: used: free: shared: buffers: cached: Mem: 268017664 239714304 28303360 0 126836736 39231488 Swap: 115109888 0 115109888 MemTotal: 261736 kB MemFree: 27640 kB MemShared: 0 kB Buffers: 123864 kB Cached: 38312 kB BigTotal: 0 kB BigFree: 0 kB SwapTotal: 112412 kB SwapFree: 112412 kB User Limits (in bytes except for NOFILE and NPROC) - RLIMIT_FSIZE : infinity RLIMIT_DATA : infinity RLIMIT_STACK : 2093056 RLIMIT_CORE : 0 RLIMIT_NOFILE : 1024 RLIMIT_NPROC : 1024 Application Environment --- Signal Handlers - SIGQUIT : ignored SIGILL : sysThreadIDump (libjava.so) SIGABRT : sysThreadIDump (libjava.so) SIGFPE : sysThreadIDump (libjava.so) SIGBUS : sysThreadIDump (libjava.so) SIGSEGV : sysThreadIDump (libjava.so) SIGPIPE : ignored SIGUSR1 : doSuspendLoop (libjava.so) Environment Variables - PWD=/cdrecorder/install LTDL_LIBRARY_PATH=/home/oracle/.kde2/lib:/opt/kde2/lib konq_sm_file=/opt/kde2/share/config/SuSE/config/konqueror:1054d0ebe29756685240014220002 PAGER=less GLX_NO_DIRECT=t HOSTNAME=linux LD_LIBRARY_PATH=/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/linux/native_threads:/lib:/usr/lib:/opt/kde/lib:/home/oracle/.kde2/lib:/opt/kde2/lib LS_OPTIONS=-N --color=tty -T 0 ignoreeof=0 KDEDIRS=/etc/opt/kde2:/opt/kde2 KDEHOME=/home/oracle/.kde2 POVRAYOPT=-l/usr/lib/povray/include SUSE_DOC_HOST=localhost QTDIR=/usr/lib/qt OPENWINHOME=/usr/openwin D=32 CLASSPATH=/tmp/OraInstall0:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/OraInstaller.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/InstImages.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/InstHelp.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/oracleice.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/help.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/ewt.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/xmlparser.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/swingaccess.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/rt.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/i18n.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/math.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/classes.zip LESSKEY=/etc/lesskey.bin LESSOPEN=|lesspipe.sh %s MANPATH=/usr/local/man:/usr/share/man:/usr/man:/usr/X11R6/man:/usr/openwin/man LANGUAGE=hungarian NNTPSERVER=news KDEDIR=/opt/kde LESS=-M -S -I USER=oracle LS_COLORS= HISTCONTROL=ignoredups XSESSION_IS_UP=yes THREADS_TYPE=native_threads MACHTYPE=i386-suse-linux XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB THREADS_FLAG=native LANG=hu_HU GNOMEDIR=/opt/gnome JAVA_HOME=/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux COLORTERM=1 X=1024 INFOPATH=/usr/local/info:/usr/share/info:/usr/info Y=768 DISPLAY=:0 LOGNAME=oracle SHLVL=3 TEXINPUTS=~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX MINICOM=-c on INFODIR=/usr/local/info:/usr/share/info:/usr/info SESSI
RE: resize in 7.3.4 urgent
DBA Handbook is by Kevin Loney. as is Oracle8 DBA Handbook and Oracle8i DBA
Handbook (this last with Marlene Theriault as co-author). and the
to-be-published (no, I don't have a date, they have just started working on
it!) Oracle9i DBA Handbook
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: resize in 7.3.4 urgent
>Date: Wed, 18 Jul 2001 07:01:36 -0800
>
>If you want to see a more visual representation of what's in a tablespace
>(including free space) use the mapper.sql from the old DBA Handbook (don't
>have it right here in front of me so I don't know the author's name). This
>is for Oracle 7.3.4.
>
>--
>rem
>rem file: mapper.sql
>rem parameters: the tablespace name being mapped
>rem
>rem Sample invocation:
>rem @mapper SYSTEM
>rem
>rem This script generates a mapping of the space usage
>rem (free space vs used) in a tablespace. It graphically
>rem shows segment and free space fragmentation.
>rem
>set pagesize 66 linesize 132 verify off
>ttitle 'Map of Tablespace ' &&1 right datevar skip 1
>column substr(file_id,1,4) heading "File|Id"
>column bytes format 999,999,999,999
>column today noprint new_value datevar
>
>SELECT
>to_char(sysdate, 'MM/DD/YY') today,
>'free space' owner, /*"owner" of free space*/
>' ' object, /*blank object name*/
>substr(file_id,1,4), /*file ID for the extent header*/
>block_id, /*block ID for the extent header*/
>blocks, /*lengthof the extent in blocks*/
>bytes /*length of the extent in bytes*/
>FROM sys.dba_free_space
>WHERE tablespace_name = upper('&&1')
>UNION
>SELECT
>to_char(sysdate, 'MM/DD/YY') today,
>substr(owner,1,10), /*owner name (first 20 chars)*/
>substr(segment_name,1,27), /*segment name (first 26 chars)*/
>substr(file_id,1,4), /*file ID for extent header*/
>block_id, /*block ID for block header*/
>blocks, /*length of the extent in blocks*/
>bytes /*length of the extent in bytes*/
>FROM sys.dba_extents
>WHERE tablespace_name = upper('&&1')
>ORDER BY 4,5
>
>/
>undefine 1
>--
>
>--
>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).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Re[2]: security problem with 8i
I would doubt he's joking. I've had simular experiences transferred to another department within the same company. Get a call from my old boss "our dba is out sick, we HAVE to have this done today, this is a highly secured system you have to help and make the changes from this pc" I go there, cannot log into the database with the username and password he gives me. We call the dba (who was really sick), apologize and ask for the username and password -- same as what I had. Still does not work. I stop, think and say "let me try something" and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his "highly secured" system that I could drive a truck through. >From: paquette stephane <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Re[2]: security problem with 8i >Date: Wed, 18 Jul 2001 07:25:48 -0800 > >Are you joking ? > > --- [EMAIL PROTECTED] a écrit : > Although there >has been so much publicity of > > security "holes" in Oracle, in > > particular the listener, the one hole that really > > causes me concern is the > > default passwords for sys and system and/or using > > the username as a password. > > Over the past 2 years I've been to a few sites, like > > 4, at a friends request > > and/or on an interview where the manager said "show > > me" and each time I've been > > able to log onto the DB with any of the following: > > > > sys/change_on_install > > sys/sys > > system/system > > system/manager > > > > Now come on, this was an old V6 thing that we were > > suppose to do, and we're > > still not!! > > > > Dick Goulet > > > > Reply > > Separator > > Author: Ray Stell <[EMAIL PROTECTED]> > > Date: 7/18/2001 5:15 AM > > > > On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon > > Walthour wrote: > > > Listers: > > > > > > My client has asked me to look into this issue and > > determine if they should > > > be concerned about it or not. Since they don't > > have any db's directly > > > accessible from the Internet and since their LAN > > is very secure anyway, I'm > > > inclined to not apply any patches based on the > > premise that if it isn't a > > > necessary patch, don't apply it in fear of > > breaking something else. What do > > > you think? > > > -- > > > > two words, disgruntled employee > > >=== > > Ray Stell [EMAIL PROTECTED] (540) 231-4109 > > KE4TJC28^D > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Ray Stell > > 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). > >= >Stéphane Paquette >DBA Oracle, consultant entrepôt de données >Oracle DBA, datawarehouse consultant >[EMAIL PROTECTED] > >___ >Do You Yahoo!? -- Vos albums photos en ligne, >Yahoo! Photos : http://fr.photos.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: =?iso-8859-1?q?paquette=20stephane?= > 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 info
Re[2]: Re[2]: security problem with 8i
I wish I was. Reply Separator Author: =?iso-8859-1?q?paquette=20stephane?= <[EMAIL PROTECTED]> Date: 7/18/2001 7:25 AM Are you joking ? --- [EMAIL PROTECTED] a écrit : > Although there has been so much publicity of > security "holes" in Oracle, in > particular the listener, the one hole that really > causes me concern is the > default passwords for sys and system and/or using > the username as a password. > Over the past 2 years I've been to a few sites, like > 4, at a friends request > and/or on an interview where the manager said "show > me" and each time I've been > able to log onto the DB with any of the following: > > sys/change_on_install > sys/sys > system/system > system/manager > > Now come on, this was an old V6 thing that we were > suppose to do, and we're > still not!! > > Dick Goulet > > Reply > Separator > Author: Ray Stell <[EMAIL PROTECTED]> > Date: 7/18/2001 5:15 AM > > On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon > Walthour wrote: > > Listers: > > > > My client has asked me to look into this issue and > determine if they should > > be concerned about it or not. Since they don't > have any db's directly > > accessible from the Internet and since their LAN > is very secure anyway, I'm > > inclined to not apply any patches based on the > premise that if it isn't a > > necessary patch, don't apply it in fear of > breaking something else. What do > > you think? > > -- > > two words, disgruntled employee > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 > KE4TJC28^D > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Ray Stell > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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).
SQL*Net Connection limits
hi gurus, Does SQL*net has a limit on concurrent simulataneous access/connection to the the database. I simulated 600 web user accesing the oracle DB thru a PHP script which connects to the data base,fetches the data, and disconnects. From the listener.log, connections is about 7/8 conncetions/sec. How can I increase the connections#/sec. I noticed that a client program takes longer to connect when the test is being run. A vmstat shows that CPU utilization : users % = 50%,sys 27#,idle 23%. The platform is Compaq Digital AS 400 with 2 CPUs,512 MB Memory, Digital Unix ver4.0d, 8.1.5 RDBMS. Any pointers Thanks --azhar -- 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).
long to clob scripts?
Title: OFF-TOPIC : remsh from a WIN workstation to a UNIX We are finally getting around to replacing all our long data types with clobs and blobs - anybody already have a script that does this?
RE: 9i RAC's
I thought RAC was a major improvement of OPS, but it was still OPS by another name. I don't believe you gang together machines of any ilk to make a cluster, but you need to use architectures expressedly designed to be loosely-coupled. CERN, the physics lab in Geneva, is presently considering Oracle to store event data from the Large Hadronic Collider. The last I heard, which was a few years ago, the requirement was to have a petabyte of data available through online and nearline storage. RAC's are one of the reasons Oracle is being considered. One way to do this would be to build one huge cluster, but that would wed you to a single vendor. One could make several clusters, but then how does one determine which cluster the data is on. There is also some doubt whether 64,000 partitions will be enough, though I haven't heard how the data is to be partitioned. There is much skepticism, a healthy majority, about Oracle's ability to handle such a system. I'm in the skeptic camp as well. I have no influence nor input on Cern's decision. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 17, 2001 9:35 AM To: Multiple recipients of list ORACLE-L I'm a little late to respond, but... RAC is most certainly a significant upgrade to and renaming of OPS. There is absolutely no doubt about it. At Oracle Open World 2000, all the Oracle OPS people doing presentations found out about the name change only a few weeks before the conference and scrambled madly to change all occurrences of "Oracle Parallel Server" to "Real Application Clusters" in their 9i (nee 8.2) presentations. The handouts still said OPS (and sometimes 8.2 ), but the otherwise identical overheads (usually) said RAC and 9i. The marketing denial of this is simply because OPS got such a bad reputation - which was, in my opinion, largely undeserved. The people who actually write the code for OPS/RAC suffer no such delusions. Granted OPS/RAC is/was more complex, but the bad rep was mostly due to people trying to use OPS inappropriately - for poorly-suited applications and systems (i.e. the majority). "RAC" is somewhat simpler to set up and administer than "OPS" and performs much better, but it is still OPS with a new name. While Oracle finally admitted that OPS was a specialty product, they seem now to be saying that RAC is for anything. I wouldn't swallow all of that particular Kool-Aid just yet! -Don Granaman [certifiable Orasaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001 2:20 PM > No it is not the upgrade of OPS as I understand. They even put OPS down > themselves saying that it was sparsely used, and far to complicated to set > up. > > What RAC does, is essentially link every machine together in to a "cluster", > then each physical machine can touch the same database concurrently > (probably on a central storage unit). There is no actual "standby" when this > is in use, as all machines connected to the cluster work together - but if > one of the machines has a hardware failure, the load is simply spread > between the remaining machines.. > > It looks *really* cool stuff, and by *Oracles* stats, beats any other > clustered databases in real world situations. > > If only I could blag the boss for a ?1,000,000 budget for a bunch of compaq > servers >:-) > > Mark > > -Original Message- > Greenfield > Sent: Friday, July 13, 2001 03:51 > To: Multiple recipients of list ORACLE-L > > > Mark, isn't RAC just the upgrade for OPS? Then that would > make it a 'standby' for the instance, but not a standby for the > database, no? > > Am I misunderstanding something? > > y > > Mark Leith wrote: > > > I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one > > of the main points they discussed about 9i, was the use of Real > Application > > Clusters (RAC). Of course you have to be running on Compaq hardware at the > > moment, but it takes the need for a standby away, as you essentially just > > plug the standby in to the cluster, and make use of it's computing power, > > instead of having the standby just stood waiting for a failure.. > > > > Just a thought.. > > > > Mark > > > > -Original Message- > > Turner > > Sent: Thursday, July 12, 2001 08:26 > > To: Multiple recipients of list ORACLE-L > > > > Anyone know if the standby in 9i can be in readonly mode while the logs > are > > being applied? I've heard about this as being the case and also that this > > isn't > > the case. > > > > Thanks, Dave Turner > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: David Turner > > INET: [EMAIL PROTECTED] > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yosi Greenfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, C
Re: OT RE: Re[2]: security problem with 8i
Ross, You can get into all of my databases that way, including the enterprise SAP database. Wonderful huh? Changing passwords around is on my todo list, but it's often not as simple as just changing it. There may be other ramifications, like it's a FailSafe database for instance. Or a 3rd party duhveloper installed the software and set everyone up to run as SYSTEM. Brilliant. Jared On Wednesday 18 July 2001 08:20, Mohan, Ross wrote: > > Although there has been so much publicity of security "holes" in > Oracle, in > particular the listener, the one hole that really causes me concern is the > default passwords for sys and system and/or using the username as a > password. > Over the past 2 years I've been to a few sites, like 4, at a friends > request and/or on an interview where the manager said "show me" and each > time I've been > able to log onto the DB with any of the following: > > sys/change_on_install > sys/sys > system/system > system/manager > > Now come on, this was an old V6 thing that we were suppose to do, and we're > still not!! > > Dick Goulet > > Reply Separator > Author: Ray Stell <[EMAIL PROTECTED]> > Date: 7/18/2001 5:15 AM > > On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: > > Listers: > > > > My client has asked me to look into this issue and determine if they > > should > > > be concerned about it or not. Since they don't have any db's directly > > accessible from the Internet and since their LAN is very secure anyway, > > I'm > > > inclined to not apply any patches based on the premise that if it isn't a > > necessary patch, don't apply it in fear of breaking something else. What > > do > > > you think? > > -- > > two words, disgruntled employee > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
Oracle 9i on AIX with RAC
Hi, Anyone has any updates on 9i with RAC on AIX platform availability? Any dates? Dates without RAC ?? Thanks in advance Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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: New Listener Question
I disagree. Mine only registers itself if I have the "service_names" entry in the init.ora file. Comment this line out and see what happens... -Original Message- Smith Sent: Tuesday, July 17, 2001 1:31 PM To: Multiple recipients of list ORACLE-L In Oracle 8i a database will self register with the default listener even if you do not have it defined. There are parameters that you can put in your init.ora to prevent this. -Original Message- Sent: Tuesday, July 17, 2001 9:35 AM To: Multiple recipients of list ORACLE-L First Off, I would like to thank everyone who replied yesterday, your answers were most helpful! Today, I am facing a new puzzle. I am currently running 3 databases on a server, but only two of them are listed in the listener.ora (bdw and rcvr). If I do a 'lsnrctl status' it shows a listener for all three databases (bdw rcvr and webprod). How is this possible? I have included my current listener.ora and output from 'lsnrctl status' ... Also, people who access these databases go through VIRTUAL ip's, i.e. the box itself has IP address xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod ip is xxx.xxx.xxx.30 The reason for the virt ip's is for the fail over we have in place, so people do not have to reconfigure their machines when we move the databases around. So by all rights I do not see how anyone can connect, but they are?!?!?!? WTH??? Thanks again guys ... # LISTENER.ORA Configuration File:/apps/oracle/product/816/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /apps/oracle/product/816) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = bdw) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = bdw) ) (SID_DESC = (GLOBAL_DBNAME = rcvr) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = rcvr) ) ) oracle@bdw1 SID: bdw /apps/oracle/product/816/network/admin > lsnrctl status LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001 09:24:30 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for Solaris: Version 8.1.6.0.0 - Production Start Date10-JUL-2001 15:14:01 Uptime6 days 18 hr. 10 min. 30 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /apps/oracle/product/816/network/admin/listener.ora Listener Log File /apps/oracle/product/816/network/log/listener.log Services Summary... PLSExtProchas 1 service handler(s) WEBPROD has 2 service handler(s) bdw has 1 service handler(s) bdw has 1 service handler(s) rcvr has 1 service handler(s) The command completed successfully -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Certification
Jared, Why amongst one's peers? I appreciate and flaunt it in other places that provide more bang for the buck (like on the resume). Dick Goulet Reply Separator Author: Jared Still <[EMAIL PROTECTED]> Date: 7/18/2001 7:01 AM On Wednesday 18 July 2001 04:30, Robertson Lee - lerobe wrote: > > Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) If you got it, flaunt it! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
Licensing
I am just curious if anyone knows anything about concurrent user licensing. My question is: am I limited to the number of instances or just to concurrent users? Any help is greatly appreciated. Thanks, -- Alan Carbutt Applications Programmer Adams State College 719-587-7096 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Carbutt 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: OFF-TOPIC : remsh from a WIN workstation to a UNIX
Use ssh, it's a secure replacement for remsh. Available as part of cygwin at http://sources.redhat.com/cygwin/ Jared On Wednesday 18 July 2001 07:41, Andrey Bronfin wrote: > Dear list ! > Is there a way to run a command from a WIN NT workstation on a remote UNIX > server (i.e. something like "remsh") . > Thanks a lot in advance ! Content-Type: text/html; charset="windows-1255"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: OFF-TOPIC : remsh from a WIN workstation to a UNIX
Title: OFF-TOPIC : remsh from a WIN workstation to a UNIX MKS toolkit? http://www.mkssoftware.com/products/tk/ds_tksa.asp -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 18, 2001 10:42 AMTo: Multiple recipients of list ORACLE-LSubject: OFF-TOPIC : remsh from a WIN workstation to a UNIX Dear list ! Is there a way to run a command from a WIN NT workstation on a remote UNIX server (i.e. something like "remsh") . Thanks a lot in advance !
Re: Oracle db missing
Have you included this database in the tnsnames.ora file on the machine where OEM is running? Also use the suggestion about the Agent. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 17, 2001 11:45 PM > I just install a preconfigure - Oracle 8i into my win2k machinese > > becoz of the testing requirement , I have configure another small 'test' db > , I can see the tnsname already include the new small baby 'test', but when > I goto DB studio ,the OEM did't show me my new db ? why ? > > I can run sqlplus scot/tiger@test ,why the OEM can't detect it > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Raymond Lee Meng Hong > 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: security problem with 8i
Are you joking ? --- [EMAIL PROTECTED] a écrit : > Although there has been so much publicity of > security "holes" in Oracle, in > particular the listener, the one hole that really > causes me concern is the > default passwords for sys and system and/or using > the username as a password. > Over the past 2 years I've been to a few sites, like > 4, at a friends request > and/or on an interview where the manager said "show > me" and each time I've been > able to log onto the DB with any of the following: > > sys/change_on_install > sys/sys > system/system > system/manager > > Now come on, this was an old V6 thing that we were > suppose to do, and we're > still not!! > > Dick Goulet > > Reply > Separator > Author: Ray Stell <[EMAIL PROTECTED]> > Date: 7/18/2001 5:15 AM > > On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon > Walthour wrote: > > Listers: > > > > My client has asked me to look into this issue and > determine if they should > > be concerned about it or not. Since they don't > have any db's directly > > accessible from the Internet and since their LAN > is very secure anyway, I'm > > inclined to not apply any patches based on the > premise that if it isn't a > > necessary patch, don't apply it in fear of > breaking something else. What do > > you think? > > -- > > two words, disgruntled employee > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 > KE4TJC28^D > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Ray Stell > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: resize in 7.3.4 urgent
If you want to see a more visual representation of what's in a tablespace
(including free space) use the mapper.sql from the old DBA Handbook (don't
have it right here in front of me so I don't know the author's name). This
is for Oracle 7.3.4.
--
rem
rem file: mapper.sql
rem parameters: the tablespace name being mapped
rem
rem Sample invocation:
rem @mapper SYSTEM
rem
rem This script generates a mapping of the space usage
rem (free space vs used) in a tablespace. It graphically
rem shows segment and free space fragmentation.
rem
set pagesize 66 linesize 132 verify off
ttitle 'Map of Tablespace ' &&1 right datevar skip 1
column substr(file_id,1,4) heading "File|Id"
column bytes format 999,999,999,999
column today noprint new_value datevar
SELECT
to_char(sysdate, 'MM/DD/YY') today,
'free space' owner, /*"owner" of free space*/
' ' object, /*blank object name*/
substr(file_id,1,4), /*file ID for the extent header*/
block_id, /*block ID for the extent header*/
blocks, /*lengthof the extent in blocks*/
bytes /*length of the extent in bytes*/
FROM sys.dba_free_space
WHERE tablespace_name = upper('&&1')
UNION
SELECT
to_char(sysdate, 'MM/DD/YY') today,
substr(owner,1,10), /*owner name (first 20 chars)*/
substr(segment_name,1,27), /*segment name (first 26 chars)*/
substr(file_id,1,4), /*file ID for extent header*/
block_id, /*block ID for block header*/
blocks, /*length of the extent in blocks*/
bytes /*length of the extent in bytes*/
FROM sys.dba_extents
WHERE tablespace_name = upper('&&1')
ORDER BY 4,5
/
undefine 1
--
--
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).
OT RE: Re[2]: security problem with 8i
there's also the ALL POWERFUL scott/tiger account to consider! -Original Message- Sent: Wednesday, July 18, 2001 11:07 AM To: Multiple recipients of list ORACLE-L Although there has been so much publicity of security "holes" in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said "show me" and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell <[EMAIL PROTECTED]> Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: > Listers: > > My client has asked me to look into this issue and determine if they should > be concerned about it or not. Since they don't have any db's directly > accessible from the Internet and since their LAN is very secure anyway, I'm > inclined to not apply any patches based on the premise that if it isn't a > necessary patch, don't apply it in fear of breaking something else. What do > you think? > -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Mohan, Ross 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: Multiple Listeners
It is my understanding that you don't need the; "SID_LIST_LISTENERDB2 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME2) (ORACLE_HOME = /path/to/oracle/home) ) )" section if you define the "service_names" entry in your init.ora files. You should do one or the other. Please correct if I'm wrong, but this is how it works on my 8.1.6 instances. -Original Message- Aschenbrenner Sent: Monday, July 16, 2001 6:27 PM To: Multiple recipients of list ORACLE-L Edward, Yes, you can setup multiple listeners. Here is an example: LISTENERDB1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521)) ) ) ) LISTENERDB2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1522)) ) ) ) SID_LIST_LISTENERDB1 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME1) (ORACLE_HOME = /path/to/oracle/home) ) ) SID_LIST_LISTENERDB2 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME2) (ORACLE_HOME = /path/to/oracle/home) ) ) After you have set this up, you can start the listeners individually: lsnrctl start listenerdb1 lsnrctl start listenerdb2 Hope that helps... Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] (303)-858-6394 -Original Message- Carr Sent: Monday, July 16, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner 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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Certification
Thanks everyone. I thinkl I have enough to be going on with. Lee -Original Message- Sent: 18 July 2001 14:54 To: [EMAIL PROTECTED] The tests come directly out of the in class study guides. All you need to do is study the guides and take a few practice test to get a feel for the types of questions and the tests themselves. There are a lot of 'tests' on the web: http://cramsession.brainbuzz.com/cramsession/oracle/ http://braindumps.com/it/o/temp1.htm http://www.geocities.com/SiliconValley/Hub/9578/oracle/index.htm http://ora.dbasupport.com/oracle/cert/train.shtml http://www.certprep.com/starthere.asp http://www.examsonline.com/ Good Luck. Todd Carlson Oracle 8i Certified DBA Bunge North America Robertson To: Multiple recipients of list ORACLE-L Lee - lerobe <[EMAIL PROTECTED]> Subject: Certification Sent by: root@fatcity. com 07/18/2001 06:30 AM Please respond to ORACLE-L Oh dear, it looks like the time has arrived whereby I am to be certified. I will be booked on all of the Oracle 8i courses (some are superfluous to my needs but they are block booked at a discount - a nice little jolly away from the office if nothing else !!) and then take the exams as I do them. So, those who have been through this - what are the best study guides to use ? Any recommendation would be welcome. Regards Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Oh dear, it looks like the time has arrived whereby I am to be certified. I will be booked on all of the Oracle 8i courses (some are superfluous to my needs but they are block booked at a discount - a nice little jolly away from the office if nothing else !!) and then take the exams as I do them. So, those who have been through this - what are the best study guides to use ? Any recommendation would be welcome. Regards Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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).
OFF-TOPIC : remsh from a WIN workstation to a UNIX
Title: OFF-TOPIC : remsh from a WIN workstation to a UNIX Dear list ! Is there a way to run a command from a WIN NT workstation on a remote UNIX server (i.e. something like "remsh") . Thanks a lot in advance !
Re[2]: security problem with 8i
Although there has been so much publicity of security "holes" in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said "show me" and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell <[EMAIL PROTECTED]> Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: > Listers: > > My client has asked me to look into this issue and determine if they should > be concerned about it or not. Since they don't have any db's directly > accessible from the Internet and since their LAN is very secure anyway, I'm > inclined to not apply any patches based on the premise that if it isn't a > necessary patch, don't apply it in fear of breaking something else. What do > you think? > -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Certification
On Wednesday 18 July 2001 04:30, Robertson Lee - lerobe wrote: > > Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) If you got it, flaunt it! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
9ias for sun intel
list, One of the developers is looking for the download of 9iAS for SUN INTEL. He would like to use the developer portion as a study aid for his college course. Does anyone know the location? OTN only has the linux intel available. It can be purchased from the Oracle store for $40 but he doesn't want to spend the $. Thanks, ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Further question: Oracle 32bit / 64bit
Last time that I installed Oracle 8.1.6 on a Sun 64 bit OS I installed the 64 bit version. If you pressed me real hard as to why I did that, the best that I could say is that it seemed like a good idea at the time. Some vague idea that the 64 bit version would work better (more optimally) with the 64 bit OS. I haven't seen anything to make me think that the 32 bit version would have been a better choice. On the other hand, it was a new installation, not a migration of an existing database. I don't know if there are any problems with migrating a 32 bit version database to 64 bit. Finally, the Oracle installation manual seems to assume the 32 bit version. As I remember we had to tweak the kernel parameters to get the database to mount and open. Don't remember which. Fortunately, you don't have to reboot to get the changes to take effect. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Certification
Very interesting reading John. Not from the North East of England are you ?? Interv8 are in North Shields and I got a couple of calls from them over the Christmas Holiday period. Lee -Original Message-From: Hallas John [mailto:[EMAIL PROTECTED]]Sent: 18 July 2001 13:35To: Multiple recipients of list ORACLE-LSubject: RE: Certification Lee, Try my web site www.hcresources.co.uk which has a page about my OCP exploits. It is not much of a site but the OCP info may be helpful John -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: 18 July 01 12:30To: Multiple recipients of list ORACLE-LSubject: Certification Oh dear, it looks like the time has arrived whereby I am to be certified. I will be booked on all of the Oracle 8i courses (some are superfluous to my needs but they are block booked at a discount - a nice little jolly away from the office if nothing else !!) and then take the exams as I do them. So, those who have been through this - what are the best study guides to use ? Any recommendation would be welcome. Regards Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.**This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited.Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Re: [Re: UNIX mailx]
I would like to thank all of you who send a reply. I got it to work emailing one file, working on multi files in one email. Thanks again Yigal > > - Original Message - > From: "Yigal Ran" <[EMAIL PROTECTED]> > To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 1:45 PM > Subject: UNIX mailx > > > > Does any one know if it is possible to attach a file when using mailx to > send > an email? > > TIA > > Yigal > > > Get free email and a permanent address at http://www.amexmail.com/?A=1 > > > Oracle documentation is here: > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage > To unsubscribe: send a blank email to [EMAIL PROTECTED] > To subscribe: send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > By using this list you agree to these > terms:http://www.lazydba.com/legal.html > > > > > Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage > To unsubscribe: send a blank email to [EMAIL PROTECTED] > To subscribe: send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > By using this list you agree to these terms:http://www.lazydba.com/legal.html > Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yigal Ran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (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: security problem with 8i
Jon, I would tend to agree with you. As long as their data is not externally available, the risk of this type of attack is very low. Most employees are not foolhardy enough to initiate DOS attacks from their internal LAN's. However if they ever intend to move their system to the internet, VPN, etc. then they need to keep this info and patch as part of their migration plan. Rodd >> Original Message << On 7/18/01, 6:45:57 AM, Jon Walthour <[EMAIL PROTECTED]> wrote regarding Re: security problem with 8i: > Listers: > My client has asked me to look into this issue and determine if they should > be concerned about it or not. Since they don't have any db's directly > accessible from the Internet and since their LAN is very secure anyway, I'm > inclined to not apply any patches based on the premise that if it isn't a > necessary patch, don't apply it in fear of breaking something else. What do > you think? > -- > Jon Walthour, OCDBA > Oracle DBA > Computer Horizons > Cincinnati, Ohio > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 09, 2001 1:26 PM > > Hi All, > > > > i am not sure if this has already been posted or not, but.. > > > > --29 June 2001 Oracle8i Database Buffer Overflow Vulnerability > > Security experts found and disclosed a pair of vulnerabilities in the > > standard and enterprise editions of Oracle8i database. The Transport > > Network Substrate (TNS) Listener has a buffer overflow vulnerability; > > a flaw in the SQL Net protocol leaves the system vulnerable to > > denial-of- service attacks. Patches are available. > > > > http://www.computerworld.com/storyba/0,4125,NAV47_STO61802,00.html > > > > -bill > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Bill Conner > > 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: Jon Walthour > 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: Rodd Holman 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).
Oracle DBA Needed in Indianapolis, IN..
*Description: Candidates local to the Indianapolis area only as no relocation assistance is provided. Client Company in Indianapolis, Indiana is currently seeking an Oracle DBA to fill a position in their current DBA staff. They have a Jr. level and Sen. Level DBA but need someone who can step in and be responsible for some projects in a short period of time. This person must be self-sufficient and have good organization and communication skills. The position has little to no travel but will involve communication with Department heads throughout the company. Client is currently working on web enabling applications using the Oracle 9i application server and this person would have some involvement in the building and implementation of that environment. This position reports to the Director of Application Systems. Candidates local to the Indy area only as no relocation assistance is provided. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Requirements: - Minimum of 3 years experience working as Oracle DBA (Prefer candidate with 4 year degree but will look at others with more years practical experience). -Experience in database tuning, SQL tuning and database backup and recovery. -Strong skill in writing SQL and PL/SQL. -Knowledge on Oracle Application a plus (they run Oracle Financials Release 11 and are moving to 11i shortly). -Knowledge of Oracle Developer 2000 a plus. - U.S. Citizenship or permanent residency This position offers: * Challenge * Opportunity to become a key member of the team * Base Salary -up to 65K-D.O.E. * They have a very aggressive budget for training of internal IT staff For immediate consideration, please send your resume as an attachment to: Bill Law, Oracle Placement Specialist OraStaff, Inc. Ph: 1-800-549-8502-Please do not call if you need sponsorship Email: [EMAIL PROTECTED] Please use job code: One/Indy/DBA/Jones/ We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Certification
If you are attending the ILT courses from Oracle Education.. err University, please stick to the material in the Student Guides and follow it (even it may be wrong, at times). Also, some 'good' instructors may provide hints as to which material is 'OCP test worthy'. So ask questions... ;) Now, isn't that special ??? ;>) Good Luck... - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 6:30 AM > To: Multiple recipients of list ORACLE-L > Subject: Certification > > Oh dear, it looks like the time has arrived whereby I am to be certified. > I will be booked on all of the Oracle 8i courses (some are superfluous to > my needs but they are block booked at a discount - a nice little jolly > away from the office if nothing else !!) and then take the exams as I do > them. > > So, those who have been through this - what are the best study guides > to use ? Any recommendation would be welcome. > > Regards > > Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
