delete database file on server -> sharing violation

#31

(sybrandb (AT) hccnet (DOT) nl) writes:

Quote:

Because on the other hand Oracle users aren't visiting sqlserver
Usenet groups to bash sqlserver!

Oh, D.A. Morgan is a regular, eh, contributor to
comp.databases.ms-sqlserver.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#32

On Oct 19, 2:17 pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:

Quote:

(sybra... (AT) hccnet (DOT) nl) writes:
Because on the other hand Oracle users aren't visiting sqlserver
Usenet groups to bash sqlserver!

Oh, D.A. Morgan is a regular, eh, contributor to
comp.databases.ms-sqlserver.

I see 225 posts there spread over 7 years, out of 8330 total. Not
sure how many of those were xposts between cdos and cdm. Not sure of
the accuracy of google, either.

I guess that makes him a regular.

I, on the other hand, have done about 38 over 11 years. Funny how
little has changed:
http://groups.google.com/group/comp....feb8749ce555dd

Maybe people are a little more fanatical these days.

Thanks for the apology, Pearl.

jg
--
@home.com is bogus.
"We know that about 50 percent of the population of Zacatecas is
living in the U.S. and sending home hundreds of millions of dollars
every year." - Jeffrey Davidow, president of the Institute of the
Americas in San Diego and former U.S. ambassador to Mexico.

#33

Erland Sommarskog wrote:

Quote:

(sybrandb (AT) hccnet (DOT) nl) writes:
Because on the other hand Oracle users aren't visiting sqlserver
Usenet groups to bash sqlserver!

Oh, D.A. Morgan is a regular, eh, contributor to
comp.databases.ms-sqlserver.

Actually I post there only a few times a year.

Except when people manage to confuse Oracle with a Microsoft product
and cross-post to every usenet group they can spell.

When they do they should be grateful I suggest a three-fingered
salute. As I get older I sometimes forget to use all three. <g>
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#34

"DA Morgan" <damorgan (AT) psoug (DOT) org> wrote

Quote:

Tony Rogerson wrote:
Given that this is Windows reboot the machine. Then delete the files.

Totally clueless.

I don't see you offering a solution to the original poster.

I didn't offer a solution since several others offered valid, correct
solutions.

I was pointing out the inaccuracy of your answer.

Quote:

Go ahead ... here's your chance ... if you don't like my answer then
by all means tell everyone, including the person asking for help how
to solve the problem.

I've never seen a Windows problem yet solved by cross-posting to an
irrelevant usenet group followed up with an insult.

If you have a solution ... why are you incapable of posting it?

I'm certainly capable. However, my point was to correct your mistaken
advice which would have only wasted the poster's time.

And in any case, I'm doing what should have been done long ago in this
thread and setting followups only to the comp.databases.ms-sqlserver group.
(as either of us should have done previously in this thread.)

Quote:

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

#35

<sybrandb (AT) hccnet (DOT) nl> wrote

Quote:

On Thu, 18 Oct 2007 13:25:45 -0400, "Greg D. Moore \(Strider\)"
mooregr_deleteth1s (AT) greenms (DOT) com> wrote:

No, this is clearly one of those times when that would almost certainly
NOT
work.

If it doesn't work, acknowledging the OP crossposted this to a
sqlserver AND an Oracle forum. why flame an Oracle DBA instead of
posting the correct response?

If correcting a wrong answer is considered flaming in the CDOS world then
the more's the pity.

Add in the fact that DA Morgan has a history of posting inaccurate answers
in the CDMS group, I felt it was important to correct his response before
his advice potentially cost the original poster's company downtime and
possibly money.

Quote:

Because you don't know the correct response?

Actually I know several possible routes, the DROP DATABASE is generally the
best route. Unfortunately given original posters obvious lack of knowledge
in this case, I suspect he'll need a bit more handholding to figure out
where and how to do that.

Now a question for you, as you state with Unix (which snide comments about
being blinded about), the inode will be held open until all access is
complete (which btw, I think is NOT true in at least one distro of Linux as
has been explained to me, which is just plain bad if true).

However, I would suspect simply deleting the files would cause error
messages to show up when Oracle was restarted or the system was restarted?
Most likely this would be non-fatal but as I prefer to run w/o errors, I'm
curious as to the "correct" way to remove a database on a Unix system.

Quote:

--
Sybrand Bakker
Senior Oracle DBA

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

#36

