Inline comments...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 11:23 AM
All this ranting is nice but consider the following:
1) You do not install oracle on a server so much.
In fact, in our shop this is done by the
yes i cross checked , the 2 sqlnet.ora files are exactly the same.
i am using 8.1.7.2.0 for all 3 db's.
-Original Message-
Bruce (CALBBAY)
Sent: Thursday, July 11, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Check the sqlnet.ora on both boxes - are they the same?
There was a
CREATE PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING
connect_string
Regards,
Amjad.
www.medicomsoft.com
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Anand Kumar N - SystemsSent: Thursday, July 11, 2002 9:33
AMTo: Multiple recipients of list
There have been times when I would have paid extra for (1) a character-mode
installer and/or (2) a reliable and consistent way to create a listing of
EXACTLY what was installed (e.g. the long-defunct instver).
I think I've installed Oracle with just about every mechanism they've had
since Oracle
Oracle 7.3.4 Version
-Original Message-
Sent: Wednesday, July 10, 2002 8:49 PM
To: VIVEK_SHARMA; LazyDBA.com Discussion
SOLVED
What version was this on? I thought this went away in
version 8 of Oracle...
Mike
--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
process.dat regid.dat Files
Anyone else get this ???
Yet another mail I did not ask for ...G
-Original Message-
Sent: 10 July 2002 21:51
To: [EMAIL PROTECTED]
Dear Lee,
I am contacting you to provide you with information about a unique systems
management tool which is being received with great interest
Amen to that Don.
I (or the other DBA) do all of our own Oracle installs. No-one else gets
anywhere near it.
Lee
-Original Message-
Sent: 11 July 2002 07:53
To: Multiple recipients of list ORACLE-L
Inline comments...
- Original Message -
To: Multiple recipients of list
Oh yes.
-Original Message-
Sent: 11 July 2002 09:53
To: Multiple recipients of list ORACLE-L
Anyone else get this ???
Yet another mail I did not ask for ...G
This
Hi,
as you were discussing that the message was sent to recent posters I guess
you are right.
I am twice assigned to the list, once at home and once with my office mail
account.
As I did recent postings to the list from my office account I only received
the Ellison Comment mail at my office mail
Guys,
Querying my v$session_wait shows 10 rows each DB FILE SEQUENTIAL
READ and DB FILE SCATTERED READ.
manuals explain it all b'coz of I/O.
there are 33 tables and 110 indexes in the same USERS tablespace
with only one datafile USERS01.DAT of size 12GB.
it's physically laid out in
Hi !
How to avoid enqueue locks
?
regards...
Shishir Kumar MishraAgni Software (P)
Ltd.www.agnisoft.com--Vidya
Dadaati Viniyam--
Hi Gurus!
How does the unindexed foreign key
affect the performance ?
regards
Shishir Kumar MishraAgni Software (P)
Ltd.www.agnisoft.com--Vidya
Dadaati Viniyam--
We are Considering Upgrading from 8.1.7.2 to 8.1.7.4 on AIX 4.3.3
Any Do's,Cares to be Taken ?
Any Advice / Serious Bugs known on this Patch Version ?
Thanks
-Original Message-
Sent: Wednesday, July 10, 2002 8:49 PM
To: LazyDBA.com Discussion
After migration from Oracle ver 7.3.4 to
Whenever You Modify the Parent Table rows the Child Table is Entirely
Locked so that no DML Takes Place.
Also If there are no Indexes on the FK. Oracle Will have to do a FTS for
all the Quries that you are going to Join with the Parent Table.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397
Title: RE: Unindexed foreign key
Shishir,
If there are only a few records in the table, very little. However, if the table is nicely populated, it can make a tremendous difference. You could always do a little testing to find out in your particular case, but I wouldn't bother. I ALWAYS
For performance , Which Option is better :-
Given 6 Internal FCAL Hard Disks ?
1) Creating 1 Volume with Software RAID 1+0 OR
2) Creating 3 Volumes of Software RAID 1 , Each Volume Containing 2 Disks Manually
Spreading the Database
across the 3 Volumes ?
Solaris 8
Machine V880 model
--
Actually, I did get that email too. I assumed I got the email through all
the computer magazines I subscribe too.
Another harvester?
-Original Message-
Sent: Thursday, July 11, 2002 4:53 AM
To: Multiple recipients of list ORACLE-L
Anyone else get this ???
Yet another mail I did not
I'm doing some research into questions Oracle DBAs would like to find
answers/solutions to but for some reason, no time, bumped to a lower
priority etc. they have not had time to find out. If you have a list of
such (Oracle DBA related!) questions, restrict to your top 10 where
necessary, I'd
Moving stuff around won't reduce I/O traffic, it'll just spread it
around across different devices.
Don't focus on how much I/O your system does, focus on how much *time*
an important process spends *doing* I/O. It's Amdahl's Law: If you
improve I/O latencies by 50%, but your program spends only
If you can move the indexes to a separate physical device (and their own
tablespace/datafile) then you will reduce I/O contention. If the
tablespace/datafile is on the same RAID device then you will be using the
same r/w heads and you will not reduce I/O contention.
The fsync() blocks the process until all the dirty pages are written to
the physical disks - maybe this is a problem with async i/o ?
How many async i/o servers are configured on the AIX box (use smitty aio
to check). As a start point set to the maximum to Number of CPU's * 10 and
set the min
Top of the Morning!
I've been tasked by my boss's PHB with performing a pro/con evaluation of
Oracle Warehouse Builder without having the benefit of actually installing
or using the product.
I would greatly appreciate hearing about any real-world experience Warehouse
Builder -- both pro con.
Jesse is probably right,
I am a regular reader to this list but not replying/posting, I didn't get
this message. My last post to this list was over a month ago.
Aleem
-Original Message-
Sent: Wednesday, July 10, 2002 10:11 PM
To: Multiple recipients of list ORACLE-L
Subject:
Make that two.
Reply Separator
Author: Hately Mike [EMAIL PROTECTED]
Date: 7/11/2002 1:58 AM
Oh yes.
-Original Message-
Sent: 11 July 2002 09:53
To: Multiple recipients of list ORACLE-L
Anyone else get this ???
Yet another mail I did
I guess your boss is a good candidate for the paper tiger of the month
award.
How can you REALLY evaluate a product without evaluating it ???
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto:[EMAIL PROTECTED]
-Ursprüngliche
Yes, I do. Thanks to Larry for inventing Perl ;)
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto:[EMAIL PROTECTED]
-Ursprüngliche Nachricht-
Von: Grabowy, Chris [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 11. Juli 2002 15:58
True, but I hope the CA/Platinum code wasn't Quest Central for Oracle. Very
disappointed in what Quest did with their perf tuning tools.
At least TOAD is still standalone.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International,
Ahhh, but have you ever experienced the joy of ruinInstaller on OpenVMS?
The X-fonts come out so big that you sometimes have to guess what's in the
text box and hope it installed correctly. Same goes for all the other
Oracle-written Java tools, like Oracle Directory Manager.
Oracle's solution:
Thanks for the explanation, Ian.
Now I know, and knowing is half the battle.
-- G.I. Joe
:)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: MacGregor, Ian
Cary Millsap,
i selected the top 25 SQL statements in the system over various
periods . all are SELECT statements only waiting for reads.
querying v$session_wait also shows more than 10 records each for
DB FILE SCATTERED READS and DB FILE SEQUENTIAL READS.does not it
mean that it's b'coz of
Thanx Thomas .
i am pretty new to RAID.
will not moving my tables and indexes to seperate tablespace
reduce my i/o ?
my h/w setup is:
there is a logical partition D:
of size 80GB with RAID5.
is it enough that i move to seperate tablespace ?
os should i create another partition like D: and
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the
Hey! Where are we going to get free data dictionary posters if CA dies?
That would be a tragedy.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Thursday, July 11, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L
Subject:
GOTCHA!
The dbca also created an SP file for you.
I was stumped by it too after doing my initial V9.2 install.
I forget the actual name, but this should give you enough of
a clue so you can get moving again.
HTH YMV!
DENNIS WILLIAMS wrote:
For Oracle 9.2 (Solaris), can anyone tell me
Dennis,
Oracle created the SPFILE which is not humanly readable. There should be an
alter database/system command that does the change for you. According to what I
heard at Oratechs 2000 editing the init.ora file is now longer effective.
Dick Goulet
Reply
Dennis,
Do you see a spfile? Are you starting the database via a tool like OEM? If
the spfile is out there, Oracle gives it preferance. Try recreating it from
the pfile and see if your change takes or just get rid of it and start
things on the server and see how that does.
HtH,
John P
Hi,
Moving to different Tablespaces will not do u any good.
To learn more there was big List of Disscussion on...
Comp.databases.oracle.server [ Google Groups http://groups.google.com ]
You can go and seasrch there seperating Tables and Indexes.
HTH
Best Regards,
Ganesh R
Tel : +971 (4)
TUSC.
So it would not be a tragedy. :P
Chris
-Original Message-
Sent: Thursday, July 11, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L
Hey! Where are we going to get free data dictionary posters if CA dies?
That would be a tragedy.
Regards,
Patrice Boivin
Systems Analyst
Title: larry want to take over your e-mai
Ok, I just used the subject line to get your attention.
From today's copy of InformationWeek's daily e-mail.
--
** Oracle Takes On Microsoft's E-Mail
Oracle CEO Larry Ellison says he wants to exploit the security
vulnerabilities and
Dennis, IIRC, the dbca creates an spfile in $ORACLE_HOME/dbs, and
startup reads that by default. If you make changes in init.ora, you'd
have to create a new spfile for them to be recognized. With 9.x, the
preferred way to change parameters is via ALTER SYSTEM...SCOPE...,
which makes the change
Dennis-
With 9i you have the option of using init.ora or the spfile. DBs created with the
assistant I think use spfile by default. To make the change you want, issue the ALTER
SYSTEM blah blah SCOPE BOTH to make the change both immediate and permanent. SCOPE
MEMORY changes it immediately
http://www.tusc.com :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 10:54 AM
To:
I just checked their web site and the only poster they have is - V$ Views
for Oracle9i.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 11:09 AM
TUSC.
So it would not be a tragedy. :P
Chris
Not sure about default pfile location, so I'm specifying it explicitly on db
startup.
As for SPFILE, the default location on Unix is $ORACLE_HOME/dbs (while on NT
it is $ORACLE_HOME/database).
So, if you create SPFILE in this default directory, than you don't have to
specify it on startup.
To
If your D partition is just a logical device then, 'No'. Only moving to a
different physical device will reduce I/O contention.
oraora
but it's not free from TUSC.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 12:09 PM
TUSC.
So it would not be a tragedy. :P
Chris
-Original Message-
Sent: Thursday,
Dennis,
the info you are looking for can be found in the IOUG Select Nov
2001 magazine.
Spfile is a new form of the INIT.ORA file, which is a binary file.
the default location is in $ORACLE_HOME/dbs/spfileSID.ora. The spfile
contains all of the initialization parameters that are currently set
ORDER or NOORDER? If the sequence is not cached then Oracle has to find
the last number generated and generate the next one. If the sequence is
ordered (default) then Oracle must satisfy the first request for NEXTVAL
before it can go on to the next request. If order is not important try
So I guess Ken is voting to keep CA around...:)
-Original Message-
Sent: Thursday, July 11, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
I just checked their web site and the only poster they have is - V$ Views
for Oracle9i.
Ken Janusz, CPIM
- Original Message -
To:
Only for those sad few who have become CA zombies.
Dick Goulet
Reply Separator
Author: Boivin; Patrice J [EMAIL PROTECTED]
Date: 7/11/2002 7:53 AM
Hey! Where are we going to get free data dictionary posters if CA dies?
That would be a tragedy.
On Thu, 11 Jul 2002 07:43:27 -0800, you wrote:
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?
By default, Oracle reads init parms from the new SPFILE. You need to
use new ALTER DATABASE (or is it ALTER SYSTEM?) syntax now in order to
change parameter
TUSC doesn't advertise a Data Dictionary poster on it's web site, only V$
Views for Oracle9i. And, they are not free.
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 11:28 AM
Read the below carefuly.
Do not forget that any ratio of an event to idle events is not considerable.
You must consider it if you see the wait in the top 5 wait event list in
statspack report.
If the time waited for buffer waits is in a considerable rate acoording to
other waits then you must
Ahhh...yeah...that's a reason to keep CA around...the free posters.
-Original Message-
Sent: Thursday, July 11, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
but it's not free from TUSC.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple
Are you sure that these are the ones that are slowing
the system down ? Did you try to find out at what
time of the day the system is really slow and execute
your wait/event queries at that time ? Did you get
a slice of 10046 data when the application was actually
running slow ?You could
This is the kind of knee-jerk reaction that folks have to think harder
about. Having data tablespaces and index tablespaces on the same physical
device (is it really a physical device, or is it a logical device?) does
not equal I/O contention. Maybe (just maybe) on your laptop or desktop, but
Title: RE: Problem with sequence and row cache lock
Thanks for the reply, but it seems to be the problem you're describing is exactly
what sequences are there for - to prevent serialization and eliminate this type
of waiting.
The sequences is ORDERED, BTW.
-Original Message-
From:
Jamadagni,
Tks for the help.
After creating the xviews it worked fine for function, packages, procedures.
I want to include SQL statements also. Was checking
but just return numbers, that explain the decode.
select distinct kglobtyp from X_$KGLOB
KGLOBTYP
--
0
1
Great minds think alike...
-Original Message-
Sent: Thursday, July 11, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L
http://www.tusc.com :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI
Using LogMiner to read redo log, how do I tell a transaction is modified by
which user and where user logins from like what columns in LogMiner should
tell me this kind of information?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
THAT DOES IT. I am starting training on DB2 right away (Yeah - I can actually AFFORD
to no $2000 requirements!!). I want a DB that KNOWS its a DB and not an
all-purpose quagmire of inter-related but not really related junk just because Larry
has a Bill complex!
Oracle and CHEAP cannot
Well they're doing at least one thing right.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Thursday, July 11, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: CA sues Quest Software for code theft
Solaris 2.6
Oracle RDBMS v8.0.5.2.1
List:
I'm trying to run a retrofit of statspack on an 8.0.5 database. (ya, I
know. upgrading would actually be easier)
The statspack stuff came from an 8.1.7 install I have on the same box.
The spreport.sql report encounters errors in the order
Thanks to everyone for the ideas on the init.ora. You were correct that the
answer is indeed with spfile. Now I have discovered a catch-22.
Oracle 9.2, Solaris
1. If spfile is created with LOG_ARCHIVE_START = true,
database will not start. Receive the error
ORA-00439 feature not
decode(kglobtyp,0,'CURSOR',7,'PROCEDURE',8,'FUNCTION',9,'PACKAGE',
11,'PACKAGE BODY',12,'TRIGGER',13,'TYPE',14,'TYPE BODY','OTHER')
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
I checked this on my 9.2 Oracle on win2k:
1- Database is up and running
2- There is no initsid.ora
3- show parameters indicate a parameter called spfile
4- checked v$parameter and found spfile is defined by default to
spfilesid.ora
5- renamed the file spfile.
6- shutdown the database.
7- try to
Vivek,
Per my understanding from Tuning 101 book, your 2nd option is better.
Check out this white paper from Gaja:
http://www.quest.com/whitepapers/Raid1.pdf
Prakash
-Original Message-
Sent: Thursday, July 11, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L
Software Raid 1 ?
Kevin,
In terms of functionality, it's good. But since it is Java based, you need
256MB+ on your desktop/laptop for it to run properly. You also need the
Oracle Gateway if you want OWB to access non-Oracle databases.
HTH!
Prakash
-Original Message-
Sent: Thursday, July 11, 2002 10:34
List,
Received this from the searchdatabase.com site about Oracle defending
the OCP pricing.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
LEAD STORY
ORACLE U. DEFENDS OCP TITLE | SearchDatabase
Defending their new DBA certification requirement against critics who
say
http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci837964,00.html
JP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
We have developers who occassionally want to be able to kill their
sessions in a dev instance. We are concerned about giving them alter
system priviledge and were wondering what people do about this. Is there
any other way they can do this? Do some shops allow certain users to do
this with some
Dennis,
Did you specify scope=both when running alter system ?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 1:48 PM
Thanks to everyone for the ideas on the init.ora. You
Are you actually experiencing a performance problem?
Are users complaining?
If not, then don't worry about it, find something else to do. :)
If so, ( and this has already been stated to you I think ) check
the wait times, don't worry about doing a lot of I/O.
If you don't know how to check
You can write a stored procedure that does the kill of a session
and grant them execute only privilege to the stored procedure.
-Original Message-
Sent: Thursday, July 11, 2002 2:51 PM
To: Multiple recipients of list ORACLE-L
We have developers who occassionally want to be able to kill
NO, they want their session killed, then they can call. I did allow this a few
years ago. It turned into a real mess, PERIOD.
Dick Goulet
Reply Separator
Author: Joe Armstrong-Champ [EMAIL PROTECTED]
Date: 7/11/2002 10:51 AM
We have developers
Nope. Not a chance. Although you could make a small app/procedure that
would help prevent them from making a mistake and killing off the wrong
process, audit the process, and execute it through another schema that would
have the privs.
HTH! GL! :)
Rich Jesse
You can't really avoid them, unless of course your database is down.
If what you really mean is that you're application is frequently waiting
on enqueue locks, then you need to find out why that is happening.
A common reason is that foreign keys are created without supporting
indexes. Another
I will take my OCP from MS!
-Original Message-
Sent: Thursday, July 11, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L
http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci83796
4,00.html
JP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
At a production Site Following Error Occuring many Times Daily
Now the init ora parameters are according to what was suggested. the Shared pool is
200M. Still we are getting the following error:
Message : 002: DATABASE ERROR - sqlcode = [-] Operation: [S]
Message -
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci832443,00.html
http://ixora.com.au/scripts/sql/dd_cluster_sizes.sql
Humm...my money is on Steve as the original author.
- Ethan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL
If your environment is mts be very careful about killing sessions. In some
cases the killed session does not die until the instance is stopped and
started.
Bryan Rodrigues
DBA
Elcom Inc.
-Original Message-
Sent: Thursday, July 11, 2002 2:51 PM
To: Multiple recipients of list ORACLE-L
Not sure of your experience with pl/sql but how about this:
a stored procedure, takes 2 parms, serial and sid.
validation in the stored proc matches the logged in user against the
username in v$session.
if the names match, dynamic sql(ddl) to do the alter command to kill the
session.
Dick,
interesting. tell us why it was such a mess.
regards,
jack
--- [EMAIL PROTECTED] wrote:
NO, they want their session killed, then they can
call. I did allow this a few
years ago. It turned into a real mess, PERIOD.
Dick Goulet
Reply
So imagine I have this series of numbers
1.1
1.1..1
1.1..13
1.1..2
1.1..3
and I want them to sort like a human would sort them
1.1
1.1..1
1.1..2
1.1..3
1.1..7
1.1..13
Anyone have sql to accomplish this?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Weinshenker
Joe,
Once you open this door, you will never get it closed. Next they will want
to modify the table structures.
What are you going to do thie first time they kill an Oracle Background
session?
I agree with Dick. Don't do it. Make them call you.
Tom Mercadante
Oracle Certified Professional
Looks like the searchdatabase copy has disappeared already.
Not many things in this life are certain, but I'll guarantee you one
thing: if there's a script at Ixora with Steve Adams' name on it, then
that script was written by Steve Adams.
Cary Millsap
Hotsos Enterprises, Ltd.
searchdatabase link points to non existent page. Did they pull it??
-Original Message-
Sent: Thursday, July 11, 2002 3:25 PM
To: Multiple recipients of list ORACLE-L
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci832443,00.html
It looks like job security :)
-Original Message-
Sent: Thursday, July 11, 2002 3:47 PM
To: Multiple recipients of list ORACLE-L
Joe,
Once you open this door, you will never get it closed. Next they will want
to modify the table structures.
What are you going to do thie first time
From when MS started offering ORACLE Certified Professional exams :-)
Khedr, Waleed [EMAIL PROTECTED] wrote:
I will take my OCP from MS!
-Original Message-
Sent: Thursday, July 11, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L
All,
I have a DOS batch file. In between this script, I
would like to add user interactive question.
Ex: Do you want to Continue [Y/N]?
Once they hit Y, it will continue rest of the batch
file.
Could someone able to help me out as per the above
requirement?
Thanks,
Bob
I would get the DB to function the way I want first using init.ora. Then
switch to SPFILE from init.ora, while preserving a copy of working init.ora
file.
Also, when a parameter is changed dynamically with SCOPE=both or spfile, I
recreate my init.ora file as the backup.
SPFILE concept is good
Well, without getting into specifics. We had an individual who had a problem
with others in the department. Now you I know that many times in development
we create monsters. That's what the environment is for after all, create what
you think the user wanted see how badly it behaves. Well
I think this will be very competitive!
-Original Message-
Sent: Thursday, July 11, 2002 4:31 PM
To: Multiple recipients of list ORACLE-L
From when MS started offering ORACLE Certified Professional exams :-)
Khedr, Waleed [EMAIL PROTECTED] wrote:
I will take my OCP from MS!
Thanks very much Jamadagni,
It works fine.
Another question, I issued a huge select, ran the script and it appeared. I
cancelled the select
and it still showed up in the result script like for more than 3 minutes,
exited the session and
dissapeared.
Is this the normal behavior ??
Tks I am
Hey all,
In 8.1.7, is there a way to easily replicate a user from one DB (e.g.
development) to another (e.g. production)? I can export all the objects
in the schema, but export/import won't recreate the schema in the import DB.
I've been using OEM to create a script (reverse engineered from
Amy one have any decent stanard error handling packages or link to advice on creating
such a package?
Thanks,
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Bob,
A little off topic, but whatever. Try WinBatch from WilsonWare
(http://www.winbatch.com/). A very nice product that allows you to do the alert
boxes and a whole lot more. Not too expensive either.
Dick Goulet
Reply Separator
Author: Bob
Hi Mitchell,
what is different between those 3 login
1. sqlplus system login, connect as internal
Answer:
when you are doing this you are user 'sys'
because you have changed from system to being
'internal'
connect internal - technically is user 'sys', and is the way
of
Title: listener configuration on HP serviceguard clusters
If anybody out there is using HP ServiceGuard for
non-OPS/RAC, I would be interested to know how you
configure the listeners. Do you use the machine IP address
or the package address in the listener.ora (or do you not
have a
Hannah,
Friday is tomorrow, settle down everything will be all right. It's just his
Bill complex showing through, you know that MicroSoft mantra, We will be
everything to everyone. I'm still waiting for that piece of Windows software
that insures my coffee cup remains full. At least the
1 - 100 of 123 matches
Mail list logo