Good question Maria and something a lot of us on the list either do, have
done or have considered.
I have no intention of questioning your abilities but being the sole DBA on
a site it is quite easy to be seen as a good dba because the users and your
management have nothing to compare against.
It
Hi all,
I tried to connect to a remote database running Oracle 9.2.0.1.0.
from my Oracle Client (SQL*Plus) which is of version 8.0.5.0.0 as
SYS. I get an error message :-
ORA-01031 : Insufficient Privileges
I tried using Password file as well, but in vain...
Could someone help me in this
Yes, I have contacted both Metalink and Veritas Support. Both are working on
the problem and no resolution
has been reached till now.
I am thinking of using hot backup scripts.
Thanks
Suamthy Thankam
-Original Message-
Sent: Friday, December 13, 2002 12:00 PM
To: [EMAIL PROTECTED];
Hi all,
We have two boxes,hp and linux. db is running at hp. and we mounted the
linux volume at hp. we can able to create/copy files. But when we attemp
to create a tablespace, we got the following errors. What could be the
problem?
DB : 8.1.6
OS : HP-UX 11.0
The Alon Peled paper? Sure have. It prompted some limited testing some time
back.
And not using Forms at this site so we are clear there.
Thanks,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon,
Title: Message
Try
connecting as some other user and see.
You
may connect SYS as SYSDBA ONLY from 9i onwards, keep that in mind!
Also
check whether your client supports connecting as SYSDBA, I'm not sure it
does!
Rgds,
Venu
G.
OCP 8i
9i
-Original Message-From: [EMAIL
OK OK so I missed the semicolon after the 'statspack.snap' command . . .
sorry.
problem fixed - back to normal state.
-bill
-Original Message-
From: Magaliff, Bill
Sent: Friday, December 13, 2002 11:55 AM
To: Oracle-L (E-mail)
Subject: DBMS_JOB problem
I'm
Statspack is installed under the username PERFSTAT. You should be able to
tell if such user exists by quering the dba_users table.
There are two good articles on the Oracle Magazine on how to install and use
Statspack. Search the technet.oracle.com site
Babu
- Original Message -
To:
From a fellow employee of mine:
I am in the process of upgrading from an Oracle 7.3.4 environment using
Pro*C and an HP 32-bit C Compiler (version A.10.32) to an Oracle 8.1.7
64-bit environment using 64-bit Pro*C and a GNU (gcc) 64-bit C Compiler.
All software is on an HP UNIX version 11.00 box.
Title: RE: Active sessions chewing up a huge amount of RAM
What
tool are you using to produce this? sqlplus? If you can use plsql,
my first thought would be to builda plsql table that would be laid out in
the format you want the data presented in. load the array in one pass, and then
loop
Title: RE: warehouse builder's dependance on oem job system.
wow. thank you. i will be testing this in the afternoon but before i do, i have one more question. we have ~50 jobs we would like to cron instead of submit to oem. so my question is, are these tcl arguments in the same order and of
I've did some tests on 816.
The tables were small, 3-4 fields including the PK
with a number of rows between 200 000 and 300 000.
The query time was the same except that the IOT read
50% less blocks.
--- Reardon, Bruce (CALBBAY)
[EMAIL PROTECTED] a écrit :
Larry,
Have you seen paper 138
I run the jobs via cron, without any parameters and we don't have any problems. If
you look at the parameter list, you'll find that most (if not all) have default values
anyway. I have been running them via cron for months without any issues, other than
the fact that we can't multitask.
Shuan - Thanks for explaining the Chinese character. Let me make it clear
that I am only a novice where wait statistics are involved, although it
solved 2 ugly problems for me yesterday very quickly. And the buffer hit
ratios were really great during both situations.
I would highly recommend
Larry Elkins wrote:
Listers,
Solaris 7, 8.1.7.4 64 bit, E10K.
Have a test IOT of around 120 million rows being created as we speak --
partitioned by month (3 months for the test), overflow by naming the column
at which to break, compressing the concatenated key, using secondary BMI's.
Maria - I think John has offered some very good advice. Often DBA tasks can
be split into development support tasks and production support tasks. At
larger sites these may be separate jobs.
When you say you are thinking of part-time DBA work, are you thinking of
marketing yourself, or seeking
Title: Another myth goes by the wayside
I learned something new today. We were getting an error when our VB app was connecting to the base: ORA-12505 TNS: listener could not resolve SID given in connect descriptor. It was an obvious tnsnames problem. So we punch up the
Shaleen/Kirti,
If this is version dependent, then Oracle will brand this a 'feature' rather
than a bug. And I think I know why this is happening As per the Concepts
manual, When you create a stored procedure, Oracle parses the procedure and
stores its parsed representation in the database. I
Title: RE: career questions
Hi Maria,
Having bounced back and forth between consulting and being an employee I'd go for it. Whether you should go for it or whether you will enjoy the consultant role is a matter of personal preference. One way to find out is to just jump in but it also
Title: New course for 9i - Dumps/Crashes from Oracle University
http://education.oracle.com and search for D12856GC10
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal
By all means, try to use SQL Server rather than Access.
SQL Server is much more capable than Access.
If by 'small' you mean 'free database servers', consider
PostGreSQL or MySQL.
Jared
On Tuesday 10 December 2002 13:15, [EMAIL PROTECTED] wrote:
Hi,
We are virtually an Oracle shop with 2-3
I'm trying to use DBMS_JOB to schedule hourly statspack snaps. Per note on
Metalink, I've try to run the following:
SQL variable x number;
SQL begin
2 dbms_job.submit(:x,'statspack.snap',sysdate,'sysdate + 1/24');
3 end;
4 /
begin
*
ERROR at line 1:
ORA-06550: line 1, column 108:
Behave children. ;)
No, I wasn't reading the list. Another story...
Jared
On Tuesday 10 December 2002 10:20, Rachel Carmichael wrote:
1) he's reading the list while traveling
2) I'm having dinner with him tonight I'll tell him
:)
--- Ruth Gramolini [EMAIL PROTECTED] wrote:
Stop
Have you tried:
1) www.veritas.com/support
2) metalink.oracle.com
Jared
On Wednesday 11 December 2002 12:05, Panicker, Thankam S. wrote:
Hi All
I am trying to create a template on a Oracle Failsafe Database
using Netbackup 4.5 Oracle Agent GUI. I try expanding the
database node and after
Hi,
We have a lot of views. Now the users have a new
requirement, only the user 'admin' can see all the
data from the views. The user 'typical' must see all
data except the one from group 380.
A basic solution is to create 2 sets of views with one
set having a group number 380.
I'm looking for
After working for the past 4 days on a continual basis with Oracle/Veritas
support, I have come to a conclusion that templates are not going to work on
an Oracle Failsafe database on Windows 2000 cluster.
I was able to backup the database and the archive logs from the Veritas
Master server
Thanks for the great suggestion!
I will remember to use that one when
those developers start getting too lippy ;-)
Babette
-Original Message-
Richard
Sent: Thursday, December 12, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
Howdy,
I believe that truncating DUAL has also been
STATSPACK related can be found under $ORACLE_HOME/rdbms/admin directory in these
documents.
Version 8.1.6 or prior ( must be 8i )
$ORACLE_HOME/rdbms/admin/statspack.doc
Version 8.1.7
$ORACLE_HOME/rdbms/admin/spdoc.txt
Prior to 8i: ( No statspack! )
$ORACLE_HOME/rdbms/admin/utlbstat.sql
Walter,
Since I just finished pulling a pile of hair out on a similar, although not
identical, problem yesterday he might look to see if things are the same. In
Pro*C we use a data type called a VARCHAR inside the Oracle declare section.
Something like:
EXEC SQL BEGIN DECLARE SECTION;
John,
Shaleen mentioned to me, in a direct e-mail, that there was a bug in 8i and there was
some workaround available. I do not have the bug number.
- Kirti
-Original Message-
Sent: Friday, December 13, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L
Shaleen/Kirti,
If
Title: Another myth goes by the wayside
Chris,
yeup. oldie but goodie - works that way all the way back to version
6.2 on VAX VMS.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Bowes, Chris
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 13, 2002 11:49
Title: RE: SQL question avoiding 2 views and not in
OLS -- Oracle Label Security... I think that's the key you are looking for.
-Original Message-
From: Stephane Paquette [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
Add this to where clause:
group decode(user,'typical',380,-100)
Instead of -100 use any number not used by the groups.
Also read about contexts and grain level security.
Waleed
-Original Message-
Sent: Friday, December 13, 2002 2:59 PM
To: Multiple recipients of list ORACLE-L
Hi,
Title: RE: SQL question avoiding 2 views and not in
Hi Stephane,
This may be more effort but have you considered having a security table to join to in the one view, instead of two views? Multiple views can really hose the optimizer, as I am sure you know. However adding a table then
I believe the error message stack is telling you what the problems is. There's
an instance of something using that datafile. Try running fuser on it.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 12/13/2002 8:37 AM
Hi all,
We have
Title: RE: SQL question avoiding 2 views and not in
dbms_rls is cheaper to use ...
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't reflect that of ESPN
Title: RE: SQL question avoiding 2 views and not in
Has anyone used context and fine-grained security? I seem to remember the performance hit was not minimal when using this functionality.
-Original Message-
From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
Sent: Friday, December 13,
The bug number is 2398050. You can read about it in metalink alongwith the
workaround. It is fixed in 9i. But the problem is that even workaround does
not work for me. I am working with oracle support on this.
Meanwhile I have resolved my basic problem with AQ for which I was trying
all this by
LOL
Title: RE: New course for 9i - Dumps/Crashes from Oracle University
hmmm ...
http://education.oracle.com/web_prod-plq-dad/plsql/cdesc?dc=D12856GC10_org_id=1001=US
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN
I had
problems running Exceed XWindows and the 9i V2 installer - turned out
theTCP/IP stack on my W2K system was fubar'd - uninstalled, reinstalled
TCP/IP thenI could run the installer and X-Window.
~brian
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL
Lisa,
A couple of years ago, when I was a consultant, I implemented Application
Context and Fine-Grained Access Control, AKA Row Level Security for a
client.
Since it causes a predicate to be appended to the Where clause of every SQL
statement issued against the tables having a Security Policy,
I took this course via Online learning network and it was conducted by Lex
deHaan, who knows what he is talking about. Recommended if you want to
understand the difference between _corrupted_rollback_segments and
_offline_rollback_segments :) And of course, in an ILT course, you can
always quiz
Sorry to take so long to respond (not much time for list lately...)
If you are going to be rebuilding regularly,
then DO NOT use compressed indexes. They save lots
of space and seem to work fairly well, but you
cannot do online index rebuilds with them
(at least it was that way in 8.1.6)
Another
The first one (seen in 8.1.6 and 8.1.7) was deadlocks caused by
simultaneous SELECTs and the addition of a new partition (even though
the queries were not querying the partition). Those deadlocks were
occurring at the dictionary level - because even if an IOT is physically
a single index,
Bill,
Try putting a ';' after snap that may fix it.
SQL variable x number;
SQL begin
2 dbms_job.submit(:x,'statspack.snap;',sysdate,'sysdate + 1/24');
3 end;
4 /
I'm trying to use DBMS_JOB to schedule hourly statspack snaps. Per note on
Metalink, I've try to run the following:
SQL
true they hv default values, but i think the Chris's runtime parameters are diff than
his default values. ill try to give another look at it come monday.
-Original Message-
From: Scott Canaan [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 10:39 AM
To: Multiple recipients
Jeremy, you've been left out of the camel joke, evidently.
It will come around again. I guess pointless is better than useless :)
joe
Jeremy Pulcifer wrote:
So, Joe, are you pointless for a reason, or is there a joke I'm not
aware of.
-Original Message-
From: JOE TESTA
In 9iRelease2 [probably 9.0.1 as well] , the Data Gatherer is included in
the Intelligent Agent.
I could use the OEM Console to see Unix performance charts [CPU, IOs,
FileSystems]
online but when I enabled collection of statistics, I began seeing errors
in the dbsnmp.log :
NMS-1: Warning:
The first time we tried importing our 8.1.5 [OPS] database
into 9.0.1 and 9.2.0.1 with
EXTENT_MANAGEMENT Local for ALL tablespaces
SEGMENT_SPACE_MANAGEMENT Auto
we found that tables with LOB segments could not be created.
This was a 9.0.1 bug which was expected to have been fixed in 9.2
[I
50 matches
Mail list logo