Re: linux
Hi, I've heard on a OpenBSD mailinglist about such thing. Seems that they've made it after some adjustments. Go to the FreeBSD mailinglists for these questions. oli [EMAIL PROTECTED] wrote: > Hi Friends, > I have small clarification to be made. > Can oracle for linux software be intalled on FREE BSD. > > Thanks in advance > > Saravana > > > Content-Type: text/html; charset="iso-8859-1"; name="Anhang: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: OPS on LINUX
Hi, I think it works only with 817 oli [EMAIL PROTECTED] wrote: > Hi, > 1) I have set up a cluster of INTEL machines on INTEL PIII using > LINUX Redhat 6.2 . > > 2) I have installed Oracle 8.1.6 on LINUX redhat 6.2 . The database > is on raw devices. > > 3) When I try to install OPS option , I get a message saying OPS not > supported on LINUX . > > > Has any one been able to configure OPS on LINUX. ? What are the > Related versions of LINUX and ORACLE. ? > > Thanks. > > shreepad > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Shreepad Vaidya > 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). > > -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: IMP-00069 error when importing 8.1.7 export
Hi, can you export your 81700 db with the 81701 exp utility? oli [EMAIL PROTECTED] wrote: > Hi list, > > I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on > Linux. Export was done with characterset UTF8, I tried to import with > characterset WE8ISO8859P1, WE8ISO8859P1 and UTF8; nothing works. Any help is > welcome. > > TIA > > Volker Schön > E-Mail: mailto:[EMAIL PROTECTED] > http://www.inplan.de > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schoen Volker > 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). > > -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: using Net8 through NAT router
--- Begin Message --- Hi, I'm using a mts-server through an openbsd-firewall (and also nat'ing into the dmz-subnet) without cmgr. There's no problem with that. You should test if your router is proper configured. Check the logfiles or if other services work correctly. Have you bound the public ip of the database server onto the internet-nic of the router or redirect the 1521 onto the machine correctly? oli On Thu, 2001-12-13 at 23:41, [EMAIL PROTECTED] wrote: > I am trying to connect to a database on the "inside" of a NAT. > I get a tns connection time-out error. According to Oracle, I have to use > Connection Manager. I find this a little hard to believe. I would think a > CISCO router doing NAT would be smart enough to translate Net8 packet headers > for me. > > Anyone? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Doug C > 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). > --- End Message ---
Re: Data warehousing Resources
Hi, try http://www.stewartmc.com/oracle http://www.dwinfocenter.org/ oli On Sat, 2002-01-12 at 06:27, [EMAIL PROTECTED] wrote: > Dear All, > > Would greatly appreciate any advice on books/resources on designing and > implementing data warehouse (on Oracle 7-8i) from a less technical and more > functional perspective. > > Cheers, > > Pete > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Pete Wang > 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: Oliver Artelt 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: NetSaint
DAMN!! I'm sitting here since three hours trying to compile the beast with mysql-Support. Libraries are forgotten in the makefiles or not in the right order, it can't read it's data and after looking at the firewall's log I start to cry. Yeah it's version 0.0.7b6. My tip: don't start at friday with this if you plan to have a happy weekend. oli On Tue, 2002-01-29 at 11:35, [EMAIL PROTECTED] wrote: > Has anybody heard of/used/liked/hated NetSaint? One of our > UNIX administrators is pushing this as a cheap alternative to > CA UniCenter, and he wants to start using it to monitor systems > and databases. > > Please let me know your opinions, thoughts, and locations of any > resources you are aware of. > > Thanx, > Mike > > --- > === > Michael P. Vergara > Guidant Corporation > Oracle DBA > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vergara, Michael (TEM) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Is Oracle 9i RAC out
Yes, is an option in the oui oli [EMAIL PROTECTED] wrote: > I know that the Oracle 9i database is out for linux. Does anyone know if > Oracle 9i Real Application Cluster is out yet for linux? > > -- > 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). > > -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Install Oracle 9i on SUSE Linux 7.1
Hi, read the chapter 'Non-Interactive Installation and Configuration' in your platform-dependant Oracle9i Installation Guide. BTW Are there any hardcore dba's out there which installing via scp from one to another machine? oli [EMAIL PROTECTED] wrote: > > So basically I encountered not one single problem. It just took a hell of a time to do the install. > I work for a client with more than 200 databases (small, but a lot of big ones), so we need to optimize the install or upgrade. > Off course the machines are a whole lot bigger than my portable. -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: have been wondering for quite a while
Hi, CONSTRAINT_TYPE VARCHAR2(1) Type of constraint definition: C (check constraint on a table) P (primary key) U (unique key) R (referential integrity) V (with check option on a view) O (with read only, on a view) oli [EMAIL PROTECTED] wrote: > DBAs: > > On the user_constraints view, you can find the constraint_type has five distinct > values: > C, O, P, R, U, and V. > C=check, > P=primary key, > R=foreign key, > U=unique key. > What about O and V? > > If I assume O=optional(null/not null), I really can not guess V. > > Anyone can help?, Thanks in advance. > > William > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: William Dong > 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). > > -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Unix tee command
tee copies it's standard input both to standard output and the file. You can see what it does and have a log file after that. BTW man tee is faster than putting this onto the list oli [EMAIL PROTECTED] wrote: > I do not understand the difference between these two commands: > > script_file > log_file > script_file | tee log_file > > As I understand, the first runs and redirects its standard output to a log > file. The second runs and pipes its standard output to the tee command, > which copies its standard input into its standard output. I have been > instructed to use the latter, but dont want to do it blindly without > understanding why. > > Thanks > Erik > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Erik Williams > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: optimizer function based indexes
Hi, Have you checked OPTIMIZER_FEATURES_ENABLE? oli [EMAIL PROTECTED] wrote: > hello i've update my database from 8.1.7 release 3 to 9i > and now following statement don't use my optimizer hint in 9i (in 8i it > works) > > upper_artikel_kurztext_idx is an function based index > select /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikel > where upper(kurztext) LIKE '%WANN%' > > when i change the statement it works but i need above statement > select /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikel > where upper(kurztext) LIKE 'WANN%' or > select /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikel > where upper(kurztext) = 'WANN' > > the following parameters are set in init.ora > QUERY_REWRITE_ENABLED=TRUE > QUERY_REWRITE_INTEGRITY=TRUSTED > OPTIMIZER_MODE = CHOOSE > > database is analyzed ! > > any ideas > > thanx joe > > Content-Type: text/html; charset="iso-8859-1"; name="Anhang: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Recovery Manager (RMAN)
[EMAIL PROTECTED] wrote > We are looking at the product. If one chooses to store the backup > information in the target database's control files, what happpens if all > the control files and data files are lost? For this query, assume the redo > logs are intact. ... then you are the looser of the day. Do a run{ allocate channel...; copy controlfile to ; } after your backup (the controlfile taken by the backup doesn't contain its own backup information). In ?/dbs you can also find snapshot controlfiles. oli -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: RMAN backup pieces
Hi, try setlimit channel kbytes 200 oli [EMAIL PROTECTED] wrote > How do you split a RMAN backupset into multiple pieces? I am using > Standard Edition so I can't use multiple channels but I need to split > the backup up because of a 2GB file size limit (I'm backing up files > from a Solaris box to a Linux box). > > Chris Rezek > Oracle DBA > DotClick Digital Music Network > http://www.dotclick.com/ -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: FTP Archive Logs
Hi, The Binary mode copy the files as they are, the ascii-mode guarantees the correct coding of the newline-characters in the different OS's. Use the binary mode for the archived logfiles. oli [EMAIL PROTECTED] wrote > I need to ftp several archive logs from one server to another. Do I need to > specify either ASCI or BINARY modes? What difference does this make when > ftping files? Thanks. > > Erik -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Slow database
Hi, it's difficult to help you because we don't know anything about your nightmare skript. Either you do a business/application tuning about these procedures or you can create a ressource plan and drive this with low processor resources. oli -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de [EMAIL PROTECTED] wrote > Hallo all you experts, > > I have an Oracle database, every night it is read many files into the > database, but all the procedures take so long, it keeps taking all the > next day almost. It shouldnt do that, because the system is very slow > because of this. When I run other things during the day, many things are > slow, for instance when i delete 1000 rows it shouldnt take one hour, which > it takes while the "big" process is running. Do you have any suggestion > what I should do to trace the whole problem? When i delete 1000 rows > during "low"-time, then it just take a few seconds to delete the records. > Hope anyone can help me with suggestions. > > > Roland Sköldblom > > > > > -- > 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). > > To: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: 1/2 control file failure - will database halt?
You can mirror the controlfiles at the hw/os level instead if you want to protect against this. oli > > I've been told a single control file failure will halt > the database, even if you've got another control file on > a second device; that the database will only come up again > after editing the init.ora to remove the reference to the > faulty control file and initiating a fresh startup. > > Is this still true, if it ever was true for any version of Oracle, for > Oracle 8.X+? The person who warned me about the halt has been using > Oracle since version 5. > > > Thanks very much. > > - Dana > > > > __ > Do You Yahoo!? > Get email at your own domain with Yahoo! Mail. > http://personal.mail.yahoo.com/ -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Re: OFF-TOPIC SUN vs. HP
I would say that's because of security reasons. oli [EMAIL PROTECTED] wrote > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, March 21, 2001 16:37 > > To: Multiple recipients of list ORACLE-L > > Subject: Re[2]: Re: SUN vs. HP > > > > ... > > only the core was there, but not totally. I've a book of > > standard Unix commands > > as recognized by ANSI and I haven't found one on HP that does > > not work as > > advertised, although HP many times provides a shortcut like > > 'll' instead of 'ls > > -al'. > > Actually, the "-a" in the "ll" command is only active for the root user, > AFAIK. Others need to explicity specify the "a" option to get all the dot > files. > > Why? Damned if I know. Coming from OpenVMS, these Unixy things are a pain > in the buttocks. Faster then hell, but a pain to admin. > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > > > This message has been scanned for viruses with Trend Micro's Interscan > VirusWall. -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Nologging
that has nothing to do with the question. But anyway, try ALTER TABLE NOLOGGING instead. oli [EMAIL PROTECTED] wrote > Alter database noarchivelog; > > will change the entire database. > > see the following for detailed information: > > http://technet.oracle.com/docs/products/oracle8i/doc_index.htm > > HTH, Jim > > -Original Message- > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Wednesday, March 28, 2001 4:37 PM > > >I know it is possible when creating a table to specify no logging > >so that it doesn't generate redo logs. Is it possible, AFTER > >the table has already been created, to change it to nologging? > > Also this is a dev database that we don't care about doing any > >type of recovery and just want to do some quick loads -- is it > >possible to change the entire database to nologging? > >This is on Oracle 8.0.5. > > > >- > >Sent using MailStart.com ( http://MailStart.Com/welcome.html ) > >The FREE way to access your mailbox via any web browser, anywhere! > > > >-- > >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). -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: *.dbf, *.ctl, redo*.log access rite
you should kept your datafiles in 640 too to protect your data oli [EMAIL PROTECTED] wrote > ..dbf = -rw-r--r-- > ..ctl = -rw-r- > ..log = -rw-r- > > > sam > > -Original Message- > Sent: Monday, April 02, 2001 8:05 AM > To: Multiple recipients of list ORACLE-L > > > Hi guys, > > Can you tell me what is your access rite for those files in unix solaris 7 > oracle 8.1.6, my current access rite are: > rwxrwxr-x for all of them. > > Sinardy -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Qualifying columns to improve performance?
Hi, you should better reuse your parsed statements oli [EMAIL PROTECTED] wrote > > At a course some years ago, we were told that in join statements, we should > qualify ALL our column names with the appropriate table name, not just > those that may be ambiguous. The reason was that the parser would not need > to spend time checking multiple tables to determine the table to which each > column belongs. > > Is this still a valid rule? > > Does this apply to statements in PL/SQL procedures/packages? Or are they > different, because they are checked at compile time? > > -a > > > ** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > ** > > > To: [EMAIL PROTECTED] Content-Type: application/octet-stream; charset="iso-8859-1"; name="TEXT.htm" Content-Transfer-Encoding: base64 Content-Description: -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: OCI
Yes, the doku of OCI should be in the platform-specific part. oli [EMAIL PROTECTED] wrote > > All, > > Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f > > One of the duhvelopers here wants to use OCI. I am sure it is installed as > part of the server installation but where do all the relevant files live > for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is > this normal. ?? > > Regards > > Lee Robertson > Acxiom > Tel:0191 525 7344 > Fax:0191 525 7007 > Email: [EMAIL PROTECTED] > > > > > The information contained in this communication is > confidential, is intended only for the use of the recipient > named above, and may be legally privileged. If the reader > of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or > copying of this communication is strictly prohibited. > If you have received this communication in error, please > re-send this communication to the sender and delete the > original message or any copy of it from your computer > system. > > > To: [EMAIL PROTECTED] Content-Type: text/html; charset="iso-8859-1"; name="Anhang: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: OID installation
the skript builds for everything an extra tsp. Be warned. oli TABLESPACE_NAME |INITIAL_EXTENT|NEXT_EXTENT|MIN_EXTENTS|MAX_EXTENTS|PCT_INCREASE|MIN_EXTLEN|STATUS |CONTENTS |LOGGING |EXTENT_MAN|ALLOCATIO|PLU --|--|---|---|---||--|-|-|-|--|-|--- SYSTEM| 16384| 16384| 1| 505| 50| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO RBS01 | 40960| 40960| 1| 505| 50| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_ATTRSTORE| 4194304|2097152| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_CT_DN| 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_CT_CN| 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_CT_OBJCL | 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_CT_STORE | 4194304|2097152| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_DEFAULT |262144|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_TEMP | 1048576|1048576| 1| | 0| 0|ONLINE |TEMPORARY|LOGGING |DICTIONARY|USER |NO OLTS_IND_ATTRSTORE| 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_IND_CT_DN|524288|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO TABLESPACE_NAME |INITIAL_EXTENT|NEXT_EXTENT|MIN_EXTENTS|MAX_EXTENTS|PCT_INCREASE|MIN_EXTLEN|STATUS |CONTENTS |LOGGING |EXTENT_MAN|ALLOCATIO|PLU --|--|---|---|---||--|-|-|-|--|-|--- OLTS_IND_CT_CN|524288|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_IND_CT_OBJCL |524288|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_IND_CT_STORE | 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO [EMAIL PROTECTED] wrote > From the Oracle 8.1.7 Solaris installation guide: > > "If Oracle Universal Installer detects an existing Oracle8i database in > this location, it does not install another one. However, for optimal > results, Oracle Corporation recommends that you install Oracle Internet > Directory on a system that does not currently have an Oracle8i database." > > Is the purpose of this recommendation to ensure best performance, or is > there some other issue? Thanks. > > > > Paul Baumgartel > InstiPro, Inc. > [EMAIL PROTECTED] > 212 813-0829 x103 (office) > 917 549-4717 (mobile) -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Recovery from noarchive db corrected
add redo groups and archiver processes oli [EMAIL PROTECTED] wrote > The developer application running huge batch inserting data into database, > that is what they told me, if you are me what you will do? > > -Original Message- > Testa > Sent: Friday, 6 April 2001 11:55 AM > To: Multiple recipients of list ORACLE-L > > > assuming you're the dba, since when does the developer dictate > recoverability to a DBA about a database. > > sounds like a role problem there. > > joe > > Sinardy Xing wrote: > > Our Developer prefer the archive off, I can't change that anymore :( > > > > -Original Message- > > Sent: Thursday, 5 April 2001 8:54 PM > > To: LazyDBA mailing list > > > > Turn archiving on. > > > > > -Original Message- > > > From: Sinardy Xing [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, April 05, 2001 4:57 AM > > > To: LazyDBA mailing list > > > Subject: Recovery from noarchive db corrected > > > > > > > > > Hi, > > > > > > My database is noarchive mode, what should I do to prevent > > > from lossing any > > > transactions ? > > > Like for example incresed the REDO buffer to ... (daily buffer)? > > > Will this decrese the performance ? > > > any technique to share ? > > > > > > Sinardy > > > > > > > > > Think you know someone who can answer the above question? > > > Forward it to them! > > > to unsubscribe, send a blank email to > > > [EMAIL PROTECTED] > > > to subscribe send a blank email to [EMAIL PROTECTED] > > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > > Tell yer mates about http://www.farAwayJobs.com > > > > > > Think you know someone who can answer the above question? Forward it to > > them! > > to unsubscribe, send a blank email to [EMAIL PROTECTED] > > to subscribe send a blank email to [EMAIL PROTECTED] > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > Tell yer mates about http://www.farAwayJobs.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Sinardy Xing > > 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). > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > 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). -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: OID installation
Hi, We had this problem too (Solaris 2.7/EE8.1.6, penguin/EE8.17). I've created the DB manually (stay in the lower meg-range), erased the echo "Oracle Internet Directory Configuration Assistant" lines in the ldap/postcfg/postcfg skript (starting at echo "Creating OiD schema...") and ran it manually. oli -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de [EMAIL PROTECTED] wrote > I'm looking for help installing Oracle Internet Directory (8.1.7, Sun > Solaris 2.7). The software installation goes fine, but once the OID > Configuration Assistant window comes up, everything stops. My database > does use the UTF8 character set. Any ideas out there? Thanks. > > > > Paul Baumgartel > InstiPro, Inc. > [EMAIL PROTECTED] > 212 813-0829 x103 (office) > 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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).
MIB for snmp/Intelligent agent
Hi all, I want to read snmp-values via the intelligent agent (not via OEM). Has someone an idea how this mib list (?/network/agent/mibs/*) easily can be converted in a classic mib.txt-file? Or I'm totally wrong? oli -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Grumble - OTN is now as ugly as Oracle.com
poor layouts go faster through the net and support the oracle 'we make your ibusiness three times faster'-strategy oli [EMAIL PROTECTED] wrote > > > Why do they insist on making these sites unreadable, > blinding to the eye, and so on? There's nowhere on > the NEW! OTN to rest your eye, to focus, to stabilize, > etc... > > Why would anyone want their site to look like this? > > > > Sorry, and thanks for letting me vent (like you had > a choice...) > > Yosi -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: RMAN Backup Size
Hi, It's all O.K., blocks that never been used aren't backuped by rman. oli [EMAIL PROTECTED] wrote > DBAs > > I have taken hot backup using RMAN. The total Size of the Database is > 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put > together is 4600MB. > > Where am I missing the remaining 600MB? > > Thanks > > Raj -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: data encryption
drop table emp; create table emp( EMPNO number primary key, FIRSTNAME VARCHAR2(30), SURNAME VARCHAR2(30), PASSWORD CHAR(32), PHONE VARCHAR2(32) ); create or replace trigger emp_encryptpassword before insert or update of password on emp for each row declare b_in raw(16) := UTL_RAW.CAST_TO_RAW(substr(:new.password, 1, 16)); b_key raw(8) := UTL_RAW.CAST_TO_RAW('EeTe32!!'); b_out raw(32); begin dbms_obfuscation_toolkit.DESEncrypt(input =>b_in, key =>b_key, encrypted_data =>b_out); :new.password :=rawtohex(b_out); end; / insert into emp values(1,'BOB','SCOTT','Tiger',NULL); Hi, Play with that. Add error checking and decrypt with a function or encrypt the given password and compare the protected strings. oli -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de [EMAIL PROTECTED] wrote > Hi Gurus ! > > Is there any standard method to encrypt data? We are making an application > that uses application-level privilege system, so we should store passwords > for users. Of course we want to store encrypted passwords, but we don't > know if is there an existing way for this or try develop own encryption. > What do you suggest? > > Thanks in advance > Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Cool way to crash an Oracle database, any time, any place
I've checked this on a 817EE penguin SuSE7.0. The row gone simply into the bad file. oli [EMAIL PROTECTED] wrote > Just thought I'd share what I learned today with everyone. This is Oracle > 8.1.7 on a VA Linux 4450, Linux Red Hat 6.2. I'm migrating customers from > MySQL to Oracle, using Sqlloader to load the data into Oracle. > > In one table I have the following column: C$NOTES VARCHAR2(4000) > > In my Sqlloader script I have an entry: C$NOTES CHAR(4000) > > When I ran Sqlloader about 130 out of 35,000 rows were not loaded due to a > "inserted value too large for column" error on C$NOTES. > > So, just for grins I changed the Sqlloader entry to C$NOTES CHAR(4). > > > So, just for grins I changed the Sqlloader entry to C$NOTES CHAR(4). > > When I run Sqlloader for the table with this value, it crashes the database > every time with an ORA-600 [4620] [] [] [] [] [] error. Every dang time. > Pmon just gives up the ghost, man. Shuts the door and turns off the lights. > Dies a horrible death. > > Now, obviously I created this problem myself, but it seems to me that > Oracle > > should be able to handle this a bit more gracefully than it does. :>) > > Anybody else ever see this? I've logged an iTar on MetaMidget to inform the > authorities of the problem. My cursory search on MetaMidget uncovered > absolutely no evidenct that anyone knows about this. > > --Walt Weaver > Bozeman, Montana -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Arkeia Backup software
Arkeia's rman media manager is only aviable for linux. I've asked them, maybe they're too stupid or too lazy to port its interface library to other platforms :-( oli [EMAIL PROTECTED] wrote > Does anyone use this? It looks funky and I am interested in any opinions > before I try it out. Im trying to get out of the Legato/Veritas vicious > circle of Very Expensive and only Moderately Useful backup software. > http://www.arkeia.com > > Regards > Mark > > > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > --------- -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Running remote scripts
ssh is your friend. oli [EMAIL PROTECTED] wrote > Hi All, > Env. is TRU64 Unix and Oracle 7.3.4 > This is a standby server configuration. I want to run > certain scripts(on secondary server), based on some incident > on primary server. And on top of that, every thing has to be > fully automated(using cron). > I got stuck at a point where I need to run some script > on secondary without explicitly logging on secondary server. > I tried using rsh, but it executes just one single command. > I would appreciate if some one can guide me on this. > > TIA, > Rajesh -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Index usage for a table
On Tuesday 30 January 2001 23:47, [EMAIL PROTECTED] wrote: > run a query using explain plan ... and use sql trace oli > > -Original Message- > Alan > Sent: Tuesday, January 30, 2001 4:40 PM > To: Multiple recipients of list ORACLE-L > > > Is there anyway to find out which indexes > are being used and which ones are not > being used for any given table? > > Thanks in Advance > Alan -- --- Oliver Artelt, System- und Datenbankadministration --- cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: ORA-12514 TNS names could not resolve service name
Don't forget your domain in tnsnames.ora. A serv.= or serv.mydomain.com should work. oli On Thursday 01 February 2001 19:33, [EMAIL PROTECTED] wrote: > Hi All, > > NT 4/Oracle 8.1.6 > > I can do a tnsping satt. The entry is in tnsnames.ora. When I try to > connect using sqlplus > I get ora-12514. This is a new installation. Everything is loaded on the > same computer. It connects > fine without service name but for other reasons I want to connect using > service name. > Any ideas? > > Thanks > Rick Cale, Science Applications International Corp. > Phone:865-481-2198, fax:865-481-8555 > e-mail: [EMAIL PROTECTED] > > > > Think you know someone who can answer the above question? Forward it to > them! to unsubscribe, send a blank email to > [EMAIL PROTECTED] to subscribe send a blank email to > [EMAIL PROTECTED] Visit the list archive: > http://www.LAZYDBA.com/odbareadmail.pl > > > To: [EMAIL PROTECTED] > [EMAIL PROTECTED] -- --- Oliver Artelt, System- und Datenbankadministration --- cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de ----------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: 8.1.7 install
Hi, I was also confused by the installer too -Oracle ships a IBM 1.1.8 jre on the disk. But I found a jdf 1.2.2 under /usr/local and have this used instead. oli On Wednesday 07 February 2001 15:46, [EMAIL PROTECTED] wrote: > 8.1.7 install prompts for location of a JDK and then falls over when I use > the default /opt/java > > Platform is AIX 4.3.3 > > What is the pathor do I need to install a JDK? > > John -- --- Oliver Artelt, System- und Datenbankadministration --- cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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).
iFS1.1: penguin gets slaughtered
Hi, I've played a little bit with ifs1.1. O.K. the penguin is a little bit lightweighted for this task (EE8.1.7, SuSE7.0, kernel 2.4.1, 512 MB RAM, 600 MHz PIII) They say that's the minimal configuration for iFS (2 users, 2 protocols) but anyway I only try it out. Now the machine is in polling state, no load from clients or so are served. The vmstat -he he he: procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 2 0 0 256168 4032 1788 227188 0 11 620 185 2174 8 8 84 8 0 0 256168 4032 1788 227188 0 0 0 0 106 655563 39 61 0 4 0 0 256168 4032 1788 227188 0 0 0 0 104 591855 39 61 0 2 0 0 256168 4028 1788 227192 0 0 0 6 123 552223 45 55 0 8 0 0 256168 4028 1788 227192 0 0 0 0 104 552822 48 52 0 2 0 0 256168 4028 1788 227192 0 0 0 17 140 575998 44 56 0 2 0 0 256168 4028 1788 227192 0 0 0 6 123 552350 40 60 0 2 0 0 256168 4028 1788 227192 0 0 0 0 105 553134 42 58 0 2 0 0 256168 4012 1788 227208 0 0 2 6 110 503228 45 55 0 8 0 0 256168 4004 1788 227216 0 0 211 131 666366 33 67 0 Wheew! This penguin got toasted by tons of jre processes. But the machine reacts on the console easy. Is that normal for a polling iFS-Server? And this nice try to compensate the ready-to-run contention with these abnormous exorbitant context switches? He he he -what is big enough to resist an oracle load test? oli --- Oliver Artelt, System- und Datenbankadministration --- cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de --- --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: TABLE CACHE
Hi select blocks from dba_segments where segment_name ='' shows the size of your table. oli On Wednesday 07 February 2001 19:54, [EMAIL PROTECTED] wrote: > Hi DBAs > I have one large table.I want to keep it into memory thru > alter table cache; > Is there any computation formula how much ram this table takes. > Please help me.Thanks in advance. > Regards > -Mala > > _ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- --- Oliver Artelt, System- und Datenbankadministration --- cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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).
test, ignore
sorry. -- Oliver Artelt Oracle certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: Who are they ?
Hi, These are users for oracle intelligent agent and two of the oracle enterprise options. They're used to separate the additional objects from the common catalogue. You should change the passwords or at least lock their accounts to protect against security attacks. oli [EMAIL PROTECTED] wrote > Lists, > > In Oracle Security Manager I found 3 users other than SYS and SYSTEM . > what is task of these users ? > > <> DBSNMP > <> MDSYS > <> ORDSYS > > TIA, > > =bambang= > > > <> Bambang Setiawan <> -- Oliver Artelt Oracle DBA OCP cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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).