date:20021003


In dates, a single day = 1.

Thus

sysdate + 1 = same time tomorrow
sysdate + 7 = same time next week
sysdate + 1/24  = one hour from now
sysdate + 1/24/60 = one minute from now
sysdate + 1/24/60/60 = one second from now

etc
etc

You can also use trunc and round

hth
connor

 --- shuan.tay\(PCI¾G¸R³Ô\) [EMAIL PROTECTED]
wrote:  Hi Gurus,
 
 i know there's 'add_month',
 is there any built-in function like 'add_hour' or
 'add_minute'?
 or i have to write a function to add it?
 
 thanks in advance.
 
  

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

Remember amateurs built the ark - Professionals built the Titanic

__
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Sql query

2002-10-03 Thread Santosh Varma




cannot perform an aggregate function on an expression containing an
aggregate or subquery
is the error i am getting while i am executing the query.
SELECT name
FROM (SELECT c.name, COUNT(p.clientid) p_count
FROM client c, project p
WHERE c.clientid = p.clientid
GROUP BY c.name) a,
(SELECT MAX(COUNT(clientid)) p_max
FROM project
GROUP BY clientid) b
WHERE a.p_count = b.p_max
clientid and name are the columns in client table
and projectid and clientid are the columns in project table.
santosh
-Original Message-
Ignaszak
Sent: Monday, September 30, 2002 6:09 PM
To: Multiple recipients of list ORACLE-L

try it:
select
name
from
(select c.name, count(p.id) p_count from clients c, projects p
where c.id = p.cl_id
group by c.name) a,
(select max(count(id)) p_max from projects
group by cl_id) b
where a.p_count = b.p_max
Regards,
Leszek
At 03:23 2002-09-30 -0800, you wrote:
Hello all,

 I have a query -
i have 2 tables - client and project

fields in project table - clientid/projectid
fields in client table - clientid/name

i want to get the maximum orders one client has got. i mean a project
having the greatest clients
how to write it in single query ??


like
project 1 client 1
project 2 client 1
project 3 client 2

in the above case, the query should return client ( 1 ).

Thanks and regards,
Santosh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leszek Ignaszak
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Santosh Varma
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like 
subscribing).

Re: Falling off my seat ( 9i R2)


Throw in the fact also that most of the default
accounts are installed with their account locked...

Love it.

 --- Grant Allen [EMAIL PROTECTED] wrote:  Hi
all,
 
 Just thought I'd comment on the fact 9i R2
 dbassist-created databases
 actually prompt for SYS and SYSTEM passwords now ...
 no more
 you-know-what.
 
 This just isn't on!  You can't just go throwing in
 sensible security
 changes like that :-) :-) :-)
 
 [very big grin]
 
 Ciao
 Fuzzy
 :-)
 
 

--
 Woo Hoo! - H. Simpson

--
 The contents of this post are my opinions only
   If swallowed seek medical advice
 
 (Apologies for the excess signature)
 This email message (and attachments) may contain
 information
 confidential to TOWER Software.  If you are not the
 intended recipient
 you cannot use, distribute or copy the message or
 message attachments.
 If you are not the intended recipient, please notify
 the sender by
 return email immediately and delete all copies of
 the message and
 attachments.  Opinions, conclusions and other
 information in this
 message and attachments that do not relate to the
 official business of
 TOWER Software, are not given or endorsed by it.
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Grant Allen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

Remember amateurs built the ark - Professionals built the Titanic

__
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Add_Month... Add_Hour? Add_Minute?




if you 
do a_date + n, it increments a_date(if it is of datatype DATE) by'n' 
days.

So 
to_date('04-OCT-2002', 'DD-MON-') + 1 = to_date('05-OCT-2002', 
'DD-MON-') 

If you 
want to increment one hour add 1/24, if you want to increment by 1 min. add 
1/(60*24) and so on

Regards
Naveen

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 03, 2002 1:13 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Add_Month... Add_Hour? Add_Minute?
  Hi Gurus,
  
  i know there's 'add_month',
  is there any built-in function like 'add_hour' or 
  'add_minute'?
  or i have to write a function to add 
  it?
  
  thanks in advance.

Re: select sequence.nextval from dual contributes to poor performan


Most commonly this is due to poor coding, where poor
means the sequence value is obtained explicitly in a
trigger or before the insert/update/etc is done.  

Certainly plain old insert into xxx values
(bbb.nextval, ... )

is a lot faster than 

a) select nextval from dual
b) do insert

and the former is also a lot nicer on indexes as well.

The other thing is that you'll see that 'select ...
from dual' is 5 logical IO's.  I you can change the
app to query from a local_dual table stored as an
IOT then this drops significantly.  Alternatively, you
could have a local dual which is a synonym to
SYS.X$DUAL.  Its a question of whether your app
supports such mods

hth
connor

 --- Fowler, Kenneth R
[EMAIL PROTECTED] wrote:  Hi,
 
 
 I am looking after an Oracle EE V8.1.6 database on
 Solaris 2.6 and I have
 been monitoring the database to try and look for
 causes of poor performance.
 I have been using Quest SQLLab Vision which is one
 of the tools around that
 will look at the SGA directly and sample stats
 multiple times /sec.  Based
 upon the information I get back, I can see that the
 following query...
 
 SELECT STAGE_DATA_SEQ.NEXTVAL FROM DUAL;
 
 Seems to use a significant amount of resource when
 you take into account the
 number of times it is executed.  The query plan
 shows a full scan of
 sys.dual and it uses significant CPU and I/O.
 
 
 Is there a better (less resource intensive) way to
 get the nextval??  It may
 seem a little petty but it just happens that this
 query is the second
 highest resource user when you take into account the
 number of times it is
 executed.
 
 
 Thanks,
 Ken
 _
 Clinical and Regulatory Informatics - Groton/New
 London
 Coordinator, Business and Technical Services
 Tel: (860) 732-0026 Fax: (860) 715-8346
 Email: mailto:[EMAIL PROTECTED]
 
 
 
 LEGAL NOTICE
 Unless expressly stated otherwise, this message is
 confidential and may be privileged. It is intended
 for the addressee(s) only. Access to this E-mail by
 anyone else is unauthorized. If you are not an
 addressee, any disclosure or copying of the contents
 of this E-mail or any action taken (or not taken) in
 reliance on it is unauthorized and may be unlawful.
 If you are not an addressee, please inform the
 sender immediately.
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Fowler, Kenneth R
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

Remember amateurs built the ark - Professionals built the Titanic

__
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Falling off my seat ( 9i R2)

2002-10-03 Thread Rachel Carmichael


not only that but most of the sensitive accounts are created LOCKED and
you actually have to unlock them to make them work.

Geez, they are asking us to THINK

Rachel

--- Grant Allen [EMAIL PROTECTED] wrote:
 Hi all,
 
 Just thought I'd comment on the fact 9i R2 dbassist-created databases
 actually prompt for SYS and SYSTEM passwords now ... no more
 you-know-what.
 
 This just isn't on!  You can't just go throwing in sensible security
 changes like that :-) :-) :-)
 
 [very big grin]
 
 Ciao
 Fuzzy
 :-)
 
 

--
 Woo Hoo! - H. Simpson

--
 The contents of this post are my opinions only
   If swallowed seek medical advice
 
 (Apologies for the excess signature)
 This email message (and attachments) may contain information
 confidential to TOWER Software.  If you are not the intended
 recipient
 you cannot use, distribute or copy the message or message
 attachments.
 If you are not the intended recipient, please notify the sender by
 return email immediately and delete all copies of the message and
 attachments.  Opinions, conclusions and other information in this
 message and attachments that do not relate to the official business
 of
 TOWER Software, are not given or endorsed by it.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Grant Allen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Query




why do 
u want such a query?

  -Original Message-From: Anand Kumar N 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 03, 2002 
  1:33 PMTo: Multiple recipients of list ORACLE-LSubject: 
  SQL Query
  I have a table 
  test((NAME VARCHAR2(10),AGE NUMBER(2));
  
  data of the table is 
  
  
  NAME 
  AGE--   
  -ANAND 
  1BALU2CHANDU3DAVID4
  
  
  I want a query which 
  give me the result as
  
  
  NAME 
  AGE--   
  -ANAND 
  4BALU3CHANDU2DAVID1
  
  Can any body pl. help me.
  
  Anand KumarITW Signode India 
Ltd

RE: Add_Month... Add_Hour? Add_Minute?

2002-10-03 Thread Nicoll, Iain $Calanais$


I think it's just that there is no need for a function as hour, minute and
second are always known fractions of a day
 
i.e 1/24, 1/1440, 1/86400  
 
whereas month is variable.  Given that a functions seems a bit excessive.
 
Iain Nicoll

-Original Message-
Sent: Thursday, October 03, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus,
 
i know there's 'add_month',
is there any built-in function like 'add_hour' or 'add_minute'?
or i have to write a function to add it?
 
thanks in advance.
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicoll, Iain \(Calanais\)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Indexing SYS tables


Depends on the version I think.  Oracle has always
allowed DESC indexes, but only in 9(?) is the keyword
actually used in the index build.

hth
connor

 --- [EMAIL PROTECTED] wrote:  
 but there is a create index ... desc?
 
 ASC | DESC
  specifies whether the index should be created in
 ascending or descending
 order.
  Oracle treats descending indexes as if they were
 function-based indexes.
 You do not need the QUERY REWRITE or GLOBAL QUERY
 REWRITE privileges to
 create them, as you do with other function-based
 indexes.
 
 Chaim
 
 
 
 
 Jesse, Rich [EMAIL PROTECTED]@fatcity.com
 on 10/01/2002 04:23:22
 PM
 
 Please respond to [EMAIL PROTECTED]
 
 Sent by:[EMAIL PROTECTED]
 
 
 To:Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc:
 
 
 
 Yes it does, at least on my test instance.
 
 Thanks!
 Rich
 
 Rich Jesse   System/Database
 Administrator
 [EMAIL PROTECTED]  Quad/Tech
 International, Sussex, WI
 USA
 
  -Original Message-
  From: Naveen Nahata
 [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, October 01, 2002 12:28 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Indexing SYS tables
 
 
  Again since the indexes store the row in ordered
 fashion, I
  guess a normal
  index should be able to do ORDER BY DESC by
 reading backwards
 
  Not sure though
 
  Regards
  Naveen
 
  -Original Message-
  Sent: Tuesday, October 01, 2002 10:33 PM
  To: Multiple recipients of list ORACLE-L
 
 
  Yes, you are obviously correct.  I really need to
 RTFM.
  sigh  Too many
  pots on the stove!
 
  Just a regular index, then.  Any other input?
 
  Thx!
  Rich
 
  Rich Jesse  
 System/Database Administrator
  [EMAIL PROTECTED]  Quad/Tech
 International,
  Sussex, WI USA
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).
 
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

Remember amateurs built the ark - Professionals built the Titanic

__
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Query

2002-10-03 Thread ASHRAF SALAYMEH


TRY THIS :

SELECT NAME, 4-AGE+1 FROM test; 
 
--- Naveen Nahata [EMAIL PROTECTED] wrote:
 why do u want such a query?
 
 -Original Message-
 Sent: Thursday, October 03, 2002 1:33 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I have a table test((NAME VARCHAR2(10),AGE
 NUMBER(2));
  
 data of the table is 
  
 NAME AGE
 ---
 ANAND  1
 BALU   2
 CHANDU3
 DAVID4
  
  
 I want a query which give me the result as
  
 NAME AGE
 ---
 ANAND  4
 BALU  3
 CHANDU   2
 DAVID   1
  
 Can any body pl. help me.
  
 Anand Kumar
 ITW Signode India Ltd
 
 


__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ASHRAF SALAYMEH
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Query

2002-10-03 Thread Santosh Varma


the below query adds/substracts the value in the age column...
SELECT NAME, 4-AGE+1 FROM test;
does not work..


-Original Message-
SALAYMEH
Sent: Thursday, October 03, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L


TRY THIS :

SELECT NAME, 4-AGE+1 FROM test; 
 
--- Naveen Nahata [EMAIL PROTECTED] wrote:
 why do u want such a query?
 
 -Original Message-
 Sent: Thursday, October 03, 2002 1:33 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I have a table test((NAME VARCHAR2(10),AGE
 NUMBER(2));
  
 data of the table is 
  
 NAME AGE
 ---
 ANAND  1
 BALU   2
 CHANDU3
 DAVID4
  
  
 I want a query which give me the result as
  
 NAME AGE
 ---
 ANAND  4
 BALU  3
 CHANDU   2
 DAVID   1
  
 Can any body pl. help me.
  
 Anand Kumar
 ITW Signode India Ltd
 
 


__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ASHRAF SALAYMEH
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Santosh Varma
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Backups

2002-10-03 Thread Ron Rogers


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and 
have implemented both exports and hot backups.  Both jobs copy to a 
separate mount point, and a job scripted by another individual then 
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it 
provides a succinct output he can email to non-technicals.  The file 
system is built on a 12 disk A1000 array.  We've provided him with a 
ufsdump script, but he's doesn't want to use it. Can the system be 
recovered from this tape?  Has anyone ever relied on a dd for a daily 
backup method? The system is Oracle 9i on Solaris 8.

Robyn

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Utl_file and OPENVMS


On unix, multiple entries in the init.ora file results in the last entry being the 
only valid value (i.e. last time variable is set).  I tested below and only dir3 is 
listed as a utl_file_dir parameter.  But if you comma delimit them w/ 1 instance of 
the variable then all dir's are listed.  Maybe NT is different, fortunately never had 
to support Oracle on NT :).

Gene

 [EMAIL PROTECTED] 10/02/02 07:13PM 
Gene,

 utl_file_dir = D:\directory name1
 utl_file_dir = D:\directory name2
 utl_file_dir = D:\directory name3

The multiple lines shown are actually the documented method for doing 
this.

The single line with comma delimited entries may also work, though I'm
not sure about it.

Jared





Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] 
 10/01/2002 11:25 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Utl_file and OPENVMS


i believe its 

utl_file_dir=dir1,dir2,dir3,...

in your example, dir 3 would be the only valid dir.

hth,
gene

 [EMAIL PROTECTED] 10/01/02 12:53PM 
Make sure you have the directory name entry covered in INIT.ORA

e.g. 

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

You need one entry per directory that you want to write to using UTL_FILE
Package

Hope this helps

Regards

Shiva




-Original Message-
Sent: Tuesday, October 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


the vms user oracle needs rights to the directory.

 [EMAIL PROTECTED] 09/30/02 10:53AM 
List,
 I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4  and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
get the package to write the files to the OS directory.
 The package is created by the Oracle user DTSUSER and executed by
DTSUSER. There is no OPENVMS user DTSUSER.
The sysadmin assures me that the permissions are correct to write to
the directory.
I have place a Dbms_output in the package to display the directory
information and it looks correct.
 Is there anything different that has to be done to an OPENVMS server
that will allow a package to write to a directory using the Utl_File
package?


Listing from the Oracle tables:

DTS_PARAMETER_NAME DTS_PARAMETER_VALUE 
 
-- -- 
 
LOAD_USERIDLOADITUP 
 
LOAD_PASSWORD  ILOADIT 
 
LOAD_SERVICE_NAME  GLC_ALPHADEV-TCP 
 
LOAD_PAR_FILE_DIR  ORADSK:[ORACLE8.DATA.PAR] 
 
LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] 
 
LOAD_CONTROL_FILE_DIR  ORADSK:[ORACLE8.DATA.CONTROL] 
 
LOAD_LOG_FILE_DIR  ORADSK:[ORACLE8.DATA.LOG] 
 
LOAD_BAD_FILE_DIR  ORADSK:[ORACLE8.DATA.BAD] 
 
LOAD_DISCARD_FILE_DIR  ORADSK:[ORACLE8.DATA.DISCARD] 

Listing from the package that writes the parameter file:

Procedure Create_New_Par_File 
 
  ( 
 
   P_Current_Table_Name  In  Varchar2 
, 
 
   P_Run_DateIn Date,  

 
   P_Load_Userid In  Varchar2 
, 
 
   P_Load_Password   In  Varchar2 
, 
 
   P_Load_Service_Name   In  Varchar2 
, 
 
   P_Load_Par_File_Dir   In  Varchar2 
, 
 
   P_Load_Data_File_Dir  In  Varchar2 
, 
 
   P_Load_Control_File_Dir   In  Varchar2  ,
 
   P_Load_Log_File_Dir   In  Varchar2 
, 
 
   P_Load_Bad_File_Dir   In  Varchar2 
, 
 
   P_Load_Discard_File_Dir   In  Varchar2   
 
  ) 
 
  as 
 
  Begin 
 
  Declare 
 
   L_Par_File_Hand   Utl_FIle.File_Type; -- Local 
variable to
hold the File Pointer for the parameter file. 
 
 
 
  Begin 
   I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE
   PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT
EN TO.
 -- Open a new parameter file  
 
 L_Par_File_Hand :=
Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w'); 
 
 -- Print the following lines into the parameter file.   
 
 Utl_File.Put
(L_Par_File_Hand,'UserId='||P_Load_UserId||'/'||P_Load_Password||'@'||P_Load
_Service_Name);
 
 
 
 
 Utl_File.New_Line(L_Par_File_Hand);  
 
 If Not P_Current_Table_Name = 'GLCRET'  
 
 Then  
 
 Utl_File.Put 
(L_Par_File_Hand,'Errors=1'); 
 
 Else

RE: Help : X$KSPPI Oracle 8.1.7.2 STATSPACK

2002-10-03 Thread Deshpande, Kirti


If you are running the statspack script as SYS, and still getting these
errors, then it appears that catalog.sql (and may be catproc.sql) was not
run (as sys) on this new database. 

- Kirti 

-Original Message-
Sent: Thursday, October 03, 2002 3:58 AM
To: Multiple recipients of list ORACLE-L


This errors I got, 
I did the same installation on an other server same 8.1.72 and never I got
any errors with statspack.
Why those objects does'nt exists ?
How can fix this problem ?
thanks


grant select on V$FILESTATXS  to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V$TEMPSTATXS  to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V$SQLXS   to PERFSTAT
*
ERROR at line 1:
ORA-01720: grant option does not exist for 'SYS.V_$SQL'



Grant succeeded.

grant select on V_$PARAMETER  to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SYSTEM_PARAMETER to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$DATABASE   to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$INSTANCE   to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$LIBRARYCACHE   to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$LATCH  to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$LATCH_MISSES   to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$LATCH_CHILDREN to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$LATCH_PARENT   to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$ROLLSTAT   to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$ROWCACHE   to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SGAto PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$BUFFER_POOLto PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SGASTATto PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SYSTEM_EVENT   to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SESSIONto PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SESSION_EVENT  to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SYSSTATto PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$WAITSTAT   to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SQLAREAto PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SQLto PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SQLTEXTto PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$SESSTATto PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on V_$BUFFER_POOL_STATISTICS to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist

-Message d'origine-
De: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Date:   mercredi 2 octobre 2002 20:33
À:  Multiple recipients of list ORACLE-L
Objet:  RE: Help : X$KSPPI Oracle 8.1.7.2  STATSPACK

That's an Oracle internal table that is created during the database
creation
time. 

What is the exact error you are receiving?

BTW, Do you use APT scripts by Steve Adams? 

- Kirti


-Original Message-
Sent: Wednesday, October 02, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L


How to create this view X$KSPPI ?

I am trying to install statspack, and it missing this view. ! ! !
Regards
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
services

Restrict certain database access using 3rd party tools.

2002-10-03 Thread Rick_Cale


Hi All,

We have users that have OPS$ accounts that have full DML privs when they
run forms application via citrix. Currently they do
not have sqlplus,etc.  There is a requirement that some can have
sqlplus,toad,etc.  I know you can set up security for sqlplus,etc
using product_user_profile but is there a way to allow only SELECT when
using a 3rd party tool such as TOAD.

Thanks
Rick



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

8.1.7 patch it up?

2002-10-03 Thread O'Neill, Sean


I'm administering a number of production databases (mixture of standard and
enterprise editions) most of which are version 8.1.7.0.0 on Windows NT and
2000.  All are functioning fine and I have no issues. 

I'm considering patching (to 8.1.7.4) some if not all databases and just
want to know if this is an absolute must if all systems are currently
running fine.   In other words does if its not broken, don't fix it apply?


Also, I'm considering implementing RMAN in the near future and am wondering
if there are significant issues with this on the unpatched 8.1.7 database. 

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Query

2002-10-03 Thread Abdul Aleem


Santosh,

If you could tell why do you want the ages be reversed?

Aleem

 -Original Message-
Sent:   Thursday, October 03, 2002 5:35 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Query

the below query adds/substracts the value in the age column...
SELECT NAME, 4-AGE+1 FROM test;
does not work..


-Original Message-
SALAYMEH
Sent: Thursday, October 03, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L


TRY THIS :

SELECT NAME, 4-AGE+1 FROM test; 
 
--- Naveen Nahata [EMAIL PROTECTED] wrote:
 why do u want such a query?
 
 -Original Message-
 Sent: Thursday, October 03, 2002 1:33 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I have a table test((NAME VARCHAR2(10),AGE
 NUMBER(2));
  
 data of the table is 
  
 NAME AGE
 ---
 ANAND  1
 BALU   2
 CHANDU3
 DAVID4
  
  
 I want a query which give me the result as
  
 NAME AGE
 ---
 ANAND  4
 BALU  3
 CHANDU   2
 DAVID   1
  
 Can any body pl. help me.
  
 Anand Kumar
 ITW Signode India Ltd
 
 


__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ASHRAF SALAYMEH
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Santosh Varma
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Query


huh?
   new value
 ANAND  1   4-1+1 = 4
 BALU   2   4-2+1 = 3
 CHANDU 3   4-3+1 = 2
 DAVID  4   4-4+1 = 1

looks right to me.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, October 03, 2002 8:35 AM
To: Multiple recipients of list ORACLE-L


the below query adds/substracts the value in the age column...
SELECT NAME, 4-AGE+1 FROM test;
does not work..


-Original Message-
SALAYMEH
Sent: Thursday, October 03, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L


TRY THIS :

SELECT NAME, 4-AGE+1 FROM test; 
 
--- Naveen Nahata [EMAIL PROTECTED] wrote:
 why do u want such a query?
 
 -Original Message-
 Sent: Thursday, October 03, 2002 1:33 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I have a table test((NAME VARCHAR2(10),AGE
 NUMBER(2));
  
 data of the table is 
  
 NAME AGE
 ---
 ANAND  1
 BALU   2
 CHANDU3
 DAVID4
  
  
 I want a query which give me the result as
  
 NAME AGE
 ---
 ANAND  4
 BALU  3
 CHANDU   2
 DAVID   1
  
 Can any body pl. help me.
  
 Anand Kumar
 ITW Signode India Ltd
 
 


__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ASHRAF SALAYMEH
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Santosh Varma
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Indexing SYS tables

2002-10-03 Thread Jesse, Rich


I'm not so sure.  I created a DESC index, but the optimizer refused to use
it in a simple query containing an ORDER BY DESC on the indexed DATE column
without hinting, even after I analyzed it (8.1.7.4 and CBO).

Without spending too much time on it, I created a good ol' fashioned b-tree
and it works like a charm.  I just need to address the issue of Should I?

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


 -Original Message-
 From: Connor McDonald [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 03, 2002 4:29 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Indexing SYS tables
 
 
 Depends on the version I think.  Oracle has always
 allowed DESC indexes, but only in 9(?) is the keyword
 actually used in the index build.
 
 hth
 connor
 
  --- [EMAIL PROTECTED] wrote:  
  but there is a create index ... desc?
  
  ASC | DESC
   specifies whether the index should be created in
  ascending or descending
  order.
   Oracle treats descending indexes as if they were
  function-based indexes.
  You do not need the QUERY REWRITE or GLOBAL QUERY
  REWRITE privileges to
  create them, as you do with other function-based
  indexes.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Backups


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Falling off my seat ( 9i R2)

2002-10-03 Thread Cornio, Georgette Ms USACFSC



I just loaded 9.2.0 on a Win 2K yesterday,
 ran the DBCA and saw neither action.

When I checked the scripts it generated,
 it still used the standard passwords for SYS  SYSTEM.

Are your setups for WIN or UNIX/LINUX ?


-Original Message-
Sent: Thursday, October 03, 2002 05:23
To: Multiple recipients of list ORACLE-L


Throw in the fact also that most of the default
accounts are installed with their account locked...

Love it.

 --- Grant Allen [EMAIL PROTECTED] wrote:  Hi
all,
 
 Just thought I'd comment on the fact 9i R2
 dbassist-created databases
 actually prompt for SYS and SYSTEM passwords now ...
 no more
 you-know-what.
 
 This just isn't on!  You can't just go throwing in
 sensible security
 changes like that :-) :-) :-)
 
 [very big grin]
 
 Ciao
 Fuzzy
 :-)
 
 

--
 Woo Hoo! - H. Simpson

--
 The contents of this post are my opinions only
   If swallowed seek medical advice
 
 (Apologies for the excess signature)
 This email message (and attachments) may contain
 information
 confidential to TOWER Software.  If you are not the
 intended recipient
 you cannot use, distribute or copy the message or
 message attachments.
 If you are not the intended recipient, please notify
 the sender by
 return email immediately and delete all copies of
 the message and
 attachments.  Opinions, conclusions and other
 information in this
 message and attachments that do not relate to the
 official business of
 TOWER Software, are not given or endorsed by it.
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Grant Allen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

Remember amateurs built the ark - Professionals built the Titanic

__
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cornio, Georgette Ms USACFSC
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Does the case of an Oracle query ...

2002-10-03 Thread Shantanu Datta


Hi,

  Thanx everybody for the numerous inputs on the issue. It helped clear up
the basics (not just for me, but for several others who go thru the posts
regularly :-)

Cheers,
Shantanu.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shantanu Datta
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Query


Santosh,

Till now you haven't exactly specified what you want and WHY you want such a
thing. 

So I can only make a guess at what you want. If you want the age of the last
record to be shown with the name of the first record and so on, then
following is the query:

SQL SELECT * FROM test;

NAME  AGE
-- --
ANAND   1
BALU2
CHANDU  3
DAVID   4

SQL SELECT t1.name, t2.age
  2  FROM (SELECT rownum r1, name FROM test) t1
  3  , (SELECT rownum r2, age FROM test) t2
  4  WHERE t1.r1 + t2.r2 - 1 = (SELECT
  5  count(*) FROM test)
  6  /

NAME  AGE
-- --
DAVID   1
CHANDU  2
BALU3
ANAND   4

SQL I'm stupid!
SQL 
SQL You are stupid!!
unknown command beginning You are st... - rest of line ignored.

Regards
Naveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Utl_file and OPENVMS


What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no 
problem with separate entries as mentioned by Jared. However, don't keep gap 
between these entries...and define it the way it was explained by Jared.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 05:28:22 -0800

On unix, multiple entries in the init.ora file results in the last entry 
being the only valid value (i.e. last time variable is set).  I tested below 
and only dir3 is listed as a utl_file_dir parameter.  But if you comma 
delimit them w/ 1 instance of the variable then all dir's are listed.  Maybe 
NT is different, fortunately never had to support Oracle on NT :).

Gene

  [EMAIL PROTECTED] 10/02/02 07:13PM 
Gene,

  utl_file_dir = D:\directory name1
  utl_file_dir = D:\directory name2
  utl_file_dir = D:\directory name3

The multiple lines shown are actually the documented method for doing
this.

The single line with comma delimited entries may also work, though I'm
not sure about it.

Jared





Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
  10/01/2002 11:25 AM
  Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc:
 Subject:RE: Utl_file and OPENVMS


i believe its

utl_file_dir=dir1,dir2,dir3,...

in your example, dir 3 would be the only valid dir.

hth,
gene

  [EMAIL PROTECTED] 10/01/02 12:53PM 
Make sure you have the directory name entry covered in INIT.ORA

e.g.

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

You need one entry per directory that you want to write to using UTL_FILE
Package

Hope this helps

Regards

Shiva




-Original Message-
Sent: Tuesday, October 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


the vms user oracle needs rights to the directory.

  [EMAIL PROTECTED] 09/30/02 10:53AM 
List,
  I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4  and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
get the package to write the files to the OS directory.
  The package is created by the Oracle user DTSUSER and executed by
DTSUSER. There is no OPENVMS user DTSUSER.
The sysadmin assures me that the permissions are correct to write to
the directory.
I have place a Dbms_output in the package to display the directory
information and it looks correct.
  Is there anything different that has to be done to an OPENVMS server
that will allow a package to write to a directory using the Utl_File
package?


Listing from the Oracle tables:

DTS_PARAMETER_NAME DTS_PARAMETER_VALUE

-- --

LOAD_USERIDLOADITUP

LOAD_PASSWORD  ILOADIT

LOAD_SERVICE_NAME  GLC_ALPHADEV-TCP

LOAD_PAR_FILE_DIR  ORADSK:[ORACLE8.DATA.PAR]

LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles]

LOAD_CONTROL_FILE_DIR  ORADSK:[ORACLE8.DATA.CONTROL]

LOAD_LOG_FILE_DIR  ORADSK:[ORACLE8.DATA.LOG]

LOAD_BAD_FILE_DIR  ORADSK:[ORACLE8.DATA.BAD]

LOAD_DISCARD_FILE_DIR  ORADSK:[ORACLE8.DATA.DISCARD]

Listing from the package that writes the parameter file:

Procedure Create_New_Par_File

   (

P_Current_Table_Name  In  Varchar2
,

P_Run_DateIn Date,


P_Load_Userid In  Varchar2
,

P_Load_Password   In  Varchar2
,

P_Load_Service_Name   In  Varchar2
,

P_Load_Par_File_Dir   In  Varchar2
,

P_Load_Data_File_Dir  In  Varchar2
,

P_Load_Control_File_Dir   In  Varchar2  ,

P_Load_Log_File_Dir   In  Varchar2
,

P_Load_Bad_File_Dir   In  Varchar2
,

P_Load_Discard_File_Dir   In  Varchar2

   )

   as

   Begin

   Declare

L_Par_File_Hand   Utl_FIle.File_Type; -- Local
variable to
hold the File Pointer for the parameter file.



   Begin
I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE
PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT
EN TO.
  -- Open a new parameter file

  L_Par_File_Hand :=
Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w');

  -- Print the following lines into the parameter file.

  Utl_File.Put

RE: Perl::DBI problems after charset change (MORE INFO -- longish

2002-10-03 Thread Jesse, Rich


Already did -- and deftly checking the list archives I see that MS Lookout
has once again thwarted me by throwing away a reply by Tim Bunce himself.

Time to get back to tracing -- after I figure out why a listener freezes
while confirming startup on another system  sigh

Thx!

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 5:03 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Perl::DBI problems after charset change (MORE INFO --
 longish
 
 
 Rich,
 
 It's time for you to join the DBI users mailing list.  :)
 
 http://lists.perl.org/showlist.cgi?name=dbi-users
 
 Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Performance monitoring

2002-10-03 Thread Grabowy, Chris


Sort of putting on my devil's advocate hat...

- perhaps the document is old and just hasn't been updated.  A lot of the 
documentation that we have lying around is marked as 7.3, we just haven't had the time 
to update them, since were overwhelmed with real work, and can't hire additional DBAs.
- some Oracle sites still believe in the myths and ratio based tuning.  It can be 
difficult to convince a client that their long practiced tuning methodology is 
obsolete.  So for your specific case, perhaps they have dealt with these types of 
clients in the past so they tread lightly.

It will be interesting to see how the hosting company responds to your explanations.

-Original Message-
Sent: Wednesday, October 02, 2002 9:39 PM
To: Multiple recipients of list ORACLE-L


we're hiring a hosting company to manage and monitor our production
apps... they handed me their spreadsheet of Oracle things to
monitor... I finally found wait events on that list. Buffer cache hit
ratios were high on the list and flagged as critical

nuh uh, didn't have time to gently explain (with the two by four) that
that was going to be unacceptable. But I will have loads of time
tomorrow. What scares me is that this list was compiled by
experienced DBAs.

--- [EMAIL PROTECTED] wrote:
 Buffer Cache Hit Ratio?
 
 What's that?
 
 
 
 
 
 
 Inka Bezdziecka [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  10/02/2002 08:03 AM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: Performance monitoring
 
 
 Well ...
  if you need short reports, look for:
 
 1. waits
 2. buffer cache hit ratio
 3. dictionary hit ratio
 4. library hit ratio
 5. latches
 6. parsing/execution ratio
 7. data file i/o 
 8. shared pool memory distribution
 9. session contention
 10. session memory usage
 
 inka
 
 -Original Message-
 Sent: Wednesday, October 02, 2002 7:08 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Thak's Mark
 
 I agreed, but they have gotten an idea to get only couple
 most important measurements from db, because they don't want
 to have a huge reports with all possible statistics. Very 
 understandable, but as You wrote, there isn't any absolutely top ten.
 
 In any case, I have to do this (stupid) list, so give Your best shot,
 please.
 
 t.Jorma
 Ps. I heard, that Dave Ensor from BMC, has once presented that
 kind of list? 
 
 -Original Message-
 Sent: 02 October, 2002 12:23
 To: Multiple recipients of list ORACLE-L
 
 
 Jorma,
 
 Performance tuning is a complex subject.  There really isn't a list
 of
 10 things to watch for.  Every system is different.
 
 I would (attempt to) summarize tuning by these five steps:
 
 1.)  Have a capacity/performance target in mind.  If you don't know
 where you're going, how will you know if you have gotten there?
 
 2.)  Monitor your response times as load increases.  Can you achieve
 your response time target at the specified load?  If so, you're done,
 successful test, congratulations.  If not, continue to next step.
 
 3.)  Actively monitor what's going on in the database, while it's
 happening.  It's always easier to see it in real time than just
 looking
 at random StatsPack snapshots taken at 5 or 10 or 15 minute
 intervals. 
 (Not that I'm saying StatsPack shouldn't be collected.  I'm just
 saying
 don't rely on StatsPack as your only source of info about the
 database.)  The V$ Wait Interface is your friend.  If you're not
 familiar with it, go to http://www.hotsos.com/ and get Mogens
 Norgaard's
 paper, Introducing the V$ Wait Interface.  Where is the database
 spending it's time?  What's the bottleneck?  If you identify a few
 trouble sessions, you may want to dive deeper w/ some 10046 traces at
 level 8 on specific sessions.  You almost certainly do NOT want to do
 this instance wide.
 
 4.)  Once you have some indication as to what's going on in the
 database, you need to see how the system is doing overall.  On most
 flavors of *nix, where I'm comfortable, sar (System Activity
 Reporter)
 is an excellent tool.  Use it to determine if you have any systemwide
 CPU, memory, or I/O contention.  (Other OSes almost certainly have
 similar utilities.)
 
 5.)  Address the biggest bottleneck.  This is where it can't be
 summarized in a simple step.  You need to understand the bottleneck,
 so
 that you can understand how to tune it.  If may be latch contention. 
 Depending on the latch, it could be poorly tuned SQL, or lack of bind
 variables, or simple CPU capacity limits, or a whole host of things. 
 I/O contention?  Could be anything from poorly designed and/or
 configured RAID array to poorly tuned SQL, or who knows what. 
 Determine
 the cause of the biggest bottleneck and minimize or eliminate it.
 
 
 There you have it, Mark's Simplified Performance Tuning, in five easy
 steps! ;-)
 
 -Mark
 
 
 
 On Wed, 2002-10-02 at 02:08, [EMAIL PROTECTED] wrote:
  Ave !
  
  I like to

RE: Performance monitoring - mostly: further derailment

2002-10-03 Thread Inka Bezdziecka


Thank you Rachel.

Jared,
here is what I meant:

select 
   100 * (a.value + b.value - c.value)
 / (a.value + b.value)   
from v$sysstat a,
 v$sysstat b,
 v$sysstat c,
 v$sysstat d
where a.statistic# = 37 and /* db block gets */
  b.statistic# = 38 and /* consistent gets */
  c.statistic# = 39 and /* physical gets */
  d.statistic# = 40  /* physical writes  */ ; 

It had been for years the most important thing to measure - if the number was over 
80%, everyone was happy. If I remember correctly, Oracle Education Services taught it  
at the advanced level of dba courses.

If anyone remembers the beginning of this tread, the issue at hand is not how to 
measure performance, but what are the 10 metrics one can measure. After the first note 
or so, there was still a plea for the list.

To add to a discussion, which derailed from the original plea for the list: 
Good or bad performance has very little to do with ratios, numbers, importance of 
transactions (by the way: from whose point of view?)
Well performing system is such, that allows ALL supported by it business functions to 
achieve their objectives for the less possible amount of money. 
If a program, which produces monthly report for shareholders is poorly written from 
the art of programming point of view, creates a report formatted as per 
specifications, including colours, ready to be delivered on time - the system is 
performing well. Even if that program runs 5 hours except 5 minutes, as long as it is 
not in a way of anything else. Computers are expensive, useless gadgets when they are 
not working. 
In addition, managers are neither educated in technical nuances nor need to be. 
Somebody, maybe another dba, or an editor of an in-flight magazine has written 
somewhere that there are ten Oracle database parameters that should be measured. 
So, to keep all parties happy, one should produce the list, meet with users to find 
out what is not performing up to their expectations. When this is known, use both, 
common sense and the list to find out what and how can be changed. If anything, 
because many times the only acceptable to the business solution is: learn to like it.

Amen.
grandma inka

-Original Message-
Sent: Wednesday, October 02, 2002 9:39 PM
To: Multiple recipients of list ORACLE-L


we're hiring a hosting company to manage and monitor our production
apps... they handed me their spreadsheet of Oracle things to
monitor... I finally found wait events on that list. Buffer cache hit
ratios were high on the list and flagged as critical

nuh uh, didn't have time to gently explain (with the two by four) that
that was going to be unacceptable. But I will have loads of time
tomorrow. What scares me is that this list was compiled by
experienced DBAs.

--- [EMAIL PROTECTED] wrote:
 Buffer Cache Hit Ratio?
 
 What's that?
 
 
 
 
 
 
 Inka Bezdziecka [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  10/02/2002 08:03 AM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: Performance monitoring
 
 
 Well ...
  if you need short reports, look for:
 
 1. waits
 2. buffer cache hit ratio
 3. dictionary hit ratio
 4. library hit ratio
 5. latches
 6. parsing/execution ratio
 7. data file i/o 
 8. shared pool memory distribution
 9. session contention
 10. session memory usage
 
 inka
 
 -Original Message-
 Sent: Wednesday, October 02, 2002 7:08 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Thak's Mark
 
 I agreed, but they have gotten an idea to get only couple
 most important measurements from db, because they don't want
 to have a huge reports with all possible statistics. Very 
 understandable, but as You wrote, there isn't any absolutely top ten.
 
 In any case, I have to do this (stupid) list, so give Your best shot,
 please.
 
 t.Jorma
 Ps. I heard, that Dave Ensor from BMC, has once presented that
 kind of list? 
 
 -Original Message-
 Sent: 02 October, 2002 12:23
 To: Multiple recipients of list ORACLE-L
 
 
 Jorma,
 
 Performance tuning is a complex subject.  There really isn't a list
 of
 10 things to watch for.  Every system is different.
 
 I would (attempt to) summarize tuning by these five steps:
 
 1.)  Have a capacity/performance target in mind.  If you don't know
 where you're going, how will you know if you have gotten there?
 
 2.)  Monitor your response times as load increases.  Can you achieve
 your response time target at the specified load?  If so, you're done,
 successful test, congratulations.  If not, continue to next step.
 
 3.)  Actively monitor what's going on in the database, while it's
 happening.  It's always easier to see it in real time than just
 looking
 at random StatsPack snapshots taken at 5 or 10 or 15 minute
 intervals. 
 (Not that I'm saying StatsPack shouldn't be collected.  I'm just
 saying
 don't rely on StatsPack as your only source of info about

Re: FAILED_LOGIN_ATTEMPTS

2002-10-03 Thread Hemant K Chitale



I have enabled Database Session Audit [with AUDIT SESSION]

I then added a program to run every 15 minutes to identify failed login 
attempts
for some specific schemas :
connect / as sysdba

set pages60

spool autoreport_failed_APPS_logins

col os_username format a12 hea 'OS User'
col username format a12 hea 'DB User'
col userhost format a12 hea 'Host (trunc)' trunc
col terminal format a14 hea 'Term. (Incmpl)'
col timestamp format a17 hea 'TimeStamp'
col returncode format 99 hea 'OraErr'

alter session set nls_date_format ='DD-MON-HH24:MI:SS';

select os_username, username, userhost, terminal, timestamp, returncode
from sys.dba_audit_session
where returncode != 0
and os_username != 'oasapps'
and username in ('APPS','APPLSYS','APPLSYSPUB')
and timestamp  sysdate - ( (16)/(60*24) )
order by timestamp
/

spool off


At 09:23 AM 02-10-02 -0800, you wrote:

All,
I have implemented FAILED_LOGIN_ATTEMPTS in one of my database profiles -
and it works beautifully !
However - is there a way to trace or capture the incorrect password (and
machine name) that trips this counter ?
I am interested in finding out who (and from where) tried to connect
unsuccessfully.
TIA
Srini Chavali
Oracle DBA
Cummins Inc


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sql query




Santosh, 

your 
query is working. See below

SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY 
KEY, 3 NAME VARCHAR2(10) 4 
);

Table 
created.

SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY 
KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES 
CLIENT(CLIENTID) 5 );

Table 
created.

SQL insert into client values(1, 'Naveen');

1 row 
created.

SQL insert into client values(2, 'Santosh');

1 row 
created.

SQL insert into project values(1, 'Oracle', 1);

1 row 
created.

SQL insert into project values(2, 'Java', 1);

1 row 
created.

SQL insert into project values(3, 'SQL', 2);

1 row 
created.

SQL commit;

Commit 
complete.

SQL edWrote file afiedt.buf

 
1 SELECT name 2 FROM (SELECT c.name, COUNT(p.clientid) 
p_count 3 FROM client c, project p 4 WHERE 
c.clientid = p.clientid 5 GROUP BY c.name) a, 6 
(SELECT MAX(COUNT(clientid)) p_max 7 FROM project 
8 GROUP BY clientid) b 9* WHERE a.p_count = b.p_maxSQL 
/

NAME--Naveen

SQL I can run your query, then what's the problem?SQL 


Regards
Naveen

  -Original Message-From: Santosh Varma 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 03, 2002 2:53 
  PMTo: Multiple recipients of list ORACLE-LSubject: Sql 
  query
  cannot perform an aggregate function on an expression containing an
  aggregate or subquery
  is the error i am getting while i am executing the query.
  SELECT name
  FROM (SELECT c.name, COUNT(p.clientid) p_count
  FROM client c, project p
  WHERE c.clientid = p.clientid
  GROUP BY c.name) a,
  (SELECT MAX(COUNT(clientid)) p_max
  FROM project
  GROUP BY clientid) b
  WHERE a.p_count = b.p_max
  clientid and name are the columns in client table
  and projectid and clientid are the columns in project table.
  santosh
  -Original Message-
  Ignaszak
  Sent: Monday, September 30, 2002 6:09 PM
  To: Multiple recipients of list ORACLE-L
  
  try it:
  select
  name
  from
  (select c.name, count(p.id) p_count from clients c, projects p
  where c.id = p.cl_id
  group by c.name) a,
  (select max(count(id)) p_max from projects
  group by cl_id) b
  where a.p_count = b.p_max
  Regards,
  Leszek
  At 03:23 2002-09-30 -0800, you wrote:
  Hello all,
  
   I have a query -
  i have 2 tables - client and project
  
  fields in project table - clientid/projectid
  fields in client table - clientid/name
  
  i want to get the maximum orders one client has got. i mean a 
  project
  having the greatest clients
  how to write it in single query ??
  
  
  like
  project 1 client 1
  project 2 client 1
  project 3 client 2
  
  in the above case, the query should return client ( 1 ).
  
  Thanks and regards,
  Santosh
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Leszek Ignaszak
  INET: [EMAIL PROTECTED]
  Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  San Diego, California -- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from). You may
  also send the HELP command for other information (like subscribing).
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Santosh Varma
  INET: [EMAIL PROTECTED]
  Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  San Diego, California -- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from). You may
  also send the HELP command for other information (like 
subscribing).

exp/imp bug - Note:199416.1

2002-10-03 Thread Jeffrey Beckstrom




Has anybody put on the patch to resolve this. On Nt, looks like fixed 
in 8.1.7.4.5. However, searching on the bug 2410612 reveals two other 
corruption bugs that appear unresolved.

Have people put this patch on or waiting for a complete resolution.

Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204

OT: Why do I receive the mails late?


I receive the mails of this late after a long delay approx 1-2 hours. Is this
common?

Sometimes i get the reply first and then i get the question

Regards
Naveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Falling off my seat ( 9i R2)


In 9i all accounts are created as locked except sys, system and scott.
For sys and system password is required to be defined at creation time as  
change_on_install or manager are not created as default. In essence all 
accounts has to be unlocked to make them operational

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 03:13:21 -0800

not only that but most of the sensitive accounts are created LOCKED and
you actually have to unlock them to make them work.

Geez, they are asking us to THINK

Rachel

--- Grant Allen [EMAIL PROTECTED] wrote:
  Hi all,
 
  Just thought I'd comment on the fact 9i R2 dbassist-created databases
  actually prompt for SYS and SYSTEM passwords now ... no more
  you-know-what.
 
  This just isn't on!  You can't just go throwing in sensible security
  changes like that :-) :-) :-)
 
  [very big grin]
 
  Ciao
  Fuzzy
  :-)
 
 
 
--
  Woo Hoo! - H. Simpson
 
--
  The contents of this post are my opinions only
If swallowed seek medical advice
 
  (Apologies for the excess signature)
  This email message (and attachments) may contain information
  confidential to TOWER Software.  If you are not the intended
  recipient
  you cannot use, distribute or copy the message or message
  attachments.
  If you are not the intended recipient, please notify the sender by
  return email immediately and delete all copies of the message and
  attachments.  Opinions, conclusions and other information in this
  message and attachments that do not relate to the official business
  of
  TOWER Software, are not given or endorsed by it.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Grant Allen
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Backups


I disagree. ALTER TABLESPACE tblsp_name BEGIN BACKUP, and you can copy the
datafiles of that tablespace using OS commands and use them for restore

Regards
Naveen

-Original Message-
Sent: Thursday, October 03, 2002 7:48 PM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Utl_file and OPENVMS


What does your utl_file_dir parameter look like in your init.ora?  I am using AIX.

 [EMAIL PROTECTED] 10/03/02 11:43AM 
What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no 
problem with separate entries as mentioned by Jared. However, don't keep gap 
between these entries...and define it the way it was explained by Jared.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 05:28:22 -0800

On unix, multiple entries in the init.ora file results in the last entry 
being the only valid value (i.e. last time variable is set).  I tested below 
and only dir3 is listed as a utl_file_dir parameter.  But if you comma 
delimit them w/ 1 instance of the variable then all dir's are listed.  Maybe 
NT is different, fortunately never had to support Oracle on NT :).

Gene

  [EMAIL PROTECTED] 10/02/02 07:13PM 
Gene,

  utl_file_dir = D:\directory name1
  utl_file_dir = D:\directory name2
  utl_file_dir = D:\directory name3

The multiple lines shown are actually the documented method for doing
this.

The single line with comma delimited entries may also work, though I'm
not sure about it.

Jared





Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] 
  10/01/2002 11:25 AM
  Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc:
 Subject:RE: Utl_file and OPENVMS


i believe its

utl_file_dir=dir1,dir2,dir3,...

in your example, dir 3 would be the only valid dir.

hth,
gene

  [EMAIL PROTECTED] 10/01/02 12:53PM 
Make sure you have the directory name entry covered in INIT.ORA

e.g.

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

You need one entry per directory that you want to write to using UTL_FILE
Package

Hope this helps

Regards

Shiva




-Original Message-
Sent: Tuesday, October 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


the vms user oracle needs rights to the directory.

  [EMAIL PROTECTED] 09/30/02 10:53AM 
List,
  I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4  and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
get the package to write the files to the OS directory.
  The package is created by the Oracle user DTSUSER and executed by
DTSUSER. There is no OPENVMS user DTSUSER.
The sysadmin assures me that the permissions are correct to write to
the directory.
I have place a Dbms_output in the package to display the directory
information and it looks correct.
  Is there anything different that has to be done to an OPENVMS server
that will allow a package to write to a directory using the Utl_File
package?


Listing from the Oracle tables:

DTS_PARAMETER_NAME DTS_PARAMETER_VALUE

-- --

LOAD_USERIDLOADITUP

LOAD_PASSWORD  ILOADIT

LOAD_SERVICE_NAME  GLC_ALPHADEV-TCP

LOAD_PAR_FILE_DIR  ORADSK:[ORACLE8.DATA.PAR]

LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles]

LOAD_CONTROL_FILE_DIR  ORADSK:[ORACLE8.DATA.CONTROL]

LOAD_LOG_FILE_DIR  ORADSK:[ORACLE8.DATA.LOG]

LOAD_BAD_FILE_DIR  ORADSK:[ORACLE8.DATA.BAD]

LOAD_DISCARD_FILE_DIR  ORADSK:[ORACLE8.DATA.DISCARD]

Listing from the package that writes the parameter file:

Procedure Create_New_Par_File

   (

P_Current_Table_Name  In  Varchar2
,

P_Run_DateIn Date,


P_Load_Userid In  Varchar2
,

P_Load_Password   In  Varchar2
,

P_Load_Service_Name   In  Varchar2
,

P_Load_Par_File_Dir   In  Varchar2
,

P_Load_Data_File_Dir  In  Varchar2
,

P_Load_Control_File_Dir   In  Varchar2  ,

P_Load_Log_File_Dir   In  Varchar2
,

P_Load_Bad_File_Dir   In  Varchar2
,

P_Load_Discard_File_Dir   In  Varchar2

   )

   as

   Begin

   Declare

L_Par_File_Hand   Utl_FIle.File_Type; -- Local
variable to
hold the File Pointer for the parameter file.



   Begin
I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE
PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT
EN TO.
  -- Open a new parameter file

  L_Par_File_Hand :=
Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w');

  -- Print the

RE: svrmgrl echo v$database in script

2002-10-03 Thread Scott . Shafer


