Not able to view table

[S.Jyotinarayan]

Hi all,
I have created with the following 
details:
 
Global DB name: manu.ifpjyo
SID:    
manu
Username:   
SYSTEM
Password:    
manager
Tables:    
tblBundleCon, tblTextCon, tblFinalImage
 
I am able to connect to the database:
SQL> connect system@manu
password: ***
Connected.
 
But I am unable to view the tables that I have 
created:
SQL>select * from tblBundleCon;
    
*
ERROR at line 1:
ORA-00942: table or view does not 
exist
 
I get the above error. Where am I going 
wrong,
Thanx a lot in advance.
Jyoti.

Re: PATCH confirmation

[Nikunj Gupta]

How long does it take to install complete patch from 8.1.7.0 to 8.1.7.2 ?



Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 12:10 PM


> yes
> 
> Seema Singh wrote:
> >
> > Hi
> > I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0 right?
> > thanks
> > seema
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dennis M. Heisler
>   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: Nikunj Gupta
  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).

Control files & Redo Logs

[Sujatha Madan]

Hi!!!

Is it a good idea to put redo logs and control files on the same disk with
nothing else on the disk???

Thanks

Sujatha
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sujatha Madan
  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: Question! ORA-12571

[Long . Nguyen]

Hien,

I would try to uninstall Oracle and reinstall it. It is possible that teh networking 
component was not installed properly. Below is an extract from Oracle 8i iInstallation 
Guide - release 3 (8.1.7) for NT on how to manually remove all
Oracle components from NT.

Long




To remove all Oracle components from a computer on Windows NT: 



Caution: 
These instructions remove all Oracle components, services, and registry entries from 
your computer. In addition, any database files under ORACLE_BASE\ORADATA\DB_NAME are 
also removed. Exercise extreme care when removing registry entries.
Removing incorrect entries can break your system.  


 
 


Ensure you are logged in as a user with Administrator privileges. 

Stop all Oracle services (if any are running): 

Choose Start > Settings > Control Panel > Services. 

If any Oracle services (their names begin with Oracle) exist and have the status 
Started, select the service and choose Stop. 

Choose Close to exit the Services window. 

Start the registry at the MS-DOS command prompt: 

C:\> REGEDT32

Go to HKEY_CLASSES_ROOT. 

Delete any key that starts with Oracle or ORCL. 

Go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. 

Delete the ORACLE key. 

Delete the Oracle ODBC Driver key under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI. 

Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and remove all keys under 
here that begin with ORACLE. 

Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services \EventLog\Application, and 
remove all keys under here that begin with ORACLE. 

Go to HKEY_CURRENT_USER\SOFTWARE\ORACLE. 

Delete keys that start with Oracle or ORCL (if any exist). 

Go to HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBCINST.INI. 

Delete any Oracle keys (if any exist). 

Close the registry. 

Go to Start > Settings > Control Panel > System > Environment tab. 

Choose the system variable path and modify the Path variable. 

Remove any Oracle entries from the path. For example, if JRE was installed by Oracle, 
remove the %ORACLE_HOME%\BIN path and the JRE path. You may see a path similar to this 
one: 

C:\ORACLE\ORA81\BIN;G:\PROGRAM FILES\ORACLE\JRE\1.1.7\BIN 

Exit the Control Panel. 

Go to SYSTEM_DRIVE:\WINNT\PROFILES\ALL USERS\START MENU\PROGRAMS. 

Delete the following icons: 

Oracle - HOME_NAME 

Oracle Installation Products 

where HOME_NAME is the previous Oracle home name. 

Delete SYSTEM_DRIVE:\Program Files\Oracle through Windows NT Explorer. 

Delete all ORACLE_BASE directories on your hard drive. 

Reboot your computer. 
-- 
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: Standby Database

[K Gopalakrishnan]

Richard,

Comments inline..

-Original Message-
Sent: Thursday, November 29, 2001 6:40 AM
To: Multiple recipients of list ORACLE-L

This sounds good, but I have a couple of questions.  How do you guarantee
that
you won't lose any committed transactions?  I mean, the C program could lag
behind
the LGWR since it's only reading it without lock and it's copying the online
redo over
to a remote machine.  So for a busy database, the LGWR will just keep
writing and the
C program won't be able to keep up with it's pace.

The external program uses X$KCCCP as a feedback for copying process. X$KCCCP
will have
the current log block (Disk RBA) and this will have the change vectors for
last commit. So you
copy the change vectors/ redo records immediately as soon as it is written.
If LGWR can keep
writing the files means why can't your C program copy the files?

Are you copying the whole partially filled online redo? or just the
difference
since the last commit?
Difference from last copy.. (last commit )



Did I miss understand it?  Please advise.

>>> [EMAIL PROTECTED] 11/29/01 12:40AM >>>

If you want to Zero data loss in standby you can copy the online redo logs
thru an external C program.  You can copy the online redo log files when
the LGWR is writing to it.

The program should read the log files without locking. You can use the fixed
table  X$KCCLE and X$KCCCP to find how much is written in the log files.
The partially filled log file  can be shipped to the standby location and
you can
open the standby database with the new control file created with NORESETLOGs
.

In this way you have a graceful fail over in the standby database and no
committed
Transaction is lost in the standby database

Does this sound good?

Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Wednesday, November 28, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L

I am also facing the same problem. All these disadvantages in 8i standby DB
have been taken care of in oracle 9i version. The other solution could be to
buy an expensive Veritas Cluster server/Database edition.

Thanks,
-- Janardhana babu

-Original Message-
Sent: Wednesday, November 28, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Quick question.  Is it a fair statement to say that using Oracle's hot
standby database allows you recoverability up to the last archive log, but
would NOT recover to the latest redo log (prior to a log switch).  In other
words, the potential to lose transactions is very high if you depend on this
for failover (not good for e-commerce type databases).  Would it be possible
to somehow mirror redo logs across to the failover server and apply them
when activating the standby database, or is the only real solution
clustering or something like DoubleTake?

Am I making sense?

Thanks,

Ed


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed
  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: Janardhana Babu
  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!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
  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
--

RE: backup unix script

[Tatireddy, Shrinivas (MED, Keane)]

should we say the !  is a tag like EOF(what we normally use).

srinivas
-Original Message-
Sent: Thursday, November 29, 2001 4:37 PM
To: Multiple recipients of list ORACLE-L


Hi grace 

it basically means that log in to sql*plus and execute
whatever is below this line till you hit bang(!) ..
literally. 

Deepak

--- grace <[EMAIL PROTECTED]> wrote:
> hi gurus,
> 
> I found this unix script ... can any tell me what
> this means?
> sqlplus - sys/msd > filename.dat < does anyone have a unix script to perform a database
> backups?
> 
> Best Regards,
> Grace Lim
> Suy Sing Comm'l Corp.
> (632)-2474134
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: grace
>   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! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  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: Tatireddy, Shrinivas (MED, Keane)
  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: Question! ORA-12571

[Hoang Duy Hien]

Thank Jared and Folks!
I Tried to config HW, Almost not find out any misconfugured HW.
I also reinstall SP2 of W2k.
Last two week I reinstalled Windows and It's working until now then repeat
that error.
Please tell me how to turn trace file on, view log... or uninstall Oracle
all cleaned, delete in Registry because I uninstall Oracle but see in
service still oracle services.

Best Regards!
Hien.



- Original Message -
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 2:01 AM



Hien,

This could be a problem with your Network.  You need to talk to your
network admin about this.

It's also been a problem with Oracle at times, but in older versions.  When
we've
experienced this, it's been a bad piece of HW or misconfugured HW.

There's a lot on MetaLink, so check there.

Jared

=
Hoang Duy Hien ([EMAIL PROTECTED]) wrote:

Hi all,
I have been out of the Oracle loop for awhile now, and I think that's why I
ma having triuble with simply installing the server. No matter what I do,
after the installation
succeeds, I cannotcreate a new database. I always get the error ORA-12571:
TNS Packet Writer
Failure. I have tried looking into Net* problems, but have come up short.
COuld someone direct down the
right path or perhaps send an answer.

My OS: Windows 2000 Adv server, SP2.
My Oracle: 8.1.6 (8.1.7).

Thanks, Hien


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hoang Duy Hien
  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: Off Topic - Windows XP Dialup connection

[Peter . McLarty]

Actually unless you have XP Professional you cant join a domain it is one the the things that differentiate HOME from Professional

HTH


Peter McLarty                   E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.Mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461 
Brisbane,  Australia                Mobile: +61 (0)402 094 238           
--                    Facsimile: +61 (0)7 3303 3048






"Jesse W. Asher" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
29/11/2001 11:06 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        Re: Off Topic - Windows XP Dialup connection



You're right - this is off topic and doesn't belong on this list at all.  Please take your quest for XP configuration  information elsewhere

Brian Haas wrote:
On Wed, 28 Nov 2001, Smith, Ron L. wrote:
This is off topic but I am trying to find someone with experience on Windows
XP.  I am trying to use a dial up connection
to connect to my office network from home.  I get connected but my NT logon
proc doesn't execute so I cannot see the
all of the network domains.  This connection worked under Windows 98 and ME.
Any suggestions?


mmm...get rid of winxp for starters ;)

I'm not positive, but with win2k, which may or may not be like xp, 
there should be some options on a dialup connection to join your domain and/or 
run your logon script. Just hunt around in the dial up properties. Right click
your connection and view the properties. under the options tab in win2k is a check box 
to logon to windows domain.

Gee and I thought they made XP based on years of usability research to make 
things easier...go figure.


HTH,

-Brian
 -- 
# Brian Haas <[EMAIL PROTECTED]>       Oracle DBA #
# Phone: (541)774-5211    #


-- 
Jesse W. Asher

"They that can give up essential liberty to purchase a little temporary
safety, deserve neither liberty or safety."  - Benjamin Franklin





-- 
This transmission is for the intended addressee only and is confidential
information.  If you have received this transmission in error, please
delete it and notify the sender.  The contents of this e-mail are the
opinion of the writer only and are not endorsed by the Mincom Group
of companies unless expressly stated otherwise.

Re: OT: Solaris

[Peter . McLarty]

Hi  Lisa

Hed on over to http://www.sunmanagers.org and subscribe there for a good list regarding Sun Admin. Have a look at the archive

http://docs.sun.com/ab2/ contains the sun Administrators Docs

This is also a good book

http://www.oreilly.com/catalog/solaris8/

HTH

Cheers

Peter McLarty                   E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.Mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461 
Brisbane,  Australia                Mobile: +61 (0)402 094 238           
--                    Facsimile: +61 (0)7 3303 3048






"Koivu, Lisa" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
30/11/2001 04:49 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        OT: Solaris


I apologize if this is a duplicate. 
I may be thrown into solaris system administration .  Can anyone recommend any good books, websites, etc. for a beginner?  I consider myself unix savvy but not an expert and am not adverse to starting at square one, especially since my employer will pay for any book I want.  Going to training isn't an option, however.  
Any suggestions would be greatly appreciated. 
Thank you very much 
Lisa Koivu 
Oracle Database Monkey Mama 
Fairfield Resorts, Inc. 
954-935-4117 



-- 
This transmission is for the intended addressee only and is confidential
information.  If you have received this transmission in error, please
delete it and notify the sender.  The contents of this e-mail are the
opinion of the writer only and are not endorsed by the Mincom Group
of companies unless expressly stated otherwise.

RE: Duplicating a Database and Changig SID

[Kevin Fries]

I'm 
interested, please post it to the list.

-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Ron YountSent: 
Thursday, November 29, 2001 5:50 PMTo: Multiple recipients of 
list ORACLE-LSubject: RE: Duplicating a Database and Changig 
SID
If 
you are using RMAN and would like some direction on how to change the DBID 
as well, let me know and I will send you some directions/steps for that as 
well.
 
-Ron-

-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Sonja 
SehovicSent: Thursday, November 29, 2001 5:45 
AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: Duplicating a Database and Changig SID
Hi!
 
Before I 
tell you procedure, be aware that when you make a clone of your database 
DBID remains the same, which is a problem if you use RMAN for you 
backups.
 
Steps 
are:
0. On 
your database issue: 
 alter 
database backup controlfile to trace 
resetlogs;
1. Backup 
your database.
2. Shutdown database (shutdown 
immediate)
3. Copy 
all your datafile, logfiles, controlfiles to the new 
location
4. Edit 
your new init.ora file and change DB_NAME, DB_BLOCK_SIZE must be the 
same, 
  
  change path for controlfiles, user_dump_dest, 
background_dump_dest, core_dump_dest
5. 
Edit  your new controlfile (which you get in step 0) and change it 
in:
    
CREATE CONTROLFILE REUSE SET DATABASE 'NEWSID' RESETLOGS 

    and change the path of 
datafiles and logs
6. 
Recreate you control file.
7. Change 
your tnsnames.ora and sqlnet.ora files.
 
This 
should do. 
I had no 
problems in doing that
 
HTH,
    Sonja

 

-Original Message-From: MRaval 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, 
November 28, 2001 7:55 PMTo: Multiple recipients of list 
ORACLE-LSubject: Duplicating a Database and Changig 
SID
Hi Guys,
 
I am newbie oracle DBA and want to duplicate my  
development database to Test database and want to change ORACLE_SID, 
Could anyone tell exact steps that I have to follow. My database is 
on SUN 5.6 and oracle 8.1.6.
 
Thanks,

RE: Possibly moving to Sun Equipment

[Seley, Linda]

We have a few production E420Rs, 4-450 mhz processors, 1 to 1.5 G
memory.  I've been quoted benchmarks (although I haven't researched
them) that an equivalent Intel processor runs faster.  Based on that I
might be inclined to recommend faster processors if we were buying new.
The CPU does seem to be the weakest area (but then they're 450's, what
do we expect?).  However, we have our front end app on one box, Oracle
Applications on another.  We don't have much volume on a regular basis
but the times we have (like the time 75,000+ emails were generated
through the concurrent manager within 10 hour time frame) the machines
handled them without breaking a sweat.  We've had one minor hardware
issue with one E420R in a year and a half (comparatively we've had more
problems with our E4500s).  

HTH

Linda

-Original Message-
Sent: Thursday, November 29, 2001 2:50 PM
To: Multiple recipients of list ORACLE-L


Sorry for the double posting.  I failed to include a subject line
initially.
My first day back, and already a list faux paus.  Two I guess if you
count
the double post.

Hello All,
It has been a while since I have been here, but I am back and properly s
ubscribed to the list again.  I am looking to draw from your experiences
here with hardware.  Our current database resides on a Data General
Aviion
system with a Clarion drive cabinet.  While we are very pleased with the
system, and it's performance Data General is going the way of the
Dinosaur,
so we need to look at other options.  The ones most currently floated
have
been the Sparc 880 or the 420R either configured with dual gigahertz
processors.  The IT manager has a desk piled high with marketing
gobbledeegook, and has asked me if I know anything about either system.
All
I have been able to do is assure him that Solaris is essentially UNIX,
and
tell him I would check with some knowledgeable folks here about the
hardware.  Our DG box sports a Gig of RAM, and 4 300 mhz Intel
processors.
The best thing by far about our system is the Clarion drive cabinet that
handles all our drives.  The good news is I hear our cabinet is
compatible
with Sun hardware, so that might come right along with us.  I have done
a
bit of internet searching, and seen these Sun boxes priced under 20K.
My
question is this.  Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple
that
volume within two years?

Steve McClure



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  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: Seley, Linda
  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).

Managing dblinks/synonyms across DEV/QA/PROD db environments

[Molina, Gerardo]

Does anyone have a good URL, paper, book that talks about best practices
when it comes to use of db links, synonyms when you've got multiple db
environments such as dev/qa/prod?

For example, is it a no-no to create views with db links?

Is there an alternative?

Or do you create different views (each with different db links), and then
use a synonym to point to a particular view?  the synonym pointing to the
appropriate view, depending on the environment?

Can views be created with synonyms, for example?


TIA,
Gerardo


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Molina, Gerardo
  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: Possibly moving to Sun Equipment

[Peter . McLarty]

Steve

he 420R is an older sparcII server, very good for workgroups and development boxes, but with your transaction load, see if your budget will extend to a F3800 Sunfire. 
These run Solaris 8 only so if that is a problem as to the version of Oracle you have then try a 3500 or even a 4500, We are now quoting F3800's where we would have possible put a 4500,
The 3800 is a 2 to 8 way box with the new Sparc III CPU's


