Several of these errors you could read on Metalink - without logging in
;)
unable to resolve service_name
unable to connect to destination
so here is a start.
Mostly, I see 904 and 942 in untested code.
ORA-0 normal, successful completion - not an error - but appears
that way when creating
just create the password file again using orapwd utilitylogin to
internal
and reset all the passwords
if u are on NT the password might be in registery(DBA_AUTHORIZATION) ?
--
From: Sreelatha[SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 2:12 PM
Have a look of the hot blocks. The most probable reason for cache buffer
chains are SQLs with bad performance. Don't discard contention on higher
level latches as redo allocation.
So to look for those hot blocks, use one of the S.Adams scripts:
hot_hash_blocks.sql ( www.ixora.com.au) and these
Well, that is correct for an Oracle 7 release. But through 8.X you only need
to increase the parameter: db_files because when the controlfile reach the
limit of MAXDATAFILES, it will increase automatically. Hence, it isn't
necessary to recreate controlfiles.
Regards.
-Mensaje original-
Hi list
Does anyone have any tales to tell of using MONITORING and the 'GATHER
STALE' option of the dbms_stats.gather* procedures? Someone here has
suggested that we use it for a new product we're developing, but I am a
little concerned over whether the monitoring has any significant
Oracle 817 on DEC 5.1 (TruUnix 64)
For Partitioned Tables , is it Advisable to Analyze Compute the Respective
Tables ?
Would there be Any Loss if the respective Tables are NOT Analyzed ?
Any Best Practices , Docs , Links etc on the way of the Optmizer in such
Cases ?
--
Please see the
Your estimate comes to around 1 row per block.
What is the average row lenght once data is in the db
? Do you have row chaining ?
What is your block size ? Can you increase it ?
If a lot of queries do not need the long raw column
you can put it in another table with a 1 to 1
relationship with
I do not understand what respective tables mean.
If your question is can I analyzed a single partition
the answer is yes.
--- VIVEK_SHARMA [EMAIL PROTECTED] a crit:
Oracle 817 on DEC 5.1 (TruUnix 64)
For Partitioned Tables , is it Advisable to Analyze
Compute the Respective
Tables ?
Just follow the installation instructions under the /lib
directory of the PL/SQL XML parser distribution and u'll have all the necessary
objects installed.
The pl/sql parser itself relies on the java one, so it's much
slower in my opinion
hth,
Marin
"When someone is seeking, it
I am looking for a way to run a SQL command or package/procedure/function
without waiting for it to finishbit like running a unix command in the
background.
Other than using dbms_job or running kivking off and external procedure to
run sqlplus, is there anyway to do this?
John
--
I had no feedback on this one.
There must be some datawarehousers on this list.
Hi,
I'm currently testing the Oracle 8i new
datawarehousing functionnalities. Are you using
materialised view for aggregate dimension ?
The second question is what do you do with yes/no
flags. They can be put in
Hi !!
--- [EMAIL PROTECTED] wrote:
Hi All,
Last night we were trying to bring down one of our
databases with Shutdown
immediate.
We waited about 20 minutes before we finally did an
abort.
We found this entry in the alert log "Waiting for
smon to disable tx
recovery." before the
-Original Message-
Sent: Wednesday, February 28, 2001 09:20
To: 'andrey'; 'List, [EMAIL PROTECTED]'
Where do i go to from here ?
Where do you want to be career wise in 5 years time?
Do you like DBAing?. If so, unless you are quite exceptional and have
crammed that two years with
Looking for feedback/opinions on quality, content, and value for money of
'Exploring Oracle' magazine by elementK journals.
Sean :)
Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
Organon (Ireland) Ltd.
Well, that is what I said. Try not to use dbms_stats with the parameter
GATHER STALE o GATHER EMPTY. With GATHER I haven't had any problem yet.
And the monitoring feature is runing well. Therefore, if you are not sure of
dbms_stats, use monitoring but with analyze or dbms_utility or dbms_ddl.
Hi Jared,
LOL, but I take it that we cannot offer our friend here any udder
alternative..
Sorry :-)
Martin Kendall (Oracle DBA during the week - Flight Instructor during the
w/end !?!)
-Original Message-
Sent: 27 February 2001 18:22
To: Multiple recipients of list ORACLE-L
On
FYI
I logged a TAR this morning, it seems to be running well again.
(a bit slow as usual, but it runs)
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systmes
Technology Services| Services technologiques
Informatics Branch
yes, I have noticed this as well. It booted me off when I went to download
a patch with some pretty ugly errors. Then I logged back on and it was like
I was in this magical place with T1 lines and ultra fast servers!! I
thought I had made a mistake, but it was Metaslouch
-Original
I laughed out loud, while waiting for my hour glass to go away! RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, February 27, 2001 4:26 PM
Our own esteemed Paul Baumgartel wants to know how our
equally esteemed Kevin would have
** Oracle Licensing Compaq Software For 9i Product
Hoping to make its upcoming Oracle 9i Real Application Clusters
software as attractive to as wide an audience as possible, Oracle
will build pieces of Compaq Computer's TruCluster technology into
the Oracle product under a new licensing deal
First off, go and get the Installation Guide for your specific platform -
www.technet.oracle.com
Then go ahead and find the Oracle 8i Reference Guide -
www.technet.oracle.com
Then the Net8 Admin Guide - www.technet.oracle.com
Then the Oracle8i Admin Guide.. from www.tecblah.debaldeblah.com
You
Say, is it just me or has the cost of the Updates Subscription Service gone
up considerably in the past six months or so?
We're currently pricing out what it'll cost us to purchase 8.1.7 Standard
Edition and the numbers we're getting are a heck of a lot higher than they
were in November.
Has
Murali,
Since we use what I really believe is an Operational Data Store or ODS, I'll
provide the insight from here, others may have their own opinion.
We are a manufacturer of power components, little modules that fit into
larger power supplies, like the one in your PC. As a result we
Hi all,
Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I have done
exactly what oracle said to do and it appears as though it is missing a .dll
and without the installation is hosed. Do you have to upgrade to some other
version first? The instance I upgraded was 8.1.6.1, then
Title: RE: Creating activity in a database
Can you illustrate pt. 3 please;
|| i'd have to do the same thing you will, namely, pull
an RTFM on the logminer facility..
some one told me that I must run the database in ARCHIVELOG mode in order to get a good activity in there. Is that
Been there -- I don't know about availability, but this is what we have to
do for people working at home through their ISP. I'm assuming NAT
produces similar problems. You can use CMAN for firewall tunnelling with
or without MTS, don't know about connection concentration, though, as we
don't
We have done this on several machines without a problem. Don't use the
patch on server running Designer 6.5. Bad Mojo.
I have an open iTAR with Oracle about this.
Todd Carlson
Oracle 8 8i Certified DBA
Bunge Corporation
Title: RE: Oracle's Updates Subscription Service
Walt, you have just shattered my picture of you as a gentle man
surrounded by docile ruminants, never uddering a discouraging word.
Yes, it's amazing, the price of the software. My line to folks
is: For your money, Oracle is the best
Title: RE: ODS
Dick,
100gb allocated or actually used?
thx
Ross
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:ODS
Murali,
Since we use what I really
I just upgraded my test server from 8.1.6.1.1. to 8.1.6.3.0, then up to
8.1.6.3.1.. You can get 8.1.6.3.1. at
ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81pat
chsets/81631/
I had previously installed a trial version of Savant QDiagnostics, but after
de-installing
i have used ODS, mostly to get data off the production server for report
generation,
but sense it was there i also used it to data loads into a DWH. This cut
out the
impact on the production server on the data scrubbing part of loading the DWH.
Hello Everyone,
This new term Operational
I need help. I'm sorry if this is a cross-posting for you.
I'd like to see some example PL/SQL code, perhaps a procedure, that will
pass
through each record of a table, test for combinations of column values and
based upon
a specific value (which would be determined by an IF... THEN... matrix),
Thanks all for the solution. I too thought of having a 1 : 1 relationship by
separating the long raw column from the table. But I believe I am not
permitted to do that (Strange). Since this is a third party product, I
am not suppose to change any of the design issues and also the datatype.
I
Check to see if the QDBA account has any jobs set to run.
If so, you should break and remove them. It does set up
jobs so the chances are good that this is the issue.
-Original Message-
Sent: Wednesday, February 28, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
I just upgraded
You put the following in a table (could be temporary):
Key A M C one two three four five
CA IND 1 1 CZ STA OFF BOO AD
CA IND 3 1 CZ STA OFF REP AD
CA IND 1 4
Ross,
There's 100GB in use. I'm in the process, along with our SA of adding
another 20GB of additional available disk space. Yeah this a pretty big ODS,
but the end users want a minimum of 90 days back data with a build plan that
approaches the vertical over the next 6 months!!!
Dick
Title: RE: Oracle's Updates Subscription Service
Well
Ross, Our campus is out in the country (just about everywhere in Montana is out
in the country) and we are, indeed, surrounded by docile ruminants. I'd like to
say that during our off-time we go out and gaze lovingly at their udders, but
Is Oracle trying to drive us nuts? Why of course they are. Take today, the OTS
phone line said that metastink was up and available, but when I got an analyst
he told me they had mail from the "metalame support team" that it would be down
until early afternoon, Florida time?
How about:
update table_name set
col5 = decode(string1,string2,'PH',string3 'CZ',).
,col6 = decode(string4,string5,'STA',string6, 'REF',)
,col7 =etc
,col8 =etc
string1 and string4, etc could be the concatentation of the four determinant columns,
string 2,3,5,6, etc would be the
Title: RE: 8.1.6 upgrade
as QDBA do
execute q$bgproc.stop_driver;
note the results
log out, then in as internal
drop user qdba cascade;
and
let us know what happens, OK?
-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February
We just had an earthquake. I'm fairly freeked.
How's everyone's disaster recover strategy? I'll think I'll be reviewing
ours today.
Dennis Taylor
Niels is bohring.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis Taylor
That's not true anymore. In IBM/AIX you have to create
JFS with large file enable option and in addition to
that in your /etc/security/limits file you need to set
fsize=-1, which means 'unlimited'. Now, you can check
it by using 'ulimit' command.
--- Shankar Shanmugaswamy [EMAIL PROTECTED]
Hi,
I am running it on a HP-UX 11.0 server and currently connected to 2
databases.
Top shows StorageXpert using anywhere between 1 to 9% CPU. I have been
running it since morning (for about 4 hours now).
What version are you using? Mine is Beta Version 1.0b4 build 1.0.4.249.
Have you contacted
I've got some simple questions on tuning SQL. Please reply with references,
I'm not looking for guesses.
* If you have a SELECT statement with a WHERE clause and 2 AND
clauses, which one is processed first, the WHERE clause, the first AND
clause, or the second AND clause?
* Is there
At 11:17 AM 2/28/01 -0800, you wrote:
We just had an earthquake. I'm fairly freeked.
See how freaked I was? I mis-spelled 'freaked'.
Dennis Taylor
Niels is bohring.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis Taylor
Where are you? RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 2:17 PM
We just had an earthquake. I'm fairly freeked.
How's everyone's disaster recover strategy? I'll think I'll be reviewing
ours today.
Hi Mala,
If you're on 8.1.6 it's a bug. If you do your export without the
consistent parameter it should finish okay but you should patch your
current installation.
--- mala singh [EMAIL PROTECTED] wrote:
Hi DBAs
I have problem at time of full export of Database.The following are the
error
Wow, Seattle, that's strange. I don't remember that happening. 6.2, whoo,
some damage goin on out there.
-Original Message-
Taylor
Sent: Wednesday, February 28, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L
We just had an earthquake. I'm fairly freeked.
How's everyone's
Hi Dennis,
You must be on the west coast! That was FUN!! (I'm in the Seattle area,
but originally from Alaska, where earthquakes are
considered to be more a form of entertainment than a major disaster.) Did
you run to the computer room as soon as the aftershocks ceased? Were the
machines
Hi Kevin,
We had this exact problem. It is a known issue, according to Oracle
"Support". They said it was caused by the following services being left
running during the patch:
MSDTS, SNMP and IIS Admin Services
You need to stop these before applying the patch.
Basically you're hosed. I hope
Software client needs 3 Oracle DBAs for its' I.T. team to staff a facility
that is relocating from the Northeast U.S. to the Virginia Beach, Virginia area.
The selected candidates May have to work in New Jersey for the first couple
of months..
but will be provided lodging and travel expenses to
Where was the earthquake? I am in the SFBay area and have not seen/felt
anything about an earthquake.
Daniel Curry
Tsola, Inc.
[EMAIL PROTECTED]
650.486.2624
-Original Message-
Sent: Wednesday, February 28, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L
Subject:
few miles south of Seattle, magnitude 6.2
Someone opined that it was cause by Windows crashing...
At 11:25 AM 2/28/01 -0800, Kevin Kostyszyn wrote:
whoa, where?
Dennis Taylor
Niels is bohring.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
It was centered in Seattle. We felt it here in Portland to.
Nothing like working in a fab, that if a certain something goes
wrong all of Gresham is gone, while in the middle of an earthquake.
Good thing I don't panic easy:-)
-Original Message-
Sent: Wednesday, February 28, 2001 11:17
Well, that was gruesome.
I couldn't log in as QDBA, so forget about using dbms_job.
I ended up revoking CONNECT, RESOURCE, and every other role it had.
Then I did a shutdown abort, startup restrict.
QDBA's job was still listed.
I took the risk of issuing a DELETE statement against dba_jobs,
I am using 8.1.7.I think this is bug.What isur view
-Mala
From: Rocky Welch [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: EXPORT PROBLEM
Date: Wed, 28 Feb 2001 11:45:51 -0800
Hi Mala,
If you're on 8.1.6 it's a bug. If you
Is there any way to do a snapshot refresh and not log it? We refresh
numerous snapshots (materialized views) every hour and it fills up our
archive filesystem pretty heavily. There is not much other redo log
information generated on this system other than the refresh. Suggestions?
--
Please
I'd say the fun quotient is inversely proportional to the number of things
that fall on your head.
At least that was my experience in Fairbanks in 1976 when an earthquake
occured there...
--Walt Weaver
Bozeman, Montana, USA
-Original Message-
Sent: Wednesday, February 28, 2001 12:58
I hate to say it but consult the metalink. That's how I found out about it
on 8.1.6.
--- mala singh [EMAIL PROTECTED] wrote:
I am using 8.1.7.I think this is bug.What isur view
-Mala
From: Rocky Welch [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Since you insisted on no guessing the only true test is for you to do
it. Since we dont have your database to test it out on,
its time for you to bust out the documentation, look at explain plan,
tkprof,.
Happy testing.
joe
I've got some simple questions on tuning SQL. Please reply with
At 12:41 PM 2/28/01 -0800, you wrote:
Hi Dennis,
You must be on the west coast! That was FUN!! (I'm in the Seattle area,
but originally from Alaska, where earthquakes are
considered to be more a form of entertainment than a major disaster.) Did
Yeah, I'm in Vancouver BC. Actually it wasn't
Failover information in Oracle Internet Directory (OID) is entered like Net8
configuration information. You can import the exact information that is in
your TNSNAMES.ORA into OID, so if you can code failovers in TNSNAMES.ORA you
can put it in OID as well. So you would handle failovers using OID
Yes, actually, I was. After that one, the rest were child's play!
-Original Message-
Sent: Wednesday, February 28, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
You must not have been in Anchorage in 64!
-Original Message-
Donna (SEA)
Sent: Wednesday, February 28,
True, nothing fell on my head with this one. I will admit that I no
longer am calling this one fun.
I ran home at lunch and found quite a bit of damage to the brick entryway.
Of course, no earthquake
insurance, talk about needing diasaster recovery! I need a bigger bank
balance!
Walt, were
I've discovered a workaround for an Oracle InterMedia Text
error.
Our platform: Oracle 8.1.6 on Windows2000
Our problem: We get the following errors when querying (with
a Contains() expression) a Union All View of
identically-structured tables, each with an InterMedia index
on the same CLOB
If we have :
1- Table T1 (c1 char, c2 char)
2- Unique index I1 on T1 (c1,c2)
3- Insert into T1 values (null,'A');
Oracle stores the above values in the index.
4- If we try to insert the same values (null,'A')
we get an error that duplicates were detected.
The question is if Oracle can
hi guys,
I installed OAS 4.0 on a NT server successfully.Then as per the post
installation tasks in the installation guide i followed the following
1) Rebooted the machine
2) connecting to the welcome page using
http://hostname.domain:port_number
3) Entered the node manager username and password
Hi,
I am asked to prepare a document listing all
possible suggestions for an effective tuningof a single
table.
The table has five to six columns with one column
having a Long Raw datatype.
The average row that gets into the database is
about 1GB.
Could anyone give me possible
The Rule-based optimizer is influenced by the order of your WHERE statements
... it won't re-arrange them to improve performance.
If you're using the cost-based optimizer, I believe it will decide what
order to process the WHERE statement clauses, based on what it decides is
the most efficient
Walt,
Last summer we noticed our support bill was split into two pieces--one for support and
one for upgrades. You can still buy both. I didn't notice that it was a lot more in
total than before, but it does give a cost cutter a chance to say we only need one of
those pieces!
Sarah
Group,
being fairly new to Oracle (and this list) I have what I consider (and
others may dare to differ) a valid question(running with 8i on Solaris
2.6)
How do you manage the division of resources between 2 instances located on
the same host?
We have two oracle 8i instances (and a number
So my standby is in managed recovery mode.
i was curious internally how does oracle send the archive logs across
from primary to standby machine(they are physically separate).
i know it goes via net8, does it do some internal fopen to write it out
and apply it, or am i way out in left field
I think you can partition the table. It would not change the logical
database design (so, your application will not see the difference).
Based on you numbers, it is very possible that row chaining and migration
exist. Follow the steps I passed to you earlier.
My suggestion:
1. Recreate database
Does anyone know - will I still have access to Metalink if I will not pay for the
support?
TIA,
Michael Netrusov,
www.atelo.com
(202) 262 8469
(877) 528 0090
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001
never mind, i found it, the RFS(remote file server) process handles it.
joe
--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L
you have to do an "alter user quota unlimited on tablespace users;"
or do a "grant unlimited tablespace to test;"
HTH
rahul
--
From: Kelly Ng Huey Ching[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 10:50 AM
To:
taking this thread further..
if we check the sysstat # 203,204
OS Page faults
OS Swaps
how accurate OS paging statistics these parameters would provide ?
regards
--
From: JAGAN RAO[SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 28,
Hi, All,
I have granted DBA role to an user. But I don't want him holding the
"Drop Any Table" system privilege.
I did as follows:
1. Connect as sysdba.
2. revoke drop any table from ABC-user;
And I got the error:" ORA-01952: system privileges not granted to
'ABC-user'".
Could anyone
78 matches
Mail list logo