echo $ORACLE_SID  logfile

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 6:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl echo v$database in script
 
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database.  I REALLY want to echo the name of the database into my log file
 before I shut down.While select name from v$database works fine from
 svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
 is
 screwing it up.  (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 Any ideas?
 
 Thx!!!
 
 Barb
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author:   Barb Baker
 # Purpose:  execute shutdown immediate on current database
 #   (i.e., database pointed to by current value of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\  at `date` 
${ORACLE_HOME}/bin/svrmgrl  EOF
connect internal
select name from v_$database;
 EOF
 
 
 $  ./stop_db.sh
 Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGRselect name from v_
   *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Baker, Barbara
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Restrict certain database access using 3rd party tools.

2002-10-03 Thread paquette stephane


In homemade applications, by default users have a role
with read only, in the applications we change the
default role that allows insert, update, delete.

I've not tested this scenario but how about if, in a
database logon trigger, you check the
v$process.program field then depending of that value
you may be able to change the user default's role.

Should work on 8i using dedicated connection.


 --- [EMAIL PROTECTED] a écrit :  Hi All,
 
 We have users that have OPS$ accounts that have full
 DML privs when they
 run forms application via citrix. Currently they do
 not have sqlplus,etc.  There is a requirement that
 some can have
 sqlplus,toad,etc.  I know you can set up security
 for sqlplus,etc
 using product_user_profile but is there a way to
 allow only SELECT when
 using a 3rd party tool such as TOAD.
 
 Thanks
 Rick
 
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why do I receive the mails late?

2002-10-03 Thread John . Hallas


I have raised this before and never seen a good explanation.
It is very frustrating to see a reply to a post prior to the post appearing.

What is even more frustrating is when you hit the send button and realise
you have made a mistake or mistyped something.
There is no way of withdrawing it and you still have 2 hours before you see
it on the list

John
-Original Message-
Sent: 03 October 2002 16:59
To: Multiple recipients of list ORACLE-L


I receive the mails of this late after a long delay approx 1-2 hours. Is
this
common?

Sometimes i get the reply first and then i get the question

Regards
Naveen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sample Pro*C code for TAF in 8iOPS/9iRAC

2002-10-03 Thread Hemant K Chitale



Actually, we are aware about TAF setup in the TNSNAMES.ORA
SQLPlus sessions fail-over perfectly well with the TNSNAMES.ORA
file.
It is our custom Pro*C programs [originally written against 8.1.5]
that
don't seem to be handling failover when it is doing DML.
Quoting from the 9iRAC Concepts Manual, Chapter 10, the
paragraphs titled Database Manipulation Language Clients
under the
section Uses of Transparent Application Failover :

Database Manipulation Language (DML)
database clients perform INSERT, UPDATE, and DELETE operations. Oracle
handles certain errors and performs a reconnect when those errors
occur.
Without this application code, INSERT, UPDATE, and DELETE operations on
the failed instance return an un-handled Oracle error code. Upon
re-submission, Oracle routes the client connections to a surviving
instance. The client transaction then stops only momentarily until
server-side recovery completes.
we doubt if the custom-built Pro*c programs are able to
handle the Oracle error code and re-submit the last DML which
was in flight
and the section Transparent Application Failover Restrictions
:

When a connection fails, you might
experience the following:
·All PL/SQL
package states on the server are lost at failover 
·ALTER SESSION
statements are lost 
·If failover
occurs when a transaction is in progress, then each subsequent call
causes an error message until the user issues an OCITransRollback call.
Then Oracle issues an Oracle Call Interface (OCI) success message. Be
sure to check this message to see if you must perform additional
operations. 
·Oracle fails
over the database connection and if TYPE=SELECT in the FAILOVER_MODE
section of the service name description, Oracle also attempts to fail
over the query 
·Continuing work
on failed-over cursors can result in an error message 
If the first command after failover is not a SQL SELECT or OCIStmtFetch
statement, then an error message results. Failover only takes effect if
the application is programmed with OCI release 8.0 or greater.

again we doubt if the programs are handling the error message,
issuing an OCITransRollback or a SQL SELECT.
My developers are now trying to include code to look for an error
message and/or reissue an SQL SELECT.
What I was looking for was some sample Pro*C programs or templates.
I have provided the cdemofo.c program from $O_H/rdbms/demo to
my
developer but that isn't very helpful.
Hemant
At 08:08 PM 02-10-02 -0800, you wrote:
Only in the sense that you must use
tools that use OCI, such as OCI itself,
Pro*Precompilers, SQLJ, and JDBC OCI drivers. APIs that do not use
OCI (and
thus can't use TAF) include JDBC Thin drivers...
You can use the TNS entry I sent in my email from SQL*Plus to
failover
between two instances in 8i OPS, 9i RAC, and certain flavors of 9i
Data
Guard. You don't need to program in OCI, just use an OCI-based
network
driver...
The distinction I was making was that in Oracle8 v8.0, you had to
actually
program the failover code in C code in OCI only...
- Original Message -
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 8:29 PM

 Tim, TAF still requires the application to be
 programmed with Oracle8 OCI and greater. TAF is a
 combination of OCI and net services to allow the
 failover to occur. This requirement is still
 documented in the Oracle9i R2 manuals.


http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/rac.920/a9
6597/pshavdtl.htm#20180

 Scott

 --- Tim Gorman lt;[EMAIL PROTECTED]gt; wrote:
 gt; Hemant,
 gt;
 gt; TAF was specific to OCI only in v8.0 of the
 gt; database. In v8.1 and upwards, it is specified
 for
 gt; any application or API in the TNSNAMES entry...
 gt;
 gt; This example comes straight out of the
 #34;Oracle Net8
 gt; Administration#34; manual, page 8-14. I'd
 suggest
 gt; reading up on the meaning of the FAILOVER_MODE
 gt; settings, specifically TYPE= and METHOD=. Also,
 if
 gt; you have your OPS/RAC instances in a pure
 gt; #34;active/passive#34; arrangement, then 
the
 TNS entry
 gt; below should work (i.e. LOAD_BALANCE=OFF). If
 you
 gt; have both instances equally available for user
 gt; connections (i.e. #34;active/active#34;
 failover
 gt; arrangement), then you might consider changing
 gt; LOAD_BALANCE=ON to distribute the connections
 gt; randomly. However, you'll want to think
 carefully
 gt; about using that mechanism... :-)
 gt;
 gt; sales.us.acme.com=
 gt; (description=
 gt;
(load_balance=off)
 gt;
(failover=on)
 gt;
(address_list=

gt;
(address=

gt;
(protocol=tcp)

gt;
(host=sales1-server)

gt;
(port=1521)

gt;
)

gt;
(address=

gt;
(protocol=tcp)

gt;
(host=sales2-server)

gt;
(port=1521)

gt;
)
 gt;
)
 gt;
(connect_data=

gt;
(service_name = sales.us.acme.com)

gt;
(failover_mode =
 gt; (type=select)(method=basic))
 gt;
)
 gt; )
 gt; Hope this helps...
 gt;
 gt; -Tim
 gt;
 gt; - Original Message -
 gt; To: #34;Multiple recipients of list
 ORACLE-L#34;
 gt; lt;[EMAIL PROTECTED]gt;
 gt; Sent: Wednesday,

Upgrade from 10.7 to 11.5.7


Hi All

What shall be the best path for moving Oracle Financials 10.7 Char with 
manufacturing/Bill of material Oracle ver 7.3.4.5 under HP-UX 11 to Oracle 
Financials with 11.5.7 with Manufacturing/Bill of material Oracle 8.1.7.4 
under HP-UX 11.11

1) either to upgrade to 8.1.7 with sever partioning/applying patches to 
bring it for upgrade for 11.5.7

or

2) straight upgrade from Oracle Financials 10.7 (7.3.4.5) to 11.5.7(8.1.7.4)

Any gotchas/advise/most relevant/estimated time for database size 80G  etc.

We have all access to Oracle resources but want to learn from expert on this 
list ...

TIA,

Regards
Rafiq



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Backups

2002-10-03 Thread John Weatherman


This doesn't sound right.  Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode.  Why wouldn't you be able to recover? 

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OT: Why do I receive the mails late?

2002-10-03 Thread ltiu


Yes. This is very normal for me as well.

Naveen Nahata wrote:
 I receive the mails of this late after a long delay approx 1-2 hours. Is this
 common?
 
 Sometimes i get the reply first and then i get the question
 
 Regards
 Naveen


-- 
ltiu
OCP 9i DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: 8.1.7 patch it up?


IMHO, If it ain't broke don't fix it!  I know some of the patch releases introduced 
new problems.  I am  at 8.1.7.0 and all is fine for 21 databases.  Soon, I wil upgrade 
to 9iR2 using RMAN.  I believe RMAN has improved some for 9iR2.

Gene

 [EMAIL PROTECTED] 10/03/02 10:03AM 
I'm administering a number of production databases (mixture of standard and
enterprise editions) most of which are version 8.1.7.0.0 on Windows NT and
2000.  All are functioning fine and I have no issues. 

I'm considering patching (to 8.1.7.4) some if not all databases and just
want to know if this is an absolute must if all systems are currently
running fine.   In other words does if its not broken, don't fix it apply?


Also, I'm considering implementing RMAN in the near future and am wondering
if there are significant issues with this on the unpatched 8.1.7 database. 

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: O'Neill, Sean
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Restrict certain database access using 3rd party tools.

2002-10-03 Thread Kevin Lange


Except for the fact that they could always change the program name that they
are running to match what you need.   Then that security is bypassed.



-Original Message-
Sent: Thursday, October 03, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L


In homemade applications, by default users have a role
with read only, in the applications we change the
default role that allows insert, update, delete.

I've not tested this scenario but how about if, in a
database logon trigger, you check the
v$process.program field then depending of that value
you may be able to change the user default's role.

Should work on 8i using dedicated connection.


 --- [EMAIL PROTECTED] a écrit :  Hi All,
 
 We have users that have OPS$ accounts that have full
 DML privs when they
 run forms application via citrix. Currently they do
 not have sqlplus,etc.  There is a requirement that
 some can have
 sqlplus,toad,etc.  I know you can set up security
 for sqlplus,etc
 using product_user_profile but is there a way to
 allow only SELECT when
 using a 3rd party tool such as TOAD.
 
 Thanks
 Rick
 
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Utl_file and OPENVMS


Like these

utl_file_dir=/u327/applmgr/10_7/finprod_output/hfs_data
utl_file_dir=/u327/applmgr/10_7/har/1.0.0/mm_cbdata

and these are the last entries in initSID.ora file.

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 07:58:38 -0800

What does your utl_file_dir parameter look like in your init.ora?  I am 
using AIX.

  [EMAIL PROTECTED] 10/03/02 11:43AM 
What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no
problem with separate entries as mentioned by Jared. However, don't keep gap
between these entries...and define it the way it was explained by Jared.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 05:28:22 -0800

On unix, multiple entries in the init.ora file results in the last entry
being the only valid value (i.e. last time variable is set).  I tested below
and only dir3 is listed as a utl_file_dir parameter.  But if you comma
delimit them w/ 1 instance of the variable then all dir's are listed.  Maybe
NT is different, fortunately never had to support Oracle on NT :).

Gene

   [EMAIL PROTECTED] 10/02/02 07:13PM 
Gene,

   utl_file_dir = D:\directory name1
   utl_file_dir = D:\directory name2
   utl_file_dir = D:\directory name3

The multiple lines shown are actually the documented method for doing
this.

The single line with comma delimited entries may also work, though I'm
not sure about it.

Jared





Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
   10/01/2002 11:25 AM
   Please respond to ORACLE-L


  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
  cc:
  Subject:RE: Utl_file and OPENVMS


i believe its

utl_file_dir=dir1,dir2,dir3,...

in your example, dir 3 would be the only valid dir.

hth,
gene

   [EMAIL PROTECTED] 10/01/02 12:53PM 
Make sure you have the directory name entry covered in INIT.ORA

e.g.

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

You need one entry per directory that you want to write to using UTL_FILE
Package

Hope this helps

Regards

Shiva




-Original Message-
Sent: Tuesday, October 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


the vms user oracle needs rights to the directory.

   [EMAIL PROTECTED] 09/30/02 10:53AM 
List,
   I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4  and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
get the package to write the files to the OS directory.
   The package is created by the Oracle user DTSUSER and executed by
DTSUSER. There is no OPENVMS user DTSUSER.
The sysadmin assures me that the permissions are correct to write to
the directory.
I have place a Dbms_output in the package to display the directory
information and it looks correct.
   Is there anything different that has to be done to an OPENVMS server
that will allow a package to write to a directory using the Utl_File
package?


Listing from the Oracle tables:

DTS_PARAMETER_NAME DTS_PARAMETER_VALUE

-- --

LOAD_USERIDLOADITUP

LOAD_PASSWORD  ILOADIT

LOAD_SERVICE_NAME  GLC_ALPHADEV-TCP

LOAD_PAR_FILE_DIR  ORADSK:[ORACLE8.DATA.PAR]

LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles]

LOAD_CONTROL_FILE_DIR  ORADSK:[ORACLE8.DATA.CONTROL]

LOAD_LOG_FILE_DIR  ORADSK:[ORACLE8.DATA.LOG]

LOAD_BAD_FILE_DIR  ORADSK:[ORACLE8.DATA.BAD]

LOAD_DISCARD_FILE_DIR  ORADSK:[ORACLE8.DATA.DISCARD]

Listing from the package that writes the parameter file:

Procedure Create_New_Par_File

(

 P_Current_Table_Name  In  Varchar2
,

 P_Run_DateIn Date,


 P_Load_Userid In  Varchar2
,

 P_Load_Password   In  Varchar2
,

 P_Load_Service_Name   In  Varchar2
,

 P_Load_Par_File_Dir   In  Varchar2
,

 P_Load_Data_File_Dir  In  Varchar2
,

 P_Load_Control_File_Dir   In  Varchar2  ,

 P_Load_Log_File_Dir   In  Varchar2
,

 P_Load_Bad_File_Dir   In  Varchar2
,

 P_Load_Discard_File_Dir   In  Varchar2

)

as

Begin

Declare

 L_Par_File_Hand   Utl_FIle.File_Type; -- Local
variable to
hold the File Pointer for

RE: Restrict certain database access using 3rd party tools.

2002-10-03 Thread Jamadagni, Rajendra

Title: RE: Restrict certain database access using 3rd party tools.





From the TOAD help file ...


Although TOAD is intended as a developer's tool, TOAD can be made read-only via the two license files that come with TOAD, READONLY.LIC and FULLTOAD.LIC.

TOAD.EXE only reads TOAD.LIC to determine if it is full TOAD or read-only. The license file contains a setting for read-only database access. The network administrator can copy READONLY.LIC over the TOAD.LIC on an individual workstation to make TOAD read-only at that workstation.

Remember, the TOAD.LIC file must be in the TOAD folder.


Quest Software


Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art!



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Subject: Restrict certain database access using 3rd party tools.



Hi All,


We have users that have OPS$ accounts that have full DML privs when they
run forms application via citrix. Currently they do
not have sqlplus,etc. There is a requirement that some can have
sqlplus,toad,etc. I know you can set up security for sqlplus,etc
using product_user_profile but is there a way to allow only SELECT when
using a 3rd party tool such as TOAD.


Thanks
Rick




This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney 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 corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Failed to archive log....

2002-10-03 Thread Steve McClure


When I see this happening at our site it simply means that ARCx is free to
work and looking for something to archive.  It grabs the oldest unarchived
file, only to discover that ARCy is in the midst of recovering that same
fileso it fails.  So the message is a bit misleading.  This happens at
our site when someone does a huge data load without telling me.  We have an
offsite standby database connected across a 512k DSL line.  So if a sizable
dataload occurs without me setting the standby archive destination to
defer, all our logs get tied up and we have 10 archivers simultaneously
transmitting across the 512k pipe.  So even if I am not made aware of a
dataload, I find out about it soon enough.

-Original Message-
Rafiq
Sent: Wednesday, October 02, 2002 7:28 PM
To: Multiple recipients of list ORACLE-L


There were lot of delete/update/insert at that time on your database and
your archiving was too much at that time...
also try to use separate disk/mount time for your arch destination to avoid
write contention at that time

Regards
Rafiq



Indicator

to increase size of your redologs or add some more group members


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 02 Oct 2002 16:58:22 -0800

Hi all,

I just wanted a little insight on the following entries of my alert log
file;

---
ARC0: Beginning to archive log# 3 seq# 51809
ARC0: Failed to archive log# 3 seq# 51809
Tue Oct 01 09:32:37 2002
ARC4: Beginning to archive log# 3 seq# 51809
ARC4: Failed to archive log# 3 seq# 51809
ARC4: Beginning to archive log# 4 seq# 51810
Tue Oct 01 09:32:37 2002
ARC0: Beginning to archive log# 4 seq# 51810
ARC0: Failed to archive log# 4 seq# 51810
Tue Oct 01 09:32:40 2002
Completed checkpoint up to RBA [0xca62.2.10], SCN: 0x.02bfbd05
Tue Oct 01 09:32:41 2002
ARC3: Completed archiving log# 3 seq# 51809

---
ARC0 failed to archive log seq#51809 at first, then ARC4 tried to archive
the same log seq# and it failed again but then the same archiver process
(ARC4) started archiving next seq# and failed again. After a few seconds
ARC0 successfully archives 51809. Similarly rest of the seq# get archived to
after a few tries by one archiver or the other. This behavior is not
regular, it appears off and on, most of the times there is no failing, and
everything proceeds normally.
I was wondering if any of you can explain the following points to help
improve my concepts,

* Is FAILING temporarily any threat?
* What could be the reason for it?
* If the first archiver fails (ARC0) and then the second (ARC4) fails too,
why does it try to archive the next seq# rather than finishing the previous
one?
* Any reason for this inconsistency?

Thanks  Regards,
Hussain Ahmed Qadri
DBA
SKMCHRC





_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Performance monitoring

2002-10-03 Thread Rachel Carmichael


they haven't been around as a company all that long so I doubt the doc
is from 7.3

as for the methodology, I've talked to their DBAs and they are forward
thinking, which is why the doc suprised me


