Hi All
I have problem related to listener. On my machine I have Oracle
8.1.5 on RH 6.2. When I issued the command $ lsnrctl I got the
following error message
lsnrctl: error in loading shared libraries: libskgxp8.so: cannot
open shared object file: No such file or directory
I have downloaded
Sorry
I meant to say partitioning is not available in SE - not replication.
Yechiel Adar
Mehish
- Original Message -
To: [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 3:21 PM
Yechiel - Do you have more information (9i and replication)? Previously
there was a document on Oracle's
Sam,
I think this will work. Can you please try it out and
let me know if I understood your problem correctly.
select t1.c2,t1.c4,t23.c2,t23.c3,t4.c4
from t1,t4,( select t2.c2 c2 ,t2.c3 c3 from t2,t3
where t2.c3=t3.c3) t23
where t1.c4=t4.c4(+)
andt1.c2=t23.c2(+)
and exists
(
select 1
You have my sympathy, as I've been in a similar situation after getting a
designer install thrown at me.
I can only offer general advice, as we hit a series of different bugs that
eventually led to abandoning designer, you've probably heard it all from Oracle
support already...
Make sure
On Thu, May 09, 2002 at 02:53:19PM -0800, MacGregor, Ian A. wrote:
* The way it fails:
* If the schema is required, OCIDirPathPrepare() should fail with an error. A
crash/core dump is an ... unconventional way of indicating an
error.
Sadly not very unconventional for OCI :(
Tim.
--
Hi ALL,
1.
How do I get know memory usage by karnel,application
programs,Filesystem Cache etc in SunOS 5.6 . I do not
have the RMC package installed in my m/c
2.
How do I know if the ORACLE is using Raw/UFS ?
3.
If I set _filesystemio_options='directIO' instead of
'async' will that save
I remember once a designer package compiled forever, it just hang up ...
I looked in the previous release of Designer and found that the code has
been changed although the meaning was really the same. So I took some 5-10
lines from previous version and voila! - it worked. Later this was
Torben Holm from Miracle created the Trace File Repository, which is a neat
little utility to put data from the 10046 output files into a couple of tables.
Then it's entirely up to you to either use one of Torbens pre-created output
formats or create your own. Torben - where can these guys get
1) Oracle uses the registry also to register some staff in other places
except the oracle entry.
2) Oracle also use c:\program files\oracle for some stuff (install log
etc.).
Why do not upgrade the machine without recreating C partition.
(I know that upgrade is more work then ghosting a new C
Sean,
We did a straight upgrade of an NT box to Win2K (some time ago) that held an
Oracle 8.1.6 database.. The database was fine after the upgrade.. What is
the choice for recreating rather than upgrading?
Mark
-Original Message-
Adar
Sent: 10 May 2002 12:29
To: Multiple recipients of
[EMAIL PROTECTED] wrote:
I think enough has been said already - I didn't intend to name the company at all.
Actually, I
don't think that I said that all the managers were incompetent. (A select few in
the wrong places
perhaps.) Since the cat is out of the bag though, I will try to end
And I respectfully agree that I was wrong :)It happens, I think I already
posted a note to the list apologizing and correcting my error.
This is what happens when I post from memory without double checking
obviously I had done a flush of my shared_pool!
Rachel
How is this essentially different than what you can get from utldtree.sql?
when Kevin Loney and I were writing the Annotated Archives a few years ago, I
tried to write a script that would show the dependencies, because part of the
reason for the book was to provide home-grown scripts that wre
Title: Oracle and Character formatting
Hello All,
We want some text to be stored in our database, entered through a Dev6 Form. Is it possible that formatted data can be stored in the database in the form it is written, i.e. with different fonts or special characters or numeric values with
Don,
Next time I need to resign, will you help me write the letter?
Having worked at several large and not-so large companies, all I can say is, the
problems you documented seem to be ubiquitous throughout most management. I have
found it nearly impossible in some places to do my job with any
Where can I find the output of the Solaris run control scripts? I am trying
to debug a database startup problem and would like to view the output of the
echo commands in these scripts.
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET:
Don - Excellent letter! Wonder what happened after you left? Did anything change?
[EMAIL PROTECTED] 05/09/02 06:37PM
I think enough has been said already - I didn't intend to name the company at all.
Actually, I
don't think that I said that all the managers were incompetent. (A select few
Sankar,
1) How many indexes does this table have?
2) How many rows currently exist?
3) Are there ANY triggers on this table?
4) Are there any column constraints other than NOT NULL?
5) Is there a foreign key on from this table to another?
6) How many rows are in the
Don,
And, of course, since it was a resignation letter, the company probably just
filed it away. I'll give you the Brass Cajones award though, for setting
the record straight.
Just curious, is the company still around? Need to make sure to avoid it in
the future! :)
Tom Mercadante
Oracle
Wow, it's a small world. My first DBA position was at CSG Systems! And
yes, the company broke off of First Data and became its own publicly traded
company. By the way, nice letter :)
-Original Message-
Sent: Friday, May 10, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Don,
I've developed a procedure that will create a public synonym on an object,
which I'd eventually like to call from a ddl after create on schema
trigger.
But I'm first working on this piece - I get an INSUFFICIENT PRIVILEGES error
(ORA-1031) on the EXECUTE IMMEDIATE line. The user running the
Hello,
Has anyone ever tried setting dml_locks to zero or disabling table locks on
an OPS (2-node, 8.1.7.2.1, 32-bit; HP 11.0, 64-bit) as a way of reducing
contention and freeing up resources ? We currently use 7,250
dml_locks/instance. Oracle's OPS Admin manual (8i) had the following to say:
So far, it does not look to be like that here. I have reviewed and made
suggestions in the past two weeks and the response has been she's right,
let's do it. And it gets done. I might actually like it here :)
Careful... they will slap you down when you least expect it! :-)
RF
-Original
Bill,
Does the OWNER of the proc have CREATE PUBLIC SYNONYM system priv?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, May 10, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L
I've developed a procedure that will create a public synonym on an
That was it - thanks!
Forgot there were two distinct system privs - CREATE ANY SYNONYM and CREATE
PUBLIC SYNONYM
-Original Message-
Sent: Friday, May 10, 2002 10:38 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Bill,
Does the OWNER of the proc have CREATE PUBLIC SYNONYM system
Are these addons to OEM worth buying?
Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Schauss, Peter
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Great minds think alike? Either that or we are the
borg and just don't know that we are part of the
collective yet.
--- [EMAIL PROTECTED] wrote:
How is this essentially different than what you can
get from utldtree.sql?
when Kevin Loney and I were writing the Annotated
Archives a few
Well, I'd take a look at the fixed bug list for the 8.1.7.2 (since several
people have said there are unspecified problems with 8.1.7.3). It's about a
hundred pages long :), but if nothing there affects you you might be all
right. I have 2 8.1.7.0 databases that have been running without
Is this surprising? I still remember an Oracle presentation when 8i was
first coming out and the Oracle rep answered a question about hints by
saying that no one should use hints any more because the optimizer always
used the best path.
Half the room burst out laughing :).
Jay Miller
Hello,
Sorry about the screw-up in the subject. It should be locks. Dreaming
about the week-end, I suppose.
Thank you,
Paul Sherman
DBAElcom, Inc.
voice - 781-501-4143 (direct #)
fax- 781-278-8341 (secure)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 10,
I'm creating an AFTER CREATE ddl trigger:
CREATE OR REPLACE TRIGGER after_create_trg
after create
on lwdev.schema
begin
if sys.dictionary_obj_type='TABLE'
OR sys.dictionary_obj_type='SEQUENCE'
then
begin
dbms_output.put_line ('TEST');
Amol - I think that you are on the right track, looking at LD_LIBRARY_PATH.
Possibly you don't have that variable set just quite right, or it isn't set
when you issue the lsnrctl. You can check the setting by entering env just
before you issue lsnrctl. Try to check for extra characters or
A la Ned Flanders, absolu-tiv-tiv-tively! Especially if you plan on usingem.
Thank you,
Paul Sherman
DBAElcom, Inc.
email - [EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 10, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
Are these addons to OEM worth buying?
Peter - It depends. If you are a big user of OEM today, then you'll probably
want them. In the long run they are probably a little like OEM itself.
Excellent for getting novices into the Oracle game, but eventually you must
learn what is beneath the tool. I found that STATSPACK offered better
On Thu, May 09, 2002 at 03:23:24PM -0800, MacGregor, Ian A. wrote:
I have learned some rudimentary gnuplot skills. Each morning I
produce graphs of what went on the in the databases the previous day on
and hour by hour basis. If something is really askew I break the
hour down into ten
Peter,
I guess it depends on whether you have any other monitoring and/or
performance tuning tools that you use.If you do, there may be quite a
bit of duplication of features provided.If you don't have any other
automated tools that provide performance monitoring and tuning
For around the same money (I think...maybe before the pricing restructure),
I like Spotlight On Oracle from Quest. Excellent drilldown capabilities,
MUCH better GUI, and for management, it's cooler-looking too.
Trials are free. Just expect a call from a salesman.
Rich Jesse
Title: RE: Asinine security workarounds in Oracle, Part III
Paul,
Does that mean some of the films I have at home are sequels with 29 other episodes?
vbg
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From:
Recreating the C: drive will definitely destroy your Oracle registry
entries and your Oracle and listener services. Doing an in-place upgrade
should not and will also give you a more stable server. Ghosting is much
easier but it can produce an unstable machine that will intermittently
suffer a
Kitri - Thanks so much for pointing this book out. I have purchased it and
worked through almost all the examples. It is excellent. It was exactly what
I needed. I had found it difficult to get started with RMAN. I had read the
Oracle manual, and taken the Oracle 8i Backup Recovery class
We've go them I think so.
Dick Goulet
Reply Separator
Author: Schauss; Peter [EMAIL PROTECTED]
Date: 5/10/2002 7:58 AM
Are these addons to OEM worth buying?
Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
--
Please see the
Hi.
We are designing a small database using a data
warehousing desing. We have created a 3rd normal form
and are now debating whether and how to denormalize
it. I see the pluses of denormalization - easier
queries creation and tuning. What are the
disadvantages that we should be aware of? Wasted
Bill,
A trigger cannot display output.
Where would it go? A trigger does not run in an interactive
session, it runs in the database independently, regardless
of the presence or absence of a SQL Plus session.
Jared
Magaliff, Bill [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/10/2002
I have 23 Oracle databases running 8.1.7.0 (knock on wood) w/out a problem. I patch
only when its broke. Or for a new install, e.g. waiting for 9i rel 2 w/ its patches
before I start the upgrade process.
FWIW,
Gene
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
ok - thanks
i edited the trigger to insert a row into a dummy table, just to see if it
works, and all works fine.
Now - the next piece.
I want this trigger to call a stored procedure that runs as an autonomous
txn and creates a public synonym for the newly-created table.
I've verified
I'm upgrading a couple of boxes to 8.1.7.2 simply because
that is the earliest version in which Oracle Names checkpoints
actually work.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/10/2002 08:58 AM
Please respond to ORACLE-L
To: Multiple recipients of
Hello All,
Here is the result I have got from the v$session_event
SID EVENT
TIME_WAITED
---
22 direct path read
109
20 db file scattered read
125
24 db file scattered read
160
26 SQL*Net more data to client
I hope you will all forgive this slightly off topic post.
You may find it a bit interesting. There's also a punch
line for all the codgers among us. ;)
Jared
-
Joys of having an intern
If you have ever had the privilege of having a fresh faced
intern at
Actually...
SQL create or replace trigger test
2 after insert on test_table
3 begin
4 dbms_output.put_line ('Hello from trigger!!!');
5 end;
6 /
Trigger created.
Elapsed: 00:00:00.02
SQL insert into test_table values ('Hello');
Hello from trigger!!!
1 row created.
Elapsed:
Folks, just a word of warning. Through NO FAULT of the authors, there are a
number of errata in the first edition of the book.
There is a complete errata list on the Osborne site:
http://shop.osborne.com/cgi-bin/oraclepress/errata.html
Page proofing is one of the worst tasks on earth (I
Anyone know why, when using DBCA, it configures user SYSTEM to have a
default tablespace of TOOLS and not SYSTEM?
This is a separate script it runs at the end, after the db and data
dictionary are both created.
thought system should have system tablespace as default, no?
thanks
--
Please see
Thanks, so I can survive with 8.1.7.0 specially for development Env.
-Original Message-
Sent: Friday, May 10, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L
I have 23 Oracle databases running 8.1.7.0 (knock on wood) w/out a problem.
I patch only when its broke. Or for a new
Limited yes, but invaluable when debugging a trigger, and other possible
uses.
Chris
-Original Message-
Sent: Friday, May 10, 2002 2:33 PM
To: [EMAIL PROTECTED]
Cc: Grabowy, Chris
Chris,
Well, dang, it does work!
Guess I should have tried it myself first.
It will only work from SQL
Chris,
Well, dang, it does work!
Guess I should have tried it myself first.
It will only work from SQL Plus though, or other
tools that capture DBMS_OUTPUT.
Oracle must send it to the big bit bucket in the
sky otherwise.
Jared
Grabowy, Chris [EMAIL PROTECTED]
05/10/2002 11:25 AM
Doh!
I forgot to mention services.
Thanks Thomas.
Thomas Day [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/10/2002 11:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Server upgrade NT4 -
supposedly no additional cost in 9i, but when I checked Oracle's store, there
was a $20 charge for each. Considering that for 7.3 and 8.0 they were $100 for
EVERY NAMED USER, regardless of how many people were actually going to use them,
that's no cost :)
|+---
|
Let's see . . . disadvantages . . . hmmm. scorn of anyone that understands
data warehousing? On your resume putting created a completely normalized
DW and wondering why everyone giggles when they read it.
Actually, a normalized schema will probably use less space than
denormalized.
The key point
-- Gurelei [EMAIL PROTECTED] on 05/10/02 10:43:23 -0800
Hi.
We are designing a small database using a data
warehousing desing. We have created a 3rd normal form
and are now debating whether and how to denormalize
it. I see the pluses of denormalization - easier
queries creation and
Hi,
I resisted, but I decided to join in this thread after reading some indirect
comments about our products.
- As said by others, trace file format is documented. But, there are many-many
traps in raw trace files. Reading them by eyes or by a simple script may give
wrong results. In other
Thanks Rachel. To choose between speedy publication (copyright 2002) and
waiting another 6 months for an error-free book, I'll choose speedy.
Especially since I've become increasingly desperate for a good RMAN tutorial
over the past months. And after all, this book is designed to teach you to
Jared,
Thanks for the answer. I must admit my ignorance in
terminology as for me data warehouse and data mart a
pretty much the same thing except for size. I
understand that data mart is smaller. The database I'm
referring to could probably be described as data mart
as it is going to be rather
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 10, 2002 5:03 AM
Hi ALL,
1.
How do I get know memory usage by karnel,application
programs,Filesystem Cache etc in SunOS 5.6 . I do not
have the RMC package installed in my m/c
I
One philosophy of DW states that you build a DW that is
fairly normalized, much like an OLTP database, albeit one
with a temporal component and complete logging of transactions
within the data.
This is then used as a warehouse. The data from the DW is used
to assemble data marts. These data
There are many things that you could check:
1) size of the shared pool
2) fragmentation of the shared pool
3) free space in the shared pool (together with 2)
check also the application for parsing (also soft parses).
Check v$rowcache to see access to the rowcache.
Anjo.
Reddy, Madhusudana
-- Gurelei [EMAIL PROTECTED] on 05/10/02 12:13:27 -0800
Jared,
Thanks for the answer. I must admit my ignorance in
terminology as for me data warehouse and data mart a
pretty much the same thing except for size. I
understand that data mart is smaller. The database I'm
referring to
Dennis,
It's possible the version you have was corrected. I know that it was the first
printing that had some serious, unintentinal omissions I think only in the
first few chapters.
What really hurts the author is when they catch the error, send the correction
in in time to be fixed for
That's CORRECT... no one other than SYS should have the SYSTEM tablespace as the
default tablespace. No one should have SYSTEM as the temporary tablespace.
for years oracle would say change the default tablespace. Now they do it for
you (and about bloodly time!)
The distinction between a data mart and a data warehouse is not size (Size
doesn't matter). It just works out that way usually...
The distinction between a DM and a DW is its function within the entire
decision-support strategy. A data warehouse is the consolidation point for
all data from all
New feature in 9i, default temporary tablespaces. Now you don't have to state
what a users temporary tablespace is and have them end up in system. It covers
sys and system at the same time since it's declared in the create database
command.
Dick Goulet
Reply
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
The key point is your users. A typical normalized
design means a lot of
tables. These tables must be joined in specific
manners. Non-I.S. users find
this intimidating. So they don't use it. So you've
spent a lot of time
creating a DW only to
A DW stores data in a denormalised fashion, that's one
point that every body knows but it is also subject
oriented. It is also developped one subject at a time.
A DW is multi-subjects as a datamart is on one
subject.
From Bill Inmon
From the data warehouse data flows to various
departments
See, they do listen. Now if we could only get them to move faster than Molasses
going up hill in the middle of an Alaskan winter!!
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 5/10/2002 4:22 PM
yeah it's sweet. they finally got
I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG.I then enabled automatic archiving of filled groups by setting
log_archive_start=true
in the database's parameter file. Finally I used
alter system archive log start;
to enable automatic archiving of filled online redo log
You probably received an error in your alert log and Oracle disabled archiving. Make
sure yuou have these 3 parameters in your initsid.ora and set accordingly:
log_archive_dest = /oracle/data/arc/sid/
log_archive_format = sid_%s.arc
log_archive_start = true
hth,
Gene
[EMAIL PROTECTED]
Trang: I think that you missed the step of alter database archivelog while
the database is mounted but not open.
Here is the precise steps for you to review:
Modify the init.ora file with log_archive_start = true (you've already done
that)
Shutdown the database.
STARTUP MOUNT
ALTER
Tim,
Don't *ever* apologize for long threads when
they are full of useful content. :)
Jared
Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/10/2002 02:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Each morning I produce graphs...
I think this is key. Having historical data graphically presented helps to
establish the norm and when there may be performance issues to investigate.
This follows step 2 of Gaja's Oracle Performance Tuning 101 Methodology
which says, Measure and document current
From what I remember, one of the main advantages of a normalized database is
a certain level of data integrity and flexibility. The integrity comes from
foreign keys, lack of duplicate data, and generally a data design based on
characteristics of the data. The flexibility comes from the ablility
-- Henry Poras [EMAIL PROTECTED]
From what I remember, one of the main advantages of a normalized
database is
a certain level of data integrity and flexibility. The integrity comes
from foreign keys, lack of duplicate data, and generally a data design
based on characteristics of the data.
Hum, I have to fight a bit more for mine suggestions to go through. That's
not fair. I guess its good for me as its helping my debating skills:-) It
does not help that the folks I work with are half way across the country.
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, May 10,
Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1
and prognosys in an year.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex Hillman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
I wish I can work for you beside learning Oracle I can be a wiser man.
-Original Message-
From: Don Granaman [mailto:[EMAIL PROTECTED]]
Sent: 11 May 2002 00:38
To: Multiple recipients of list ORACLE-L
Subject: Re: Good HR vs. Bad HR...
Actually, I don't think the company is
82 matches
Mail list logo