RE: Who are certified Oracle Masters?
Apology accepted. We had to do a lot of hard work to get those superman-style crystal shafts. Among the things we had to do the get the shaft: - Stand on a piece of masking tape on the stage - Not make fun of the OCM program while we were getting the award - Not make fun of any of the other honorary OCM recipients during the presentation - Act imporant and smarter than everyone else - Hold up our shafts for a publicity photo The OCM program was actually in its early testing phase at the time we got them. So in fact, the honorary OCMs are actually OCMBs: Oracle Certified Master Betas. :-) (Please don't kick me off the list!) The best thing I did with my OCM was get a visa to work in the UK, as I posess no other official qualifications that come close to the requirements. As for the bullfrog thing, my parents were made to believe that nobody would remember that song after 1973, and that I would not endure a life of people singing Joy to the World. Admittedly, this thread was the first time anyone has actually done it to me by email. Am I a bullfrog? Find me and see for yourself. Or you can hire me. I charge $15/hour for home repairs and construction, and $250/hour to open the database you trashed by accident. No free Oracle advice at the $15 rate. After 6.5 years, I have parted ways with Amazon, and am now doing stuff like tiling and home repairs for the still-employed DBAs. Thinking about moving to Madison WI or Iowa City. Anyone here from either of those places? I want to start an organic farm. Anyway contact me off list or on the OT list if you can give input on either of those two cities. -- Jeremiah "OCMB" Wilton http://www.speakeasy.net/~jwilton On Thu, 11 Dec 2003, Cary Millsap wrote: > I owe an apology whether I'm correct or not, because (1) I didn't really > *know* the answer (only what I've heard), and (2) it's really none of my > business anyway. So... even if my speculation were correct, all I've > done here is to propagate a rumor, which is what I'm trying to live my > professional life to teach people NOT to do. > > So, to the list, and to Rich, please accept my apology. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta > - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas > - Hotsos Symposium 2004: March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > > -Original Message- > Cary Millsap > Sent: Thursday, December 11, 2003 4:19 PM > To: Multiple recipients of list ORACLE-L > > The answer to your first question is "Correct." > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta > - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas > - Hotsos Symposium 2004: March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > > -Original Message- > Ryan > Sent: Thursday, December 11, 2003 3:59 PM > To: Multiple recipients of list ORACLE-L > > you mean niemic didnt actually have to take the test? It was just handed > to > him? who is jeremiah wilton? > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, December 11, 2003 4:09 PM > > > > IIRC, Tanel did the OCM as well, but I suspect most of the others on > > your list aren't prepared to waste their time attending OCP exams and > > courses just so they can get the OCM. :) > > > > There were some honorary OCM's announced when the program first > started > > (OOW2002?). From memory, Rich Niemic and Jeremiah Wilton are the only > > names that spring to mind from that group. > > > > Pete > > > > "Controlling developers is like herding cats." > > > > Kevin Loney, Oracle DBA Handbook > > > > "Oh no, it's not. It's much harder than that!" > > > > Bruce Pihlamae, long-term Oracle DBA > > > > > > -Original Message- > > Mladen Gogala > > Sent: Friday, December 12, 2003 7:54 AM > > To: Multiple recipients of list ORACLE-L > > > > I know only of Pete Sharman. Who are other Oracle Certified Masters on > > this group? I suspect Tanel to be one, as well as Steve Adams, Cary > > Millsap, > > Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti > > Deshpande. > > Am I correct? > > > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > INET: [EMAIL PROTECTED]
RE: when do you use v$statname?
On Wed, 26 Nov 2003, Hately, Mike (LogicaCMG) wrote: > v$statname is a lookup table for the statistic# that appears in v$sesstat > and v$sysstat. You use it in most queries on those tables unless you're > named Tanel and have memorised the statistic numbers. =) Remember Oracle likes to change around all the statistic#s with every major release. So if you write (or memorize) something that relies on the statistic# being permanently associated with a particular statistic, it will break (give results for the wrong statistic) as soon as you upgrade. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: 26 November 2003 13:24 > To: Multiple recipients of list ORACLE-L > > This view seems to be a smaller subset of v$sysstat? When is it useful? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Configuring multi-threaded server
You have to make sure the dispatchers are registered with the listener. Use "lsnrctl services" to make sure. The error you gave shows that they are not registered. If your listener is not on 1521, then the dispatchers won't know how to find it to register. You'll have to add the listener= atttribute to the mts_dispatchers parameter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 17 Nov 2003, Schauss, Peter wrote: > Oracle version 8.1.7 > AIX 4.3.3 > > I am trying to configure mult-threaded server on one of my development > databases. In my init.ora file, I set > > (mts_dispatchers="(address=(protocol=tcp))" > mts_servers=10 > > When I bring up the database, I can see the dispatcher and > servers. When I connect to the database with sqlnet, however, > it still gives me a dedicated server. > > I tried forcing the connection by putting (server=shared) into > the tnsnames.ora file on my client. Then I get: > > ORA-12520: TNS:listener could not find available handler for requested type > of > server -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: SQL*Loader and rollback segment
How about just committing every n rows, instead of trying to fit the whole thing into one transaction? This is why they have the ROWS= option on the command line and in the parameter file. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 15 Nov 2003, Stephane Faroult wrote: > [EMAIL PROTECTED] wrote: > > > > I have a problem loading data from flat file using SQL*Loader. The problem is > > unable to extend rollbacksegment. Is there a way to assign BIG rollback segment to > > SQL*Loader transaction? If not what is the work around to load huge volume of data > > without using TRUNCATE option? > > One work around might be to create a dedicated Oracle account with the > suitable rights (INSERT on the table to load) and to use a login trigger > to assign the rollback segment. > Another, and probably much better, way would be to have several sessions > running and parallel (and hopefully assign to different rollback > segments by Oracle). If your volume of data is really big, chances are > that you are loading into a partitioned table. If your input data had > the good taste of being made of several files, each one destined to a > separate partition, would be great. Perhaps some preprocessing is > required. Otherwise split your data file, be certain to have several > free lists to avoid contention, and there you go. > You may have to play with constraints, this is usually the price to pay > to do things in parallel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: ORA-4031 error help.
Well, you neet to check the full error, because otherwise there's no
way to tell if you are running low on shared or large pool.
The view that shows space usage in both places in v$sgastat. I
suggest you start looking there. Maybe your third-party application
doesn't use bind variables and is bloating the shared pool. You could
verify this by observing that the sqlarea component of the shared pool
is very large as seen in v$sgastat. If this is the case then you might
consider testing with cursor_sharing=force.
You could also count different versions of similar SQL from the
application by grouping sql_text in v$sqlarea by the first 30
characters or so. This assumes your problem is shared pool sqlarea
bloat. You could just be runnning out of space for MTS session heaps
in the large pool. You have to look at v$sgastat first.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 29 Oct 2003, [EMAIL PROTECTED] wrote:
> Hello List, Need some help in resolving ORA-4031 error message. We
> are using Lawson and for last few days users are getting ORA-4031
> error 2-3 times a day in LAWSON log files but there is no error
> message in alert log file or any trace file. Both shared pool and
> large pool is set to 1GB. Below is the current init.ora file. We are
> on Oracle 9202 and AIX 5.1, using MTS.
>
> # Miscellaneous
> COMPATIBLE=9.2.0
> DB_NAME=LAWSON
> DB_FILES=1500
> GLOBAL_NAMES=TRUE
> DB_BLOCK_SIZE=8192
> DB_CACHE_SIZE=1792M
> DB_KEEP_CACHE_SIZE=16M
> LARGE_POOL_SIZE=1024M
> SHARED_POOL_SIZE=1024M
> SGA_MAX_SIZE = 5G
> DB_FILE_MULTIBLOCK_READ_COUNT=8
> CONTROL_FILE_RECORD_KEEP_TIME=45
> CURSOR_SHARING=SIMILAR
> OPEN_CURSORS=750 # From Lawson--Raised from 500 to 750 10/24/03
> BACKGROUND_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/bdump
> CORE_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/cdump
> USER_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/udump
> TIMED_STATISTICS=TRUE
> CONTROL_FILES=("/appl/lawdb/oracle/data/db01/LAWSON/contrl_LAWSON_01.ctl",
>"/appl/lawdb/oracle/data/db02/LAWSON/contrl_LAWSON_02.ctl",
>"/appl/lawdb/oracle/data/db03/LAWSON/contrl_LAWSON_03.ctl",
>"/appl/lawdb/oracle/data/db04/LAWSON/contrl_LAWSON_04.ctl",
>"/appl/lawdb/oracle/data/db05/LAWSON/contrl_LAWSON_05.ctl")
>
> # Archive
> LOG_ARCHIVE_DEST=/appl/lawdb/oracle/archive_logs/LAWSON/
> LOG_ARCHIVE_DUPLEX_DEST=/appl/lawdb/oracle/archive_logs_2/LAWSON/
> LOG_ARCHIVE_FORMAT="ARC_LAWSON_%S.%T"
> LOG_ARCHIVE_START=TRUE
> # LOG_ARCHIVE_TRACE = 1
>
> # Distributed, Replication and Snapshot
> DB_DOMAIN=PHSOR.ORG
>
> # Pools
> JAVA_POOL_SIZE=0
>
> # Processes and Sessions
> # PROCESSES=800 Increased value per vendor JMK 6/09/03
> PROCESSES=1000
> SESSIONS=1140
> ENQUEUE_RESOURCES=8000
> TRANSACTION_AUDITING=FALSE
> REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
> FAST_START_MTTR_TARGET=1200
> SORT_AREA_SIZE=0
> HASH_AREA_SIZE=0
> UNDO_MANAGEMENT=AUTO
> UNDO_TABLESPACE=undo
> UNDO_RETENTION = 10800
> PGA_AGGREGATE_TARGET=1G
> WORKAREA_SIZE_POLICY = AUTO
> JOB_QUEUE_PROCESSES = 10
> LOG_BUFFER = 8192000# To reduce 'log file parallel write' wait event in
> v$system_event
> CURSOR_SPACE_FOR_TIME = TRUE
> SERVICE_NAMES=lawson_ax3202a
> LOCAL_LISTENER=lawson_ax3202a
> # Network Registration
> INSTANCE_NAME=LAWSON
> DISK_ASYNCH_IO = FALSE
> BACKUP_TAPE_IO_SLAVES=TRUE
> PARALLEL_THREADS_PER_CPU = 6
> PARALLEL_MAX_SERVERS = 6
> PARALLEL_MIN_SERVERS = 1
> DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=provicon)(PORT=5000))(DISPATCHERS=1)"
> MAX_DISPATCHERS = 3
> SHARED_SERVERS = 10
> MAX_SHARED_SERVERS = 50
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremiah Wilton
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: Shutdown takes 20+ minutes
I don't think using abort = corruption potential. If you have a cluster for high-availability, how can you afford to do a weekly bounce and cold backup (decidedly low-availability practices)? Why not leave it up and do online backups? If you absolutely must have a cold backup, then the [checkpoint] - abort - restrict - immediate sequence is the right one for you to be using. I realize you want immediate to work, but there are so many reasons that it can get stuck, it just doesn't seem to make sense to me to ever rely on it finishing in any kind of reasonable time. Among the many classic causes of slowness with IMMEDIATE are cleaning up lots of temp segments and rolling back one or more large transactions. Maybe look in to the DROP_SEGMENTS event or loko for large uncommitted transactions. Finally I believe there are events you can set in 8i to diagnose hanging IMMEDIATE. Why not just try a 10046 level 12 in your SYSDBA session when you are trying to shut down. Then you can tail the trace file in another window and see what wait events it is waiting on. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 22 Oct 2003, Tortorelli, Mary Jo wrote: > We do shutdown immediate as the standard weekly cycle/cold-backup of > this production db. The cluster failover is part of the procedure > and is a test - it's not a real failover. We don't want to > routinely shutdown abort and increase corruption potential if it's > not necessary. > > We want a clean shutdown for the backup and I'm trying to figure out > why it takes so long since it's messing up the fail-over test that > follows. > -Original Message- > Sent: Tuesday, October 21, 2003 7:24 PM > To: Multiple recipients of list ORACLE-L > > I bet you can get that 4 minutes down to 1 if you dispense with the > down/up/down and just do checkpoint/abort/failover/startup. > > Why bother with "immediate" for a cluster failover? Isn't it just a > waste of time? > > On Tue, 21 Oct 2003, Tortorelli, Mary Jo wrote: > > > An 8.1.7.4 production database on HP-UX 11.0 running Apps 11.5.7 takes long to > > shutdown and is causing cluster failover testing to time out. > > > > Upon shutdown immediate it takes 1-3 minutes for the DATABASE DISMOUNTED, DATABASE > > CLOSED, and Archival stopped messages in the alert log but then it takes another > > 15+ minutes for the ORACLE database shutdown message to return to sqlplus. During > > this time, a ps -ef shows no background or ghost database processes - only the > > sqlplus process. > > > > If a shutdown abort, startup restrict, shutdown is done after five minutes, the > > shutdown after the abort/startup takes 4 minutes total. > > > > Does anyone know what Oracle does between DATABASE CLOSED, ARCHIVE STOPPED and the > > ORACLE database shutdown message? Has anyone else run into this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Shutdown takes 20+ minutes
I bet you can get that 4 minutes down to 1 if you dispense with the down/up/down and just do checkpoint/abort/failover/startup. Why bother with "immediate" for a cluster failover? Isn't it just a waste of time? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 21 Oct 2003, Tortorelli, Mary Jo wrote: > An 8.1.7.4 production database on HP-UX 11.0 running Apps 11.5.7 takes long to > shutdown and is causing cluster failover testing to time out. > > Upon shutdown immediate it takes 1-3 minutes for the DATABASE DISMOUNTED, DATABASE > CLOSED, and Archival stopped messages in the alert log but then it takes another 15+ > minutes for the ORACLE database shutdown message to return to sqlplus. During this > time, a ps -ef shows no background or ghost database processes - only the sqlplus > process. > > If a shutdown abort, startup restrict, shutdown is done after five minutes, the > shutdown after the abort/startup takes 4 minutes total. > > Does anyone know what Oracle does between DATABASE CLOSED, ARCHIVE STOPPED and the > ORACLE database shutdown message? Has anyone else run into this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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 Logs Problem
On Sun, 3 Aug 2003, Naveen Nahata wrote: > This will reduce the updates and inserts to the Data-Dictionary tables since > in LMTs extent information is stored locally and not in Data-Dictionary I do not believe that there are real practical examples of this making any signifgicant difference. Dictionary management doesn't account for much redo at all, even in masively misconfigured environments. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Monday, August 04, 2003 11:59 AM > To: Multiple recipients of list ORACLE-L > > How come changing the TS to LMT would reduce the excessive Redo generation. > > -Original Message- > VIVEK_SHARMA > Sent: Monday, August 04, 2003 9:49 AM > > Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive > Redo generation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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 Logs Problem
Not only that, but the query shown will show redo generation for the entire life of a session. So if a daemon has been logged in for a long time but generating redo slowly, it can still look like the top redo generator. To do this in a purely analytical way, a delta of two selects from v$sesstat needs to be done. This is pretty easy in perl on in a spreadsheet even. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 1 Aug 2003, Tanel Poder wrote: > Hi! > > Statistic#'s vary between versions (and possibly platforms), so one should > use statistic names instead of numbers in scripts. > Statistic# 99 is "physical reads direct (lob)" in my test environment for > example. > > Tanel. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, August 01, 2003 6:49 PM > > > > Hi, > > you may be able to identify the sessions that are generating a lot of redo > > by running this query. It will list the amount of redo generated by eash > > session. > > > > select s.sid,s.value > > from v$sesstat s > > where s.statistic#=99 > > and s.value!=0 > > > > Cheers, > > Mike Hately > > > > > > > > -Original Message- > > Sent: 01 August 2003 10:34 > > To: Multiple recipients of list ORACLE-L > > > > > > Hi Listers, > > > > One of my remote Clients is facing a problem with Redo Logs. The Redo Logs > > and the Archive logs in turn have suddenly started to generate at an > > alarming Rate. This has suddenly started from the last 1 week without any > > changes to Database Configuration or any other system settings (as per > > client). > > > > Can anyone please help me and let me know all the reasons that could be > > responsible for this behavior. Any Help from u will be appreciated. > > > > Regards > > > > Munish Bajaj > > > > > > > > > > > > > > > > > > E mail Disclaimer > > > > You agree that you have read and understood this disclaimer and you agree > to be bound by its terms. > > > > The information contained in this e-mail and any files transmitted with it > (if any) are confidential and intended for the addressee only. If you have > received this e-mail in error please notify the originator. > > > > This e-mail and any attachments have been scanned for certain viruses > prior to sending but CE Electric UK Funding Company nor any of its > associated companies from whom this e-mail originates shall be liable for > any losses as a result of any viruses being passed on. > > > > No warranty of any kind is given in respect of any information contained > in this e-mail and you should be aware that that it might be incomplete, > out of date or incorrect. It is therefore essential that you verify all such > information with us before placing any reliance upon it. > > > > CE Electric UK Funding Company > > Lloyds Court > > 78 Grey Street > > Newcastle upon Tyne > > NE1 6AF > > Registered in England and Wales: Number 3476201 > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Hately, Mike (LogicaCMG) > > 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: Tanel Poder > 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 l
RE: Redo Logs Problem
Probably an application has started generating lots of changes, causing the jump in redo generation rate. The client needs to get a delta of each session's value for 'redo size' in v$sesstat when this is happening, then they can identify the culprit session. There is one bug that could cause this. Bug 2186174 is triggered under certain circumstances under 9.x if fast_start_parallel_rollback is set to TRUE. It causes instances to SPEW redo in a big way. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 1 Aug 2003, Whittle Jerome Contr NCI wrote: > >> This has suddenly started from the last 1 week without any changes to Database > >> Configuration or any other system settings (as per client). > > Clients lie. > > Jerry Whittle > ASIFICS DBA > NCI Information Systems Inc. > [EMAIL PROTECTED] > 618-622-4145 > > > -Original Message- > > From: Munish Bajaj [SMTP:[EMAIL PROTECTED] > > > > Hi Listers, > > > > One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the > > Archive logs in turn have suddenly started to generate at an alarming Rate. This > > has suddenly started from the last 1 week without any changes to Database > > Configuration or any other system settings (as per client). > > > > Can anyone please help me and let me know all the reasons that could be > > responsible for this behavior. Any Help from u will be appreciated. > > > > Regards > > > > Munish Bajaj > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
I use SQL*Plus running under emacs shell every day. It is my preferred way of: - Recording my sqlplus sessions so I can go back and search to see what I did - having an up-arrow comand history capability - Having line editing capability - editing SQL scripts in the same window where I am running - everything else I came to prefer emacs because it has capabilities far in excess of vi or any other unix editor. Because it is open source software, many people have contributed over the years, making the package extremely powerful. Also, I started on Vax/VMS edt and eve/tpu, which are more like emacs than vi. There is an emacs OracleSQL mode, but I don't use it. I just start emacs, META-X shell, then sqlplus... -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jul 2003, Orr, Steve wrote: > I agree with the developer vs. sysadmin generalization but this was not > meant to be a post about favorite editors... It's about whether anyone > has used or seen a SQLPlus "shell" running under emacs. Has anyone > "witnessed" SQLPlus running under a well-configured emacs session and > have impressions to share? > > The statistics I've heard are that 9 out of 10 SysAdmin/DBA's use vi. I > wonder what the breakdown is for Linux admins? Since emacs is easy to > implement I could see it gaining ground on Linux but sometimes old > dinosaur type SysAdmins are slow to evolve. :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Here comes Oracle10G
No, it's "G... another ORA-600." Or "G... it's down again." JW - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 8:59 PM > Kirtikumar Deshpande wrote: > > > > OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G > > > > Gee, it's not 'i' anymore ? > > Nope!! It's Capital G. > > > > G for God? > > No. It's Grid :) > > > > Enjoy.. > > - Kirti > > The first thing that comes to mind (as a commuter) is Grid...lock! I can see it now...New oracle error, "I'm sorry, but you can't get there from here." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Oracle Clinical
On Tue, 24 Jun 2003, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: > What's a DAB? Among the Hmong, a dab is an evil spirit thet makes mad things happen. For instance, a dab might hang out at a particular intersection and make fender-benders happen. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > > -Original Message- > > From: [EMAIL PROTECTED] > > > > what is Oracle Clinical. > > I saw some job advertisement Oracle Clinical DAB or programmer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: recreating a create database file
Not sure if this was already mentioned. You can hack up the result of this: alter database backup controlfile to trace; into an exact replica of the create database statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 17 Jun 2003, Jack van Zanen wrote: > Maybe not exactly what you are looking for, but > > > Start the GUI DBCA (NO don't shoot), go through the all the motions and at > the end choose generate scripts only. > > Jack > > > > > > > > -Original Message- > Sent: Tuesday, June 17, 2003 4:09 PM > To: Multiple recipients of list ORACLE-L > > > Good morning all, > > Somehow all of my scripts to create the databases on my 9i sandbox have > disappeared. Does anyone have a script or trick or something to recreate > these files? I could recreate them manually but I am somewhat of a time > crunch. > > Thanks in advance, > Ruth > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ruth Gramolini > 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: Jack van Zanen > 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: Jeremiah Wilton 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or
1. Join the 10i beta program 2. Convert your 9.2 datafiles using the cross-platform transportable tablespaces feature of a dummy 10i instance. ;-) Or... Back when one of our system swas at around 200M, we had a C program that dumped table data in parallel by rowid ranges, wrote the streams in SQL*Loader native format to named pipes that were being dd'd with large block sizes across a fast network, to several SQL*Loader processes on the other side using direct/unrecoverable. We ran several of these at a time. As soon as a table would finish we would kick off the index creation in parallel/unrecoverable mode. The goal was to get both the source and target hosts as close to 100% utilization as possible. This was Oracle 8.0.5, migrating Compaq Tru64 (DEC OSF to HP-UX 11 64-bit. The migration took 6 hours. It shouldn't have even taken that long, but we were clumsy in a few ways. There's a lot involved in a migration. Lots of dependencies and details to think about. I recommend repeated practice runs on test equipment before trying the real thing. There's a lot of blood to be squeezed out of this stone to get the time down and reliability up. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 9 Jun 2003, Goulet, Dick wrote: > Exp/imp of a 200GB database is possible, but I'd think the time required would be > the long pole in the tent. I'd say your looking at at least a 4 day weekend at best > and only if you used direct mode. Someone has hinted that you can simply move the > datafiles from one box to the other. Well I'd not loose the original system before > you prove that. My experience with database file from Solaris to HP-UX has been a > 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Saturday, June 07, 2003 7:29 AM > To: Multiple recipients of list ORACLE-L > .. > > > Hi all: > > We are considering migration of an Oracle eBusiness Suite 11.5.8 from > HP-UX 11.0 to Solaris9. > > I'd like to know if anyone has done this and how daunting the task is. > > Are there any 3rd Party tools which can help out? > > Coming to the conventional approaches: > > 1. What do you think of Export/Import of a 200 GB database? > 1a. How much time will it take? > 1b. Any strategies for cutting that down? > > 2. How does CTAS over dblink compare to Export/Import? > > 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to > Oracle datafiles on Solaris 9. If so we would just need to recreate the > control files on the target database and we are done. > > Any suggestions, pointers, words of wisdom are greatly appreciated... > > Thanks & Regards, > Sashi > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sashidhar Kondareddy > 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: Jeremiah Wilton 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: Chris: Thank you!
I have a bit of Oracle memorabilia but I probably won't be willing to part with it. Maybe the Oracle Museum should be virtual, with a registry of who has what archaic Oracle stuff. I have all the version 5 for DOS diskettes, which it sounds like you have as well. I tried running the installer in the DOS window on my Windows NT PC a couple years ago, and it only balked because I didn't have one of the designated PC brands. Not sure where I'm going to find a Leading Edge brand PC these days. I also have the "Oracle: The Complete Reference" for v.5 and v.6 by George Koch, which includes a variety of v.5 administration syntax (IOR WARM, etc.), and a wall-mountable full color picture of the author on the back looking very spiffy with the exception of needing a neck shave. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 4 Jun 2003, Jamadagni, Rajendra wrote: > Dang ... > > last Friday we threw away Oracle 6/7/8 disks and printed manuals ... Let me > see still ... > > Raj > > > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > > Reply-To: [EMAIL PROTECTED] > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Tue, 03 Jun 2003 14:19:44 -0800 > > > I have to tell you this, my friends: > > Today, a package arrived here in Maaloev on the oak table. It contained > Oracle version 5.1.C and 6.0 on 5.25'' diskettes. > > The sender was Chris G. from Nokesville, VA. > > This will go right into the Oracle Museum, and I hope to be able to let you > guys one day try to install version 5 on a DOS PC at some future conference. > > Chris - I owe you a case of beer or two. And your name will be forever saved > > in the Oracle Museum. > > Thank you. > > Mogens > > PS. Version 5 and 6 docs are most welcome, if anyone can live without them. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Need to Log on 2000 users
You mean 2000 concurrent sessions? Why do you need to use dedicated server? Normally, you would accomplish this with Shared Server. You will need 128Gb of memory for the PGAs alone. Or you can use swap, but get ready to wait. Even that will probably be so slow that the connections may time out, or background thread IPC will time out, bringing the instance down. This seems like a silly exercise. Whose idea is it? "Good luck with all that" -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Munish Bajaj wrote: > Hi Gurus, > > I am facing a problem. I need to log on 2000 users to my database via > dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced > server. > > Please guide me as to what all parameters need to be tuned to achieve the > same. > > The Server is a single CPU server with 3G RAM. > > I need just to logon 2000 users. This is a load test that I need to perform. > > Thanks to all > > Regards > Munish Bajaj > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Online index creation on 9.2
I see, you can't find ot the waits because you don't want to ruin the performance again on purpose. That makes sense! Online index rebuild has been problematic WRT the journal application phase (among other problems such as abandoned journal segments after cancel or failure) since it was introduced. On highly transactional systems, a variety of waits, mostly library cache related, can occur at the end of the index rebuild. Many more such problems are addressed (fixed) in 9.2.0.3 than were in 8.1.7. Unfortunately, you probably will need to hit this while doing a 10046 trace with waits in one of the application processes and the index rebuild. ALternatively, multiple systemstate or hanganalyze dumps, or even the output from a typical session's v$session_event or v$session_wait from the time of the slowdown would help support to ID what is actulally going on. Different systems access patterns are not alike enough just to say you have problem X based on your description. So management can either live with slowness due to indexes not being rebuilt for a long time, an outage to rebuild them in blocking mode, or another shot at the online rebuild to find the root cause and get it fixed for good. Or you can try to get it to happen under load on a test system. Hope this helps! -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Stephen Lee wrote: > > I appreciate the response. The questions here are not "Are there waits?" > Most obviously, there are. The questions flying around here are: We have > been doing this with no problems when the database was 8.1.7.4. Now we try > when the database is 9.2.0.3, and we don't just see waits, we see the thing > go right into the dirt. So question is, does 9.2.0.3 have "issues" with > online index builds on large tables in a large database? We have a TAR > going, and we are going to try to figure out a way we can get some > diagnostics going. There is no way management is going to allow us to do > this on the production database. It would have been nice if a big mess of > diagnostics had been running at the time. But it wasn't (other than > spotlight -- OK, I use _ONE_ GUI), and when you're up to your ass in > alligators, it's hard to think much about draining the swamp. I suspect > what we will try to find out is what type of transactions would be most > affected and get with the application people to see if we find some > correlation. > > > -Original Message- > > > > What are the wait events of the slowed sessions? > > > > What is the correspondence with v$session_longops phases for the > > rebuild? > > > > Really, the answer to 75% of the questions in this group is "look at > > v$session_wait." > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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: Jeremiah Wilton 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: Online index creation on 9.2
What are the wait events of the slowed sessions? What is the correspondence with v$session_longops phases for the rebuild? Really, the answer to 75% of the questions in this group is "look at v$session_wait." -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Stephen Lee wrote: > > On 9.2.0.3, I have experienced a problem with online index creation. When > creating indexes on what I suppose most would consider to be large tables > (with nasty, sharp, pointy teeth and a bad disposition), when Oracle is > doing its initial data gathering, sorting, slicing, and dicing in > preparation for the actual creation of the index, it appears that "normal" > access to the table -- and this includes selects which do not modify data -- > becomes severely reduced to the point that the application is no longer > usable. When Oracle finishes with its fact finding mission and begins to > build the index (as evidence by the appearance of a segment with a number > for a name), everything is OK again. We never had this problem with > 8.1.7.X. > > Is this a new "feature" of 9.2.0.3? Is there some new magic parameter that > needs to be set? Are we wearing the wrong grass skirts and/or incorrectly > performing our ritual sacrifice ceremonies? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - why shutdown so much???
On Fri, 4 Apr 2003, Darrell Landrum wrote: > I once read an article in an IT publication (several years ago) in > which the author stated that if you are still rebooting your Unix > servers routinely, your Unix admins don't know what they're doing. > Yes, the language was that harsh. > I thought this was ludicrous for 2 reasons: > 1) The author assumes no applications have memory leaks. (Uh, yeah!) Host boot should not be necessary to reclaim memory from an application that leaks memory. The process/processes that leak memory just need to exit or be killed for that. > 2) Users, developers, (even DBAs) make changes. Imagine a change made > which doesn't take affect until a shutdown. Now, imagine the next > shutdown 4 months later. Now, imagine that change broke something. > Finding the cause could be a perilous exercise. But that's not "routine," that's "as needed." If you have to boot to do something that you need to do, then booting is reasonable. I think the author must have been referring to routine reboots when nothing is actually wrong, or when the solution to the problem can be achieven by other means than shutting everything down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
Mark has hit on the crux of the issue. Most of us have expectations from users and management that we will have the databases available as much as possible. Downtime costs money and should be avoided. That said, we will eventually need downtime for one reason or another. The question becomes how do we minimize it. I use shutdown abort to increase availability. If you 'alter system checkpoint' before you shutdown abort, then automatic crash recovery is extremely fast, since only a few bytes of redo need to be applied. On the other hand, if you shutdown immediate, you may be waiting all day for those temp segments to get deallocated or for that large transaction to get rolled back. With abort, the deallocation doesn't have to happen (it was unnecessary anyway), and the rollback is deferred until after the database is open again and already available to users. So use your test systems, load them up like production, and try both. I bet in 9 out of 10 cases, checkpoint+abort+startup will be much faster than shutdown immediate+startup. Of course, there are cases when you need a consistent database while down. Switching to archivelog mode is one example. For those, checkpoint+abort+startup restict+shutdown immediate should do the trick. This may only be useful if you are running a system that is busy enough to have immediate take a long time. I don't know why I am such a tyrant on this issue. I guess I think it exposes fuzzy thinking. Yes I have driven to work many times without accidents, but comparing this to many succesful aborts is inaccurate. Cars are not designed in a fundamental way not to strike each other. People have to be careful when driving not to hit each other. Oracle, on the other hand, is fundamentally designed to start up after a shutdown abort. I have reason to expect that I may have an accident if I am not careful while driving. But so far, nobody has produced current bug numbers and issues or even solid reasoning that leads me to believe that using shutdown abort is "dangerous" or won't work consistently. If abort is more dangerous than immediate, can we get a list of other fully supported features of Oracle that are considered "dangerous?" We should call support and file a bug, no? It reminds me of instructions for doing something I once found on MetaLink: One of the steps read: "Start up the database carefully." -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 2 Apr 2003, Mark Richard wrote: > I don't think the issue is so much about whether Oracle recovery can handle > a database crash or not. I think the issue is whether you want to spend > the time of going through that process. I'm sure recovery can also handle > the server being powered cycled but how many people do that without > shutting down Oracle first? > > Since we had a car analogy already in this thread... I'm confident that > the seat belts in my car work but I'm in no rush to test them out, and even > if they do work I'm likely to end up bruised anyway. > > I guess the bruising my equate to overtime spent recovering the database... > Oh, I hate trying to make really good analogies. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
On Wed, 2 Apr 2003, GovindanK wrote: > Shutdown immediate does rollback and will take time if no.of users > is high. Number of users is not the largest contributing factor to shutdown immediate taking a long time. The longest poles in the tent are large transaction rollback and lazy temp segment deallocation. > On the otherside, shutdown abort simply takes the db down and does > not bother about anything else. As per manual, if you do a shutdown > abort then you WILL need the online redo logs for recovery just in > case. Do you know of anyone who does not have their online redologs? You pretty much need them or your database would have crashed a long time ago. > Think twice if your db is in NOARCHIVELOG mode. If your db is in > ARCHIVE mode make sure the logs are multiplexed. As has been pointed out, having multiplexed logs has nothing to do with archivelog mode. Furthermore there is no reason to be more careful about using abort if you are in noarchivelog mode. Crash recovery will not need any archived redologs, since it only needs those logs since the last checkpoint. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
On Wed, 2 Apr 2003, Chris Berry wrote: > Shutdown abort is pretty drastic, are you sure shutdown immediate > didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
On Wed, 2 Apr 2003, Stephen Murphy wrote: > We replace the simple shutdown command with: > > shutdown immediate > startup restrict > alter system switch logfile; > host sleep 10 > shutdown immediate Why do you do this elaborate dance? Are you trying to get the last logfile? If so, you should know that this combination of commands will not accomplish that. Any user with DBA priv can be in the database doing stuff and making transactions after your switch logfile and your shutdown immediate. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
What does this have to do with archivelog mode? In the bizarre scenario in which you lose a log between the time you shut down and started up, you are screwed with or without archivelog mode. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 2 Apr 2003, GovindanK wrote: > This topic is getting interesting once more. Lets contribute. > > >>Multiplexing redo logs has nothing to do with the archive mode. > > Take a situation wherein the db is in NOARCH mode with only one member per group > (default setup). The dba gives shutdown abort and upon starting for some reason the > active log could not be read for recovery. How would one perform a complete > recovery?. > > Let me know if you have a workaround. > > I am willing to learn. > > GovindanK > > -- > |XXX| > |You should treat others the way you want to be treated - Mahatma Gandhi| > |XXX| > > > "Daniel W. Fink" <[EMAIL PROTECTED]> wrote: > > >Multiplexing redo logs has nothing to do with the archive mode. Logs are > >multiplexed so that an error writing to one of the members in a group > >does not cause the instance to terminate. > > > >Myth - If you use disk mirroring, you don't need to multiplex your redo > >logs. > >Reality - Mirroring only protects from hardware failure. It will not > >protect you from accidental deletion of the log (been there, had to fix > >it!). > > > >-- > >Daniel W. Fink > >http://www.optimaldba.com > > > >GovindanK wrote: > > > >>>Shutdown abort is pretty drastic, are you sure shutdown immediate didn't > >>>work? > >>> Â Â > >>> > >> > >>Well said. This topic has been circulating in many DBA forums for a long time. > >>Shutdown immediate does rollback and will take time if no.of users > >>is high. On the otherside, shutdown abort simply takes the db down and > >>does not bother about anything else. As per manual, if you do a shutdown abort > >>then you WILL need the online redo logs for recovery just in case. > >>Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make > >>sure the logs are multiplexed. Â Though Oracle's recovery seems > >>to be sturdy, double check your backup & recovery strategies. Also, which option > >>to use is influenced by how much downtime/shutdown time you can afford. > >> > >>HTH > >> > >>GovindanK > >> Â > > > __ > Try AOL and get 1045 hours FREE for 45 days! > http://free.aol.com/tryaolfree/index.adp?375380 > > Get AOL Instant Messenger 5.1 for FREE! Download Now! > http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: GovindanK > 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: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
On Wed, 2 Apr 2003, [EMAIL PROTECTED] wrote: > Then, while bringing up, we do > > startup restrict; > shutdown immediate; > startup Why? Doesn't it start up fine the first time? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Which process is taking up so much CPU???
On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote: > Fermin >Add this line to your init.ora file. > timed_statistics = true >Then shutdown, startup your Oracle instance. I would hasten to point out that this parameter can be set dynamically using alter system from at least 8.1.x forward. Thus, restarting the instance is unnecessary and only reduces availability. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Friday, March 28, 2003 6:24 AM > To: Multiple recipients of list ORACLE-L > > I wonder where I should set TIMED STATISTICS = TRUE, if any of you > has the time to answer I'd be grateful, but I will look for it in the docs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Michael, Your split is no different from a very fast hot backup. So, it does not matter that the split is not atomic. Just use hot backup mode, and generate a binary controlfile using backup controlfile to 'file' and copy it to your destination. A the destination just recover the one or two logs generated while you did the split. Forget about suspend, it serves no purpose and is just decreasing your system's availability. BTW, your current hot-live copies of controlfiles are potentially invalid and totally unsupported. All that expensive equipment and you're suspending! Don't take the thing out of service unnecessarily! -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hand, Michael T wrote: > Jeremiah, > The only reason I could forsee is if the split is not atomic. This is the > case > in our (Non-SAN) environment. The split takes several minutes and the > control > files have been mis-matched when the DB copy was started on the reporting > server. > My solution under V8.0 was to use only one of the control files for > reporting > database. > > My $0.02 > Mike Hand > > -Original Message- > Sent: Wednesday, March 26, 2003 11:04 AM > To: Multiple recipients of list ORACLE-L > > > Why do you have to suspend? > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Wed, 26 Mar 2003, Hemant K Chitale wrote: > > > > > We want true server-less backups. I know that RMAN's overhead is [much] > lower > > than that of the ALTER TABLESPACE BEGIN/END BACKUP but the > > Snapshot method in a SAN [akin to splitting and resilivering a mirror, in > > some ways] > > should be much faster. The database is in BACKUP mode only for the time > it > > takes the SAN to create the Snapshot which, I've been told, is seconds or > > minutes, > > irrespective of the size of the database. [Of course, there will be some > > time lag > > between the first ALTER TABLESPACE BEGIN BACKUP and the > > ALTER SYSTEM SUSPEND command when the database will be doing a > > Checkpoint at each Tablespace, and writing more Redo for transactions upto > > the ALTER SYSTEM SUSPEND and will the END BACKUPs are still being issued.] > > > > And I cannot use RMAN with the Snapshot method. I must SUSPEND the > database > > and RMAN does not support that. > > > > See > > > http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/osba > ckup.htm#4233 > > "Making Backups in Suspend Mode" in Chapter 4 "Performing Operating > System > > Backups" > > of the 8i Backup and Recovery Guide. > > > > Hemant > > > > At 05:38 AM 26-03-03 -0800, you wrote: > > >Hemant - If you've got to rework your backup script anyway (and retest > it), > > >why not consider switching to RMAN at this time? In my experience, > > >negligible interference with production during a hot backup. > > > > > >Dennis Williams > > >DBA, 40%OCP, 100% DBA > > >Lifetouch, Inc. > > >[EMAIL PROTECTED] > > > > > > > > >-Original Message- > > >Sent: Tuesday, March 25, 2003 10:49 PM > > >To: Multiple recipients of list ORACLE-L > > > > > > > > > > > >Some of my databases will be migrating to a SAN. > > >Currently, I run hot backups to disk using the > > >ALTER TABLESPACE BEGIN BACKUP ; > > >host cp ; > > >ALTER TABLESPACE END BACKUP > > > > > >On a SAN, where the vendor promises server-less backups > > >using Snapshots, I guess I would have to issue the > > >commands : > > >ALTER TABLESPACE BEGIN BACKUP > > >.. > > >.. > > >ALTER TABLESPACE BEGIN BACKUP > > > > > >ALTER SYSTEM SUSPEND > > >> take a "snapshot" > > >ALTER SYSTEM RESUME > > > > > >ALTER TABLESPACE END BACKUP > > >.. > > >.. > > >ALTER TABLESPACE END BACKUP > > > > > > > > >Would that be right ? What are real-world experiences > > >[bugs / time required for the SUSPEND/RESUME, actually > > >flushing all I/O to the disks] ? > > > > > >The SAN will be a Hitachi 9970 sold by Sun. > > >The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. > > > > > >Hemant K Chitale > > >http://hkchital.tripod.com > > >-- > > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > > >-- > > >Author: Hemant K Chitale > > > INET: [EMAIL
RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Why do you have to suspend? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hemant K Chitale wrote: > > We want true server-less backups. I know that RMAN's overhead is [much] lower > than that of the ALTER TABLESPACE BEGIN/END BACKUP but the > Snapshot method in a SAN [akin to splitting and resilivering a mirror, in > some ways] > should be much faster. The database is in BACKUP mode only for the time it > takes the SAN to create the Snapshot which, I've been told, is seconds or > minutes, > irrespective of the size of the database. [Of course, there will be some > time lag > between the first ALTER TABLESPACE BEGIN BACKUP and the > ALTER SYSTEM SUSPEND command when the database will be doing a > Checkpoint at each Tablespace, and writing more Redo for transactions upto > the ALTER SYSTEM SUSPEND and will the END BACKUPs are still being issued.] > > And I cannot use RMAN with the Snapshot method. I must SUSPEND the database > and RMAN does not support that. > > See > http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/osbackup.htm#4233 > "Making Backups in Suspend Mode" in Chapter 4 "Performing Operating System > Backups" > of the 8i Backup and Recovery Guide. > > Hemant > > At 05:38 AM 26-03-03 -0800, you wrote: > >Hemant - If you've got to rework your backup script anyway (and retest it), > >why not consider switching to RMAN at this time? In my experience, > >negligible interference with production during a hot backup. > > > >Dennis Williams > >DBA, 40%OCP, 100% DBA > >Lifetouch, Inc. > >[EMAIL PROTECTED] > > > > > >-Original Message- > >Sent: Tuesday, March 25, 2003 10:49 PM > >To: Multiple recipients of list ORACLE-L > > > > > > > >Some of my databases will be migrating to a SAN. > >Currently, I run hot backups to disk using the > >ALTER TABLESPACE BEGIN BACKUP ; > >host cp ; > >ALTER TABLESPACE END BACKUP > > > >On a SAN, where the vendor promises server-less backups > >using Snapshots, I guess I would have to issue the > >commands : > >ALTER TABLESPACE BEGIN BACKUP > >.. > >.. > >ALTER TABLESPACE BEGIN BACKUP > > > >ALTER SYSTEM SUSPEND > >> take a "snapshot" > >ALTER SYSTEM RESUME > > > >ALTER TABLESPACE END BACKUP > >.. > >.. > >ALTER TABLESPACE END BACKUP > > > > > >Would that be right ? What are real-world experiences > >[bugs / time required for the SUSPEND/RESUME, actually > >flushing all I/O to the disks] ? > > > >The SAN will be a Hitachi 9970 sold by Sun. > >The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. > > > >Hemant K Chitale > >http://hkchital.tripod.com > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Hemant K Chitale > > 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: DENNIS WILLIAMS > > 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). > > Hemant K Chitale > My personal web site is : http://hkchital.tripod.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hemant K Chitale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list
Re: Shutdown Immediate hangs
1. Turn on PMON and SMON tracing for your instance and look at their trace files during shutdown 2. Look for segments of type TEMPORARY with many extents that need deallocating prior to shutdown - this will be done "lazily" during shutdwn immediate 3. Look for large transactions that need commit/rollback prior to shutdown 4. Look for which processes are still alive during the shutdown, use lsof to trace them back to the client app OR select a list of sessions and their respective processes prior to shutdown 5. Forget about shutdown immediate, use shutdown abort. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sun, 23 Mar 2003, DENNIS WILLIAMS wrote: > We have been running Oracle 8.1.6 unchanged for several years. Within the > past 3 days, our cold backup scripts have had a shutdown immediate hang. In > the alert log the message is: > > Shutting down instance (immediate) > Sun Mar 23 00:09:10 2003 > SHUTDOWN: waiting for active calls to complete. > > Normally the message is: > > Sun Mar 16 00:04:06 2003 > Shutting down instance (immediate) > Sun Mar 16 00:05:11 2003 > ALTER DATABASE CLOSE NORMAL > > Our immediate suspicion is that someone has implemented an application this > last week that connects to the database in a more active manner than we've > experienced before. Does anyone have any idea what I should look for (aside > from asking each developer: "What did you do last week?". Since 3 systems > have been affected, we are wondering if a process using a database link > could cause a problem like this. Any ideas appreciated. > > > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > 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: Jeremiah Wilton 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: Standby errors
Why does the copying of archive logs to the standby have anything to do with a hot backup on the primary? They seem like unrelated events. The reason you are getting an incomplete log is that you are using 'alter system switch logfile'. This command returns before archival, so your copy can commence and finish before archival is complete. The correct command to use is 'alter system archive log current'. This command will not return until the current log is fully archived. Than your copy can proceed safely. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 14 Mar 2003, Ball, Terry wrote: > Oracle 8.1.6 on Solaris 5.8. > > We have a read-only standby database for one of our production databases. > Each night, the standby is shutdown and the previous days archive logs from > production are applied. Then the database is brought backup in read-only > mode. To get the archive logs, a hot backup is done on the production > database. As the last step is the hot backup, a log switch is done and then > the archive logs are ftp'd to the server where the standby is. > > After the hot backup completed yesterday, the log switch occurred, and the > logs sent, but when an attempt was made to apply the archive logs we got an > error: > > ORA-00332: archived log is too small - may be incompletely archived > ORA-00334: archived log: '/orabackup/archive/TBSPRD/arch1352.arc' > ORA-332 signalled during: ALTER DATABASE RECOVER > > In looking at the archive log, both on the production and standby servers, > they are the same size - 16k (the block size for the db is 8k). The next > log is 8k in size and then there is another that is 16k before we see any > that are normal sized. These would have been the first logs _after_ the hot > backup the night before. > > In the alert log for the production db, it appears the log 1353 was archived > _before_ 1352. > > Has anyone seen this behavior before? Does anybody have any idea why it > happened in the first place? Is there something we can do to make sure it > never happens again? > > > P.S. We are upgrading to 9.2 this weekend, if that makes any difference. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: remote / as sysdba
Hi Bill,
My wife is from Marshfield, so I'll help you!
The documentation you want to look at starts at:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1167
Basically I think you need to create a paswordfile using orapwd and
set the REMOTE_LOGIN_PASSWORDFILE parameter.
HTH,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 6 Mar 2003, [EMAIL PROTECTED] wrote:
> env: Oracle 9.2.0.2 on Solaris 9.
>
> Does anyone know of a way to use the "/ as sysdba" logon remotely?
> (to a separate Oracle instance on a separate machine)
>
> Other remote user logons work OK.
>
> I have tried several variations from sqlplus, such as
>
> [EMAIL PROTECTED]>connect /@DWQ as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> [EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED]
> SP2-0306: Invalid option.
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> where ::= [/][@] | /
>
> [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED]
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> I also find I cannot even "connect sys/syspassword" locally:
>
> [EMAIL PROTECTED]>connect sys/sys_password
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> This does work locally, but not remotely:
>
> [EMAIL PROTECTED]>connect sys/sys_password as sysdba
> Connected.
>
> I am a member of the dba group on both platforms.
>
> I have verified that I am using the correct sys_password for sys
> on the remote instance.
>
> Eventually, I want to do a remote transportable tablespace import, where
> the userid would be listed in a parfile; I have tried the same logons in
> a parfile, and that also fails.
>
> I found a Metalink doc that says the O7_DICTIONARY_ACCESSIBILITY (sp?)
> must be true to do this, but the same doc strongly advises against setting
> this to true.
>
> So, has anyone found a way to use the "/ as sysdba" logon remotely?
> (without setting the O7 parameter to true)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremiah Wilton
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: Can't find orazht.msg file
I think it is looking for the Taiwan Chinese (BIG5) error file, which you don't have. If you change your NLS_LANG environment variable to something that is available in that directory, it will probably work. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 6 Mar 2003, [big5] shuan.tay\(PCI¾G¸R³Ô\) wrote: > Where can i download orazht.msg? > 'Cos when i issue 'oerr ora 1562', > it showed "Cannot find /home/oracle/product/8.1.6/rdbms/mesg/orazht.msg file." > > I'm using Oracle8.1.6 on Redhat7.2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: create control file failed
So the obvious question: What is the db_block_size and what is the size in bytes of /oradba/oradata/HTK443M8/audit_sis01.dbf as it was restored from backup? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 5 Mar 2003, BanarasiBabu Tippa wrote: > I am recreating the database from cold backup. But I am facing the following > problem > > Oracle version : 8.1.7 > Environment : HP > > SVRMGR> CREATE CONTROLFILE REUSE SET DATABASE "HTK443M8" RESETLOGS > ARCHIVELOG > 2> MAXLOGFILES 32 > 3> MAXLOGMEMBERS 2 > 4> MAXDATAFILES 254 > 5> MAXINSTANCES 8 > 6> MAXLOGHISTORY 29041 > 7> LOGFILE > 8> GROUP 1 '/oradba/oradata/HTK443M8/redo01.log' SIZE 500K, > 9> GROUP 2 '/oradba/oradata/HTK443M8/redo02.log' SIZE 500K, > 10> GROUP 3 '/oradba/oradata/HTK443M8/redo03.log' SIZE 500K, > 11> GROUP 4 '/oradba/oradata/HTK443M8/redo04.log' SIZE 500K > 12> DATAFILE > 13> '/oradba/oradata/HTK443M8/system01.dbf', > 14> '/oradba/oradata/HTK443M8/tools01.dbf', > 15> '/oradba/oradata/HTK443M8/rbs01.dbf', > 16> '/oradba/oradata/HTK443M8/temp01.dbf', > 17> '/oradba/oradata/HTK443M8/users01.dbf', > 18> '/oradba/oradata/HTK443M8/indx01.dbf', > 19> '/oradba/oradata/HTK443M8/admin_01.dbf', > 20> '/oradba/oradata/HTK443M8/bmpi_01.dbf', > 21> '/oradba/oradata/HTK443M8/cnc_01.dbf', > 22> '/oradba/oradata/HTK443M8/evnt_mast_01.dbf', > 23> '/oradba/oradata/HTK443M8/evnt_othr_01.dbf', > 24> '/oradba/oradata/HTK443M8/images_01.dbf', > 25> '/oradba/oradata/HTK443M8/lists_01.dbf', > 26> '/oradba/oradata/HTK443M8/matrl_01.dbf', > 27> '/oradba/oradata/HTK443M8/audit_sis01.dbf', > 28> '/oradba/oradata/HTK443M8/audit_sis_idx01.dbf', > 29> '/oradba/oradata/HTK443M8/matrl_use_01.dbf', > 30> '/oradba/oradata/HTK443M8/modules_01.dbf', > 31> '/oradba/oradata/HTK443M8/obs_01.dbf', > 32> '/oradba/oradata/HTK443M8/patients_01.dbf', > 33> '/oradba/oradata/HTK443M8/pdt_01.dbf', > 34> '/oradba/oradata/HTK443M8/personnel_01.dbf', > 35> '/oradba/oradata/HTK443M8/quality_01.dbf', > 36> '/oradba/oradata/HTK443M8/schedules_01.dbf', > 37> '/oradba/oradata/HTK443M8/script_01.dbf', > 38> '/oradba/oradata/HTK443M8/admin_idx_01.dbf', > 39> '/oradba/oradata/HTK443M8/bmpi_idx_01.dbf', > 40> '/oradba/oradata/HTK443M8/cnc_idx_01.dbf', > 41> '/oradba/oradata/HTK443M8/rbs1_01.dbf', > 42> '/oradba/oradata/HTK443M8/evnt_mast_idx_01.dbf', > 43> '/oradba/oradata/HTK443M8/evnt_othr_idx_01.dbf', > 44> '/oradba/oradata/HTK443M8/images_idx_01.dbf', > 45> '/oradba/oradata/HTK443M8/lists_idx_01.dbf', > 46> '/oradba/oradata/HTK443M8/matrl_idx_01.dbf', > 47> '/oradba/oradata/HTK443M8/matrl_use_idx_01.dbf', > 48> '/oradba/oradata/HTK443M8/modules_idx_01.dbf', > 49> '/oradba/oradata/HTK443M8/rbs2_01.dbf', > 50> '/oradba/oradata/HTK443M8/obs_idx_01.dbf', > 51> '/oradba/oradata/HTK443M8/patients_idx_01.dbf', > 52> '/oradba/oradata/HTK443M8/pdt_idx_01.dbf', > 53> '/oradba/oradata/HTK443M8/personnel_idx_01.dbf', > 54> '/oradba/oradata/HTK443M8/quality_idx_01.dbf', > 55> '/oradba/oradata/HTK443M8/schedules_idx_01.dbf', > 56> '/oradba/oradata/HTK443M8/script_idx_01.dbf', > 57> '/oradba/oradata/HTK443M8/interface_01.dbf', > 58> '/oradba/oradata/HTK443M8/drsys01.dbf', > 59> '/oradba/oradata/HTK443M8/quest01.dbf', > 60> '/oradba/oradata/HTK443M8/crystal_report_01.dbf', > 61> '/oradba/oradata/HTK443M8/crystal_report_idx_01.dbf', > 62> '/oradba/oradata/HTK443M8/interface_idx_01.dbf', > 63> '/oradba/oradata/HTK443M8/sisweb_01.dbf', > 64> '/oradba/oradata/HTK443M8/rules_engine_01.dbf' > 65> CHARACTER SET US7ASCII > 66> ; > CREATE CONTROLFILE REUSE SET DATABASE "HTK443M8" RESETLOGS ARCHIVELOG > * &g
RE: Duplicate online Database
Ofer, Are you suggesting that it is OK to copy an open database without using hot backup mode, as long as there isn't a log switch during copy? Do you use this method at your place of employment? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 4 Mar 2003, Ofer Harel wrote: > if the database is not heavy updateable, i.e., the switching of redo log is > rare, and the database is not too large, you can try this scenario: > 1. copy (operation system) all the datafiles, redo log, etc.. > you need to copied the hall database without a redo log switch in the > middle. > 2. Act with those files as its a hot backup > 3. Recover the database using a 'backup controlfile to trace' > 4. It work to me > > if you need more, email > > -Original Message- > I need to duplicate online database Oracle 8.1.7. > It is not possible to shutdown the primary database. > Can I do online backup this primary database by RMAN, > and + using archivelogs create duplicate database? > Inconsistent backups of RMAN + archivelogs = duplicate database?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Listener/Database shutdown sequence
OK, after emphatically stating it doesn't matter, I thought of a situation in which the order of shutting down could make a difference. In this scenario, you first must be the kind of person who needlessly insists on shutdown immediate (instead of abort). Second, you must have a very heavy rate of incoming connections, such as from a huge user base or many many webservers. Finally, you must be CPU bound. If you try to shutdown immediate, any activity, such as rolling back transactions and deallocating temp segments, that must complete before the shutdown completes, will have cycles stolen away by a needlessly spinning listener(s) that is just rejecting connections, one after another. So, in such a case, listener first, then database. But shutdown immediate is for wimps. Just shoot DBW0 in the head with a SIGKILL. ;-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Mar 2003, Mercadante, Thomas F wrote: > that's kind of a different question. > > in this case, as others have stated, the order of shutting things down does > not matter too much. > > For practical purposes, I would shut the listener down first and then the > database - only because the database takes longer to shut down. > > For startup, I would start the listener first - the database being up > without the listener is pretty useless anyway. > > -Original Message- > It is for the server auto-start/auto-shutdown procedures run by root. > > >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> > > > >it just doesn't matter. why do you even feel the need to shut the listener > >down? > > > >-Original Message- > >Should the databases be shutdown before the listener or the other way > >around. > > > >A DBA here (actually at Service Provider) believes that the listener has to > >be shutdown before the databases in 8i according to some documentation > >(they > > > >can't recall). > > > >I am proposing: > > > >Set Oracle 817 environment > >shutdown database > >stop 817 listener > >set Oracle 806 environment > >stop 806 listener > > > >They feel it should be the other order: > >Shutdown Listeners > >Shutdown databases > > > >Any comments and/or issues -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Listener/Database shutdown sequence
Why do you/they think it matters, regardless of the documentation? You can shut them down in any order you want. Users just get a different error if the listener is up vs. when it is down. Starting up, if services are registered via local_listener or mts_dispatchers, the listener should be up before the database opens. Otherwise, you will have to wait for instance registration with the listener, or force it with 'alter system register'. For dedicated connections, this problem can be avoided with a sid_desc in the listener.ora -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Mar 2003, david davis wrote: > > Should the databases be shutdown before the listener or the other way > around. > > A DBA here (actually at Service Provider) believes that the listener has to > be shutdown before the databases in 8i according to some documentation (they > can't recall). > > I am proposing: > > Set Oracle 817 environment > shutdown database > stop 817 listener > set Oracle 806 environment > stop 806 listener > > They feel it should be the other order: > Shutdown Listeners > Shutdown databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: What to check?
The wait events. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 28 Feb 2003, Nguyen, David M wrote: > Someone writes a SQL script to dump a table on three different database on > three different Solaris8 machines, he complaines one of machines took 6 > hours to dump a table while other two's only take one hour. He asks me to > investigate why. I log into the machine in question to check I/O statistic, > memory, CPU usage and found no problem. What else should I check here? > > Regards, > David > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: DBV
In Unix, maybe something like this? for X in *.dbf do dbv file="$X" & done Add logfiles, paths, etc. as you wish. I suppose something similar must be possible in batch scripting for windows. Then again maybe not! -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 27 Feb 2003, [EMAIL PROTECTED] wrote: > > Jeremiah, > > Perhaps the fact that my experience was with Personal Oracle 7.3.2.3 on > Win95 explains the hosed database - Win95 not being the best platform, to > say the least. > > I'll definitely try it again - on a test database, of course. > > BTW, I can't find any way to tell DBV to verify more than one datafile at a > time. Is there? > > Thanks. > > Jack C. Applewhite > Database Administrator > Austin Independent School District > Austin, Texas > 512.414.9715 (wk) > 512.935.5929 (pager) > [EMAIL PROTECTED] > > > > > > Jeremiah Wilton > > <[EMAIL PROTECTED]To: Multiple recipients of > list ORACLE-L > y.net><[EMAIL PROTECTED]> > > Sent by: cc: > > [EMAIL PROTECTED] Subject: Re: DBV > > > > > > 02/26/2003 06:34 > > PM > > Please respond to > > ORACLE-L > > > > > > > > ... > So unless Jack had an OS that writes when you ask it to read, there's no > way that DBV could have done anything bad to your database. > ... > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > > > > > -- > 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: Jeremiah Wilton 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: DBV
I have used DBV repeatedly and heavily on a variety of platforms from version 7.3.2 on. ALthough it has always been called an "Offline Verification Utility," that has never meant that it cannot be used on open datafiles. It just means it is not a utility that connects to the database. DBV has never done anything to datafiles but read. So unless Jack had an OS that writes when you ask it to read, there's no way that DBV could have done anything bad to your database. The 7.3 docs are hilarious. Offline or online > DB_VERIFY is an external command-line utility that performs a > physical data structure integrity check on an offline database. It > can be used against backup files and online files (or pieces of > files). You use DB_VERIFY primarily when you need to insure that a > backup database (or datafile) is valid before it is restored or as a > diagnostic aid when you have encountered data corruption problems. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Feb 2003, Daniel W. Fink wrote: > I had a scheduled job that ran dbv on Solaris 8.0.4 databases once a > week. Never a problem. It has been awhile since I used it on Windows, > and I don't recall using it on 7.3 (not that I did not, but my memory is > starting to go...). I have never had a problem with it, either with the > db up or down. > From the 8i Data Server Internals (which I have found accurate) > "DBVERIFY Utility...Opens data files read-only; can run while the > database is open." > > dbverify was introduced in 7.3, so you could have encountered a bug. It > is definitely a good idea to try it out first on a test database. > > Dan Fink > > [EMAIL PROTECTED] wrote: > > >Dan, > > > >That must be new for 9i, since my 8.1.7 docs say it is an "offline" > >utility. I remember hosing an entire 7.3 test database years ago when I > >first ran DBV on it while it was up and open - can't remember the errors, > >but the DB was unusable. One of the (too) many times I learned to read the > >docs more carefully. :-( > > > >Jack C. Applewhite > >Database Administrator > >Austin Independent School District > >Austin, Texas > >512.414.9715 (wk) > >512.935.5929 (pager) > >[EMAIL PROTECTED] > > > > > > > > > > > > "Daniel W. Fink" > > > > <[EMAIL PROTECTED]To: Multiple recipients of > > list ORACLE-L > > .com> <[EMAIL PROTECTED]> > > > > Sent by: cc: > > > > [EMAIL PROTECTED] Subject: Re: DBV > > > > > > > > > > > > 02/26/2003 01:54 > > > > PM > > > > Please respond to > > > > ORACLE-L > > > > > > > > > > > > > > > > > > > >Yes, you can. It may report that a block is influx if the block is being > >written while dbv is looking at it. If you encounter this error, run it > >again. If it does not report the same block, you are in the clear. > >As with any i/o intensive process, run it off-hours. > > > >Dan Fink > > > >Breno A. K. Magnago wrote: > > > > > > > >>Hi, > >>Can I use the program DBV on a production datafile (read and write), > >>without take offline the tablespace ? > >> > >> > >> > > > >-- > >Author: Daniel W. Fink > > INET: [EMAIL PROTECTED] &g
Re: History
Seems like 1999 around OOW. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Feb 2003, Jonathan Lewis wrote: > > Does anyone happen to remember when > Juan Loaiza and Bhaskar Himatsingka first > published their paper called: > > How to stop defragmenting and start living: > the definitive word on fragmentation. > > Thanks > > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Coming soon one-day tutorials: > Cost Based Optimisation > Trouble-shooting and Tuning > Indexing Strategies > (see http://www.jlcomp.demon.co.uk/tutorial.html ) > > UK___March 19th > USA_(FL)_May 2nd > > > Next Seminar dates: > (see http://www.jlcomp.demon.co.uk/seminar.html ) > > USA_(CA, TX)_August > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jonathan Lewis > 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: Jeremiah Wilton 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: corrupted block
On Wed, 26 Feb 2003, Yechiel Adar wrote: > We had a session with an expert on Monday and he recommended export > to \dev\nul to detect errors in the database. Well the expert isn't going to find any corruptions in indexes that way. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Null Event in v$session_wait
Null event is the bane of ORACLE 9.X. It pops up uner any circumstance that you really really need to know what a session is waiting on. Also, if you select your own wait event, it is always Null event. Result is about 15 bugs filed with Oracle by us alone. They promise it will get better in 10i, with some backports and patch releases for 9.2. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 18 Feb 2003, Jacques Kilchoer wrote: > I was looking this up on Metalink just the other day, and here is one of the > items of interest I found: > Doc ID: 408286.999 > In my case I was trying to do a online index rebuild in 8.1.7 so I went with > support's explanation. > > < timeout, without waiting for a particular resource. One place in the code > that this is done is during online index rebuild/creation. The session doing > the rebuild/create will try to get a DML lock no-wait, and if it fails to > get the lock, it sleeps on the "NULL event", and tries again. There are > probably other places where this occurs as well, however, this was one issue > discovered and documented in bug 1703940 (fixed in 9.2). > Gina Oracle Support Services>> > > -Original Message- > > I'm researching an performance issue with a Java program that appears to be > hung in the database. I query v$session wait and it's waiting on a "null > event". What exactly does this mean ? I've searched several books and > cannot find anything specifically on a null event wait event. > Any help would be appreciated. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an
John, In 7.3.4, wasn't background TX recovery already a feature? In other words, weren't large rollbacks delayed until after the database was already open and available? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 7 Feb 2003, John Kanagaraj wrote: > Just to add another aspect: I had a problem once with a 7.3.4 database when > we performed a shutdown abort. Now this database was in the middle of a > complete refresh of a rather large Table from another database. The shutdown > abort occurred properly, but the db took its sweet time to come up while it > rolled back all the snapshot data > > The key to this issue, as with any other aspect of DB admin: Know thy > application, Know thy database! > > > -----Original Message- > > From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] > > > > For problem 1, you mean transaction recovery, i.e. rollback, right? > > Did this problem happen only with fast start parallel rollback or also > > with normal version 7-on background TX rollback? How about user > > rollbacks (user 1 rolls back large transaction, user 2 truncates the > > table in the mean time). In other words, does it really have anything > > specifically to do with ABORT? Also, do you have a bug number for > > that? > > > > For problem 2, do you have a version where you have experienced this > > problem, or a bug number? As you know, the redologs also contain > > entries for the changes to the controlfile, so partial write or not, > > instance recovery should repair a partial write to the controlfile. > > > > Finally, I'm pretty sure you can be certain you have checkpointed at > > any given time. If you haven't, the database will soon run out of > > online redologs and stop until a checkpoint does complete! > > > > Forcing a checkpoint is a great idea -- for speeding up instance > > recovery -- but it doesn't make ABORT any more or less safe. > > > > My motto is: Shutdown abort is not shutdown abhorrent! > > > > :-) > > > > On Thu, 6 Feb 2003, Robert Freeman wrote: > > > > > RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands > > Solaris andLet me > > > throw in my 2 cents worth on this topic. There are two problems with > > > SHUTDOWN ABORT that I have experienced in the past. > > > > > > 1. Before 9i (it appears to be fixed in 9i) if you inserted > > data in a table, > > > then did a shutdown abort, if after restarting the > > database, you tried to > > > truncate the table while the database was performing > > recovery on that table, > > > the database would crash. > > > > > > 2. Assume that you have applications that are dynamically > > doing things like > > > adding and dropping tablespaces. WHat happens if the app is > > in the middle of > > > such an operation and it's in the middle of writing new > > records to the > > > control file. What is the result if you shutdown abort in > > the middle of this > > > write, before it's complete. We experienced a situation > > like this earlier > > > this week. > > > > > > I've always been opposed to shutdown abort unless you are > > certain that you > > > have checkpointed and that there are no user sessions > > operating on the > > > database. > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf > > Of Jamadagni, > > > Rajendra > > > > > > When we do cold backups, our script issues 'shutdown > > immediate', if within > > > 3 minutes the db is not shut down, we cancel and issue > > 'shutdown abort'. In > > > either case, we (again issue) startup/shutdown to make it > > clean before > > > taking backup. > > > > > > We don't worry about users connecting, as during cold > > backup window, the > > > listeners are shutdown. For us it is a circus (kind of) because our > > > production DBs talk to each other, so we have to follow a > > specific seq of > > > shutdown/startup. > > > > > > So far we haven't encountered any major issues because of > > 'shutdown abort' > > > ... (heavily knocking on the wood !!) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an
Hi Robert, For problem 1, you mean transaction recovery, i.e. rollback, right? Did this problem happen only with fast start parallel rollback or also with normal version 7-on background TX rollback? How about user rollbacks (user 1 rolls back large transaction, user 2 truncates the table in the mean time). In other words, does it really have anything specifically to do with ABORT? Also, do you have a bug number for that? For problem 2, do you have a version where you have experienced this problem, or a bug number? As you know, the redologs also contain entries for the changes to the controlfile, so partial write or not, instance recovery should repair a partial write to the controlfile. Finally, I'm pretty sure you can be certain you have checkpointed at any given time. If you haven't, the database will soon run out of online redologs and stop until a checkpoint does complete! Forcing a checkpoint is a great idea -- for speeding up instance recovery -- but it doesn't make ABORT any more or less safe. My motto is: Shutdown abort is not shutdown abhorrent! :-) -- Jeremiah "Shutdown Abort" Wilton http://www.speakeasy.net/~jwilton On Thu, 6 Feb 2003, Robert Freeman wrote: > RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris andLet me > throw in my 2 cents worth on this topic. There are two problems with > SHUTDOWN ABORT that I have experienced in the past. > > 1. Before 9i (it appears to be fixed in 9i) if you inserted data in a table, > then did a shutdown abort, if after restarting the database, you tried to > truncate the table while the database was performing recovery on that table, > the database would crash. > > 2. Assume that you have applications that are dynamically doing things like > adding and dropping tablespaces. WHat happens if the app is in the middle of > such an operation and it's in the middle of writing new records to the > control file. What is the result if you shutdown abort in the middle of this > write, before it's complete. We experienced a situation like this earlier > this week. > > I've always been opposed to shutdown abort unless you are certain that you > have checkpointed and that there are no user sessions operating on the > database. > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni, > Rajendra > > When we do cold backups, our script issues 'shutdown immediate', if within > 3 minutes the db is not shut down, we cancel and issue 'shutdown abort'. In > either case, we (again issue) startup/shutdown to make it clean before > taking backup. > > We don't worry about users connecting, as during cold backup window, the > listeners are shutdown. For us it is a circus (kind of) because our > production DBs talk to each other, so we have to follow a specific seq of > shutdown/startup. > > So far we haven't encountered any major issues because of 'shutdown abort' > ... (heavily knocking on the wood !!) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: First version with multiple archiver processes?
Sorry Kirti, that was meant for Peter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 6 Feb 2003, Jeremiah Wilton wrote: > Kirti > > In v.7 the archiver is called ARCH. If 'archive log start to xxx' > starts another, what is it called? > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Wed, 5 Feb 2003, Peter Gram wrote: > > > Kirti > > > > From version 7.x you can manually start multiple archive processes by > > using the "archieve log start to " and the added > > processes wil die when there is no more redofiles to archive, but for > > permanent having multiple processes the answer is 8.1.3 :-) > > > > Deshpande, Kirti wrote: > > > > >I can think of 8.1.3. > > > > > >- Kirti > > > > > >-Original Message- > > >Sent: Wednesday, February 05, 2003 6:04 PM > > >To: Multiple recipients of list ORACLE-L > > > > > > > > >What was the first version of Oracle with the ability to start > > >multiple archiver processes? > > > > > >-- > > >Jeremiah Wilton > > >http://www.speakeasy.net/~jwilton > > > > > > > > > > > > > > > > > > > > > > -- > > Peter Gram, Miracle A/S > > Phone : +45 2527 7107, Fax : +45 4466 8856 > > mailto:[EMAIL PROTECTED] - http://MiracleAS.dk > > > > > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: First version with multiple archiver processes?
Kirti In v.7 the archiver is called ARCH. If 'archive log start to xxx' starts another, what is it called? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 5 Feb 2003, Peter Gram wrote: > Kirti > > From version 7.x you can manually start multiple archive processes by > using the "archieve log start to " and the added > processes wil die when there is no more redofiles to archive, but for > permanent having multiple processes the answer is 8.1.3 :-) > > Deshpande, Kirti wrote: > > >I can think of 8.1.3. > > > >- Kirti > > > >-Original Message- > >Sent: Wednesday, February 05, 2003 6:04 PM > >To: Multiple recipients of list ORACLE-L > > > > > >What was the first version of Oracle with the ability to start > >multiple archiver processes? > > > >-- > >Jeremiah Wilton > >http://www.speakeasy.net/~jwilton > > > > > > > > > > > > > > -- > Peter Gram, Miracle A/S > Phone : +45 2527 7107, Fax : +45 4466 8856 > mailto:[EMAIL PROTECTED] - http://MiracleAS.dk > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).
First version with multiple archiver processes?
What was the first version of Oracle with the ability to start multiple archiver processes? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and
Rajesh, There are unknowns with every feature. ABORT is a feature just as IMMEDIATE is. In version 7, I encountered a bug with IMMEDIATE that required recovery from a backup, and eventually manual BBED'ing of the SYSTEM datafile by Oracle BDE. SO maybe we shouldn't use immediate either. I'll just call all the users and ask them to log off. "Hello? My name is is Jeremiah from Amazon.com, and I was wondering if you could stop buying books right now..." I would submit that ABORT is one of the most tested features of Oracle 8 and 9 - not at Oracle, but at customer sites - because it is one of the most used. No serious HA site is still using IMMEDIATE on a consistent basis, because it is unreliable. Consistent performance requires the use of ABORT for reliable shutdowns and for cluster failovers. Oracle even recommends it in their FailSafe manual. So my advice is to cite the exact circumstances, test case and number of your bug for those few still using version 7. Many features were screwed in V.7. I would submit that in your case, with an unresponsive instance, you may have had problems outside your database that contributed to the need for recovery, and are mistakenly fingering ABORT as the cause. Since Oracle 7.3.4, I have not heard reliable accounts of any problems with ABORT. This is mainly because transactions are transactions, and they have to have a response from the O/S and recorded their redo before a COMMIT is returned to the application. That makes them recoverable as soon as they are considered successful by the app. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Feb 2003, Rajesh Dayal wrote: > I totally agree > > I am witness of one of these untested combination resulting in "true > disaster" . > > And the combination was shutdown immediate to an extremely database > (with no response), followed by shutdown abort and all the data > files got corrupted. We could not recover that big production > database from that corruption of all the datafiles and we had to go > back to Old and valid set of backup. That was Oracle 7.3.4 running > telecom database around a year back. > > Sine then I am too shaky on using shutdown abort, I avoid it unless > it is as extreme urgency and if at all I have to use it, I never do > it after shutdown immediate > > -Original Message- > > I have to say that I still have an emotional > response to 'shutdown abort', despite knowing > that logically it ought to be perfectly safe. > > The reason for this is the lack of stress testing > that goes on at Oracle Corp. In most (if not > all) cases, the only blanket stress test that > the software gets is from production end-users. > > How many millions of times per day is the > message passing mechanism for parallel > query tested ? And it still has bugs. > > How many times per day is shutdown abort > tested - how many possible combinations of > events coinciding with a shutdown abort have > not yet received a single test ? > > I find it very hard to shake the feeling that > somewhere there is a code path that will > eventually result in a big problem for someone > once they switch to a regular shutdown abort. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and
Alter system checkpoint... You don't say... Hey, this is the first time this thread has concluded without the usual "you guys better watch out b/c yer gonna break your database!" post. I'd say this universal support for ABORT over IMMEDIATE represents a dramatic change in the prevailing DBA attitude over, say, two years ago. How do you suppose that happened? :-) The only dissenter was Dan. Dan, what's the difference between a kernel transaction and a regular transaction? Are you talking about the O/S kernel or Oracle? Can you explain in more detail what the kernel transaction does to make Oracle unrecoverable after ABORT? I'm still mulling over that 'alter system checkpoint.' Sounds familiar. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 1 Feb 2003, [iso-8859-1] Connor McDonald wrote: > Agreed. All that matters is the redo logs. If Oracle > had named the shutdown options more accurately, that > is > > shutdown abort => shutdown fast > shutdown immediate => shutdown hopefully > shutdown transactional => shutdown when hell freezes > over > shutdown normal => shutdown never > > then I'm pretty sure I know what everyone would be > using...An 'alter system checkpoint' just before the > abort also helps startup times. > > --- Hemant K Chitale <[EMAIL PROTECTED]> wrote: > > > > Comparing the shutdown scenarios with what would > > happen if someone > > were to "pull the plug" on the server is the best > > way to explain the behaviour > > of Oracle. > > What if > >a. Someone switched-off the server [there's a > > power failure and the UPS > > doesn't kick in] ? > >b. The server crashes with a Unix Panic > > well, the Oracle instance dies and yet, [as long as > > the disks are still good, > > even if you have to do an "fsck"] there's Instance > > Recovery which goes through > > successfully. > > So what's the problem with SHUTDOWN ABORT ? Its > > about the same thing, > > but not as bad. > > > > I consistently use SHUTDOWN ABORT, STARTUP RESTRICT, > > SHUTDOWN NORMAL > > on Production, Mission-Critical databases. I've > > never had a problem with a > > SHUTDOWN ABORT. > > Even a clone of an ABORTed instance can work if the > > online redo logs and > > current > > control-file are also cloned ! > > > > I have seen SHUTDOWN IMMEDIATE hang very many times > > [particularly when > > DBMS_JOB jobs are running or the un-intelligent > > Intelligent Agent is > > connected]. > > > > At 05:29 PM 31-01-03 -0800, you wrote: > > >Dan, > > > > > >If you look at Rama Velpuri's most famous treatise > > on B & R - namely > > >'Oracle8 Backup & Recovery Handbook' (Oracle > > Press), you will see the path > > >that the various shutdown options take. [Page 43, > > Chapter 2: The Oracle > > >Architecture and Configuration]. I belive this is > > the closest that we could > > >come to a published look under the covers. Some one > > mentioned a switch > > >logfile prior to the shutdown abort. In any case, a > > shutdown abort would not > > >be as bad as someone pulling the plug on the juice > > (as in Cleaning lady: 'I > > >need to plug in my hoover... aaah - here's a socket > > I can use). The instance > > >goes down not-so-gracefully, but the disk is still > > safe as long as the > > >server stays up. > > > > > > > -Original Message- > > > > From: Fink, Dan [mailto:[EMAIL PROTECTED]] > > > > > > > > I know I am going to catch major grief for this, > > but I avoid > > > > shutdown abort > > > > when possible. Shutdown immediate can take some > > time, as it will do > > > > transaction rollback in serial (where recovery > > at startup can do it in > > > > parallel and as needed). The main reason I avoid > > it is that > > > > there are known > > > > bugs that will cause the database to be > > unrecoverable when a > > > > shutdown abort > > > > is done while a kernel transaction is being > > performed. > > > > Granted, I have not > > > > personally encountered this, and the chances of > > encountering > > > > it are slight, > > > > but why take the risk? > > > > > > > > > > > > Dan Fink > > > > > > > > -Or
RE: Making dispatchers re-read tnsnames.ora?
Well, my first objection to ONames was just in the context of solving my problem. Dispatchers cache addresses for outgoing connections, whether they cache them from tnsnames.ora or ofrom Oracle Names. Or so I understand it. If someone knows differently about Names then I would like to hear about it. As for the limitations of names... Yes, you can have the local host caching of directory entries. My objection is more to adding a new service with added equipment and expense where flat files actually do a better job. Sitations with very high connection rates pose a problem. Using a pool of application servers, there may be a need for multiple listeners to handle the load if a connection pooling technology is not in the picture. In such a situation it is helpful for purpises of scalability and availability to segregate a large number of app servers into "cells" of, say, 10 or 20 servers each. You want each of these cells to be inidividually maintainable, and to be able to be put in and taken out of service independently, so that overall aailability for the application base is always maintained. In the cell model, a listener or set of listeners is created FOR EACH CELL. The TNS entries vary from cell to cell for that one service, because they specify different listeners. The advantages to doing this are many. With a cell out of service, you can take down a listener for whatever reason with no impact to the running application. And if a listener or set of listeners becomes saturated, the majority of inbound connections are unaffected by the problem, thus limiting the scope of a fault. AFAIK, you can't really do this in ONames without making up a different service name for every cell's listeners. Now, say your service is so important that you don't want all the back-office Duke Nukem and Doom sessions saturating the network and interfering with the application traffic. In reaction, you create a totally separate dedicated network for the most important systems in the company to communicate with the database server. You add a network interface card with its own IP addfress, but you leave the old one there so that the back office people can make occasional database queries. Naturally you will want separate listeners servicing the "importantnet" than service the old office LAN. In ONames, you would again have to name the same database's services on different networks differently. So then I ask, what advantage is there to Names? You can change things in a central location. There are no files to push around. Well, pushing files isn't really bad once you have a good set of scripts to do it. And flat files are a really reliable sevice. If you screw up a tnsnames.ora file change, you can catch the mistake by just testing with TNS_ADMIN, rather than taking down the whole company by fatfingering an ONames change. So in short, why again do I want yet another service that needs to be available (or the local caching up to date) to keep people connecting to my databases (especialy if I have to set up a separate service name for every little special situation)? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 30 Jan 2003, Jesse, Rich wrote: > Not that ONames doesn't have it's shortcomings, but I'm not sure how ONames > is a single point of failure. Even in our little 35-alias ONames repository > with only the root region, we have a secondary Names Server. With local > checkpoint files, the repository is not required for continuous access, so > there's no SPoF there. > > Could you expound a bit on that, Jeremiah? > > Thanks, > Rich > > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > -Original Message- > Sent: Thursday, January 30, 2003 10:10 AM > To: Multiple recipients of list ORACLE-L > > > On Thu, 30 Jan 2003, Gogala, Mladen wrote: > > > Yeah! Put it in Oracle*Names. > > Will it make a difference? Does a dispatcher really re-query Names > every time it tries to make a connection? No caching of service > addresses? You promise? > > Off I go to convert my 300-instance organization to rely on a single > point of failure and make a bunch more calls for every connect... > > YEEHAW! Oh wait. Names can't handle multiple interface and or > distinct allocation of certain clients to certain > listeners/interfaces. Oh well, and I thought I was going to have an > exciting weekend. Guess its back to that Rubik's cube. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-50
RE: Making dispatchers re-read tnsnames.ora?
On Thu, 30 Jan 2003, Gogala, Mladen wrote: > Yeah! Put it in Oracle*Names. Will it make a difference? Does a dispatcher really re-query Names every time it tries to make a connection? No caching of service addresses? You promise? Off I go to convert my 300-instance organization to rely on a single point of failure and make a bunch more calls for every connect... YEEHAW! Oh wait. Names can't handle multiple interface and or distinct allocation of certain clients to certain listeners/interfaces. Oh well, and I thought I was going to have an exciting weekend. Guess its back to that Rubik's cube. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > > -Original Message- > > From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, January 30, 2003 7:49 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Making dispatchers re-read tnsnames.ora? > > > > > > Dispatchers and job queue processes read tnsnames.ora on process > > startup in case they need to make an outound database link on behalf > > of one of he sessions using that dispatcher. > > > > If you make a change to the tnsnames.ora, dispatchers and job queue > > processes won't register it unless you restart them. For job queue > > processes this is simple (alter syste set job_queue_processes = 0; > > wait for jobs to complete, then set them back to the orig. value). > > > > For dispatchers, you have to "shutdown dispatcher" (alter system > > shutdown 'Dnnn'). Then, to get it to restart, you have to run "alter > > system set dispatchers = '';" with the COMPLETE dispatcher > > specification for the parameter index you eliminated the dispatcher > > from. > > > > This is annoyingly complex. When using multiple interfaces, multiple > > dispatcher parameter indexes and a variety of listener attributes > > within the dispatcher parameters, it can be difficult to get it right. > > > > Also, you have to do the dispatchers ONE AT A TIME so you don't block > > everyone out while you are waiting for the dispatchers to exit. TIME > > CONSUMING! > > > > Is there a way to make the dispatcher just reread the tnsnames.ora > > file without all this rigamaroll? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).
Making dispatchers re-read tnsnames.ora?
Dispatchers and job queue processes read tnsnames.ora on process startup in case they need to make an outound database link on behalf of one of he sessions using that dispatcher. If you make a change to the tnsnames.ora, dispatchers and job queue processes won't register it unless you restart them. For job queue processes this is simple (alter syste set job_queue_processes = 0; wait for jobs to complete, then set them back to the orig. value). For dispatchers, you have to "shutdown dispatcher" (alter system shutdown 'Dnnn'). Then, to get it to restart, you have to run "alter system set dispatchers = '';" with the COMPLETE dispatcher specification for the parameter index you eliminated the dispatcher from. This is annoyingly complex. When using multiple interfaces, multiple dispatcher parameter indexes and a variety of listener attributes within the dispatcher parameters, it can be difficult to get it right. Also, you have to do the dispatchers ONE AT A TIME so you don't block everyone out while you are waiting for the dispatchers to exit. TIME CONSUMING! Is there a way to make the dispatcher just reread the tnsnames.ora file without all this rigamaroll? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Re: 100% CPU utilization, urgent
On Mon, 20 Jan 2003, Hussain Ahmed Qadri wrote: > It's the Oracle.exe which is taking 100%. V$session tells me about the users > connected to the database, but no the info about which user is taking what > percentage of CPU. How can I identify which Oracle process (like DBSNMP or > anyother) it is that is taking so much CPU? I don't know how to see the top CPU-using thread in Windows, but you can get this from the database if you have TIMED_STATISTICS set to TRUE. Just query v$sesstat and join to v$statname by statistic# looking only for 'CPU used by this session', and find out which sid is using the most CPU BETWEEN QUERIES. Alternately, you can get this info from the same table since instance startup by dividing the statistics value by the total lifetime of the session taken from from v$session. I'll let you make the SQL. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > >--- Hussain Ahmed Qadri <[EMAIL PROTECTED]> wrote: > > > >> We have a consistent problem of CPU utilization > >> 100%. We have had this > >> problem since Saturday, but it automatically > >> subsided, I mean went back to > >> normal after a few hours, and remained normal on > >> Sunday as well. But its > >> back to 100% since morning, that is when the load > >on > >> the server has gone up > >> again to 100% and over all work is non-existent. > > > >> Our machine is Compaq Proliant ML350, 900 MB ram, > > > >> 933 single Processor, > >> Database size of roughly 5 GB. WINNT4.0, Oracle > >> 8.1.7. > >> I have checked the temporary tablespaces, they > >are > >> normal. > >> We have a 24x7 environment, a hospital, so please > > > >> can you suggest the areas > >> to look in to, its really very urgent. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).
1998 UK Oracle Users Group conference papers
Hopefully this should be the last of these requests. I am looking for anyone with program materials or whitepapers, especially the CD ROM from the 1998 UK Oracle Users Group conference. I am searching for a paper called "An artistic look at tuning very large Oracle8 databases" by Meghraj Thakkar. If you have any such materials that you would be willng to share, please contact me off the list. [EMAIL PROTECTED] Thanks, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Trace file size...
On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote: > My SQL_TRACE is on for instance. For the whole instance? Usually, we only run SQL tracing for one or a few sessions at a time. Turning it on for the whole instance makes for a whole lot of tracing and greatly decreased performance. What are you trying to find out? > What will happen to trace file if it reaches MAX_DUMP_FILE_SIZE. > wether it is truncated? or it will start writing into another file? It will end the tracing to the file, and no new file will be started. There will be a message at the end of the file indicating it has reached the max file size. > Is there a way to recognize, which trace file belongs to which session? Unless you are running MTS/Shared Server, the trace output begins with something like: *** SESSION ID:(134.58553) 2003-01-13 09:11:02.501 That's SID.SERIAL# inside the parentheses. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).
1998 IOUG or Openworld session listings/programs
If anyone has a conference program or other documentation with session listings from 1998, could you please contact me off the list. "Really interested in the who's who of Oracle 7.3 tuning!" Thanks! -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).
1998 Openworld CD
I believe 1998 was the last year they provided CDs with papers and presentations. Does anyone still have the 1998 CD and is willing to share it? Please mail me directly off list: [EMAIL PROTECTED] Thanks, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Finding User sessions = idle > 30 min??
The last_call_et column of v$session shows the seconds elapsed since the session last made a database call, regardless of the current wait event. This is how I have always identified idle sessions. And Naveen is right. The seconds_in_wait column of v$session_wait shows the actual time spent waiting. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 11 Dec 2002, Naveen Nahata wrote: > Won't 'seconds_in_wait' show the total time waited for the session rather > than the current wait time? > > -Original Message- > Denham - I'm going to make a guess here and someone will probably correct > me. How about >select sid from v$session_wait where event = 'SQL*Net message from > client' and seconds_in_wait > 1800 > You can join to other tables like V$SESSION to get more information. > > -Original Message- > Please help - I am trying to find/create a script that will return all user > sessions whose Idle time is greater than 30 minutes. > > ie > SELECT SID, SERIAL# > FROM V$SESSION >" WHERE IDLE_TIME > 30 min;" > > My forays into the Documentation and searches have not been very successful. > > I don't really want to do this via the roles IDLE_TIME setting, I very much > would like to be able to query directly to the database. > > Based on the information I would then make the decision to kill the user > process etc. > Just in case you might be interested it is Oracle 817 DB on Windows 2k. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Increase size of data files and rollback segments
On Wed, 11 Dec 2002, Yechiel Adar wrote: > Do not allow your datafile to autoextend across 4GB boundary. > There is a bug that cause this datafile to be unusable. I think the 4Gb limit is confined to a handfull of older operating system versions or older Oracle versions. For about the last five years I have been accustomed to creating 16Gb datafiles with no problem. Imagine trying to build a 5 terabyte data warehouse out of 1900Mb datafiles! It would require 2760 datafiles! Can anyone confirm that this is no longer a problem after certain versions of O/S and Oracle? Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you specify no size for a datafile, then adds it to the controlfile /data dictionary in a way that makes it look like it has a ton (like a terabyte) of free space. The datafile can't be resized or offline dropped, and the tablespace must be dropped and recreated (unless you get the patch). Let one segment extend into there and watch the ORA-600s. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Wednesday, December 11, 2002 2:46 AM > > > > As a start, look up the following commands in the SQL Reference guide: > > > > alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on > maxsize 20480M; > > Read up on the implications of autoextend and whether you want it > > > > alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; > > > > For rollback datafile - same as any other datafile, eg: > > alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on > maxsize 10240M; > > > > You may then need to add another rollback segment or increase the max > extents of an existing one. eg to add another rollback segment: > > CREATE PUBLIC ROLLBACK SEGMENT r09_big > >TABLESPACE rollback > >STORAGE > >( minextents 20 > > INITIAL 10M > > NEXT 10M > > MAXEXTENTS UNLIMITED) > > > > (you would then need to bring this online - eg "alter rollback segment > r09_big online;") > > > > > > For tempfile (ie LMT temporary tablespaces): > > alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize > 10240M; > > > > Remember - don't use the exact sizes I've shown - alter to suit your case > (these were part of a huge load into a new test system) > > > > > > Hope this helps (and willing to learn if some of the above could be > improved). > > > > Regards, > > Bruce > > > > -Original Message- > > Sent: Wednesday, 11 December 2002 8:15 AM > > > > > From: Nguyen, David M [mailto:[EMAIL PROTECTED]] > > > > > > Alright guys, just because you know Jeremiah better than me > > > so you can take > > > his joke. > > I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I > nearly flamed you myself, and I'm just a lowly developer. > > > My apology to him as I did not recognize it was a > > > joke, however > > > when I am asking for help from the group, I am in a situation > > > to resolve > > > problem ASAP and hope to find a answer not a joke. > > The problem is that if enough people like you refuse to RTFM, then no one > will want to answer questions because it'll be duller'n your resume. > > > If you were in my situation, you would understand. > > I've been in your situation, and been damned ashamed of myself for not > having researched the question first. It ain't all that hard... > > -- > > 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 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.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Die
Re: Increase size of data files and rollback segments
On Mon, 9 Dec 2002, Nguyen, David M wrote: > How do I increase size of oracle data files and rollback segments and Can I > do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Table Locks
Seems to me you should just have your program try to lock tables in exclusive mode. If it succeeds, then rollback. If it fails (timeout), it opens another session while the 'lock table' is waiting, and finds the blocker. Otherwise, if you are only interested in sessions that are actually blocking other sessions, just look in v$lock where block = 1. As interesting as it seems, I think you won't succeed in trying to put triggers on x$kgllk or anything like that. They're not real tables - just table-like accessors for memory structures in the SGA. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 29 Nov 2002, [EMAIL PROTECTED] wrote: > I would like to send an alert message to a client when a data row is > locked for more than a certain period of time. For this can I write > triggers on the system tables. If so on which table should I write a > trigger to retrieve the table lock information. Are there any implications > on writing triggers on the system tables. > > The alert message should be sent automatically in the sense, can I write > an alert and signal it from a trigger written on some system table where > the lock information is available? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Oracle on windows and shadow thread file access
Yes, I meant "files they need for read." No matter how many times you proofread before sending... A shadow server process would only write if it were using direct path insert /*+append*/ or sqlldr or sorting to TEMP. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 29 Nov 2002, Jeremiah Wilton wrote: > On Fri, 29 Nov 2002, Jeff Herrick wrote: > > > None...only the oracle background processes (threads in Winblows) > > access the datafiles/logfiles etc. All other communication is > > done through the SGA. On some Unix variants you _can_ reach > > a file_open max kernel parameter because each process (in a > > dedicated server scenario) opens it's own stdin/stdout/stderr. > > I guess the same could be true of processes running under > > windows too. So in the limit...you could hit a wall but only > > due to the per-process overhead. > > Uh, I'm probably not going to be the only one to point out this isn't > true. I don't know about Win32 thread architecture, but in Unix and > unix-like operating systems, the shadow (server) processes each open > whatever files they need for write. It is true that they also open > the shared memory segments in order to write and read from the SGA, > but they do the reading from disk. Otherwise, which process do you > think is reading from the datafiles? > > A sample lsof of a typical server process: > unixhost# lsof -p 29290 > COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME > oracleorc 29290 oracle cwd VDIR 64,0x10002 22528 10090 >/oracle/product/8.1.7/dbs > oracleorc 29290 oracle mem VREG 64,0x7532 20465 /var/spool/pwgr/status > oracleorc 29290 oracle txt VREG 64,0x10002 3855 22842 >/oracle/product/8.1.7/bin/oracle > oracleorc 29290 oracle mem VREG 64,0x6 13215 3024 /usr/lib/tztab > oracleorc 29290 oracle mem VREG 64,0x61572640 6873 >/usr/lib/pa20_64/libc.2 > oracleorc 29290 oracle mem VREG 64,0x6 274664 8414 >/usr/lib/pa20_64/libm.2 > oracleorc 29290 oracle mem VREG 64,0x6 24032 8484 >/usr/lib/pa20_64/libdl.1 > oracleorc 29290 oracle mem VREG 64,0x6 23336 2688 >/usr/lib/pa20_64/libnss_dns.1 > oracleorc 29290 oracle mem VREG 64,0x6 131264 19010 >/usr/lib/pa20_64/libpthread.1 > oracleorc 29290 oracle mem VREG 64,0x6 24896 2671 >/usr/lib/pa20_64/librt.2 > oracleorc 29290 oracle mem VREG 64,0x10002 40600 3388 >/oracle/product/8.1.7/lib64/libdsbtsh8.sl > oracleorc 29290 oracle mem VREG 64,0x100027101192 3390 >/oracle/product/8.1.7/lib64/libjox8.sl > oracleorc 29290 oracle mem VREG 64,0x6 289000 8482 >/usr/lib/pa20_64/dld.sl > oracleorc 29290 oracle0r VCHR 3,0x20t066 /dev/null > oracleorc 29290 oracle1w VREG 64,0x5 1177 6173 >/tmp/listener_L_ORCL_start.out > oracleorc 29290 oracle2w VREG 64,0x5 1177 6173 >/tmp/listener_L_ORCL_start.out > oracleorc 29290 oracle3r VCHR 3,0x20t066 /dev/null > oracleorc 29290 oracle4r VCHR 3,0x20t066 /dev/null > oracleorc 29290 oracle5r VCHR 3,0x20t066 /dev/null > oracleorc 29290 oracle6u inet 0x4ecd06680t0 TCP *:* (IDLE) > oracleorc 29290 oracle7r VCHR 3,0x20t066 /dev/null > oracleorc 29290 oracle8u unix 0x4a1c8e000t0 >/var/spool/sockets/pwgr/client29290 > oracleorc 29290 oracle9r VREG 64,0x10002 360448 2274 >/oracle/product/8.1.7/rdbms/mesg/oraus.msb > oracleorc 29290 oracle 10u VCHR 64,0x3000e 0x512bc000 2233 >/dev/data3/rorclsession_item-01 > oracleorc 29290 oracle 11u inet 0x515d3a68 0t1684264 TCP >unixhost.corporation.com:1541->clienthost.corporation.com:1577 (ESTABLISH > ED) > oracleorc 29290 oracle 12u VCHR 64,0x3000f 0x842c000 2237 >/dev/data3/rorclts1_idx-02 > oracleorc 29290 oracle 13u VCHR 64,0x10078 0xaacc000 2197 /dev/data1/rorclts1-02 > oracleorc 29290 oracle 14u VCHR 64,0x2006a 0t59826176 2203 >/dev/data2/rorclts1_idx-01 > oracleorc 29290 oracle 15u VCHR 64,0x1006d 0xad0a000 2050 /dev/data1/rorclts1-01 > oracleorc 29290 oracle 16u VCHR 64,0x20078 0t89505792 2231 /dev/data2/rorclts2-01 > oracleorc 29290 oracle 17u VCHR 64,0x30015 0x16aa2000 2248 >/dev/data3/rorclts3_idx-02 > oracleorc 29290 oracle 18u VCHR 64,0x20073 0x6a144000 2221 >/dev/data2/rorclts3_idx-01 > oracleorc 29290 oracle 19u VCHR 64,0x30010 0x3819c000 2239 >/dev/data3/rorclts4_idx-02 > oracleorc 29290 oracle 20u VCHR 64,0x20072 0x375a8000 2219 >/dev/data2/rorclts4_idx-01 > oracleorc 29290 oracle 21u VCHR 64,0x1006f 0x77b6a000 217
Re: Oracle on windows and shadow thread file access
On Fri, 29 Nov 2002, Jeff Herrick wrote: > None...only the oracle background processes (threads in Winblows) > access the datafiles/logfiles etc. All other communication is > done through the SGA. On some Unix variants you _can_ reach > a file_open max kernel parameter because each process (in a > dedicated server scenario) opens it's own stdin/stdout/stderr. > I guess the same could be true of processes running under > windows too. So in the limit...you could hit a wall but only > due to the per-process overhead. Uh, I'm probably not going to be the only one to point out this isn't true. I don't know about Win32 thread architecture, but in Unix and unix-like operating systems, the shadow (server) processes each open whatever files they need for write. It is true that they also open the shared memory segments in order to write and read from the SGA, but they do the reading from disk. Otherwise, which process do you think is reading from the datafiles? A sample lsof of a typical server process: unixhost# lsof -p 29290 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME oracleorc 29290 oracle cwd VDIR 64,0x10002 22528 10090 /oracle/product/8.1.7/dbs oracleorc 29290 oracle mem VREG 64,0x7532 20465 /var/spool/pwgr/status oracleorc 29290 oracle txt VREG 64,0x10002 3855 22842 /oracle/product/8.1.7/bin/oracle oracleorc 29290 oracle mem VREG 64,0x6 13215 3024 /usr/lib/tztab oracleorc 29290 oracle mem VREG 64,0x61572640 6873 /usr/lib/pa20_64/libc.2 oracleorc 29290 oracle mem VREG 64,0x6 274664 8414 /usr/lib/pa20_64/libm.2 oracleorc 29290 oracle mem VREG 64,0x6 24032 8484 /usr/lib/pa20_64/libdl.1 oracleorc 29290 oracle mem VREG 64,0x6 23336 2688 /usr/lib/pa20_64/libnss_dns.1 oracleorc 29290 oracle mem VREG 64,0x6 131264 19010 /usr/lib/pa20_64/libpthread.1 oracleorc 29290 oracle mem VREG 64,0x6 24896 2671 /usr/lib/pa20_64/librt.2 oracleorc 29290 oracle mem VREG 64,0x10002 40600 3388 /oracle/product/8.1.7/lib64/libdsbtsh8.sl oracleorc 29290 oracle mem VREG 64,0x100027101192 3390 /oracle/product/8.1.7/lib64/libjox8.sl oracleorc 29290 oracle mem VREG 64,0x6 289000 8482 /usr/lib/pa20_64/dld.sl oracleorc 29290 oracle0r VCHR 3,0x20t066 /dev/null oracleorc 29290 oracle1w VREG 64,0x5 1177 6173 /tmp/listener_L_ORCL_start.out oracleorc 29290 oracle2w VREG 64,0x5 1177 6173 /tmp/listener_L_ORCL_start.out oracleorc 29290 oracle3r VCHR 3,0x20t066 /dev/null oracleorc 29290 oracle4r VCHR 3,0x20t066 /dev/null oracleorc 29290 oracle5r VCHR 3,0x20t066 /dev/null oracleorc 29290 oracle6u inet 0x4ecd06680t0 TCP *:* (IDLE) oracleorc 29290 oracle7r VCHR 3,0x20t066 /dev/null oracleorc 29290 oracle8u unix 0x4a1c8e000t0 /var/spool/sockets/pwgr/client29290 oracleorc 29290 oracle9r VREG 64,0x10002 360448 2274 /oracle/product/8.1.7/rdbms/mesg/oraus.msb oracleorc 29290 oracle 10u VCHR 64,0x3000e 0x512bc000 2233 /dev/data3/rorclsession_item-01 oracleorc 29290 oracle 11u inet 0x515d3a68 0t1684264 TCP unixhost.corporation.com:1541->clienthost.corporation.com:1577 (ESTABLISH ED) oracleorc 29290 oracle 12u VCHR 64,0x3000f 0x842c000 2237 /dev/data3/rorclts1_idx-02 oracleorc 29290 oracle 13u VCHR 64,0x10078 0xaacc000 2197 /dev/data1/rorclts1-02 oracleorc 29290 oracle 14u VCHR 64,0x2006a 0t59826176 2203 /dev/data2/rorclts1_idx-01 oracleorc 29290 oracle 15u VCHR 64,0x1006d 0xad0a000 2050 /dev/data1/rorclts1-01 oracleorc 29290 oracle 16u VCHR 64,0x20078 0t89505792 2231 /dev/data2/rorclts2-01 oracleorc 29290 oracle 17u VCHR 64,0x30015 0x16aa2000 2248 /dev/data3/rorclts3_idx-02 oracleorc 29290 oracle 18u VCHR 64,0x20073 0x6a144000 2221 /dev/data2/rorclts3_idx-01 oracleorc 29290 oracle 19u VCHR 64,0x30010 0x3819c000 2239 /dev/data3/rorclts4_idx-02 oracleorc 29290 oracle 20u VCHR 64,0x20072 0x375a8000 2219 /dev/data2/rorclts4_idx-01 oracleorc 29290 oracle 21u VCHR 64,0x1006f 0x77b6a000 2179 /dev/data1/rorclts3-01 oracleorc 29290 oracle 22u VCHR 64,0x10079 0x75c94000 2199 /dev/data1/rorclts3-02 -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > On Fri, 29 Nov 2002, Grant Allen wrote: > > > Saw an interesting post in comp.databases.oracle.server postulating that if > > a shadow thread needed an open file handle on all files in a instance (or > > even some of them), the process handle limit in windows could constrain user > > scalability (e.g. too many users would result in ora-12500 unable to spawn > > errors and the like). (Let's ignore MTS/shared server mode for the moment) > > > > Sounded interesting, but I thought I'
Re: how do I calculate the Oracle's usage
Even though the name of the statistic is "CPU used by this session,"
the v$sysstat view contains aggregated data of the statistics of all
sessions that have ever logged into your instance since it started.
For consistency, they use the same statistic names as are used by the
session-level statistics from v$sesstat, which is being aggregated in
v$sysstat. The full list of statistics is in v$statname. So if you
wanted your own statistics, you would have a query like this:
select value from v$session s, v$sesstat ss, v$statname sn where
s.audsid = userenv('sessionid') and s.sid = ss.sid and ss.statistic# =
sn.statistic# and sn.name = 'CPU used by this session';
To get the total for everyone ever logged in up to now, just query
v$sysstat.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 25 Nov 2002, Gurelei wrote:
> Wouldn't this only give me the statistics for
> MY current session? I'm looking for the data on
> all the running sessions.
>
> --- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> > How about you collect the following value from each
> > instance on the
> > host, wait a few hours, then collect the numbers
> > again? You can then
> > subtract the earlier values from the later values,
> > and you'll have a
> > good idea which instances are using more CPU
> > relative to the others.
> >
> > SQL> select value from v$sysstat where name = 'CPU
> > used by this session';
> >
> > On Mon, 25 Nov 2002, Gurelei wrote:
> >
> > > I'm trying to figure out how much of the srever's
> > resources
> > > (CPU-wise) a database and the application running
> > against it is
> > > taking. There are several databases on that server
> > and I'm only
> > > interested in one so vmstat won't really help that
> > much. Besides
> > > just running ps -ef | grep INSTANCE is there any
> > other way for me to
> > > get a feeling of the load that puts on the CPU my
> > database?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
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: how do I calculate the Oracle's usage
How about you collect the following value from each instance on the host, wait a few hours, then collect the numbers again? You can then subtract the earlier values from the later values, and you'll have a good idea which instances are using more CPU relative to the others. SQL> select value from v$sysstat where name = 'CPU used by this session'; -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Gurelei wrote: > I'm trying to figure out how much of the srever's resources > (CPU-wise) a database and the application running against it is > taking. There are several databases on that server and I'm only > interested in one so vmstat won't really help that much. Besides > just running ps -ef | grep INSTANCE is there any other way for me to > get a feeling of the load that puts on the CPU my database? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Problem doing RMAN backup of Clone?
Unfortunately, this problem is with the DBID, not anything in the controlfile. Oracle 9.2 comes with a utility called 'nid' in $ORACLE_HOME/bin/, which can change the DBID of a database. AFAIK, there is no other way to change the DBID, and you just have to use another catalog. I think nid may work on lower version databases, but I am not sure. Check out the docs. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Koivu, Lisa wrote: > I can't answer the question about rman... but if you recreate the > controlfile you will have a new incarnation number of the database. Have > you tried that? > > > -Original Message- > > From: Doug C [SMTP: ] > > > > Someone has just told me you can't do an RMAN backup of a clone because it > > has > > the same database id as the original. Is this true or not? If so, how > > to get > > around it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: instance shutdown problem ? (please help)
Hmm, I think the error is right there in a snippet fo the alert log in the poster's original message. ORA-205 "Error in identifying controlfile." The database will not start because Oracle cannot find or access one or more of the controlfiles. Are all the postings today about controlfiles? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 23 Nov 2002, Arup Nanda wrote: > Well, system does not do a shutdown abort. Oracle finds a problem and then > instance aborts. > > A few things you can do here. > > (1) See if a trace file is generated around that time in user_dump_dest or > background_dump_dest that might provide clues. If you see a core fiel in any > directory named core_* in the core_dump_dest, it has cored dumped. > > (2) Start the database from command line. From NT services panel, make the > services OracleServiceXXX manual, from automatic. Then reboot the box. Start > the service manually and then see what happens in the process. > > (3) Start the instance and service in a command prompt window using oradim > comamnd. I am not sure of the options; but the oradim command gives a help. > > At some point you would hit a problem that is decipherable. Please let us > know what came out of it. > > >From: john <[EMAIL PROTECTED]> > > > >ver 8i NT4.o > >all services have been set to automatic and start fine > > > >however the NT Event Viwer and the oracle "alert.log" > >show that the instance being shutdown just after the > >box boots up. > > > >how do we rectify this problem ? > > > >below is from the alert.log > > > >ORA-205 signalled during: alter database mount exclusive.. > >Shutting down instance (abort) > >License high water mark = 5 > >Instance terminated by USER, pid = 144 > >--- > >please note: the shutdwon was not initiated by any admin > >or user but done by the system itself after the box boots > >up. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: please help with control file
If you haven't created the database yet, look at the 'create database' command. The controlfiles get created when you create the database. If you already created a database, what happened to your controlfiles? Anyway, if you lost them, you can always use the 'create controlfile' command to get them back. Also, you might want to have a look at the Oracle Concepts Manual. It explains all about creating a database and controlfiles. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sun, 24 Nov 2002, john wrote: > the location mentioned in the init.ora for control files does not > have any control file. > since this is a new install, please let me know how to generate or > rather recreate control file(s). > [since there are no control file the system is unable to start] > > since instance is getting shutdown, i cannot enter sql as well. how > do i create these control files ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
UKOUG Conference
Anyone going to he UKOUG conference and exhibition Dec. 9 - 11? Anyone been to previous ones who can vouch for the value of the conference? Anyone know if they are looking for more speakers? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Move ALL Data from 1 Database into Another
On Wed, 13 Nov 2002, [EMAIL PROTECTED] wrote: > Are you sure about the "one round trip" thing. Turns out you are right about not doing a single round-trip per row. My information was either outdated or apocryphal: SQL> select value from v$sesstat ss, v$statname sn where sid = 31 and ss.statistic# = sn.statistic# and sn.name = 'SQL*Net roundtrips to/from dblink'; VALUE -- 0 SQL> insert into foobar (select * from foobar@baz); 1660073 rows created. SQL> select value from v$sesstat ss, v$statname sn where sid = 31 and ss.statistic# = sn.statistic# and sn.name = 'SQL*Net roundtrips to/from dblink'; VALUE -- 1925 (Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production) However, using DB links can never be as efficient as a parallel datafile copy followed by a near-zero downtime switchover. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > Hi Jeremiah > > Are you sure about the "one round trip" thing. I may be mistaken but I must > admit that has not been my experience. Are you thinking of occasions when > you use a remote table (accessible via a DBLink) in a local join? In such > cases the optimizer might set up the plan to get the remote rows > individually rather than doing unproductive remote full or range scans. One > would anticipate that a query like INSERT into (select * from > remotetable@link) would pull things over in a stream. OCI certainly streams > query results like that - I'm not saying that DBLinks are based on OCI - > just that there is precedent for this in at least one Oracle networking > layer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Move ALL Data from 1 Database into Another
I don't like any of the suggestions so far, because they take more time than necessary. DB links do ONE ROUND TRIP for every row fetched! That is not efficient. Export is a nightmare of potential failures. I think you can devise the best solution by just copying the database files. Try this idea on for size: 0. Make sure both versions of Oracle are installed on the host. 1. Make a hot backup or RMAN copy of the database, and start it under a different SID. 2. Upgrade the copy to 8.1.7, but keep COMPATIBLE at 7.3.4. 3. Roll the copy forward to the current time using the logs generated by the old 7.3.4 instance, which is still in use. 4. Shut down the old instance, apply the last log to the new one, and restart the new one with COMPATIBLE = 8.1.7. 5. Replace the listener with an 8.1.7 listener pointing at the new instance. This method gives you near zero downtime between kicking the users off the old database and letting them into the new one. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 13 Nov 2002, [EMAIL PROTECTED] wrote: > > What about foreign keys, functions, procedures, synonyms, roles, grants > and > > triggers (if any)? I've used the db link and it's faster than imp/exp but > > it doesn't do anything for other database objects. Also, if you do have > > foreign keys then a certain amount of pre-planning is necessary to move > > data in the right order. > > Actually in this case you can have your cake and eat it too. Use the > freeware DBATool to generate the database recreation scripts. Run the the > scripts to create all of the structure (including foreign keys, procedures, > synonyms etc). The DBATool can also generate scripts to disable (and > re-enable) all of the foreign keys. Disable the FK's, pull the table data > across via one or more DBLinks and run the FK re-enable script when done. > > DBATool: http://www.DataBee.com/dt_home.htm > > Kind Regards > Dale Edgar > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > 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.com -- Author: Jeremiah Wilton 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: disable SNP job processing temporarily
How about: 1. alter system set job_queue_processes = 0; 2. wait for nothing to be running in dba_jobs_running 3. do your stuff 4. alter system set job_queue_processes = 5; -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 4 Nov 2002, Markham, Richard wrote: > I have job_queue_processes 5 and job_queue_interval 3 > I need to release locks on packages for a recompile > but ALTER SYSTEM ENABLE RESTRICTED SESSION; is not > always an option for me. Does anyone know what I can > do to suspend job processing (with minimal impact). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: query progress meter
On Fri, 1 Nov 2002, Jamadagni, Rajendra wrote: > But ... you have to keep updating the data in v$session_longops ... using > dbms_application_info to actually see it in the query. No, you don't have to update anything if you are tracking table scans, index builds, and all kinds of other stuff that Oracle updates in there automatically. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE
On Thu, 31 Oct 2002, [EMAIL PROTECTED] wrote: > Reboot and open a TAR. I would preserve the evidence as long as is practical, and open a ticket with Sun. There should not be a sustained condition in Solaris during which a process is unkillable with SIGKILL. If you open a TAR, this is probably what they will tell you. What is the state of the unkillable processes according to the ps command? Does Solaris have a kernel debug mode? If so, and if the state of the process is 'U' (uninterruptible, meaning it is in a system call), you should be able to attach to the running Solaris kernel and get a thread trace of the unkillable process's system thread that will help Sun diagnose the problem. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: 31 October 2002 15:43 > > When I do shutdown abort my LGWR and CKPT still around and also kill -9 > cannot get rid of them anyone know why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: query progress meter
On Fri, 1 Nov 2002, Maria Quinn wrote: > I've just been asked if Oracle has an API which allows you to query > the progress of a query, say, as a percentage of the whole time > taken. It sure does. Look into v$session_longops. It gets better and better with every release. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Get together at OOW
I was on oracle-free leave for three months this summer (my first real vacation in over five years), so I didn't submit anything this year either. However, two of my colleagues, Grant McAlister and Jamie Kinney are presenting separately on their work on 9i RAC on Linux. They should be top-notch presentations. These guys do not tow the line. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 22 Oct 2002, Deshpande, Kirti wrote: > Gaja is an Oracle employee now.. > ... but will not be presenting this year... > > - Kirti > > -Original Message- > Sent: Tuesday, October 22, 2002 12:09 PM > To: Multiple recipients of list ORACLE-L > > > > they still allow the token non-Oracle speaker once in a while... > > Such as Gaja, Steve Adams, Jeremial Wilton, Rich Niemiec, (and of course the > Goddess :) > > We will miss you this OOW Meet Rachel. Why don't you get Ari's PocketDBA/SA > and do everything via your trusty PDA while sipping a cup of your favorite > liquid at Chevy's? > > John > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > 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.com > -- > Author: Deshpande, Kirti > 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.com -- Author: Jeremiah Wilton 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: Get together at OOW
On Tue, 22 Oct 2002, [iso-8859-1] Connor McDonald wrote: > Does anyone remember the days when there were > non-Oracle people allowed to speak at OpenWorlds ? You > know, there were actually presentations that didn't > sound like you had accidentally dropped into a > car-salesman's convention I have spoken at OOW for the last three years, and I have never worked for Oracle. Hopefully, I have never sounded like a shill for Oracle. If anything, I derive perverse pleasure from making fun of Oracle in my presentations, just to see if I can get myself uninvited next year. It is true, that presenters are predominantly Oracle employees, and major Oracle customers and partners. This limits the number of presentations having technical merit. I only attend OOW to present papers, to meet you all, and then only if admission is free. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > > :-) > > Connor > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > > Not this year... we have several highly visible apps > > going live > > anywhere from 10/31 through 11/8 (well, they were > > all scheduled for > > 10/31, all the database group's work is done but the > > developers..) and > > while I am not the production DBA (a refreshing > > change), I still don't > > think be away the first few weeks is advisable. > > > > Rachel > > > > --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > > > Jared, > > > > > > Count me in as I live in San Jose, and will drop > > in on any agreed > > > date. > > > Gerardo Molina (of SF, still on this list?) and > > self pulled together > > > a group > > > of illustrious personalities that even included > > Steve Adams (and the > > > Goddess > > > of course!) > > > > > > It would be a pleasure to meet you after all these > > years! > > > John Kanagaraj > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] > > [mailto:Jared.Still@;radisys.com] > > > > Sent: Monday, October 21, 2002 4:19 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: Get together at OOW > > > > > > > > > > > > Dear list, > > > > > > > > Though I won't be attending OOW, I will be in > > San Francisco during > > > > those same dates ( 11/10 - 11/15), just a couple > > miles from the > > > > Moscone Center where OOW is held. > > > > > > > > Are there any plans yet among list members to > > get together one > > > > evening? I think Monday is spoken for myself, > > but it would be nice > > > > to meet a few list members another evening. > > > > > > > > Jared > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > > -- > > > > 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.com > > > -- > > > Author: John Kanagaraj > > > 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 m
Re: Backup Strategy - Informal Survey
On Fri, 20 Sep 2002, Nat wrote: > We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our > database once a week for half an hour for cold bcv splits. So far it has > worked very well. Just curious, why do you do a cold backup weekly? Do you not trust your hot backups? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > - Original Message - > > > I'd like to pose a question to you all and get your response. If you are > > running a database that is larger than 250GB, what place in your backup > > strategy does a logical export have? Do you do logical exports at all, and > > if so with what frequency? Do you feel that logical exports are an > important > > part of your backup/recovery strategy? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Online vs offline backups
I wrote a little snippet that should answer at least some of your questions. Let me know if there's anything unclear in there: http://www.speakeasy.net/~jwilton/oracle/baseline-cold-backup.html -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 18 Jun 2002, Tracy Rahmlow wrote: > If you create a new database and do a full online backup (this also includes > future regular full online backups) is it ever necessary to do a full offline > backup? I have heard conflicting answers, regarding this and am looking for > some clarification. Don't 24x7 applications always have to execute offline > backups? Are offline backups done for peace of mind, and if yes why? What > issues are introduced if only offline backups are issued. In addition, we are > using BMCs Sql BackTrack product and I am not sure if it is a requirement of > the tool that an offline backup be periodically performed. If you know that as > well, please share. Thanks everybody > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tracy Rahmlow > 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: Jeremiah Wilton 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: Recovery of CTAS with NOLOGGING Data
On Wed, 5 Jun 2002, VIVEK_SHARMA wrote: > Did a Database Recovery & was Able to Successfully Recover ALL Data > of a Table Created with the CTAS NOLOGGING Option Did you recover from a backup taken before or after the CTAS? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: move the production database from one machine to another
On Wed, 29 May 2002, Ray Stell wrote: > It is not supported as an upgrade process. Oracle does not support > prod at 8.1.7.0 and standby at 8.1.7.2. I think this is a real > crime, since it would be a great feature to lower downtime. Why? It takes almost no time to shut down an 8.1.7.0 instance and start it up on an 8.1.7.2 ORACLE_HOME on the same server. The part that takes a long time is re-running catalog, catproc, etc., which I've never understood why you have to do, and which you have to do with the database open and only you logged in. You shouldn't need a standby to perform a fast upgrade even in a supported manner. Rerunning catalog and catproc takes much too long. Oracle should figure out the small number of objects that need to be recompiled under a new binary and provide a script with just those in it. Rerunning everything is a waste of time, and resources, and is disruptive as well. Anyway, since the log format of 8.1.7.0 is the same as 8.1.7.2, there should be no real problem running the standby in this mode, which I'll take you word for it is unsupported. The question is, why would someone do it? Disk space for ORACLE_HOME? An extra disk is probably cheaper than a whone second server for a standby. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > On Wed, May 29, 2002 at 03:53:32PM -0800, Li Zhang wrote: > > The company I am working for is planning to move the whole production server > > to a new faster box. As DBA, I will move the database and planning to use > > hot backup files in order to minimize the production server down time. Are > > there any issues or drawbacks I need to be aware of if the hot backup files > > are used to replicate the database? > > > > This is 8.1.7 on Solaris 2.7 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: online backup and alter system switch logfile
On Wed, 29 May 2002, Dave Morgan wrote: > You do not need to archive the log files. > > Alter system switch logfile does not return until > the logfile is written to disk. This is demonstrably untrue, and incredibly easy to disprove. Try it yourself! SQL> select group#, sequence#, archived, status, first_time from v$log order by sequence#; GROUP# SEQUENCE# ARC STATUS FIRST_TIME -- -- --- 5 54283 YES INACTIVE 2002-05-29:16:13 4 54284 YES INACTIVE 2002-05-29:17:15 1 54285 NO CURRENT 2002-05-29:17:17 SQL> alter system switch logfile; System altered. SQL> select group#, sequence#, archived, status, first_time from v$log order by sequence#; GROUP# SEQUENCE# ARC STATUS FIRST_TIME -- -- --- 1 54284 YES INACTIVE 2002-05-29:17:15 2 54285 NO ACTIVE 2002-05-29:17:17 3 54286 NO CURRENT 2002-05-29:17:26 -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: online backup and archived redo logs files (Was online backup
The only logs you must back up in order to have a valid online backup are: All the logs between and including the log that was active when you issued the first "alter tablespace ... begin backup" command or RMAN "backup database/tablespace/datafile" command and the log that was active when you completed the last "alter tablespace ... end backup" command or the last RMAN "backup database/tablespace/datafile" command completed. Beyond that, you would need all the logs since your last backup in order to roll forward to an arbitrary point in time. This is a question we can't answer completely for you, because it depends on your recovery needs. Maybe you need to be backing up logs every hour in order to have recoverability to a fairly recent point in time. We can't tell you what you need. Also, when you are citing one of my papers in a widely distributed email, it would be nice to have some attribution. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 29 May 2002, John Dunn wrote: > Can anyone please clarify what archived logs should be backed up when doing > a online backup? > > I have seen various online backup scripts that seem to take different > approaches. > > I have also seem the comment > > "a backup script should never just back up "all the archived redologs." If a > script does not restrict itself only to those logs that it knows to be > archived, it may improperly try to back up an archived redolog that is not > yet completely archived. To determine which logs are archived, a backup > script should query the v$archived_log view to obtain a file list for > copying." -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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 backup question.Thank You
It is pretty easy to restore and recover a single table to an arbitrary point in time from a physical backup. I don't think Oracle needs to provide an extra feature. You restore a small subset of the database (system, rollbacks and the tablespace with the table in it), offline drop the datafiles you didn't restore, and roll the "mini-clone" forward to the point in time you want. Export/import the table from the "mini-clone" into the original database via named pipes. Query flashback won't work past a certain timeframe, and it won't work on tables that have been mangled by DDL (drop/truncate). And you have to use server-managed undo to use query flashback. Personally, there are a lot of queries the developers here have come up with that I have flashbacks of anyway, usually around 3 or 4 in the morning. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 28 May 2002, Rachel Carmichael wrote: > isn't that supposed to be flashback query? :) > > --- Gene Sais <[EMAIL PROTECTED]> wrote: > > maybe 10i will allow table pt in time recovery :) > > > > >>> [EMAIL PROTECTED] 05/25/02 05:53PM >>> > > you mean the export? it's a lot easier to recover a single table from > > an export and let everyone else keep working. AFAIK, Oracle still > > doesn't do table-level recovery, the lowest granularity is > > tablespace. > > > > Also, exports are good at letting you clone users and application > > schemas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: "snapshot too old" error - strange
On Mon, 27 May 2002, Nirmal Kumar Muthu Kumaran wrote: > Increase rollback segment size for this transaction and make sure > that the transaction will use the huge rollback segment I don't think that solution is correct. This is a common misconception about "snapshot too old." Assigning your long-running select to a giant rollback segment will not help solve the problem. Here a short article on this misconception: http://www.speakeasy.org/~jwilton/oracle/snapshot-too-old.html I suspect the original poster is encountering "snapshot too old" as a result of block cleanouts. See the following article for more information: http://home.clara.net/dwotton/dba/snapshot2.htm -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > > -Original Message- > > From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] > > > > There is something strange going on in my production DB. > > There is a program that reads fom 2 huge tables (A and B - select only) > > and > > writes a fraction of records into some third table (let's call it C - > > inserts only). > > Now , NO ONE carries a DML agains A or B . > > But occasionally i get the Ora-1555 - "snapshot too old" error during the > > run of the aforementioned program. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: online backup and alter system switch logfile
On Tue, 28 May 2002, [EMAIL PROTECTED] wrote: > Add a 'sleep' command to your UNIX-side shell script before you copy > the logs to ensure the log has finished writing. You need to have > that last archivelog - it contains the data regarding datafile > header record changes you'll need to apply in the event you have to > restore to sync up your controlfile. Sleep doesn't seem like a very reliable approach here. As has already been mentioned, Oracle provides a command that does not return until the current log is archived. alter system archive log current; In fact, this is one of the Oracle misconceptions I wrote about: http://www.speakeasy.org/~jwilton/oracle/switch-logfile-backups.html -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > John Dunn <[EMAIL PROTECTED]> > > I have a online backup script which issues the command > > ALTER SYSTEM SWITCH LOGFILE; > > immediately before copying the archived redo logs. > > Does this make sense? I am finding that the ARC process has not finished > archiving the log before I copy the archive logs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: What makes Export slow ?
On Mon, 20 May 2002, Reddy, Madhusudana wrote: > The idea of huge rollback segment is just to eliminate the contention the > rollback segment. Well its not always applicable ( possible make sure all > the other applications are not used), but we can create a big rollback > segment and bring it on line and make other rollback segments offline, and > run the export . So definitely the big rollback segment will be used. Used for what? Are you talking about constructing consistent reads? If so, then that shouldn't be necessary on any significant scale if we, as you suggest, "make sure all the other applications are not used." Even if concurrent access is allowed (as it should be) during export, why would constructing consistent reads from a variety of rollback segments cause "contention" conpared to constructing the same consistent reads from one big rollback segment? What are you trying to accomplish with the big rollback segment? What do you think the rollback segments are being used for by an export? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Monday, May 20, 2002 1:04 PM > To: Multiple recipients of list ORACLE-L > > > On Mon, 20 May 2002, Reddy, Madhusudana wrote: > > > Huge Buffer, commit=y, direct=y, assigning the big rollback segment > > should help you to have faster export , > > What do you mean "assigning the big rollback segment?" How do you do > that to an export and what does it accomplish? > > What does COMMIT=Y do in an export? > > If I were the original poster, I'd just look at v$session_event for > the export session after several minutes of slowness. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > > -Original Message- > > Sent: Monday, May 20, 2002 3:43 AM > > To: Multiple recipients of list ORACLE-L > > > > I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster > > processors and more memory space) > > > > I create the database with the same script that I used to for my database > in > > the older machine, > > > > When I export my database from the older machine it was very fast and when > I > > import to newer machine it was fast too, > > > > and when I export from new machine it is really slow (very slow), (I am > > using same export parameters in both servers) > > Can someone help with tuning tips or anything you have... : ( > > > > > > - The no of records are the same for both machines > > - v$session_wait.seconds_in_wait is more than 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: What makes Export slow ?
On Mon, 20 May 2002, Reddy, Madhusudana wrote: > Huge Buffer, commit=y, direct=y, assigning the big rollback segment > should help you to have faster export , What do you mean "assigning the big rollback segment?" How do you do that to an export and what does it accomplish? What does COMMIT=Y do in an export? If I were the original poster, I'd just look at v$session_event for the export session after several minutes of slowness. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Monday, May 20, 2002 3:43 AM > To: Multiple recipients of list ORACLE-L > > I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster > processors and more memory space) > > I create the database with the same script that I used to for my database in > the older machine, > > When I export my database from the older machine it was very fast and when I > import to newer machine it was fast too, > > and when I export from new machine it is really slow (very slow), (I am > using same export parameters in both servers) > Can someone help with tuning tips or anything you have... : ( > > > - The no of records are the same for both machines > - v$session_wait.seconds_in_wait is more than 10000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Connecting to Oracle without using Listener
You can connect directly to a dispatcher you have started on a different port. No listener required. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 17 May 2002, Keith Peterson wrote: > if your real question is "can I circumvent the > listener", the answer is "no". > > Keith > > > Date: Thu, 16 May 2002 19:33:46 -0800 > To: "Multiple recipients of list ORACLE-L" > > Is it possible to connect to Oracle DB server using > DBI/ODBC through > TCP/IP > with or without using Listener at port 1521? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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-L gathering etc.
On Wed, 1 May 2002, Connor McDonald wrote: > Having seem some of the presenters in action, I can > heartily recommend the seminar in Oz to anyone that > can get there...I can also heartily recommend Oz as > easily the best place on the planet! (touch of bias) > > ... also interesting is that under my piddly old > Netscape 3 I can see the "Great Buy" offer Jonathan > alludes to, but it does not appear under IE 5.5 > > Jeremiah - comment? Well having never been down under it is a little hard to comment. Being under the restrictions of employee NDA with the zon, it is even harder to say. But I'll give you this: It isn't the flavor of browser. Also, remember when posting that you can specify Amazon detail page URLs as shorter strings by cutting off everything after the ISBN, like so: http://www.amazon.com/exec/obidos/ASIN/0201715848 -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > --- Jonathan Lewis <[EMAIL PROTECTED]> > wrote: > > > Talking of forums (fora ?) of Oracle-L members, > > it occurred to me that I haven't seen Mogens > > mention here DBF 2002 which he is organising > > in Sydney on May 27th / 28th. > > > > Apart from putting up with Mogens talking, there > > is a dazzling array of well-informed individuals > > who have volunteered to give several presentations > > on an educational nature about Oracle. > > > > For more details see: > > > > http://miracleas.dk/events/DBF2002AU/invitation.html > > > > And if you need a little light reading to keep you > > going > > through the flight there, Amazon.com is currently > > doing > > a special offer on the books by the "non-US trio" of > > James Morle, Steve Adams, and Jonathan Lewis. > > > > > http://www.amazon.com/exec/obidos/ASIN/0201715848/qid%3D974459938/sr%3 > > D1-12/103-3940479-8339835 > > > > (which URL will probably get broken and wrapped) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: PATCH?
RTFM. http://www.bcpl.net/~rgarriqu/babyman.html -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 29 Apr 2002, [EMAIL PROTECTED] wrote: > > EPIDURAL.. > > advice from the recently hatched (eight month old little girl:>) > > > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Koivu, Lisa" ><[EMAIL PROTECTED]> > Sent: Monday, April 29, 2002 4:54 PM > To: Multiple recipients of list ORACLE-L > Subject:PATCH? > > How to give birth? Please advise. > > Thx. --Lisa > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Koivu, 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). > > -- 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: System datafile corruption.
Why don't you verify that the corrupted block belongs to the segment you think it does, or belongs to a segment at all? select owner||'.'||segment_name, segment_type from dba_extents where file_id = and 67108870 between block_id and (block_id + blocks - 1); -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 18 Apr 2002, Jenner Mike wrote: > I have a system datafile that returns dbv errors for a SYSTEM > datafile. > > The fault has existed for a long time undiscovered so recovery from backup > is not possible. The database still does not exhibit any problems except for > dbv! > The errors are all 'Block Type = Undo data block', so I assume the fault is > in the system rollback segment. > > I'm sure I can't drop/recreate the SYSTEM rbs, so does anyone have any > suggestions apart from a full export and import? > > Dbv extract is below: > > > Block Checking: DBA = 67108870, Block Type = Undo data block > > ERROR: Undo Block Corrupted. Error Code = 2008 > > ktu4ubck: size(108) of undo record #1 corrupted. > > UNDO BLK HEADER: > > xid: 0x.08a.0151 seq: 0x198 cnt: 0x4d irb: 0x4d icl: 0x0 flg: > 0x000 > 0 > > Rec Offset | Rec Offset | Rec Offset | Rec Offset | Rec Offset > > --- > > 0x00 0x1fe8 | 0x01 0x1f80 | 0x02 0x1f2e | 0x03 0x1ee0 | 0x04 0x1e76 > > . > . > 0x4b 0x027c | 0x4c 0x0212 | 0x4d 0x01b0 > > Hex dump: > > 0x000b6b94(+): 00 0a 00 10 00 3c 00 10 00 02 00 00 2a 11 00 00 > > . > . > 0x000b6bf4(+0060): 00 9d 00 00 78 bc 01 00 > > > > grep 'Block Type' dbv_log | wc -l > 127 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Upgrade 8.0.5 to 8.1.7.3 (fwd)
On Wed, 17 Apr 2002, John Weatherman wrote: > Clean up fragmentation/chaining, change block size at the same time, > in my current case, chage hardware platform... > > All sorts of reasons. :) What do those things have to do with an upgrade? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > On Wed, 17 Apr 2002, Browett, Darren wrote: > > > The previous DBA, also used the export/import method, and is the method > > I am most likely going to use. > > Can someone explain why anyone would opt for export/import as a path > to do an 8.0 to 8.1 upgrade? Doesn't the basic upgrade just consist > of starting the instance on the new ORACLE_HOME and running an upgrade > script? Why would someone undergo the disruption and complexity of a > full export/import when you can just leave the data where it is? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Upgrade 8.0.5 to 8.1.7.3
On Wed, 17 Apr 2002, Browett, Darren wrote: > The previous DBA, also used the export/import method, and is the method > I am most likely going to use. Can someone explain why anyone would opt for export/import as a path to do an 8.0 to 8.1 upgrade? Doesn't the basic upgrade just consist of starting the instance on the new ORACLE_HOME and running an upgrade script? Why would someone undergo the disruption and complexity of a full export/import when you can just leave the data where it is? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > Create the new ORACLE_HOME (8.1.7) > Patch to rev desired (8.1.7.2 or 8.1.7.3) > Export from 8.0.5 > Import to 8.1.7.x > Upgrade application. > Test like crazy. > > -Original Message- > Sent: April 17, 2002 7:43 AM > To: Multiple recipients of list ORACLE-L > > we are in the process of upgrading to 8.1.7.3 some of our databases (now > 8.0.5) > According to the Doc's thsi has to be done in two steps > Upgrade to 8.1.7.0.0 followed by and upgrade to 8.1.7.3.0. > > This means that we have to upgrade all our databases in one go, or install > another base 8.1.7 install to do some databases later. > > On our test system however we have upgraded directly form 8.0.5 and all > seems to be fine. > > Anybody care to comment/share their opinions/experiences -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: upgrade from 8.1.6 to 8..1.7.3
Sounds like a documentation bug in the readme. I have always patched the software to the highest available patchset plus one-off patches, then switched the instance to the new ORACLE_HOME and ran the upgrade scripts. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 17 Apr 2002, Jeffrey Beckstrom wrote: > On the same server running 8.1.6.1.5 and 8.1.7.3.2. > > Now ready to upgrade the 8.1.6 database to 8.1.7. > > Our 8.1.7 is 8.1.7.3.2, in the 8.1.7.3.0 readme it stated: > Database Migration > When migrating a database from an earlier release, for instance 8.0 to 8.1, you > must complete the database migration to the 8.1.7 release prior to applying > this patch set. You cannot perform the 8.1.7 migration after a patch set has > been installed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: EMC Storage Array Issue
Which filesystem/volume manager are you using, if any? That is potentially where you would want to look if the async write queue is getting backed up. Just shutting off async is a terrible suggestion from EMC. I am suprised at them. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 15 Apr 2002, Scott Canaan wrote: > We have implemented a Sun Solaris Cluster (4 machines), connected to > an EMC storage array. The migration began last fall, and we now have 15 > Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We > recently have had 2 occurances of asynchronous I/O wait times exceeded. > When this occurs, every database crashes at the same time. The solution > from EMC is to turn asynchronous I/O off in all of the Oracle instances > (disk_async_io = false) and to increase the database writer slaves > (dbwr_io_slaves = ) to emulate asynchronous I/O. > Has anyone run into this problem before? If so, how did you > "correct" it? My feeling is that EMC is trying to give us a bandage to > cover up the real problem, by trying to get Oracle to ignore it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: protocol.ora
If you trace the listener you will see that it is looking for .protocol.ora with a leading period. This is a documented bug. Just copy protocol.ora to .protocol.ora. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 12 Apr 2002, Sajid Iqbal wrote: > We used to use the protocol.ora file to restrict access to the database, > on oracle 8.0.5 > > However since moving to Oracle 8.1.6.3 this doesn't work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
Decyphering LMT space bitmap
Out of curiosity I decided I wanted to look at what composed the extent map in locally-managed tablespaces. I dumped the first 5 blocks of the tablespace's first datafile with 'alter system dump datafile ...' The results surprised me, as they appeared to consist of almost no data. The LMT in question contains a variety of segments and extents. How is the LMT bitmap organized? Start dump data blocks tsn: 1 file#: 2 minblk 1 maxblk 1 Block 1 (file header) not dumped: use dump file header command Start dump data blocks tsn: 1 file#: 2 minblk 2 maxblk 2 frmt: 0x02 chkval: 0x type: 0x1d=KTFB Bitmapped File Space Header File Space Header Block: Header Control: RelFno: 2, Unit: 8192, Size: 524352, Flag: 1 Initial Area: 3, Tail: 524292, First: 30, Free: 34 Start dump data blocks tsn: 1 file#: 2 minblk 3 maxblk 3 frmt: 0x02 chkval: 0x type: 0x1e=KTFB Bitmapped File Space Bitmap File Space Bitmap Block: BitMap Control: RelFno: 2, BeginBlock: 5, Flag: 0, First: 30, Free: 128994 FF3F ... all zeros Start dump data blocks tsn: 1 file#: 2 minblk 4 maxblk 4 frmt: 0x02 chkval: 0x type: 0x1e=KTFB Bitmapped File Space Bitmap File Space Bitmap Block: BitMap Control: RelFno: 2, BeginBlock: 1056964613, Flag: 0, First: 0, Free: 129024 ... all zeros FWIW: SQL> select count (*) from dba_extents where file_id = 2; COUNT(*) -- 30 SQL> select extent_management from dba_data_files df, dba_tablespaces ts where df.tablespace_name = ts.tablespace_name and file_id = 2; EXTENT_MAN -- LOCAL -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Insert statement hangs
v$session_wait -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 3 Apr 2002, [EMAIL PROTECTED] wrote: > I am trying to insert a record thru sql*plus into a table. I am the only > one accessing database. It just hangs and never inserts. What I can I > look at to help determine why this is happening? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