--- Grabowy, Chris [EMAIL PROTECTED] wrote:
 Sort of putting on my devil's advocate hat...
 
 - perhaps the document is old and just hasn't been updated.  A lot
 of the documentation that we have lying around is marked as 7.3, we
 just haven't had the time to update them, since were overwhelmed with
 real work, and can't hire additional DBAs.
 - some Oracle sites still believe in the myths and ratio based
 tuning.  It can be difficult to convince a client that their long
 practiced tuning methodology is obsolete.  So for your specific
 case, perhaps they have dealt with these types of clients in the past
 so they tread lightly.
 
 It will be interesting to see how the hosting company responds to
 your explanations.
 
 -Original Message-
 Sent: Wednesday, October 02, 2002 9:39 PM
 To: Multiple recipients of list ORACLE-L
 
 
 we're hiring a hosting company to manage and monitor our production
 apps... they handed me their spreadsheet of Oracle things to
 monitor... I finally found wait events on that list. Buffer cache
 hit
 ratios were high on the list and flagged as critical
 
 nuh uh, didn't have time to gently explain (with the two by four)
 that
 that was going to be unacceptable. But I will have loads of time
 tomorrow. What scares me is that this list was compiled by
 experienced DBAs.
 
 --- [EMAIL PROTECTED] wrote:
  Buffer Cache Hit Ratio?
  
  What's that?
  
  
  
  
  
  
  Inka Bezdziecka [EMAIL PROTECTED]
  Sent by: [EMAIL PROTECTED]
   10/02/2002 08:03 AM
   Please respond to ORACLE-L
  
   
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  cc: 
  Subject:RE: Performance monitoring
  
  
  Well ...
   if you need short reports, look for:
  
  1. waits
  2. buffer cache hit ratio
  3. dictionary hit ratio
  4. library hit ratio
  5. latches
  6. parsing/execution ratio
  7. data file i/o 
  8. shared pool memory distribution
  9. session contention
  10. session memory usage
  
  inka
  
  -Original Message-
  Sent: Wednesday, October 02, 2002 7:08 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Thak's Mark
  
  I agreed, but they have gotten an idea to get only couple
  most important measurements from db, because they don't want
  to have a huge reports with all possible statistics. Very 
  understandable, but as You wrote, there isn't any absolutely top
 ten.
  
  In any case, I have to do this (stupid) list, so give Your best
 shot,
  please.
  
  t.Jorma
  Ps. I heard, that Dave Ensor from BMC, has once presented that
  kind of list? 
  
  -Original Message-
  Sent: 02 October, 2002 12:23
  To: Multiple recipients of list ORACLE-L
  
  
  Jorma,
  
  Performance tuning is a complex subject.  There really isn't a list
  of
  10 things to watch for.  Every system is different.
  
  I would (attempt to) summarize tuning by these five steps:
  
  1.)  Have a capacity/performance target in mind.  If you don't know
  where you're going, how will you know if you have gotten there?
  
  2.)  Monitor your response times as load increases.  Can you
 achieve
  your response time target at the specified load?  If so, you're
 done,
  successful test, congratulations.  If not, continue to next step.
  
  3.)  Actively monitor what's going on in the database, while it's
  happening.  It's always easier to see it in real time than just
  looking
  at random StatsPack snapshots taken at 5 or 10 or 15 minute
  intervals. 
  (Not that I'm saying StatsPack shouldn't be collected.  I'm just
  saying
  don't rely on StatsPack as your only source of info about the
  database.)  The V$ Wait Interface is your friend.  If you're not
  familiar with it, go to http://www.hotsos.com/ and get Mogens
  Norgaard's
  paper, Introducing the V$ Wait Interface.  Where is the database
  spending it's time?  What's the bottleneck?  If you identify a few
  trouble sessions, you may want to dive deeper w/ some 10046 traces
 at
  level 8 on specific sessions.  You almost certainly do NOT want to
 do
  this instance wide.
  
  4.)  Once you have some indication as to what's going on in the
  database, you need to see how the system is doing overall.  On most
  flavors of *nix, where I'm comfortable, sar (System Activity
  Reporter)
  is an excellent tool.  Use it to determine if you have any
 systemwide
  CPU, memory, or I/O contention.  (Other OSes almost certainly have
  similar utilities.)
  
  5.)  Address the biggest bottleneck.  This is where it can't be
  summarized in a simple step.  You need to understand the
 bottleneck,
  so
  that you can understand how to tune it.  If may be latch
 contention. 
  Depending on the latch, it could be poorly tuned SQL, or lack of
 bind
  variables, or simple CPU capacity limits, or a whole host of

RE: Why do I receive the mails late?

2002-10-03 Thread Farnsworth, Dave


It must be that 386 mail server that is the bottleneck.  Or it's the perl program 
handling the mail that has the
SLEEP(7200);
line of code in it.

;o)

Dave

-Original Message-
Sent: Thursday, October 03, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L


I have raised this before and never seen a good explanation.
It is very frustrating to see a reply to a post prior to the post appearing.

What is even more frustrating is when you hit the send button and realise
you have made a mistake or mistyped something.
There is no way of withdrawing it and you still have 2 hours before you see
it on the list

John
-Original Message-
Sent: 03 October 2002 16:59
To: Multiple recipients of list ORACLE-L


I receive the mails of this late after a long delay approx 1-2 hours. Is
this
common?

Sometimes i get the reply first and then i get the question

Regards
Naveen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: logon trigger

2002-10-03 Thread Ron Thomas



FWIW, do not place the terminating semicolon in the execute string, ie,

begin
  execute immediate 'Alter session set OPTIMIZER_MODE = choose' ;
end ;
/



Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


   

  [EMAIL PROTECTED] 

   To:   [EMAIL PROTECTED]  

  10/03/02 02:43 AMcc: 

  Please respond toSubject:  RE: logon trigger 

  ORACLE-L 

   

   





Hi all





Ok if I execute these commands/SQL in sqlplus it works. When I add to the trigger for 
after logon it
does not work.





I get the feeling it is only valid for the current block, begin -  End.





Any ideas to work around this.





grant alter session to smload;





drop trigger olap_logon_trigger;


create or replace trigger olapl_logon_trigger


  after logon on smload.schema


begin


  execute immediate 'Alter session enable parallel query;';


  execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;';


   execute immediate 'Alter session set OPTIMIZER_MODE = choose;';


   execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';


   execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;';


end;


/





George





George Leonard


Oracle Database Administrator


Dimension Data (Pty) Ltd


(Reg. No. 1987/006597/07)


Tel: (+27 11) 575 0573


Fax: (+27 11) 576 0573


E-mail:[EMAIL PROTECTED]


Web:   http://www.didata.co.za





You Have The Obligation to Inform One Honestly of the risk, And As a Person


You Are Committed to Educate Yourself to the Total Risk In Any Activity!


Once Informed  Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure 
Themselves as
They See Fit!


  -Original Message-
  From: George Leonard (ZA) [mailto:[EMAIL PROTECTED]]
  Sent: 03 October 2002 09:03 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: logon trigger





  Thx, I also found this last night.





  I will wait for the developers so arrive so that they can test their process.





  George


  


  George Leonard


  Oracle Database Administrator


  Dimension Data (Pty) Ltd


  (Reg. No. 1987/006597/07)


  Tel: (+27 11) 575 0573


  Fax: (+27 11) 576 0573


  E-mail:[EMAIL PROTECTED]


  Web:   http://www.didata.co.za





  You Have The Obligation to Inform One Honestly of the risk, And As a Person


  You Are Committed to Educate Yourself to the Total Risk In Any Activity!


  Once Informed  Totally Aware of the Risk, Every Fool Has the Right to Kill or 
Injure
  Themselves as They See Fit!


-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
Sent: 02 October 2002 19:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: logon trigger





Altering current_schema, you will not see anything in user_tables, but 
you should be
able to reference tables in this new schema without using siebel prefix.





Igor Neyman, OCP DBA
[EMAIL PROTECTED]

 - Original Message -


 From: George Leonard (ZA)


 To: Multiple recipients of list ORACLE-L


 Sent: Wednesday, October 02, 2002 12:18 PM


 Subject: RE: logon trigger





 Hi all





 Ok the trigger has been changed to this, It compiles.





 The problem now is that all the objects that need to be access is owner 
by the siebel
 user. I do not want to create synonyms. The tool being used can not 
append the siebel
 schema name in front of the objects, and it is expecting to log in as 
siebel.





 Any idea why the 'Alter session set CURRENT_SCHEMA = SIEBEL;' is not 
changing my
 current schema. I have tried executing Alter session set CURRENT_SCHEMA = 
SIEBEL; in a
 standard sqlplus window and then looking at the user_tables table and it

RE: svrmgrl echo v$database in script

2002-10-03 Thread Rachel Carmichael


If fyou want to do it from within a script, you either need to code the
select into a .sql file that you run OR you need to escape the $ with
a \ in your ksh script


--- [EMAIL PROTECTED] wrote:
 echo $ORACLE_SID  logfile
 
 Scott Shafer
 San Antonio, TX
 210.581.6217
 
 
  -Original Message-
  From:   Baker, Barbara [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, October 02, 2002 6:28 PM
  To: Multiple recipients of list ORACLE-L
  Subject:svrmgrl echo v$database in script
  
  
  Oracle 8.0.5
  Solaris 2.6
  
  List:
  I've created a script (ksh) called from elsewhere that shuts down
 the
  database.  I REALLY want to echo the name of the database into my
 log file
  before I shut down.While select name from v$database works
 fine from
  svrmgrl interactively, it throws up in the script.  I'd guess the $
 sign
  is
  screwing it up.  (I can get other commands to work within the
 script.)
  However, I don't know what to do about it.
  
  Any ideas?
  
  Thx!!!
  
  Barb
  
  $ svrmgrl
  
  SVRMGR connect internal
  Connected.
  SVRMGR select name from v$database;
  NAME
  -
  TADENT
  1 row selected.
  
  
  #!/usr/bin/ksh
  # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
  # Name: stop_db.sh
  # Author:   Barb Baker
  # Purpose:  execute shutdown immediate on current database
  #   (i.e., database pointed to by current value of
 ORACLE_SID)
  
  echo Stop oracle instance \${ORACLE_SID}\  at `date` 
 ${ORACLE_HOME}/bin/svrmgrl  EOF
 connect internal
 select name from v_$database;
  EOF
  
  
  $  ./stop_db.sh
  Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
  
  
  SVRMGR Connected.
  SVRMGRselect name from v_
*
  ORA-00942: table or view does not exist
  SVRMGR
  Server Manager complete.
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Baker, Barbara
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
 services
 
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: svrmgrl echo v$database in script

2002-10-03 Thread Robertson Lee - lerobe


Hi,

This works

#!/bin/ksh
export ORACLE_SID=ADW
export ORACLE_HOME=/usr/app/oracle/product/8.0.5
export PATH=$ORACLE_HOME/bin:$PATH

svrmgrl EOF
connect internal
select name from v_\$database;
exit

EOF

Just escape the $ sign with a backslash.

HTH

Lee

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 16:43
To: Multiple recipients of list ORACLE-L


echo $ORACLE_SID  logfile

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 6:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl echo v$database in script
 
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database.  I REALLY want to echo the name of the database into my log file
 before I shut down.While select name from v$database works fine from
 svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
 is
 screwing it up.  (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 Any ideas?
 
 Thx!!!
 
 Barb
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author:   Barb Baker
 # Purpose:  execute shutdown immediate on current database
 #   (i.e., database pointed to by current value of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\  at `date` 
${ORACLE_HOME}/bin/svrmgrl  EOF
connect internal
select name from v_$database;
 EOF
 
 
 $  ./stop_db.sh
 Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGRselect name from v_
   *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Baker, Barbara
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




**
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT: Why do I receive the mails late?

2002-10-03 Thread Vergara, Michael (TEM)


Oh...I dunno...it breaks up my day to figure out the 
order of some of the posts.  I just figure it's an artifact
of mailing over the internet, with propagation delays and
traffic and whatnot, and our own mail server doing it's
intrusion and virus detection 'thing'.

I suppose if you switch to digest mode the messages would
be in order...maybe?

Just my 2¢...

-Original Message-
Sent: Thursday, October 03, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L


Yes. This is very normal for me as well.

Naveen Nahata wrote:
 I receive the mails of this late after a long delay approx 1-2 hours. Is this
 common?
 
 Sometimes i get the reply first and then i get the question
 
 Regards
 Naveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Restrict certain database access using 3rd party tools.


Rick,

Can you change the forms application?
If so, then a really simple way of doing this is to grant insert, update and
delete access to the tables to an Oracle role.

When the form starts, enable that role to grant access to the tables.  By
default, the role would not be enabled for the user.

You could even extend this idea by having a password required on the role,
and getting that password inside the form.  that way, a sqlplus user could
not enable the role.

the other ideas restricting access by program name do not work because you
do not have control of the PC desktop.

Another thing I've seen done is to establish shadow accounts.  this idea
involves a person having an OPS account with read-only access to the db
tables.  the user also has another oracle account that has total access to
all tables.  but the user doesn't even know this account exists.  again, the
forms application is run, connecting via the OPS account.  the first thing
the form does is to query a lookup table, finding the OPS account and the
shadow account/password, and re-connects to the database using this account.

this is the best idea I have found for protecting the database.

hope these help.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, October 03, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L


Hi All,

We have users that have OPS$ accounts that have full DML privs when they
run forms application via citrix. Currently they do
not have sqlplus,etc.  There is a requirement that some can have
sqlplus,toad,etc.  I know you can set up security for sqlplus,etc
using product_user_profile but is there a way to allow only SELECT when
using a 3rd party tool such as TOAD.

Thanks
Rick



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: svrmgrl echo v$database in script

2002-10-03 Thread Deshpande, Kirti


Use \ to escape the $ sign. 

select name from v_\$database;


- Kirti


 -Original Message-
 From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 6:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl echo v$database in script
 
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database.  I REALLY want to echo the name of the database into my log file
 before I shut down.While select name from v$database works fine from
 svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
 is
 screwing it up.  (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 Any ideas?
 
 Thx!!!
 
 Barb
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author:   Barb Baker
 # Purpose:  execute shutdown immediate on current database
 #   (i.e., database pointed to by current value of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\  at `date` 
${ORACLE_HOME}/bin/svrmgrl  EOF
connect internal
select name from v_$database;
 EOF
 
 
 $  ./stop_db.sh
 Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGRselect name from v_
   *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Baker, Barbara
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: svrmgrl echo v$database in script

2002-10-03 Thread Fink, Dan


What happens if the ORACLE_SID is set to one value and the caller uses
SQL*Net to access a different database? While this is not usually the case
in scripts, it could be a problem if the script is parted of a called
function. 
ORACLE_SID=DEV
sqlplus scott/tiger@PROD  -- I'm not connected to DEV anymore.

I realize this is nit-picking, but I've done far too many recoveries because
someone thought they were in DEV when they actually connected to PROD. I'd
rather know EXACTLY which db I'm connected to, not which one the O/S thinks
I should be in.

My $.02

Dan Fink

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


echo $ORACLE_SID  logfile

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 6:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl echo v$database in script
 
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database.  I REALLY want to echo the name of the database into my log file
 before I shut down.While select name from v$database works fine from
 svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
 is
 screwing it up.  (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 Any ideas?
 
 Thx!!!
 
 Barb
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author:   Barb Baker
 # Purpose:  execute shutdown immediate on current database
 #   (i.e., database pointed to by current value of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\  at `date` 
${ORACLE_HOME}/bin/svrmgrl  EOF
connect internal
select name from v_$database;
 EOF
 
 
 $  ./stop_db.sh
 Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGRselect name from v_
   *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Baker, Barbara
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: svrmgrl echo v$database in script

2002-10-03 Thread Kevin Lange


In order for the K Shell to let you use a Dollar Sign ($) as a litteral
 you need to use the escape character before it (\)
 
 So, instead of 
   select name from v$database;
 use
   select name from v\$database;

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L


echo $ORACLE_SID  logfile

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 6:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl echo v$database in script
 
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database.  I REALLY want to echo the name of the database into my log file
 before I shut down.While select name from v$database works fine from
 svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
 is
 screwing it up.  (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 Any ideas?
 
 Thx!!!
 
 Barb
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author:   Barb Baker
 # Purpose:  execute shutdown immediate on current database
 #   (i.e., database pointed to by current value of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\  at `date` 
${ORACLE_HOME}/bin/svrmgrl  EOF
connect internal
select name from v_$database;
 EOF
 
 
 $  ./stop_db.sh
 Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGRselect name from v_
   *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Baker, Barbara
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Backups


I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman
to do online backups.  No problem with recovery!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 12:18 PM


This doesn't sound right.  Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode.  Why wouldn't you be able to recover?

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051

RE: Restrict certain database access using 3rd party tools.

2002-10-03 Thread paquette stephane


Oups ! you're right.
 --- Kevin Lange [EMAIL PROTECTED] a écrit :  Except
for the fact that they could always change
 the program name that they
 are running to match what you need.   Then that
 security is bypassed.
 
 
 
 -Original Message-
 Sent: Thursday, October 03, 2002 11:08 AM
 To: Multiple recipients of list ORACLE-L
 
 
 In homemade applications, by default users have a
 role
 with read only, in the applications we change the
 default role that allows insert, update, delete.
 
 I've not tested this scenario but how about if, in a
 database logon trigger, you check the
 v$process.program field then depending of that value
 you may be able to change the user default's role.
 
 Should work on 8i using dedicated connection.
 
 
  --- [EMAIL PROTECTED] a écrit :  Hi All,
  
  We have users that have OPS$ accounts that have
 full
  DML privs when they
  run forms application via citrix. Currently they
 do
  not have sqlplus,etc.  There is a requirement that
  some can have
  sqlplus,toad,etc.  I know you can set up security
  for sqlplus,etc
  using product_user_profile but is there a way to
  allow only SELECT when
  using a 3rd party tool such as TOAD.
  
  Thanks
  Rick
  
  
  
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051
  http://www.fatcity.com
  San Diego, California-- Mailing list and
 web
  hosting services
 

-
  To REMOVE yourself from this mailing list, send an
  E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
  the message BODY, include a line containing: UNSUB
  ORACLE-L
  (or the name of mailing list you want to be
 removed
  from).  You may
  also send the HELP command for other information
  (like subscribing). 
 
 =
 Stéphane Paquette
 DBA Oracle, consultant entrepôt de données
 Oracle DBA, datawarehouse consultant
 [EMAIL PROTECTED]
 

___
 Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et
 en français !
 Yahoo! Mail : http://fr.mail.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: =?iso-8859-1?q?paquette=20stephane?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Kevin Lange
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared

2002-10-03 Thread Bob Metelsky


All Im trying to run the following statement

EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

And get the following error

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be
declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Looking under SYS schema I have package and package body for DBMS_SYSTEM
and the body includes
SET_SQL_TRACE_IN_SESSION

I had to turn on tracing on the database level...
What could be the matter with this??

Many Thanks in advance
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Backups

2002-10-03 Thread Markham, Richard

Title: RE: Backups





It would be interesting to see how you would explain how either
cp or dd (which know nothing of archive log mode, or the concept
of hot backup, itself, none the less) is going to keep things
consistent, when these utilities themselves are for point in 
time operations.




-Original Message-
From: John Weatherman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backups



This doesn't sound right. Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode. Why wouldn't you be able to recover? 


John P Weatherman
Database Administrator
Replacements Ltd.




-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L



If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup. If it is not, you won't be
able to recover.


Just a thot,
Ruth


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM



Robyn,
We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
ROR mª¿ªm


 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,


I need some info about backups. I am working on a customer site, and
have implemented both exports and hot backups. Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.


Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals. The file
system is built on a 12 disk A1000 array. We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape? Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.


Robyn


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like

Re: svrmgrl echo v$database in script


Lee, you're alive.  I'll let the OT list know!  Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 1:33 PM


 Hi,

 This works

 #!/bin/ksh
 export ORACLE_SID=ADW
 export ORACLE_HOME=/usr/app/oracle/product/8.0.5
 export PATH=$ORACLE_HOME/bin:$PATH

 svrmgrl EOF
 connect internal
 select name from v_\$database;
 exit

 EOF

 Just escape the $ sign with a backslash.

 HTH

 Lee

 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: 03 October 2002 16:43
 To: Multiple recipients of list ORACLE-L


 echo $ORACLE_SID  logfile

 Scott Shafer
 San Antonio, TX
 210.581.6217


  -Original Message-
  From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
  Sent: Wednesday, October 02, 2002 6:28 PM
  To: Multiple recipients of list ORACLE-L
  Subject: svrmgrl echo v$database in script
 
 
  Oracle 8.0.5
  Solaris 2.6
 
  List:
  I've created a script (ksh) called from elsewhere that shuts down the
  database.  I REALLY want to echo the name of the database into my log
file
  before I shut down.While select name from v$database works fine
from
  svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
  is
  screwing it up.  (I can get other commands to work within the script.)
  However, I don't know what to do about it.
 
  Any ideas?
 
  Thx!!!
 
  Barb
 
  $ svrmgrl
 
  SVRMGR connect internal
  Connected.
  SVRMGR select name from v$database;
  NAME
  -
  TADENT
  1 row selected.
 
 
  #!/usr/bin/ksh
  # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
  # Name: stop_db.sh
  # Author:   Barb Baker
  # Purpose:  execute shutdown immediate on current database
  #   (i.e., database pointed to by current value of
ORACLE_SID)
  
  echo Stop oracle instance \${ORACLE_SID}\  at `date` 
 ${ORACLE_HOME}/bin/svrmgrl  EOF
 connect internal
 select name from v_$database;
  EOF
 
 
  $  ./stop_db.sh
  Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
  SVRMGR Connected.
  SVRMGRselect name from v_
*
  ORA-00942: table or view does not exist
  SVRMGR
  Server Manager complete.
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Baker, Barbara
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author:
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).




 **
 The information contained in this communication is
 confidential, is intended only for the use of the recipient
 named above, and may be legally privileged.
 If the reader of this message is not the intended
 recipient, you are hereby notified that any dissemination,
 distribution, or copying of this communication is strictly
 prohibited.
 If you have received this communication in error,
 please re-send this communication to the sender and
 delete the original message or any copy of it from your
 computer system. Thank You.

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Robertson Lee - lerobe
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author:

RE: svrmgrl echo v$database in script

2002-10-03 Thread Scott . Shafer


A)  Change your unholy methods to use the light side of the force.
or
B)  Just use a different variable to hold the tnsnames.ora entry of wherever
you happen to be connecting to.  Or initialize the $ORACLE_SID variable to
whatever you want it to be.  This allows you to iterate through a list of
SIDs to perform ops on multiple db's if needed, i.e., 

