OraFAQ Forum: Server Administration » TNS-V1-V3 in v$session

Home » RDBMS Server » Server Administration » TNS-V1-V3 in v$session (Database 10.2.0.4.0)

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

TNS-V1-V3 in v$session [message #457758]

Tue, 25 May 2010 20:32

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Hi all,

We have quite a number of sessions in database MES (production) coming from another machine.

From v$session, the program is oracle@WID27 (TNS V1-V3). This WID27 (hostname) consists of quite a number of development databases inside. We have to trace which jobs are actually triggering this, as WID27 are not suppose to connect to production databases.

How can we tell whether the sessions came in is from dblink or from the machine itself?

Thanks a lot!

Report message to a moderator

Re: TNS-V1-V3 in v$session [message #457760 is a reply to message #457758]

Tue, 25 May 2010 20:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How can we tell whether the sessions came in is from dblink or from the machine itself?

From your perspective what is different between "dblink" and "from machine itself"?

You need to visit each of the development DB to see which have connected to the production DB.

What is Operating System name & version for both development server & production server?

Why allow Dev system connect to Production server, ever or at all?

Report message to a moderator

Re: TNS-V1-V3 in v$session [message #457762 is a reply to message #457760]

Tue, 25 May 2010 21:20

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

I was thinking whether the sessions came in via:

- dblink
- sqlplus through tnsnames from the machine (HP-UX)
- application login through tnsnames

Went in each of the development database, can't really get any infor for this 1. Not sure how could we trace these sessions, would want to point it out to application team and get them to disable if it is a job.

Report message to a moderator

Re: TNS-V1-V3 in v$session [message #457763 is a reply to message #457762]

Tue, 25 May 2010 21:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What is Operating System name & version for both development server & production server?

on Production DB create or add to sqlnet.ora file the following lines
tcp.validnode_checking = yes
tcp.excluded_nodes = (dev.localdomain.com)

The DB server session only can accurately report which system is the client system, but you already know the culprit host!

from each Dev DB issue following SQL

SELECT COUNT(*) FROM v$sql where sql_text like '%<PROD_DBLINK%>';

Report message to a moderator

Previous Topic:	help,the sys user can not connect oracle instance
Next Topic:	Prohibit the User from viewing Users_ & All_ dictionary Views

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 15:37:51 CDT 2024