HTH

Peter McLarty                   E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.Mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461 
Brisbane,  Australia                Mobile: +61 (0)402 094 238           
--                    Facsimile: +61 (0)7 3303 3048






DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
30/11/2001 08:54 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        RE: Possibly moving to Sun Equipment


Steve - Is the 420R part of the new Sun Serengeti series? We had a test box
here and I recall the model number as being similar. If it is the same
thing, that box was a real screamer. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 29, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L


Sorry for the double posting.  I failed to include a subject line initially.
My first day back, and already a list faux paus.  Two I guess if you count
the double post.

Hello All,
It has been a while since I have been here, but I am back and properly s
ubscribed to the list again.  I am looking to draw from your experiences
here with hardware.  Our current database resides on a Data General Aviion
system with a Clarion drive cabinet.  While we are very pleased with the
system, and it's performance Data General is going the way of the Dinosaur,
so we need to look at other options.  The ones most currently floated have
been the Sparc 880 or the 420R either configured with dual gigahertz
processors.  The IT manager has a desk piled high with marketing
gobbledeegook, and has asked me if I know anything about either system.  All
I have been able to do is assure him that Solaris is essentially UNIX, and
tell him I would check with some knowledgeable folks here about the
hardware.  Our DG box sports a Gig of RAM, and 4 300 mhz Intel processors.
The best thing by far about our system is the Clarion drive cabinet that
handles all our drives.  The good news is I hear our cabinet is compatible
with Sun hardware, so that might come right along with us.  I have done a
bit of internet searching, and seen these Sun boxes priced under 20K.  My
question is this.  Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple that
volume within two years?

Steve McClure



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  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: DENNIS WILLIAMS
  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).




-- 
This transmission is for the intended addressee only and is confidential
information.  If you have received this transmission in error, please
delete it and notify the sender.  The contents of this e-mail are the
opinion of the writer only and are not endorsed by the Mincom Group
of companies unless expressly stated otherwise.

RE: Calling SQL*Plus and Run Procedure in UNIX script, How ?

[Kempf, Reed]

Robert,

Here is an example of logging into sql plus and running a stored procedure.
I pass 3 variables to my stored procedure.  This is alot more to my shell
script than this but this will hopefully get you what you want.  I pass $1,
$2, and $3 on the command line (separated by spaces) when I execute my
script.

#!/bin/ksh 
export ORACLE_SID=
export ORACLE_BASE=
export ORACLE_TERM=vt100
export ORACLE_HOME=
export PATH=$PATH:$ORACLE_HOME/bin

ID=$1
START_VAL=$2
END_VAL=$3

# Log into sqlplus and run the pl/sql procedure
sqlplus -s sitemon/sitemon > /dev/null 2>&1 << END
  set pagesize 0 echo off feedback off heading off verify off
  exec request_times(${ID},'${START_VAL}','${END_VAL}');
exit;

END

HTH

ReedK

-Original Message-
Sent: Thursday, November 29, 2001 3:30 PM
To: Multiple recipients of list ORACLE-L


In UNIX shell script: How does one invoke SQL*Plus, pass a shell variable
to run a stored procedure ?
i.e. if you have a UNIX variable $my_table (= dept)
how do you invoke sql*plus and pass $my_table to a procedure
which you'd otherwise manually run in sql*plus as

SQL> exec check_table('dept')

Thanks very much !
Robert Chin

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Chin
  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: Kempf, Reed
  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: Favor requested

[Mohan, Ross]

It loaded essentially immediately. 

I am on IE 5.5, high encryption, Raptor Firewall. 

I post to the list because it might be of some
value to others.

hth

-Original Message-

This is way off topic, but if several people could hit the following Web
page, it would really help me:

http://www.jcpenneyportraits.com

Does it load fast or stall with an hourglass on image downloads?



-- 
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: Possibly moving to Sun Equipment

[Steve McClure]

Well I have just returned from the Sun site, and checked out the two
systems.  The 420r is a rackmount server in the Enterprise Server series.
It uses Sparciii processors, up to 4 at 450mhz.  I don't' think I would
consider this configuration an upgrade.  I also doubt you'd classify this
one as a screamer.

The 880 is one of the Sunfire series of servers sporting a pair of 2 900mhz
64 bit UltraSparciii processors.  This one sounds much more exciting to me.

As I type this, I am informed that the powers that be are also looking at
some HP UX boxes.  Well either way we go I don't think it will be too
traumatic for me.  I am hoping for that Sun 880 now.



-Original Message-
Sent: Thursday, November 29, 2001 2:54 PM
To: Multiple recipients of list ORACLE-L

Steve - Is the 420R part of the new Sun Serengeti series? We had a test box
here and I recall the model number as being similar. If it is the same
thing, that box was a real screamer.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 29, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L


Sorry for the double posting.  I failed to include a subject line initially.
My first day back, and already a list faux paus.  Two I guess if you count
the double post.

Hello All,
It has been a while since I have been here, but I am back and properly s
ubscribed to the list again.  I am looking to draw from your experiences
here with hardware.  Our current database resides on a Data General Aviion
system with a Clarion drive cabinet.  While we are very pleased with the
system, and it's performance Data General is going the way of the Dinosaur,
so we need to look at other options.  The ones most currently floated have
been the Sparc 880 or the 420R either configured with dual gigahertz
processors.  The IT manager has a desk piled high with marketing
gobbledeegook, and has asked me if I know anything about either system.  All
I have been able to do is assure him that Solaris is essentially UNIX, and
tell him I would check with some knowledgeable folks here about the
hardware.  Our DG box sports a Gig of RAM, and 4 300 mhz Intel processors.
The best thing by far about our system is the Clarion drive cabinet that
handles all our drives.  The good news is I hear our cabinet is compatible
with Sun hardware, so that might come right along with us.  I have done a
bit of internet searching, and seen these Sun boxes priced under 20K.  My
question is this.  Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple that
volume within two years?

Steve McClure



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
  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: DENNIS WILLIAMS
  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: Steve McClure
  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).

MATERIALIZED VIEWS

[Harvinder Singh]

Hi,

We need to create the materialized view on query like:
select * from table1
union all
select * from table2
union all
select * from tabl3

we r getting error set operation not allows.
Is there any other way to create the materialized views based on union all
queries???

Thanks
-Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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: Duplicating a Database and Changig SID

[Ron Yount]

If you 
are using RMAN and would like some direction on how to change the DBID as well, 
let me know and I will send you some directions/steps for that as 
well.
 
-Ron-

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja SehovicSent: 
  Thursday, November 29, 2001 5:45 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Duplicating a Database and Changig 
  SID
  Hi!
   
  Before I tell 
  you procedure, be aware that when you make a clone of your database DBID 
  remains the same, which is a problem if you use RMAN for you 
  backups.
   
  Steps 
  are:
  0. On your 
  database issue: 
   alter 
  database backup controlfile to trace 
  resetlogs;
  1. Backup your 
  database.
  2. Shutdown database (shutdown 
  immediate)
  3. Copy all 
  your datafile, logfiles, controlfiles to the new location
  4. Edit your 
  new init.ora file and change DB_NAME, DB_BLOCK_SIZE must be the same, 
  
      
  change path for controlfiles, user_dump_dest, background_dump_dest, 
  core_dump_dest
  5. Edit  
  your new controlfile (which you get in step 0) and change it 
  in:
      CREATE 
  CONTROLFILE REUSE SET DATABASE 'NEWSID' RESETLOGS 
      and change the path of datafiles 
  and logs
  6. Recreate you 
  control file.
  7. Change your 
  tnsnames.ora and sqlnet.ora files.
   
  This should do. 
  
  I had no 
  problems in doing that
   
  HTH,
      Sonja
   
  
-Original Message-From: MRaval 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 
2001 7:55 PMTo: Multiple recipients of list 
ORACLE-LSubject: Duplicating a Database and Changig 
SID
Hi 
Guys,
 
I 
am newbie oracle DBA and want to duplicate my  development database to 
Test database and want to change ORACLE_SID, Could anyone tell exact steps 
that I have to follow. My database is on SUN 5.6 and oracle 
8.1.6.
 
Thanks,

OT: Favor requested

[DENNIS WILLIAMS]

This is way off topic, but if several people could hit the following Web
page, it would really help me:

http://www.jcpenneyportraits.com

Does it load fast or stall with an hourglass on image downloads?

Don't reply to the group, but mail me your results
mailto:[EMAIL PROTECTED]

I am experiencing a weird problem that I think is firewall-related. I assume
most people on this list are behind a firewall. 

The bonus question is what type of firewall and browser you are using, if
you know.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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).

O/S upgrade

[Browett, Darren]

I recently upgraded one of my Tru64 Unix system from 4.0f to 5.1.

Can I run the 4.0f compiled 8.0.5 binaries under 5.1, or should they
re-compiled under 5.1.

Also can I copy a database from a 4.0f system to 5.1, or is this a
export/import situation. ?

Thanks

Darren


--
Darren Browett P.EngThis message
was transmitted
Data Administrator  using 100%
recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Browett, Darren
  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: Possibly moving to Sun Equipment

[DENNIS WILLIAMS]

Steve - Is the 420R part of the new Sun Serengeti series? We had a test box
here and I recall the model number as being similar. If it is the same
thing, that box was a real screamer. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 29, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L


Sorry for the double posting.  I failed to include a subject line initially.
My first day back, and already a list faux paus.  Two I guess if you count
the double post.

Hello All,
It has been a while since I have been here, but I am back and properly s
ubscribed to the list again.  I am looking to draw from your experiences
here with hardware.  Our current database resides on a Data General Aviion
system with a Clarion drive cabinet.  While we are very pleased with the
system, and it's performance Data General is going the way of the Dinosaur,
so we need to look at other options.  The ones most currently floated have
been the Sparc 880 or the 420R either configured with dual gigahertz
processors.  The IT manager has a desk piled high with marketing
gobbledeegook, and has asked me if I know anything about either system.  All
I have been able to do is assure him that Solaris is essentially UNIX, and
tell him I would check with some knowledgeable folks here about the
hardware.  Our DG box sports a Gig of RAM, and 4 300 mhz Intel processors.
The best thing by far about our system is the Clarion drive cabinet that
handles all our drives.  The good news is I hear our cabinet is compatible
with Sun hardware, so that might come right along with us.  I have done a
bit of internet searching, and seen these Sun boxes priced under 20K.  My
question is this.  Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple that
volume within two years?

Steve McClure



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  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: DENNIS WILLIAMS
  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: Snapshot Problems

[Scott Shafer]

Patch your database with the appropriate bug fix.

--S


Jeff Wiegard wrote:
> 
> Good Day.
> 
> I have a problem with recreating some snapshots. I would like to
> add to the current set of snapshots. They were created in the
> following manner:
> 
> create snapshot snap_test as select * from test@test_DB;
> 
> They are executed nightly in the following manner:
> 
> execute DBMS_SNAPSHOT.REFRESH('SCOTT.TEST','?');
> 
> However, when I try and create them, I get an ORA-01406 error, due
> to truncation of the varchar2(4000) . According to Oracle, this is a
> bug. Does someone know of a work-around?
> 
> Jeff

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  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: rman disk channel destination

[Deepak Thapliyal]

try this ..

RUN
{ 
  ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT
'/disk1/%d_backups/%U'; 
  ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT
'/disk2/%d_backups/%U'; 
  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT
'/disk3/%d_backups/%U';
  BACKUP DATABASE; 
} 


Deepak

PS: straight from the manual (based on search criteria
entered on google .. hehehe)


--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> This info isn't forthcoming on metalink or in the
> doco as far as I can tell.
> Can anyone tell me how to change the directory
> associated with the rman
> command 'allocate channel disk'?  Or at least figure
> out where it is, rather
> than hunt and peck?  
> 
> Is it fixed?  Boy that would really bite. 
> 
> Thanks
> 
> Lisa Koivu
> Oracle Database Monkey Mama
> Fairfield Resorts, Inc.
> 954-935-4117
> 
> 


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  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).

Calling SQL*Plus and Run Procedure in UNIX script, How ?

[Robert Chin]

In UNIX shell script: How does one invoke SQL*Plus, pass a shell variable
to run a stored procedure ?
i.e. if you have a UNIX variable $my_table (= dept)
how do you invoke sql*plus and pass $my_table to a procedure
which you'd otherwise manually run in sql*plus as

SQL> exec check_table('dept')

Thanks very much !
Robert Chin

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Chin
  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: rman disk channel destination

[Orr, Steve]

Hi Lisa,

You can put the full path after the backup format keyword. Check out the
"format" keyword section in the backup command. It's in the RMAN Command
Syntax section 10 in my 8.1.7 docs.

Steve Orr



-Original Message-
Sent: Thursday, November 29, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L


This info isn't forthcoming on metalink or in the doco as far as I can tell.
Can anyone tell me how to change the directory associated with the rman
command 'allocate channel disk'?  Or at least figure out where it is, rather
than hunt and peck?  
Is it fixed?  Boy that would really bite. 
Thanks 
Lisa Koivu 
Oracle Database Monkey Mama 
Fairfield Resorts, Inc. 
954-935-4117 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: rman disk channel destination

[DENNIS WILLIAMS]

Lisa - I am new to RMAN (just had the Oracle class), so bear with me, and
I'll take a shot. I don't quite understand your question. In the class
workbook, the following example appears:

RMAN> create script level0backup {
   2> allocate channel d1 type disk;
   3> backup incremental level 0
   4> format '/u01/db01/backup/df%s_%
   5> filesperset 5
   6> (database include current controlfile);
   7> release channel d1; }

If I understand your question, the answer is that the directory is specified
in a separate statement from the allocate channel statement. I hope this
helps or maybe will clarify your question so someone more experienced in
RMAN can answer your question.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

   
-Original Message-
Sent: Thursday, November 29, 2001 3:30 PM
To: Multiple recipients of list ORACLE-L


This info isn't forthcoming on metalink or in the doco as far as I can tell.
Can anyone tell me how to change the directory associated with the rman
command 'allocate channel disk'?  Or at least figure out where it is, rather
than hunt and peck?  
Is it fixed?  Boy that would really bite. 
Thanks 
Lisa Koivu 
Oracle Database Monkey Mama 
Fairfield Resorts, Inc. 
954-935-4117 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Standby Database

[Jared . Still]

Thanks for this Don.

You and Patrice ( Unix vs. NT thread ) have together justified
the time I spend on this list.

Jared




   
 
"Don Granaman" 
 

.com>cc:   
 
Sent by: Subject: Re: Standby Database 
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
11/29/01 12:05 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Quick question, long answer...

You are not only making sense, you have hit the primary issue with the
Oracle standby database directly on the head.  With DataGuard in 9i
(or 8i on HP-UX or Solaris only), you can *try* to retrieve redo log
files.  You could also do it manually - with any version.  In either
case, there are no guarantees.  If the primary site goes away in a
tornado, the redo logs and possibly one or more unfinished (w.r.t.
sent or archived) archive logs go with it - and the standby does not
have all the transactions.  The 9i marketing rhetoric says that this
is not an issue with 9i DataGuard since it allows synchronous logfile
writes to a remote site and some other enhancements.  I haven't tried
it yet, but I'm not drinking all their Kool-Aid.  I'm sure that even
Oracle9i didn't change the laws of physics (186,000 miles/second isn't
just a good idea - its the law!  And light doesn't travel in anything
vaguely resembling a straight line inside a fiber optic cable.).
Synchronous writes, especially of redo logs, to a geographically
remote standby have to be a significant performance hit on any
non-trivial primary.  Even locally, synchronous host-based writes
usually have a very significant performance impact.

