Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can I have more than one client connection at a time?

I have two Oracle 9i servers installed on Windows Server 2000. I want to connect server 1 as a client to server 2. But I am unable to do this. Only one client connection is live at one time.

I have two Oracle 9i servers installed on Windows Server 2000. I want to connect server 1 as a client to server 2. For this I have modified the tnsnames.ora of server 1 with server 2. But when I run both through the client (SQL*Plus) I am unable to do this. Only one client connection is live at one time. I want to run both the clients on server 2.

SQL*Plus can connect to only one instance at a time. There is no way around this limitation. If this limitation were removed, how would your SQL statements know which instance to submit a SQL statement to? In some cases, that question would be impossible to answer.

Other applications may be able to connect to multiple instances at the same time. That is how those applications are designed. SQL*Plus was not designed this way.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close