RE: another listener.ora

Morning, The listener starts using the file listener.ora in the directory pointed to by the environment variable TNS_ADMIN. By default this is set to $ORACLE_HOME/network/admin or $ORACLE_HOME/net80/admin depending on the Oracle version (%ORACLE_HOME%\net... on Windows). You can set the

Re: ORA-00600 error

Title: Message Yes I am running 8.1.7.3 .. Is this a bug ? What will I do then? Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database

Stanby Database- Archive Transfer Problem

Title: Stanby Database- Archive Transfer Problem Oracle 8.1.7 and WINNT4 Our Standby database was running smoothly but due to some reasons we had to reconfigure it. We have used the same init parameter file which we used earlier(to have the exact parameters). The standby database was

LGWR Error

Hi all, My instance was terminated by the LGWR bg process and the trace files reference error 7211, which I don't think is an oerr. Any clue about the possible cause ? --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat

RE: Stanby Database- Archive Transfer Problem

Title: Stanby Database- Archive Transfer Problem If you find a solution for this, I would be interested in it. We have the same problem, same platform. Somatimes SAP starts some kind of processing and the network load increases enormously. And the archive log transfer fails after a while.

RE: LGWR Error

Simon, My 8.1.7.3 system returns this description from oerr : 07211, 0, slgcs: gettimeofday error, unable to get wall clock. // *Cause: Gettimeofday system call returned an error. Possible OS error. // *Action: Check additional information returned in OS reference manual. //

RE: LGWR Error

Mike, DB restarted with some delay in shut down immediate(due to tx recovery). I've gone through oerr 7211 and subsequent workarounds from metalink which point to a bug -failure of bg processes to withstand OS errors. Trouble is that my traces/alert are very quiet about the possible system error:

RE: AUTOMATIC SHUTDOWN/STARTUP SCRIPT

msg40478/bin0.bin Description: application/pkcs7-mime

Deleting old archive log files.

Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All

RE: LGWR Error

Simon, this looks like a long standing issue though I've personally never hit it. Bug 2001757 looks like a good match unfortunately it states that a fix has been prepared and will be available in v9.2. Not much help. Also no sign of a backport for it. You could try tracing the LGWR process from

RE: Stanby Database- Archive Transfer Problem

The quick answer to this one is : Try using more online redologs, adding them is a fairly simple RTFM. From looking at the setup you describe, I think you have two issues with your standby database. Which one you fix will depend on how you want the system to behave. It looks like you are

RE: LGWR Error

The OS system call gettimeofday() is returning an error. This is a reported bug. And its number is 2001757. For more info take a look in Metalink. Regards. --- Hately Mike [EMAIL PROTECTED] wrote: Simon, My 8.1.7.3 system returns this description from oerr : 07211, 0, slgcs:

Re: Deleting old archive log files.

I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL

View creation error on a table with grant through a role?

Hi, Is it normal that connect x/x select id, name from y_schema.table1; execuites fine, but connect x/x create or rpelace view v_myview( id, name) as select id, name from y_schema.table1; fails? User X has grants on y_schema's table1 through a role only. TIA, Tamas Szecsy -- Please

RE: EMC question

This is true - but then again... raw doesn't cost anything... ...Quick IO and cached Quick IO do :-) I only raise the point because in these days of lvm's (gui and/or otherwise) and enterprise backup products, I often fail to see the managment difficulties with raw devices. Cheers Connor ---

RE: View creation error on a table with grant through a role?

