ROR and RAC - Ruby/Ruby On Rails(Archived)

What is the current state of the oracle/oci8 adapters and the active-record-oracle adapter with respect to using TAF with 11g RAC?
Are there any references available or code examples that take advantage of TAF?
Thanks
Alan Davis 

Ruby-OCI8 is maintained by Kubo [kubo#jiubao.org|http://forums.oracle.com/forums/#]. You can send email to him or to the Ruby-OCI8 developer mailing list
[ruby-oci8-devel#rubyforge.org|http://forums.oracle.com/forums/#]. AFAIK, TAF is not supported yet. BTW, DRCP feature is supported in Ruby-OCI8.
- Jesse 

Hi,
I've been using Rails with Oracle 10g / XE and all my tests seem to show that TAF works out of the box.
I even got a problem where TAF (i think) wants to recover connections broken (due to innactivity timeout) by a firewall. This thing leads to another 8~10 minute timeout (which I think is related to the TCP implementation in Solaris 10)
To enable TAF you only have to configure it in your tnsnames.ora. I don't think you have to change anything in your code.
Regards,
Luis Reis

Related

Database XE as a server fopr many clients

Hello,
I would like to know if from license point of view, is it possible to use Oracle Databsae XE as a database server for remote clients (copmuters)?
My interest is to install Oracle Databse XE in small networks (lets say up to 5 workstations) instead of Oracle Database Standard Edition One.
If yes, is there any limitation for number of clients? 
Hi,
should not be of any concern.
As far as I understand it the limits are solely set on the performance of the server running XE, i.e. max 1 processor, 1GB of ram and 4GB of user data.
If you have one hundred user connecting to the db and they are happy with the performance, that should be fine.
Regards,
~Dietmar. 
See also this thread regarding the number of concurrent processes on the XE instance: ORA-12519: too many new conenctions
~Dietmar. 
Thank you for quick replay.
I am familiar with those limitations.
What I want to know is there anywhere in license agreement written that it is intended for use with local connections only or I should follow the statement: "if it is not prohibited it is allowed". 
It is allowed, it is a "server". Remote connections are acceptable. 
Actually I didn't found any place written that it is a server, if you found one please send me a link.
I know that it is technically allowed, my question whether it is allowed by license or not?
Regards 
It is - it is installed and configured as a server available to all machines on the network - out of the box, it just "is".
There is nothing stating it "is for a single machine, not to be used in the network".
It is installed and configured as a server. The listener is up and running, the machine accepts connections from any machine - in fact, we've written in another thread that for security reasons we are thinking about making it such that it is initially only available on the local machine and you would have to release it to the network (permit it to be used by others on the network) 
From the XE data sheet found at http://www.oracle.com/technology/products/database/xe/pdf/dbxe_datasheet.pdf
"Developers can easily set up their own development environment or shared database server with groups of developers." 
(wrong thread, sorry)
Message was deleted by:
Bernd Eckenfels

Email reply to Announcement: Share Your XE Experiences!

Email to otnfeedback_us#oracle.com
Hello
Are you (Am I) a satisfied Oracle Database 10g XE customer?
Well I like to say yes but unfortunately I have failed at the second hurdle to get the product to work
The problem is I cannot plug in my network cable and still have access to the database home page in Internet Explorer IE6 this is on an XP Pro SP2 single PC environment.
I have request help from the online forum but no one has responded yet.
I will post this email on that forum too. I hope that someone will be able to give
Given that, this is the first oracle database, which can be freely, distributed,
I was sort of hoping to develop systems in Visual Studio.Net employing Oracle Database in place of Access and the Access jet engine.
However, Access and the jet engine work straight out of the box and do not rely on this http server approach, which is ok if it works but in my case and I have seen other request for help with similar problems occurring it does not.
It is most likely that my PC configuration is at odds here but as yet I have found no way of determining where the problem lies and just by unplugging the network cable it will work leads me to believe it must be something very simple that need to be altered.
I am sorry not to have any thing positive to say about your product, documentation or forum help and I hate to add fuel to the Microsoft argument but unless I can solve this problem some how I cannot say any good about 10gXE.
What a pity!
Neill Rutherford 
Patience my good man, it sometimes takes us a while to get to the questions... and we don't even work for Oracle ;) (well, ok most of us don't)
~Jer 
Are you (Am I) a satisfied Oracle Database 10g XE
customer?Simply "speaking": Yes. But I'm not using Windows and the Windows Port of XE, therefore I'm unable to help you with your problems.
C. 
My suspicion ... the system has been configured using DHCP.
The database was installed without having a network connection. Therefore the database listener was instructed to listen for 'local' requests. When the network is plugged in, the systems gets an IP address and a network name. Requests then go to the network name instead of the internal name.
(Using DHCP is similar to someone who keep changing their mailing address when they wake up but does not let anyone know the new mailing address. All is OK until they go to sleep ...)
Part of this can be verified by using command line - ipconfig tells us what IP address is being used. No network, the default is to use the loopback adapter (which may not have been configured); with network, there is a system name and a different IP address.
There is some discussion around this in the Oracle docs at http://download-east.oracle.com/docs/cd/B19306_01/install.102/b14316/reqs.htm#BABBDGBI
<g> Even though this is caused by the Windows configuration, it is (of course) Oracle's fault. </g> 
I have taken note of this article and installed the loopback adaptor and removed and reinstalled the oracle database server. Although i can connect to http://127.0.0.1:8080/apex I can connect to if I use localhost instead of 127.0.0.1
so thanks for the guidance. If the current XE documentation reference the above document I DID NOT SEE IT. As to my setup I have now switched back to connecting through a wireless router (but by wire) I have the norton system works 2006 which (includes the Antivirus) installed and MsnMessenger all of which concerned me when i was loocking for the cause. Thanks once again to forbirich 
Glad it worked out.
Web based servers tend to assume you have a connection to the web. (MS Access is not a web based server. If anything, it is client-server, although it might use a non-html client in a browser.)
The XE documentation does not explicitly discuss the loop back adapter. You did not miss it.
There are a number of very consistent installation challenges that are suitable for a separate FAQ (or other medium that is more dynamic than the documentation.)

Bad performance with OS authentication

Hi
I switched my application from database authentication to OS authentication and noticed that the performance dropped significant. Just starting up my application takes with OS authentication double the time compared to database authentication. Wile starting up the application I have to open and close many connections as I have several independent software modules.
I understand that it takes long but I am very surprised that the impact is that bad. I expected that connection pooling would increase the performance a bit so that the over all impact is not too bad but whatever parameter I choose for connection pooling I see no impact at all on the performance.
Does anyone have any idea why the connection pooling does not affect the performance?
Does anyone have any idea how to boost the performance when using OS authentication?
Thanks for you help.
Ben 
Hi,
Connection pooling with OS Authentication isnt supported by ODP until 11.1.6.20, is that the version you're using?
With respect to the amount of time it takes to make a connection using OS Authentication, this probably isnt the right forum for that, but I'm not sure which one would be. The authentication is handled at the Oracle client layer below ODP.NET. I assume you see the same behavior using SQLPlus, for example.
Hope it helps,
Greg 
Thanks for that information.
I am using the version 10.2.0.
So I would have to update to version 11.1.6.20 to take advantage of connection pooling with OS Authentication.
Would there be a sigificant perofmance increase if I switch to version 11.1.6.20?
How big is the impact of connection pooling on OS Authentication on the performance side? 
The impact is quite huge on my application.
I already can see that when I just disable connection pooling on database authentication.
Thanks for that information. 
Are there any oracle redommondation about using server and cleints of different version?
I am using the Oracle Database 10.2.0 right now and updating to version 11 is not possible at the monent.
What would happen if I were using ODP.Net 11.1.6.20 on Oracle Database 10.2.0. Does anyone have any experiance or information about that? 
I posted this as a new thread.
Using clients with different version than the database.

Universal Connection Pool (UCP)

Hi! I would like to know if UCP can be used on 10g database or just in 11g. There is some confusion about the version of driver or database where UCP can be used. Thanks a lot
We tried using UCP with 10g but had some really odd (and intermittent) problems with data not committing until a connection was reused. We reverted back to OracleDataSource as we didn't have time to investigate.
We also found that failover in a RAC didn't work reliably (but did with OracleDataSource)
I can't say these issues were because of 10g, or our environment, or just general bugs with UCP.
Regards,
Tom

Lost DB connection when internet connection drops or fails.

Hi All.
I have XE installed on my laptop and use serveral tools to access the database: Developer 6i, TOAD, Developer 10g.
I have this weird situation:
Whenever my internet connection drops, i also lose connections from 6i, TOAD, etc. although the database remains up.
Why would this happen?
How can i prevent my DB connections from falling whenever internet drops?. These are not related right?
Best regards, Luis ...! 
Boy. that IS weird.
Perhaps it's related to the fact that XE access is handled by the listener (unless you use the implied bequeath adapter) and the listener listens on the network and when the network fails the operating system sends a 'network has been reset' message through the network subsystem.
Dunno. Might be related. 
Yep, but i wonder if there's a way to avoid this situation... This is also happening on production enviroment..
Hope someone has an idea.
Is there a hearbeat or something ...? Some network parameter maybe ...? 
Look at the listener logs.
This aspect of XE is the same as the bigger database cousins. You could get more opinions in the "Database - General" forum.

Categories

Resources