> > From: Ray Stell [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, February 14, 2002 8:14 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Re: URGENT: need help by point in time recovery
> >
> >
> > This reminds me of something I al
> -Original Message-
> From: Ray Stell [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 15, 2002 1:38 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: URGENT: need help by point in time recovery
>
> On Fri, Feb 15, 2002 at 10:03:48AM -0800, Dejam, Ru
I think export and import are the only way you can do this.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 5:40 PM
> I have a 8.1.6.0.0 database.
>
> What is the best way to change Character Set from WE8ISO8859P1 to
Hello,
Import Export is the simple way.
If you are using Corba in your DB be careful because it is a bit tricky.
Regards
Henrik
Larry Taylor wrote:
> I have a 8.1.6.0.0 database.
>
> What is the best way to change Character Set from WE8ISO8859P1 to UTF8
>
> from:
i once hear someone said that:
update sys.props$ set value='utf8' where name ='NLS_characterset';
and it seems it do work,but not konw whether it is legal,and no experience in
production database.
- Original Message -
From: "Larry Taylor" <[EMAIL PROTECTED]>
To: "Multiple recipients
DO NOT do this in 8i as you will not be able to restart the database.
Martin
-Original Message-
Sent: 14 February 2001 10:31
To: Multiple recipients of list ORACLE-L
i once hear someone said that:
update sys.props$ set value='utf8' where name ='NLS_characterset';
and it seems it do wor
bruary, 2001 13:21
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Urgent! Change Character Set from WE8IS088591 to UTF8
>
>
> DO NOT do this in 8i as you will not be able to restart the database.
>
> Martin
>
> -Original Message-
> Sent: 14 February
To change Character Set, You need to recreate the database.
Correct me if I'm Wrong.
-Original Message-
Sent: Wednesday, February 14, 2001 4:31 AM
To: Multiple recipients of list ORACLE-L
i once hear someone said that:
update sys.props$ set value='utf8' where name ='NLS_characterset';
a
E-L
<[EMAIL PROTECTED]>
Sent by: cc:
root@fatcity.Subject: RE: Urgent! Change Characte
Title: RE: Urgent! Change Character Set from WE8IS088591 to UTF8
With 8.1.6, you may go through an extensive check with the data in all the character columns in your database to verify the compatibility and then use 'alter database nls_characterset = UTF8'
Zhong
It's anothe
T301.log' size
1M,'/data/oracle8/TEST3/redoTEST302.log' size
1M,'/data/oracle8/TEST3/redoTEST303.log' size
1M;}EOF
-----Original Message-From: Stankus, Paula G
Sent: Monday, August 04, 2003 4:12 PMTo:
'[EMAIL PROTECTED]'Subject: RE: URGENT: Tr
Title: Message
Guys,
When
trying to duplicate database with this script
I have
my auxiliary setup as new database, target setup as old database and am using
duplicate database command along with logfile command to create new
logfiles.
Get
error:
RMAN-06136: ORACLE error fro
Title: Message
you
need to : startup nomount pfile=xxx.ora
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 4:09 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate
database from cold
Title: Message
I
did.
-Original Message-From: Anne Yu
[mailto:[EMAIL PROTECTED]Sent: Monday, August 04, 2003 5:24
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
URGENT: Trying to duplicate database from cold backup -
auxi
you
need to : startup nomount
Paula - I was never able to get this working, but then I didn't have Robert
Freeman's book at that time. Do you have his book as a resource?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, August 04, 2003 4:39 PM
To: Multiple
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
Hmmm.
Got Robert's book on 9i
This database and clone is in 8.1.7 hmmm.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 04, 2003 5:49 PM
To: Multiple recipien
Paula - Look in the back, in Appendix C, at the end there is a page on
Duplication in Oracle8i.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message---
Sent: Monday, August 04, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L
Hmmm.
Got Rob
Paula,
Try to mount the auxillary database manually, and see what error you get.
That might help point you in the right direction in solving the problem.
probably 70% of the time it's an issue with the configuration of the aux
database (e.g. parameter set wrong, etc...). Manual startup will show y
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
Dear Robert,
Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate an existing database to a new database. Therefore, I don't have an existing control file and when I have done this with
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
Robert,
Page
405+ of your 9i backup book looks like it is do to me using a backup control
file for this "duplication" and therefore must use the "set until".
H. Not to mention it just is faste
: [EMAIL PROTECTED]
08/04/2003 02:09 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi
This is the type of script I am using:
rman
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
I have done DR just fine using the same database name and creating (with links or otherwise) the same file system names. This was using a complete backup to restore a database to the same host with a different name and
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
With DR did use RMAN. Again:
(1) using RMAN worked fine from one host to another of same database
(2) using cold backup and editing backup controlfile worked fine for same host different database name
(3) using RMAN
E-L
<[EMAIL PROTECTED]>
cc:
Subject:RE: URGENT: Trying to duplicate database from
cold backup - auxi
Robert - What I've done over the years is tie the creation of test
databases
to backup verification. The old issue of how can you trust your backups
unless you
Paula - Okay, when you say you brought the database down, copied the files,
etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in
that post, but your original post was all about RMAN.
-Original Message-
Sent: Tuesday, August 05, 2003 10:19 AM
To: Multiple recipients
Paula - Now you've got my attention. Can you describe in more detail what
you mean by "editing backup controlfile". I use a backup controlfile to
create test databases / validate RMAN backups, so this sounds like something
I could use. Thanks.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, I
Paula - How is your duplication going? Well I hope. Are you basically trying
to perform a disaster recovery? That was basically what I was requested to
do. The statement was "imagine the computer room was taken out by
terrorists, and all you have are the tapes from the off-site storage. You
are pro
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi
Jared
Okay, I'll bite. What do you mean about a "separate project for
verifying
backups". It remin
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
I am with ya.
-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 05, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate
>> BTW, I just waited till afterhours brought the database down, copied
>> the file and cloned the easy way.
I love RMAN, but truth be told, I still find the old manual method of
cloning a database to be easier somehow. Must be an old fogie.
RF
--
Please see the official ORACLE-L FAQ: http://
recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate
database from cold backup - auxi
This
is the type of script I am using:
rman
<connect target rman/[EMAIL PROTECTED]connect catalog
rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run
{resync cat
:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: URGENT: Trying to duplicate database from cold backup -
auxi
Robert - What I've done over the years is tie the creation of test
databases
to
AMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/05/2003 02:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:RE: URGENT: Trying to duplicate database from
cold
backup - auxi
Robert
PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi
>> BTW, I just waited till afterhours brought the database down, copied
>
lto:[EMAIL PROTECTED] Sent: Monday, August 04,
2003 11:09 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: URGENT: Trying to duplicate database from cold
backup - auxi
This is the type of script I am using:
rman <connect target
rman/[EMAIL PROTECTED]co
wo servers into a gigabit switch and
copy the files across a private network at approx 100 gigabytes
per hour.
Jared
DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/05/2003 02:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[
Robert - What I've done over the years is tie the creation of test databases
to backup verification. The old issue of how can you trust your backups
unless you've done a recovery. It has seemed that I get a request to build a
test database at about the right interval to periodically verify the back
s about. ;)
>
> Jared
>
>
>
>
>
> DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 08/05/2003 03:29 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
>
check listener.ora and the hostname of the box for resoltution problems.
-Original Message-
Sent: Friday, August 15, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L
Have you seen this before
15-AUG-2003 12:10:34 *
(CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB
i always did like that about the internet, i can telnet to 127.0.0.1 on
ANY server and it knows my userid/passwd, total awesome.
joe
Mladen Gogala wrote:
Several possibilities:
The host you specified in listener.ora does not exist or your machine is
unable
to recognize it. That usually happen
Yeah, that host is always reachable. As for the telnet, I don't run that
thingy any more. It's ssh localhost, not telnet localhost. Telnet is
politically
incorect.
--
Mladen Gogala
Oracle DBA
-Original Message-
Testa
Sent: Friday, August 15, 2003 3:59 PM
To: Multiple recipients of list
very true and telnet service is usually disabled but localhost it just
doesn't have the confusion for the newbies as 127.0.0.1 does
joe
Mladen Gogala wrote:
Yeah, that host is always reachable. As for the telnet, I don't run that
thingy any more. It's ssh localhost, not telnet localhost. Telnet
Message-
> From: Joe Testa [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 15, 2003 2:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such
> file
>
>
> i always did like that about the internet, i can
sta [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 15, 2003 2:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such
> file
>
>
> i always did like that about the internet, i can telnet to
> 127.0.0.1 on
Luis:
We're patching like crazy, too. So far, none of our systems
has experienced any issues. We're running mostly 8 and 8i,
with a couple 9i machines in there too, on NT4 and Win2k.
Cheers,
Mike
-Original Message-
Sent: Tuesday, August 19, 2003 10:39 AM
To: Multiple recipients of lis
Thanks for your response.
-Original Message-
Sent: Tuesday, August 19, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database?
We are running 9i 9.0.1.1.1 on an Windows 2000 advanced server and our netw
Hi,
We've applied this on NT4 and W2K servers running 81745 with no Oracle issues.
However, have seen 1 anomaly after this patch:
nbtstat against a remote server no longer shows the logged on user name.
This may have been a security improvement by design.
Note you can still use the freeware pslogge
n the same object are locks on
seperate partitions. Not sure.
>
> From: "NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>
> Date: 2003/09/03 Wed AM 09:59:27 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: URGENT : sql*loader performanc
Title: RE: RE: URGENT : sql*loader performance problem on partionned table - not sql*loader problem but cursor pb!
Here the informations :
table HREL_FUSION :
63 millions rows
3 indexes on columns : nodos_or, nodos_or, numcli <--- too much indexes ??
ta
Did you explain plan? I suspect FTS taking place in case of NOT EXISTS.
It must be using Range scan for the non partitioned table.
Can you confirm / post the explain plan.
GovindanK
> Here the informations :
> table HREL_FUSION :
> 63 millions rows
> 3 indexes on columns : nodos_or,
Title: RE: RE: URGENT : sql*loader performance problem on partionned tab
here the trace :
SELECT STATEMENT, GOAL = CHOOSE 2 72 1368
FOR UPDATE
FILTER
PARTITION
There was an issue in 9.0.1.0 with BLOB and ASSM feature. It was rectified in 9.0.1.2.
Are you sure the Oracle version is *exactly* the same? And that the machine B, is not
missing any Oracle patches applied to machine A?
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 5:2
Administrators guide
chapter on auditing.
joe
Mandal, Ashoke wrote:
>>Greetings,
>>
>>We have a database with very sensitive data. Our management wants me to find out the
>way to secure this data from unauthorized login and track these users who tried to
>login to this database.
>>
>>Is ther
Joe,
We referred the auditing option. My understanding is that you can track the oracle
users using database auditing feature once the users are logged into the database.
But my requirement is to track the users who tried to login to the database but could
not login due to wrong password.
Fo
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
I have an idea for a poor man's version of what you are looking for. Turn on listener logging to a level high enough where you can see the text of the net traffic. With some creativity or a copy of Sed & Awk
I stand by my original statement, look at auditing unsuccessful connections.
joe
Mandal, Ashoke wrote:
>Joe,
>
>We referred the auditing option. My understanding is that you can track the oracle
>users using database auditing feature once the users are logged into the database.
>
>But my req
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Administrators guide.
Chapter on auditing.
Audit session.
Rivaldi
-Original Message-
From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 12:54 PM
To: Multiple recipients of list
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: URGE
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi
Revaldi and Joe (Testa),
I went
through the following Administrator's guide.
Oracle8i Administrator's
GuideRelease 2 (8.1.6)Part Number
A76956-01
I could
only see chapter 24 on 'Auditing database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
To
track users who tried and logged into the database :
SQL
> audit session;
I
don't know in which section you can find that in the Administrator
Guide.
Rivaldi
-Original Message-From: Mandal
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
The
SQL reference has some information...
http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074
HTH
Tim
-Original Message-From: Behar, Rivaldi
[mailto:[EMAIL
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi all,
I have never done this particular activity but by following the clues given
in this
thread AND BY reading the documentation I was able to make this work. The
steps I followed were.
1. change the initializaion
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: URGENT Help on tracking unauthorized login to
M
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Sub
231, need a CR version of the block but found the current version of the block
and that is being modified at this moment
220, looking for current version of block but that is bein modified
210, basically the same as 220.
Anjo.
Arun Chakrapani wrote:
> Can somebody please let me know what the fo
njo Kolk [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 12:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Urgent need information on Buffer busy wait P3 value
>
> 231, need a CR version of the block but found the current version of the
> blo
In general the title of what is in P1 P2 and P3 is in P1TEXT P2TEXT
and P3TEXT. In this case, it just says 'id.'
The documentation is also unhelpful:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/apa3.htm#264253
Event Name P1 P2 P3
1-6217
>
> "Common sense will not accomplish great things. Simply become insane and
> desperate."
>
> > -Original Message-
> > From: Anjo Kolk [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, March 14, 2002 12:25 PM
> > To: Multiple recipients of list
l not accomplish great things. Simply become insane and
> desperate."
>
> > -Original Message-
> > From: Anjo Kolk [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, March 14, 2002 12:25 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Urge
imply become
> insane and
> > desperate."
> >
> > > -Original Message-
> > > From: Anjo Kolk [SMTP:[EMAIL PROTECTED]]
> > > Sent: Thursday, March 14, 2002 12:25 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject:
great things. Simply become
> insane and
> > desperate."
> >
> > > -Original Message-
> > > From: Anjo Kolk [SMTP:[EMAIL PROTECTED]]
> > > Sent: Thursday, March 14, 2002 12:25 PM
> > > To: Multiple recipients of list ORACLE-L
> &g
> > > From: Anjo Kolk [SMTP:[EMAIL PROTECTED]]
> > > Sent: Thursday, March 14, 2002 12:25 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Urgent need information on
> Buffer busy wait P3 value
> > >
> > > 231,
; > > Scott Shafer
> > > San Antonio, TX
> > > 210-581-6217
> > >
> > > "Common sense will not accomplish great things.
> > Simply become insane and
> > > desperate."
> > >
> > > > -Original Message-
> > > > From
Hello,
Are u performing any exception handeling in Ur
code? Try to capture oracle err mesg using
"USER DEFINED EXCEPTIONS". For more detail look
into "DBMS_ERROR_CODE" and "DBMS_ERROR_TEXT "
OraCOP
--- Charu Joshi <[EMAIL PROTECTED]> wrote:
> Hi Arup,
>
> Thanks for the reply.
Madhu,
Can you ping the host?
BTW, please use '!'s sparingly - I couldn't help but noticed that most of your message
carry a few. They should be used for emergencies not just attention grabbers.
Dennis
-Original Message-
Sent: Friday, August 15, 2003 1:14 PM
To: Multiple recipients of l
Madhu,
If you are sure you are starting all the listeners, not just the default
listener but named listeners as well (if any). I would look into the
HPUX error next. What is file or directory is it looking for? I would
examine the listener.ora closely and verify that the logging/tracing
directori
Several possibilities:
The host you specified in listener.ora does not exist or your machine is
unable
to recognize it. That usually happens when hosts are known under many
nicknames
and, of course, the host recognizes only some of them.
You are trying to resolve the hostname by using a name se
Luis,
Sorry for the delayed reply.
we installed the same patch on all our 8i/9i instances on win2k.
we have not faced any problem so far.
Regards,
Jp.
>Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database?
>We are running 9i 9.0.1.1.1 on an Windows 2000 advanced
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
There seems to be a problem with consistent shutdowns in 9i
Oracle 9i 64bit
9.0.1.3.0 - infrastructure database that comes with the application server
9.2.0.1.0 - that is the
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
BTW,
nothing happening in terms of processes that would hang-up the system.
Also, I have check alert and trace files and there are no obvious errors.
-Original Message
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them
to shutdown elegantly... and they sometimes crash
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems
Paula - Haven't noticed an issue. What command are you using to shut down?
SHUTDOWN IMMEDIATE? Are you receiving an error message? Anything in
alert_log? Which Oracle version are you on? Most of my databases are
9.2.0.1.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
Which
brings up that thread of - if they are hard to shutdown and possibly going to
crash anyway then . why not just wait some period of time and do the old
shutdown abort
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
No
errors in the alert logs, no traces no ORA- but they don't shutdown cleanly
and so I don't get consistent backups (this is every once in awhile).
-Origin
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
We have started waiting 90 min then do shutdown abort, startup, shutdown
immediate
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas
Few people really enjoy
cc:
[EMAIL PROTECTED] Subject: RE: URGENT!!! My 9i
databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
...wait...for...it...
-Original Message-From: Josh Collier
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003
12:50 PMTo: Multiple recipients of list ORACLE
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
Wait...and... wait... and w.a.i.t
In our case, a lot of the problem was 'supposed' to be a bug fixed
in 9.2 (for a while it was EMN0 waking up... but now that erro
cc:
[EMAIL PROTECTED] Subject: RE: URGENT!!! My 9i
databases are not shutting down cleanly/cons
MON is busy when the shutdown
is issued.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April
WellsSent: Wednesday, August 20, 2003 2:09 PMTo:
Multiple recipients of list ORACLE-LSubject: RE: URGENT!!!
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
Any errors ?? what does alert log say?
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views
Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
I’d suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...
Does anyone remember the UNIX mantra of
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up
What
exactly "goes wrong"?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20,
2003 9:25 AMTo: Multiple recipien
Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
sync,
sync sync always reminded me of Benny Goodman.
Henry
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Tim GormanSent:
Wednesday, August 20, 2003 5:04 PMTo
Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
Hi!
I've always wondered why 3 syncs. Is it quaranteed,
that after *exactly 3* syncs everything has been written to disk? Or it more
like that after that number of syncs, most of the changes should be on disk?
(s
rSent: Thursday, August 21, 2003 12:05 PMTo:
Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i
databases are not shutting down cleanly/cons
Hi!
I've always wondered why 3 syncs. Is it
quaranteed, that after *exactly 3* syncs everything has been written to disk?
Or it
Title: Message
how
about if I send you $1,111,111.11 3 times.
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
URGENT!!! My 9i databases are not shutting down
Title: Message
Hey
Tom,
You
can send me $111 3 times and I'll be happy! ;o)
-Scott
Stefick
-Original Message-From: Mercadante,
Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August
21, 2003 1:40 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: U
I will not object to anything. You can send me $1 and I'll gladly take it
Contr
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday,
August 21, 2003 2:49 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting
down cleanly/cons
Hey
Tom,
You
can send me $111 3 times and I'll be happy! ;o)
-Scott St
301 - 400 of 424 matches
Mail list logo