sqlplus user@current_sid
 ...
 exit
 echo $current_sid  logfile

in your script.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Fink, Dan [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, October 03, 2002 12:34 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: svrmgrl echo v$database in script
 
 What happens if the ORACLE_SID is set to one value and the caller uses
 SQL*Net to access a different database? While this is not usually the case
 in scripts, it could be a problem if the script is parted of a called
 function. 
 ORACLE_SID=DEV
 sqlplus scott/tiger@PROD  -- I'm not connected to DEV anymore.
 
 I realize this is nit-picking, but I've done far too many recoveries
 because
 someone thought they were in DEV when they actually connected to PROD. I'd
 rather know EXACTLY which db I'm connected to, not which one the O/S
 thinks
 I should be in.
 
 My $.02
 
 Dan Fink
 
 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 03, 2002 9:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 echo $ORACLE_SID  logfile
 
 Scott Shafer
 San Antonio, TX
 210.581.6217
 
 
  -Original Message-
  From:   Baker, Barbara [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, October 02, 2002 6:28 PM
  To: Multiple recipients of list ORACLE-L
  Subject:svrmgrl echo v$database in script
  
  
  Oracle 8.0.5
  Solaris 2.6
  
  List:
  I've created a script (ksh) called from elsewhere that shuts down the
  database.  I REALLY want to echo the name of the database into my log
 file
  before I shut down.While select name from v$database works fine
 from
  svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
  is
  screwing it up.  (I can get other commands to work within the script.)
  However, I don't know what to do about it.
  
  Any ideas?
  
  Thx!!!
  
  Barb
  
  $ svrmgrl
  
  SVRMGR connect internal
  Connected.
  SVRMGR select name from v$database;
  NAME
  -
  TADENT
  1 row selected.
  
  
  #!/usr/bin/ksh
  # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
  # Name: stop_db.sh
  # Author:   Barb Baker
  # Purpose:  execute shutdown immediate on current database
  #   (i.e., database pointed to by current value of
 ORACLE_SID)
  
  echo Stop oracle instance \${ORACLE_SID}\  at `date` 
 ${ORACLE_HOME}/bin/svrmgrl  EOF
 connect internal
 select name from v_$database;
  EOF
  
  
  $  ./stop_db.sh
  Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
  
  
  SVRMGR Connected.
  SVRMGRselect name from v_
*
  ORA-00942: table or view does not exist
  SVRMGR
  Server Manager complete.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: svrmgrl echo v$database in script


Dan,

You can use a anonymous PL/SQL block like the following in you login.sql or
script file is necessary, it keeps those errors from happening:

whenever sqlerror exit
declare
  db varchar2(30);
begin
  select global_name into db from global_name;
  if(db not like 'DEV%') then raise_application_error(-20100, Wrong Database);
  end if;
end;
/


Dick Goulet

Reply Separator
Author: Fink; Dan [EMAIL PROTECTED]
Date:   10/3/2002 9:33 AM

What happens if the ORACLE_SID is set to one value and the caller uses
SQL*Net to access a different database? While this is not usually the case
in scripts, it could be a problem if the script is parted of a called
function. 
ORACLE_SID=DEV
sqlplus scott/tiger@PROD  -- I'm not connected to DEV anymore.

I realize this is nit-picking, but I've done far too many recoveries because
someone thought they were in DEV when they actually connected to PROD. I'd
rather know EXACTLY which db I'm connected to, not which one the O/S thinks
I should be in.

My $.02

Dan Fink

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


echo $ORACLE_SID  logfile

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 6:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl echo v$database in script
 
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database.  I REALLY want to echo the name of the database into my log file
 before I shut down.While select name from v$database works fine from
 svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
 is
 screwing it up.  (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 Any ideas?
 
 Thx!!!
 
 Barb
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author:   Barb Baker
 # Purpose:  execute shutdown immediate on current database
 #   (i.e., database pointed to by current value of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\  at `date` 
${ORACLE_HOME}/bin/svrmgrl  EOF
connect internal
select name from v_$database;
 EOF
 
 
 $  ./stop_db.sh
 Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGRselect name from v_
   *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Baker, Barbara
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051

RE: svrmgrl echo v$database in script

2002-10-03 Thread Scott . Shafer


Or a here document that allows you to iterate through a list of SID's if
necessary.  Env variables don't have to be static on *nix...

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, October 03, 2002 12:44 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: svrmgrl echo v$database in script
 
 If fyou want to do it from within a script, you either need to code the
 select into a .sql file that you run OR you need to escape the $ with
 a \ in your ksh script
 
 
 --- [EMAIL PROTECTED] wrote:
  echo $ORACLE_SID  logfile
  
  Scott Shafer
  San Antonio, TX
  210.581.6217
  
  
   -Original Message-
   From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
   Sent: Wednesday, October 02, 2002 6:28 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  svrmgrl echo v$database in script
   
   
   Oracle 8.0.5
   Solaris 2.6
   
   List:
   I've created a script (ksh) called from elsewhere that shuts down
  the
   database.  I REALLY want to echo the name of the database into my
  log file
   before I shut down.While select name from v$database works
  fine from
   svrmgrl interactively, it throws up in the script.  I'd guess the $
  sign
   is
   screwing it up.  (I can get other commands to work within the
  script.)
   However, I don't know what to do about it.
   
   Any ideas?
   
   Thx!!!
   
   Barb
   
   $ svrmgrl
   
   SVRMGR connect internal
   Connected.
   SVRMGR select name from v$database;
   NAME
   -
   TADENT
   1 row selected.
   
   
   #!/usr/bin/ksh
   # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
   # Name: stop_db.sh
   # Author:   Barb Baker
   # Purpose:  execute shutdown immediate on current database
   #   (i.e., database pointed to by current value of
  ORACLE_SID)
   
   echo Stop oracle instance \${ORACLE_SID}\  at `date` 
  ${ORACLE_HOME}/bin/svrmgrl  EOF
  connect internal
  select name from v_$database;
   EOF
   
   
   $  ./stop_db.sh
   Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
   
   
   SVRMGR Connected.
   SVRMGRselect name from v_
 *
   ORA-00942: table or view does not exist
   SVRMGR
   Server Manager complete.
   
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   -- 
   Author: Baker, Barbara
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- 858-538-5051 http://www.fatcity.com
   San Diego, California-- Mailing list and web hosting
  services
  
  -
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like
  subscribing).
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 
 __
 Do you Yahoo!?
 New DSL Internet Access from SBC  Yahoo!
 http://sbc.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL

Re: Backups

2002-10-03 Thread Ron Rogers


Lest we not forget the archivelogs also during this backup procedure.
Ron

 [EMAIL PROTECTED] 10/03/02 01:53PM 
I forgot about alter tablespace begin backup; etc. I am spoiled, I use
rman
to do online backups.  No problem with recovery!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 12:18 PM


This doesn't sound right.  Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode.  Why wouldn't you be able to recover?

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you
won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only
a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd
function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Maili
ng list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: John Weatherman
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ:

RE: OT: Why do I receive the mails late?

2002-10-03 Thread David . Schmoldt


Me too.  I sort the messages by subject and then date received, and I often
see the responses before the original question.

I don't think it's unique to this list, though.

