Error Install 9i Rel.2 on Windows 2000

I want to install Oracle 9i Rel. Database on Windows 2000 Professional. Error Message after clicking on setup.exe: The Java Runtime Environment was not found at bin\javaw.exe. Hence the Oracle Universal Installer cannot be run. Please visit http://www.javasoft.com and install JRE version 1.3.1

RE: runInstaller Error ....

I did the setting for LD_LIBRARY_PATH and is not working. I also executed rda.sh script (REMOTE DIAGNOSTIC AGENT for UNIX), It came out with an error as follows: Argument LD_LIBRARY_PATH=/lib:/usr/local/oracle/817/lib:/usr/lib not recognized and was forced to exit. I don't know how /lib was

1 way of getting creation time of tablespaces

SQL select a.tablespace_name,b.creation_time from dba_data_files a,v$datafile b where a.file_id=b.file#; TABLESPACE_NAMECREATION_TI -- --- SYSTEM 22-MAR-2002 ROLLBACK 22-MAR-2002 TEMP

RE: oracle 9i

Hi, Greg, JDBC driver 8i (thin) will not work with 9i. Regards, Vadim -Original Message- Sent: Thursday, July 25, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks.

RE: Cursor Sharing .... Continued

yes im aware -Original Message- Sent: Friday, July 26, 2002 9:09 AM To: Multiple recipients of list ORACLE-L * * * HAPPY DBA/SA APPRECIATION DAY!!! * * * Beware of ORA-600,

RE: Cursor Sharing .... Continued

Take your case to management with that statistics of how long queries take with and without bind variables. Let them decide when to make the developers re-code their apps. If your management doesnt make them correct it then I dont know what to say from there.My management has said It

RE: efficient way to duplicate db on another unix host?

I have a paper on how to do this using the same version of Oracle on the same O/S if you are interested. basically you are using hot backups from a Tar. If you are interested let me know. Mike -Original Message- Sent: Friday, July 26, 2002 9:20 AM To: Multiple recipients of list

Re: type of join in sql

Hi The choice of of whether to use nested loop, hash join, sort-merge join is driven by the cost (logical ios performed ) and cardinality ( count of rows source for given operation ). Optimizer formulates several plan - before the best plan among them is chosen Approach one can take to benefit

RE: Cursor Sharing| Soft Parsing

I'll admit I'm gullible, and I do look to you as more knowledgeable than me about internals. On the other hand, I'm a born and bred New York City girl and I've never bought a bridge yet. guess I'll have to live with because as the answer Get on with you :) Rachel --- Connor McDonald

RE: Help on Temp Space

I have seen this exact behavior too. FWIW. Mike -Original Message- Sent: Friday, July 26, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Lisa, I've had problems with TEMPORARY tablespaces in Version 7. Busy databases continually ran out of TEMP space, and it would not get

RE: Cursor Sharing| Soft Parsing

OK, I think this explains a lot with the introduction of the new and highly technical term, softer parse. So we have the hard parse, the soft parse, and the softer parse. You can get or derive stats for all three: 1) hard parses = parse count (hard) 2) soft parses (AKA parse calls) = parse

Re: Errors trying to connect from 8.1.7 client to 7.3.2 server

Not sure about AIX, but on some platforms the format of tnsnames.ora can be quite picky. Have also experienced odd errors connecting from 8x to 7x databases. You might try reformatting it like this: test1.world = (DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=mfgad11)(PORT=1521))

Re: Help on Temp Space

Lisa, I've had problems with TEMPORARY tablespaces in Version 7. Busy databases continually ran out of TEMP space, and it would not get released for use by other sessions. We finally went back to PERMANENT temp TBS's on version 7 and the problems disappeared. I haven't experienced this on

Re: Help on Temp Space

