OS patches required by Oracle

Hi. How do I find the list of OS patches that are required by Oracle 8.1.7 on DYNIX. I have looked at both melink and ibm.com sites, but couldn't find the info there. Am I looking at wrong places? thanks Gene __ Do You Yahoo!? LAUNCH - Your Yahoo

Free ODTUG2002 registrations

Chris, the info. is at: https://www.odtug.com/ssl/2002_reg_iraje.asp Keith Date: Tue, 21 May 2002 10:29:45 -0800 To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> I am interested. Thanks. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To: M

RE: Outstanding bugs in 8.1.7.2

I've dumped the Solaris one to: http://www.westbend.net/~legoman/readme_solaris_8173.html HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: [EMAIL PROTECTE

RE: host from SQL> prompt --- LOL

The product profile is the way to go. Richard Huntley To: Multiple recipients of

RE: complementary Conference passes

I am interested. Thanks. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To: Multiple recipients of list ORACLE-L we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keit

RE: complementary Conference passes

Ops. Sorry list. -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To: Multiple recipients of list ORACLE-L we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith

Re: ORA_ENCRYPT_LOGIN

I'm not using it, but you can look at the packets too and from the client by setting these lines in the clients sqlnet.ora: TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = TRACE_FILE_CLIENT = The output is pretty huge, so you don't want to do this for more than a trivial session before you tu

RE: host from SQL> prompt

Title: RE: host from SQL> prompt I wish I could train them like monkeys, but no, it's an account for tech. support and they're ssh'ing into the production box, and I want to limit their access and give them no way to get to a command prompt, if I can avoid it.  Would you believe that they were

RE: UPDATE Results

Title: UPDATE Results If you are within a C-type program, the SQLCA contains a field that contains the number of rows updated.  Look at the Application Developer’s Guide for more information.   Thank You   Stephen P. Karniotis Product Architect Compuware Corporation Direct: 

complementary Conference passes

we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the of

RE: UPDATE Results

Title: UPDATE Results Thank you.  This worked great!!   -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: UPDATE Results   using sql%rowcount innediately after up

PLS-908

Can't see anything on metalink regarding this error over a database link. We have an 8.1.6 database trying to execute a package on a 7.3.2.3 database and it's giving the following error. Any solution other than upgrade? ORA-04052: error occurred when looking up remote object TEST1.TEST_PKG@SANDB

RE: host from SQL> prompt

See the following link http://soi3.mmtel.ru/books/oracle8-how-to/chap1_11.html which gives some details on using product_user_profile. I'm assuming it'll be the same for higher versions. Iain Nicoll -Original Message- Sent:

RE: How to populate many-to-many

I would follow the exact approach that Forms gives you with drop down lists. You would then have the actual table fields filled in with background/hidden fields within the application. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408

RE: Outstanding bugs in 8.1.7.2

Is there anyway to download the readme file without downloading the whole product set for 8.1.7.3? Thanks, Cherie "Jesse, Rich"

RE: UPDATE Results

Title: UPDATE Results using sql%rowcount innediately after update statement will give you that value.   Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and

RE: host from SQL> prompt

Title: host from SQL> prompt Disable the command from the product profile by adding a row to table PRODUCT_PROFILE.   Thank You   Stephen P. Karniotis Product Architect Compuware Corporation Direct:   (248) 865-4350 Mobile:  (248) 408-2918 Email:   

RE: How to populate many-to-many

Title: RE: How to populate many-to-many Dennis, M2M's are ugly but a fact of life. I've done what you have suggested. I suggest that you make the combination of server_id and software_id a unique constraint to keep out dupes. In Access drop down lists are called combo boxes. You can base t

Re: ORA_ENCRYPT_LOGIN

[EMAIL PROTECTED] wrote: > Anyone using this and if so, do you know of a way to verify that the > password is actually being encrypted? > > > > Thanks. > seems like you could put a sniffer on it and watch the data flow by. -- -- Bill "Shrek" Thater ORACLE DBA