Dave

 -Original Message-
 From: ltiu [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 03, 2002 11:53 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: OT: Why do I receive the mails late?
 
 
 Yes. This is very normal for me as well.
 
 Naveen Nahata wrote:
  I receive the mails of this late after a long delay approx 
 1-2 hours. Is this
  common?
  
  Sometimes i get the reply first and then i get the question
  
  Regards
  Naveen
 
 
 -- 
 ltiu
 OCP 9i DBA
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: ltiu
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Data modeling question about reference table

2002-10-03 Thread John Thomas


Stephane,

Sounds like you know the answer really.

If your reference tables are all like (CODE, VALUE) or similar, and they 
are pretty static values, why not move them all into one table? Probably 
gives you performance advantages and maybe code reuse:

SELECT value
FROM ref_values
WHERE code = :bind_value

Instead of:

SELECT value
FROM code_table_name
WHERE code = 'code'

Whether its really worth the bother depends upon your precise 
requirements, data volumes etc though. (Could be that most of the 
reference tables are not used much. By caching the few that are used, 
you can get great performance without indexes... like I say, just 
depends.)

Cheers,

John Thomas

In message [EMAIL PROTECTED], paquette stephane 
[EMAIL PROTECTED] writes
Hi,

We're discussing on reference table.
One containing everything (using a type) or one per
entity. We'll have a lot of entities.

This is for a staging area where data will be validate
before going in Siebel. In theory, this staging will
become a very big staging for a datarehouse and still
in theory there is no plan yet that that staging will
be available to the users as an ODS.

What do you think ?

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
John Thomas Tel:01506 881 037
Oracle Contract DBA Mobile: 07986 182 368
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Thomas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: Backups


I've used cpio, dd, and fbackup to do hot and cold backups before, but never
again.  With those utilities the burden of keeping track of what is on which
tape rests with you and normally a stubby pencil  pad of paper because you know
what won't be available when you need to do a recovery.  They do work be
assured, but the administrative overhead is just not worth it anymore, even for
a small shop.  Get a copy of Veritas or OmniBack or some other software package
that does library management for you and preferably integrates with RMAN.  Life
can be so much easier!!

Dick Goulet

Reply Separator
Author: Markham; Richard [EMAIL PROTECTED]
Date:   10/3/2002 10:03 AM

It would be interesting to see how you would explain how either
cp or dd (which know nothing of archive log mode, or the concept
of hot backup, itself, none the less) is going to keep things
consistent, when these utilities themselves are for point in 
time operations.



-Original Message-
Sent: Thursday, October 03, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L


This doesn't sound right.  Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode.  Why wouldn't you be able to recover? 

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information

Re: Perl::DBI problems after charset change (MORE INFO -- longish

2002-10-03 Thread Tim Bunce


On Thu, Oct 03, 2002 at 06:38:28AM -0800, Jesse, Rich wrote:
 Already did -- and deftly checking the list archives I see that MS Lookout
 has once again thwarted me by throwing away a reply by Tim Bunce himself.

That'll be this one...

Tim [also who skims oracle-l sometimes...]


On Tue, Oct 01, 2002 at 04:17:51PM -0500, Jesse, Rich wrote:
 Hi,
 
 A Solaris system that I have little control over is running Perl 5.005_03,
 and a DBI_TRACE level 2 shows DBI v1.13 and DBD::Oracle v1.03.  The Oracle
 client on the Solaris server is 8.0.5.0.0.  The Oracle DB we're connecting
 to is 8.1.7.4.0 on HP/UX.
 
 After changing the 8.1.7 DB's characterset from US7ASCII to WE8ISO8859P1,
 I've been receiving constant ORA-1017, invalid username/password errors on
 the DB's audit trail.  Amazingly, no users complained.  After a
 support-level network trace, it appears that simple connect statements like
 this one:
 
 $dbh = DBI-connect(dbi:Oracle:MYSID,myuser,mypass);
 
 fail with the ORA-1017, but then automatically retry the connection and
 succeed without reporting the error.  All other Oracle Client tools on this
 Solaris machine, like SQL*Plus, work as normal.  The DBI/DBD::Oracle error
 occurs over several Perl scripts for various applications.

 The trace also showed something I haven't seen before -- the password on the
 second try (the successful one) was sent unencrypted.
 
 Is this a documented problem in the somewhat dated versions of DBI and/or
 DBD::Oracle?  Is there a documented fix?  I can't ask to upgrade any of this
 without evidence that the upgrade will fix the problem.

DBD::Oracle has no connect retry logic in it. Looks like Oracle's client
library is doing it. Do a DBI trace level 9 to see the OCI calls being used.

 BTW, I've attempted to match the NLS_LANG on the client by setting it to
 AMERICAN_AMERICA.WE8ISO8859P1. But while SQL*Plus works fine with this,
 DBI/DBD::Oracle doesn't:
 
 DBI-connect failed: ORA-12705: invalid or unknown NLS parameter value
 specified (DBD: login failed) at ./cursor_sharing_yes.pl line 17

DBD::Oracle has no NLS parameter code in the connect logic.
Looks like Oracle's client library is doing it (from the env var).

It's possible that DBD::Oracle is missing some OCI calls that it
should make, and if anyone can tell me what they are I'll happily
add them!

[Ding! A lightbulb over head moment...] Solaris now has a very cool
tool called apptrace which can trace calls from any application
into any shared library it uses. You could use it to trace what OCI
calls SQL*Plus is using to connect. Let me know what you find.
(Anyone else on Solaris (=8 I think) is welcome to try this and
send me the relevant info.)

Tim.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Bunce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be dec


Bob,

It can only be one of two things:

Try EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

or

connect as SYS and grant execute on DBMS_SYSTEM to your_Oracle_account and
try it again.

Hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, October 03, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
declared


All Im trying to run the following statement

EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

And get the following error

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be
declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Looking under SYS schema I have package and package body for DBMS_SYSTEM
and the body includes
SET_SQL_TRACE_IN_SESSION

I had to turn on tracing on the database level...
What could be the matter with this??

Many Thanks in advance
bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Restrict certain database access using 3rd party tools.

2002-10-03 Thread Jacques Kilchoer

Title: RE: Restrict certain database access using 3rd party tools.





Stupid DBA trick #32, or how to drive your DBA colleague wild on April Fool's day:
go over to her machine, and change the name of the SQL*Plus executable (%ORACLE_HOME%\bin\sqlplusw.exe, plus80w.exe or whatever it is) by surrounding it with parentheses, e.g. (sqlplusw).exe and change the shortcuts to point to that program. SQL*Net will NOT be happy.

 -Original Message-
 From: Kevin Lange [mailto:[EMAIL PROTECTED]]
 
 Except for the fact that they could always change the program 
 name that they
 are running to match what you need. Then that security is bypassed.

RE: RE: Backups

2002-10-03 Thread Markham, Richard

Title: RE: RE: Backups





Yes I personally run Veritas Netbackup for both cold and RMAN. A fiber
SAN has its added benefits as well =). I have never really explored the
implications of these other utilities. My head filled with many
distasteful visuals. Yes, I agree with you and I realize that I am
spoiled knocking on wood.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 1:38 PM
To: Markham; Richard; Multiple recipients of list ORACLE-L
Subject: Re:RE: Backups



I've used cpio, dd, and fbackup to do hot and cold backups before, but never
again. With those utilities the burden of keeping track of what is on which
tape rests with you and normally a stubby pencil  pad of paper because you know
what won't be available when you need to do a recovery. They do work be
assured, but the administrative overhead is just not worth it anymore, even for
a small shop. Get a copy of Veritas or OmniBack or some other software package
that does library management for you and preferably integrates with RMAN. Life
can be so much easier!!


Dick Goulet


Reply Separator
Subject: RE: Backups
Author: Markham; Richard [EMAIL PROTECTED]
Date: 10/3/2002 10:03 AM


It would be interesting to see how you would explain how either
cp or dd (which know nothing of archive log mode, or the concept
of hot backup, itself, none the less) is going to keep things
consistent, when these utilities themselves are for point in 
time operations.




-Original Message-
Sent: Thursday, October 03, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L



This doesn't sound right. Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode. Why wouldn't you be able to recover? 


John P Weatherman
Database Administrator
Replacements Ltd.




-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L



If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup. If it is not, you won't be
able to recover.


Just a thot,
Ruth


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM



Robyn,
We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
ROR mª¿ªm


 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,


I need some info about backups. I am working on a customer site, and
have implemented both exports and hot backups. Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.


Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals. The file
system is built on a 12 disk A1000 array. We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape? Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.


Robyn


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
 INET: [EMAIL

RE: Restrict certain database access using 3rd party tools.

2002-10-03 Thread Jacques Kilchoer

Title: RE: Restrict certain database access using 3rd party tools.





P.S. IIRC this will happen with any client program using SQL*Net:
e.g. change My_program.exe to (My_program).exe and SQL*Net will be unable to establish a connection.


 -Original Message-
 From: Jacques Kilchoer 
 
 Stupid DBA trick #32, or how to drive your DBA colleague wild 
 on April Fool's day:
 go over to her machine, and change the name of the SQL*Plus 
 executable (%ORACLE_HOME%\bin\sqlplusw.exe, plus80w.exe or 
 whatever it is) by surrounding it with parentheses, e.g. 
 (sqlplusw).exe and change the shortcuts to point to that 
 program. SQL*Net will NOT be happy.

RE: OT: Why do I receive the mails late?

2002-10-03 Thread Farnsworth, Dave


It's just like the game show Jeapordy.  First you see the answer and then you get the 
question.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


Me too.  I sort the messages by subject and then date received, and I often
see the responses before the original question.

I don't think it's unique to this list, though.

Dave

 -Original Message-
 From: ltiu [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 03, 2002 11:53 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: OT: Why do I receive the mails late?
 
 
 Yes. This is very normal for me as well.
 
 Naveen Nahata wrote:
  I receive the mails of this late after a long delay approx 
 1-2 hours. Is this
  common?
  
  Sometimes i get the reply first and then i get the question
  
  Regards
  Naveen
 
 
 -- 
 ltiu
 OCP 9i DBA
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: ltiu
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

* Production Oracle DBA Needed in Hartford, CT...

2002-10-03 Thread OraStaff


Position: Oracle DBA 

Location: Hartford, Connecticut

Salary Range: 60-80K-depends on experience plus excellent benefits 
  and wonderful work environment.

Candidates already in the Greater Hartford, CT area will be given first
priority..
this company strongly prefers not to relocate.

DO NOT send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

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

*Description:
The DBA will spend 50% on 'release management'(vendor term) implementing
fixes and new releases 
into test and production.(tandem/comaq/HP environment.) 
40% of time will be doing development and writing SQL for updates and data
retrieval. 
STRONG SQL IS REQUIRED. 
Remaining 10% on normal Oracle DBA funtions. 
Platforms used are oracle/unix, oracle/wintowe, sybase/unix, etc.
Person will be trained on other databases/platforms in 'slack time'.

Requirements:
-4+ years Production Oracle DBA experience. 
-Strong SQL background. 
-Unix
-Multi industry background is preferred.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Hartford/Oracle DBA/Stan D.
ph: 1-800 -549-8502

All Submissions are handled in confidence.

*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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why do I receive the mails late?

2002-10-03 Thread Richards, Brian


Have you ever scrutinized the email headers to find out where the delay is
coming from?

We have had a rough couple of weeks with delays in and out due to
virus/content scanners that check every message in or out. Some days the
delays have been up to 6 hours!

Brian

-Original Message-
Sent: Thursday, October 03, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L


I receive the mails of this late after a long delay approx 1-2 hours. Is
this
common?

Sometimes i get the reply first and then i get the question

Regards
Naveen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richards, Brian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be dec

2002-10-03 Thread Jacques Kilchoer

Title: RE: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared





You might not have a public synonym for dbms_system.
Try
execute SYS.dbms_system.set_sql_trace_in_session (:sid, :serial#, true)


 -Original Message-
 From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
 
 All Im trying to run the following statement
 
 EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)
 
 And get the following error
 
 ERROR at line 1:
 ORA-06550: line 1, column 7:
 PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be
 declared
 ORA-06550: line 1, column 7:
 PL/SQL: Statement ignored
 
 Looking under SYS schema I have package and package body for 
 DBMS_SYSTEM
 and the body includes
 SET_SQL_TRACE_IN_SESSION
 
 I had to turn on tracing on the database level...
 What could be the matter with this??

Re: Backups


I still prefer cold backups when performing full OS backups.

 [EMAIL PROTECTED] 10/03/02 02:28PM 
Lest we not forget the archivelogs also during this backup procedure.
Ron

 [EMAIL PROTECTED] 10/03/02 01:53PM 
I forgot about alter tablespace begin backup; etc. I am spoiled, I use
rman
to do online backups.  No problem with recovery!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 12:18 PM


This doesn't sound right.  Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode.  Why wouldn't you be able to recover?

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you
won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only
a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd
function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Maili
ng list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: John Weatherman
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the

Re: Backups


But of course, rman... backup archivelogs delete.  Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 2:28 PM


Lest we not forget the archivelogs also during this backup procedure.
Ron

 [EMAIL PROTECTED] 10/03/02 01:53PM 
I forgot about alter tablespace begin backup; etc. I am spoiled, I use
rman
to do online backups.  No problem with recovery!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 12:18 PM


This doesn't sound right.  Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode.  Why wouldn't you be able to recover?

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you
won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only
a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd
function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Maili
ng list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or

RE: Utl_file and OPENVMS


hmm, when you go into svrmgrl connect internal and show parameters, do both show up or 
just the last one?  on my system, i only see the last.

 [EMAIL PROTECTED] 10/03/02 01:13PM 
Like these

utl_file_dir=/u327/applmgr/10_7/finprod_output/hfs_data
utl_file_dir=/u327/applmgr/10_7/har/1.0.0/mm_cbdata

and these are the last entries in initSID.ora file.

Regards
Rafiq



Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 07:58:38 -0800

What does your utl_file_dir parameter look like in your init.ora?  I am 
using AIX.

  [EMAIL PROTECTED] 10/03/02 11:43AM 
What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no
problem with separate entries as mentioned by Jared. However, don't keep gap
between these entries...and define it the way it was explained by Jared.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 05:28:22 -0800

On unix, multiple entries in the init.ora file results in the last entry
being the only valid value (i.e. last time variable is set).  I tested below
and only dir3 is listed as a utl_file_dir parameter.  But if you comma
delimit them w/ 1 instance of the variable then all dir's are listed.  Maybe
NT is different, fortunately never had to support Oracle on NT :).

Gene

   [EMAIL PROTECTED] 10/02/02 07:13PM 
Gene,

   utl_file_dir = D:\directory name1
   utl_file_dir = D:\directory name2
   utl_file_dir = D:\directory name3

The multiple lines shown are actually the documented method for doing
this.

The single line with comma delimited entries may also work, though I'm
not sure about it.

Jared





Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] 
   10/01/2002 11:25 AM
   Please respond to ORACLE-L


  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
  cc:
  Subject:RE: Utl_file and OPENVMS


i believe its

utl_file_dir=dir1,dir2,dir3,...

in your example, dir 3 would be the only valid dir.

hth,
gene

   [EMAIL PROTECTED] 10/01/02 12:53PM 
Make sure you have the directory name entry covered in INIT.ORA

e.g.

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

You need one entry per directory that you want to write to using UTL_FILE
Package

Hope this helps

Regards

Shiva




-Original Message-
Sent: Tuesday, October 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


the vms user oracle needs rights to the directory.

   [EMAIL PROTECTED] 09/30/02 10:53AM 
List,
   I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4  and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
get the package to write the files to the OS directory.
   The package is created by the Oracle user DTSUSER and executed by
DTSUSER. There is no OPENVMS user DTSUSER.
The sysadmin assures me that the permissions are correct to write to
the directory.
I have place a Dbms_output in the package to display the directory
information and it looks correct.
   Is there anything different that has to be done to an OPENVMS server
that will allow a package to write to a directory using the Utl_File
package?


Listing from the Oracle tables:

DTS_PARAMETER_NAME DTS_PARAMETER_VALUE

-- --

LOAD_USERIDLOADITUP

LOAD_PASSWORD  ILOADIT

LOAD_SERVICE_NAME  GLC_ALPHADEV-TCP

LOAD_PAR_FILE_DIR  ORADSK:[ORACLE8.DATA.PAR]

LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles]

LOAD_CONTROL_FILE_DIR  ORADSK:[ORACLE8.DATA.CONTROL]

LOAD_LOG_FILE_DIR  ORADSK:[ORACLE8.DATA.LOG]

LOAD_BAD_FILE_DIR  ORADSK:[ORACLE8.DATA.BAD]

LOAD_DISCARD_FILE_DIR  ORADSK:[ORACLE8.DATA.DISCARD]

Listing from the package that writes the parameter file:

Procedure Create_New_Par_File

(

 P_Current_Table_Name  In  Varchar2
,

 P_Run_DateIn Date,


 P_Load_Userid In  Varchar2
,

 P_Load_Password   In  Varchar2
,

 P_Load_Service_Name   In  Varchar2
,

 P_Load_Par_File_Dir   In  Varchar2
,

 P_Load_Data_File_Dir  In  Varchar2
,

 P_Load_Control_File_Dir   In  Varchar2  ,

 P_Load_Log_File_Dir   In  Varchar2
,

 P_Load_Bad_File_Dir   In  Varchar2
,

 P_Load_Discard_File_Dir

RE: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared


From which schema are you trying to run this procedure?

I can run it from Sys schema. If you are not running it from Sys schema then
use

EXEC sys.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

This should work if you have the privileges

Regards
Naveen

-Original Message-
Sent: Thursday, October 03, 2002 11:49 PM
To: Multiple recipients of list ORACLE-L
declared


All Im trying to run the following statement

EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

And get the following error

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be
declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Looking under SYS schema I have package and package body for DBMS_SYSTEM
and the body includes
SET_SQL_TRACE_IN_SESSION

I had to turn on tracing on the database level...
What could be the matter with this??

Many Thanks in advance
bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Backups

2002-10-03 Thread Steve McClure

Title: RE: Backups

Lots
of folks here on the list canexplain it, but really you would get more
from the Oracle Backup and Recovery Manual. In short, you place your
tablespaces in 'backup mode', one TS at a time is the prefered method. You
backup the datafiles associated with the Tablespaces in backup mode, using cp or
tar or dd or whatever you prefer. You end backup mode, perform a log
switch, and backup all archived redo logs created during your backup. You
do this, and you can restore your backup, and Oracle will, for the purposes of
this response, magically recover your database.

Steve
McClure
60%
certified and counting

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Markham, RichardSent:
Thursday, October 03, 2002 11:03 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Backups
It would be interesting to see how you would explain how
either cp or dd (which know nothing of archive log
mode, or the concept of hot backup, itself, none the
less) is going to keep things consistent, when these
utilities themselves are for point in time
operations.
-Original Message- From: John
Weatherman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Backups
This doesn't sound right. Put the database in hot backup
mode, backup (whether using cp to a staging point like
the poster here is doing or straight to tape using dd
or dump or some other utility), come out of hot backup
mode. Why wouldn't you be able to recover?
John P Weatherman Database
Administrator Replacements Ltd.
-Original Message- Sent:
Thursday, October 03, 2002 10:18 AM To: Multiple
recipients of list ORACLE-L
If you want to be able to use any OS backup for
restore/recovery that database must be closed when you
do the backup. If it is not, you won't be able
to recover.
Just a thot, Ruth
- Original Message - To:
"Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM
Robyn, We used the DD method on
pre 7.1 oracle with RAW devices. It worked fine except
that it used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of
the data on tape should not be a problem if a restoral
is needed. The dd function is just another OS method
of copying data to a tape. I don't know for sure but I
think there might be some issues about transportability of the dd tape. Other users will know about the
transportability issues. Ron ROR mª¿ªm
[EMAIL PROTECTED] 10/02/02 08:08PM
Hello,
I need some info about backups. I am working on a
customer site, and have implemented both exports and
hot backups. Both jobs copy to a separate mount
point, and a job scripted by another individual then moves the files to tape.
Here's the problem - he's using a dd command, primarily
because it provides a succinct output he can email to
non-technicals. The file system is built on a 12
disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system
be recovered from this tape? Has anyone ever
relied on a dd for a daily backup method? The system
is Oracle 9i on Solaris 8.
Robyn
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.com --
Author: Robyn Anderson Sands
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.com --
Author: Ron Rogers INET:
[EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.com --
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and

Re: * Production Oracle DBA Needed in Hartford, CT...


Remaining 10% on normal Oracle DBA function. 
Platforms used are oracle/unix, oracle/wintowe, sybase/unix, etc.
Person will be trained on other databases/platforms in 'slack time'.

hmm, sounds like 90% developer + 10% dba still = dba.  lets not forget slack time for 
learning sybase *rofl*

 [EMAIL PROTECTED] 10/03/02 02:53PM 
Position: Oracle DBA 

Location: Hartford, Connecticut

Salary Range: 60-80K-depends on experience plus excellent benefits 
  and wonderful work environment.

Candidates already in the Greater Hartford, CT area will be given first
priority..
this company strongly prefers not to relocate.

DO NOT send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

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

*Description:
The DBA will spend 50% on 'release management'(vendor term) implementing
fixes and new releases 
into test and production.(tandem/comaq/HP environment.) 
40% of time will be doing development and writing SQL for updates and data
retrieval. 
STRONG SQL IS REQUIRED. 
Remaining 10% on normal Oracle DBA funtions. 
Platforms used are oracle/unix, oracle/wintowe, sybase/unix, etc.
Person will be trained on other databases/platforms in 'slack time'.

Requirements:
-4+ years Production Oracle DBA experience. 
-Strong SQL background. 
-Unix
-Multi industry background is preferred.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED] 
Please use job code: One/Hartford/Oracle DBA/Stan D.
ph: 1-800 -549-8502

All Submissions are handled in confidence.

*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 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: svrmgrl echo v$database in script

2002-10-03 Thread Fink, Dan


Dick,
That is one method. My rule is that all destructive actions are run
from scripts that require the database name as a parameter. If the
$ORACLE_SID and parameter don't match, the script terminates. I realize this
is redundant, but better safe than having to perform a production recovery.
I don't have to code in any database specific values like 'DEV', 'PROD',
etc. so the script can be used for any database. My 'stub' korn shell script
already has this built in, so I don't even have to remember it.
As an aside, one of the problems I have had with putting this kind
of code in login.sql or glogin.sql is that it causes problems if the
database is not open. I recall spending a few hours troubleshooting a
monitoring script. It would work just fine while we were developing and
testing, but it would fail overnight in the cron job. The database was down
and the glogin.sql script was terminating. To this day, I still don't put
any queries inside login.sql and glogin.sql. One of those things that is
probably fixable, but I'd rather work in improving my Buffer Cache Hit
Ratio.

Dan

-Original Message-
Sent: Thursday, October 03, 2002 11:42 AM
To: Fink; Dan; Multiple recipients of list ORACLE-L


Dan,

You can use a anonymous PL/SQL block like the following in you login.sql
or
script file is necessary, it keeps those errors from happening:

whenever sqlerror exit
declare
  db varchar2(30);
begin
  select global_name into db from global_name;
  if(db not like 'DEV%') then raise_application_error(-20100, Wrong
Database);
  end if;
end;
/


Dick Goulet

Reply Separator
Author: Fink; Dan [EMAIL PROTECTED]
Date:   10/3/2002 9:33 AM

What happens if the ORACLE_SID is set to one value and the caller uses
SQL*Net to access a different database? While this is not usually the case
in scripts, it could be a problem if the script is parted of a called
function. 
ORACLE_SID=DEV
sqlplus scott/tiger@PROD  -- I'm not connected to DEV anymore.

I realize this is nit-picking, but I've done far too many recoveries because
someone thought they were in DEV when they actually connected to PROD. I'd
rather know EXACTLY which db I'm connected to, not which one the O/S thinks
I should be in.

My $.02

Dan Fink

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


echo $ORACLE_SID  logfile

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 6:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl echo v$database in script
 
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database.  I REALLY want to echo the name of the database into my log file
 before I shut down.While select name from v$database works fine from
 svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
 is
 screwing it up.  (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 Any ideas?
 
 Thx!!!
 
 Barb
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author:   Barb Baker
 # Purpose:  execute shutdown immediate on current database
 #   (i.e., database pointed to by current value of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\  at `date` 
${ORACLE_HOME}/bin/svrmgrl  EOF
connect internal
select name from v_$database;
 EOF
 
 
 $  ./stop_db.sh
 Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGRselect name from v_
   *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Baker, Barbara
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web

* Sr. Oracle 8i DBA Needed in NYC- Locals Only..

2002-10-03 Thread OraStaff


Position: Sr. Oracle 8i DBA 

Location: New York, New York

Industry: Publishing, Ecommerce

Salary Range: 90-110K-depends on experience plus excellent benefits and
bonus plan.


*PLEASE DO NOT send your resume for this position UNLESS you already live in
the 
 Greater New York City area and have the skills outlined below for this
position.

DO NOT send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

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

No H-1B candidates please.

*Description:
This well-established, very successful New York City based Fortune
500 Company is looking for a Senior Oracle 8i Database DBA to assist in the
design and development of a database supporting the implementation of an
enterprise content management system that will support major new ecommerce
initiatives. 
As a Sr. Oracle 8i Database Administrator, you will assist in the design,
development, 
testing and support of the development and production databases for this
brand new, 
rapidly expanding Ecommerce environment. - Work extensively with various
Ecommerce development 
teams,as well as database developers to assist in the development of various
Content
Management databases. - Create stored procedures, triggers, and functions.
Daily support includes: extensive replication, performance tuning and
monitoring, optimization of the databases, patches, upgrades, backups, redo
logs, etc. - Perform data modeling, logical and physical design. Build
physical databases from logical data model. - Provide support to the
production DBA group on an as-needed basis. 

*Requirements:
-BSCS degree or related discipline.
-Must have 5+ years Oracle 8i DBA (development and production support)
experience.
-Must have strong experience working with Unix (Solaris preferred). 
-Extensive shell scripting experience is required. 
-Must have experience working in an Ecommerce (Transaction Based) Environment. 
-Content Management experience is a plus. 
-Full project life cycle experience required. 
-MUST HAVE Excellent verbal and written communication skills.
-Must possess strong problem solving / analytical skills. 
-Any 9i experience is a plus.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/New York City//Oracle 8i DBA/Corey
(*NYC area candidates only- no exceptions)
ph: 1-800 -549-8502

All Submissions are handled in confidence.

*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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Re:RE: Backups


Rman keeps track of everything.  No hand documentation..I like that!
You have to use a third party media manager to go directly to tape but you
can backup to disk and then use the OS utilities to put the backups on tape.

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 2:43 PM


I've used cpio, dd, and fbackup to do hot and cold backups before, but never
again.  With those utilities the burden of keeping track of what is on which
tape rests with you and normally a stubby pencil  pad of paper because you
know
what won't be available when you need to do a recovery.  They do work be
assured, but the administrative overhead is just not worth it anymore, even
for
a small shop.  Get a copy of Veritas or OmniBack or some other software
package
that does library management for you and preferably integrates with RMAN.
Life
can be so much easier!!

Dick Goulet

Reply Separator
Author: Markham; Richard [EMAIL PROTECTED]
Date:   10/3/2002 10:03 AM

It would be interesting to see how you would explain how either
cp or dd (which know nothing of archive log mode, or the concept
of hot backup, itself, none the less) is going to keep things
consistent, when these utilities themselves are for point in
time operations.



-Original Message-
Sent: Thursday, October 03, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L


This doesn't sound right.  Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode.  Why wouldn't you be able to recover?

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

RE: Performance monitoring

2002-10-03 Thread Deshpande, Kirti


 some Oracle sites still believe in the myths and ratio based
 tuning.  It can be difficult to convince a client that their long
 practiced tuning methodology is obsolete.  

In such cases, Connor's wonderful script comes very handy ;) 
http://www.oracledba.co.uk/tips/choose.htm
I have used it to convince some old dogs 

- Kirti

-Original Message-
Sent: Thursday, October 03, 2002 12:44 PM
To: Multiple recipients of list ORACLE-L


they haven't been around as a company all that long so I doubt the doc
is from 7.3

as for the methodology, I've talked to their DBAs and they are forward
thinking, which is why the doc suprised me


--- Grabowy, Chris [EMAIL PROTECTED] wrote:
 Sort of putting on my devil's advocate hat...
 
 - perhaps the document is old and just hasn't been updated.  A lot
 of the documentation that we have lying around is marked as 7.3, we
 just haven't had the time to update them, since were overwhelmed with
 real work, and can't hire additional DBAs.
 - some Oracle sites still believe in the myths and ratio based
 tuning.  It can be difficult to convince a client that their long
 practiced tuning methodology is obsolete.  So for your specific
 case, perhaps they have dealt with these types of clients in the past
 so they tread lightly.
 
 It will be interesting to see how the hosting company responds to
 your explanations.
 
 -Original Message-
 Sent: Wednesday, October 02, 2002 9:39 PM
 To: Multiple recipients of list ORACLE-L
 
 
 we're hiring a hosting company to manage and monitor our production
 apps... they handed me their spreadsheet of Oracle things to
 monitor... I finally found wait events on that list. Buffer cache
 hit
 ratios were high on the list and flagged as critical
 
 nuh uh, didn't have time to gently explain (with the two by four)
 that
 that was going to be unacceptable. But I will have loads of time
 tomorrow. What scares me is that this list was compiled by
 experienced DBAs.
 
 --- [EMAIL PROTECTED] wrote:
  Buffer Cache Hit Ratio?
  
  What's that?
  
  
  
  
  
  
  Inka Bezdziecka [EMAIL PROTECTED]
  Sent by: [EMAIL PROTECTED]
   10/02/2002 08:03 AM
   Please respond to ORACLE-L
  
   
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  cc: 
  Subject:RE: Performance monitoring
  
  
  Well ...
   if you need short reports, look for:
  
  1. waits
  2. buffer cache hit ratio
  3. dictionary hit ratio
  4. library hit ratio
  5. latches
  6. parsing/execution ratio
  7. data file i/o 
  8. shared pool memory distribution
  9. session contention
  10. session memory usage
  
  inka
  
  -Original Message-
  Sent: Wednesday, October 02, 2002 7:08 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Thak's Mark
  
  I agreed, but they have gotten an idea to get only couple
  most important measurements from db, because they don't want
  to have a huge reports with all possible statistics. Very 
  understandable, but as You wrote, there isn't any absolutely top
 ten.
  
  In any case, I have to do this (stupid) list, so give Your best
 shot,
  please.
  
  t.Jorma
  Ps. I heard, that Dave Ensor from BMC, has once presented that
  kind of list? 
  
  -Original Message-
  Sent: 02 October, 2002 12:23
  To: Multiple recipients of list ORACLE-L
  
  
  Jorma,
  
  Performance tuning is a complex subject.  There really isn't a list
  of
  10 things to watch for.  Every system is different.
  
  I would (attempt to) summarize tuning by these five steps:
  
  1.)  Have a capacity/performance target in mind.  If you don't know
  where you're going, how will you know if you have gotten there?
  
  2.)  Monitor your response times as load increases.  Can you
 achieve
  your response time target at the specified load?  If so, you're
 done,
  successful test, congratulations.  If not, continue to next step.
  
  3.)  Actively monitor what's going on in the database, while it's
  happening.  It's always easier to see it in real time than just
  looking
  at random StatsPack snapshots taken at 5 or 10 or 15 minute
  intervals. 
  (Not that I'm saying StatsPack shouldn't be collected.  I'm just
  saying
  don't rely on StatsPack as your only source of info about the
  database.)  The V$ Wait Interface is your friend.  If you're not
  familiar with it, go to http://www.hotsos.com/ and get Mogens
  Norgaard's
  paper, Introducing the V$ Wait Interface.  Where is the database
  spending it's time?  What's the bottleneck?  If you identify a few
  trouble sessions, you may want to dive deeper w/ some 10046 traces
 at
  level 8 on specific sessions.  You almost certainly do NOT want to
 do
  this instance wide.
  
  4.)  Once you have some indication as to what's going on in the
  database, you need to see how the system is doing overall.  On most
  flavors of *nix, where I'm comfortable, sar (System Activity
  Reporter)
  is an excellent tool.  Use it to determine if you have any
 systemwide

