RE: Contigency plan
Please check Tech Republic web site, the are some information. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 09:17 To: Multiple recipients of list ORACLE-L Cc: [EMAIL PROTECTED] Subject:Contigency plan Hi all, Do you guys have any good references (books or URLs) that teach some good Oracle potential problems with solutions for my contingency plan? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = Internet Headers: Start = Received: from 63.74.90.24 by lionvillelab.com; FRI, 11 May 2001 09:17:02 -0400 Received: from newsfeed.cts.com ([209.68.248.164]) by mail.bee.net (Post.Office MTA v3.5.3 release 223 ID# 0-52106U5000L500S0V35) with ESMTP id net for [EMAIL PROTECTED]; Fri, 11 May 2001 09:12:30 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA89919; Fri, 11 May 2001 06:09:37 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 00300AC6; Fri, 11 May 2001 05:45:45 -0800 Message-ID: [EMAIL PROTECTED] Date: Fri, 11 May 2001 05:45:45 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Sinardy Xing [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit = Internet Headers: End === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tran, Chieu Minh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 - RE: PostGres
Nope, not yet. It's on my list of things to test and do with the system. Right now, I'm just doing the design and development -- I know, I know, I should probably architect the system better first, but this really is just a family project at the moment. When I do get to testing and scaling and backup and recovery and tuning and sizing and all that grand stuff, I'll make sure to post to the list. Even though we're all Oracle professionals, I know we're also getting tired of the bloat. It's nice to have an alternative sometimes. :) I certainly learned that when I was actually in the position of having the budget and having to pay for the darn stuff. Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] [EMAIL PROTECTED] ms.osd.mil To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Fax to: Subject: OT - RE: PostGres 05/11/2001 03:12 PM Please respond to ORACLE-L Diana, Sounds like an excellent alternative to higher end systems (shoots self in oracle-foot). Have you tested how well it scales yet? Scott Shafer San Antonio, TX 210-581-6217 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Shared Memory Problem
Upanesh,
Steve Adams' book, Oracle 8i Internal Services, has a really good explanation
of the shared pool behaviour (and other SGA structures). The following
is a brief summary of what is happening in your case.
Approximately half of the shared pool size is reserved (as free memory)
when the instance is started up. As the utilisation of the shared
pool increases with time the free memory is released into the shared pool.
The ORA-4031 error occurs when all of the reserved free memory has been
allocated. Flushing the shared pool coalesces contiguous free memory
chunks, creating larger memory chunks which can be allocated thus avoiding
the 4031 error.
You could also pin large and frequently used objects into the shared
pool to help alleviate the problem (especially sequences if you are going
to flush the shared pool). Pinning helps to reduce fragmentation
of the shared pool. By doing this you will also gain a better understanding
of the optimum size that your shared pool should be.
The final option is to increase the shared pool size (if you have memory
resource available).
Glen
Upanesh Patel wrote:
Hello,
We're Running Oracle 8.1.6.2 on Sun 420R with solaris
7. We have a front-end Siebel 2000 Sales Package. We
have about 50 concurrent users and a lot of Siebel
Workflow Process (which basically just route the work
from one user to the next... so lot of sql it send to
the server...) and have an SGA of about 120M of which
60M is shared_Pool_size...
Problem:
ORA-04031: unable to allocate 4096 bytes of shared
memory ("shared pool","unknown object","PL/SQL
MPCODE","BAMIMA: Bam Buffer")
It looks like Siebel is using bind variables, so that
should not be a problem. Also, this erros occurs
after the database has been up for about 5 days.
Is there a bug or anything with Oracle 8.1.6.2?
TIA,
Upanesh
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Upanesh Patel
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051
FAX: (858) 538-5051
San Diego, California --
Public Internet access / Mailing Lists
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).
--
Glen Mitchell NZ Phone: +64 9 3730400
Energy Research Lab URL: http://www.peace.com
Peace Software Email: [EMAIL PROTECTED]
RE: RE: Silver vs. Gold support
The Lord, of course. || -Original Message- || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 6:50 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: RE: Silver vs. Gold support || || || honey if I am the goddess here then who would I be afraid of exactly? || || lol || || || || || From: Mohan, Ross [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: RE: RE: Silver vs. Gold support || Date: Fri, 11 May 2001 08:50:50 -0800 || || Is this truly the beloved authoress of Oracle DBA 101 I hear? || || You speak sourly of our Lord in front of his very home? || snicker snicker || || || -Original Message- || || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 11, 2001 10:21 AM || || To: Multiple recipients of list ORACLE-L || || Subject: RE: RE: Silver vs. Gold support || || || || || || so the support bill we just paid should get refunded because || || it was for || || Silver Support which no longer exists? and I pay for support || || but they || || desupport the products I have paid support for, and instead || || of giving me the || || new software release so that the support I paid for is still || || relevant, they || || will charge me for the update. And not give me a prorated refund. || || || || Ya know, if I'm gonna get screwed I'd at least like to enjoy it || || || || || || || || || || From: Eric D. Pierce [EMAIL PROTECTED] || || Reply-To: [EMAIL PROTECTED] || || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || || Subject: RE: RE: Silver vs. Gold support || || Date: Thu, 10 May 2001 13:17:06 -0800 || || || || Apparently now Bronze/Silver is just called Product || || Support, and Gold is called Premium. All 24x7. || || || || Upgrades have been split off. || || || || Of course now Metalink has to also be renamed (Oracle Ink9i, or || || OInk9i?) since there is no more Metal, right. :) || || || || || || http://www.oracle.com/support/index.html?support_ebus.html || || || || ---excerpt--- || || || || ... || || Oracle Support is leveraging the power of the Internet || || to deliver simpler and sharply focused support services, || || while making their purchase faster and easier. To || || facilitate web-based transactions, Product Support is || || now priced as a percentage of list license price. || || [7% of license cost (annual?)] || || Additionally, software updates can be purchased separately || || on a subscription basis, || || [15% of license cost, annual] || || and our OracleBRONZE and OracleSILVER services have been || || consolidated into a single 24 x7 technical assistance || || service and removed from the price list. OracleGOLD, || || OracleLifecycle and our Oracle Expertise service || || capabilities are now offered within the Premium Support || || menu. || || || || ... || || || || ---end--- || || || || || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Eric D. Pierce || ||INET: [EMAIL PROTECTED] || || || || Fat City Network Services-- (858) 538-5051 FAX: || (858) 538-5051 || || San Diego, California-- Public Internet access / || || Mailing Lists || || || || || 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). || || || || _ || || Get your FREE download of MSN Explorer at http://explorer.msn.com || || || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Rachel Carmichael || || INET: [EMAIL PROTECTED] || || || || Fat City Network Services-- (858) 538-5051 FAX: || (858) 538-5051 || || San Diego, California-- Public Internet access / || || Mailing Lists || || || || || 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.com || -- || Author: Mohan, Ross ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists ||
OT RE: RE: Silver vs. Gold support
LOL!! || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 9:26 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: RE: Silver vs. Gold support || || || HELP || || On 11 May 2001, at 10:41, Mohan, Ross wrote: || || ... || But, even if I leave the happy world of Power Units, || Armani suits, and self-tuning apps, I will still || stay on this list, just to ask people my favorite || question: Are you an idiot? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Contigency plan (Thank You fyi)
Thank You Guys, -Original Message- Xing Sent: Friday, 11 May 2001 9:46 PM To: Multiple recipients of list ORACLE-L Hi all, Do you guys have any good references (books or URLs) that teach some good Oracle potential problems with solutions for my contingency plan? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: When to go for ORACLE NAMES Server
Sounds like client-based Forms would be OK with ONS, then. Or, izzit? - ross ( i won't FedEx you a burger, but write yerself a raincheck) || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 11:50 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: When to go for ORACLE NAMES Server || || || || Ross, || || What I was referring to was using Oracle Forms directly on || Unix, *not* through iAS. iAS takes care of that stuff for || you. || || Lesse, I tried using forms 5.x on Solaris a couple of years || ago, and much to my dismay found that tnsnames.ora was || *required* in order to connect to a database. This was || on a box that worked just fine with ORANAMES when || connecting via sqlplus or Perl. || || Reports had the same problem. || || I was troubleshooting some forms of the 6i variety on Solaris || a few months ago, and since I still had the tnsnames.ora setup || on that box from the previous go round with forms, I honestly || don't know if Forms 6i required it or not. || || The trouble shooting was in native forms mode on Solaris 2.6, || though the forms were moved to another box and run in iAS, || which functioned just fine with ORANAMES. || || I don't have ORANAMES setup here at home or I would try || and test this here. || || Jared || || On Friday 11 May 2001 10:45, Mohan, Ross wrote: || Jared, || || You may have just earned yourself a dinner. (And I || promise you will not receive it the way you did my || $0.02 recently ;-) || || Can you tell me more...alot more would be grand...about || how Forms needs tnsnames? || || *thanks* || || Ross || || || -Original Message- || || From: Jared Still [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 11, 2001 1:43 PM || || To: [EMAIL PROTECTED]; Mohan, Ross || || Subject: Re: When to go for ORACLE NAMES Server || || || || || || || || Somewhat of a pain to setup for the first time, for sure. || || || || But after you get it implemented, you will never want to || || go back. || || || || One caveat: There is a fair amount of software around || || that *requires* tnsnames.ora or it won't work. Oracle || || Forms on unix comes to mind. Yes, Oracle's own software || || does not fully utilize names. || || || || This is a minor problem when compared to the benefits though. || || || || Jared || || || || On Friday 11 May 2001 10:50, Mohan, Ross wrote: || || if the tediousness exceeds your perception of the || || || || difficulty, do Names. || || || || if not, not. || || || || In my very limited experience, a truly robust, || || || || well-managed Names service || || || || is great, but takes some work to set up, test, and document. || || || || YMMV || || || || || -Original Message- || || || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || || || Sent: Friday, May 11, 2001 12:15 PM || || || To: Multiple recipients of list ORACLE-L || || || Subject: When to go for ORACLE NAMES Server || || || || || || || || || There is another thread going on about no database on || || || a single server, I have another question to ask. || || || || || || We have nearly 30 databases across Sun and Win 2000 || || || Platforms. We are finding it tedious to keep track of || || || tnsnames.ora. While looking out for a solution we hit || || || at ORACLE Names server. I hear it is going to give way || || || to ORACLE Internet directory. But after reading a || || || little I think using either would be too much of a || || || kill for the problem. || || || || || || Any opinions? || || || || || || || || || __ || || || Do You Yahoo!? || || || Yahoo! Auctions - buy the things you want at great prices || || || http://auctions.yahoo.com/ || || || -- || || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || || -- || || || Author: Johnson Poovathummoottil || || || INET: [EMAIL PROTECTED] || || || || || || Fat City Network Services-- (858) 538-5051 FAX: || || || || (858) 538-5051 || || || || || San Diego, California-- Public Internet access / || || || Mailing Lists || || || || || || || || || || 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.com || -- || Author: Jared Still || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858)
why index taking more space.
Hi gurus, I am try to create index on table ... and after esimating the size of index ... then I created the index the estimated size is different from actaul allocated size... I am missing something. Non unique index calculation: block size - 161 16384-161 = 16223 2) pct free of table 8% 16223 * (8/100) = 1297.84 3)avilable space to store index entries 16223 - 1297.84 = 14925.16 4)space used per row: avg.row length + no of columns + number oof long columns + 8 header bytes avg row size : select avg(nvl(vsize(rollno),0)) + avg(nvl(vsize(asses_no),0)) avg length from lis.parcel = 6.56 space used per row: 6.56 + 2 + 0 + 8 = 16.56 bytes 5) entries /block = trunc(14925.16/16.56) = 901 entries. 6) no of blocks needed = totno of rows/entries per block = 1874863 /901 = 2080.9 (approx) size of index = no of blocks * block size = 2080.9* 16384 = 32 mb aproximately around 32 -33 mb So when I created index CREATE INDEX VNZ_PARCEL_INDEX ON VNZ_PARCEL(ROLL_NO, ASSESS_NO) TABLESPACE LIS_IDX3 PCTFREE 5 STORAGE(INITIAL 56623104 NEXT 1048576 PCTINCREASE 0 ) ; and I cheked the size of index by going through the extents it is around 59 mb with 4 extens. Can some body explain me why the index space more than expected ? Am I missing some thing. regards naren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Urgent: Why is system tablespace growing?
Presently that seems to be the only reason for the mentioned error. However, as suggested by other members you should alter all users to have temporary Tablespace as TEMP (and not system). Also check that all the users have their default tablespace as non-system tablespace. HTH, Rajesh -Original Message- Sent: Sunday, May 13, 2001 12:10 AM To: Multiple recipients of list ORACLE-L Rajesh, touser's temporary tablespace is temp, do have any other idea's as to why system tablespace is suddenly running out of space? Thanks abdul latif --- Rajesh Dayal [EMAIL PROTECTED] wrote: Check whether the user TOUSER has a default setting of SYSTEM tablespace for TEMPORARY TABLESPACE. You can perform this check by following query: Select temporary_tablespace from dba_users where username = 'TOUSER'; If the result points to SYSTEM tablespace, then alter the user as follows: ALTER USER touser temporary tablespace temp ; Then try reimporting .. HTH, Rajesh -Original Message- Sent: Saturday, May 12, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Does anyone know why system tablespace is changing? I'm doing an fromuser touser import and the system tablespace is for some reason is being written to. Here what is being reported: IMP-00017: following statement failed with ORACLE error 1652: CREATE UNIQUE INDEX PK_BF ON PAGE (ID ) P CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536) LOGGING IMP-3: ORACLE error 1652 encountered ORA-01652: unable to extend temp segment by 1065 in tablespace SYSTEM IMP-00017: following statement failed with ORACLE error 1652: CREATE INDEX I_BFPT ON FLOW (ID ) P CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536) LOGGING IMP-3: ORACLE error 1652 encountered ORA-01652: unable to extend temp segment by 1065 in tablespace SYSTEM IMP-00017: following statement failed with ORACLE error 1652: TIA abdul latif __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: abdul latif INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: abdul latif INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Running remote scripts
Hi All, Env. is TRU64 Unix and Oracle 7.3.4 This is a standby server configuration. I want to run certain scripts(on secondary server), based on some incident on primary server. And on top of that, every thing has to be fully automated(using cron). I got stuck at a point where I need to run some script on secondary without explicitly logging on secondary server. I tried using rsh, but it executes just one single command. I would appreciate if some one can guide me on this. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Fwd: Re: DATABASE COMPARE SCRIPT
--Boundary-00=_TI6B0KP3KE5T3HEN611V
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 8bit
The database compare script didn't come out to well the first
time, so I've just embedded them in this post.
The scripts are:
clears.sql
columns.sql
title.sql
schema_diff.sql
Jared
--- title.sql - copied from title80.sql
-- specify line width when calling
-- eg @title 'report heading' 90
rem TITLE.SQL - This SQL*Plus script builds a standard report
rem heading for database reports that are XX columns
rem
column TODAY NEW_VALUE CURRENT_DATENOPRINT
column TIMENEW_VALUE CURRENT_TIMENOPRINT
column DATABASENEW_VALUE DATA_BASE NOPRINT
set term off feed off
rem
define COMPANY = BCBSO
define HEADING = 1
col cPageNumLoc new_value PageNumLoc noprint
select ('2' - 10 ) cPageNumLoc from dual;
rem
TTITLE LEFT Date: current_date CENTER company col PageNumLoc Page:
format 999 -
SQL.PNO SKIP 1 LEFT Time: current_time CENTER heading RIGHT -
format a15 SQL.USER SKIP 1 CENTER format a20 data_base SKIP 2
rem
rem
set heading off
set pagesize 0
rem
column passout new_value dbname noprint
SELECT TO_CHAR(SYSDATE,'MM/DD/YY') TODAY,
TO_CHAR(SYSDATE,'HH:MI AM') TIME,
--DATABASE||' Database' DATABASE,
--rtrim(database) passout
name||' Database' DATABASE,
lower(rtrim(name)) passout
FROM v$database;
set term on feed on
rem
set heading on
set pagesize 58
set line 2
set newpage 0
define db = '_dbname'
undef 1 2
---
-- columns.sql
col blocks format 99,999,999 head 'BLOCKS'
col db_link format a30 head 'DB LINK'
col db_link_instance format a30 head 'DB LINK|INSTANCE'
col db_link_username format a10 head 'DB LINK|USERNAME'
col empty_blocks format 99,999,999 head 'EMPTY BLOCKS'
col host format a10 head 'HOST'
col index_name format a30 head 'INDEX NAME'
col initial_extent format 9,999,999,999 head 'INITIAL|EXTENT'
col instance format a4 head 'INST'
col max_blocks format 9,999,999 head 'MAX BLOCKS'
col max_bytes format 99,999,999,999 head 'MAX BYTES'
col max_extents format 999,999 head 'MAX|EXTENTS'
col min_extents format 999 head 'MIN|EXT'
col next_extent format 9,999,999,999 head 'NEXT|EXTENT'
col object_name format a30 head 'OBJECT NAME'
col owner format a10 head 'OWNER'
col pct_free format 999 head 'PCT|FREE'
col pct_increase format 999 head 'PCT|INC'
col pct_used format 999 head 'PCT|USED'
col synonym_name format a30 head 'SYNONYM NAME'
col table_name format a30 head 'TABLE NAME'
col table_owner format a10 head 'TABLE|OWNER'
col tablespace_name format a15 head 'TABLESPACE|NAME'
col timestamp format a19 head 'TIME STAMP'
col username format a10 head 'USERNAME'
col last_ddl_time head 'LAST DDL|TIME'
col created head 'CREATED'
col procedure_name format a30 head 'PROCEDURE NAME'
col function_name format a30 head 'FUNCTION NAME'
col package_name format a30 head 'PACKAGE NAME'
col package_body_name format a30 head 'PACKAGE BODY NAME'
col segment_name format a30 head 'SEGMENT NAME'
--
-- clears.sql
set pause off
set echo off
set trimspool on
set feed on term on echo off verify off
set line 80
set pages 24 head on
clear col
clear break
clear computes
btitle ''
ttitle ''
btitle off
ttitle off
---
-- schema_diff.sql
-- Jared Still
-- [EMAIL PROTECTED]
-- [EMAIL PROTECTED]
--
--
-- 07/14/1999 jkstill - removed table_owner from the index_diff
-- section as this made all indexes appear
-- in the difference report if the schemas
-- had different names
-- -
-- this script will create reports of the
-- differences between 2 schemas
-- the reports created are:
-- table_diff.txt
-- index_diff.txt
-- arg_diff.txt
-- sequence_diff.txt
-- all differences are checked both
-- ways - schema1 is compared to schema2
-- and then schema2 is compared to schema1
-- it does not matter which database the
-- reports are initiated from
-- requirements:
--
-- either global links or database links to
-- the schemas to be compared
--
-- dba privileges
--
-- this report creates temporary tables for it's reports
-- they are left intact for your perusal
-- tables:
-- arg_diff
-- index_diff
-- table_diff
--
-- REPORT SUMMARY
-- table_diff.txt
-- this report compares tables from 2 schemas
-- included are
--tables/columns that appear in a table in
--one schema, and not the other
--
--any differences between columns; includes
--order of column, type and size.
-- index_diff.txt
-- this report compares indexes from 2 schemas
-- included are
--indexes that appear in one schema
--and not the other
--
--any differences between index structures
--does not check for storage parms
-- arg_diff.txt
-- this report compares arguments from 2 schemas
-- included are
--all procedures/packages/functions
Re: When to go for ORACLE NAMES Server
On Sunday 13 May 2001 18:51, Mohan, Ross wrote: Sounds like client-based Forms would be OK with ONS, then. Or, izzit? Forms 5 wouldn't work on Solaris with ONS. I'm not sure about forms 6 or 6i. MetaBlink is stuck right now or I'd try and verify this through support. Jared - ross ( i won't FedEx you a burger, but write yerself a raincheck) || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 11:50 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: When to go for ORACLE NAMES Server || || || || Ross, || || What I was referring to was using Oracle Forms directly on || Unix, *not* through iAS. iAS takes care of that stuff for || you. || || Lesse, I tried using forms 5.x on Solaris a couple of years || ago, and much to my dismay found that tnsnames.ora was || *required* in order to connect to a database. This was || on a box that worked just fine with ORANAMES when || connecting via sqlplus or Perl. || || Reports had the same problem. || || I was troubleshooting some forms of the 6i variety on Solaris || a few months ago, and since I still had the tnsnames.ora setup || on that box from the previous go round with forms, I honestly || don't know if Forms 6i required it or not. || || The trouble shooting was in native forms mode on Solaris 2.6, || though the forms were moved to another box and run in iAS, || which functioned just fine with ORANAMES. || || I don't have ORANAMES setup here at home or I would try || and test this here. || || Jared || || On Friday 11 May 2001 10:45, Mohan, Ross wrote: || Jared, || || You may have just earned yourself a dinner. (And I || promise you will not receive it the way you did my || $0.02 recently ;-) || || Can you tell me more...alot more would be grand...about || how Forms needs tnsnames? || || *thanks* || || Ross || || || -Original Message- || || From: Jared Still [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 11, 2001 1:43 PM || || To: [EMAIL PROTECTED]; Mohan, Ross || || Subject: Re: When to go for ORACLE NAMES Server || || || || || || || || Somewhat of a pain to setup for the first time, for sure. || || || || But after you get it implemented, you will never want to || || go back. || || || || One caveat: There is a fair amount of software around || || that *requires* tnsnames.ora or it won't work. Oracle || || Forms on unix comes to mind. Yes, Oracle's own software || || does not fully utilize names. || || || || This is a minor problem when compared to the benefits though. || || || || Jared || || || || On Friday 11 May 2001 10:50, Mohan, Ross wrote: || || if the tediousness exceeds your perception of the || || || || difficulty, do Names. || || || || if not, not. || || || || In my very limited experience, a truly robust, || || || || well-managed Names service || || || || is great, but takes some work to set up, test, and document. || || || || YMMV || || || || || -Original Message- || || || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || || || Sent: Friday, May 11, 2001 12:15 PM || || || To: Multiple recipients of list ORACLE-L || || || Subject: When to go for ORACLE NAMES Server || || || || || || || || || There is another thread going on about no database on || || || a single server, I have another question to ask. || || || || || || We have nearly 30 databases across Sun and Win 2000 || || || Platforms. We are finding it tedious to keep track of || || || tnsnames.ora. While looking out for a solution we hit || || || at ORACLE Names server. I hear it is going to give way || || || to ORACLE Internet directory. But after reading a || || || little I think using either would be too much of a || || || kill for the problem. || || || || || || Any opinions? || || || || || || || || || __ || || || Do You Yahoo!? || || || Yahoo! Auctions - buy the things you want at great prices || || || http://auctions.yahoo.com/ || || || -- || || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || || -- || || || Author: Johnson Poovathummoottil || || || INET: [EMAIL PROTECTED] || || || || || || Fat City Network Services-- (858) 538-5051 FAX: || || || || (858) 538-5051 || || || || || San Diego, California-- Public Internet access / || || || Mailing Lists || || || || || || 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