There are options of geo-mirroring both the online redo logs and
archive logs with something like EMC SRDF to create a true "no loss"
standby database.  There is a white paper on it somewhere on EMC's
site and I've seen a more generic white paper / presentation on it
from Oracle (from Wei Hu or Ron Weiss probably).  I've designed
something like this with a long-haul multi-hop EMC implementation
(local synchronous SRDF with R2 in bunkered Symmetrix, BCV split in
bunkered Sym, adaptive copy of the BCV to remote standby).  It works
well, but doesn't look much like an automagically managed "normal"
standby database.  This required custom scripts - to enforce a delay,
manage recovery and such.  The idea is to synchronously mirror to a
"safe" location (in the EMC scenario, a bunkered Symmetrix a short
distance away) and then asynchronously/periodically update the more
remote standby system from there.  It is an expensive solution, but if
you truly can't afford any data loss there are no cheap ones.  This
one in particular has the added advantage that the "heavy lifting"
grunge work is done in the Symmetrix so there is no noticeable host
load on the primary.  Some other storage vendors - Hitachi, etc. -
have similar capability.  You could do it with host-based software
(e.g. Veritas) also, but then you have host load,
potential/probability of OS write performance degradation, and perhaps
some other issues (e.g. multi-hop capability?).

I don't even know what DoubleTake is.  However, local clustering is an
entirely different critter compared to a standby database.  It
provides a "standby instance" for fast failover in the event of a
system/instance failure, but doesn't provide any intrinsic media
protection or a disaster recovery solution.  A standby database is
typically a disaster recovery (DR) solution, but a poor high
availability (HA) solution - but, as Bill Clinton might say "that
depends on the meaning of '

RE: rman disk channel destination

[Sujatha Madan]

Title: rman disk channel destination



Hi,
 
Are 
you asking how to set the target directory for the backup 
images
 
If you 
are the script should go something like this:
 
..
allocate channel d1 type disk
backup
format 
'\u01\backups\controlfiles\cf%d_t%t_s%s_p%p'
(current controlfile);
...
 
Hope I 
answered ur question.
 
Regs,
Sujatha

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, 30 November 2001 
  8:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  rman disk channel destination
  This info isn't forthcoming on metalink or in the doco 
  as far as I can tell.  Can anyone tell me how to change the directory 
  associated with the rman command 'allocate channel disk'?  Or at least 
  figure out where it is, rather than hunt and peck?  
  Is it fixed?  Boy that would really bite. 
  
  Thanks 
  Lisa Koivu Oracle Database 
  Monkey Mama Fairfield Resorts, Inc. 
  954-935-4117 

RE: rman disk channel destination

[Jack C. Applewhite]

Title: rman disk channel destination



Lisa,
 
You 
specify the destination directory with the FORMAT keyword, by which you both 
format the backup piece files and specify their destination.
 
Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Thursday, November 29, 2001 3:30 PMTo: Multiple recipients of list 
  ORACLE-LSubject: rman disk channel destination
  This info isn't forthcoming on metalink or in the doco 
  as far as I can tell.  Can anyone tell me how to change the directory 
  associated with the rman command 'allocate channel disk'?  Or at least 
  figure out where it is, rather than hunt and peck?  
  Is it fixed?  Boy that would really bite. 
  
  Thanks 
  Lisa Koivu Oracle Database 
  Monkey Mama Fairfield Resorts, Inc. 
  954-935-4117 

Re: Re: ACM SIGMOD-papers of interest #1

[Jared . Still]

Try amazon.com

Jared



   
 
"Cyril 
 
Thankappan"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
   Subject: Re: Re: ACM SIGMOD-papers of 
interest #1  
Sent by:   
 
[EMAIL PROTECTED]   
 
   
 
   
 
11/27/01 04:05 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 





Hi!

 Where can I get a copy of
" Scaling Oracle 8i"
  please

 Cyril


On Tue, 27 Nov 2001 Jared Still wrote :
> On Monday 26 November 2001 19:15, Rachel Carmichael
> wrote:
> > > For those of you techheads that don't yet have a
> copy of 'Scaling
> > > Oracle
> > > 8i',
> > > it's full of architectural info that will help you
> understand this
> > > stuff.
> > >
> > > Good bedtime reading.  :)
> >
> > gotta get you a life Jared :)
> >
>
> Huh?  What's that?
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jared Still
>   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: Cyril  Thankappan
  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: 
  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: Oracle/UNIX vs. Oracle/NT

[Jared . Still]

Patrice,

This is great stuff,  thanks.




   

"Boivin, Patrice   

J"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]   cc:

mpo.gc.ca>  Subject: RE: Oracle/UNIX vs. Oracle/NT 

Sent by:   

[EMAIL PROTECTED]   

   

   

11/28/01 05:10 AM  

Please respond to  

ORACLE-L   

   

   





Here are my comments, speaking from personal experience as an Oracle DBA
for
3 years on Tru64 UNIX and NT databases.  I am also doubling as the NT
administrator now.  There is another Oracle DBA (more experienced than me),
and there are 3 UNIX system administrators.  10 NT servers (2 old OWS
3.0.1.1., 2 iAs 9i, 1 used to have 5 7.3.4.4. instances on it, one has 3
8.1.7. instances on it), with 5 Digital (sorry, Compaq) Tru64 UNIX servers,
with 1-3 instances on them).

This is my perception at this point.

Microsoft marketing is very strong.  Managers use Windows9x/ME, so they
think WindowsNT/2000 is easy too.  Heck they know little about computers
and
they can run MS Office and Outlook no problem, imagine what the techies
downstairs could do with the server OS from Microsoft!  Most managers don't
use computers - they need the latest laptops etc. for office status
purposes, but they don't use them for much more than running MS Office and
Outlook.  They read ComputerWorld and they see PC Magazine and PC World in
the pharmacies, that's about it.  They also notice that none of the UNIX
vendors ever advertise on TV (what's up with that?).  The people who decide
where to spend the money are not the people who have to work with the
systems.  In a good shop they would consult the people below, but often
they
end up deciding first and arguing (or delaying purchase indefinitely) if
the
techies down below question their decision).

Do they take into account replacing all their servers to keep NT/2000
running?  I imagine their existing machines can't run NT or Windows2000.

The point someone else made about training is a valid one, management may
be
thinking that training is not required at all for NT because it's a Windows
OS and the techies can do anything, or that MCSEs are a dime a dozen now so
staff costs will be lower.  Problem is, they will need more staff to keep
the NT servers going than for an equivalent number of UNIX machines - once
a
UNIX box runs, it runs reliably.

UNIX machines are not affected by the likes of NIMDA, BackOrifice and other
tools out there.  Most hackers don't have grudges against UNIX systems, but
they certainly do against Microsoft. Have you updated your virus files
lately?  If using McAfee, is your engine up to date?  Have you checked your
Event Viewer security log?  Has auditing even been enabled on your system?
You realize that auditing is shut off by default on NT.  (also not taught
in
the NT4 MCSE classes).  Anyone with a copy of a server's ERD can crack the
passwords of all the user accounts that server has seen since the OS was
installed.  If someone gets the ERD from your BDC or PDC, you are royally
screwed.  How many ERDs are lying around in your computer room?  Do
contractors / term / casual employees ever go in there, and do any of them
have any reason to be unhappy with the way your company is treating them?
If one ERD is missing, how long will it take for anyone to notice?  The
attitude that "NT is just Windows" doesn't help security at all, the OS has
to be taken seriously.  If your machines have to be secure, get ready to
spend time doing it.  More time than if it was a UNIX host.

Web servers should use something other than IIS, IIS is popular because...
it's f

RE: guess I'm presenting at OOW

[Jared . Still]

Kirti,

FedEx a few of the review forms to me, and I'll fill them
out as an absentee.  :)

Jared



   
  
"Deshpande, Kirti" 
  

rizon.com>cc:  
  
Sent by:  Subject: RE: guess I'm presenting at 
OOW   
[EMAIL PROTECTED]   
  
   
  
   
  
11/28/01 06:55 AM  
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Rachel,
Don't worry, if you want, I will bring Don's book with me... Tuning with
Statspack (I think that's what it's called).
And btw, I liked Conner's idea very much.. just keep it a Q&A session after
those opening remarks. I will write up a good review for you..

- Kirti

-Original Message-
Sent: Wednesday, November 28, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L


and as long as Gaja or Kirti are in the room, it's cool :)


--- Connor McDonald <[EMAIL PROTECTED]> wrote:
> You just open up with:
>
> "This is statspack.  You install it with spcreate,
> collect stats with a pl/sql call, and report with
> spreport.sql.  Then you interpret the myriad the
> results - but of course, that is a tuning discussion
> not a statspack one...Questions anyone?"
>
> :-)
>
>  --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > This is a cross post folks...
> >
> > so...unfortunately, Susan McClain will not be able
> > to attend OOW, and
> > it now seems I AM presenting (where the heck did I
> > put that skirt?)...
> > I will be giving her presentation for her Statspack
> > on Monday (I think
> > at 11)
> >
> > Be kind folks, I haven't even SEEN the paper or
> > presentation yet, and I
> > haven't really worked with statspack much.
> >
> > This means it will be a short presentation :)
> >
> > I think they call this a "challenge".
> >
> > Rachel
> >
> > __
> > Do You Yahoo!?
> > Yahoo! GeoCities - quick and easy web site hosting,
> > just $8.95/month.
> > http://geocities.yahoo.com/ps/info1
> > --
> > 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).
>
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"
>
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page from News and Sport to
> Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   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: Crontabs and Oracle

[DENNIS WILLIAMS]

Kevin
One thing you mentioned concerned me, the "CSH and not for KSH". I
assume you are referring to Unix C shell and Korn shell script languages. I
don't know if this is your problem, but I  wanted to make the following
points:
1. The #! /bin/ksh mentioned earlier will make sure the script is running in
Korn shell, rather than whatever it inherits from the parent.
2. C shell and Korn shell are unfortunately very similar but differ in
insidious ways. I recently spent an uncomfortable Sunday evening debugging a
script and the error hinged on a subtle difference. It wasn't even my
script! Arrg!
3. I would avoid using C shell scripts. Borne shell was the original
scripting language, and C shell was developed to add better interactive
features. Then Korn shell was created, which is basically Borne shell with
those interactive features.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Thursday, November 29, 2001 3:00 AM
To: Multiple recipients of list ORACLE-L


Thanks David, and everyone else for all your help.

Unfortunately, I've done all this, specifying the variables etc and it still
doesn't appear to like it much! I don't know whether it's because it's
written in the CSH and not for KSH...I'll keep looking.

Thanks again,
Kev.

"Some mornings it just doesn't seem worth it to gnaw through the
leather straps."
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com






-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 21:21
To: Multiple recipients of list ORACLE-L



Thomas,

I got called to task before on this, but I didn't save the note, so whoever
corrected me, please do so again.  In any case, cron jobs in UNIX are (and
this is where I was corrected - although what follows should solve your
problem) executed by root.  This is why Mike suggested running the .profile
to properly set up the environment to find and execute sqlplus.  The user
who "owns" the cron job is invoked by root without all the proper
environmental variables set.  As an alternative you can explicitly set your
variables at the beginning of the shell script as follows (for ksh):

#!/bin/ksh

export ORACLE_SID=ifas
export ORACLE_HOME=/u001/app/oracle/product/8.1.7
export PATH=$PATH:/u001/app/oracle/product/8.1.7/bin
export ORACLE_BASE=/u001/app/oracle
export HOME=$ORACLE_HOME
cd $HOME

Hope this helps.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


 

"Thomas, Kevin"

  
anais.com>  cc:

Sent by:Subject: Crontabs and Oracle

[EMAIL PROTECTED]

 

 

11/28/2001 05:00

AM

Please respond to

ORACLE-L

 

 





Guys,

I have a Unix shell script that runs and does some things with sqlplus. The
script runs fine when I start it up manually just using the command

$ host_startup.sh

However, If I try to start this host_startup.sh from the Crontab I get this
error logged in my mail.

>From apt2 Wed Nov 28 08:15:01 2001
Date: Wed, 28 Nov 2001 08:15:01 GMT
Message-Id: <[EMAIL PROTECTED]>
To: apt2
Content-Length: 143

Your "cron" job on phys-ki-sun4k2
/ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh

produced the following output:

sqlplus: Command not found


Any ideas? I've specifically said in the shell script where to find the
sqlplus binaries, so I'm not sure?! Any help would be much appreciated.

Cheers,
Kev.

"I put instant coffee in a microwave oven and almost went back in time. "
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com




-Original Message-
Sent: 21 November 2001 12:20
To: Multiple recipients of list ORACLE-L



Have a look at Categoric Xalerts.

It is a general purpose Alerting system, not just for DBA and SYSADMs.

Their new Java based system is just out.

www.categoric.com

Steve Parker
Technical Consultant
LIS

 --
Logistics & Internet Systems Ltd.
E Mail: [EMAIL PROTECTED]
 --





Kumanan Balasundaram


[EMAIL PROTECTED]> cc:

Sent by:   Subject: Reliable
alerting system that is not so costly??
[EMAIL PROTECTED]





21/11/2001 11:50

Please respond to

ORACLE-L









Hi  there,

Any of you using or have come across a reliable alert system that can also
escalate
to different persons based on criteria such as how important that system
is?

We are looking to invest in such a software.

Kumanan Bal

RE: RE: RE: Siebel.

[Mohan, Ross]

Dick, 

question for yaif you "owned" Siebel, lock, stock and barrel,
what would you do?

1) Fix and switch ALL RI to the database ( oracle and ms and ibm and others)
2) Just fix it where it is broken, but leave it in the app itself
3) leave it out but publish a tech spec document telling users/DBAs how
and where to implement RI constraints.
4) something else. 

I am curious how you would solve Tom Siebel's problem of shipping an app
across, say, four or five major different dbms platforms while
simultaneously
keeping bugs, development costs , requiring consulting and document costs
down, 
and upgrade schedules and bug fixes in place. 

In other words...if you were "god" how would you fix this problem you see?

curious, 

Ross

-Original Message-
Sent: Thursday, November 29, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


Dennis,

You ought to be a sales droid!  That was a perfectly worded reply and in
MANY instances I'll agree with you.  The ease or of lack thereof in
administering an application is very often decided on by damagement by
whether
or not they need a dedicated/specialized resource to handle it.  Therefore
sales
droids will constantly downplay that requirement, until the check is in
hand. 
Actually sales droids downplay a lot of requirements for their software
until
the deal is in the bank.  Then they drop the bomb.  And then people like us
are
left to clean up.

Dick Goulet

-- 
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: ORA-12701 on Oracle 9i

[Charlie Mengler]

I had this EXACT problem yesterday when I was trying to build a new 9i DB.
My solution was to blow away all files associated with the new DB and to
build it again. I got the build to succeed by changing a line in init.ora
#remote_login_passwordfile=EXCLUSIVE
remote_login_passwordfile=NONE
 
HTH & YMMV!

> Yuval Arnon wrote:
> 
> Dear dba list,
> I have a test  9.0.1 database that was working fine. After being down for while (no 
>time to play with it) I tried to start in and
> I am getting the following errors.
> 
> Metalink does not help.
> Machine is Sun 420 OS 5.7,
> 
> SQL> conn sys/manager as sysdba
> Connected to an idle instance.
> SQL> startup pfile=inittest9i.ora
> ORACLE instance started.
> 
> Total System Global Area  235701300 bytes
> Fixed Size   279604 bytes
> Variable Size 167772160 bytes
> Database Buffers   67108864 bytes
> Redo Buffers 540672 bytes
> Database mounted.
> ORA-01092: ORACLE instance terminated. Disconnection forced
> 
> and when lookinig in the Oracle alert file.
> 
> ORA-12701: CREATE DATABASE character set is not known
> Error 12701 happened during db open, shutting down database
> USER: terminating instance due to error 12701
> Instance terminated by USER, pid = 4066
> ORA-1092 signalled during: ALTER DATABASE OPEN...
> 
> Thanks
> 
> Yuval.

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
In life, sometimes you're the windshield; other times you're the bug!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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:RE: RE: Siebel.

[dgoulet]

Dennis,

You ought to be a sales droid!  That was a perfectly worded reply and in
MANY instances I'll agree with you.  The ease or of lack thereof in
administering an application is very often decided on by damagement by whether
or not they need a dedicated/specialized resource to handle it.  Therefore sales
droids will constantly downplay that requirement, until the check is in hand. 
Actually sales droids downplay a lot of requirements for their software until
the deal is in the bank.  Then they drop the bomb.  And then people like us are
left to clean up.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   11/29/2001 12:55 PM

