RE: tnsnames.ora not working ?

2004-01-20 Thread Scott Canaan
Are you using Oracle Services? I've seen this happen before and we change SERVICE_NAME to SID and everything works fine. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Reuben

Re: Cold Fusion and Bind Variables

2004-01-13 Thread Scott Behrens
Jared, Try this link. It still worked for me this morning. http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_oracle_databases.html Scott [EMAIL PROTECTED] 1/12/04 8:49:25 PM Dear List, We have a developer here that is pretty good with the web stuff, but his strong suit

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Scott Canaan
This is what I got, Oracle 8.1.7.4 on Sun Solaris (I dropped the user): Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL create user scott identified by tiger; User created. SQL select password 2

Re: Re: Little competition

2003-12-12 Thread Scott Behrens
Hey Richard, One of my desktop treasures is an autographed copy of Jonathan Lewis' book, Practical Oracle8i. The humorous, self-deprecating caption in the author's own hand: 'Never believe all you read.' Scott [EMAIL PROTECTED] 12/12/03 7:24:24 AM Hi Jonathan,SQL create tablespace

RE: Misbehaving query

2003-12-12 Thread Scott Canaan
That's what I was thinking, too. I tried it on 8.1.7.4 and it works the same way, as I expected. You would need an outer join to get something back. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer

RE: what is oracle rdb?

2003-11-25 Thread Scott Graves
limited to the VMS platform (no flames, I love VMS) it would have a much bigger installation base. Back to the grind...(What was that Unix/Oracle command to...) /list lurker on Scott Graves Sr. Systems Programmer NISC RDQ-STP Email: [EMAIL PROTECTED] Phone: 636-922-9122 x7616 Fax: 636-922-2080

RE: Oracle 10g Migration

2003-11-21 Thread Scott Canaan
According to the presentation by Dave Foster of Oracle at the last UNYOUG meeting, there will be a direct upgrade from 8.1.7 and 9.2. Also, the new dbassistant has an undo feature, to rollback the upgrade. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out

RE: New Virus alert from paypal

2003-11-19 Thread Scott Canaan
Since, I believe, Paypal is owned by eBay, has any that's received this sent a message to safeharbor? I would think they should be made aware of it. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer

RE: Point-In-Time recovery question, Non-RMAN solution

2003-11-06 Thread Scott Canaan
Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message

RE: RE: dba interview questions

2003-10-24 Thread Scott Canaan
; end; / Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Friday, October 24, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Sure do, here's my favorite

RE: Question about sql

2003-10-16 Thread Scott Canaan
How about: insert into table3(company_id,lev_id,vare_id) (select table2.company_id,lev_id,vare_id from table1, table2 where table1.company_id = table2.company_id); Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you

Re: Basic question about controlfile recovery

2003-10-08 Thread scott
Thankz Mladen Govindan. I do have Velpuri's book besides me. let me go thro' it once again. Regards, Scott. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http

RE: FIRST_ROWS hints

2003-10-08 Thread Scott Canaan
Did you remember to cut the db_file_multiblock_read_count in half, since you doubled the blocksize? I would assume that you also started seeing more full table scans, as well. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends

Basic question about controlfile recovery

2003-10-06 Thread scott scott
controlfile recovery ? Q3.i have backup ( one day old ) of all my datafiles/archivelogs/controlfile.now,when all my controlfiles are lost with online redologs intact, is complete recovery possible ? if so, is open resetlogs reqd. why ? Please enlighten me. i'll continue RTF(ine)M. Regards, Scott

RE: Using dimensions

2003-09-29 Thread Scott Canaan
, century. This is used for rollup reporting within the data mart. I dont see any good use of it in an OLTP environment, but I may be wrong. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original

RE: Sqlloader question

2003-09-12 Thread David Scott
. If you can't get to the IOUG web site and would like a copy of the paper, send me an email. David Scott [EMAIL PROTECTED] From: [EMAIL PROTECTED] Date: Thu, 11 Sep 2003 14:12:49 +0200 Subject: Sqlloader question Hallo, Anyone whom could tell me if it is in an sqlloader possible to write

RE: Sqlloader question

2003-09-11 Thread Scott Canaan
em_contact_hist_ld.ctl In the script, this was followed by a call to sqlldr with the control file em_contact_hist_ld.ctl. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent

