Rajesh,
Instead of running the .profile for the oracle user, you might try
invoking the oracle user. I don't think you're seeing the
$ORACLE_HOME. Try something like:
su - oracle "-c sqlplus -s"<
> Hi All,
>
> I am facing some problem while running sqlplus
> scripts from cron
I've used the DBA exam guide and found it to be very helpful but if you're
going for any of the certifications, you should also read the other Oracle
Press Books dealing with the specific area such as Tuning. I also read the
Exam Cram books and bought and used the practice test for all the unit
Larry,
Sorry I can't help you there. We never put enough load on it to
tell what it would handle.
Other than the Sun->Intel switch, how are things going? Well
I hope.
Me, I'm trying to break into contracting. It appears to be bad timing
for it, but I was helped along a little when my positi
Hi All,
I am facing some problem while running sqlplus
scripts from crontab. Env is Tru64 Unix 4.0f and
Oracle 7.2.3.
Through crontab all system commands run fine,
but when I try to invoke sqlplus, it gives following
error:
/oracle/test1.sh: -o: bad option(s)
A
this recipe was originally for a "traditional" layer cake with cream cheese
frosting. Since I hate cream cheese frosting, I changed the recipe a bit...
makes a much better addition to a Sunday brunch, IMHO
Enjoy folks!
CARROT CAKE (makes 1 loaf & 6 muffins)
Ingredient
Hi all,
What are the steps required to perform full imp from full export dump file.
Because there are FK constraints
currently my steps are:
1. perform full exp with system/manager
in other machine
2. disable all constraints
3. truncate all tables
4. perform full imp with system/manager
5. ena
well.. "ever" might be pushing it a bit... but yes, it was funny :)
>From: "Paul Baumgartel" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: stupid DBA
>Date: Fri, 13 Apr 2001 18:50:55 -0800
>
>Eric's post was the f
Mladen,
Thanks very much for responding to this. I was
leafing thru' a tuning book and it suggest checking
the types of metrics az mentioned by you. I suspect
the db parameters needs some tuning.
Regards,
Ed
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> Ed, try looking in the v$session_wa
LOL..
That guy deserves the 'Darwin' award. Flying like that under the a wing of
bigger plane
As for the original poster... the signature tells the real story (if it is
really real,that is).
> -Original Message-
> From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 13
Eric's post was the funniest thing I have ever read on this list.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, April 13, 2001 10:05 PM
>
> and the original post was not??
>
>
>
> >From: PK J <[EMAIL PROTECTED]>
> >Reply-To: [EMAI
tylenol, cough syrup & sudafed working here
the thought police suggested something stronger, but am still
resisting assimilation
quit nicotine 3 months ago, current side effects minimal, with
possible exception of premature permanent onset of curmudgeonly
behavior
please advise
On 13 Apr 2
One more certification required for that kind of job..
IBM Certified Professional Nurse..
--- Robert Chen <[EMAIL PROTECTED]> wrote:
> Stupid "BUSH" time! Stupid US people select Bush as
> president. Stupid DBAs.
> Stupid job mkt.
> Stupid software Engineer! I am considering to change
> to be a
http://www.darwinawards.com
excerpt:
Literary Reference
The existence of Darwin Awards shows that we apparently
do need common sense warnings like,
"Caution: Batman cape does not enable wearer to fly."
([from:] Greg Hanes [mailto:[EMAIL PROTECTED]])
On 13 Apr 2001, a
and the original post was not??
>From: PK J <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: stupid DBA
>Date: Fri, 13 Apr 2001 16:55:19 -0800
>
>This was mean.
>--- "Eric D. Pierce" <[EMAIL PROTECTED]> wrote:
> > Ever
Eric,
Are you feeling alright? This is possibly the shortest, most succinct answer
I have ever seen you post! :)
Rachel
>From: "Eric D. Pierce" Reply-To: [EMAIL PROTECTED] To: Multiple
>recipients of list ORACLE-L Subject: RE: How to get rid off file
>permanently? Date: Fri, 13 Apr 2001 1
Oh, I thought this was a personal message to me. At least that is how
our applications people refer to the DBAs whenever THEY screw up.
Denise Gwinn
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services
This was mean.
--- "Eric D. Pierce" <[EMAIL PROTECTED]> wrote:
> Ever considered trying out for fighter pilot in the
> chinese air force? I think they have an opening.
>
>
> On 13 Apr 2001, at 14:45, Robert Chen wrote:
>
> Date sent:Fri, 13 Apr 2001 14:45:30 -0800
> To:
On 13 Apr 2001, at 17:12, [EMAIL PROTECTED] wrote:
To: <[EMAIL PROTECTED]>
Copies to: <[EMAIL PROTECTED]>
Date sent: Fri, 13 Apr 2001 17:12:54 -0500
> And where did you get the info on 8.1.7 and Forms Server not being able to
> be on the same NT / W
Eric,
Thanks for the feedback, and yes, the Intel boxes would be running NT. The
DB will still be on the HP V2500.
And where did you get the info on 8.1.7 and Forms Server not being able to
be on the same NT / W2K machine? I am about to try to install 9iAS on my W2K
box at home. I already have 8
On Fri, 13 Apr 2001, Gregory Conron wrote:
>unless a user is running a query or transaction against the data in
> the partition (the query/transaction will fail).
d'oh! must correct myself - if a user is running a transaction against the
data, the alter table drop will fail as it will not be able
Ever considered trying out for fighter pilot in the
chinese air force? I think they have an opening.
On 13 Apr 2001, at 14:45, Robert Chen wrote:
Date sent: Fri, 13 Apr 2001 14:45:30 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> ...I am c
On Fri, 13 Apr 2001, Robert Chen wrote:
> Stupid "BUSH" time! Stupid US people select Bush as president. Stupid DBAs.
> Stupid job mkt.
> Stupid software Engineer! I am considering to change to be a nurse associate
> or something like that.
Tomorrow you may want to get up on the other side of the
Jared,
Even though it was easier to support (which can add up to cost savings) was
the performance a problem for you where on the Intel boxes?
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 12, 2001
Stupid "BUSH" time! Stupid US people select Bush as president. Stupid DBAs.
Stupid job mkt.
Stupid software Engineer! I am considering to change to be a nurse associate
or something like that.
Best wishes!
Yours sincerely, Robert Chen
___
Cisco Certified Network As
On Fri, 13 Apr 2001, [EMAIL PROTECTED] wrote:
> I've looked through the on-line documentation on dropping partitions
> but I have not seen the following question specifically addressed:
>
> How does dropping a date-range partition affect the rest of the
> table/partitions?
New data will be in
Hi Kevin,
The Database Cache Assistant works fine till it
reaches
the last part where it tries to export some User
data..
The error which it gives is "Unable to export User
privileges" and then it fails and moves onto
installing
other components, I tried to install Oracle DB 8.1.7
and Oracle 9iA
Major Houston company needs several Sr. Level Oracle Financials DBAs to join
its' I.T. staff.
These DBAs will work on the support side. They will support developers and
end-users.
DBA will support both internal and external clients.
Client has gone from 107. To 11.
Requirements:
-Must have 4 yr
I am trying to setup rman.The catalog database(cat) and target database(tar)
are running on Oracle 8.1.5.
I am following the Note from Metalink No.106432.1 and 109223.1.I am
following all the steps as
given in the note but I am facing errors.
When REgistering the Target database I did the followi
delicious. :)
On 13 Apr 2001, at 13:40, Gogala, Mladen scribbled with alacrity and cogency:
> ... As a DBA and a gentleman I can not but take
> pride
> in helping people to stop making mistakes.
next:
... John Leo on CSPAN. As you may recall, he is the columnist from
"U.S. News
Ed, try looking in the v$session_wait to see what is the session waiting
for.
That should give you a hint on what might be going on. If you cannot find
anything in the database, check OS, swapping, paging, CPU, queues on the
disk
drives etc
-Original Message-
Sent: Friday, April 13,
Well, if a total newbie is given root access to production machines then my
suggestion will actually help them streamline their operating procedures
and find flaws in their administration principles. Actually, you might say
that if there is a company which has a person of the right mindset to foll
Hi Kirti,
Unfortunately I am running this in char-mode. However,
I did managed to download a few pdf docs from the HP
site(the docs did mentioned gpm).
Anyway, thanks very much for your feedback.
Best regards,
Ed
--- "Deshpande, Kirti" <[EMAIL PROTECTED]>
wrote:
> Hi Ed,
> If possible run Glan
Hi!
can u pls tell me the errros u encountered
in opening 64-bit database using 32-bit Oracle
or vice versa?
Thanx
- Original Message --
[EMAIL PROTECTED] wrote:
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
From:[EMAIL PROTECTED]
Date:Fri, 13 Apr 2001
Hi Ed,
If possible run Glance in motif mode (gpm under X-Windows). It has better
on-line Help available.
HTH..
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -Original Message-
> From: Ed [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 13, 2001 12:40 P
I've looked through the on-line documentation on dropping partitions
but I have not seen the following question specifically addressed:
How does dropping a date-range partition affect the rest of the
table/partitions? I read that if I drop a partition with a global
partitioned index that the e
On 13 Apr 2001, at 10:06, Ed wrote:
> the re-start seems to clear the buffer or any "cow
> webs" from previous session.
As all old timer Oracle users know, you really want to get
rid of all those buffer clogging "cow webs" ASAP, otherwise
you might get "mad dot com" disease. :)
Go on down to y
Jonathan,
Nice review.
Looks like a fantastic book! It would have been great to
have it when I first started Oracle (or will be great to get
it if we start having more complex data loading requirements
than is currently the case, e.g. graphics files).
About 5 or 6 years ago I called Oracle tec
Plus, they can practice recover (or determine if their backup procedures
are adequate).
-Original Message-
Sent: Friday, April 13, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L
If someone has been given access to root and doesn't know what they are
doing, then the sysadmins des
Not every company is big enough to have an IT staff. Some I've worked at, you are the
developer, sysadmin, network/firewall admin, and dba. However, I would draw the line
on doing bathrooms :-)
>>> [EMAIL PROTECTED] 04/13/01 01:46PM >>>
If someone has been given access to root and doesn't kno
Ed:
Thanks for your compliments. I'm glad you enjoyed it. It was a fun article to write
because I had experienced such great results after spending very little time tuning
the jobs. Tuning is always trying to find the easiest way to get the best results and
this was a a great example the a
Thanks for all the feedback. Hope everyone that uses SQL*Loader benefits from it.
Stephen
>>> [EMAIL PROTECTED] 04/13 10:31 AM >>>
On Fri, 13 Apr 2001, Jonathan Gennick wrote:
> Stephen Andert, a member of this list, has a
> SQL*Loader-related article running on the O'Reilly &
> Associates web
I am in the initial test phase of migrating our Oracle 8.0.5.2.1 database and
Oracle Applications 11.0.2 to Oracle 8.1.6 and Applications 11.5.3.
We run this on Sun Sparc Solaris 2.6
In reading the Upgrading Oracle Applications Release 11.5.3 documention, I read
on page 1-14 that Applications 1
I can't comment on the cross-platform dependencies,
but I've deployed wrapped stuff with no problems in
the past...Of course, don't lose your source!
hth
connor
--- John Dunn <[EMAIL PROTECTED]> wrote: > We are
considering using wrappers to hide our PL/SQL
> code from customers.
>
> Are there
Greetings all,
This is more of a tuning question. We have a pl/sql
procedure doing inserts and updates to a very large
table. This procedure process different groups of
same types of data sequentially. The difference
between these groups is with the volume of raw data.
When the procedure get
If someone has been given access to root and doesn't know what they are
doing, then the sysadmins deserve whatever happens to their systems...
My two cents
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gene Sais
> Sent: Friday, April 13, 2001 9:10
Jonathan,
Congratulations on finishing the book. After reading Stephen's article, I
can't wait to pick up a copy!!
Stephen,
Great job in reviewing the book! It was great to learn how you were able to
apply the knowledge acquired from the book into real-life experiences. It's
amazing how many p
hi ppl
does anybody know bout database migration from MS SQL 7.0 to Oracle 8i.
thanks and regards
- NIHAR SANGHVI
NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063
Phone: 8723003 extn: 144
www.netmagicsolutions.com
--
Pleas
On Fri, 13 Apr 2001, Jonathan Gennick wrote:
> Stephen Andert, a member of this list, has a
> SQL*Loader-related article running on the O'Reilly &
> Associates web site. You can get to it from the O'Reilly
> home page (halfway down right-hand column), or you can get
> to it directly at the followi
Greetings all,
We have a DB running on HP-UX11. I am not the unix
admin but I can run Glance on the OS but clueless on
the metrics being displayed. I am hoping someone who
has access to any documentation on the HP Glanceplus
utility can shar that with me. The "man" provides
limited description
Cherie,
And how 'truncate a partition' will help you with recoverability?
Truncating partition is still DDL - not DML.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday,
And what about developer 6i?
Does the order of installation matter? i.e.,
1- Oracle 8i database
2- Oracle 9iAS
3- Developer 6i
TIA
Aleem
-Original Message-
Sent: Thursday, April 12, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Oracle9ias
Hi,
Yes u
Stephane,
Thanks for your reply. We are considering truncating the
partitions first. Our main issue is recoverability. Not so
much if we can't recover a partition that we want to get rid
of but rather if we accidentally truncate a partition that we
want to keep. Just trying to cover all ou
Jun,
Thanks for your reply. We are considering truncating the
partitions first. Our main issue is recoverability. Not so
much if we can't recover a partition that we want to get rid
of but rather if we accidentally truncate a partition that we
want to keep. Just trying to cover all our bas
Denny,
Thanks for the tip, I'll give it a try. It sounds like it will work.
Of course, there's a list on Metalink of places where it doesn't
work or where it causes errors. But it sounds just right - thanks.
Yosi
-Original Message-
Sent: Thursday, April 12, 2001 3:48 PM
To: Multiple rec
On Fri, 13 Apr 2001, Feng, Jun wrote:
> We have that kind application running on the production and didn't have any
> problem since it was deployed last Oct.. The application will truncate the
> one of the table partitions which contains 99% of the data (about 7M
> records) before reload the data
Stephen Andert, a member of this list, has a
SQL*Loader-related article running on the O'Reilly &
Associates web site. You can get to it from the O'Reilly
home page (halfway down right-hand column), or you can get
to it directly at the following URL:
http://oracle.oreilly.com/news/oraclesqlload_0
But, it can be modified. It was sent as a format, not as the final word.
Terry
"Libal, Ivo" wrote:
> But it is normal listener - not external procedure listener.
> There can be a problem with tnsnames.ora entry for EXTPROC_CONNECTION_DATA.
> regards
> Ivo Libal
>
> -Original Message-
>
We have that kind application running on the production and didn't have any
problem since it was deployed last Oct.. The application will truncate the
one of the table partitions which contains 99% of the data (about 7M
records) before reload the data every two weeks. For you situation, you can
tr
Removing data from a partition is not a lot of work :
alter table X truncate partition Y ;
--- [EMAIL PROTECTED] a écrit : >
> Anyone have any problems dropping partitions that
> hold data?
>
> We are debating the risk involved in dropping
> populated partitions
> as opposed to purging the da
Anybody knows how Oracle insure recoverability of such bitmaps. My
understanding is that any change should be written into redo log file.
Question is how much info is written etc.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL
HI dba man,
I made my own security system by making database users and giving them
synonyms to access the owners objects,also I created public synonyms for the
objects .Then I created roles and assigned them to menu items in the main menu
and sub-menus.After creating the user (in a form I develop
But it is normal listener - not external procedure listener.
There can be a problem with tnsnames.ora entry for EXTPROC_CONNECTION_DATA.
regards
Ivo Libal
-Original Message-
Sent: Friday, April 13, 2001 03:41 PM
To: Multiple recipients of list ORACLE-L
Correcti
The listener.ora I sent
Anyone have any problems dropping partitions that hold data?
We are debating the risk involved in dropping populated partitions
as opposed to purging the data out of them first and then dropping
them (a lot of work).
Theoretically, this should work o.k. but has anybody actually had
problems doi
Mark,
I had OTS recommend setting this back on version 6.0.36 due to a bug. But
since I've removed it.
Dick Goulet
Reply Separator
Author: "Mark Leith" <[EMAIL PROTECTED]>
Date: 4/12/2001 11:55 PM
Nope:)
I can't for the life of me think why s
I've sent that mail days ago with no feedback, Oracle
Support hasn't been able help, anybody ?
On Oracle 816/Solaris 5.7, I'm trying to refresh fast
a mview without success: ORA-12032.
It's a mview with single table aggregate, I've
followed all the restrictions in the doc (I'm having
a mview log
2 listeners cannot listen on the same port.
Alex Hillman
-Original Message-
Sent: Friday, April 13, 2001 8:16 AM
To: Multiple recipients of list ORACLE-L
Correcti
mysid_lis =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= mysid)
)
(ADDRESS=
(PROTOCOL= TCP)
(Ho
Connie,
1st, can you have a 32 and 64 bit database on the same machine: Yes we've
got two machines working that way with no problems.
2nd, Can you migrate from 32 to 64 bit: Yes via exp/imp. I've tried just
mounting the database files with the 64 bit executables & the errors are not
pre
Hi,
I want to use dynamic host array's in pro*c i.e. assigning array size in
runtime by using variabl to reduse memory allocation.
I am useing pro*c 1.6
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Abhijit Bhivapure
INET: [EMAIL PROTECTED]
Fat City Netw
The listener.ora I sent is two seperate listeners. Just substitute the SID
names for SID1 and SID2 and issue the start command.
lsnrctl start listener_sid1
lsnrctl start listener_sid2
Terry
John Dunn wrote:
> Thanks...but how to create 2 seperate external listeners, one for each SID?
>
You shouldn't joke like that :). There are some real new newbies on this list who
will follow exactly what you say.
Gene
>>> [EMAIL PROTECTED] 04/12/01 06:10PM >>>
Another good way of reclaiming disk space on Unix boxes is to execute "rm
-rf /"
as "root". That is an excellent way for saving so
Now won't you feel bad if someone actually follows your tongue-in-cheek suggestion?
>>> [EMAIL PROTECTED] 04/12/01 06:10PM >>>
Another good way of reclaiming disk space on Unix boxes is to execute "rm
-rf /"
as "root". That is an excellent way for saving some money for the disk
drives
mysid_lis =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= mysid)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= myhost.mynet.com)
(Port= 1525)
)
)
STARTUP_WAIT_TIME_mysid_Lis = 0
CONNECT_TIMEOUT_mysid_Lis = 10
TRACE_LEVEL_mysid_Lis = OFF
SID_LIST_mysid_Lis =
(SID_LIST =
Thanks...but how to create 2 seperate external listeners, one for each SID?
John
> -Original Message-
> From: Pampati, Kiran [SMTP:[EMAIL PROTECTED]]
> Sent: 12 April 2001 23:11
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Sseperate external procedure listeneers for
I would like to ask somebody who is experienced with PRO*C on Alpha
OpenVMS.
I have created process, which is connected to the database and constantly
going.
But his PGA is constantly increasing. On Metalink I have found advice to use
kompile parameter (in file pcscfg.cfg)
RELEASE_CURSOR=YES
Do not increase the sort_area_size at the database
level but at the session level. When I have big batch
jobs running alone at night I increased the
hash_area_size and the sort_area_size of the session
running the job.
--- CC Harvest <[EMAIL PROTECTED]> a écrit : >
Kirti:
>The server is solely
Nope:)
I can't for the life of me think why somebody would set this to none, as it
could seriously damage your data integrity right? Sorry, I forgot to mention
all of this in my original post.. Thanks Jared.
Mark
-Original Message-
Sent: Friday, April 13, 2001 02:30
To: Multiple recipie
76 matches
Mail list logo
