Your details

Please see the attached file for details. movie0045.pif Description: Binary data

Re: alter system reset

Yes , opened up spfile in a text editor and undo_suppress_errors exists. But I get the error , no matter which parameter I try to reset. ex: undo_management, undo_tablespace, undo_retention, pga_aggregate_target, workarea_size_policy, shared_pool_size, sort...etc, etc However when I open the sp

RE: Oracle on Win2000

Citrix could another option worth evaluating. (I personally find it better than PCAnywhere.)   Regards, Charu. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Thursday, September 04, 2003 3:25 AMTo: Multiple recipients o

ProAct with Oracle

Hi all,   who has used ProAct products (NetApp Filer etc),  with oracle with RAC and/or Linux.   How do rate those and do you have any feedback or recommendations.   All information is appreciated!   rgds gWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger

Re: EXECUTE IMMEDIATE and PL/SQL variables - SOLVED

Sorry listers, I spent a bit of time searching Google and quickly found my answer. I shouldn't have rushed to post to the list. The answer is to move the INTO clause outside of the string as shown below: DECLARE n_count NUMBER; BEGIN EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM DUAL' IN

RE: Oracle not available???

Thanks Patrice, I'll look into this, however I find it way strange that the server has been running no problems for almost three months. Maybe a suggestion from one of the other listers is very pertinant - reboot bi-weekly perhaps. However I hear from my virus admin that we were attacked by anothe

RMAN backup and recovery scenarios

Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks & Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-50

EXECUTE IMMEDIATE and PL/SQL variables???

Hi List, I know someone will have a good answer to this question: I have a large PL/SQL program to convert some data. Some tables are created dynamically during the PL/SQL procedure using EXECUTE IMMEDIATE. I need to query values from some of these tables (only a couple of rows, so performance

Re: Urgent INFO needed.

Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that "you get what you pay for" or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...

Re: ORA-01031: insufficient privileges -- from user oracle running

Sorry to be pedantic, but that isn't the sticky bit, that is the SUID bit. There's also an SGID bit. The sticky bit is set with a 't', and is redundant on modern versions of unix ( including linux ) and may well be ignored altogether. Oh, and I'm not sorry about being pedantic, not really. :)

Re: Oracle World - Listers get together (proposed Tuesday Sep 9)

Why don't listers meet on the east coast, somewhere in the area codes 203,718 or 212? I don't pay roaming charges in those phone areas. Can you hear me now? On 2003.09.04 00:49, Arup Nanda wrote: John, Oracle Awards felicitation is a luncheon on Wednesday. So Dinner is free that day. By the way, S

Re: Oracle World - Listers get together (proposed Tuesday Sep 9)

John, Oracle Awards felicitation is a luncheon on Wednesday. So Dinner is free that day. By the way, Sean Hull also expressed his interest to join the party. Thanks. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 03, 2

Re: ORA-01031: insufficient privileges -- from user oracle running

OK, I found the problem. It was due to Bug Number 923077 (see metalink Doc ID: Note:110901.1). Guang On Wed, 3 Sep 2003, Dave Hau wrote: > Make sure you have the sticky bit set for the oracle executable: > > chmod u+s $ORACLE_HOME/bin/oracle > > HTH, > Dave > > > > > [EMAIL PROTECTED] wrote: > >

Re: ORA-01031: insufficient privileges -- from user oracle running

Make sure you have the sticky bit set for the oracle executable: chmod u+s $ORACLE_HOME/bin/oracle HTH, Dave [EMAIL PROTECTED] wrote: Hi: I have an Oracle 8173 db running on Solaris 2.8 box (called rex) and today I found something that I am trying to understand. When I login to the Unix box

RE: Re: "Application DBA"

William, I did my OCP because of the same reason. My student was given preference by one recruiter who did OCP and my resume kept on a side because I was not OCP. My 10 years experience in 1998 was not counted agianst 1 year experience + OCP of my student. Yes, this happened in USA. Now a days

ORA-01031: insufficient privileges -- from user oracle running

Hi: I have an Oracle 8173 db running on Solaris 2.8 box (called rex) and today I found something that I am trying to understand. When I login to the Unix box as user "oracle" (which I used to install oracle software), I can manaully run svrmgrl, then connect as "internal", I can do "startup" and

Re: DBI in activestate perl

This may or may not work depending on which version of Perl that you install. If you installed Perl 5.8, you can't install DBD::Oracle from ActiveState. ActiveState seems to be in a bit of disarray in this regard.  There are numerous modules for which I have had to hack the PM so that I could in

RE: A basic replication question

Some issues to think about here: Do they really need all the data from production? Or are they just saying that without any justification... Do they know what questions they are going to ask? Or is this a fishing expedition. Are they going to understand ad-hoc development will continue to not oc

RE: Oracle on Win2000

Hammer, screwdriver and duct tape.   ;o) -Original Message-From: Bala Regupathy [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle on Win2000 First time I have got to maintain Oracle databases on W

Re: DBI in activestate perl

Hi Mladen Jared and Andy's book "Perl for Oracle DBA's" has an excellent chapter all about getting DBD and DBI and installing from source and binary. basically for ActiveState you can use the "ppm" utility run it from a DOS window and type c:\> ppm ppm> install DBI ppm> install DBD-Oracle8 Jare

RE: Urgent INFO needed.

> part of the problem is that very few people can write decent > specs - because in any creative process, and software > engineering is one, you only converge towards the result > through several iterations Good point. If folks speaking the same language aren't communicating well how much more

RE: Does the 9iR2 Installer delete patch files?

Oracle Untested Infuriator strikes again. -- Mladen Gogala Oracle DBA -Original Message- Jesse, Rich Sent: Wednesday, September 03, 2003 11:54 AM To: Multiple recipients of list ORACLE-L Hey all, During the instal of 9iRAC on RH9, the instructions say to install the 9.2.0.1 soft

RE: Oracle on Win2000

Depending on the size of your databases OEM and its Tuning Pack may work very well for you. -Original Message-From: Bala Regupathy [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle on Win2000 First

RE: Re: "Application DBA"

Back in India, the academic qualification is weighed more than anything else. Guys from institutes like Indian Institute of Technology IITs / Indian Institue Management (IIT/IM) (to quote an example) are treated as demi-godes and look at with awe (even if the guy doesn't know anything about Oracle

RE: Oracle survey

Humm, Looks like a fishing expedition to catch additional revenue. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, September 03, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Someone asked about EMS, Oracle posted this: http://infopoll

RE: Oracle Masters exam

And having sat through the beta of the masters exam, let me reiterate what Reichert said in the article. You really do have to have the hands on experience to pass it. I've been using Oracle for something like 15 years now, and training others in the DBA world for 11 or so of those 12 years, and

Re: test

fail Babette Turner-Underwood wrote: > test > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Babette Turner-Underwood > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list

Re: test

fail - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 03, 2003 3:04 PM > test > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Babette Turner-Underwood > INET: [EMAIL PROTECTED] > > Fat Ci

Re: Urgent INFO needed.

Freeman Robert - IL wrote: > > Actually, I've seen the reverse be true. I've seen the work offshore be so > poor that more folks are brought in locally to correct the problems, yet the > offshore remain too because of contractual issues. Happened to me on at > least two different occations. You ge

Re: Oracle Standby Database Backups.

Tom As long as your standby database is Physical Standby DB [ Not for Logical Standby Database where you also need to take the standby database backup] If the Database size is very big [ Not even in TB but few hundred GB ], If the Database is 24*7 If the Network connection is good [ We are not

RE: RAC 9i database - gx$ views ?

No, those are XXX$ views. -- Mladen Gogala Oracle DBA -Original Message- Browett, Darren Sent: Wednesday, September 03, 2003 4:04 PM To: Multiple recipients of list ORACLE-L I know there is the gv$ views which are the cluster wide equivialent of the v$ views, but is there any gx$ vie

Re: Oracle World - Listers get together (proposed Tuesday Sep 9)

John I am also going to join everybody after finishing mine Presentation which is also scheduled on Tuesday from 5:30-6:30pm Thanks Indy Johal Manager, Database Administration PR Newswire [EMAIL PROTECTED] http://www.prnewswire.com (201) 946-5687 [W] (201) 400-3960 [M] "We tell your story to

RE: Oracle on Win2000

The primary reason for problems with terminal server is that it is just that - a terminal. VNC and PcAnywhere actually take control of the console on a Windows machine. A default Oracle install requires console access for certain things, such as starting the database from a command line using sv

test

test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Oracle Standby Database Backups.

Tom,   You should perform backups from the Standby database, regular RMAN backups, no need to shutdown the database. Make sure you backup the archived log files from there too. Contrary to what the docs might _imply_, I use the word "imply" rather than "state", since the docs have been kind

Oracle World - Listers get together (proposed Tuesday Sep 9)

Hi all, We talked about this earlier and I wanted to get this mail out before everyone participating departs for OOW. I would propose a Lister's get-together on the evening of Tuesday Sep 9. Monday is the first day, Wed has the 'OracleWorld Appreciation day' in the evening and I am assuming there

Oracle Masters exam

Oracle Mag has something about the Oracle Masters program... http://otn.oracle.com/oramag/oracle/03-sep/o53news.html Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Oracle Enhancement Request System

Title: Oracle Enhancement Request System Raj,   The new enhancement system is inside Metalink now. When you want to open an ER, just open an iTAR, but in the drop down field named Type of TAR, choose "Enhancement Request".   Thanks.   Arup - Original Message - From: Jamadagni,

Re: Urgent INFO needed.

i dont think so. There is too much money in this. Odds are they will refine their processes 'slowly' improve. Over a period of years they will be better. Will it always be as good as the US? No, but it doesnt need to be. Its cheap. This doesnt mean every IT job will dissapear, but there is a contra

RE: Oracle on Win2000

Title: Message Be careful using Terminal Server.  If you are running batch jobs, the variables like ORACLE_SID and ORACLE_HOME don't always get picked up correctly by the batch job.  I have spent hours trying to debug a script run with Terminal Server, then switch to VNC and it works fine.  

RE: Re: "Application DBA"

Bill, Did you point out to them how *freekin wrong* they had been?!?!?!?! I would not have been able to resist the free shot. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 03, 2003 2:59 PM To: Multiple recipients of list ORACLE-L [EMAIL PR

RE: Future demand for DBAs

>> They estimate that by 2010, a quarter of the IT workforce will be over >> 55 years old. Heck, thats true now in the mainframe world I think. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/3/2003 8:54 AM The META Group has released a study that forecasts incr

RE: Oracle on Win2000

Windows Terminal services that comes with Windows (in Control Panel, Add/Remove Programs, Add/Remove Windows Components, then install Windows Terminal Client on admin PC). Bigger hassle to install and configure, but a LOT better performer than PCAnywhere or VNC (other two "usual suspects" f

RE: Urgent INFO needed.

Actually, I've seen the reverse be true. I've seen the work offshore be so poor that more folks are brought in locally to correct the problems, yet the offshore remain too because of contractual issues. Happened to me on at least two different occations. You get what you pay for. There are some gre

Re: Re: "Application DBA"

im going with the flow. doing a Masters(company is paying for it) and doing my OCP. Ill probably go cert happy over time... do java,solaris, etc... I know for a fact not having a computer science degree hurt me. I was told it. So if employers want something, Ill give it to them. As long as a compan

RE: RAC 9i database - gx$ views ?

> -Original Message- > From: Browett, Darren [mailto:[EMAIL PROTECTED] > > I know there is the gv$ views which are the cluster wide > equivialent of > the v$ views, > but is there any gx$ views where are equivalent to the x$ views ??? I don't think so, but does the source code for a RAC

RE: alter system reset

Ian, That is a very good point to remember. Sounds like the voice of experience. Thanks for the tip. Ron >>> [EMAIL PROTECTED] 09/03/03 03:34PM >>> Is the want to read the spfile just a curiosity? One should not rely on either the init.ora or the spfile to determine which parameters are set, but

RE: Urgent INFO needed.

That is call mondialisation...     Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Oracle survey

Someone asked about EMS, Oracle posted this: http://infopoll.net/live/surveys/s23243.htm Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: more questions

Check with http://download-west.oracle.com/docs/html/A96167_01/post-inst.htm#sthref548 Make sure to shutdown/start related stuff (viz OAS) that might have been installed too. Also, on some UNIX systems, NFS file system from Server A might have been mounted on Server B. If so, you need to shutdow

RE: Future demand for DBAs

by the time 2010 rolls around I will be on FULL social Security. The numbers were not given but the percentages were. 66% increase in the DBA's and 25% of the workforce will be over 55. Is that 25% of the 66% that are DBA's or is it 66% of the 25% that are DBA's? Rom mª¿ªm >>> [EMAIL PROTECTED]

RE: sqlload

John, I didn't say that a parameter file can't be used. The correct syntax is "control=", not "parfile=". And I agree about postings. I posted that message yesterday at around noon. FInally showed up today. But my email server is flaky. Tom Mercadante Oracle Certified Professional -Orig

rename data file on standby database

Hi Listers, I have standby database working fine (until now!). I have renamed one datafile on the primary database and I'm wondering if I have to do the same thing on the standby database to reflect the structure change. I have renamed the file yesterday and the standby database stil recovering

Re: decode

Imran Ashraf wrote: > > Hi, > > I have this query... > select decode(length(sn),8),substr(sn,-7),sn )from . > > However i want to change it so that if the length of sn is >= 8 then set sn > to last 7 characters. > > How can i implement this? > > Regards > -- decode(sign(length(sn) - 8

Re: ORA-16014

Saira Somani-Mendelin wrote: > > Received this alert minutes ago. There is no disk space shortage. > > What else can I check for? > > ORA-16014: log 2 sequence# 6362 not archived, no available destinations > ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' > ORA-00312: online l

RE: C program won't run in 9.0.2.3

Thanks, Peter! We have solved the problem now. Glad for the help, tho! Regards, Ruth > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Pete Finnigan > Sent: Monday, September 01, 2003 8:44 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: C

RE: Future demand for DBAs

Yeah, you and running guru Jim Fixx. Oh wait... BTW, high alpha-acid beers (from hops) contain xanthohumol. Xanthohumol is a type of flavinoid, which is acts as an antioxidant. Xanthohumol is also reported to be six times as strong an antioxidant as those found in citris fruits. Put down the B

RE: log buffer space wait

I have one question regarding these wait times, may be dump. In the following wait events what is the unit of measurement for Time, I believe its in seconds as per the documentation. If yes then here stats are collected for only 51.23 Minutes (Appx 3073 seconds), how come Oracle is showing

RE: Future demand for DBAs

Title: RE: Future demand for DBAs Again, Some issues: -Labor supplied from operations overseas -Issues of security -Issues of plain old communication and the role of a DBA requiring communication -Cost of moving overseas - certainly can't be afforded by all companies -"remote" administratio

RE: Urgent INFO needed.

All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message-From: Ora DBA [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 5:30 AMTo: Multiple recipients of list ORACLE-LSubject: Urgent INFO nee

RE: decode

decode(sign(8 - length(sn)), -1, substr(sn,-7), sn ) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Imran Ashraf Sent: Wednesday, September 03, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Hi, I have this query... select decode(length(sn),8),substr(sn,-7),sn )from

RE: Re: "Application DBA"

[EMAIL PROTECTED] scribbled on the wall in glitter crayon: > more and more employers are requiring OCPs and 'related degrees' such > as computer science or a masters degree. At least in the US they are. > How are things in other parts of the world? that they are and experience doesn't seem to c

RAC 9i database - gx$ views ?

I know there is the gv$ views which are the cluster wide equivialent of the v$ views, but is there any gx$ views where are equivalent to the x$ views ??? Thanks Darren -- Darr

RE: 64bit or 32 Bit

isainfo -v -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 1:14 PM To: Multiple recipients of list ORACLE-L How can I find if my SunOs is 64 or 32 bit? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET

Re: Future demand for DBAs

Well, it may at last be the golden age, with EXPERIENCED developers ! SF "Goulet, Dick" wrote: > > "They estimate that by 2010, a quarter of the IT workforce will be over 55 > years old." > > Well, I don't know about that, but one of those old fogies is right here!! > > Dick Goulet > Senior

RE: Onames and various connections scenarios

My names servers and clients are both 8.1.7. Could be a problem between versions. I'm not sure why support thinks a client is any different than a server. I have 3 names servers.  By logging on to the the oracle account on one of the servers, I use namesctl for admin work on all 3. In this cas

Re: alter system reset

>> One should not rely on either the init.ora or the spfile to determine which parameters are set, but should query the database True, but the original poster wanted to see why the ALTER SYSTEM RESET ... SCOPE=SPFILE failed and that would occur only if the entry is not found in the spfile, even if

RE: Some posts not showing up

Of course, the assumption that everyone is making is that their posts made it to fatcity.com in the first place. Given the recent assaults on mail servers by spam and viruses, that's not a good bet. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  09/03/2003 10:29 AM

RE: alter system reset

Is the want to read the spfile just a curiosity? One should not rely on either the init.ora or the spfile to determine which parameters are set, but should query the database. Now that we have both init.ora and an spfile someone is going to get caught. For instance a patch requirement requi

RE: log buffer space wait

These are cumalitive times for a few hundred processes. Jared <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  09/03/2003 10:34 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        R

RE: DBI in activestate perl

That won't help. ActiveState does not have a DBD::Oracle for Perl 5.8. Jared "Bob Metelsky" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  09/03/2003 08:09 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:  

Re: DBI in activestate perl

ftp://ftp.esoftmatic.com/outgoing/DBI/ "Mladen Gogala" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  09/03/2003 07:09 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        DBI in ac

RE: "Application DBA"

not here... we are running Oracle Financials somewhere but not related to me, I don't interact with that group. Patrice. -Original Message- Sent: Tuesday, September 02, 2003 5:29 PM To: Multiple recipients of list ORACLE-L i take 'applications dbas' when i see them advertised as jobs to

Re: Oracle on Win2000

pcanywhere...the remote control for the windoze servers. Murali. "Bala

RE: Listener Lockout Feature

Yeah -Original Message- Sent: Wednesday, September 03, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Whoops, disregard my last post - do you mean logging on to lsnrctl? -Original Message- Post, Ethan Sent: 03 September 2003 17:39 To: Multiple recipients of list ORACLE-L

RE: decode

Use greatest ... decode(greatest(sn,7),sn, substr(sn,-7),sn ) Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message- Imran

RE: A basic replication question

"ad-hoc queries" as in, we'll write something that will bring your database to its knees that kind of reporting, it's better to have a separate database --- "Thater, William" <[EMAIL PROTECTED]> wrote: > Weaver, Walt scribbled on the wall in glitter crayon: > > > Okay, we have a request for q

ORA-16014

Received this alert minutes ago. There is no disk space shortage. What else can I check for? ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log

Re: Listener Lockout Feature

Listener password failures do not lock the password, unfortunately; but it is possible to identify the failed logins. The listener log shows entries similar to the lines below 05-JUL-2003 21:14:39 * services * 1169 TNS-01169: The listener has not recognized the password Note the lines "TNS-01169:

Re: Read data from a file

How embarrasing! Someone else suggested a Perl solution. I did think of doing so, but then didn't do so for some reason. And of course, there are some scripts for that in "Perl for Oracle DBA's" .  :) Jared Mladen Gogala <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  09/03/2003 05:14 A

Re: DBI in activestate perl

Title: Message You can user perl package manager in activestate . from ppm command prompt issue "search dbi" or "search dbd" and then issue install dbd /dbi.   -ak   - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Wednesday,

RE: sqlload

Tom, I am afraid you are wrong there, a parameter file can be used to run a sqlloader script The syntax that Fawzia uses is correct although as per imp/exp it would be better to put all the parameters in the parfile file I spent years not knowing that and in frustration posted to the list and w

RE: Future demand for DBAs

"They estimate that by 2010, a quarter of the IT workforce will be over 55 years old." Well, I don't know about that, but one of those old fogies is right here!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, September 03, 2003 9:55 AM To: Multi

RE: sqlload

Congratulations Thomas! You win the eagle-eye prize of the day! Unfortunately it is a virtual prize. Funny what an obscure error sqlldr produced. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 02, 2003 1:05 PM To: Mul

RE: Future demand for DBAs

That is precisely why I don't smoke, don't drink, work out and watch what I eat. I want to be around when the demand goes up. In 2061, I'll be the 1st century old DBA in the good ol' US. Life is a bore, but it will be a long one. -- Mladen Gogala Oracle DBA -Original Message- DENNIS W

Does the 9iR2 Installer delete patch files?

Hey all, During the instal of 9iRAC on RH9, the instructions say to install the 9.2.0.1 software, then apply the 9.2.0.4 patch separately to the Installer, OCM, and finally to the RAC software itself. This is my second time through and both times there were files in the cpio-exploded patch that h

Re: Offshore threat

i find it difficult to believe. manufacturing jobs have been going over seas for years. Michael Jordan shoes are made in sweat shops in Asia. People are less likely to feel sorry for relatively high payed DBAs than they are for poorer manufacturers and what good did it do them? Their unions didn

Oracle Standby Database Backups.

All, We are in the beginning stages of designing a database with Oracle Standby capability.  The initial size of the database will be 600-800 Gig.  The proposed database will be run on a IBM P690 with a mirrored fail-over machine.  Two separate machines with separate disk.  We are considerin

RE: Oracle not available???

You don't get any other message than a 'Not Available' message? I have one application that did that a lot, but that was because it's SGA was sized way to small. And, thankfully, the people on the this list help me over that bump in the road. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Mana

Priority paging and Solaris 8

List, This is not entirely an Oracle question, more related to Solaris 8. We had some reports which run for 5 to 10 minutes and the unix process gone to sleep for an hour before it woke up and finished. The Oracle session showed that they are waiting for SQL message from client. During the same per

Re: RE: URGENT : sql*loader performance problem on partionned table

1. by 'filling' are you doing inserts also? I see a 'FOR UPDATE' statement which implies that you are doing updates from with in a cursor. 2. How many indexes do you have on this table? 3. Is anything else running at the same time? 4. Are you doing your DML from with in a cursor. This is very sl

Future demand for DBAs

The META Group has released a study that forecasts increased demand for DBAs in the future. They quote the U.S. Department of Labor's Bureau of Labor Statistics that forecasts a 66% increase in DBAs by 2010. The two factors that META feels will increase demand are: 1. Increased use of DW 2. Agi

RE: Permissions error

Well spotted Ron. I had not realised it was a VMS box Either way the principle is correct - set up the environment first John -Original Message- Sent: 03 September 2003 13:25 To: Multiple recipients of list ORACLE-L John, If the OS is Dec Alpha OpenVMS. In the user environment execute

Re: 64bit or 32 Bit

Use the isalist command to determine whether the machine is running the 32-bit or 64-bit operating system. If you are running the 64-bit operating system on an UltraSPARC machine, then isalist

RE: Oracle on Win2000

Bala,   I create shortcuts to the Oracle/dbs directory and bdump & Udump directories so that I can get there easily from my desktop.   I use telnet to log onto the machine to bring the database up and down.  I have NT admins for installing the software, so I don't need to use PCAnywhere fo

RE: Listener Lockout Feature

Ethan, You can do this with profiles. Here's an example by Connor McDonald, on Jonathan Lewis' site: http://www.jlcomp.demon.co.uk/faq/password_expiry.html HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F:

Offshore threat

All - Recently several shared their experiences with offshore development. This month's CIO magazine is devoted to issues surrounding offshore. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] 1. The Politics: Backlash As a growing number of IT jobs move overseas, some CI

Re: Re: "Application DBA"

more and more employers are requiring OCPs and 'related degrees' such as computer science or a masters degree. At least in the US they are. How are things in other parts of the world? > > From: "Nuno Souto" <[EMAIL PROTECTED]> > Date: 2003/09/03 Wed AM 07:19:25 EDT > To: Multiple recipients of

Urgent INFO needed.

Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!? Y

RE: A basic replication question

Well, that's what the users want. :>) But, due to the way our web hosting security is set up we can't do it. --Walt > -Original Message- > From: Thater, William [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 03, 2003 11:49 AM > To: Multiple recipients of list ORACLE-L > Subject

  1   2   >