Greg D. Moore (Strider) (mooregr_deleteth1s (AT) greenms (DOT) com) writes:

Quote:

However, I would suspect simply deleting the files would cause error
messages to show up when Oracle was restarted or the system was restarted?
Most likely this would be non-fatal but as I prefer to run w/o errors, I'm
curious as to the "correct" way to remove a database on a Unix system.

You probably don't do that by deleting files. It was very long ago since
I had reason to work with a database on Unix, but when I worked with
Sybase in the first half of the nineties the strong recommendation was
to put production databases on raw partitions. This may very well have
changed since then, and it could be different for Oracle. The problem
with database files in the file system was that the DB engine had to use
synchronous operations to be sure that data was down on disk, and not
buffered in the file system. Or something like that. It was a very long
time ago.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#37

On Sat, 20 Oct 2007 00:41:04 -0400, "Greg D. Moore \(Strider\)"
<mooregr_deleteth1s (AT) greenms (DOT) com> wrote:

Quote:

However, I would suspect simply deleting the files would cause error
messages to show up when Oracle was restarted or the system was restarted?
Most likely this would be non-fatal but as I prefer to run w/o errors, I'm
curious as to the "correct" way to remove a database on a Unix system.

Dbca: delete database.

--
Sybrand Bakker
Senior Oracle DBA

#38

<sybrandb (AT) hccnet (DOT) nl> wrote

Quote:

On Sat, 20 Oct 2007 00:41:04 -0400, "Greg D. Moore \(Strider\)"
mooregr_deleteth1s (AT) greenms (DOT) com> wrote:

However, I would suspect simply deleting the files would cause error
messages to show up when Oracle was restarted or the system was restarted?
Most likely this would be non-fatal but as I prefer to run w/o errors, I'm
curious as to the "correct" way to remove a database on a Unix system.

Dbca: delete database.

Thanks. I'll keep that in mind.

Quote:

--
Sybrand Bakker
Senior Oracle DBA

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

#39

Erland Sommarskog wrote:

Quote:

Greg D. Moore (Strider) (mooregr_deleteth1s (AT) greenms (DOT) com) writes:
However, I would suspect simply deleting the files would cause error
messages to show up when Oracle was restarted or the system was restarted?
Most likely this would be non-fatal but as I prefer to run w/o errors, I'm
curious as to the "correct" way to remove a database on a Unix system.

You probably don't do that by deleting files. It was very long ago since
I had reason to work with a database on Unix, but when I worked with
Sybase in the first half of the nineties the strong recommendation was
to put production databases on raw partitions. This may very well have
changed since then, and it could be different for Oracle. The problem
with database files in the file system was that the DB engine had to use
synchronous operations to be sure that data was down on disk, and not
buffered in the file system. Or something like that. It was a very long
time ago.

RAW is still the fastest place to be ... with Oracle, with DB2,
with Informix, with Sybase, and I'd bet with SQL Server too if
anyone in the Windows world was technical enough to install and
benchmark it.

With Oracle one generally uses ASM to manage RAW as it provides
performance slightly better than most RAW device solutions plus
makes management quite easy.

It should be noted that these days *NIX solutions, including Linux,
offer asynch i/o.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)

#40

On Oct 20, 9:06 am, "Greg D. Moore \(Strider\)"
<mooregr_deletet... (AT) greenms (DOT) com> wrote:

Quote:

sybra... (AT) hccnet (DOT) nl> wrote in message

news:n73kh3tkv0mv1ojudea4nskfd1amodq4dl (AT) 4ax (DOT) com...

On Sat, 20 Oct 2007 00:41:04 -0400, "Greg D. Moore \(Strider\)"
mooregr_deletet... (AT) greenms (DOT) com> wrote:

However, I would suspect simply deleting the files would cause error
messages to show up when Oracle was restarted or the system was restarted?
Most likely this would be non-fatal but as I prefer to run w/o errors, I'm
curious as to the "correct" way to remove a database on a Unix system.

Dbca: delete database.

Thanks. I'll keep that in mind.

Is a database that you are talking about the same as the database that
Sybrand is talking about? It is pretty common for the Oracle
equivalent to an MS database to be a schema. So the correct way on a
unix system would be a "drop user" command, with other commands such
as "drop tablespace including contents and data files" for actually
removing files. But you really should know what you are doing.
Whether the datafile handles are kept open varies by configuration and
versions.

jg
--
@home.com is bogus.
http://bofh.ntk.net/StickyMags.html