Verisign and MetaLink
Per the doc on MetaLink, Oracle Wallet Manager and Sun Java JDK are affected by the Verisign certs. Here is some of the info: VeriSign Class 2 and Class 3 PCA root certificates are included in the Oracle Wallet Manager as well as Sun's Java JDK. These certificates will expire on January 7, 2004 and are referred to as the Expiring certificates in this note. Both the Oracle Wallet Manager and Sun's Java JDK are shipped or utilized by the affected products listed above. These certificates are used in Oracle's products to authenticate web sites and applications communicating over SSL using VeriSign certificates. They are also used to digitally sign source code and libraries as a means to validate that the libraries and archives have come from a trusted source. VeriSign has issued new certificates with the same public key and new validity periods as a replacement for the expiring certificates. The expiring certificates should be replaced with the new certificates following the instructions described in this note. --- Customers who use VeriSign Class 2 and Class3 PCA root certificates as trusted certificates for SSL authentication of users and servers (database or web server) will be affected by the root CA expiry starting January 8, 2004. --- This patch will be available for the following products and versions: o Oracle Database Server (versions 8.1.7.4, 9.0.1.5, and 9.2.0.4) o Oracle Application Server (versions 9.0.2.3, 9.0.3.1, and 9.0.4.0) I can send a copy of the doc if you like. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Database is 32 or 64 Bit ? - Clarification
Query the v$sql table. If the 'address' field contains 8 hex characters, it's 32 bit. If there are 16 characters, it's 64 bit. select address from v$sql where rownum 2; Robyn Inka Bezdziecka wrote: you need to 'describe' v$session, not to 'select' from it SQL desc v$session -Original Message- Sent: Friday, October 04, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Hi Qs What do you mean by raw(4) / raw(8) ? Does it mean Length of the Field Data Value ? From my Database :- SQL select saddr from v$session where rownum 2 2 / SADDR 313941C0 CASE - Assuming on receiving a Database from a 3rd party 1) My Existing Installed ORACLE_HOME software is 64 - Bit 2) Assuming the Database Sent is a 32-Bit Database ( which i am Ignorant of ) Qs When i Bring up this 32-Bit Database using my 64-Bit Oracle Software will SADDR Still show raw(4) values ? Thanks -Original Message- Sent: Friday, October 04, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I posted the note below a few weeks ago, hope it helps John Listers, Here is a little summary of commands to identify the bit version of an o/s and 2 methods of identifying whether a database is a 32 bit or 64 bit installation Operating System Compaq Tru 64 - will be 64 bit HP-UX /usr/sbin/swlist | grep -E '32|64' returns HPUXEng64RT B.11.00.01 English HP-UX 64-bit Runtime Environment if 64 bit Sun isalist -v If the return contains the phrase 'sparcv9' then it is a 64 bit o/s Oracle Version To check Oracle version - 2 methods do a file on $ORACLEHOME/bin/oracle returns either ELF-32 or ELF-64 executable Within sqlplus desc v$session and look for the definition of saddr (if raw(4) then 32 bit else if raw(8) 64 bit) -Original Message- Sent: 04 October 2002 07:53 To: Multiple recipients of list ORACLE-L Given a Database . It is 32 Bit or 64 Bit , how can it be found ? Assuming Cold Backup of Database Sent from Elsewhere -- Robyn Anderson Sands iTeam Technologies, Inc. Office: 404.816.6920 Mobile: 404.234.4873 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Backups
Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Backups
Thank you for the response - I especially liked ( agreed with) the rant. You expressed many of the same concerns that I have, but this is a small operation and there's a lot to clean up. The application was installed in the system schema, the users all had 'SYSTEM' for their temporary tablespace, dual had 121 rows in it, backup was copying the wrong $ORACLE_HOME, the database and configuration files were in 'unusual' locations and the developer uses a where clause to sequence his results instead of specifying 'order by'. Did I mention there's no test server? Maybe I'll get them on RMAN eventually, and I will be testing the recovery process, but for now, I'll just be happy to get a complete backup on tape. If anyone is aware of potential pitfalls to watch out for until the situation can be improved, I'd appreciate add'l input. Robyn Tim Gorman wrote: I've relied on dd, mainly when working with raw devices. dd is probably one of the oldest commands in the UNIX lexicon. It's just another way to get the job done... soapbox rant RMAN is a *much* better solution. After all, how are these exports, backup scripts, and what-not going to check the database for block corruption? For archived redo logfile corruption? How will someone be able to determine how many backups are on tape for each datafile and archived redo logfile? Can you do trial restores, to test what's on tape? Will any restore/recovery scenarios be scripted? /soapbox rant - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 6:08 PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Robyn Anderson Sands iTeam Technologies, Inc. Office: 404.816.6920 Mobile: 404.234.4873 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).