RE: Backup Strategy
1. If you can afford to lose data from the time of the last backup, then you are right. However, I even put those databases on 24x7 mode whenever possible because (1) Developers, like DBAs, work strange hours in the night and day and would probally like to have access to the database. (2) You never had a developer be pissed off at you because you couldn't restore one table without having to wipe out all the work he or jack did earlier today. (3) How can you truely test a 24x7 application on a non 24x7 Oracle database when now the SGA differs between the two machines? 2. I am a strong believer of the KISS philosophy as well, you guys haven't seen my users! This, however, should not apply to us as DBAs whose job is to know DBA related commands. Regards, Satar --- Gene Sais <[EMAIL PROTECTED]> wrote: > I see 2 advantages of cold over hot backups: > > 1) Archive log mode not required for cold backups. > Dev & Test DB's do not need archive space. > > 2) Cold backups follow the KISS principle. Shutdown > db, tar, dump, cpio, dd, etc. the datafiles, redo > logs, ctl files, oracle filesystems, etc. to tape, > Startup db, Done. Take the tape to same or another > server and restore, No Oracle cmds required > (filesystems being the same). Now for Hot Backups, > we have to add a step. Not a big step :) We need > the arcs and need to recover the db. > > Gene > * Still not convinced backing up closed files are > not safer/better than open files :) * > > >>> <[EMAIL PROTECTED]> 10/04/01 04:59PM >>> > > > OK, I'll bite, what OS commands? > > As for cold backups, and I'm sure you've heard this > already, they're only > really needed after you open a database with > 'resetlogs' . Otherwise it > is not necessary to use a cold backup. > > Jared > > __ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Droping System User
Actually there is... for example in 8i: DBA_REFRESH DBA_2PC_PENDING DBA_SNAPSHOTS and so on... Regards, Satar --- Jacques Kilchoer <[EMAIL PROTECTED]> wrote: > No such thing as DBA_ tables. :-) > > SQL> select obj#, name > 2 from sys.obj$ > 3 where name like 'DBA\_%' escape '\' > 4 and type# = 2 ; > > aucune ligne sélectionnée > > > -Original Message- > > The DBA_ tables are owned by SYS. > > But a lot of features such as AQ and such use > objects owned by SYSTEM. > __ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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 will not shutdown in Normal or IMMEDIATE mode
You can do an offline backup with shutdown abort. But anyway...see if there are any Oracle processes using CPU and go from there. There was a couple of bugs in that version of Oracle in which one (if memory serves me right) hangs on shutdown immediate if the number of processes were reached and the second bug had to do with the Archiving process spawning a lot of processes. I always hated trouble shooting problems on Microcrap products. Good Luck, Satar --- "Cale, Rick T (Richard)" <[EMAIL PROTECTED]> wrote: > Hi All, > > It is one of those days. > Anyway Oracle 8.0.5 / Win 4.0. > > I am trying to shutdown instance in Normal mode but > just hangs. I am able > to shutdown abort and restart. Heck I even rebooted > server > in case files were locked. There are no errors in > alert log > > Any ideas why I cannot shutdown in NORMAL or > IMMEDIATE. > No other users/sessions on the system. I have done > this many times but not > working today. I need to do this because I want to > do > an offline backup. > > Thanks > Rick > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Cale, Rick T (Richard) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Backup Strategy
Actually, I'll take it even one step further... ;) There should be no reason to choose cold backups over hot backups. Even companies who can afford to be down during weekends and weeknights will appreciate a database that can be accessed by users anytime. Regards, Satar --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > Why is better Gene? What is it about the files > being closed > that gives you the trust factor? I don't use RMAN > here either > but its more because my backup method works wonders > and I just > don't need those extra features that RMAN provides. > > > There are a lot of sites out there that cannot > afford to have > the database come down even for 5 minutes so you > might want > to spend some time getting the warm fuzzies over hot > backups. > I swear, they work. > > -Original Message- > Sent: Thursday, October 04, 2001 12:25 PM > To: Multiple recipients of list ORACLE-L > > > I personally prefer cold backups over hot. Always > better when the files are > closed. But hey, this is coming from someone who > still doesn't trust Rman > :) > > Gene > __ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: DISK IO?
UNIX: man iostat while you're there, checkout: man vmstat Windoze 2000: I think they have something called "Performance Monitor" in 2000. From what I hear, it isn't helpful. I think they are trying to resolve the constant system crashes before they concentrate on "small" things, such as disk I/O. ;) Regards, Satar --- Seema Singh <[EMAIL PROTECTED]> wrote: > Hi > How to monitor disk IO on Unix AND Win2000 platform? > Thanks > -Seema __ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Veritas Quickio and DB_BLOCK_SIZE
--- Jonathan Lewis <[EMAIL PROTECTED]> wrote: > > Is this the thread where Thomas says something > about: Yes, it is. > Neither Thomas nor I made a throwaway remark > suggesting a specific block size was appropriate I meant to & should have wrote: "...why he would recommend a 2k block size on an OLTP type database." The whole reason behind posting your reasons were to show some examples as to why you would use a 2k block size. The reason I suggested 2k is that if they face performance problems (which usually does happen with a 2k blocksize), there are other parameters and means to use to offset the negative performance hit. Systems that are I/O bound can be easily fixed. > - > we both stated that we had on occasions used > 2K where appropriate. Acknowledged. > Nor did we add a valueless > caveat about 'the application being appropriate', > we actually gave concrete reasons why an application > may or may not be appropriate. I'm glad you took the time to give concrete reasons why an application may or may not be appropriate. One might argue the actual value of your reasons, if they did not apply to the situation. I figuired it was better than nothing. And because of this, I'm sure the author of the original post will now take the time to research his/her own environment and come up with his/her own opinion. Maybe this whole experience might be called "indirect value"? Any way, it's been fun. Time for me to move on... Regards, Satar > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > |By the way, you are agreeing and disagreeing with > |Jonathan Lewis at the same time. The index > efficiency > |on small block size is Jonathan's point he made a > |couple of years ago when he was stating why he > |recommends a 2k block size on an OLTP type > database. > |The other index point (scanning an index on a small > |block size) is from Thomas Kyte on the same > |thread...If you disagree with him, you can write > him > |an e-mail so you can correct him. > > __ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Backup Strategy
Your backup strategy all depends on your business requirements for uptime. Consult your Manager and let him/her give you the guidelines. I can give you my backup strategy, just write me an e-mail at [EMAIL PROTECTED] It has our business requirements and the Backup that I have put in place to meet those business requirements. Regards, Satar --- Veronica Levin <[EMAIL PROTECTED]> wrote: > Hi listers, > I was wondering how do you decide your backup > strategy. > > I do daily full exports and weekly full backups with > database in archivelog > mode. > Plus weekly Operating System Backup. > > Is this all I can do to ensure fast recovery of the > database or server when > it is needed? > > Any input on this topic will be appreciated! > > Saludos, > Veronica Levin Enriquez > Compañía Cervecera de Nicaragua > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Veronica Levin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Disk layout
It's real easy, pay close attention... Put every Oracle object on it's own disk drive and controller. If your table is too huge and you must use more than one disk drive, then make sure that each disk drive has it's own disk bus. Larry will then come to your site and run benchmark testing and will praise you on how well your database performs. Regards, Satar --- Steven Hovington <[EMAIL PROTECTED]> wrote: > Could anyone please point me towards documentation > which discusses optimum > disk layouts for Oracle databases. > > Thanks in advcance. > > Steven. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Steven Hovington > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Veritas Quickio and DB_BLOCK_SIZE
Hi Christopher, Like I said, Oracle experts can argue this issue until they are blue in the face, kinda like the Certification debate. Without any information on the data or application, I suggest a 2k block size. Everyone is entitled to thier own opinion, and I hope the author of the original post becomes successful in choosing his/her block size. By the way, you are agreeing and disagreeing with Jonathan Lewis at the same time. The index efficiency on small block size is Jonathan's point he made a couple of years ago when he was stating why he recommends a 2k block size on an OLTP type database. The other index point (scanning an index on a small block size) is from Thomas Kyte on the same thread...If you disagree with him, you can write him an e-mail so you can correct him. I hope you can appreciate the irony. Regards, Satar PS Nice website, I like the goth look! Now you should play some Bauhaus or Christian Death in the background. ;) --- Christopher Spence <[EMAIL PROTECTED]> wrote: > I disagree in the 2k for OLTP as well, for similar > reasons Jonathan > mentioned, as well as a few of the obvious. Most > OLTP are not PERFECTLY > tuned to only do indexes scans either. And indexes > are much more efficient > on the larger block sizes as well > > > Christopher R. Spence > Oracle DBA > > -Original Message- > Sent: Tuesday, October 02, 2001 8:55 PM > To: Multiple recipients of list ORACLE-L > > Hi Jonathan, > > Sweeping statement...maybe. It all depends on your > application. That's why I put an emphasis on his/her > application (meaning both physical structure and > data) > requirements. As a GENERAL rule of thumb, I > (personally) suggest (if possible) 2k for OLTP > databases. It's like if you ask me what car to buy, > I > would say a "Honda". But if you were to tell me that > you need speed, style and sex on wheels, I would > suggest a Benz. > > You and I, (especially you!) can argue the > benefits/disadvantages of using 2k block > size...Which > I don't care to do. I've put the benefits/reasons of > a > 2k blocksize at the bottom of this reply just to > show > some reverse examples of the ones you replied with. > Some of the reasons should look familiar to you! ;) > > Regards, > Satar > > 1. The OLTP app has lots of small rows (<2k) > > 2. The OLTP app does massive scattered reads (you > don't full scan in OLTP). It > reads a block here, a block there based on some > primary key (after doing lots of > scattered reads to walk an index structure) > > 3. The OLTP app has 1,000 connected users -- each > wants their current row(s) they > are using in the cache. > > 4. A smaller block size in a database that does lots > of scattered IO's (eg: an OLTP system) and random > keyed reads can definitely benefit from smaller > blocksizes. > > 5. The indexes for the critical access paths fit > exactly into an N-layer tree and allow an optimum > buffering strategy when memory is limited. > > 6. In almost all cases the data for a single index > value will be (significantly) less than 2K and will > all be found in the same block. > > 7. Memory is at a premium. > > --- Jonathan Lewis <[EMAIL PROTECTED]> > wrote: > > > > That's a fairly sweeping statement to make without > > any justification - after all, at 2K: > > > > The block header is a much larger percentage > > of the block size - so you lose space. > > > > The probability of wasting space from the > > PCTFREE > > setting increases - so you lose space. > > > > The memory overhead due to x$bh is fixed per > > block, > > so you use more memory to hold the same volume > > (block size x block count) of data. > > > > Index depth may increase through having fewer > > entries per branch block. > > > > Latch activity is likely to increase on range > > scans > > because leaf blocks hold fewer entries - you > get > > the same effect on tables with clustered data > - > > and the effectiveness of IOTs will > particularly > > be > > reduced. > > > > > > Jonathan Lewis > > http://www.jlcomp.demon.co.uk > > __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Veritas Quickio and DB_BLOCK_SIZE
Hi Jonathan, Sweeping statement...maybe. It all depends on your application. That's why I put an emphasis on his/her application (meaning both physical structure and data) requirements. As a GENERAL rule of thumb, I (personally) suggest (if possible) 2k for OLTP databases. It's like if you ask me what car to buy, I would say a "Honda". But if you were to tell me that you need speed, style and sex on wheels, I would suggest a Benz. You and I, (especially you!) can argue the benefits/disadvantages of using 2k block size...Which I don't care to do. I've put the benefits/reasons of a 2k blocksize at the bottom of this reply just to show some reverse examples of the ones you replied with. Some of the reasons should look familiar to you! ;) Regards, Satar 1. The OLTP app has lots of small rows (<2k) 2. The OLTP app does massive scattered reads (you don't full scan in OLTP). It reads a block here, a block there based on some primary key (after doing lots of scattered reads to walk an index structure) 3. The OLTP app has 1,000 connected users -- each wants their current row(s) they are using in the cache. 4. A smaller block size in a database that does lots of scattered IO's (eg: an OLTP system) and random keyed reads can definitely benefit from smaller blocksizes. 5. The indexes for the critical access paths fit exactly into an N-layer tree and allow an optimum buffering strategy when memory is limited. 6. In almost all cases the data for a single index value will be (significantly) less than 2K and will all be found in the same block. 7. Memory is at a premium. --- Jonathan Lewis <[EMAIL PROTECTED]> wrote: > > That's a fairly sweeping statement to make without > any justification - after all, at 2K: > > The block header is a much larger percentage > of the block size - so you lose space. > > The probability of wasting space from the > PCTFREE > setting increases - so you lose space. > > The memory overhead due to x$bh is fixed per > block, > so you use more memory to hold the same volume > (block size x block count) of data. > > Index depth may increase through having fewer > entries per branch block. > > Latch activity is likely to increase on range > scans > because leaf blocks hold fewer entries - you get > the same effect on tables with clustered data - > and the effectiveness of IOTs will particularly > be > reduced. > > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Host to The Co-Operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > Author of: > Practical Oracle 8i: Building Efficient Databases > > -Original Message- > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > Date: 02 October 2001 21:56 > > > |If your application allows it, and if the > Application > |will not change in the future, then use a 2k block > |size for OLTP database. > | > |If you are not sure on the application needs, then > |stick with 4k to be safe. > | ______ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Veritas Quickio and DB_BLOCK_SIZE
If your application allows it, and if the Application will not change in the future, then use a 2k block size for OLTP database. If you are not sure on the application needs, then stick with 4k to be safe. Regards, Satar --- Brian Haas <[EMAIL PROTECTED]> wrote: > Hi, > > According to the Veritas manual, they claim that a > db_block_size of 2K when > using the quick-io files and an oltp system has the > most performance according > to benchmarks. > > I know full well that benchmarks != real world. Has > anyone had any experience > using quickio? If so what are your thoughts on this > and what block size(s) are > you using? > > I'm using solaris 2.8, oracle 8.1.7, latest version > of the veritas suite. > > Thanks, > > -Brian > __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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 -> SQL Server
Try to contact the "Mainframe & Integration Technologies" group at Oracle and see what path that takes you. Also, have you tried to see if you can accomplish your goal by shooting the info from SQL server to a table in Oracle, then running a query against that table within Oracle? Did that make sense? I picked the wrong week to stop sniffing glue! Regards, Satar --- Christopher Spence <[EMAIL PROTECTED]> wrote: > It is for something which won't have a huge budget > as the data is moving > over to Oracle eventually, but for now we want > access to it. I was thinking > about just building a java/perl replication engine > for now. It isn't a lot > of data. But if there was something pre-packaged it > would be nicer. > > I think the transparent gateway was dropped, either > way it is so expensive > and out of the range for such a small project. > > "Do not criticize someone until you walked a mile in > their shoes, that way > when you criticize them, you are a mile a way and > have their shoes." > > Christopher R. Spence > Oracle DBA > Phone: (978) 322-5744 > Fax:(707) 885-2275 > > Fuelspot > 73 Princeton Street > North, Chelmsford 01863 > > > > -Original Message- > Sent: Tuesday, October 02, 2001 4:55 PM > To: Multiple recipients of list ORACLE-L > > Hi Christopher, > > It can be done, Usually from third party software > companies. For example, Check out: > http://www.datamirror.com/products/tserver/ > > Back in the day (1996), Oracle had a "Mainframe & > Integration Technologies" group that handled such > problems. You might want to contact Oracle and see > if > such a group still exists and if they can provide > you > with a solution. > > Regards, > Satar > > > --- Christopher Spence <[EMAIL PROTECTED]> wrote: > > I know there is a way in SQL server to query > oracle > > tables, is there a way > > to do the reverse? > > > > I am looking at trying to create access from an > > Oracle DB to SQL Server data > > until we convert the SQL server database. > > > > Anyone have any ideas on this, I searched technet > > (ms/oracle) and metalink, > > as well as some search engines without luck. > > > > > > "Do not criticize someone until you walked a mile > in > > their shoes, that way > > when you criticize them, you are a mile a way and > > have their shoes." > > > > Christopher R. Spence > > Oracle DBA > > Phone: (978) 322-5744 > > Fax:(707) 885-2275 > > > > Fuelspot > > 73 Princeton Street > > North, Chelmsford 01863 > > > > > > > > > > __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: interesting problem with jdbc
Without knowing everything about your setup, I believe your problem is due to the fact that Oracle JDBC drivers implement ROWID as a Java string. Regards, Satar --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > Okay, I'll preface this by saying we did find a work > around but this > was strange and I wondered if any of you had run > into this. > > Background: > > two 8.1.6.0 databases, one is Solaris 2.8 32 bit and > the other is > Solaris 2.6 > > the local database is on the 2.8 machine, call it > users > the remote database is on the 2.6 machine, call it > compdata > > Public database link from users to compdata > > private synonym events for events@compdata in the > users database. > > log into sqlplus, select * from events where id=# > works fine > > via the java program & jdbc 1.1, select * from > events where id=# > returns the first row you selected, no matter what > id you subsequently > give it. So id=4 as the first selected means that > whatever id you now > give it, it will return the data from id 4. > > drop the public synonym, create a copy of the events > table on users. > > sqlplus AND the program run fine > > go back to the synonym across the link and the > program blows up, > sqlplus is fine (at least it's consistent) > > change the program code to > > select * from events@compdata > > and the program is fine > > so something is wrong not with the database, but > with java settings, or > jdbc drivers (1.1) or ? > > All other accesses with other links between the two > databases are fine. > > The only other thing we could think of was that that > program runs on an > app server with an older version of WebSphere. > > Any ideas on what would cause this? As I said, we > have a work around > (hard-code the link) but I'd like not to have to do > that > > Rachel > > __ > Do You Yahoo!? > Listen to your Yahoo! Mail messages from any phone. > http://phone.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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 -> SQL Server
Hi Christopher, It can be done, Usually from third party software companies. For example, Check out: http://www.datamirror.com/products/tserver/ Back in the day (1996), Oracle had a "Mainframe & Integration Technologies" group that handled such problems. You might want to contact Oracle and see if such a group still exists and if they can provide you with a solution. Regards, Satar --- Christopher Spence <[EMAIL PROTECTED]> wrote: > I know there is a way in SQL server to query oracle > tables, is there a way > to do the reverse? > > I am looking at trying to create access from an > Oracle DB to SQL Server data > until we convert the SQL server database. > > Anyone have any ideas on this, I searched technet > (ms/oracle) and metalink, > as well as some search engines without luck. > > > "Do not criticize someone until you walked a mile in > their shoes, that way > when you criticize them, you are a mile a way and > have their shoes." > > Christopher R. Spence > Oracle DBA > Phone: (978) 322-5744 > Fax:(707) 885-2275 > > Fuelspot > 73 Princeton Street > North, Chelmsford 01863 > > > > > __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Background jobs inUnix
That's fine, but I would look into using the nohup command to solve error issues and to report any errors. Regards, Satar --- "Tatireddy, Shrinivas (MED, Keane)" <[EMAIL PROTECTED]> wrote: > Hi Lists, > > Shall I close the unix session after submitting my > job (compressing the > dmp file after importing) in the background on > solaris. > > $ compress /u01/dmps/zvr_dd.dmp & > > is this harmful ? (like killing the running jobs) > > > thnx in adv > srinivas > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Tatireddy, Shrinivas (MED, Keane) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: HOTBACKUP issue !!
Hi, the easiest way to find the info is to look for Jeremiah Wilton's website. On his website (if he still has it up) is an article on the internals of Hotbackups. I don't the name of his website, but you can do a search on the web. Regards, Satar --- "Dash, Saroj (CAP,CEF)" <[EMAIL PROTECTED]> wrote: > Hello All, > > > When you take begin back up of tablespace what > exactly oracle does > internally. > > what happen the transcation in that period. > > Please tell me . > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Dash, Saroj (CAP,CEF) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: find out ip
netstat -in Will also tell you if there are any other assigned ip addresses to that server, for example in a cluster configuiration. Regards, Satar --- "Tatireddy, Shrinivas (MED, Keane)" <[EMAIL PROTECTED]> wrote: > Hi lists > > How to find out a server (solaris) IP address, that > I logged in . > Any command ? > > thanx in advance > srinivas __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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 Open World
I never cared for Oracle Open World, it was just one big commercial. The only cool thing about it, is seeing all my friends who started their own Oracle consulting firms or working for someone that I know. Plus I'm a shop-a-holic and I spend way too much money on Oracle clothes and junk, like key-chains, license plate frames, etc. Then I kick myself on why I spend so much money to advertise other people's products. I would think that with the economy and the situation on the east coast, attendance will be low. Regards, Satar "Groping Hands & Grandma Fetish" Naghshineh --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > Just thought I would ask. How does everyone feel > about Oracle Open World > this year. Will attendance be down? > > Ron Smith > Database Administrator > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Network Appliance Options
Hi Kathy, I attended a meeting with NetApp's Database Marketing Manager 2 to 3 years ago. I discussed with him on how the technology of the NetApp filer works with Oracle database environments and why he feels that NetApp is a solution for Oracle databases. The meeting was a result of me not supporting NetApp in any Oracle environment. To keep a long story short, here is what I learned and now believe: At that time, what was told to us by him was that they (NetApp) were not ready to be pushed in the market of OLTP type of databases because of performance limitations of network systems. I learned that NetApp is a valid (maybe not the best solution) storage solutions for data warehouses and databases where performance is not a critical requirement. NetApp is an expensive solution compared to other storage solution providers. The markup on hard drives alone were insane. However, the administration of the netapp filer was very easy to understand and perform. Regards, Satar --- Kathy Duret <[EMAIL PROTECTED]> wrote: > Has anyone used Network Appliance? > > Any options good/bad appreciated as it applies to > Unix (Solaris and HP) and Oracle 8.1.6 and above. > > Going to a dog and pony show by them tomorrow. > > Kathy > __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Rachel - RE: 2nd DBA or ?
It is clear that you did not understand the meaning of my previous post, and I won't lower myself to respond to your flamatory/negative remarks. I only apologize that I couldn't communicate my response clearly enough for you to understand it. The only thing I need to reply to is: > Oh and I may have ridden in the car (with several > other people at OOW > on the way to a group dinner), but the groping hands > were not > appreciated. > I hope you were not referring to me as being the one with "groping hands". Maybe you have your facts and fantasies mixed up? Any way, some one asked for advice, and I gave them my point of view. Whether they take the advice or not is of no concern of mine. I wish them the best of luck in the decision that they made. Regards, Satar __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: file changed during tape backup ???
To add to Jared's response... If it's a: Cold Backup: Is the database really down? Hot Backup: Make sure you issue a "Backup control file to ..." then back that control file up. Regards, satar --- Jared Still <[EMAIL PROTECTED]> wrote: > > Janet, > > I would investigate the backup process to see what > the final step is before the controlfiles are > backed up to tape. > > Could be that you need a delay of a few seconds > in there somewhere to allow for the controlfiles > to be updated. > > Jared > > > On Monday 24 September 2001 16:45, Janet Linsy > wrote: > > Hi all, > > > > I got the following from our Unix admin. Looks > like > > control files for some database on many boxes got > > changed when being backed up on tape. (I suppose > the > > backup on tape happened during mid-night) Does > > anybody know what the reason is, and why this only > > happened to control files? Thank you. -- Janet > > > > > > Following are Oracle warnings during the nightly > tape > > backup: > > > > SNOW: > > snow:/orafs/ora1 save: Warning - > > `/orafs/ora1/oradata/GOLD404/control01.ctl' > changed > > during save > > * snow:/orafs/ora1 save: Warning - > > `/orafs/ora1/oradata/AMY40/control01.ctl' changed > > during save > > > > SLEET: > > sleet:/orafs/ora1 save: Warning - > > `/orafs/ora1/oradata/oradata/TEST/control01.ctl' > > changed during save > > > > ICE: > > ice:/orafs/ora1 save: Warning - > > `/orafs/ora1/oradata/CP40TD/control01.ctl' changed > > during save > > > > > > TSUNAMI: > > * tsunami:/orafs save: Warning - > > `/orafs/ora1/oradata/AB406CNV/control01.ctl' > changed > > during save > > * tsunami:/orafs save: Warning - > > `/orafs/ora2/oradata/AU406CNV/control02.ctl' > changed > > during save > > * tsunami:/orafs save: Warning - > > `/orafs/ora3/oradata/AU406CNV/control03.ctl' > changed > > during save > > > > > > > > > > > > __ > > Do You Yahoo!? > > Get email alerts & NEW webcam video instant > messaging with Yahoo! > > Messenger. http://im.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Optimal Disk Layout??
Hi Walter, It looks like you're having a bottleneck on your controller during a hot backup. This is a result of (1) reading the data then (2) writing the data and compressing the data within the same controller. To answer your questions: 1. During RAID 5, all your disks are being written to and parity rotates on each disks. You can do a search on RAID levels on the web. One thing to note is that a RAID 5 needs at least 4 physical drives to work efficiently. 2. Since you are running a single A1000 with 8 slots, I would avoid the RAID 0+1 idea. Keep the RAID 5 setup unless you go with 10 drives, then go for RAID 1+0. Alocate a couple of drives for redo logs (on seperate internal disk bus within the A1000) and multiplex the redo logs on the two drives. Keep a drive for the archived redo logs, you can even use a bigger hard drive that has the same form factor as the 9GB hard drive. Try to squeeze a Hot Spare in as well. seperate the RAID 5 drives between the two internal disk bus of the A1000 as well. Look into backing up your database to a TAPE device instead of hard drives. With a 8GB database, you can restore your database in 10 minutes with a DLT 8000, just make sure the backup software binaries and database resides on a sperate system on your network. Your best bet, if you can afford it, is to return the A1000 and get a A3500, which comes with 2 D1000's. Buy the additional controller for redundancy and do a RAID 50 or 10. This is the best bet because of the redundancy on the conntroller, disks and internal bus of the system. Also implement the TAPE backup system. I believe the A1000 is a 10 slot (for 9GB drives and some 18GB drives). If it is only a 8 slot storage, make adjustments accordingly, keeping the internal disk bus in mind. Lay out your disk: Slot 1 - RAID 5 DRIVE Slot 2 - RAID 5 DRIVE Slot 3 - Archived redo logs Slot 4 - Redo Logs (Members A) Slot 5 - EMPTY Slot 6 - RAID 5 DRIVE Slot 7 - RAID 5 DRIVE Slot 8 - Redo Logs (Members B) Slot 9 - HOT SPARE Slot 10- EMPTY If it is a 10 slot and you decide to go with 10 hard drives, implement RAID 1+0 to increase write performance. Use the Hot SPARE disk as an extra disk to throw junk into. Hope this helps. Let me know if I confused you more or if you need additional info. Regards, Satar --- Walter K <[EMAIL PROTECTED]> wrote: > Hi, > > I'm encuntering a relatively high iowait percentage > when my hot backups are running. The platform is Sun > (E420 2cpu running SunOS 5.7) with an A1000 disk > array > (8 9Gb drives, hardware Raid-5). The array is one > volume and all DB components (redo, archive, data, > index, system, etc.) are on the same volume except > for > the binaries. The database is not large, only ~8Gb > in > size and the transactional volume is not much > either. > However, when the backups run, the iowait according > to > 'top' hovers between 50-70% which causes our > application to time-out via Web Logic 6.0. > > The developers can't explain why the timeouts are > occurring (WLS 6.0 is a new upgrade from 5.1). The > SysAdmin isn't much help either. > > I have an opportunity to rebuild the database on > another machine and use RAID 1+0 -- the thought > being > that we are choking ourselves with Raid-5 when the > hot > backups are performing the cp's (copies) and then > the > files are compressed. > > My first question is, how is the data distributed > across the drives in my Raid-5 configuration? Is > each > disk being filled contiguously in series or is the > data being spread around in a pseudo-striping > manner? > > My second question/dilema is, the new array (another > A1000) will have 6 18Gb drives and with Raid 1+0 > that > shrinks to 3 drives of usable space for everything > except redo and archive. 4 9Gb drives will be added > in > two mirrored sets, one for redo and the other for > archive. I'm afraid that I will see worse I/O > performance with the new array because it has so > fewer > physical drives, thus eliminating the benefit of not > having to write the parity info. > > Do you concur? Knowing the two arrays I have to work > with, which would be the better configuration? > > Any suggestions, recommendations would VERY much be > appreciated. > > Thanks again for the feedback. > -w > ______ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -
Rachel - RE: 2nd DBA or ?
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > way too cynical. Thanks! It's this personality (or lack of) that has made me very sucessful at my age. I was driving a 45k dollar car (which you rode in) and owned my first house at age 23. Now at 26, I also own a new Benz (valued at 75k) and own a second home. I hate to sound egotistical (isn't that one of the traits of a good DBA?), but I just want you to know where I am coming from. > One of the few things I learned in the management > class I took was "you have to train the people > below you to do your job if you ever want a > promotion" Who wants to work in Management? At my full-time job, I make close to what my boss makes (he is the CIO) but without all the responsibility and dealing with personal problems. To me, if you know the basics of Business Management and Child Psychology, you'll do well in Management. > If no one else can do what you do, then you can't > move on to other things. Maybe because I'm still young, but I always believe that your future is in your own hands, not at your company's discretion. If I don't get what I want, then I move on to another company. It might change when I get married and have kids, in which I have to worry if my child eats Frosted Flakes cereal in the morning or if he/she goes to school hungry. Until then, I am free. > On the other hand, Satar is a consultant. I also have a full time job, but hopefully I can quit my job soon if this project I'm currently working on is sucessful. I have goals, and I am close to self-actualizing them. > And looking at the world from that direction, you > wouldn't want anyone else around to do what you do > because you'd lose the contract if there were a > full-timer around (you can have a fulltimer put in > extra hours without having to pay more) Nice philosophy. In a dog-eat-dog world, it's good not to be a dog! Also, if you live in California, chances are you are getting paid by the hour, along with overtime. California residents, you might want to look into California Assembly Bill 60 (AB 60) on the internet. > But as a full-time employee, I want someone else > around. Because there is ALWAYS too much work for > one person, at least in my shop. The MIS managers or system admins can experience Oracle Support if they can't get a hold of me. Unfortunately, they put a lo-jack system (cell phone) on me, so I am available to them 24/7. To date, after 1 and half years working for this company, none of my databases have experienced any problems. I like to think it's due to my expertise, or maybe I'm wrong, and it's just luck. Also, I hope this doesn't come across mean or unappreciative, but if you remove yourself from the list, you will give yourself so much more time to tackle the work at your shop. As you might have noticed, I removed myself from the list for 7-8 months while my company gave me the responsibility of UK's databases. I needed that time to go to the UK, configure and tune the datbases, setup an automated backup and recovery procedure, post application tuning and provide remote support, along with other things. I do have to agree with Christopher Spence, if this is a in-house Development, or continued developed oracle application environment, then of course you will need additional people to help you out. I initially replied to this post, because I was given the same opportunity to bring in another DBA for the UK. I chose to do the job myself, eliminating a part-time DBA that was positioned in the UK and also removing the need for Oracle Support in the UK (which is extremely expensive compared to the US). I made my suggestion based on my previous experiences as a consultant working for corporate America. You may call it cynical and paranoid, which is ok because everyone is entitled to their own views, but this is my reality. > Rachel Regards, Satar PS I'm glad to see you are OK from last week's attacks. I was praying for everyone in NY and Washington, especially for you. I hope you and your family are doing well. __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: 2nd DBA or ?
If we lived in a perfect world, where the employee matters, then I would hire an additional DBA to share ideas and responsibility. However, since we live in a capatilistic world, I would do the job by myself for the following reasons: 1. Management will see one of you as being redundant during financial problems because there was one person doing this job before, therefore they can get rid of one of the DBAs and still be ok. 2. Mamangement acknowledges that there is a possible need to hire an additional person, thus acknowledging that you do the job of two people. This is a benefit to you for asking for a big pay increase. 3. Hiring Oracle consultants and purchasing software are tax deductible to the company as opposed to paying a salary to another person and providing them with Health Care and Office Space. At least in the USA. 4. If you hire a entry-level DBA, chances are that he/she will learn his skill set from you and then move on to bigger opportunities (which puts you back to square one) or he/she will just stab you in the back to try to get your job. Regards, Satar --- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote: > I've been presented with an opportunity to justify > requirements for a 2nd > DBA at our site. As I see it there are an number of > paths this presents: > > 1 - Justify and get a 2nd DBA. > Pro's: Gives me more time to get involved in other > projects as a senior DBA. > Holidays and attendance at courses and seminars etc. > easier to take > > 2 - Outsource this role and activate it when > required and justify putting > money into investing in software and/or hardware to > allow a single DBA > function to required levels. > Pros: New tools etc. to learn and broader experience > gained. More > bargaining power if required. > > I'd like to hear your feedback on which path you'd > be inclined to take and > why?. Also if going it alone what you'd look for > software in hardware and > other areas. Currently 6 NT servers, 10 databases > and expanding... > > > Sean :) > > Rookie Data Base Administrator > Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K > [0%] OCP Oracle8i DBA > [0%] OCP Oracle9i DBA > __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Error in creating tablespace
Ashraf Jan, Create a directory within the C drive labled "ORADATA". Then in svrmgr30, login as system, then type: CREATE TABLESPACE PAYROLL DATAFILE 'C:\ORADATA\PAYROL.ORA' SIZE 10M; make sure to use the semicolon, not the /. I know it sounds stupid, but just do it please. Please let me know what happens. For some reason, Oracle is having a problem writing to the FIRST block, which indicates that something is preventing writes to the root directory. Regards, Satar Naghshineh --- ASHRAF SALAYMEH <[EMAIL PROTECTED]> wrote: > Hi List, > > I tryed to create the tablespace from svrmgr30 > as satar naghshineh told me. > But i still face the same error... > CREATE TABLESPACE PAYROLL > DATAFILE 'C:\PAYROL.ORA' SIZE 10M > SQL> / > ERROR at line 1: > > > ORA-19502: write error on file "C:\PAYROL.ORA", > > > blockno 1 (blocksize=2048) > > > ORA-27069: skgfdisp: attempt to do I/O beyond > the > > > range of the file > > > OSD-04026: Invalid parameter passed. > > > O/S-Error: (OS 64) The specified network name is > > Any one can tell me what I have to do? > > Regards, > Ashraf __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Error in creating tablespace
Salaam Ashraf Jon, It appears that Oracle has a problem writing to the C drive to create the datafile on the very first block. This error is usually the result of a size issue over 4gb for the datafile or a file that has been autoextended. In your case, it appears it doesn't like the command (maybe some character is being passed through the command?). Delete the file and re-try it again. try doing this in svrmgrl80 and put a ; at the end. Good Luck, Satar Naghshineh --- ASHRAF SALAYMEH <[EMAIL PROTECTED]> wrote: > Hello list, > > I'm using Personal Oracle8 Database and Win98 > Platform > > I issued this command from Sqlplus8.0 : > >CREATE TABLESPACE PAYROLL >DATAFILE 'C:\PAYROL.ORA' SIZE 10M > SQL> / > > I am trying to create new tablespace Payroll but I > have got this error! > > > CREATE TABLESPACE PAYROLL > * > ERROR at line 1: > ORA-19502: write error on file "C:\PAYROL.ORA", > blockno 1 (blocksize=2048) > ORA-27069: skgfdisp: attempt to do I/O beyond the > range of the file > OSD-04026: Invalid parameter passed. > O/S-Error: (OS 64) The specified network name is no > longer available. > > > The strange is you can see the PAYROLL.ORA under C:\ > Directory > After the error is displayed. > > But when you query : > > SQL> select tablespace_name > from dba_data_files; > > you can find nothing, no tablespace is created at > all... > > I wish someone can help me to solve this problem. > > Best Regards, > Ashraf Salaymeh > __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Looking for 24 X 7 Design Considerations
I'm pretty much in the same boat. All my global databases are doing well. There are virtually no database issues. People wonder why the company pays me so much money for doing nothing. However, I still get those calls at odd hours of the day/night (because of the time differences) from system administrators that think something is wrong with Oracle. Also, management loves to implement software upgrades/patches during the Holidays or weekends. I'm just glad that I live in California, where a recent law (Assembly Bill 60)forces my employer to pay me by the hour. Overtime and off hour phone calls are my new best friends! Regards, Satar Please understand that the Muslim faith does not advocate violence. The animals who targeted America are not TRUE believers of the faith and acted on EVIL, instead of the teachings of the Koran. Please do not displace your anger on innocent Muslims living in your local area. --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > Now I must disagree with this. Although I am on > call every annoying day of the year it is so rare > that I have database issues its not even funny. > I think nothing of leaving for the weekend. At the > very least I can talk someone though something, even > if I am at the top of a mountain. Calls have > to wait while I am on the wall at Smith Rock though > (or my climbing partner is on the wall). > > > 5. Kiss your weekends and Holidays good bye! > > __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: The DBA in the IS organization
King > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: O'Neill, Sean > 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). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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: Looking for 24 X 7 Design Considerations
All the databases that I have worked on or been responsible for, have been 24x7. Here are some suggestions: 1. Know the requirements of your environment in regards to UPTIME. Have it documented. The best practice that works well is Service Level Agreements, if there is none in place, implement them. There is a world of cost differences between systems that can be down for 2 hours to those which can't be down at all. 2. In high availability databases, a Hardware cluster configuiration is highly recommended for 2 purposes: (A) Fast recovery and (B) Software upgrades (both APP and DB). 3. If you do not have a Test server, buy one! 4. Make sure that everyone (network Admins, DBAs, System Admins, etc.) has a way to communicate with one another. I suggest Cell phones as apposed to pagers. 5. Kiss your weekends and Holidays good bye! If you have any specific questions, please feel free to contact me at [EMAIL PROTECTED] Regards, Satar Please remember that TRUE muslims do not advocate violence. Please do not displace your anger upon innocent muslims in your local area. --- Tracy Rahmlow <[EMAIL PROTECTED]> wrote: > We currently have 15+ databases (7.3.4 & 8i using > IBM AIX and HACMP) that do > not have a 24x7 restriction. Now, management is > looking to bring in new > products that will need to be 24X7. They are > looking for costs to determine > the viability of such a decision. I have no 24x7 > experience and am looking for > ideas or options to consider. [At least initially > they are stating there can > be no downtime for maintenance (upgrades/reorgs)] > __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 8i Upgrade Proposal - Need Help!
Title: Oracle 8i Upgrade Proposal - Need Help! Hello Ladies and Gentlemen, I need to present a proposal to management on Upgrading on of our databases from Oracle 7 to 8i. I was wondering if anyone out there already has done this. If so, can you please e- mail me a copy of this proposal or presentation. Also, any ideas or thoughts that should be included, will be greatly appreciated. If any of you are Running BaaN ERP on top of Oracle, I would love to hear from you as well. Regards, Satar Naghshineh PS I apologize for re-posting, but I forgot to include a subject line which might have been the reason why I didn't receive any replies. mailto:[EMAIL PROTECTED]
RE: Tablespace layout
Title: RE: Tablespace layout Hi Cherie, Just shove all your data on a RAID 5 (great for data Warehouses) and forget about it. If that is not possible, then stick with what your DBA team has stated about everything being ok as long as the extents are multiples of one another. Regards, Satar Naghshineh -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 7:27 PM To: Multiple recipients of list ORACLE-L Subject: Tablespace layout I've been thinking a lot about our tablespace layout for our data warehouse. Our warehouse is approaching 200Gig and is almost out of space on disk. I'm getting another 75 Gig this weekend and am trying to plan the best use for that 75Gig. Our current data tablespace layout is that we have two tablespaces for small, medium, and large data tables and the same for indexes. So it's something like this: SM_DATA01 SM_DATA02 MED_DATA01 MED_DATA02 LG_DATA01 LG_DATA02 SM_IDX01 SM_IDX02 MED_IDX01 MED_IDX02 LG_IDX01 LG_IDX02 I think that theoretically, all of the tables in each of the tablespaces were supposed to have the same sized extents when they were originally created. However, over time, there are multiple sizes of extents in the large and medium tablespaces. Even though we show significant free space, it is fragmented and coalescing can not put together enough contiguous space to reuse a lot of the available space. Our largest tables are partitioned. However the partitions are not split out into separate tablespaces but go into the same medium and large tablespaces as non-partitioned tables. Theoretically, I suppose that this is not a problem if, when partitions are dropped every month, the resulting space is reused 100%. I'm not sure if it is. Here is my question. My DBA team members feel that it's fine to have tables with a variety of extent sizes in the same tablespace as long as they are all multiples of each other (50, 100, 400, 2000, etc.). My concern is that this setup is fine when the smaller tables need to extend but when the larger tables need to extend, they can't pull together enough contiguous space and I keep having to add more. I'd prefer to have only one size of extent in each tablespace and keep it very pure that way. Then I know every single extent can be reused. So I am considering increasing the number of tablespaces so we have something more like this: 1kdata 10kdata 100kdata 1mdata 10mdata 100mdata 1000mdata 1kidx 10kidx 100kidx 1midx 10midx 100midx 1000midx I would also probably split them out into at least two tablespaces for each level. Maybe not for the smaller sizes, but for the larger sizes. I have several issues I'm trying to keep in mind. One is the ease of maintenance for initial creation and ongoing upkeep. I don't want to have too many tablespaces if I don't need to. Another issue is mean time to recover. If we lose a single tablespace, I'd prefer to have to recover fewer files. The maximum file size we are using is 2Gig. We need to keep our recovery time under four hours total. Probably the biggest issue I'm facing now is the sheer size of the large tablespaces. They are so big and bulky that it's almost impossible to reorg them or even just clean them up. I think that if I had more smaller tablespaces, I would have more options. This database is still at 8.0.4 and it's going to be a while before it can be upgraded so that limits my options for reorging as well. All cleanup has to be done in a series short Sunday windows. I don't have the luxury of a tool for doing this reorg so have to do it manually. Another issue is partitions. We are dropping the old partitions on the main fact table once a month. We are not currently planning on dropping any of the other partitions. The tables have a variety of partition names and schemes. Some are partitioned yearly, monthly, quarterly, half-yearly. There is no consistency. I'm debating whether I should split each partition out into it's own tablespace. That would be almost a hundred tablespaces. Or just the table that we're dropping partitions on monthly. That would be about 50 tablespaces. Or should I just leave them all in the same tablespaces as non-partitioned tables? We are using Sun Solaris 2.6 on an E10K. We have EMC disk and Veritas file manager. Using version 8.0.4 of Oracle, as I said. Using RMAN and Veritas for backups. Any feedback, ideas, suggestions, things to watch out for, think about, etc. would be greatly appreciated. This is going to take a lot of time and effort to do and I don't want to get all the work done and find out it doesn't work as well as I hoped and have to redo everything. Thanks for your time, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Burning game CD's
Title: RE: Burning game CD's Hi Tom, Here's a great website for all your burning questions! http://www.ultimateresourcesite.com/cdburning/main.htm Also a search on www.deja.com (AKA google) on "burning game CD" produced a lot of interesting related articles. Happy Reading and Burning! Regards, Satar Naghshineh > -Original Message- > Tom > Sent: Monday, August 27, 2001 10:55 AM > To: Multiple recipients of list ORACLE-L > > > Off Topic: I bought a PC this weekend that had my first every CDROM > burner. I > couldn't wait to use it. I burned several game CD's (Age of Empires, > Return Fire II, Roller coaster Tycoon) and none of them worked. The games > just hung > when I ran them. Bummer. Is it not possible to make copies of my CD's or > am I > doing something wrong? > > Tom > > Tom Terrian > Oracle DBA > WPAFB - DAASC > [EMAIL PROTECTED] > 937-656-3844 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Terrian, Tom > INET: [EMAIL PROTECTED]
RE: How fast are your tape backups?
Title: RE: How fast are your tape backups? 50 gigs in 1.5 hours. HPUX 10.20 OmniBack 3.5 Oracle 7.3.4 HP DLT8000 Regards, Satar Naghshineh -Original Message- From: J.C. Stofer [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 2:05 AM To: Multiple recipients of list ORACLE-L Subject: How fast are your tape backups? Hello list. I have a brand new database that is around 200 GB in size. Our tape backup solution which was supplied by the hosting company is only giving me bewteen 6 and 7 MB per second . A full cold backup can take 8 to 10 hours at this rate. I looked at the specs for the tape library they sold us and it says 15MB/sec or up to 30 MB/sec compressed. What gives? The storage is SCSI 3 and also some Fibre channel so I don't think the drives are the bottleneck. What kind of numbers are other people getting? The system NT 4 4GB RAM 400 GB storage (mix of SCSI 3 and fibre) Oracle 8.1.6.3.0 ~ 200 GB in Oracle data files Tivoli Storage Manager IBM robotic tape library (via fibre) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: J.C. Stofer INET: [EMAIL PROTECTED]
No Subject
Title: Hello Ladies and Gentlemen, I need to present a proposal to management on Upgrading our database from Oracle 7 to 8i (don't laugh, we know we're behind the times!). I was wondering if anyone out there already has done this. If so, can you please e- mail me a copy of this proposal or presentation. Also, any ideas or thoughts that should be included, will be greatly appreciated. If any of you are Running BaaN ERP on top of Oracle, I would love to hear from you as well. Regards, Satar Naghshineh mailto:[EMAIL PROTECTED]