OraFAQ Forum: Networking and Gateways » Client to server connection

Home » RDBMS Server » Networking and Gateways » Client to server connection (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Client to server connection [message #455440]

Tue, 11 May 2010 09:59

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?

Report message to a moderator

Re: Client to server connection [message #455442 is a reply to message #455440]

Tue, 11 May 2010 10:06

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

Report message to a moderator

Re: Client to server connection [message #455444 is a reply to message #455440]

Tue, 11 May 2010 10:16

ramoradba
Messages: 2457
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

Report message to a moderator

Re: Client to server connection [message #455445 is a reply to message #455444]

Tue, 11 May 2010 10:32

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...

Report message to a moderator

Re: Client to server connection [message #455448 is a reply to message #455445]

Tue, 11 May 2010 10:47

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

those are internal process you cannot check them...

sriram Smile

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 17:50:19 CST 2025