Henry - The issue isn't the major RDBMS vendors, although there can be
interesting variations among them when it comes to how RI is implemented.
Most successful ERP packages have been around for a number of years, so they
have had to be available on many platforms. On some of those platforms the
popular database alternative might not have RI. 
Another aspect from the vendor's point of view is being able to
create a package that will work at many, many sites and not require many
support calls, especially not require an experienced DBA. While in fact, as
you and I know, a serious package on Oracle should be supported by an
experienced DBA, when you are in a competitive sales situation, success is
spelled by "don't give the customer a reason not to buy our product." If the
customer doesn't have a DBA and they get the idea your package requires a
good DBA and your competitor is giving out hints that their package doesn't,
then the customer might just do something stupid and buy from your
competitor.
I'll give you an example of this. I don't know anything about Oracle
Applications (honest!). However, somebody told me that when it is installed,
no indexes are created. If true, that means that a DBA will need to figure
out the most common access paths for my site and create indexes. As an
ignorant purchaser, I could easily conclude that Oracle Applications were
difficult to administer.
I fully realize that from the point of view of the experienced DBA
there are a lot of reasons why life would be better if the idiot vendor
would implement RI, or many other things. I am just saying that the picture
looks different from the vendor's point of view, and the minuses probably
outweigh the plusses, and certainly for an existing product it must be
weighed against other development priorities. And if you decide to add it,
then you must figure a way to allow all existing customers to upgrade
without causing them a lot of problems and generating a lot of complaints.
Oh well, that is probably more than you wanted to know.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 29, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


Just curious, but which of the major RDBMSs don't have RI?

Henry

-Original Message-
Sent: Thursday, November 29, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


Another factor is that when RI was first introduced, people tended to
overuse it and then performance was bad. I don't think this is such a
problem today, but I think many ERP packages were either developed before RI
was common to all SQL databases, or were discouraged by the initial
problems. But I agree that the main factor has been that they try to be
compatible with all databases and the easiest way is to maintain their own
data dictionary and not implement RI in the database. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Henry Poras
  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 t

Possibly moving to Sun Equipment

[Steve McClure]

Sorry for the double posting.  I failed to include a subject line initially.
My first day back, and already a list faux paus.  Two I guess if you count
the double post.

Hello All,
It has been a while since I have been here, but I am back and properly s
ubscribed to the list again.  I am looking to draw from your experiences
here with hardware.  Our current database resides on a Data General Aviion
system with a Clarion drive cabinet.  While we are very pleased with the
system, and it's performance Data General is going the way of the Dinosaur,
so we need to look at other options.  The ones most currently floated have
been the Sparc 880 or the 420R either configured with dual gigahertz
processors.  The IT manager has a desk piled high with marketing
gobbledeegook, and has asked me if I know anything about either system.  All
I have been able to do is assure him that Solaris is essentially UNIX, and
tell him I would check with some knowledgeable folks here about the
hardware.  Our DG box sports a Gig of RAM, and 4 300 mhz Intel processors.
The best thing by far about our system is the Clarion drive cabinet that
handles all our drives.  The good news is I hear our cabinet is compatible
with Sun hardware, so that might come right along with us.  I have done a
bit of internet searching, and seen these Sun boxes priced under 20K.  My
question is this.  Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple that
volume within two years?

Steve McClure



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  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).

rman disk channel destination

[Koivu, Lisa]

Title: rman disk channel destination





This info isn't forthcoming on metalink or in the doco as far as I can tell.  Can anyone tell me how to change the directory associated with the rman command 'allocate channel disk'?  Or at least figure out where it is, rather than hunt and peck?  

Is it fixed?  Boy that would really bite. 


Thanks


Lisa Koivu
Oracle Database Monkey Mama
Fairfield Resorts, Inc.
954-935-4117

RE: RE: Siebel.

[Henry Poras]

Dennis, 
Maybe I'm naive, or I'm giving too much credit to those making the purchase,
but I feel that for applications the size and cost of most ERPs you could
market them using features such as stability and data integrity along with
the bells and whistles. A cleaner schema would also make it easier for
companies to integrate the product into their other apps, saving $$. Maybe
radical steps don't go with sales and marketing. 

Henry

-Original Message-
Sent: Thursday, November 29, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L


Henry - The issue isn't the major RDBMS vendors, although there can be
interesting variations among them when it comes to how RI is implemented.
Most successful ERP packages have been around for a number of years, so they
have had to be available on many platforms. On some of those platforms the
popular database alternative might not have RI. 
Another aspect from the vendor's point of view is being able to
create a package that will work at many, many sites and not require many
support calls, especially not require an experienced DBA. While in fact, as
you and I know, a serious package on Oracle should be supported by an
experienced DBA, when you are in a competitive sales situation, success is
spelled by "don't give the customer a reason not to buy our product." If the
customer doesn't have a DBA and they get the idea your package requires a
good DBA and your competitor is giving out hints that their package doesn't,
then the customer might just do something stupid and buy from your
competitor.
I'll give you an example of this. I don't know anything about Oracle
Applications (honest!). However, somebody told me that when it is installed,
no indexes are created. If true, that means that a DBA will need to figure
out the most common access paths for my site and create indexes. As an
ignorant purchaser, I could easily conclude that Oracle Applications were
difficult to administer.
I fully realize that from the point of view of the experienced DBA
there are a lot of reasons why life would be better if the idiot vendor
would implement RI, or many other things. I am just saying that the picture
looks different from the vendor's point of view, and the minuses probably
outweigh the plusses, and certainly for an existing product it must be
weighed against other development priorities. And if you decide to add it,
then you must figure a way to allow all existing customers to upgrade
without causing them a lot of problems and generating a lot of complaints.
Oh well, that is probably more than you wanted to know.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 29, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


Just curious, but which of the major RDBMSs don't have RI?

Henry

-Original Message-
Sent: Thursday, November 29, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


Another factor is that when RI was first introduced, people tended to
overuse it and then performance was bad. I don't think this is such a
problem today, but I think many ERP packages were either developed before RI
was common to all SQL databases, or were discouraged by the initial
problems. But I agree that the main factor has been that they try to be
compatible with all databases and the easiest way is to maintain their own
data dictionary and not implement RI in the database. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Henry Poras
  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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538

RE: RE: Siebel.

[Weaver, Walt]

Damn. I've been wracking my brain all day trying to figure out how to say
this.

Thanks, Dennis.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Thursday, November 29, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L


Henry - The issue isn't the major RDBMS vendors, although there can be
interesting variations among them when it comes to how RI is implemented.
Most successful ERP packages have been around for a number of years, so they
have had to be available on many platforms. On some of those platforms the
popular database alternative might not have RI. 
Another aspect from the vendor's point of view is being able to
create a package that will work at many, many sites and not require many
support calls, especially not require an experienced DBA. While in fact, as
you and I know, a serious package on Oracle should be supported by an
experienced DBA, when you are in a competitive sales situation, success is
spelled by "don't give the customer a reason not to buy our product." If the
customer doesn't have a DBA and they get the idea your package requires a
good DBA and your competitor is giving out hints that their package doesn't,
then the customer might just do something stupid and buy from your
competitor.
I'll give you an example of this. I don't know anything about Oracle
Applications (honest!). However, somebody told me that when it is installed,
no indexes are created. If true, that means that a DBA will need to figure
out the most common access paths for my site and create indexes. As an
ignorant purchaser, I could easily conclude that Oracle Applications were
difficult to administer.
I fully realize that from the point of view of the experienced DBA
there are a lot of reasons why life would be better if the idiot vendor
would implement RI, or many other things. I am just saying that the picture
looks different from the vendor's point of view, and the minuses probably
outweigh the plusses, and certainly for an existing product it must be
weighed against other development priorities. And if you decide to add it,
then you must figure a way to allow all existing customers to upgrade
without causing them a lot of problems and generating a lot of complaints.
Oh well, that is probably more than you wanted to know.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 29, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


Just curious, but which of the major RDBMSs don't have RI?

Henry

-Original Message-
Sent: Thursday, November 29, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


Another factor is that when RI was first introduced, people tended to
overuse it and then performance was bad. I don't think this is such a
problem today, but I think many ERP packages were either developed before RI
was common to all SQL databases, or were discouraged by the initial
problems. But I agree that the main factor has been that they try to be
compatible with all databases and the easiest way is to maintain their own
data dictionary and not implement RI in the database. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Henry Poras
  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: DENNIS WILLIAMS
  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 li

Major 11i issue question?

[Peterson, John/COR]

HI,
The 11.5.5 Oracle 11i database has a problem exporting from one server and
being able to import into a database on a different vendor's server.
Example Sun to Compaq.
Is anyone on this list working on the problem(similar post to oaugnet-dba
list).
It looks like the new stuff, object types of java class, java resource are
not
being imported, this is 8.1.7.1 of the database.  Roughly 3500 objects donot
wind up in the imported database, this is out of about 126,000.

We have an open tar with OWS, making slow progress, issue has been open
since 11.5.1.
Looks like the export may be working, but the import seems to be broken.

Any help, or common experiences would be wonderful to hear about.
Thanks,
-john
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peterson, John/COR
  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).

ORA-12701 on Oracle 9i

[Yuval Arnon]

Title: ORA-12701 on Oracle 9i





Dear dba list,
I have a test  9.0.1 database that was working fine. After being down for while (no time to play with it) I tried to start in and I am getting the following errors.

Metalink does not help.
Machine is Sun 420 OS 5.7,


SQL> conn sys/manager as sysdba
Connected to an idle instance.
SQL> startup pfile=inittest9i.ora
ORACLE instance started.


Total System Global Area  235701300 bytes
Fixed Size   279604 bytes
Variable Size 167772160 bytes
Database Buffers   67108864 bytes
Redo Buffers 540672 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced


and when lookinig in the Oracle alert file.


ORA-12701: CREATE DATABASE character set is not known
Error 12701 happened during db open, shutting down database
USER: terminating instance due to error 12701
Instance terminated by USER, pid = 4066
ORA-1092 signalled during: ALTER DATABASE OPEN...


Thanks


Yuval.

Re[2]: OpenWorld dispatches

[Jonathan Gennick]

Hello Jared,

I'll (hopefully) remember to post reminders to the list. The
URL for our dispatch page will be the same all week:

http://oracle.oreilly.com/news/openworld_dispatch_1101.html

On this page will be a link to each day's individual
dispatch.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

Thursday, November 29, 2001, 2:00:29 PM, you wrote:
JSrc> Thanks Jonathan.

JSrc> Feel free to post those to this list as well if you like.

JSrc> Or maybe even better,a daily reminder to the list
JSrc> that you have a new dispatch available and the URL?

JSrc> Thanks,

JSrc> Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  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).

[no subject]

[Steve McClure]

Hello All,
It has been a while since I have been here, but I am back and properly s
ubscribed to the list again.  I am looking to draw from your experiences
here with hardware.  Our current database resides on a Data General Aviion
system with a Clarion drive cabinet.  While we are very pleased with the
system, and it's performance Data General is going the way of the Dinosaur,
so we need to look at other options.  The ones most currently floated have
been the Sparc 880 or the 420R either configured with dual gigahertz
processors.  The IT manager has a desk piled high with marketing
gobbledeegook, and has asked me if I know anything about either system.  All
I have been able to do is assure him that Solaris is essentially UNIX, and
tell him I would check with some knowledgeable folks here about the
hardware.  Our DG box sports a Gig of RAM, and 4 300 mhz Intel processors.
The best thing by far about our system is the Clarion drive cabinet that
handles all our drives.  The good news is I hear our cabinet is compatible
with Sun hardware, so that might come right along with us.  I have done a
bit of internet searching, and seen these Sun boxes priced under 20K.  My
question is this.  Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple that
volume within two years?

Steve McClure


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  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: Errors running catdbsyn.sql

[Stephane Faroult]

Ken Janusz wrote:
> 
> When I run catdbsyn.sql I get these errors
> 
> drop synonym DBA_CATALOG
> ORA-01434: private synonym to be dropped does not exist
> 
> create synonym DBA_CATALOG for SYS.DBA_CATALOG
> ORA-01471: cannot create a synonym with same name as object
> 
> Why is this and what can I do about it?
> 
> Thanks,
> 
> Ken

01434 : Ignore
01471 : You should run it as SYSTEM, not as SYS or INTERNAL, contrarily
to the catalog (while you are logged as SYSTEM, run
$ORACLE_HOME/sqlplus/admin/pupbld.sql as well).

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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: RE: Siebel.

[DENNIS WILLIAMS]

Henry - The issue isn't the major RDBMS vendors, although there can be
interesting variations among them when it comes to how RI is implemented.
Most successful ERP packages have been around for a number of years, so they
have had to be available on many platforms. On some of those platforms the
popular database alternative might not have RI. 
Another aspect from the vendor's point of view is being able to
create a package that will work at many, many sites and not require many
support calls, especially not require an experienced DBA. While in fact, as
you and I know, a serious package on Oracle should be supported by an
experienced DBA, when you are in a competitive sales situation, success is
spelled by "don't give the customer a reason not to buy our product." If the
customer doesn't have a DBA and they get the idea your package requires a
good DBA and your competitor is giving out hints that their package doesn't,
then the customer might just do something stupid and buy from your
competitor.
I'll give you an example of this. I don't know anything about Oracle
Applications (honest!). However, somebody told me that when it is installed,
no indexes are created. If true, that means that a DBA will need to figure
out the most common access paths for my site and create indexes. As an
ignorant purchaser, I could easily conclude that Oracle Applications were
difficult to administer.
I fully realize that from the point of view of the experienced DBA
there are a lot of reasons why life would be better if the idiot vendor
would implement RI, or many other things. I am just saying that the picture
looks different from the vendor's point of view, and the minuses probably
outweigh the plusses, and certainly for an existing product it must be
weighed against other development priorities. And if you decide to add it,
then you must figure a way to allow all existing customers to upgrade
without causing them a lot of problems and generating a lot of complaints.
Oh well, that is probably more than you wanted to know.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 29, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


Just curious, but which of the major RDBMSs don't have RI?

Henry

-Original Message-
Sent: Thursday, November 29, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


Another factor is that when RI was first introduced, people tended to
overuse it and then performance was bad. I don't think this is such a
problem today, but I think many ERP packages were either developed before RI
was common to all SQL databases, or were discouraged by the initial
problems. But I agree that the main factor has been that they try to be
compatible with all databases and the easiest way is to maintain their own
data dictionary and not implement RI in the database. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Henry Poras
  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: DENNIS WILLIAMS
  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: Determinants of control file

[K Gopalakrishnan]

Title: Determinants of control file









Other than
dumping/ tracing the control file, you can find the required details in the

dynamic view
V$controlfile_record_section. This view has all the information you want

 

 

Best Regards,

K Gopalakrishnan

 

 

-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy,
Shrinivas (MED, Keane)
Sent: Thursday, November 29, 2001
3:21 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Determinants of
control file

 

Hi Nirmal,

 

   Use 

 

alter
database backup controlfile to trace;

    

    You
can find these details in the trace file, that will be dumped to your udump
destination.

 

HTH

Srinivas.

 

   

-Original
Message-
From: Nirmal Kumar Muthu Kumaran
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001
7:52 AM
To: Multiple recipients of list
ORACLE-L
Subject: Determinants of control
file

Hi all, 

The determinants(size)
of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., 

But after creation of
control files, where should i get details about these parameter values?... 

i checked in
v$controlfile and v$database... i didn't get enough info on it. 

And i found
controlfile_sequence# column i found in v$database view. I multiplexed the
control files. 
Where will i get the sequence# of other control
files then... 

Nirmal, 

Errors running catdbsyn.sql

[Ken Janusz]

When I run catdbsyn.sql I get these errors


drop synonym DBA_CATALOG
ORA-01434: private synonym to be dropped does not exist

create synonym DBA_CATALOG for SYS.DBA_CATALOG
ORA-01471: cannot create a synonym with same name as object

Why is this and what can I do about it?

Thanks,

Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  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: PATCH confirmation

[Dennis M. Heisler]

yes

Seema Singh wrote:
> 
> Hi
> I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0 right?
> thanks
> seema
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis M. Heisler
  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).

changing password of default users

[Jeffrey Beckstrom]

Due to a security problem, we are looking into changing the passwords for 
several default users: ORDSYS ORDPLUGINS MDSYS CTXSYS I 
seem to recall that if the password for these users was changed, some sql file 
was to be changed as well so that future runs of "catalog", etc would not have a 
problem. I am now unable to find such a document. Anyone know what I am talking 
about.  Can I simply change the passwords??
 
 
 
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204