RE: How to send an email from unix command line?

2003-09-09 Thread Scott Canaan
Have you tried mailx? That's what we use here. Scott Canaan ([EMAIL PROTECTED]) -Original Message- Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL

Re: Forms - as sysdba

2003-08-22 Thread Scott Lamb
Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. Does anyone know if/how is it possible? Yes, you could do this by creating an ON-LOGON trigger. But this is a really, really bad idea. Scott Lamb

Re: ADMIN: Warning about virus threats this week

2003-08-22 Thread Scott Lamb
deliberately not sending them. Thanks, Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: select strings with '_' in it

2003-08-19 Thread Scott Lamb
an index on translate(col1,'_','#') (unlikely), that query will always result in a sequential scan. Ugh. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Tracing a user session with multiple database connections

2003-08-18 Thread Scott Lamb
-- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

Auth via Active Directory

2003-08-15 Thread Scott Lamb
or something, for audit trails, I think.) Does anything like this exist? Or is there another way, however convoluted? Thanks, Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: what happens if a remove a job that is running?

2003-08-14 Thread Scott . Shafer
Yes. If you really want to kill the job, the graceful way is to break it first (dbms_job.broken) and then remove it (dbms_job.remove). Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 10:00

RE: Oracle SCN Question

2003-07-31 Thread Scott . Shafer
I thought Bass and Rap were synonymous? Or am I out of touch with the current music scene? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Nick Wagner [SMTP:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 4:24 PM To: Multiple recipients of list ORACLE-L

RE: STATSPACK in Oracle 8.1.6.0

2003-07-18 Thread Scott . Shafer
Metalink, Technet, Google, or at the scripts themselves (which all have explanatory headers). Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Richard Foote [SMTP:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:34 AM To: Multiple recipients of list ORACLE-L

RE: Recent reports on outages caused by DB2 and 9iRAC issues

2003-07-18 Thread Scott . Shafer
That's funny, I thought SAC's motto was SAC eats it's young. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Goulet, Dick [SMTP:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Recent reports

RE: Interview Questions for a Unix Solaris System Admin

2003-07-15 Thread Scott . Shafer
question #1: Do you realize that your DBA is a God, and you will obey his/her edicts without question? question #2: Are you aware of the daily offering of food/beer required to keep in your God's (DBA's) good graces? etc... Scott Shafer San Antonio, TX 210.581.6217 -Original Message

RE: Interview Questions for a Unix Solaris System Admin

2003-07-15 Thread Scott . Shafer
You only spend time on the technical stuff if they pass this round. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Interview

RE: log for transaction

2003-06-24 Thread Scott . Shafer
We use a similiar method which involves inserting periodic rows into a log table, which is dumped to a file at end-of-job. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Kirtikumar Deshpande [SMTP:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:05 PM

RE: Re: Passwords and authentication

2003-06-19 Thread Scott . Shafer
HIPAA Auditing for Oracle Database Security Nice. Well, Arup, Get to publishing! ;-) --Scott -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 3:19 PM http://www.dba-oracle.com/bp/bp_titles.htm Look about in the middle of the page. -Original Message

RE: copy a datafile to a raw device

2003-06-19 Thread Scott . Shafer
You left out, ...and why is there a goat in the corner? Sounds like a fun way to have at my duhvelopers (not the good ones). -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 4:49 PM Concerning my speculation about error messages in the Oracle kernel, the

RE: World premier performance of the BAARF party logo

2003-06-12 Thread Scott . Shafer
And the satanic redeye is a nice effect for a dba. Could this be the start of oracle pr0n? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/12/03 6:19 PM Hey, Who cares about that RAID thing. Whose the cutie in the pictures - hehe. -Original Message-

Re: Anyone installed Oracle 9.2 RAC on solaris 9

2003-06-06 Thread Scott
and Veritas DBE/AC 3.5 you will have to use update 3 or apply a patch (which I am not sure of at this time) to fix a problem with the /dev/sd driver and SCSI-III persistent reservations. Hope this helps, Scott --- laura pena [EMAIL PROTECTED] wrote: We have been given the funding to install

RE: Anyone installed Oracle 9.2 RAC on solaris 9

2003-06-06 Thread Scott
that they have successrully tested a 8 and 16 node Veritas cluster with 9i RAC and they are working with Oracle to get this certified. So, yes Veritas DBE/AC 3.5 is currently supported up to 4 nodes with MP1 installed. Scott --- Matthew Zito [EMAIL PROTECTED] wrote: Pete's absolutely right - I didn't

RE: cannot allocate new log

2003-06-03 Thread Scott Stefick
the db up in mount mode to start the archiver before you open the database. -Scott At 08:24 AM 6/2/03 -0800, you wrote: Hi Denis, Thanks for the quick reply, We're not getting an oracle error no: This is the message in the alert log Mon Jun 02 08:19:19 2003 Thread 1 cannot allocate new

Re: SunCluster 3. 0 Veritas File system RAC

2003-04-04 Thread Scott
. You can't Veritas's CFS on SC3.0. Hope this helps, Scott --- Vladimir Barac [EMAIL PROTECTED] wrote: Anyone using this configuration? Since I would like to avoid raw partitions, I was thinking of recomending Veritas File system... Is it certified / working? Anyone working

Importing Schema getting compilation errors on some triggers

2003-04-04 Thread Scott Stefick
and imported the whole .dmp file into TRAIN. Any Thoughts? -Scott ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott

Re: Importing Schema getting compilation errors on some

2003-04-04 Thread Scott Stefick
= I'm guessing it's a problem with DBMS_OFFICE and not with the trigger after seeing this. -Scott At 01:43 PM 4/4/03 -0800, you wrote: Scott, can you run this command in sqlplus and e-mail the results out to us... show errors trigger triggername [EMAIL PROTECTED] 04/04/03 02:14PM Hello

RE: Importing Schema getting compilation errors on some

2003-04-04 Thread Scott Stefick
ignored = I'm checking why this would have happened. So far I've checked the synonyms and the dba_objects view and they look ok. -Scott At 01:59 PM 4/4/03 -0800, you wrote: Scott: My first thought is to ask if there are any external references

RE: Importing Schema getting compilation errors on some

2003-04-04 Thread Scott Stefick
, that doesn't make sense to me now. Rick, if you're ever in the Chicago area, I'll have to buy you a beer (or whatever you prefer). Also, thanks to everyone who helped me. Rick Weiss Darrell Landrum Stephane Faroult Gary Kirsh Charlie Mengler Thanks! -Scott At 02:53 PM 4/4/03 -0800, you wrote: Do you

RE: Importing Schema getting compilation errors on some

2003-04-04 Thread Scott Stefick
Rick, I agree with having to celebrate, since I was able to accomplish my task before I left for the weekend. That's always a good thing. Have a good weekend as well and good luck with the weather and the fishing. -Scott At 03:43 PM 4/4/03 -0800, you wrote: Scott- Wow - what a way to finish

Where to set LD_LIBRARY_PATH in Database for 3rd Party Utilities

2003-04-03 Thread Scott Graves
this to work, but no details. Where should I set the LD_LIBRARY_PATH variable for the database to be able to find this 3rd party library files? Any ideas would be appreciated. As you can probably tell, Im new to Unix/Linux. Thanks in Advance, Scott Graves Sr. Systems Programmer NISC RDQ-STP

Re: Sun HA Monitoring and Oracle 9

2003-04-03 Thread Scott Canaan
(about 1 week). If we get the funding, our plan is to buy 2 more Sun machines, build a 2-node cluster with HA 3.0, migrate the applications to that cluster, then bring 2 of the original Sun machines into that cluster, making it a 4-node cluster again. Barbara Baker wrote: Scott (or anyone runing

RE: Oracle Job Task Analysis

2003-04-02 Thread Scott
. Is knowing the GUI sufficient for me to be a DBA? These are why I am asking these questions. I really want to know what you really need to know right down to you only need to know it if you implement the option. Does this help? Scott --- Hallas, John, Tech Dev [EMAIL PROTECTED] wrote: Scott

Oracle Job Task Analysis

2003-04-01 Thread Scott
for Multidimensional OLAP processing Thanks in advance for your help, Scott __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: alert log file

2003-03-31 Thread Scott Stefick
If you move the alert log to another directory, Oracle will create a new one in its place. There is no need to bounce the DB. -Scott At 07:54 AM 3/31/03 -0800, you wrote: for one of the db over here alert log is biggg .Looks like its never been truncated or backup . Is it a problem if i

Re: Hotsos Clinic 101 Feedback

2003-03-26 Thread Scott Stefick
). ** Scott Stefick Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services

Test

2003-03-21 Thread Scott Stefick
This is a test, I have not received any messages in the last couple of days. -Scott ** Scott Stefick Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http

Urgent - ORA-03001 Error While creating BLOB in 9.0.1 ?!

2003-03-19 Thread Scott Nealy
: http://www.orafaq.net -- Author: Scott Nealy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

Re: Thanx: how to get metalink user name

2003-03-18 Thread Scott Nealy
: http://www.orafaq.net -- Author: Scott Nealy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

Re: Thanx: how to get metalink user name

2003-03-18 Thread Scott Nealy
: http://www.orafaq.net -- Author: Scott Nealy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

RE: why SAN ? why not external storage ?

2003-03-14 Thread Scott . Shafer
Oh, Gods forbid the sysadmins would have to gulp do their job... HAHAHAHAHA!!! Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Subject

RE: RE: why SAN ? why not external storage ?

2003-03-14 Thread Scott . Shafer
All of the places I've worked its been sysadmins fat-fingering that has hosed or cross mounted disks. Then again, we've never had EMC... HP arrays are enough trouble. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent

RE: DBV Cannot Load Module LIBDCE.A

2003-03-13 Thread Scott Behrens
r the sake of dbv(if the rest of the environment is stable) until I had a better understanding of the opsys environment and the Oracle installation history. HTH, Scott [EMAIL PROTECTED] 3/12/03 5:15:58 PM Hi all,First, thanks Jared for the info.The libdce.a file does not exist on any of our A

RE: POLL: Database to DBA ratio

2003-03-11 Thread Scott . Shafer
139 remote production servers/instances (30 are large to VLDB, the rest small), 5 development instances, 1 9iAS test instance, 3 dba's. Mostly reporting with batch ETL jobs run nightly. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Robin Ilardi [SMTP:[EMAIL

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Scott Stefick
Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: Amen! For several years we heard from EMC reps, don't worry about it, don't worry about it, then recently we we're given a white paper from EMC on striping for Oracle

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Scott Stefick
That's great! Thanks a ton. -Scott At 10:44 AM 3/7/03 -0800, you wrote: I'm pretty sure I only recieved a hard copy (I'm not in the office to check), but they publish a lot of pdf documents on their site. I'll see if I can locate it there and send a URL. [EMAIL PROTECTED] 03/07/03 10:55AM

RE: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Scott Stefick
the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ

Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-06 Thread Scott Stefick
on a SAN architecture provided that management goes that way. The SAN box we are looking at right now is the EVA3000 from HP (although this isn't a definite) not sure if this matters. TIA, -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle

Re:

2003-03-04 Thread Scott Stefick
Anyone? ... Anyone? At 11:50 AM 3/4/03 -0800, you wrote: HELP ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 **

Import Problem

2003-03-03 Thread Scott Canaan
interrupted? I have been looking in metalink and on the net and haven't found anything that says how to do it. I tried technet, but it was way too slow. Any thoughts would be greatly appreciated. Thank you, -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out

Re: Purely for your amusement

2003-02-27 Thread Scott Behrens
Thanks! I especially liked: TABLE...FULL OF 'WOE' That seems to be how the day is going for several of us. Scott [EMAIL PROTECTED] 2/27/03 1:23:55 PM And you thought your job was bad . . .(Yes, this IS a production job)-- snipped

Re: UPDATE...REPLACE...#39;...apostrophe...

2003-02-25 Thread Scott Canaan
m_num, '-OR') = b.item_num and b.last_cost > 0 union select c.whse_code, c.item_num, c.last_cost, c.last_cost as last_cost_rev from item_w c where c.last_cost > 0 ; -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

Re: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??

2003-02-21 Thread Scott
install RAC. Hope this helps, Scott --- dist cash [EMAIL PROTECTED] wrote: I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks

RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??

2003-02-21 Thread Scott
Greg, Sorry to be picky but you can still use raw Devices with Veritas DBE/AC 3.5 if you don't want to use thier CFS. If you use SC then your only choice is raw and you probably will need Veritas to manage you LVM's anyway. Scott --- Loughmiller, Greg [EMAIL PROTECTED] wrote: news to me

lsnrctl status

2003-02-19 Thread Scott Stefick
ideas why this could be happening? I want to be able to be in any one of the environments and see the services. TIA, -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130

RE: lsnrctl status

2003-02-19 Thread Scott Stefick
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH TNS_ADMIN PATH=$ORACL_HOME/bin:$PATH export PATH */ The 9i login environment script look the same except for: ORACLE_HOME=u01/app/oracle/product/9201 ORACLE_SID=REGENTDB Thanks, Scott At 11:24 AM 2/19/03 -0800, you wrote: You forgot

Re: lsnrctl status

2003-02-19 Thread Scott Stefick
. Scott Stefick sstefickTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @harpercollege.e cc: du Subject: lsnrctl status Sent

RE: Teradata baned from IOUG???

2003-02-19 Thread Scott . Shafer
Soon you too will be assimilated. The TUSC Collective will add your distinctiveness to its own. --Seven of Nine-Hundred Ninety-Nine -Original Message- From: Daniel W. Fink [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:59 PM To: Multiple recipients of list ORACLE-L

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Scott Stefick
I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful

Re: Oracle 8i or 9i ?

2003-02-17 Thread Scott Stefick
list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130

Re: Oracle 8i or 9i ?

2003-02-14 Thread Scott Stefick
suggest taking the 9i courses. I took the 8i courses because they were the New Version when I started. This helped me a lot in my learning process and I would recommend it to anyone. So far I think it's a great field and I think its the best career decision I've made to this point. Good luck, -Scott

Re: URL for Oracle 9i entry level email lists

2003-02-14 Thread Scott Stefick
if you really want to work with Oracle. -Scott At 08:44 AM 2/14/03 -0800, you wrote: This list seems at like it's a little too advanced for a beginner. Do you think I should just stick with it for a while to get familiar w/ some of the Oracle stuff? - Original Message - From: Jamadagni

RE: AIX Oracle 9.2

2003-02-13 Thread Scott . Shafer
How about relink all from the $OH/bin directory? Or is this utility gone in 9i? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Tim Gorman [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Subject

Re: No redo or archived log files

2003-02-13 Thread Scott Stefick
want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130

Re: rootpre.sh

2003-02-11 Thread Scott Behrens
async I/O.) It seems to me I read somewhere that 8.1.7 still requires a 32-bit kernel extension and therefore, you may not be able to run a 64-bit AIX kernel with 8.1.7. Scott [EMAIL PROTECTED] 2/11/03 12:59:53 PM I am trying to run rootpre.sh. My admin just upgrade the kernel to 64-bit.We were

RE: multiple oracle homes

2003-02-07 Thread Scott Stefick
. Then it calls another script depending on the choice to set those variables and echo them to verify by using: env | grep ORA env | grep TNS This has been working ok so far, but if anyone has any better suggestions, let me know. -Scott At 10:34 AM 2/7/03 -0800, you wrote: I agree with Dennis. We

Re: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

2003-02-06 Thread Scott Behrens
. Hope this was relevant, Scott [EMAIL PROTECTED] 2/6/03 9:23:58 AM Good morning everyone - Quick poll for those of you on 8.1.7 and AIX 4.3.3: Do you have TIMED_STATISTICS = true? Have you encountered any problems with it? The databases I inherited have this set false all over the place

RE: Update NT to 2000 Server

2003-02-06 Thread Hayes, Scott
First off I am an NT/Win2k admin and I fully agree with you Jared. Blow the partition and start from zero, you'll be happy you did. Scott First off, I am not an NT/Win2k admin, and don't even play one on TV. The advice from every SA I've asked about this, and from searching the web

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

2003-02-06 Thread Scott Stefick
Lisa, Try oslevel -r at the command promt. It should tell you. -Scott At 09:49 AM 2/6/03 -0800, you wrote: Hi Ethan, Thanks so much for your reply. I'll have to check which patch level we are on. Have a great day! Lisa -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED

Export / Import

2003-01-31 Thread Scott Stefick
, -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET

export/import

2003-01-31 Thread Scott Stefick
Never mind. After I posted, I found a good website that included all of what I was looking for. Just incase anyone else wants that kind of info, here is the link: http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96652/part1.htm Thanks, -Scott

RE: STATSPACK

2003-01-29 Thread Scott . Shafer
See: http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.html and related articles. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 3:49 PM To: Multiple recipients

RE: Perl - Was Unix time conversion function

2003-01-28 Thread Scott Stefick
What's the title of Jared's book? -Scott At 05:03 AM 1/28/03 -0800, you wrote: I used to be, but I finally bit the bullet ... I ordered my copy of Jared's book from Amazon.com yesterday !! Raj __ Rajendra Jamadagni MIS, ESPN Inc

RE: AUTORAID and VA7100 disk arrays for rp7400

2003-01-23 Thread Scott . Shafer
We are using the VA7100's and VA7400's. They are several orders of magnitude faster than the old 12H AutoRAID arrays if configured properly. I'm no expert, but I know the VA7X00's combine some caching technology with faster IO channels. Scott Shafer San Antonio, TX 210.581.6217 -Original

Re: ORA-29702: error occurred in Cluster Group Service operation

2003-01-10 Thread Scott
Sean, Have you installed the hang-check-timer RPM? If you have installed hangcheck are you loading the hangcheck module? insmod hangcheck-timer hangcheck_tick=TICK hangcheck_margin=MARGIN Scott --- From [EMAIL PROTECTED] wrote: Hello all... I'm running 9iRAC 9.2.0.2 on Linux 2.4.20

Sun HA Monitoring and Oracle 9

2003-01-06 Thread Scott Canaan
require a rebuild of the entire cluster. Has anyone else run into this problem? If so, what have you done to get around it? Let me know if I forgot any important piece of information. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out

Re: Hotsos Clinic

2003-01-02 Thread Scott Behrens
Keith, I had the great good fortune to be able to attend the Hotsos Clinic in March, 2002 and then, in November, to attend Jonathan Lewis' seminar. Best investments in Oracle I ever made. Scott Behrens [EMAIL PROTECTED] 1/2/03 1:41:45 PM I have an opportunity to attend a Hotsos Clinic

Re: warehouse builder's dependance on oem job system.

2002-12-13 Thread Scott Canaan
also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott

RE: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],

2002-12-12 Thread Scott Graves
Satish, list lurker off Use the JDBC driver from the 9.0.1 database. The 8i JDBC driver causes this error. /list lurker on Scott -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of SATISH P Sent: Thursday, December 12, 2002 8:34 AM To: Multiple

Re: hmm...

2002-12-06 Thread Scott Canaan
list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ

RE: hmm...

2002-12-06 Thread Scott
Adam, If you need keep the global_name the Create the database link with @ symbol. The online documentation http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96521/ds_admin.htm#13803 gives you some examples. I am not sure if this is what you are looking for but it may help. Scott

RE: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Scott Stefick
). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL

RE: Recipe for application design to run on RAC

2002-12-04 Thread Scott
-mastered, but the view is never populated. This is one those if it's in the Doc. it may have been true in the past, It may be true now or it may true in the future. This one of those in the future features. Scott --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: I know I know (he says jumping up

Best practice for backing out of Application Patches

2002-12-03 Thread Scott Stefick
a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official

[no subject]

2002-12-03 Thread Scott Stefick
unexpected issues. TIA! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott

RE: Best practice for backing out of Application Patches

2002-12-03 Thread Scott Stefick
the production Database (As long as the problem was caught before getting put on the production Database). I just want to be covered from all angles before this application goes into production. Thanks again! -Scott Stefick At 12:14 PM 12/3/02 -0800, you wrote: Scott, Of course, the answer

Re: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????

2002-12-03 Thread Scott
I have not used this feature but there is a note on metalink that you may find useful regarding dynamic SGA issues on Solaris 8. It is note 151222.1 Scott --- dist cash [EMAIL PROTECTED] wrote: We are doing ORACLE 9.2.0.2 Enterprise Edition testing on SUN server (Solaris 8

RE: a PL/SQL design question.

2002-11-28 Thread Hayes, Scott
here is my answer. -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 28, 2002 12:34 PMTo: Multiple recipients of list ORACLE-LSubject: a PL/SQL design question.

  1   2   3   4   5   6   >