[SLUG] Oracle 9i database and samba

2008-02-28 Thread Simon Wong
Hi all!

Can anyone confirm whether Oracle 9i running under Windows will work if
it's DB files are stored on a samba share?

I have to try and run Mincom's Minescape under Windows but want the data
and DB shared via Samba.

TIAs

-- 
Simon Wong [EMAIL PROTECTED]

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Adrian Chadd
On Thu, Feb 28, 2008, Simon Wong wrote:
 Hi all!
 
 Can anyone confirm whether Oracle 9i running under Windows will work if
 it's DB files are stored on a samba share?
 
 I have to try and run Mincom's Minescape under Windows but want the data
 and DB shared via Samba.

.. why do you think this would be a good idea?



Adrian


-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Asus Eee 4G 7 Micro Laptop

2008-02-28 Thread Sridhar Dhanapalan
On Wed, 27 Feb 2008, Martin Visser [EMAIL PROTECTED] wrote:
 On Fri, Feb 22, 2008 at 9:43 PM, Amos Shapira [EMAIL PROTECTED]

 wrote:
  On Fri, Feb 22, 2008 at 7:04 AM, Martin Visser [EMAIL PROTECTED]
 
  wrote:
   to fill. I'd be pretty confident that they other main vendors will be
   quickly trying to come up with competition. (And no, even though I
 
  And here they come marching: http://www.everex.com/

 And right on cue, here comes my employer's eeePC killer -
 http://www.engadget.com/2008/02/19/hps-umpc-2133-revealed/

 You have to wonder though whether in 10 years we have really come that far
 - http://www.hpmuseum.net/display_item.php?hw=233 . The sub-notebook
 category all but dissappeared and now it seems to be back with a vengeance.

If it hasn't been mentioned yet, the General Talk at tomorrow's SLUG meeting 
will be all about these kinds of devices :)

http://www.slug.org.au/node/90


-- 
Need to fork out $$$ for the next software upgrade? Break the cycle!
http://www.linux.org.au/linux


signature.asc
Description: This is a digitally signed message part.
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] Open source Requirements Tools

2008-02-28 Thread Sridhar Dhanapalan
On Thu, 28 Feb 2008, Marghanita da Cruz [EMAIL PROTECTED] wrote:
 While Wikis and Mailing lists seem to be the tools that power open source
 software development - has anyone come across more purpose specific tools?

Not all Wikis are built alike :)

We've been delving more into Xwiki as of late. It's an enterprise-focused wiki 
platform with strong scripting capabilities for building functions and 
providing integration with other tools.


-- 
We don't have the user-centricity. Until we understand context, which is way 
beyond presence - presence is the most trivial notion of context.
- Bill Gates, July 2002


signature.asc
Description: This is a digitally signed message part.
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] ADSL modem recommendations (with bridging)

2008-02-28 Thread Erik de Castro Lopo
Hi all,

I've been banging my head against my adsl modem and I wondering if it
might not just be easier/cheaper to replace it with something better.

Can anybody recommend an ADSL modem that does up to an including
ADSL2+, is Linux friendly and easy to set up in bridging or half
bridging mode? It would also be nice if the adminstrative functions
were still accessible when it is in bridging mode.

Cheers,
Erik
-- 
-
Erik de Castro Lopo
-
Fifty years of programming language research, and we
end up with C++ ???   --Richard A. O'Keefe
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] ADSL modem recommendations (with bridging)

2008-02-28 Thread Tony Lissner
On 28/02/2008, Erik de Castro Lopo [EMAIL PROTECTED] wrote:
  I've been banging my head against my adsl modem and I wondering if it
  might not just be easier/cheaper to replace it with something better.
  Can anybody recommend an ADSL modem that does up to an including
  ADSL2+, is Linux friendly and easy to set up in bridging or half
  bridging mode? It would also be nice if the adminstrative functions
  were still accessible when it is in bridging mode.

I've been using a Thompson SpeedTouch 536 in straight bridge
mode in front of a WRT54GL (OpenWrt) with the WRT handling the pppoe dialing
but your modem should handle it in bridge mode OK. When you switch to bridge
mode you usually lose administrative access to the modem. I haven't played
with half bridging so not much help there. This is with Bigpong and it needs
the pppoe username and password.
You could try seeing if it works in gateway? mode before switching to bridge?
With this modem in gateway mode it has a fairly good CLI.

