Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Server Administration » Dedicated USR1234 to instance1 only (HP-UX 11.11 DB Oracle 10g Rel2)
Dedicated USR1234 to instance1 only [message #409820] Wed, 24 June 2009 03:17 Go to next message
razisolaris
Messages: 26
Registered: February 2008
Location: Riyadh
Junior Member
USER1234 dedicated to instance PROD1 (merged 6) [message

Hi All,

Iam using HP-UX(PARISC) 11.11 , Oracle Database 10g Release 2, which is configured as a RAC with two instance PROD1(one server) and PROD2 (second server). All users are connect through Oracle Application 9.0.1.4 Apache (HTTP).

My Question is , HOW CAN I DEDICATE USER1234 TO PROD1 Instance only.

Needs all expert help to sort this issue ......... Have a lovely day.
Report message to a moderator
Re: Dedicated USR1234 to instance1 only [message #409821 is a reply to message #409820] Wed, 24 June 2009 03:23 Go to previous messageGo to next message
gentlebabu
Messages: 1382
Registered: December 2005
Location: India, Hyderabad
Senior Member

For all client machine Configure TSN Entry only PROD1

Thanks
Report message to a moderator
Re: Dedicated USR1234 to instance1 only [message #409828 is a reply to message #409821] Wed, 24 June 2009 03:39 Go to previous messageGo to next message
razisolaris
Messages: 26
Registered: February 2008
Location: Riyadh
Junior Member
Hi,

Iam connecting oracle database through http://xxxx Oracle Application server. Eventhough if i changed client machine TNS it did not effect.


so again what is the process to dedicate instance1 for user1234 only.
Report message to a moderator
Re: Dedicated USR1234 to instance1 only [message #409850 is a reply to message #409828] Wed, 24 June 2009 04:27 Go to previous messageGo to next message
ThomasG
Messages: 1871
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:
Iam connecting oracle database through http://xxxx


Then change the TNS connection of the application server accordingly.
Report message to a moderator
Re: Dedicated USR1234 to instance1 only [message #409891 is a reply to message #409850] Wed, 24 June 2009 06:44 Go to previous messageGo to next message
razisolaris
Messages: 26
Registered: February 2008
Location: Riyadh
Junior Member
Hi,

I have more than 100 users and wanted this particular user1234 connected to instance1 only due to some shared folders available for processing data. which is not available on instance2.


Therefore only user1234 require instance1 rest can balance both side no problem...........
Report message to a moderator
Re: Dedicated USR1234 to instance1 only [message #409935 is a reply to message #409891] Wed, 24 June 2009 09:17 Go to previous message
gentlebabu
Messages: 1382
Registered: December 2005
Location: India, Hyderabad
Senior Member
Quote:
Iam connecting oracle database through http://xxxx Oracle Application server


Explain; how your application connection database? (like ODBC,OLEDB,TNS Entry etc...)

Thanks
Report message to a moderator
Previous Topic:ORACLE DBA (merged)
Next Topic:External Table is loading data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 17:48:34 CST 2009

Total time taken to generate the page: 0.23244 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.