HP-UX Can not authenticate via OS

2004-01-09 Thread Post, Ethan
Any one see this one? I am working on getting more info about the configuration of this database, I don't have access to it. On AIX and Solaris, it is working fine. (9.2.0.4.0) on HP-UX. While I am trying to connect to the database using OS Authentication, the following error is r

Re: Memory consumption on HP-UX

2003-11-11 Thread Richard Foote
nombre de > Richard Foote > Enviado el: martes, 11 de noviembre de 2003 13:35 > Para: Multiple recipients of list ORACLE-L > Asunto: Re: Memory consumption on HP-UX > > > Hi Helmut, > > Notice the parameter is called pga_aggregate_TARGET and not > pga_aggregate_MAX_SI

RE: Memory consumption on HP-UX

2003-11-11 Thread Juan Miranda
Enviado el: martes, 11 de noviembre de 2003 13:35 Para: Multiple recipients of list ORACLE-L Asunto: Re: Memory consumption on HP-UX Hi Helmut, Notice the parameter is called pga_aggregate_TARGET and not pga_aggregate_MAX_SIZE. That's because the P_A_T is just that, a target the Oracle does

RE: Memory consumption on HP-UX

2003-11-11 Thread Nelson, Allan
Use glance if you have that package installed, look for ps -ef | grep midaemon Allan -Original Message- Sent: Tuesday, November 11, 2003 3:54 AM To: Multiple recipients of list ORACLE-L Hi, how do I find out how much memory Oracle uses on an HP-UX box? Finding the shared memory

Re: Memory consumption on HP-UX

2003-11-11 Thread Richard Foote
mber 11, 2003 7:54 PM > Hi, > > how do I find out how much memory Oracle uses on an HP-UX box? > > Finding the shared memory portion (i.e. SGA) is fairly easy... > > But how do I find out how much memory each dedicated user process is > consuming? > > Or is the

Memory consumption on HP-UX

2003-11-11 Thread Daiminger, Helmut
Hi, how do I find out how much memory Oracle uses on an HP-UX box? Finding the shared memory portion (i.e. SGA) is fairly easy... But how do I find out how much memory each dedicated user process is consuming? Or is the rule of thumb like this: no matter whether you have 10 or 500 users, the

Re: Find CPU clock speed on HP-UX 11

2003-10-21 Thread bulbultyagi
Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 12:24 > Hi! > > I'm new to HP-UX and need to find out how many processors are in a mchine > and at what clock speed they operate. I can get

Re: Solved: Find CPU clock speed on HP-UX 11

2003-10-16 Thread Mladen Gogala
head -1 Jared Mladen Gogala <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/16/2003 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Solved: Find CPU clock speed on HP-UX 11 Her

Re: Solved: Find CPU clock speed on HP-UX 11

2003-10-16 Thread Mladen Gogala
I don't know whether HP-UX has /proc/cpuinfo, but that is the place where the information about CPU is recorded. On 10/16/2003 02:29:31 PM, [EMAIL PROTECTED] wrote: I'm as much a Perl bigot as anyone Mladen, but really, what's the point of rewriting grep? grep -i HZ /var/log/s

Re: Solved: Find CPU clock speed on HP-UX 11

2003-10-16 Thread Jared . Still
       Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        Re: Solved: Find CPU clock speed on HP-UX 11 Here is a very complex program that will do the same thing: #!/usr/bin/perl -w use strict; open SYSLOG,"/var/log/syslog" ||     di

Re: Solved: Find CPU clock speed on HP-UX 11

2003-10-16 Thread Mladen Gogala
l Message- Sent: Thursday, October 16, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Hi! I'm new to HP-UX and need to find out how many processors are in a mchine and at what clock speed they operate. I can get the number of CPUs through glance or top, but I have no idea about the

Solved: Find CPU clock speed on HP-UX 11

2003-10-16 Thread Daiminger, Helmut
/platform/sun4u/sbin Regards Pawan Dalmia Database Administrator Orange-9820018753 Extn -5064 -Original Message- Sent: Thursday, October 16, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Hi! I'm new to HP-UX and need to find out how many processors are in a mchine and at what

Find CPU clock speed on HP-UX 11

2003-10-15 Thread Daiminger, Helmut
Hi! I'm new to HP-UX and need to find out how many processors are in a mchine and at what clock speed they operate. I can get the number of CPUs through glance or top, but I have no idea about the clock speed. How would I get that information? I would know how to do it on Solaris t

