RE: OT -- Boston Globe job listings
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Boston Globe job listings
area over the past > couple of years. Most of these companies also provide e-mail service that > sends you an email when a job is posted that meets your specs. So, why > waste your time on newspaper ads that only appear every Sunday? > > My $0.02 worth, > > Ken Janusz, CPIM > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, August 14, 2003 6:34 AM > > >> I've been keeping an eye on the Boston Globe's Oracle DBA job postings, > two >> years ago it wasn't uncommon to see eight or more per week, now I tend to >> see one or two, or none. >> >> For a while they also announced big IT job fairs, I don't know if they > still >> do that or how successful they now are. >> >> The market has really shrunk in two years! >> >> There can't be a huge glut of DBAs out there looking for work... It must > be >> a reduction in demand because companies are not making big infrastructure >> changes anymore. >> >> Patrice. >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Boivin, Patrice J >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- 858-538-5051 http://www.fatcity.com >> San Diego, California-- Mailing list and web hosting services >> - >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You may >> also send the HELP command for other information (like subscribing). >> >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Script Question
Title: RMAN Script Question
David,
Change the
following line in ur script :
backup database plus archivelog delete
input
to
backup incremental level = 0 plus
archivelog delete input
Hth,
Samir
Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418
Ext. 76028 Fax
: +44 (0) 115 - 957
6018
-Original Message-From: David Wagoner
[mailto:[EMAIL PROTECTED]Sent: 06 August 2003
15:09To: Multiple recipients of list ORACLE-LSubject:
RMAN Script Question
I believe I have an RMAN script syntax error.
The following script works fine:
resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 0 skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile)
; release channel t1;
}
However, when I change the backup command to
include archive logs and remove them after backup, I get an exit status of 1
in NetBackup and some RMAN errors. Here is the revised
script:
resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup database plus archivelog delete
input skip
inaccessible tag
hot_db_bk_level0 filesperset
5 format
'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; }
Here is the RMAN error:
RMAN-00571:
=== RMAN-00569: === ERROR MESSAGE STACK
FOLLOWS === RMAN-00571:
=== RMAN-00558: error encountered while parsing input
commands RMAN-01005: syntax error:
found "(": expecting one of: "channel, comma, delete, diskratio, filesperset,
format, force, include, keep, maxsetsize, noexclude, nokeep, not, parms, pool,
;, skip, setsize, tag"
RMAN-01007: at line 8 column 36 file:
/usr/openv/netbackup/oracle_db/hot_database_backup_level0.rcv
Anyone see the error?
Best regards,
David B. Wagoner Database Administrator Arsenal
Digital Solutions
RE: RMAN Script Question
Title: RMAN Script Question
David,
I notice that u r
using the line
format 'data_full_%d_%U_%p_%c.bak' (database);
in ur backup
script when u r actually performing a database backup including archived logs
backup.
Try modifying the
script as :
resync catalog; run { allocate channel t1
type 'SBT_TAPE'; backup database plus archivelog delete
input skip inaccessible tag
hot_db_bk_level0 filesperset 5
format 'data_full_%d_%U_%p_%c.bak'; backup
tag='control_file_backup' format
'control_%s_%t.ctl' (current controlfile) ; release channel t1; }
Samir
-Original Message-From: David Wagoner
[mailto:[EMAIL PROTECTED]Sent: 06 August 2003
16:00To: Multiple recipients of list ORACLE-LSubject:
RE: RMAN Script Question
Thanks Samir, but I already tried that one too and it
didn't work either.
Best regards,
David B. Wagoner Database Administrator Arsenal
Digital Solutions -Original Message-From:
SARKAR, Samir [mailto:[EMAIL PROTECTED]Sent:
Wednesday, August 06, 2003 9:52 AMTo:
'[EMAIL PROTECTED]'Cc: David WagonerSubject: RE: RMAN
Script Question
David,
Change the
following line in ur script :
backup database plus archivelog delete
input
to
backup incremental level = 0 plus
archivelog delete input
Hth,
Samir
Samir Sarkar Oracle DBA SchlumbergerSema
Email :
[EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext.
76028 Fax :
+44 (0) 115 - 957
6018
-Original Message-From: David Wagoner
[mailto:[EMAIL PROTECTED]Sent: 06 August 2003
15:09To: Multiple recipients of list
ORACLE-LSubject: RMAN Script Question
I believe I have an RMAN script syntax
error. The following script works fine:
resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 0
skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak'
(database); backup
tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ;
release channel t1; }
However, when I change the backup command to
include archive logs and remove them after backup, I get an exit status of
1 in NetBackup and some RMAN errors. Here is the revised
script:
resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup database plus archivelog delete
input skip
inaccessible tag
hot_db_bk_level0 filesperset
5 format
'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup'
format 'control_%s_%t.ctl' (current
controlfile) ; release
channel t1; }
Here is the RMAN error:
RMAN-00571:
===
RMAN-00569: === ERROR
MESSAGE STACK FOLLOWS === RMAN-00571:
===
RMAN-00558: error encountered while
parsing input commands RMAN-01005: syntax error: found "(": expecting one of: "channel,
comma, delete, diskratio, filesperset, format, force, include, keep,
maxsetsize, noexclude, nokeep, not, parms, pool, ;, skip, setsize,
tag"
RMAN-01007: at line 8 column 36 file:
/usr/openv/netbackup/oracle_db/hot_database_backup_level0.rcv
Anyone see the error?
Best regards,
David B. Wagoner Database Administrator Arsenal Digital Solutions
RE: Upgrading from 8.1.7 32 bit to 9.2.0.3 64 bit
Jay, Just make sure that ur OS is 64-bit as well and go ahead as per the documentation. If ur OS is HP-UX, do not forget to set ur SHLIB_PATH and CLASSPATH as well. Cheers Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 June 2003 15:50 To: Multiple recipients of list ORACLE-L Hi all, Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bit? I'm trying to determine whether it's necessary to perform any other steps than the regular upgrade process. Note 62290.1 seems to imply that no other steps are required, but this is contradicted elsewhere and it's proving almost impossible to get a straight answer from Oracle. There's one hilarious Forum exchange on metalink (search on 32 bit Sahoo) where the tech manages to avoid saying anything other than read the documentation. So, any advice, experience, or pointers to other articles out there? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo generation rate
Tim, Thanks so much for your response.ur query was of immense help. Cheers Samir -Original Message- Sent: 27 May 2003 18:50 To: Multiple recipients of list ORACLE-L Samir, I find this query useful... select first_time, mb, mb - (avg(mb) over ()) dev_from_avg from(select trunc(first_time) first_time, sum(blocks*block_size)/1048576 mb fromv$archived_log group by trunc(first_time)) order by first_time; Hope this helps -Tim > All, > > Can anybody please help me on this : > > We are trying to find out the bandwidth required for > keeping our DR database updated using Dataguard. > There is an equation the networking guys use for this but > I need to give them the redo generation rate > or redo copy rate in bytes per second. Is there any way I > can find this out without using Statspack ?? > > Thanks and Regards, > > Samir > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com San Diego, California-- > Mailing list and web hosting services > -- > --- To REMOVE yourself from this mailing list, > send an E-Mail message to: [EMAIL PROTECTED] (note > EXACT spelling of 'ListGuru') and in the message BODY, > include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also > send the HELP command for other information (like > subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Redo generation rate
All, Can anybody please help me on this : We are trying to find out the bandwidth required for keeping our DR database updated using Dataguard. There is an equation the networking guys use for this but I need to give them the redo generation rate or redo copy rate in bytes per second. Is there any way I can find this out without using Statspack ?? Thanks and Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database hang on Shutdown
Has anyone ever seen - and resolved - a database hang at shutdown when the message "SHUTDOWN: waiting for active calls to complete." appears in the alert log. We get this occasionally and no matter how long we wait the shutdown never completes. A new connection to do an abort is not possible as we get "ORA-01090: shutdown in progress - connection is not permitted" when we connect. Oracle don't seem to have anything to say that is useful - just do what the message says and wait. Our only solution so far is to kill all the database processes from UNIX and then remove the sga from memory manually using ipcrm - not an ideal solution. Regards Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PGA
So whats the reality, Connor ?? I thought it was the reverse which was the myth i.e. it is often misunderstood as the total memory available to the database user as a whole for sort operations.I believe the reality is that the sort area size is the size allocated by Oracle per user process for sorting data. Do enlighten me if I am wrong Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 31 March 2003 15:19 To: Multiple recipients of list ORACLE-L Oracle Myth #1745 "When u set the sort_area_size for a database, it will allocate that much memory PER USER for any sort operation being performed on the database" --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote: > Arvind, > > When u set the sort_area_size for a database, it > will allocate that much > memory PER USER > for any sort operation being performed on the > database. In practice, it > means that if u allocate > too high a value for the sort_area_size and multiple > users are performing > multiple sorts, the Unix > system may run out of memory and Oracle will return > u a process memory > error. > > For eg. if u have ur sort_area_size as 100MB and u > have 10 users performing > sort operations > on the database, Oracle will take up 100*10 MB > memory. This might degrade ur > system performance. > > Samir > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 31 March 2003 11:04 > To: Multiple recipients of list ORACLE-L > > > hello all, > > how does increasing the value of SORT_AREA_SIZE > affect the unix system > perfomance. > > > Thanks > Arvind > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Arvind Kumar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > _ > This email is confidential and intended solely for > the use of the > individual to whom it is addressed. Any views or > opinions presented are > solely those of the author and do not necessarily > represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised > that you have received > this email in error and that any use, dissemination, > forwarding, printing, > or copying of this email is strictly prohibited. > > If you have received this email in error please > notify the > SchlumbergerSema Helpdesk by telephone on +44 (0) > 121 627 5600. > _ > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.
RE: PGA
Arvind, When u set the sort_area_size for a database, it will allocate that much memory PER USER for any sort operation being performed on the database. In practice, it means that if u allocate too high a value for the sort_area_size and multiple users are performing multiple sorts, the Unix system may run out of memory and Oracle will return u a process memory error. For eg. if u have ur sort_area_size as 100MB and u have 10 users performing sort operations on the database, Oracle will take up 100*10 MB memory. This might degrade ur system performance. Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 31 March 2003 11:04 To: Multiple recipients of list ORACLE-L hello all, how does increasing the value of SORT_AREA_SIZE affect the unix system perfomance. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
SET ORACLE-L NOMAIL _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Idle Connections
Many thanks, Dick.much appreciated. Samir -Original Message- Sent: 10 September 2002 19:21 To: SARKAR, Samir; Multiple recipients of list ORACLE-L Samir, Yes there is, 1st set resource_limit = TRUE in the init.ora file. 2nd bounce the database. 3rd create a profile for those who are the inconsiderate bunch and set idle_timeout = x where x is in minutes. Their session will show up in V$session as sniped. You can then easily put together a perl script or something similar, I use Pro*C, that kills off the Unix process and really terminates their session. Works like a charm. Dick Goulet Reply Separator Author: "SARKAR; Samir" <[EMAIL PROTECTED]> Date: 9/10/2002 8:18 AM Hi All, I am facing problems with a database with some very irresponsible users who just connect to the database from their applications and simply dont logout. Apart from the usual chidings I have been giving them, could any of you please tell me whether any parameter exists which can be put either in the sqlnet.ora file or database parameter file which will timeout and close the idle connections after a particular time interval ?? Thanks, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Idle Connections
Hi All, I am facing problems with a database with some very irresponsible users who just connect to the database from their applications and simply dont logout. Apart from the usual chidings I have been giving them, could any of you please tell me whether any parameter exists which can be put either in the sqlnet.ora file or database parameter file which will timeout and close the idle connections after a particular time interval ?? Thanks, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sql loader control file help - solved
.com > -- > Author: Ron Thomas > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-4030 Out of Process Memory
Thanks a bunch for replying, John. I had a look at the /etc/sysdef file and it seemed to be exactly the same as yours.so were the ulimit parameters. I have logged a call with Oracle but they do not seem too be very responsive either. Anybody else with any other ideas about what and how to tweak any of the server or database parameters ?? Any help will b greatly appreciated. Thanks, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 15 August 2002 09:18 To: Multiple recipients of list ORACLE-L Samir, Does ulimit -a indicate anything? From my Solaris 8 system: $ ulimit -a time(seconds)unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes)8192 coredump(blocks) unlimited nofiles(descriptors) 256 vmemory(kbytes) unlimited Also look at '/etc/sysdef': * * Process Resource Limit Tunables (Current:Maximum) * Infinity:Infinity cpu time Infinity:Infinity file size Infinity:Infinity heap size 0x0080:Infinity stack size Infinity:Infinity core file size 0x0100:0x0400 file descriptors Infinity:Infinity mapped memory Hth, John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-Original Message- >From: SARKAR, Samir [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, August 14, 2002 3:59 AM >To: Multiple recipients of list ORACLE-L >Subject: ORA-4030 Out of Process Memory > > >Hi All, > >This is 8.1.6.3 (32-bit) on Solaris 8. We have been trying to run a >transaction on the database >and it is throwing up ORA-4030. The process is indeed a big >process and we r >getting this >error only while running a particular transaction. On running >'maxmem', we >get the following : > >Memory starts at: 137992 ( 21b08) > Memory ends at: 2147483647 (7fff) > Memory available: 2147345655 (7ffde4f7) > >Can anybody help me finding out how to increase the Memory >available to more >than 2 Gig ?? I think >that this memory limitation is why my process is dying when >its grown to >circa 2 Gig. Also, do I need to >increase the swap space and bounce the server ?? My swap info >is as under : > > swapfile dev swaplo blocks free >/dev/vx/dsk/swapvol 239,8 16 16774704 16774704 >/dev/vx/dsk/rootdg/v_swap 239,6 16 34815984 34815984 > >Any other checks/inputs on this will be highly appreciated as this is a >production database and I have >an impatient client. > >Thanks, >Samir > >Samir Sarkar >Oracle DBA >SchlumbergerSema >Email : [EMAIL PROTECTED] >Phone : +44 (0) 115 - 957 6028 >EPABX : +44 (0) 115 - 957 6418 Ext. 76028 >Fax : +44 (0) 115 - 957 6018 > > > >_ >This email is confidential and intended solely for the use of the >individual to whom it is addressed. Any views or opinions >presented are >solely those of the author and do not necessarily represent those of >SchlumbergerSema. >If you are not the intended recipient, be advised that you >have received >this email in error and that any use, dissemination, >forwarding, printing, >or copying of this email is strictly prohibited. > >If you have received this email in error please notify the >SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. >_ > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 53
ORA-4030 Out of Process Memory
Hi All, This is 8.1.6.3 (32-bit) on Solaris 8. We have been trying to run a transaction on the database and it is throwing up ORA-4030. The process is indeed a big process and we r getting this error only while running a particular transaction. On running 'maxmem', we get the following : Memory starts at: 137992 ( 21b08) Memory ends at: 2147483647 (7fff) Memory available: 2147345655 (7ffde4f7) Can anybody help me finding out how to increase the Memory available to more than 2 Gig ?? I think that this memory limitation is why my process is dying when its grown to circa 2 Gig. Also, do I need to increase the swap space and bounce the server ?? My swap info is as under : swapfile dev swaplo blocks free /dev/vx/dsk/swapvol 239,8 16 16774704 16774704 /dev/vx/dsk/rootdg/v_swap 239,6 16 34815984 34815984 Any other checks/inputs on this will be highly appreciated as this is a production database and I have an impatient client. Thanks, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Objects and Object Translator
Hi All, Just a quick question.. Does anybody know if Oracle Objects and Oracle Object Translator comes with the basic Oracle server installation or is it a separate product or is it something which comes with the Oracle Client installation ?? Thanks and Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 64-bit OS
Lisa, Just type the command isainfo -kv This will give u the result. You will have to run this as root. HTH, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 12 June 2002 17:18 To: Multiple recipients of list ORACLE-L Hi - We have just installed Solaris 2.8 (8) on a new SUN server. Is there a command I can run to tell if it's running in 64-bit mode? If I'm building a database for a homegrown Oracle data warehouse - would it be best to run 64-bit Oracle? Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Messaging Gateway
Hi All, Is there anybody among you who has installed and configured Oracle Messaging Gateway and if so, could you please tell me where I can get the guidelines for the same ?? Any help would b greatly appreciated. Thanks and Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cronjob
0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Thanks in advance Roland -- 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 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rman, Duplicating without set untill.... & cloning with not a
Jack, Of course you can duplicate a db using RMAN without using the 'set until time' feature. Are u sure all the archived logs which have been backed up by RMAN are present i.e. none of the logs have been accidentally deleted ?? RMAN will use the archived logs to apply the changes and open the database with the 'resetlogs' option. Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 12 April 2002 10:58 To: Multiple recipients of list ORACLE-L tablespaces Hi All, I'm currently in the middle of a tar with Oracle about duplicating without set until time/scn According to the doc's it must be possible but when trying I get an error message about an archive log file that it needs but is not yet there. Any of you duplicating without set untill time/scn etc.. w/o problems if so what version RMAN/Oracle What OS/version What sequence of actions do you perform? Second I try to find the rman alternative to cloning just a part of the database but can't find anything in the Doc's Anybody TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECT
RE: Instance fails to start
Bill, Check whether u have any hung shared memory segments by issuing the command : $ ipcs -mobs Look for an oracle:dba user having NTTACH = 0. If it exists, remove it using the command : $ ipcrm -m Attempt to restart. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 10 April 2002 16:48 To: Multiple recipients of list ORACLE-L Hi All! I have encounterd an interesting problem after attempting to make a change in my parameter file. I made a minor change in the date format, and upon shutting down (normal) and starting up, an error in the format was reported. I changed the format back to it's original form so that there was no diff between the original pfile and the current one, and attempted to restart, and I receive the following error: SQL> startup ORA-24323: value not allowed ORA-03113: end-of-file on communication channel There is nothing interesting in the alert log, and I see the same error with a startup nomount. Any ideas as to what is going on? Thanks in advance!! Bill Tantzen University of Minnesota Libraries [EMAIL PROTECTED] 612-626-9949 (office) 612-250-6125 (cell) I guess the man's a genius, but what a dirty mind he has, hasn't he? -- Nora Joyce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Tantzen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN madness !!
tch clone datafile all;
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: switch
RMAN-03023: executing command: switch
RMAN-08015: datafile 2 switched to datafile copy
RMAN-08507: input datafilecopy recid=1 stamp=458671845
filename=/disk01/oradata/test/data/rbs01sid1.dbf
RMAN-08015: datafile 3 switched to datafile copy
RMAN-08507: input datafilecopy recid=2 stamp=458671845
filename=/disk01/oradata/test/data/rbslarge01sid1.dbf
RMAN-08015: datafile 4 switched to datafile copy
RMAN-08507: input datafilecopy recid=3 stamp=458671845
filename=/disk01/oradata/test/data/temp01sid1.dbf
RMAN-08015: datafile 5 switched to datafile copy
RMAN-08507: input datafilecopy recid=4 stamp=458671845
filename=/disk01/oradata/test/data/tools01sid1.dbf
RMAN-08015: datafile 6 switched to datafile copy
RMAN-08507: input datafilecopy recid=5 stamp=458671845
filename=/disk01/oradata/test/data/users01sid1.dbf
RMAN-08015: datafile 7 switched to datafile copy
RMAN-03027: printing stored script: Memory Script
{
set until time 'to_date(''20-MAR-2002 20:00:00'',''DD-MON-
HH24:MI:SS'')';
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-00601: fatal error in recovery manager
RMAN-03012: fatal error during compilation of command
RMAN-03028: fatal error code: 600
RMAN-03013: command type: Duplicate Db
RMAN-00600: internal error, arguments [15120] [] [] [] []
RMAN-01005: syntax error: found "single-quoted-string": expecting one of:
";"
RMAN-01007: at line 2 column 30 file: Memory Script
Any ideas anybody ?? My head is all mitered by now.
Thanks and Regards,
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018
___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.
If you have received this email in error please notify the SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.
___
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SARKAR, Samir
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Hallas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SARKAR, Samir
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RMAN madness !!
Jay,
Thanks so much for ur help. Could u please tell me whether I shall have to
set the NLS_DATE_FORMAT and NLS_LANG in the parameter file of the auxiliary
db alone or on
the target db (the main prod db) as well ???
Regards,
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018
-Original Message-
Sent: 08 April 2002 18:28
To: [EMAIL PROTECTED]; SARKAR, Samir
You need to change this line
set until time 'to_date(''20-MAR-2002
20:00:00'',''DD-MON-HH24:MI:SS'')';
to
set until time '2002032020';
This is bug 1887009. This isn't fixed until 9.0.2.
You must set
NLS_DATE_FORMAT=MMDDHH24MISS (or your favorite date format)
and
NLS_LANG= (whatever your nls lang is for the database)
I learned the hard way, that if you don't set NLS_LANG, then NLS_DATE_FORMAT
is ignored (at least in 8.1.7 on Tru64).
Don't forget to shutdown your auxiliary db, delete it's files, then start it
up again, NOMOUNT.
Jay
>>> [EMAIL PROTECTED] 04/08/02 02:03PM >>>
Hi All,
I am back againand yes, my script didn't work completely. It did
write the data files
to the respective locations but it returned the following error during the
process of duplicating
the db :
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel dupdb_d1: starting datafile backupset restore
RMAN-08502: set_count=335 set_stamp=456984311 creation_time=20-MAR-2002
RMAN-08089: channel dupdb_d1: specifying datafile(s) to restore from backup
set
RMAN-08523: restoring datafile 1 to
/disk01/oradata/test/data/system01sid1.dbf
RMAN-08523: restoring datafile 2 to
/disk01/oradata/test/data/rbs01sid1.dbf
RMAN-08523: restoring datafile 3 to
/disk01/oradata/test/data/rbslarge01sid1.dbf
RMAN-08523: restoring datafile 4 to
/disk01/oradata/test/data/temp01sid1.dbf
RMAN-08523: restoring datafile 5 to
/disk01/oradata/test/data/tools01sid1.dbf
RMAN-08523: restoring datafile 6 to
/disk01/oradata/test/data/users01sid1.dbf
RMAN-08023: channel dupdb_d1: restored backup piece 1
RMAN-08511: piece handle=DB_BKUP_INCR_0_SID1_456984311_335_1
tag=DB_BKUP_INCR_0 params=NULL
RMAN-08024: channel dupdb_d1: restore complete
RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "test"
RESETLOGS ARCHIVELOG
MAXLOGFILES 48
MAXLOGMEMBERS 2
MAXDATAFILES 1000
MAXINSTANCES10
MAXLOGHISTORY 2042
LOGFILE
GROUP 1 ( '/disk03/oradata/test/logs/log01a01sid1.dbf' ) SIZE 188743680
,
GROUP 2 ( '/disk03/oradata/test/logs/log02a01sid1.dbf' ) SIZE 188743680
,
GROUP 3 ( '/disk03/oradata/test/logs/log03a01sid1.dbf' ) SIZE 188743680
DATAFILE
'/disk01/oradata/test/data/system01sid1.dbf'
CHARACTER SET WE8ISO8859P1
RMAN-03027: printing stored script: Memory Script
{
switch clone datafile all;
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: switch
RMAN-03023: executing command: switch
RMAN-08015: datafile 2 switched to datafile copy
RMAN-08507: input datafilecopy recid=1 stamp=458671845
filename=/disk01/oradata/test/data/rbs01sid1.dbf
RMAN-08015: datafile 3 switched to datafile copy
RMAN-08507: input datafilecopy recid=2 stamp=458671845
filename=/disk01/oradata/test/data/rbslarge01sid1.dbf
RMAN-08015: datafile 4 switched to datafile copy
RMAN-08507: input datafilecopy recid=3 stamp=458671845
filename=/disk01/oradata/test/data/temp01sid1.dbf
RMAN-08015: datafile 5 switched to datafile copy
RMAN-08507: input datafilecopy recid=4 stamp=458671845
filename=/disk01/oradata/test/data/tools01sid1.dbf
RMAN-08015: datafile 6 switched to datafile copy
RMAN-08507: input datafilecopy recid=5 stamp=458671845
filename=/disk01/oradata/test/data/users01sid1.dbf
RMAN-08015: datafile 7 switched to datafile copy
RMAN-03027: printing stored script: Memory Script
{
set until time 'to_date(''20-MAR-2002 20:00:00'',''DD-MON-
HH24:MI:SS'')';
RMAN-00571: ===
RMAN-00569: === ER
RMAN madness !!
r copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _______ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another RMAN Problem ---> Urgent !!
John, Jack, Tom, Jay and all those who replied, Thanks so much for ur help. I have been able to resolve my problem. I was connecting to both the target and auxiliary databases with '/' as the connect string and as a result, RMAN was getting confused. I had to necessarily create a password file and connect to RMAN using the connect string : rman target / catalog rman_sid1/rman_sid1@rman817 auxiliary internel/password@test as John and Jay suggested. I also had to put an entry in the tnsnames.ora file for the service name of the auxiliary db which was named 'test'. I also added an entry for the auxiliary db in the listener.ora and restarted it. As for the script, I had to make another change..the line : duplicate target database to test had to be modified to :duplicate target database to "test" The Restore operation is in progress now...its a big db so it will take some time.will bother you folks again if it fails ;-) Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another RMAN Problem ---> Urgent !!
Jay and Tom,
Thanks a million for your replies. I have now ran the script by creating it
and
then executing it from the RMAN prompt. It worked but I got the following
error :
rman target / catalog rman_sid1/rman_sid1@rman817 auxiliary /
Recovery Manager: Release 8.1.7.2.0 - Production
RMAN-06005: connected to target database: SID1 (DBID=647056675)
RMAN-06008: connected to recovery catalog database
RMAN-06020: connected to auxiliary database
RMAN> run {execute script dup_db;}
RMAN-03021: executing script: dup_db
RMAN-03022: compiling command: set
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dupdb_d1
RMAN-08500: channel dupdb_d1: sid=43 devtype=SBT_TAPE
RMAN-08526: channel dupdb_d1: VERITAS NetBackup for Oracle8 - Release 3.4GA
(030800)
RMAN-03022: compiling command: set limit
RMAN-03023: executing command: set limit
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: Duplicate Db
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: dupdb_d1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03015: error occurred in stored script dup_db
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-05500: the auxiliary database must be not mounted when issuing a
DUPLICATE command
Can you tell me if there is anything wrong with my Connect String ?? If so,
how do I
specify the connect string correctly ?? The auxiliary is DEFINITELY not
mounted here since
I have started it in NOMOUNT mode. The target db is the one I am trying to
duplicate and
the auxiliary db is the duplicate db I am attempting to create. The target
db is obviously
open. I am not using a password file since I am working directly on the
server.
Regards,
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018
-Original Message-
Sent: 08 April 2002 14:06
To: [EMAIL PROTECTED]; SARKAR, Samir
Your input to RMAN should be a script or "here" list. Scrap the shell
script, put your "run" script into a file, run RMAN from the command line
and call the rman "run" script that you just created.. Also, set
NLS_DATE_FORMAT and NLS_LANG. Depending on your database version the
"to_date" function will not work as you have it in "set until time".
Jay
>>> [EMAIL PROTECTED] 04/08/02 09:43AM >>>
Dear All,
I am totally out of my depth here and this is a production db which needs to
be restored urgently.
I shall explain my scenario first. Our application team had lost some data
after last Wednesday night's
backup. They have a tool to have a dump of the data from the database from
which they can extract the
data if needed. This dump was taken on Thursday morning. Due to some ***hole
they lost some more data
on Thursday during the day. They recovered this data from the database dump
which they had taken on
Thursday morning.
They now want the data which was lost on Wednesday. Since there was no
database dump available prior to
this, I suggested that we can create a duplicate database upto a point of
time (as on Wednesday night) to a
different location on the server. They could then take a database dump with
their tool and extract the lost records.
This is my script which I compiled with help from Metalink and an old
post from John Hallas (the backup of our target database is taken on tape
with Veritas Netbackup) :
#!/bin/ksh
rman target / catalog rman_sid1/rman_sid1@rman817 auxiliary /
run {
set until time "to_date('20-MAR-2002 20:00:00','DD-MON- HH24:MI:SS)";
allocate channel c_dlt1 type 'SBT_TAPE';
allocate auxiliary channel dupdb_d1 type disk;
setlimit channel c_dlt1 kbytes 67108864 maxopenfiles 128 readrate 256;
setlimit channel dupdb_d1 kbytes 67108864 maxopenfiles 128 readrate 256;
set newname for datafile
'/disk01/oradata/sid1/data/system01sid1.dbf'
to '/disk01/oradata/test/data/system01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/rbs01sid1.dbf'
to '/disk01/oradata/test/data/rbs01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/temp01sid1.dbf'
to '/disk01/oradata/test/data/temp01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/tools01sid1.dbf'
to '/disk01/oradata/test/data/tools01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/da
Another RMAN Problem ---> Urgent !!
Dear All,
I am totally out of my depth here and this is a production db which needs to
be restored urgently.
I shall explain my scenario first. Our application team had lost some data
after last Wednesday night's
backup. They have a tool to have a dump of the data from the database from
which they can extract the
data if needed. This dump was taken on Thursday morning. Due to some ***hole
they lost some more data
on Thursday during the day. They recovered this data from the database dump
which they had taken on
Thursday morning.
They now want the data which was lost on Wednesday. Since there was no
database dump available prior to
this, I suggested that we can create a duplicate database upto a point of
time (as on Wednesday night) to a
different location on the server. They could then take a database dump with
their tool and extract the lost records.
This is my script which I compiled with help from Metalink and an old
post from John Hallas (the backup of our target database is taken on tape
with Veritas Netbackup) :
#!/bin/ksh
rman target / catalog rman_sid1/rman_sid1@rman817 auxiliary /
run {
set until time "to_date('20-MAR-2002 20:00:00','DD-MON- HH24:MI:SS)";
allocate channel c_dlt1 type 'SBT_TAPE';
allocate auxiliary channel dupdb_d1 type disk;
setlimit channel c_dlt1 kbytes 67108864 maxopenfiles 128 readrate 256;
setlimit channel dupdb_d1 kbytes 67108864 maxopenfiles 128 readrate 256;
set newname for datafile
'/disk01/oradata/sid1/data/system01sid1.dbf'
to '/disk01/oradata/test/data/system01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/rbs01sid1.dbf'
to '/disk01/oradata/test/data/rbs01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/temp01sid1.dbf'
to '/disk01/oradata/test/data/temp01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/tools01sid1.dbf'
to '/disk01/oradata/test/data/tools01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/users01sid1.dbf'
to '/disk01/oradata/test/data/users01sid1.dbf';
duplicate target database to test
logfile
group 1 '/disk03/oradata/test/logs/log01a01sid1.dbf' size 180M,
group 2 '/disk03/oradata/test/logs/log02a01sid1.dbf' size 180M,
group 3 '/disk03/oradata/test/logs/log03a01sid1.dbf' size 180M;
}
What happens is that RMAN connects to the target, catalog and auxiliary
database and goes into the
RMAN prompt and just hangs thereafter some time, when I type 'exit'
there out of frustration, I
get the following errors :
./create_dupdb.sh[5]: run: not found
./create_dupdb.sh[9]: allocate: not found
./create_dupdb.sh[11]: allocate: not found
./create_dupdb.sh[13]: setlimit: not found
./create_dupdb.sh[14]: setlimit: not found
./create_dupdb.sh[17]: /disk01/oradata/sid1/data/system01sid1.dbf: cannot
execute
./create_dupdb.sh[18]: to: not found
./create_dupdb.sh[21]: /disk01/oradata/sid1/data/rbs01sid1.dbf: cannot
execute
./create_dupdb.sh[22]: to: not found
./create_dupdb.sh[29]: /disk01/oradata/sid1/data/temp01sid1.dbf: cannot
execute
./create_dupdb.sh[30]: to: not found
./create_dupdb.sh[33]: /disk01/oradata/sid1/data/tools01sid1.dbf: cannot
execute
./create_dupdb.sh[34]: to: not found
./create_dupdb.sh[37]: /disk01/oradata/sid1/data/users01sid1.dbf: cannot
execute
./create_dupdb.sh[38]: to: not found
./create_dupdb.sh[77]: duplicate: not found
./create_dupdb.sh[79]: logfile: not found
./create_dupdb.sh[80]: group: cannot execute
./create_dupdb.sh[81]: group: cannot execute
./create_dupdb.sh[82]: group: cannot execute
./create_dupdb.sh[83]: syntax error at line 84 : `}' unexpected
Could anybody please help me in identifying what is the problem and why does
it say 'run:not found' and the
other subsequent lines ?? This is highly urgent for me !!
Thanks and Regards,
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018
___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.
If you have received this email in error please notify the SchlumbergerSema Helpdesk
by telephone on +44 (0) 121 627 5600.
___
--
Please see the official ORACLE-L FAQ: http://www.orafaq.
RE: Re[2]: WHICH UNIX FOR ORACLE?
the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A RMAN question
Thanks Jay.actually our clients want it that way that the cloned DB is backed up instead of the production DB. I think u r right about RMAN getting confused when it reads the controlfiles the next day for taking an incremental backup since they will have been replaced overnight. But I am using a recovery catalog database, so I dont understand why won't RMAN just go and take an incremental backup of only the changed blocks anyway instead of bothering about whats there in the control files of the target database. Does this also mean that in case I have to recreate the controlfile of the target database, I can never do an incremental backup during the first go ?? Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 March 2002 14:58 To: Multiple recipients of list ORACLE-L I think RMAN will have problems with the incremental backup. When it looks at the control files for the cloned db, they will have no record of a previous backup. What you are doing is a bit unusual in that the database on server A (which would be considered production) should be backed up. And if you are backing up the database on server A, why bother to backup the datbase on Server B? Especially if you are refreshing it each night. It sounds like you should really be setting up a standby database. Jay > -Original Message- > From: SARKAR, Samir [SMTP:[EMAIL PROTECTED]] > Sent: Thu, March 21, 2002 10:38 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: A RMAN question > > Hi Dennis, > > Thanks for replying. I guess I have not been able to make my question > clear. > You see, I need to backup only the cloned database on server B and NOT the > > database on server A. My scenario is as follows : > > The main db on server A is a partitioned data warehouse system and we r > planning to copy over the data files and the control files every night to > the cloned db on server B. Thereafter, we will b taking a RMAN backup of > the > cloned db on server B only. > As I said, RMAN writes the backup info on the target database's control > files > when it takes the backup. I also said that we plan to take a full backup > on > > Sundays and incremental backup on the other days. > > My confusion was : > > Say, RMAN takes a backup of the database on the cloned db on server B > on a Monday. On MOnday night as per procedure, the control files and > the database files from the main db on server A are copied over to server > > B. On Tuesday, will RMAN b happy taking the incremental backup again > of the cloned db on server B even though it finds that the control files > r different than the ones it wrote the backup info to the previous day ?? > Or will it get confused and prompt for a FULL backup ?? > > Any ideas from anybody would b appreciated a lot. > > Regards, > Samir > > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
RE: A RMAN question
Hi Yechiel, Of course I do use a RMAN catalog on server B to backup the cloned database. The scenario I described was because I am wondering whether RMAN will be happy taking a second incremental backup the next day after the controlfiles of the target database were overwritten overnight. Please read my earlier mail keeping in mind that a RMAN catalog database is being used. I would b thankful for any advice on this. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 March 2002 13:38 To: Multiple recipients of list ORACLE-L Hello Samir I do not work with RMAN but I THINK that you have a conceptual error in your logic. Since you do not have a catalog RMAN use the control files as catalog. When you want to restore RMAN will not find the data on the full backup in the control files. You will have only the data on the last incremental backup. How can you restore? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: SARKAR, Samir [SMTP:[EMAIL PROTECTED]] > Sent: Thu, March 21, 2002 10:38 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: A RMAN question > > Hi Dennis, > > Thanks for replying. I guess I have not been able to make my question > clear. > You see, I need to backup only the cloned database on server B and NOT the > > database on server A. My scenario is as follows : > > The main db on server A is a partitioned data warehouse system and we r > planning to copy over the data files and the control files every night to > the cloned db on server B. Thereafter, we will b taking a RMAN backup of > the > cloned db on server B only. > As I said, RMAN writes the backup info on the target database's control > files > when it takes the backup. I also said that we plan to take a full backup > on > > Sundays and incremental backup on the other days. > > My confusion was : > > Say, RMAN takes a backup of the database on the cloned db on server B > on a Monday. On MOnday night as per procedure, the control files and > the database files from the main db on server A are copied over to server > > B. On Tuesday, will RMAN b happy taking the incremental backup again > of the cloned db on server B even though it finds that the control files > r different than the ones it wrote the backup info to the previous day ?? > Or will it get confused and prompt for a FULL backup ?? > > Any ideas from anybody would b appreciated a lot. > > Regards, > Samir > > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 20 March 2002 19:16 > To: Multiple recipients of list ORACLE-L > > > Samir - We have found that each Oracle database has an internal ID. This > ID > doesn't change when you clone it as you describe. RMAN uses this ID, and > will become confused if it sees two databases that are identical. One way > around this is to run two RMAN catalogs. I have not considered it an > advantage to use RMAN with the control file (non-catalog) option, so I > haven't considered all the ramifications there. > Have you looked at the RMAN DUPLICATE command to clone the database? > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, March 20, 2002 10:14 AM > To: Multiple recipients of list ORACLE-L > > > Hi All, > > Though I have been using RMAN for quite a while now, I would like to ask > for > a clarification > here. > > We have a production database with partitioning options on server A. We > copy over the files > (including the control files) of the prod database each night to a server > B. > We will then be using > RMAN to backup the database on server. We intend to take a Full backup on > Sundays and Incrementals > on all weekdays. > I know that when we take a RMAN backup, it writes information about that > task to the target database's > control files which is precisely why we need not have a catalog database > necessarily. > > My question is when RMAN takes a backup once, will it return an error when > tries to take an > incremental backup a second time since we have replaced the control files > overnight ?? I mean, > will RMAN be happy with taking an INCREMENTAL backup of the database even > if > i
RE: A RMAN question
Hi Dennis, Thanks for replying. I guess I have not been able to make my question clear. You see, I need to backup only the cloned database on server B and NOT the database on server A. My scenario is as follows : The main db on server A is a partitioned data warehouse system and we r planning to copy over the data files and the control files every night to the cloned db on server B. Thereafter, we will b taking a RMAN backup of the cloned db on server B only. As I said, RMAN writes the backup info on the target database's control files when it takes the backup. I also said that we plan to take a full backup on Sundays and incremental backup on the other days. My confusion was : Say, RMAN takes a backup of the database on the cloned db on server B on a Monday. On MOnday night as per procedure, the control files and the database files from the main db on server A are copied over to server B. On Tuesday, will RMAN b happy taking the incremental backup again of the cloned db on server B even though it finds that the control files r different than the ones it wrote the backup info to the previous day ?? Or will it get confused and prompt for a FULL backup ?? Any ideas from anybody would b appreciated a lot. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 March 2002 19:16 To: Multiple recipients of list ORACLE-L Samir - We have found that each Oracle database has an internal ID. This ID doesn't change when you clone it as you describe. RMAN uses this ID, and will become confused if it sees two databases that are identical. One way around this is to run two RMAN catalogs. I have not considered it an advantage to use RMAN with the control file (non-catalog) option, so I haven't considered all the ramifications there. Have you looked at the RMAN DUPLICATE command to clone the database? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 20, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Hi All, Though I have been using RMAN for quite a while now, I would like to ask for a clarification here. We have a production database with partitioning options on server A. We copy over the files (including the control files) of the prod database each night to a server B. We will then be using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: ht
A RMAN question
Hi All, Though I have been using RMAN for quite a while now, I would like to ask for a clarification here. We have a production database with partitioning options on server A. We copy over the files (including the control files) of the prod database each night to a server B. We will then be using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: problem in creating control file?
What did u do ?? Did u use the command 'alter database backup controlfile to trace' from database TESTDB to generate the 'create controlfile' statement ?? If so, the datafiles in the 'create controlfile' statement should have the name 'TESTDB' as the db name in their header. You can only change the path of the datafile names in the 'create controlfile' statement and not the actual datafile itself while creating the clone. Log on to the TESTDB database again and ascertain whether the datafiles listed in ur 'create controlfile' statement matches those in TESTDB. Modify the 'create controlfile' statement to read : CREATE CONTROLFILE RESUE SET DATABASE "TEST2" RESETLOGS ARCHIVELOG Hope this helps, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 12 March 2002 11:48To: Multiple recipients of list ORACLE-LSubject: problem in creating control file? I try to clone my database . I have the datafiles on D:\yedek123 and want to create the control files . What I do is : set oracle_sid=new_sid svrmgrl internal/ startup nomount pfile=new_pfile CREATE CONTROLFILE DATABASE "TEST2" RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 1815LOGFILE GROUP 1 'D:\yedek123\REDO01.LOG' SIZE 1M, GROUP 2 'D:\yedek123\REDO02.LOG' SIZE 1M, GROUP 3 'D:\yedek123\REDO03.LOG' SIZE 1MDATAFILE 'D:\yedek123\SYSTEM01.DBF', 'D:\yedek123\RBS01.DBF', 'D:\yedek123\USERS01.DBF', 'D:\yedek123\TEMP01.DBF', 'D:\yedek123\TOOLS01.DBF', 'D:\yedek123\INDX01.DBF', 'D:\yedek123\DR01.DBF'CHARACTER SET WE8ISO8859P9; But When I run the create control file script , I am encountering the error below. CREATE CONTROLFILE DATABASE "TEST2" RESETLOGS ARCHIVELOG*ORA-01503: CREATE CONTROLFILE failedORA-01161: database name TESTDB in file header does not match given name of TEST2ORA-01110: data file 1: 'D:\yedek123\SYSTEM01.DBF' TESTDB is the original database . TEST2 is new DB. What is the problem ? Thank you. Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: problem in creating control file?
What did u do ?? Did u use the command 'alter database backup controlfile to trace' from database TESTDB to generate the 'create controlfile' statement ?? If so, the datafiles in the 'create controlfile' statement should have the name 'TESTDB' as the db name in their header. You can only change the path of the datafile names in the 'create controlfile' statement and not the actual datafile itself while creating the clone. Log on to the TESTDB database again and ascertain whether the datafiles listed in ur 'create controlfile' statement matches those in TESTDB. Modify the 'create controlfile' statement to read : CREATE CONTROLFILE RESUE SET DATABASE "TEST2" RESETLOGS ARCHIVELOG Hope this helps, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 12 March 2002 11:48To: Multiple recipients of list ORACLE-LSubject: problem in creating control file? I try to clone my database . I have the datafiles on D:\yedek123 and want to create the control files . What I do is : set oracle_sid=new_sid svrmgrl internal/ startup nomount pfile=new_pfile CREATE CONTROLFILE DATABASE "TEST2" RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 1815LOGFILE GROUP 1 'D:\yedek123\REDO01.LOG' SIZE 1M, GROUP 2 'D:\yedek123\REDO02.LOG' SIZE 1M, GROUP 3 'D:\yedek123\REDO03.LOG' SIZE 1MDATAFILE 'D:\yedek123\SYSTEM01.DBF', 'D:\yedek123\RBS01.DBF', 'D:\yedek123\USERS01.DBF', 'D:\yedek123\TEMP01.DBF', 'D:\yedek123\TOOLS01.DBF', 'D:\yedek123\INDX01.DBF', 'D:\yedek123\DR01.DBF'CHARACTER SET WE8ISO8859P9; But When I run the create control file script , I am encountering the error below. CREATE CONTROLFILE DATABASE "TEST2" RESETLOGS ARCHIVELOG*ORA-01503: CREATE CONTROLFILE failedORA-01161: database name TESTDB in file header does not match given name of TEST2ORA-01110: data file 1: 'D:\yedek123\SYSTEM01.DBF' TESTDB is the original database . TEST2 is new DB. What is the problem ? Thank you. Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: Changing the SID of a database
Take a backup of the controlfile statement by doing a alter system backup controlfile to trace; Then use this script to create a new controlfile with the new SID after u have transferred all the datafiles, redolog files and archive log files. The first line of the create controlfile script may look aomething like : CREATE CONTROLFILE REUSE SET DATABASE "" RESETLOGS ARCHIVELOG Change the path of the log files and other datafiles in the script if they happen to be different than the old database. Remember to run the create controlfile script in nomount mode. Remember to change the db_name parameter in ur parameter file for the new database. After creating the controlfile, startup the database using the resetlogs option : alter database open resetlogs; Hope this helps, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 04 March 2002 15:23 To: Multiple recipients of list ORACLE-L I'm going to take the datafiles from a cold backup and use them for a new database. However, to do this, I need to change the SID of the new db. I've read that it's possible, but not how to do it. Is this an easy thing to do, or would it be better to extract the tables and create the new db that way? Thanks for any help. Rick -- 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 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Lost a redo disk
Do u have a consistent backup of the database ?? If so, restore the same and issue the command : recover database until cancel; When all the archived logs have been applied, issue the command : alter database open resetlogs; This should create the online redologs. Hope this helps, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 February 2002 13:28 To: Multiple recipients of list ORACLE-L Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Create Database ... really dumb question
Check Metalink Note : 56016.999
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018
-Original Message-
Sent: 14 February 2002 13:23
To: Multiple recipients of list ORACLE-L
Okay... I am at a loss. There is SOMETHING wrong, and I can not for the
life of me see it. I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors... >:\
THESE are my errors..
create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component
THIS is my script...
create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse
WHAT is wrong with it. I am really not this inept... really... but I can't
see what is wrong with the database name.
Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.
April Wells
Corporate Systems
Amarillo Texas
___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.
If you have received this email in error please notify the SchlumbergerSema Helpdesk
by telephone on +44 (0) 121 627 5600.
___
begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-Ahttp://www.orafaq.com
--
Author: April Wells
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SARKAR, Samir
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Rollback Segment Problem
Thanks a lot, Rafiqthe output from ur query after running it on the database showed the rollback segment to be highly fragmented.the total extents were 7490 and the extents coalesced were only 440. The initial and next extents have been set at 409K which seems to me as quite small. Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 13 February 2002 16:03 To: Multiple recipients of list ORACLE-L Samir, It is not coalesced automatically at shutdown and startup. It is to be coalesced manually. It applies to any tablespace with pctincrease set as 0(zero). I have no idea of 9i but this is normal behaviour of ver 7.3.4 to 8.1.7... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 13 Feb 2002 05:48:28 -0800 Rafiq, Just a small questionr the rollback segment extents in the rollback segment tablespace de-allocated when the database is shut down ?? In that case, does the fragmentation remain when the database is restarted or r the blocks coalesced automatically ?? Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 12 February 2002 17:49 To: Multiple recipients of list ORACLE-L Is your tablespace fragmented as it is not finding contingous extent .. TRy to coalesce your subject tablespace and try... you can use following script to check whether coalesing is required or not.. If percent is < 100 then coalesce it.. select substr(tablespace_name,1,10)TS_NAME,total_extents "Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0) from dba_free_space_coalesced order by tablespace_name / HTH Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 12 Feb 2002 02:33:19 -0800 All, The following is the pitiable scenario I am in and would really appreciate a bit of help : We were running a long running delete job which gave the following error : Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production SQLWKS> EXECUTE PKG_PAS_AnnualDataMaintenance.Delete_OldData (2000, '/home/sqribe/work/live', '2000AnnualDataDelete.log'); ORA-01562: failed to extend rollback segment number 8 ORA-01650: unable to extend rollback segment RSUNDB08 by 50 in tablespace RSUN425 ORA-06512: at "PAS.PKG_PAS_ANNUALDATAMAINTENANCE", line 66 ORA-06512: at line 2 I don't understand why it ran out of rollback space. The rollback segment has a virtually unlimited number of extents, so the only explanation I can see is that this particular rollback segment expanded until it exceeded the space allocation for the whole tablespace RSUN425, which is 3,000M. However, Oracle Storage Manager shows only 200M of the tablespace used, and it also shows high water marks against each rollback segment, none of which exceeds 400M. This would suggest to me that none of the previous month's deletions exceeded 400M per month, so why should it fail on this particular one when it had nearly 3,000M available? Is there something I am not understanding about rollback segments ?? Thanks and Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 Sa
RE: Rollback Segment Problem
Rafiq, Just a small questionr the rollback segment extents in the rollback segment tablespace de-allocated when the database is shut down ?? In that case, does the fragmentation remain when the database is restarted or r the blocks coalesced automatically ?? Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 12 February 2002 17:49 To: Multiple recipients of list ORACLE-L Is your tablespace fragmented as it is not finding contingous extent .. TRy to coalesce your subject tablespace and try... you can use following script to check whether coalesing is required or not.. If percent is < 100 then coalesce it.. select substr(tablespace_name,1,10)TS_NAME,total_extents "Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0) from dba_free_space_coalesced order by tablespace_name / HTH Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 12 Feb 2002 02:33:19 -0800 All, The following is the pitiable scenario I am in and would really appreciate a bit of help : We were running a long running delete job which gave the following error : Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production SQLWKS> EXECUTE PKG_PAS_AnnualDataMaintenance.Delete_OldData (2000, '/home/sqribe/work/live', '2000AnnualDataDelete.log'); ORA-01562: failed to extend rollback segment number 8 ORA-01650: unable to extend rollback segment RSUNDB08 by 50 in tablespace RSUN425 ORA-06512: at "PAS.PKG_PAS_ANNUALDATAMAINTENANCE", line 66 ORA-06512: at line 2 I don't understand why it ran out of rollback space. The rollback segment has a virtually unlimited number of extents, so the only explanation I can see is that this particular rollback segment expanded until it exceeded the space allocation for the whole tablespace RSUN425, which is 3,000M. However, Oracle Storage Manager shows only 200M of the tablespace used, and it also shows high water marks against each rollback segment, none of which exceeds 400M. This would suggest to me that none of the previous month's deletions exceeded 400M per month, so why should it fail on this particular one when it had nearly 3,000M available? Is there something I am not understanding about rollback segments ?? Thanks and Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
RE: Rollback Segment Problem
Thanks a lot for ur help, Rafiq. I have acted as per ur recommendation and asked the customer to try the delete job again.have not received a feedback from them yet but sometimes they only revert back to me if they have faced a problem again.if I do not hear anything by this evening, I will assume that it has worked. Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 12 February 2002 17:49 To: Multiple recipients of list ORACLE-L Is your tablespace fragmented as it is not finding contingous extent .. TRy to coalesce your subject tablespace and try... you can use following script to check whether coalesing is required or not.. If percent is < 100 then coalesce it.. select substr(tablespace_name,1,10)TS_NAME,total_extents "Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0) from dba_free_space_coalesced order by tablespace_name / HTH Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 12 Feb 2002 02:33:19 -0800 All, The following is the pitiable scenario I am in and would really appreciate a bit of help : We were running a long running delete job which gave the following error : Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production SQLWKS> EXECUTE PKG_PAS_AnnualDataMaintenance.Delete_OldData (2000, '/home/sqribe/work/live', '2000AnnualDataDelete.log'); ORA-01562: failed to extend rollback segment number 8 ORA-01650: unable to extend rollback segment RSUNDB08 by 50 in tablespace RSUN425 ORA-06512: at "PAS.PKG_PAS_ANNUALDATAMAINTENANCE", line 66 ORA-06512: at line 2 I don't understand why it ran out of rollback space. The rollback segment has a virtually unlimited number of extents, so the only explanation I can see is that this particular rollback segment expanded until it exceeded the space allocation for the whole tablespace RSUN425, which is 3,000M. However, Oracle Storage Manager shows only 200M of the tablespace used, and it also shows high water marks against each rollback segment, none of which exceeds 400M. This would suggest to me that none of the previous month's deletions exceeded 400M per month, so why should it fail on this particular one when it had nearly 3,000M available? Is there something I am not understanding about rollback segments ?? Thanks and Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send a
Rollback Segment Problem
All, The following is the pitiable scenario I am in and would really appreciate a bit of help : We were running a long running delete job which gave the following error : Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production SQLWKS> EXECUTE PKG_PAS_AnnualDataMaintenance.Delete_OldData (2000, '/home/sqribe/work/live', '2000AnnualDataDelete.log'); ORA-01562: failed to extend rollback segment number 8 ORA-01650: unable to extend rollback segment RSUNDB08 by 50 in tablespace RSUN425 ORA-06512: at "PAS.PKG_PAS_ANNUALDATAMAINTENANCE", line 66 ORA-06512: at line 2 I don't understand why it ran out of rollback space. The rollback segment has a virtually unlimited number of extents, so the only explanation I can see is that this particular rollback segment expanded until it exceeded the space allocation for the whole tablespace RSUN425, which is 3,000M. However, Oracle Storage Manager shows only 200M of the tablespace used, and it also shows high water marks against each rollback segment, none of which exceeds 400M. This would suggest to me that none of the previous month's deletions exceeded 400M per month, so why should it fail on this particular one when it had nearly 3,000M available? Is there something I am not understanding about rollback segments ?? Thanks and Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Dropping user hangs indefnitely
Rachel, This is bafflingI did look up the v$locked_object view and dba_waiters both of which returned no rows. The v$lock had the value 0 for lock requests. I tried a shutdown immediate through a stored script which brings down the context server alongwith bringing down the database. That hung as well although there weren't any users using the database. I looked up the processes on the server and sure enough there was a ctxhx process initiated by the context server which was running. I killed the same and the database shutdown was completed. The database was restarted and we could then remove the user. My point is since the context server held locks on the objects owned by a particular user in the database, the same should have shown up in the lock info which I accessed. Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 05 February 2002 14:15 To: Multiple recipients of list ORACLE-L before shutting down the server why not look to see if there are locks on the objects? --- Mark Leith <[EMAIL PROTECTED]> wrote: > I think that might be a good start.. > > -Original Message- > Samir > Sent: 05 February 2002 11:30 > To: Multiple recipients of list ORACLE-L > > > Thanks for your reply, Gopalakrishnan. I did check whether the user > has > logged into the database but I got a negative. > However, I did come across the following possiblity but I am not sure > of > this so > could u please throw some light on it ?? > > We have a context server running Intermedia applications which > accesses the > the objects held by that user (the user trying to b dropped). Is > there a > chance > of a lock being held on one of those objects due to which the > dropping of > the user > takes forever ?? Will it help if we shutdown the context server which > runs > the > Intermedia applications before we try to drop the user ?? > > Regards, > Samir > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 05 February 2002 10:30 > To: Multiple recipients of list ORACLE-L > > > Probably that user might have connected to the instance. Check > V$session. > > > Best Regards, > K Gopalakrishnan > Bangalore, INDIA > > > > -Original Message- > Samir > Sent: Tuesday, February 05, 2002 1:41 AM > To: Multiple recipients of list ORACLE-L > > > Hi list, > > Can anybody help me how to identify why the dropping of a particular > user > hangs indefnitely ?? > > Database is 8.1.7 on Solaris 7. > > Regards, > Samir > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018 > > > > ___ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented > are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have > received > this > email in error and that any use, dissemination, forwarding, printing, > or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the > SchlumbergerSema > Helpdesk by telephone on +44 (0) 121 627 5600. > ___ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > __
RE: Dropping user hangs indefnitely
Thanks for your reply, Gopalakrishnan. I did check whether the user has logged into the database but I got a negative. However, I did come across the following possiblity but I am not sure of this so could u please throw some light on it ?? We have a context server running Intermedia applications which accesses the the objects held by that user (the user trying to b dropped). Is there a chance of a lock being held on one of those objects due to which the dropping of the user takes forever ?? Will it help if we shutdown the context server which runs the Intermedia applications before we try to drop the user ?? Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 05 February 2002 10:30 To: Multiple recipients of list ORACLE-L Probably that user might have connected to the instance. Check V$session. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Samir Sent: Tuesday, February 05, 2002 1:41 AM To: Multiple recipients of list ORACLE-L Hi list, Can anybody help me how to identify why the dropping of a particular user hangs indefnitely ?? Database is 8.1.7 on Solaris 7. Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dropping user hangs indefnitely
Hi list, Can anybody help me how to identify why the dropping of a particular user hangs indefnitely ?? Database is 8.1.7 on Solaris 7. Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Tunning
Well Mogens, Niemiec's book does have its plus points as well. What we basically want from Oracle is improved response times and faster performancewhich is all about how many hits we r getting and improving the hit ratio is something any DBA will try to attain. There is a wonderful technique in his book about how to estimate the size of the db_block_buffers by mythically raising it by a certain amount and checking the hit ratio or decreasing it and checking the impact. This way, we can arrive at an optimum value for the db_block_buffers. How to interpret the UTLESTAT/UTLBSTAT statistics r very clearly and lucidly explained as r the various join methods, improper use of indexes including index suppression, using the x$bh table to monitor buffer use, a very clear explanation of the Explain Plan, new tips for Oracle 8/8i, how to use PL/SQL for better performance etc. The best part is the book has lots of very useful queries and screen reprints to help us understand the scenario better. Am not saying that it is the best tuning book in the market but the techniques of tuning r very clearly explained in it. Tuning by wait events is still very arcane and not explained clearly exactly how to do it in many books though I haven't read the 101 book. I still find it difficult to properly interpret all the various wait events and latch contention and how to go about tuning them And until Steve Adams comes out with his advanced performance tuning book, we will all have to wait. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: 31 January 2002 18:39To: Multiple recipients of list ORACLE-LSubject: Re: Oracle TunningCommit; :-)In my opinion, you shouldn't spend your money on buying the Niemich book. It's full of errors (increase the buffer cache hit ratio, for instance) and the wrong approach (no time-based measurement method, just checklist after checklist).Buy 101 by Gaja. Then buy Tom Kyte's One-On-One book for general fantastic advise on anything. Then go to oraperf.com (Anjo), hotsos.com (Millsap), ixora.com.au (Steve Adams) and Jonathan Lewis' website (can never remember the adresse). Or go to MiracleAS.dk and find all these links, including the book links.MogensMiracle A/SDenmarkFarnsworth, Dave wrote: Binay,I totally agree with this recommendation from Jared for a tuning book.Read the first three chapters, stop and re-read them. And if you playyour cards right you can even get a question answered by an author onthis list. Cool, eh.Dave-Original Message-Sent: Tuesday, January 29, 2002 3:05 PMTo: Multiple recipients of list ORACLE-LStart with 'Oracle Performance Tuning 101', available at anamazon.com near you.JaredOn Tuesday 29 January 2002 09:10, [EMAIL PROTECTED] wrote: Hi Everyone Can anyone suggest me some very good book on Oracle Tunning.Please only mention those books which you think is really worth purchasingBinay KumarOracle Cerified DBALondon---The contents of this e-mail are confidential to the ordinary userof the e-mail address to which it was addressed and may also beprivileged. If you are not the addressee of this e-mail you shouldnot copy, forward, disclose or otherwise use it or any part of itin any form whatsoever. If you have received this e-mail in errorplease notify us by telephone or e-mail the sender by replying tothis message, and then delete this e-mail and other copies of itfrom your computer system. Thank you.We reserve the right to monitor all e-mail communications throughour network. ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: Total extents
This query should give u the total number of used extents in a tablespace as well as the number of used blocks and bytes : select a.tablespace_name, NVL(count(extent_id),0) "Used Extents", sum(NVL(bytes,0)) "Bytes Used", sum(NVL(blocks,0)) "Blocks Used" from dba_tablespaces a, dba_extents b where a.tablespace_name = b.tablespace_name(+) group by tablespace_name; Hope this helps, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 31 January 2002 13:30 To: Multiple recipients of list ORACLE-L yep that works -- that is the total ALLOCATED extents in the tablespace. --- Viraj Luthra <[EMAIL PROTECTED]> wrote: > Could I use the following query to get the total used extents :- > > SELECT t.tablespace_name, t.initial_extent, > t.next_extent, t.min_extents, t.max_extents, > t.pct_increase, status, contents, sum(extents) > FROMsys.dba_tablespaces t, sys.dba_segments s > where t.tablespace_name=s.tablespace_name > group by t.tablespace_name, t.initial_extent,t.next_extent, > t.min_extents, t.max_extents, > t.pct_increase, status, contents > / > > > There is addition of sum(extents) from dba_segments? > > Rgds, > > Raj > -- > > On Wed, 30 Jan 2002 21:25:21 > Viraj Luthra wrote: > >Hi all, > > > >I want to come to know if I can get the Total number of Used Extents > in addition to what I am getting in the following query :- > > > >SELECT tablespace_name, initial_extent, > > next_extent, min_extents, max_extents, > > pct_increase, status, contents > > FROMsys.dba_tablespaces > > ORDER BY tablespace_name > > > > > >Is it possible? How? > > > >Rgds, > > > >Raj > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Viraj Luthra > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing > Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viraj Luthra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly p
RE: Total extents
Errata : Change the last line of the query to group by a.tablespace_name Sorry about that !! Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 31 January 2002 13:30 To: Multiple recipients of list ORACLE-L yep that works -- that is the total ALLOCATED extents in the tablespace. --- Viraj Luthra <[EMAIL PROTECTED]> wrote: > Could I use the following query to get the total used extents :- > > SELECT t.tablespace_name, t.initial_extent, > t.next_extent, t.min_extents, t.max_extents, > t.pct_increase, status, contents, sum(extents) > FROMsys.dba_tablespaces t, sys.dba_segments s > where t.tablespace_name=s.tablespace_name > group by t.tablespace_name, t.initial_extent,t.next_extent, > t.min_extents, t.max_extents, > t.pct_increase, status, contents > / > > > There is addition of sum(extents) from dba_segments? > > Rgds, > > Raj > -- > > On Wed, 30 Jan 2002 21:25:21 > Viraj Luthra wrote: > >Hi all, > > > >I want to come to know if I can get the Total number of Used Extents > in addition to what I am getting in the following query :- > > > >SELECT tablespace_name, initial_extent, > > next_extent, min_extents, max_extents, > > pct_increase, status, contents > > FROMsys.dba_tablespaces > > ORDER BY tablespace_name > > > > > >Is it possible? How? > > > >Rgds, > > > >Raj > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Viraj Luthra > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing > Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viraj Luthra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED]
RE: Performance Tuning
Okay Rachelu have me convinced thereI am adding the 101 book to my shelf !! I said *some* of the masters of OracleI do realize that there r lots of other masters of Oracle who do not work for TUSC. Yep...Alomari's book does deal more on OS tuning for Oracle but don't u think that much of our tuning efforts always go towards the database whereas the real focus should b directed on the OS which houses Oracleof course, it depends on case-to-case basis but I have come across so many DBAs who always think that the problem is with the database rather than otherwise. Other than Alomari's book, I haven't come across any other book which explains so well the way Oracle works within the OS kernel, thats the reason I thought anybody working on Oracle on Unix needs that book. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 19:21 To: Multiple recipients of list ORACLE-L I didn't say Rich's book is bad, just that if you could only buy one, I'd buy the 101 book. It's written in a more "friendly" style than the other one, mostly because that's the goal of the 101 series. Of course, since I did some of the editing on the book, I'm prejudiced (and no, I don't get any money if more copies sell) define "masters of Oracle" -- there are a heck of lot of incredibly brilliant Oracle users (developers and DBAs) who don't work for TUSC As for Alomari's book -- it deals more with OS tuning for Oracle than for performance tuning within the database. --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote: > Maybe u r right, Rachel.since except for me, all the others have > suggested the 101 book. Thing is, I bought Rich's book based on the > customer reviews on Amazon and I must say that I am not disappointed > but > then, > I haven't read the 101 book. At the same time, TUSC is supposed to > have some > of the masters of Oracle. > One thing I wonder is why nobody has recommended Alomari's book cos > it is a > gem for DBAs working on Unix. > > Samir > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 30 January 2002 15:50 > To: Multiple recipients of list ORACLE-L > > > I would perhaps suggest Oracle Performance Tuning 101 instead of > Rich's > book (if you had to make a choice). > > the 101 book conforms most closely to Oracle's current thinking on > performance tuning > > > --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote: > > Practically, u should get two books to have a full grasp on Oracle > > Performance > > Tuning : > > > > 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec > > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari > > > > If u r in an exceptionally high development environment where u > have > > lots of > > SQL tuning to do, > > consider buying the SQL High Performance Tuning by Don Burleson. > > Otherwise, > > the > > above two books should suffice for both production and development > > databases. > > > > Samir > > > > Samir Sarkar > > Oracle DBA - Lennon Team > > SchlumbergerSema > > Email : [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > Phone : +44 (0) 115 - 957 6217 > > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > > Fax : +44 (0) 115 - 957 6018 > > > > > > -Original Message- > > Sent: 30 January 2002 10:25 > > To: Multiple recipients of list ORACLE-L > > > > > > Hi Everyone > > > > I am interested in purchasing some exceptionally good book on > Oracle > > Performance Tuning. Can anyone suggest me some very good book on > > Oracle > > Tunning worth purchasing > > > > > > Binay Kumar > > Oracle Cerified DBA > > > > London > > > > > > > > *** > > Binay Kumar > > Focus 3 -Technical Support > > P & O Nedllyod > > London > > 0044 207 441 1648 > > *** > > > > > > > > --- > > > > The contents
RE: Performance Tuning
Maybe u r right, Rachel.since except for me, all the others have suggested the 101 book. Thing is, I bought Rich's book based on the customer reviews on Amazon and I must say that I am not disappointed but then, I haven't read the 101 book. At the same time, TUSC is supposed to have some of the masters of Oracle. One thing I wonder is why nobody has recommended Alomari's book cos it is a gem for DBAs working on Unix. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 15:50 To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote: > Practically, u should get two books to have a full grasp on Oracle > Performance > Tuning : > > 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari > > If u r in an exceptionally high development environment where u have > lots of > SQL tuning to do, > consider buying the SQL High Performance Tuning by Don Burleson. > Otherwise, > the > above two books should suffice for both production and development > databases. > > Samir > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 30 January 2002 10:25 > To: Multiple recipients of list ORACLE-L > > > Hi Everyone > > I am interested in purchasing some exceptionally good book on Oracle > Performance Tuning. Can anyone suggest me some very good book on > Oracle > Tunning worth purchasing > > > Binay Kumar > Oracle Cerified DBA > > London > > > > *** > Binay Kumar > Focus 3 -Technical Support > P & O Nedllyod > London > 0044 207 441 1648 > *** > > > > --- > > The contents of this e-mail are confidential to the ordinary user > of the e-mail address to which it was addressed and may also be > privileged. If you are not the addressee of this e-mail you should > not copy, forward, disclose or otherwise use it or any part of it > in any form whatsoever. If you have received this e-mail in error > please notify us by telephone or e-mail the sender by replying to > this message, and then delete this e-mail and other copies of it > from your computer system. Thank you. > > We reserve the right to monitor all e-mail communications through > our network. > > -- > 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 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > ___ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented > are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have > received this > email in error and that any use, dissemination, forwarding, printing, > or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the > SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > ___ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >
RE: Session_wait
t glance, though, you don't appear to be I/O throttled but likely have inefficiencies in buffer cache. Pin some small tables? Reexamine access paths for fts, even if on "small" tables (generally defined to be around 5% in blocks of buffer cache size?)and consider seeking out and destroying nested loops joins in favor of hash joins. There's more CPU, but less buffer cache splashing arounddon't forget to review init.ora settings for hash, buffer pools, and query planning. (...be happy to do a flyover of those as well, if you like.) That's about all i can get in a one minute glance, but there are alot of people on the list who'll see more. Look to them for longer posts with more explanation. Good Luck! - Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___________ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance Tuning
Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P & O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need some help PLEASE on an ora 3113 in svrmgrl
Bill, I think u have some hung shared memory segments which need to b cleaned up before u can start ur instance. Do the following : At the Unix prompt, type : $ ipcs -mobs Then identify the segment id which has Owner = Oracle and Nattch = 0. Remove that segment using the following command : $ ipcrm -m Start up the database. Hope this helps. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 28 January 2002 21:42 To: Multiple recipients of list ORACLE-L Hi All, i am running oracle 8170 on solaris 7, i had a problem shutting down oracle and ended up having to do a shutdown abort. i reboot the server to clean everything up and when i tried to restart the db i get the ora 3113 inside of svrmgrl. There are 2 other db that start up fine. It creates a 20m core file and there are no errors in the alert log, listener log, sqlnet log etc and no trace files. Any help would be greatly appreciated!! i am lost been looking around metalink for hours and can't find anything useful. Thanks, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: COPY vs. OCOPY on NT
; > > installations/sites > > > (the number keeps growing). > > > From time to time, our field engineers are bringing back to me > sets > > > of > > > online (can not use "cold" backup - our systems should run 24*7, > I'm > > > not > > > saying they are, but we are trying to minimize downtime) backed > up > > > files (db > > > files and archived RedoLog files), and I recover them with no > problem > > > (we > > > need this, to test how the upgrade to next release of our product > > > will run > > > against "real" customers data). > > > > > > Now, about MetaLink Note:139327.1 > > > It says: > > > > > > Ocopy opens the file using CreateFile() with the FILE_SHARE_READ > and > > > FILE_SHARE_WRITE flags. This allows writing to continue while we > > > take the > > > backup. Inconsistencies in the backup are repaired by applying > > > archived > > > redo during recovery. The 'copy' command from NT doesn't use > these > > > flags > > > since it wants to prevent writes to the file while the copy is > > > taking > > > place. > > > > > > > > > I don't think, it's very accurate, and here is why: > > > When during online backup I run "NT copy" against db file, the > file > > > is > > > already opened by Oracle (at moment, when I "open" the database). > > > So, even if "NT copy" opens file without FILE_SHARE_READ and > > > FILE_SHARE_WRITE flags, all it means is that "Subsequent open > > > operations on > > > the object will fail" (quote from NT docs). I want you to > notice, it > > > says > > > "Subsequent open operations" not "Subsequent write/read > operations". > > > So, > > > all it does is prohibiting some other program/process from > "opening" > > > the > > > file. But Oracle, as I mentioned, has this file already opened, > and > > > it is > > > perfectly capable of reading/writing this file. > > > Of course, the image of the saved file will be "fuzzy", and > that's > > > why when > > > recovering from online backup we are applying archived RedoLog > files > > > (which > > > getting written much more intensely during online backup). > > > > > > > > > And yes, I agree about Oracle (un-)support. > > > > > > Igor Neyman, OCP DBA > > > [EMAIL PROTECTED] > > > > > > > > > - Original Message - > > > From: "Thomas B. Cox" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Cc: <[EMAIL PROTECTED]> > > > Sent: Friday, January 25, 2002 3:38 PM > > > Subject: Re: ORACLE-L Digest -- Volume 2002, Number 025 > > > > > > > > > > > > > > Could one of you forward this to your list? I'm not a > subscriber. > > > > > > > > Also, I'm very curious if Igor can recover from his COPY hot > > > > backups, and if so, whether Oracle Support might actually be > > > > wrong. > > > > > > > > If nothing else, one might want to use OCOPY in order > > > > to get Oracle support in the case something goes wrong. I > > > > doubt they'd be able to help if one used an unsupported backup > > > > approach... > > > > > > > > Thanks. > > > > -Tom > > > > > > > > --- "Thomas B. Cox" <[EMAIL PROTECTED]> wrote: > > > > > > > > > > I gave the right advice for the wrong reasons. My bad. I'll > > > revise > > > > > the next release of the paper and credit Igor -- thanks. > > > > > > > > > > Here's the word from Oracle Support: > > > > > > > > > > > > > > > Doc ID: Note:139327.1 > > > > > > > > > > The Differences between Windows NT COPY and Oracle OCOPY When > > > Doing > > > > > Backups: > > > > > > > > > > > > > > > == > === message truncated === __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SCOTT/TIGER
Whats all this about a cat (they hardly make good pets) I definitely heard from 'reliable sources' that Tiger was Scott's dog.and a German Shepherd at that !! Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 23 January 2002 18:46 To: Multiple recipients of list ORACLE-L well I've heard several versions of this. all of them agree that Scott was one of the early developers but tiger has been variously attributed to: scott's girlfriend's cat scott had a stuffed tiger on his desk larry walking by and saying "make it tiger" --- [EMAIL PROTECTED] wrote: > Yes. Scott was an early developer of the Oracle DB and > Tiger was the name of his girlfriend's cat. Or so the > story went when I worked for Oracle. > > Ken > > Anyone out there know the history of this? > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mohan, Ross > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > -- > 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 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dropped datafile problem
You have gone about a totally wrong way of dropping the datafile. To drop a datafile from a tablespace, u have to export the tablespace by taking a series of user exports in that tablespace, dropping the tablespace, deleting the datafile at the OS level, recreating the tablespace with the proper datafiles and importing back the contents of the tablespace. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 January 2002 14:40 To: Multiple recipients of list ORACLE-L Dear gurus ! I have an "offline dropped" datafile at my database. The file was physically deleted at the OS level after "offline drop". Before dropping the file , all the objects that had extents allocated in that file (from dba_extents) were dropped. Now , V$datafile shows this file as of size=0 and status = 'RECOVER' which is fine. BUT , file$ show this file as of size 8GB, which is the file size as it used to be before being dropped. Moreover , fet$ shows 8GB as free extents residing at this file . And , after all , tables get created in that file , i.e. dba_extents show extents with FILE_ID of that file ! When a select statement tries to access a table with extents residing in that file , i get an error message , off course. So , the question is , how do i make the file's extents disappear from fet$ ? Thanks a lot. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ftp command
At the ftp prompt, type the wordpromptin the following way : ftp> prompt Hope this helps, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 January 2002 14:55 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
Well, it is much better than standard SQL*Plusgives u a lot of GUI options and other functionalities. For that matter, most of the products of Quest Software are quite good..especially their performance monitoring tools. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 14 January 2002 12:00 To: Multiple recipients of list ORACLE-L Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup job of archives files won't start
RMAN of course connects to the target database while taking a backup. In the backup process, it takes a snapshot of the current controlfile and then takes the backup of the controlfile. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 11 January 2002 14:20 To: Multiple recipients of list ORACLE-L Hi Bruce, At 09:40 PM 1/10/02 -0800, you wrote: >Hi Jose, > >For the archive backup, are you able to answer the following: >Does the RMAN process connect to the target database? >If not, what is in the listener log file? Does not connect, I think, because the job seats on the active job window with scheduled status and I checked the listener.log, and listener.trc, and are not showing any info about the job connecting to the database. >Does the RMAN process then connect to the RMAN catalog? >If not, what is in the listener log file? >What is the RMAN process on the target waiting on - check v$session_wait I checked the table but I don't know what field you are asking for >What is the RMAN process on the catalog waiting on - check v$session_wait I checked the table but I don't know what field you are asking for >Does OEM show the job as scheduled or only as submitted? scheduled, but this job was created to run immediately >Does OEM get to showing the job as started? no, only as scheduled, and I left in purpose the job from last night, and it was created to run immediately >On your target node, does a file get created in the ?\network\agent\jobout >dir? no file >If so, what is the contents of the file? no file >Does the directory you are trying to backup the archives to exist? Yes >Is the backup drive full? No, lots of space Thanks for your help in advance. Jose >Some answers to some of the above will help diagnose. > >Bruce Reardon > >-Original Message- >Sent: Friday, 11 January 2002 8:15 > >Help on this one Guys!!! > >I have a backup job where I only select the archives, it submits the job, >but It won't run it at all, I am doing this in Oracle's OEM my version is a >Linux Oracle 8I >, Linux ver 6E, I can summit other type of backup jobs, entire, datatables, >image backup, but this one won't even run, it only displays it on the >backup active jobs panel. >Thanks in advance for your help. > >Jose >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Reardon, Bruce (CALBBAY) > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
Database block changes
Hi all, Can anybody help me with how to know that the data blocks in a particular database have changed since a particular time ?? Thanks, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: The OCP bar is being raised
Title: Message H...so all we have to do is appear for 2 exams and get OCA and then appear for the remaining 3 exams and upgrade ourselves to OCP...or do we need to take all the 5 exams all over again ?? Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Bowes, Chris [mailto:[EMAIL PROTECTED]]Sent: 10 January 2002 15:35To: SARKAR, Samir; '[EMAIL PROTECTED]'Cc: Bowes, ChrisSubject: RE: The OCP bar is being raised From the website: --To become an Oracle Certified Professional, you must pass all required exams --in your selected job role, including those at the Associate level. The way I read that, you have to have the OCA exams before you can get the OCP. So if you take and pass the OCP, until you pay for and pass the OCA, you cannot get the OCP certificat and recognition and you cannot even take the OCM. --Chris -Original Message-From: SARKAR, Samir [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 10:28 AMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: The OCP bar is being raised Chris, Am not clear on this. To b an OCP, we require to pass 5 examsright ?? So, if we get the OCP Associate after passing 2 exams, we need to pass only another 3 exams for getting OCP or do we have to go through all the 5 exams all over again ?? I think we can directly sit for the OCP tests though instead of going through the OCA. But to get the OCP Master, we will necessarily have to b a OCP. Do correct me if I am wrong though. Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Bowes, Chris [mailto:[EMAIL PROTECTED]]Sent: 10 January 2002 15:05To: Multiple recipients of list ORACLE-LSubject: RE: The OCP bar is being raised I'd say the cost is being raised. Look at the requirements for each. You can't just take the OCM exam. No we would first have to get the OCA. Whether or not we need the entry level cert we have to have it. Then, and only then, can we take the OCP. Then and only then, can we take the OCM and that is after we take these REQUIRED classes from Oracle Ed. So someone the caliber of Steve Adams or Jared Still, has to spend money in a class that they could probably teach from memory before they can get certification and that is after getting 2 other certs that have no value to them. Call me a cynic, but to me, this is nothing but a money grab. From the website: --To become an Oracle Associate, you must pass the exams required -- for the Oracle Associate level of your selected job role. Typically, --two exams are required; the first one can be taken via the Internet, --while subsequent exams must be taken in a proctored environment. By --completing your Oracle Associate, you are half-way toward achieving the -- Oracle Certified Professional credential. --To become an Oracle Certified Professional, you must pass all required exams --in your selected job role, including those at the Associate level. --To become an Oracle Certified Master, you must first be an Oracle --Certified Professional. Additionally, achieving your OCM credential --requires attending two advanced level Oracle University courses from --the list shown on this page as well as passing the OCM Practicum exam. --Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 9:16 AM To: Multiple recipients of list ORACLE-L Subject: The OCP bar is being raised Anyone care to comment on the following, IMHO it's about time: --- Introducing two new levels of Oracle Certified Professional (OCP) Achievement A recent *IDC report on IT Education and Training Services quoted database professionals and network engineers as the fastest-growing areas of Professional Certification. And in an October survey from *crn.com on Certification, 58% of respondents said that it is very difficult to find qualified Oracle Certified Professionals-Databa
RE: The OCP bar is being raised
Title: RE: The OCP bar is being raised Chris, Am not clear on this. To b an OCP, we require to pass 5 examsright ?? So, if we get the OCP Associate after passing 2 exams, we need to pass only another 3 exams for getting OCP or do we have to go through all the 5 exams all over again ?? I think we can directly sit for the OCP tests though instead of going through the OCA. But to get the OCP Master, we will necessarily have to b a OCP. Do correct me if I am wrong though. Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Bowes, Chris [mailto:[EMAIL PROTECTED]]Sent: 10 January 2002 15:05To: Multiple recipients of list ORACLE-LSubject: RE: The OCP bar is being raised I'd say the cost is being raised. Look at the requirements for each. You can't just take the OCM exam. No we would first have to get the OCA. Whether or not we need the entry level cert we have to have it. Then, and only then, can we take the OCP. Then and only then, can we take the OCM and that is after we take these REQUIRED classes from Oracle Ed. So someone the caliber of Steve Adams or Jared Still, has to spend money in a class that they could probably teach from memory before they can get certification and that is after getting 2 other certs that have no value to them. Call me a cynic, but to me, this is nothing but a money grab. From the website: --To become an Oracle Associate, you must pass the exams required -- for the Oracle Associate level of your selected job role. Typically, --two exams are required; the first one can be taken via the Internet, --while subsequent exams must be taken in a proctored environment. By --completing your Oracle Associate, you are half-way toward achieving the -- Oracle Certified Professional credential. --To become an Oracle Certified Professional, you must pass all required exams --in your selected job role, including those at the Associate level. --To become an Oracle Certified Master, you must first be an Oracle --Certified Professional. Additionally, achieving your OCM credential --requires attending two advanced level Oracle University courses from --the list shown on this page as well as passing the OCM Practicum exam. --Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 9:16 AM To: Multiple recipients of list ORACLE-L Subject: The OCP bar is being raised Anyone care to comment on the following, IMHO it's about time: --- Introducing two new levels of Oracle Certified Professional (OCP) Achievement A recent *IDC report on IT Education and Training Services quoted database professionals and network engineers as the fastest-growing areas of Professional Certification. And in an October survey from *crn.com on Certification, 58% of respondents said that it is very difficult to find qualified Oracle Certified Professionals-Database Administrators. To meet this demand, we have recently introduced two new levels of professional achievement to DBAs (and soon to be released to Application and Java Developers worldwide): The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification requiring successful completion of two exams. The Oracle Certified Master (OCM) -- an advanced qualification for Oracle Certified Professionals (OCP), that requires students to take a practicum exam on-sitee at an Oracle University education center. Visit http://www.oracle.com/education/certification/news/index.html?certlevels.html for more information IDC, IT Education and Training, Sept 2001 crn.com, Certification: What's Hot, What's Not, Oct 2001 - -- 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 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individ
RE: CHAINED ROWS
Title: RE: CHAINED ROWS Thanks Jacques...forgot about the Index-organized tables. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: 08 January 2002 18:56To: Multiple recipients of list ORACLE-LSubject: RE: CHAINED ROWS If your chained rows are inside an Index-Organized table, be sure to read the Oracle manual on the "Analyze" command. There are two versions of the "chained-row" table, for index-organized tables you should create the "chained-row" table with universal rowids (head_rowid has datatype urowid). The "chained-row" table with universal rowids is the one named "...1.sql", i.e. has a 1 at the end of the file name. -Original Message- From: SARKAR, Samir [mailto:[EMAIL PROTECTED]] If Oracle 8i is ur current version, run the utlchain1.sql script available in ur ORACLE_HOME/rdbms/admin directory. This will create the chained_rows table for u. Now analyze the affected table using the command : analyze table list chained rows into chained_rows; Now when u select from the chained_rows table, u will get the rowid of all the rows that r chained in the table as head_rowid. The best way to deal with chained rows is to export the table's data, rebuild the table with a higher pctfree and import the data back. Otherwise, copy the chained rows into a temporary work table in the following way : create table as select * from where rowid in (select head_rowid from chained_rows where table_name = '' and owner_name = ''); Then delete the chained rows from the main table in the following way : delete from where rowid in (select head_rowid from chained_rows where table_name = '' and owner_name = ''); Next, re-insert the chained rows into the table : insert into table_name select * from ; Commit ur work. Remember to disable any foreign key constraints during the deletion stage and re-enable them again after re-insertion of the rows. This should eliminate most of ur chained rows. -Original Message- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] I have seen that There are some number of chained rows in several tables of a schema in my database . What is it done in such a situation ? ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: CHAINED ROWS
If Oracle 8i is ur current version, run the utlchain1.sql script available in ur ORACLE_HOME/rdbms/admin directory. This will create the chained_rows table for u. Now analyze the affected table using the command : analyze table list chained rows into chained_rows; Now when u select from the chained_rows table, u will get the rowid of all the rows that r chained in the table as head_rowid. The best way to deal with chained rows is to export the table's data, rebuild the table with a higher pctfree and import the data back. Otherwise, copy the chained rows into a temporary work table in the following way : create table as select * from where rowid in (select head_rowid from chained_rows where table_name = '' and owner_name = ''); Then delete the chained rows from the main table in the following way : delete from where rowid in (select head_rowid from chained_rows where table_name = '' and owner_name = ''); Next, re-insert the chained rows into the table : insert into table_name select * from ; Commit ur work. Remember to disable any foreign key constraints during the deletion stage and re-enable them again after re-insertion of the rows. This should eliminate most of ur chained rows. Hope this helps. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 08 January 2002 13:36To: Multiple recipients of list ORACLE-LSubject: CHAINED ROWS I have seen that There are some number of chained rows in several tables of a schema in my database . What is it done in such a situation ? Thank you Bunyamin ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: A Simple Rollback Segment Question
When the database is created, the SYSTEM rollback segment is created automatically. The only available tablespace after database creation is the SYSTEM tablespace. We will need to obviously create more tablespaces including the rollback segment tablespace. The second rollback segment is created to create the other tablespaces since we do not want the SYSTEM rollback segment to b used while creation of the other rollback segments. Obviously, the second rollback segment has to b created in the SYSTEM tablespace since it is the only available tablespace to us immediately after database creation. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Naveen Nahata [mailto:[EMAIL PROTECTED]]Sent: 08 January 2002 09:50To: Multiple recipients of list ORACLE-LSubject: A Simple Rollback Segment Question Hello people,This one is from Oracle Manual: "In general, after database creation, you should create at least one additional rollback segment in the SYSTEM tablespace. " I can understand that you should create one additional rollback segment after database creation b'coz otherwise oracle will use the SYSTEM rollback segment and this may lead to fragmentation in the SYSTEM tablespace and also a performance degradation. But why is one additional rollback segment needed in SYSTEM TABLESPACE? TIA \\\|/// \\ - - // ( @ @ )+--oOOo-(_)-oOOo--+|Naveen Nahata| Off: Churhcill SSI| 89 SVR Complex| Hosur Road | Madiwala,Bangalore - 560068| INDIA.| Work: (9180) 5535005|&n! ! ! bsp; Ext - 111| Home: (9180) 6685754| E-mail: [EMAIL PROTECTED]+-Oooo---+ oooO ( ) ( ) ) / \ ( (_/ \_) Do You Yahoo!?Send FREE video emails in Yahoo! Mail. ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: Becoming a DBA questions
ng list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _______ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Mark.u have to send the mail to [EMAIL PROTECTED] with the message SET ORACLE-L NOMAIL to temporarily suspend mail from the list. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 December 2001 10:05 To: Multiple recipients of list ORACLE-L SET ORACLE_L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rama Velpuri's 9i Backup and Recovery Book Available?
message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Merry Christmas
Hi everybody on the list !! Am going on my holidays today evening and shall b back in the New Year. Wish you all a merry and drunk (for some) Christmas and a very happy and database problem-free New Year !! Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rama Velpuri's 9i Backup and Recovery Book Available?
Personally speaking I think that it is one of the best books available on Backup and Recovery.the case studies at the end of the boom r pure gems. I have the Oracle 8 edition and the concepts r very clearly explained esp. Media Recovery the concepts of which r still not very clear to many DBAs. Do get the book cos it is a sure keeper..I dont think there is a 9i Backup and Recovery book yet available. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 December 2001 19:31 To: Multiple recipients of list ORACLE-L Hello, One of the DBAs here thinks that it is ok, esp. if you need material on using RMAN (we do not). Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 20, 2001 1:10 PM To: Multiple recipients of list ORACLE-L > I am thinking of buying Rama Velpuri's book, 'Oracle 8i Backup and > Recovery'. Can anybody tell me if this is still considered to be one of > the best Oracle Backup and Recovery books available? Before buying the 8i > version of this book, can anybody tell me if there is a 9i book available? > Or if there are plans to produce a 9i version of the book and when it > might be available? > Thanks, > Sam. > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ora-1555
Thanks a bunch, Gopalakrishnan Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 17 December 2001 11:45 To: Multiple recipients of list ORACLE-L www.evdbt.com Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- Sent: Monday, December 17, 2001 2:40 AM To: Multiple recipients of list ORACLE-L Hi list, Could anybody tell me on which site shall I find Tim Gorman's paper "Cats, Dogs and ORA-1555" ?? Thanks, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ora-1555
Hi list, Could anybody tell me on which site shall I find Tim Gorman's paper "Cats, Dogs and ORA-1555" ?? Thanks, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed tablespaces
Hi John, Thanks so much for ur advice.never knew about that procedure before. By the way, could u please tell me what do the allocation_unit, relative_fno within the paranthesis mean ?? Or could u just give me a document link where I can read more about this procedure ?? Regards, Samir Samir Sarkar< BR>Oracle DBA - LennonT eam SchlumbergerSema Email : [EMAIL PROTECTED] s [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: orantdba [mailto:[EMAIL PROTECTED]]Sent: 14 December 2001 15:40To: Multiple recipients of list ORACLE-LSubject: Re: Locally managed tablespacesHiAny reason that this external consultant is not using the packagedbms_space_admin.tablespace_migrate_to_local procedure ??This would seem a much cleaner method of doing this than the method they are recommending.From the plsql supplied reference. TABLESPACE_MIGRATE_TO_LOCAL Procedure Use this procedure to migrate the tablespace from dictionary managed format to locally managed format. Tablespaces migrated to locally managed format are user-managed. SyntaxTABLESPACE_MIGRATE_TO_LOCAL(tablespace_name, allocation_unit, relative_fno) Hope this helps,John[EMAIL PROTECTED] wrote: I have just heard today that an external consultant, who is coming toupgrade software for our Student Records system next week, wants to unloadthe live, test and training databases, and recreate them using locallymanaged tablespaces.I've been reading all the incredibly positive things oracle have to sayabout this, but has anybody any real experience of using locally managedtablespaces, and if so, are there any major disadvantages or knock-oneffects that I should be aware of? Apart from trying to find disk space tounload each database to do this, would it have any additional spaceimplications?Basically, I need to decide if I should let this go ahead.Heather ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: Install of two client versions on same box
Title: Install of two client versions on same box Yes, u can but u will need to have two separate ORACLE_HOME, maybe one could be /u01/app/oracle/product/8.1.6 and the other /u01/app/oracle/product/8.1.7. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: 13 December 2001 15:10To: Multiple recipients of list ORACLE-LSubject: Install of two client versions on same box Hi! Is it possible to install two client versions (8.1.6 and 8.1.7) on the same Sun Solaris box? The reason for that is that we are using BEA Weblogic, which requires a specific Oracle client version and our application needs another one. Don't ask me about the sense behind it... This is 8.1.6/8.1.7 on Sun Solaris. Thanks, Helmut ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: which view used ?
By the way, there r x$ indexes too as there r x$ tables. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 13 December 2001 10:10 To: Multiple recipients of list ORACLE-L The v$ and x$ objects are views not tables, therefore they won't show up. HTH Mark -Original Message- Sent: 12 December 2001 20:50 To: Multiple recipients of list ORACLE-L Hi which view is used to see all tables in database?I think all_all_tables right? Including v$ and x$ tables Thanks -seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: which view used ?
Mark, The v$ objects r views but aren't the x$ objects tables ?? Do correct me if I am wrong. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 13 December 2001 10:10 To: Multiple recipients of list ORACLE-L The v$ and x$ objects are views not tables, therefore they won't show up. HTH Mark -Original Message- Sent: 12 December 2001 20:50 To: Multiple recipients of list ORACLE-L Hi which view is used to see all tables in database?I think all_all_tables right? Including v$ and x$ tables Thanks -seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standby Database - Log Shipping
Metalink Note : 120855.1 Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 12 December 2001 16:16 To: Multiple recipients of list ORACLE-L Does anyone know where I can find a paper on how to set up a standby database? I am talking about a database that is always in recovery mode and archive logs are applied throughout the day to keep it up to date. Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN - archive log files
Dennis, To perform media recovery using RMAN, it is necessary that u backup archived log files too since it is the key to a successful recovery. I suggest that u store the RMAN recovery catalog on a different machine cos if ur machine crashes thus crashing the database, ur RMAN catalog goes as well. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 11 December 2001 14:10 To: Multiple recipients of list ORACLE-L Must I have RMAN back up the archive log files? We are at the delicate position of getting acquainted with RMAN. We are using it but not yet ready to completely trust it, or rather trust that our setup is entirely correct (we production DBAs tend to be a conservative lot). We are just writing RMAN files to disk, no media manager. Needless to say, we are getting the disadvantages of both methods. In addition to the disk space taken up by the archive log files, I also have the disk space taken up by the RMAN archive log files, so I have used twice the amount of disk. If I didn't have RMAN store the archive log files, would it still be able to perform a recovery? Would it just grab the existing log files off disk? I'm thinking it must since it has to use some archive log files that were created since RMAN last ran. Appreciate your insights. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database down
Or check whether u have a large pool too..reduce the large_pool_size parameter. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 10 December 2001 20:16 To: Multiple recipients of list ORACLE-L There is not enough memory on the server to allocate the shared memory that the init.ora requires. Make you shared_pool smaller and try again. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 2:25 PM > ORA-27123: unable to attach to shared memory segment > SVR4 Error: 12: Not enough space > > Any ideas? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeff Wiegard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _______ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: truncate or drop
In my view a Truncate is always faster than a Drop. Also, the original table structures of the table r preserved. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 10 December 2001 16:40 To: Multiple recipients of list ORACLE-L Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Error opening the database
Hi Rao,
I tried the steps u mentioned. I get the following errors :
SVRMGR> recover database until cancel;
ORA-00279: change 3412601 generated at 11/30/2001 09:43:43 needed for thread
1
ORA-00289: suggestion :
/usr/local/oracle/admin/sid1/archive/60_0001.arc
ORA-00280: change 3412601 for thread 1 is in sequence #60
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/disk01/oradata/sid1/data/system01sid1.dbf'
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/disk01/oradata/sid1/data/system01sid1.dbf'
As I said, there is a block corruption on the physical disk as well. It
doesn't
show up with the alert log but it shows when we used the ufsdump utility.
The disk will have to be swapped and the filesystem recreated anyway, but I
was wondering
if there was anything I could do to open the database to take a full db
export since
it would be a lot easier for me to import the data after the database is
recreated.
The cold backup is no good since the /var/adm/messages file show that the
block corruption
occurred on 26/11/01 and the tapes r kept only for 7 days. However, I didnt
detect the bad
blocks cos the database was functioning normally until today.
Any other ideas ??
Thanks,
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018
-Original Message-
Sent: 04 December 2001 15:30
To: Multiple recipients of list ORACLE-L
Samir,
>From your mail, I assume the following :
1. You shutdown the database either through immediate or normal.
2. Now you are trying to open the database. At this point, you are getting
this error.
If the above is true, then, try the following.
1. Close the instance by issuing the command at svrmgrl --- Shutdown
immeidate (even though your database is not open, your instance would have
been created which you need to shut it down).
2. After successful close, come to the O.S. prompt, and then, delete all the
redo logs. <--- Imp. step.
3. Now, issue the following sequence of commands.
1. startup mount;
2. alter database recover until cancel;
3. Alter database open resetlogs;
The above last command would open the database and also would create the
redo logs.
Rao
-Original Message-
Sent: Tuesday, December 04, 2001 4:45 AM
To: Multiple recipients of list ORACLE-L
Hi folks,
On trying to open one of our development databases today morning, I get the
following
error :
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00333: redo log read error block 129347 count 1719
The database is 8.1.7 on Solaris and is running in NOARCHIVELOG mode.
Is this a case of redolog corruption ?? In that case, how do I recover the
database even if I restore
the previous backup since there r no archive logs (NOARCHIVELOG mode) ??
Any help would be greatly appreciated.
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.
If you have received this email in error please notify the SchlumbergerSema Helpdesk
by telephone on +44 (0) 121 627 5600.
___
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SARKAR, Samir
INET: [EMAIL PROTECTED]
F
RE: Error opening the database
Hi Rao, My database is running in NOARCHIVELOG mode. Would it still be possible for me to issue the 'recover database until cancel' command ?? I understand that this command applies all the archived logsbut since I do not have any archived logs, how will the database perform recovery ?? Thanks, Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 04 December 2001 15:30 To: Multiple recipients of list ORACLE-L Samir, >From your mail, I assume the following : 1. You shutdown the database either through immediate or normal. 2. Now you are trying to open the database. At this point, you are getting this error. If the above is true, then, try the following. 1. Close the instance by issuing the command at svrmgrl --- Shutdown immeidate (even though your database is not open, your instance would have been created which you need to shut it down). 2. After successful close, come to the O.S. prompt, and then, delete all the redo logs. <--- Imp. step. 3. Now, issue the following sequence of commands. 1. startup mount; 2. alter database recover until cancel; 3. Alter database open resetlogs; The above last command would open the database and also would create the redo logs. Rao -Original Message- Sent: Tuesday, December 04, 2001 4:45 AM To: Multiple recipients of list ORACLE-L Hi folks, On trying to open one of our development databases today morning, I get the following error : SQL> alter database open; alter database open * ERROR at line 1: ORA-00333: redo log read error block 129347 count 1719 The database is 8.1.7 on Solaris and is running in NOARCHIVELOG mode. Is this a case of redolog corruption ?? In that case, how do I recover the database even if I restore the previous backup since there r no archive logs (NOARCHIVELOG mode) ?? Any help would be greatly appreciated. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Error opening the database
Thanks Claudio.it has subsequently been detected that there is a bad media on the disk.the ufsdump utility confirmed thatit was the disk which was corrupted. We have logged a call with Sun and we might have to swap the whole disk and re-create the file systems. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 04 December 2001 12:45 To: Multiple recipients of list ORACLE-L first make a backup of the broken database, then try to use the init parameter _allow_resetlogs_corruption= true open the database and make an export. Let me know if you will win :-) by Claudio. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, December 04, 2001 10:45 AM > Hi folks, > > On trying to open one of our development databases today morning, I get the > following > error : > > SQL> alter database open; > alter database open > * > ERROR at line 1: > ORA-00333: redo log read error block 129347 count 1719 > > The database is 8.1.7 on Solaris and is running in NOARCHIVELOG mode. > > Is this a case of redolog corruption ?? In that case, how do I recover the > database even if I restore > the previous backup since there r no archive logs (NOARCHIVELOG mode) ?? > > Any help would be greatly appreciated. > > Samir > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 95 76217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018 > > > > ___ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have received this > email in error and that any use, dissemination, forwarding, printing, or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > ___________ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: claudio cutelli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Error opening the database
Hi folks, On trying to open one of our development databases today morning, I get the following error : SQL> alter database open; alter database open * ERROR at line 1: ORA-00333: redo log read error block 129347 count 1719 The database is 8.1.7 on Solaris and is running in NOARCHIVELOG mode. Is this a case of redolog corruption ?? In that case, how do I recover the database even if I restore the previous backup since there r no archive logs (NOARCHIVELOG mode) ?? Any help would be greatly appreciated. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Doubts reg :Export and import
nt to be removed from). You may > also send the HELP command for other information (like subscribing) -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Duplicating a Database and Changig SID
Same here Ron.will really appreciate it if u could send me the file at my email id as an attachment..I think the LIST doesnt support attachments..else, a text file will also help. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Prakriteswar Santikary [mailto:[EMAIL PROTECTED]]Sent: 30 November 2001 16:21To: Multiple recipients of list ORACLE-LSubject: RE: Duplicating a Database and Changig SID Ron, I was trying to open your attached document. I get this error: Could you pl. send this doc as .txt file to me ? I would really appreciate that. thanks Santi -Original Message-From: Ron Yount [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 7:41 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Duplicating a Database and Changig SID Sonja, Here are my rough instructions for how to duplicate a database (by copying files) and then how to alter the database name (typically referred to as "cloning" a database). At the end, you will find how to alter the dbid so that RMAN will see it as a new database. Be sure to bounce the instance as instructed. -Ron- -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja SehovicSent: Friday, November 30, 2001 3:11 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Duplicating a Database and Changig SID Yes, please, I'm very interested. Sonja -Original Message-From: Ron Yount [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 12:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Duplicating a Database and Changig SID If you are using RMAN and would like some direction on how to change the DBID as well, let me know and I will send you some directions/steps for that as well. -Ron- -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja SehovicSent: Thursday, November 29, 2001 5:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Duplicating a Database and Changig SID Hi! Before I tell you procedure, be aware that when you make a clone of your database DBID remains the same, which is a problem if you use RMAN for you backups. Steps are: 0. On your database issue: alter database backup controlfile to trace resetlogs; 1. Backup your database. 2. Shutdown database (shutdown immediate) 3. Copy all your datafile, logfiles, controlfiles to the new location 4. Edit your new init.ora file and change DB_NAME, DB_BLOCK_SIZE must be the same, change path for controlfiles, user_dump_dest, background_dump_dest, core_dump_dest 5. Edit your new controlfile (which you get in step 0) and change it in: CREATE CONTROLFILE REUSE SET DATABASE 'NEWSID' RESETLOGS and change the path of datafiles and logs 6. Recreate you control file. 7. Change your tnsnames.ora and sqlnet.ora files. This should do. I had no problems in doing that HTH, Sonja -Original Message-From: MRaval [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 7:55 PMTo: Multiple recipients of list ORACLE-LSubject: Duplicating a Database and Changig SID Hi Guys, I am newbie oracle DBA and want to duplicate my development database to Test database and want to change ORACLE_SID, Could anyone tell exact steps that I have to follow. My database is on SUN 5.6 and oracle 8.1.6. Thanks, ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and
RE: OCP tests
Title: RE: OCP tests Hi John, Thanks so much for ur reply. I visited ur website and had a good idea of what to look for towards preparing the exam and how to go about it. Also, the treatment of Logminer was very useful for me too. I do not much experience in PL/SQL too...in our setup, they r mostly considered as a developer's job and I hardly have to actually write long and complicated programs and the most I do is write a trigger or procedure here and there to help me with my DBA work. I guess I will face a hard time passing this part of the exam as well. I will b appearing for the 8i exams as I have mostly worked with 8i in my 4 years of experience as a DBA. My company will reimburse the cost of the exams too but only if I pass it :). I will b starting off preparing for the exams early next year, so I guess I will b appearing for the first exam (which of course will be the DBA Admin exam) some time in March or April..I have to find a convenient centre too since I am based in Nottingham. I will get the exam crams from Amazon but the 8i exam crams r not readily available on Amazon at the moment. Thanks again and I will let u know how I get along..am not really nervous about it but I find it hard to find time to actually sit down and study specially for an exam of this naturebut I will have to manage somehow.wish luck !! Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-From: Hallas John [mailto:[EMAIL PROTECTED]]Sent: 29 November 2001 08:40To: Multiple recipients of list ORACLE-LSubject: RE: OCP tests Hi Samir, I think the Exam Cram books from Coriolus are OK. They do not cover everything, they are slightly inaccurate sometimes but they compress and summarise what you need and they are relatively cheap (£21 UKP) compared with others. I have an article on my web site http://www.hcresources.co.uk which covers my foray into the OCP world. You may find it interesting (there again you may not... ). There are lots of resources on the web which are useful.The brainbuzz site has some good stuff as well in the cramsession pages http://.brainbuzz.com John -Original Message- From: SARKAR, Samir [mailto:[EMAIL PROTECTED]] Sent: 28 November 2001 15:31 To: Multiple recipients of list ORACLE-L Subject: OCP tests Tom, Am thinking of taking the OCP tests early next year..could u please suggest me a really good and comprehensive guide book for the same ?? There r quite a few of them available on Amazon but I am confused now as to which of these is really good. Thanks and Regards, Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copyi
OCP tests
Tom, Am thinking of taking the OCP tests early next year..could u please suggest me a really good and comprehensive guide book for the same ?? There r quite a few of them available on Amazon but I am confused now as to which of these is really good. Thanks and Regards, Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Crontabs and Oracle
ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___________ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: import
Before export issue the following command at the root prompt : NLS_LANG=AMERICAN_AMERICA.UTF8;export NLS_LANG Then do the export and import.import recognises the character set automatically. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 23 November 2001 13:40 To: Multiple recipients of list ORACLE-L Hello listers, > I have problem with character encoding during import using imp. > > Error code is ..> IMP-00016: > > required character set conversion (type 1 to 871) not supported . > > My question is : What is syntax for import with settings charset ? Database charaset is UTF8. Thanx Oto -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moucka otakar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is CKPT process is Mandatory in 8i
Mandatory starting with Oracle 8 Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 22 November 2001 14:55 To: Multiple recipients of list ORACLE-L Hi List, Today we had a big argument at our work place whether CKPT is Mandatory/Optional process in 8i. My contention is that it is an optional process. I am sure it was optional in 7.3 and later became mandatory in 8. Gurus, can you please clarify whether CKPT is a Mandatory or Optional process in 8i. TIA, Muths _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Metalink gone to sleep ?????
This is strange..I could not log into Metalink using the link metalink.oracle.com. But I could log in using the link oracle.com/support/metalink. Whats happening here, guysn and gals ?? Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 November 2001 12:10 To: Multiple recipients of list ORACLE-L OK, Let's do a poll. Someone else says they have access. Could it be the browser? I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in. I am going to try from one of the servers (IE 5.0) to see what the result is. [...] IE 5.0 SP2 --> no problem accessing MetaLink. So it could either be my NT Workstation, or MetaLink doesn't support IE6. Late last week I could access MetaLink, but I don't know if the LAN Services people here suddenly decided to push IE 6.0 on my workstation without telling me, will check. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Subject:RE: Metalink gone to sleep ? I can't get in. "Farnsworth, Dave"To: Multiple recipients of list ORACLE-L @Ashleyfurnitcc: ure.com> Subject: RE: Metalink gone to sleep ? Sent by: root 11/20/2001 10:00 AM Please respond to ORACLE-L I just connected with no problems. -Original Message- Sent: Tuesday, November 20, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Can't log in to Metalink today either...am getting the opening page but gives the 'Page temporarily unavailable' after that..anybody else sharing the same problem Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed fr
RE: Metalink gone to sleep ?????
Ok...got it now through another link.http://oracle.com/support/metalink Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 November 2001 16:15 To: Multiple recipients of list ORACLE-L No, I am working fine on metalink (from Italy). - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, November 20, 2001 3:45 PM > Can't log in to Metalink today either...am getting the opening page but > gives the > 'Page temporarily unavailable' after that..anybody else sharing the same > problem > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 95 76217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018 > > > > ___ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have received this > email in error and that any use, dissemination, forwarding, printing, or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > _______ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: claudio cutelli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Upgrade to Solaris 8
Hi, Could anybody tell me if I need to take any steps as regards my database when I upgrade my OS from 32-bit Solaris 7 to 64-bit Solaris 8 ?? This is version 8.1.6.3. Thanks and Regards, Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Metalink gone to sleep ?????
Can't log in to Metalink today either...am getting the opening page but gives the 'Page temporarily unavailable' after that..anybody else sharing the same problem Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Disk to Disk backups and RMAN
(858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Disk to Disk backups and RMAN
L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spell
RE: SQL query tuning problem
Title: Blank
Well Greg..I just ordered
the SQL Tuning book by Guy Harrison from Amazon
hope it is real good as u
recommend :)
Thanks and Cheers
!!
Samir Sarkar
Oracle DBA - Lennon
Team SchlumbergerSema
Email :
[EMAIL PROTECTED]
[EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418
Ext. 76217 Fax
: +44 (0) 115 - 957
6018
-Original Message-From: Greg Moore
[mailto:[EMAIL PROTECTED]]Sent: 08 November 2001
18:28To: SARKAR, SamirSubject: Re: SQL query tuning
problem
>> syntax for having multiple tables in the hint
/*+ full( a b ) */
Look in the Oracle documentation, in the Tuning Guide. There is a
complete chapter on Hints.
If you are interested in tuning, get Guy Harrison's book. It's
available on Amazon. It's one of the best Oracle books ever
written.
- Original Message -
From:
SARKAR, Samir
To: 'Greg Moore'
Cc: '[EMAIL PROTECTED]'
Sent: Thursday, November 08, 2001 2:04
AM
Subject: RE: SQL query tuning
problem
Greg,
Thanks a bunch for ur
detailed reply. I am trying out all the options enumerated by you and
I will hopefully get some
results.
I was doing a mistake with
the hint to disable indexes.I was using the table name instead of the
alias in the hint.
Could u please tell me the
syntax for having multiple tables in the hint ?? Tahat is, if I want
the query to run by
disabling the indexes in all the joined tables, what would the syntax be
??
Thanks
again,
Samir Sarkar
Oracle DBA - Lennon
Team SchlumbergerSema
Email :
[EMAIL PROTECTED]
[EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957
6418 Ext. 76217 Fax : +44 (0) 115 - 957
6018
-Original Message-From: Greg Moore
[mailto:[EMAIL PROTECTED]]Sent: 07 November 2001
20:09To: SARKAR, SamirSubject: Re: SQL query tuning
problem
Samir,
To disable an index, use the hint FULL in the SQL.
select /*+ full(e) */ ename, phone, address
from emp e
where ename = 'Smith'
This will cause a full table scan on the emp table (instead of using
an index). Note you must give the table an alias in the FROM clause,
and you must use that alias in the hint. Also, the hint must have no
errors. If it contains errors you won't get an error message.
So after putting in a hint, be sure to run an explain plan to see if your
hint worked. For the FULL hint, obviously, your explain plan should
show a full table scan and should not show use of an index.
The explain plan you sent is very interesting. The words "MERGE
JOIN (CARTESIAN)" are very interesting. Normally a Cartesian join is
a mistake, because the programmer forgot to include a join between two
tables in the WHERE clause. In your case, however, the tables appear
to be all properly joined.
Oracle enhanced the optimizer for data warehouses, where there is
usually one big table an many smaller ones. The smaller tables can't
be joined to each other, only to the large table. However, the most
efficient solution is for Oracle to first join all the small tables, and
since they can't be linked with primary and foreign keys, Oracle just does
a Cartesian join. This produces lots of results, but not too many
because the tables are all small. Then, for the last step, Oracle
finally joins the results from these small tables to the big table.
The idea is to put off dealing with the big table until the end, and
then only deal with it once. This is faster than joining each small
table to the big table, one at a time.
Although this was meant for data warehouses, sometimes Oracle will
create a plan like this simply because it sees that one table is very big
and the others are small. I think that is what is happening with
your SQL and explain plan.
I am sorry to report that even with the proper indentation, I cannot
fully understand your explain plan. It is simply different from what
I am used to seeing and I don't understand how a couple of the steps work
together.
I can, however, offer some ideas for things to try:
(1) Use timed_statistics=true and then run a trace and
TKPROF. Then look in the TKPROF report at the very left of the
explain plan. There is a column that says ROWS. Right now it
contains all zero's! This column has very useful information -- it
tells
RE: Disk to Disk backups and RMAN
Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora 24314 service handle not initialized
You need to migrate from 8.1.6 to 8.1.7 using the Oracle 8.1.7 CD and using the Installer and use the Database Migration Assistant or do the upgrade manually by running the u081060.sql script. That will do the migration for u. I prefer the manual method since it gives greaterf lexibility. Take a full backup of ur database on tape and also a full database export b4 doing the installation/upgrade. Stop ur listener and backup ur listener.ora, tnsnames.ora, sqlnet.ora, init.ora and the OraInventory directory. Create a new directory called 8.1.7 under /u01/app/oracle/product. In the Oracle .profile, set ur LD_LIBRARY_PATH and PATH to the new values. Change the oratab entries to 8.1.7. Also, change the ORACLE_HOME in the .kshrc file to reflect the new ORACLE_HOME. Then run the Installer and install the 8.1.7 database and run the above script and also the utlrp.sql script and check for INVALID objects after running the latter. Remember to set up a link between ur pfile and ur ORACLE_HOME/dbs directory since Oracle looks for the parameter file in the same. Modify ur listener.ora and sqlnet.ora entries to reflect the new ORACLE_HOME. Start up listenerthats it, u r on Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 16 November 2001 13:20 To: Multiple recipients of list ORACLE-L Hello all, I was working with an 8.1.6 DB and I needed to migrate to 8.1.7. As I was newbie (And i keep on being that) I copied all the files related with the DB (control, dbf..). I created a new DB with the same name and path as the 81.6 one and replaced its files with the one I saved previously. Maybe it´s a madness solution... My problem now is that I get the 'ora 24314 service handle not initialized' error. I have read something in metalink, note 122183.1, just the point in which it sais 'If the ORACLE_HOME points to the 8.1.7 software yet the database was created with 8.1.6 or 8.1.5, then this error can occur' is my problem. I don´t know how could I resolve it. Could somebody orient me? Or if you think it´s impossible to recover, please, tell me? A lot of thanks ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
