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: 48
Registered: February 2008
Location: Riyadh
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
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
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: 48
Registered: February 2008
Location: Riyadh
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: 3211
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: 48
Registered: February 2008
Location: Riyadh
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
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
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: Tue Jul 02 23:20:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.