Installation problems (8.1.7 on AIX 5.2)

I am trying to install Oracle 8i release 3 (8.1.7.0.0 - as this is the minimum version of Oracle that our products support) onto an IBM Server running AIX 5L. I have followed the instructions in the Oracle installation guide and have proceeded to install the 'typical' installation. Everything was

HELP

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhou, Tapiwanashe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhou, Tapiwanashe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Installation problems (8.1.7 on AIX 5.2)

Hi Zhou, This most likely becoz your OS is incomplete you must install FULL DISTRIBUTION VERSION Upgrade your OS Sinardy -Original Message- Sent: 18 August 2003 17:14 To: Multiple recipients of list ORACLE-L I am trying to install Oracle 8i release 3 (8.1.7.0.0 - as this is the

RE: HELP

DIAL 911 -Original Message- Sent: 18 August 2003 17:14 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhou, Tapiwanashe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE:

DIAL 911 -Original Message- Sent: 18 August 2003 17:24 To: Multiple recipients of list ORACLE-L help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhou, Tapiwanashe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Canada and US friends (YOUR WISH IS COME TRUE)

-Original Message- Sent: 18 August 2003 14:29 To: Multiple recipients of list ORACLE-L Please, please send us some candles and torchlights. If you can, please send in some John Smith Extra Smooth and Bailey's Irish Cream. When I come to think of it, you can skip candles and lights

AW: BEA's WebLogic vs. Jdeveloper and iAS

Hi I can't give you a clear answer on this one, but: Is it possible that BEA uses J2EE Connector Architecture to access People Soft ? I've seen this for SAP, it's kind of a standardized J2EE API which allows programmatic access to ERP (and the like) resources. If that's the case, then you should

RE: Org charts

--_=_NextPart_001_01C3655F.E5DC1490 Content-Type: text/plain; charset=iso-8859-1 Nice as far as it goes, Jared - let us know when you can generate a complete ER diagram from SQL*Plus... ! peter edinburgh -Original Message- Sent: Saturday, August 16, 2003 2:04 AM To: Multiple

Re: Re: system tablespace at 50 pct_increase in 9i?

i thought you should leave the system table space to the defaults? Ive never touched System. you really should change system to locally managed tablespaces? From: Tim Gorman [EMAIL PROTECTED] Date: 2003/08/17 Sun PM 11:19:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

OpenLDAP instead of OID

Hi list Some people where interested in feedback regarding the usage of OpenLDAP instead of OID or Names to resolve TNS strings. Seems to work ;). Here is what to do: Prerequisite: I used openldap-2.0.23 instead of 2.1, since I had to use CygWin to test it locally on my laptop. Bill of

Re: Re: system tablespace at 50 pct_increase in 9i?

Actually, from 9iR2, system tablespace is created as locally managed autoallocate. They should have put in SEGMENT MANAGEMENT AUTO clause as well, but hey, you can't always get what you want, but you can try sometimes. On 2003.08.18 07:59, [EMAIL PROTECTED] wrote: i thought you should leave the

Re: Oracle 9i and connect as sys

CREATE PUBLIC SYNONYM is a permission I'll give away freely, even to a PHB. It's DROP PUBLIC SYNONYM that really needs some thought... Installing Oracle in a shop that has never used UNIX or Oracle before is never cheap, whether I do it or not. This particular shop was OpenVMS/Ingres coming into

Is there any certification for Systems Analyst/Designer ?

Hi all, Is there any certification for "Systems Analyst/Designer" ? Regards,Salaheldin BEGIN:VCARD VERSION:2.1 N:Aboali;Salaheldin FN:Salaheldin Aboali ORG:Management Information System;Software Development TITLE:Senior Software Developer TEL;WORK;VOICE:Ext. 235 TEL;HOME;VOICE:+202.744.35.80

RE: Is there any certification for Systems Analyst/Designer ?