We found that that worked, but converting back to PERMANENT tbs was much more effective on Version 7. Jared Mohammad Rafiq [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/26/2002 10:10 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: Errors trying to connect from 8.1.7 client to 7.3.2 server

Peter, Sorry for repeating but: Can your AIX client ping this host: mfgad11.atdc.northgrum.com ? Is your domain: atdc.northgrum.com or northgrum.com ? Waleed -Original Message- Sent: Friday, July 26, 2002 1:25 PM To: Multiple recipients of list ORACLE-L I should have added that I can

RE: RE: BR solutions

In Rich's case (I was working with him when his infrastructure was built) and in mine now, the backups largely define how database cloning is carried out. We are using Veritas Snaps here, allowing me to clone an instance with few minutes of sync time and a control file rebuild, much faster than

(Fwd) Re: System Administrator Appreciation Day

http://ars.userfriendly.org/cartoons/?id=20020726 --- Forwarded message follows --- Also - if you don't already read it, check out today's userfriendly comic, at http://www.userfriendly.org . The 'singer' in the strip is Stef Murkey, marketing type, while the 'singee' is Mike

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

every time I've gone to www.oracle.com and clicked oracle university lately, it hangs my browser (IE6). On 26 Jul 2002 at 4:55, [EMAIL PROTECTED] wrote: Hmm. Good point. Anyone know how we can verify that if you take the 8i exams and pass you can just do the upgrade exam without the

Stored Procedures/Functions

Dear Gurus How would one monitor when and who may be executing a stored procedure/package etc at any one point in time. Similar to table locks although thats more straightforward to monitor. Pls advise Thanks in Advance IMPORTANT: This e-mail (including all attachments) is confidential and

RE: Cursor Sharing .... Continued

Michael - So . . . since you have a work-around that is relatively easy from the developer point of view, how do you plan to convince them to rewrite their programs? Or do you have a really big hammer? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent:

RE: When was a tablespace created?

try this: select a.file_name, a.tablespace_name, b.creation_time from dba_data_files a, v$datafile b where a.file_name = b.name should give the time for the first file added to the tablespace, translates to the tablespace creation time. someone might have a better idea, I guess. Sunil Nookala

Re: Help on Temp Space

put it offline and again online immediately...do it at off-peak time , tested solution... Regards rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 26 Jul 2002 08:09:14 -0800 Hi all, Still on 7.3.4, and can't seem to free up the temp

Re: efficient way to duplicate db on another unix host?

Having just been working with it rman duplicate seems a good bet. It seems very efficient and you don't have to worry about sizing issues as it just builds it as it sees it If you have any questions I might be able to help I have seen one problem and that was with it not doing a proper

RE: Errors trying to connect from 8.1.7 client to 7.3.2 server

I should have added that I can ping the host and tnsping works also. Tracing on the server shows that listener is receiving the connection but gives no hint of why the connection failed. $ lsnrctl status (on the server): LSNRCTL

RE: Cursor Sharing| Soft Parsing

Thanks for sharing your interesting research Ian. If cached cursors obviate the need for a parse call then why do they increment parse count (total)? Despite all the list contributions it does not appear that this question has been answered. As Cary Millsap pointed out, there's a problem with

RE: SQLLDR question SOLVED

Thanks for all the help. It turns out there was a problem with the data and the field seperator was part of the data in one of the fields. -Original Message- Sent: Friday, July 26, 2002 10:33 AM To: Multiple recipients of list ORACLE-L I am trying to load data via sqlldr (8.1.6.3 on

Help on Temp Space

Hi all, Still on 7.3.4, and can't seem to free up the temp space. it is set up as temporary, and I have tried the alter tablespace TEMP default storage (pctincrease 1); to see if that would clean up (reset) the free space. I swear I have done this before (with success) but maybe the brain is

RE: SQLLDR question

Terry, I tried the following in 817 and it worked fine: LOAD DATA INFILE * INTO TABLE test REPLACE FIELDS TERMINATED BY ',' TRAILING NULLCOLS ( col1 char , col_seq test_seq.nextval ) BEGINDATA 'one', 'two', (sorry about the first email - fingers slipped!) Do you get an error in the

RE: Cursor Sharing| Soft Parsing

* * * HAPPY DBA/SA APPRECIATION DAY!!! * * * Mr. Kyte's parsing explanation is also in this iss of OraMag. For the papyrus-impaired:

RE: Cursor Sharing| Soft Parsing

Connor, Well, technically that answers the why... with Oracle's because I said so :) the REAL question is why 3 and not 2 or 4 or 10 or. ? Rachel --- Connor McDonald [EMAIL PROTECTED] wrote: RTM :-) Performance Guide 9.2 Caching Session Cursors (blah blah blah) Oracle

RE: SQLLDR question

I'm not a sqlloader expert, so take with a large grain of salt. If you are using conventional path, a series of 'insert' statements are executed. This may cause the to be interpreted as the variable indicator. If you are using direct path, it may create a block of rows and then directly place

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

Hi, the requirement for an instructor-led course is only for people wishing to gain the 9i DBA OCP credential from scratch. It's not required for people taking the 8i course, upgrading from 8i or those who've already taken an exam towards the 9i OCP credential. And the evidence is at

When is the next patchset for 9.2.0.1 coming out?

Gene, What patchsets are currently available for 9iR2 (9.2.0.1)? I'm not aware that any are available. Does anyone know when the next patchset is expected to be released for 9.2.0.1? Thanks, Cherie Machler Oracle DBA Gelco Information Network

Open -- Parse --Execute -- Fetch Rows -- Close

Yes, it is done at the parse call. In some cases such as witn DBMS_SQL the calls are explicit . One writes code to explicitly open the cursor, parse the cursor, execute the cursor, fetches rows from the cursor, and close the cursor. The fetch rows call is often placed in a loop. When

RE: Is it correct way of adding two tables without having self-jo

Do you think there is any reason for adding same tables two times without having self join condition??? IMHO, Oracle development guys has done some mistake -Original Message- From: Straub, Dan [mailto:[EMAIL PROTECTED]] Sent: Fri 7/26/2002 22:44 To: Multiple recipients