Hello
all,
Sorry
for posting an off-topic discussion.
I wanted to know any
delphi mailing lists (IF ANY)...could anybody help me out ?
Thanks and Regards,
Santosh
Hello,
I have a doubt ...
Is it true that Solaris (7, 8, 9) has a OS block size of 64K by default
?
In this case, is it correct to sizing the DB_BLOCK_SIZE for a new
database (8.1.7) at 64K ?
This question because all of our databases was installed with:
db_block_size = 8192
How to check the
I need to duplicate online database Oracle 8.1.7.
It is not possible to shutdown the primary
database.
Can I do online backup this primary database by
RMAN,
and + using archivelogs create duplicate
database?
Inconsistent backups of RMAN + archivelogs = duplicate
database??
Thanks
Edouard
Can we set a limit to the number of open cursors per oracle user?
thanks. =)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maria Aurora VT de la Vega
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
Use
the Rman duplicate command
Example test script for Oracle 8i:
sqlplus /nolog EOFconnect sys/oracledba as
sysdbashutdown abortstartup nomountexitEOFrm
/data/oracle8/TEST3/*rman EOFconnect target
rman/[EMAIL PROTECTED]connect catalog
rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL
Edouardhello,
if the database is not heavy
updateable, i.e., the switching of redo log is rare, and the database is not too
large, you can try this scenario:
1. copy (operation system) all
the datafiles, redo log, etc..
you need to
copied the hall database without a redo log switch in the
Set open_cursors in init.ora. It sets the maximum open cursors per
session.
Dennis
Maria Aurora VT de la Vega wrote:
Can we set a limit to the number of open cursors per oracle user?
thanks. =)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maria Aurora
I'll look this up when I get into the office but I'm pretty sure it is 512 bytes.
[EMAIL PROTECTED] 03/04/03 04:28AM
Hello,
I have a doubt ...
Is it true that Solaris (7, 8, 9) has a OS block size of 64K by default
?
In this case, is it correct to sizing the DB_BLOCK_SIZE for a new
database
Title: RE: Purely for your amusement
Paula,
We Use:
Catalog on Solaris 2.7 64bit
with8.1.7.4 using 32bit oracle.
Targets are Solaris 2.7 64bit, solaris 8
64bit all with 32bit Oracle 8i. AlsoNT and W2K.
Only
one target (solaris 864bit) is a legato client. The legato admin machine is
Ofer,
Are you suggesting that it is OK to copy an open database without
using hot backup mode, as long as there isn't a log switch during
copy?
Do you use this method at your place of employment?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 4 Mar 2003, Ofer Harel wrote:
if
Unfortunately I found one of my database need a recovery back on time
without a legal backup. There where only the disks backup.
So I tried, I had nothing to lose.
And it worked. Not documented, not recommended, but it worked.
Of course, now this database is backup :)
Ofer
-Original
Dangerous advice !
If the database IS already in ARCHIVELOG mode, why not use RMAN
or put all the Tablespaces in BACKUP mode before copying the files
[there would be very little cost associated with this if the database
is not heavy updateable]
Hemant
At 03:54 AM 04-03-03 -0800, you wrote:
I don't see why not. Prior to RMAN I used a procedure documented in Oracle
Magazine called database cloning that used hot backups and archived logs. I
have a white paper on it if you're interested. I'm sure RMAN has the same
capability.
--
Chuck
- Original Message -
To: Multiple
duct
tape
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]Sent: Monday, March 03, 2003 5:10
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Big SGA...
Sybase, Schmybase, Oracle, Schmoracle -- the
concepts are still the same. Developers create
Hi,
Now that URGENT! applications are in place, we do not have much pressure
from our management so we can do some real planning of our database.
I would much appreciate if you could give your expert opinion.
TIA!
Aleem
We are going to start with General Ledger as our first (hoped to be)
ODC has been around for quite some time, at least a year if not more. Some
of the
the IT analysts here do get assistance from Oracle Support that way. It
sure is cool !
Hemant
At 07:18 AM 03-03-03 -0800, you wrote:
Today I found out that the OWS personnel can use 'Oracle Direct Connect'
to
Rachel,
Did you ever determine if the unix crossmount or such to be the complete
problem?
Did the Rman backup turn out to be ok after all- no corruptions?
Ever find out if they run validate command?
Thanks Rachel,
Brian Spears
-Original Message-
Sent: Monday, March 03,
I think Ora Mag started as one of the marketing tools.
Over the years, it has added more technical topics
- Kirti
-Original Message-
Sent: Monday, March 03, 2003 4:00 PM
To: Multiple recipients of list ORACLE-L
LOL.
This is actually the definition of a marketing white paper,
Because RMAN doesn't use backup mode.
-Original Message-
From: Hemant K Chitale [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Duplicate online Database
Dangerous advice !
If the database IS already in
I would never want to rely on that method. I had run into that several years
ago (Y2K), a Unix Admin had backed up a server and restored to a test
machine. Oracle wasn't shutdown at the time of the filesystem backup. The
problems were numerous because of checkpoint information in the datafiles
Darrell Landrum,
Hi, for Ufs and VXFS, It should be 8k in most case. Use df -g, fstyp
to verify the blocksize.
Also from the man newfs:
-b bsize The logical block size of the file sys-
tem in bytes (either 4096 or 8192). The
Anyone messing with RedHat 8.0 and Oracle 9.2..?
I've got 9.2.0.2.0 database running on 8.0, most of the Java utilities
don't work. (not that that is new)
Oracle OMS crashes when discovering or refreshing nodes. (segmentation
faults)
I am wondering if it is JRE version related.
I know Oracle
The last time I had a UNIX SA backup an open database the backup software
locked a control file just as Oracle was trying to write a checkpoint.
Crashed the database and left the database unopenable. Fortunately (or per
Oracle's recommendation) we had multiple copies of the control file and we
Tim and Dennis: Thanks for your responses:
SVRMGR show parameter session
NAME
TYPE VALUE
---
--- --
license_max_sessions
integer
0
license_sessions_warning integer
0
session_cached_cursors
integer
10
sessions
Aleem
There are two considerations for placing tables into tablespaces. Size
and application. Size makes sense so you can put similar sized tables
together. Study LMTs and Uniform extents. Oracle recommends you put all your
small tables in a tablespace with 128k extents, medium with 4meg
I run that config pretty successfully but I dont believe in java(its a
religious thing, bwahahaha) and really only use that config for
backup/recovery RMAN testing.
joe
Anyone messing with RedHat 8.0 and Oracle 9.2..?
I've got 9.2.0.2.0 database running on 8.0, most of the Java
Thomas
Excellent reason to not try this trick. However, it is worth remembering
that this can actually work sometimes, so if a novice SA or DBA or even a
SAN engineer claims they can back Oracle up without shutting down or hot
backup, there is a slight possibility they may succeed. In other
Oracle use it's own jre. Comes with the install package and installs
as part of the software package.
You probably have an unrelated DISPLAY or X server problem.
--
Lyndon Tiu
Quoting Odland, Brad [EMAIL PROTECTED]:
Anyone messing with RedHat 8.0 and Oracle 9.2..?
I've got 9.2.0.2.0
... large burlap sack and a small bat
-Original Message-From: Loughmiller, Greg
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003
7:39 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Big SGA...
duct
tape
-Original Message-From: Tim
OpenVMS 7.2-1
Oracle 7.3.4
Crystal 8.5
List:
We have a large work order (WO) table. It previously
had a record containing fields
job_nbr, charg_code_1, charg_code_2, charg_amt1,
charg_amt2
After major application change, charge codes and amts
were removed from WO and placed in new table. New
A late-breaking thought - but it's not my area
of expertise, so others may laugh.
If you have a very large SGA, don't you end
up with a very large 'page table' at the O/S
level to map virtual memory to real memory.
And if you do, doesn't this affect the speed
and cost of a context switch. If
Wow, I'm actually sending two messages in quick succession...
The SQL test was extremely easy if you have any SQL experience in the
real world. I never understood why people said not to take it first,
it was by far the easiest test of the five.
There probably is no best test to take first. It
1) RMAN on Oracle 8.1.7
2) Create a latest backupset using:
rman nocatalog
run
{
allocate channel ch1 type disk;
backup database;
backup current controlfile;
backup archivelog all;
}
3) Delete all *.dbf, control and archive log files (simulate a
catastrophic database loss).
4) Restore
Any ideas or leads on where to look next?
BANNER
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
PL/SQL Release 8.1.6.3.0 - Production
CORE8.1.6.0.0 Production
TNS for 32-bit Windows: Version 8.1.6.3.0 -
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC
System/6000: Version 2.3.4.0.0.
Yesterday morning our LISTENER process hung. ERROR:
ORA-12203: TNS:unable to connect to destination. We resolved
the problem using the following steps:
a)
Stop Listener using LSNRCTL utility (this hung
Do you have any 24x7 databases? We do so we *must* back them up while open
with either RMAN or in some cases with an older style hot backup.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 10:19 AM
Personally I would never
Title: RE: Big SGA...
... applied to the parent who spoiled the child ...
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Kevin Lange [SMTP:[EMAIL PROTECTED]
... large burlap sack and a small bat
Title: RE: 9i OCP Upgrade Exam - Again
Thanks Dennis, Chip, Robert, April and all the others that responded. Now I have the tools I need. I thank all of you for your generosity in responding not just to my request but to the other requests posted. Now, I have no excuse - darn!
See ya at the
Thanks! ( I was basing my initial feedback based on the default reporting of a number
of tools to show 512 byte increments. )
[EMAIL PROTECTED] 03/04/03 09:09AM
Darrell Landrum,
Hi, for Ufs and VXFS, It should be 8k in most case. Use df -g, fstyp
to verify the blocksize.
Also
If you go to sunsolve.sun.com and enter filesystem block size in the search
box, you will come up with some stuff. It looks like, if this is a non-RAID
device, newfs -N device_name will show you what you want.
-Original Message-
How to check the value for the OS block size on
Title: RE: 9i OCP Upgrade Exam - Again
Good
luck.
I am
scheduling mine for 3/21!
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003
12:06 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: 9i OCP Upgrade Exam - Again
There is nothing below which suggests data were selected over a database link. Check
the alert log for errors. The most likely culprit is improper tnsname resolution.
See if you can refresh the snapshot manually. Explicitly set TNS_ADMIN incase there
are rogue tnsnames.ora files. If you
Title: automatic segment-space management and pctfree
The documentation says:
(Oracle9i SQL Reference, Release 1 (9.0.1), Part Number A90125-01, ALTER TABLE)
For segments with automatic segment-space management, Oracle ignores attempts to change the PCTUSED setting. If you alter the PCTFREE
HELP
Anyone running Oracle to support HP OpenView Service Desk, would like to
know # of users supported, options and size of system?
Thanks,
Ethan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services--
Sorry, my mistake for speaking too freely. I would never use the cp
command (or it's equivalent) to backup a database when the database was
open.
I'm probably long-past OT
Oracle Magazine is still a marketing tool for both Oracle Corp. and the
magazine's contributing authors. But (attempts at humor aside) there's
nothing wrong with that. Visibility is the principal motive that authors
have for writing in the magazine. And this doesn't
April Wells
Don't forget to use discount code 'OTN20' for 20% discount. In short you
will pay $100 instead of $125. Somebody on this list suggested 'OPP30' which
gives 30% discount but it applies to people working with Oracle partner
program...
Now you can claim this discount by scheduling
Why are the failing? Is there an error message associated with the failure?
Is it an automatic refresh? How is the refresh initiated - manually,
dbms_job, cron, winat? Is there a log?
The listing below doesn't help much. It just tells you you've got some
sessions waiting for the client to tell it
Thanks, that nailed the culprit. The production DBAs (new summer inter)
had shut down the listener on the master database. No explanation --- just
one of life's little mysteries. The sound you hear is me, kicking myself
for not having checked that first, but it never crossed my mind that they
Title: RE: 9i OCP Upgrade Exam - Again
Hi all
-
I have
an interesting problem at hand - we have a request from a developer that ask to
access some tables owned by a user generated by third party app. Since I don't
have the password for this user and system/sys do not have admin option on
Ok. I assume there is nothing wrong with snapshot refreshes. How do I
verify it replicates the data completely from the master database without
missing a record?
Regards,
David
-Original Message-
Sent: Tuesday, March 04, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Thanks,
Thomas,
To prevent the situation from occuring I have the SA exclude the mount
points/directories where the database datafiles are located from the
filesystem backups. I know this made our people who manage the Tivoli
Storage Management system happy.
From: Thomas Day [EMAIL PROTECTED]
This
is how you can cleanup listener.log w/o taking the listener
down.
You can copy the listener.log to an
archive location, then do the following:
cat "/dev/null" and redirect to listener.log file. This will
zero the current file and allow other updates to the log from the listener to
Title: RE: 9i OCP Upgrade Exam - Again
grant select any table to your developer
/
Shouldn't this work?
Raj
-
Rajendra dot Jamadagni at espn dot
com Any views expressed here are
strictly personal. QOTD: Any clod can
have facts,
It's possible. I've heard of this happening before
and the recommendation was to clear out the listener.log file. There are a
couple of ways to clear out that file. One is to stop the listener and delete
it. The other is to cat /dev/null to it (i.e. cat /dev/null listener.log).
The latter
John,
A few months ago (my how time flies) if I had seen your post the next stop
would be the armory for a fully fueled flame-thrower. But times have changed
I won't flame you, even though my opinions about MicroSoft remain. Personally,
I think over the next 2 to 3 years we're in for
We'll need to set up multi-master replication between two 8.1.7 databases within the
next few months. We're not experienced with replication beyond relatively simple
snapshots and snapshot groups. Can anyone suggest good training, web, and/or printed
resources we can use to get up to speed?
Meng, Dennis wrote:
Hi all -
I have an interesting problem at hand - we have a request from a
developer that ask to access some tables owned by a user generated by
third party app. Since I don't have the password for this user and
system/sys do not have admin option on these tables, I
Barbara - Since you haven't gotten any replies, consider this:
create table test (col1 number, col2 number)
/
insert into test values (100, 2)
/
insert into test values (200, 3)
/
select a.col2 First, b.col2 Second
from test a, test b
where a.col1 = 100
and b.col1 = 200
/
Sometimes this is
Thank-you!
This should prove to be helpful.
Sam Bootsma
George Brown College
[EMAIL PROTECTED]
416-415-5000 x4933
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: March 4, 2003 2:22 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE:
I've had those days too. Send the mail to /dev/null, forward the phone to
the receptionist (not the sharp one, the one who doesn't know what's going
on) and call it a day.
brian
-Original Message-
Sent: Tuesday, March 04, 2003 1:51 PM
To: Multiple recipients of list ORACLE-L
HELP
--
Also check out the journal of Rocky Mountain Oracle User Group -
SQLUPDATE, very good content and professionally produced. Another source
is TechJournal, the journal of New York Oracle User Group, available to
members only.
- Original Message -
To: Multiple recipients of list ORACLE-L
create a procedure belonging to the third_party_app schema owner that grants access.
e.g.
create procedure third_party_app_user.grant_priv
(table_name_in in varchar2, privileges_in in varchar2, grantee_in varchar2)
as
begin
execute immediate 'grant ' || privileges_in || ' on ' ||
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC
System/6000: Version 2.3.4.0.0.
I have a database here with about 600 Oracle users defined
in dba_users. However, likely one half or more of the defined users no
longer connect to the database. I want to purge out the users that do not
Anyone? ... Anyone?
At 11:50 AM 3/4/03 -0800, you wrote:
HELP
**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
Title: RE: Question related to security
Dennis,
If you have CREATE ANY PROCEDURE and EXECUTE ANY PROCEDURE privileges, you can on 8.1 and up:
create or replace procedure
user.exe_cmd$$(p_cmd in varchar2)
as
begin
execute immediate p_cmd;
end;
execute user.exe_cmd$$('grant select on
I believe this is free with the Enterprise Edition of the database server, but I have
not been able to confirm it. There is certainly no iFS option. Am I correct here
or not? Can anyone point me to an Oracle document saying it is free.
We are looking at collaboration tools such as SharePoint
are you stupid?
signed the are you stupid responder
Scott Stefick wrote:
Anyone? ... Anyone?
At 11:50 AM 3/4/03 -0800, you wrote:
HELP
**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
Title: RE: Script to Turn Off All Oracle Auditing Options?
To create the audit trail views, run cataudit.sql.
To delete the audit trail views, run catnoaud.sql.
To find out which are the active options, use this statement:
SELECT * FROM sys.dba_priv_audit_opts;
or for audit options on a
Hi,
Yes it is free with the Enterprise Edition of the database software. Here's
a link I found:
http://www.hallogram.com/oracle/
Regards,
Sujatha
-Original Message-
Sent: Wednesday, 5 March 2003 11:20 AM
To: Multiple recipients of list ORACLE-L
I believe this is free with the
Is it true that Solaris (7, 8, 9) has a OS block size of 64K by default
I believe that you are really up against several things:
1) filesystem block size, if you are using filesystem.
This is a function of the newfs parameters
(which may/may not
In my previous message, I forgot to say:
You could always use the scorched earth approach and change everyone's
password. Then see who complains that they can't log in. :)
-Original Message-
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version
2.3.4.0.0.
I have a
I see yet another poor soul still supporting V7.3.4.5 as I am doing on V2.6
Solaris.
You should be warned that on a couple of different occasions (I'm a slow
learner)
when I launched a SQL script which changed AUDITing on hundreds of objects,
Oracle went bonkers. It appearded as though the
Isn't it ARE YOU AN IDIOT???
-Original Message-
Sent: Wednesday, 5 March 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
are you stupid?
signed the are you stupid responder
Scott Stefick wrote:
Anyone? ... Anyone?
At 11:50 AM 3/4/03 -0800, you wrote:
HELP
I passed the Intro to SQL and PL/SQL. It says on OTN I can take either that
or the SQL test for either the DBA or Developer exam. Can I use it for both
certifications?
Also, anyone who took the developer test. Im looking at the PL/SQL test. I
have an older book and it discusses PL/SQL Builder,
Dear all,
There's a line in .trc file:
"DUMP FILE SIZE IS LIMITED TO 0 BYTES".
"show parameter dump" in sqlplus output:
NAME
TYPE VALUE ---
--background_core_dump
string
partialbackground_dump_dest
string
Sorry for the very late response, but I've seen a lot of similar postings
recently. I've been lurking for some months now, when I have time for even
that, but I've never been accused of being under-opinionated, so...
In my opinion, the exam to take first is the Architecture Administration
exam.
If you are testing.. and want to try it again.. Backup CONTROL FILE at the
end.. i.e. even after the archive logs are backed up.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 09:35 AM
1) RMAN on Oracle 8.1.7
2) Create a
Dear all,
Please find below the 2 queries :
select dep_date from test_date1
where to_char(dep_date,'dd-mon-') = '12-jan-2002'
select dep_date from test_date1
where TRUNC(dep_date) = to_DATE( '12-jan-2002','dd-mon-')
The execution plan for both the queries shows a FTS on test_date1.
80 matches
Mail list logo
