Re: ** database configuration assistant scripts

2003-10-29 Thread Chip
ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip 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

Re: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6

2003-09-11 Thread Chip
are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: tuning question when you have a 3GL application

2003-08-19 Thread Chip
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Oracle World anyone?

2003-08-15 Thread Chip
you, Paul R. Sherman DBA/Sr. Appl. Analyst Bacou-Dalloz office - 401-232-1200 x200 cell- 401-935-2802 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: how to turn off ODBC auto-commit?

2003-08-14 Thread Chip
') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL

Re: [Q] anyone has ORACLE cold backup script for NT?

2003-08-14 Thread Chip
ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip 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

Re: failed to archive

2003-07-15 Thread Chip
archiving log# 3 seq# 87568 -ak ocp dba 8i -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: DECODE AND SELECT

2003-07-12 Thread Chip
... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: installed users

2003-07-12 Thread Chip
the passwords. Sigh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: installed users

2003-07-12 Thread Chip
and create production databases at 9.2.0.2 when development was at 9.2.0.1!) Okay, but does CTXSYS *really* need DBA privs? off to check the notes... Thanks! --- Chip [EMAIL PROTECTED] wrote: dbms_websearch.metalink = 234712.1 160861.1 131752.1 From 160861.1: MDSYS, ORDSYS, CTXSYS

Re: trigger and LogMiner

2003-07-10 Thread Chip
of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Join , Where

2003-07-05 Thread Chip
Server 2000, and it works fine there, what I am doing wrong ??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Should percent increase higher than 0 in 817?

2003-07-02 Thread Chip
Historically, two values of PCTINCREASE were practical: 0 - keep same extent size 100 - double extent size Have Fun :) Gaja Krishna Vaidyanatha wrote: Greetings, Non-zero PCTINCREASE causes unnecessary free space fragmentation in your tablespaces and should be avoided. Especially in

Re: controlfile backup obsolete above 2 days

2003-07-02 Thread Chip
FAQ: http://www.orafaq.net -- Author: Chip 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

Re: RMAN - Remote vs Local Backups

2003-06-01 Thread Chip
network resource intensive and therefore slower versus the backup being initiated from the same machine as t -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: C++ Issues

2003-05-30 Thread Chip
our compiler machine. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Alternative way to write delete query

2003-05-30 Thread Chip
to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: Hotsos Clinic 101 Feedback

2003-03-28 Thread Chip
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Oracle Licences Req on Intel Xeon CPU

2003-03-28 Thread Chip
) |PHONE: +61-419-TJAMBU(852628) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: OT: PLSQL question, JAVA, JDBC

2003-03-28 Thread Chip
__ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: HP-UX 11i/8.1.7.4/login.sql

2003-03-26 Thread Chip
--- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Oracle Licences Req on Intel Xeon CPU

2003-03-26 Thread Chip
) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Locally Managed Tablespaces

2003-03-22 Thread Chip
CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: Problems installing Developer on XP

2003-03-22 Thread Chip
Any other ideas on what to do ??? Thanks - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Running multiple instances on a [large] server

2003-03-16 Thread Chip
manager shows ~850 MB of mem usage. Currently these 5 demo databases are running noarchivelog mode. Have Fun :) Rachel Carmichael wrote: At RMOUG last week, I heard that someone (Chip Briggs I think) had 5 (count 'em 5) isntances of Oracle running on his PC. I don't think it was Linux

Re: netappfilers

2003-03-07 Thread Chip
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: 9i OCP Upgrade Exam - Again

2003-03-03 Thread Chip
Guys, Sorry to post this again. However, finished OCP 8i and wish to study for 9i OCP. What is good materials - books, self-test exams? References. Don't have time or money to travel - going to IOUG however. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip

Re: Oracle version??

2003-02-27 Thread Chip
FAQ: http://www.orafaq.net -- Author: Chip 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

Re: Oracle version??

2003-02-27 Thread Chip
vide a way to quickly get an idea of the oracle server version(s) installed by OUI. Use the inst_loc registry key to find the inventory location, then look for "oracle.server" within "Components" and "PatchSets"; the included folders have the version numbers. Have Fun :) Rajes

Re: Oracle Performance Tuning Exam

2003-02-27 Thread Chip
the certification exams. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Basic RMAN question

2003-02-26 Thread Chip
The connect string looks invalid. Please try: rman target='backup_admin/[EMAIL PROTECTED] as sysdba' nocatalog log="test.log" Have Fun :) Ceri Townsend wrote: Hi All, I am starting to play with rman in a test environment, however I seem to be hitting a really basic problem starting rman.

Re: Dealing with 3rd Party Applications

2003-02-26 Thread Chip
After learning how a vendor is (ab)using Oracle, perhaps an improvement request can be submitted back to the vendor with a better algorithm (that can be incorporated into a future release). A patch to a 3rd party application changed its logon processing: a table was created (using a sequence

Re: ODBC and password expire messages

2003-02-26 Thread Chip
The Oracle ODBC 8.1.7.2 driver added a button (when adding or configuring a DSN) to test the database connection. If a password has expired, the "Test Connection" will pop-up another dialog box so the password can be changed. Oracle 9i clients do not include the "Oracle ODBC Test" (c) 1996,

Re: SQL struggle - UPDATE too?

2003-02-25 Thread Chip
achieve these results in a report. Thanks in advance for your time, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Embeded password in script

2003-02-24 Thread Chip
, how do I code these steps in the script? $svrmgrl SVRMGRLconnect internal SVRMGRLshutdown Thanks in advance, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: corrupted block

2003-02-24 Thread Chip
Metalink Note 130605.1 is worth reading about setting Maxcorrupt for an RMAN whole database backup (and checking alert.log for corruption messages). Metalink Note 207413.1 describes RMAN incorrectly reporting block corruption. Bugs 2068275, 1849726, and 1802432 may be interesting

Re: Problem starting Oracle on W2K

2003-02-24 Thread Chip
ORA-12560: TNS:protocol adapter error. but if i start oracle from the services, i can start svrmgrl without any error. what wrong m i doing ? thanks ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: newbie sqlplus ?

2003-02-24 Thread Chip
Reading "The OFA standard: Oracle for Open Systems" could be helpful: http://www.hotsos.com/catalog/ An OFA compliant setup looks a bit different: $ORACLE_BASE=/db/oracle $ORACLE_HOME=/db/oracle/product/8.1.7 The Admin directories could be: /db/oracle/admin/817db1

Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

2003-02-23 Thread Chip
Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: SqlNet Response ports

2003-02-21 Thread Chip
SQLNET to use only 443 on the response? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services