i did exactly the first thing you named.
RE: composite primary key versus unique index
---BeginMessage---
You mean you created an index A on the table with the descending column
order, and then added a primary key constraint, which created another index
on the same columns (except that all the
Hi all. Thanks to all who replied. I'm still trying
to speed the things up and wondering whether someone
can explain what is paging to file system is
referring to? Does this indicate that I don't have
enough memory? Is it related to reads? Anything else?
Yes it does relate to a lack of
also check the value of CONNECT_TIMEOUT_lsnr,
its default value is 10 (secs).
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 11:04 AM
Oh boy!
You need to fix that firewall. You should
a) allow your local nodes to go out on
--_=_NextPart_001_01C346BE.A37BB570
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Didn't this guy get himself an entry in the Darwin awards? Sounds
familiar...=20
A RR jet engine in a car Cute idea! There is an urban legend about a
military guy
Hi Arup and Joe
When I wrote the SANS Oracle security step-by-step book I wrote in there
the list of restrictions for log miner including that is didn't support
selects and during the review process of my book someone in Oracle who
was reviewing it informed me that selects would be in the redo in
We used a similar idea on an in-house application - hard-coded the role
password into the application.
Neither approach is perfect, if someone wanted to try hard enough they
could reverse-engineer the app, or try and pick up the password by spying
on the sql*net connection.
For practical
I seem to recall from Jonathan Lewis' book that moving a LOB index after
creation was possible in some versions of 8.0, but no longer possible in
8i. Unfortunately, I don't have the book in front of me right now so I
can't say for sure.
If packets are dropped, increasing timeout will not help.
There are things in this world which cannot be done by
modifying oracle parameter values.
On 2003.07.10 05:19, Manoj Kumar Jha wrote:
also check the value of CONNECT_TIMEOUT_lsnr,
its default value is 10 (secs).
- Original Message -
Hi!
Maybe they were thinking that if you audit select statements, you can
analyze inserts on AUD$ using logminer later on
Anyway, if there's any future release where selects can be in redo, I hope
they aren't there by default..
Tanel.
- Original Message -
To: Multiple recipients of
Hi Jacques,
It sounds like the encrypted password is read by the client? and
decrypted on the client? or in the database as a package procedure?. If
it was decrypted in the client and then the set role command was sent to
the database the password could be read from the network with a tool
such
Is having multiple addresses valid for a tns entry?
A client provided this to me and initailly looked invalid
alias =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526))
it's valid.
if there is no response on the first port, Oracle tries the next etc
etc etc. It's a means of failover or allowing for continuity of
connections while doing maintenance on a listener or server
--- Bob Metelsky [EMAIL PROTECTED] wrote:
Is having multiple addresses valid for a tns
I think this is used in Parallel server environments. I have seen something
similar (maybe not exactly) so it could well be valid. My understanding is
that it should be working it's way down the list or pick a random address
depending on (not much experience with OPS/RAC)
Jack
-Original
Add FAILOVER=ON and it will check the next address if the previous
one has failed. Alternatively, use SOURCE_ROUTE=ON and it will check
every single one of them if the previous one fails.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent:
Thanks Rachael
Getting some more feedback on this
What this appears to be is a cluster configuration with a middle ware
capability ( like Oracle FailSafe) to fail a database over from one node
to its backup. This would be the reason each IP is configured with two
ports.
That sounds
Stephen
From what I understand from our Web administrator, the netcraft site
just reports the web server that is used, not the application server or
database.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]
Title: Location of trace files and alert log
How do I locate where all trace files and alert log are saved? There is no parameter setup in init.ora file.
Thanks,
David
Title: Location of trace files and alert log
SQLshow parameter background_dump_dest
SQLshow parameter user_dump_dest
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 10, 2003 11:44
AMTo: Multiple recipients of list ORACLE-LSubject:
Title: Message
We have a future
needto create an Oracle database on a mainframe (MVS) which will then pull
data from an Oracle database on an HPUX box. I know nothing about MVS so
does anyone know of any connectivity problems between the two boxes? For
example,SQL*Netdoes come with the
query v$parameter?
joe
Nguyen, David M wrote:
How do I locate where all trace files and alert log are saved? There
is no parameter setup in init.ora file.
Thanks,
David
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
--
Please see the
Title: Location of trace files and alert log
Yes thereare ...
Originally called ... SAVE_ALERT_LOGFILE_DIR and SAVE_USER_TRACEFILE_DIR
... but they were replaced with various *_DUMP_DEST parameters ... because the
committee who certifies and performs code reviews didn't have sense of
humor.
--_=_NextPart_001_01C346F5.C2C8F737
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
All,
=20
=20
We are implementing portal 9iAS rel1 and for the failover purposes we are t=
rying to find out if it is possible to have the two nodes (iAS homes) point=
Title: Message
I have
done a little of this. TNS is there but I don't know about Pro*Cobol, I
would assume so. Database links between MVS and HPUX work as
expected.
Allan
-Original Message-From: Terrian, Tom
(Contractor) (DAASC) [mailto:[EMAIL PROTECTED] Sent: Thursday,
Title: Message
great,
thanks Allan
-Original Message-From: Nelson, Allan
[mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 12:19
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle on a mainframe (MVS)
I
have done a little of this. TNS is there but I
Works for me. I just did a the test on Oracle 8.1.7. Here is the trace
file. Note the nsopen: unable to open transport after trying to find host
fleming. Then it goes on to try host altair which succeeds. One thing
though. The host must not exist or be unreachable. If the host is reachable
but
Title: Message
I've
started with Oracle 5 on MVS a very long time ago, ProCobol was
there.
It is
probably still there since it is the most popular language on
mainframes.
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
www.standardlife.ca
Ravi:
Do you have a statspack report? I would like to see that. But
in any case, 45% kernel is just too much?
BTW have you verified the private interconnect is used
for cache fusion transfer.. Make sure the cache fusion
is not going thru the public network.
Best Regards,
K Gopalakrishnan
In a RAC environment, what is the best way to synchronize the time clocks on the
nodes? It seams I came across a case where select sysdate from dual; produced two
different values.
Thanks!
Nick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nick Wagner
INET:
I had a similar experience on OPS when we tried with
releasable locks. What is the platform? What kind of
interconnect do you have?
On 2003.07.10 12:44, K Gopalakrishnan wrote:
Ravi:
Do you have a statspack report? I would like to see that. But
in any case, 45% kernel is just too much?
BTW have
Title: RE: RAC system Calls
You seem to have timed_statistics=TRUE right ?? in RAC you will ALWAYS see GCS pings ... basically as long as cluster_database=true, even if only one node is running, you will still see Oracle trying to ping other instances.
My guess is that's what is happening
To ALL,
If any of you have an Time accounting application in house called Smart Time,
would you please reply privately? I've a few questions.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
And are you using jumbo frames on your interconnect? That can make a
significant contribution to reducing overhead from a system standpoint.
Thanks,
Matt
--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com
-Original
Title: RE: RAC time clocks (sysdate)
Our sysadmins use ntp or something like that ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can
The Oracle Applications Users Group Database SIG will be holding elections
for Vice Chairman and Secretary on September 14 at the OAUG conference in
San Diego. If anyone is interested in being an officer, please go to our
website for more information (http://datasig.oaug.org).
--
Michael Brown
We're considering high availability options. One of our requirements
is to be able to take one database offline (i.e., direct all
application connections to a second database server), perform database
and application upgrades, and perform a few hours' worth of tests
before bringing it back
Exactly. Surf over to http://www.ntp.org and follow the links to download
(binaries or source), install, and configure.
If it were me doing it, I'd probably setup an existing local non-RAC
Internet-connected server (if available) with ntp to sync to an external
stratum-2 server (see ntp docs for
Title: RE: RAC time clocks (sysdate)
thanks!
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 10, 2003
10:40 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: RAC time clocks (sysdate)
Our sysadmins use ntp or something like that ..
Raj
Hi!
Is this your own-written app?
If you want performance, control and
no-data-loss reliability:
1) Have 2 completely independent
databases
2) Have your application servers
multiplex
all DML requests to both
database servers
That means, if your
client inserts something,
then app
Title: RE: RAC time clocks (sysdate)
Yup ... we got redundant time servers on dedicated boxes ... they feed to unix/windowz clients. No production boxes are EVER exposed to ANYTHING outside a firewall.
Raj
I'm hoping for expert assistance. I'm using SQL*Loader to load some
2200+ records (comma delimited) into a table and running into this
problem for the modcnt field:
The control file reads:
modcnt DECIMAL EXTERNAL -- I'm sure this is where my problem is. I have
tried almost every datatype that
It is our own application. That's an interesting approach, thanks!
--- Tanel Poder [EMAIL PROTECTED] wrote:
Hi!
Is this your own-written app?
If you want performance, control and no-data-loss reliability:
1) Have 2 completely independent databases
2) Have your application servers
are you suggesting that they basically write their own home-grown
version of replication?
If so, I believe Peter Robson has already done this in his shop and may
be able to share the code, or at least give a list of gotchas.
seems a bit excessive and prone to error and failure to me.
---
Title: RE: High availability and upgrades
Tanel,
points 1 2 isn't it like using data guard ??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
Matt,
What are jumbo frames? Are these assigning private
network IPs to cluster_interconnects parameter?
-Ravi.
--- Matthew Zito [EMAIL PROTECTED] wrote:
And are you using jumbo frames on your interconnect?
That can make a
significant contribution to reducing overhead from a
system
Title: dbms_repair question
Okay ... so I used dbms_repair today for the first time ... found one corrupt row in a table. dbms_repair.check_object populated the repair_Table and data shows corrupt_type = 6148 and corrupt_description is null. This gives me no clue ... so does anyone know what
Title: Message
Beware, NTP can be a complicated critter to get working in a proper
fashion. The best way to configure your NTP is to have one ortwo
local stratum 2 or stratum 3 servers that all of your nodes sync off of (a good
choice for these servers are servers that do other low-load
Jumbo frames are the use of larger than normal MTU (Maximum Transmission
Unit) settings on gigabit Ethernet links. The traditional limit for
Ethernet frames is 1500 bytes, which was fine for 10 and 100 megabit
Ethernet links. With gigabit, however, since you lose a certain minimum
amount of
can anyone please help?
errors like below when any of the redo or rollback raw LVs are created using stripe:
CREATE TABLESPACE RBS DATAFILE '/dev/vgrbs/rrbs01.dbf' SIZE 8000M REUSE AUTOEXTEND OFF
MINIMUM EXTENT 512K DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS
UNLIMITED )
Hi!
I wouldn't call it replication, because data is not replicated from one
database to other. The DML feed always goes from app servers to all active
databases. One database doesn't even have to know about existence of other
one during normal operations, it's done on app server (client) level.
Title: RE: High availability and upgrades
Hi!
In data guard, when you do a DML, it first goes to
primary instance log buffers, then to redolog, then to standby host using log
transport services, then applied to stanby using log apply
services.
Thus, in data guard maximum protection mode
Hey Matt!
I thought that it was a bit of proper manners to avoid hitting the public
stratum-1 servers unless you were planning on being a public stratum-2, just
to avoid overloading the stratum-1s.
Thoughts?
Rich
Rich Jesse
System/Database Administrator
Quad/Tech Inc.
A Subsidiary of
Is he trying to do failover or load balancing?
Bob Metelsky
Ugh - this is a tricky idea for a couple of reasons. What happens when
one database goes down? When its brought back up its no longer in sync
with the original, and has to be brought up to speed somehow (I see that
you mention that, but that in and of itself is a project). Besides
that, what
I don't know, thats what Im trying to figgure out. Non the less the
connection works, It looked weird to me (on the first impression)
I suppose I could ask, I was just wondering if this was an easily
identifiable entry
Thanks
bob
Is he trying to do failover or load balancing?
--
Oh, that could definitely be true. My impression on that point had
always been that the really bad form was to have all 100+ hosts on your
network hit the public stratum-1 servers, hence the delgation to local
stratum-2s. But it is definitely better form to never touch the
stratum-1s. So, if
The problem is that if the decryption and set role were done inside a database
package, then that means that the Oracle database user needs execute privilege on the
package, and so the user could call the package from inside SQL*Plus on the client.
At my old company they were talking about
Here is a good one:
create or replace directory bdump as
'/oracle/admin/o9i/bdump' / grant read on directory bdump to
public / create table alert_log_ext ( line varchar2(2000) )
organization external ( type oracle_loader default directory
bdump access parameters
(
records
And load 'em to CLOBs as well and use InterMedia Text to index them ;)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 12:59 AM
Here is a good one:
create or replace directory bdump as
'/oracle/admin/o9i/bdump'
Hi!
In the case of 1), not only have you not given yourself high
availability, you've actually reduced the MTBF for your system, since
you'll go down twice and often. In the second case, you've got data
consistency problems - log mining is fine and dandy, but how do you deal
with a
Matt, can you elaborate a bit? Configure your two servers in a
cluster how: RAC, FailSafe (these are Windoze servers,
unfortunately)?
Third mirror implies the two nodes share a disk cluster in which all
active drives consist of three mirrored copies; when the third mirror
is split off, the
If you have more databases, there are synonyms, views and db-links.
That is classic DBA patchwork. The funniest siutations arise when
you have a circle of synonyms and db-links pointing to each other,
just like perpetuum mobile. What is impossible in thermodynamics, is
possible in oracle. It
COBOL, SQL*Net, DB_Link...it's all there.
You might want to follow these links to the dark side
http://www.mvsoraclesig.org/
http://www.oramain.com/welcome.htm (this guy runs the users group)
Cluster - like Microsoft or Veritas - strictly active/passive, though
you could do RAC if you wanted. That's for high availability - one box
goes down, the other one either stays up or kicks into action.
Third Mirror - absolutely correct. It could be a whole separate storage
array or just a
Hey Matt,
Thanks for the useful info.
into a smaller number of ethernet frames,
reducing both latency and overhead. Ideally, each
block will fit into one ethernet frame,
We are using 16K blocksize, so we cannot avoid
datagram splits with 9k frames - but certainly, sounds
better than with
Raj,
Yes. Timed_statistics=true. But I see the 'times' even
in single instance(non-rac)database but relatively
called negligible number of times.
-Ravi.
--- Jamadagni, Rajendra
[EMAIL PROTECTED] wrote:
You seem to have timed_statistics=TRUE right ?? in
RAC you will ALWAYS see
GCS pings ...
Nah - no reason not to use it, especially given how long they've been
around. Basically you should enable jumbo frames everywhere you can -
whenever your box talks to a host that doesn't support them, it just
won't use them, and when it can it'll get the performance advantage
(side note: your
Hi,
I have a database (200GB+ 8.1.7.4 version) on Vxfs file systems on a Sun server (
Solaris 8), which I need to migrate to Ufs file systems mounted on same server. To cut
the migration time,
can I copy the database files from vxfs to ufs ie across the different filesystems
type. Has anyone
Hi!
Yep, there should be no problems. It is possible to copy files to and from
raw devices (with one issue of raw device header block(s)).
And if you want to cut migration time, then make a full online backup to
your ufs file system, then shutdown your production and do recovery of ufs
database.
We use a similar process for several of our in-house applications. The users
get an Oracle id that only has create session. The application prompts for
the users username and password and attempts to login to the database. If
the login succeeds the application closes the connection and then logs
Thanx Mladen.
i have got some scripts now.
i have to try one by one and find out which suits my need.
thanx u all.
Jp.
10-07-2003 09:09:24, Mladen Gogala [EMAIL PROTECTED] wrote:
Here is a good one:
create or replace directory bdump as '/oracle/admin/o9i/bdump'
/
grant read on directory bdump
Idea for testing: looking for redo associated with select
statement(s) that are cleaning out row level locks in
block(s) from previously committed DML transaction(s).
Have Fun :)
Tanel Poder wrote:
Hi!
Maybe they were thinking that if you audit select statements, you can
analyze inserts on AUD$
Hi, All,
When an unique constraint is violated, is there any way to know which record
cause this problem?
TIA,
Chuan
Important: This transmission is intended only for the use of the addressee
and may contain confidential or legally privileged information. If you are
not the intended recipient,
There is a way, but you have to master the Tao first. When you
do, you will not ask questions like that. Short of that,
you could try selecting the record(s) from the table which
have the same unique key as the record you're trying to insert.
Truncate table will also rid you of the problems with
Title: Message
is
following correct ,
'total foreground time' = 'cpu used by this session'
+ 'total of Foreground Wait times'
or
is 'cpu used by
this session' includes also 'total of Foreground
Wait times'
74 matches
Mail list logo