Re: Solaris8 64bit

  • From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
  • To: <joe_dba@xxxxxxxxxxx>
  • Date: Wed, 27 Sep 2006 16:33:06 +1000



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 as well!
2)      SQR failed with ORA-1790 with this simple sql statement:
                SELECT :G_InvoiceID
                         FROM DUAL
                         SELECT ss.siteinvoiceid
                         FROM vw_inv_sitesummary ss
                         WHERE ss.invoiceid = :G_InvoiceID
The program compiled fine against the 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. 







From: "Joe Smith" <joe_dba@xxxxxxxxxxx>

Subject: 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 right now.  It is my choice to go to,, or


any feedback is appreicated.




Leng Kaing

Senior Oracle DBA

Hansen Technologies; 2 Frederick St; Doncaster 3108

Ph: +61-3-9840-3832


Other related posts: