Kirti
From version 7.x you can manually start multiple archive processes by
using the archieve log start to destnation and the added
processes wil die when there is no more redofiles to archive, but for
permanent having multiple processes the answer is 8.1.3 :-)
Deshpande, Kirti wrote:
I can
Hemant,
have you considerd HP Openview Omniback or related products form Veritas ??
cheers alex
Hemant K Chitale
Kirti
In v.7 the archiver is called ARCH. If 'archive log start to xxx'
starts another, what is it called?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 5 Feb 2003, Peter Gram wrote:
Kirti
From version 7.x you can manually start multiple archive processes by
using the
dbms_space may provide some of the info you want.
It won't tell you if the blocks are contiguous.
On Wednesday 05 February 2003 12:09, [EMAIL PROTECTED] wrote:
Does any have a script that shows actual # of used and free blocks in an
extent? I would like to determine the maximum # of
In Sybase's ASA there was an unload command which wrote to a text file
the SQL to recreate a table, along with all it's data which running the
SQL then imported. This allowed you to very easily dump a table, edit
it's structure and suck the data back in.
The closest thing I've found in Oracle is
Sorry Kirti, that was meant for Peter.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 6 Feb 2003, Jeremiah Wilton wrote:
Kirti
In v.7 the archiver is called ARCH. If 'archive log start to xxx'
starts another, what is it called?
--
Jeremiah Wilton
Title: RE: Partition and primary key
thank U Johnattan, which book are you talk about ? (isbn)
-Message d'origine-
De: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
Date: mercredi 5 février 2003 19:20
À: Multiple recipients of list ORACLE-L
Objet: Re: Partition and primary key
First
I think your list of reasons for using RMAN is incomplete.
The database backup window may need to be shrunk not
because the database is so big, but because there are a lot
of systems to backup, and they use a lot of time and tape.
RMAN backs up blocks, hot backup backs up files.
Also, finding
We also have named user multi server.
Oracle no longer sells those licenses.
Jared
On Wednesday 05 February 2003 20:48, Hemant K Chitale wrote:
When you buy a Named User license do you generally
buy a Named User Single Server license or a
Named User Multi Server license for the Oracle
use toad and export the table to a text file.
Also u could use the command line export/import utility.
But setting up oem is not that dificult.
Regards
Paulo
-Original Message-
Sent: quinta-feira, 6 de Fevereiro de 2003 9:34
To: Multiple recipients of list ORACLE-L
In Sybase's ASA there
Do you have a Sybase Open Client CD ? The odbc drivers are usually on there.
From my Sybase years I recall that the ODBC drivers were sourced from
Merant, now DataDirect technologies, might be worth looking there.
Personally I'd go for the bcp out/SQL*Loader in scenario.
Ade
-Original
Good day to
everyone
How do I find hardware info on Tru64
machine?
Available RAM, number of
CPUs...?
Thanks in advance,
Vladimir
Barac
Hello Listers,
Anyone used this tool? What was your experience like?
I am planning on using it to move about 20GB of data from a
Sybase 11.x database to Oracle 8i (Rel 3). This is a one time
activity. Flat file route (using Sybase 'bcp') is the
alternate solution. I would like see if we
Hi,
I am installing 9iAS( 9.0.2.0.1) Infrastructure on RedHat Linux 7.2.
During the installation, I get the Error in invoking target install of
makefile ins_oemagent.mk during linking
some lines from install/make.log file regarding this problem are as :
/usr/bin/make -f ins_oemagent.mk
Practical Oracle 8i
Addison Wesley; ISBN: 0201715848
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
UK___March 19th
Where is it well documented how to install multiple server versions,
8i and 9i, on the same unix server?
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
--
Please see the official ORACLE-L FAQ:
Pomin,
The log is usually located in the bdump location defined in the
initSID.ora file for your instance. The name will be something like
alert_SID.log.
Ron
[EMAIL PROTECTED] 02/05/03 09:38PM
hi all,
how I know where the log directory in oracle on redhat 7.3 ?
because I have a problem with my
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
I
agree with Richard. We used VMware in our development environment to
consolidate servers. I will say - unless you have a substantial amount of
hardware, there is going to the inevitable temptation to add that one extra VM
instance that's just one too many and performance suffers. But, if
Title: RE: Partition and primary key
Jared,
UNABLE TO EXTENT TEMP SEGMENT BY ...
-Message d'origine-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Date: mercredi 5 février 2003 21:50
À: Multiple recipients of list ORACLE-L
Objet: Re: Partition and primary key
What is the exact
Thanks for your response.
This morning I was informed that there is a Sybase Open Client CD that I can use (if
they could find it :) We do have a few Sybase products, so we have support, licenses
etc
We will be exploring both known avenues to get the data into Oracle database. Sybase
bcp
Kirti,
I am no Sybase expert, but I am staring at a Sybase to SQL Server migration,
and I installed the Sybase client tools on my machine and it gave me Sybase
Adaptive Server ODBC driver Release 3.50.00.10. Unfortunately I can't tell
you if my version is newer or yours is (50 is bigger than
I would be pleased to be informed - privately or via the list - about further
progress.
Oracle is a fine thing - not judging just giving away my sympathy - and hopefully you
can get more people on the Oracle path.
Fence the w..dogs off - sorry, couldn't resist to temptation.
Apologies for
Thanks for the heads-up. I did some looking around at the HP and Veritas
websites and came up with information for my managers.
Hemant
At 12:48 AM 06-02-03 -0800, you wrote:
Hemant,
have you considerd HP Openview Omniback or related products form Veritas ??
cheers alex
Title: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question
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,
Hi allThank you very much for all your
suggestions.I already experimented with copy command. But I failed Following
is the output..SQL copy from qest/qest@ndlp to
scott/tiger@test1 - append contacts_new using select * from
contacts;Array fetch/bind size is 15. (arraysize is 15)Will commit
No problem, Jeremiah.
I never could open Peter's e-mails due to some error stating 'Your Digital ID name can
not be found by the underlying security system'.
I saw what he posted in your message.
I was not aware of this Oracle7 'feature'... Sounds like an un-documented trick :)
Thanks,
-
Stephan,
Thanks for the reply. You were right, it had nothing to do with java 3D. I
just wish I knew what caused the problem, but with the lack of controls
around here it is tough to test. I noticed the error consistently appeared
in one of two spots, so I set up 4 scenarios to test (different
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Hi
Lisa
There
is no harm in using TIMED_STATISTICS=TRUE. I was using that on same
environment
thanks
Banarasi
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003
7:54
Babu - I don't know how large your tables are, but you should consider
committing during the copy. This is a parameter available to COPY.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, February 06, 2003 8:34 AM
To: Multiple
We're in the process of updating our DR plan and adding some more detail
G!. So I've been racking the auld grey matter and trying to identify a
list of useful hardcopy documents which would be really useful for DR. The
type of documents you store in a folder at home and bring along should the
Hi Henry
So, it's basically working now ? Or are you still trying to figure out the
why part ?
What does this setup.aix do ? Is it an executable that execs a java process
starting setup.jar ?
Or is it a script you could post here so I can take a look at it ?
Regarding the logs, usually, if a java
hi!
unload and load work like that
SQL exp myuser/@mydb file=C:\temp\mydump.dmp tables=(mytable)
SQL imp myuser/@mydb file=C:\temp\mydump.dmp tables=(mytable)
but i don't think you will have a good time editing the file.
if you want a | delimited file, you should use spool and
Vladimir - Quick answer, look in the message file that was created the last
time the system was booted up. There is also a command you can enter, I just
don't know what it is.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, February
psrinfo -v
vmstat -P
-Original Message-
How do I find hardware info on Tru64 machine?
Available RAM, number of CPUs...?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Kirti,
I've been searching on the IBM site for aiostat without much luck. What kind
of information does it give you? (if I'm going to convince my SA to call IBM
about this I'll need a very good argument. I'm still working on getting the
rights to use sar).
Henry
-Original Message-
Kirti
Lots of emails were sent yesterday, so in case if any kind soul had missed my request
(which didn't bear any result), I am posting this again. Please help if you can.
Thanks.
--
On Wed, 05 Feb 2003 09:59:29
waseem khan wrote:
Folks,
Is there a much better way of writing the following SQL
Posted 2 messages in Oracle 9i Lite Forum on Metalink. No responses yet.
I'm looking to this list for help on either of these issues. Thanks in
advance for your time. Please e-mail me privately
([EMAIL PROTECTED]) if this is not the proper forum for these
issues. Someone out there has to be using
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Lisa,
When I
first got to URI (8.1.7 4.3.3) timed_statistics were also set to false. I
changed them to true and have had no problems with it.
I have
also found that a lot of PeopleSoft setups aren't installed by experienced
Lisa,
I have had TIMED_STATISTICS set to true on 5 different 8.1.7
databases
(4 at 8.1.7.4 (64-bit), one at 8.1.7.0 (32-bit)) on 3 different servers
for some timewith no perceived problems.
These servers are either at AIX maintenance level 9 or 10.
I have struggled with swap space
Good morning everyone Win2k pro, oracle 8.17
Ive been investigating a simple monitor script which will email me if
the database is not available. I need this to be as simple as possible
(ideally a batch file)
Ive come across this on orafaq
http://www.orafaq.net/scripts/win/isdbup.txt
But dosnt
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Lisa,
We have several databases on AIX 4.3.3/8.1.7.x. All of them have
TIMED_STATISTICSset to TRUE.
Not problems havebeenencountered.
And about that tuning question: May bethose are all dedicated
connections, if so check what's
Reed,
Thanks.
I do not know what we may have. They (Sybase DBAs) are still looking for the CD for
me.
May be this newer release of the driver might work with OMWB...
- Kirti
-Original Message-
Sent: Thursday, February 06, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L
Look for sys_check.tar in the Compaq web.
It do a full test and audit of your system.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de DENNIS
WILLIAMS
Enviado el: jueves, 06 de febrero de 2003 15:59
Para: Multiple recipients of list ORACLE-L
Asunto: RE: hw
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Lisa,
We've been using
timed_statistics=true
at our site for over
a year, without any problems.
ed
- Original Message -
From:
Koivu, Lisa
To: Multiple recipients of list ORACLE-L
Sent: Thursday,
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
No problems here AIX 4.3.3 ML9 Oracle 8.1.7 64 bit.
Lisa,
Be aware that there are some issues with ML9 as I am finding out with
swap. We are planning on going to ML10 which should fix the problem as
well as using vmtune command
-I'm thinking some type of crib sheet with useful commands for that DR
-situation might be useful too.
This is one of my main ways that I survive, I really like cheat sheets. Also have a
$50 bill in the folder to go buy beer afterwards, you'll need it. ;o)
Dave
-Original Message-
Hi,
Is any one getting emails from OAUGNet OAUGNet-DBA
list servers (WWW.OAUG.COM)? For some reason, I am not
getting emails for the last one week.
Thanks
Bob
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
Quoting Bernardus Deddy Hoeydiono [EMAIL PROTECTED]:
I
suggest if
your O/S (Win2K) running well ,please don't apply the service if
not
necessary.
Perhaps this is the advice most people followed that's why that
Slammer worm took off.
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ:
This is ok for tape restores but not for disk restore...but thanks Rob.
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 4:36 PM
To: Multiple recipients of list ORACLE-L
Take a look at this link, it might be helpful...
Hello,
I'd like to update my server (Windows NT) to Windows 2000 Server.
I have a Oracle Database 9i in this machine.
Does anyone know any kind of problem in this operation (database
compatible) ?
Thank.
--
Breno A. K. Magnago mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares
Could you post execution plan, statistics?
Concatenated index on (TEST_DATE,TEST_VAL) might help, as well as increasing
the size of sort_area (if you find, that it uses disk for sorting).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list
I had to apply the SP1 for Oracle to run.
I built the PC from all off-the-shelf inexpensive parts ;)
I will now let my Win NT4.0 Server die on its own...
- Kirti
-Original Message-
Sent: Thursday, February 06, 2003 12:09 AM
To: Multiple recipients of list ORACLE-L
upto you if you're
hi aidan,
the following script will create .ctl and .dat files for each table of
OWNER.
These files can then be used with sqlldr.
HTH alex
#!/bin/ksh
###
#
# Desc: create CTL and DAT files for sqlldr usage
#
Sean - I could probably be of more help if you could describe something
about how you propose to recover the system. Do you have a recovery site?
Have assurance from your vendor that they could provide a comparable system
somewhere in a reasonable frame of time?
Another item to consider would
Dennis,
I tend to treat use of hints for exceptional cases only. With
collections CASTed as tables, I seem to have a generalized problem of
tables involved being scanned FULL (not using the available indexes)
and query response being slow. I can't seem to build a query with
collections and have
Kool!
Thanks...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 16:33
psrinfo -v
vmstat -P
-Original Message-
How do I find hardware info on Tru64 machine?
Available RAM, number of CPUs...?
--
Thanks Dennis...
Ya.. its all on disk and problably only a test with some tuning is going
to give me realistic picture. I am going to try it on NETAPPS new disaster
recovery SAN solution
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 3:50 PM
To: Multiple recipients
Vladimir,
You can also try these:
sizer -p (# of processors)
sizer -v (full version string i.e. 5.1A where uname -a says 5.1)
HTH
Stephen
[EMAIL PROTECTED] 02/06/03 08:33AM
psrinfo -v
vmstat -P
-Original Message-
How do I find hardware info on Tru64 machine?
Available RAM,
Bob,
I have a very simple script which checks to see if the database is up and
open. I've emailed you the script.
Orysia Husak
Database Management Services
PEROTSYSTEMS
(602) 307-2896
cell: (602) 300-9752
-Original Message-
Sent: Thursday, February 06, 2003 9:00 AM
To: Multiple
Hello guys,
I remember seeing a freeware software that can connect to a database
through ODBC on Windows, then reverse engineer the ER diagram from the
database.
Could someone on this list email me or us the link to get this
software? Thank you very much.
--
Lyndon Tiu
--
Please see the
Thanks Peter... Ya, I will be moving it between Netapp san and EMC disk.
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
You will only know what your system is capable of
It is very dependant on the disk arrays and no
Precisely. Our partner's SA also followed this idea and that's why
his Sun server crashed due to a NFS bug. Unfortunately, my database
was on it. :(
Richard
-Original Message-
Sent: Thursday, February 06, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
Quoting Bernardus Deddy
It worked once and I'm not going to try it again (why bother?). The
setup.aix is just an executable that execs a java process using setup.jar.
I'm not really happy and this system is pretty unstable, but so it goes. I'm
still struggling with igoring the problems I see or I wouldn't get anything
Henry,
I got aiostat from IBM Support when I bugged them about how to monitor AIO. Not sure
if aiostat is readily available as a download from their Web site or in/for the newer
versions of AIX.
It works similar to vmstat and iostat, showing number of pending AIO requests at the
time of
Title: RE: Looking for simple monitor script dbup.bat
Hi Bob,
Check out Steve Adams' script (www.ixora.com.au). It's written in ksh and will need a little modification to send emails, but it's bulletproof. Also others on the list have mentioned Cygwin (?) the Windows-ksh to allow this to
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
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]]Sent: Thursday, February 06, 2003
Hi Jared,
Responses in line.
Jared Still wrote:
I think your list of reasons for using RMAN is incomplete.
The database backup window may need to be shrunk not
because the database is so big, but because there are a lot
of systems to backup, and they use a lot of time and tape.
I have been told that I will finally get a budget for some training and want to get
some in Oracle. I see that Learning Tree has some classes. Do you guys have any
recommendations to links to point me to other sources for classes. Everything I have
learned has been from RTFM and books from
Saira,
I've forwarded your message to the CTO of Oracle Lite, my old friend
Jacob Christfort, whom I know from our days at the National Hospital
Dormitory in Copenhagen, where we had lots of fun, and where many nurses
lived. Those were the days, but sadly we both ended up working with IT.
If
Hrm, how about UTF8?
-Original Message-
Sent: Wednesday, February 05, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L
Dear List,
Life was pretty easy here before they came up with
this euro symbol :-( We had WE8ISO8859P1 (the default
I bevieve) as a char set on all Unix and MS
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Hi
Henry,
OS
isn't paging when I've looked. But with the memory this low it seems to me
paging could happen pretty darn quick.
There
are a couple of logins that can run reports. These aren't big databases
but as you know a
Could you post it to the list?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 12:14 PM
Bob,
I have a very simple script which checks to see if the database is up and
open.
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,
is don't do it. Rebuild the box. There are remnants of NT left if you do
an
upgrade, and you don't really want that, do you?
Jared
Breno A.
The Oracle Software Investment Guide should be downloaded about every
two weeks according to my friends in Oracle Legal, because things change
rather often. The SIG is about 70-80 pages, by the way.
There are cpu licenses and Named User Plus (NUP) liceneses available
now. That's it.
Mogens
Well, you're getting close.
The full message looks like this:
ORA-01652, unable to extend temp segment by %s in tablespace %s
The interesting part of the message appears where the '%s' are.
Jared
NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/06/2003 05:43
When Klaus Andersen (the guy who hired me into Oracle Denmark in 1990,
and now is Managing Director of Microsoft Denmark) was head of Oracle
Education world-wide he put into the standard license terms that you
cannot use Oracle software for training of 3rd parties.
Klaus is a very smart guy.
Title: RE: windows application to show sql being executed by a client
If anything it will be incorporated into an existing Quest Product.
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Pretty cool...
A future Quest product ??? ;)
Just wondering... :)
Title: windows application to show sql being executed by a client program
Looks
pretty nice. Real similar in concept to TOAD's SQL Monitor, but adds the
option of seeing the values of bind variables, formatting the SQL, watching
processes, etc.
Worth
the download, IMHO.
Dave
Hey Dave,
In Madison, Greenbrier Russell -- I believe they were the first Oracle
Certifed Partner -- has many Oracle classes. I've been happy with the
Milwaukee-area classes.
http://www.gr.com/what/classhtml/coursesbylocation_madison.asp
HTH! GL! :)
Rich
Rich Jesse
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,
is
Consider TUSC for your training needs. We offer all sorts of Oracle classes.
www.tusc.com.
Robert G. Freeman
Technical Management Consultant
TUSC - www.tusc.com
Author of several books you can buy on Amazon.com!
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/6/2003
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
Title: RE: windows application to show sql being executed by a client pr
Well I guess the cat is out of the bag! I didn't think that TOAD with SQL Monitor had been released yet. Yes, an (earlier?) version of his app was chosen to be incorporated in TOAD.
-Original Message-
From:
Hi all -
We are thinking about using Mercury WinRunner to load test our 11 to 11i
upgrade and wondering if anybody has experience using this before. How steep
the learning curve, how reliable and how 'real' the load is comparing to the
production load. Any other feedbacks are also welcome.
Thanks
Sorry
to contact u of list.
Do
happen to know how to install rpm packages in aix?
I
downloaded c 5.1 from ibm (in rpm) wich is necessary to install 9ir2 but i don't
know how to install rpm in aix 4.3.3. Could u help me???
Thanks
in advance
Paulo
-Original Message-From: Scott
By the way, Lisa. AIX 4.3.3 is being desupported.
We are testing 9i on AIX5.2 as I write this. I could not get the powers
that be to move away from 8.0.x and now we are jumping right to 9i. I did
install 8.1.7 and use OEM2.2, but that won't support a 9i database. I will
install the new OEM
Yet another choice:
www.thinkspark.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
I am not currently working in an AIX environment; but when I did (and it was
4.3 with 8.1.6/7) we always set timed_statistics=true with no adverse
effects.
-Original Message-
Sent: Thursday, February 06, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Good morning everyone -
Kirti,
Just took another look at our kproc processes. What is weird is that we have
26 of them, 9 are owned by oracle the rest are root (huh?). All of them
started at system boot. Also, almost all of the CPU is used by the top four
(current %CPU and total over the life of the process) with the
And the teachers at the Madison GR training center are frequently either
Oracle contractors or ex-oracle employees.
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein
-Original Message-
Sent: Thursday, February 06,
I agree with Jared and Scott that's the best way to do it.
-Original Message-
Scott
Sent: Thursday, February 06, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
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
Title: RE: Looking for simple monitor script dbup.bat
If I understand you correctly, the problem is that you don't get an ERRORLEVEL set when you are unable to connect to a database. Have you tried sqlplus/nolog? (Ignore the french text, I have Oracle installed in french on my PC)
D:\sqlplus
Does the max_enabled_roles initialization parameter have to be set for
an instance?
If it is not set is the limit the default of 20 or do you have
unlimited enabled roles. I have looked through the docs and I only find
the upper limit for max_enabled_roles is 148.
Thanks
Don Bricker
Database
http://news.lycos.com/news/photo.asp?from=mylycosphotosection=BreakingPhoto
sphotoId=amdf319368
Or for the full story
:http://news.lycos.com/news/story.asp?section=Breakingpitem=ODD%2DLIFE%2DJA
PAN%2DDOG%2DDCrev=20030206pub_tag=REUTGfrom=photodetail
--
Please see the official ORACLE-L FAQ:
Bob,
They switched to a different list server provider and there were numerous problems.
They may have unsubscribed you. Here's a quick list of email addresses for the
OAUGNet-DBA list. I assume the OAUGNet list email addresses would be similar.
To unsubscribe, E-mail to: [EMAIL PROTECTED]
OK. And about the Oracle compatible.
Only create a new windows 2000 service is necessary, any upgrade of
database is require. Is it Correct ?
--
Breno A. K. Magnagomailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares
Thursday, February 06, 2003, 4:39:17 PM, you
I have a developer that wrote a VB program using ADO, connecting to Oracle
8.1.6 on a Compaq Tru64 server. One program of his runs for hours each
night, and sometimes receives an ORA-03113 end-of-file on communication
channel. Not consistently, just sporadically, and at varying amounts of
time. I
Ray - Since I don't see where anyone replied, I think the problem is your
stress on well documented. Might have scared people off. The basic
procedure is to use separate ORACLE_HOME for each version. Make sure each
version doesn't share anything you don't want them to. Most Unix systems
require
OMG
are you KIDDING
Do you
know when?? I just found out (as you may remember from my "Just Shoot Me"
post) that IBM's version of desupport is "don't even ask us".
Thank
you so much Ruth for pointing this out.
Have a
great day.
Lisa
-Original Message-From: Ruth Gramolini
1 - 100 of 139 matches
Mail list logo