Tony
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Open source Requirements Tools

2008-02-28 Thread Marghanita da Cruz

Sridhar Dhanapalan wrote:

On Thu, 28 Feb 2008, Marghanita da Cruz [EMAIL PROTECTED] wrote:

While Wikis and Mailing lists seem to be the tools that power open source
software development - has anyone come across more purpose specific tools?


Not all Wikis are built alike :)

We've been delving more into Xwiki as of late. It's an enterprise-focused wiki 
platform with strong scripting capabilities for building functions and 
providing integration with other tools.




My wish list was a graphical representation of requirements, tracking,
prioritisation and scheduling, costing and a web accessible (not requiring an
additional app to view)and slides for presentations.

Something that was familiar to business and developers. The problem with many of
the tools is everyone seems to need to be an expert in the tool as well as
analysing business requirements and translating into ICT solutions.

The open source attraction was for refinement.

Has anyone had any experience of

Open Source Requirements Management Tool 1.5 (Default)

http://freshmeat.net/projects/osrmt/?branch_id=64576release_id=250323

Marghanita
--
Marghanita da Cruz
http://www.ramin.com.au
Phone: (+61)0414 869202


--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Asus Eee 4G 7 Micro Laptop

2008-02-28 Thread Marghanita da Cruz

snip
If it hasn't been mentioned yet, the General Talk at tomorrow's SLUG meeting 
will be all about these kinds of devices :)


http://www.slug.org.au/node/90



Has anyone has experience with the video conferencing on the EEEPC? There is 
someone (with a EEEPC) who would like to attend remotely.


Marghanita
--
Marghanita da Cruz
http://www.ramin.com.au
Phone: (+61)0414 869202

--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Open source Requirements Tools

2008-02-28 Thread David Peterson


On Fri, 2008-02-29 at 08:44 +1100, Marghanita da Cruz wrote:

 My wish list was a graphical representation of requirements, tracking,
 prioritisation and scheduling, costing and a web accessible (not requiring an
 additional app to view)and slides for presentations.
 

Hi Marghanita,

It's not open source, but have you checked out Mingle by ThoughtWorks
studios. It's an agile software design tool and would seem to support
some of the requirements you identify. In conjunction with open-source
tools like a wiki and Trac (or a trac-like tool) it might get you a long
way.

http://studios.thoughtworks.com/mingle-project-intelligence

It's written in Ruby on Rails (runs under JRuby) and is free (cost) to
use for small development teams. HTH.

Dave


-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Simon Wong
On Thu, 2008-02-28 at 18:04 +0900, Adrian Chadd wrote:
  Can anyone confirm whether Oracle 9i running under Windows will work if
  it's DB files are stored on a samba share?
  
  I have to try and run Mincom's Minescape under Windows but want the data
  and DB shared via Samba.
 
 .. why do you think this would be a good idea?

because the instance of Windows will be running under VMware server (or
Workstation) and I like to keep the data outside the VM where it can
also be shared with other instances of the app.

What are you thinking?


-- 
Simon Wong [EMAIL PROTECTED]

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] ADSL modem recommendations (with bridging)

2008-02-28 Thread Peter Hardy
Hey hey.

On Thu, 2008-02-28 at 23:11 +1100, Erik de Castro Lopo wrote:
 Can anybody recommend an ADSL modem that does up to an including
 ADSL2+, is Linux friendly and easy to set up in bridging or half
 bridging mode? It would also be nice if the adminstrative functions
 were still accessible when it is in bridging mode.

I have a D-Link DSL-502T, which is a couple of years old by now.

It had a lot of problems with Linux clients when it was running as a
gateway - the Linux resolver just didn't play nicely with its name
service. But I'm using it in full bridge mode now in front of a WRT-54G
and have no complaints.

Don't think they do half-bridging. But flipping it into full bridging
mode is a snap, and the internal interface keeps the address that was
assigned to it, so the admin interface is still accessible.