Re: GRANT REFERENCES

[Ekan Emokpae]

Thanks for your reply Paul.

Would you be kind enough to elaborate on the 3rd point.  I thought I
followed but what I implemented gave me this error
ORA-02021: DDL operations are not allowed on a remote database.

Any pointers would be most appreciated.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 10:00 AM


> I haven't done it with the REFERENCES privilige but with others the
> following will work:
>
> 1. create the same user account with the same password in the other
> database.
> 2. grant the appropriate permissions to that user.
> 3. refer to the table with @servicename or create a synonym with the
> @servicename notation. When the user refers to the object the
> username/password from the current instance will be passed to the other
> instance.
>
> -Original Message-
> Sent: Thursday, November 29, 2001 8:50 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
>
> I am trying to GRANT REFERENCES on a table that resides on a different
> database, on a different server. Is this possible and how do I go about
> doing it.
>
> TIA
> E.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Troiano, Paul (CAP, GEFA)
>   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: Ekan Emokpae
  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).

PATCH confirmation

[Seema Singh]

Hi
I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0 right?
thanks
seema

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: Solaris

[Orr, Steve]

Title: OT: Solaris



I like 
the "UNIX System Administration Handbook" from Prentice Hall because it 
highlights *NIX command and directory variations.

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 
  11:49 AMTo: Multiple recipients of list ORACLE-LSubject: 
  OT: Solaris
  I apologize if this is a duplicate. 
  I may be thrown into solaris system administration 
  .  Can anyone recommend any good books, websites, etc. 
  for a beginner?  I consider myself unix savvy but not an expert and am 
  not adverse to starting at square one, especially since my employer will pay 
  for any book I want.  Going to training isn't an option, however.  
  
  Any suggestions would be greatly appreciated. 

  Thank you very much 
  Lisa Koivu Oracle Database 
  Monkey Mama Fairfield Resorts, Inc. 
  954-935-4117 

Re: backup unix script

[Deepak Thapliyal]

Hi grace 

it basically means that log in to sql*plus and execute
whatever is below this line till you hit bang(!) ..
literally. 

Deepak

--- grace <[EMAIL PROTECTED]> wrote:
> hi gurus,
> 
> I found this unix script ... can any tell me what
> this means?
> sqlplus - sys/msd > filename.dat < does anyone have a unix script to perform a database
> backups?
> 
> Best Regards,
> Grace Lim
> Suy Sing Comm'l Corp.
> (632)-2474134
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: grace
>   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! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  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: Question! ORA-12571

[Jared . Still]

Hien,

This could be a problem with your Network.  You need to talk to your
network admin about this.

It's also been a problem with Oracle at times, but in older versions.  When
we've
experienced this, it's been a bad piece of HW or misconfugured HW.

There's a lot on MetaLink, so check there.

Jared





   
 
"Hoang Duy 
 
Hien"To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
   Subject: Question! ORA-12571  
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
11/29/01 02:45 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi all,
I have been out of the Oracle loop for awhile now, and I think that's why I
ma having triuble with simply installing the server. No matter what I do,
after the installation
succeeds, I cannotcreate a new database. I always get the error ORA-12571:
TNS Packet Writer
Failure. I have tried looking into Net* problems, but have come up short.
COuld someone direct down the
right path or perhaps send an answer.

My OS: Windows 2000 Adv server, SP2.
My Oracle: 8.1.6 (8.1.7).

Thanks, Hien



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hoang Duy Hien
  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: 
  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: RMAN, Netbackup question

[Richard Ji]

That's what I thought but the class has Class Type of Oracle.
And under that class type the multiple data stream is greyed out.  So I shouldn't use
"oracle" as the class type then?

>>> [EMAIL PROTECTED] 11/29/01 01:49PM >>>
I think you need to configure your NetBackup "class" to handle multiple
streams.


-Original Message-
Sent: Thursday, November 29, 2001 11:23 AM
To: Multiple recipients of list ORACLE-L


Richard-I've seen ti done before.. But I can't remember the details.

I had a couple of guys on my team at a previous shop do it.

Greg

-Original Message-
Sent: Thursday, November 29, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I have a question regarding RMAN working with Netbackup.  Is it possible to
kick off multiple streams
to write to the tape?  I tried through RMAN to have 4 channels, but they are
queued at the Netbackup
Server.  I want them to go in parallel.  Now, it seems that for the Class
Type Oracle, it's won't allow 
multiple data sterams.  That option is greyed out.

Thanks

Richard Ji

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Richard Ji
  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: Loughmiller, Greg
  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: Orr, Steve
  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: Richard Ji
  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: Crontabs and Oracle

[Jared . Still]

Kevin,

Here's a trick to get all you need in a shell script for a cron job.

This is useful for situations such as yours where you just can't
seem to get the environment set correctly.

Run your job from the command line to make sure it works.  I
assume that you've already done this.

Now set your job up to run via  the 'at' command:

   at 22:30 -f myjob.sh

( syntax may not be exact :)

Now will be be given a job #

$  > at now + 1 hour
at> ls -l
at> 
commands will be executed using /bin/ksh
job 1007064577.a at Thu Nov 29 12:09:37 2001

Now I have job 1007064577 set in at.

On solaris you can get a copy of that job at

/var/spool/cron/atjobs/1007064577.a

Copy this file to a test shell script.  It will have your
entire environment in it, as well as everything else
to run the job.  You can edit it to get rid of stuff you're
sure you don't need.

I've seen a number of suggestions for sourcing .profile
in the cron jobs, but this is not always a good idea, as
.profile often contains script that will not execute when
not attached to a tty.

HTH

Jared

PS.  Don't forget to cancel the phony job via  'atrm'.



-- 
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: Off topic Perlesque question

[Jared . Still]

Ivan,

The best place to ask this question is on a Perl list of course, but I
understand
your quandary.

Why not do what many folks on this list do:  open a hotmail account
specifically
for your perl list subscriptions?  Then you don't fill up your mailbox.

It would also help to know which modules you are looking for.  Some are
available
from sources other than ActiveState.

Also, go to the General Support forum at www.activestate.com and search the
archives, you may find what you need.  You can also ( I think this is right
) locate
archives for other Perl lists at lists.perl.com.

HTH

Jared




   

[EMAIL PROTECTED]  

tate.fl.us  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
Sent by:cc:

[EMAIL PROTECTED]Subject: Off topic Perlesque question  

   

   

11/28/01 10:43 AM  

Please respond to  

ORACLE-L   

   

   





I know this is off topic but if I can get grab you perl guru's ear for
second I'd greatly appreciate it.  First I'd like to ask for a better place
to post these types of questions.  A perl list would be ideal but my boss
has explicitly said I can join no more lists - my mail box is getting too
big :(.


os (I know here's the fundamental problem) : Win2K
perl: ActiveState 5.6.1.630
Microsoft C++ Visual Studio 6.0


Ok now to the problem.  I am having trouble using cpan to install certain
modules/Bundles.
I have been able to use ppm to install most of the modules I need but there
are still 7-10 that I believe need to be done through the cpan interface.
The problem I am having with cpan is when it's ready to compile the code it
never works because of make problems.


I have tried to download nmake instead to see if that would work but to no
avail.  I am making the correct changes in the config.pm file where it says
make='blah blah'  but the command is always bombing out and thus if no make
test it will not continue the real make.  Has anyone else had this problem
or know how to fix it? What else can I do?


I believe that the problem is in the syntax that cpan is using to compile
things is not compatible with the windows version of make. The readme I
used suggested to download nmake and use that but again the syntax seems
different.


In the cpan error I see it doing:  make -f blah blah
but the windows make help command shows all arguments should be like '/A'
and I havent seen an argument for force.  Does anyone know of a make out
there for windows that behaves as unix in terms of syntax?


My ultimate goal is to get slashcode to run on this machine for a web site
but have to do it on a windows machine.  I am terribly lost and don't know
what to do next or where to look. Any advice would help thanks. Sorry for
being so lengthy and off topic I don't know where I can post this and still
be able to get a reply. Wish I could join an additional list.


Is there any file I can edit so that every time cpan calls for 'make -f' I
can substitute it with a syntax my nmake command will accept? Thank you
very much. Ivan







-- 
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: LAWSON NAS and SAN

[Jared . Still]

I will attempt to address one of your questions, the one regarding HD size.

The answer is it depends on the throughput and latency of the individual
drives.  Though you may have fewer spindles by using larger drives, they
are newer technology, likely faster, and you may actually see more
throughput
by using them.

For an excellent explanation of this, you should purchase a copy of
'Scaling Oracle 8i'.  I can't recommend this book highly enough.  The
info in it will tell you how to compare drives yourself.

Every DBA should have a copy, regardless of platform.

Jared




   
 
Mario Brenes   
 

e.com>   cc:   
 
Sent by: Subject: LAWSON  NAS and SAN  
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
11/28/01 03:55 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




I am evaluating a solution for LAWSON, and in the requirements I need a
server with at least 450 GIGs of hard drive, 3 GIGs of RAM, 8 Intel Based
Processors.

I am proposing to buy Compaq Servers, and 14 slots external units to
fulfill
these requirements, but I have some questions to see if someone can help
me??

1) Will my application suffer a lot if I decide to buy 72Gigs hard drivers
or should I buy 36Gigs hard drives.  My problem is that for future grow,
the
72 will allow me more data on my external 14 slots storage unit

2) Is someone using NAS Network Attached Storage Units?  How well do they
perform?  What about SAN Storage Attached Network units?

3) A company told me about this NAS that mirrors data changes over LAN or
WAN, they claim it is a great product and that in case of emergency
recovery, I will be able to recover in minutes??  Is it true??

Please Help.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mario Brenes
  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: 
  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: OpenWorld dispatches

[Jared . Still]

Thanks Jonathan.

Feel free to post those to this list as well if you like.

Or maybe even better,a daily reminder to the list
that you have a new dispatch available and the URL?

Thanks,

Jared




   
 
Jonathan   
 
Gennick  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
 Subject: OpenWorld dispatches 
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
11/28/01 07:10 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




I'll be attending OpenWorld this year, and, as in years
past, I'll be writing daily dispatches from the show. If
you're interested, you can read my preview dispatch at the
following URL:

  http://oracle.oreilly.com/news/openworld_preview_01.html

Best regards,

Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
  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: 
  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: RE: ORA-03113

[Koivu, Lisa]

Title: RE: RE: ORA-03113





Thanks Rao for correcting me.  Like I confessed earlier, I am unix savvy, not an expert :)



-Original Message-
From:   Rao, Maheswara [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 29, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: RE: ORA-03113


Lisa,
 
ps -fu oracleSID - command would not work.  The reason is when you -u option with ps, it looks for the user by name mentioned. In this case, there would not be any user by name oracleSID (most likely).  All the oracle processes would be owned by the user oracle.

 
Now,  the following modification for the command might work. I did not test this completely.
 
ps -fu oracle | grep -v SID | grep -v PPID | awk '{ print $2; }' | xargs kill -9
 
Rao


-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: ORA-03113




Yes, you are right.  If you have multiple instances change the command to something like this, assuming your sid name is SID

> ps -fu oracleSID|grep -v PPID|awk '{ print $2; }'|xargs kill -9 


Try it without the xargs kill -9 to verify it's choosing what you need.  Otherwise just kill smon, pmon and the database will come down.  I have done this many times and only once did I end up in a recovery.  

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117 



-Original Message-
From:   Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 29, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Subject:    Re: RE: ORA-03113 


If I'll apply this command it's will take all oracle processes down  for every instance in this box? 


Thanks. 




>>> [EMAIL PROTECTED] 11/29 10:35 AM >>>
Why don't you want to want to take all the oracle processes down?  I thought
that's what you wanted to accomplish with shutdown immediate? 


Go ahead and issue Mladen's command and restart the database.  It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus. 


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117 



> -Original Message-
> From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 29, 2001 10:05 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  ORA-03113
>
> Hi All!
> I tried shutdown immediate and get ORA-03113.
> Now I can't connect to database. How I can take instance down? On this HP
> box 10 different databases.
> This command was posted some time back by Mladen:
>
> ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9
> It's will take all oracle processes and listeners down
> which I don't want to do. I'm on  Oracle 8.1.6.
> Thanks.
> Greg.
>
> --
> Please see the official ORACLE-L FAQ: 
> --
> Author: Greg Faktor
>   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: 
--
Author: Greg Faktor
  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: Checking DB Status in NT env.

[Jared . Still]

> select 'PING' from dual;

How very clever Mark.  ;)

Jared




   
 
"Mark Leith"   
 

ls.co.uk>cc:   
 
Sent by: Subject: RE: Checking DB Status in NT 
env. 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
11/28/01 01:40 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




connect scott/tiger@sid

select 'PING' from dual;

If you receive an output from the database you can pretty much say it's up
and running don't you think? If you get an error anywhere along this path -
you have a problem..

Mark

-Original Message-
Sent: 27 November 2001 19:55
To: Multiple recipients of list ORACLE-L


Hi

Is there any easy way for our operator to check db status on NT env. any
clue?


Mitchell

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mitchell
  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: Mark Leith
  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: 
  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: RE: ORA-03113

[Ball, Terry]

Try doing:
ps -ef|grep pmon|grep 
It will look something like
  oracle 20065 1  0   Nov 11 ?0:07 ora_pmon_BI
Issue the kill against the PPID that is returned, in this case 20065.
The kill command would look like:
kill -9 20065

Terry

-Original Message-
Sent: Thursday, November 29, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L


If I'll apply this command it's will take all oracle processes down  for
every instance in this box?

Thanks.



>>> [EMAIL PROTECTED] 11/29 10:35 AM >>>
Why don't you want to want to take all the oracle processes down?  I thought
that's what you wanted to accomplish with shutdown immediate? 

Go ahead and issue Mladen's command and restart the database.  It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus. 

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117


> -Original Message-
> From: Greg Faktor [SMTP:[EMAIL PROTECTED]] 
> Sent: Thursday, November 29, 2001 10:05 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  ORA-03113
> 
> Hi All!
> I tried shutdown immediate and get ORA-03113.
> Now I can't connect to database. How I can take instance down? On this HP
> box 10 different databases. 
> This command was posted some time back by Mladen:
> 
> ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 
> It's will take all oracle processes and listeners down 
> which I don't want to do. I'm on  Oracle 8.1.6.
> Thanks.
> Greg.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Greg Faktor
>   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: Greg Faktor
  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: Ball, Terry
  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).

OT: Solaris

[Koivu, Lisa]

Title: OT: Solaris





I apologize if this is a duplicate. 


I may be thrown into solaris system administration .  Can anyone recommend any good books, websites, etc. for a beginner?  I consider myself unix savvy but not an expert and am not adverse to starting at square one, especially since my employer will pay for any book I want.  Going to training isn't an option, however.  

Any suggestions would be greatly appreciated. 


Thank you very much


Lisa Koivu
Oracle Database Monkey Mama
Fairfield Resorts, Inc.
954-935-4117

RE: enable the partitioning option in database?.

[Molina, Gerardo]

I should have mentioned that my comments were for UNIX platform.
 
I recommend calling Oracle Support to see if there are equivalent commands
for NT platform.
 
Gerardo

-Original Message-
Sent: Thursday, November 29, 2001 6:30 AM
To: Multiple recipients of list ORACLE-L



i didn't find the directory ORACLE_HOME\rdbms\lib itself... there is one
directory jlib, but in that there is no 'make' file

my system is ora817 on win nt. 

any help pls. 

-Original Message- 
Sent:   Wednesday, November 28, 2001 8:33 PM 
To: Multiple recipients of list ORACLE-L 

Assuming you have installed the Oracle Partitioning option, there
may be an 
extra step required to "enable" it, and that is to make sure you relink with

the correct option.  See the following excerpt taken from MetaLink: 

To enable the Partitioning Option you must relink the rdbms
executable. 

Ensure that the database is shut down and relink as follows: 

cd $ORACLE_HOME/rdbms/lib 

For 8.0.x: 

make -f ins_rdbms.mk part_off (to disable) 

make -f ins_rdbms.mk part_on (to enable) 

make -f ins_rdbms.mk ioracle 

For 8.1.x: 