UPDATE Results

Title: UPDATE Results Is there a way to access 'something' that would denote if any rows were updated? Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from?  I have found a 'Returning' clause of the update statement, but I

Re: host from SQL> prompt

Are they telnetting in to your server and then running SQLPlus at the command prompt or are they running SQLPlus from their client and connecting via SQLNet? If the first, then "host" will not give them anything that they won't get from the telnet session. If the second, they they'll most likel

Re: Oracle on (Ssshhh NT)

Lee, I am in the same boat...although I am going to be allowed to install 8.1.7 and use it for my own stuff. Our hired gums(consultants) won't let us more without permission. Take heart, ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesd

RE: Outstanding bugs in 8.1.7.2

A good start would be to get the list of fixes in the README of the 8.1.7.3 bundle for your platform, but I don't know of any comprehensive list. If you find one, let me know! GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Interna

host from SQL> prompt

Title: host from SQL> prompt How can I prevent users from typing "host" to get to an OS prompt while logged into a DB account with an OS account?  They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if

RE: Korn Shell & Sqlplus

According to Oracle Support, in 8.1.6, this can cause processes and locks of the KILLed sessions to hang. And we've seen it. Even after 24 hours, the processes are still listed in V$SESSION, but they have no corresponding entry in V$PROCESS. At this point, the only fix is to bounce the instance

RE: SQL*Plus and DBMS_OUTPUT won't display extended charset?

Yup, as I mentioned in the "export..." statement, it is. Looks like an iTAR... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Grabowy, Chris [mailto:[EMAIL PROTECTED

ORA_ENCRYPT_LOGIN

Title: SQL Server to Oracle DB Anyone using this and if so, do you know of a way to verify that the password is actually being encrypted?   Thanks.

Re: Restoring archivelogs through RMAN

Here is the corrent syntax: restore archivelog from logseq until logseq thread 1; You have to specify from logseq ...unt8il logseq even if you only want to restore 1 logfile. An easier way would be: restore logfile all; This will get any archivelogs in the backupset. HTH, Ruth

RE: How to enable Java

Thanks for the help folks. We are moving along with our IAS install now. It's funny, I've been using the command line with Oracle for so long, I didn't know that dbassist was even there. And once again, the GUI failed where good ole SQL prompt resolved the problem. Thanks, Joe -- Please s

RE: Statspack Problem

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon, > Bruce (CALBBAY) > Sent: Monday, May 20, 2002 10:08 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Statspack Problem > > > Have you connected via BEQ or Net8 initially? > Have yo

RE: Oracle on (Ssshhh NT)

Oracle Performance Tuning 101 has NT and unix specific info in it.  Most publications are geared to NT.  I hate to say it but about the best one is in the FM.  In the Oracle for NT docs is the Oracle Administrators Guide for NT. Waiting for your next recipe.  :o)   Dave -Original Mes

How to populate many-to-many

I am designing a database our software/hardware inventory and there is a many-to-many relationship between 'server' and 'software' table. So I created an association table between them to resolve this. While I believe this is the right thing to do, I am wondering how we are going to populate this

Re: SHARED POOL SIZE

NO, THERE IS NO WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN (sic) THE DATABASE below 9i. Please don't use All-Caps. I remember the first time I used All-Caps on a NewsGroup about 7 or 8 years ago, I was roundly berated. Hemant K Chitale - Original Message - To: "Multiple re

RE: ORA-2085

Yes, I "inherited" this, and I am setting up Multimaster Advanced Replication, setting global_names=false isn't an option. I have suggested moving the donotfiretrigger logic into the trigger, which has some initial support. For the moment, we are changing the code to point to a link with the sam

init.ora params for quick i/0

Hello, We have implemented quick i/o on a sun server running solaris 8 and Oracle 8173. I have set disk_asynch to true. I have verified using truss that dbwr is making kaio calls. Is there anything I am missing on the db side to make proper use of quick i/o ? Also, I am noticing heavy I/O relate

RE: How to enable Java

I don't have an account with metalink, and I can't get to this article on technet. Anyplace else to get this. Also, I'm trying to do this in 8.1.6. Thanks, Joe On Tue, 21 May 2002, Rodrigues, Bryan wrote: > Hi Joe, > > Check out oracle document note:156477.1 JVM installation on 8.1.7 for > d

Restoring archivelogs through RMAN

In running RMAN and restoring a database, the necessary archivelogs are not restored. I found that they have to be restored separately, unless its something we are doing incorrectly. My question is, I have attempted to use the 'restore archivelog like 'PROD_1_2%' but it fails with RMAN-06004: ORAC

Re: Oracle on (Ssshhh NT)

The question of Oracle and NT came up before. I had some papers (not mine) that I'd downloaded to my hard drive so I posted them where people could find them. This doesn't answer your question exactly and I'm not sure how useful the papers were to other people but they have been useful to me.

RE: Oracle on (Ssshhh NT)

Do'h. Just shows how much notice/interest I have in the subject. I have just picked up my copy (apologies Gaja/Kirti) and went straight to the stuff you are talking about.   Thanks to all for the help thus far. I will make more use of my existing library set before bothering you good people

Re: ORA-2085

I think that this is one of the few Oracle error messages where the suggested "action" truly represents the solution. Far more helpful than "Contact your Oracle Representative"... :-) This might be a long shot, however... SQL> create synonym "[EMAIL PROTECTED]" for sys.dual; S

