Listener problem in Oracle 8.1.5 for RH 6.2

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

Re: I need to change the instance name

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

RE: SQL -Can this be done in a single query

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

Re: I have a black hole in my database

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

Re: Transactions per second

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. --

MEMORY USAGE

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

Re: I have a black hole in my database

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

Re: formating 10046 (level 12) trace file

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

Re: Server upgrade NT4 - W2K Oracle implications

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

RE: Server upgrade NT4 - W2K Oracle implications

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

Re: Good HR vs. Bad HR...

[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

RE: optimizer not using function based indexes

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

Re: script to show heirarchical list of object dependencies for a

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

Oracle and Character formatting

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

Re: Good HR vs. Bad HR...

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

Solaris RC Script Output

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:

Re: Good HR vs. Bad HR...

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

Re[2]: Improving Oracle Performance

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

RE: Good HR vs. Bad HR...

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

RE: Good HR vs. Bad HR...

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,

errors with CREATE SYNONYM procedure

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

RE: Cronjob

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:

RE: Good HR vs. Bad HR...

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

RE: errors with CREATE SYNONYM procedure

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

RE: errors with CREATE SYNONYM procedure

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

Oracle Diagnostic and Tuning Packs

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

Re: script to show heirarchical list of object dependencies for a

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

RE: Upgrade is Necessary?

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

RE: too low optimizer_index_cost_adj causing bizarre index choice

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

e: locks, not cronjob!

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,

AFTER CREATE trigger help, please

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');

RE: Listener problem in Oracle 8.1.5 for RH 6.2

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

RE: Oracle Diagnostic and Tuning Packs

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?

RE: Oracle Diagnostic and Tuning Packs

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

Re: WAITS

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

Re: Oracle Diagnostic and Tuning Packs

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

RE: Oracle Diagnostic and Tuning Packs

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

RE: Asinine security workarounds in Oracle, Part XXXXIII

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:

Re: Server upgrade NT4 - W2K Oracle implications

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

RE: Rman ... what do YOU need

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

Re:Oracle Diagnostic and Tuning Packs

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

data warehousing desing - to denormalize or not to denormalize - that is the question

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

Re: AFTER CREATE trigger help, please

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

RE: Upgrade is Necessary?

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:

RE: AFTER CREATE trigger help, please

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

RE: Upgrade is Necessary?

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

Locks and Waits

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

Joys of having an intern

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

RE: AFTER CREATE trigger help, please

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:

RE: Rman ... what do YOU need

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

why does DBCA (DB Create Assist) reassign default tablesepace for

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

RE: Upgrade is Necessary?

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

RE: AFTER CREATE trigger help, please

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

RE: AFTER CREATE trigger help, please

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

Re: Server upgrade NT4 - W2K Oracle implications

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 -

Re:Oracle Diagnostic and Tuning Packs

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 :) |+--- |

RE: data warehousing desing - to denormalize or not to denormaliz

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

Re: data warehousing desing - to denormalize or not to denormalize -

-- 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

Re: formating 10046 (level 12) trace file

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

RE: Rman ... what do YOU need

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

Re: data warehousing desing - to denormalize or not to denormalize - that

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

RE: MEMORY USAGE

- 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

Re: data warehousing desing - to denormalize or not to denormalize - that

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

Re: Locks and Waits

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

Re: data warehousing desing - to denormalize or not to denormalize -

-- 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

RE: Rman ... what do YOU need

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

Re: why does DBCA (DB Create Assist) reassign default tablesepace

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!)

Re: data warehousing desing - to denormalize or not to denormalize - that

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

Re[2]: why does DBCA (DB Create Assist) reassign default tab

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

RE: data warehousing desing - to denormalize or not to denormaliz

--- 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

Re: data warehousing desing - to denormalize or not to denormalize -

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

Re[2]: Re[2]: why does DBCA (DB Create Assist) reassign defa

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

Redo log files questions. Need help.

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

Re: Redo log files questions. Need help.

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]

RE: Redo log files questions. Need help.

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

Re: data warehousing desing - to denormalize or not to denormalize - that

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:

RE: WAITS

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

Re: data warehousing desing - to denormalize or not to denormaliz

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

Re: data warehousing desing - to denormalize or not to denormaliz

-- 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.

RE: Good HR vs. Bad HR...

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,

Oracle version usage

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)

RE: Good HR vs. Bad HR...

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