for the don'ts you could just read my paper how not to be a DBA, the
top 20 mistakes which I gave at IOUG last year
--- Freeman Robert - IL [EMAIL PROTECTED] wrote:
I'm collecting up a list of the top 10 do's and don'ts for DBA's
for a little article I'm doing. Anyone want to provide their
I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued
the command sqlplus and I rec'd a command not found error. Is there
something I forgt to do before the install? Let me kow if u need more info.
THanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Title: Message
Hi
list,
I have my DB
server with 2 network card and I want to split theconnections between the
users to balance the load.
I
addedLOAD_BALANCE=ON in the listener.ora and another line with the new ip
address with the port 1526.
Now all the
connections are managed with
Looked over some websites and still couldn't figure out why I was getting
these errors. I made sure my variables were set and still could not
connect. Any ideas?
I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need
more info.
error 1034: Oracle not avail.
error 27101:
Les,
Check your PATH. Issue echo $PATH and your should
have $ORACLE_HOME/bin
Otherwise you should enter the full path.
Luc
--- Les Ayudo [EMAIL PROTECTED] wrote:
I have just installed Oracle 8i1.7 on solaris 9
(ultra sparc 10) and issued
the command sqlplus and I rec'd a command not
found
Les Ayudo wrote:
Looked over some websites and still couldn't figure out why I was getting
these errors. I made sure my variables were set and still could not
connect. Any ideas?
I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need
more info.
error 1034: Oracle
Do the following at the command line:
echo $PATH
Then look to see if your ORACLE_HOME/bin is in the path.
If not, you need to put that in your path. and just to make sure that it is
being found, do:
which sqlplus
This should return the path to sqlplus. If it cannot find it, you will get a
Ahhh well, I will look it over but I wouldn't want to plagiarize from
you Rachel.
RF
-Original Message-
Carmichael
Sent: Sunday, February 23, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L
for the don'ts you could just read my paper how not to be a DBA, the
top 20 mistakes
Thanks Robert ! sure, i also need to learn RMAN. that would definitely help.
thanks all for the guidelines !!!
-Original Message-
Robert - IL
Sent: Saturday, February 22, 2003 8:49 PM
To: Multiple recipients of list ORACLE-L
If I may, my Oracle9i RMAN Backup and Recovery book provides
Rachel: where can we find that article ? can u post the url ?
-Original Message-
Carmichael
Sent: Sunday, February 23, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L
for the don'ts you could just read my paper how not to be a DBA, the
top 20 mistakes which I gave at IOUG last
it's likely that many of the don'ts are generic, that was the point.
or you could just quote me or make some sort of attribution, then it's
not plagiarism :)
--- Robert Freeman [EMAIL PROTECTED] wrote:
Ahhh well, I will look it over but I wouldn't want to plagiarize
from
you Rachel.
You can find it on www.nyoug.org under presentation link.
Richard
-Original Message-
Sent: Sunday, February 23, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L
Rachel: where can we find that article ? can u post the url ?
-Original Message-
Carmichael
Sent: Sunday,
The article is available on the NYOUG website (www.nyoug.org) under the
Technical Journal archives
--- [EMAIL PROTECTED] wrote:
Rachel: where can we find that article ? can u post the url ?
-Original Message-
Carmichael
Sent: Sunday, February 23, 2003 6:24 AM
To: Multiple
Title: Message
Which one is the
substituion procedure for DBMS_SHARED_POOL in 9i ?
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
hi, friends:
We are considering whether to use data guard to replace OS ha solution like
VCS.I tested Data Guard 9.2 on my linux PC server and it seems they work pretty good.
But I have no experience running data guard in production, so ask for your experience:
1.Do you use data
Hi All,
We are trying to implement change data capture. It works great on
tables, however I am unable to get it to work on snapshots. Created a
change table on the snapshot. Updated the base table, refreshed the
snapshot but did not see any rows being populated in the change table.
Any
Title: Message
Sorry, new DB and
hadn't execute the Dbmspool.sql script.
CREATE OR REPLACE
TRIGGER PAQUETES_MEMORIA AFTER STARTUP ON
DATABASE BEGIN exec immediate
dbms_shared_pool.keep('DBMS_ALERT'); exec immediate
dbms_shared_pool.keep('DBMS_DDL'); exec immediate
yes, it looks like the setuid bit is correctly set...Any other suggestions?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, February 23, 2003 6:38 AM
Les Ayudo wrote:
Looked over some websites and still couldn't figure out why I was
Title: Message
I erased the exec
clause and it worked.
Sorry and
tks
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
Don't think you need to use execute immediate. Try this (should be run
as SYS):
CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA
AFTER STARTUP ON DATABASE
BEGIN
dbms_shared_pool.keep('DBMS_ALERT');
dbms_shared_pool.keep('DBMS_DDL');
dbms_shared_pool.keep('DBMS_DESCRIBE');
Title: Message
You do not need 'exec immediate'
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list ORACLE-L
Sent: Sunday, February 23, 2003 2:58
PM
Subject: Error pinning PKS in shared pool
Sorry, new DB
and hadn't execute the
I would say that one of the more important Do's is Do understand
details about your O/S and storage system. For example, I think every
DBA should be able to map data files back to physical devices,
regardless of the storage vendor (EMC, Hitachi, etc). When you look at
I/O statistics from
Les Ayudo wrote:
yes, it looks like the setuid bit is correctly set...Any other suggestions?
Hmmph ... Is your database started ?...
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL
Title: Message
You can take out the exec immediate,
I believe.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ramon
E. Estevez
Sent: Sunday, February 23, 2003
2:59 PM
To: Multiple recipients of list
ORACLE-L
Subject: Error pinning PKS in
OK, I finished my top 10 do's and don'ts... I'll put my list in another post
for anyone to comment on.
THEN I looked at your list Rachel.
I had some of yours on mine, but I actually disagreed with you about
autoextend.
I've had this argument with others before, and here is my POV:
1. In
Here is the list of top 10 do's and don't that I came up with.
#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your
I've seen this error before a long time ago and can't remember exactly what I did
(should start keeping a database, no pun intended).
Have you been able to start this database at all ( can you start / stop it using
svrmgrl )?
If not, are there other databases running on this system (probably not
Yes, regarding these 3, how can they be considered absolute do's or don'ts?
I didn't take Cary's material to mean ignore physical IO's but rather to show the
importance and impact of logical IO's. Too many PIOs could still be an issue.
(I would say maybe Cary could speak to this, but I'd rather
Robert,
Thanks for sharing this...
Sorry to chime in late (we got over 20 inches in the mountains this
weekend!), how about Don't execute any day-to-day SQL manually more than
once; plan for reuse by scripting it the first time?
And, with all due respect, how about changing Do Monitor Your
OpenVMS 7.1-2
Oracle 8.1.7.4
db_block_size 4096
I need to re-create a large table and its associated
indexes as fast as possible, and with a limited amt of
disk space. I have a new tblspace at 7000m for index
creation.
I'm creating indexes with DOP4. (I really need the
speed I get with
Actually, I have quite a bit of text associated with each of my 10 do's and
don'ts... in the text of each, I actually state what you are saying. That
is, that there are actually very few hard and fast rules about anything. For
example with ASSM I suggest that in 9i it's probably not usable, and if
Interesting thoughts Tim! I shall consider changing those!
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Amazon.com!
-Original Message-
Sent: Sunday,
I don't say never use autoextend in production, I just say think about
it :)
--- Freeman Robert - IL [EMAIL PROTECTED] wrote:
OK, I finished my top 10 do's and don'ts... I'll put my list in
another post
for anyone to comment on.
THEN I looked at your list Rachel.
I had some of yours on
This thread is great. Wish I was paying more attention to it.
Here is one Don't
Done rely on gui tools to accomplish any task. Great DBAs can endure the
SQL to get the answer done. Good DBAs may opt for a GUI tool but will still
use command line SQL first. Poor DBAs run for their GUI
why #5 on the don'ts?
I know we've had lots of discussions on this list about it, but I
haven't seen anything that made me think never ever use that
--- Freeman Robert - IL [EMAIL PROTECTED] wrote:
Here is the list of top 10 do's and don't that I came up with.
#1 - Do Maintain your
20 INCHES of snow WOW!! When I moved up to Chicago in January, I
expected at least a little snow boy, weve gotten just little snippets of
snow and that's it disappointing. Now I know where it's all gone!
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts
Hey Robert, I rather like your list, it gives one plenty to ponder. I have
maintained my own much smaller list for some years, and thus will take this
opportunity to share it:
1. Do keep your knowledge concurrent. This includes reading books (by Jared,
Cary, let us not forget Gaja and Kirti's
Well.
...this morning my wife looked around and harrumphed, It must have been a
*MAN* who said this is more than 20 inches. :-) Can't imagine what she
was referring to...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, February 23, 2003
Title: Message
remove
exec immediate.
Richard
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]Sent: Sunday, February 23,
2003 2:59 PMTo: Multiple recipients of list
ORACLE-LSubject: Error pinning PKS in shared pool
Sorry, new DB
and hadn't
#0 - Do understand the business need(s) being met (along with business
terminology).
Being able to commincate technical information in terms that business
decision makers
use is critical for the business bottom line (and by extension - your
own bottom line).
Have Fun :)
Freeman Robert - IL
You guys are very kind, thank you.
My LIO vs PIO thesis is this:
1. Too many PIOs *is* a bad thing.
2. But eliminating unnecessary PIOs isn't enough. Even completely
memory-resident databases can perform horribly (not scale, consume
dozens of hours per query, etc.)
3. If you begin by eliminating
Now that everyone has said remove the exec I'll
confuse things :-) by adding that you might to have
the trigger always succeed, because after all, it is
a startup trigger on the database.
So maybe something like:
create or replace trigger ...
procedure pin_me(x,y,z) is
begin
...oops, and I forgot to add that you might wanna wrap
the call to 'dbms_shared_pool' in pin_me within exec
immed, so that if the package ever goes invalid (or
does not exist - ie forgotten to be run) the trigger
will still run ok.
cheers
connor
--- Richard Ji [EMAIL PROTECTED] wrote:
remove
Robert and Matthew,
Thanks for your responses. This is an attempt at adressing both points of
views.
Personally, I didn't want my messages to imply that people working with and
for IOUG are bad people that don't do anything good. If that's what came
across from my messages, a heartfelt
44 matches
Mail list logo
