We are in the process of creating a 9.2 RAC database. And we are being
forced to follow a standard whereby, all files are to be in a directory
structure, say /local. No standards have yet been defined, if one were
using raw volumes. And since we will be using raw volumes for the
datafiles, to
tnsping for tbasun Database (below) 10 ms
whereas tnsping for bby01 Database (below) is 10,000 ms
Qs. Is is due to the Multiple ADDRESS Entries with LOAD_BALANCE = yes for tbasun ?
NOTE - tnsnames.ora file put on the Database(DB) Server itself tnsping also being
issued from the DB Server
Setting of parameter vxio:vol_maxio (Veritas)
Nature of Database Hybrid in Nature
Application Database undergoing MOSTLY Index Scan Operations (db file sequential
reads).
The underlying OS Call is pread64 .
Qs. Anybody has used the parameter in Production Databases ?
Qs. Is there any known
Thanks Jared
I want to create an amended version that I can call from a shell script,
passing the table name each time I call it?. Is there such a version already
in existence?
John
-Original Message-
Sent: 08 February 2003 00:10
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Importance:
Hello
list,
I
am implementing a software in Oracle 8.1.7.
The client wants to
have the backup and recovery procedure. As of now, they are using EXPORT
utility.
Could any one of you
tell me any other utility which the client will be able to use for Backup of
their data ?
Thanks and
Hi DBA's
I have a common listener setup for 4 database on a
server.
i.e. listener.ora is listening to 4 different
databases on the server (port numbers are different
for each DB).
is there a way to stop services for only 1 database (I
mean if I stop listener, it stops connections for all
These are both supposedly LDAP 3 compliant, is it possible to make them work
well together?
(I logged a TAR as well, am looking for comments).
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
Santosh,
By stating that the client wants to backup their data, Does it mean
that they want to backup the database or just their data. If it is Just
their data then the export works great to extract their schema from the
database. If they want to backup the entire database then RMAN,
Hot-backups,
--FYI--
Dave
-Original Message-
Sent: Friday, February 07, 2003 6:12 PM
To: Farnsworth, Dave
and Notices
This e-mail contains priority desupport information and is being sent to MetaLink
users as a service from Desupport Services.
The following new desupport notices and advisories
This is great! So how can we get a RAC configuration running for less 1000
dollars? :)
Waleed
-Original Message-
Sent: Sunday, February 09, 2003 12:24 AM
To: Multiple recipients of list ORACLE-L
To those who are interested in running RAC on Linux.
I know we have been talking about RAC
Export is not the best way to do backup. Have a look at
rman, it comes with the rdbms. Ruth
- Original Message -
From:
Santosh
Varma
To: Multiple recipients of list ORACLE-L
Sent: Monday, February 10, 2003 6:43
AM
Subject: Backup and Recovery
Hello
short answer: no
Longer answer:
you would have to have a separate listener for each database to stop
the services only for one database. Or you could edit the listener.ora
file, remove the one database you wanted to stop listening for, stop
the listener (this won't disconnect anyone already
Srinivas
Stopping the listener does not affect existing connections, but only
users that are trying to connect. Therefore you can modify the listener.ora
file, then stop and start the listener without affecting your users. I would
recommend that you avoid doing this when a lot of your users are
Santosh - You might consider locating an Oracle consultant with experience
in backup and recovery procedures to help this client. If the client is
paying you under the assumption that you are an Oracle backup and recovery
expert, you may be misleading them. Honesty builds long-term relationships.
John,
I forwarded your suggestion, together, with more information on the Veritas
Foundation Suite
to the team negotiating the hardware solution with the vendors [my involvement
came in as I was allowed to us about how database backups in a SAN
were to be done].
Hemant
At 09:29 AM 07-02-03
I'm setting this up now. Still not exactly smooth. I currently have 4
different sets of instructions on how to set this up and I'm working through
them with increasingly high stress levels =)
Perhaps it's time to cut back the coffee intake and have lunch.
Cheers,
Mike Hately
-Original
Title: Message
There
is a product from CA (they got it when they bought out Platinum Technology)
called SQL-Station. It is now a part of the Unicenter environment. It provides a
cooperative development that includes versioning and deployment options. I've
used it in an environment with 15
Does anyone know how to turn on client-side SQL*Net tracing?
Jeff - Thanks for your idea. We were able to find the sqlnet.log file, which
I was unable to find previously. It does have the TNS-12560 error you
predicted. The network guys think they have the switch port hard-coded to
100Mb/s full
Ask Engineering about the possibility of going 105% on the reactor.
Engineering says 105% possible, but not recommended.
-- The Hunt for Red October
Egad! It's probably possible, although I'm not too certain how you'll need
it setup. When you say work together, what
I don't think that link is active anymore. It forwards to what looks like
the ISP's page.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Friday, February 07, 2003 7:59 PM
Well u still probably can't(for production purposes) but for
testing(which is what i want to do), its possible.
I'm downloading right now, 4 600M+ iso images.
hopefully next week will start messing with it and let you all know how
it works out.
Joe
This is great! So how can we get a RAC
Desupport Administrator?? That must be a lovely job. I hope that he or she
does not get overly productive.
-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L
Subject: FW: Oracle
Hrm, let's see. I use one PC with 1/2gb RAM, 20GB HD $500. VMWare $399.
RAC (download from OTN).
There you go. :)
Richard Ji
-Original Message-
Sent: Monday, February 10, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
This is great! So how can we get a RAC configuration
How to build a $1000 RAC
http://www.cool-tools.co.uk/products/docs/91rac_config.pdf
;)
-Original Message-
Waleed
Sent: 10 February 2003 14:04
To: Multiple recipients of list ORACLE-L
This is great! So how can we get a RAC configuration running for less 1000
dollars? :)
Waleed
I found a couple of demo versions.
One is from Sybase:
http://www.sybase.com/detail?id=1020999
One is from TheKompany:
http://www.thekompany.com/products/dataarchitect/demo.php3?PHPSESSID=328ec531c8c3db6bb4f5086963d866bf
I heard that Oracle Designer can do this? Is this true? Last time I
Hi all,
I am in the process of setting up an Oracle Database that is currently
about 70Gb in size. The data is static except from a weekly load of
about 20Mb of data. Each load goes into a new partition held in a
separate tablespace. After the load the tablespace is changed to be read-only.
So
Title: RE: Freeware reverse engineer ER diagram from ODBC connection
Oracle Designer can do reverse engineering except Oracle calls it Design Capture now...
-Original Message-
From: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 10:29 AM
To: Multiple
Hello Folks,
I am just working with recovery scenarios and have question about
rman.
Consider following situation:
1. Use recovery manager without catalog only control file.
2. Have level 0 database backup + level 1 backup.
If we lost all datafiles except datafiles from SYSTEM it is not a
OCFS I'm afraid. The RHAS install goes quickly and without incident. The
problem I have is that having installed the firewire kernel and the OCFS
tools, my disk (which I can happily format as ext2) refuses to be formatted
as an OCFS filesystem.
The format command completes immediately with no
Hey all,
In 8.1.7.4, does anyone have a SQL that will take the output from the
following:
SELECT sql_text
FROM PERFSTAT.STATS$SQLTEXT SS
WHERE SS.HASH_VALUE = :myhash
ORDER BY PIECE
...and append/concat all the rows into a single column.
I *know* someone's done this before and I don't want to
Cool :)
Waleed
-Original Message-
Sent: Monday, February 10, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
How to build a $1000 RAC
http://www.cool-tools.co.uk/products/docs/91rac_config.pdf
;)
-Original Message-
Waleed
Sent: 10 February 2003 14:04
To: Multiple
Are you pulling your hair out over the RHAS or RAC installs?
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Monday, February 10, 2003 9:19 AM
To: Multiple recipients of
Oh forgot the $60 for RHASD.
-Original Message-
Sent: Monday, February 10, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
Hrm, let's see. I use one PC with 1/2gb RAM, 20GB HD $500. VMWare $399.
RAC (download from OTN).
There you go. :)
Richard Ji
-Original Message-
How about just a 'Reload' insead of stop and start? Much faster.
Ron Smith
-Original Message-
Sent: Monday, February 10, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L
Srinivas
Stopping the listener does not affect existing connections, but only
users that are trying to
Question 1)
I've got a update trigger on a table that updates a record in another
table.
i.e.
CREATE OR REPLACE TRIGGER table1_trigger_update
BEFORE UPDATE ON table1
FOR EACH ROW
BEGIN
UPDATE
Table2
SET
Table2.version = Table2.version + 1
WHERE
Ayou're using Wim Coekaerts' Firewire mod. I wonder if that's
what's giving you grief and not OCFS? Please?
We should be able to test RAC with a dual-ended SCSI or SAN.
prayHopefully we won't have those problems!/pray
Keep us informed of your progress! GL!
Rich
Rich Jesse
Alex,
In nocatalog mode, rman stores info it needs in the control file. As long as you have
your control file, you should be able to recover.
When in doubt, try it out
Lisa Koivu
Oracle Monkey Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA
Hi Listers,
I set the sql trace true in a procedure,
let's say the procedure testproc(var1 IN number, var2 IN varchar2).
Is there a way to know the value passed to that procedure (the value of var1
and
var2) in the trace file ? And also the value of bind variable of each SQL
statement in that
Are you going to use RH AS or the plain version?
Thanks
Waleed
-Original Message-
Sent: Monday, February 10, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
I'm setting this up now. Still not exactly smooth. I currently have 4
different sets of instructions on how to set this
Ah, got it! As with all things it doesn't really work until you tick the box
that says FORCE.
Cheers,
Mike
-Original Message-
Sent: 10 February 2003 16:38
To: 'Jesse, Rich'; '[EMAIL PROTECTED]'
Cc: Hately, Mike (NESL-IT)
OCFS I'm afraid. The RHAS install goes quickly and without
Ceri
If you can change some of the tablespaces to read-only, you can back them
up once, and keep the tape where you can find it if you ever need it. The
key is you must back it up AFTER you change it to read-only. This is the
simple answer. Basically if you back it up, then change it to
Alex
Someone may reply with better information, but we have been doing
disaster recoveries with RMAN, using just the control file. In our case, we
are just trying to recover the level 0 backup, but I can't see a reason you
couldn't incorporate the level 1 backup as well. If you are just getting
Rich,
I was just about to go the SCSI route when the firewire patch came out and I
have 2 machines available with firewire and 500MB RAM each.
Once I get this up and running I might try the NBD method that Brian Hengen
suggested last week.
Someone on site here is talking about building a Tru64
In order to see the actual value of bind variables, you need to use
event 10046 with level 4.
from your procedure do:
alter session set events '10046 trace name context forever, level 4'
Richard
-Original Message-
Sent: Monday, February 10, 2003 12:29 PM
To: Multiple recipients of list
This might get a better response from the TOAD development team themselves:
http://groups.yahoo.com/group/TOAD
http://groups.yahoo.com/group/toadbeta
HTH!
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
Douglas,
After you change the tablespaces to read-only then you can them up at
your leasure. Oracle will not change them again until you change them to
read-write for what ever reason. Be sure to backup controlfile to
trace after you change the tablespace to read-only to have an up to
date
Thanks Jesse.
Oracle Support said I could manually import LDAP files across to OID, they
didn't say anything about the other way around.
As for hair, I lost much of mine, the rest I keep cropped short just for
situations like this. It's too short to pull out.
I had another interesting answer
Alex, 8i or 9i? If 8i, you will need to manually recover your control file
from your RMAN backup sets since you are not using a recovery catalog. With
9i, it's much easier, as long as you have enabled automated control file
backups.
RF
-Original Message-
To: Multiple recipients of list
Hi Jared,
I think a letter to the Redwood Shores police
department alleging IP theft and asking them to investigate
may be effective.
I believe copyright in it's current business model is dead
but since everyone's reputation is based on their copyrights
you can not allow this theft to
It worked well from SQLplus but not from procedure.
Did I miss something ?
SQLcreate or replace procedure testtrace
2 as
3vempno varchar2(3);
4vempno1 varchar2(3);
5begin
6 ALTER Session SET EVENTS '10046 trace name context forever, level 4';
7 select empno
Manually??? What about the Oracle Directory Integration Server as
specified in Chapter 30 of the Oracle Internet Directory Administrator's
Guide Release 9.2 (Part Number A96574-01)??? I thought that's specifically
what it was for, but I've been second guessing Oracle Support as far as OID
since
You might try playing around with the DBMS_SUPPORT package which is loaded
with the dbmssupp.sql script in the rdbms/admin directory.
dbms_support.start_trace_in_session(SID, SERIAL#, waits=false, binds=true)
dbms_support.stop_trace_in_session(SID, SERIAL#).
-Original Message-
It
An 8.0.6 ops database being migrated to 9i RAC database on Solaris 8. The
8.0 database had an block size of 2k. Multiblock read count is 8. This is
an OLTP database, all transactions almost always work on a single row. None
of the row sizes exceed the block size. Hardly any chained or migrated
alter session is DDL, you should do:
execute immediate 'ALTER Session SET EVENTS ''10046 trace name context
forever, level 4''';
Richard
-Original Message-
Sent: Monday, February 10, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
It worked well from SQLplus but not from
Hi.
You would need to wrap the ALTER SESSION into an Execute Immediate
statement:
EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 trace name content
forever, level 4''';
Regards,
Mark.
PS: Single quotes become double quotes since the whole thing is wrapped in
another set of quotes,
Try
exec sql alter session set events .
Rajesh
-Original Message-
Sent: Monday, February 10, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L
It worked well from SQLplus but not from procedure.
Did I miss something ?
SQLcreate or replace procedure testtrace
2
Hi Dave,
Thank you very much for your detailed reply.
I am looking in to it and will let you know how I am going to handle it in
my case.
Sorry, it took a while just to say thanks also as things have been hectic on
my side.
Thanks again.
Surendra
-Original Message-
[mailto:[EMAIL
Stephen,
What version of oracle are you talking about?
I didn't find dbms_support in 9.2.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 10, 2003 3:43 PM
You might try playing around
As a longtime Oracle DBA who has used many products, including RMAN, I
find myself
guilty of a paradoxical mistrust of RMAN, dating back from the time when
Oracle has tried
several products, including integration with Legato and other
hardware/software backup vendors,
without a consistent
Reading my oracle 9i new features , there is now something
called:
Multiple Database Block Size Support. In other words, it is no
longer necessary
to commit to a single block size for your database. I'd suggest
looking into this, as
it may now be possible to test using different blocksizes for
You have to load it by running the dbmssupp.sql script in the ?/rdbms/admin
directory.
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Bind variables
Stephen,
What
Hi,
We are using Oracle 8i and have successfully recovered the control file from
the a backup piece. Like you, we have been testing this for disaster
recovery purposes and it works well. There is one tip that I can suggest
though.
In the Oracle manuals all the suggested scripts seem to
If only Oracle can come up with a Postgresql command such as:
pg_dump dbname | gzip dbname_backup.gz
Then backups would be easy. I know, I know Oracle can do the same with
export, and sqlplus but hell it ain't that easy with Oracle.
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ:
Hello Folks,
Thank you everybody for help.
Sorry to confuse you I forgot to show what version I am using for testing...
It is 9iR2.
I just realized why I got unexpected behavior of recovery scenario
during my testing. I removed datafiles with started instance. And when
my script tried to login
Title: 8.1.7.4 databases going bad
This is on our RS6000 test server running AIX 4.3.3.
We've been gradually migrating our 8.1.7.x databases to 9i. We started by laying down
the 9i software 3 months ago. No problem. Then we started up the 9.2.0.1 listener as the sole
listener for the box 3
Lyndon,
Unfortunately Oracle is probably focused more on dealing with large
databases with complicated uptime requirements. I can just imagine how
long it would take to push 1TB through gzip. Doing a daily backup would
require multiple CPU's just to deal with the fact that it would still be
Logicworks, maker of ERwin, was bought by Platinum which was bought by CA.
It was a great tool the last time I used it (3 years ago) and expensive.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 10, 2003 9:04 AM
I don't think
Hi Ruth,
In my company we run export for our daily backup. Why is it not best way to
do backup ? and about RMAN, is it third party program on oracle or it is
already include in oracle, or if it is a script, would you share it to me ?
I use oracle 9i on windows 2000 server.
TIA,
Sony
Hi Bahar,
If you run it on form you can find out the values by debugging that
'procedure testproc'.
Rgrds,
Sony
-Original Message-
From: Bahar, Rivaldi (BBASSI-CHQ) [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 12:29 AM
To: Multiple recipients of list ORACLE-L
I dumped my home grown scripts pretty soon after Oracle released RMAN
(after they fixed a number of early defects of course) and have never looked
back. Although the RMAN scripting language is yet another language to learn
it is well worth the effort. It allows you to backup an entire database
Lyndon,
You are comparing Apple with Orange here. I can backup my hsql database
which is stored in a text file with:
cp my_db my_db.backup
using OS command only. :)
Richard Ji
-Original Message-
Sent: Monday, February 10, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L
If
Stephen Lee,
Hi, in 8i etc, you can use
dbms_system.set_ev(sid,serial#,10046,level(1-12),'') too.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
=== 2003-02-10 14:09:00 ,you wrote£º===
You have to load it by running the
Thanks to all who replied to me regarding Back-up. I think RMAN will be good
choice for Back.up.
Thanks and regards,
Santosh
-Original Message-
WILLIAMS
Sent: Monday, February 10, 2003 7:24 PM
To: Multiple recipients of list ORACLE-L
Santosh - You might consider locating an Oracle
An 8.0.6 ops database being migrated to 9i RAC database on Solaris 8. The
8.0 database had an block size of 2k. Multiblock read count is 8. This is
an OLTP database, all transactions almost always work on a single row. None
of the row sizes exceed the block size. Hardly any chained or migrated
-Original Message-
From: John Dunn [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 12:04 AM
To: Multiple recipients of list ORACLE-L
Subject: Questions for Oracle list
Question 1)
I've got a update trigger on a table that updates a record in another
kommareddy sreenivasa,
hei, you can just create 4 listener and each listener listeners on one
port for one database, isn't it pretty easy?
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
=== 2003-02-10 04:03:00 ,you
Raj,
Another consideration is a potential for a buffer busy waits. the larger the
block size is, the more the number of rows in an average block. Thsi
increases the possibility of a buffer busy wait.
HTH.
Arup
An 8.0.6 ops database being migrated to 9i RAC database on Solaris 8. The
8.0
Rajesh.Rao,
If you exp/imp, your can change your db_block_size, else, you have to
move all the tables to the new tablespaces with 8K db_block_size.
And if you are using 9.2, I suggest you use segment management auto
option of the tablespaces new created.If
On Monday 10 February 2003 07:23 pm, Richard Ji wrote:
Lyndon,
You are comparing Apple with Orange here. I can backup my hsql database
which is stored in a text file with:
What's hsql ?
cp my_db my_db.backup
I do not undertstand this command. Oracle database files are in binary format.
This has nothing to do with copyrights, patents, reputation, or IP. It's a
script. It was posted on the internet. Nothing more than a case of bad
manners.
There is no disservice in not tilting at this particular windmill. You owe
Jared an apology.
- Original Message -
To: Multiple
How to find approx. index row length with ease ?
There is seemingly some Easy way whereby after analyze of the Index ,
the Column sizes which get populated in some internal object can simply be Summed up .
Oracle 8.1.7
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Kommareddy, Srinivas (MED, Wissen Infotech),
What about change it from the database? like alter system enable
resticted session?So, general user without special privs will not be able to logon to
the database even the listener is still up and conection to other database is still
Hello Mogens,
I really got interested with your reply.
You seem to know a lot about how Oracle works with their licenses.
Is this information just your opinion or you know it for a fact?
I'd really appreciate if you could give your legal opinion,
about what we plan to do.
For starters, we plan
83 matches
Mail list logo