Re: 9.2.0.8.0 Solaris8 64bit
- From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
- To: <joe_dba@xxxxxxxxxxx>
- Date: Wed, 27 Sep 2006 16:33:06 +1000
Joe,
There was a similar thread that I started a few days ago.
1) libraries in lib32 and lib still don't have read and execute
permissions to the world. Problem existed in 9.2.0.7 as well!
2) SQR failed with ORA-1790 with this simple sql statement:
SELECT :G_InvoiceID
FROM DUAL
UNION
SELECT ss.siteinvoiceid
FROM vw_inv_sitesummary ss
WHERE ss.invoiceid = :G_InvoiceID
The program compiled fine against the 9.2.0.6 database. We had to do a
TO_NUMBER against the select from DUAL
3) dbms_stats.export_schema_stats fails with "ORA-06502: PL/SQL: numeric
or value error" if statid had the hyphen or period included, eg.
LENG-20060925 would fail, but LENG#20060925 would work. bug 5548043. Not
a Bug. To Filer.
So far it's been in our development and test regions for a week without
major issues.
Rgs,
Leng.
-------------------------------------------------------
From: "Joe Smith" <joe_dba@xxxxxxxxxxx>
Subject: 9.2.0.8.0 Solaris8 64bit
Date: Tue, 26 Sep 2006 15:07:36 -0500
Has anybody encountered any problems with this patch on 9iRel2 EE on
Solaris8 64bit?
We are at 9.2.0.5.0 right now. It is my choice to go to 9.2.0.6.0,
9.2.0.7.0, or 9.2.0.8.0
any feedback is appreicated.
------------------------------------------------------------------
Leng Kaing
Senior Oracle DBA
Hansen Technologies; 2 Frederick St; Doncaster 3108
Ph: +61-3-9840-3832
Other related posts:
