Re: Media Recovery needed

On 2002.05.27 02:33 Simon Waibale wrote: Hi Mladen Gogala, Thanks for your input, I did use similar approach to your suggestion save I left everthing to oracle! 1) svrmgrl 2) connect internal 3) startup mount; 4) recover automatic database; 5) alter database open; That means that

RE: altering next extent solved

The batchjob was doing a truncate, Thx Iain ! Jeroen -Oorspronkelijk bericht- Van: Nicoll, Iain (Calanais) [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 24 mei 2002 15:16 Aan: 'Jeroen van Sluisdam' Onderwerp: RE: altering next extent I believe that if you set the next extent then all

Financials Client question

We have outsourced implementation and setup of a scaled down Oracle Applications 11i (rel 11.5.5) for Suse Linux... I have received a memo from the implementation team's application DBAs and they have informed me of a certain limitation for the specs of the client PC's. I was informed that the

novice learns a new thing

Hi all, I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words. So seniors please help === SQL conn hlledw/hlledw@orcl9iConnected.SQL grant select on edw_week_lvl to scott;

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

Anjo , List If you mean it is SAFE to set this parameter to Either Value , Thanks Are there any Guidelines to Set this Value for Best Performance ? OR Should we Simply Set it See ? The only Concern is that it is a Production Database . Thanks -Original Message- Sent: Sunday, May 26,

RE: how to pick the lastes file using UTL_FILE package ?

- Original Message - From: Rahul [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sun, 26 May 2002 22:18:18 list, the requirement is to use the UTL_FILE package on the server side to open and process the files as they are created (each hour) in a

Re: novice learns a new thing

A quick look showed normal behaviour. You granted as the object owner select to test1 and scott than as test1 you tried describing a scott object that scott does not own but only has select rights on thus the error. after you created the synonym scott owned an object with that name (pointing to

RE: novice learns a new thing

Ther is Nothing Strange in this. If you see the Object was owned By hlledw. You granted the Rights to Both Scott and Test but there was not Object named edw_% in these schemas. Then u Tries to describe the Object thru hlledw and that worked but when u tried to acces it thru scott it did not

Set Timing on and DBMS_utility.get_time()

Hi List, I am really confused by the results from the DBMS_UTILITY.get_time() and set timing on in the SQL PLUS. Can anybody please explain this with an example. I gave the following in the SQL PLUS SQL Set timing on SQL Select * from emp; Elapsed: 00:00:00.08 Does this mean the command

Re: novice learns a new thing

But the interesting point is that scott never granted the privileges on the object to test1 Coz I am a NoviceDBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous - Original Message - To: Multiple recipients of list ORACLE-L

RE: how to pick the lastes file using UTL_FILE package ?

1. Run a Cron Job that every Hour Runs the Ls command with the necessary switches to sort the file listing by the date and redirect the filename to a Flat file. 2. Run a Job In Oracle that will open that particular file and read the contents of that file and open the file mentioned therein.

Post Migration to 8.1.7.2 from Oracle 7.3.4 on Tru64 Unix - Best Practices ??

Batch Jobs seem to be performing Slightly Slower than Before . Are there any Best practices / parameters on Digital Tru64 Unix OR 8.1.7.2 for Better Performance ? This is a Hybrid Application (Banking) doing about 3 Million OLTP Transaction Daily in a 5 Hours Window Thanks P.S. Oracle

ProC problem

All, Tru64 5.1a Oracle 8.0.6.3.0 One of our developers is getting the following error when trying to compile up a program Pro*C/C++: Release 8.0.6.3.0 - Production on Fri May 24 16:27:04 2002 (c) Copyright 1999 Oracle Corporation. All rights

snapshot too old error - strange

Dear list ! 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

RE: ProC problem

The directory where the gflib.h file lives is in the .cfg file in the $ORACLE_HOME/precomp/admin directory. Anyone have any ideas Regards Lee Lee, file or

RE: snapshot too old error - strange

Title: RE: snapshot too old error - strange Increase rollback segment size for this transaction and make sure that the transaction will use the huge rollback segment hth nirmal -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Mon, May 27, 2002 15:53 To:

RE: Media Recovery needed

Mladen - I am curious about your disaster recovery test. I am in the process of implementing RMAN here, but management says I must continue to do cold backups until I can successfully perform a disaster recovery test using RMAN. I can't argue the point. In a realistic sense, in a real disaster,

RE: ProC problem

Thanks for the reply, this is the entry in the pcscfg.cfg file in the $ORACLE_HOME/precomp/admin directory. sys_include=(/user1/include,/usr/include) If I do an ls -l listing of that directory -rwxr-xr-x 1 root system 1378 Apr 3 15:45 gflib.h HELP - I am an idiot. Regards Lee

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

Vivek - I don't know if you checked Google, but the following page has some information. http://www.ixora.com.au/notes/direct_io.htm It sounds like on Tru64 5.0 this is yes by default, so you would only be setting it no. And sure I always try out new settings on the production server.

RE: snapshot too old error - strange

Hi Andrey, Are there any LOB columns in the tables ? I read something on Metalink about bugs on ORA-01555 messages (followed by a ORA-22924), on tables with LOBs ... HTH, Remco -Oorspronkelijk bericht- Van: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Verzonden: maandag 27 mei 2002 14:53

RE: how to pick the lastes file using UTL_FILE package ?

Rahul - Just a thought here. This would be a simple task in Unix. One idea would be to take a look at the Unix/Posix type interface packages. Another thought would be to ask this question on a W2K forum. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent:

RE: snapshot too old error - strange

Check size of your rollback segs Vs the job of selecting from a big table to insert into another big table -might have to increase size of segs. -Original Message- Sent: Monday, May 27, 2002 5:03 PM To: Multiple recipients of list ORACLE-L Hi Andrey, Are there any LOB columns in the

Covert tnsnames.ora to OID

Hello All How can I covert all the names from tnsnames.ora to OID? I do not feel like entering all this data again, by hand, one by one. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network

Re: how to pick the lastes file using UTL_FILE package ?

Rahul, This isn't exactly what you're asking but, If OEM is set up: You can use the intelligent agent on win2k. Write a script that identifies the file and then calls the PL/SQL procedure. Schedule the job in OEM. Chaim Rahul [EMAIL PROTECTED]@fatcity.com on 05/27/2002 02:18:18 AM

RE: snapshot too old error - strange

no , no lobs. thanks ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Mon, May 27, 2002 4:03 PM To: Multiple recipients of list ORACLE-L Hi Andrey, Are there any LOB columns in the tables ? I read something on Metalink about bugs on

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

Tru64 5.0 pk3 and oracle 8.1.7.2 Where can I find this parameter ( _tru64_directio_disabled ) ? It is not in V$PARAMETER Thanks Darren -Original Message- Sent: May 27, 2002 6:58 AM To: Multiple recipients of list ORACLE-L Vivek - I don't know if you checked Google, but the

RE: how to pick the lastes file using UTL_FILE package ?

Well, in that case use loader to process the file into a tmptable, and forget UTL_FILE. aRNO -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 27, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Rahul, This isn't exactly what you're asking but, If OEM

Re: so when did you switch from NT to unix for oracle

Maybe it's time to provoke a bit :-). Situation: I'm sitting here in Steve Adams' house (about 7 meters away from the IxOra server, which is SO small - just like the LITTLE mermaid in Copenhagen - very disappointing), and Anjo, Cary, Jonathan and the rest have gone to bed. Whiskies

Re: so when did you switch from NT to unix for oracle

its not a unix processor versus intel processor, i think its more a OS decision. I run all of my stuff on intel processors, just linux not windoze :) joe Mogens Nørgaard wrote: Maybe it's time to provoke a bit :-). Situation: I'm sitting here in Steve Adams' house (about 7 meters away

Re: RMAN + Legato Networker Module for Oracle

http://www.legato.com/products/networker/modules/oracle.cfm On Sun, May 26, 2002 at 10:08:17PM -0800, [EMAIL PROTECTED] wrote: Hello all, does anyone have a document or could you point me a link how to implement RMAN with Legato Networker Module for Oracle on UNIX/NT.

Re: Financials Client question

Maria, The Jinitiator is an applet required by Oracle Developer's Forms Server, mainly for authentication purposes. As an applet, it is extremely sensitive to the version of the browser and Windows, but not so much the hardware. However, for someone to assert that the applet is sensitive to

Re: ProC problem

The -I directives to the cc command tell the C compiler where to find the .h (include) files. The directory in which that specified file resides is not mentioned in any of the -I directives. Either modify the pcscfg.cfg file mentioned as containing the default options to add

Re: Multiple ennvironments with Portal and 9iAS

I do not have experience with them either yet ... anyway the client doesn't want to pay for more licences so we'ill install on one server and configure the tools to handle 3 environments. --- Jared Still [EMAIL PROTECTED] a écrit : Stephane, I don't have any experience with the

online backup question .

I must write an online backup script for the database 8.1.7 . Are my steps below true? 1) Alter system archive log current ; 2) Alter tablespace begin backup; copy datafiles Alter tablespace end backup; FOR ALL TABLESPACES EXCEPT TEMPORARY ONES. 3) alter database backup

Re: Media Recovery needed

Well, Oxford Health Plans (the company that I work for) has a 4-way OPS cluster (HP-9000/N) which gets restored to a single class N machine. I perform database recovery using backup controlfile until cancel and then somebody from the business side verifies the number of members, providers and

PREVIOUS SQL statement

Hi Guys, I was wondering if someone could help me I'm trying to create an AFTER SERVERERROR trigger that will log all errors and the SQL that caused the error. Here's what I have so far CREATE OR REPLACE TRIGGER server_error_trig AFTER SERVERERROR ON DATABASE DECLARE text

Re: Financials Client question

Actually, there have been (in the past) several issues where Java-ish things have problems with the Pentium 4 processor. Most notably: Note: 178050.1 Jinitiator will not install on Pentium 4 (IV) systems Note: 145839.1 Oracle Apps 11i not supported on MS Windows NT/2000 with

Re: PREVIOUS SQL statement

David, I have tried to get the previous SQL on a number of versions and I have always found the address and hash value pretty buggy - usually the same as the current SQL. Moreover, SQL statements which have failed are usually pretty hard to catch (no mention in V$SQLAREA, for what I know). I

Re: snapshot too old error - strange

2 huge tables A and B Now , NO ONE carries a DML agains A or B. If no one ever does DML against those two tables, how did they end up having so many rows? Do you run large batch update or insert operations against these tables from time to time? -- Please see the official ORACLE-L FAQ:

Re: so when did you switch from NT to unix for oracle

OK, I'll bite... A P4 can run circles around an Alpha? I think not... The Intel processors are not winning the technical battle, butIntel Corporation iswinning the battle with the bean-counters and the MBAs. In a world where CIOs seriously consider outsourcing the entire IT department of

Re: ORA-600

When I found the ORA 600 form, I opened the frame in its own window and bookmarked the URL. No need to look up the associated note first. http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=153788.1blackframe=0 -Chris From: Nalla Ravi [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To:

Re: snapshot too old error - strange

Greg Moore wrote: 2 huge tables A and B Now , NO ONE carries a DML agains A or B. If no one ever does DML against those two tables, how did they end up having so many rows? Do you run large batch update or insert operations against these tables from time to time? One additional

SAN Implementation

Hello Group / Guru's Anyone has White Paper on SAN, it Implementation especially with ORACLE ?? Any thought, personal experience with pros and cons will be highly appreciated. TIA Enlighten Me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikunj Gupta INET:

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

_tru64_directio_disabled is an NON-Documented Tru64 Unix Specific parameter To get List of ALL (Documented NON-Documented) parameters :- set echo on spool parm1 select a.ksppinm Parameter, a.ksppdesc Description, b.ksppstvl Session Value, c.ksppstvl Instance Value from x$ksppi a, x$ksppcv