Maybe, what was the error you got? Regards, Mike Hately -Original Message- Sent: 04 April 2002 12:28 To: Multiple recipients of list ORACLE-L Hi, Is it normal that connect x/x select id, name from y_schema.table1; execuites fine, but connect x/x create or rpelace view v_myview(

Re: View creation error on a table with grant through a role?

Hi To create a view or procedure the rights have to be granten to the person directly and not through a role So yes, quite normal behaviour (maybe not wanted) Jack

DEFERRED FK Constraint

Hi all, When testing behaviour of INITIALLY DEFERRED foreign key constraints I'm confused by the following behaviour and I'd appreciate any interpretation! I create the FK constraint on a column in a 1 million row table. This works OK - if I update individual entries to nonsense values,

RE: View creation error on a table with grant through a role?

you need grant with admin option for creating view on a table owned by someone else. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of

RE: Deleting old archive log files.

I think you can use pearl script. Thanks, Ashoke -Original Message- Sent: Thursday, April 04, 2002 5:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from

recordset as argument

Hi Gurus ! Is it possible to pass recordset or cursor as argument in stored procedure?? thanx in advance.. Shishir Kumar MishraAgni Software (P) Ltd.www.agnisoft.com

RE: Deleting old archive log files.

Mark, I have a simple Perl script that can do the job for you. I've not found a way to do this using NT scripting. Attached is the script. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:43 AM To: Multiple recipients

RE: another listener.ora

BP, John's example below is the proper way to do this - not having separate LISTENER.ORA files. Once you have the file setup as below, you simply: lsnrctl start LISTENER_LIVE lsnrctl start LISTENER_DEV Also look at the SET CURRENT_LISTENER command within lsnrctl to use the STATUS

RE: DB Trigger to control PK change

Thanks to all that reply, I will make a try Ramon -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of John Carlson [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 8:33 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:

RE: recordset as argument

In Oracle 8.x you can pass in a INDEX BY Table, Varray, etc. In Oracle 9i a procedure can accept a REF CURSOR as an input parameter. Caver -Original Message-From: Shishir [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 04, 2002 8:08 AMTo: Multiple recipients of list

RE: DB Trigger to control PK change

My version is 8.1.7.3 on AIX and Solaris. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Jesse, Rich [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 6:24 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:RE: DB

RE: View creation error on a table with grant through a role?

:-O Thanks. Its funny. Could some one please point me to some online docs (OTN)? Just to see the logic behind this - for me unwanted - feature? Tamas -Original Message- Sent: Thursday, April 04, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Hi To create a view or

Re: Stanby Database- Archive Transfer Problem

What do the interface stats look like? netstat -i If you have excessive interface errors (sounds like you do) then set up a private lan between the primary and standby, after you wake the guy who is responsible for lan operations. On Thu, Apr 04, 2002 at 03:28:20AM -0800, [EMAIL

RE: Deleting old archive log files.

Tom, This is perfect! Thanks! Best wishes Mark -Original Message- Thomas F Sent: 04 April 2002 14:04 To: Multiple recipients of list ORACLE-L Mark, I have a simple Perl script that can do the job for you. I've not found a way to do this using NT scripting. Attached is the script.

Re: RMAN Core dumps while restoring datafile

I don't think you need to take the tablespace offline. I never do when I restore a datafile. The database must be in mount state also. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 4:13 PM Greetings all, I

RE: Deleting old archive log files.

Install the resource kit. Use the command forfiles. (I don't remember the syntax.) Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246 -Original Message- Sent: Thursday, April 04, 2002 4:39 AM To: Multiple recipients of list ORACLE-L Hi All, To save me

Re: Deleting old archive log files.

Hi Mark, We use xxcopy utility to do that. but here is the sample script to do this. http://www.ultratech-llc.com/KB/?File=DelOld.TXT Delete Files Older Than XX Days Last Modified: 15 Aug 2001 ~~~ *** PLEASE NOTE: Link(s), If Provided,

Re: sysdba

[EMAIL PROTECTED] wrote: the acoount that i used was oracle account. primary group is oinstall and secondary is dba. try chenging it to the other way around. with DBA as the primary and oinstall as the secondary. that's the way i always set the oracle account up and i've had no problems

RE: How to use Email server in 9iAS.

Hi What couldn't you download from OTN and why. OTN has the following manuals which I downloaded - Planning Guide, Installation Guide, Administration Guide and Developers Guide. I toyed with the idea of setting up the Email Server for mass mailings (not spam!) with personalized text from an

RE: recordset as argument

Hi Caver, Can u pls give in details with a sample code, if posible the implementation of the recorset(or resultset) in REF CURSOR. With Regards Rakesh Banerjee From: Toepke, Kevin M [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: recordset as argument

Read FM on "reference cursor". Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Shishir To: Multiple recipients of list ORACLE-L Sent: Thursday, April 04, 2002 8:08 AM Subject: recordset as argument Hi Gurus ! Is it possible to pass

RE: View creation error on a table with grant through a role?

I have the grant via a role. You can not grant to a role with grant option! Tamas -Original Message- Sent: Thursday, April 04, 2002 2:39 PM To: Multiple recipients of list ORACLE-L you need grant with admin option for creating view on a table owned by someone else. Raj

Re: Deleting old archive log files.

If you are not using RMAN, the best, safest, and most portable approach whether deleting archived redo log files on UNIX, VMS, or Windows is the technique of SQL-generating-OScmd. Query the V$ARCHIVED_LOG view to retrieve the file's NAME where COMPLETION_TIME whatever-you-want and ARCHIVED='Y'.

RE: DB Trigger to control PK change

John, How about: CREATE OR REPLACE TRIGGER On_DDL after CREATE ON your.schema BEGIN . HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL

RE: Deleting old archive log files.

Mark, We use the forfiles.exe utility that comes with the NT Resource kit. I have attached it here and below I have pulled the code out of our hotbackup.cmd which runs our hotbackups. Its the last step in our hotbackup, to clean up old archived logs which have already been archived to tape.

Re: Coriolis is dead

On Mon, 01 Apr 2002 06:58:39 -0800, you wrote: By the way, Jonathan, Have your SQL*Plus books (love em!)... see you have good reviews on your SQL*Loader book, so I will be buying it as well. Workn' on anything new? You'll laugh, but my latest book is a Transact-SQL Cookbook that I coauthored

RE: DEFERRED FK Constraint

I do not think Oracle will design it this way. If it's me who put the design I will validate normally during any DML and mark the records that do not satify the constraint to be checked at a later stage (commit time). Regards, Waleed -Original Message- To: Multiple recipients of list

RE: RMAN

Hi Kimberly, we are on 8.1.7. Like I said below, we are stuck with Arcserve (and limited to 8.1.* because of that). However, I've decided to backup to disk and then let Arcserve grab the datasets and write them to tape. I was able to integrate rman and Arcserve but it was soo slow, and

RE: View creation error on a table with grant through a role?

Hi, From the online generic doc's version 8.1.7 * Data Definition Language Statements and Roles A user requires one or more privileges to successfully execute a data definition language (DDL) statement, depending on the statement. For example, to create a table, the

RE: RE: License standby database?

Title: RE: RE: License standby database? That's what I was told 2 years ago. But as we have seen, Oracle has an 'evolving' licensing standard. Or was that 'revolving'? Jon -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 9:48

RE: View creation error on a table with grant through a role?

Who said there was logic behind this? ;P -Original Message- Tamas Sent: 04 April 2002 14:08 To: Multiple recipients of list ORACLE-L :-O Thanks. Its funny. Could some one please point me to some online docs (OTN)? Just to see the logic behind this - for me unwanted - feature? Tamas

RE: Literal SQL and sys.dual

This is the code you submitted later yesterday and the error I am getting during compile is shown below. I am wondering how you got it to work. I tried it this on 8i/Solaris and 9i/NT. SQL CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS 2 -- 3 PROCEDURE eval_this (pi_string IN VARCHAR2)

Re: Seeking opinions

On Tue, 02 Apr 2002 07:43:34 -0800, you wrote: Great point. I had recently created a DB file and forgot to put the .dbf extension on it. If someone didn't query the DD of the DB first, they might have thought it was a junk/temp file (they would have to ignore the file's timestamp) and deleted

RE: sysdba

OK, any other details missing frorm your post? Like Oracle version, whether or not you use a password file, OS type/version, etc.? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: paPIpapupapePO [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 5:43 PM To:

RE: sysdba

and i'm just curious what does paPIpapupapePO means ? -- From: paPIpapupapePO[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 6:43 AM To: Multiple recipients of list ORACLE-L Subject: Re: sysdba the acoount that

IMPORT from 8.17 to 8.16

Dear List, If I want to import a dump file from 8.1.7 to 8.16 what do i have run first or dosn't need any thing? Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to

Re : Oracle 9i on Linux Resources

Hi, You can find the Oracle installation on Linux and resources at dbresources.com. Check out the Oracle on Linux articles at http://www.dbresources.com/search.php?topic=1 Thanks Jason __ Do You Yahoo!? Yahoo! Tax Center - online filing with

Pl/SQL debug

Hallo, I am trying to insert things into the table PRISREGISTER_KOPIA_WED but why doesnt the insert statement work. It says Missing expression when the insertstatement runs and when i look at the sql code which is trying to be run to insertinto the table it says just missing expression and it

RE: Deleting old archive log files.

the most portable and sanest route is to use RMAN Agreed. Go RMAN... Gorman... Hmmm... :-) Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. If you

RE: View creation error on a table with grant through a role?

Thanks Jack! Tamas -Original Message- Sent: Thursday, April 04, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hi, From the online generic doc's version 8.1.7 * Data Definition Language Statements and Roles A user requires one or more privileges to

RE: View creation error on a table with grant through a role?

Well put! I absolutely hate this feature of Oracle. Based on the number of times this questions comes up here and other lists, and my own experience, its a source of major confusion, not to mention the fact that it makes managing object privileges unnecessarily diffcult. (Sorry for the

RE: EMC question

-Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 6:53 AM To: Multiple recipients of list ORACLE-L Subject: RE: EMC question This is true - but then again... raw doesn't cost anything... Unless you buy it from certain company

Re: RMAN

Lisa, We baclup to disk and use the OS backup to tape to put the backupsets on tape. Disk is much faster and the OS can do the copy to tape in the background whenever. And don't feel bad about 8.1.7 forever, we are stuck on 8.0.6.3 forever because the contractors who build our application

RE: Coriolis is dead

Currently, I'm helping Steven Feuerstein revise his Oracle PL/SQL Programming book. I'm only revising a few chapters in that: the one on datetimes for example, and today I'm beginning work on the Strings chapter. VERY glad to hear that one is getting revised. Its one of the MOST used books on

Waiting for 9i (was RE: RMAN)

Lisa, while you're waiting for 9i, start converting all of your SVRMGRL scripts to use SQL*Plus instead. Tackle one here or there as you can. They don't take a long time (usually) and it'll be that much less to do when you convert. Just call me Heloise. Erm, maybe not. ;) Rich Jesse

RE: recordset as argument

Rakesh: I haven't implemented it. Just read about it in the docs. Caver -Original Message- Sent: Thursday, April 04, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Hi Caver, Can u pls give in details with a sample code, if posible the implementation of the recorset(or

RE: Deleting old archive log files.

Oh I agree as well.. Unfortunately, this was for a customer of ours, so the choice of backup utility is not up to me, and not our domain to recommend (though I did ask whether they had considered RMAN).. ours is not to reason why .. .. Thanks for all of your help though guys! Cheers Mark

PL/SQL again

I sent the wrong pl/sql code in last message. I want the field BORTTAGS_FLAGG to be inserted in prisregister_kopia_wed. (See attached file: regicarol.txt) What is missing? Thanks in advance Roland S regicarol.txt Description: Text - character set unknown

RE: Deleting old archive log files.

No, not from what I saw. I may be wrong, though. Lisa -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Deleting old archive log files. the most portable and sanest

Favourite Urban Myth

The DBA needs root privileges on the server This is one of my interview questions. Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services--

Re: Pl/SQL debug

You are missing the BORTTAGS_FLAGG in your INSERT STATEMENT at the end of the code, where you are creating the string. The last variable is vare_snr and not BORTTAGS_FLAGG lvSQL := 'INSERT INTO PBK.PRISREGISTER(' || 'BUTIKID,' ||

ORA-27072/HP-UX file too large

Hi, all. Oracle 8.1.7.2.0 on HP-UX B.11.00. When performing a full database export, I'm getting EXP-8: ORACLE error 1114 encountered ORA-01114: IO error writing block to file 201 (block # 366985) ORA-27072: skgfdisp: I/O error HP-UX Error: 27: File too large Additional information: 366985

Re: Coriolis is dead

That one should have read... Banner Add On ... text text text ... Banner Add Off I'm still looking for the coupons.lol Brian P. MacLean Oracle DBA, OCP8i

RE: RMAN

Hi Ruth, I am glad to hear that someone else has taken the same route I have. I think I ticked off the sysadmin but I really don't care :) I can blame it all on hormones. It adds another step in recovery, and I have a feeling all my rman reports won't be correct (because they want to be able

WHICH UNIX FOR ORACLE?

We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT

RE: RE: Deleting old archive log files.

You can recover just one or a set of datafiles with RMAN. I've had to do that for a recovery before. It will recover just the datafiles you need plus the necessary archive logs. Jim Koivu, Lisa [EMAIL PROTECTED] wrote: No, not from what I saw.  I may be wrong, though. Lisa

RE: ORA-27072/HP-UX file too large

Hi, My guess is that the file system you are writing to doesn't handle large files. ( 2 GB) Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 04, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Subject:

ORA-12514

Dear List, I have created a new instance on 8.1.7 under sun solaris, then try to shutdown the databse to change some parameter after changing the ini.ora when I try to open the database Got this error: ORA-12514 Listener could not resolve SERVICE-NAME given in connect descriptor. Strange is I

RE: Literal SQL and sys.dual

For the 3rd time I am sending this code, Mohammad, it wouldn't be a bad idea to try to resolve the code yourself. CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS v_result NUMBER; -- PROCEDURE eval_this (pi_string IN VARCHAR2) IS BEGIN RTRIM(pi_string,';') || '; end;'; END

RE: Favourite Urban Myth

Unless your DBA is also your SA. Kinda hard to create mountpoints and directories otherwise. ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Dave Morgan

RE: Favourite Urban Myth

Heck I don't WANT root privs... I would rather have an experienced SA to help me with the OS. Working as a team with a skilled SA is much more preferable than doing it all yourself. Also, having someone else there when the sh*t has hit the fan to work through the problem with you and possibly

RE: RMAN

Hi Lisa, Steve, But what advantage do you gain by taking the two days to install RMAN? The only one I can think off is the block level backup but that can create problems of it's own. They used to do block level backup in the 60's and gave that up

RE: PL/SQL again

Roland, I'm afraid I've already deleted the original e-mail so I can't check but it may be you have to handle the BORTTAGS_FLAGG field if it is an empty string (or null). Iain Nicoll -Original Message- Sent: Thursday, April 04, 2002 5:04 PM To: Multiple recipients of list ORACLE-L I

Re: ORA-27072/HP-UX file too large

its an os problem, make sure your filesystems are large enabled. aix has a 64gb filesize limit, forgot what hp ux is. [EMAIL PROTECTED] 04/04/02 11:23AM Hi, all. Oracle 8.1.7.2.0 on HP-UX B.11.00. When performing a full database export, I'm getting EXP-8: ORACLE error 1114

Re: Seeking opinions

and, on a Unix box, I ALWAYS do an fuser before deleting a file. Just in case. --- Jonathan Gennick [EMAIL PROTECTED] wrote: On Tue, 02 Apr 2002 07:43:34 -0800, you wrote: Great point. I had recently created a DB file and forgot to put the .dbf extension on it. If someone didn't query

Re: WHICH UNIX FOR ORACLE?

here go the wars :) 1. Solaris 2. HP UX 3. IBM AIX imho, in order. this is definitely in the archives. gene [EMAIL PROTECTED] 04/04/02 11:36AM We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about

RE: Favourite Urban Myth

I try NOT to get root privs. I know just enough to really damage the server and OS, but not enough to do much that is useful --- Koivu, Lisa [EMAIL PROTECTED] wrote: Heck I don't WANT root privs... I would rather have an experienced SA to help me with the OS. Working as a team with a

RMAN recovery behavior for a single datafile...

You can recover just one or a set of datafiles with RMAN. That's what I did just yesterday only I used the recover tablespace syntax. What Lisa is saying is that if you only need to recover one datafile all you have to do is use the recover database syntax and RMAN will automagically figure out

Re: ORA-27072/HP-UX file too large

Paul, I think you filesystem is not created/mounted with largefiles option. Tell your SA to check. Normal cmd is depending on your filesystem type either mkfs -m /dev/ and for changing it to large files check man pages for fsadm. HTH Cheers, RS --- Paul Baumgartel [EMAIL PROTECTED] wrote:

Re: WHICH UNIX FOR ORACLE?

What are you planning..? A religious war..:) well..here is my 2 cents,IMHO 1. HP-UX 2. SOlaris 3. AIX in the order of preference. I have worked with all three and I found HP machines to be reliable and HP-UX easy to work with. This is not to say solaris is not but I had some nightmare stroies

Re: Literal SQL and sys.dual

Raj, and for the 3rd time the version you post, wouldn't compile. Look below at what you posted. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 11:54 AM For the 3rd time I am

RE: PL/SQL again

Just doing a quick search on the code. I see you creating a bortags_flagg variable. I see you writing SQL to select this value but I do not see the variable being assigned. This is in your declare statment. borttags_flagg number; Here you define lvSQL with a select statment. (I have

Re: WHICH UNIX FOR ORACLE?

Might as well get my two cents in... :-) 1. Solaris Tied for 2... AIX, Tru64, HP/UX (leaving NUMA out of the equation for now. If you like NUMA, then look into the status of IBM's acquisition of Sequent, I'm out of touch with that right now.) Different hardware solutions from different vendors

RE: RMAN

Well, to start: Block level backup, though it may have it's problems that you elude to, allows compact backups for very large databases. I have never had a backup fail because of block locking. Incremental backups to save resources on very large databases. The ability to report on your

sqlloader errors

Hello, Env: Oracle 8.1.6.0.0 on Solaris 2.7 Does anyone know what controls sqlloader behaviour regarding the number of records it rejects when an error is encountered? We have a number of daily sqlldr processes; this morning, one sqlldr process rejected 7 records because of unique constraint

RE: WHICH UNIX FOR ORACLE?

Anyone use Linux for Sparc with an Oracle db on top? -Original Message- Sent: Thursday, April 04, 2002 11:10 AM To: Multiple recipients of list ORACLE-L Importance: High Might as well get my two cents in... :-) 1. Solaris Tied for 2... AIX, Tru64, HP/UX (leaving NUMA out of the

RE: RMAN

Hi Dave, what advantage do you gain... Well if something goes wrong with your scripts you only have yourself to blame but if something goes wrong with RMAN then you can blame Larry and company. :-) Of course the ultimate responsibility for data remains with the DBA regardless and I'm sure YOUR

RE: WHICH UNIX FOR ORACLE?

I'm very suprised no one has said Linux. ?? It is one of the first tier platforms for Oracle now, isn't it? I also thought I read on this list a while back that Solaris was no longer the dev platform? Guess it all depends on what strengths you are looking for. For my employer, who is CHEAP,

RE: WHICH UNIX FOR ORACLE?

HP-UX Stable, Do you like patches? SolarisPopular, Good for the resume. AIXNo experience with this, Is that really UNIX? Linux Free + You get coolness points. IMHO... of course!   -Original Message- Sent:

RE: WHICH UNIX FOR ORACLE?

Bunyamin, Here we go again! (Raj - this _is_ a war!!) My preference is: 1. AIX 2. HP-UX 3. Solaris Ultimately, it is a question of how much $$$ - now (purchase), later (maintenance costs), and how much when it goes down. I have managed about 150 AIX boxes at one time, and have not had H/w

RE: WHICH UNIX FOR ORACLE?

Raj, I have to agree with your order here. I've seen horrendous problems with Sun OS upgrades and Sun hardware. HP has been rock-solid. AIX is well, AIX - 'nuff said. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent:

RE: WHICH UNIX FOR ORACLE?

Considering there's no binaries for it, I'd say you'd be hard-pressed to find one! :) I'm just happy I got a thin client running on my Alpha/Linux box at home. :D Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex,

RE: RMAN Core dumps while restoring datafile

Ruth, As we are recovering only one datafile we should be able to restore and recover when the database is open. I am not sure why it core dumps instead of reporting an error. Thanks, Ashoke -Original Message- Sent: Thursday, April 04, 2002 7:43 AM To: Multiple recipients of list

RE: RMAN

List, I need the name of a good book that deals specifically with RMAN. I have read the fine manual and have found out that it basically works with a third party vendor software if you are using tape as the backup storage media. There has to be a way around this requirement. I have a 70 GIG

sqlloader errors

Oracle got back to me (very promptly) regarding the rejection of several records by sqlloader when only one record in the batch had an error. The short answer is that the violated PK constraint, unlike all others, had been created as DEFERRED. From Metalink: **( Source:

  1   2   >