Home » Server Options » RAC & Failsafe » testing RAC (11g)
testing RAC [message #455996] Fri, 14 May 2010 00:35 Go to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
We are testing RAC implemented by a vendor on oracle 11gr1. I observe following, kindly tell me whether it should be like this

1. I update a column of a table on one node and terminate the session without commiting. I checked it was applied. (My understanding is that when we close s session without commit, it rollback )
2. Same happens in insert case.

3. I issue a time consuming update/Insert , and before it ends it close session. (Nothing was applied)

Can you please help, what should i do for further testing.

We are using
Oracle Enterprise Linux 5.4
DRBD 0.8.3 (Dual Primary Mode)
OCFS2 1.4.4
Oracle Clusterware 11.1
Oracle RDBMS 11gr1
Re: testing RAC [message #456008 is a reply to message #455996] Fri, 14 May 2010 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what should i do for further testing.

What is the purpose of your tests?
If it is to verify that Oracle satisfies the transactional rules, it is just a waste of time, Oracle guarantees it.

Regards
Michel
Re: testing RAC [message #456018 is a reply to message #456008] Fri, 14 May 2010 02:03 Go to previous messageGo to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
Our purpose is check, weather deployment is correct or some thing remain.......
Re: testing RAC [message #456025 is a reply to message #456018] Fri, 14 May 2010 02:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
weather deployment is correct

Against which criteria?

Regards
Michel
Re: testing RAC [message #456050 is a reply to message #456025] Fri, 14 May 2010 05:13 Go to previous messageGo to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
what is your opinion about three points, regarding which i enquire.

If you can tell me what should be the criteria of testing.
Re: testing RAC [message #456084 is a reply to message #455996] Fri, 14 May 2010 08:57 Go to previous messageGo to next message
denissun
Messages: 3
Registered: July 2009
Junior Member
1,2 maybe depend on your client. With SQL* Plus, if you type "exit" to terminate, Oracle issues "commit"; if you close the terminal window using your mouse, It roll back.
( Sorry I have no TOAD or OEM or any other GUI tool with me, and did not get time to test them).

For 3, I believe no matter what, it should roll back.

This test has nothing to do with RAC Smile

Hope this help.
Re: testing RAC [message #456873 is a reply to message #456084] Wed, 19 May 2010 22:56 Go to previous messageGo to next message
raghunandanas
Messages: 1
Registered: December 2009
Location: bangalore
Junior Member
there is concept of autocommit. It is possible to configure session to commit automatically on exit
Re: testing RAC [message #456875 is a reply to message #456873] Wed, 19 May 2010 23:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle does not know autocommit but client can implement it if it wants.
This means that if client is killed or aborts then transaction is rolled back.

Regards
Michel
Re: testing RAC [message #456946 is a reply to message #456875] Thu, 20 May 2010 07:20 Go to previous messageGo to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
When i login as "sqlplus / as sysdba"
then whatever i update or insert and kill session, without commit it behave exactly what i mentioned at 1 & 2.

But when i login as "sqlplus taq/pwd@node" and do some update or insert and kill session, without commit it rollback.

In both cases autocommit was off. I could not understand this difference.
Re: testing RAC [message #456957 is a reply to message #456946] Thu, 20 May 2010 07:51 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.

Previous Topic: oracle 10.2.0.4 upgrade
Next Topic: INSTALLING RAC (merged)
Goto Forum:
  


Current Time: Thu Mar 28 05:51:58 CDT 2024