Home » RDBMS Server » Server Administration » USER1234 dedicated to instance PROD1 (merged 6)
icon14.gif  USER1234 dedicated to instance PROD1 (merged 6) [message #409573] Tue, 23 June 2009 03:01 Go to next message
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 #409584 is a reply to message #409573] Tue, 23 June 2009 03:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Spamming the forum with the same question 6 times is not a good way to get an answer.

Regards
Michel
Re: USER1234 dedicated to instance PROD1 (merged 6) [message #409587 is a reply to message #409584] Tue, 23 June 2009 03:50 Go to previous messageGo to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Sorry Michel,

Every time i got a message SERVER FAILED so i tried multiple time and now we can see the output ........

Expect a valuable input from all experienced professionals.
Re: USER1234 dedicated to instance PROD1 (merged 6) [message #411245 is a reply to message #409587] Thu, 02 July 2009 13:11 Go to previous messageGo to next message
olddba
Messages: 5
Registered: June 2009
Location: Longview, Wa
Junior Member
Look up "instance name" in the net services administrators manual
Re: USER1234 dedicated to instance PROD1 (merged 6) [message #411278 is a reply to message #409573] Thu, 02 July 2009 23:15 Go to previous message
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
Previous Topic: ora-01157:cannot identify/lock data file 12 - see DBWR trace file
Next Topic: Equivalent Privilege in oracle 9i and 10g (merged)
Goto Forum:
  


Current Time: Wed Dec 07 22:43:52 CST 2016

Total time taken to generate the page: 0.13880 seconds