-- 
Pete

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Joel Heenan
On Fri, Feb 29, 2008 at 10:08 AM, Simon Wong [EMAIL PROTECTED] wrote:

 On Thu, 2008-02-28 at 18:04 +0900, Adrian Chadd wrote:
   Can anyone confirm whether Oracle 9i running under Windows will work
 if
   it's DB files are stored on a samba share?
  
   I have to try and run Mincom's Minescape under Windows but want the
 data
   and DB shared via Samba.
 
  .. why do you think this would be a good idea?

 because the instance of Windows will be running under VMware server (or
 Workstation) and I like to keep the data outside the VM where it can
 also be shared with other instances of the app.

 What are you thinking?


Simon,

Why don't you run the database on a big fat database server then have all
the applications connect to it via oracle listeners through TCP/IP. That
would be the standard solution to this problem.

This solution is strange because

  - you may hit issues because not all FS locking commands will be supported
  - running multiple database instances connecting to the same DB files is
normally done in an Oracle RAC configuration. You don't run Oracle on the
app servers you run it on database servers and use a shared filesystem like
ASM or OCFS2 normally connected to the DB files over a SAN. Network
filesystems are not normally used for database files.

Is there a good reason you need more than one oracle instance?

Joel
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Jeremy Portzer

Joel Heenan wrote:

Network
filesystems are not normally used for database files.



I work for an ASP that has all of its Oracle databases (hundreds of 
them) mounted via NFS.  It works just fine.  The database servers are 
running Red Hat Enterprise Linux 4 and 5, and the NFS mount points are 
NetApp filers.


Now, this is a bit tangential to the original question, which was about 
Windows and samba.  SMB/CIFS is not at all the same thing as NFS.  But 
it's worth pointing out that Oracle on network filesystems is perfectly 
doable - and NFS is fully supported by Oracle, given certain conditions. 
 An important way that we meet those conditions is that all NFS traffic 
for Oracle is in a physically separate network from all other traffic, 
and is managed very carefully to avoid congestion.


--Jeremy
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Open source Requirements Tools

