Re: ** database configuration assistant scripts
When creating a custom database, DBCA has an option to save the database creation scripts. Have Fun :) A Joshi wrote: Hi, I am using database configuration assistant to create a NT database. Is there a way I can get the scripts used in the creation? I clicked on the template but do not know where the template goes. Thank you Do you Yahoo!? Exclusive Video Premiere - Britney Spears <http://launch.yahoo.com/video/?1093432&fs=1&redirectURL=http://launch.yahoo.com/promos/britneyspears/> -- 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 - 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: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Trying to create an RMAN 8.1.7.0.0 catalog in an Oracle 9.2.0.3 database ran into a PL/SQL bug fix. Oracle 9.2.0.3 expects the PL/SQL specification default values and body default values to match. Unfortunately, the RMAN 8.1.7.0.0 create catalog fails since the rman package defaults do not match for 4 parameters. Have Fun :) Mladen Gogala wrote: 9.2.0.3 catalog works with 8.1.7, that I have tested personally. I don't have a clue about 8.0.6. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, September 11, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6 Before I begin I have an rman catalog currently in 8.1.7 it supports catalogs for databases in 8.0.6 I wish to migrate using database migration assistant to 9.2.0 and keep the older catalogs in-place. Will this even work or do I have 2 have more than one rman catalog? Thanks, Paula Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message 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-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: tuning question when you have a 3GL application
Just wondering if the Software Engineering Team can be taught how to run their own 10046 trace (capturing the painful "part" of their application). The Hotsos Sparky tool (free) can help the 10046 tracing, including the automation of sending the trace file to the team for analysis. The Hotsos profiler is ideal for analyzing the trace file. The free trace analysis tools: tkprof and Oracle Trace Analyzer have some shortcomings. Have Fun :) [EMAIL PROTECTED] wrote: its the way the taem is organized. all communication goes through the product managers to the client. No direct access for the technical people. i dont make the rules. I just have to live with them. Ive been onsite with clients before. its easier. So Im looking for things to make my life easier... :( luckily yesterday was a problem with the COM objects and had nothing to do with the database. From: Jared Still <[EMAIL PROTECTED]> Date: 2003/08/19 Tue AM 10:34:24 EDT To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: tuning question when you have a 3GL application Your customer tells you that the database is slow, but won't allow you the opportunity to correct it if that is the case? As Cary says, your problem is not a technical one. It sounds as if they don't *want* you to have the opportunity to prove that the database is not the problem. Jared On Mon, 2003-08-18 at 12:24, [EMAIL PROTECTED] wrote: We have two teams. Database team and a Software engineering team. The software engineering team wrote an application in .net. We periodically get 'the application is slow' from them. I have not gotten the ok to run statspack in production. Are there any canned scripts I can run to monitor the v$views or latch contention etc... It may not be the database, but I need some metrics. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). -- 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 - 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: Oracle World anyone?
The Hotsos Clinic 101 is better the 2nd time around, especially with a spiral bound draft copy of Cary Milsap's forthcoming "Bugs" (actually Yellow Jackets) book. RMOUG is close to home so I have already marked my calendar with February 11-12, 2004 for Training Days. After attending the 1st Hotsos symposium and IOUG-A Live 2003 this year, I can readily understand Rachel Carmichael's decision to be the 1st one to register for the Hotsos symposium in 2004. Due to hotel capacity (specifically feeding people), the Hotsos symposium 2004 has a limit of 500 people (who are serious about Oracle system performance). Have Fun :) Daniel Fink wrote: I just returned from the Hotsos Clinic, so that is a big MUST ATTEND In terms of shows/conferences, #1 will be the Hotsos Symposium in March. (www.hotsos.com). If I have to choose between this and IOUG, Hotsos wins hands down. My #2 is RMOUG Training Days (www.rmoug.org) in February. It is held in Denver for 2 days and draws a few of the bests (including several of the top contributors to this list). Granted, I'm biased (I live here in Denver), but the $$$s are good (less than $400 for both days) and the speakers are excellent. Check out the local Oracle User Groups because they often have some top notch meetings that are easy to attend and afford. Daniel Fink [EMAIL PROTECTED] wrote: Jared et al, I was just told by my new boss that I have to have any requests for any conferences/shows in by Sept. 5th (his budget deadline). It's been years since I worked for a company that would pay for me to go anywhere, so, for 2004, what would you (or others on the list) recommend? It'd prob. have to be scheduled already to appease the budget gods, so any dates, locations, web-sites? Also, it would have to be Oracle- or MS SQL Server-based, as that's what I support (9i, and 2000, respectively, all on Win2ks (do I hear violins playing)). Finally, what's the 'hottest' (read that as the most beneficial) Oracle course these days for a DBA that's been around since 6.0 and is now working with 9i? Internals? Thank 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, 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: [Q] anyone has ORACLE cold backup script for NT?
cold_backup_o920.cmd file (manually executed after verifying no users/jobs in database): MODE 150,300 ECHO ON set ORACLE_SID=o920 H: cd \Oracle\Admin\msora920\AdHoc H:\Oracle\9.2.0\bin\sqlplus /nolog @o920shutdown.sql COPY /V /Y /B H:\Oracle\Admin\msora920\PFile\*o920.ora H:\Oracle\Admin\msora920\PFile\Backup COPY /V /Y /B I:\Oracle\OraData\msora920\*.* E:\Oracle\OraData\msora920\Backup COPY /V /Y /B J:\Oracle\OraData\msora920\*.* F:\Oracle\OraData\msora920\Backup COPY /V /Y /B K:\Oracle\OraData\msora920\*.* G:\Oracle\OraData\msora920\Backup H:\Oracle\9.2.0\bin\sqlplus /nolog @o920startup.sql PAUSE o920shutdown.sql file: spool H:\Oracle\Admin\msora920\AdHoc\o920shutdown set echo off connect / as SYSDBA set echo on set trimspoolon set pagesize1000 set linesize150 SELECT * FROM v$controlfile; SELECT * FROM v$logfile; SELECT * FROM v$datafile; SHUTDOWN NORMAL spool off exit o920startup.sql file: spool H:\Oracle\Admin\msora920\AdHoc\o920startup set echo off connect / as SYSDBA set echo on STARTUP MOUNT PFILE=H:\Oracle\9.2.0\database\inito920.ora ALTER DATABASE BACKUP CONTROLFILE TO TRACE; ALTER DATABASE BACKUP CONTROLFILE TO 'H:\Oracle\Admin\msora920\Control\Backup01o920.ctl' REUSE; ARCHIVE LOG LIST SHOW PARAMETER ARC ALTER DATABASE OPEN; spool off exit Note: the listener does not have to be shut down for a cold backup. Have Fun :) mike mon wrote: Does anyone has NT cold backup script for ORACLE that I can reference? The script I need include : shutdown listener shutdown service service shutdown DB backup files startup DB startup Service startup listener Thanks. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.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 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: how to turn off ODBC auto-commit?
Oracle ODBC Driver Configuration => Application Tab Batch Autocommit Mode (drop down list): 1) Commit only if all statements succeed 2) Commit up to the first failing statement (Oracle7 ODBC Behavior) 3) Commit all successful statements The 1st option is the default Oracle setting. Have Fun :) DENNIS WILLIAMS wrote: Ryan Then you're ahead of me. That's why I said "I think", thereby implying a degree of uncertainty. I have worked with ODBC for many years and this wasn't mentioned. I first heard of it when JDBC arose. I did a quick search on Google for "odbc autocommit" and received 9000 hits. It looks like a function odbc_autocommit() may toggle the behavior for you. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 10:00 AM To: Multiple recipients of list ORACLE-L it says it is in tom kytes book. he says its there because ODBC is written by microsoft and sql server needs to commit often because reads blocks writes and you run into concurrency issues. From: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 2003/08/11 Mon AM 10:44:29 EDT To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: how to turn off ODBC auto-commit? Ryan I don't think autocommit is a feature of ODBC. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, August 09, 2003 8:54 PM To: Multiple recipients of list ORACLE-L There is a function to turn off the auto-Commit in the JDBC. Is there one for the ODBC? Id prefer to commit at the transaction level and not for every statement. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- 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 - 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: failed to archive
In Oracle 8.1.7, a database can be configured with LOG_ARCHIVE_MAX_PROCESSES = 1 which starts 1 archive process when the database starts. If the I/O response time for archiving a log takes too long, then Oracle will automatically start another archive process. The alert log shows the various archive process failures for archiving a log. After the poor I/O response for the archive destination(s) has been fixed, the database can be altered: ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES = 1; to shut down the extra archive processes. Have Fun :) AK wrote: I see a lot of "failed to archive " messages in alert.log . But finally the log gets archived . Is it due overloaded archiver ? this is from alert log. ARC0: Beginning to archive log# 3 seq# 87568 ARC0: Failed to archive log# 3 seq# 87568 ARC0: Beginning to archive log# 2 seq# 87569 Mon Jul 14 11:36:23 2003 ARC4: Completed 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 - 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: installed users
Knowing Oracle 9.2 database creation locks some users:
dbms_websearch.metalink('lock default users') included
131752.1 and 160861.1 => reading suggested 'lock outln' search,
which included 234712.1 and 207959.1 (All About Security).
Have Fun :)
Rachel Carmichael wrote:
hm, when I did the metalink search I got nothing -- what keyword did
you use? sometimes it's all in the creativity of the search :)
We did NOT create the databases at the time of install. at least, I
don't think they did, it was done by a hosting company and the other
dba (this is the person who let them install 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, and ORDPLUGINS are created to support Oracle
Intermedia.
Have Fun :)
Jacques Kilchoer wrote:
ctxsys - intermedia text (the old Context text cartridge)
ordsys - intermedia data types for storing of audio and video data
mdsys - data types for storing of spatial data
I think that in 9.0 and 9.2, by default those users are created with
expired and locked logins.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]
I've started a project to review all users in all our databases and
remove unused/unnecessary users or at the very least restrict the
privileges they have to the minimal ones they need. In several of
the
databases there are both ORDSYS and CTXSYS. From what I've
been able to
find out by running the above procedures, ORDSYS is for Intermedia.
I
could have sworn CTXSYS was the Intermedia account. So... is there
a
manual I've missed that tells me exactly which of these two I have
to
have in my databases and why?
In addition, I know you have to install Spatial Option as part of
an
Oracle installation, even if you don't want to use it. Some of
these
databases also have the account MDSYS, some don't. All but one are
9iR2. We don't use Spatial. The two databases that have this
account
(8.1.7.4 and 9.2.0.2) both use Intermedia. Does that have something
to
do with it? I don't want to remove an account I need, but I don't
want
to leave ones I don't need in the databases.
Let's not even begin to talk about the fact that just about EVERY
user
seems to have "unlimited tablespace" priv.
This is not going to be pretty, easy or clean. But I will have
secure
databases. Except of course, every app has a configuration file in
which they hard-code 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
-
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).
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.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 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: installed users
dbms_websearch.metalink => 234712.1 160861.1 131752.1 From 160861.1: MDSYS, ORDSYS, CTXSYS, and ORDPLUGINS are created to support Oracle Intermedia. Have Fun :) Jacques Kilchoer wrote: ctxsys - intermedia text (the old Context text cartridge) ordsys - intermedia data types for storing of audio and video data mdsys - data types for storing of spatial data I think that in 9.0 and 9.2, by default those users are created with expired and locked logins. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED] I've started a project to review all users in all our databases and remove unused/unnecessary users or at the very least restrict the privileges they have to the minimal ones they need. In several of the databases there are both ORDSYS and CTXSYS. From what I've been able to find out by running the above procedures, ORDSYS is for Intermedia. I could have sworn CTXSYS was the Intermedia account. So... is there a manual I've missed that tells me exactly which of these two I have to have in my databases and why? In addition, I know you have to install Spatial Option as part of an Oracle installation, even if you don't want to use it. Some of these databases also have the account MDSYS, some don't. All but one are 9iR2. We don't use Spatial. The two databases that have this account (8.1.7.4 and 9.2.0.2) both use Intermedia. Does that have something to do with it? I don't want to remove an account I need, but I don't want to leave ones I don't need in the databases. Let's not even begin to talk about the fact that just about EVERY user seems to have "unlimited tablespace" priv. This is not going to be pretty, easy or clean. But I will have secure databases. Except of course, every app has a configuration file in which they hard-code 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 - 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: DECODE AND SELECT
Oracle 8i (8.1.6+) PL/SQL can use execute immediate for SQL with searched CASE expressions. Have Fun :) Nuno Souto wrote: - Original Message - I am in urgent need of backporting oracle9i pl/sql to oracle8i.I have encountered some case satements like this CASE when x>0 then (select y from deptno) else (select Z from emp) end i need to convert them to decode statements.Can anybody tell me how to write a select statement within decode. You already got some suggestions. But if you're backporting from 9i to 8i, don't bother: 8i supports CASE happily. At least in SQL... 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 - 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: trigger and LogMiner
Idea for testing: looking for redo associated with select statement(s) that are cleaning out row level locks in block(s) from previously committed DML transaction(s). Have Fun :) Tanel Poder wrote: Hi! Maybe they were thinking that if you audit select statements, you can analyze inserts on AUD$ using logminer later on Anyway, if there's any future release where selects can be in redo, I hope they aren't there by default.. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 10, 2003 2:19 PM Hi Arup and Joe When I wrote the SANS Oracle security step-by-step book I wrote in there the list of restrictions for log miner including that is didn't support selects and during the review process of my book someone in Oracle who was reviewing it informed me that selects would be in the redo in one of the 9i releases, so i changed the book to say fixed in 9i. To be honest I now agree with you, it doesn't make sense for selects to be in the redo, although i suppose they could include them if they wanted to. At least for 9iR1 I am sure they are not included as I did some tests 2 or 3 weeks ago when i was writing a paper "detecting SQL injection on Oracle" for securityfocus.com and selects were definitely not recorded by logminer. I did not also dump the archive log to trace to see if there was no select in it but at least LogMiner does not recognise selects. I copied the list i posted from a file yesterday without thinking i was perpetuating this issue even though i saw myself a few weeks ago it wasn't true. kind regards Pete In article <[EMAIL PROTECTED]>, Arup Nanda <[EMAIL PROTECTED]> writes Hi Pete, I am a little prerplexed by "selects are not recorded in redo prior to 9i ". AFAIK selects are nevere recorded in the redo, and therefore archived logs - so they are never unearthed by LogMiner, even in 9i Release2. Isn't that true? Thanks. Arup -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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). -- 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 - 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: Join , Where
ompany) AND (poline.po_code = pol.po_code) AND (poline.po_number = pol.po_number) AND (poline.po_release = pol.po_release) AND (poline.line_nbr = pol.line_nbr) AND (popivuf.procure_group = poline.procure_group) AND (popivuf.item = poline.item) AND (popivuf.vendor = poline.vendor) AND (itemloc.item = itemmast.item_group) AND (itemloc.company = poline.company) AND (poline.LOCATION = itemloc.LOCATION) AND (itemloc.item = poline.item) ) I was running the query in SQL 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 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: controlfile backup obsolete above 2 days
MetaLink Bug 2458246 (fixed in 9.2.0.2) DENNIS WILLIAMS wrote: Offhand it sounds to me like you may have uncovered an error. I would search metalink and if you don't find an error matching this situation, I would file a TAR. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 9:34 PM To: Multiple recipients of list ORACLE-L Hello list sorry to trouble you all so much, I tried all that I stated below on another database I created, and as long as I don't use an spfile , no problem. As soon as I start using an spfile , I always get my backup shown as obsolete , irrespective of the number of days (the value of n) I specify in ''report obsolete recovery window of n days; '' . Also a few more details , previously i was getting the problem on a 9.2.0.1.0 enterprise edition database in noarchivelog mode. The problem I stated above is on a 9.2.0.1.0 enterprise edition database in archivelog mode with automatic archiving enabled. All this on win32. - Original Message - To: <[EMAIL PROTECTED]> Sent: Saturday, June 21, 2003 00:28 : Hello list : I was having problems with my controlfile backups being reported as : obsolete ; : I have narrowed down the problem to the number of days specified in : the recovery window . : : 1. My control_file_record_keep_time=7 : : 2. Suppose I start rman and there are no backups yet. (This is : confirmed by the commands : : delete noprompt force backup ; : delete nopromt force copy ; : list backup ; (This shows no o/p confirming that there are no : backups ) : list backup of controlfile ; (This shows no o/p confirming that there : are no backups ) : : 3. All the rman configuration settings are at their default values . : I did not modify any , and just to be sure I checked using 'show all : ;' : : 4. Now I backup the database : : backup database ; : : As expected it creates a single set with a single piece whose name is : in the o/p: : : channel ORA_DISK_1: finished piece 1 at 21-Jun-2003 00:13:01 : piece handle=D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 comment=NONE : channel ORA_DISK_1: backup set complete, elapsed time: 00:00:28 : Finished backup at 21-Jun-2003 00:13:01 : : : 5. I confirm this by using 'list backup ;' and : list backup of controlfile ; : : 6. NOW THE PROBLEM IS : : : : RMAN> report obsolete recovery window of 1 days ; : : no obsolete backups found : : : RMAN> report obsolete recovery window of 2 days ; : : no obsolete backups found : : : : RMAN> report obsolete recovery window of 3 days ; : : Report of obsolete backups and copies : Type KeyCompletion TimeFilename/Handle : - -- -- : Backup Set3 21-Jun-2003 00:12:52 : Backup Piece 3 21-Jun-2003 00:12:52 : D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 : : Why is this happening for all values above 2 days ? : Please advise : . : -- 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 - 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: Should percent increase higher than 0 in 817?
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 8.1.7, where there is no need for this, given that locally-managed tablespaces are supported, where PCTINCREASE is NOT even relevant. If you use One of the historical reasons for having a non-zero PCTINCREASE in the Oracle6 and Oracle7 days, was to urge SMON to automatically coalesce free space, at the end of the file, especially after an object is dropped. In 7.3, the alter tablespace XXX coalesce command was introduced, which provided on-demand coalescing even with PCTINCREASE at 0. If you have dictionary-managed tablespaces try to convert to locally-managed tablespaces. Otherwise, use a PCTINCREASE of 0, use uniform extent sizes at the tablespace and DO NOT use extent-sizing at the object-level. Cheers, Gaja --- [EMAIL PROTECTED] wrote: Everything I have seen says no. I did the following. Set PCTINCREASE = 0 Set my initial and next extents to 5m so they are uniform. A woman I work with swears there is Oracle documentation that in 817 PCTINCREASE should be greater than 0 because the default is 50. ORA-03232 unable to allocate an extent of string blocks from tablespace string Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater than the tablespace's NEXT value. Action: Increase the value of NEXT for the tablespace using ALTER TABLESPACE DEFAULT STORAGE or decrease the value of HASH_MULTIBLOCK_IO_COUNT. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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). = __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
Re: RMAN - Remote vs Local Backups
Metalink Note 73431.1 has an RMAN Compatibility Matrix. TargetRMANCatalog DBCatalog Schema 9.2.0>=9.0.3>=8.1.x >= RMAN executable An RMAN920 schema can be created in an Oracle 8.1.6 database that contains the recovery catalog for Oracle 9.2.0 databases. Have Fun :) DENNIS WILLIAMS wrote: Jared - Excellent point. My understanding is that the RMAN catalog must run on an Oracle version equal or greater than the target instances. Has anyone found this requirement to be a big pain? I am looking to configuring RMAN on another set of servers, but they are Oracle 9.2 and my current RMAN server is 8.1.6, and would need an O.S. upgrade to move to 9.2. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Dennis, The cron job can run on B only if it is the same version of Oracle that is on A. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/29/2003 03:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RMAN - Remote vs Local Backups Walter - What you describe is the standard RMAN configuration. Box B contains the RMAN catalog, therefore it must command the backup. And so the cron job must run on Box B. But the actual backup occurs on the target machine (A in your example). If you back up to tape, you must have an MML (Media Management Library). You can also back up to disk (that is what I do). Since the actual backup occurs on the target machine, not much network traffic is involved. RMAN sends some commands, the target sends some status back, and that is about it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Thanks Tim, Dennis and Ron for your feedback. I appreciate it. Let me clarify what I'm seeking. In my example, I am using a centralized catalog which is on its own dedicated database/server and backups are to tape. BCV's are not involved. Normally, in my experience, RMAN backups are initiated from the target server via a cron job. But, I've seen a case where a cron job for an RMAN backup was run from a box that was different from the database server machine. I find this configuration strange and confusing because it implies this was done for a "reason" and makes life difficult to find out where all the backups are running from. In the scenario of backing up the database on box A via an rman/cron job on box B, is this particular configuration more 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 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: Alternative way to write delete query
delete from table_a a
where exists
( select null
from table_b b
where a.column = b.col_a
or a.column = b.col_b
)
Have Fun :)
Mark Richard wrote:
Hi List,
I'm having a mental blank and looking for suggestions... I'm trying to
remember alternative ways to write the below query:
delete from table
where column in (select col_a
from table_b
union all
select col_b
from table_b);
Having said that, I don't mind if you simplify the nested query down to
"select col_a from table_b" even. I just have a feeling that I've seen an
equivalent query written totally differently but I can't remember how. I
have a feeling it effectively allows more than one table to be mentioned in
the delete without needing a nested query (like the options available in
normal selects).
Any suggestions?
Thanks,
Mark.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message
(or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
by reply e-mail or by telephone on (61 3) 9612-6999.
Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
that do not relate 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 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: C++ Issues
From the Oracle C++ Call Interface Programmer's Guide Release 2 (9.2): Oracle C++ Call Interface (OCCI) is an application program interface (API) that provides C++ applications access to data in an Oracle database. OCCI enables C++ programmers to utilize the full range of Oracle database operations, including SQL statement processing and object manipulation. The Net Services 9.0.1 client included with the Oracle 9i Developer Suite can still connect to Oracle 7.3.4 databases. Note: although Oracle 7.3.4 is not supported on Windows 2000, it can be installed 1st (in default home using a Y2K compliant installer) then peacefully coexist with later Oracle versions. Have Fun :) Post, Ethan wrote: I am trying to track this down for a buddy, any ideas, I know nothing about C++. Thanks, Ethan Our application currently has presentation programs written in Microsoft Visual C++ that read Oracle Version 7.3.4 databases. We have Oracle Professional/2000 installed on 1 machine. The Pro*C/C++ pre-compiler provided by Oracle is the method we use to pre-compile our program. This pre-compile converts the EXEC SQL commands into C++ calls to incorporate the Oracle Database functions into the programs. Other methods I have found in research is to use OCI or ODBC calls. However everything I look at indicates that we would need to rewrite our applications to utilize additional include libraries as well as modify our SQL calls to wrap them with the appropriate language elements. We wish to fully utilize the functionality of the Microsoft Visual C++ Professional Edition environment to allow each developer to use their own machine to compile and unit test these programs. However, I am unable to get the pre compile process to work. Pro C will not run on our machines if it is not installed. We get a "Incorrect environment variable. Please reinstall Pro*C/C++" message version error if we try to run the copy that is on the compiler machine from our machine. However, I can not install it because Oracle 7.3.4 does not support Windows 2000 and the installation process abends whenever I try to run it. What we are looking for is a method to compile, debug, and unit test using C++ on our machine without getting rid of Pro*C/C++ and yet utilize each developer's machine more to remove the load from 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 - 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: OT: PLSQL question, JAVA, JDBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:986230504001 Have Fun :) Darrell Landrum wrote: I'd take a look on http://java.sun.com, there are some great forums there. Also try http://devtrends.oracle.com. [EMAIL PROTECTED] 03/27/03 11:03AM >>> Hi list, this is a question for JAVA/PLSQL programmers. I need to pass an array object from my code in Java using JDBC to a stored procedure in Oracle. I do not know how to do that, could you give me a call example so I can figure out how to achieve this ? TIA Gabriel Aragon __ 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 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: Oracle Licences Req on Intel Xeon CPU
http://www.microsoft.com/windows2000/server/evaluation/performance/reports/hyperthread.asp has a link to an article that has the BIOS requirement for logical CPU numbering (and start-up order). Note: since Windows 2000 Server does support up to four CPU's, the task manager does display 4 CPU's on a hyperthreaded dual XEON computer. Have Fun :) david hill wrote: Yes Redhat Advanced Server 2.1 does support hyperthreading. Its not to bad either. I ran some tests and we get about a 15% increase in performance with hyperthreading turned on. -Original Message- From: Michael Brown [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Licences Req on Intel Xeon CPU 2000 only shows 2 CPUs because it cannot take advantage hyperthreading. From what I have read (Intel's website, some others), hyperthreading requires both BIOS and OS support to be utilized. Currently, XP and the newer Linux releases are all that I have seen that will take advantage of it. My research on this was fairly light since I was just after can Redhat Advanced Server support it, but I do remember seeing that W2K would not. -- Michael Brown Glen Raven, Inc./Info Services Senior Oracle DBA 1831 N. Park Ave Phone: (336)586-1146Glen Raven, NC 27217 Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 26, 2003 3:44 AM To: Multiple recipients of list ORACLE-L Depending on the OS, Microsoft has different CPU counts. The Windows 2000 family counts each hyper thread as 1 CPU. In contrast, Windows XP and Windows 2003 Server count each CPU instead of each hyper thread. Thus, the task manager in Windows XP Professional show 4 CPU's (on a dual XEON CPU computer with hyper threading enabled) while Windows 2000 Professional only shows 2 CPU's in the task manager. Have Fun :) [EMAIL PROTECTED] wrote: >Hi all > >For those that are running or intending on running Oracle on >Intel's Xeon CPU, the following information may be of interest to you. > >The Xeon CPU has a feature called Hyper Threading with double the number >of registers. This feature when turned will present to the Operating >Systems an additional virtual CPU. As far as the O/S is concern, it >looks like there are _two_ CPUs. What does this mean to your software >licensing? > >Microsoft says that it is one CPU. What does Oracle say? > >Well, it depends on who you speak to and what day of the week it is. >Seriously, you will need to get some confirmation in writing from your >account manager the next time you purchase Oracle S/w for Intel's Xeon > >ta >tony > > _ / |Tony Jambu, Database&Web Consultant > /_ _/_ __ / |Wizard Consulting Pty Ltd > /(_)/ )(_/ \_/(///(/_)/_( |IOUG's Select Asia-Pacific Tech. Editor > \___/ |EMAIL: TJambu @ wizard.cx (REMOVE Spaces from email ) >----|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 - 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). -- 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 - 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: Hotsos Clinic 101 Feedback
Attending a Hotsos Clinic and Hotsos Symposium was very worthwhile. If an employer cannot afford the training time, flexing work hours (or using vacation) may be possible. Note: if you do attend a Hotsos event on your own time, your company name can be removed from your name tag ;) Looks like some Hotsos Clinics have been scheduled in 4 countries: Apr 8 - 10 Chicago, IL, USA May 13 - 15 London area, UK Jun 2 - 4 Reykjavik, Iceland Jun 10 -12 Ottawa, ON, CA Aug 12 - 14 Denver, CO, USA Personally, I enjoy listening and learning from Cary, Jeff, and Gary. Have Fun :) Michael Brown wrote: I've taken it twice (one of the first public classes and again the when they started offering the reduced alumni rate), and stand by my quote on Hotsos's website. "If you have the time to take a class, take the Hotsos Clinic. It was the absolute best performance tuning resource that I have ever invested time in." Of course, I would change "tuning" to "optimization" since we are making tuning a dirty word. For those of you who were not at the Hotsos Symposium in Dallas, you missed a fantastic conference. You should make your plans to be in Las Vegas next year. I am not affiliated in any way with Hotsos, just am impressed by both the knowledge Cary and Jeff have and their ability to convey it to others. -- Michael Brown Glen Raven, Inc./Info Services Senior Oracle DBA 1831 N. Park Ave Phone: (336)586-1146Glen Raven, NC 27217 Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message- Stefick Sent: Wednesday, March 26, 2003 2:09 PM To: Multiple recipients of list ORACLE-L I haven't taken it yet, but I am signed up for the Chicago Clinic on April 8-10Can't Wait! I've heard really good things about it. At 08:04 AM 3/26/03 -0800, you wrote: Anybody take this course before. Any comments, good or bad. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow 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). ** Scott Stefick Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick 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). -- 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 - 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: Oracle Licences Req on Intel Xeon CPU
Depending on the OS, Microsoft has different CPU counts. The Windows 2000 family counts each hyper thread as 1 CPU. In contrast, Windows XP and Windows 2003 Server count each CPU instead of each hyper thread. Thus, the task manager in Windows XP Professional show 4 CPU's (on a dual XEON CPU computer with hyper threading enabled) while Windows 2000 Professional only shows 2 CPU's in the task manager. Have Fun :) [EMAIL PROTECTED] wrote: Hi all For those that are running or intending on running Oracle on Intel's Xeon CPU, the following information may be of interest to you. The Xeon CPU has a feature called Hyper Threading with double the number of registers. This feature when turned will present to the Operating Systems an additional virtual CPU. As far as the O/S is concern, it looks like there are _two_ CPUs. What does this mean to your software licensing? Microsoft says that it is one CPU. What does Oracle say? Well, it depends on who you speak to and what day of the week it is. Seriously, you will need to get some confirmation in writing from your account manager the next time you purchase Oracle S/w for Intel's Xeon ta tony _ / |Tony Jambu, Database&Web Consultant /_ _/_ __ / |Wizard Consulting Pty Ltd /(_)/ )(_/ \_/(///(/_)/_( |IOUG's Select Asia-Pacific Tech. Editor \___/ |EMAIL: TJambu @ wizard.cx (REMOVE Spaces from email ) |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 - 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: HP-UX 11i/8.1.7.4/login.sql
Personally, I use a modification of Tom Kyte's sql*plus setup from "Expert One-On-One Oracle" (book publisher bankrupt): -- Connect.sql CONNECT&1 UNDEFINE 1 @@Login.sql SETTERMOUTOFF SAVEafiedt.bufREPLACE DEFINEprompt_global_name = SQL COLUMNprompt_globalNEW_VALUE prompt_global_name SELECT LOWER(USER)||'@'||SUBSTR(global_name,1,INSTR(global_name,'.')-1) prompt_global FROM global_name / SETSQLPROMPT"&&prompt_global_name>" SETSQLCONTINUE"&&prompt_global_name>" UNDEFINEprompt_global_name CLEARCOLUMNprompt_global SELECT * FROM v$version / SETTERMOUTON GETafiedt.bufNOLIST -- Login.sql SETARRAYSIZE6 SETMAXDATA6 SETLINESIZE132 SETLONG1 SETPAGESIZE1000 SETSERVEROUTPUTONSIZE100 SETTABON SETTRIMSPOOLON SETTERMOUTON In sql*plus I now use @connect user... instead of connect user... The Connect.sql script saves any SQL in the buffer, changes the prompt, displays database version info, and restores the SQL into the buffer. If the connection fails (e.g. bad password), the SQL> prompt appears. Have Fun :) Vergara, Michael (TEM) wrote: That I can do... -- variable sqlpmpt varchar2(30); set termout off pause off verify off declare username varchar2(30); instname varchar2(30); begin begin select substr(global_name, 1, instr(global_name||'.', '.')-1) into instname from global_name; exception when OTHERS then instname := 'UNK'; end; begin select user into username from dual; exception when OTHERS then username := 'SQL'; end; :sqlpmpt := instname||'-'||username||'> '; exception when OTHERS then :sqlpmpt := 'SQL> '; end; / select :sqlpmpt sqlp from dual; set sqlprompt '&sqlp_var' column sqlp clear undefine sqlp_var undefine sqlpmpt define _editor=vi set trimspoolon set pagesize 24 set tab off set serveroutput on set termout on -Original Message- Sent: Tuesday, March 25, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Perhaps you could send the contents of your LOGIN.SQL -Original Message- Sent: Tuesday, March 25, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Greetings Everyone! I have a LOGIN.SQL script that I've customized to fit my preferences. However, when I use SQLPLUS /NOLOG, it fails miserably since there is no connection to the database. Is there a way - other than undefining ORACLE_PATH - that the LOGIN.SQL script can be skipped or ignored when using the /NOLOG parameter? Thanks, Mike --- === 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 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: Problems installing Developer on XP
http://otn.oracle.com/software/products/forms/content.html has a link to download Oracle Forms Developer/Services 6i Release 2 for Windows 98/NT/2000/XP that was posted 13 Feb 03. Note: this is the first Forms 6i installer that can install on Windows XP Professional (previous versions were disabled). The OTN Forms statement of direction is worth reading: http://otn.oracle.com/products/forms/htdocs/FormsSOD.html Looks like Windows XP Professional will be the last Windows platform to be certified for Forms 6i client/server deployment. Also, OTN has a certification matrix for Forms 6i: http://otn.oracle.com/products/forms/htdocs/clientsod_forms6i.html Have Fun :) Babette Turner-Underwood wrote: I am trying to install Developer 6i on a Pentium 4 Xeon The Oracle Universal Intaller has a problem and tries to send error report to Microsfot. I checked Metalink and the workaround was to search for symcjit.dll in the install directories and rename to symcjit.old ... did this. Also the solution was to replace JInitiator 1.1.7 with JInitiator 1.1.8. I checked and when I installed Oracle 9i on this machine the 1.1.8 was installed and I do not have the 1.1.7 under c:\programs\oracle\jre 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 - 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: Locally Managed Tablespaces
The other pctincrease option that preserves a multiple of the extent size is 100. Similiar to LMT autoallocate extent sizes always being a multiple of 64K. Have Fun :) Rachel Carmichael wrote: pctincrease=0 and set the storage parameters at the tablespace level and do NOT put storage parameters on the individual objects. you can "fake" the workings (without the bitmap!) of an LMT by doing that. Next extent=initial extent, pctincrease=0 will effectively allocate extents of equal sizes --- [EMAIL PROTECTED] wrote: thanks in case I happen to work on a 7.3 database what kind of pctincrease should I set? What about the other settings? Just curious. Ryan From: "BALA,PRAKASH (HP-USA,ex1)" <[EMAIL PROTECTED]> Date: 2003/03/21 Fri PM 12:54:41 EST To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Locally Managed Tablespaces Once you set to uniform extents, pctincrease will default to 0. Most Oracle gurus advise to just use uniform extents for all situations. -Original Message- Sent: Friday, March 21, 2003 10:59 To: Multiple recipients of list ORACLE-L This is probably pretty basic, so please keep in mind that Im a developer and Im trying to pick up more of the DBA side. I am assuming that the preferred way to create a tablespace in 8i, 9i is as follows(this is out of OTN docs) CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K; When you use Uniform Extents you know longer have to worry about tablespace fragmentation correct? You also do not need to worry minimum,initial,and next extents correct? What are some rules of thumb for setting PCTINCREASE(there is another PCT setting too right)? A DBA I used to work with said you should almost always use zero for PCTINCREASE. Could someone please tell me why? The default is like 40? Is there a time when I should not use Uniform Extents? Thanks... hope this isnt too basic. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BALA,PRAKASH (HP-USA,ex1) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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). __ 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 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: Running multiple instances on a [large] server
A Dell Inspiron 8200 laptop has 1 GB of RAM with 30 GB of disk running Window 2000 Professional. The SGA sizes for 5 Oracle instances are: Oracle 7.3.4.5.0 - 11 MB Oracle 8.0.6.3.8 - 15 MB Oracle 8.1.7.4.1 - 94 MB Oracle 9.0.1.4.0 - 109 MB Oracle 9.2.0.2.1 - 113 MB While presenting, the task 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 and it definitely wasn't production anything Rachel -- 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 - 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: netappfilers
http://www.netapp.com/products has Network Appliance (NetApp) product information. Have Fun :) kommareddy sreenivasa wrote: Hi All: OS: solaris 2.8 DB: 8i I am new to the concept netappfilers. I dont know even abc of this. What I know is, they are some sort of disks and used to improve I/O. Can somebody through some light on this ? if anybody have any documentation, URLs etc, can you pass it to me? Thanks and Regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.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 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: 9i OCP Upgrade Exam - Again
If your employer is an Oracle Partner, an employee benefit is free access to the Oracle Learning Network, which has many Oracle 9i OCP Upgrade modules (very well done - using as a model for IOUG presentations). Also, reading the "Oracle 9i Database Concepts" manual is free (and always worthwhile). The "New Features" manual has useful information. Personally, I did not use the 9i books and STS for preparation (not available before the 9i beta upgrade exam). Note: Oracle Learning Network professional subscription is $ 349/year. http://www.oracle.com/education/oln/ Have Fun :) DENNIS WILLIAMS wrote: Paula - Here is a pretty good on-line reference. Not quite detailed enough for the exam, but he explains things clearly. http://www.oracle-base.com/Links/9inf.pdf <http://www.oracle-base.com/Links/9inf.pdf> One tip I picked up from my Oracle instructor is that most of the exam questions seem to be taken from the notes at the bottom of the page of the Oracle class notes. Don't know if this is true. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 03, 2003 10:04 AM To: Multiple recipients of list ORACLE-L 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 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: Oracle Performance Tuning Exam
Depends on the path chosen to Oracle 9i DBA OCP: 1A) Pass the 5 Oracle 8i OCP DBA exams, then pass the Oracle 9i DBA OCP upgrade exam (total of 6 exams, but still does not need an Oracle Univeristy course) Note: if Oracle retires the Oracle8i DBA exams like the Oracle 8 DBA exams, they would be available until May 2004 (5 months after Error Correction End Support). 2A) Pass 2 exams for Oracle 9i DBA OCA (Associate), 2B) Pass 2 more exams and attend an Oracle Univeristy course (unless an Oracle 9i DBA OCP exam was passed before Sep 1, 2002) http://www.oracle.com/education/certification/index.html?certpaths.html has the certification path information (Oracle has promised to publish changes 6 months before implementation) The Oracle 9i DBA OCM (Master) requires Oracle 9i DBA OCP, 2 advanced DBA courses from Oracle Univeristy, and passing a 2 day hands-on exam (using Oracle on Red-Hat Linux). While I agree with the continuing education requirement, I disagree that Oracle University is the ONLY place that offers high quality advanced DBA education. I wish Oracle would count the Hotsos Symposium 2003 (and future Hotsos Symposiums as a meeting the Master education requirement). In my meager experience of Oracle conferences, the Hotsos Symposium has been the best education value. Since my employer won't pay for OCM (cutting training budget again), I would rather attend several conferences (and learn from many fine people on this list) than spend $ 4,000 to $ 7,000+ pursuing 9i DBA OCM. Realistically, OCP DBA only validates that someone can read and memorize; I passed 3 of my 4 certifications without hands-on experience using that version of Oracle. The exams validated I had spent some time learning the terminology of new features, but offer no indication that I know how to use them. As more hairs turn gray (silver), I can appreciate why experience is needed and valued. Also, certification does show an employer serious interest in becoming a DBA. Have Fun :) OCP DBA 7.3, 8, 8i, & 9i (yea yea I got the paper and the plastic, but this list is far more educational and fun) Alan Davey wrote: If you are taking the 9i certification, there are only 4 exams that you have to take. Unfortunately, unless you took at least one exam last year and got "grand-fathered", you will have to enroll at Oracle U. for one of the four courses covering 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 - 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: Oracle version??
My inventory logs (19 files, 16.6 MB) do have a verbose record of OUI actions. Note: all the installation logs can be deleted to clean up space. Also, the inventory logs only record OUI actions. The Oracle 8.1.7.4.6 patch installation does not use OUI (the DBA manually copies many files into the Oracle Home), which does cause a mismatch between the inventory version and the actual version installed. On the OUI opening screen, the "Installed Products..." button can be used to display the current inventory. Thus, I was looking in the inventory folder trying to guess what OUI is using. Looking again, I found some more interesting folders: N:\Oracle\Inventory\PatchSets\oracle.server\8.1.7.4.1\1\resources N:\Oracle\Inventory\PatchSets\oracle.server\9.0.1.4.0\1\resources N:\Oracle\Inventory\PatchSets\oracle.server\9.2.0.2.1\1\resources The inventory folders does provide 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 :) Rajesh Dayal wrote: Hi Chip, I am talking of log directory(N:\Oracle\Inventory\logs and not N:\Oracle\Inventory\components), where every Installer action is logged and not . This doesn't matter whether your Oracle.exe is replaced or not. All of your OUI actions will be logged with all the relevant information and typically the file names are of following format. installActions2003-01-21_12-01-02PM.log So if you put little extra effort digging these files (depending on size, timestamp etc.) you can find out what is last activity you performed on what ORACLE_HOME and so the precise patch level is also available there... And that YP-ZP I mean XP, I would really hate to see a Oracle Database on that ;-)... Cheers, Rajesh -Original Message- Sent: Thursday, February 27, 2003 11:59 AM To: Multiple recipients of list ORACLE-L In the registry "My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc" specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have no record of the patch (e.g. 8.1.7.4.6). Inside the inventory folder, "Components" and "Patches" have folders for components installed by OUI. For example, my inventory folder contains these folders: N:\Oracle\Inventory\Components\oracle.server\8.1.7.0.0\1\resources N:\Oracle\Inventory\Components\oracle.server\9.0.1.1.1\1\resources N:\Oracle\Inventory\Components\oracle.server\9.2.0.1.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\8.1.7.4.1\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.0.1.4.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.2.0.2.1\1\resources Note: the version numbers (folder names) do match my OUI installation of Oracle servers and patches. When using Windows XP Pro, the properties of oracle.exe is interesting - the version displayed near the top is 0.0.0.0, yet the "File Version" near the bottom of the dialog box does display the correct version. Wonder how Windows XP Pro finds the correct version, while Windows 2000 Pro can't see it. Have Fun :) Rajesh Dayal wrote: Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL P
Re: Oracle version??
In the registry "My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc" specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have no record of the patch (e.g. 8.1.7.4.6). Inside the inventory folder, "Components" and "Patches" have folders for components installed by OUI. For example, my inventory folder contains these folders: N:\Oracle\Inventory\Components\oracle.server\8.1.7.0.0\1\resources N:\Oracle\Inventory\Components\oracle.server\9.0.1.1.1\1\resources N:\Oracle\Inventory\Components\oracle.server\9.2.0.1.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\8.1.7.4.1\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.0.1.4.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.2.0.2.1\1\resources Note: the version numbers (folder names) do match my OUI installation of Oracle servers and patches. When using Windows XP Pro, the properties of oracle.exe is interesting - the version displayed near the top is 0.0.0.0, yet the "File Version" near the bottom of the dialog box does display the correct version. Wonder how Windows XP Pro finds the correct version, while Windows 2000 Pro can't see it. Have Fun :) Rajesh Dayal wrote: Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- 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 - 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: ODBC and password expire messages
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, which could also issue SQL statements. Note: the "Oracle Call Interface Programmer's Guide" describes the OCIPasswordChange() function, but I do not know how to call OCI functions from VB. Have Fun :) When adding or configuring ODBC us Martin, Alan (Contractor) (DLIS) wrote: ODBC and password expire messages Hi listers: In another moment you'll be able to tell I'm not ODBC literate. I can query a UNIX 9i DB using SQL*Plus from my PC using a Oracle9i client, and get ORA-28002: the password will expire within 10 days. The 8i client (to a 9i DB) does not show these messages. Neither does the 8i Oracle ODBC Test. I'd like to test a 9i ODBC connection from the PC client. I don't see an Oracle ODBC Test for the 9i client ORACLE_HOME. Is it still available? Should the ORA-28002 be passed back via ODBC? How does one check for it in VB? Thanx, Alan Martin Defense Logistics Information Service Battle Creek, MI
Re: Dealing with 3rd Party Applications
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 number for part of the name), used briefly for storing a 1-dimensional list, then the table was dropped before allowing the user to interact with the application. An enhancement request was entered into the vendor's system about the serialization being forced by the logon change and suggesting an alternate method. Note: ironically the patch was done trying to improve logon time. Several months later, the vendor changed their implementation. Have Fun :) DENNIS WILLIAMS wrote: Darrell said: "Yes, read the vendor documentation, then scrutinize it." Tim said: "Don't neglect the possibility that the application is somehow misconfigured or configured inappropriately somehow." Amen to both. The vendor may have a stupid method of using Oracle. But you must understand their stupid method before you can work around it. Often vendors assume the lowest common denominator in the DBA, and many companies buy Oracle and an application without hiring a DBA. Neither Oracle or the 3rd party vendor will refuse their money. Sometimes the vendor will discourage the use of something like partitioning because they fear the novice DBA would be over his/her head with that and then the vendor reaps the blame. But once you understand how the vendor uses Oracle, you are in a position to be creative. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 26, 2003 7:19 PM To: Multiple recipients of list ORACLE-L Jeff, Comments inline... So my boss comes over this morning and tells me that the users are having a performance problem with a 3rd party application that have recently began using. This is an oracle database where they bought the software and had the system admin install the software which included the vendors instruction of creating and setting up the database (basically use the defaults). It is an Oracle 8.1.7 database on Windows 2000. He wants me to find out "if you can create some indexes or something", etc. (he likes to give solutions before the cause if discovered). Good observation about your boss -- never forget it! Anyway, I decide to take a look at it. The performance they are complaining about is when they log into the application it takes about a minute for their initial screen (which includes a list of values) to appear. I use the tool that someone posted here a while ago, SQL Monitor from www.fastalgo.com, and find that during the time the user is waiting for the first screen the application is executing a sql statement about 2200 times. Excellent technique. Never used the tool, but you are responding to the facts and symptoms, not conjecture and guesses... The SQL is: SELECT PARENTID FROM PROC_ WHERE PROCEDUREID=:1 The bind variable is different for each execution with appears to be the procedureid values from the table proc_. Table proc_ has 2203 rows. I check the executions for the sql text in v$sqlarea. Executions = 58,825. (aha, I think this is the problem). I explain plan the query and find that it is using the primary key index. My tuning skills are still pretty basic. Since I have no control over the application is there anything I can do to increase the performance of running the query thousands of times? Your tuning skills are not basic. You know enough to look before assuming and you appear to know your way around an Oracle database. It is not easy to tune something that is executing thousands of times, except to work on reducing the cost per execution. How many "logical reads" is each execution performing? Or, at least how many logical reads are performed in total and what is the number of executions? I have posted an Oracle8i AFTER LOGON database-event trigger in a script named "tracetrg.sql" at http://www.EvDBT.com/tools.htm. You can use that trigger to initiate SQL Tracing immediately upon connection by the user. Are you familiar with SQL Trace and TKPROF? Hopefully, the parameter TIMED_STATISTICS is set to TRUE in this database; if it isn't, you can enable it in the TRACETRG trigger for the session (i.e. "execute immediate 'alter session set timed_statistics = true';") or using ALTER SYSTEM to set it to TRUE for the instance. If you can set TIMED_STATISTICS to TRUE, then please use the "sort=prsela,exeela,fchela" clause with the TKPROF command; if it is FALSE, then please use "sort=exeqry,execu,fchqry,fchcu" clause. This way, the worst SQL statements will percolate to the top of the TKPROF report... If you can get a
Re: Basic RMAN question
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. I have oracle 9.2.0.1.0 installed on Redhat AS 2.1 When i issue the command: rman target='backup_admin/backup as [EMAIL PROTECTED]' nocatalog log="test.log" rman: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri
Re: SQL struggle - UPDATE too?
Do these SQL statements work ? SELECT whse_code , item_num , last_cost , ( SELECT last_cost FROM item_whl1 WHERE whse_code = 'HL1' ANDREPLACE(u.item_num,'-OR') = hl1.item_num ) hl1_cost FROM item_wu / UPDATE ( SELECT whse_code , item_num , last_cost , ( SELECT last_cost FROM item_whl1 WHERE whse_code = 'HL1' ANDREPLACE(u.item_num,'-OR') = hl1.item_num ) hl1_cost FROM item_wu WHERE whse_code <> 'HL1' ) SET last_cost = hl1_cost / Note: whse_code and item_num could be removed from the UPDATE statement. Also, added WHERE whse_code <> 'HL1' so the source last_cost is not updated to its current value (reduces redo log entries and rollback segment usage). Have Fun :) Saira Somani wrote: I am very confused (and fairly new to SQL which would be my excuse to post such amateurish questions on this list). Now I've been asked to update LAST_COST on item_w so it looks like this: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR1.12 CPD-TGH 111230-OR1.12 HL1 50034 .91 MSH-CDS 50034 .91 CPD-TGH 50034-OR .91 HL1 650300 4.789 TWH-STAT 650300 4.789 CPD-TWH 650300-OR 4.789 CPD-TGH 650300-OR 4.789 -Original Message- Sent: February 25, 2003 12:55 PM To: '[EMAIL PROTECTED]' List Gurus, I need help and I won't be ashamed to ask :) Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODEITEM_NUM LAST_COSTLAST_COST_REV - -- HL1 111230 1.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0 0.91 HL1 650300 4.789 4.789 TWH-STAT 650300 0 4.789 CPD-TWH 650300-OR 0 4.789 CPD-TGH 650300-OR 0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can 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://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: newbie sqlplus ?
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 /db/oracle/admin/817db2 /db/oracle/admin/817db3 Each admin/817db# directory should have these sub-directories: adhoc adump bdump cdump create exp logbook pfile udump The database file directories could be: /db/oradata/817db1 /db/oradata/817db2 /db/oradata/817db3 If more mount points are available, then /db could be replaced by other mount points for database files. Have Fun :) Les Ayudo wrote: RE: newbie sqlplus ? Another question, I setup my computer like this: $ORACLE_BASE=/db/oracle $ORACHE_HOME=/db/oracle/ora817/817home My oracle directories like this: /db/oracle/ora817/817db1 --files for db1 /db/oracle/ora817/817db2 --files for db2 /db/oracle/ora817/817db3 --files for db3 During the installation, i get a prompt asking me for db file installation, would this be /db/oracle/ora817/817db1 ? if this was my 1st db being installed? - Original Message - From: Les Ayudo To: Multiple recipients of list ORACLE-L Sent: Monday, February 24, 2003 2:10PM Subject: Re: newbie sqlplus ? Well, since I already went through the deinstalloption and also deleted the $oracle_home, is there something else I cando? I'm trying to reinstall the db but i'm getting a prompt asking me ifI want to upgrade or migrate the old db at /db/oracle/... (strange since i haddeleted that folder). Can i just ignore this option and proceed w/ theinstall w/o the install going haywire? Can I still delete the old db w/dbassist after the install? - Original Message - From: Chris Stephens To: Multiple recipients of list ORACLE-L Sent: Monday, February 24, 2003 1:30 PM Subject: RE: newbie sqlplus ? Launch $ORACLE_HOME/bin/dbassist and delete any database you have created. Then launch the installer from your oracle cd and select deinstall option to deinstall the software. chris -Original Message- From: Les Ayudo [mailto:[EMAIL PROTECTED]] Sent: Monday, February 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: newbie sqlplus ? I'm just going to reinstall Oracle8i and start from scratch. Any docs out there on uninstalling Oracle8i? The only ones I have found are on Windows and they're all saying how Oracle does not completely uninstall. Is this true for Oracle on Solaris? I ran the uninstaller and removed everything but I noticed the oracle home was still there. I ended up deleting it. Is there anything else I need to do? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 2:34 AM > hi! > > in your profile set $ORACLE_HOME to your oracle directory and > put $ORACLE_HOME/bin in your path > > daniel > > Les Ayudo wrote: > > > > I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued > > the command sqlplus and I rec'd a "command not found" error. Is there > > something I forgt to do before the install? Let me kow if u need more info. > > THanks. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Daniel Wisser > 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 co
Re: Problem starting Oracle on W2K
set ORACLE_HOME=d:\oracle\ora81 set ORACLE_SID=everest lsnrctl start net start OracleServiceeverest svrmgrl @startora.sql The windows service has to be started before connect internal works. Have Fun :) [EMAIL PROTECTED] wrote: Hi ... oracle 817 ee os - win2k sp3 since i dont want oracle to start always on my home pc, i have changed the services to manual. whenever i want oracle, i run the below batch file : set ORACLE_HOME=d:\oracle\ora81 set ORACLE_SID=everest lsnrctl start svrmgrl @startora.sql /* startora.sql */ connect internal startup exit but when i start svrmgrl, i get the error "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-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: corrupted block
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 (upgrading Oracle 7 to Oracle 8i could contain a nasty surprise). Have Fun :) Ponnusamy wrote: I had the same belief that RMAN catches the corruption earlier, but not NOW. We had a database crash two months back and while performing the recovery(RMAN) one of the restored data file was corrupted. *BIG SHOCK* to everyone..We ran the dbverify on the restored files, the corruption showed up easily.. But not a single clue on the RMAN backup logs'. We asked Oracle Support, if rman checks for corruption in the data files when the data files are being backed up.. He said "No".. Oracle Ver: 8.1.7.2/Sun 2.6 ..Ponnusamy At 11:40 AM 2/24/2003 -0800, DENNIS WILLIAMS wrote: Stephen RMAN ignored your corrupted block? Ya gotta tell us more man! We're relying on it to catch everything. Did you have the MAXCORRUPT parameter set? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, February 24, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I think more recent versions of Oracle have options for skipping corrupt blocks with exports. One possible way: If you have a valid primary key index on the table, and the index is in a good tablespace, you might be able to cycle through all the primary keys, select the row corresponding to that primary key and insert it into a new table. I was able to do this about a month ago with a 8.1.7 database. In my case, I think it was a block header that was corrupt, not data; so I got all the data OK. It was rather slow, grabbing and inserting one row at a time; but I got all the data. As long as I didn't do anything that would cause a table scan of any kind, I could get the data. By the way, rman not only failed to spot the corruption, but backed it up AND restored the corruption! My initial attempt was to just rename the datafile at the file system level, then recover it from the previous backup. I could relate another one of those TAR non-support -- total and complete NON-support! -- on this one. > -Original Message- > > So my question is, if all backups contain the corrupted > block, how would > I copy all non-corrupted blocks from this table into a new table? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Embeded password in script
$cd ${STUFF}/log
$cat ../parms/dbimpl.Connect
connect dbimpl/[EMAIL PROTECTED] as sysdba
-- Optionally, could have sql*plus environment modifications
$cat ../sql/demo.sql
@../parms/&1..Connect
-- SQL commands
shutdown
exit
$sqlplus /nolog @../sql/demo.sql dbimpl
The unix permissions on the parms directory can be quite restrictive
(only authorized people).
The sql directory can be read only to the world (no passwords are stored
in any scripts).
The ps command cannot display the password, but can show what script is
running.
Have Fun :)
Nguyen, David M wrote:
I have been tasked to write a script to run SQL. I don't want a password
field to be shown in the script. Does someone have run into this and have a
better idea? For example, I have following line in my script.
Sqlplus dbimpl/password @SQLscript.sql
Also, from command line we go through following steps to shutdown database,
how do I code these steps in the script?
$svrmgrl
SVRMGRL>connect internal
SVRMGRL>shutdown
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 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: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments
#0 - Do understand the business need(s) being met (along with business terminology). Being able to commincate technical information in terms that business decision makers use is critical for the business bottom line (and by extension - your own bottom line). Have Fun :) Freeman Robert - IL wrote: Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 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 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: general recovery scenarios
The "Oracle Backup & Recovery 101" book by Kenny Smith & Stephan Haisley is worthwhile (RMAN 9i syntax is an appendix). In contrast, Robert Freeman placed RMAN 8i syntax into an appendix. Robert's RMAN 9i book is the only one that includes examples with 4 different Media Management Layers (Veritas NetBackup, Legato Networker Module, Tivoli Storage Manager, and HP Omniback II v4.0) for backup and recovery using tape. Also, Regis University offers an online course, MSCD 642 Database Backup and Recovery, that includes several practice scenarios (using Oracle at home or an online Citrix Server). http://www.regis.edu/regis.asp?sctn=apg&p1=gp&p2=mscit&p3=cd Have Fun :) Freeman Robert - IL wrote: If I may, my Oracle9i RMAN Backup and Recovery book provides a number of different recovery case studies, from the simple to the complex, that you can work though with RMAN. Robert Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Saturday, February 22, 2003 7:24 PM To: Multiple recipients of list ORACLE-L Since you want to learn, how about getting Rama Velpuri's Oracle Backup and Recovery Guide. I find it to be the *best* book on this subject. It also has a number recovery scenarios for you to practice and learn. - Kirti (Just finished recovering a database from a loss of 7 data files. Thanks to our brave & bold SAs, who were installing Veritas VM and moving files around to newer disk..) -Original Message- Sent: Saturday, February 22, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Sorry folks .. i asked a wrong question. thanks for ur answers but those crashing dbs recovery was totally heavy for me. i shud i have asked, what r the different types of crashes and how to recover from them ? i mean, only the general recovery scenarious. since i m learning, i just want to understand the most frequent ones and learn recovering. say like, Rich Jesse mentioned, recovering a truncate'd table from the backup. something similiar, on those lines. albiet, thanks for the earlier answers ! -sam -- 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 - 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: SqlNet Response ports
Searching Metalink for "firewall" turns up several useful documents (e.g. notes 131524.1 and 125021.1). The Oracle Connection Manager may be worth exploring. Just wondering how NMCI handles web page access. Also, a Citrix Terminal Server (next to the database server) may be a possibility for client/server (especially over a WAN). Have Fun :) Regina Harter wrote: Hi listers, Here is a question my client asked me, that I can't seem to find the answer to on metalink, mostly because I am not sure how to frame the search query. If you don't know what NMCI is, just know that it is a government program that is establishing control over the network which our database servers are on. Anyone have any ideas or advice for me? TIA, Regina Then, one of the NMCI technical guys mentioned that NMCI PCs wouldn t allow inbound/outbound 1521 traffic (SQLNET). Hence, no NMCI user would be able to use any client/server application. Wow, that s a major problem. There are a few possible solutions. 1. Configure the database server to listen on port 443, because NMCI allows 443. But, SQLNET uses random high order ports on the return. Anybody know if you can configure 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 - 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).
