Question

Laserfiche with Oracle

Laserfiche

Updated September 16, 2016

asked on May 19, 2014

Hi all,

We have an existing Laserfiche customer that will be upgrading from Avante to Rio (as well as from SQL to Oracle), and I’ve just got a couple of questions I was hoping you could answer:

Will Laserfiche work with either the Standard or Enterprise versions of Oracle?
Will Laserfiche work with an Oracle installation running on Unix/Linux?

Many thanks,

Martin

0 0

Answer

SELECTED ANSWER

replied on May 19, 2014

According to the Laserfiche Server Preinstallation Checklist it does not specify, so either one should be sufficient.

1 0

Replies

replied on May 21, 2014

I can confirm that Laserfiche can work with Oracle installations running on Linux, we've had a test environment that does that. I'm not aware of any edition-specific requirements either.

0 0

replied on July 9, 2014 • Show version history

hi Justin

is it supporting Oracle 10g

Database version : 10.2.0.4

Operating System : Unix-AIX

Operating System version : 5300-06

Database Block Size : 4k

0 0

View 1 previous reply

replied on July 12, 2014

hello Miruna

my client Oracle Team would like to know if Laserfiche is Compatible with Oracle 9.2.0.8+ then why laserfiche is not supporting Oracle 10.2.0.4 ?

0 0

replied on September 26, 2014

Sorry, Mazahir, I didn't see this until today. 10.2.0.5 was the lowest version in the 10.2 release series still supported by Oracle: http://www.orafaq.com/wiki/Oracle_10g

1 0

replied on February 18, 2015

Just to add my grain of salt... We've been running LF on Oracle from the beginning, something like 5 years ago. We do have a few MSSQL databases here but they are not really managed. They just live. I'm a senior Oracle DBA and wanted LF to use Oracle so that I could troubleshoot problems and tune queries if need be. Our ERP is on Oracle so we had the licenses already.

I effectively had to tune a few things on a couple of occasions, and some of that work made its way to the latest versions of the product. I did not find other bottlenecks after migrating from 8.3 to 9.0 and that's a good thing.

Overall, the product is very very stable and we don't have performance problems.

We have in excess of 3 million documents in LF, plus many workflows.

1 0

replied on September 26, 2014

I have a question along similar lines so figured I'll ask in this thread instead of a new post:

Does the Laserfiche Rio Oracle license allow a customer to register repositories with a mix of both Oracle and SQL databases? A customer is looking to transition from Oracle to SQL and I would like to know if they can use the same Laserfiche server to host repositories with both kinds of databases.

Thanks!

0 0

replied on October 1, 2014

Hi Travis,

The Laserfiche licensing and backend structures for Oracle and SQL are different, so you won't be able to use a Rio Oracle license with a mix of Oracle- and SQL-backed repositories.

What time frame is the customer looking at for their transition from Oracle to SQL databases? Your Laserfiche Regional Manager can provide you with a temporary Laserfiche Rio SQL license for use during this migration. This would allow you to have both your Oracle and SQL servers set up for a short period of time, with repositories on each, as you make the migration from one system to the other.

0 0

replied on October 16, 2014 • Show version history

Hi Kelsey, thanks for the response. I had assumed this as well, however upon reviewing their feature summary in the License Manager, it indicates that both SQL and Oracle are supported. I've attached a screenshot for you to look at. Would this not indicate they have capabilities to have both SQL and Oracle-backed repositories?

As for a timeframe, the customer is looking at migrating their repositories over a period of several weeks, and then performing extensive testing on all of them. Several of the repositories are quite large with a multitude of workflows to test through on each, and they want to be certain the conversion is 100% successful before pulling out the rug, therefore it may involve two-three months of full conversion tasks and testing.

Oracle License Summary with SQL Listed.png (9.11 KB)

| Download

1 0

replied on October 17, 2014

Travis,

I would love to hear how this goes for your customer and your approach. Its good to hear others are making this migration so we can learn from them. I hope to have this on our roadmap in the next year or so.

0 0

replied on May 19, 2014

Martin,

May I ask why your customer wants to move from SQL to Oracle?

I'm one of the very very few Oracle customers and I'm working on a plan to move from Oracle to SQL.

I'm curious why they would want to make this move.

0 1

View 1 previous reply

replied on May 21, 2014

Sure thing Kenny.

The customer is looking at moving from a one-site Avante installation to a multi-site Rio setup. Their current Avante system is running on the free version of SQL, SQL Express, but all the other offices are already using Oracle (for other things) and as such have already purchased licenses for it.

SQLExpress isn't appropriate for the number of users at these new sites, so to avoid having to purchase full SQL they plan to use the Oracle they own already.

It short, it's a cost saving exercise. I agree that Oracle LF customers are few an far between, of the ~75 Laserfiche systems we work with this will be the first I've seen that's not using SQL.

0 0

replied on May 21, 2014

We are trying to move because there is a price premium using Laserfiche with Oracle.

To the best of my knowledge, Oracle installations make up far less than 1% of the total Laserfiche install base. This means that no matter how long you wait to upgrade, you are almost always near the front of the line. I have not experienced an upgrade where I have not run into bugs specific to Oracle installations in the last 6 years and most of the solutions were provided by our senior Oracle DBA (7.2.1 to 8.0.1 to 8.1.1 to 8.3 to 8.3.2 to 9.1.1). (Like this issue that was fixed in January for SQL users, but LF didn't provide a fix for Oracle until I asked for it recently.)

I would suggest that you carefully consider the cost (premium on the LF purchase), but also the cost of using an environment that is not the same as 99%+ of Laserfiche users. There is power in numbers. The Laserfiche team has much more experience troubleshooting, developing, and performance tuning with SQL than Oracle.

I have noticed a remarkable improvement in these areas for Oracle in the last 2 years at Laserfiche. Issues are resolved quicker and their database-focused sessions at the Empower conferences now contain a few more suggestions compared to 3 years ago where the presenter(s) told me they had no recommendations for Oracle systems. (I was also the only person with an Oracle system in the entire class of 100+.)

These are the reasons we are looking to switch to SQL from Oracle.

I hope this helps.

1 0

replied on September 16, 2016

Hi Kenny,

We are also using oracle database. We have an almost daily problem with LF Rio 10 overloading the oracle (Oracle 11gR2 (11.2.0.4.5) 64bit Enterprise Edition on 64bit Oracle Linux) database with open sessions.

9/16/2016 11:20:28 AMCustom QueryORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Is an error seen in workflow, while client users may get General Database Error or Unknown Error, or Cannot Connect to LF server or just get logged out.

LF server will show crash of lfs.exe and restart itself most of the time.

Have you experienced this? LF support told me to just allow the database unlimited sessions but my DBA can't do that because of other databases on the oracle box needing resources as well.

Any oracle database tuning tips you found that helped?

0 0

replied on September 16, 2016

I will consult with our DBA about tuning tips.

We are on United, not Rio, which might change how sessions work. Also, our Laserfiche system has its own dedicated Oracle server (admittedly overkill for our repository).

If I hear anything useful, I'll let you know, but I don't think we have tried limited the number of sessions from the Oracle side.

0 0

You are not allowed to follow up in this post.

Question

Question

Laserfiche with Oracle

Answer

Replies

Sign in to reply to this post.