Message-Id: <10611.116299@fatcity.com> From: "Koivu, Lisa" Date: Wed, 6 Sep 2000 09:57:56 -0400 Subject: 8.1.6.1 Upgrade: has anyone seen this before? Or installed 8.1.6. This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0180A.75D72EF0 Content-Type: text/plain; charset="iso-8859-1" Yesterday I attempted to upgrade an 8.1.5 prod database to 8.1.6.1, running HP/UX 11.0. The initjvm.sql did not complete successfully - it died on a timeout error. Also, the rmjvm.sql script did not complete successfully, it died on an exec rmjvm.run(TRUE) error. I spent the entire night on the phone with support, they had no clue. They wanted me to modify the database with dbassist (pointy-clicky, YUCK) and dbassist didn't run correctly, either. Their answer of course is to install the 8.1.6.2 patch, which must be newly available. We ended up reverting back to 8.1.5 after seven hours of anguish. I am now going to do a fresh install & export/import upgrade, I don't expect the upgrade scripts to work after the patch. Has anyone encountered the same type of errors? Or has anyone installed the 8.1.6.2 upgrade for HP/UX? Comments anyone? This is just so appropriate.... "Insanity: doing the same thing over and over again and expecting different results." -Albert Einstein Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." ------_=_NextPart_001_01C0180A.75D72EF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 8.1.6.1 Upgrade: has anyone seen this before? Or installed = 8.1.6.2 HP/UX?

Yesterday I attempted to upgrade an = 8.1.5 prod database to 8.1.6.1, running HP/UX 11.0.  The = initjvm.sql did not complete successfully - it died on a timeout = error.  Also, the rmjvm.sql script did not complete successfully, = it died on an exec rmjvm.run(TRUE) error.  I spent the entire = night on the phone with support, they had no clue.  They wanted me = to modify the database with dbassist (pointy-clicky, YUCK) and dbassist = didn't run correctly, either.  Their answer of course is to = install the 8.1.6.2 patch, which must be newly available.   = We ended up reverting back to 8.1.5 after seven hours of anguish. =

I am now going to do a fresh install = & export/import upgrade, I don't expect the upgrade scripts to work = after the patch.  Has anyone encountered the same type of = errors?  Or has anyone installed the 8.1.6.2 upgrade for = HP/UX?  Comments anyone?

This is just so appropriate....
"Insanity: doing the same thing = over and over again and expecting different results."
-Albert Einstein

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  = 33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The = information contained herein does not express the opinion or position = of Qode.com and cannot be attributed to or made binding upon = Qode.com."

------_=_NextPart_001_01C0180A.75D72EF0-- ------------------------------ From: "Rusnak, George A. II" Date: Wed, 6 Sep 2000 09:53:55 -0400 Subject: RE: previous DBA job posting Yesterday I saw a posting for a job in Richmond, Va. and this morning a friend asked me if there were any jobs available in the Richmond area. Is there an archive for this mailing list and if so how do I get there from here? TIA Al ------------------------------ From: "Aldi Barco" Date: Wed, 06 Sep 2000 21:52:47 JAVT Subject: Sysdate problem...... Hi list, I've just restored (copy from physical backup) the database and now have strange problem in sysdate : sysdate does not take the correct time and the minute part does not move forward. SQL> !date Wed Sep 6 09:39:14 CDT 2000 SQL> select to_char(sysdate,'HH:MM:SS') from dual; TO_CHAR( -------- Note : not getting value from system date 09:09:57 ,It should be 09:39:15 SQL> / TO_CHAR( -------- 09:09:59 SQL> / TO_CHAR( -------- Note : The minute should be 10, not 09. 09:09:01 Oracle 805 on Solaris 26. Thanks for any clue. Aldi Oracle DBA _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ------------------------------ From: L Date: Wed, 6 Sep 2000 10:51:20 -0400 (EDT) Subject: [Q] how to install demo FORMS on 6i? On ORACLE developer version 2.1 and previoud version, there has entry I can select to install the "demo Forms". I can't find it under Developer 6i. Does anyone know to do it under 6i? Thanks ------------------------------ From: Murugesan Balakrishnan Date: Wed, 6 Sep 2000 08:09:19 -0700 (PDT) Subject: Re: AW: ODBC drivers I had a similar problem. I downloaded the latest version of ODBC driver from oracle.com and now it works without any errors. You can try that out. Muru --- Schoen Volker wrote: > I think your problem is the MS Transaction Server. > Configure your DSN and > click checkbox "Disbale MTS Support". I think this > should work. > > Regards > > Volker Schön > E-Mail: mailto:v.schoen@inplan.de > http://www.inplan.de > > > > -----Ursprüngliche Nachricht----- > Von: Witold Iwaniec > [mailto:wiwaniec@novalistech.com] > Gesendet: Dienstag, 5. September 2000 16:45 > An: Multiple recipients of list ORACLE-L > Betreff: ODBC drivers > > > Hi > > I have strange behavior of ODBC drivers and wonder > if anyone else > noticed it, knows fix for it. Here it goes: > > I have a stored procedure that takes three > parameters VARCHAR2, > VARCHAR2, NUMBER > the call through ODBC would be, for example,: > > begin my_proc('-1', 'INT_TEN_RS', 1); end; > > I connect to Oracle 8.1.6 database on Sun Solaris > from Windows > NT 4.0 SP 5. When I use Microsoft ODBC driver or old > Oracle > ODBC driver (Oracle 73 ver 2.5) it works. But when I > use Oracle > ODBC driver installed with Oracle 8i client (ver > 8.01.06.00) > sometimes it works but in most cases it returns > error 6550 with the > message: > line1, column 64: PLS-00103: Encountered the symbol > "" The > symbol "" was ignored. > > I would look into the procedure but it works with > other drivers, as > well as with OCI etc. > > Has anyone worked with the driver? > > Thanks > > Witold > > ====================================== > Witold Iwaniec > Senior Software Developer > NovaLIS Technologies > wiwaniec@novalistech.com > http://www.novalistech.com > -- > Author: Witold Iwaniec > INET: wiwaniec@novalistech.com > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Author: Schoen Volker