Re: Find CPU clock speed on HP-UX 11

2003-10-15 Thread K Gopalakrishnan
Hi, It is very simple in Solaris. Just try psrinfo or psrinfo -v. You will get the CPU details. Not sure abt HP though :( KG --- "Daiminger, Helmut" <[EMAIL PROTECTED]> wrote: > Hi! > > I'm new to HP-UX and need to find out how many processors are in a > mchi

RE: Find CPU clock speed on HP-UX 11

2003-10-15 Thread K Gopalakrishnan
Does this work? echo "selclass qualifier cpu;info;wait;infolog"|cstm (Got it from Google and don't have a HP-UX now. So may or may not work) KG --- Pawan Dalmia <[EMAIL PROTECTED]> wrote: > Hi > I am also not aware of HP but on solaris u can find using prtdiag &

RE: Find CPU clock speed on HP-UX 11

2003-10-15 Thread Pawan Dalmia
recipients of list ORACLE-L Hi! I'm new to HP-UX and need to find out how many processors are in a mchine and at what clock speed they operate. I can get the number of CPUs through glance or top, but I have no idea about the clock speed. How would I get that information? I would know how to do

HP-UX 11i/Oracle 9.2.0.4/(Semi)Intelligent Agent

2003-10-13 Thread Vergara, Michael (TEM)
Hi List: I have a server with multiple network interfaces. When this server does an IP address lookup, the address returned is the private backbone between the database and application servers. The IA starts, and is listening on this address. I am trying to query the agent from the public netw

Relink Error 9.2.0.4 Patch HP/UX

2003-10-02 Thread Odland, Brad
Is anyone running 9.2.0.4 on HP/UX? 11.0 HP9000 I had 9.2.0.2 running and downoaded and installed the 9.2.0.4 patch and now I can't relink. Unsatisfied symbol in "kkxfcab" in file /usr/oracle/9.2.0/lib//libserver9.a[kwqa.o] I have a tar in process but wondering if anyone e

Re: HP-UX 11/9iR2/dbv

2003-09-16 Thread Tanel Poder
(reposting) Hi! In 9i, you can actually "dbv" files online. No blocks are falsely detected as corrupt, they're just rescanned in case block header & tail SCN and wrap bytes don't match. If the block is continuously in change, then block is reported as being in flux not corrupt. Tanel. - Ori

Re: HP-UX 11/9iR2/dbv

2003-09-14 Thread Stephane Faroult
"Vergara, Michael (TEM)" wrote: > > Hi All! > > This is a question for the script gurus out there. I am running > an SAP system. Recently, during a DR test, we found several > files with corruption. These were found originally with an > ORA-600 [12700], and confirmed with dbv. > > So now they

HP-UX 11/9iR2/dbv

2003-09-14 Thread Vergara, Michael (TEM)
Hi All! This is a question for the script gurus out there. I am running an SAP system. Recently, during a DR test, we found several files with corruption. These were found originally with an ORA-600 [12700], and confirmed with dbv. So now they want me to run dbv's on the database files during

Re: HP-UX 11/9iR2/Processes

2003-08-23 Thread Tanel Poder
Hi! In addition to docs, you can select name, description from v$bgprocess to see names and max numbers of all background processes. For example DBW% prorcesses go from DBW0 up to DBWj Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Frida

Re: HP-UX 11/9iR2/Processes

2003-08-22 Thread Murali_Pavuloori/Claritas
lt;[EMAIL PROTECTED] cc: ant.com> Subject: HP-UX 11/9iR2/Processes

HP-UX 11/9iR2/Processes

2003-08-22 Thread Vergara, Michael (TEM)
Hi Everyone: I've noticed a new type of background process in my 9iR2 databases. It's name is ora_j00n_. Does anyone know what this process is? Any links to Docs? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PRO

RE: HP-UX

2003-08-14 Thread Nelson, Allan
inistrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Seema Singh [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 14, 2003 11:45 AM > To: Multiple recipients of list ORACLE-L > Subject: HP-UX > > > Hi, > Can s

RE: HP-UX

2003-08-14 Thread Jesse, Rich
I USA > -Original Message- > From: Nelson, Allan [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 14, 2003 1:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: HP-UX > > > It's out of stock, > > Allan > > -Original Message--

RE: HP-UX

2003-08-14 Thread Jesse, Rich
L PROTECTED] > Sent: Thursday, August 14, 2003 11:45 AM > To: Multiple recipients of list ORACLE-L > Subject: HP-UX > > > Hi, > Can someone send me system administration document on OS > HP-UX 11.0 if have > ? > thx > -Seema -- Please see the official ORACLE-L

RE: HP-UX

2003-08-14 Thread Nelson, Allan
The standard manual set is quite large. You might try HP-UX 11.x System Administration by Poniatowsky. A really short quide capable of being sent to you in email might exist. If so it will only suffice to make you extremely dangerous and will almost certainly get you into a lot of trouble. At

HP-UX

2003-08-14 Thread Seema Singh
Hi, Can someone send me system administration document on OS HP-UX 11.0 if have ? thx -Seema _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-22 Thread Daniel Fink
Metalink has a note that the INLIST ITERATOR may cause problems on certain platforms. That's about as much detail as it offers. I don't know the internal workings of II, but I suspect there is some sort of merging occuring after each (or all) iterations. Perhaps someone on the list can explain ho

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-22 Thread Vergara, Michael (TEM)
Ok you guys... Here's the latest on the 'real' subject of this thread. You know what an explain plan looks like, right? On our production DB, it looked like SELECT STATEMENT CHOOSE SORT GROUP BY TABLE ACCESS BY INDEX ROWID INDEX RANGE SCAN Ok...so far so what, right? Well, on our s

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-22 Thread Ron Rogers
Jared, With your luck the "check" you refer to will be like the ckeck in a restaurant. Don't forget the tip. Ron >>> [EMAIL PROTECTED] 07/22/03 03:34PM >>> Hopefully, not a pink one? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-22 Thread Jared . Still
Color may be irrelevant, depending on amount. "Gogala, Mladen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/22/2003 12:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-22 Thread Gogala, Mladen
Hopefully, not a pink one? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 22, 2003 11:55 AM To: Multiple recipients of list ORACLE-L 10gR4 will modify payroll and send me the check. Jared On Monday 21 July 2003 19:39, Mla

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-22 Thread Jared Still
10gR4 will modify payroll and send me the check. Jared On Monday 21 July 2003 19:39, Mladen Gogala wrote: > 10gR3 will read programmer's mind and automatically correct all design > errors. RDBMS 11T will look like Arnie Schwartzenegger ("T" is for > "Terminator"). I'll be back. > > On 2003.07.2

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Mladen Gogala
10gR3 will read programmer's mind and automatically correct all design errors. RDBMS 11T will look like Arnie Schwartzenegger ("T" is for "Terminator"). I'll be back. On 2003.07.21 22:04, Rachel Carmichael wrote: 10gR2 will automatically correct the errors. I'm waiting for the version that will

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Reardon, Bruce (CALBBAY)
You need Rdb (Oracle's other database) for that to work: eg: SQL> seelct count(*) from pot; %SQL-I-SPELLCORR, identifier SEELCT replaced with SELECT 334 1 row selected SQL> show version Current version of SQL is: Oracle Rdb SQL V7.1-101 Underlying versions are: Database with filenam

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Rachel Carmichael
10gR2 will automatically correct the errors. I'm waiting for the version that will know that I *meant* to type "select" when I actually type "seelct" --- Daniel Fink <[EMAIL PROTECTED]> wrote: > Okay, so its Monday... > > What I meant to say is that are the queries with different execution > p

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Jared . Still
lease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: HP-UX 11i/9.2.0.3/Strange Executions He needs to contact oracle support, because the dump came from the oracle server process. If he's lucky, t

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Anderson, Brian
Metalink: 241160.1 ALERT: ORA-7445 Signalled from Different Functions on 64-bit HP-UX. Versions 9.2.0.2 and 9.2.0.3 > -Original Message- > From: Daniel Fink [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 6:20 PM > To: Multiple recipients of list ORACLE-L > Subject

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Daniel Fink
Okay, so its Monday... What I meant to say is that are the queries with different execution plans the ones encountering 7445s. If there is a common thread in the execution plans (i.e. hash join instead of nested loops), then the hj may be triggering the 7445s. Actually, 10g will have a new "FOR

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Gogala, Mladen
Actually, I'm quite unaware of ORA-07745 as an execution plan. Can "EXPLAIN PLAN" foretell the error? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 6:20 PM To: Multiple recipients of list ORACLE-L Michael, W

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Gogala, Mladen
d address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTE

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Daniel Fink
Michael, When you say 'different execution plans', what are the differences? Is the choice in execution plans causing the ORA-07445? If so, why are the execution plans different (there has to be a reason)? Statistics, parameters, etc. will alter the execution plan choices. The 7

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
Ron: According to the ABAP programmers, the code 'variant' is identical. The generated SQL 'looks' the same, but the execution plans are radically different. Thanks, Mike -Original Message- Sent: Monday, July 21, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Is or are ALL of

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I upgraded my SAP *PRODUC

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions Raj:   Is OWS 'Oracle Worldwide Support'?  Our Oracle support comes directly from SAP, and they're on the case, but are as flummoxed as I am.  Right now they're trying to convince me that the problem is in the NLS parame

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
Jared: I am in contact with SAP support, but they're scratching their collective heads, too. I was hoping that maybe a SAP-savvy lister would be able to say "We had that...here's the fix". What's strange is that the report runs to completion on our Stage server. Thanks, Mike -Original Mes

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Ron Rogers
lease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until n

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Gogala, Mladen
chael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Jamadagni, Rajendra
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions Most likely some thing to do with OS library. contact OWS. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Jared . Still
cipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (

HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server

RE: Oracle Financials 10SC on HP-UX rev 11

2003-06-19 Thread Hemant K Chitale
[30-Jun-03]. Only Extended Support is available for another year. Hemant At 09:05 AM 18-06-03 -0800, you wrote: I shall just comment on conversion from 10.20 to HP-UX 11. Install fresh HP-UX-11 11 on a new box. Install 10.7 version for HP-UX 11 and Oracle 7.3.4.5 . Apply all application

RE: Oracle Financials 10SC on HP-UX rev 11

2003-06-18 Thread M Rafiq
I shall just comment on conversion from 10.20 to HP-UX 11. Install fresh HP-UX-11 11 on a new box. Install 10.7 version for HP-UX 11 and Oracle 7.3.4.5 . Apply all application patches for Hp 11 version on new box. Copy over all your datafile and migrate to new binaries. At this stage don&#

RE: Oracle Financials 10SC on HP-UX rev 11

2003-06-18 Thread Nelson, Allan
We did this before conversion to Financials 11.5.7 from 10.7. The only real issue is that you can't relink. Adpatch et all still work. Hopefully you are stable at this point so you won't have to patch too often. I would go for 8.1.7.4 db because 7.3.4 was out before HP-UX 11 saw th

Oracle Financials 10SC on HP-UX rev 11

2003-06-18 Thread Trevor . Williams
Hi Has anyone converted Oracle Financials from HP_UX rev 10.20 (DB v7.3.4.4) to run on HP-UX rev 11? The only rev 10.20 host we have left is running our Oracle Financials 10SC. We are looking at converting to HP-UX rev 11 purely for disaster recovery reasons. It will be most useful to communicate

Re: HP-UX 11i/8.1.7.4/login.sql

2003-04-03 Thread Joan Hsieh
I got same problem. what I did is before call sqlplus /nolog, I rename the glogin.sql to something else and change back after the jobs done. That is most easy step I need to do. Joan John Carlson wrote: > > The way I do it is to create another login.sql script for batch jobs only and place > th

RE: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX 11.00

2003-04-01 Thread Nelson, Allan
ipients of list ORACLE-L Hello Gurus We are in process of planning to upgrade our existing Oracle Financials 10.7 Character Applications to 11i( ver 11.5.8) Existing env HP-UX 11.00 32bits Oracle Financials 10.7 Char with Manufacturing & Bill of Material Some customization (of Forms &

RE: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX 11.00

2003-04-01 Thread M Rafiq
Hello Gurus We are in process of planning to upgrade our existing Oracle Financials 10.7 Character Applications to 11i( ver 11.5.8) Existing env HP-UX 11.00 32bits Oracle Financials 10.7 Char with Manufacturing & Bill of Material Some customization (of Forms & Reports) No middle tier

RE: hp-ux question

2003-03-27 Thread Spears, Brian
04:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:hp-ux question why on my hp-ux box ( with 2 cpu ) , I always see one cpu idle while other is being used at 90% . Any Idea ? Thanks, ak --

RE: hp-ux question

2003-03-27 Thread Nelson, Allan
: Multiple recipients of list ORACLE-LSubject: hp-ux question why on my hp-ux box ( with 2 cpu ) , I always see one cpu idle while other is being used at 90% . Any Idea ?   Thanks, ak __ This email is intended sole

Re: hp-ux question

2003-03-26 Thread Jared . Still
TECTED] 03/26/2003 04:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:hp-ux question why on my hp-ux box ( with 2 cpu ) , I always see one cpu idle while other is being used at 90% . Any Idea ?

hp-ux question

2003-03-26 Thread AK
why on my hp-ux box ( with 2 cpu ) , I always see one cpu idle while other is being used at 90% . Any Idea ?   Thanks, ak

Re: HP-UX 11i/8.1.7.4/login.sql

2003-03-26 Thread Chip
Personally, I use a modification of Tom Kyte's sql*plus setup from "Expert One-On-One Oracle" (book publisher bankrupt): -- Connect.sql CONNECT&1 UNDEFINE 1 @@Login.sql SETTERMOUTOFF SAVEafiedt.bufREPLACE DEFINEprompt_global_name = SQL COLUMNprompt_globalNEW_VALU

RE: HP-UX 11i/8.1.7.4/login.sql

2003-03-25 Thread John Carlson
The way I do it is to create another login.sql script for batch jobs only and place that in another directory. I have also created a file I call ".cronenv" under $HOME. This sets environment variables needed for cron jobs. In it, I set SQLPATH so the first place it looks is the directory I pl

RE: HP-UX 11i/8.1.7.4/login.sql

2003-03-25 Thread Vergara, Michael (TEM)
That I can do... -- variable sqlpmpt varchar2(30); set termout off pause off verify off declare username varchar2(30); instname varchar2(30); begin begin select substr(global_name, 1, instr(global_name||'.', '.')-1) into instname from global_name; exception when OTHERS

RE: HP-UX 11i/8.1.7.4/login.sql

2003-03-25 Thread Spears, Brian
Perhaps you could send the contents of your LOGIN.SQL -Original Message- Sent: Tuesday, March 25, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Greetings Everyone! I have a LOGIN.SQL script that I've customized to fit my preferences. However, when I use SQLPLUS /NOLOG, it

HP-UX 11i/8.1.7.4/login.sql

2003-03-25 Thread Vergara, Michael (TEM)
Greetings Everyone! I have a LOGIN.SQL script that I've customized to fit my preferences. However, when I use SQLPLUS /NOLOG, it fails miserably since there is no connection to the database. Is there a way - other than undefining ORACLE_PATH - that the LOGIN.SQL script can be skipped or ignored

RE: HP-UX and IBM ESS

2003-03-20 Thread Stephen Lee
We had a case where the hardware revision level of an I/O device was not at the correct version, and we would get random error messages about corrupt blocks during a select when there were, in fact, no corrupt blocks. This was on Tru64, not HPUX, but it might be something to investigate. > -

HP-UX and IBM ESS

2003-03-20 Thread McBain, Neil SITI-ITDIEEE
Anyone using HP K-class servers connected to IBM ESS running HP-UX 11.0 and Oracle 8i successfully - if so maybe you can shed some light on the following :- We have a test HP K460 (9000/889) connected to an IBM ESS for storage which we are currently testing to see if we can connect all our test

RE: RE: HP-UX Installation questions for 8i/9i on a HP-UX 11/

2003-03-19 Thread Mandar A. Ghosalkar
CTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 19, 2003 2:13 PM > To: Mandar A. Ghosalkar; Multiple recipients of list ORACLE-L; > [EMAIL PROTECTED] > Subject: Re:RE: HP-UX Installation questions for 8i/9i on a HP-UX 11/ > > > Jeff, > > Care to put your 2 c

Re:RE: HP-UX Installation questions for 8i/9i on a HP-UX 11/

2003-03-19 Thread dgoulet
ndar > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 19, 2003 1:00 PM > To: Mandar A. Ghosalkar; Multiple recipients of list ORACLE-L; > [EMAIL PROTECTED] > Subject: Re:HP-UX Installation questions for 8i/9i on a HP-UX 11/11

RE: HP-UX Installation questions for 8i/9i on a HP-UX 11/11i

2003-03-19 Thread Mandar A. Ghosalkar
gt; [EMAIL PROTECTED] > Subject: Re:HP-UX Installation questions for 8i/9i on a HP-UX 11/11i > > > Mandar, > > I'm going to include my HP-UX GURU on to the reply so > that he can comment > about the JFS as he feels appriopriate. > > As for trhe MicroF

Re:HP-UX Installation questions for 8i/9i on a HP-UX 11/11i

2003-03-19 Thread dgoulet
Mandar, I'm going to include my HP-UX GURU on to the reply so that he can comment about the JFS as he feels appriopriate. As for trhe MicroFocus Cobol, NO you don't need it. Ansi C can become another matter. If your going to use any exernal procedures you will need it

HP-UX Installation questions for 8i/9i on a HP-UX 11/11i on RP7400

2003-03-19 Thread Mandar A. Ghosalkar
Installation requirements for 8i/9i on a HP-UX 11/11i on RP7400 Do we need to install Ansi C developers module on HP-UX, if i am not going to use Pro*C? Do we need to install Microfocus Cobol module on HP-UX, if i am not going to use Pro*cobol? Do u'll use "onlineJFS" (Veri

RE: Sun=/var/messages HP-UX=???

2003-03-14 Thread Deshpande, Kirti
kernel virtual memory /stand/vmunixthe kernel, system name list > -Original Message- > From: Deshpande, Kirti [mailto:[EMAIL PROTECTED] > Sent: Friday, March 14, 2003 3:41 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Su

RE: Sun=/var/messages HP-UX=???

2003-03-14 Thread Anderson, Brian
m name list > -Original Message- > From: Deshpande, Kirti [mailto:[EMAIL PROTECTED] > Sent: Friday, March 14, 2003 3:41 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Sun=/var/messages HP-UX=??? > > > What version of HP-UX? > Here is what I get on

RE: Sun=/var/messages HP-UX=???

2003-03-14 Thread Post, Ethan
Thanks, I looked through both files (they are both here) and the information in syslog seems more meaningfull on the HP-UX than what I see in the messages file, it is just the opposite on the Sun box. - Ethan -Original Message- Sent: Friday, March 14, 2003 10:44 AM To: Multiple

RE: Sun=/var/messages HP-UX=???

2003-03-14 Thread Deshpande, Kirti
What version of HP-UX? Here is what I get on HP-UX 11.0: df2hp105 [IWHA]: ll /var/adm/me* /var/adm/me* not found - Kirti -Original Message- Sent: Friday, March 14, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Actually /var/adm/messages on hpux is the message file, which my

RE: Sun=/var/messages HP-UX=???

2003-03-14 Thread Anderson, Brian
lson, Allan [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 9:20 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Sun=/var/messages HP-UX=??? > > > /var/adm/syslog/syslog.log is the hp-ux equivelant. > > -Original Message- > Sent:

RE: Is async IO configured on HP-UX?

2003-03-13 Thread Jesse, Rich
, 2003 1:36 PM To: Multiple recipients of list ORACLE-L The HP-UX syscall tracing tool is called 'tusc', and it's supposed to be available by visiting ftp://ftp.cup.hp.com/dist/networking/misc/. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos

RE: Is async IO configured on HP-UX?

2003-03-13 Thread Cary Millsap
The HP-UX syscall tracing tool is called 'tusc', and it's supposed to be available by visiting ftp://ftp.cup.hp.com/dist/networking/misc/. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101, Mar 25-27 Oxford - Hotsos Clinic 101, Ap

RE: Is async IO configured on HP-UX?

2003-03-13 Thread STEVE OLLIG
Ethan - it has been a while and we don't have an HP-UX box here, but if memory serves the missing /dev/async is a dead giveaway that your not using async io. to use async io on HP-UX we had to install something called the asyncdisk driver in SAM and then use mknod to create /dev/async dire

RE: Is async IO configured on HP-UX?

2003-03-13 Thread Richard Ji
How about truss/strace equivalent on HP-UX on dbwr to see whether its using AIO or not. If AIO fails then it will follow by a normal IO call. Richard -Original Message- Sent: Thursday, March 13, 2003 8:44 AM To: Multiple recipients of list ORACLE-L /dev does not have an async

Is async IO configured on HP-UX?

2003-03-13 Thread Post, Ethan
/dev does not have an async directory, async IO is turned on in the database, how do I determine if async IO is activated on the OS side of the house? Is the missing async directory an indicator? Also, is the database smart enough to figure out that the OS is not using async and make correct cal

RE: Sun=/var/messages HP-UX=???

2003-03-13 Thread Nelson, Allan
/var/adm/syslog/syslog.log is the hp-ux equivelant. -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the

RE: Sun=/var/messages HP-UX=???

2003-03-13 Thread Deshpande, Kirti
Ethan, Check /var/adm/syslog/syslog.log - Kirti -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the

Re: Sun=/var/messages HP-UX=???

2003-03-13 Thread Darrell Landrum
I'm not sure if this is the default or standard location, but one file of importance on HP is /var/adm/syslog/syslog.log. Darrell >>> [EMAIL PROTECTED] 03/13/03 12:58AM >>> I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth mon

Sun=/var/messages HP-UX=???

2003-03-12 Thread Post, Ethan
I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: HP-UX 11i/8.1.7/DB Link Question

2003-01-29 Thread John Kanagaraj
> Sent: Wednesday, January 29, 2003 11:09 AM > To: Multiple recipients of list ORACLE-L > Subject: HP-UX 11i/8.1.7/DB Link Question > > > Hi Everyone! > > I have been tasked with finding out how often connections are > made between > databases using DB links. Does a

HP-UX 11i/8.1.7/DB Link Question

2003-01-29 Thread Vergara, Michael (TEM)
Hi Everyone! I have been tasked with finding out how often connections are made between databases using DB links. Does anyone know of a tracking or auditing tool, or perhaps a audit methodology, that would provide this information? Thanks, Mike --- ==

Re: HP-UX 11.0 mount parameter mincache

2003-01-15 Thread chao_ping
sn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-01-14 17:28:00 ,you wrote£º=== >We have HP-UX 11.0 and are having IO problems. >Oracle and HP say to set a mount parameter >mincache=direct. We currently have it set >to mincache=tmpcache. B

RE: HP-UX 11.0 mount parameter mincache

2003-01-14 Thread Deshpande, Kirti
ORACLE-L We have HP-UX 11.0 and are having IO problems. Oracle and HP say to set a mount parameter mincache=direct. We currently have it set to mincache=tmpcache. But when we set it to "direct" the db slows down to the point it's unusable. HP said to increase the db_block_buffers,

HP-UX 11.0 mount parameter mincache

2003-01-14 Thread tony ynot
We have HP-UX 11.0 and are having IO problems. Oracle and HP say to set a mount parameter mincache=direct. We currently have it set to mincache=tmpcache. But when we set it to "direct" the db slows down to the point it's unusable. HP said to increase the db_block_buffers, so we

Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question

2002-12-18 Thread Yechiel Adar
dministrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > > -Original Message- > > From: Yechiel Adar [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, December 17, 2002 1:24 AM > > To: Multiple recipients of list ORACLE-L > > S

RE: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question

2002-12-17 Thread Jesse, Rich
TECTED]] > Sent: Tuesday, December 17, 2002 1:24 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question > > > I am currently busy with the same project. Junk tnsnames.ora for OID. > I installed OID 9.2.0.1. > I then

Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question

2002-12-17 Thread Yechiel Adar
ppy Holidays Everyone! > > > > I have been hacking around the MetalLink site looking for how to > > move from using a TNSNAMES.ORA file to Active Directory. We use a > > mixed environment of HP-UX, Solaris, and Windows, with versions > > of Oracle from 7.3.4 (really!)

Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question

2002-12-16 Thread Yechiel Adar
Holidays Everyone! > > I have been hacking around the MetalLink site looking for how to > move from using a TNSNAMES.ORA file to Active Directory. We use a > mixed environment of HP-UX, Solaris, and Windows, with versions > of Oracle from 7.3.4 (really!) to 9iR2. > > All the notes

Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question

2002-12-16 Thread chao_ping
have been hacking around the MetalLink site looking for how to >move from using a TNSNAMES.ORA file to Active Directory. We use a >mixed environment of HP-UX, Solaris, and Windows, with versions >of Oracle from 7.3.4 (really!) to 9iR2. > >All the notes and docs I can find seem

  1   2   3   >