Re: 9i r2

Have you had these bags under your control since you packed them? Has anyone unknown to you asked you to carry anything on this flight? ...same situation... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 8:03 AM > I beli

RE: Oracle on (Ssshhh NT)

Thanks Rachel, this will be (for this year anyway) on Oracle 8 (not even 8i, don't ask !!!) Regards Lee -Original Message- Sent: 21 May 2002 15:23 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Oracle Press has two... Oracle9i for Windows(R) Handbook by Velpuri (should be good) and O

RE: How to enable Java

Hi Joe, Check out oracle document note:156477.1 JVM installation on 8.1.7 for details. Bryan -Original Message- Sent: Tuesday, May 21, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.s

Re: patching 8.1.7

I just talked to OWS and they suggested to read the patch notes and if I need any of the fixes and if not, just install and don't patch until I have to. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 9:38 AM > I have

Re: How to enable Java

Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.sql -- setup database for running Hava and the ORB /rdbms/admin/initplsj.sql -- initializes java libraries for pl/sql There may be other scripts depending on your needs but I think these you must run.

RE: 9i r2

Pointless until someone sues Oracle for allowing those products to be freely downloaded to a restricted country. It's free software and you're being asked to click in 4 check boxes. It's a tough life. Mike -Original Message- Sent: 21 May 2002 15:03 To: Multiple recipients of list ORACLE-

Re: Export problem

[EMAIL PROTECTED] wrote: > Hi! > > Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically > it should work. > > EXP-8: ORACLE error 942 encountered > ORA-00942: Tabelle oder View nicht vorhanden > EXP-00024: Export views not installed, please notify your DBA > EXP-0:

Re: 9i r2

nothing stops anyone from lying... but it's CYA on Oracle's part, they ASKED --- [EMAIL PROTECTED] wrote: > > On Mon, 20 May 2002 [EMAIL PROTECTED] wrote: > > > as wget no longer works with -http-user and -http-password from > this site. > > > > So, you get to do it from a browser. What fun. >

PLS-00553

Can anyone tell me what this PL/SQL error actually means? The manual says An unrecognised name appears in the character set specification John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Outstanding bugs in 8.1.7.2

I've been hunting around OTN and can't remember where to find this. I'd like to see a list of all outstanding bugs that are present in version 8.1.7.2 of EE. Is there one convenient place to find these or am I going to have to compile a list from multiple other versions. Thanks, Cherie Machl

Re: 9i r2

Hi, Were you able to untar and use the cpio command to extract the binaries successfully for Linux without any problems? Because, I was able to sucessfully download all the three files, but I was getting an error "Unexpected end of file" when using hte cpio command. Regards CP "Markus Reger

RE: How to enable Java

Joe, Log on to your server, and change your directory to : ORACLE_HOME/JAVAVM/INSTALL Start up Sqlplus, connecting as SYS and run the INITJVM.SQL file. Be sure hat Java_Pool_Size = 52428800 is in your init.ora file. This takes about 20 minutes to complete. This will install the Java engine

RE: patching 8.1.7

I have patched up to 8.1.7.3 (on Tru64) but there quite a few noises coming from this list to say that this release is buggy and therefore I should have stopped at 8.1.7.2. HTH Lee -Original Message- Sent: 21 May 2002 13:48 To: Multiple recipients of list ORACLE-L Good morning all,

RE: What makes Export slow ?

Using a large buffer size allows more data to be written via export (a C Program) from the database to a file. The buffer specifies the size of each write to the database. Direct=Y was added in Oracle7 and allows export to bypass the SQL communication layer and write data from the database to th

RE: 9i r2

I believe those check boxes are required by US export laws. Granted, it won't stop someone from those countries from downloading the software, but then I believe Oracle is not liable. And yes...seemingly pointless... -Original Message- Sent: Tuesday, May 21, 2002 1:23 AM To: Multiple re

Re: How to enable Java

You can installed java with scripts. Check metalink note 156477.1 Use more space (10-20M more )than specified on the note for java_pool_size and shared_pool --- Joe LaCascio <[EMAIL PROTECTED]> a écrit : > > Hi folks: > > I'm installing IAS on our web server which is a DEC > Alpha 800, one

Export problem

Title: Export problem Hi! Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically it should work. EXP-8: ORACLE error 942 encountered ORA-00942: Tabelle oder View nicht vorhanden EXP-00024: Export views not installed, please notify your DBA EXP-0: Export terminated

Oracle on (Ssshhh NT)

All,   Anyone can point me in the direction of some excellent books re. the setup/admin/tuning of Oracle on NT in specific. I could google it but theres nothing better than personal recommendations.   It would appear we have a(nother !!) major client here who requires an Oracle/NT  solution

ORA-2085

Hi all. I have recently had to enable global_names in order to set up a replicated environment. The application uses a database link to reconnect to the database under a differant user id (I inheirited this, I had nothing to do with the design!). Appearantly, global_names has a prblem with

How to enable Java

Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to

patching 8.1.7

Good morning all, They are finally going to let me install 8.1.7 and try it on my little database that hold my recovery catalog and OEM repository. I would like to know if I will have to apply a patch before using it. We are on AIX 4.3.3. Thanks in advance, Ruth -- Please see the official O

Re: TEST

you've been ignored, forever RAJESH DAYAL wrote: > TESTING .. > PLS IGNORE . > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: How to find current ORACLE_HOME programmatically

Hi you should be able to find it under: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE Harold -Original Message- Sent: Tuesday, May 21, 2002 01:08 To: Multiple recipients of list ORACLE-L Hi, guys. I need to find current value of ORACLE_HOME on the client from VB program, running on that

TEST

Title: TEST TESTING .. PLS IGNORE .

Re: 9i r2

just to mention: used Opera to download - Oracle 9.2.0.1.0 - for LINUX, SOLARIS and NT - as we have'm all three - there was NO problem. kr >>> [EMAIL PROTECTED] 05/20/02 22:17 PM >>> Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with -h

Re: 9i r2

just to mention: used Opera to download - Oracle 9.2.0.1.0 - for LINUX, SOLARIS and NT - as we have'm all three - there was NO problem. kr >>> [EMAIL PROTECTED] 05/20/02 22:17 PM >>> Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with -h

<    1   2