2008-02-28 Thread Zhasper
If we're going to plug This suggestion completely contradicts what
you said you were looking for,  but... solutions, SLUG's hosts
Atlassian have some products that seem to fit the bill - Jira
(http://www.atlassian.com/software/jira/) probably being the best
match.

It's written in a real language, Java, and is also free for
open-source projects and community groups. The licence gives you
access to the source and the right to make your own modifications
forever (and when the licence expires, it just means you don't get
access to new source any more - your existing install still works, and
you still have the right to make your own modifications) (at least, I
think it does, check before you hand over cash though).

(obdisc: my partner works for Atlassian. I was an Atlassian fanboy
even before he started working there)

On Fri, Feb 29, 2008 at 9:17 AM, David Peterson [EMAIL PROTECTED] wrote:


  On Fri, 2008-02-29 at 08:44 +1100, Marghanita da Cruz wrote:

   My wish list was a graphical representation of requirements, tracking,
   prioritisation and scheduling, costing and a web accessible (not requiring 
 an
   additional app to view)and slides for presentations.
  

  Hi Marghanita,

  It's not open source, but have you checked out Mingle by ThoughtWorks
  studios. It's an agile software design tool and would seem to support
  some of the requirements you identify. In conjunction with open-source
  tools like a wiki and Trac (or a trac-like tool) it might get you a long
  way.

  http://studios.thoughtworks.com/mingle-project-intelligence

  It's written in Ruby on Rails (runs under JRuby) and is free (cost) to
  use for small development teams. HTH.

  Dave




  --
  SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
  Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html





-- 
There is nothing more worthy of contempt than a man who quotes himself
- Zhasper, 2004
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Open source Requirements Tools

2008-02-28 Thread David Peterson


Zhasper - I think your criticism is a bit harsh! I was just trying to
provide a bit of help to someone looking to solve a problem. Seriously,
the list can verge on the antisocial at times. I wonder why there are so
many lurkers and so few contributors ... hmm.

I am familiar with JIRA, it's a well-written product. That said, I'm not
sure that the open source project licence of JIRA gives you access to
the JIRA source code. I'd query that point, anyway.

The poster was seeking a solution to managing software and business
requirements in a simple tool that is accessible to both technical and
non-technical people. Mingle provides such a solution. It's not OSS but
it is free to use for small groups - so it's quite possible that it
might fit the bill. Lots of people had previously suggested Wiki-based
system (and Trac) and I was just seeking to offer another possibility.

Oh, and as for your real language sleight, we work daily in both Java
(JEE) and Ruby and I can assure you that both are real languages.


Dave



On Fri, 2008-02-29 at 11:03 +1100, Zhasper wrote:
 If we're going to plug This suggestion completely contradicts what
 you said you were looking for,  but... solutions, SLUG's hosts
 Atlassian have some products that seem to fit the bill - Jira
 (http://www.atlassian.com/software/jira/) probably being the best
 match.
 
 It's written in a real language, Java, and is also free for
 open-source projects and community groups. The licence gives you
 access to the source and the right to make your own modifications
 forever (and when the licence expires, it just means you don't get
 access to new source any more - your existing install still works, and
 you still have the right to make your own modifications) (at least, I
 think it does, check before you hand over cash though).
 
 (obdisc: my partner works for Atlassian. I was an Atlassian fanboy
 even before he started working there)
 
 On Fri, Feb 29, 2008 at 9:17 AM, David Peterson [EMAIL PROTECTED] wrote:
 
 
   On Fri, 2008-02-29 at 08:44 +1100, Marghanita da Cruz wrote:
 
My wish list was a graphical representation of requirements, tracking,
prioritisation and scheduling, costing and a web accessible (not 
  requiring an
additional app to view)and slides for presentations.
   
 
   Hi Marghanita,
 
   It's not open source, but have you checked out Mingle by ThoughtWorks
   studios. It's an agile software design tool and would seem to support
   some of the requirements you identify. In conjunction with open-source
   tools like a wiki and Trac (or a trac-like tool) it might get you a long
   way.
 
   http://studios.thoughtworks.com/mingle-project-intelligence
 
   It's written in Ruby on Rails (runs under JRuby) and is free (cost) to
   use for small development teams. HTH.
 
   Dave
 
 
 
 
   --
   SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
   Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
 
 
 


-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


[SLUG] Debian on AMD64

2008-02-28 Thread Heracles

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I have the 64 bit version of Debian etch running on an AMD system. All
was well until recently when it stopped doing updates with the error:
cannot connect to host 4001: 127.0.0.1 connection refused (error 111 ...)
(Note that this as close as I can remember the error message as I
rebooted into ubuntu 32 bit before writing this)
It still connects to the internet and is happy to browse but if I ask it
to check for updates it gives this error and apt-get update also gives
this error on the repository I use.
Although now, since moving from SuSE, I usually use Ubuntu I am not
familiar with Debian. Is this a common error and is it easily fixed? Any
clues appreciated.

Heracles
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHx14wybPcBAs9CE8RAk1ZAKC4MOBPdLClrAmYsX5yxw4VJ3FjrgCfaP0L
EkY26RX/8Ui3KtbG6h0Tl00=
=X1eq
-END PGP SIGNATURE-
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Adrian Chadd
On Fri, Feb 29, 2008, Simon Wong wrote:

  .. why do you think this would be a good idea?
 
 because the instance of Windows will be running under VMware server (or
 Workstation) and I like to keep the data outside the VM where it can
 also be shared with other instances of the app.
 
 What are you thinking?

That I'd be asking Oracle and your application vendor whether your proposed
setup is fully supported.

Backending databases onto random network attached storage is a very bad idea
unless you Know What You Are Doing; and if you're on here asking then you
probably don't fall into that category.

The other poster who runs Oracle off a netapp filer is surprising to me, as I've
had no end of issues with databases on network attached storage, but -my- 
experiences
haven't been with Oracle on Netapp NFS, just MySQL on Linux NFS. In any case, 
knowing
what I know about the wildly different flavours of NFS implementations, I'd not 
be
putting a critical SQL DB on it (or heck, even hash tables with shared 
writers!) unless
my vendor told me it was ok.

In short: Ask your vendors. Thats what you're paying them for. :)



Adrian

-- 
- Xenion - http://www.xenion.com.au/ - VPS Hosting - Commercial Squid Support -
- $25/pm entry-level VPSes w/ capped bandwidth charges available in WA -
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Debian on AMD64

2008-02-28 Thread Kristian Erik Hermansen
On Thu, Feb 28, 2008 at 5:21 PM, Heracles [EMAIL PROTECTED] wrote:
  I have the 64 bit version of Debian etch running on an AMD system. All
  was well until recently when it stopped doing updates with the error:
  cannot connect to host 4001: 127.0.0.1 connection refused (error 111 ...)
  (Note that this as close as I can remember the error message as I
  rebooted into ubuntu 32 bit before writing this)
  It still connects to the internet and is happy to browse but if I ask it
  to check for updates it gives this error and apt-get update also gives
  this error on the repository I use.
  Although now, since moving from SuSE, I usually use Ubuntu I am not
  familiar with Debian. Is this a common error and is it easily fixed? Any
  clues appreciated.

I have run both Debian and Ubuntu on AMD64 for about 5 years now.  I
have never seen that issue.  It looks like trying to connect to a host
'4001', which does not look right.  Check your apt sources...
-- 
Kristian Erik Hermansen
--
It has been just so in all my inventions. The first step is an
intuition--and comes with a burst, then difficulties arise. This thing
gives out and then that--'Bugs'--as such little faults and
difficulties are called--show themselves and months of anxious
watching, study and labor are requisite before commercial success--or
failure--is certainly reached -- Thomas Edison in a letter to
Theodore Puskas on November 18, 1878
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


[SLUG] Using Gtkmorph to morph (rather than warp) images

2008-02-28 Thread elliott-brennan

Hi all,

I've had a look at the man pages and the site AND 
the help section, as well as a general google'ing 
and am having trouble with finding useful help on 
creating a morph image using Gtkmorph.


Has anyone on the list any experience with this 
app and, if so, can you help with an 'idiots' 
guide or some clues??? :)


Regards,

Patrick

--
Registered GNU/Linux User 368634
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Amos Shapira
On Fri, Feb 29, 2008 at 10:08 AM, Simon Wong [EMAIL PROTECTED] wrote:

 On Thu, 2008-02-28 at 18:04 +0900, Adrian Chadd wrote:
   Can anyone confirm whether Oracle 9i running under Windows will work
 if
   it's DB files are stored on a samba share?
  
   I have to try and run Mincom's Minescape under Windows but want the
 data
   and DB shared via Samba.
 
  .. why do you think this would be a good idea?

 because the instance of Windows will be running under VMware server (or
 Workstation) and I like to keep the data outside the VM where it can
 also be shared with other instances of the app.

 What are you thinking?


Do you plan to have access to that database in parallel to having that
VMware WIndows running?

Because if so then Joel Heenan's solution is the right one - run Orcale 9i
on the host and have it accessed from the Windows under VMware.

If you don't need parallel access and don't want to run Oracle on a separate
host then maybe another solution would be to import an LVM (or a plain file)
into the VM guest as a separate virtual disk.

Generally, the advise I remember (at least for Postgres) is that running
databases on top of network file systems is a bad idea at least for
performance, but I never tried this personally.

--Amos
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Debian on AMD64

2008-02-28 Thread Martin Visser
It sounds like you have a broken anon-proxy installation (nothing to do with
AMD64)

http://ubuntuforums.org/archive/index.php/t-182018.html refers to the same
issue.

On Fri, Feb 29, 2008 at 12:21 PM, Heracles [EMAIL PROTECTED] wrote:

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 I have the 64 bit version of Debian etch running on an AMD system. All
 was well until recently when it stopped doing updates with the error:
 cannot connect to host 4001: 127.0.0.1 connection refused (error 111 ...)
 (Note that this as close as I can remember the error message as I
 rebooted into ubuntu 32 bit before writing this)
 It still connects to the internet and is happy to browse but if I ask it
 to check for updates it gives this error and apt-get update also gives
 this error on the repository I use.
 Although now, since moving from SuSE, I usually use Ubuntu I am not
 familiar with Debian. Is this a common error and is it easily fixed? Any
 clues appreciated.

 Heracles
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.4.6 (GNU/Linux)
 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

 iD8DBQFHx14wybPcBAs9CE8RAk1ZAKC4MOBPdLClrAmYsX5yxw4VJ3FjrgCfaP0L
 EkY26RX/8Ui3KtbG6h0Tl00=
 =X1eq
 -END PGP SIGNATURE-
 --
 SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
 Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html




-- 
Regards, Martin

Martin Visser
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Simon Wong
On Fri, 2008-02-29 at 11:18 +0900, Adrian Chadd wrote:
 That I'd be asking Oracle and your application vendor whether your proposed
 setup is fully supported.

I don't think it is well supported!

 Backending databases onto random network attached storage is a very bad idea

I agree but this is shared on the same machine.  I think that is a lt
more reliable apart from other FS issues.

 unless you Know What You Are Doing; and if you're on here asking then you
 probably don't fall into that category.

Not it in this instance! ;-)

 The other poster who runs Oracle off a netapp filer is surprising to me, as 
 I've
 had no end of issues with databases on network attached storage, but -my- 
 experiences
 haven't been with Oracle on Netapp NFS, just MySQL on Linux NFS. In any case, 
 knowing
 what I know about the wildly different flavours of NFS implementations, I'd 
 not be
 putting a critical SQL DB on it (or heck, even hash tables with shared 
 writers!) unless
 my vendor told me it was ok.

