Home » Server Options » RAC & Failsafe » Query
Query [message #644460] Sat, 07 November 2015 01:39 Go to next message
ivan01
Messages: 7
Registered: November 2015
Location: Australia
Junior Member
How to identify read only access to the database? At the end, I would like to separate those application module with SELECT privilege to run on a newly created read only service name.

Report message to a moderator

Re: Query [message #644461 is a reply to message #644460] Sat, 07 November 2015 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

1/ What do you mean by a read-only service name?
2/ Without tracing all sessions or auditing all statements you can't know which modules are read-only and which ones are read-write.

Report message to a moderator

Re: Query [message #644462 is a reply to message #644461] Sat, 07 November 2015 02:36 Go to previous messageGo to next message
ivan01
Messages: 7
Registered: November 2015
Location: Australia
Junior Member
1/What do you mean by a read-only service name?
Read-only service name created in cluster level.

Report message to a moderator

Re: Query [message #644463 is a reply to message #644462] Sat, 07 November 2015 03:04 Go to previous messageGo to next message
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
Senior Member
What do mean by
Quote:
Read-only service name created in cluster level.


Also, is this actually an Enterprise Manager question? Or should the topic to moved to another forum?

Report message to a moderator

Re: Query [message #644464 is a reply to message #644463] Sat, 07 November 2015 04:29 Go to previous messageGo to next message
ivan01
Messages: 7
Registered: November 2015
Location: Australia
Junior Member
Read-only service name created in cluster level.

Yes. It is related Oracle enterprise manager question. Apologize for confusing here.
For example, we will see such service name running in cluster level.
e.g.:
$ srvctl status service -d dbname
Service app_read is not running.
Service app_readwrite is running on instance(s) dbname1,dbname2

Report message to a moderator

Re: Query [message #644465 is a reply to message #644464] Sat, 07 November 2015 04:35 Go to previous messageGo to next message
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
Senior Member
I've moved your topic to the RAC forum, it has nothing to do with Enterprise Manager.

You seem to have created your service, all you need to do is start it:
srvctl start service -d dbname -s app_read

What's the problem?

And, just to do the moderator bit:
Quote:
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Report message to a moderator

Re: Query [message #644466 is a reply to message #644465] Sat, 07 November 2015 04:44 Go to previous messageGo to next message
ivan01
Messages: 7
Registered: November 2015
Location: Australia
Junior Member
Can I use Oracle logminer to track the 'SELECT' transaction?

Report message to a moderator

Re: Query [message #644467 is a reply to message #644466] Sat, 07 November 2015 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

There is no SELECT transaction.
SELECT does not generate redo data so there is nothing LogMiner can see.

Report message to a moderator

Re: Query [message #644468 is a reply to message #644467] Sat, 07 November 2015 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Also what is your Oracle version?

Report message to a moderator

Re: Query [message #644472 is a reply to message #644468] Sat, 07 November 2015 07:11 Go to previous messageGo to next message
ivan01
Messages: 7
Registered: November 2015
Location: Australia
Junior Member
My database version is 11.2.0.3.0, 11.2.0.4.0 and 11.1.0.7.0
I think I could only use tracing sessions or enable audit in order to detect the select sessions running on database.

Report message to a moderator

Re: Query [message #644475 is a reply to message #644460] Sat, 07 November 2015 08:45 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ivan01 wrote on Fri, 06 November 2015 23:39
How to identify read only access to the database? At the end, I would like to separate those application module with SELECT privilege to run on a newly created read only service name.


What will be gained by doing as above?

What will be done with any session that does both SELECT & DML (INSERT, UPDATE, or DELETE)?

Report message to a moderator

Previous Topic: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed
Next Topic: rac setup using vmware
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 19 23:38:03 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.