Re: 9.2.0.8.0 Solaris8 64bit

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_at_hotmail.com>

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  

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 27 2006 - 01:33:06 CDT