OK

 In short: Ask your vendors. Thats what you're paying them for. :)

I will and will post back here if I get it running too!


-- 
Simon Wong [EMAIL PROTECTED]

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Simon Wong
On Fri, 2008-02-29 at 10:38 +1100, Joel Heenan wrote:
 Why don't you run the database on a big fat database server then have
 all the applications connect to it via oracle listeners through
 TCP/IP. That would be the standard solution to this problem.

hmmm, the more I look into this application (Mincom Minescape) it seems
that may in fact be what it does, it has a Design File Server.

 This solution is strange because 
 
   - you may hit issues because not all FS locking commands will be
 supported
   - running multiple database instances connecting to the same DB
 files is normally done in an Oracle RAC configuration. You don't run
 Oracle on the app servers you run it on database servers and use a
 shared filesystem like ASM or OCFS2 normally connected to the DB files
 over a SAN. Network filesystems are not normally used for database
 files. 

I am sure you are correct, I don't have any experience with Oracle or
large, distributed DB installations.

 Is there a good reason you need more than one oracle instance?

No!

I think I phrase the question incorrectly to start with.  If I just want
one instance of the Oracle DB (the Design File Server) can I run it
installed in a VM and have it's DB files stored on Samba shared to it
from the host OS?

-- 
Simon Wong [EMAIL PROTECTED]

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Simon Wong
On Fri, 2008-02-29 at 14:40 +1100, Amos Shapira wrote:
 Do you plan to have access to that database in parallel to having that
 VMware WIndows running?

There will be multiple VMs running on the same machine.

 Because if so then Joel Heenan's solution is the right one - run Orcale 9i
 on the host and have it accessed from the Windows under VMware.

I think the solution will be one Windows VM running Oracle (possible
with the DB files on Samba) and the other VMs accessing that Oracle
instance.
 Generally, the advise I remember (at least for Postgres) is that running
 databases on top of network file systems is a bad idea at least for
 performance, but I never tried this personally.

Understandable but these DB files are on the same physical machine,
different OS (Linux VMware host).

Thanks.


-- 
Simon Wong [EMAIL PROTECTED]

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] Oracle 9i database and samba

2008-02-28 Thread Adrian Chadd
 I think I phrase the question incorrectly to start with.  If I just want
 one instance of the Oracle DB (the Design File Server) can I run it
 installed in a VM and have it's DB files stored on Samba shared to it
 from the host OS?

Again, why are you asking here versus the two vendors in question?

I strongly suggest you just ask your vendors and get them to sign off on it.
I sincerely doubt anyone here is qualified to tell you yes or no;
and Minescape looks like a serious piece of mine design and operations planning
software.



Adrian

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html