thx a lot all ,
for the info.
(I'll look out for book Oracle9i for Windows
2000 Tips Techniques)
-Original Message-
From: Michael P Sale [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 7:43 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Archive log full
Hi all,=0D
=0D
How to find out the smallest (minimal) transaction
size from Dictionary vie=
w or base tables =0D
I try to set my OPTIMAL rollback segment base on
smallest transaction size =
to prevent ora-1555. since shrinking rollback
segments may cause ora-1555.=
=0D
=0D
=0D
Thanks =0D
=0D
If you don't want to grant select any table to owner2, try this :
select 'grant select on '||table_name from all_tables where owner = 'OWNER1'
It selects all grant statements, you have to execute them. For this, you may
write a pl/sql block or just execute it as script.
Balazs Farkas
On
BDY.RTF
Description: RTF file
Thanks man,
I mean the minimum optimal size base on the maximum transaction size, So the HWM is
the answer ?
Sinardy
-Original Message-
Sent: 03 June 2002 16:53
To: Multiple recipients of list ORACLE-L
Hi all,=0D
=0D
How to find out the smallest (minimal) transaction
size from
Pkg Variables are Presistent for the session. They Get Deallocated once the
session dies.
So It will not be available for the next SQLLDR Run.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Package is initialized when user first time access it on the session level.
Think about it like each session has a copy of package. Does not matter
which user access it.
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 03, 2002
Hi Stephane,
I run the script and I have
OPTIMAL = 5 * ceil(max(v$rollstat.aveactive) / 4 / sys.ts$.blocksize)*
sys.ts$.blocksize / 1024
the result is 0 K for my optimal. : )
regards,
Sinardy
-Original Message-
Sent: 03 June 2002 16:53
To: Multiple recipients of list ORACLE-L
Hi,
I am calling a packaged function in sql loader
control file.
I 've declared a variable in pkg body to hold old
value . I am comparing
this with current value obtained from sql ldr
and also storing last value in the old value
variable.
My question is will the package variable declared
Thanks man,=0D
=0D
I mean the minimum optimal size base on the maximum
transaction size, So th=
e HWM is the answer ?=0D
=0D
=0D
Sinardy=0D
=0D
Depends. If activity was 'normal', yes (if HWM is about the same for all RS, you can
be fairly confident with the value). If somebody has run a big
So, If I am working a long time why should I now quit and move to work with
them?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 31, 2002 4:19 PM
Great Company located in Greater Dallas, Texas area (Richardson)
Hi,
OS : AIX 4.3.3.0
RDBMS : 8.0.6.2.0
We have a Unix daemon write in Pro*C that wake up every X minutes (I think
it's about 1)
to look at one table on an AS400 via dblinks and transparent gateway from
the AIX server.
Our problem is that the shadow process constantly increase his consomation
BDY.RTF
Description: RTF file
Hello Itiu
You wrote: Most people use it :
We have a saying: zillions flies can not be wrong, eat shit.
BTW - We use NT servers.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, June 02, 2002 2:43 AM
What's wrong
Hi Stephane,=0D
=0D
I run the script and I have =0D
=0D
OPTIMAL =3D 5 * ceil(max(v$rollstat.aveactive) / 4
/ sys.ts$.blocksize)* sy=
s.ts$.blocksize / 1024 =0D
=0D
the result is 0 K for my optimal. : )=0D
=0D
regards,=0D
Sinardy=0D
Probably not enough significant activity. It tries to set
Hi,
OS : AIX 4.3.3.0
RDBMS : 8.0.6.2.0
We have a Unix daemon write in Pro*C that wake up
every X minutes (I think
it's about 1)
to look at one table on an AS400 via dblinks and
transparent gateway from
the AIX server.
Our problem is that the shadow process constantly
increase
Frederic,
Please ask the PRO*C programmer if they are making any use of the C
malloc() library at all in that program, or anything similar. If so, then
the most likely problem is that they are not properly freeing memory after
grabbing some more. This is a very common mistake when writing
...and what makes you think that we all don't? Do you know anything about
how wine and beer are made?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 03, 2002 5:43 AM
Hello Itiu
You wrote: Most people use it :
We have a saying:
Hello all. I am seeking opinions of experienced database folks on this
issue:
I am implementing a replication environment between IBM DB2 and UNIX Oracle
using DataMirror's Transformation Server (TS) product. TS replicates and
transforms data between disparate databases. (Right now I am
Hi all,
I've recently been asked to set up an extproc listener and as this is the
first non-apps one I have had to deal with, I was hopping somebody could
give some pointers. I have RTFM, and sarcasm it's oh so clear /sarcasm.
Anyway, how does one go about figuring out the LISTENER_KEY? Is the
In address_list to listen for extproc connection through IPC protocol use
EXTPROC0 as a KEY.
SID_NAME for extproc is always PLSExtProc.
ORACLE_HOME is your regular oracle_home directory.
Here is an example:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
Read on Oracle's Heterogeneous Services, allows to connect (through db-link)
to foreign databases using ODBC.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, June 02, 2002 8:08 PM
i want to be
I'd never heard that Oracle has stopped
or is stopping support for Tru64.
We have more than 35 production databases
on Tru64 and have no intention of moving
out of Alpha-Tru64 in a hurry. We're even
looking at upgrading a mission critical
8iOPS cluster on Tru64 to 9iRAC on Tru64.
Hemant K
Pat
Excellent summary. I have only a few points to add. I must point out
that I am an RMAN novice, just getting brief spurts of time between other
people's priorities.
- If you use RMAN to back up to disk, I haven't figured an advantage to
backing archive logs up with RMAN. If anyone
Well, from a browse of Metalink, if your on a version of TRU64 = 5.0 you are
desupported.
Dick Goulet
Reply Separator
Author: Hemant K Chitale [EMAIL PROTECTED]
Date: 6/3/2002 6:53 AM
I'd never heard that Oracle has stopped
or is stopping support
Stephane, Hemant
Below is the official word that I pulled off HP's website. It is
straight PR material, so read between the words as you choose. As I recall,
Compaq had already decided not to build the next-generation Alpha chip
before the merger arose. If you are interested, I would
I dunno about MySQL, but from oracle you can have external procedures
accessing MySQL and returning data into oracle. There is also a TNS API
which allows you to write your very own transparent gateway and select
data from MySQL.
-Original Message-
From: Gabriel C Millerd
I can confirm that Tru64 is quite alive and well at Oracle, no desupport
seen in the future. In fact there are new efforts going into Tru64 RAC.
Even when the alpha goes away there is an effort to port Tru64 to the
intel platform, but who knows where that is going with the merger :)
Regards,
Hi List,
Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all, My question is for installing
any patch
Some of you may recall a question I posted on a problem with MTS connection
pooling. MTS continued to try to connect to our old IP address after
switching between production and standby. This happened even though we
switched the IP address the DNS Name was pointing to.
Well, we finally managed
All,
For what its worth, I believe Rachel has the best approach to the SA / DBA relations dilemma. -).
Another approach, I developed, consists of a matrix that helps delineate SA, DBA, lead and Architect responsibilities.
Please feel free to download it and use at will. The on-line version
Ron,
Thanks for replay, But still don't know what I have to do to solve the
problem, do I have to change some thing or what?
Can you please explain more?
Thanks allot
-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L
You generally get this
Oracle database patchsets for UNIX are cumulative. Applying the latest
patchset will include all of the fixes in previous patchsets for the
same baseline version. (i.e. The 8.1.7.4.0 will include the fixes in
8.1.7.3). Unless otherwise noted, you can apply the latest patchset
with out applying
You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc
points to the
wrong OraInventory directory.
We just went to 8.1.7.4 to resolve some issues with .2. So far, so good.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they
I have also two other instances running on 8.1.6.2, This upgrade may be
effected from these version of Oracle or not, or this upgrade can be totaly
independent from 8.1.6.2
I am a bit confused, Need your advise guy
Thanks allot
-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To:
Dennis :
Good point. It was not clear in my note - but yes we are going with a
server that is dedicated to RMAN and OEM.
Instead of using the 'cross-mount architecture' we decide to backup the
Oracle Database (RMAN and OEM) that reside on this server using a manual
script based hot backup
Dennis ;
You are absolutely right - the DISK option has a big down side that I did
not catch :
In a disaster (computer room fire) the daily archive logs would be lost
leaving you without the ability to roll forward your database - and thus the
loss of data. Therefore if you were to go with
Thanks for all the helpful suggestions. Here is what worked:
Query:
SELECT Record_Type, Archive_Input_File
FROM MDMA_Input_File
GROUP BY Record_Type, Archive_Input_File
I modified the record_type column to not null. This allowed an index FFS which the
optimizer wisely selected.
The update
I couldn't find/var/opt/oracle/oraInst.loc I am on solaris which
directory I have to look for looking at this file
-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L
You generally get this error if the conents of the file
http://metalink.oracle.com/oracleinstall/oracle8i/windows.html
this and a couple other links i've read, give the impression that oracle
with terminal server/services is not supported. is there a work around to
allow you to user terminal services and oracle?
i'd like to use sqlplus and connect
This is why we:
1. Use a separate tech stack (oracle home) for each instance.
1a. Use a separate unix account for each oracle home for total isolation. The DBA
here is real
anal. (BTW, that's me).
1b. I've also found that it is easier to use one listener for each instance instead of
one
It works fine ... the problem is when you go in for support. But if you can
reproduce the error in normal environment (i.e. without terminal server)
they will support you.
YMMV
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot
Yes, there is a workaround. I use terminal services for everything,
including installs and have not had any issues.
You have to force everything to go through sqlnet by using @sidname, and
never use the bequeath adapter.
SVRMGRL connect internal@yoursid
SQLPLUS username/pwd@yoursid
or
c:\
Someone from the list will need to respond. I work on HPs here and I haven't done a
Sun install in
a few years.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.
--William Butler
Yeats.
You mentioned disk management issues... A problem with disk is that you
are probably limited to only doing level 0 backups. If your recovery spans
multiple RMAN backups then it could be a real bear trying get everything
you need to recover if you're staging from disk to tape. You'd have to be
That file is the pointer for the installer to know where to look
for things. It's usually in the same place as oratab. As for the SUN
install, let me quote the girl from the original Jurassic Park: It's a Unix
system! I know how to use that!
-Original Message-
From: Ron Thomas
Where is your tape during the computer room fire? We have a script that copies
archivelogs to a remote server. This way, when the computer rooms burns, we can
recover up to the last log switch (which we also force via a script a few times a
day). We only keep 1 day's worth of archive logs
Dear List,
When I run dmesg command from oracle account on HP-UX 11.0, it responds as
can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x.
Could someone tell me what needs to be done in order to execute dmesg
command successfully from oracle account.
Thanks,
--Babu
--
Please
I find that not setting OPTIMAL seems to be optimal.
Jared
Sinardy Xing [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/02/2002 09:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Rollback Segment
Hello All Again,
I just find the OraInst.loc and here is the content of the file:
inventory_loc = /opt/home/rcosme ...don't know what's this mean?
inst_group=
This is all about this file, Is any body know what contenet this file must
have, Do I have to put Oracle userID address here or
Steve, Pat
In our experiments so far, we had enough space to leave the level 0 backup
on disk. The other incremental backups are so small compared with the level
0, that they aren't a problem. We keep a couple of weeks of archives on
another disk anyway. All these can be backed up to tape
To read kernel memory requires root privs, so don't think there is a way
to do that from the oracle account without some undesirable hack.
Janardhana Babu Donga wrote:
Dear List,
When I run dmesg command from oracle account on HP-UX 11.0, it responds as
can't read kernel memory. The
/etc/dmesg: 'can't read kernel memory' - must be root
http://welcome.hp-ww.com/country/img/arrows/a_ff9900.gifprintable
http://support2.itrc.hp.com/service/cki/docDisplay.do?printable=truef_Pass
Babu,
This should be possible if your SysAdmin sets the SUID bit for dmesg. I see
no harm in doing this, but it is essentially upto your SYsAdmin.
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
The manuals for Oracle are here: http://tahiti.oracle.com
The manual for Life
I have compiled a list of 'rman configuration recommendations' that I have
based my RMAN deployment on.
I am sending this out to the list for general discussion.
If you have anything to add let me know - I am learning as I go.
PS : Either CC me on all question responses or I will get back to you
1. Use a separate tech stack (oracle home) for each instance.
In general I like the idea, but it gets a bit pricey on disk space if you
are running say 20-30 instances on a given box doesn't it??
1a. Use a separate unix account for each oracle home for total isolation.
The DBA here is
real
Suzy,
Thanks for your reply. I needed it because Oracle has supplied a script:
InstallPrep.sh on Metalink which check the server to ensure that it has
adequate resources to successfully install Oracle9i database software. It
should be run as oracle user only, but it executes dmesg command. It is
All:
Remember this? Well, after losing an support analyst, we finally got the
java stuff to work with 9iR2...the problem was the inventory_loc=/opt/oracle
entry in /var/opt/oracle/oraInst.loc. it should have been
inventory_loc=/opt/oracle/oraInventory
The installer did not complain that it
but many (and especially older hands) Oracle DBAs consider M$ systems to
be for wimps,
just good for running Access and possibly SQL Server.
Yea... and I'm sure that there are those older hands that would prefer the
days of the
card punching return :-)) Old habits and ways are hard to
There are several solutions to this that I can think of besides just going
to tape...
Duplexing the backups to different disks in different physical locations is
one,
or using some sort of remote mirroring strategy is another. If you have an
offsite
DR location that you can duplex to (on disk)
Dennis,
Which MML and how much $$?
The Oracle client for Veritas is about $3500. Small change
for a piece of a backup system.
Jared
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/03/2002 12:33 PM
Please respond to ORACLE-L
To: Multiple recipients of list
Janardhana Babu Donga wrote:
Dear List,
When I run dmesg command from oracle account on HP-UX 11.0, it responds as
can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x.
Could someone tell me what needs to be done in order to execute dmesg
command successfully from oracle
Ban M$, run Linux.
Dick Goulet
Reply Separator
Author: Freeman; Robert [EMAIL PROTECTED]
Date: 6/3/2002 12:08 PM
but many (and especially older hands) Oracle DBAs consider M$ systems to
be for wimps,
just good for running Access and possibly SQL
this way you are not writing unnecessary information to the RMAN
dictionary.
Isn't the data that goes to the RMAN repository so small that this is moot?
take one step back and begin by configuring RMAN to backup to disk first.
I've used the sbttest utility that comes with Oracle to test the
Oracle really seems to have messed up considerably with the oraInventory
directory. I've had several problems and from reading various threads it
seems that I'm far from the only one.
-Original Message-
Sent: Monday, June 03, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
All:
Hi,
Does anyone know where to get a trial version of
Oracle Financial, or other components of 11i?
Thank you!
Leslie
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official
List,
Can some body tell me what's the usage of oratab orainst.loc files (sun
solaris OS), I am getteing confused because I have two diffrent Oracle_home
but just one one Orainventory Directory, It shouldn,'t be for each
oracle_home own Orainventory directory???
Appreciate your HELP.
Thanks,
Leslie,
Go to the Oracle web site and click on the store icon and check out
the CDPACKS for $40 each. You can get anything for your own play
evaluation purposes.
Ron
ROR mô¿ôm
[EMAIL PROTECTED] 06/03/02 04:58PM
Hi,
Does anyone know where to get a trial version of
Oracle Financial, or other
Ron,
That's fine for everything BUT E-Business Applications (and isn't that
what most people want?) from the web page - * We do not offer trial
licenses for our E-Business Suite Applications.
Leslie,
Be prepared to spend at least $40 and LOTS of learning time to install to
try. I don't think
Title: RE: So, What is a 'Production DBA'?
Guys,
In my experience there are so many issues that come up in design that eventually affect the quality of life for a production dba that I have real concerns splitting the role. In my world as much as possible I do both starting with design I
Title: RE: foreign key what help!!
Okay guys,
Have foreign keys defined on large dw tables. When loading get foreign key errors. However, after load (w/o change in data and supposedly data it was barking on) could create fk's just fine on the same data elements involving the same data
There isn't a separate orainventory for each ORACLE_HOME. A single
orainst.loc file defines where orainventory is located, and the
orainventory contains info about what is installed for all versions of
Oracle on the system (8i and above).
A single oratab file is used by all versions of
Thanks,
So why when I try to Upgrade from 8.1.7.0 to 8.1.7.4 installer get confused
and looking for a installed patch?
What the content of oratab should be?
I have the following values in my oratab:
STAR:/u01/app/oracle:Y 8.1.6
CQST:/u01/app/oracle:Y 8.1.6
HMS:/u01/app/oracle:N8.1.6
Hi All,
Anyone have any sites where they are doing performance compares of linux vs
solaris or any other OS.
TiA,
-bill
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Conner
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Title: RE: foreign key what help!!
are
you loading more than one table? could you be loading child records b4 the
parents are inserted?
-bill
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002
6:13 PMTo: Multiple recipients
Hello Hamid,
I don't think your problem with the patch has anything to do with the oratab file. I
had an identical problem upgrading a server from 8.1.7.0 to 8.1.7.3 where the
installer insisted that no patch was needed. I had this happen on two different
servers.
In my case, predecessors
Hi List,
I just find this on Metalink:
If an inadvertent attempt is made to apply this Patch Set to a non-8.1.7
release, then a warning dialog box entitled Dependencies is displayed which
contains the following error message:
There are no patches that need to be applied from the patch set
Title: RE: foreign key what help!!
It is
probably a question of timing when Child records are loaded before Parents. It
can be a question of table order or even record order (self referencing
relationship). Once the data is loaded, enforcement of the constraint is easy
because all of
The Y or N indicate to the dbstart program whether each database will be
started on system startup or not
I do not think the installer will take any note of these settings. It only
uses the oratab file to determine the Oracle_home settings (as well as using
the environment/registry settings)
HTH
The oratab doesn't look right to me. The second token should have the
full path to ORACLE_HOME for each version. Unless of course Oracle is
*really* installed under /u01/app/oracle instead of
/u01/app/oracle/8.1.6, in which case that doesn't follow OFA standards.
STAR:/u01/app/oracle/8.1.6:Y
You said:
There isn't a separate orainventory for each ORACLE_HOME. A single
orainst.loc file defines where orainventory is located, and the
Not necessarily (and not recommended). It is very easy to setup an orainventory file
for each
installation. Check metalink for details.
Ron Thomas
Debi, did you happen to go to technet.oracle.com and see if want you
need is there?
joe
[EMAIL PROTECTED] wrote:
I can't find the generic rdbms README anywhere on my server for 9iR2.
There are 42 readme.txt files on the server in a variety of formats/cases
making it difficult to find:
On Mon, 3 Jun 2002, Gogala, Mladen wrote:
I dunno about MySQL, but from oracle you can have external procedures
accessing MySQL and returning data into oracle. There is also a TNS API
which allows you to write your very own transparent gateway and select
data from MySQL.
is this the
On Mon, 3 Jun 2002, Igor Neyman wrote:
Read on Oracle's Heterogeneous Services, allows to connect (through db-link)
to foreign databases using ODBC.
this seems more like the way to go .. i didnt expect to have to program
anything rather configure oracle, a mysql driver, and transport
What about $ORACLE_HOME/rdbms/doc/README_rdbms.htm?
HTH
Lyubomir Petrov
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 03, 2002 4:48 PM
I can't find the generic rdbms README anywhere on my server for 9iR2.
There are 42 readme.txt
I did find the readme on MetaLink but I need to give the location to others
in our office who don't have access...and the readme says it was installed
on the server! If I don't find it I will just copy the file from MetaLink,
convert it to ascii text, and put it on the server myself. I
There is no Trial version of the E-Business suite. Check with your Oracle
salesperson to see if you can work something out.
Mike
Hi,
Does anyone know where to get a trial version of
Oracle Financial, or other components of 11i?
Thank you!
Leslie
Whaddya mean by run html? HTML files are not run, they are viewed in
Galeon,
Mozilla or, pardon my French, IE.
On 2002.06.03 22:38 Debi wrote:
I did find the readme on MetaLink but I need to give the location to
others in our office who don't have access...and the readme says it
was
$ ls -l $ORACLE_HOME/rdbms/doc
total 236
rw-r--r--1 oracle dba239804 Jun 2 18:50 README_rdbms.html
$ sqlplus scott/tiger
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jun 4 00:16:33 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
89 matches
Mail list logo