Maybe at www.duhveloper.com ;o) -Original Message-From: Salaheldin Aboali [mailto:[EMAIL PROTECTED]Sent: Monday, August 18, 2003 8:39 AMTo: Multiple recipients of list ORACLE-LSubject: Is there any certification for "Systems Analyst/Designer" ? Hi all, Is there any

Re: system tablespace at 50 pct_increase in 9i?

Title: Re: system tablespace at 50 pct_increase in 9i? Good point! Another war story... Some 6 years ago, during v7.3.3 timeframe, a DBA decided to modify INITIAL, NEXT, and PCTINCREASE of everything, including stuff in SYSTEM. Unfortunately, he chose first to do this in pre-PROD (to become

RE: system tablespace at 50 pct_increase in 9i?

Title: Re: system tablespace at 50 pct_increase in 9i? Another point of discussion - just what do you expect to gain by altering the SYSTEM tablespace's storage params? It is not a high volume tablespace - the O's part of I/O to this particular tablespace is very low. Altering storage params

RE: Oracle 9i and connect as sys

First off, you should not be connecting as sys on a regular basis, so making it harder is a good thing. Makes us think about what we're doing. Anyway, my experience is that whenever you want to connect as SYS you have to do so AS SYSDBA. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA

Re: Re: system tablespace at 50 pct_increase in 9i?

Hi Mladen, Just to avoid any confusion, you have the *option* to create a LM System tablespace, the *default* is still DM. The ODCA uses the extent management local clause in it's default scripts but to create a database manually, you need to remember the clause. Whether it should use ASSM is

Re: Is there any certification for Systems Analyst/Designer ?

Unfortunately not anymore. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Is there any certification for Systems Analyst/Designer ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno

Re: system tablespace at 50 pct_increase in 9i?

Title: Re: system tablespace at 50 pct_increase in 9i? Tim, WebIV? I must have skipped a generation; I used the OraSupport forum on CompuServe before the MetaLink. You had to subscribe to CompuServe; and it was accessible only through dial-up; so we had dial-up lines at our desk, had to buy

Re: Oracle World anyone?

Hi! I think Oracle has changed the name for this seminar series, search for Oracle9i Database: Seminar Series for Oracle Server in www.oracle.com/education. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 15, 2003 10:04 PM

Re: Is there any certification for Systems Analyst/Designer ?

I would have said fortunately ... ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 1:04 AM Unfortunately not anymore. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple

RE: system tablespace at 50 pct_increase in 9i?

Title: Message Same here. I've actually had 14400 modem on my desk. Before that, I was using 9600 modems and kermit or "SET HOST/X25" (once upon a time on a VAX far, far away) --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: Urgent Business Proposal (Nigerian scam, with a twist)

lol OR SHOULD i HAVE SAID LOL! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Is there any certification for Systems Analyst/Designer ?

you got a point there... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I would have said fortunately ... ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: Oracle 9i and connect as sys

Hi! Note that if you set your init.ora parameter o7_dictionary_accessibility to true, then you can connect as sys *without* sysdba or sysoper. But setting this parameter to true (old behaviour) isn't a good idea anymore, but might work for patching maintenance type of work. Tanel. -

AW: It's an Oracle Fun Friday!

... just hope you didn't stop your remodeling activities after removing the bath tub, toilet bowl, etc. Your wife might eventually complain ;) Stefan -Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 8. August 2003 20:04 An: Multiple recipients

Re: BEA's WebLogic vs. Jdeveloper and iAS

Hi! Oracle has it's InterConnect (comes with 9iAS EE IIRC and supports Peoplesoft other ERP vendors) which might be what you're looking at? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, August 17, 2003 3:44 AM We are highly

Re: AW: It's an Oracle Fun Friday!

Monday, August 18, 2003, 11:34:29 AM, you wrote: SJ ... just hope you didn't stop your remodeling activities after removing the SJ bath tub, toilet bowl, etc. Your wife might eventually complain ;) Yes, well, uh, er, that's just it. I haven't exactly stopped. I've just had to set the work aside

SQL Navigator

I'm considering SQL Navigator (Quest)for web app dev and am looking for some feedback from you, the experts. I can't seem to find any training being offered on this product. There seems to be no technical books for it. I'm wondering, is there a steep learning curve with it? Did anyone find it

32 or 64?

From a technical and business perspective, what are the reasons to migrate from 32-bit to 64-bit Oracle? Are there known bugs/problems with one version that are not present in the other? Daniel Finkbegin:vcard n:Fink;Daniel x-mozilla-html:FALSE org:Sun Microsystems, Inc. adr:;; version:2.1

RE: SQL Navigator

I compared it to Quest's TOAD (I believe SQL Nav was theirs before they bought TOAD), and found TOAD more flexible with more features and generally easier to use. Then again, I've been using TOAD since the original freeware was announced in the July/August '98 issue of OraMag. Last year, I asked

Re: 32 or 64?

A bigger SGA comes to mind as one immediate benefit. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 18, 2003 12:14 PM From a technical and business perspective, what are the reasons to migrate from 32-bit to 64-bit Oracle? Are

Re: 32 or 64?

well some OS you're forced to at some level, but my understanding is UNLESS you build the database with 64 bit binaies, just chaging the word size supposedly doesn't let you gain any of the 64 bit performance enhancements, fact or fiction, someone willing to elaborate? joe Daniel Fink wrote:

RE: Oracle 9i and connect as sys

The security is not as bad as it sounds. The patch is to release major software and the user gets prompted to enter the password. It is not stored any place (just UNIX variables during the running of the release). The software upgrades are released once every six months to year. Not all patches

Re: 32 or 64?

There are no performance benefits from the software change; in fact, anecdotal evidence is that there might even be a hit, since we're now moving more data about (i.e. 64-bit integers instead of 32-bit integers), but that is certainly debatable. Some very simple testing with C programs on

RE: SQL Navigator

Hi, I have been using SQL Navigator since 2000 and I am quite happy with it. I am still using version 3.1 but version 4 has been out for a long time. It is not difficult at all, but if you are converting from SQL*Plus it seems to be a huge obstacle initially. If your objective is server side

RE: 32 or 64?

Fiction. I migrated a 32 bit database to 64 and did not change anything else. DB definitely runs better. As in WEB pages returning in 10 second vs. 40 seconds before the migration. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, August 18,

RE: 32 or 64?

You want to migrate to 64 bit for several reasons: a) That's in, so you'll be the coolest guy in the pub. b) You can have a very large SGA, which will dramatically improve BCHR (Buffer Cache Hit Ratio), which will, in turn, make all your queries run blindingly fast, according to old oracle

Re: Re: system tablespace at 50 pct_increase in 9i?

i did use the dbca to create this instance? From: Richard Foote [EMAIL PROTECTED] Date: 2003/08/18 Mon AM 10:39:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re: system tablespace at 50 pct_increase in 9i? Hi Mladen, Just to avoid any confusion, you

RE: Oracle 9i and connect as sys

It's the new way, the INN thing. -Original Message- Sent: Saturday, August 16, 2003 10:29 PM To: Multiple recipients of list ORACLE-L I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/[EMAIL PROTECTED]

Re: 32 or 64?

We are running oracle 9i on Windows 2000 Server. I recently started administering Oracle on Windows 2000 and noticed that when the oracle.exe process consumes 1450+ Mb of memory, we run into out of process memory error. We ended up recycling application servers every time this has happened and

RE: Re: system tablespace at 50 pct_increase in 9i?

Well, technically he's right. If you don't qualify CREATE TABLESPACE or CREATE DATABASE command with the EXTENT MANAGEMENT LOCAL clause, you will get dictionary tablespaces. dbca, however despicable it is, does not forget it. -- Mladen Gogala Oracle DBA -Original Message- [EMAIL

RE: 32 or 64?

Did you exp/imp for the migrate? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 12:24 PM To:

RE: BLOB question/JDBC

Title: Message IIRC, the thin driver doesn't support LOBs -Original Message-From: Robert Foley [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 8:26 AMTo: Multiple recipients of list ORACLE-LSubject: BLOB question/JDBC Hi, I'm fairly new to the area of JDBC and

RE: 32 or 64?

NO. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, August 18, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Did you exp/imp for the migrate? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: BLOB question/JDBC

Hi Robert, Try Metalink Note:68349.1 The code is for 8i, but works quite well for 9i too. Vadim -Original Message-From: Robert Foley [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 10:26 AMTo: Multiple recipients of list ORACLE-LSubject: BLOB question/JDBC Hi,

RE: 32 or 64?

The added benefit comes with technology's ability to address/reference disk/memory/etc. in the 64-bit address space. Additionally straight 64-bit computing offers some added performance versus the concatenation of two 32-bit words. Tim is correct in that some performance degradation can be

What is _NEXT_OBJECT

I recently had to install a couple of things to my 817 database so that I could get UTL_SMTP. I ran ORACLE\javavm\install\initjvm.sql and ORACLE\rdbms\admin\initplsj.sql as SYS and then followed up by use ALTER objectType to recompile all invalid objects. The only thing I have left is a object

RE: What is _NEXT_OBJECT

This is a extremely valuable and irremovable object within the database that is essentially a pointer to the next object ID within the database data dictionary. Don't worry about it. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile:

Re: What is _NEXT_OBJECT

According to MetaLink _NEXT_OBJECT is a hidden entry in obj$ which determines the next

tuning question when you have a 3GL application

We have two teams. Database team and a Software engineering team. The software engineering team wrote an application in .net. We periodically get 'the application is slow' from them. I have not gotten the ok to run statspack in production. Are there any canned scripts I can run to monitor the

RE: BLOB question/JDBC

Thin driver supports LOBs. -Original Message- From: Vordos, Suzy [mailto:[EMAIL PROTECTED] Sent: Mon 8/18/2003 2:19 PM To: Multiple recipients of list ORACLE-L Cc: Subject:RE: BLOB question/JDBC IIRC, the thin driver doesn't support LOBs -Original Message-

Re: tuning question when you have a 3GL application

10046, and only 10046. There are many ways to set this event, even in another session. It is the method for identifying the exact problem. Statspack and queries on v$ views have their own shortcomings that make them inefficient for use in identifying specific problems. Get the SE team to

RE: ORA-1652: unable to extend temp segment by 8091 in tablespace

Thanks all. The replies have been really helpful. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 6:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1652: unable to extend temp segment by 8091 in

RE: tuning question when you have a 3GL application

Writing an application in what is, essentially, vaporware, was a smart business decision if I ever saw one. If you have said COBOL, I'd understand, but you have said .NET and that is the difference. Does that MS vaporware have a profiler? It would be very nice to use it, because your problem

RE: OpenLDAP instead of OID

Congratulations Stefan! Thanks for posting this. Do you (or anyone else) have any ideas for doing this with Micro$oft Active Directory? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 18, 2003 8:15 AM To: Multiple

Change Data Capture

I am testing the Change Data Capture and for the most part I am able to get it working. I have the following issues/questions. 1. I published 3 columns out of 9 column table and subscribed those 3 columns. When I make a change to the columns that were not published/subscribed, I see change

Re: Re: tuning question when you have a 3GL application

all i usually get is 'the application is slow' i cant get more out of them than that. its in acceptance testing so i often get that from the customer. they are offsite and i dont have direct contact with them. so i cant run traces on individual sessions. Further when the database runs slow

Re: tuning question when you have a 3GL application

[EMAIL PROTECTED] wrote: We have two teams. Database team and a Software engineering team. The software engineering team wrote an application in .net. We periodically get 'the application is slow' from them. I have not gotten the ok to run statspack in production. Are there any canned

stripe size

Is there any command on hp-ux which can tell me on what disks particular file is striped on and stripe size . Hp-ux ( 11 ) Thanks, ak

RE: Auth via Active Directory

Scott Lamb [mailto:[EMAIL PROTECTED] on Friday, August 15, 2003 6:49 PM said; Is there any way to get Oracle 8i (or 9i; we're planning to upgrade) Enterprise Edition to authenticate against Active Directory, short of buying Oracle Advanced Security? What we're planning on doing (note,

Re: stripe size

As long as you're using software RAID and not hardware, you can use vxprint to give you that information. I believe a functional syntax that includes the stripe size is vxprint -hrt -g (diskgroup) . If you're using hardware RAID, you're going to need whatever array management tools your

RE: Re: tuning question when you have a 3GL application

Then you have a political problem, not a technical one. This is plenty common. In my opinion, you'll aggravate yourself to death before you'll successfully solve a political problem with a technical solution. I have total faith in the technical solution that Dan suggested, but you won't be able

Performance Query - help

Hi all, I have a query which takes 4 seconds to execute. The query looks like: SELECT DISTINCT tfc_fct_value FROM PD_TMP_AGG_VALS_5071_544,PD_OUTPUT_ITEMS,tp_fact_ctl WHERE OUI_OUT_ID=5071 AND OUI_FACT_ID IS NOT NULL AND oui_item_type=tfc_item_type AND vd17=oui_fact_id ORDER BY

Re: Tracing a user session with multiple database connections

Schauss, Peter wrote: Is there any way to trace all of the connections for a given sid without setting sql_trace for the entire instance? You could try creating a trigger to do it. create trigger foo after login on database ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --