 USER1234 dedicated to instance PROD1 (merged 6) [message #409573] |
Tue, 23 June 2009 03:01  |
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
|
Member |
|
|
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.
|
|
|
|
|
|
|
|
|
|
| Re: USER1234 dedicated to instance PROD1 (merged 6) [message #411278 is a reply to message #409573] |
Thu, 02 July 2009 23:15  |
animesh_nz19
Messages: 7
Registered: July 2009
|
Junior Member |
|
|
For that you might need to create an service name in tnsnames.ora and dedicate the connection to only one instance.
SOmething like this :
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.177.63.117)(PORT = 1522))
CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = golu)
)
)
PS : Not sure how it will be achieved in Apps environment, from sqlplus this will work.
Regards,
Animesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
