OraFAQ Forum: RAC & Failsafe

Home » Server Options » RAC & Failsafe » Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query [message #644460]

Sat, 07 November 2015 01:39

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

Michel Cadot
Messages: 68341
Registered: March 2007
Location: Nanterre, France, http://...

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

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

John Watson
Messages: 8793
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

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

John Watson
Messages: 8793
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

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

Michel Cadot
Messages: 68341
Registered: March 2007
Location: Nanterre, France, http://...

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

Michel Cadot
Messages: 68341
Registered: March 2007
Location: Nanterre, France, http://...

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 28 20:11:44 CST 2023