RE: Client-server Forms6i against Oracle 9i (9.2.0.4) database?
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <>
RE: 9iAS v 1.0.2.2.0 Installation Problem
I remember the command window that opens and doesn't do anything. closing it manually is what I was told so the install can continue. I think their were also some places where it opened windows behind the installer, minimize the installer or check the task bar. *** Brian L. Anderson SA/DBA Darton College [EMAIL PROTECTED] --- spamtrap: [EMAIL PROTECTED] > -Original Message- > From: Luis deUrioste [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 18, 2003 11:00 AM > To: Multiple recipients of list ORACLE-L > Subject: 9iAS v 1.0.2.2.0 Installation Problem > > > We are trying to install 9iAS 1.0.2.2.0 on a Dell Poweredge > 2650 / P4 2Gig, we have succesfully installed this software > in older model machines. When we try to run the installer > from the distribuition media we get an error that the > installer did not run because it was probably aborted and to > run setup again. We bypassed this by downloading the OUI > 2.8.18.2 (installer 2.2) and that way we were able to run the > installation. Everything seems to run fine until we get > towards the end a CMD windows is display and it hangs, we > closed it manually. Then a new CMD window is displayed and > some script flashes trhough, after this the installation gets > to 99% and it hangs. The installer shows that is installing a > .gif file and it stays there. > Can somebody shed some light on me, and prompt me on a solution path? > > I spent hours serching through Metalink and havn't found > anything that helped. > > I submitted a TAR, but you guys know it may take a while and > I'm pressed for time. > > T.I.A.. > > Luis Octavio de Urioste > Systems Analyst > PH. (850) 454.2943 > e-mail: [EMAIL PROTECTED] > Vertex Aerospace LLC > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Luis deUrioste > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Congratulations Arup (DBA of the Year)
> related the method of milking a nanny goat who has mastitis > (yes, carefully > and gently for starters, watch the horns...) :-) Is this going to be a session at Hotsos or OracleWorld? ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hey Jared
Come on, be fair, M$ is not that unstable/insecure. It's all the 3rd party products, how do you expect them to be stable/secure with all the unknown applications people install. Windows would be a wonderful OS, if people would just quit installing applications. Solitaire runs. ;) > -Original Message- > From: Mladen Gogala [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2003 4:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Hey Jared > > > Security hole with M$? That would definitely the 1st one! I > mean, it's not > like the security holes > are regular thing with M$. M$ operating systems are known as > rock solid and > completely secure products. > Fox news are fair and balanced. > > > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: date checking ???
>From a sql perspective, you want to trunc(now), to get rid of the time.
As for how to do this in java, I don't know.
> -Original Message-
> From: Andrea Oracle [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 6:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: date checking ???
>
>
> Hi all,
>
> May I ask a javascript question?? (sorry to post
> here!) below is a form checking input date. The input
> date cann't be earlier than today. But it also
> compares hours and minutes which I don't want.
> Suppose you input 08/20/2003, it thinks it's
> 08/20/2003 00:00:00 which is earlier than now
> (08/20/2003 15:30:00). How to solve this?? Thank you!
>
>
>
>
> function validate(){
> var obj = document.forms("shipping");
>
> //$$ sending date cannot be earlier than today
> now = new Date();
> sDate = obj.p_sending_date.value;
> sDate = sDate.substring(0,2) + "/" +
> sDate.substring(3,5) + "/" + sDate.substring(6,10);
>inputDate = new Date(sDate);
> if (inputDate < now) {
> alert("Sending date cannot be earlier
> than today.");
>
>}else{
> alert("ok");
> }
> }
>
>
>
>
>
> onClick="validate();">
>
>
>
>
>
>
> __
> Do you Yahoo!?
> Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> http://calendar.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Andrea Oracle
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Anderson, Brian
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: How to tell Oracle the directories of script files
Keep in mind that, unless they've changed the function, spool also searches the sqlpath for files. If you say: spool modify_users.sql select 'alter user '||username||'whatever;' from dba_users; spool off Spool just looked in your current directory for a file named modify_users.sql to replace, then it followed your sqlpath for a file to replace (file permissions allowing), if it doesn't find one then it creates one in your current directory. > -Original Message- > From: Stephen Andert [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 14, 2003 2:20 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: How to tell Oracle the directories of script files > > > export SQLPATH=/usr/users/oracle/dba/scripts:/app/oracle/admin > > before you run SQL*Plus > > HTH > Stephen > > >>> [EMAIL PROTECTED] 08/14/03 11:09AM >>> > > Hello, > Suppose I have some SQL scripts in my /home/user directories, > /usr/local/bin > directories, etc. > If I start 'sqlplus' from console in /home/user directories, I can > load/execute the script by doing: > SQL> @scriptname > > But what if I don't start sqlplus from that directories? How do I tell > Oracle > to find the scripts in /home/user, then if it's not there in > /usr/local/bin, > for example? So that I can be anywhere in the filesystem when starting > > sqlplus and can execute my SQL script. > > Just like the $PATH environment variables in *nix system that tell the > shell > where to find executables, is there a similar thing for Oracle? > > Thanks for any help. > > RDB > > -- > Reuben D. Budiardja > Department of Physics and Astronomy > The University of Tennessee, Knoxville, TN > - > /"\ ASCII Ribbon Campaign against HTML > \ / email and proprietary format > X attachments. > / \ > - > Have you been used by Microsoft today? > Choose your life. Choose freedom. > Choose LINUX. > - > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Reuben D. Budiardja > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Andert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dba age
I claim 36, making me the youngest DBA here. Of course, myself is the oldest DBA here at 36. And I is the average of our ages. Me, myself, and I work pretty well together, if you ignore all the arguments. > -Original Message- > From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 23, 2003 1:35 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: dba age > > > Well I *AM* 37, and I don't feel old. I'm actually the > youngest DBA in my > group, and it seems like I'm always the youngest wherever I go... > > Robert > > > > > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 7/23/2003 12:14 PM > > King Arthur: "Old woman!" > Dennis: "Man." > KA: "Sorry. Old man! Whose castle is that?" > D: "I'm 37!" > KA: "What?" > D: "I'm 37, I'm not old!" > KA: "Well, I can't just call you 'man'." > D: "Well, you could say 'Dennis'." > KA: "I didn't know you were called Dennis." > D: "You never bothered to find out, did you?" > > At least I'm "only" on the cusp of 35. And I have 6 years > "experience" > with > Oracle. I've lost whole databases, even, thanks to WindohsNoT running > Oracle7. My experience tells me not to put Oracle on Windohs. YMMV. > I've > experienced upgrades, patches, and migrations -- oh my! I've > experienced > the joy that isn't OiD 9.0.2. I've experienced a developer who could > have > sworn he was in the test DB. I've experienced successful > recovery with > zero > data loss and no downtime during core business hours. I've > experienced > AutoRAID. I've experienced BAARF. I've experienced Intel, Alpha, > SPARC, > and PA-RISC. Duhvelopers have experienced my wrath. I have > experienced > my > own wrath during moments of Duh. I've experienced this list, > with it's > many > helpful and some not so helpful members. > > And yet, there's so much I haven't experienced. Like lunch today. > > Standing in for Paul Harvey, > I'm Rich Jesse. Good Day! > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HP-UX 11i/9.2.0.3/Strange Executions
EEN :A6 AND > > :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" > BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 > OR T_00 . "MATNR" BETWEEN > > :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR > T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( > :A20 , :A21 , :A22 , :A23 , > > :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , > :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 > , :A41 , :A42 , :A43 , :A44 , > > :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , > :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 > , :A62 , :A63 , :A64 , :A65 , > > :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , > :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 > , :A83 , :A84 , :A85 , :A86 , > > :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , > :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , > :A103 , :A104 , :A105 , :A106 , > > :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , > :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 > , :A122 , :A123 , :A124 , :A > > 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 > , :A133 , :A134 , :A135 , :A136 , :A137 , :A138 , :A139 , > :A140 , :A141 , :A142 , :A143 > > , :A144 , :A145 , :A146 , :A147 , :A148 , :A149 , :A150 , > :A151 , :A152 , :A153 , :A154 , :A155 , :A156 , :A157 , :A158 > , :A159 , :A160 , :A161 , > > :A162 , :A163 , :A164 , :A165 , :A166 , :A167 , :A168 , > :A169 , :A170 , :A171 , :A172 , :A173 , :A174 , :A175 , :A176 > , :A177 , :A178 , :A179 , :A1 > > 80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187 > , :A188 , :A189 , :A190 , :A191 , :A192 , :A193 , :A194 , > :A195 , :A196 , :A197 , :A198 > > , :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , > :A206 , :A207 , :A208 , :A209 , :A210 , :A211 , :A212 , :A213 > , :A214 , :A215 , :A216 , : > > A217 , :A218 , :A219 , :A220 , :A221 , :A222 , :A223 , > :A224 , :A225 , :A226 , :A227 , :A228 , :A229 , :A230 , :A231 > , :A232 , :A233 , :A234 , :A23 > > 5 , :A236 , :A237 , :A238 , :A239 , :A240 , :A241 , :A242 , > :A243 , :A244 , :A245 , :A246 , :A247 , :A248 , :A249 , :A250 > , :A251 , :A252 , :A253 , > > :A254 , :A255 , :A256 , :A257 , :A258 , :A259 , :A260 , > :A261 ) ) AND T_01 . "SPRAS" = :A262 > > - Call Stack Trace - > > > > --- > > > ====== > = > > Michael P. Vergara > > Oracle DBA > > Guidant Corporation > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Vergara, Michael (TEM) > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web > hosting services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL in the future?
"you are better served by our commercial license" is not necessarily the same as: "you must buy our commercial license." Either way, if you want to verify the license needs for your specific situation, contact the company. > -Original Message- > From: Jacques Kilchoer [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 18, 2003 6:25 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: MySQL in the future? > > > It seems (almost) clear to me from the text at > http://www.mysql.com/products/licensing.html > "This is our licensing policy in brief: Our software is 100% > GPL, and if > yours is also 100% GPL (or OSI compliant), then you never > have to pay us for > the licences. In all other instances, you are better served by our > commercial licence." > > If your application is 100% GPL (Gnu Public License) then you > can use mySQL > for free. > If your application is NOT 100% GPL then you can use mySQL > but you have to > pay for it. > > > -Original Message- > > From: Richard Ji [mailto:[EMAIL PROTECTED] > > > > What? Are you sure? My understanding is if I make changes to MySql > > code or some addon to MySql I need to submit my changes > bakc to public > > and GPL. That what the whole dispute between MySQL the > > company and the > > community before, right? > > > > But my application too? For just using it? What about all > > those sites -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 10i
They have but it's an added feature, and you thought the current license was expensive. > -Original Message- > From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 29, 2003 4:00 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: 10i > > > I thought the database was going to manage itself! > > Now I'm disappointed, I thought they were going to implement > just one nice > big GUI button that does everything. > > Patrice. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: make utility in Solaris 8
Check SUNWsprot and SUNWbtool, these were needed for a 9ias installation on a core solaris 8 install. > -Original Message- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 25, 2003 9:06 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: make utility in Solaris 8 > > > Ross - I'm far from a Solaris guru, but since I don't see > where you received > a reply, here goes. The Oracle install may fail because it > can't complete > the make process. This happens, and requires a fix. But what > makes (no pun > intended) you think the root cause is that the Solaris make > utility was > improperly installed? Now if you are coming from a Micro$oft > background, > that might be a reasonable reaction. ;-) >Are you receiving some error messages during make? > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, March 25, 2003 12:04 AM > To: Multiple recipients of list ORACLE-L > > > Env. Solaris 8 Oracle 817 > > My apologies for this OT posting. I know we have quite a lot > of Solaris > gurus here. > It appears the "make" utility was not installed properly as the Oracle > install keeps failing. > Can anyone tell what the SUN package name where make is in? > Apologies again. > > Rgds, > Ross > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ross Collado > INET: [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Remove killed session from v$session
It should disappear eventually, it sometimes takes a while. Try the immediate clause next time, they don't usually hang around. alter system kill session '&sid,&serial' immediate; > -Original Message- > From: Stefan Jahnke [mailto:[EMAIL PROTECTED] > Sent: Friday, March 21, 2003 8:54 AM > To: Multiple recipients of list ORACLE-L > Subject: Remove killed session from v$session > > > Hi list > > Is there any way to remove a killed session from v$session. Is it even > necessary to do that ? > I ran this: > > select spid, status, osuser, s.program from > v$process p, v$session s where p.addr=s.paddr > > To check for the killed processes' spid in order to remove > the thread (it's > 9.2 on win2k) with orakill. > But for the killed process, no process is shown. So, what's > left ? Should I > even bother or just wait > till Oracle removes the killed session ? > > Regards, > Stefan > > Stefan Jahnke > Consultant > BOV Aktiengesellschaft > Voice: +49 201 - 4513-298 > Fax: +49 201 - 4513-149 > mailto: [EMAIL PROTECTED] > Please remove nospam to contact me via email. > > visit our website: http://www.bov.de > subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp > > Sicherheitsluecken mit IT-Security-Konzepten von BOV > effizient schliessen! > Weitere Informationen unter +49 201/45 13-240 oder E-Mail an > mailto:[EMAIL PROTECTED] > > Wie Sie wissen, koennen ueber das Internet versandte E-Mails > leicht unter > fremden Namen erstellt oder manipuliert werden. Aus diesem > Grunde bitten > wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die > rechtliche Verbindlichkeit der vorstehenden Erklaerungen und > Aeusserungen > ausschliessen. > > As you are probably aware, e-mails sent via the Internet can easily be > copied or manipulated by third parties. For this reason we > would ask for > your understanding that, for your own protection and ours, we > must decline > all legal responsibility for the validity of the statements > and comments > given above. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stefan Jahnke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
hpux 11.0 man dmesg shows the standard setup using /var/adm/messages. dmesg looks in a system buffer for recently printed diagnostic messages and prints them on the standard output. The messages are those printed by the system when unusual events occur (such as when system tables overflow or the system crashes). If the - argument is specified, dmesg computes (incrementally) the new messages since the last time it was run and places these on the standard output. This is typically used with cron (see cron(1)) to produce the error log /var/adm/messages by running the command: /usr/sbin/dmesg - >> /var/adm/messages every 10 minutes. The arguments core and system allow substitution for the defaults /dev/kmem and /stand/vmunix respectively, where core should be a file containing the image of the kernel virtual memory saved by the savecore(1M) command and system should be the corresponding kernel. If the system is booted with a kernel other than /stand/vmunix say /stand/vmunix_new, dmesg must be passed this name, the command must be, /usr/sbin/dmesg [-] /dev/kmem /stand/vmunix_new WARNINGS The system error message buffer is of small, finite size. dmesg is run only every few minutes, so there is no guarantee that all error messages will be logged. AUTHOR dmesg was developed by the University of California, Berkeley. FILES /var/adm/messageserror log (conventional location) /var/adm/msgbuf memory scratch file for - option /dev/kmemspecial file containing the image of kernel virtual memory /stand/vmunixthe kernel, system name list > -Original Message- > From: Deshpande, Kirti [mailto:[EMAIL PROTECTED] > Sent: Friday, March 14, 2003 3:41 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Sun=/var/messages HP-UX=??? > > > What version of HP-UX? > Here is what I get on HP-UX 11.0: > > df2hp105 [IWHA]: ll /var/adm/me* > /var/adm/me* not found > > - Kirti > > -Original Message- > Sent: Friday, March 14, 2003 10:44 AM > To: Multiple recipients of list ORACLE-L > > > Actually /var/adm/messages on hpux is the message file, which > my solaris 8(2.8) machine is also using /var/adm/messages, > maybe I changed this, I don't remember. > /var/adm/syslog/ is the default syslog directory equivalent > to /var/log/ on solaris. > > > -Original Message- > > From: Nelson, Allan [mailto:[EMAIL PROTECTED] > > Sent: Thursday, March 13, 2003 9:20 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Sun=/var/messages HP-UX=??? > > > > > > /var/adm/syslog/syslog.log is the hp-ux equivelant. > > > > -Original Message- > > Sent: Thursday, March 13, 2003 12:59 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I monitor /var/messages on my Sun boxes, does HP-UX have > anytype of OS > > log files worth monitoring? > > > > Thanks, > > Ethan > -- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) machine is also using /var/adm/messages, maybe I changed this, I don't remember. /var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris. > -Original Message- > From: Nelson, Allan [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 9:20 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Sun=/var/messages HP-UX=??? > > > /var/adm/syslog/syslog.log is the hp-ux equivelant. > > -Original Message- > Sent: Thursday, March 13, 2003 12:59 AM > To: Multiple recipients of list ORACLE-L > > > I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS > log files worth monitoring? > > Thanks, > Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send Mail in Unix
I use mutt which has the option to attach a file. mutt -s 'subject' -a filename user@mailserver < /dev/null would send an attachment with no body, put a file instead of /dev/null if you want a body for the message. With mailx in unix, I've been told it can be done by piping through uuencode or something, but I haven't done that. I'm also sure it can be done with perl, some of the perl guru's on the list might be able to provide details. > -Original Message- > From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 10:44 AM > To: Multiple recipients of list ORACLE-L > Subject: Send Mail in Unix > > > All, > > I'm trying to send an email attachment (Oracle Tablespace > Report) from a Sun > Unix box to myself when the batch job runs. > > Anybody been able to do this? I can send the text of the > file, but what I > really want to do is to send the file (it's an Excel Spreadsheet). > > thanks in advance. > > Tom Mercadante > Oracle Certified Professional > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: help set nomail
mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 05, 2003 9:52 AM > To: Multiple recipients of list ORACLE-L > Subject: help set nomail > > > Hi All > > my machine has been rebuilt, with my outlook file lost, thus > I do not have > the mail that describes how to set my account not to receive > mail until I > say so. I sent a message to [EMAIL PROTECTED] with content > : set nomail > Oracle-L. This came back as an invalid list. Could someone > please tell me > how to set my account not to receive any mail, as I am > preparing to fly to > Dallas for the symposium, and have a few other errands to run > before and > after. > > TIA. Regards: > > Ferenc Mantfeld -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLPlus Substitution Variables
Something like this, perhaps.
accept var1 char prompt 'What grantee? ';
select *
from dba_sys_privs
where grantee = upper('&&var1');
> -Original Message-
> From: Erik Williams [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 15, 2003 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQLPlus Substitution Variables
>
>
> I am using substitution variables in SQLPlus, but don't want
> to be prompted
> for their values. I want to set them at the start of the
> script. Kind of
> like a preprocessor directive. Is this possible?
>
> Erik
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Erik Williams
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Anderson, Brian
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Oracle 9i installation - Basic Qs
on the client pc: Right click exceed - tools - configuration - security - host access control list I use file: click edit and add the ip address to let the db server connect to the x-server on your pc. > -Original Message- > From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 26, 2002 9:39 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle 9i installation - Basic Qs > > > > Oracle 9i installation on Solaris being attempted > # xhost + > Message - unable to open display : " " > export DISPLAY=:0.0 > # xhost + > Xlib : connection to client refused "" > Xlib : cannot set display to "" > NOTE - Installation being initiated from a laptop using > Exceed Hummingbird software to simulate Xwindows Console > > Any Solutions ? > > Thanks > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: moving from dedicated connections to MTS
Doc: 125021.1 talks about firewalls. Look for "USE_SHARED_SOCKET " to keep the dedicated connections. > -Original Message- > From: Yechiel Adar [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 19, 2002 11:24 AM > To: Multiple recipients of list ORACLE-L > Subject: moving from dedicated connections to MTS > > > Hello all > > First a little background. > > We work with oracle 8.1.6.3.4 on NT or win2000 servers. > The technical people have just move an application server > behind a firewall. > The application servers access a database that is a central > repository of > user connections (i.e. all applications on the intranet > access this database > for each page for each user). They saw that the application > works fine for a > while and then they get access denied. They track it down to the port > numbers in the firewall. We are working with dedicated > connections and it > seems that the port numbers for each connections are climbing > up until they > exceeded the range of open ports in the firewall. They said > that they had > the same problems in another server, they brought an outside > guy (of course > without telling the DBA group) and he solved the problem. > They brought me > the init.ora file of that database (I can not access it via > the firewall) > and showed me the parameters that made the difference. The guy put in: > mts_dispatchers= ... port=8000) (5 dispatchers). Since they > want me to do it > on a central and essential database I want to ask you guys: > > 1) Any gotcha moving from dedicated connections to MTS? > 2) Is each dispatcher assigned for the current sql command > and then released > or is it assigned for the duration of the session? > 3) What is the ratio of users per dispatcher? > 4) Is there a way to tell oracle to reuse port numbers for dedicated > connections that were closed? > 5) Anything else you care to share. > > Sorry if my questions are somewhat trivial but we need a > decision tomorrow > morning (in 18 hours) as they start doing some training session on the > system on Sunday and time is short. > > TIA > > Yechiel Adar > Mehish > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: AW: Off Topic, slightly - Crystal Reports internal format
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Anderson, Brian 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: Rename Oracle User
If you haven't already done this, the find's are unneeded.
How about replacing 1,3,4 with:
create dba group
usermod -l oracle -g dba oracle2
Since the ownership's in UNIX are by UID, if the username is changed
then all the files are now owned by the new username(same UID).
shutdown
BACKUP
usermod
update scripts
startup
> -Original Message-
> From: Todd Carlson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 10:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Rename Oracle User
>
>
> Solaris 5.8 Oracle 8.1.7.2
> Has anyone successfully renamed the Oracle user on a solaris
> box? At the
> moment I don't a test box and this is a rarely used
> development system.
> The current Oracle user and group are oracle2 and dba2. We have to
> change it to match our standards, i.e. oracle & dba.
>
> The plan is to (after a full system backup):
> 1) Create the correct local user & group with the same home
> directory.
> 2) Shutdown all Oracle processes.
> 3) Find . -user oracle2 -exec chown oracle {} \;
> 4) Find . -user dba2 -exec chgrp dba {} \;
> 5) Modify all scripts to use the correct group & user.
> 6) Pray.
> 7) Start the database and listener.
> 8) Check for functionality & errors.
> 9) Shut everything down and take a full system backup.
>
> Am I missing anything? Is there any problems with the method?
>
> Thanks,
> Todd Carlson
> Oracle Database Administrator
> Tripos, Inc.
> (314) 647-8837 Ext.3246
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Todd Carlson
> 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: Anderson, Brian
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: lsnrctl - can I remove world executable privileges?
lsnrctl < -Original Message- > From: Miller, Jay [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 20, 2001 1:28 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: lsnrctl - can I remove world executable privileges? > > > Thanks, I'll probably do this also now, after I change the > permissions. > How does one code a password into a script to stop and start > the listener? > > Jay Miller > > -Original Message- > Sent: Tuesday, November 20, 2001 11:30 AM > To: Multiple recipients of list ORACLE-L > > > Give the listener a password. > > -Original Message- > Sent: Tuesday, November 20, 2001 7:56 AM > To: Multiple recipients of list ORACLE-L > > > Had a bit of a shock this morning. I never knew that the lsnrctl was > -rwxr-x--x by default and a random unix user shut down the > listener on our > production database. > > Is there any reason not to change the privileges on this > file, making it > -rwxr-x---? Is there a reason it's set this way? This seems > like a big > security hole. > > Jay Miller > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > 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: 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: Miller, Jay > 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: Anderson, Brian 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: Intelligent Agent
I don't have 8.0.3 or Tru64 UNIX to look at, but on HPUX we have $ORACLE_HOME/network/lib in the SHLIB_PATH. Check if the library it is looking for is in $OH/network/lib, and try adding that to your env. > I recently installed Compaq's Tru64 UNIX 5.1a on an Alpha > 2100 server I had > lying around. It is to be used for minimal software > development with Oracle > and general testing. > > I was able to get Oracle installed (8.0.3) without much of a > hitch. The > problem arose when I tried starting the listener (lsnrctl > start). It gave > the Fatal Error: Cannot map library libclntsh.so.1.0. I was > able to fix the > problem by resetting the LD_LIBRARY_PATH variable to include > $ORACLE_HOME/lib and $ORACLE_HOME/obackup. After the change, > the listener > started up, and I was able to mount the database. > > My issue is with the Enterprise Manager's Intelligent Agent - > dbsnmp. When > I try to run dbsnmp_start under lsnrctl, I'm getting the > library map error > again, but the variable is set correctly. Is there another > variable I'm not > aware of? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: financial problems with fatcity.com
> Do we get a t-shirt, like for PBS? > > My 5-year old son got a great DragonTales t-shirt. > > Now we have to think of a caption for the t-shirt. Didn't we already cover the T-shirt question a while back? Help!!! Are You An Idiot? ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: How do you audit a DBA?
I want to be required to take 2 weeks vacation. > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 3:37 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:RE: How do you audit a DBA? > > > Dick, > > Actually, many states are "work at will" -- which means the > company can fire > you because. No reason, just because. > > The idea of sending the DBA off on a training course -- NYS > has a similar > concept in the state banking laws. Anyone working for a > state-chartered bank > who has more than 2 weeks of vacation is required to take two weeks > consecutively, those with 2 weeks or less have to take a > week. The theory > is, if you are "cooking the books" it should come to light in > that time > period. > > Rachel > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: How do you audit a DBA?
This has been discussed before, I'll try to summarize it as I remember. Sure, you could put triggers, turn on auditing, whatever. But the DBA by nature of his job function, can disable, remove, whatever you turn on. So it basically comes down to trusting your DBA, or getting a new DBA. > -Original Message- > From: Dave Leach [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 11:56 AM > To: Multiple recipients of list ORACLE-L > Subject: How do you audit a DBA? > > > Anyone who can help, > > I've been asked if Oracle can somehow audit the DBA ie. Raise > an alert if > the DBA were to execute DML statements against sensitive tables, this > assumes the DBA has the SYS password. I thought this was a pretty > reasonable question but couldn't think of an answer. My > trail of though was > maybe an email alert to a designated member of staff sent via > a trigger on > the table. > > Any comments would be very appreciated. > > Dave Leach > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: database upgrade policy?
Just for the PLEASURE of using OUI! > -Original Message- > From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 22, 2001 6:07 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: database upgrade policy? > > > I have people here who just want to upgrade for the sake of > upgrading...rrggg..ok.:) > KK > > -Original Message- > Sent: Wednesday, August 22, 2001 5:01 PM > To: Multiple recipients of list ORACLE-L > > > Well, we wanted to upgrade from 8.0.4 to 8.1.6 last year > because it had been > desupported. We got most of the machines upgraded except for the main > production machine. I wanted to upgrade that last September. I have > finally gotten permission to tentatively schedule the for > next month (one > year later), just in time for the 8.1.6 desupport notice. Sigh. > > -Original Message- > Sent: Wednesday, August 22, 2001 3:36 PM > To: Multiple recipients of list ORACLE-L > > > Lisa, > You need some work to do > Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze? > ROR mô¿ôm > > >>> [EMAIL PROTECTED] 08/22/01 12:45PM >>> > Don't upgrade unless there is a very good reason. > > All of these are candidates > > 1. current oracle version is unstable > 2. specific bug addressed by an upgrade/patch, as identified > by support > 3. need to utilize new feature > 4. desupport date coming up. > > If it works, don't fix it! > > Don't do it just for fun. Because it can turn into HELL. > > Lisa Koivu > Certifiable Gimp Monkey (and DBA) > Ft. Lauderdale, FL, USA > > > -Original Message- > > From: Mark Marsden [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, August 22, 2001 11:45 > > To: Multiple recipients of list ORACLE-L > > Subject:database upgrade policy? > > > > Hi Listers > > > > I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?) > > as I get the occasional ORA-600/ORA-7445. > > > > Do you upgrade to the latest subversion as a matter of policy > > (and not test very much) to prevent possible errors > > or only upgrade if you have problems? > > > > Do you upgrade to major versions (7 to 8.0 to 8.1) for increased > > functionality, cos Oracle are desupporting (the main reason > we upgrade) > > or to improve the CV ;-) with the possible downside of instability. > > > > Mark. > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Disaster recovery
I need to do some documenting too. Person probably driving the bus ;-) (That person thats been stalking you) Oracle Versions Patches installed File system layout Instances mapped to Oracle Homes log files (methods for checking/trimming) scripts/tools (what/where/when/why) listener info (name/port) passwords (available from a secure location) backup practices > -Original Message- > From: O'Neill, Sean [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 21, 2001 5:46 AM > To: Multiple recipients of list ORACLE-L > Subject: Disaster recovery > > > >>I have to document our Oracle databases for the case where > I'm e.g. hit by > the proverbial bus. So if you DBA folk were to >>come on > site to pick up > the tab and start managing our databases what information > would you like to > be able to refer to, to >>allow you get up to speed as > quickly as possible > with our set-up. > > Rachel and Bruce, thanx for your input on this. Some points > ya'll made I > had not considered. I'm sure there are more. Come on folks > let's hear your > input on this. I'll publish a list to the list when it looks > as though all > avenues have been explored!. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Code Red
> The trouble with code red was that it went through port 80, > which is left > open by firewalls because that is the port used for HTTP pages (WWW). > Closing that would mean no one could access Web pages. So > firewalls won't > help you re. things like that. You can now go through any > ports that are > left open, and there is software out there to detect ports > that were left > open. Start up apache on port 80 and you can see the hits from code red in the log files. I'm waiting for them to get really advanced code red 6, "The IIS hunter killer", which scans for ports running IIS, and hits it at other ports. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Code Red
Can read all about sadmind at cert. http://www.cert.org/advisories/CA-2001-11.html > -Original Message- > From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 08, 2001 10:11 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Code Red > > > Paul, > Thanks for the assist, I tried to find the name on line > but definatly > couldn't find it. Interesting thing though, we don't have > Solaris machines > here, so I am assuming it can exploit the NT weakness on it's own! > KK > > -Original Message- > Vincent > Sent: Wednesday, August 08, 2001 5:46 AM > To: Multiple recipients of list ORACLE-L > > > We got that a few weeks ago - exactly the same message on one > of our NT > servers. This was before people were talking about "Code > Red". Apparently > it's known as the "sadmind" virus. It exploits a weakness in Solaris > security to get into a Solaris server. From there, it sniffs > out any NT > servers (or networked workstations) which are running IIS, > and then exploits > an NT security loophole to replace the default webpage on the > NT server with > that "f*** the US Government" message. Our sysadmins tell me > this is well > documented at all the usual virus information websites. Just > look under > "sadmind". > > > Paul Vincent > Database Administrator, University of Central England > > > > -Original Message- > > From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] > > Sent: 07 August 2001 18:27 > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Code Red > > > > > > Yeah, that's what I read. I had applied the patch and I > > don't have Code red > > or Code Red II, however it appears that I have something > > else. It doesn't > > seem to have worked but it looks like someone tried to deface > > our website. > > It's just a message that says "f--k the us government and > > f--k poisonbox", > > not sure what to do with it yet. > > KK > > > > -Original Message- > > Brian > > Sent: Tuesday, August 07, 2001 12:56 PM > > To: Multiple recipients of list ORACLE-L > > > > > > The worm is just memory resident, so a reboot should get rid > > of it, BUT > > without the patch, you'll get it right back. > > > > The problem for the new version is it deposits a trojan > > backdoor on your > > server. > > Mcafee dat 4152 is supposed to find the trojan, I'm sure other virus > > scanners are releasing versions also. Check with your > > anti-virus site. > > > > > -Original Message- > > > From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, August 07, 2001 11:56 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Code Red > > > > > > > > > So does anyone know how to get rid of the virus if you got it? > > > > > > Sincerely, > > > Kevin Kostyszyn > > > DBA > > > Dulcian, Inc > > > www.dulcian.com > > > [EMAIL PROTECTED] > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Kevin Kostyszyn > > > 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: Anderson, Brian > > 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, se
RE: Code Red
The worm is just memory resident, so a reboot should get rid of it, BUT without the patch, you'll get it right back. The problem for the new version is it deposits a trojan backdoor on your server. Mcafee dat 4152 is supposed to find the trojan, I'm sure other virus scanners are releasing versions also. Check with your anti-virus site. > -Original Message- > From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 07, 2001 11:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Code Red > > > So does anyone know how to get rid of the virus if you got it? > > Sincerely, > Kevin Kostyszyn > DBA > Dulcian, Inc > www.dulcian.com > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kevin Kostyszyn > 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: Anderson, Brian 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: For those who got Code Red in the face
I would check quickly for these files, http://vil.nai.com/vil/virusSummary.asp?virus_k=99177 Presence of the files: c:\inetpub\scripts\root.exe c:\progra~1\common~1\system\MSADC\root.exe d:\inetpub\scripts\root.exe d:\progra~1\common~1\system\MSADC\root.exe. Also make sure your virus protection is up to date, it should let you know if the back door put in by the latest code red is on your machine. > -Original Message- > From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 06, 2001 6:25 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: For those who got Code Red in the face > > > Our webserver got hit a couple of weeks ago. It got cleaned > up and the > security patch(es) applied. I thought nothing more about it. > > However, I think it or a variant got three of our other Win2k > servers that > don't run IIS at all. Yesterday I found a strange process, > VMGR32.exe, > chewing up 50% CPU on our production db server. The file, in > C:\WinNT\System32, was dated 07/30/2001 08:40pm. Another > file, acer4.exe, > of exactly the same size, 272KB, had exactly the same > datetime. Neither > file shows the usual "Version" tab in the Properties window > (after right > click on the file). I searched the Microsoft site and did a > Google search > on both, with zero hits. Suspicious... > > I checked out > http://www.net-security.org/text/articles/coverage/code-red/ > but couldn't see any similarities until it suggested running > netstat -an to > see if your server was connecting to dozens of random IP > addresses at port > :80. I did and ours was! > > I changed the service "Remote Administration Service" (which loads > VMGR32.exe) to Manual and rebooted the servers. The > connections to random > IP addresses at port :80 have stopped and VMGR32.exe is no > longer running as > a process. > > I also installed Win2k Service Pack 2. > > I hope I've squashed this worm! Have I? Are the port :80 > connections and > VMGR32.exe related or have I been chasing the wrong culprit? The NT > sysadmin at our colocation facility isn't a lot of help (one > reason we're > looking to switch pretty soon!), so I'm kind of at a loss. > > Any suggestions? > > Thanks. > > Jack > > > Jack C. Applewhite > Database Administrator/Developer > OCP Oracle8 DBA > iNetProfit, Inc. > Austin, Texas > www.iNetProfit.com > [EMAIL PROTECTED] > (512)327-9068 > > > -Original Message- > [EMAIL PROTECTED] > Sent: Monday, August 06, 2001 2:24 PM > To: Multiple recipients of list ORACLE-L > > > New worm targets same systems as Code Red > > Security analysts warned that a new and potentially dangerous > worm began > circulating over the weekend, targeting the same > Windows-based servers as > the > high-profile Code Red worm. > > http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62834_NLTAM%2C00.html > -- > > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: computer history stories - Now: Age discrimination?
In South Georgia, the standard practice is to carry a disposable cup. -Original Message- Sent: Monday, August 06, 2001 3:00 PM To: Multiple recipients of list ORACLE-L > -Original Message- > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] > > There are about 1200 permanent employees here. You can't > spit without hitting someone with a physics doctorate Try aiming downwards at a spittoon or a trash can instead of sending your projectiles in a horizontal trajectory. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
t; LOCAL SERVER > > ora2000 has 6 service handler(s) > > DEDICATED SERVER established:76 refused:0 > > LOCAL SERVER > > The command completed successfully > > > > > > init.ora looks like: > > > > mts_dispatchers = "TCP,5" > > mts_max_dispatchers=50 > > mts_servers=20 > > mts_max_servers=50 > > LOCAL_LISTENER = "(ADDRESS_LIST = (Address = (Protocol = > TCP) (Host=ora2000) > > (Port=1521)))" > > > > > > Thanks > > Harvinder > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Harvinder Singh > > 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). > >W±ëzØ¡÷r&9,B¶Yà > §©Ê뢷jSz7jSzɨ¡Êrq´(È×ÂSIê?ÇóYßÎçQ_ÎçÓjpz > jX¢¹hû-'z×ëqdzóSXEUR¸¶ÄDCTLº»*÷¢kSÉSX'X¶Çu©1¨(tm)ëj > ¸´k¹ör+r?¢×\²--)¡ò²Ñ®æv)...é²Æxb)-çjXyʵ¨Sx5%9,B®Ø©¡ùSX'X·*Á© > ¶?é½ç®?¢éÉ©¢ÇvØ Br?jw¢º...êú(tm)«¢y'ënÇ?¸ > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: computer history stories - Now: Age discrimination?
I'm 34 with a 10 and 11 year old, and recently a -6 month old, and I sure feel old sometimes. But in this discussion, I guess I'm a teen. BLA > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 03, 2001 12:47 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: computer history stories - Now: Age discrimination? > > > I don't want you to feel to old, but at last count I have 5 > sons and 20 grandchildren. Grandchildren range from 16mo to > 16 years old. Birthdays and Christmas are expensive. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 08/03/01 11:40AM >>> > Actually this whole thread is making me feel a whole lot better !!!. > > I am 37 and was a bit concerned as to the age of many of the > people on this > list (thinking I may be a lot older than most) I'm glad I appear to be > mistaken.. It seems strange but all the DBAs I know in this > country as well > are in their 30s or older. All the younger guys I know want > to be Software > Engineers (JAVA etc) and HTML people, they all see the > DBA/S.A arena as > something that takes too long to learn well and therefore not > worth it. > Maybe there is a future after all :-)) > > Lee > > > > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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 -- suggestions to ensure nerdiness in potential IT staff
I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3. For those not in the US, it's from an old TV commercial. I started playing on Commodore-64's in high school in 1982. I've still got some of those Verbatim 5.25 disks in the closet at home. > > > >What is the language that uses a turtle for teaching children about > >computers? What language was it based on? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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 -- suggestions to ensure nerdiness in potential IT staff
> > How would you convert a 1-sided 5 ¼" diskette into a 2-sided one? > > Flip the floppy and cut a notch. I actually used scissors. > I loved it when > they came out with those precise clippers. ***I just used a plain hole punch > > What colour were the Verbatim 5 ¼" diskette pockets? > > Was it grey? Was that 3Ms? I remember paying 50 bucks for > 10 floppies. I > thought it was a great deal!! > *** It was pink > > What IBM PS/2 model was listed as having a 2.88M diskette drive? > > Sorry, I went with all the generic PCs. *** I don't remember what IBM had them, but my old generic 486 has one. > > Did the first macintosh computer come with a handle? *** No, I don't believe it did. > > Extremely important entertainment bonus question: What > cartridges came > with > > the Atari 2600 game system upon initial purchase? > > Asteroids, I think. I never got an Atari, but I would guess pong. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Largest Oracle Databases
Actually, speaking from a state college, the official policy is you get forwarded around and put on hold for a couple hours, until you get to someone sitting in a closet somewhere at the public information desk, who will research your question and send it right to you in 6 - 8 months. -Original Message- Sent: Tuesday, July 31, 2001 10:31 AM To: Multiple recipients of list ORACLE-L yeppers thats exactly what i'm saying they have to tell you the metrics but not what they store. joe >>> [EMAIL PROTECTED] 07/31/01 09:55AM >>> Are you saying that if I called up the CIA and said "Hey guys, I was just wondering how many bytes you db's are and what platform your using" they would HAVE to tell me:? That's sweet!!! I'll give them and the NSA a call, if I disappear, you'll know why:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Anderson, Brian 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: UNIX SCRIPT ISSUE - URGENT
for i in `ls`
do
YourScript.shl $i
done
Unless you are also processing your newfile.dat in the script you need
to make unique names for the output files.
Something like:
sed "s/Report by Hosts/$IP| Report by Hosts/" $FN > new_${FN}.dat
so you will get an output file from each input file.
> -Original Message-
> From: Johan Muller [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 25, 2001 10:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: UNIX SCRIPT ISSUE - URGENT
>
>
> I need to extract the first 16 bytes of a filename (AIX 4.3)
> which consists of
> an IP address (nnn.nnn.nnn.nnn), and move that to first 16
> positions in the
> file itself, plus adding a pipe (|) sign for a delimiter, and
> save the IP
> address as a file name with a .dat extension, before loading
> the contents into
> a table.
>
> My predecessor concocted the following:
>
> #!/usr/bin/ksh
> FN=$1
> IP=`echo $FN|cut -c1-16`
> sed "s/Report by Hosts/$IP| Report by Hosts/" $FN > newfile.dat
> #-- End of file
>
> which is great for a single file at a time.
>
> Right now I have to perform this surgery on 19 986 files,
> which is in one
> place.
> Using the script above would take me over 20 000 hours.
>
> Any way I can grab the files one at the time based on a ls
> command, and invoke
> the script, and to end up when the last file has been processed.
>
> ALTERNATIVE:
>
> Each file contains the IP address which has to move into the
> first position
> after a string on line 13 which you guessed it: is called 'IP
> Address:'. Is
> their a way vi could be used to achieve the same result?
>
> Any input would be appreciated,
>
>
> Johan Muller
>
> __
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with
> Yahoo! Messenger
> http://phonecard.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Johan Muller
> 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: Anderson, Brian
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: SHARED SQLNET.ora? RE: tnsnames.ora in clients
We have a shared location for on campus, and it's working with tnsnames.ora and sqlnet.ora. But for laptops going off campus they have a local copy, updated as needed from the network copy. > -Original Message- > From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 24, 2001 2:16 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: SHARED SQLNET.ora? RE: tnsnames.ora in clients > > > Hi Ed, > We use ONAMES. We had tried putting SQLNET.ora on the shared > drive. It was > working. However, they later found out that accessing it at > all times from > various locations was not always the fastest, easiest and > acceptable way. We > have a number of portable clients. And all shared drives are > not always > mapped as it depends on how they chose to connect/dial-in. > So, lately we > just keep a master copy of SQLNET.ora on a shared drive. We > seldom change it > (we use aliases for the Servers running the Names). As new clients > (laptops) are deployed, the PC support team just copies it to > the PCs from > the shared (master) location. And this process has been > working great for a > few years now. > > If you need any specific information, please let me know. > > Thanks. > > Regards, > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Haskins, Ed [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, July 24, 2001 12:29 PM > > To: Multiple recipients of list ORACLE-L > > Subject:SHARED SQLNET.ora? RE: tnsnames.ora in clients > > > > Has anyone been successful with putting the SQLNET.ora file > in the same > > shared location as the TNSNAMES.ora file? I know it's > supposed to be used > > solely on the user workstation in /network/admin > (Net80/admin), but some > > people are trying to place it on the shared drive as well. > > > > We're actually implementing ONAMES, so we're replacing the > SQLNET.ora file > > to specify ONAMES, and some Regions are thinking they only > need to place > > this on the shared drive where TNS_ADMIN points to. I > don't think this is > > supported or works in all situations. Any experiences or comments?? > > > > Ed > > > > -Original Message- > > Sent: Tuesday, July 24, 2001 1:02 PM > > To: Multiple recipients of list ORACLE-L > > > > > > We use a shared tnsnames.ora from a NT server. > > > > > -Original Message- > > > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, July 23, 2001 2:33 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: tnsnames.ora in clients > > > > > > > > > Does this method of "sharing" the tnsnames work for you? What > > > operating system are you using? I use Novell and when I tried > > > this method of sharing the tnsnames it wouls not work. We had > > > to resolve to downloading the latest copy to the users when > > > they logged in. > > > ROR mª¿ªm > > > > > > >>> [EMAIL PROTECTED] 07/23/01 11:41AM >>> > > > You can write a script and each time when a user logs > into a domain > > > it will check and copy the latest tnsnames.ora file. Or > you can just > > > place the tnsnames.ora file on the network drive and > point everyone > > > to it. > > > > > > >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> > > > Hello All, > > > > > > Good morning! > > > I would like to know how the 'tnsnames.ora' file on all > > > client(windows) > > > machines can be updated automatically whenever something > changed on > > > central 'tnsnames.ora' file. > > > Is this the process still being used extensively or else > > > advanced features > > > like ONS. > > > > > > Your suggestions are highly appreciated. > > > > > > Thanks, > > > > > > Suren > > > Consultant DBA > > > Sony > > > -- > > > -- > 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 &
RE: tnsnames.ora in clients
We use a shared tnsnames.ora from a NT server. > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 23, 2001 2:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: tnsnames.ora in clients > > > Does this method of "sharing" the tnsnames work for you? What > operating system are you using? I use Novell and when I tried > this method of sharing the tnsnames it wouls not work. We had > to resolve to downloading the latest copy to the users when > they logged in. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 07/23/01 11:41AM >>> > You can write a script and each time when a user logs into a domain > it will check and copy the latest tnsnames.ora file. Or you can just > place the tnsnames.ora file on the network drive and point everyone > to it. > > >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> > Hello All, > > Good morning! > I would like to know how the 'tnsnames.ora' file on all > client(windows) > machines can be updated automatically whenever something changed on > central 'tnsnames.ora' file. > Is this the process still being used extensively or else > advanced features > like ONS. > > Your suggestions are highly appreciated. > > Thanks, > > Suren > Consultant DBA > Sony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tirumala, Surendra > 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: Richard Ji > 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: 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Exp/Imp - suppress screen output?
1 is standard output 2 is standard error > -Original Message- > From: Michael E. Cupp, Jr. [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 20, 2001 10:41 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Exp/Imp - suppress screen output? > > > Why 1 >/dev/null 2>dev/null and not just >/dev/null > > -Original Message- > Surendra > Sent: Friday, July 20, 2001 10:15 AM > To: Multiple recipients of list ORACLE-L > > > use this.. > > exp usn/pwd 1>/dev/null 2>dev/null > > Suren > > -Original Message- > Sent: Friday, July 20, 2001 9:15 AM > To: Multiple recipients of list ORACLE-L > > > Does anyone know of a way, within Unix, to suppress > the screen output from the Export and Import > utilities? > > Thanks! > -w > > __ > 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: Walter K > 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: Tirumala, Surendra > 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: Michael E. Cupp, Jr. > 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: Anderson, Brian 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: some thing strange with user_tables vs real table
Wow, I actually know the answer to this one. It's a known result of tables from Access, they can end up lower case, mixed case, whatever. You have to use the quotes around the name, like you did in the second select. You could get rid of this by: create table new_tmp_april as select * from 'tmp_april'; So new_tmp_april would be a regular oracle named table. > -Original Message- > From: Ari, Rama [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 19, 2001 4:32 PM > To: Multiple recipients of list ORACLE-L > Subject: some thing strange with user_tables vs real table > > > One of our programmer had imported a table from ACESS database. > > When I query user_tables I get following result. > SQL> select table_name from user_tables where table_name= 'TMP_APRIL' > > no rows selected > > SQL> select table_name from user_tables where table_name= 'tmp_april' > > TABLE_NAME > -- > tmp_april > > When I query tmp_april table I get following result. > SQL> select count(*) from tmp_april; > select count(*) from tmp_april > * > ERROR at line 1: > ORA-00942: table or view does not exist > > SQL> select count(*) from TMP_APRIL; > select count(*) from tmp_april > * > ERROR at line 1: > ORA-00942: table or view does not exist > > For some reason, table name has been stored as tmp_april > (lower case). When > we create table it supposed to store table name with upper case. > > Did any one had similar kind of problem? > > Thanks in Advance, > > Rama Ari > Database Administrator > [EMAIL PROTECTED] > 610.964.5128 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ari, Rama > 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: Anderson, Brian 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: Could not Connect to 8.1.6
I haven't tried it, or seen it myself, but some people here in the state have said there is a problem connecting from an 8.0.5 home to an 8.1.6 database. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 28, 2001 12:01 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Could not Connect to 8.1.6 > > > Did you update your listener? And TNSNAMES? > -- Reply Separator -- > Author: [EMAIL PROTECTED] (N J Neog) > Date: 4/27/01 9:40 PM > > Hi all, > > We 3 Oracle server as follows. > > A. Oracle8 Enterprise Edition 8.0.5 > B. Oracle8i Enterprise Edition 8.1.5 > C. Oracle8i Enterprise Edition 8.1.6 was Installed Recently. > > All are in Digital Unix > > The problem is > > From a Unix user if my ORACLE_HOME is pointing to database > A(8.0.5) or > B(8.1.5), > > we can connect from Sqlplus to Oracle Server A and B not to C (8.1.6.) > But If ORACLE_HOME is pointing to C(8.1.6), Sql Plus can > connect to all > database. > > > Is there a problem with 8.1.6 ? or had we Installed 8.1.6 wrongly ? > Any suggestion how to rectify it assuming my ORACLE_HOME always > points to 8.1.5 or 8.0.5. > > Thanks in advance > > Regards. > > Naba J Neog > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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).
Further OT: Dr. Strangelove
Or was it "Purity of Essence" Protect your bodily fluids. If you don't get the President on the phone, you'll have to answer to the Coca-Cola Company. A GREAT MOVIE. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > Michael Sun wrote: > > Peace on earth and de-fragmented Oracle database everywhere. > > "Peace on earth" was the password from the movie called "Dr. > Strangelove", > in my opinion one of the best movies ever made. De-fragmented > databases > are not an issue any more now that we have locally mismanaged > tablespaces. > -- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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's ftp site
> ftp://external-ftp.us.oracle.com > ftp://205.227.44.220 > ftp://oracle-ftp.oracle.com These worked for me. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > -Original Message- > From: Murray, Margaret [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 17, 2001 11:01 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle's ftp site > > > Anybody know where oracle has moved (hidden) their ftp address now? > > What doesn't work: > ftp://external-ftp.us.oracle.com > ftp://209.246.5.40 > ftp://205.227.44.220 > ftp://oracle-ftp.oracle.com > > > In case it helps, the error I get says "An error occurred reading the > contents of the folder. Make sure the file name is valid and you have > permission to access the location specified. > Details: The connection with the server was reset." > > > Thanks for any help, > Margaret Murray > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Murray, Margaret > 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: Anderson, Brian 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: stupid DBA
> http://www.darwinawards.com > > excerpt: > >Literary Reference > >The existence of Darwin Awards shows that we apparently >do need common sense warnings like, > >"Caution: Batman cape does not enable wearer to fly." > OF COURSE, you have to have the SUPERMAN cape to FLY!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: newbie Q: what is the maximum number of logfile member per gr
Look in docs for CREATE DATABASE command, maxlogfiles and maxlogmembers are defined at database creation and stored in the control files. To change it you must recreate control files. You probably don't want to oversize this by much, as the control files grow to leave space for the log entries. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > -Original Message- > From: Dulce L. Cajigas [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 09, 2001 4:50 AM > To: Multiple recipients of list ORACLE-L > Subject: newbie Q: what is the maximum number of logfile member per > group? > > > We tried adding an additional member to an existing group but an error > message told us that we can not add another member becoz the > maximum is 2 > only. What file should i check to see where it was set up initially. > > thank you so much and hoping for an answer. > > dulce > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dulce L. Cajigas > 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: Anderson, Brian 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 being scalable
move the tml back up to the .h (wintergrp.html) > > > > > http://www.oracle.com/ip/deploy/database/featurestory/index.ht > ml?wintergrp.h > > tml > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Exp/imp into different version
Sure is. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > -Original Message- > From: Connie Milliken [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 12:26 PM > To: Multiple recipients of list ORACLE-L > Subject: Exp/imp into different version > > > Is is possible to take a full database export from Oracle > 8.0.5/HPUX and > import it into Oracle 8.1.6/HPUX? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Connie Milliken > 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: Anderson, Brian 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 : Sinclair was RE: Metalink Again
I thought it was a green dinosaur on their signs, maybe they were just faded. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > And I thought it was an old oil company. Their gas station > symbol was a > dinosaur (not to be confused with "put a tiger in your > tank"). I vaguely > recall the Sinclair exhibit at the 1967 World's Fair, and I > still have a > blue plastic model of one of their dinosaurs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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 : Sinclair was RE: Metalink Again
I've got my Commodore 64. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > Any more spectrum owners out there that want to admit to it ? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> -Original Message- > > Just keep the supply of Diet Coke coming. :) > Make that "Tab", for me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: problem with UTL_FILE.FILE OPEN
I believe * is valid (though I can't find the page in a book right now),
though it could be dangerous, utl_file writes as oracle, make sure some
duhveloper doesn't overwrite/append to your datafiles.
Look at the UTL_FILE.FOPEN commands and verify the paths.
lv_log_file:= UTL_FILE.FOPEN('/dir1/dir2/dir3','logfile.dat','A');
Brian L. Anderson
Flunky/SA/DBA
Darton College
[EMAIL PROTECTED]
> -Original Message-
> From: Dasko, Dan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 14, 2001 10:07 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: problem with UTL_FILE.FILE OPEN
>
>
> I thought that a directory had to be specified by name in
> initora. I don't
> think you can specify a wildcard or a higher level directory.
> I could be
> wrong.
>
> Dan
>
> -Original Message-
> Sent: Wednesday, March 14, 2001 5:16 AM
> To: Multiple recipients of list ORACLE-L
>
>
> List hi!
> Oracle817 on AIX. (64 bit)
> We have defined in initora file UTL_FILE_DIR=*
> When we start function UTL_FILE.FOPEN it raises exception
> INVALID_PATH.
> Everything is set and available (permissions are 777).
> Do you have any idea what's wrong?
>
> TIA,
> Sonja
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
> 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 message has been scanned for the presence of all
> known computer
> viruses by the MessageLabs Virus Control Center. However, it is still
> recommended that you use local virus scanning software to
> monitor for the
> presence of viruses.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dasko, Dan
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anderson, Brian
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: questions: security on the unix
Mine are all 640. Check who owns the datafiles. Brian L. Anderson Flunky/SA/DBA Darton College [EMAIL PROTECTED] > -Original Message- > From: Mitchell [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 23, 2001 1:32 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: questions: security on the unix > > > DBAs > > Whis is right security for oracle datafile. 640 or 777 or others. > > I found today in my AIX that some oracle datafile is 777 or > some are 660. > But when I chmod 644 for those 777 files. The user could not > do update and I > had to change back. what is wrong > > How about sys file. Mine is 666 currently. I think should be > 640. Any idea? > > Mitchell > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mitchell > 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: Anderson, Brian 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: OFFTOPIC: Spam, Death, the Universe, and Everything
Wasn't Eddy Haskell the friend of Wally on "Leave it to Beaver" who always caused trouble. -Original Message- I just sent out a team of hunter/killer mercenaries to kill EVERYONE associated with Eddy Haskell, OraKnowledge, OCP, Oracle, and having anything to do with data, information, or the Internet in general. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: this drove me crazy!!!
select * from table where 1 = 1 /* and insert into table ... */; seems to work fine as long as it is formatted with the proper characters surrounding the statement. Why do you want to put an insert into a select? Is the desire to select the records that are being inserted or what? Brian L. Anderson Flunky/SA/DBA Darton College [EMAIL PROTECTED] > -Original Message- > From: Abdul Aleem [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 12, 2001 7:42 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: this drove me crazy!!! > > > Yes! he can, as a matter of fact he can even write a complete > song in WHERE > clause, its just that it won't work :) > HTH! > -Original Message- > Sent: Sunday, February 11, 2001 1:25 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: this drove me crazy!!! > > I think your customer is just testing your treshold for insanity > > [EMAIL PROTECTED] wrote: > > > > Hi d.b.a people, > > how r u? > > I'm an Oracle DBA and my customer told me something that drove > > me crazy,he told me that he could write an 'insert statement' in the > > 'where' clause of a 'select' statement. > > Is this true? and if so,could you kindly tell me how? > > thanks alot > > > > > > Get free email and a permanent address at > http://www.netaddress.com/?N=1 > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: MOHAMMAD AMER > > 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 own FREE, personal Netscape Webmail account today at > http://webmail.netscape.com/ > -- > 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: Abdul Aleem > 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: Anderson, Brian 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: unix cron
On Solaris 7 (probably the same as 2.6) as root: /etc/init.d/cron stop /etc/init.d/cron start Brian L. Anderson Flunky/SA/DBA Darton College [EMAIL PROTECTED] > -Original Message- > From: Arslan Bahar [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 06, 2001 9:11 AM > To: Multiple recipients of list ORACLE-L > Subject: unix cron > > > > how can i start and stop cron deamon on solaris 2.6 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arslan Bahar > 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: Anderson, Brian 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: OT NT2K vs Unix.
The future of computers, look at the games of today. Brian L. Anderson Flunky/SA/DBA Darton College [EMAIL PROTECTED] > -Original Message- > are some that I can think of). Heck, I wouldn't be surprised > if the code > for some database query optimizers trace back to some gaming > AI code. :) > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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).