make -f ins_rdbms.mk part_off ioracle (to disable) 

make -f ins_rdbms.mk part_on ioracle (to enable) 

HTH 

Gerardo 

-Original Message- 
Sent: Wednesday, November 28, 2001 5:55 AM 
To: Multiple recipients of list ORACLE-L 



hI GURUS' 

How can i enable the partitioning option in database?. 

Any idea? 

[EMAIL PROTECTED]> SELECT PARAMETER, VALUE FROM V$OPTION
WHERE 
VALUE='FALSE'; 

PARAMETER 
 
VALUE 
 
Partitioning 
FALSE 

Parallel Server 
FALSE 

Java 
FALSE 

Rgds, 
Nirmal. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Molina, Gerardo 
  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: Molina, Gerardo
  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: 9ias Vs IIS

[Boivin, Patrice J]

Try sans
Also do a search in google for isn news or for IIS hacking or IIS security,
I'm sure you will come up with something.
Yahoo, C|Net, Wired, Register also have articles on IIS, I am convinced.

You can also go to www.microsoft.com/security
  and do a graph showing how many patches
they released in the last three years for IIS 4 and IIS 5, and what it takes
to secure an NT server (there is a security checklist for NT servers, the
same thing probably exists for Windows2000 servers).  Once you secure your
web server, what happens when service packs have to be applied, admin time
to keep everything up-to-date, etc.

That is the clincher, the time it takes to administer NT in a secure
environment, they must take that into account when they do cost analyses.

Extract from this morning's SANS newsletter:

19 & 20 November 2001  Microsoft Apologizes, Admits it Knew of
Vulnerability
*   19 & 20 November 2001  Microsoft Apologizes, Admits it Knew of
Vulnerability
Microsoft apologized for "inaccurate" statements regarding an Internet
Explorer (IE) vulnerability disclosed by Online Solutions.  Initially,
Microsoft blasted Online Solutions for making the vulnerability
public on November 8, but then admitted that the security company
had notified them of the problem a week before.
http://news.cnet.com/news/0-1003-200-7920273.html?tag=prntfr
 
http://www.theregister.co.uk/content/55/22935.html
 


I used to subscribe to ISN News e-zine, I liked it a lot - after parsing
through the e-mails from that listserv you will be convinced it's not a fun
world out there.
Maybe after Sept 11th and additonal powers for CIA, FBI, NSA and other
agencies, hacking will go way down.  (?).
You might want to search the ISN News archives, there must be stuff in
there.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Sunny Verghese [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 29, 2001 12:04 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: 9ias Vs IIS

Thanks for you inputs.
I'd like some concrete data on Security issues with IIS. Do you know
of any 
sites for this ??? You know how it is, I can't just go to management
and 
tell them that it's not very secure, I need to prove it with data
(To make 
this all the more interesting I'm contracting with a state agency
right 
now... you can imagine the managers there... No offense to any
State 
"managers" in this group :-) !!!)

>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: 9ias Vs IIS
>Date: Wed, 28 Nov 2001 15:00:26 -0800
>
>I'm not a web expert either ... we're just starting to look at
web-enabling
>our forms.
>
>But one big potential drawback to using IIS would be security
issues.  It's
>the most-targeted and most-hacked server out there.  Someone will
need to 
>be
>applying patches constantly and hoping for the best.
>
>Ask the new guys when was the last time they had to deal with a
>security/hacker problem with your current 9iAS/Apache setup. :-)
Not that
>it can't be hacked ... but the hackers tend to focus on the easiest
target.
>
> > -Original Message-
> > From: Sunny Verghese [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 28, 2001 2:14 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: 9ias Vs IIS
> >
> >
> > Briefly, our current setup includes Web enabled forms (PL/SQL
> > Cartridges)
> > accessing an 8i database via 9ias (currently OAS 4.2 but will
> > be moving to
> > 9ias in a month). Btw, we also use ORACLE APPS (11i) using
> > the same Web
> > Server (apps and ias handled by another dba... thankfully :-)
..)
> >
> > For a new system (requirement : ability for customers to
> > upload files (xml,
> > fixed format text file or spreadsheet, or enter data via a
> > form. Need only
> > specific people to be able to upload these files. Files need to
be
> > transmitted and saved securely.. Digital signature ?.
> > These files could
> > be required later (Law suit)) that we are looking at, a
> > couple of new guys
> > (who believe that the Sun rises and sets because of Microsoft
> > ) are
> > proposing using IIS --> ASP --> OEMDB --> ORACLE database
> > (existint DB).
> > They also have a problem with IIS --> JSP --> JDBC --> ORACLE
   

RE: RE: ORA-03113

[Rao, Maheswara]

Title: RE: RE: ORA-03113



Lisa,
 
ps -fu 
oracleSID - command would not work.  The reason is when you -u option 
with ps, it looks for the user by name mentioned. In this case, there would not 
be any user by name oracleSID (most likely).  All the oracle processes 
would be owned by the user oracle.
 
Now,  the following modification for the command 
might work. I did not test this completely.
 
ps -fu 
oracle | grep -v SID | grep -v PPID | awk '{ print $2; }' | xargs kill 
-9
 
Rao

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 
  1:27 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: RE: ORA-03113
  Yes, you are right.  If you have 
  multiple instances change the command to something like this, assuming your 
  sid name is SID
  > ps -fu oracleSID|grep -v PPID|awk '{ print $2; 
  }'|xargs kill -9 
  Try it without the xargs kill -9 to verify 
  it's choosing what you need.  Otherwise just kill smon, pmon and the 
  database will come down.  I have done this many times and only once did I 
  end up in a recovery.  
  Lisa Koivu Oracle Database 
  Administrator Fairfield Resorts, Inc. 
  954-935-4117 
  
-Original Message- From:   Greg 
Faktor [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, 
November 29, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Subject:    Re: RE: ORA-03113 
If I'll apply this command it's will take all 
oracle processes down  for every instance in this box? 
Thanks. 
>>> [EMAIL PROTECTED] 11/29 
10:35 AM >>> Why don't you want 
to want to take all the oracle processes down?  I thought 
that's what you wanted to accomplish with 
shutdown immediate? 
Go ahead and issue Mladen's command and restart 
the database.  It's the only way you 
can bring it down if you can't connect with svrmgrl or sqlplus. 
Lisa Koivu Oracle Database Monkey Fairfield 
Resorts, Inc. 954-935-4117 

> -Original Message- > From: Greg Faktor [SMTP:[EMAIL PROTECTED]] 
> Sent: Thursday, November 29, 2001 
10:05 AM > To:   Multiple 
recipients of list ORACLE-L > 
Subject:  ORA-03113 > > Hi All! > I tried shutdown immediate and get ORA-03113. 
> Now I can't connect to database. How I can 
take instance down? On this HP > box 
10 different databases. > This command 
was posted some time back by Mladen: > 
> ps -fu oracle|grep -v PPID|awk '{ 
print $2; }'|xargs kill -9 > It's will 
take all oracle processes and listeners down > which I don't want to do. I'm on  Oracle 8.1.6. 
> Thanks. > Greg. > > -- > Please see 
the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Greg 
Faktor >   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: Greg Faktor 
  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: Listers meeting at OOW

[Orr, Steve]

OK I'll be there too but I'm not local anymore :-)  See Ya!

Loco in Montana,
Steve Orr


-Original Message-
Sent: Wednesday, November 28, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Are the locals driving down to SF from parts of the Bay Area? (methinks we
will have a major parking issue around that place, so carpooling would be a
good idea?) Do y'all want to meet within the Exhibitor area somewhere before
walking down? As for head count (so far):

1. Rachel Carmicael
2. Kirti Deshpande
3. Gerardo Molina
4. Jeremiah Wilton
5. John Kanagaraj
6. Greg Loughmiller (?)
7. Gaja Vaidyanatha (?)

John Kanagaraj
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: Email through trigger

[Ramon Estevez]

The package is UTL_SMTP

Ramon E. Estevez
[EMAIL PROTECTED]  
809-565-3121


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Aldi Barco
Enviado el: Thursday, 29 November, 2001 11:05 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Email through trigger


Hi Listers,

What is the oracle procedure / package to send an email through store 
procedure or trigger ?

Tia.
Aldi


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Aldi Barco
  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: Ramon Estevez
  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: RMAN, Netbackup question

[Orr, Steve]

I think you need to configure your NetBackup "class" to handle multiple
streams.


-Original Message-
Sent: Thursday, November 29, 2001 11:23 AM
To: Multiple recipients of list ORACLE-L


Richard-I've seen ti done before.. But I can't remember the details.

I had a couple of guys on my team at a previous shop do it.

Greg

-Original Message-
Sent: Thursday, November 29, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I have a question regarding RMAN working with Netbackup.  Is it possible to
kick off multiple streams
to write to the tape?  I tried through RMAN to have 4 channels, but they are
queued at the Netbackup
Server.  I want them to go in parallel.  Now, it seems that for the Class
Type Oracle, it's won't allow 
multiple data sterams.  That option is greyed out.

Thanks

Richard Ji

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Ji
  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: Loughmiller, Greg
  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: Orr, Steve
  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: RMAN, Netbackup question

[Loughmiller, Greg]

Richard-I've seen ti done before.. But I can't remember the details.

I had a couple of guys on my team at a previous shop do it.

Greg

-Original Message-
Sent: Thursday, November 29, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I have a question regarding RMAN working with Netbackup.  Is it possible to
kick off multiple streams
to write to the tape?  I tried through RMAN to have 4 channels, but they are
queued at the Netbackup
Server.  I want them to go in parallel.  Now, it seems that for the Class
Type Oracle, it's won't allow 
multiple data sterams.  That option is greyed out.

Thanks

Richard Ji

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Ji
  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: Loughmiller, Greg
  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: RE: ORA-03113

[Koivu, Lisa]

Title: RE: RE: ORA-03113





Yes, you are right.  If you have multiple instances change the command to something like this, assuming your sid name is SID

> ps -fu oracleSID|grep -v PPID|awk '{ print $2; }'|xargs kill -9 


Try it without the xargs kill -9 to verify it's choosing what you need.  Otherwise just kill smon, pmon and the database will come down.  I have done this many times and only once did I end up in a recovery.  

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From:   Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 29, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Subject:    Re: RE: ORA-03113


If I'll apply this command it's will take all oracle processes down  for every instance in this box?


Thanks.




>>> [EMAIL PROTECTED] 11/29 10:35 AM >>>
Why don't you want to want to take all the oracle processes down?  I thought
that's what you wanted to accomplish with shutdown immediate? 


Go ahead and issue Mladen's command and restart the database.  It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus. 


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117



> -Original Message-
> From: Greg Faktor [SMTP:[EMAIL PROTECTED]] 
> Sent: Thursday, November 29, 2001 10:05 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  ORA-03113
> 
> Hi All!
> I tried shutdown immediate and get ORA-03113.
> Now I can't connect to database. How I can take instance down? On this HP
> box 10 different databases. 
> This command was posted some time back by Mladen:
> 
> ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 
> It's will take all oracle processes and listeners down 
> which I don't want to do. I'm on  Oracle 8.1.6.
> Thanks.
> Greg.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Greg Faktor
>   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: Greg Faktor
  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:RE: RE: Siebel.

[dgoulet]

Sounds like the path NAI's predecessor took with Support Magic.  WHAT A MESS

Dick Goulet
Off to buy a new shovel, wonder why?

Reply Separator
Author: "Mark Leith" <[EMAIL PROTECTED]>
Date:   11/29/2001 8:45 AM

Another good one is when they change the application from flat files to an
RDBMS.. And then continue to forget all about relational database theory..

Love it!!

-Original Message-
[EMAIL PROTECTED]
Sent: 29 November 2001 14:50
To: Multiple recipients of list ORACLE-L


Henry,

I am sorry to have to admit it, but my experience with third party
software
is that all of them don't want to imbed their referential integrity into the
database.  I like you also believe it is because they do not have any kind
of
data model, never mind a 'proper' one Although the reason I was recently
given
was that it was "proprietary information of a confidential nature".  Smells
like
BS, looks like BS, care to taste it??

We've bothered PeopleSoft for theirs as we have to write some software
to
interface our Automated line to them.  They did finally come up with one,
but it
is dead wrong.  The model they came up with had tables missing, other tables
were on the model, but there was no definition of them in the database, and
the
data integrity on the model did not match the data in the database.  Mostly
we
found that foreign keys are not being completely enforced, and that primary
keys
are not exactly always unique.  One place where I will give on this type of
issue is when, for whatever reason, they populate tables in reverse order
namely
the children before the parents.  This I mostly see in massive batch
processing.

Dick Goulet

Reply Separator
Author: Henry Poras <[EMAIL PROTECTED]>
Date:   11/28/2001 11:45 AM

Does anybody else get the same feeling as me that it is not that vendors are
ignoring proper data models, they don't even know what they are.

Henry

-Original Message-
Sent: Wednesday, November 28, 2001 2:14 PM
To: Multiple recipients of list ORACLE-L


Unfortunately it's the case way too often. Even at the enlightened place
where I work, our RI is done at the application level.

Not much I can do about it. Our development is done on MySQL and then
"ported" to Oracle.

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Wednesday, November 28, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L




BAH!! These bloody application providers leaving the integrity to their
bloody applications instead of leaving it in it's rightful place in the
database!!! Makes my life 10 times harder!!! Got no consideration at all
have they?



:P

Thanks!

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: 28 November 2001 17:46
To: Multiple recipients of list ORACLE-L



We use Siebel and no it does NOT have RI.




"Mark Leith" <[EMAIL PROTECTED]>@fatcity.com on 11/28/2001 10:56:07 AM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:


Hi Gang,

Does anybody use Siebel - I believe it's a CRM package?

I'm trying to find out of the Siebel application enforces RI within the
database or the application? Anybody know?

Cheers

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
  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:
  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: Mark

Re: SYS vs SYSTEM

[Stephane Faroult]

"Van M. Etheridge" wrote:
> 
> Hi Ken,
> 
> My guess is that you need to set up sys.dba_all_tables with a public
> synonym.
> 
> HTH
> 
> Van
> 
> -Original Message-
> Sent: Thursday, November 29, 2001 11:50 AM
> To: Multiple recipients of list ORACLE-L
> 
> 8.1.7 on W2000
> 
> select owner, table_name, tablespace_name from dba_all_tables;
> 
> When I log into sqlplus as SYS is runs.
> 
> When I log into sqlplus as SYSTEM I get the error table or view does not
> exit.
> 
> What is happening here and how do I fix it?
> 
> Thanks,
> 
> Ken
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
>   INET: [EMAIL PROTECTED]

More precisely, log in as SYSTEM and execute

@$ORACLE_HOME/rdbms/admin/catdbsyn

It creates private, not public, synonyms.

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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: CROSS TAB QUERY

[Aponte, Tony]

Title: RE: CROSS TAB QUERY






I gave it a whack and came up with the following solution (I needed the distraction).  For demo purposes each statement build upon the previous ones.  But first a little reality.  There are some problem boundaries that can be declared.  The first one is that there are 12 months in the year so we can adjust the SQL to accommodate them.  The second is that the table's columns are also known.  

I created a bogus table with the format you included in the example:


create table x (MONTH VARCHAR2(20),

ERLANG  NUMBER(7,2),

CONG        NUMBER(5,2),

CSETUP  NUMBER(5,2));


insert into x values('JAN',1,1,1);


insert into x values('FEB',2,2,2);


insert into x values('MAR',3,3,3);


insert into x values('DEC',4,4,4);

            

commit;



Since the table's columns are known I created an in-line view of month,column name,value:


SELECT month,colname,value 

FROM (SELECT month,'erlang' colname,erlang value from x

       UNION

      SELECT month,'cong',cong             from x

       UNION

      SELECT month,'csetup',csetup         from x);

      


With this statement I add a row number to each so that I can pivot by them:

      

SELECT month,colname,value,row_number() over(partition by colname order by month nulls last) 

FROM (SELECT month,'erlang' colname,erlang value from x

       UNION

      SELECT month,'cong',cong             from x

       UNION

      SELECT month,'csetup',csetup         from x);


By adding the DECODE I can place the months into columns:


SELECT 

 colname

,DECODE(line_no,01,month,NULL) Month01

,DECODE(line_no,02,month,NULL) Month02

