Home » RDBMS Server » Networking and Gateways » Client to server connection (10g)
Client to server connection [message #455440] Tue, 11 May 2010 09:59 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
When i connect from client to server the client looks up for the host address and port number in tnsnames.ora and connect to it via listener.ora in server.Where does pga and sga come into picture here?

Also what is the role of sqlnet.ora in client?What will happen if i specify a different port for the instance in tnsnames.ora and listener.ora?
Re: Client to server connection [message #455442 is a reply to message #455440] Tue, 11 May 2010 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Where does pga and sga come into picture here?
In the center of the screen.


>Also what is the role of sqlnet.ora in client?
It is optional.

>What will happen if i specify a different port for the instance in tnsnames.ora and listener.ora?
Make your changes.
Run your tests.
Report results back here, please.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

ALWAYS
Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version
Re: Client to server connection [message #455444 is a reply to message #455440] Tue, 11 May 2010 10:16 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
And better read the documents frist.
As you are from INDIA
You can get more concepts in PDf format
search for oracle student guide volumes in google

sriram Smile
Re: Client to server connection [message #455445 is a reply to message #455444] Tue, 11 May 2010 10:32 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
I read some docs on pga and sga,client server i cant actually connect them..can u give me some links if u dont mid.

Which version of Oracle 10g can i install in my personal system for free to check out...
Re: Client to server connection [message #455448 is a reply to message #455445] Tue, 11 May 2010 10:47 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
those are internal process you cannot check them...

sriram Smile
Previous Topic: error ORA-02019: while selecting table from oracle10g to SQL Server 2005
Next Topic: What does status UNKNOWN mean for a service?
Goto Forum:
  


Current Time: Fri Mar 29 07:51:44 CDT 2024