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
--
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
---
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
---
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
mini
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
Sa
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 http://www.fatcity.co
-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 an
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
--_=_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 r
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 PROTECT
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 materials
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 th
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
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.8
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
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 P
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 param
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
-
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 som
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: N
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 e
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 P
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: "Multip
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 PROTEC
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
--
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 ht
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.
- Origin
... 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 o
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 highl
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 asid
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 to
>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
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
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
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:
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
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
dedicat
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
devel
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, 2
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 w
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 c
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]
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 it
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 PR
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: M
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
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]
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,
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
experi
I recently had to install a couple of things to my 817 database
so that I could get UTL_SMTP. I ran \javavm\install\initjvm.sql
and \rdbms\admin\initplsj.sql as SYS and then followed up
by use ALTER to recompile all invalid objects.
The only thing I have left is a object of name _NEXT_OBJECT of
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:
According to MetaLink
_NEXT_OBJECT is a hidden entry in
obj$ which determines the next
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
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-
Se
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 identif
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
tablespaceRaju
We have a third party application which makes multiple connections
to the database. The application keeps one connection open for
the duration of the session and then opens and closes one or more
connections
in succession. Some of the connections only last for a few seconds, so
running the set_sq
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
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 recip
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 reco
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 the
I'm looking for information about the differences between Quest's TOAD and
SQL Navigator. Specifically, which would be better for an Oracle web
application developer. I am more interested in development features; I am
less interested in the DBA functions, although they are nice to have.
Any info
[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
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
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, pla
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
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 t
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
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
--
A
Shouldn't time_waited/100 be time_waited*100?
Regards
Naveen
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 11:19
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
SGAMitchell,
Which portion of the statspack report
70 matches
Mail list logo