,DECODE(line_no,03,month,NULL) Month03

,DECODE(line_no,04,month,NULL) Month04

,DECODE(line_no,05,month,NULL) Month05

,DECODE(line_no,06,month,NULL) Month06

,DECODE(line_no,07,month,NULL) Month07

,DECODE(line_no,08,month,NULL) Month08

,DECODE(line_no,09,month,NULL) Month09

,DECODE(line_no,10,month,NULL) Month10

,DECODE(line_no,11,month,NULL) Month11

,DECODE(line_no,12,month,NULL) Month12

FROM (SELECT month,colname,value,row_number() over(partition by colname order by month nulls last) line_no 

      FROM (SELECT month,'erlang' colname,erlang value from x

         UNION

            SELECT month,'cong',cong               from x

         UNION

            SELECT month,'csetup',csetup           from x)

      );


The resultset still needs work to put it into a single row.  Here I use the MAX/GROUP functions to return a single row of month names to be used as the column heading of your report:

      

SELECT 

 colname

,MAX(DECODE(line_no,01,month,NULL)) Month01

,MAX(DECODE(line_no,02,month,NULL)) Month02

,MAX(DECODE(line_no,03,month,NULL)) Month03

,MAX(DECODE(line_no,04,month,NULL)) Month04

,MAX(DECODE(line_no,05,month,NULL)) Month05

,MAX(DECODE(line_no,06,month,NULL)) Month06

,MAX(DECODE(line_no,07,month,NULL)) Month07

,MAX(DECODE(line_no,08,month,NULL)) Month08

,MAX(DECODE(line_no,09,month,NULL)) Month09

,MAX(DECODE(line_no,10,month,NULL)) Month10

,MAX(DECODE(line_no,11,month,NULL)) Month11

,MAX(DECODE(line_no,12,month,NULL)) Month12

FROM (SELECT month,colname,value,row_number() over(partition by colname order by month nulls last) line_no 

      FROM (SELECT month,'erlang' colname,erlang value from x

         UNION

            SELECT month,'cong',cong               from x

         UNION

            SELECT month,'csetup',csetup           from x)

      )

GROUP BY colname;


Now change the column from month to value to get the actual row data that used to be in columns:


SELECT 

 colname

,MAX(DECODE(line_no,01,value,NULL)) value01

,MAX(DECODE(line_no,02,value,NULL)) value02

,MAX(DECODE(line_no,03,value,NULL)) value03

,MAX(DECODE(line_no,04,value,NULL)) value04

,MAX(DECODE(line_no,05,value,NULL)) value05

,MAX(DECODE(line_no,06,value,NULL)) value06

,MAX(DECODE(line_no,07,value,NULL)) value07

,MAX(DECODE(line_no,08,value,NULL)) value08

,MAX(DECODE(line_no,09,value,NULL)) value09

,MAX(DECODE(line_no,10,value,NULL)) value10

,MAX(DECODE(line_no,11,value,NULL)) value11

,MAX(DECODE(line_no,12,value,NULL)) value12

FROM (SELECT month,colname,value,row_number() over(partition by colname order by month nulls last) line_no 

      FROM (SELECT month,'erlang' colname,erlang value from x

         UNION

            SELECT month,'cong',cong               from x

         UNION

            SELECT month,'csetup',csetup           from x)

      )

GROUP BY colname;


I didn't handle sorting by calendar month since that's easy enough to handle with DECODES, but it would have distracted fro

RE: Standby Database

[Mohan, Ross]

Title: RE: Standby Database



Shareplex is a great tool, i have heard anecdotally. Of course, it 
ain't cheap, either. 
 
 
Both 
facts need to be addressed. 
 
 
Is 
there any interest in sharing that kind of sales information? For, say, a Sun 
6500, 12 processors, 8GB RAM, 
"shareplexing" to another box of same type...
 
 
Just a 
question. 
 
Ross

  -Original Message-From: Nick Wagner 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 
  12:15 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Standby Database
   
  I usually don't do these kind of posts... but I've seen a lot 
  of activity on this topic lately.  
  What is really the problem we are trying to solve here?  
  Maybe we are using the wrong tool.   
  If you are looking for data protection in the event of a 
  failure, or disaster... Or if you are trying to create a real time reporting 
  instance. And you are using standby databases... there is a better 
  solution.    
  We provide a product called SharePlex for Oracle... it 
  continually scans the online redo logs for any transactions on the tables that 
  are critical to your environment.  It takes these transactions, and sends 
  them to a target machine over TCP communication, and posts them via standard 
  Oracle SQL.  The target system is completely open and available, while we 
  are posting to it, for reporting and/or verifying that the data is there and 
  available for use in case of a failure or disaster at the primary site.  
  
  It can even be used in a peer to peer replication scheme as 
  well.  
   
   for more 
  information you can go to http://www.quest.com/shareplex/   
    
  Sorry about the 'sales announcement'  but this list is 
  for helping people, and trying to solve their problems... I see this as a 
  solution.   
  Nick Wagner Technical PM 
  Quest Software 
  -Original Message- From: Ed 
  [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Subject: Standby Database 
  Quick question.  Is it a fair statement to say that using 
  Oracle's hot standby database allows you 
  recoverability up to the last archive log, but would 
  NOT recover to the latest redo log (prior to a log switch).  In 
  other words, the potential to lose transactions is 
  very high if you depend on this for failover (not good 
  for e-commerce type databases).  Would it be possible to somehow mirror redo logs across to the failover server and apply 
  them when activating the standby database, or is the 
  only real solution clustering or something like 
  DoubleTake? 
  Am I making sense? 
  Thanks, 
  Ed 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- Author: Ed   
  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). 

OT : 9ias Vs IIS

[Marin Dimitrov]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 14:40


> So which would you rather use?
>

apache

> Would you rather use a less secure (yes
> I *DO* believe it is less secure) larger target, or the alternative that
is
> stable and less of a target?
>

presented this way it sounds like choosing between being rich&healthy or
being poor&sick

u can't just install Apache and forget about it - that's what the IIS
'admins' did and the result was the spread of Code Red/etc


Marin


"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marin Dimitrov
  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: Statistics not updated

[Raj Gopalan]

No.

-Original Message-
Sent: 29 November 2001 15:30
To: Multiple recipients of list ORACLE-L



Are you seeing 'UNABLE TO EXTEND TEMP TABLESPACE...' in your alert log?

-Original Message-
Sent: Thursday, November 29, 2001 6:05 AM
To: Multiple recipients of list ORACLE-L


Hi DBAs
 
The DB is 8.1.5 on Solaris under CBO.
 
The statistics for some of the tables are getting updated after issuing
analyze table. I tried with dbms_utility also but no result. What could be
wrong?
 
Thanks
 
Raj
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raj Gopalan
  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: Troiano, Paul (CAP, GEFA)
  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: Raj Gopalan
  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: Comments on RMAN

[Koivu, Lisa]

Title: RE: Comments on RMAN





It's here, halfway down


http://www.evdbt.com/library.htm


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 29, 2001 10:35 AM
To: Multiple recipients of list ORACLE-L
Subject:    Re: Comments on RMAN



Someone on this list recently referenced the paper Is RMAN Really Worth the
Trouble?  By Tim Gorman of SageLogix, Inc.  It's fairly interesting.   I
don't have a soft copy, just a hard one.


I can't remember where I found the copy I printed.  I think if you search
for it with Google, you will find it.


Cherie Machler
Oracle DBA
Gelco Information Network



    
    "Ruth Gramolini"    
    <[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>    
    ate.vt.us>   cc:    
    Sent by: Subject: Re: Comments on RMAN  
    [EMAIL PROTECTED]    
    
    
    11/29/01 08:45 AM   
    Please respond to   
    ORACLE-L    
    
    





I thought I had another one but I can't find it.  It was done by Michael
Abbey of Pythian Consulting of Ottawa, Canada.  His presentaion was entitle
something like 'If you don't use rman now you will'  and explained how rman
uses oracle internals to avoid problems.


Regards,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 8:55 AM



> Ruth,
>
> I'd be interested in those articles if you don't mind?
>
> Cheers
>
> Mark
>
> -Original Message-
> Gramolini
> Sent: 29 November 2001 13:05
> To: Multiple recipients of list ORACLE-L
>
>
> I have used rman exclusively for all backups since I started with Oracle.
> It was very buggy before 8.0.6 but after that it is very stable.  It is
well
> worth learning,  I can send you some articles about is if you would like.
> You can't send attachments on the list.
>
> Regards,
> Ruth
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, November 29, 2001 7:25 AM
>
>
> > What is the general consensus from the list on using RMAN? Pros? Cons?
> > Any previous experience with problems as a result of using RMAN versus
> > cold and hot backups. I would appreciate your inputs. Thanks in
advance.
> >
> > Belinda K. Taylor
> > Database Analyst, Database Support
> > Database Application Services, Technology Systems Division
> > Information Technology Unit
> > George Mason University
> > Office:  (703) 993-3346
> > Fax:  (703) 993-3403
> >
> > --
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   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

RE: GRANT REFERENCES

[Troiano, Paul (CAP, GEFA)]

I haven't done it with the REFERENCES privilige but with others the
following will work:
 
1. create the same user account with the same password in the other
database. 
2. grant the appropriate permissions to that user.
3. refer to the table with @servicename or create a synonym with the
@servicename notation. When the user refers to the object the
username/password from the current instance will be passed to the other
instance.

-Original Message-
Sent: Thursday, November 29, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L


Hi All, 

I am trying to GRANT REFERENCES on a table that resides on a different
database, on a different server. Is this possible and how do I go about
doing it. 

TIA 
E.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Troiano, Paul (CAP, GEFA)
  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: Comments on RMAN

[David Wagoner]

Did anyone else get an error while trying to open the RMAN pdf file?



David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc.
4815 Emperor Blvd., Suite 110
Durham, NC 27703
Tel. (919) 941-4645
Fax (919) 474-0735
Email mailto:[EMAIL PROTECTED]
Web http://www.arsenaldigital.com/

 
***  NOTICE  ***
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, work
product or exempt from disclosure under applicable law.  If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail
message from your computer.  Thank you.

-Original Message-
Sent: Thursday, November 29, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L

I thought I had another one but I can't find it.  It was done by Michael
Abbey of Pythian Consulting of Ottawa, Canada.  His presentaion was entitle
something like 'If you don't use rman now you will'  and explained how rman
uses oracle internals to avoid problems.

Regards,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 8:55 AM


> Ruth,
>
> I'd be interested in those articles if you don't mind?
>
> Cheers
>
> Mark
>
> -Original Message-
> Gramolini
> Sent: 29 November 2001 13:05
> To: Multiple recipients of list ORACLE-L
>
>
> I have used rman exclusively for all backups since I started with Oracle.
> It was very buggy before 8.0.6 but after that it is very stable.  It is
well
> worth learning,  I can send you some articles about is if you would like.
> You can't send attachments on the list.
>
> Regards,
> Ruth
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, November 29, 2001 7:25 AM
>
>
> > What is the general consensus from the list on using RMAN? Pros? Cons?
> > Any previous experience with problems as a result of using RMAN versus
> > cold and hot backups. I would appreciate your inputs. Thanks in advance.
> >
> > Belinda K. Taylor
> > Database Analyst, Database Support
> > Database Application Services, Technology Systems Division
> > Information Technology Unit
> > George Mason University
> > Office:  (703) 993-3346
> > Fax:  (703) 993-3403
> >
> > --
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   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: Mark Leith
>   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: David Wagoner
  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

Oracle DBA Team Leader Needed in Milwaukee

[OraStaff]

Oracle DBA Team Leader
Years Exp: 5+ years
Location: Milwaukee, WI 
Compensation: Competitive Package
Prod Offered: Financial Services

Candidates local to the Greater Milwaukee area preferred but all will be
considered.

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

Position Description:
Outstanding opportunity to join a leading company in the investments
industry that is is converting from Oracle 8.1X to Oracle 9. 
They are seeking a creative, effective person to lead a group of 2-4 Oracle
DBAs. 
This person will be instrumental in all Oracle operations.

Requirements:
BS or BA degree, 5 or more years of strong Oracle along with
proven leadership skills are required.
Oracle 8 and/or 9 experience is highly desired.
U.S. citizenship or permanent residency is also required.

For  immediate consideration, please send your resume as an attachment to:
Bill Law, 
Oracle Placement Specialist
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/DBA/Milwaukee/Harris

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: OraStaff
  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).

Snapshot Problems

[Jeff Wiegard]

Good Day.

I have a problem with recreating some snapshots. I would like to
add to the current set of snapshots. They were created in the
following manner:

create snapshot snap_test as select * from test@test_DB;

They are executed nightly in the following manner:

execute DBMS_SNAPSHOT.REFRESH('SCOTT.TEST','?');


However, when I try and create them, I get an ORA-01406 error, due
to truncation of the varchar2(4000) . According to Oracle, this is a
bug. Does someone know of a work-around?  

Jeff

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Wiegard
  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: SYS vs SYSTEM

[Van M. Etheridge]

Hi Ken,

My guess is that you need to set up sys.dba_all_tables with a public
synonym.

HTH

Van

-Original Message-
Sent: Thursday, November 29, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L


8.1.7 on W2000

select owner, table_name, tablespace_name from dba_all_tables;


When I log into sqlplus as SYS is runs.

When I log into sqlplus as SYSTEM I get the error table or view does not
exit.

What is happening here and how do I fix it?

Thanks,

Ken 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  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: Van M. Etheridge
  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: RE: ORA-03113

[Greg Faktor]

If I'll apply this command it's will take all oracle processes down  for every 
instance in this box?

Thanks.



>>> [EMAIL PROTECTED] 11/29 10:35 AM >>>
Why don't you want to want to take all the oracle processes down?  I thought
that's what you wanted to accomplish with shutdown immediate? 

Go ahead and issue Mladen's command and restart the database.  It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus. 

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117


> -Original Message-
> From: Greg Faktor [SMTP:[EMAIL PROTECTED]] 
> Sent: Thursday, November 29, 2001 10:05 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  ORA-03113
> 
> Hi All!
> I tried shutdown immediate and get ORA-03113.
> Now I can't connect to database. How I can take instance down? On this HP
> box 10 different databases. 
> This command was posted some time back by Mladen:
> 
> ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 
> It's will take all oracle processes and listeners down 
> which I don't want to do. I'm on  Oracle 8.1.6.
> Thanks.
> Greg.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Greg Faktor
>   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: Greg Faktor
  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: backup unix script

[Mohan, Ross]

my, that's attractive! ;-)

-Original Message-
Sent: Thursday, November 29, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L


I believe the it is as follows:


Run SQL*Plus
|   THIS SHOULD NOT BE HERE
|   | database username
|   | |   database password
|   | |   |   Redirect output to file filename.dat
|   | |   |   |  Read input up to the next line
starting with "!", 
|   | |   |   |  |  this is what is called a
"here-document", for more
|   | |   |   |  |  on here-documents see any man
page for sh or ksh
|   | |   |   |  |
sqlplus - sys/msd > filename.dat 

RE: Comments on RMAN

[Baker, Barbara]

You can find this on Tim's web site
www.evdbt.com

Barb


> --
> From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, November 29, 2001 8:35 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Comments on RMAN
> 
> <>
> 
> Someone on this list recently referenced the paper Is RMAN Really Worth
> the
> Trouble?  By Tim Gorman of SageLogix, Inc.  It's fairly interesting.   I
> don't have a soft copy, just a hard one.
> 
> I can't remember where I found the copy I printed.  I think if you search
> for it with Google, you will find it.
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> 
>  
> 
> "Ruth Gramolini"
> 
> <[EMAIL PROTECTED]   To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>
> ate.vt.us>   cc:
> 
> Sent by: Subject: Re: Comments on
> RMAN  
> [EMAIL PROTECTED]
> 
>  
> 
>  
> 
> 11/29/01 08:45 AM
> 
> Please respond to
> 
> ORACLE-L
> 
>  
> 
>  
> 
> 
> 
> 
> 
> I thought I had another one but I can't find it.  It was done by Michael
> Abbey of Pythian Consulting of Ottawa, Canada.  His presentaion was
> entitle
> something like 'If you don't use rman now you will'  and explained how
> rman
> uses oracle internals to avoid problems.
> 
> Regards,
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, November 29, 2001 8:55 AM
> 
> 
> > Ruth,
> >
> > I'd be interested in those articles if you don't mind?
> >
> > Cheers
> >
> > Mark
> >
> > -Original Message-
> > Gramolini
> > Sent: 29 November 2001 13:05
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > I have used rman exclusively for all backups since I started with
> Oracle.
> > It was very buggy before 8.0.6 but after that it is very stable.  It is
> well
> > worth learning,  I can send you some articles about is if you would
> like.
> > You can't send attachments on the list.
> >
> > Regards,
> > Ruth
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Thursday, November 29, 2001 7:25 AM
> >
> >
> > > What is the general consensus from the list on using RMAN? Pros? Cons?
> > > Any previous experience with problems as a result of using RMAN versus
> > > cold and hot backups. I would appreciate your inputs. Thanks in
> advance.
> > >
> > > Belinda K. Taylor
> > > Database Analyst, Database Support
> > > Database Application Services, Technology Systems Division
> > > Information Technology Unit
> > > George Mason University
> > > Office:  (703) 993-3346
> > > Fax:  (703) 993-3403
> > >
> > > --
> > > 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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   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: Mark Leith
> >   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 oth

RE: RE: Siebel.

[Mark Leith]

Another good one is when they change the application from flat files to an
RDBMS.. And then continue to forget all about relational database theory..

Love it!!

-Original Message-
[EMAIL PROTECTED]
Sent: 29 November 2001 14:50
To: Multiple recipients of list ORACLE-L


Henry,

I am sorry to have to admit it, but my experience with third party
software
is that all of them don't want to imbed their referential integrity into the
database.  I like you also believe it is because they do not have any kind
of
data model, never mind a 'proper' one Although the reason I was recently
given
was that it was "proprietary information of a confidential nature".  Smells
like
BS, looks like BS, care to taste it??

We've bothered PeopleSoft for theirs as we have to write some software
to
interface our Automated line to them.  They did finally come up with one,
but it
is dead wrong.  The model they came up with had tables missing, other tables
were on the model, but there was no definition of them in the database, and
the
data integrity on the model did not match the data in the database.  Mostly
we
found that foreign keys are not being completely enforced, and that primary
keys
are not exactly always unique.  One place where I will give on this type of
issue is when, for whatever reason, they populate tables in reverse order
namely
the children before the parents.  This I mostly see in massive batch
processing.

Dick Goulet

Reply Separator
Author: Henry Poras <[EMAIL PROTECTED]>
Date:   11/28/2001 11:45 AM

Does anybody else get the same feeling as me that it is not that vendors are
ignoring proper data models, they don't even know what they are.

Henry

-Original Message-
Sent: Wednesday, November 28, 2001 2:14 PM
To: Multiple recipients of list ORACLE-L


Unfortunately it's the case way too often. Even at the enlightened place
where I work, our RI is done at the application level.

Not much I can do about it. Our development is done on MySQL and then
"ported" to Oracle.

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Wednesday, November 28, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L




BAH!! These bloody application providers leaving the integrity to their
bloody applications instead of leaving it in it's rightful place in the
database!!! Makes my life 10 times harder!!! Got no consideration at all
have they?



:P

Thanks!

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: 28 November 2001 17:46
To: Multiple recipients of list ORACLE-L



We use Siebel and no it does NOT have RI.




"Mark Leith" <[EMAIL PROTECTED]>@fatcity.com on 11/28/2001 10:56:07 AM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:


Hi Gang,

Does anybody use Siebel - I believe it's a CRM package?

I'm trying to find out of the Siebel application enforces RI within the
database or the application? Anybody know?

Cheers

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
  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:
  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: Mark Leith
  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 

RE: RE: Siebel.

[Henry Poras]

Just curious, but which of the major RDBMSs don't have RI?

Henry

-Original Message-
Sent: Thursday, November 29, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


Another factor is that when RI was first introduced, people tended to
overuse it and then performance was bad. I don't think this is such a
problem today, but I think many ERP packages were either developed before RI
was common to all SQL databases, or were discouraged by the initial
problems. But I agree that the main factor has been that they try to be
compatible with all databases and the easiest way is to maintain their own
data dictionary and not implement RI in the database. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Henry Poras
  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: Standby Database

[Nick Wagner]

Title: RE: Standby Database








I usually don't do these kind of posts... but I've seen a lot of activity on this topic lately.  


What is really the problem we are trying to solve here?  Maybe we are using the wrong tool.   


If you are looking for data protection in the event of a failure, or disaster... Or if you are trying to create a real time reporting instance. And you are using standby databases... there is a better solution.    

We provide a product called SharePlex for Oracle... it continually scans the online redo logs for any transactions on the tables that are critical to your environment.  It takes these transactions, and sends them to a target machine over TCP communication, and posts them via standard Oracle SQL.  The target system is completely open and available, while we are posting to it, for reporting and/or verifying that the data is there and available for use in case of a failure or disaster at the primary site.  

It can even be used in a peer to peer replication scheme as well.  






for more information you can go to http://www.quest.com/shareplex/   
  


Sorry about the 'sales announcement'  but this list is for helping people, and trying to solve their problems... I see this as a solution.   

Nick Wagner
Technical PM
Quest Software


-Original Message-
From: Ed [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Standby Database



Quick question.  Is it a fair statement to say that using Oracle's hot
standby database allows you recoverability up to the last archive log, but
would NOT recover to the latest redo log (prior to a log switch).  In other
words, the potential to lose transactions is very high if you depend on this
for failover (not good for e-commerce type databases).  Would it be possible
to somehow mirror redo logs across to the failover server and apply them
when activating the standby database, or is the only real solution
clustering or something like DoubleTake?


Am I making sense?


Thanks,


Ed



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed
  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: Siebel - ODB.

[Henry Poras]

Title: RE: Siebel - ODB.



Of 
course a well designed database should (??!!) be used by multiple applications. 
So ideally, constraints which are data driven (long term) would be in the 
database, and constraints which are application driven (business rules) would 
reside in the application. But when application vendors create the database with 
no need to share data between other applications ...
 
Henry

  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 
  8:00 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Siebel - ODB.
  Lisa,
   
  One 
  arguement I lost regarding business rules (foreign keys) in the application, 
  rather than in the database was that it made the application "database 
  independent", not relying on database tools that might exist in one database 
  but not another.  In theory, this gave this person more opportunity to 
  sell the application to another organization that would prefer to use, say, 
  DB2 rather than Oracle.
   
  I'm 
  not agreeing with the philosophy, but at the time, it made some business 
  sense.
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 
2001 4:26 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Siebel - ODB.
Why implement it in the database when 
you can write more bloated, more complex code?  Databases don't work 
anyway.  It also gives us a chance to issue more patches.  

I have NEVER understood why some people 
take the angle of not letting the database do what it is designed for.  
And I don't think I ever will.  I pray I never meet the DBA's of Yore 
and Yesteryear.
Rant on, Mark! 
Lisa Koivu Oracle 
Database Bimbo. Fairfield Resorts, Inc. 
954-935-4117 

  -Original Message- From:   Mark Leith [SMTP:[EMAIL PROTECTED]] Sent:   Wednesday, November 28, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Subject:    RE: Siebel. 
   
  BAH!! These bloody application providers 
  leaving the integrity to their bloody 
  applications instead of leaving it in it's rightful place in the 
  database!!! Makes my life 10 times harder!!! 
  Got no consideration at all have 
  they? 
   
  :P 
  Thanks! 
  Mark 
  -Original Message- [EMAIL PROTECTED] Sent: 28 November 2001 17:46 To: Multiple recipients of list ORACLE-L 
  We use Siebel and no it does NOT have 
  RI. 
  "Mark Leith" 
  <[EMAIL PROTECTED]>@fatcity.com on 11/28/2001 10:56:07 AM 
  
  Please respond to [EMAIL PROTECTED] 
  
  Sent by:  [EMAIL PROTECTED] 
  To:   Multiple recipients of list 
  ORACLE-L <[EMAIL PROTECTED]> cc: 
  Hi Gang, 
  Does anybody use Siebel - I believe it's a CRM 
  package? 
  I'm trying to find out of the Siebel 
  application enforces RI within the database or the application? Anybody know? 
  Cheers 
  Mark 
  === 
   Mark 
  Leith 
  | T: +44 (0)1905 330 281  Sales 
  & Marketing  | F: +44 (0)870 127 
  5283  Cool Tools UK 
  Ltd  | E: [EMAIL PROTECTED] 
  === 
     http://www.cool-tools.co.uk    Maximising throughput & 
  performance 
  -- Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 
    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:   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 ORAC

SYS vs SYSTEM

[Ken Janusz]

8.1.7 on W2000

select owner, table_name, tablespace_name from dba_all_tables;


When I log into sqlplus as SYS is runs.

When I log into sqlplus as SYSTEM I get the error table or view does not
exit.

What is happening here and how do I fix it?

Thanks,

Ken 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  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: ORA-03113

[Mohan, Ross]

grep, then, for the instance you DO want to take down. 

or, ask Mladen again. I understand he likes taking things down! 

;-)

-Original Message-


Hi All!
I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can take instance down? On this HP
box 10 different databases. 
This command was posted some time back by Mladen:

ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 


-- 
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: ORA-03113

[Troiano, Paul (CAP, GEFA)]

You could always start a bit nicer and kill pmon, wait a couple of minutes
to see if the others are brought down. They usually will as Oracle
recognizes the instance failure.
 
 -Original Message-
Sent: Thursday, November 29, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L



Why don't you want to want to take all the oracle processes down?  I thought
that's what you wanted to accomplish with shutdown immediate? 

Go ahead and issue Mladen's command and restart the database.  It's the only
way you can bring it down if you can't connect with svrmgrl or sqlplus. 

Lisa Koivu 
Oracle Database Monkey 
Fairfield Resorts, Inc. 
954-935-4117 


-Original Message- 
Sent:   Thursday, November 29, 2001 10:05 AM 
To: Multiple recipients of list ORACLE-L 

Hi All! 
I tried shutdown immediate and get ORA-03113. 
Now I can't connect to database. How I can take instance down? On this HP
box 10 different databases. 
This command was posted some time back by Mladen: 

ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 
It's will take all oracle processes and listeners down 
which I don't want to do. I'm on  Oracle 8.1.6. 
Thanks. 
Greg. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Greg Faktor 
  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: Troiano, Paul (CAP, GEFA)
  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: Win2K Drive Mapping Question

[Marin Dimitrov]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 19:03


> Anyone know how to map more than 26 drives on Win2K
> workstation?  I trying to map 36 servers to a
> workstation.
>

for Win2k u could do this by using Distributed FS (Control Panel --> Admin
Tools --> Distributed File System) -  it allows you to network shares in a
hierarchy


"With Dfs, you can make files distributed across multiple servers appear to
users as if they reside in one place on the network. Users no longer need to
know and specify the actual physical location of files in order to access
them.


hth,

Marin

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marin Dimitrov
  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: Multiple instances - Sun Solaris: shmsys and semsys settings

[Troiano, Paul (CAP, GEFA)]

here is the excerpt from my /etc/system file, we currently have 12 instances
on it. Be sure to apply the logic in the comments and not the actual values
that I used. The settings will make sense to your SA. The logic comes from
reading many papers on the subject (I have them around here somewhere).

This is a Sun E5k with 2.5 GB memory, 10 processors running Solaris 2.6 with
both 8.0.5.2.1 and 8.1.7.1.0 Oracle databases. I use the same logic on all
our systems.

HTH
- Paul


* Revised Shared Memory parameters 
*

* Maximum shared memory size. Set to maximum allowable on
* a 32-bit system. Its easier to remember the value in Hex.
set shmsys:shminfo_shmmax=0x

* Minimum shared memory size. Always set to 1 byte.
set shmsys:shminfo_shmmin=1

* Number of shared memory identifiers to pre-allocate. Set to handle
* 200 users for 6 instances or 100 users for 12 instances (1200) + 
* 10 background processes each (60) + 20 for Sybase + 10% (130) 
* = 1410 -> 1500.
set shmsys:shminfo_shmmni=1500

* Maximum number of shared segments per process. Set to Oracle 
* recommendation. However, I recall reading that only a maximum
* of 10 is allowed in Oracle. ??
set shmsys:shminfo_shmseg=20


* Revised Semaphore parameters
*

* Number of semaphores in the system. Set to the shmmni setting x 2. 
* Oracle needs this extra in order to start up.
set semsys:seminfo_semmns=3000

* Maximum number of semaphores per semaphore group. Set to the 
* maximum number of process per instance.
set semsys:seminfo_semmsl=200

* Maximum number of semaphore identifiers. Must be at least semmns/semmsl
* (=15) but want to allow for many semaphore groups with less
* than the maximum number of semmsl.
set semsys:seminfo_semmni=100

* Number of entries in the semaphore map. Pre-allocate the semaphores.
* Set to semmns.
set semsys:seminfo_semmap=3000



-Original Message-
Sent: Wednesday, November 28, 2001 9:05 AM
To: Multiple recipients of list ORACLE-L


Hi - 

We are running a solaris server (2.6) for our develoment environment.  We
currently have 5 instances on the server.  When we create another instance
and try to start it, we get a ORA-27101:  shared memory realm does not
exist.  The text reads 'Unable to locate shared meory realm'.

We have set the following kernal parameters to what we believe to be
appropriate.  

SHMMAX=1207959552
SHMMIN=1
SHMSEG=10
SEMMNI=100
SEMMSL=350
SEMMNS =1000
SEMOPM =100
SEMVMX=32767

Does anyone know of any other kernal parameter settings that may be causing
this error?

THanks -
Lisa
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: YTTRI  Lisa
  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: Troiano, Paul (CAP, GEFA)
  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: RE: Siebel.

[DENNIS WILLIAMS]

Another factor is that when RI was first introduced, people tended to
overuse it and then performance was bad. I don't think this is such a
problem today, but I think many ERP packages were either developed before RI
was common to all SQL databases, or were discouraged by the initial
problems. But I agree that the main factor has been that they try to be
compatible with all databases and the easiest way is to maintain their own
data dictionary and not implement RI in the database. 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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).

Email through trigger

[Aldi Barco]

Hi Listers,

What is the oracle procedure / package to send an email through store 
procedure or trigger ?

Tia.
Aldi


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Aldi Barco
  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).

ORA-03113

[Greg Faktor]

Hi All!
I tried shutdown immediate and get ORA-03113.
Now I can't connect to database. How I can take instance down? On this HP box 10 
different databases. 
This command was posted some time back by Mladen:

ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 
It's will take all oracle processes and listeners down 
which I don't want to do. I'm on  Oracle 8.1.6.
Thanks.
Greg.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Faktor
  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: Comments on RMAN

[Prakriteswar Santikary]

thanks Ruth.

Santi

-Original Message-
Sent: Thursday, November 29, 2001 6:46 AM
To: Multiple recipients of list ORACLE-L


I thought I had another one but I can't find it.  It was done by Michael
Abbey of Pythian Consulting of Ottawa, Canada.  His presentaion was entitle
something like 'If you don't use rman now you will'  and explained how rman
uses oracle internals to avoid problems.

Regards,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 8:55 AM


> Ruth,
>
> I'd be interested in those articles if you don't mind?
>
> Cheers
>
> Mark
>
> -Original Message-
> Gramolini
> Sent: 29 November 2001 13:05
> To: Multiple recipients of list ORACLE-L
>
>
> I have used rman exclusively for all backups since I started with Oracle.
> It was very buggy before 8.0.6 but after that it is very stable.  It is
well
> worth learning,  I can send you some articles about is if you would like.
> You can't send attachments on the list.
>
> Regards,
> Ruth
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, November 29, 2001 7:25 AM
>
>
> > What is the general consensus from the list on using RMAN? Pros? Cons?
> > Any previous experience with problems as a result of using RMAN versus
> > cold and hot backups. I would appreciate your inputs. Thanks in advance.
> >
> > Belinda K. Taylor
> > Database Analyst, Database Support
> > Database Application Services, Technology Systems Division
> > Information Technology Unit
> > George Mason University
> > Office:  (703) 993-3346
> > Fax:  (703) 993-3403
> >
> > --
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   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: Mark Leith
>   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: Prakriteswar Santikary
  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).