RE: freebie. Summarize Oracle Listener logs

Sorry - meant to send just to Steve Please ignore -Original Message- Hallas, John, Tech Dev Sent: 05 January 2004 11:19 To: Multiple recipients of list ORACLE-L Steve, I have an awk script which does something similar - see code and example below However I can put your file on my

RE: freebie. Summarize Oracle Listener logs

s our current logs or older stuff. Rather than pasting both of them inline, email me and I'll send them out. if you want it bad :), email me at work <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] otherwise use [EMAIL PROTECTED] and I'll get to it when I get home. if somebody optimi

RE: Code Conversion from MSSQL into Oracle

ROM cur_temp_GEMT INTO @branch_id, @entity_id END CLOSE cur_temp_GEMT DEALLOCATE cur_temp_GEMT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Servi

RE: shareplex: datatype unsupported

ing: UNSUB ORACLE-L (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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Networ

RE: A quick note

iling 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://

RE: how to check 32 or 64 bit?

ommand for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mai

RE: translate, replace...?

ltiple recipients of list ORACLE-L Looks like you've got "one too many" REPLACEs. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Hallas, John, Tech Dev Sent: Wednesday, September 17, 2003 11:00 AM To: Multiple recipients of list ORACLE-L IA, The following co

RE: translate, replace...?

ote EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:/

RE: get sid (session id) and serial#?

ed 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: Corniche Park > INET

RE: How can I measure my DB performance.

m this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like

RE: Oracle on Win2000

, Bala. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: sqlload

on (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Permissions error

C OSF/1 (AXP) Error: 13: Permission denied Did some permissions get corrupted. I am able to connect using sqlplus from my oracle account. This happens when I try to connect from a different account. Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:

RE: Permissions error

count. Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting ser

RE: Some posts not showing up

ntaining: UNSUB ORACLE-L (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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City

RE: get sid (session id) and serial#?

--- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also s

RE: Congratulations Arup (DBA of the Year)

'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 --

RE: number of active members in this list

containing: UNSUB ORACLE-L (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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat Ci

RE: speeding up conventional path sqlldr

stGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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

RE: SharePlex

n error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Networ

RE: SharePlex

licy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Die

RE: sar

pelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.ne

RE: 8.1.7.4 interim patch management strategy

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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 ht

RE: Extproc setup Q?

le/app/product/9.2.0) (SID_NAME = ora92) ) ) TIA Jack van Zanen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-505

RE: DB_BLOCK_LRU_LATCHES , multiple buffer pools , oracle9i

containing: UNSUB ORACLE-L (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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat Ci

RE: faq broke? -- Other options

PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: rman legato 32 vs 64 bit conflict.

t 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatci

RE: any script to parse alert log ?!

elf from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other inform

RE: Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues

o 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-50

RE: Urgent: Need Oradim.exe for version 8.1.6

ed attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohi

RE: Re: Rule Based Optimizer

-- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name

RE: dbms_stats via dbms_job - syntax question SOLVED

; method with "naming": either you use formal parameters, or not. It seems like you need "naming". I used CHR(39) to get quotes around schema name. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Hallas, John, Tech Dev Sent: Tuesday, June 10, 2003 9:35 AM To:

RE: Deleting Statspack tables.

containing: UNSUB ORACLE-L (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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City

RE: dbms_stats via dbms_job - syntax question

ored procedure, you can not mix and match "positional" method with "naming": either you use formal parameters, or not. It seems like you need "naming". I used CHR(39) to get quotes around schema name. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Ha

dbms_stats via dbms_job - syntax question

ppaer to exist any more John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

RE: 9.2.0.3 online index builds resolved (we hope)

L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing). (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Hallas, John, Tech Dev (B INET: [EMAIL PROTECTED] (B (BFat C

RE: Function Based Index - Not Used ???

ww.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

RE: alter table add

procedure .It can't find that column . is it a bug ? 8.1.6. hp-ux -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Calif

RE: certifications was Re: Remote DBA

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 messag

RE: Anyone whom could explain this?

n (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Californ

RE: Oracle Job Task Analysis

ODY, include a line containing: UNSUB ORACLE-L (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: Hallas, John, Tech Dev INET: [EMAI

RE: Backup Strategy

the message BODY, include a line containing: UNSUB ORACLE-L (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: Hallas, John, Tech Dev INET: [E

RE: Backup Strategy

w.orafaq.net -- Author: Hallas, John, Tech Dev 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 you

RE: Re: OCP

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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Networ

RE: "Is Anybody Out There" - Pink Floyd

FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev 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

RE: Make first character Versal

Title: RE: Make first character Versal The following sql gives the first character of a column. I am sorry but I don't know what you mean by VERSAL select substr(version,1,1)  from database_control John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 27

RE: Archiving Data Strategies.

Title: RE: Archiving Data Strategies. As you say Ian partitioning is a obvious answer as I imagine the billing data will be quite easy to range partition using dates. However why go to 9i, 8i has many partitioning options and it may be an easier upgrade as well as a leap that management might

RE: Convertion from Figures to Words

Title: RE: Convertion from Figures to Words I can get the following to work with a date format but I cannot see how to do it with just plain numbers. If nobody else comes up with an answer then I suppose  you could use DECODE or populate a reference table with each number and it's alphabetic

RE: Concatenating formated number and date doesn't work

Title: RE: Concatenating formated number and date doesn't work Well spotted Catherine. I got it working by wrapping an LTRIM round the TO_CHAR(12345,'099') line John -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 08:18 To: Mul

RE: Cronjob misbehaving

Title: RE: Cronjob misbehaving It looks as if your ORACLE_HOME is not being set up. Try either or both of the following 1) Amend your cron job to look like the following (I assume you are running this as user oracle) 0 5 * * * su - oracle 'usr/scripts/recompile.sh' > /ops/scripts/recompile

RE: cannot create bitmap index "feature not enabled"

Title: RE: cannot create bitmap index "feature not enabled" Forget my previous reply regarding query_rewrite privileges  - I misread it as a FBI question not a BMI one - enough of these TLA BFN! John -Original Message- From: Joe Raube [mailto:[EMAIL PROTECTED]] Sent: 20 March

RE: cannot create bitmap index "feature not enabled"

Title: RE: cannot create bitmap index "feature not enabled" Try granting the query_rewrite and query_rewrite_enabled (check spelling first) privileges to the user -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 March 2002 14:28 To: Multiple recipients o

RE: More info on sql query running slow

Title: RE: More info on sql query running slow The query in itself seems quite well optimised in my opinion, although 30 seconds does seem quite long relative to what is possible. What I do not understand is why the query uses the PCON_CMPY_FK index on the PHY_CONTRACTS table when that field

RE: Oracle Certification Upgrade 8 to 8i

Title: RE: Oracle Certification Upgrade 8 to 8i Manoj I am in the same situation and looking at the IZO-020 exam as well. It is 8 that is due to retire , IZO-020 is an 8i exam. You have plenty of time to take the exam. John -Original Message- From: Manoj Jain [mailto:[EMAIL PROTE

RE: Identification of tables NOT being used in the System.

Title: RE: Identification of tables NOT being used in the System. There was a note previously on a similar theme which I have posted below. The dba_tab_modifications does not show when a table has been selected from which could be a problem for reference data type table which can easily be ove

RE: Fav. Urban Legend...

Title: RE: Fav. Urban Legend... Patrice, Given the current state of the job market I am not sure if this is myth or fact John -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 12:18 To: Multiple recipients of list ORACLE-L Subject: R

RE: Anyone use V$SESSION_LONGOPS ???

Title: RE: Anyone use V$SESSION_LONGOPS ??? There have been a few posts today which are repeat posts from a few days ago -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 12:53 To: Multiple recipients of list ORACLE-L Subject: RE: Anyone use V$SESSION

RE: Time for a reorg?

Title: RE: Time for a reorg? Having a sulk Mark?  :-) There may be a number of factors involved here 1) Database well designed and managed and reorganisation does not become a problem 2) Regular use of alter table move and rebuild index reduces/removes the need to reorg 3) LMT and well si

RE: RE: Time for a reorg?

Title: RE: RE: Time for a reorg? Thanks Dick, I think what you are saying ties in exactly with my post on the matter John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 13:53 To: Multiple recipients of list ORACLE-L Subject: Re:RE: Time f

RE: Poll & Questions

Title: RE: Poll & Questions I agree the work involved in creating a representative subset of data , complete with full RI in place can be quite significant. I know there are tools in place that do some of the work (Checkmate by BitybyBit and Quest have one  - data factory I think) but these al

RE: Free scripts

Title: RE: Free scripts I use Tim Onion's site which has a comprehensive listing of basic DBA scripts and there is also a zip file to download the lot in one go. www.timonions.com John -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 22:54 T

RE: problem in creating control file?

Are you sure the sid is set to the new sid (TEST2) and also add a SET command in the first line CREATE CONTROLFILE SET DATABASE "TEST2" RESETLOGS ARCHIVELOG      HTH   John -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 12 March 2002 11:48To: M

RE: local partition index question

Title: RE: local partition index question This subject nicely raises an question(s) I have. We have some tables complete with PK and FK's referencing them. We have now added a create_timestamp column to the tables and wish to partition the tables using the range (create_timestamp). No proble

RE: Number / 0

Title: RE: Number / 0 Sinardy You are trying to create a function based index. To do so you need the query rewrite privilege The index will still fail with a divide by 0 error (don't know why you are dividing by zero) AS USER create index wrong_logic on john(income/0)  

How's the job market - UK - (slightly OT)

Title: How's the job market - UK - (slightly OT) Here in the UK it has been pretty bad but from all accounts I understand there to be a bit of light at the end of the tunnel As I have just been given notice I would appreciate anyone on the list in the UK or Europe who knows of DBA vacancies

RE: vxfs File System full - it's not, and it's not Oracle (I don'

Title: RE: vxfs File System full - it's not, and it's not Oracle (I don't think) David, Why does the SA say it is an Oracle issue? The error message shown refers to a LV that is full (allegedly) that happens to contain some files owned by the oracle user. Sorry if I am being a bit dense but

RE: Function based indexes

Sergey,   I did a quick test which indicates that no special path is mentioned when using a FBI, instead the execution plan will show that an index is being used, which it would not do if a FBI had not been set up. The example below shows what I mean   HTH   John     SQL> create index joh

RE: Pinning Packages in the Shared Pool??

Title: RE: Pinning Packages in the Shared Pool?? John, I understand this still to be true or at least I have never heard anything to oppose it. Looking at the latest book I have purchased (101 Performance Tuning) the authors do talk about the principle and state "many database administrators

RE: ORA-27072

Have a word with your sysadmin. See if I can find out what/who is using that file Are all datafiles/control files and redo log etc owned by the same user (Oracle) and with the same permissions Seems odd that it appears to be random across a number of files   HTH   John -Original Me

RE: SQL Loader:How to load data with carriage return embedded

Arul, Interesting problem. We had a similar situation and used AWK instead after a bit of head-scratching. The following code worked for us   BEGIN{     FS="`"     first=0 } {     if (substr($1,1,3)=="KB0"){  -- to identify each new record which starts with

RE: 8i and Veritas NetBackup

Title: RE: 8i and Veritas NetBackup The folloiwng is a good post from Samir which I kept. It seems to cover your environment well. Hope it helps John Hi, In order for RMAN to work with a third party backup product the third party vendor writes an interface to an Oracle supplied API and sup

RE: Woopeee and TWO ORA-600's!

Title: RE: Woopeee and TWO ORA-600's! Mark, Here are a couple of notes I saved on the subject John rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following.   If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql

RE: Woopeee and TWO ORA-600's!

Title: RE: Woopeee and TWO ORA-600's! Mark The ora600 lookup  tool on Metalink states that there is no description for this code John -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 09:34 To: Multiple recipients of list ORACLE-L Subject: Woopeee an

RE: OPS DBA work (was dumb question)

Title: Message Bjorn, I don't have any issues with what you say - in fact it really agrees mostly with what I stated. You have added 2 important factors though, better application knowledge and use of raw file systems. I use Compaq Tru64 so that does not require raw files systems but other

RE: How to find out what caused job to fail?

Title: How to find out what caused job to fail? How bizarre. Roland asked a question about where does he find alert log & trace files   (answer  = select name,value from v$parameter where name like '%dest%') or check your init.ora file   at least 10 minutes before this message came to me.

OPS DBA work (was dumb question)

Title: Message Shreeni,   The mangement of a OPS system does not require any extra skills or facilities. Areas that are different or need more attention from a standalone instance include the following :   Management and tuning of internode communication. Specifically reducing the level of p

RE: Rman again. Long screen output removed/SOLVED

ong screen output removed/SOLVED Hi All, It was an Oraclebug. The only , very workable, workaround Oracle could come up with is to set NLS_DATE_FORMAT at Unix level and use : set time until 'string';  (STRING BEING IN THE FORMAT OF NLS-DATE_FORMAT AT UNIX LEVEL) 9.0.2 is suppose

RE: RTFM questions (formally RE: PL/SQL)

Title: RE: RTFM questions (formally RE: PL/SQL) Kevin, I am afraid your post shows a distinct lack of ambition. :-) No flames please John -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 30 January 2002 08:50 To: Multiple recipients of list ORACLE-L Subject: R

Alter system check datafiles

Title: Alter system check datafiles Paul Sherman wrote 'I tried an 'alter system check datafiles' I had never come across that command before and looked at the documentation which states that 'in a distributed database system, such as an Oracle Parallel Server environment, updates an instan

RE: Web site of messages

Title: RE: Web site of messages I also found this site by searching Google for Oracle-L http://faqchest.dynhost.com/prgm/oracle-l/ -Original Message- From: Marin Dimitrov [mailto:[EMAIL PROTECTED]] Sent: 30 January 2002 08:00 To: Multiple recipients of list ORACLE-L Subject: Re: Web

RE: Rman again. Long screen output removed

Title: RE: Rman again. Long screen output removed Jack, Your date format is set until time  'to_date(''29012002094700'',''ddmmhh24miss'')'; whereas one that works for me and matches the documentation is set until time "to_date('18-SEP-2001 01:00:00','dd-mon- HH24:M

RE: auditing tables

Title: RE: auditing tables Auditing is a definite overhead but the degree varies depending on what auditing is set up and how many transactions you have. Auditing can tell you who did what to a table (IUD etc). What it will not do is store before and after values. If that is what you want the

RE: Unix script

Title: RE: Unix script Basis of a script added into yours below. Note I am only checking to see if there is a PMON proces up - maybe best to make a sqlplus connection and read v$instance or something and exit if it fails. Really very poor but will give you something to work on. What I don't

RE: RMAN and ORA 8.1.7 on NT/W2K

Title: RE: RMAN and ORA 8.1.7 on NT/W2K Allen, I am sure you can continue in the same manner as before if you wish. I am no NT expert but we are using hot backups on a variety of Unix and NT servers using 8.1.7. We also have some RMAN backups as well. Carry on with the hot backups and then pe

RE: COPY vs. OCOPY on NT

Title: RE: COPY vs. OCOPY on NT Try http://www.speakeasy.org/~jwilton/oracle/hot-backup.html for a view on this John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 January 2002 09:20 To: Multiple recipients of list ORACLE-L Subject: RE: COPY vs. OCOP

RE: Query

Title: RE: Query Short for machine John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 January 2002 12:50 To: Multiple recipients of list ORACLE-L Subject: RE: Query What is: m/c ??? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] >

RE: More Rman q's

Title: RE: More Rman q's Jack, TEST3 instance should be exactly as you stated, an Oracle instance with no datafiles as yet. What I think I was meaning regarding the names of the objects is that the format is Rman catalogue = catalogue Source database  = target new database   = auxilliary.

RE: Re: How can I tell if a procedure/package is running?

Title: RE: Re: How can I tell if a procedure/package is running? Sinardy, This only tells you if an object exists not if it is running - or even if it is valid unless status is elected from dba_objects as well. There was a thread around 30/10/01 with the appropriate title 'How can I tell if a

RE: Sqlloader

Title: RE: Sqlloader See the following note sent on 4/12/01 - it should assist John Try the following example: TMD=`date '+%Y/%m/%d'` TMS=`date '+%Y%m%d%H%M%S'` sqlplus -s internal < set verif off pages 0 echo off feed off term off lines 200 spool $SHELLSRCDIR/dbcontents.$TMS.

pinning objects

Title: pinning objects I wrote a database tuning document a while ago and the notes below are from the section on pinning. I do recall that the final comment re the difference betwen pinning and keeping was from a Steve Adams response to a question on this list. The library cache forms par

RE: pinning objects

Title: RE: pinning objects I wrote a database tuning document a while ago and the notes below are from the section on pinning. I do recall that the final comment re the difference betwen pinning and keeping was from a Steve Adams response to a question on this list. The library cache forms pa

RE: login/exit problems

Title: RE: login/exit problems There was a problem with  Oracle Trace being set in some V7 instances. A couple of files grew quite large. STOP PRESS just checked on Metalink and found note 45482.1 This suggest checking the $ORACLE_HOME/otrace/admin directory for a file process.dat and see if

RE: Becoming a DBA questions

Title: RE: Becoming a DBA questions Mark, Why do you sound so  suprised Mark? £120 / hour - wouldn't get out of bed for that. As Lee says he is either very lucky, specialised or both. Wherever the job is in the UK I will undercut by £10/hour :-) John -Original Message- From: Rob

RE: Criteria for handoff from development

Title: RE: Criteria for handoff from development Taking a slight diversion away from data modelling issues a set of Production type issues need to be addressed prior to going live These could include Signed off user acceptance testing, Backup strategy, devised, tested and signed-off Expecte

RE: Problem Granting Roles

Title: RE: Problem Granting Roles What exactly is the error message - if it is table or view does not exist (ORA-904) then I suspect that it is synonyms that are not working/created. get the user to select from the full table name sys.x and see what happens. -Original Message- F

RE: XP Professional & 9i

Title: RE: XP Professional & 9i I think it is our problem actually because the majority of questions you ask could be answered quite easily by looking at the manual or using Metalink. Is your company just a one or 2 man band or is it a reasonably sized company. If so I would have thought that

RE: Exp / Imp Utility Questions

Title: RE: Exp / Imp Utility Questions 1) You cannot have read the docs to well not to know the answer to Q1 Hint  - look at the ignore parameter to imp 2) It all depends if the triggers have been run once to change the data that is now in the conversion db. You may have a trigger that adds 1

RE: online backup help

Title: RE: online backup help Jain, This is not really an Oracle issue, rather a sys admin one. Hot backup is Oracle method of ensuring that a datafile can be copied whilst still in use. So just issue the command to put it into backup mode, backup the file by whatever means and then take the

RE: unused blocks BELOW HWM - Thanks

Title: RE: unused blocks BELOW HWM - Thanks I agree with your reasoning Dennis. I have long felt that one of the problems with the list is that the original raiser of the question should have some sort of responsibility for summarising the various responses and posting a short summarised reply

RE: Deinstalling JServer

Title: RE: Deinstalling JServer Cherie - see the post below from sunilshivappa -  12/11/01 John +++ rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following.   If for any reason the installation fails then $ORACLE_HOME/javavm/install/r

  1   2   3   >