RE: Utl_file and OPENVMS


Here you are right. You will see here only one because of width. Please 
don't rely on svrmgrl for such info. Instead use sqlplus and check it from 
v$parameter

result is
PARAMETER
--
VALUE


utl_file_dir
/u327/applmgr/10_7/finprod_output/hfs_data, 
/u327/applmgr/10_7/har/1.0.0/mm_cbda
ta

Both entries are appearing here,

HTH
Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 11:13:42 -0800

hmm, when you go into svrmgrl connect internal and show parameters, do both 
show up or just the last one?  on my system, i only see the last.

  [EMAIL PROTECTED] 10/03/02 01:13PM 
Like these

utl_file_dir=/u327/applmgr/10_7/finprod_output/hfs_data
utl_file_dir=/u327/applmgr/10_7/har/1.0.0/mm_cbdata

and these are the last entries in initSID.ora file.

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 07:58:38 -0800

What does your utl_file_dir parameter look like in your init.ora?  I am
using AIX.

   [EMAIL PROTECTED] 10/03/02 11:43AM 
What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no
problem with separate entries as mentioned by Jared. However, don't keep gap
between these entries...and define it the way it was explained by Jared.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct 2002 05:28:22 -0800

On unix, multiple entries in the init.ora file results in the last entry
being the only valid value (i.e. last time variable is set).  I tested below
and only dir3 is listed as a utl_file_dir parameter.  But if you comma
delimit them w/ 1 instance of the variable then all dir's are listed.  Maybe
NT is different, fortunately never had to support Oracle on NT :).

Gene

[EMAIL PROTECTED] 10/02/02 07:13PM 
Gene,

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

The multiple lines shown are actually the documented method for doing
this.

The single line with comma delimited entries may also work, though I'm
not sure about it.

Jared





Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/01/2002 11:25 AM
Please respond to ORACLE-L


   To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
   cc:
   Subject:RE: Utl_file and OPENVMS


i believe its

utl_file_dir=dir1,dir2,dir3,...

in your example, dir 3 would be the only valid dir.

hth,
gene

[EMAIL PROTECTED] 10/01/02 12:53PM 
Make sure you have the directory name entry covered in INIT.ORA

e.g.

utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3

You need one entry per directory that you want to write to using UTL_FILE
Package

Hope this helps

Regards

Shiva




-Original Message-
Sent: Tuesday, October 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L


the vms user oracle needs rights to the directory.

[EMAIL PROTECTED] 09/30/02 10:53AM 
List,
I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4  and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
get the package to write the files to the OS directory.
The package is created by the Oracle user DTSUSER and executed by
DTSUSER. There is no OPENVMS user DTSUSER.
The sysadmin assures me that the permissions are correct to write to
the directory.
I have place a Dbms_output in the package to display the directory
information and it looks correct.
Is there anything different that has to be done to an OPENVMS server
that will allow a package to write to a directory using the Utl_File
package?


Listing from the Oracle tables:

DTS_PARAMETER_NAME DTS_PARAMETER_VALUE

-- --

LOAD_USERIDLOADITUP

LOAD_PASSWORD  ILOADIT

LOAD_SERVICE_NAME  GLC_ALPHADEV-TCP

LOAD_PAR_FILE_DIR  ORADSK:[ORACLE8.DATA.PAR]

LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles]

LOAD_CONTROL_FILE_DIR  ORADSK:[ORACLE8.DATA.CONTROL]

LOAD_LOG_FILE_DIR  ORADSK:[ORACLE8.DATA.LOG]

LOAD_BAD_FILE_DIR  ORADSK:[ORACLE8.DATA.BAD]

LOAD_DISCARD_FILE_DIR  ORADSK:[ORACLE8.DATA.DISCARD]

Listing from the package that writes the parameter file:

Procedure Create_New_Par_File

 (

  P_Current_Table_Name  In  Varchar2
,

  P_Run_DateIn Date,


  P_Load_Userid In

Re:RE: RE: Backups


Richard,

Distateful is being nice.  Try down right horrifying is a more appriopriate
description.  Been There, Done that, now have three Unix SA's who handle it. 
Life is so grand!!

Dick Goulet

Reply Separator
Author: Markham; Richard [EMAIL PROTECTED]
Date:   10/3/2002 10:53 AM

Yes I personally run Veritas Netbackup for both cold and RMAN.  A fiber
SAN has its added benefits as well =).  I have never really explored the
implications of these other utilities.  My head filled with many
distasteful visuals. Yes, I agree with you and I realize that I am
spoiled knocking on wood.

-Original Message-
Sent: Thursday, October 03, 2002 1:38 PM
To: Markham; Richard; Multiple recipients of list ORACLE-L


I've used cpio, dd, and fbackup to do hot and cold backups before, but never
again.  With those utilities the burden of keeping track of what is on which
tape rests with you and normally a stubby pencil  pad of paper because you
know
what won't be available when you need to do a recovery.  They do work be
assured, but the administrative overhead is just not worth it anymore, even
for
a small shop.  Get a copy of Veritas or OmniBack or some other software
package
that does library management for you and preferably integrates with RMAN.
Life
can be so much easier!!

Dick Goulet

Reply Separator
Author: Markham; Richard [EMAIL PROTECTED]
Date:   10/3/2002 10:03 AM

It would be interesting to see how you would explain how either
cp or dd (which know nothing of archive log mode, or the concept
of hot backup, itself, none the less) is going to keep things
consistent, when these utilities themselves are for point in 
time operations.



-Original Message-
Sent: Thursday, October 03, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L


This doesn't sound right.  Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode.  Why wouldn't you be able to recover? 

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the

Re:RE: RE: svrmgrl echo v$database in script


Dan,

For the most part I wholeheartedly agree.  But on the same note I do install
stuff like that in scripts that I expect developers to run  I know exactly what
database their suppose to be in.  On top of that, since the developers don't
have the ability to perform an alter database command to change global_name It's
even safer.  Anything to keep a developer from mucking about where they're not
suppose to.

Dick Goulet

Reply Separator
Author: Fink; Dan [EMAIL PROTECTED]
Date:   10/3/2002 11:43 AM

Dick,
That is one method. My rule is that all destructive actions are run
from scripts that require the database name as a parameter. If the
$ORACLE_SID and parameter don't match, the script terminates. I realize this
is redundant, but better safe than having to perform a production recovery.
I don't have to code in any database specific values like 'DEV', 'PROD',
etc. so the script can be used for any database. My 'stub' korn shell script
already has this built in, so I don't even have to remember it.
As an aside, one of the problems I have had with putting this kind
of code in login.sql or glogin.sql is that it causes problems if the
database is not open. I recall spending a few hours troubleshooting a
monitoring script. It would work just fine while we were developing and
testing, but it would fail overnight in the cron job. The database was down
and the glogin.sql script was terminating. To this day, I still don't put
any queries inside login.sql and glogin.sql. One of those things that is
probably fixable, but I'd rather work in improving my Buffer Cache Hit
Ratio.

Dan

-Original Message-
Sent: Thursday, October 03, 2002 11:42 AM
To: Fink; Dan; Multiple recipients of list ORACLE-L


Dan,

You can use a anonymous PL/SQL block like the following in you login.sql
or
script file is necessary, it keeps those errors from happening:

whenever sqlerror exit
declare
  db varchar2(30);
begin
  select global_name into db from global_name;
  if(db not like 'DEV%') then raise_application_error(-20100, Wrong
Database);
  end if;
end;
/


Dick Goulet

Reply Separator
Author: Fink; Dan [EMAIL PROTECTED]
Date:   10/3/2002 9:33 AM

What happens if the ORACLE_SID is set to one value and the caller uses
SQL*Net to access a different database? While this is not usually the case
in scripts, it could be a problem if the script is parted of a called
function. 
ORACLE_SID=DEV
sqlplus scott/tiger@PROD  -- I'm not connected to DEV anymore.

I realize this is nit-picking, but I've done far too many recoveries because
someone thought they were in DEV when they actually connected to PROD. I'd
rather know EXACTLY which db I'm connected to, not which one the O/S thinks
I should be in.

My $.02

Dan Fink

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


echo $ORACLE_SID  logfile

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 6:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl echo v$database in script
 
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database.  I REALLY want to echo the name of the database into my log file
 before I shut down.While select name from v$database works fine from
 svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
 is
 screwing it up.  (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 Any ideas?
 
 Thx!!!
 
 Barb
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author:   Barb Baker
 # Purpose:  execute shutdown immediate on current database
 #   (i.e., database pointed to by current value of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\  at `date` 
${ORACLE_HOME}/bin/svrmgrl  EOF
connect internal
select name from v_$database;
 EOF
 
 
 $  ./stop_db.sh
 Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGRselect name from v_
   *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Baker, Barbara
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To

RE: Backups


I haven't done nor recommended a cold backup in 3 years since I've been
using Rman.  Just not needed anymore.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, October 03, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L


I still prefer cold backups when performing full OS backups.

 [EMAIL PROTECTED] 10/03/02 02:28PM 
Lest we not forget the archivelogs also during this backup procedure.
Ron

 [EMAIL PROTECTED] 10/03/02 01:53PM 
I forgot about alter tablespace begin backup; etc. I am spoiled, I use
rman
to do online backups.  No problem with recovery!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 12:18 PM


This doesn't sound right.  Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode.  Why wouldn't you be able to recover?

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Thursday, October 03, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup.  If it is not, you
won't be
able to recover.

Just a thot,
Ruth

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 9:08 AM


Robyn,
 We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it  used a lot of tape dumping a raw device when only
a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd
function
is just another OS method of copying data to a tape. I don't know for
sure but I think there might be some issues about transportability of
the dd tape.
Other users will know about the transportability issues.
Ron
 ROR mª¿ªm

 [EMAIL PROTECTED] 10/02/02 08:08PM 
Hello,

I need some info about backups.  I am working on a customer site, and
have implemented both exports and hot backups.  Both jobs copy to a
separate mount point, and a job scripted by another individual then
moves the files to tape.

Here's the problem - he's using a dd command, primarily because it
provides a succinct output he can email to non-technicals.  The file
system is built on a 12 disk A1000 array.  We've provided him with a
ufsdump script, but he's doesn't want to use it. Can the system be
recovered from this tape?  Has anyone ever relied on a dd for a daily
backup method? The system is Oracle 9i on Solaris 8.

Robyn

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Robyn Anderson Sands
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Maili
ng list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: John Weatherman
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To

Re:* Sr. Oracle 8i DBA Needed in NYC- Locals Only..